MADHAVAN Madhavan

Professional Skills Summary Having 6+ years of experience in ETL testing with proven track of record in designing, testing and debugging new & existing ETL Process and Transformation. Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Professional experience in Integration, Functional, Regression, System Testing and UAT Testing. Experience in Healthcare based applications like Facets applications for membership and Provider subject area. Experience in implementation of IT Solutions for leading clients in Investment Banking, wealth management domain and sub-sectors that include ‘Security Services’, ‘Fund & Asset management’, ‘Custody Services’, ‘Private Equities’. Experience in SQL, Apache Drill and PL/SQL scripting. Created ETL test data for all ETL mapping rules to test the functionality of the System/Integration. Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W. Expertise in Informatica PowerCenter (Designer, Workflow Monitor) and Informatica Data Validation Objects (DVO). Experience in creating Requirement Traceability Matrix (RTM) documents. Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables. Experience in using Azure Devops and HP Quality Center (ALM) for Test Progress Tracking and Defect Reporting. Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, Sybase and Teradata for data integrity. Experience in Reports testing in SAP BO Objects. Have some knowledge in Automation using Python . Having a learning experience in Power BI. Gained little exposure in AWS Cloud platforms like S3, Redshift. Proven ability in Working individually or as a part of team, Problem solving, Process improvement activities, Analytical skills, Reporting and Assisting to Management Strong communication & interaction with Clients, Developers, Data Analysts Ability to handle a team and be a team player to handle the project in difficult scenarios.

• Received “BEST TEAM MEMBER (Nebula)” award for giving extensive support and timely Deliverables in the project
• Completed Udemy Course on “AWS Cloud Practitioner Certification”,” Python Programming from Beginner to Masterclass” and “Microsoft Power BI”
• Project Experience:
• Organization: BNP Paribas
• Client Name: Fezziwig (Future Fund Group, Australia).

Google Data Analytics