JayaPriya Munaswamy
Data Engineering Senior Analyst
Bengaluru
Summary
Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
11
11
years of professional experience
8
8
years of post-secondary education
Work History
Senior Data Analyst
Accenture Solutions Pvt Ltd
Bengaluru
09.2021 - Current
- Working as Offshore Test Lead for Data Analytics Team for Blue Cross Blue Shield-NC A Health Care Insurance Company – PAYER
- Currently serving BCBSNC in the Information Delivery Space (Data Warehouse).Dealing with extracts from multiple source such as Facets ,Optum,Amisys.
- Working in Agile model of continuous delivery.
- Worked on Extraction of data from Cloud and loading in to Teradata Datawarehouse.
- Migrated Data pipelines from Helix to Snowflake Datawarehouse ,remediated Pyspark to Abinitio Components.
- Extensively interacted with Business Analysts,Solution Architect ,understood Business requirements and created QA Estimates
- Design – Create Test Strategy, Identify Data, Environment and Regression
- Developed Test Scripts based on Specification document and Mapping document to ensure all the Transformation logic applied while moving th data from Source to Target database
- Build – Build Test Cases and Scripts, Prepare Data and Onshore Review, Upload Scripts in QC
- Worked with Data Modeling team to get the Database objects deployed in required Environment and validated it against the Business requirements.
- Created ETL Test data for all the Business rules to test the functionality of Abinitio graphs
- Worked in Control-M too for scheduling the Jobs which loads the data in to Snowflake Datawarehouse
- Worked in ALM tool to manage the Releases,Tets Plan ,execution and Defect Tracking.
- Leading the Defect triage calls from Offshore.
Test Analyst
Infosys Limited
Hyderabad
09.2016 - 08.2021
- Worked for a Healthcare giant CVS Caremark asTest Analyst Offshore
- Participated in Requirement Walkthrough sessions
- Involved in effort estimation and Test plan preparation
- Responsible for Scenarios Preparation, Test case Design, test data preparation, Test execution and Defect logging
- Responsible for attending Peer and Project Management reviews
- Coordinating with the Client on daily progress and Schedule
- Test Design review and feedback
- Test Execution and consolidating test results
- Defect finalization and tracking their closure
- Preparing the Test summary and documentation
- As ETL tester,Indentified the Business Scenarios from Business Requirement Specifications providing estimates, solutions, conducting walkthroughs etc., with the customer
- Performing the Data Load based on the requirements, checking Transformation rules ETL
- Designing SQL queries for data validation
- Executing the designed SQL queries in Teradata
Test Engineer
Wipro Technologies
Chennai
07.2012 - 03.2014
- Worked for DHL a Logistics company as ETL Test Engineer
- Identified the Business Scenarios from Business Requirement Specifications providing estimates, solutions, conducting walkthroughs etc., with the customer
- Working with BDQ Team (Onsite) on ETL and Reporting layer (Query/Report/Event Studio) using IBM Cognos 8/10 and SQL on Teradata
- Creating and Managing Users, Groups and Roles using IBM Cognos Administration
- Ensuring the DB extraction using SQL under FORWarding INtelligence (FORWIN) based on the requirements, checking Transformation rules before and after ETL
- Performed Integration Testing for NFE Co-Existence and Security Testing on Roles and Groups during the migration to SAP
- Responsible for the smooth deployment of requirements and support till stabilization and providing support to the team
- Cohesive Team Player with Fast Learning Curve along with strong analytical, problem solving, innovation, planning, communication & interpersonal skills
- Developed a tool using Excel VB Script to automate the extraction of issues from the issue tracking tool JIRA by taking the inputs from the user such as ProjectName, Username, created date etc.
Education
Bachelor of Technology - Computer Science
Srinivasa Institute of Technology and Management studies, Jawaharlal Nehru Technological University
Anantapur, AP 01.2007 - 04.2011
Intermediate - MPC
Sri Chaitanya Junior Kalasala
01.2005 - 04.2007
SSC - undefined
Vignana Deepthi English Medium School
01.2004 - 04.2005
Skills
Snowflake
ETL Testing
Teradata
Data Warehousing
SQL
Data Migration
Functional testing
ALM,JIRA,Rally
IBM Cognos
SQL Server
Reltio
Healthcare
Insurance
Accomplishments
- Received Extra Mile Stone Award for Outstanding Contribution Excellence in Delivery at Accenture
- Received many appreciations from client for good interpersonal and analytical skills.
- Quick learner and Self-starter with good comprehensive problem solving skills.
- Completed Certification on Core AWS Services as a AWS Cloud Practitioner
Timeline
Senior Data Analyst
Accenture Solutions Pvt Ltd
09.2021 - Current
Test Analyst
Infosys Limited
09.2016 - 08.2021
Test Engineer
Wipro Technologies
07.2012 - 03.2014
Bachelor of Technology - Computer Science
Srinivasa Institute of Technology and Management studies, Jawaharlal Nehru Technological University
01.2007 - 04.2011
Intermediate - MPC
Sri Chaitanya Junior Kalasala
01.2005 - 04.2007
SSC - undefined
Vignana Deepthi English Medium School
01.2004 - 04.2005