Mihir Patwardhan Email & Phone Number

Boston, Ma, Us

Natick, Ma, Us

Waltham, Ma, Us

- Initiated and led development of Data Warehouse (DW) for 4 mainstream products to store structured and meaningful data from unstructured source; DW used by 60+ healthcare clients - Designed and developed ~30 user interactive dashboards & reports with advance visualization and analytical features such as drill down/through capability and dynamic filters- Engineered reporting solutions to streamline Ad-Hoc requests received from multiple clients; Saved 20% of the analyst time for redoing similar requests- Introduced and implemented ETL performance tuning methods which improved server efficiency- Proactively identify opportunities for automation; Saved ~40 hours of manual efforts 30+ BI reports

Austin, Texas, Us

- Analyzed and implemented ~450 technical requests from Oracle’s 50+ global clients for environments like OBIA, OBIEE, Big Data Discovery, Oracle Data Integrator, Informatica etc.- Provided 95% defect free solutions and recommendations; won customer confidence and earned 2 ‘Exceeded Expectation’ awards from Oracle- Acted as a liaison between client, technical account manager and ETL architects to present and defend new technical or business functionality suggested by clients. 70% such enhancements were part of later product release - Identified requirements for customized reports, analyzed Data Warehouse for source systems like - EBS, People-soft, Cloud - Taleo, Fusion, developed ETL strategies and delivered reports - Identified and recommended methods for improved ETL performance for client environment. Used tuning methods such as HINTS that saved 5 hours/day with 20% ETL efficiency- Authored Knowledge Modules documents on Oracle BI Products (OBIEE & OBIA) published for global clients

Westborough, Ma, Us

- Develop Data Migrations strategy by analyzing client’s various databases and mapping to Eclinicalworks MySQL and MSSQL database to support Eclinicalworks Healthcare Software- Recommended the automation of existing manual Data Migration process using cost effective ETL tools to save ~10 man hours /week and minimize errors

Little Rock, Ar, Us

- Developed and optimized complex SQL queries and PL/SQL procedures for ~10% faster data retrieval from different systems/sources – Salesforce.com, DB2, Oracle etc.- Automated process for publishing reports through Informatica ETL tool saving almost 40 man hours/ month- Optimized and automated the data backup process for data migration using ETL tool reducing complexity of existing system by ~10%

Dublin 2, Ie

- Supported the Cognos Planning BI applications for budgeting, planning and forecasting of healthcare products- Worked on the entire report development life cycle from requirement gathering to deployment of reports- Structured DB schemas using Framework Manager at metadata layer to create Data Marts and used them further for creating reports

Master'S Degree, Computer Science

Bachelor Of Engineering (B.E.), Information Technology