SUMMARY:

• A mature, high energy financial industry IT professional with demonstrated strengths in software and database testing.
• Database, ETL and Data Integration Tester and Coach/Mentor
• As a data warehouse and business intelligence / data warehouse tester, I organize and lead efforts associated with data analysis, data quality improvements and functional testing of large BI and data warehouse enhancements projects.
• I apply knowledge of data analytics and business intelligence models to routinely complex business testing problems.
• I participate throughout the entire software development lifecycle, including planning, estimating, reviewing requirements, impact analysis, and performing the testing efforts.

SKILLS SUMMARY:

• QA mentor and coaching for test teams
• Data quality assurance assessments, test planning and execution: strategies & engineering (incl. function, regression, load, and UAT testing), change, defect and configuration management. Certified at Confidential .
• Certified outsourcing test coordinator and manager
• Data test process improvement: risk management / compliance, software life - cycle process, standards, and management; CMM implementation, TPI (Test Process Improvement), Agile testing and IEEE software development & test standards
• Working with author of the book, “Testing Data Warehouse Applications”, wrote several new chapters for 2nd Edition in 2012
• APPLICATIONS TOOLS: MS Word, PowerPoint, Excel, MS Project, Access, Visio, ETL Validator. Trained & experienced for Quality Center and testing Oracle10, OBIEE, SSRS, PL/SQL Testing, SQL Navigator, Informatica, SQL Server and SSIS
• Use Cases, HTML, SQL, relational databases
• WIN10 .NET, J2EE, Unix, z/OS, Business Objects
• Experience in maintaining support documents, QA Sign off Documents and maintaining Weekly Status Reports
• Experience with working tools like TOAD 10.0, MS SQL Server Management studio, Win SQL for creating and executing SQL Queries
• Experienced in complete Software Development Life Cycle(SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle.
• Proficiency in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications
• Skills in Defect management, Bug tracking, Bug Reports and generating the graphs using Test Management Tools such as Quality Center, MS Visual Studio & TFS (Team Foundation Server)
• Expertise in OLTP/OLAP System Study, Slowly Changing Dimensions types (SCD'S) Analysis, developing Database Schemas like Star and Snowflake schema used in relational, dimensional and multidimensional modeling
• Extensive experience in Black Box Testing Functional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing on Warehouse Applications
• Familiar with PL/SQL Coding, Normalized Database creation in relational databases like Oracle 8i/9i, MS-SQL Server 2000 and optimizing the SQL to improve the performance
• Good understanding concepts on Business Intelligence and Informatica Power Center 9 using Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Involved in preparation of Test Data to test the functionality of ETL Sources Mappings and Targets.
• Involved in preparation of Test Plans, Test Cases based on High level requirements and make an ensure detailed/system level process wrote Test Scripts
• Involved in preparation of Traceability Matrix based on detail requirements and Test Cases.
• Involved in testing of Business Objects reports by executing the SQL Scripts.
• Over 9 years of IT experience in Analysis and Testing of Business Intelligence solutions using Conversion Data, Data Warehouse/Data Mart Design, Manual, ETL, OLAP, Client/Server applications
• Proficient in understanding warehouse designs based on Ralph Kimball and Bill Inman methodologies
• Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing
• Worked on various Domains like E-Commerce, Health Care Insurance, Supply Chain, Investments and Pharmacy
• Worked under testing methodologies like Agile-SCRUM and Waterfall Model.

TESTING SKILLS/QUALIFICATIONS:

Database, data warehouse testing, Black Box Testing, White Box Testing, Agile Testing; Function, Usability, System, Automated, Performance, Stress, Load Testing, UAT / Acceptance, Regression Testing. Test Planning and Management, Test Coordination, QA Standards / Best Practices, Software Quality Assurance Methods, Test Process Improvement, SDLC Process. Certified Outsource and offshore project manager.

PROFESSIONAL EXPERIENCE:

Confidential

ETL Testing Advisor, DW and ETL Course Speaker

Responsibilities:

• Develop and present data warehouse, data integration, and data migration ETL testing courses for Datagaps' clients
• Develop and deliver Datagaps QA services for data integration (ex. DW) and business intelligence customer teams

Confidential

Data Warehouse and ETL Tester Development

Responsibilities:

• Developing and presenting a course titled “Testing a Data Warehouse” to be delivered online and at client sites. See this free one-hour webinar as in introduction for a full-day course on the same subject.

Confidential

Data Warehouse & ETL Tester

Responsibilities:

• Developed complex SQL queries for ETL and BI report testing
• Developed, documented, and tested extensive ETL process across multiple platforms
• Conducted extensive data integration testing
• Developed and executed plans for data profiling across all source and target data
• Conducted data analysis, data quality improvements, and functional testing on large BI and data warehouse enhancements projects

Confidential

Data Warehouse & ETL Tester, BI Report Tester

Responsibilities:

• Supported business-wide Oracle and Informatica data quality and ETL testing for security investment accounting (EDM) system
• Developed and executed plan for data profiling, Informatica ETL, data warehouse and BI report testing
• Planned and conducted OBIEE report tests for wide variety of applications
• Planned, documented and tested extensive data integration process (PL/SQL) in support of financial security data in the enterprise data management environment (EDM)
• Implemented effective data quality testing standards, verification procedures and tools
• Developed and presented executive level data quality status and process improvement
• Used HP Quality Center: Test Center, Test Lab, Defect management
• Developed & executed an advanced plan to improve data testing with tools, QA process with industry best-practices

Confidential

Data Warehouse & ETL Tester, BI Report Tester

Responsibilities:

• Supported business-wide Oracle data quality and ETL testing for security investment accounting (EDM) system
• Developed and executed plan for data profiling, and BI report testing
• Planned and conducted OBIEE report tests for wide variety of applications
• Planned, documented and tested extensive data integration process (PL/SQL) in support of financial security data
• Implemented effective data quality testing standards, verification procedures and tools
• Used HP Quality Center: Test Center, Test Lab, defect management

Confidential

Data Quality Analyst, Data Warehouse / ETL Tester

Responsibilities:

• Supported business-wide data quality testing for broker dealer accounting system serving 5,000 financial analysts
• Developed and executed plan for data profiling, SQL Server SSIS ETL, stored procedure testing, data warehouse and BI report testing
• Planned, documented and tested extensive data integration process to a data warehouse and data mart
• Implemented effective data quality testing standards, verification procedures and tools
• Developed and presented executive level data quality status and process improvement
• Used Quality Center: Test Center, Test Lab, Defect management
• Developed & executed an advanced plan to improve data testing with tools, QA process with industry best-practices

Confidential

Senior QA Test Lead, Data Warehouse / ETL Tester

Responsibilities:

• Supported business-wide QA process development and deployment for corporate security pricing and rating
• Presented with McGraw Hill Company’s 2009 “ Corporate IT Innovation ”
• Developed, documented and tested extensive PL/SQL, data warehouse and Informatica ETL process
• Implemented effective data quality testing standards, verification procedures and tools
• Prepared highly effective test plans, test execution, defect management - client accounting
• Planned test automation using QTP: candidate components to be automated; what can and cannot be automated; when to begin automation; priorities of components to be automated.
• Developed and presented executive level QA status and process improvement
• Used Quality Center: Test Center, Test Lab, Defect management
• Developed & executed an advanced plan to improve testing with tools, QA process with industry best-practices
• Lead QA analyst and UAT lead for a major credit default swap (CDS) application; on-time, high quality - winner of McGraw Hill Corporation’s highest IT, 2009

Confidential

QA Tester

Responsibilities:

• Lead a team of test specialists to oversee the process associated with settlement, reconciliation and billing of stock and securities lending instruments
• Identified trade discrepancies as well as mitigated the risks related to the trade life cycle.
• Identified complex operational, data and settlement problems.
• Interacted closely with trading, systems support, vendors and clearing organizations to resolve problems and to implement new processes
• Owned test process management and controls associated with pre and post settlements to include regular management review of MIS for aging, number and dollar outstanding as well as identification SOX and other audit requirements.
• Prepared highly effective test plans, test execution, defect management - client accounting, SEC regulation reporting
• Developed and presented management-level QA status and process improvement
• Devised new methods for data quality verification using MS Access, Excel and Quest TOAD
• Developed & executed an advanced plan to improve testing with tools, QA process with industry best-practices

Confidential

QA Test Manager

Responsibilities:

• Business to outsourcing liaison: acceptance tests, defect management, project reporting; release deployment
• Planned test automation using QTP: candidate components to be automated; what can and cannot be automated; when to begin automation; priorities of components to be automated.
• Used Quality Center: Test Center, Test Lab, Defect management
• Developed and presented management-level QA status and process improvement proposals
• Developed test process and reporting tools that substantially enhanced defect management & reporting

Confidential

QA Test Planner

Responsibilities:

• Developed strategy and plans for testing corporate financial office (FAO) applications to support Basel II accounting.
• Teamed to design, develop and test programs that reconcile Basel II balance sheet accounting to current balance sheet accounting processes. Tested BusinessObjects-based reports for the Basel II production data warehouse.
• Planned and conducted end-to-end testing and data analysis of month-end trade account posting to support Basel II accounting and capital risk management. Primary task was data analysis, profiling and cleansing trade data for input to data warehouse, data quality. Used Excel and MS Access extensively for data verification and reporting.
• Planned, developed and conducted unit, function, integration, data warehouse and UAT tests for all money market, secured financing and derivative product applications
• Planned, developed and delivered test process assessment and improvement process for consultancy

Confidential

QA Test Planner

Responsibilities:

• Founded a business named “Software QA Associates”, a best QA practices firm through which this assignment was executed
• Conducted QA and data quality assessment and improvement roadmap for a primary online banking application. Wrote an important technical report with recommendations for SDLC and QA improvements Web development
• Planned, developed and conducted unit, function, integration, data quality and UAT tests
• Worked with business to improve requirements process and develop agile requirements and programming methodology
• Used Mercury Quality Center to manage test reports; Loadrunner for performance, load and stress testing.
• Worked as development and test liaison for Chase Manhattan and their software vendors -- managing communications and QA approvals.
• Using Rational RUP, wrote technical QA and test plans, procedures, and test cases for the Consumer Credit Card programming test process.

Confidential

Quality Assurance Strategist & Analyst, Manager

Responsibilities:

• Assessed the entire manual test process for each of Cygnifi's browser-based client applications to document areas of risk.
• Created functional and UAT test matrixes; prioritized application functions whose failure would represent major problems for users and the business.
• Developed a repeatable test plan to advance the test team from "exploratory testing" process and undocumented tests to documented test cases and scripts.
• Developed a Master QA Strategy to migrate the test department from CMM (Capability Maturity Model) Level 1 through Level 3 over a 1-year period.