Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Bhagyashree Madkaikar

Pune

Summary

ETL Developer with over 6 Years of experience in Application Development in HealthCare Domain. Proven ability to leverage full-stack knowledge and experience to develop interactive ETL processes and oracle data management and Implementation of Data warehouse/Data Mart. Extensive Hands-on experience in using ETL tool AWS Glue and Spark Sql development also involved in Data migration projects.

Overview

6
6
years of professional experience

Work History

Application Developer

Saama Technologies
Pune
01.2023 - Current
  • Client Name: Genentech Biotechnology Company
  • Project/Module Name: AGGS: Aggregate Spend Module using AWS
  • Description: Aggregate spend process to monitor the total amount spend by healthcare org and individual. The project has multiple source systems to process data into AWS cloud. It has complex ETL process architecture.
  • Responsibility: 1. Migrated legacy system into AWS application using AWS Glue ETL process. 2. Managed application development from start to completion, including planning, design and development. 3. Documented software features, functionality and operations in user guides and manuals to guide end-users and technical teams on system usage. 4. Wrote high-quality code to complete applications within schedule. 5. Daily task updates shared over email. 6. Analyzed data to determine new system requirement.

ETL Developer

Saama Technologies
Pune
06.2021 - 12.2022
  • Client Name: Genentech Biotechnology Company
  • Project/Module Name: AGGS: Aggregate Spend Module using Informatica PC
  • Responsibility: 1. Worked on multiple assigned Jiras. 2. Developed the ETL process from start. 3. Actively listened to understand requests and address concerns. 4. Handled inbound calls per day. 5. Performed data validation and cleansing, optimizing database quality standards.

Programmer Analyst

Cognizant Technology Solutions
Pune
08.2017 - 06.2021
  • Client Name: Sanofi Aventis Pharma
  • Project/Module Name:
  • 1. Axis Integration phase 1 and phase 2
  • 2. Global Insight phase1 and phase2
  • 3. Performance tuning and DQC implementation and automations
  • 4. Sanofi Genzyme DW Application
  • Responsibility: 1.Planned, researched and developed programme logic and code tests. 2.Communicated with clients to gain a comprehensive understanding of programme requirements. 3.Created DQC framework to check data quality and mail processing using PL/SQL and Informatica. 4.Involved in scheduling activities and ETL migration activities 5.Developed Informatica cloud flow to load files from client and involved in data management process like procedures, functions, triggers and views.

Education

Pyspark And Python Training

-
01-2022

AWS Cloud Practitioner Training

-
01-2022

Master of Science - Computer Science

Savitribai Phule Pune University
Pune
01-2019

Bachelor of Science - Computer Science

Savitribai Phule Pune University
01-2017

Informatica PC And Cloud Training At Cognizant

-
01-2017

Skills

  • Programming Languages: Pyspark, Python
  • AWS Services (S3, Glue, Athena, RDS, CloudWatch, etc)
  • Database: MySql, Oracle, Pl/SQL
  • Operating Systems; Windows, Linux
  • Tools : Informatica PC, Informatica Cloud, SQL Developer, Toad, DBeaver, Pyspark Databricks

Languages

English
First Language

Timeline

Application Developer

Saama Technologies
01.2023 - Current

ETL Developer

Saama Technologies
06.2021 - 12.2022

Programmer Analyst

Cognizant Technology Solutions
08.2017 - 06.2021

Pyspark And Python Training

-

AWS Cloud Practitioner Training

-

Master of Science - Computer Science

Savitribai Phule Pune University

Bachelor of Science - Computer Science

Savitribai Phule Pune University

Informatica PC And Cloud Training At Cognizant

-
Bhagyashree Madkaikar