Devendra Agashe

Experience

• 

  Cognizant

  Dec 1999 - Apr 2003

  Project : Systems Support & Enhancements ; Client : IMS Health (USA) ; Role : DeveloperL3 Support and enhancement the various applications as listed belowFRM Formulary Focus System records and maintains details of various formularies that different health plans subscribe.PGT Product Grouping Tool groups various pharmaceutical products (drugs) into groups as per the business requirements.CMF Common Master File System application maintains products and automatically emails list of new products to ASR’s (Account Service Reps).NDC The NDC tool supports bridging between products in CMF configuration and NDC configuration and helps maintain the equivalence.OLEP The Outlet Exception Processing System finds exceptions in the outlet database and helps correct them.MC Managed Care application maintains Pharmacy Benefit Manager to Plan links.VPN Virtual Private Network delivers data to the client securely and reliably.HDO Hospital Database Operations tool enabling bridging of un-bridged hospital data.Responsibilities· Interaction with the client to collect requirements for enhancements.· Develop enhancement specifications and get them approved from the client.· Set-up Test Environment & Develop and implement changes.· 24 X 7 support of these systems. Show less Project : Pharbase ; Client : Synavant (Europe) ; Role : ETL DeveloperClient has data regarding doctors, hospitals clinics etc. This data is fed into the database using a front-end application developed in Power Builder. This data is to be delivered to the big pharmaceuticals according to their specifications. A data delivery mechanism was developed in Oracle and Ardent Data Stage (data warehousing etl tool) adhering to the complex business rules specific to each client. The existing data in AS400 was migrated to Oracle with Data Stage jobs. Another mailing application was developed in PB-Oracle for delivering mails to the clients with doctor’s names and addresses.Responsibilities· Design and Development of ETL jobs to deliver data.· Involved in initial data migration to the delivery system.· Onsite System Implementation and support to the User Acceptance Test.· Onsite Offshore co-ordination.· Provide post implementation support.Tools: Oracle, DataStage Show less

  • Associate

    Jan 2003 - Apr 2003

  • Associate

    Jun 2001 - Dec 2002

  • Associate

    Dec 1999 - Jun 2001
• 

  Cognizant Techology Solutions

  May 2003 - May 2004

  Associate

  Project : MI Prescriber Repository Enhancements ; Client : IMS Health (USA) ; Role : ETL Module LeadThe Prescriber Repository records prescribers with their many attributes. Client files are matched against this core and clean data is sent back to the pharmaceuticals. The matching is done by a set of complex rules which are embedded in Informatica batches. As business changed over time, these rules needed to be changed to better align with the current business scenarios.Responsibilities· Interaction with the business architect to understand the requirements.· Develop and validate “matching rules” to be changed /newly implemented.· Setup Test Environment.· Develop and implement ETL changes. Provide post production support.· Onsite-Offshore Co-ordination.Tools: Oracle, Informatica Show less

• 

  Cognizant Technology Solutions

  Jun 2004 - May 2007

  Project : Dashboards PMT & RPT ; Client : AMGEN ; Role : Technical LeadAmgen develops drugs and follows a specific lifecycle model for it. This model has been templated into different linked project plans across the organization within the functional departments, together known as “Integrated Project Plan”. These plans are stored on MS Project Server. There is a datamart created based on these historical timelines to view strategic data regarding drug development, effective control over Project Management and facilitate generation of parameters to help optimization of processes at Amgen and Project Portfolio Management. The project is to generate Program Management Dashboard and Research Management Dashboard Cognos reports based on the datamart and feeds from other systems. These are very critical dashboards and at a glance summarize all the business drivers, for all the programs (Research and Development), across Amgen. Responsibilities· Interact with the Business Analyst’s to understand business requirements and define scope of enhancements.· Technically lead and guide the team and help resolve technical issues.· Identify risks and identify strategies to mitigate them.· Interact with Data Architects and Data Modeler for database design and data modeling.· Environment setup for development, integration testing and production.· Provide insights to the team to resolve complex data issues and run/execute the project.Tools: Oracle, Cognos ReportNet 1.1, MS SQL Server, Informatica Show less Project : APECS – Integrated Project Plan Datamart ; Client : AMGEN ; Role : Technical LeadAmgen develops drugs and follows a specific lifecycle model for it. This model has been templated into different linked project plans across the organization within functional departments, together known as “Integrated Project Plan”. These plans are stored on MS Project Server. The project is to create a datamart out of these historical timelines to have strategic data regarding drug development, effective control over Project Management and facilitate generation of parameters to help optimization of processes at Amgen for the Project Portfolio Management team.Responsibilities· Interact with the Business Analyst’s to understand requirements & scope out enhancements.· Technically lead and guide the team and help resolve technical issues.· Lead design sessions with Business and Architecture Groups, evolve a detailed data model.· Refine the data model and procure necessary approvals from architecture group.· Environment setup for development, integration testing and production.· Provide insights to the team to resolve complex data issues and run/execute the project.Tools: Oracle, Cognos ReportNet 1.1, SQL Server, Informatica Show less Project : Supplier Management DataMart (RxInsight) ; Client : IMS Health (USA) ; Role : Technical LeadSupplier Management Department at IMS Health hosts a website powered by Webi which provides canned reports as well as ad hoc reporting facility to their suppliers over the web externally. Internal users can use the intranet or two-tier BO or ZABO (Zero Administration Business Objects) for these reports. There are clusters of servers which hosts Business Objects that delivers the data from the underlying datamart. This project involved major enhancements to the SMD datamart and a major version upgrade of Business Objects from 5.x to 6.5.1.Responsibilities· Interact with Data Architect and DBA’s for data modeling and database design.· Interact with Business Objects (vendor) to plan migration and resolve various issues with the upgrade / design workarounds. · Environment setup for development, integration testing and production.· Provide insights to the team to resolve complex data and Business Objects migration issues.· Setting up environment for performance testing, eyeball testing of reports & tuning.Tools: Oracle, Business Objects, Webi, Autosys, ZABO Show less

  • Associate Project Manager

    Nov 2006 - May 2007

  • Senior Associate

    Oct 2005 - Oct 2006

  • Senior Associate

    Jun 2004 - Sept 2005
• 

  Cognizant Technology Solutions India Private Limited

  Jun 2007 - Dec 2007

  Associate Project Manager

  Project : AMGEN DWH Projects - Offshore Set-up ; Client : AMGEN ; Role : AMGEN DWH Projects - Offshore Set-upResponsibilities :· Interact with the Business Analyst’s and tech leads to understand business requirements and define scope of enhancements.· Prepare project plan, estimate efforts, resource recruitment and resource management, lead the project.· Identify risks; work out strategies to mitigate them.· Deal with various agencies including HR, Finance, Admin, Network Team from Cognizant and Amgen to setup Environment for development, setup of virtual access to Amgen Environments.· Provide insights/guidance to the team to resolve complex data issues and run/execute the project.· Ensure Quality Deliverable is delivered on time.Tools: Oracle, Cognos Report Net 1.1, SQL Server, Informatica Show less

• 

  Credit Suisse

  Jan 2008 - Jul 2014

  Project : Architecture and Set-up of DWH Application Platform & DWH Reporting Platform - Hub NY ; Role : DWH Platform Management & Architecture Data warehouse Application Platform is a massive & highly complex data warehouse shared platform with integrated tool chain and security automation. It has a custom built framework which integrates disparate technologies and provides standards and governance for uniform code development.I was involved in creating the High Level & Detailed System Specifications for the platform.I managed the set-up project end-to-end, It involved designing the DWH software tool stack, servers, storage, back-up strategy, replication strategy, failover strategy, database clustering, networking, application on-boarding, additional network interface configuration based on technical requirements. I collaborated with various agencies within Credit Suisse, presenting possible options for each of the above areas and getting the preferred option approved. Each component/option selected was designed and set-up optimally to work with other components resulting in a performant, scalable and integrated large scale data warehouse. Further I negotiated with the System Integrator (SI) to put together a work order for the actual set-up of the platform. Actively participated in implementation & interacted with the engineering team(s) and the platform support team(s) across geographies to set-up the DWH application platform and DWH reporting platform. Interacted with the application development team to understand their requirements, determine their on-boarding suitability via RAG analysis and on-boarding questionnaire and finally help them on-board onto the platform. I was involved in designing and was hands-on in implementing the integrated Security Automation for the platform. I designed and implemented processes surrounding the platform and also implemented lifecycle upgrades. Show less Project : Various Architecture Project with Swiss DWH ; Role : DWH Platform ArchitectSynonym Strategy:Created a detailed Strategy/Concept for set-up of a “Synthetic” DWH environment with artificial data to enable offshore development also be compliant with the legal regulations for the Swiss Data warehouse Platform. Creation of such a common environment will dramatically reduce costs and help improve quality/time to deliver and problem resolution time. This involved...· Identifying various stakeholders and syndicating their requirements.· Knowing the legal regulations.· Researching and identifying various possible alternatives (solutions) for this.· Doing the necessary "Speed of Access" checks/tests from various locations to check the feasibility of the solution.· Evaluating the "best fit" (solution) for the problem.IT DWH: IT DWH is a data warehouse of all IT related data. This involved…· Creating a business case and roadmap for IT DWH.· Created a prototype for the "Core SMA"(includes modeling the SMA).· Studied the "IT Reference Model" and aligned the design of "Core SMA" to it.New BI Strategy:I was involved in detailed evaluation of various BI tools (Microsoft & SAP Business Objects tool suite) in standard, adhoc reporting and Dashboards categories for functionality, productivity and learning curve topics. Prepared a detailed concept for ways SQL Server Analysis Services Cube could be accessed via a JAP Program (Java/.NET interoperability).Design & Set-up of DWH Objects & DWH Platform in CATi:CATi is a tool used by architects to track the various implementations of data warehouses and other projects in Credit Suisse. The tool gives details about the lifecycles of various components and allows the architect to do quick analysis of dependencies for various scenarios, manage lifecycle of products and enforce standards. I worked with almost all the IT owners within Credit Suisse to design how these can be set-up within CATi Show less

  • Associate Vice President

    May 2010 - Jul 2014

  • Employee

    Jan 2008 - Apr 2010
• 

  Citi

  Aug 2014 - May 2017

  Vice President

  Role : Global Information Warehouse Site Lead – Pune & Master & Reference Data Management App Dev. Mgr.Led Master & Reference data application development team end to end to deliver on several mission critical & must-win projects. Collaborated globally with stakeholders :- Business, Architecture , Solution Analysts, Technical Leaders to put together a strategic roadmap for the application(s). Based on the roadmap carved out programs/projects and got approvals for the same from business/management by putting up business cases. Planned the individual projects and with stakeholder buy-in and lined up resources to execute the projects. Monitored the projects closely, facilitated status calls, arranged for war-rooms (in case of aggressive projects) nd tracked the projects closely to budget .Identified risks and raised them regularly with the top management. Instrumental in putting together the team from scratch in Pune, aggressively hired quality resources in a challenging hiring environment in a short span. In the role of Pune GIW Site Lead, I am providing local /day-to-day leadership for the Global Information Warehouse Pune Team (current size ~50 and growing). It includes managing hiring end-to-end for GIW @Pune. Providing local support to the team in terms of arranging technical trainings like advanced Ab-initio ,Talend etc., arranging local events and team building exercises. Interface with Senior Management as GIW Pune representative and provide regular inputs to Senior Management Reporting for Pune. Interface with HR and local agencies and handle local resource and compliance issues, manage on-boarding – off-boarding of resources, vendor management, mentor Grads and manage Rewards & Recognition for team members. Conduct performance reviews and communication of year-end performance to team members. Groomed & developed leadership within the sub-teams to put in place a viable team structure. Effectively tracked and managed vendors working on various projects. Show less

• 

  Rises Analytics Solutions Pvt Ltd

  Feb 2018 - Sept 2018

  Vice President

  Rises Analytics is an early stage Fin-tech Startup and is involved in developing AI, Blockchain and Big Data based boutique solutions/products. Led a team to develop an AI and Big Data driven MVP (Minimum Viable Product) in the Risk Advanced Analytics space following the Lean Startup Methodology. Had end-to-end ownership of the product from its conceptualization, market research, gap analysis, creating product pitches & capability decks, CxO level engagement & presentation(s), requirements validation, creating proposals & demos, project & cost planning, resource management & hiring, technical architecture and leading the delivery team to develop the MVP through rapid agile sprints. MVP was developed on the cloud (Microsoft Azure) based Rises AI Platform, which involves a big data layer (Hadoop/Spark) for data preparation ,ingestion & processing, AI driven predictive analytics engine involving machine learning/deep learning algorithms , micro-service based architecture / Restful APIs supporting dashboard/GUI generation from the target database (Cosmos DB). It also supports dockerization as a deployment model in case of on-premise solution requirement. Was involved in developing product roadmap and the technical architecture to support its evolution Show less

• 

  Gescheft Analytics

  Oct 2018 - Dec 2019

  Director & Co-Founder

  Gescheft Analytics was founded with focus on services in the areas of AI, Big Data, Cloud Consulting. Currently I am involved in Infrastructure set-up, creating capability deck/client pitch, meeting potential customers to identify use cases, building project pipeline, creating initial prototypes and proposals. We are actively engaged/having traction with various clients in AI, Big Data and Cloud on-boarding space.

• 

  Saama

  Apr 2019 - May 2020

  Delivery Head : Consulting role with Saama Technologies

  Consulted with Saama to set-up and run delivery of various services to US based Pharma client from offshore with peak team size of around 70. It involved set-up of analytics based managed services, AI based Product Implementation in the Drug Safety Area - co-developed and implemented an AI based product to discover adverse events/post market safety signals of drugs on human beings on real world data - early on , so could be acted upon more effectively. Conceptualized and developed an AI-based chat bot for the client (called as “iPharmabot”),the bot would integrate with existing information within the organization to intelligently answer end user questions, based on a home grown chat bot framework based on NLP. Involved in driving customization of big data lake based product related to clinical and patient data for a US based Pharma data aggregator to deliver insights.Was responsible end-to-end in this engagement - right from from recruitment & effective management & mentoring of resources, fostering innovation, bringing in efficiencies through automation, adoption of agile and DevOps tools & processes, account / operations management, bringing in value-adds through development of accelerators, lead proposals, interfacing with clients and being responsible for the core delivery and also personally being hands of stuff like developing chatbot,(s) using Azure/AWS etc Show less

• 

  Capgemini

  May 2020 - now

  Director

  Leading an account for a major Australian Bank ,involved in executing big data /AI based projects based on AWS. Involved end-to-end to set-up squads to ingest, conform and serve data in and out of big data lake. Personally leading different projects which develop AI models for different use cases for the bank along with developing the supporting big data lake. Involved in recruiting ,training and mentoring resources, architecting and developing solutions/accelerators /value-adds and automations , maintaining financial profitability and overall leading the account. Show less