CAREER GOAL:

To join a highly qualified and competent team of professionals as a Test Manager or Sr. Test Lead and contribute towards meeting customer goals by using my strong project management and technical skills and experience.

PROFESSIONAL SKILLS SUMMARY:

• 14 years of experience in Software Industry with 11 years in Data warehousing projects
• Experience in managing Client expectation and coordination with stake holder.
• Extensive experience in Project Management activities like Efforts Estimation, SOW, Change Control, Resource Tracking, Project Plan, WBS tracking, Status reports and various daily and weekly quality metrics for management
• Strong skills in management of large test teams and coordination at Onshore and also in Onshore - Offshore model
• Proficient in Functional, Regression, E2E, Migration and System Integration (SIT) testing
• Experience in formulation and management of Test Strategy, Test Plan, Execute and Manage different phases of each deliverable, Risk assessment of deliverables, Monitor and Enhance the test process to continually improve the service offerings, Defect Triage meetings, Test Artifacts walk-through and approvals and Test closure activities
• Excellent knowledge and working experience in Requirement Analysis, Test Scenario and Test Cases creation, Test execution, Defect analysis and Reporting
• Extensive hands on experience in testing ETL processes and data warehouses (DW/BI).
• Sound knowledge of Data warehousing concepts like Star Schema, Fact Dimension tables, SCD types., Classification values, Historical data, data quality and data profiling.
• Excellent SQL and PL/SQL skills and ability to script complex queries to interrogate data and write stored procedures and functions
• Proficient in setting up test automation for test case creation and execution using various tools such as DVO, Dbfit, Beyond Compare, SSIS and Excel Macros.
• In depth knowledge of entire testing life cycle and also on test environment, test data setup, data obfuscation, SQA methodology and Test processes.
• In-depth understanding of development methodologies like Agile, Waterfall and Iterative.
• Experience in various domain like - Insurance, Telecom and Banking
• Excellent written and verbal communication, very good listener and believes in doing things in an optimised and organised way.

TECHNICAL SKILLS SUMMARY:

Software Development Methodologies: Agile, Waterfall and Iterative

Test Management Tools: Project Management, HP Quality Center / ALM, JIRA, Microsoft TFS, Informatica DVO, Dbfit, .net, VBScript, Excel Macros, Beyond Compare, IBM BDM, Informatica 9.5, SSIS, Wherescape RED 6.8.1.1, Attunity Cloudbeam, Putty, Aginity Workbench, WinSQL, TOAD, SQL Developer, AQT, Microstrategy 8.0, ER Studio 7.0, ERWin, Business objects - FirstLogic, Data Quality, Siebel EIM, Autosys, ESP Scheduler, MS Project 2003, MS Visio 2003, MS Office 2013.

Operating Systems: Unix, Windows X, MS-DOS

Databases: Amazon Redshift, IBM DB2 9.7, SSMS/SQL Server 2008 R2, Oracle 11g, Greenplum DB, Teradata, PostgreSQL

PROFESSIONAL EXPERIENCE:

Test Manager

Confidential, Los Angeles

Responsibilities:

• SPOC for testing team in total team size of 120 members.
• Communication and Coordination with Leads and Managers from different teams such as Home Office in Japan, PMO, DMO, Technology, Business Analysts, Data Analysts, Release Management, Infrastructure, Development, Data masking, Performance testing and UAT team.
• Estimation of the efforts, walkthrough to stakeholders and following up on approvals.
• Creating SOW for the project.
• Creating a Resource Plan, Utilization and Capacity planning.
• Tracking test progress based on Project Plan and WBS
• Conducting interviews and mentoring new team members,
• Performance appraisal of team members, providing feedback and identifying individual development plan and tracking.
• Analyze and Review the Business Requirements and Mapping documents
• Creating test strategy and test plan along with walkthrough, review and approval.
• Evaluating Test Automation strategy and continuous enhancement as per project needs
• Coordinating with various stake holders for various testing needs like data model walkthrough, mapping documents, test environment, code handover, data load, defect triage, test artifacts review and approvals.
• Identifying test scenarios for different source systems and reviewing Test Cases
• Technical assistance to the team for writing Complex SQL queries as part of ETL validation of each stage and in resolving various test challenges like different source formats, mainframe files, high volume of data and complex ETL logic.
• Daily project status reporting to senior management using HP ALM, Team progress reporting in daily Scrum calls.
• Tracking project based on various Quality Metrics like Defects Severity, Age, Status, Assigned To and Test Execution progress on Planned vs Actual, Total Pass/Fail/No Run Test Cases, Schedule, Effort and Budget Performance Index, etc.,
• Conducting daily status meetings, team meetings and defect triage meetings,
• Evaluating data quality risks, laying out a mitigation plan and escalating to avoid issues.

Confidential

Sr. ETL Test Analyst and Test Lead

Responsibilities:

• Analyze the User Stories and Acceptance Criteria by having discussions with Business Analyst, Product Owner and Developers.
• Estimating Story points.
• Laying out a test strategy and creating test plan.
• Identifying test scenarios for each stage of data validation.
• Creating templates for Test Automation and laying out structure of the Regression Pack.
• Building fully automated Regression test pack using Dbfit to validate Voice, SMS and Internet data in Large Flat Files with DB and from DB to DB.
• Setting up Test data from Cloudbeam to Amazon Redshift using Attunity Cloudbeam and Replicator. Data load by creating SQL's, Creating mockup data and also data load using python scripts.
• Writing Simple and Complex SQL queries as part of ETL validation of each stage from Source files to Staging to ODS to DWH to KPI
• Creating and peer reviewing Test Cases, Execution of test cases, analyzing test case failures, logging bugs in JIRA
• Structuring bug review meetings as per priority during test execution phase.
• Test artifact management in JIRA.
• Training the team on test automation and mentoring new members on the project.
• Conducting status meetings, task allocation, monitoring progress and status reporting.
• Conducting walkthrough and approvals of test automation, test strategy and test plan.
• Effectively driving the Demo of test user stories to stake holders and Test Sign-Off.

Confidential, NJ

DW Project Test Lead

Responsibilities:

• Requirement analysis using the business requirements, DWH functional design and mapping documents
• Layout the project Test plan, walkthrough and approvals
• Estimation of the efforts required, Review and negotiation
• Creating and Tracking the Work Breakdown Structure
• Laying out a test strategy and Proof of Concept (PoC) to compare data in different DB by exporting the data to flat files and then to MS Access using SQL developer’s DTS feature and comparing using MS Access unmatched query wizard and demonstrating it to the client.
• Creating test scenarios based on business rules and also writing test cases to validate ETL transformation rules
• Writing Complex SQL queries and helped team solve day to day Data warehousing and technical challenges
• Effectively conducting defect triage meetings with stakeholders and setting up defect priority for quick resolution.
• Training team in Data Quality to understand concepts of Name and Address parsing.
• Resolved technical risks such as Test execution of SQL queries across multiple databases, comparing large text files.
• Daily task allocation to the team, progress tracking, status reporting and reviewing metrics.

Confidential

Sr. Data warehouse Test Analyst

Responsibilities:

• Won customer confidence and received frequent appreciation from Senior Management as consistently exceeded project expectations
• Laying out Test Strategy, Identifying key challenges and guiding the test team in functional test approach.
• Complex SQL Test Case creation to functionally test the Staging, Entity Model and Datamart areas and analysis of bugs.
• Sole responsibility of building data warehouse SQL test case Automation using SSIS, complex stored procedure and Dbfit. This resulted in About 60% Effort reduction and considerable savings
• Created Regression pack structure and Implemented it using Test Automation which enabled continuous running of Regression tests and validate data quality whenever new code changes were deployed.
• Identified critical defects which led also led to considerable design changes.
• Improved Acceptance Criteria and clear understanding of requirements for the project as created templates and provided valuable inputs.
• Efficiently organized Regression test pack which reduced regression test efforts and made it a smooth process.
• Successfully lead team of Senior testing team members.
• Reviewing and providing valuable inputs to have better Acceptance Criteria for User Stories
• Estimation of the User Stories and playing Planning Poker.
• Formulating and creating the Test Automation and Regression Pack.
• Complex Test case SQL creation, peer review and technical guidance to the team.
• Analyzing defects and reviewing with Application Development and Product Owner
• Coordinating work required on the project with testers, reviewing the same to deliver it with best quality and in given time frame during part time test lead role.
• Frequent communication and coordination for data load, environment planning, task prioritization, etc., within the scrum
• Arranging Spike sessions to solve complex technical, environment challenges, laying out test strategy, etc.,

Confidential, CT

Test Lead and Onshore Coordinator

Responsibilities:

• High Level of communication and coordination with various teams responsible for different systems to meet testing needs such as requirement clarification, walkthrough and training, mapping documents, test data, test artifacts review and approval
• Delivered all the projects with highest quality (zero QA misses) and on time (zero effort variance)
• Efforts Savings by using Automation tools like Advanced Query Tool(AQT) and Beyond Compare for data compare. Also implemented automated test execution utility using Excel Macros to save test execution time by 40%.
• Wrote Complex SQL Test Cases and helped team solve day to day technical challenges and understand business complexities
• Mitigated the technical risk of executing SQL queries across multiple databases and comparing large text files by developing new test strategies like using AQT and DTS service in SSDB, creating POC for the same and demonstrating it to the client.
• Effectively coordinated and managed 6 projects at one time having total team size of 18 offshore members and 3 onshore leads.
• Requirement analysis using the business requirements, functional requirement and mapping document
• Estimation of the efforts required on the project and negotiating cost.
• Project planning
• Data load, test cycle and test environment planning
• Creating Master test document
• Complex Test case creation, review and technical guidance to the team.
• Reviewing defects with Application Development and Business teams
• Coordinating work required on the project with multiple offshore teams and reviewing the same to deliver it with best quality and in given time frame
• Validating outbound feed data using Microstrategy BO reports

Confidential, Minneapolis, MN

ETL Developer and Onsite Team Lead

Responsibilities:

• Analyzed the Informatica batch jobs and made changes to it or created new Informatica maps for hot fixes, CR’s, performance improvement and also to reduce the deadlocks from 15-20 a week to 1-2 a week.
• Improved the data quality by identifying data issues in DB2 databases, analyzed the data by extracting it to tab-delimited flat files, then comparing it with Beyond Compare tool and creating Informatica loads to cleanse the data. This included creating new mappings to delete duplicate data, segregate data for analysis, populating missing data, etc.,
• Explored the ERStudio tool for data modeling and trained staff. This gave everyone a better picture of the database and its relationships. Used the tool as part of data analysis.
• Coordinated the data loads automation project and did significant development for migration of the batch jobs from UNIX to ESP scheduler. Successfully implemented the same and streamlined the process to reduce the overhead on the on-call rotation and ultimately saved on support cost.
• Setup of Siebel EIM jobs on various servers, testing the setup, recovery management of failed Siebel EIM jobs through Siebel GUI and monitoring the progress of EIM tasks was handled effectively to load the data correctly with immediate turnaround time.
• Coordinated with various groups in the team for loading mass data in counts of couple of billion records.
• Development of Informatica mappings, data load failure analysis and debugging, code fix and deployment to production.
• Workflow monitoring and escalation as per SLA
• Communicating, planning and coordinating work given by the client with the offshore team and reviewing the same
• Analysis of data in DB2 databases by writing SQL queries to understand data related issues
• Performance tuning of Informatica batch jobs to reduce run time so that they complete before business hours.
• Resolving deadlock in batch jobs by analyzing the data integrity
• Development of new Informatica mappings and changing existing mappings to meet the frequent business needs
• Setup and scheduling of batch jobs using ESP scheduler
• Estimation of work and planning the overall activities
• Code development of new VB and dot net batch jobs and applications modules.
• Mentored new resources to speed up in the project.