Jul 2016 – Sep 2019 · 3 yrs 2 mos

• Gather business requirement and translate them into technical designs
• Design the ETL architecture of the project
• ETL integration between salesforce CRM and warehouse to provide seamless connection
• Integrate data from multiple sources like relational, flat files, CRM etc.
• Team management - work allocation to the team, monitoring of deliverables by assuring quality
• Working in an onshore/offshore model and communicating effectively and in a timely manner with the client for clarifying requirements or reporting bugs and risks
• Design and calculation of key metrics (KPI) for sales and activity data
• Optimizing process flows through performance tuning and identifying bottlenecks
• Addition of custom data checks to the existing DQM framework to ensure data quality
• Production support for 29 countries, interacting directly with the client stakeholders
• Digital data analysis using SQL and Excel and generating impactful insights from Digital data
• Clickstream data analysis
• Personalized analytics for Brand managers and sales reps
• CLM data Processing and analysis using Informatica and SQL
• Production support for multiple countries
• Optimizing and Automating the entire data-mart
• Design of technical data model
• Worked on all phases of SDLC: Requirements, Design, Build, Testing and Deployment
• Working in an Onshore/Offshore model and communicating effectively and in a timely manner with Client for clarifying requirement or reporting bugs and risks

Apr 2014 – Jun 2016 · 2 yrs 2 mos

• Multi-Country BI Implementation for EU based Pharma Client (BI Developer)
• Work with ZS has involved Extensive experience in BI, Data Warehousing,Reporting , preparing fully automated solutions for pharmaceutical clients
• Worked on all phases of SDLC: Requirements, Design, Build, Testing and Deployment
• Extensively worked on data extraction, transformation and loading raw CRM (VEEVA) and sales
• datasets from multiple sources systems into the Data Warehouse using Informatica Mappings.
• Design and calculation of key metrics (KPI) around sales and activity data using complex SQL
• queries/ aggregate mappings.
• Optimizing process flows (Informatica) through performance tuning and identifying
• bottlenecks.
• Addition of custom data checks to the existing DQM framework to ensure data quality.
• BI Solution for one of the top 10 Pharmaceutical Companies of the World (ETLDeveloper)
• Sales and marketing data solution for UK based client.
• Design and development of Base to Reporting layer in DWH for calculation of Key Metrics
• using complex SQL queries/informatica mappings. Experience includes developments of
• Physical data model.
• Optimizing and Automating the entire data-mart using Autosys
• Design of technical data model
• Technical expertise
• Expertise in Data warehousing, SQL, Informatica, MS Excel.
• Expertise in preparing client presentations using PowerPoint
• Expertise in Pharma Data Analysis

May 2013 – Apr 2014 · 11 mos · Bengaluru Area, India

• My role as a Associate Software Engineer at Accenture was to work in a team responsible for understand client business requirements, operating business rules, data, and processes thereby providing the appropriate BI solutions.
• My responsibilities include the following:-
• Develop deep expertise in third-party ETL tools like Informatica PowerCenter 9.5/9.1, Databases like Oracle and SQL server, Database tools like Toad 12.1/9.0, reporting/analysis tools
• Create solutions that serve long-term business process needs for clients.
• Adapt/enhance solutions to changing business needs.
• Enhancing generic solutions to meet the client requirements.