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
undefined
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