Oct 2020 – Jun 2021 · 8 mos · Hyderabad, Telangana, India

• Developing a platform for data management solution that harnesses the power of the healthcare data explosion to enhance people's live.
• As a Technical manager, Responsible to design and implement the AWS cloud-based data lake and foundational data marts (Redshift) to integrate the data coming from different vendors to ease the building of the reporting layer, ease of communication between marts, extensibility of the framework to new subject areas with minimal code changes in the configs, ABC framework, auto sizing of the cluster based on the batch size etc.
• Responsibilities:
• 1) Part of design, development, and delivery of complex ingestion framework implementation.
• 2) Designed the framework to implement features such as Standardization rules for Data Quality, deduplication criteria, auto sizing of EMR cluster based on batch file sizes, Data lineage tracking implementation for data, audit data for job runs, etc.
• 3) In depth data profiling activities on all the source system entities to identify the distribution styles, sort keys and encoding techniques to be used on Redshift Tables.
• 4) Automate the implementation of data model changes to framework with respect to new tables / column addition etc. with minimal build effort driving it through config changes.
• 5) Performance tuning –
• a) Spark memory optimization, Pools implementations, AWS redshift distributions and sort keys design
• 6) Estimate- system capacity to meet near- and long-term processing requirements.

Aug 2015 – Sep 2020 · 5 yrs 1 mo · Greater Hyderabad Area

• Optum is a leading health services and innovation company focused on improving affordability, quality and efficiency of care. RQNS is Risk Quality and services portfolio deals with services provided to Member, Payer and Provider for US Healthcare. It deals with assigning Risk score to Members which in turn reflects the revenue of the payer.
• Responsibilities:
• Designing ETL and Reporting solutions using Spark, Python, Sqoop, Hive and HBase..
• Developed data pipelines to extract the data from S3,HDFS and NoSQL technologies like Cassandra and MongoDB.
• Enhancing the Application as per the Business Requirement.
• Generating Weekly and Monthly Reports based on client requirement.
• Implemented Incremental load to improve the performance which in turn saved 300+ hours of productivity.
• On- Boarding the New Clients which includes both External and Internal .
• Design and Implement new ETL’s Using Sqoop to ingest & retrieve data from various RDBMS like Oracle DB & MySQL.
• Designed the Re circulation flow to fetch the missing data from different domains which is caused due to timing difference.
• Design recommend best approach suited for data movement from different sources to HDFS using Apache Kafka
• Worked on Automation of tasks which include manual intervention earlier and it saved manual efforts.
• Proven ability to effectively manage time and resources and prioritize tasks to ensure smooth delivery to Business.
• . Experienced in Team Management , also part of Training program for new joinees.

Aug 2014 – Aug 2015 · 1 yr · Hyderabad

• migrated legacy Applications in SAS to Hadoop Environment, Understood Existing legacy application and identified the performance related issues and provided solution in Hadoop environment. Migration is completed Using Sqoop,Hive,HBase for data extraction and storage and MR for processing data.

May 2012 – Aug 2014 · 2 yrs 3 mos · Greater Hyderabad Area

• The BSYS SAS Data Mart provides a single environment for reporting and analysis of Medicare data. SAS DataMart is built from all of the disparate sources of Medicare data. This is used by the Clinical Performance & Compliance department to support Medicare Risk Adjustment activities and to fulfill contractual arrangements and support information products.. Reports and Analysis are delivered through the appropriate CPC channel Via SAS Web Report Studio, SAS Datasets in the Shared Folder and Reports in Excel and Tableau.nt.

Jan 2010 – May 2012 · 2 yrs 4 mos · India

• Joined GE as GET and worked in the area of Supply chain management and Handled Legacy Applications and ETL along with Identifying the chances we have for the process Improvement.