ETL Tester

email: acz3ja@r.postjobfree.com mobile: 210-***-****

Senpaka Priya Venkatasamy

No visa sponsorship required Open to relocate

QA Analyst / Data Analyst / SQL Developer

5+ years of experience in Quality Assurance and Data Analysis in roles as QA Analyst, Data Analyst and QA Engineer

Commendable hands on experience in Requirements Analysis, Test Design, Test Coordination and Test Execution for development / migration / upgrade / reporting projects

Proven experience in ETL validation for Staging, Integration and Reporting layers for complex systems

Seasoned in preparing Test Strategy, Test Plan, Estimation, Test Case Preparation, Defect Management, Traceability Matrix and Quality Metrics to aid comprehensive test coverage and on-time quality deliverables

Expert in creating Source-Target Mapping document, Data Lineage, Data Quality Analysis and Gap Analysis

Proficient in writing SQL queries, stored procedures and triggers

Extensive experience in production support and troubleshooting issues in data and reports

Competent in design and development of ETL jobs to extract, scrub and massage the data from different sources / file systems (like Databases, Flat files, Salesforce) and load to target systems

Excellent understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)

Expert in using HP Quality Center and JIRA for defects tracking and reporting

Skilled in all phases of Testing which includes System Testing, Integration Testing, Functional Testing, Regression Testing and User Acceptance Testing

Experienced in BI reports development using Qlikview and SAP Business Objects

Good understanding on Star and Snow flake dimensional modeling

Proficient in Waterfall, Agile, Scrum and Kanban

Knowledgeable in setting up Test Environments, Test Data for UAT and training end users

Experienced in liaising with Onsite and Offshore teams to accomplish the daily tasks on time

Experienced in preparing daily test status reports to communicate the test status with the team

Self-Motivated team player and fast learner, possessing strong communication, reporting and multi-tasking skills

Master of Engineering in Computer Science, Bannari Amman Institute of Technology, India

Bachelor of Engineering in Computer Science, PSR College of Engineering, India

Languages

C, SQL, PL/SQL, Excel Macros

Databases

Microsoft SQL Server, Oracle, Sybase, MS Access

Tools

JIRA, ALM QC, TOAD, WinSQL, Qlikview, BO, Informatica, Autosys, Ultra Edit, Putty, Cognos, MS Suite

Cognizant Technology Solutions, India March-2013 to November-2015

Assignments:

1.The Hartford

Group Benefits – Analytics E3 QA Analyst May-2015 to November-2015

Technologies Used: TOAD, ALM-QC, Informatica, SQL, Autosys, SAP Business Objects, Microsoft Office and Excel Macros

Key Activities:

Successfully led a team of four and was the single Point of contact for QA planning and execution

Analyzed functional requirements and prepared Test Scenarios, Test Case Documents, Test Data accordingly for efficient testing with optimal results which reduced defect leakage

Prepared Test Closure Documents and communicated the same to the client and cognizant leadership team

Performed System Integration Testing, Regression Testing and Smoke testing with Zero defect leakage

Generated reports in BO and compared with values in the data warehouse based on the report logic

Involved in UI system co-ordination for efficient defect identification and test data creation

Un-Earthed defects from already existing systems and highlighted them to client for further improvement

Logged the defects in Quality Centre, triaged them with the team, got them to closure and performed day-to-day onsite co-ordination

Synthesized daily status report and communicated with the stakeholders

Group Benefits - Analytics QA Analyst, Data Analyst June-2014 to May-2015

Technologies Used: TOAD, ALM-QC, Informatica, SQL, Autosys, Microsoft Office and Excel Macros

Key Activities:

Analyzed the data to find the data anomalies and identified the data objects

Synthesized Data Lineage artifacts to aid troubleshooting and impact analysis

Involved in business analysis and technical design sessions with business and technical team to develop requirements document, and ETL specifications

Involved in Source-Target mappings to complement the design and development of ETL

Analyzed functional requirements and prepared Test Scenarios, Test Case Documents and Test Data accordingly for efficient testing with optimal results which reduced defect leakage

Performed System Integration Testing, Regression Testing with minimal defect leakage

Involved in checking Transformations, Mapping and Monitoring autosys jobs

Successfully assigned tasks to the QA team of 7 members and monitored it to closure. Reviewed the work done by the team and submitted daily status report to the stakeholders

Logged the defects in Quality Centre, triaged them with the team and performed day-to-day onsite co-ordination

Played a vital role in the calls with the clients and attended Defect Triage calls

Prepared Test Closure Documents and communicated the same to the client leadership team

2.Rentokil Initial

BI Programme Data Analyst, QA Analyst March-2013 to May-2014

Technologies Used: WinSQL, Microsoft SQL Server 2008, JIRA, Qlikview, Visual Basic Microsoft Office, Excel Macro and Microsoft Access

Key Activities:

Responsible for creating Data Mapping documents between Staging and Integration layer, validation of reports and data profiling

Involved in end-to-end QA and was responsible for QA planning and execution

Involved early during the requirements phase to complement creation of efficient Test ideas, Test strategy, Test Plan, Test Design and Test data strategy

Automated test case creation using Excel Macros which increased the productivity by 5 times

Worked with source system teams on creation of test data according to the Test Scenarios

Created Qlikview dashboard according to the test requirements which enabled easy and accurate testing

Performed Test Execution, logged and tracked defects using JIRA and narrowed down the root cause of defects for easy and accurate defect fix

Performed End to End test coordination with all the involved applications, reported status on daily basis and prepared Test Closure documents

3. Vaanam Technologies Pvt. Ltd., India August-2010 to December-2012

Technologies Used: MS SQL Server, MS Access, Microsoft Office and Excel Macros

Key Activities:

Collected requirements, performed data profiling, and articulated the findings to assist the business needs

Performed extensive data analysis using SQL for preparing Data Audit

Involved in checking Transformations, Mapping and Monitor jobs

Collated the project status and communicated with stakeholders

References available on request Open to relocation

Contact this candidate