Prathamesh Patkar

Developed and supported data-warehouse ETL and Python scripts, delivering 3 new Python scripts, modifying 2 mainframe Webhost scripts and 5 datasets, and troubleshooting 7 production Python scripts.

Developed 3 Snowflake and IBM DataStage data pipelines for campaign insights and supported team expansion by interviewing 7 candidates.

Created 2 proofs-of-concept for data warehouse modernization using Pentaho and AWS and analyzed modernization roadmaps for migration planning.

Oversaw BI development activities, migrating 4 scripts across Testing/Dev/UAT/Prod environments and troubleshooting and documenting fixes for 2 PySpark scripts.

Analyzed 32 existing scripts using Unix commands to support migration efforts and prepared artifacts for cutover activities.

Engineered and tested 2 PySpark scripts to prepare data for actuarial reporting and created 6 SQL queries to support ad hoc report investigations.

Performed migration of data-warehouse tables from PostgreSQL to AWS to enable cloud-based operations and improved data availability.

Implemented 2 insurance product change requests and 3 front-end bug fixes, and optimized 2 PL/SQL procedures reducing execution time by 60%.

Ingested data using 2 PostgreSQL scripts for a healthcare e-commerce application to support parts ordering insights and executed 3 data quality checks using Excel.

Led full lifecycle development for 3 Oracle BI Publisher reports, maintained OBIEE RPD across physical, business and presentation layers, and mentored new hires.

Designed and supported 4 Oracle BI Publisher reports for manufacturing as sole developer, delivered training to new team members and received team performance awards.

Ingested data from 7 source systems for archival using Informatica, Teradata and shell scripts to support long-term data retention.

Designed 6 static reports in Pentaho Reports Designer, created 2 Mondrian schemas and delivered 4 dynamic reports in Pentaho User Console for finance and allocation insights.

Ingested data from 5 source systems into the enterprise data lake (HDFS) and performed data quality validation to ensure reliable downstream analytics.

Monitored 800+ daily ETL runs using Informatica and Siebel DAC, implemented archival best practice saving over 2TB and a process improvement delivering $35,475 annual savings.

Developed a project using C++, UNIX, SQL and PL/SQL and resolved a major build issue using the make utility to stabilize the project.

Grade: 8.37 CGPA (Distinction)

Completed a part-time Master of Business Administration in Information Management from Welingkar (affiliated to University of Mumbai) in 2022 with an 8.37 CGPA (distinction).

Completed the Advanced Certificate Programme in Machine Learning and Deep Learning through UpGrad in collaboration with IIIT Bangalore in 2021.

Grade: 64.75% (First class)

Graduated with a Bachelor of Engineering in Information Technology from Fr. Conceicao Rodrigues College of Engineering (affiliated to University of Mumbai) in 2012 with first class (64.75%).

Grade: 86.83% (Distinction)

Completed the Higher Secondary Certificate (12th) from Sathaye College in 2008 with 86.83% (distinction).

Grade: 91.20% (Distinction)

Completed the Secondary School Certificate (10th) from Smt. J. B. Khot High School No.2 in 2006 with 91.20% (distinction).