Experience

Client Server Technology Solutions LLC

• United States
• Software Development
• 1 - 100 Employee

• Data Engineer I

  • Feb 2023 - Present

  Seattle, Washington, United States • Collaborated with cross-functional teams, business stakeholders following AGILE setting to gather and document functional requirements • Extracted and performed data cleaning on 10 million+ rows of insurance data from multiple sources using SQL and Python • Collected and analyzed current as well as historical insurance data to Identify trends, patterns to pinpoint change in cost trends • Achieved ~50% reduction in manual effort by automating merging of structured & unstructured data… Show more • Collaborated with cross-functional teams, business stakeholders following AGILE setting to gather and document functional requirements • Extracted and performed data cleaning on 10 million+ rows of insurance data from multiple sources using SQL and Python • Collected and analyzed current as well as historical insurance data to Identify trends, patterns to pinpoint change in cost trends • Achieved ~50% reduction in manual effort by automating merging of structured & unstructured data using Powerquery, Macros in Excel • Designed and developed 10+ interactive Tableau dashboard which helped business stakeholders to take data driven decisions Show less



Amazon Web Services (AWS)

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Data/Software Development Engineer

  • Mar 2022 - Feb 2023

  Seattle, Washington, United States • Spearheaded migration of IMDSv1 calls for more than 1000 EC2 instances across 7 services strengthening the security posture by 10% • Leveraged AWS CDK to implement seamless CI/CD using AWS CodeCommit & CodePipeline hence improving data delivery time by 20% • Executed data cleaning, transformations using SQL queries joins, window functions thus refining data readability by 18% • Engineered robust client infrastructure using AWS services and optimized YAML files for efficient… Show more • Spearheaded migration of IMDSv1 calls for more than 1000 EC2 instances across 7 services strengthening the security posture by 10% • Leveraged AWS CDK to implement seamless CI/CD using AWS CodeCommit & CodePipeline hence improving data delivery time by 20% • Executed data cleaning, transformations using SQL queries joins, window functions thus refining data readability by 18% • Engineered robust client infrastructure using AWS services and optimized YAML files for efficient allowlisting of service principles • Designed and developed dashboards and alarms using AWS Lambda, AWS SNS to ensure 100% efficiency of services and data pipelines Show less



Newscape Consulting

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Analyst

  • Apr 2021 - Jul 2021

  Boston, Massachusetts, United States • Created a single source of truth from multiple healthcare datasets and led risk assessment analysis to drive data-driven decisions • Integrated AWS S3 with AWS Quicksight , developing 3 interactive dashboards boosting user experience and engagement by 15% • Implemented end-to-end ETL pipelines elevating data transfer speeds and availability by 58% to meet service quality requirements • Documented business intelligence reports to capture metrics requested by stakeholders to enhance… Show more • Created a single source of truth from multiple healthcare datasets and led risk assessment analysis to drive data-driven decisions • Integrated AWS S3 with AWS Quicksight , developing 3 interactive dashboards boosting user experience and engagement by 15% • Implemented end-to-end ETL pipelines elevating data transfer speeds and availability by 58% to meet service quality requirements • Documented business intelligence reports to capture metrics requested by stakeholders to enhance decision making process • Scripted Lambda script to schedule job for validating & refreshing data automatically on daily basis increasing data accuracy by 28% Show less



Northeastern University

• United States
• Higher Education
• 700 & Above Employee

• Student Proctor

  • Sep 2020 - May 2021

  Boston, Massachusetts, United States



Newscape Consulting

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Sr. Data Analyst

  • Jun 2019 - Dec 2019

  Pune • Administered end-to end solution to map insurance claim data to pre-defined vocabularies using AWS Redshift and AWS EC2 • Migrated existing data from Excel to AWS S3, built ETL pipelines and carried out ETL operations, for huge healthcare insurance dataset • Mentored a team of 3 members to improve technical depth in defining a vision and built a roadmap to launch technical services • Managed entitlements to monitor incoming, outgoing traffic of AWS S3 by configuring rules enabling… Show more • Administered end-to end solution to map insurance claim data to pre-defined vocabularies using AWS Redshift and AWS EC2 • Migrated existing data from Excel to AWS S3, built ETL pipelines and carried out ETL operations, for huge healthcare insurance dataset • Mentored a team of 3 members to improve technical depth in defining a vision and built a roadmap to launch technical services • Managed entitlements to monitor incoming, outgoing traffic of AWS S3 by configuring rules enabling security control over data Show less



ThingsMeet Solutions Private Limited

• Data Analyst

  • Jul 2016 - Jun 2019

  Pune • Analyzed, manipulated, visualized healthcare data (Medicare, Mediclaim) using advanced Excel functions(VLOOKUP, PivotTables) • Established data models and created views using SQL queries thus enriching data protection of healthcare data by 30% • Architected and deployed ETL pipelines to load approx. 5 million records to OLAP data warehouse reducing data retrieval time by 60% • Initiated and conducted analysis using SQL scripts, making use of joins, window functions, that informed… Show more • Analyzed, manipulated, visualized healthcare data (Medicare, Mediclaim) using advanced Excel functions(VLOOKUP, PivotTables) • Established data models and created views using SQL queries thus enriching data protection of healthcare data by 30% • Architected and deployed ETL pipelines to load approx. 5 million records to OLAP data warehouse reducing data retrieval time by 60% • Initiated and conducted analysis using SQL scripts, making use of joins, window functions, that informed data-driven decision making Show less