Archana Sharma
Gurgaon
Summary
Adept at transforming complex data into actionable insights, I spearheaded ETL development at R1 RCM, enhancing data warehousing and analysis efficiency. Leveraging Azure Databricks and Python, I significantly improved system performance. My agile methodology and effective communication skills ensured seamless team collaboration and project success, demonstrating a strong blend of technical expertise and leadership.
Overview
9
9
years of professional experience
Work History
Database and Azure Databricks ETL Developer
R1 RCM
01.2021 - Current
- Currently working with Dev and ETL Team in healthcare Domain
- As a database and ETL Developer, have done requirement understanding and develop solution accordingly
- The development was done by using various BI Tools such as SSIS SQL SP writing which has now converted into Azure Databricks ETL pipeline.
- I also handle performance tuning of the system
- The main task here was to support their data load from various source files to Main database tables
- Software Skills: Business intelligence/Analytics, Data Warehousing, Azure Databricks , Python Notebook, Data Base- SQL Server, PL/SQL, Python
- Tools Used ETL Tool - SSIS Reporting Tools - SSRS, Power BI, AWS Quick Sight and QlikView
- Programming knowledge - .NET, power-shell scripting, Python Notebook
- In addition to this, I have also knowledge of tools like: Jira, Bitbucket, GIT Repository, TFS, Excel
- Methods: Agile methodology
- Domain: Banking & financial domain, Healthcare, Retail Domain, Hi-Tech Domain
- Deployment using CI/CD pipeline
TCS
01.2016 - 01.2021
- Worked in banking and finance domain, Hi-Tech and retail domain
- Handled ETL solutions, reporting and visualizations using PowerBI
- Python programming
- Managed five projects and successfully completed requirement on time with Go-Live
- Performance improvement of the existing system saved billing cost by saving manpower Hours
- Domain knowledge: Banking finance
- (BFSI), Hi-Tech and Retail, Health care domain
Education
Bachelors degree - ECE branch
01.2015
Intermediate - PCM
01.2011
High school - Maths
01.2009
Skills
- Data modeling and reporting
- Data mining and analysis
- ETL
- Reporting
- Visualization
- Business Understanding
- Requirement gathering
- Performance Optimization
- Agile methodology
- Observation
- Decision making
- Communication
- Multi-tasking
- Business intelligence
- Analytics
- Data warehousing
- SQL server
- PL/SQL
- Python
- SSIS
- SSRS
- Power BI
- AWS Quick Sight
- QlikView
- NET
- Power-shell scripting
- Jira
- Bitbucket
- GIT Repository
- TFS
- Excel
- CI/CD pipeline
Timeline
Database and Azure Databricks ETL Developer
R1 RCM
01.2021 - Current
TCS
01.2016 - 01.2021
Bachelors degree - ECE branch
Intermediate - PCM
High school - Maths
Similar Profiles
Tanya SagarTanya Sagar
Lead Associate at R1 RcmLead Associate at R1 Rcm
Rudhra Aruldev G MRudhra Aruldev G M
Senior Analyst at R1 RCMSenior Analyst at R1 RCM
Ganta SashikanthGanta Sashikanth
Senior Medical Coder at R1 RCMSenior Medical Coder at R1 RCM
CAMILLA ORGANCAMILLA ORGAN
A/R Denials Supervisor at R1 RCMA/R Denials Supervisor at R1 RCM
Ashish VashisthAshish Vashisth
Senior General Manager at Cars24Senior General Manager at Cars24