Apr 2023 – Jun 2024 · 1 yr 2 mos

• Efficiently integrated diverse information systems, such as electronic health records (EHRs) and practice management systems (PMs), to extract clinical data from the client's database for US healthcare providers.
• Focused on optimizing the query performance to address slow extraction and eliminate data redundancy, resulting in a remarkable 35% reduction in processing costs.
• Applied my analytical skills to harness insights, develop and implement data models, and evaluate and enhance existing models in order to generate effective solutions.
• Actively investigating and pinpointing the underlying causes of bugs or exceptions that arose during the data extraction process using the extraction tool by owning the Incident tickets in JIRA.
• Utilized custom models and algorithms to analyse various data sets, enabling me to assess and address a wide range of challenges faced by the company.
• Dedicated myself to training and mentoring employees, I effectively boosted the overall performance of the team, leading to a remarkable 40% improvement.
• Utilizing BigQuery, I conducted extensive data mining on a large dataset, meticulously correcting any errors or inconsistencies, ensuring the data was in optimal condition before proceeding with its integration into the DataMart.

Sep 2020 – Mar 2023 · 2 yrs 6 mos

• I established a mapping between the ETL tool and the CDR data warehouse, aligning it with the defined HIVE CDR structure. This mapping facilitated the creation of a seamless data pipeline, enabling smooth and efficient data flow from the client server to the central hub.
• I developed SQL queries to retrieve intricate data from tables located in both on-site and remote databases.

Jan 2020 – May 2020 · 4 mos · Pune Area, India