SUMMARY:

• Around 18 years of IT experience in the field of Quality Assurance, testing, Design & Development of various software application, software test and development life cycle including requirement analysis, program design, database design, debugging, Unit testing, implementation, maintenance, customization and support of Business Applications.
• Presently working as subject matter expert on multiple applications QA Delivery process on ETL Data warehousing, Web Applications, estimating work products, Resource management, budgeting, forecasting, performing hands - on testing, troubleshooting, debugging application code, overseeing test team’s deliverables, providing functional and technical guidance to test team, ensuring SLAs are met, performed exceptionally well and received many client appreciations.
• Software QA experience includes testing applications working on MS SSIS ETL, SQL Server 2008, SQL, CORDA, Kendo UI, SSRS Reports, .NET,XML, Hadoop, AbInitio ETL, Oracle11g, IBM DB2 UDB, UNIX, Java, UNIX Shell scripts, Vi Editor, Selenium, Perl, JIRA, IBM Clear Quest, HP ALM/Quality Center etc.
• Software Development experience includes working on Oracle Client/Server Multi-tier Architecture environment in the area of Oracle Application 11i, Oracle 9i/8i/8.0, Oracle Web Application Server, Developer 9i/6i(Forms 9i, Reports 9i), SQL, PL/SQL, UNIX, Java, JSP, Java script, XML etc.
• Very good experience in Horizontal Data warehousing Applications, Web service testing using SOAP UI tool, XML, WSDL and development experience on web technology on TCP/IP and HTTP protocols on Oracle Web Application Server environment.
• Good experience on RDBMS having experience in Database design, creation and management of schemas, Analyzing and writing Stored procedures, functions, triggers, Complex SQLs, performance tuning, Normalization, De-normalization, Data modeling etc.
• Experience with Oracle Applications (ERP) performing Technical and Functional work, Design, Development and implementation skills spanning Full Life cycle implementations, application upgrades, Production support, modification on Data conversion and Interfaces (Inbound/Outbound) of Oracle Apps Data model and leveraging the data for effective reporting.
• Very good experience on Requirements gathering, Functional and technical GAP Analysis, architecting system interactions, designing custom solutions, preparing Functional Design specification, Detail Design specification, Technical specification Document, Software Configuration Management plan, coding, testing, implementation, scheduling and producing documentation and Interfacing with users.
• Strong experience working as QA Lead/Manager in Onsite-Offshore model work environment includes mentoring team, providing complete end to end functional knowledge, training on QA and testing tools, providing technical assistance and guidance to team, reviewing team work before final delivery in software/application release process, Verification in QA/Staging/Training/UAT environment before production deployment.
• Analyzing business requirements and converting requirements to create Test Design, Test script generation, writing and reviewing test cases, test plan, test strategy and test finding documents, providing Training to end users, Test management and Automation,
• Extensive job knowledge including quality & problem solving skills, Leadership quality to lead the team to participate effectively in teamwork. Well versed with SEI/CMMI, Six Sigma and ISO9000:2000 level work environment.
• Experience in Agile SDLC methodologies and project deliverables in Sprints.
• Extensive experience on Functional, Regression, Integration, System, User Acceptance (UAT), Sanity, Performance, Stress, Cross Browser, Security and Database Testing.

SKILL:

Databases: SQL Server 2008, IBM DB2 UDB, Oracle 11g/9i/8i/8, Oracle Web Server

Big Data: Apache Hadoop

Datawarehousing Tool: MS SSIS, Ab Initio ETL

Languages & Tools: SQL, SQL*PLUS, PL/SQL, Java, JavaScript, XML, HTML, .NET, SSRS, Kendo UI, CORDA, JReports, SQL*Net, SQL*Loader, Pro*C,Designer 2000, Oracle Discoverer, SQL*Net, Perl, PNC, Progeni, Muti-Edit

Testing Tools: HP ALM 11.0/ Quality Center, IBM Rational ClearQuest

Automation Tool: Selenium,QTP

Applications: Oracle Applications 11i AR (Accounts Receivables), GL(General Ledger), AP(Accounts Payable)

Front End Tools: Oracle Developer 9i/6i/6.0/2000 ( Forms 9i/6i/6.0/5.0, Reports 9i/6i/6.0/3.0)

Other software/Utilities: AQT,Sql Developer, MS-Visual Studio,TOAD,Erwin,JSP,JDBC, Servlets, IBM Websphere, NDM, FTP, MS-Frontpage, Ms-Office, Visio, SEEC

Project Management/Tracking Tool: MS-Project, Primavera Team Play

SCM Tool: Visual SourceSafe, Rational ClearCase,TFS

Change Management Tool: JIRA, ClearQuest, PVCS Tracker

Operating Systems: Sun Solaris Unix, HP-UX11.0, IBM AIX, Windows XP/2003/NT

Standards: ANSI X12 EDI 820 transactions, SEI CMMI Level 5, PCMM Level 5, PCI compliance, ISO

Methodology: Agile-Scrum, Waterfall, Spiral

Hardware: IBM Servers/IIS Server, IBM RS 6000, HP 3000

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA /Austin, TX

Sr. QA Lead / Manager

Environment: SQL Server 2008, MS SSIS ETL, .NET, XML, SQL, SSRS Reports, Kendo UI, CORDA, JIRA, Selenium,Cucumber, Maven, soapUI, HP ALM 11.0, ClearQuest, Windows7, Agile methodology

Responsibilities:

• Analyzing business requirements and converting requirements to create Test Artifacts, design and conduct test case reviews, tracking project deliverables and milestones, delivering test result and test finding as per Visa Test Management Methodology (TMM).
• Worked on SSIS ETL testing in Staging and QA environments, verification, analysis and validation of data in VCF, Post-VCF, Post-ETL and Aggregation process and Automation of UI features.
• Writing complex SQL scripts for verification and validation of data in ETL process.
• Testing of Kendo UI and CORDA dashboard chart, data mapping and validation.
• Testing of online modules like Alerts, Dashboard, Transaction Categorization, Reports, Admin, Rules, Predictors, Sampling, Sourcing on Desktop and Responsive UI validation on Device Anywhere Studio including Mobile testing.
• HSM testing on horizontal scalable data warehousing environment with ARX encryption/decryption
• White Label, BRP, 508 testing Web service testing using SoapUI.
• Writing and reviewing Test plan, test cases, test scripts and providing UAT support.
• Involved on Dry run certifying Golden build code base in Training environment.
• Mentoring entire test team during test life cycle on test execution,data analysis, business functionality in onsite-offshore delivery model.
• Working actively in application release process, coordinating with different project stakeholders including platform,product and L3 support team.

Confidential, Foster City, CA,

Sr. QA Lead / Manager

Environment: AbInitio, Oracle 11g, DB2 UDB, JIRA, Hadoop, Unix, XML, SQL, SQL Developer, ALM 11.0, Windows 7, Agile methodology

Responsibilities:

• Analyzing business requirements and converting requirements to create Test Artifacts (test plan, test strategy, test finding document) as per Visa Test Management Methodology (TMM).
• Working on AbInitio ETL, DB2, Oracle Databases to read the consumer profile, wallet transaction and RDS data and load to CAE Hadoop.
• Executing ETL process to load wallet transaction, merchant reference data, order intent data on a regular basis to CMLS and load Playspan wallet transaction and merchant reference data to Common Services.
• Writing complex SQL scripts for verification and validation of data in Oracle and DB2 database..
• Participating in daily Scrum process, coordinating with different project stakeholders, provide status on release readiness and identify test activity blockers on release,.

Confidential, Foster City, CA,

Sr. QA Lead / Manager

Environment: SQL Server 2008, MS SSIS ETL, .NET, XML, SQL, SSRS Reports, CORDA, Selenium, HP Quality Center, ClearQuest, Windows 2003, QTP

Responsibilities:

• Worked on SSIS ETL to load VCF4.0 files (Single and Multibyte) in Staging and QA environments after configuring ETL Metadata, verification, analysis and validation of data in VCF/Post-VCF Aggregate roll up.
• Writing complex SQL scripts for verification and validation of data in ETL and Post-ETL process.
• Testing of CORDA dashboard pop-chart, data mapping and validation.
• Testing of online modules like Compliance, Rules, Reports, Dashboards, Predictors, Admin, Sampling, Sourcing etc.
• HSM testing on horizontal scalable data warehousing environment with ARX encryption/decryption
• BRP testing in shared database along with white Label and 508 testing.
• IP Filter testing on multiple split databases configured with single Admin database and PCI compliance testing.
• Application Integration testing using QTP and Smart Framework.
• Predictor Data analysis and validation of disputed card transaction
• Standard and Custom Report and Rules validation on SSRS Reporting environment.
• Analyzing business requirements and converting requirements to create Test Artifacts (test plan, test strategy), design and conduct test case reviews, delivering test result and test finding as per Visa Test Management Methodology (TMM) and tracking project deliverables and milestones.
• Writing and reviewing test plan, test cases and test scripts and providing UAT support.
• Mentoring entire test team during test life cycle on test execution,data analysis, business functionality in onsite-offshore delivery model.
• Working actively in application release process, coordinating with different project stakeholders including platform,product and L3 support team.

Confidential, Foster City, CA,

Sr. QA Lead/ Manager

Environment: Ab Initio, IBM DB2 UDB, XML, SQL, JReports, Java, IBM Websphere, HP Quality Center, ClearQuest, AQT, UNIX Shell Scripts, soapUI, Java script, EDI 820 on Sun Solaris Unix/ IBM AIX

Responsibilities:

• Worked on multiple Data warehousing and web based applications in Commercial Data services team and Testing of Data services applications on Ab Initio Graphs, Data analysis in Inbound and Outbound process.
• Writing complex SQL scripts for verification and validation of Data in Unix Preprocess, Postprocess and matching in AbInitio GDE environment.
• ETL execution with VCF and different proprietary files and matching the data with DB fields against input file fields.
• VCF Multibyte Data processing and validation in DB2 UDB database and PCI Compliance testing.
• Testing web based application using web service testing tool SoapUI in Visa Payable Automation project.
• Creating test scripts to automate batch processing of data.
• Functional, Integration, Regression testing of different data files and preparing/reviewing test cases, test scripts and test plans.
• Execution of EDI 820 data file and validating and analyzing different supplier data in data base.
• Analyzing business requirements and converting requirements to create Test Artifacts (test plan, test strategy, test finding document) as per Visa Test Management Methodology (TMM).
• Working actively in application release process for the modules moving to production environment.
• Mentoring and guiding testing team in onsite-offshore delivery model.
• Effectively communicating with different groups and reporting status to client managers.

Confidential, Boston,

Technical Lead

Environment: Oracle 9i, DB2, XML, MAUI, MQ Series, SQL Scripts, Java, JSP, Java Script, IBM Websphere, ClearCase, ClearQuest, CICS, Cobol II, JCL, Easytrieve, Intertest

Responsibilities:

• Converting business spec into application software solutions.
• Resolving Production Abends in production batch jobs being in On-call Support.
• Analysis and Writing SQL scripts and testing the same.
• Analysis and Coding of programs, XML parsers, views and stored procedures.
• Crunching of views in Maui environment.
• Writing XML test scripts and test cases, Unit testing of different views in MQ Series/web environment and preparing test plans.
• Analysing SQLs, Tuning SQLs which process the requests and fixing the production bugs in custom reporting application.Providing mailbox support, resolving queries of clients and client support managers.
• Working closely with key business users to trouble shoot and resolve issues logged and communicate status frequently and clearly to business owners
• Working with QA team actively in the software/application release process along with Verification Test and UAT.
• Responsible for SCM process while the programs/modules move to production environment.

Confidential,

Project Lead

Environment: Oracle Applications 11i AR module, Oracle 9i, Developer 6i(Forms 6i, Reports 6i), PL/SQL, TOAD, SQL *PLUS, VSS, on HP-Unix/Windows NT/2000.

Responsibilities:

• Detail System Study, preparing User requirement document.
• Translating business needs into application software solutions.
• Working with Development Team and business users to ensure requirements will be incorporated into system design, technical documentation and testing.
• Providing support for the Lowes and fixing production bugs.
• Analyzing business needs from Functional documents to determine optimal means of meeting those needs.
• Assist in the implementation and ongoing maintenance of Oracle 11i Financials Application AR Modules.
• Analysing and Resolving Incident requests and business(user) requests.
• Designing and developing front-end Forms using Oracle Financials 11i system, Oracle Forms 6i, Writing PL/SQL procedures, triggers and functions in Oracle 9i database environment.
• Designing and developing custom financial reports using Oracle Financials 11i system, Oracle Reports 6i tools that can be used within Finance and other cross-functional groups to improve processes and overall efficiencies.
• SQL Tuning, Analysing SQLs, Capacity Planning.
• Writing test scripts, test cases, Unit Testing and Integration Testing of different modules and preparing test plans.
• Working closely with key business users to trouble shoot and resolve technical and functional issues logged and communicate status frequently and clearly to business owners and management.

Confidential, Troy, Michigan,

Project Lead

Environment: Oracle 9i, SQL, PL/SQL, MF Cobol, PROGENI, PNC/FORMS, Multi-Edit 8.0, Unix Shell Scripts, PVCS, PMS on HP-UX 11.0/Windows 2000

Responsibilities:

• Requirement analysis and Coding of Programs/Forms/Reports/Stored Procedures and documentation in the new development process.
• Preparing Test Cases, Unit and Integration testing of the modules developed and preparing test plans.
• Preparing Technical documents on PNC, Online Printing Laser Forms
• Mentoring team members, Guiding team of developers in Analysis, Coding & Testing phase.
• Preparing Software Metric Tracking Sheet.

Confidential,

Technical Lead

Environment: Oracle 9i, Developer 6i(Forms 6i, Reports 6i), PL/SQL,TOAD, SQL*PLUS, MS-Project, VSS, CICS, Cobol II, JCL, Easytrieve, HP-Unix/Windows NT/2000

Responsibilities:

• Resolving Production bugs and Providing production support and resolving user queries.
• Enhancement and Development of forms and reports
• Create Maintain and tracking of end user’s business issues.
• Analyzed various performance issues and tuning issues faced by the client in the system and reports, working with the DBAs using explain plan/generating TKPROFs.
• Design, develop, test, implement and Support the customizations basically reports, forms and PL/SQL procedures.
• Data mapping of Oracle system with IBM Mainframe.
• Discussed user needs with business units and develop the solution documents

Confidential

Project Lead

Environment: Oracle Applications 11i module, Oracle 9i, Developer 6i(Forms 6i, Reports 6i), PL/SQL,TOAD, SQL*PLUS, VSS, HP-Unix,DB2, CICS, VS Cobol II, Primavera Team Play

Responsibilities:

• Involved in Requirement analysis and system study.
• Analysis, Design, develop, test, implement and Support the customizations basically Reports, Forms and PL/SQL procedures.
• Involved in complex restructuring, Data Conversion from Legacy Systems to Oracle Database by using SQL*Loader & PL/SQL.
• Involved in GL Mapping and Conversion for Independent Legacy Systems
• Developed concurrent programs for inbound and outbound using PL/SQL.

Confidential, Virginia,

Technical Lead

Environment: Oracle 8i, Developer 6.0/2000 (Forms 6.0/Forms 4.5),SQL, PL/SQL, Unix Shell Scripts, Net Express, VSS on HP-UX 11.0/Windows NT

Responsibilities:

• Analysis, Design, Development, Conversion and Testing of Programs/Forms/Reports using Forms 6.0 and Reports 6.0.
• Analysing and testing Oracle scripts.
• Interacting with Client for receiving Source Code, Delivery of the developed code and the requirements related to the system functionality.
• Converting business specification to technical specification, prepared FDS and DDS.
• Made a library of common objects, which could be referenced by various programs of the module.

Confidential, Atlanta,

Team Lead

Environment: Oracle 8, Developer 5.0(Forms 5.0, Reports 3.0), SQL, PL/SQL, Quest TOAD, Oracle Web Server, HTML, VSS on Windows NT.

Responsibilities:

• Participated in Design Change of the database, front-end forms & Reports.
• Responsible for coding Maintain Customer, Define Business Rules and Sales Program Modules. This includes coding for components such as Data providers and business logic for reusable components.
• Designed the modules like Maintain Customer, Sales Program etc.
• Developed Reports, Approvals, Data Manipulations etc which are all handled on Web keeping the database at a central place.
• Unit testing/ Integration Testing of the modules developed.

Confidential,

Team Lead

Environment: Oracle 8i, Developer 6.0 (Forms 6.0, Reports 6.0), SQL, PL/SQL, Oracle Web Server, HTML, VSS on UNIX/ Windows NT.

Responsibilities:

• Detail System Study, preparing User requirement document, FDS and DDS.
• Participated in the design of database, front-end forms & Reports.
• Coding of Master forms like Item Master, Stock Card Master, Supplier Master User Master, Buyer Master etc & transaction forms like daily Indent, PO generation, Store Requisition, Change Order, Outward Gate Pass etc.
• Designed & Developed Reports like PO Generation, List of Indents, Monthly indents, Outward Gate Pass, Quotation Details, Inspection reports, Voucher, Change Order etc.
• Prepared quality related documents like SPMP, SQAP, SCMP and collected different Metrices etc.
• Made a library of common objects, which could be referenced by various programs of the module.

Confidential,

Team Lead

Environment: Oracle 8.0, Oracle Web Application Server 3.0, HTML, Java Script, JDK 1.2.2, Servlets, JDBC, MS-Front Page 98, Developer 2000, IE4.0, Netscape Navigator on Windows NT 4.0

Responsibilities:

• Analysis, Design and implementation of oracle database.
• Designed & developed front-end screens, templates using HTML and MS-FRONT PAGE according to client requirement and Bug Fixing of the same.
• Coding of different procedures for the same for connectivity to database, front end and performance monitoring.
• Coding core DSCAT info, Supplier info, Variety reduction, price negotiation classes, includes coding for components such as data provider, controls & business logic for reusable components.
• Responsible for implementing business rules in server side controls to handle database queries.

Confidential, Ohio,

Team Lead

Environment: IBM 3090, VS COBOLII, DB2, CICS, JCL, Xpediter, File-Aid, Infoman, Intertest, TSO/ISPF, Transcentury Tool.

Responsibilities:

• Analysis, Coding and Testing of batch and online programs.
• Interacting with Client for Spec. Analysis, Delivery of the developed code and the issues related to the system functionality.
• Made a detailed analysis of the system and prepared user Requirement document on the basis of which whole system was designed.

Confidential,

Team Lead

Environment: IBM3090, COBOL II, DB2, CICS, JCL, Xpediter, File-Aid, TSO/ISPF

Responsibilities:

• Analysis, Coding, Review, Testing and Documentation and providing status report, assignment report to Project Manager.

Confidential,

Project Lead

Environment: HP-3000, HP-COBOL, HP JCL, CHC Signature 2000.

Responsibilities:

• Analysis, Coding, Review, Testing of the Programs in the new enhancement process using client supplied business rules.

Confidential

Team Lead

Environment: IBM 3090, VS COBOLII, DB2, JCL, Xpediter, File-Aid, Mantis, TSO/ISPF, CHC Signature 2000.

Responsibilities:

• Impact Analysis, Coding, Review and Testing of the programs and providing status reports to Project Manager.

Confidential,

Developer

Environment: VS Cobol II, DB2, CICS, JCL on IBM 3090.

Responsibilities:

• Impact Analysis, study of Inventory components, Coding, Review and documentation.

Confidential

Developer

Environment: Oracle 7.3, Developer 2000 (Forms 4.5, Reports 2.5) on Windows NT

Responsibilities:

• Coding & Testing of Forms & Reports in Issue, GRN, Physical stock transaction module for development of forms & Reports. Participated in preparing design & user Manual.

Confidential

Developer

Environment: MF Cobol85, FoxPro 2.6, Novell Netware

Responsibilities:

• Analysis, coding, debugging, testing and documentation.

Confidential

Developer

Environment: dBase III, Novell Netware, Windows 3.1

Responsibilities:

• System maintenance and database maintenance.