Sanjay Kumar

Data Engineer

Novartis•  September 2020 - Present

• Collaborated with Data as a team on ETL (Extract, Transform, Load) tasks, maintaining data integrity, designing data workflows and verifying pipeline stability. • Responsible to Identify way to improve data reliability, efficiency and quality • Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls. • Responsible to identify and automate the process using Python scripting to eliminate manual intervention in end to end process • Explained data results clearly and discussed how it can be utilized to support project objectives. • Prepared documentation and analytic reports effectively and efficiently delivering summarized results, analysis and conclusions to stakeholders. • Performed large-scale data conversions, transferring unstructured/semi-structured data into standardized structured formats for integration into dashboard.

Business Technology Analyst

ZS Associates•  June 2018 - September 2020

Business Technology Analyst ZS Associates, Pune, Maharashtra Roles & Responsibilities: • As senior associate, responsible for managing client relations and developing analytics-based insights to drive better sales results and improve overall customer engagement. • Working experience on various brands / therapeutic areas for field suggestion and help sales reps with valuable action and insights to promote a product • Responsible for finding trends in data sets and developing algorithms to help make raw data more useful to the Sales Reps • Lead team of four members, responsible for handling development of various franchises such as Vaccines, Hospital Brands etc. • To determine HCP level trends to provide relevant and actionable insights to reps through Veeva CRM platform. This automation of HCP analysis increases rep efficiency, improves customer experience, and enables business agility • Hands-on experience to handle large datasets through SQL, Teradata, Amazon Redshift databases, data manipulation and ETL tools such as Informatica, Revo etc. • Understanding of cloud, data architecture, data modeling, data warehousing and data lake • Create metrics and attributes based on sales, calls and digital interactions data by writing complex queries in SQL • Investigated and corrected or escalated project problems • Hands on experience on Hive, Sqoop, Spark to analysis large data sets

Programmer Analyst

Cognizant Technology Solutions•  October 2016 - May 2018

• Worked for American agrochemical and agricultural biotechnology corporation to develop the necessary data model to store exceptions raised, build the challenging ETL layer to load data and glue the various components of end to end solution • Performing ETL functions for manipulating and transformation of data as per business requirements • Designing Informatica mappings such as pass through, split, Type 1, Type 2 and used various transformation such as Lookups, Aggregator, Ranking, Mapplets, Connected and Unconnected lookup etc. • On regular basis interacting with client for requirement gathering and providing status of project • Developing complex mappings using Informatica Power Center as per client requirement with various transformation • Participation in all phases of data warehousing such as analysis, requirement gathering, design, documentation and development of ETL processes • Performing unit testing and creating UATs • Designed and implemented SQL queries for reporting and complex solution development