SUMMARY

• Over 11 years of IT l , experience as BI QA Lead in performing Analysis, Design, Development, Data Analysis Testing and Implementation of various business application systems. Professional experience in diversified IT fields such as Data-warehousing, Data Mart & Client/Server applications under Mainframe, Unix & Windows Environments
• 10 years of experience with System, Regression, Functionality, Integration and U.A.T. with expertise in data mapping, backend testing. used ETL tool Ab Initio and informatica. Also worked with operational sources like DB2, Oracle, MS Sql Server, MS Access Teradata and Flat files
• More than 10 years experience in Auto, Mortgage, Banking, Finance, Insurance, ecommerce and marketing service industries.
• Experience in ETL Data Warehousing, database testing using Ab Initio and Informatica
• 10 years hands on experience with testing Business Intelligence applications
• Over 10 years experience in using and querying multi-dimensional data models
• Well versed with Data Modeling tools like Erwin and Working experience on methodologies like Star Schema and Snowflake Schema
• Hands on experience and strong knowledge of Micro strategy and crystal Reports and other OLAP tools Strong knowledge and experience with Data Mapping/Analysis/Data Merging/Data Cleansing/Data Scrubbing 10 years hands on experience with SQL Hands on experience with TOAD , SQL Station and Teradata Sql Asst for validation of data t
• 8 years hands on experience withQuality Center. Rational Tools (Clear Quest and Clear Case)
• Expertise in handling and testing various Shell Scripts for ETL process in UNIX
• Ex in preparing test data sets ( Initial Loads , Incremental Loads, Constraining Tests)
• Strong hands on experience with OLAP Tools Brio, Cognos, BI. Micro strategy
• Strong hands on experience with analytical skills
• Prepared Test Plans , test cases, test data and executed the test cases , testing status and defect tracking reports
• Involved in Regulatory testing projects and well versed with SDLC and SOX guidelines and compliances
• Strong hands on experience with Testing Methodologies and Testing Tools
• Strong hands on experience with Project Plans and Excel
• Possess Excellent Communication (both verbal and written) & Interpersonal skills. Technically sound, Result-Oriented with strong Problem Solving skill.
• Team Player as well able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies Educational Qualifications: Master of Commerce ( Finance and Accounts) India Post Graduate Diploma in Computer Applications

Work Status: Permanent Resident (Green Card)

TECHNICAL SKILLS

• Languages: PL/SQL, SQL, VB, JAVA1.2, COBOL, C++ and JCL
• Scripting Languages: Java Script, Perl and VB Scripting, Unix Scripting
• Data Bases: Oracle , DB2, M.S SQL server 2003 and 2005 and Teradata , Essbase ( multidimensional)
• GUI: .Net and Developer 2000
• Web: ASP, Java, XML and HTML,
• Operating Systems: MS DOS, Windows XP/NT, Unix and MVS
• OLAP Tools: Brio Query, Crystal Reports, Cognos and Business Objects, Microstragey
• DBA Tools: TOAD, SQL Station and Teradata SQL Asst 6.0
• ETL Tools: Ab Initio , Data Stage and Informatica Powercenter
• Productivity Tools: MS Office, MS Project , Outlook and Visio
• Defect Tracking Tools: Test Director, Quality Center and ClearQuest
• Automated Test Tools: WinRunner, QTP and Load Runner
• ERP: Peoplesoft , SAP FICO
• BI Tools: Cognos, Microstrategy, HFM

PROFESSIONAL EXPERIENCE

Capital One Richmond VA Sept’07 to Present
Test Lead /Senior Tester Capital One Bank IT Project
Responsibilities;

Responsibilities:

• Presently leading the testing efforts of AML Surveillance Program Project which is a ETL Datawarehouse Project in Capital One Bank IT Project and completed the Osmosis Project in Capital One Small Business Group which is also a Datawarehouse Project
• Prepared the Test Plan , Test Cases, Test Entrance Criteria documents , prepared the Test Coverage and Test Kick Off documents and mapped test cases to Requirement Traceability Matrix
• Prepared the Test Scheduled and managed all the Test Schedules in MS Projects
• Assisted the Manager in allocating resources for the Project Level of Effort estimation was given for the testing process for the Project and provided Risk based analysis
• Gathered the requirements and create test cases that ensure the quality of the Data Warehouse (ETL, Ab initio) Extraction, Transformation and Load Process..
• Monitored the jobs and executed and tested the reports and verified the History List
• Tested various reports through Microstrategy and verified the data in target tables
• Verified that the data is populated in Data ware house tables in order to use through Micro strategy
• Tested all the business requirements through Microstategy
• Prepared the Datasets for Initial Loads, Incremental Loads and for Constraining Testing
• Extensively used TOAD, SQL Station and Teradata SQL Asst for validation of data
• Hands on experience with viewing, identifying logs, defects, rejected records
• Logged all the defects and generated reports using Defect Tracking systems
• Reviewed the mapping of operational systems and data sources
• Perform a risk analysis for loading necessary data into the data warehouse
• Lead the Payroll, Checking and ACH systems in Osmosis Project which is a ETL Datawarehouse and GUI involving Ab Initio , Unix , MS SQL and Tera Data
• Hands on experience with Quality Center for writing and executing the Test Cases
• implemented SOX and SDLC
• Accountable for QS SDLC and other QS discipline specific deliverables
• Documented each stage of the project and attended conducted test status meetings every day and weekly

Environment: ETL Windows XP, Unix, Oracle , Clear Case, Clear Quest, SQL, Quality Center 9.0, QTP , , Micro Strategy, Toad, I.E 6.0 S, Java, JSP, WebLogic, XML, Ab Initio, UNIX, MS SQL Server, Teradata, .Net, MS Project, MS Office, MS Access, ODBC, TOAD, Teradata SQL Asst. SQL station

Confidential, Richmond, VA March ‘07 – Aug ‘07
Lead Quality Assurance Analyst, General Motors Quality Assurance Team
Responsibilities:

• Completed the testing cycle of GM Model Office, Decision Power , which are ETL Datawarehouse projects
• Prepared the Test Plan, test cases and executed the test cases and execute test cases and evaluated the results against expected results
• Managed all verification and validation activities for all Production modifications including projects, releases, and changes
• Involved in additional project management responsibilities include planning, estimating, reporting status, identifying and managing risk, and monitoring project to ensure on-time
• Work on Data Quality management practices which support the data environment
• Extracted the data from transaction system to the reporting system and generated different reports using the different business objects tools.
• Involved in testing various web applications including Call Center and Online Member Access Applications
• Involved in testing the back end and batch processing.
• The data is validated by running SQL queries against the tables in the database, and viewed online through Brio query application.
• Hands on experience Designer, Workflow manager, workflow monitor, load manager of Informatica
• Verified the Session log files, session details , performance detail file, reject files, raw error logs, recovery tables and file
• Worked as ETL Tester responsible for the requirements/ ETL Analysis, ETL Testing and designing of the flow and the logic for the Datawarehouse Project
• Creating and executing SQL queries to perform Data Integrality testing on Oracle Database to validate and test data using Toad
• Ran workflows created in Informatica by developers then compared before and after transformation data generated to ensure that the transformation was successful,
• Extensively used SQL for retrieving the data from tables
• Extensively use TOAD and SQL Station – database tools for Data Validation
• Hands on experience with Autosys job management
• Very familiar with the production environments.
• Involved in Production Support for all the applications and instrumental between the development and the production.
• Extensively test the UNIX shell scripting, back end and batch processing.
• Extensively used Quality Center for writing test cases, executing test cases and logging defects.
• Update weekly status reports, attend project meetings, communicate with the project manager, and test team leader.

Environment: ETL, ODBC, Websphere, Windows NT/2000/XP, Unix, Unix Scripting , Telnet, SQL, PL/SQL, Oracle 8.1.7, SQL Server 7.0, Java, VB, MS Access, SQL Loader, VSS, Visio, Ftp, Winscp, QTP, Quality Center, Cognos, Informatica, XML, Java, JSP, WebLogic, Autosys, M.S. SQL, .Net, MS Project, MS Office and Outlook, Autosys

Confidential, Richmond, VA April’06 - March ‘07
Test Lead /Senior Tester
Responsibilities:

• Led the testing efforts of Access Central, Capital One University, SSO (Single Sign On ) Datawarehouse and GUI Projects
• Prepared the Test Plan , Test Cases, Test Entrance Criteria documents , prepared the Test Coverage and Test Kick Off documents
• Mapped the test cases to Requirement Traceability Matrix
• Prepared the Test Scheduled and managed all the Test Schedules in MS Projects
• Assisted the Manager in allocating resources for the Project Level of Effort estimation was given for the testing process for the Project and provided Risk based analysis
• Defined Source – Staging – Data Mart Strategy
• Gathered the requirements and create test cases that ensure the quality of the Data Warehouse (ETL, Ab initio) Extraction, Transformation and Load Process..
• Extensively used TOAD, SQL Station and Teradata SQL Asst for data validaton
• Tested various reports through Microstrategy and verified the data with the target tables
• Prepared the Datasets for Initial Loads, Incremental Loads and for Constraining Testing
• Reviewed Data Mapping/Analysis/Data Merging/Data Cleansing/Data Scrubbing Reviewed the mapping of operational systems and data sources
• Perform a risk analysis for loading necessary data into the data warehouse
• Hands on experience with Quality Center for writing and executing the Test Cases
• Accountable for QS SDLC and other QS discipline specific deliverables
• Extracted the data from different sources and loaded in different tables using ETL tool Ab inito, Unix, Oracle

Environment: ETL, Windows XP, Unix, Oracle 8.17, Clear Case, Clear Quest, MVS, JCL, Test Director, Win Runner, Ab Initio, Micro Strategy, Toad, Java, JSP, SQL, WebLogic, XML. Ab Initio, UNIX, M.S.SQL, Teradata, Peoplesoft, Net, MS Project, MS Office, Microstrategy, Ms Access , ODBC, Crystal Reports

Confidential, Richmond, VA Aug ’05 - March ‘06
Test lead /Senior Tester
Responsibilities:

• Developed Test Plan, Model Activity and formalize QA Methodology as per the Business Requirements and Software Resources Specifications
• Managed all verification and validation activities for all Production modifications including projects, releases, and changes
• Assessed risk to quality based on results of verification and validation and make appropriate recommendations.
• Interacted with Business and System analysts, end users and Developers to understand the System requirements prior to the testing of the application.
• Created Test Data , and wrote and executed Test cases and mapped the Requirements to test cases ,prepared the Requirement Traceability Matrix
• Involved in the User Acceptance Testing from start to end
• Assisted the Testing Manager in monitoring the project and updating of the Project
• Assisted the Testing Manager in directing and administering all operational aspects of the QA group.
• Reviewed the requirements for testability
• Verified the session log files, session details, performance detail file, reject files, raw error logs, recovery tables and files
• Responsible for Product Pricing Engine which comprises of 110 products in Mortgage Transformation Project.
• Creating and executing SQL queries to perform Data Integrality testing on Oracle Database to validate and test data using Toad
• Extensively used SQL for retrieving the data from tables
• Prepared and managed the Test Schedule
• Assisted the manager in analyzing and aggregating all QA project metric data and reports findings to the SDM operations manager.
• Implemented SDLC and SOX
• Assisted the manager in providing guidance on training needs for QA staff and project teams and partners with project managers and sponsors to resolve quality issues.
• Involved in to set organizational quality targets and provides QA support to designated organizational initiatives
• Bug Tracking Done through Test Director
• Documented each state of the project and attended and conducted test status meetings every day and weekly

Environment: ETL, ODBC, Webshphere, Oracle 8.17, ASP , .Net, SQL Server, MLCS, Web Logic, QTP 8.1, Test Director 8.0, IE 6.0, DB2, SQL Plus, Quest, MVS and JCL, Windows XP, MS Project, MS Office, Outlook, Informatica, SOX

Confidential, Richmond, VA March ‘03 - July 05
Test Lead /Senior Tester
Responsibilities:

• Developed Test Plan and Model Activity as per the Business Requirements and Software Resources Specifications
• Completed the testing of SCM Data ware house project , Formula One Project(CRM) , Access One Data Integration, Project One , Single Sign On (Identity Management), Data Distribution Environment (DDE) data warehouse projects
• Prepared Full Life Cycle Test Plan and formalize QA Methodology as per the Business Requirements and Software Resources Specifications
• Managed all verification and validation activities for all Production modifications including projects, releases, and changes
• Assessed risk to quality based on results of verification and validation and make appropriate recommendations.
• Interacted with Business and System analysts, end users and Developers to understand the System requirements prior to the testing of the application.
• Involved in additional project management responsibilities include planning, estimating, reporting status, identifying and managing risk, and monitoring project to ensure on-time
• Instrumental in completing the Quality Assurance and testing of the SCM, Formula One , Data Distribution Projects
• Prepared the weekly Project Status Reports, Operational Tracker and Monthly Dash Board regarding the Projects
• Conducted the weekly project status meetings with the developers and testers
• Ensured that the project QA activities are discussed, reviewed, and agreed upon by the Project Manager and all affected groups before the onset of project activities
• Ensured that the QA involvement in the project is documented and that the activities fully support the project objectives.
• Instrumental in completing testing of the SCM Project both Data warehouse and application Extensively using the Ab Initio (ETL) for data transformations from 18 sources to Target tables
• Well versed with Ab Initio commands
• Monitored the jobs and executed and tested the reports and verified the History List
• Hands on experience and strong knowledge of with Micro strategy Architecture and drilling
• Executed and tested Micro strategy documents and involved in job prioritization
• Gathered the requirements and create test cases that ensure the quality of the Data Warehouse (ETL, Ab initio) Extraction, Transformation and Load Process.
• Created test data to meet the business requirements for the Spend Analysis, Formula One, WMS, Project One and TEDS data mart projects.
• Gathered the requirements and create test cases that ensure the quality of the Data Warehouse (ETL, Ab initio) Extraction, Transformation and Load Process.
• Ensured the senior management t that the project was meeting the terms of all applicablepolicies, processes, standards, and procedures.
• Prepared the Datasets for Initial Loads, Incremental Loads and for Constraining Testing
• Did Data Mapping/Analysis/Data Merging/Data Cleansing/Data Scrubbing Reviewed the mapping of operational systems and data sources
• Involved in all the data validation of the SCM Project
• Created the test data for the 18 sources in Formula One (CRM) Project
• Developed the test cases for the 18 sources for Formula one Project (CRM)
• Conducted the Test Kick off Meeting, Test Readiness Meeting, Test Exit and Review Meetings.
• Tracked defects in Test Director defect tracking application.

Environment: ETL , Ab Inito ODBC, Windows XP, Unix, Oracle 8.17, Teradata, DB2, SQL Plus, Teradata SQL Asst 6.0, Clear Case, Clear Quest, MVS, JCL, Test Director, Win Runner, Ab Initio, Micro Strategy, Toad, I.E 6.0 and TEDS, PEARL, Peoplesoft, DDE, Autosys

Confidential - IL June ’00 - Feb ‘03
Test Lead / Senior Tester
Responsibilities:

• Lead system testing and UAT for the entire ETL DataWarehouse Projects both backend and front end web based projects in EDS (Enterprise Data Services) division in Allstate Insurance.
• Tested the Data Warehouse Projects like ECM, Sales Data Mart, Quote Data Mart, SIU Data Mart and Specialty Ops Data mart projects.
• Coordinated with many different groups like environments, release, development, Configuration Management
• Interacted with Business and System analysts, end users and Developers to understand the System requirements prior to the testing of the application.
• Involved in identifying, objectives, standards for the Automation
• Involved in monitoring, training, gathering and analyzing the automation of the application
• Coordinated in unit, parallel, system, integration, stress (load), and production readiness testing.
• Involved in additional project management responsibilities include planning, estimating, reporting status, identifying and managing risk, and monitoring project to ensure on-time
• Worked on Data Quality management practices which support the data environment
• Worked with Project management team to Prepare Full Life Cycle Test Plan and formalize QA Methodology as per the Business Requirements and Software Resources Specifications.
• Extracted Data from DB2 Database, and transformed the data to UNIX and loading it to the Oracle Database.
• Extracted the data from transaction system to the reporting system and generated different reports using the different business objects tools.
• Gathered the requirements and created test cases that ensure the quality of the Data Warehouse (ETL, Ab initio) Extraction, Transformation and Load Process.
• Created test data to meet the business requirements for the ECM, Sales Data Mart, Quote Data Mart and Specialty Ops data mart projects.
• Gathered the requirements and created test cases that ensure the quality of the Data Warehouse (ETL, Ab initio) Extraction, Transformation and Load Process.
• Created parallel applications and sorting the data in multi-file subsystems.
• Executed test cases by running jobs that extract data from DB2 tables, and UNIX shell scripts that load the data in the Oracle database.
• The data was validated by running SQL queries against the tables in the database, and viewed online through Brio query application.
• Extensively tested SQL and PL/SQL procedures and functions.
• Extensively used TOAD and SQL Station - database tools for the Data validation.
• Worked as Release Coordinator for the UNIX Version Control.
• Extensively familiar with the production environments.
• Involved in Production Support for all the applications and instrumental between the development and the production.
• Extensively tested the UNIX shell scripting, back end and batch processing.
• Tracked defects in Test Director defect tracking application.
• Updated weekly status reports, attend project meetings, communicate with the project manager, and test team leader.
• Conducted all the inspections and walkthroughs with developers and communicating with the production.

Environment: Ab initio, Windows NT/2000, Unix, Unix Scripting (Korn) MVS, Reflection, Telnet, JCL, CICS, SQL, PL/SQL, Oracle 8.1.7, SQL Server 7.0, Java, VB, MS Access SQL Loader, SAP, VSS, Visio, Db2, Ftp, RCS, JRS, Tool box in unix, WinRunner, Load runner, TestDirector,, M.S.SQL, Brio , Crystal Reports

Confidential, CA Feb’ 00 - May ‘00
Lead QA Analyst

Confidential, GA June ’99 - Jan’00
QA Analyst.

Confidential, MI Jan ’99 - May ’99
QA Engineer

Confidential, TX Apr ’98 - Dec ‘98

Confidential Hyderabad, India June’96 - Mar ’98
Programmer/ Tester