Narasimha Adhikarla
Hyderabad
Summary
Dynamic Senior Data Engineer with a proven track record at Carelon Global Solutions and LBG(TCS), specializing in Snowflake and Python to enhance data processes. Excelled in transforming data silos into centralized lakes and optimizing SQL queries, boosting report speed by 25%. A collaborative team member, adept in cloud technologies and data warehousing, I drive significant business decisions through data quality improvements.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Data Engineer
Carelon Global Solutions
Hyderabad
05.2020 - Current
- Project HealthOS: Worked on a UI-based project where the members can log in to the portal and fetch the history of providers they have consulted, as well as the details of medical claims and pharmacy claims. We have built a JSON structure to make this possible by using Snowflake as a tool to build the JSON, sourcing the data from AEDL. We used Snowflake, AWS, and Python as tools.
- Project DAAS: This project handles the requests raised by the customer for a specific period which contains the Claim, Pharmacy, and Provider details of the different state vendors of Anthem in the US. The Dev team has to deliver extracts as per vendors' requested frequency using AWS, Snowflake, and Python as tools.
- Deployed robust, cloud-based data testing strategies that enhanced data quality and reliability, directly supporting business decision-making.
- Engineered an SQL query optimization project that accelerated report generation speed by 25%, significantly benefiting financial analysts
Data Warehouse Specialist
LBG(TCS)
Hyderabad
12.2016 - 05.2020
- Project ACH: This project deals with introducing the details - phone number, address, and location - of additional cardholders of the existing primary cardholders. It also involves updating the historical data of the primary cardholders with one-off loads and identifying all the impacted downstream through analysis.
- Project LEM: This project deals with the calculation of CTO and balances of customers by adding some new fields to existing GRID tables, which, in turn, involves calculations.
- Facilitated team knowledge sharing by documenting ETL and data transformation techniques, which cut onboarding time by half.
Education
Bachelor of Technology - Electrical and Electronics Engineering
Lendi college of College of Engineering (JNTUK)
Skills
- Snowflake
- Teradata SQL
- Data Stage
- Unix
- ETL development
- Data Modeling
- Performance Tuning
- Data Warehousing
- Database Design
- Python Programming
- RDBMS
- Data Science
- Python
- Collaborative Team Member
- AWS
- Lambda
- IAM
- S3
- Cloudwatch
- SNS
- SQS
- DBT
- Glue
- GCP
Awardsandappreciation
- Received HACKWOK certification for participating in the Gen AI implementation for EDA data platform
- Received Impact awards on multiple occasions for providing business solutions and for the support provided
Professional Highlights
- Achievement-driven professional with an experience of 8 years in Teradata and Snowflake.
- Having hands on related to different TERADATA LOAD UTILITIES like BTEQ, FAST LOAD, MULTI LOAD, FAST EXPORT and MYSQL.
- Having knowledge in Loading data with Snowpipe and JSON data from Internal and External staging areas like AWS S3 bucket.
- Having good hands on with concepts like Time Travel and Clustering and Snowflake Architecture which helps in optimal utilization of SF resources.
- Hands on AWS services like Glue, IAM, CloudWatch, Lambda and IAM roles creation.
- Expertise in loading data into snowflake database with copy commands along with Snowpipe.
- SQL expertise in developing both strategic and tactical queries, especially large/complex queries using Joins and Sub Queries.
- Effective in liaising with stakeholders during problem diagnoses, requirements gathering, detailed level design, development, to ensure that optimal resolutions were achieved.
Accomplishments
- Got Impact Award (Above and beyond) for Implementing Health OS FHIR interoperability and FHIR standards through snowflake.
- Received on the spot award for participating and implementing Gen AI technologies.
Certification
- SnowPro core
- Google associate cloud engineer
Languages
Telugu
First Language
English
Upper Intermediate (B2)
B2
Hindi
Intermediate (B1)
B1
Timeline
Senior Data Engineer
Carelon Global Solutions
05.2020 - Current
Data Warehouse Specialist
LBG(TCS)
12.2016 - 05.2020
Bachelor of Technology - Electrical and Electronics Engineering
Lendi college of College of Engineering (JNTUK)
Similar Profiles
MADHAVI CHENGATUMADHAVI CHENGATU
Business Analyst at Carelon Global Solutions: Summitworks Technologies and UST GLOBALBusiness Analyst at Carelon Global Solutions: Summitworks Technologies and UST GLOBAL
Kapish Kumar AgarwalKapish Kumar Agarwal
Senior Associate at Carelon Global SolutionsSenior Associate at Carelon Global Solutions
Nixon RexNixon Rex
Technical Lead II at Carelon Global SolutionsTechnical Lead II at Carelon Global Solutions
RAMASUBRAMANYAM MATHURRAMASUBRAMANYAM MATHUR
Senior Delivery Manager at Carelon Global Solutions/UST (Elevance Health)Senior Delivery Manager at Carelon Global Solutions/UST (Elevance Health)
Sameer TelikicherlaSameer Telikicherla
PAM Consultant at Capgemini India Pvt Ltd.PAM Consultant at Capgemini India Pvt Ltd.