Founder | Chief Planing Officer

• Feb 2022 - Present

Founder | Chief Planning Officer

• Jul 2015 - Feb 2022

Data Engineer III

• Nov 2021 - Feb 2022

Data Engineer II

• Mar 2019 - Nov 2021

Data Engineer I

• Apr 2018 - Mar 2019

Salesforce Data Migration Specialist

• Feb 2017 - Apr 2018

ETL programmer

• Jul 2015 - Feb 2017

Responsibilities: • Cleanse, De-duplicate and transform the data in the XLS and load it to Microsoft SQL Server Tables • Perform complex Look up operations with other tables to derive new fields. • Writing Unit Test cases and executing those Test cases to check if the application is as per requirements. • Exception Handling - handling failure events and send email about failure as per required. Responsibilities: • Cleanse, De-duplicate and transform the data in the XLS and load it to Microsoft SQL Server Tables • Perform complex Look up operations with other tables to derive new fields. • Writing Unit Test cases and executing those Test cases to check if the application is as per requirements. • Exception Handling - handling failure events and send email about failure as per required.

Senior Programmer

• Oct 2013 - Jun 2015

Client: PFIZER. Description:Pfizer, as a part of its Engine for Sustainable Innovation (ESI) program to dramatically increase R&D productivity, is moving to a multi-Clinical Research Organization (CRO) strategic partner operating model for much of its clinical trial operations, and intends to allow partners to use their own clinical applications to conduct studies on Pfizer’s behalf. This approach will significantly reduce the transactional computing footprint within Pfizer’s… Show more Client: PFIZER. Description:Pfizer, as a part of its Engine for Sustainable Innovation (ESI) program to dramatically increase R&D productivity, is moving to a multi-Clinical Research Organization (CRO) strategic partner operating model for much of its clinical trial operations, and intends to allow partners to use their own clinical applications to conduct studies on Pfizer’s behalf. This approach will significantly reduce the transactional computing footprint within Pfizer’s Development Operations organization. The Clinical Aggregation Layer (CAL) program will: • Develop, implement and maintain an aggregated, integrated computing environment made up of clinical, operational and unstructured data content, and external data housed in an industry-standard clinical hosted environment. • Provide capability of offering timely and accurate responses to corporate, partner, regulatory and legal requests for information within the clinical, scientific and operational domains. • Deliver using a phased approach to quickly establish the most critical functionality to support the initial goals of the ESI program. Responsibilities: • Prepare Detailed Designs to Develop Informatica Mappings based on functional requirements for a release in the Life Science frame work. • Provided product and design level technical best practices. • Created the Source to target map documents. • Developed logical and physical data flow models for ETL applications, translated data access, transformation and movement requirements into functional requirements and mapping designs. • Migration of Informatica Code from Development Environment to Test or Production. • Code, test, implement and maintain medium to highly complex ETL mappings and scripts to build and maintain automated ETL processes. • Testing the code developed from the development perspective. • Insuring high quality code for self and as well as team with the help of peer reviews. Environment: Informatica BI Tools.

Senior Programmer

• Jul 2011 - Sep 2013

Project: Network Planning (NWP) Client: Bharti Airtel. Description: The One Plan Server (OPS) database required regularly updated data which reflects current state of Bharti network. The NWP Team is responsible for performing the refresh on network data using ETL Tool. Tool Extract scheduled updates from Bharti data sources (M6 and UGIS) containing network infrastructure and forecast data. The NWP Team function is to extract data from various sources in Bharti network and… Show more Project: Network Planning (NWP) Client: Bharti Airtel. Description: The One Plan Server (OPS) database required regularly updated data which reflects current state of Bharti network. The NWP Team is responsible for performing the refresh on network data using ETL Tool. Tool Extract scheduled updates from Bharti data sources (M6 and UGIS) containing network infrastructure and forecast data. The NWP Team function is to extract data from various sources in Bharti network and transform it conform to One Plan Server database schema and perform forecasting and trending. Responsibilities: • Handling entire ownership of NWP tasks from business knowledge gathering to development, testing, validating and deployment. • Designing ETL mapping and workflows to fetch data from multiple sources in Bharti network and transforming in order to conform to OPS application. • Worked in area of Trending and Involve in preparing monthly data for the analysis and uploading same to the portal • Taken initiative to perform tech arch in warranty support so I am managing all servers and handling tech arch related quires. • Involved in backup activities and preparation of transition documents of both tech arch and ETL related work. • Installing tools and software’s on client work environment (one time activity as working lone from client location) and handling tech-arch related problems. • Handling Airtel Project from The ETL front, Tech Arch front and from client representative front. • Completed knowledge transition of Tech Arch activities to Airtel Okhla Data Centre team (to both DB team and operational team) in two day long training session • Perform post development validation and taking signoff from business. Environment: Informatica BI Tools, Rapid Miner 5.0.

Database Manager

• Dec 2013 - Jan 2015