SAROJINI VEMPATI
Data Analyst Data Engineer
Hyderabad
Summary
Insightful Senior Data Analyst with over 12 years of experience in data analysis, modeling, and ETL processes in banking and insurance. Spearheaded data mapping into a Common Data Model (CDM) and enhanced risk assessment dashboards. Managed stakeholder communications and change controls while ensuring data-lake infrastructure integrity through effective monitoring and data management.
Overview
3
3
Certifications
12
12
years of professional experience
Work History
Senior Data Analyst (AVP Data Analyst)
HSBC
Hyderabad, India
07.2022 - Current
- Perform CDM data modeling, analyzing and mapping data from source systems into the Common Data Model to support downstream consumption and reporting.
- Perform CDM data modelling, analysing and mapping data from source systems into the Common Data Model to support downstream consumption and reporting.
- Supported Strategic Risk Assessment data model for dashboard development and customer risk analysis, enhancing decision-making capabilities.
- Analyzed large financial datasets using SQL and Python to support business decisions.
- Conduct data quality testing and validation, investigate data discrepancies, and support resolution of data-related issues.
- Managed and tracked defects, coordinated investigations and remediation with relevant teams, and communicated status to stakeholders to ensure timely resolution.
- Coordinate stakeholder discussions to clarify requirements, explain data issues, align on modeling decisions and support delivery.
- Support CDM change control activities, including reviewing and coordinating model changes in line with the change process.
- Collaborate with technical and business teams to maintain reliable, consistent and fit-for-purpose data assets.
- Support HDP07 user-storage management by following up with users on obsolete/unused storage and coordinating deletion in accordance with the applicable process.
Data Masking Expert
TCS
Bangalore
01.2019 - 07.2022
- Collected requirements and converted into technical specifications supporting test-data management and data masking.
- Deployed Delphix-based data masking across SQL Server, Oracle, delimited/fixed-width text, and JSON sources.
- Built masking rules while performing data subsetting, tokenization, and data profiling.
- Executed SQL/Oracle queries and Linux commands to enable data analysis subsetting and file-masking activities; gained exposure to Python
- Coordinated with peers, clients, and stakeholders to produce solution documentation and complete work within agreed timelines.
- Collaborated with Nordea Bank
- Assisted with transition to HSBC
SQL Developer, Business Support
TCS
01.2015 - 12.2018
- Supported application maintenance through SQL database changes and code enhancements aligned with business requirements.
- Tracked job execution with Control-M, handled incidents/change requests in ServiceNow.
- Applied data modeling to client environment.
- Designed and executed complex SQL queries to support data extraction, reporting, and business analysis.
- Client: Protective Life Insurance
Education
B.Tech - Electronics and Communication Engineering
Koneru Lakshmaiah University
04-2014
Skills
Data Modelling & CDM
SQL & Data Analysis
Quality testing
Defect Management
ETL / Data Migration
Data Governance
Data Risk Analysis
SQL (SQL Server, Oracle)
Delphix (Data Masking Tool)
Control-M
ServiceNow, JIRA
Stakeholder Management
CDM Change Control
Data Science WorkBench
Accomplishments
- Customer Risk Analytics: Contributed to strategic risk assessment data modeling initiatives supporting customer risk analysis and downstream reporting
- CDM Data Modeling & Design: Contributed to the design and development of CDM solutions, defining data structures, entities, attributes and relationships to support business and analytical requirements.
- Stakeholder & Change Management: Collaborated with technical stakeholders to clarify requirements, manage defects and coordinate CDM chnage control activities.
- Data Lake Governance & Infrastructure: Supported data lake infrastructure and storage governance activities, including user working-folder management and deletion processes.
- Data Quality & Defect Resolution: Performed data validation and testing, investigated data quality issues, coordinated defect resolution and supported reliable data delivery.
Certification
LOMA 281 — Meeting Customer Needs with Insurance and Annuities (Sep 2015)
Timeline
Senior Data Analyst (AVP Data Analyst)
HSBC
07.2022 - Current
Data Masking Expert
TCS
01.2019 - 07.2022
SQL Developer, Business Support
TCS
01.2015 - 12.2018
B.Tech - Electronics and Communication Engineering
Koneru Lakshmaiah University