Madhan Radhakrishnan

Email - ac2lh4@r.postjobfree.com

Tel - 480-***-****

OBJECTIVE:

Seeking a challenging opportunity for a ETL Test Lead role in a well reputed organization, where I can apply my technical, analytical, problem solving, leadership skills and user perspective thinking to improve quality of every deliverable.

PROFILE HIGHLIGHTS:

12 years of experience in Software testing of complex Financial and Banking and Billing applications.

7.5 years experience in QA team leading, Project Management, training and guiding team members to achieve project target.

Experienced in ETL, Data warehousing and Database testing on SQL and Oracle databases.

Experienced in SSIS Packages Imports from file to Database.

Experienced in SSRS reports.

Expert in test management using HP Quality Center, ALM, MS TFS, MS Testing Center.

Strong exposure to SDLC on Waterfall as well as Agile/Scrum methodologies.

Expert in Business requirements analysis and suggesting enhancements for improvement of product quality, performance and better usability.

Proficient in Test Management, Test strategy development, Test planning and hands on execution.

Domain Expert in Financial and Banking related to Portfolio management, Investment Banking Billing, ETL of Financial Collections and Loan Processing.

Dynamic in working with all teams involving Developers, Business Analysts, Product management and Client Support teams for deliveries on time, budget with highest quality.

ENVIRONMENTS:

Windows 98 to Windows 10, Win 2008-12R2 servers,

Unix, Back end servers with Solaris and AIX OS

Oracle 9i-11GR2, Informix

SQL Server 2012, 2014 standard and enterprise edition

Toad Data Point

Informatica IDQ

C,C++,Java, .Net

MS Access and SSRS reports

HP -QC and ALM

MS TFS, Share point, Visual Studio

TESTING TOOLS:

Test Management with HP Quality Center, ALM

Exposure to QTP

Microsoft TFS and Testing Center

CERTIFICATIONS:

ISTQB certified tester

Microsoft Certified Professional

EDUCATION:

Bachelor of Technology in Information Technology- Madras University, Chennai, India.

PROFESSIONAL EXPERIENCE

1. Project - Advantage Fee April2015– Till Date

Employer – Fiserv, Los Angeles CA

Role: QA Tech Lead

Advantage Fee is highly customizable and complex billing software used for invoice generation by almost all major Investment banks. The product offers solutions for Invoice generation in custom invoice formats and billing rules, Forecasting Revenue, Accounts Receivable, Accounts Payable, Accruals, Reporting, Dashboards and Importing data feeds. Advantage fee offers imports modules for accounts, securities, transactions, accrual history, Account Receivable and payments and exports for Direct Debit and General Ledger extracts.

Responsibilities:

Team leading, training and guiding QA team members on product functionality, calculations and business use case scenarios.

Installation, Deployment and Troubleshoot to resolve errors in SSIS, SSRS, Database issues and Software test environment for the team.

Implement new and improved overall quality process and management, testing methods and tools.

Testing critical production issues in test environment and finding out the root cause.

Auditing and Ensuring highest quality standards throughout all stages of product life cycle.

Estimate Schedules, determine project scope and drive project delivery, monitor Quality Assurance activity and approve project releases.

Review product requirement documentation, participate in design sessions and provide stakeholders with risk analysis.

Provide Technical assistance, technical training, review and approve test plans, test cases, release notes, user manuals and identify technical issues within project delivery.

Improve Regression test suite by identifying, reviewing and adding additional test scenarios to ensure high product quality.

Automation test suite improvement and adding additional test scenarios

Involved in every level of System, Integration, regression testing, Performance benchmark testing.

Test estimation, Planning, Test strategy, Test cases creation and execution.

Escalate the risk of outstanding issues, quality and performance issues to senior management.

Improve testing efficiency, test scenarios coverage and effectiveness of testing methods and strategy.

Lead Defect Triage and Defect Removal Efficiency improvements.

Database testing of data structure changes to improve and optimize the data handling.

Validate and ensure proper error handling mechanisms in import processes.

Certify product for technology upgrades like .Net frame work upgrades, Browser upgrades and Database version upgrades, legacy VB6 code conversion to SSIS Packages.

Propose enhancements and changes to the product for better usability, performance and better user experience.

Environment and Tools:

HP ALM Quality Center 12.01

SQL Server Management Studio

SQL 2012

SQL 2014 Standard and Enterprise edition

.Net3.5 and 4.6 frameworks

WPF

SQL Server Reporting Services SSRS reports.

SQL Server Integration Services (SSIS Packages)

Windows server 2008 R2 and 2012R2

Microsoft Share point

C,C++, .Net C#

2. Project – Bank of the West, CCAR & CAPPR July 2014– April2015

Role: ETL QA Project Lead

CCAR and CAPR is a project to submit the Financial, Capital, Loan, Assets and Liabilities report to the Federal Bank from Bank West (BWE)with consolidated information from Bank of the West (BOW)and First Hawaiian Bank(FHB). The project involves ETL of data from all sources to staging tables, enrich them and finally load the Schedule tables from which the reports will be generated.

Responsibilities:

Co-ordinate between teams like Data Governance, Business Analysis, PMO, Line of Business, IT QA and UAT teams.

Test estimation, Planning, Test strategy, Test cases creation and execution.

Layout and implement SDLC process improvements across all IT teams in the organization.

Analyze the Data mapping requirements and business logic to pull data from sources and load into staging table clients in a very challenging environment

Testing ETL Data to Staging and Schedule Tables from Enterprise Data Warehouse sources.

Responsible for Test strategy and planning to integrate data from multiple sources.

Involved in System, Integration, regression testing and end to end testing.

Responsible for leading QA team, data analysis, calculation logic and deliverable for all projects.

Helping the Line of Business to successfully perform the UAT of Schedule elements.

ETL and Database testing of data structure changes to improve and optimize the data handling.

Team leading and guiding QA team members on data analysis and calculations.

Auditing and reviewing all project documents in every stage of SDLC from requirements to ensure quality and process adherence.

Environment and Tools:

Oracle 11g

Toad Data Point

Unix

XML

Informatica IDQ

HP ALM

3. Project – Weltman Weinberg & Reis March 2013– Jun2014

Role: ETL QA Project Lead

WWR is a financial collection law firm which handles the collection process of many major banks in the US. The Information is exchanged in EDI format between the banks and the firm which is either extracted or loaded from the Data warehouse. The input information received from all banks in EDI format is loaded into Data warehouse and the ETL is done through SSIS packages. After all the financial processing and maintenance, the data is once again fetched from database and loaded into Data warehouse and information is sent to banks again in EDI format.

Responsibilities:

Analyze EDI data formats and mapping based on requirements of client EDI format in a very challenging environment

Testing ETL Data from EDI files to Database extracted from New Data warehouse to EDI file reports.

Responsible for Test strategy and planning to integrate current EDI process to CSS Impact EDI software.

Perform System, Integration, regression testing and helping developers for recreating production support issues.

Test estimation, Planning, Test strategy, Test cases creation and execution.

Preparing Test Summary reports and present to executive management team and escalate the risk of outstanding issues to senior management.

Taking initiative to automate repetitive tasks and regression testing.

ETL and Database testing for the changes in data structure to improve and optimize the data handling by the application processes to improve performance.

Team leading, training and guiding QA team members on EDI data analysis and calculations.

Driving project progress and coordinating with all onshore and offshore team members and managers.

Reviewing and approving test documents of team members.

Auditing and reviewing all project documents in every stage of SDLC from requirements to release notes and user guides to ensure quality and process adherence.

Layout and implement SDLC Process improvements across all IT teams in the organization.

Environment and Tools:

Microsoft Team Foundation Server, Microsoft Share point and Testing center

SQL Server Management Studio

SSIS Packages

SSRS reports

Web services

SQL Server 2008 R2, Windows Servers

4. Project -RPAI Domain Migration Oct 2012 - Feb2013

Client - RPAI

Role - Project Lead.

This is a domain migration project involving the migration of all systems like Active Directory Migration,Email exchange migration, Domain migration of all servers, Implementation of Business critical applications like JDE, Microsoft CRM, Share point, Tenant Portal and Imanage in new domain.

Responsibilities:

Responsible for Test estimation, Planning, Test strategy, Test cases creation and execution.

Implementing and Testing Active Directory Security policies for the entire project including Active Directory Migration, Email exchange migration, Domain migration of all servers, Implementation of Business critical applications like JDE, Microsoft CRM, Share point.

Troubleshooting critical issues in client environment servers and finding resolution with quick turnaround.

Interacting with onshore client and users and understanding their business requirements and working with offshore team to implement the requirements.

Driving project progress by coordinating with all onshore and offshore team members and managers.

Auditing and reviewing all project documents in every stage from Requirements to user guides to ensure quality and process adherence.

Helping development and implementation team members to troubleshoot and fix security issues on servers.

Successfully delivered every deliverable on time within budget with high quality.

Improved testing process and streamlined project progress.

5. Project - Advantage Fee Jan 2010– Sep 2012

Client – Fiserv, Los Angeles CA

Role: QA Project Lead

Advantage Fee is highly customizable web based billing software used for invoice generation by all major Investment banks. The product offers solutions for Invoice generation in custom invoice formats and billing rules, Forecasting Revenue, AR,AP, Accruals, Reporting, Dashboards and Importing data feeds. Advantage fee offers imports modules for accounts, securities, transactions, accrual history, Account Receivable and payments and exports for Direct Debit and General Ledger extracts.

Responsibilities:

Worked on both web hosted services HTTPS and also TCP/IP deployment model.

Responsible for testing all components of the software and a complete regression testing of the Billing Engine for calculations and UI enhancements.

Involved in System, Integration, regression testing, performance benchmark testing and helping developers for Unit testing and product team for UAT testing.

Test estimation, Planning, Test strategy, Test cases creation and execution.

Preparing Test Summary reports and present to entire team and escalate the risk of outstanding issues to senior management.

Database testing for the changes done in data structure in database to improve and optimize the data handling by the application processes to improve performance.

Team leading, training and guiding QA team members on product functionality and billing calculations.

Interacting with Onshore Client QA Director and QA manager for project status reporting.

Driving project progress and coordinating with all offshore team members and managers.

Testing the software product for technology upgrades like .Net frame work upgrades, Browser upgrades and Database version upgrades.

Auditing and reviewing all test scenarios, cases and project documents in every stage of SDLC from Requirements to release notes and user guides to ensure quality and process adherence.

Environment and Tools:

HP Quality Center

Quality Test Professional.

Oracle 9i – 11GR2, SQL 2005-2008,.Net3.5 and 4 frameworks, WPF,MS Access and SSRS reports, Windows XP – Windows7 OS, Win 2000- 03 servers, Share point.

6. Project – Global Investment Manager Sep 2006-Dec2009

Client –Fiserv, Los Angeles CA

Role: Senior QA Tester for UBS bank Dedicated Team

GIM is a Portfolio Accounting and Investment management product used by portfolio managers of leading financial institutions and investment banks. GIM provides complete portfolio management and reporting solutions which deals with every asset type that can be bought. It provides multi-currency support for accounting, trade and settlement operations.

Responsibilities:

Expert in Analysis of Requirement documents, Design documents & Business Rules.

Testing critical production issues in test environment and finding the root cause.

Test estimation, Planning, Test strategy, Test cases creation and Test execution.

Reviewing test documents of team members.

Reviewing all project documents from Requirements to release notes and user guides to ensure process adherence.

Suggesting enhancements/changes to the product for better usability, performance and better user experience.

Training and guiding new QA team members and giving presentations on functionality and calculations.

Helping team members on the overall functionality and business use case scenarios to implement

Enhancements.

Environment and Tools:

HP Quality Center 9.2

UNIX, Informix, Oracle, Backend servers with AIX and Solaris and Windows XP.

7. Project : Mercia Links Enterprise– Infor Oct 2005 – Aug2006

Client –Infor, UK

Role: Tester

MLE is supply chain management and ERP product which offers ERP and SCM solutions for clients in production industry with Inventory management, revenue and sales Forecasting based on historical data and Market intelligence with the help of statistical analysis.

Responsibilities:

Exploring and learning the functionality of the product and participating in brainstorming sessions.

Found few application crashing defects during product training phase itself.

Test cases creation

Test execution

Defect Logging and tracking to closure

Environment & Tools:

Windows 98, XP, SQL & Oracle, Toad, Tomcat, Royal Blue bug tracker.

Contact this candidate