SUMMARY:

• Over 11+ years of experience in Software Industry as a Project Manager, Test Manager and as a Developer.
• Produced and managed project plans for major IT implementations through Agile/Scrum project method.
• Experience on Banking,Retail Products, Process, Methodology, Risk Framework and Analysis for Market risk/Credit Risk.
• Experience on creation of Test Plan, Test Strategy for all phases of testing including, BCP,System Integration Testing (SIT), User Acceptance Testing (UAT), Client Acceptance Testing (CAT), Functional, Performance and Regression Testing including new and modified applications
• Implementing Client/Server SDLC/AGILE, Web Applications by using different Tool: Hadoop, Ab - Initio(ETL), Informatica, Query Surge, CAPSTONE, TSYS, MAINFRAMES,QTP, Nexsure,Selenium, ALM/QC,DB2,ORACLE,SQL Server, SCOREX and UNIX.
• Domain industry expertise in Data Warehousing(ETL), Credit risk operations and Credit card processing, Credit risk
• Detailed hands-on experience on industry-standard back office processing functional areas, including settlements (SWIFT, ACH, Fed Wire), documentation (confirmation, advices, reset advices, etc.) and accounting (general ledger),measurement and management, Lease finance, Transferring funds, checks and Residential mortgage loan processes.
• Experience in handling onsite and offshore teams.
• Involved in entire QA Life Cycle, which includes Design, Development and implementation of entire QA process and creating of Test Plans, Test Cases and Test Scripts for Relational Database/Web and clients/server Applications.

TECHNICAL SKILLS:

DBMS: Hadoop, Oracle 9.x/8i/7.x, SQL Server 2000/7.0, DB2, Teradata 7.1

Testing Tools/System Tools: Mainframes, Query Surge, Selenium,Hadoop,ily,BMC,QTP8.2/9.0,QC9.1,TRIRIGA,WinRunner8.2,ClearQuest,TestDirector,LoadRunner7.6,TES,TDG,CONFIG WORKSTATION, IBM Amdahl, Erwin, HAMMER, Einstein.

ETL/Reporting: AbInitio, Informatica,Datastage6.0/7.0,BusinessObjects, CAPSTONE, Control M, TSYS, Micro Strategy.

Operating System: MVS, TSO/ISPF, Windows XP/ NT/2000/2003, MAC, SQLSERVER 2005, AIX, TANDEM, Linux, UNIX, Sun Solaris 2.6/2.7,IBM, HP-UX.

Scripting Language: Java Script, V.B Script.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Test Lead

Responsibilities:

• Participated in BCP Testing, System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Responsible for complete release of the product and track Metrics on different stages of project with production support
• Validation of the new Confidential test data warehouse (TDM)for exact processes/business rules with respect to DWH of Confidential Environment
• Build new Data Dictionary sheet to support Confidential business rule with respect to data constraints for downstream(SAP)
• Evaluate the migration of billing and Invoicing for new QA Environment
• Identifying creation and managing of test data metrics and reporting
• Perform functional testing, regression testing, UAT Testing and End to End testing
• Schedule knowledge acquisition workshops sessions with SMEs to gain knowledge of existing application
• Preparing application specific document repository assessment like functional & technical specs, test data
• Support processes- incident Management, change management, release management
• Track and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc
• Act as the single point of contact between Development and Testers for iterations, testing and deployment activities.
• Identify Test Data required to complete the Test Scenarios and interacting with Project Team members to ensure the Data is available for Testing and execute assigned Test Cases manually.
• Oversee project planning for development, testing and implementation phases
• Daily sync with Offshore QA/Automation team and providing KT on new business enhancements

Environment: s/Tools: NEXSURE,SQL Server,Velocity, SAP,ALM,JIRA,UNIX,Epic

Confidential, Charlotte

QA Test Lead

Responsibilities:

• Introduced and Implemented new process toward the LUCAS application which is 30 years Old.
• Define new strategy to move current old process and coordinating/upgrade to new/downstream environments
• Integration plan to sync the external parties systems with Confidential system
• Manage Offshore QA team in India, provide enough transition and track daily work/status
• Maintain data integration between 4 applications 1) PRECISE 2) LUCAS Web 3) CLICK and 4) LUCAS
• Redefine and validation of 288 iReports for downstream and Analysis of data
• Assists in the creation, preparation, and implementation of systems quality assurance reviews, development and execution of test plans and test scripts.
• Implementation of Data Driven framework for integration of LUCAS and System Interfaces
• Responsible for sharing and building team knowledge in customer requirements
• Works with more experienced analysts to assist in test strategy development.
• Track/verify the defects and production support.
• Documents all phases of the Systems QA process.
• Gathering business and technical requirements during the initial and enhancement phases of the project.
• Participated in analysis, overview and walkthrough meetings with user groups
• Responsible for understanding requirements, writing Test cases and executing test cases (GUI and Back End DB)
• Environment/Tools: LUCAS, JIRA,UFT,SQL, ALM, .NET, SSIS

Confidential, St Louis, MO

ETL Test Lead

Responsibilities:

• Review/Base line all requirements with Business and follow Agile/Scrum process
• Connect with 3rd party vendor RTTS for the implementation of Hadoop-QS environment
• Analysis on Automation scope with present Testing process and implementation of QTP/UFT automation tool
• Validation of Informatica work flows dumped data from SOR to RAW layer and from RAW to HM and then from HM to Delta Layer. HM Layer is where data is sanitized.
• Downstream customer data validation fter ETL process using TSYS in different screens
• Validation of scheduled jobs through Autosys
• Implementation of Query Surge and Informatica work flows validation of distributed source/target systems: hdfs,DB2(Linux/Mainframes),SQL Server, Oracle, LINUX
• Data Points includes File Data Validations, Boundary Validations. Schema Validations, HM Data field transformation validation. Count Validation.
• Used Selenium- To parameterize the project ID and project name. Check boundary values. Performance, Speed and accuracy. Parameterize the variable values. Run multiple files by parameterizing.
• Testing the Parameters in SOR to RAW Parameter file, RAW to HM parameter file.
• XML File validation-validate the Workflow Name, Project Name, Folder Name and file names
• Develop the test plan for the tasks, dependencies and participants required to mitigate the risks to system quality
• Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization.
• Act as the single point of contact between Development and Testers.
• Track and prepare the report of testing activities like test testing results, test case coverage, required resources, and defects discovered and their status, performance baselines etc.
• Preparation/review of test reports
• Ensuring the appropriate planning and management of the test resources
• Assessing the progress and effectiveness of the test effort
• Advocating the appropriate level of quality by the resolution of important Defects

Environment: /Tools: Hadoop-HDFS,Hive, TSYS,Mainframes, Informatica, UNIX, Query Surge,DB2, Teradata,UNIX,Selenium,Oracle,db2,SQL Server,HIVE,ALM,QTP

Confidential, Bentonville, AR

ELT Test Lead

Responsibilities:

• Gathering business and technical requirements during the initial phase of the project.
• Data Validation of different distributed (source/target) systems using HIVE,ORACLE, UNIX
• Validation of 3 custom reports with target data for downstream analysis
• Validation of ETL work flows scheduled with different process condition
• Followed agile model and interact with Business and Product owners for 3 modules
• Creation of Test Cases, Test Plan, Test Strategy and SMTD documents
• Managing story point and test cases using JIRA
• End to End testing of POS system with third party company “3P”
• End to End accounting/GL validation using TSYS and UNIX jobs
• Managing Oozie work flows and validation of jobs and data with respect to the process defined on loads
• Co-coordinating with offshore team and handling production issues and coordinating with of shore team and generating Execution Monitoring, DailyTrack and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status.
• Creation and utilization of Selenium Automation scripts of 3 regression suites.
• Participated in analysis, overview and walkthrough meetings with user groups
• Attend code review meeting for each Sprint/production role outs
• Responsible for understanding requirements, writing Test cases and executing test cases (GUI and Back End DB)
• Generating Reports and live analysis Graphs sharing with the team to check how much work load to evaluate due to new changes/Enhancements
• Coordinating & Reviewing the Unit Testing & Integration Testing.
• Setting up Test Environment for QA testing and SIT/ UAT .

Environment: /Tools: Hadoop, UNIX, JIRA,NET, COBAL,JCL,TSYS,Spark, Selenium,JSON Web Token,Eclips, AJAX, Angular, Tririga, Oozie

Confidential

Project Manager

Responsibilities:

• Planning and managing of multiple IT testing projects
• Preparation of test plans, writing of test cases, Execution of test cases to meet highest quality of the products being tested
• Validation of Mainframe JCL jobs and Control-M scheduled process
• Validation of 5 “DC” operation logic with different mode of transition methods
• Creating stories and tracking defects in JIRA
• Validation and review the logs. XML,MQ series and Web Services
• Provide production support and monitor batch cycles for daily and weekly jobs
• Project matrix capturing, Project status reporting and etc.
• Tracking of defects and test coverage to reduce bug leakage

Environment: /Tools: MAINFRAMES, JDA, JCL,COBAL,DB2,Oraccle,QC,UNIX

Confidential

Test Lead

Responsibilities:

• Participate in architecture reviews, design reviews, validation of new code on test systems, ensuring the code performs as expected and assist production implementation.
• Involved the analysis of current customer tools offering, determining requirements and improving current or selecting new web-based tools.
• Perform functional testing, regression testing, UAT Testing and End to End testing
• Participated in BCP Testing, System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Responsible for complete release of the product and production support
• Schedule knowledge acquisition workshops sessions with SMEs to gain knowledge of existing application
• Preparing application specific document repository assessment like functional & technical specs, test data
• Support processes- incident Management, change management, release management
• Track and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc
• Act as the single point of contact between Development and Testers for iterations, testing and deployment activities.
• Identify Test Data required to complete the Test Scenarios and interacting with Project Team members to ensure the Data is available for Testing and execute assigned Test Cases manually.
• Oversee project planning for development, testing and implementation phases.

Environment: /Tools: UNIX, SQL,QC/ALM,TES,Nexsure Env

Confidential, Richmond, VA

System Specialist/Test Manager

Responsibilities:

• As a part of the team, responsible for business requirements collection, communicating directly with other data warehouse team members including business clients, data modelers, business clients and warehouse developers to confirm requirements and taking part in preparing functional and technical design documents.
• Worked with the business users in identifying gaps and requirements and documented them accordingly.
• Working End-to-End testing of Secured/GFE/UPMARKETS/CANADA Cards/Web applications application.
• Worked extensively on CAPSTONE to check different solicitations like CUSTOME, REUSE etc.,
• Extensively worked Ab-Initio graphs by using various techniques like using look ups (instead of joins), In-memory Sorts, Joins and Rollup to speed up Ab-Initio graphs.
• Validation of Ab-Initio graphs for different load on source and Target table- Extract, transform and load data from multiple input sources like Flat files, Oracle files etc.
• Created daily status reports and submit them to the Business Manager, Project Manager and other stakeholders.
• Designed and Developed the graphs using the GDE, with components partition by round robin, partition by key, rollup, sort, scan, reformat, join, merge, gather Normalize, concatenate components. Also used the components like filter by expression, partition by expression, replicate, partition by key and sort Components
• Mapping and validation of data through process and TSYS
• Scrum meetings with development and business teams to understand and address their needs.
• Gathering business and technical requirements during the initial phase of the project.
• Planning different cycles of testing with BA's for high-level scenarios as part of SIT
• Generating Daily work Task, evaluating with the team and categorizing the level of issue.
• Conducting meeting with offshore team to resolve high priority Production issues.
• Coordinating & Reviewing the Unit Testing & Integration Testing Setting up Test Environment for QA testing and SIT/ UAT .
• Since this application contains sensitive information of customers, performed Security Testing to ensure that security was maintained throughout the application.
• Handling production issues and coordinating with of shore team and generating Execution Monitoring, Daily load reports using Business Objects.
• Generating Daily work Task, evaluating with the team and categorizing the level of issue.

Environment: CAPSTONE,ABInitio,CONFIGWORKSTATION,SAS,QC,BusinessObjects,QTP,TSYS,TDG,PL/SQLPlus,JAVA,PERL,TSO,ISPF,TOAD,DB2,VisualBasic,Teradata,LoadRunner,MAINFRAMES,FileAid,Sitescope,M.SSQL,JUNIT,AIX, MACINTOSH,,UNIX,CICS,TANDEM, TCP/IP,FTP,HTTP,SSL,FTP/IP,SSH(PUTTY),SMTP,SNMP,LDAP and IBM Amdahl.

Confidential, NJ

Test Lead

Responsibilities:

• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality (Agile).
• Validation of Data Stage flows with respect to business requirements expectations
• Created Test Plans, Test Cases and Test Scripts zfor the modules of the application under test (AUT) using Quality Center.
• Testing new migrated code (Every Two week’s release) and validating the conditions with lookups
• References used automation using QTP and Defects: QC.
• Involved in Designing and development of PL/SQL Programs, procedures, Load/running UNIX Scripts to Track carrier status and data files on real time basis.
• Co-coordinating with Specs writer, Developer and Quality Assurance engineer for solving persistent faults.
• Involved in Performance testing, Regression testing, SIT and User Acceptance Testing.
• Created User Defined functions to enhance the maintainability of test scripts which includes process for cross browser validations
• Testing an applications which contains sensitive information of customers, performed Security Testing to ensure that security was maintained throughout the application.
• Involved in Gathering and Reviewing Business Requirements and System Requirements.
• Produce and document summary and detailed test reports using standard templates.

Environment: /Tools: NES,MAC,QTP,QC/TestDirector8.0,PL/SQLPlus,XML,Oracle8i/9i,DATASTAGE,TOAD,UNIX,PVCS, TeamTrack,WEBSTAR,V.B,MAC OS.

Confidential, Wilmington, DE

QA Lead

Responsibilities:

• Extensively involved in Life Cycle including requirement gathering, analysis, design, development, testing, implementing and maintenance for Data warehousing using ETL Tool (Data Stage) and monitoring/Schedule Control-M.
• Validation of GL’s for 5 Business Cards related to Customer Activities, Billing validations using TSYS
• Confidential Bank launched Business Card product, which will require data capture from paper applications, and the transmission of that data through automated processes, extensively worked on the system.
• Involved in Designing and development of PL/SQL Programs, procedures, Load UNIX Scripts to Track carrier status and data files on real time basis.
• Responsible for understanding requirements, writing Test cases and executing test cases (GUI and Back End DB).
• Extensively handled production issues (along with Offshore) in promoting and scheduling the jobs using Control-M.
• Understanding/Implementation of Customer Retention System (CRS).
• Responsible for Functional, Data Driven and Regression Testing on different Applications..

Environment: SCOREX,TSYS/TS2,PL/SQL Plus,XML,Datastage,Java,App Edit,HAMMER,Batch Edit, Oracle 8i/9i,QC 9.0,V.B Script,PeopleSoft,QTP,Web Load,TOAD,Control-M,Windows XP,UNIX,C.

Confidential, Richmond, VA

Test Lead

Responsibilities:

• Working End-to-End testing of Secured/GFE/UPMARKETS/CANADA Cards/Web applications application.
• Worked extensively on CAPSTONE to check different solicitations like CUSTOME, REUSE etc.,
• Extensively worked Ab-Initio graphs by using various techniques like using look ups (instead of joins), In-memory Sorts, Joins and Roll up to speed up Ab-Initio graphs.
• The project extensively used Ab-Initio to extract, transform and load data from multiple input sources like flat files, Oracle files etc.
• Tested on improving the performance of Ab Initio graphs by using Various Ab Initio performance techniques such as using lookups instead of Joins etc.
• Implemented Lookup’s, lookup local, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Extensively worked on TS2 Cardholder system to manage card portfolios and serve customers.
• Worked on different subsystems used to perform different Task as responding to customer inquiries, collecting on delinquent accounts, Credit cards payments, checks, managing risk, and detecting fraud.
• Testing Delta file for the DW processing, Flow file and cross reference file (JCL/PROC).

Environment: CAPSTONE,EINSTEIN,TES,TDG,CONFIGWORKSTATION,Abinitio,SAS,QC/TestDirector8.0,COBOL,JCL,TSO/ISPF, AIX,UNIX,TANDEM, CICS,DB2,Oracle 8i/9i, PB 6.0,TOAD,NCR Teradata (one view),Clear Quest, and IBM Amdahl.