Bhavin Shah

● Managing multiple programs/ projects for risk portfolio using SCRUM and Waterfall methods using JIRA

● Works with multiple SCRUM teams to ensure timely execution of QE activities for technology outcomes

● Collaborates with business and technology leaders on product roadmaps, statuses, escalations

● Facilitates communication within a program’s cross-functional teams. Formulates, organizes, and monitors inter-connected project activities

● Develops and controls deadlines and activities for change, risk, and resource management

● Managing diverse team of 25+ onshore / offshore Team Leads and Engineers

● Managing all resourcing requirements and vendor management

● Coordinating QE activities for multiple Product teams working on ETL project streams for its Planning, Estimation, Assignments, Monitoring & Tracking and Reporting

● Managed Basel 3 Reforms, IFRS9 and many regulatory programs / projects.

● Guided team for developing QE automation framework for back end ETL validations using Python and for front end applications and reporting portals using Selenium Web driver

• Collaborated with product owners, team members, technologists, and other scrum masters to define solutions and drive progress
• Managed diverse team of 40 onshore / offshore Quality Engineers and Analyst
• Coordinate QA activities for multiple Big data and ETL project streams and working with individual teams for its management (Planning, Estimation, Assignments, Monitoring & Tracking and Reporting
• Managed diverse team of 40 onshore / offshore Quality Engineers and Analyst Coordinate QA activities for multiple Big data and ETL project streams and working with individual teams for its management (Planning, Estimation, Assignments, Monitoring & Tracking and Reporting
• Enhance QE process and methodology for implementation of DevOps pipeline.
• Managed several regulatory initiatives life Volcker, FRTB, Brexit, IFRS9, Basel Reporting schedules FRY9C and FFIEC 009.
• Guided team for developing automation framework for back end ETL validations using Python and for front end applications and reporting portals using Selenium Web driver

• Major responsibilities include Coordinating, QA Leading & Management (Planning, Estimation, Assignments, Monitoring & Tracking and Reporting). Lead team of 6 testers.
• Managed QA teams, QA deliverables, Functional, integration, system, regression testing & Automation testing.
• Developed test scripts / routines and testing framework for large data warehouse ETL validations processed via Data Stage
• Authored Test Strategies, Test Plans and review of Test artifacts including Test Cases, test scripts, test plan and test results.
• Working closely with Project Manager for resource estimation and budgeting and project priority.
• Maintained QA Plan within the overall Project Plan for multiple Agile project
• Involved in SDLC process improvement discussions
• Reported status to management

• Supported QA activities of 10 applications and various business groups
• Maintain QA Timelines / activities for the various assigned projects
• Managed EDF(Enterprise Document Framework) documentations for all projects
• Maintained QA Plan within the overall Project Plan for multiple Agile project
• Authored Testing Strategies, Test Plan, Testing estimates reports, Traceability Matrix
• Mentored team members for various business and technical knowledge
• Developed automation framework design and guided automation specialist
• Developed test scripts / routines for large data warehouse ETL validations
• Involved in SDLC process improvement discussions
• Reported status to higher management

• Lead all the QA activities for the project
• Managed day to day work distribution of work for onshore and offshore resources
• Maintained QA Plan within the overall Project Plan for multiple Agile project
• Authored Testing Strategies, Test Plan, Testing estimates reports, Traceability Matrix
• Worked as technical BA for working with SME for enhancement requirement gathering
• Lead automation framework design
• Developed ETL and report validation routines

• Maintained QA Plan within the overall Project Plan for multiple Agile project
• Authored Testing Strategies, Test Plan, Testing estimates reports, Traceability Matrix
• Managed day to day work distribution of work to outsourced company consultants.
Worked closely with Director for resource estimation and budgeting and project priority.
• Create Traceability Matrix from Business Requirement for QA /SIT Testing
• Analyzed, designed, implemented and maintained data loads and extractions for various data repositories in Oracle Exadata database, Informatica 8.6
• Developed procedures for extraction of data from data marts, pulling data from various source systems.
• Leading project wide ETL testing automation initiative
• Worked with external vendor in executing the QA activities.
• Developed routines for validating extraction of data from source systems, transformations and various reports and outbound feeds.

• Authored Testing Strategies, Test Plan, Testing estimates reports, Traceability Matrix and Testing result reports.
• Create Traceability Matrix from Business Requirement for QA /SIT Testing
• Worked closely with Project Manager for resource estimation and budgeting.
• Maintained QA Plan within the overall Project Plan.
• Analyzed business requirements and technical master mapping documents for feed processing, reporting & outbound feeds
• Developed routines for validating extraction of data from source systems, transformations and various reports and outbound feeds.
• Validated and reconciled reports like BCAR , CAD, Calculator engine, NCR and Rapid statutory Cognos report to OSFI .
• Analyzed Data, ETL workflows and Mapping Rule / Business rule implementation between source to staging, Staging to ODS, ODS to Warehouse/Data Mart using SQL and PL/SQL routines.
• Developed SQL Scripts, PL/SQL Functions, Procedures and packages for analyzing the rules, data transformation and its population in ODS and Data Warehouse.
• Developed Source System Req. (SSR) and Data Mapping from various sources systems like ACBS, MIF, SIF, Wholesale credit data warehouse etc.
• Created Test Cases and Test Scripts and executed in several runs.
• Validated the Data flows and Mapping Rule / Business rule implementation in ODS and Warehouse/Data Mart based on the Business requirements and use cases.
• Verified Counts and all $figures and its calculations in monthly, Quarterly and Year End reports

• Authored Testing Strategies, Test Plan, Testing estimates reports, Traceability Matrix and Testing result reports.
• Create Traceability Matrix from Business Requirement for QA /SIT Testing
• Worked closely with Project Manager for resource estimation and budgeting.
• Maintained QA Plan within the overall Project Plan
• Create Traceability Matrix from Business Requirement for QA /SIT Testing
• Gathered and analyzed OSFI requirements for reporting and translate them into functional specifications.
• Analyzed, designed, implemented and maintained data loads and extractions for various data repositories in SQL server database using DTS

• Authored Testing Strategies, Test Plan, Testing estimates reports, Traceability Matrix and Testing result reports.
• Create Traceability Matrix from Business Requirement for QA /SIT Testing
• Worked closely with Project Manager for resource estimation and budgeting.
• Maintained QA Plan within the overall Project Plan.
• Analyzed business requirements and technical master mapping documents for feed processing, reporting & outbound feeds
• Developed routines for validating extraction of data from source systems, transformations and various reports and outbound feeds.
• Validated and reconciled reports like BCAR , CAD, Calculator engine, NCR and Rapid statutory Cognos report to OSFI .
• Analyzed Data, ETL workflows and Mapping Rule / Business rule implementation between source to staging, Staging to ODS, ODS to Warehouse/Data Mart using SQL and PL/SQL routines.
• Developed SQL Scripts, PL/SQL Functions, Procedures and packages for analyzing the rules, data transformation and its population in ODS and Data Warehouse.
• Developed Source System Req. (SSR) and Data Mapping from various sources systems like ACBS, MIF, SIF, Wholesale credit data warehouse etc.
• Created Test Cases and Test Scripts and executed in several runs.
• Validated the Data flows and Mapping Rule / Business rule implementation in ODS and Warehouse/Data Mart based on the Business requirements and use cases.
• Verified Counts and all $figures and its calculations in monthly, Quarterly and Year End reports

• ETL processing done from 11 different sites. Data extraction definitions prepared.
• Performed rudimentary cleaning, Transformation, change data formats and data load to staging database using ETL tool Actaworks.
• Performed standardizing and centralizing of data during stage to warehouse process.
• Developed and implemented Business logic in the ETL tools for data loading
• Used Actaworks for processing data and making it ready for Data Mart
• Implemented code to perform normalization of source files and create Tables in normalized form with common content.
• Using Oracle 8i, data conversion into various formats for supplying to 5 different global project
• Developed Database Designs, Normalization, Database Triggers, Stored Procedures.