SUMMARY:

• Worked as Test Engineering Sr. Analyst in Accenture Service Pvt. Ltd. having approx 7 years experience in ETL Testing and System Integration testing (SIT) of the web based applications in STLC methodology.
• Worked in a client location Confidential, Los Angeles, USA as an ETL Test Lead for 1 year (Duration: Feb 2016 - Jan 2017) under H1B work visa category.
• 8 months coding experience in Application development on C/C++/UNIX platform.
• 2 months of Audit Readiness experience as part of Control Gaps testing in the different LOBs within the bank.
• Good knowledge on Informatica Powercenter - ETL Development tool comprises components such as Repository, Mappings Designer, Workflow Manager & Workflow Monitor.
• Responsible to certify the Production data before implementing to various downstream(s) through MDM.
• Focal point for the Production deployment support occurring every month (MDM releases)
• Expertise lies in ETL testing, Functional testing, Manual Testing and Automated Testing, Back end Testing, Regression testing, User Acceptance testing UAT, System testing, Integration testing
• Excellent knowledge of Agile Scrum development environment, multiple web browsers, and automated testing suites.
• Extensively worked on the various subject areas within a bank e.g. Enterprise Data Warehouse, Financial Crimes and Transaction Monitoring, Corporate Solutions, Risk Assessment etc.
• Well versed with requirement analysis, test planning, test execution, and defect management process.
• Experience in writing complex SQL for querying data against different databases for data verification process.
• Onsite-Offshore Coordination adhering to a Global Delivery Model.
• Having excellent problem solving and analytical skills and experience of test plans, strategy and Procedures throughout the life cycle of a project from specification reviews through to user Acceptance.

TECHNICAL SKILLS:

Primary Skill: Master Data Management, Database/ETL testing(SQL), Data warehouse concepts, Functional Testing(web-based)

Secondary Skill: VB scripting basics (excel macros), C/C++, UNIX

Industry Expertise: FS-Banking, Capital Markets, Insurance

Tools: Toad for Oracle 10.6, SOAP UI, Data Steward UI, Hermes, Informatica Powercenter 9.5.1, MySQL workbench, Putty, WinSCP, HP ALM 11.0(Business Process Test Cases), QTP basics

Development Tools: PAID, SSH Tectia Client C(Unix) based IDE, Exceed on Demand C(unix) based IDE, Perforce and Attachmate Extra X-treme GF2 testing , dacr03 GMX testing

PROFESSIONAL EXPERIENCE:

Confidential

 ETL Tester/Certification tester

Responsibilities:

• Created temporary tables for validations after understanding the transformation logic.
• Validated Message notifications under Pub Sub queues coming from MDM to the various downstream systems
• Validated Survivorship of the Party (customer) during Unmerge and Collapse Parties feature of MDM through Source as well as DSUI tool.
• Validated SOA XML Request and Response retrieved as part of various services like Get Party, Search Party and Maintain Party through SOAP UI
• Validated Initial and Incremental Loads of source system(s) into MDM.
• Validated Customer Metrics and Annual Survey performed source wise.
• Certified Production data and part of Production deployment- MDM releases.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Documented the validation rules, error handling and test strategy of the mapping.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Extensively Used HP Quality Center QC /ALM as test management tool and Created and maintained the defects in HP Quality Center/ALM.
• Tested data sheets with Agile and Waterfall methodologies.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Conducted test case daily reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System ETL Mapping Document for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Defect triage with Business Analysts, Data Architects and Developers in order to identify valid defects.

Confidential

ETL Tester/Functional Tester/Control Tester

• Preparation of Test plan, Test Approach, Test Scripts, Requirement Traceability Matrix based on the requirements given in FRD/BRD.
• Writing complex SQL queries for querying data against different databases for data verification process
• ETL validation includes
• File Conformance
• Transformation Logic validation
• Referential Integrity validation
• Source to Target data comparison
• De-duplication validation
• Output MANTAS file validation
• Defect management
• Walkthrough on the overall testing process to the Client team.
• Daily basis reporting of Feed instance keys to entire FCTM file delivery system..
• Preparation of project documents like Application Testing Document, Project workflow docs on File conformance and Staging Validations.
• Preparation of Test plan, Test Approach, Test Scripts based on requirements given in FRD/BRD.
• Quality Control Workbook that includes Entry/Exit Criteria Gates
• Project Plan, Test Cycle Matrix documentation
• Test Data Analysis and management
• Rationalized BPT scripts creation
• Defect management/ Defect leakage metrics
• UAT support
• Daily Status Reports
• Other forms of testing like UI vs DB testing, Smoke Bed, Blackduck, Sanity Checks
• As part of Audit Readiness within different LOBs of bank, testing the controls placed to remediate an issue identified during Audit.
• Validate their effectiveness and sustainability in the business.
• Present the test results to the Business stakeholders, Issue owners and Action Plan owners.
• Conclude the Closure rating.

Confidential

 C/C++/UNIX Developer

• Understanding LLD and HLD documents
• Developed convertors responsible from converting payment transactions from different source systems.
• Analysis existing code in the PAID application and grapped generic code that is used/helpful in creation of further applications ( like: Swift tags for Ack and Nack in the code, how it was used in the existing functionality and its generic stubs)
• Inward and outward Message clearing flow
• Swift tags for Ack-Nack
• Malaysia RENTAS inbound/outbound clearing flow
• IMF to ICBC conversion
• CRF/EAPS to IMF conversion
• Creation of Technical Design document
• Unit testing and creation of UTC document.