Pankaj Borole Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

Pune, Maharashtra, India

Pune Area, India

Responsibilities (ETL Test Lead/ DB Automation Lead): Since Oct-2014• Management of various ETL testing activities for various products and releases for IMS Health • Preparation of test plan, test strategy and maintaining test data for different product/ versions• Conducting test plan review meetings with Architects, stake holders• Management of Business data quality across various data pipelines used in products.• Design and develop the data quality rules/ metrics as per the domain requirements.• Actively involved in ETL Test data preparation / Domain specific functional test data set.• Automated the weekly/monthly/quarterly EB cloud reports validation against customer source. • Developed and deployed end to end generic data validation framework for IMS products to check the data post ETL operations.• Involved in execution of ETL performance testing for clinical research products• Developing of SQL/PLSQL procedures for test execution, generating test data for testing, review of detailed test cases before start of execution.

San Jose, Ca

# Project1: Salesforce.com (JigSaw)Role: Prodution ETL Support/DB Automation engineer• Development of DB automation framework using MYSQL and Shell Scripts.• Validation of OLTP/DWH metrices using DB test framework• Verification of ODC mechanism using Mysql replication and database triggers to capture daily data from source system.• Optimizer the database operations to achieve daily/ weekly and monthly delivery of the data sets.• Monitor and verify the operations to perform summary data populations and Aggregate data population, and data quality. Automated test cases to verify aggregated data on daily/ weekly/ monthly etl jobs.• Added changes to support DB changes regression cycles along with test prioritization groups• Preparation of MicroStrategy reports and dashboards using SQL scripts against PRD documents• Designing and implementation of database test automation framework to verify the metric values across different oltp and dwh using Mysql procedures and shell scripts.# Project2: Yahoo.inc (Edward/Edlite)• Monitoring of DB deployment jobs using hudson on QA/Dev environments • Monitor and support daily ETL data load using ETL job innovator engine.• Managing huge data loads/ big data operations on Oracle Partitions • Monitoring of Dimension split processing / de-dup/ Internal job scheduling engine• Execution of pending ETL jobs to populate data on the various test/dev environments.• Provide support in case of child jobs failure, report in case of unit data available.• Preparation of data mart scripts for data quality checks against the MSTR report/ dashboard.• Involved in automation of SQL queries (MSTR security model) for regression testing• Actively involved in support DB DEV / ETL testing team in order to replicate production environments with masked data.

Pune Area, India

# Projects: ANTS & ACS (DB Products later ACQUIRED BY XXX ) • Installation of Sybase and Oracle databases, setting up source / target systems• Oracle DBA activities required to migration setup DEV/QE and provide the production deployment instructions• Prepare migration mappings using Oracle Migration workbench• Preparation of DB framework to used for POC automation. • Creation of Oracle database schema/ objects/ Users replicate the application environment.• Involvement in performance and longevity testing for ACS.• Execution of TPC-H (Transaction Processing Performance Council) Benchmarks • Developed Oracle DBA_XXX Views for ACS for compatibility with Oracle