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
Tina Parks RHIATina Parks RHIA
Senior Medical Coding Specialist at R1 RCMSenior Medical Coding Specialist at R1 RCM
Colleen SeipelColleen Seipel
Coding Specialist II at R1 RcmCoding Specialist II at R1 Rcm
Rudhra Aruldev G MRudhra Aruldev G M
Senior Analyst at R1 RCMSenior Analyst at R1 RCM
Antonina Kaisa-SalafaiAntonina Kaisa-Salafai
Credit Balance Specialist at R1 RcmCredit Balance Specialist at R1 Rcm
Rohit SharmaRohit Sharma
Assistent Consultent at Tata Consultancy ServiceAssistent Consultent at Tata Consultancy Service