Industries:

Finance, Banking, Retail, Mortgage, Insurance, Healthcare, Public Sector, Telecom

Functional Areas:

SOA, SAP, Oracle EBS, ERP, CRM, ETL, BI / DW, O2C, Order Management, WMS

Methodologies / Techniques:

Waterfall, V Model, Scrum, Agile, DMAIC, Six Sigma, Test Automation, Manual Testing, Use Cases

Testing Tools:

HP ALM, JIRA, Quick Test Pro, HP Sprinter, SOAPUI Pro, Clear Quest, Test Director, Win Runner, Rational Robot, Functional Tester, Manual Tester, Requisite Pro, C Factory

Application Development Tools:

SAP BI BEx , SAP BPC, Oracle EBS, System Z, SunGard OMNI Plus, Power Image, Plan Office, EPM, MDM, ECC, Dev 2K

Application Package:

SOA, SAP, Oracle E-Business Suite, People Soft, .NET, JAVA/J2EE

Databases / DB Tools:

Oracle, Golden Gate, Oracle SQL Developer, MS SQL Server, DB2, MS Access, TOAD, MS SQL Server Management Studio, ExperThink UDC Tool

Operating Systems:

LPS, MSP, MS Windows, Mainframe, CICS, TSO, UNIX, AS-400, MS DOS

Programming Languages:

PL-SQL, TSL, HTML, Java, C , Dev 2K

Desktop Tools:

MS Project, MS Visio, SharePoint, Confluence, MS Office

CONFIDENTIAL

SR QA ANALYST BI/DW, WEB SERVICES, ORACLE EBS

• PDW PRICING DATA WAREHOUSE : Replacement solution allowing ATD to exit the relationship with outside vendor, Vendavo, while providing Pricing Dept. users enhanced analytic capabilities in-house for Competitor, Sales History and Pricing data.

• Wrote Scenarios and Test cases to validate ETL and Data Cubes for Sales Transaction History and Competitive Pricing Data.
• Validated ETL Extract and Load Table Structure, number of fields and field validations using Data Dictionary/ Source to Target Mapping document. MS SQL Server Management Studio and Oracle SQL Developer tools were used.
• Performed Row Counts using SQL queries to compare counts between Source Oracle to Target ETL/Staging and then AmericanTireDW and reported issues to the BI team.
• Validated Data Cubes using MS Excel Pivot to test Sales, Marketing and Pricing DW DataMart.
• Developed Adhoc reports using various Dimensions, Facts and Measures and logged defects in QC for the failed.
• Validated Sales History and Competitive Pricing data that will be exposed to users in SSAS cubes the roll-ups, aggregations and drill-downs/through the users have to perform ad-hoc analysis.
• Environment: MS SQL Server, Oracle, MS BI Stack TSQL, SSIS for ETL, SSAS for Cubes , SQL Server Management Studio, SharePoint, CSV, Tableau, BI, HP ALM, JIRA, Oracle SQL Developer, RedGate
• FS 2.0 Freight Services : Freight Services 2.0 should encompass a comprehensive upgrade of ATD's current Freight Services system using SOA as Middleware, Oracle E-Business Suite as ERP and Oracle as Back End.

• Validated Freight Services Coherence Cache between SOA and Oracle EBS and verified data consistency. File Loader/Updater
• Manipulated XML files to Test SOA Web Services Packaging, Modifier, Rater, and Internal Freight in SOA using SOAPUI Pro Tool. XML Request and Response validations / Parameter and Value Derivation .
• Performed End to End and Regression Testing utilizing System Z, ATD Online, Oracle EBS. Wrote SQL Queries using Oracle SQL Developer to validate data in Oracle.

Environment:

M SOA, Web Services, SOAPUI Pro, XML, Oracle, Oracle E-Business Suite, WMS-Warehouse Management Systems, HP ALM, HP Sprinter, JIRA, System Z, ATD Online, Telnet, Hybris, Mainframe, O2C, Order Management, CMR / FRX, EAS, Confluence

CONFIDENTIAL

LEAD QA ANALYST SAP BPC, BI/DW, DATA VALIDATIONS

• Global Finance Operations / FSR Consolidations: FSR is a multi-year initiative to replace aging and loosely integrated financial management systems with a single source of high-quality and accurate data called eLedger, an SAP product. The eLedger platform has many automated processes, from inbound processing of transactions from hundreds of applications to internal processing of payment and depreciation to data delivery to hundreds more downstream applications. This initiative will fulfill business requirements in addition to performing system design, in preparation for a global roll out. SAP BusinessObjects Planning and Consolidation BPC 10.0 is a NW based application that was selected by BoA for financial consolidations reporting. The approach taken during the Analyze and Design Phase was to split the efforts into two categories based on the FITS/GAPS Analysis. FITS includes All Configurable Items and GAPS include all items require Custom Development that includes Validations, Data Movements, Calculations and other Misc.

• Reviewed BRD / FDD and various processes to understand application scope, requirements and functionalities.
• Requested a data loads in a flat file and validated extracted actual data against expected.
• Validated various reporting functionalities Eliminations, Intercompany matching, Master Data Load, and Pencil Adjustments, Transaction Data Load for the data loaded into SAP/BI or EPM. and various custom developments.
• Worked with Financial Analysts to develop, maintain and execute the test scripts and various data sheets.
• Worked with the Deloitte development and Configuration Team to co-ordinate and resolve testing issues / defects.
• Performed FUT and SIT Testing, End to End Testing and Regression Testing in the Test environment.

Environment:

M SAP BPC NW 10.0, EPM, Data Manager, MDM, ECC, ETL, BI / DW, HP ALM, QTP, Manual and Automated Testing, SharePoint, MS Office, Data Validations, V Lookup / Key, DMAIC, Six Sigma

CONFIDENTIAL

SR. QA ANALYST LOAN PROCESSING SYSTEM, WEB TESTING

• ER Early Resolution Home Preservation and Collection : This initiative is a WF Home Mortgage Default Servicing world developed by Computer Science Corporation with a goal to work with customers to help them retain or liquidate the home to avoid foreclosure. It offers several different workout options to help customers and also various functionalities for collection process.

• Reviewed BRD / FDD and SURF to understand application scope, requirements and functionalities.
• Created positive and negative test scripts to cover all the requirements that are deemed testable using QC.
• Executed Test Scripts and various SURF tickets to validate testable functionalities and reported defects for the failed conditions using Mercury QC and provided daily / weekly status reports to the higher management on a timely basis.
• Worked with Automation Team to develop, maintain and execute the automated test scripts and regression test suites using QTP. Worked with the CSC development and Configuration Team to co-ordinate and resolve testing issues / defects.
• Performed SIT, End to End Testing and Regression Testing in the QA environment.

Environment:

M MSP Mortgage Servicing Platform , LPS Loan Processing System , CICS, Mainframe, SharePoint, Web Testing, .NET, Manual and Automated Testing, HP QC, QTP, Scrum

CONFIDENTIAL

TEST LEAD WEB TESTING

• MVAS Multi Vendor Admin Solution : The current Plan Administrator Online Enrollment application provides our clients with general core capabilities to complete their day to day enrollment activity but has several limitations. These projects will address the requirements for the user experience of a Plan Administrator with Online Enrollment and Online Salary Deferral Agreements, MVAS, Build confidence and brand reputation with Plan Administrators and further strengthen standing as a trusted retirement plan administration partner with clients.

• Successfully managed Test Team for various Projects / Releases within Individual and Institutional Client Services INI line of business / OPS Technology.
• Responsible for Test estimates, Resource planning, Assignments to better communicate and align expectations on the quality and duration required to complete a level of testing that delivers a correct and acceptable solution to the business.
• Provided technical expertise and direction on setting up the Testing approach, Test tool setup, Test cycles and Defect management process.
• Co-ordination / Task allocation with the team on a daily basis, functional requirement clarification and addressed queries / issues occurred.
• Developed Test plan that identifies test scope, Roles and responsibilities, types of test planned, test milestones and acceptance criteria.
• Assessed/Analyzed the test scenarios/test scripts written by QA Analyst in QC and provided feedback for updates.
• Created test metrics/reports to ensure test coverage, test effectiveness and testing productivity and provided daily / weekly status reports to the higher management on a timely basis.

Environment:

M Admin Web Center, Power Image, Envisage Web Services, MVAS, OMNI, Feedback / Seed / CR Files, OPE, HP QC, Manual and Automated Testing, QTP, Waterfall

CONFIDENTIAL

SR. QA ANALYST WEB TESTING, HOGAN/CIS DATA VALIDATION

Brokerage Account Management: The Account Management Applications supports AM-Account Maintenance, NAO-New Account Opening, AMA AR-AMA Recharacterization, FBAR-Fee Based Recharacterization and DM-Document Management. These projects are a set of requirements that will satisfy various business needs.

• BR to Hogan CIS Interface: The purpose of this project is to transmit Brokerage Customer, Account, and Relationship data to Hogan Customer Information System CIS on a daily basis. Key activities includes Development of batch processes to add/update Hogan CIS and Distinguish between existing batch jobs and this new batch to Hogan CIS such that red / Wells accounts go to Hogan CIS and unconverted / blue accounts continue to go to CZ/CIS.

• Reviewed FDD, Test Plan and Test Scenarios to understand application scope, requirements and functionalities.
• Performed SIT, End to End Testing and Regression Testing in the ITE environments. Structured UAT was conducted at the end of the SIT.
• Validated the core functionalities in Phase 1- Account Maintenance to WBS Access, validation, page displays, and data transformations , Automatic and Manual Bank link Capabilities for WBS Standard Brokerage Accounts, ACH, Workflow Routing and NAO changes.
• Validated the Phase 2 functionalities- Account Maintenance for WBS Back Office users WBS Contact Center , Implementation of Account Maintenance-related Broker and Einstein system functionality which include real-time updates to Bank Systems.

Environment:

M HP QC, Hogan, Mainframe, Smart Station, Wisdom, CICS, BETA, Document Management Services DMS , Manual and Automated Testing, Waterfall

CONFIDENTIAL

UAT ANALYST WEB TESTING

• LOWES.COM Next Generation eCommerce Platform : Replace Lowes.com with an industry leading eCommerce platform that will provide powerful business-managed merchandising and marketing capabilities, decrease time to market for future releases and enable a competitive online experience.

• Reviewed BRD / FDD to understand application scope, requirements and functionalities for various Stages of the new website platform Lowes.com
• Wrote and Executed Test cases for Functional, UI and Error messages for each stage and Reported defects for the failed conditions using Mercury Test Director. Created Test data and Test User Accounts for the Test case execution during Beta.
• Performed UAT, Adhoc, Smoke, Usability Testing and Regression Testing in the Staging and Beta Deploy test environments using various Internet Browsers i.e. IE, Firefox and Safari on both MS Windows and Mac Operating systems.
• Validated the core functionalities in Stage 1 Browse , Stage 2 Order , State 3 Promote , and Stage 4 Support .
• Validated Beta Build Certification scripts and performed Post UAT Regression Testing and provided Beta support.

Environment:

MS Java, HTML, IBM WebSphere, MS SharePoint, Mercury Test Director, QTP, IE, Firefox and Safari, MS XP, Mac, Scrum and Waterfall

CONFIDENTIAL

QA TEST LEAD WEB APP, OMNI, CONVERSION TRANSACTION TESTING

• TOPS Next Generation Retirement Platform : TIAA-CREF is in the process of converting its Legacy records to a new, more robust, product offering and record keeping system named TIAA-CREF Open Plan Solutions. A key component of this process is the migration of the existing data from Legacy to OmniPlus. Business benefits will be Improved operational efficiency, system automation, and consolidation and Increased level of service standards to TIAA-CREF customers.
• PLAN OFFICE, CTT, QC IMPLEMETATION: Web application, Conversion Transaction Testing and QC Implementation Pilot Projects.

• Validated the individuals and institutions trade financial securities Capital Market using Plan Office and OMNI.
• Wrote Test Procedure documents for Plan Office EFT / Remit Funding processes. Developed Test plan for each testing efforts to identify test scope, Roles and Responsibilities, types of test planned, test milestones and acceptance criteria.
• Created Test Metrics to ensure test coverage, test effectiveness and testing productivity. Reviewed/Approved and linked the test cases to the requirements for the traceability and test coverage. Imported Test cases written in MS Excel into HP QC.
• Analyzed and Setup EFT/Remit Funding banking transactions Plan setup in OMNI for the Plan Office Projects and requested batch services to execute transactions to be posted in OMNI via batch processing.
• Data mining and extractions of the OMNI transactions and submitted them to the Automation Team for the further processing using QTP scripts. Setup test data in Siebel to assist Business users during testing.
• Performed Transaction Testing against converted data for CTT Projects and Web testing for the Plan Office.

Environment:

SunGard OMNI Plus, Plan Office, Power Image, TRPS, AWC, Admin Portal, Siebel, Mainframe CICS/TSO , HP QC, QTP, Manual and Automated Testing, Waterfall

CONFIDENTIAL

CONFIDENTIAL

BUSINESS ANALYST

• ITS Host Entry: Project allowed BCBS to collect the submitted subscriber and patient information for each Host Claim. Collection of information is required for each claim in accordance to BCBSA guidelines and must be passed onto the Home plan via the ITS SF Submission Format transaction. Establish a consistent identifier for the life cycle of the claims. After implementation, User should be able to access the ITS Host membership info using a web browser as front end connected to I series server as back end and CGI as interface between the two. User should be able to search for ITS Host member info by entering the Sub Id, Advance search for a Host member based on a partial Sub Id or First name or last name of Subscriber, Add a new subscriber, Add a new patient to existing subscriber, Add Existing Subscriber/Patient to Claim.

• Gathered and participated in Business Requirement Document BRD and Functional Design Document FDD review process. Reviewed ITS Host documents SOW and DSD to validate the scope and the system.
• Developed Integration and Acceptance Test plans and Test strategy for several functional areas. Also created a test process flow diagram for the client presentation.
• Designed and executed Test Scenarios and Use Cases for the ITS various functionalities.
• Involved in the Unit/Integration Testing to assist developers in writing and executing test cases to verify software components works independently in Unit region and jointly in the Integration region before code moves to the Acceptance region for system testing.

Environment:

AS 400, Mainframe, COBOL, DB2, Manual and Automated Testing, MS Project, MS Visio, V Model

CONFIDENTIAL

CONFIDENTIAL

QA TEST LEAD - DATA WAREHOUSE/DATA MIGRATION EFFORT

• BEACON HR Payroll: Building Enterprise Access for NC's Core Operation Needs project is NC's program to streamline and standardize key business processes in HR, Payroll, Data Warehousing, Financials, Tax and Revenue. With the implementation of SAP ERP software solution, the goal is to transform the business, build a foundation for management flexibility, increased efficiency, and improved access to information, ultimately enhancing the quality of services to the public.

• Responsible for Test estimates, Resource planning, Assignments to better communicate and align expectations on the quality and duration required to complete a level of testing that delivers a correct and acceptable solution to the business.
• Extensively involved in leading and monitoring ETL / Data migration Test efforts Transformation from legacy applications to Oracle Relational repositories and then SAP BI environment.
• Developed Data Migration Test Plan that identifies test scope, Roles and responsibilities, types of test planned, test milestones and acceptance criteria for each of the data migration stages.
• Test cases were created, executed and tracked using QC. Test cases were also aligned to the requirements for the traceability and to verify the test coverage.
• Involved in backend testing and assisted team in writing complex SQL queries to extract the data from Oracle. Reported defects for failed conditions and retested resolved defects.
• Performed data validation for each Data Migration stage From Legacy to Windows 2003 server, From Win 2003 server to Non-cleansed and cleansed repositories, from cleansed to Transformed and From Transformed to SAP BI environment.
• Validated the state wide combined reporting functionalities for the data loaded into SAP/BI from SAP/R3 and Oracle relational repositories.
• Analyzed and tested mapping rules/reconciliation rules on the historical and online data loaded from legacy system to Oracle to ensure that all requirements met as expected for new SAP HR Payroll system.

Environment:

HP QC, SAP ERP, SAP BI, BEx, ETL, Oracle, ExperThink UDC Tool, MS Visio, Mainframe, Manual and Automated Testing, Waterfall

CONFIDENTIAL

QA / BA ANALYST

• e-MPIRE: eManaged Processes for Integrated Revenue Enterprise is intended to replace all major tax processing systems currently in use by the NYS Tax Department with a new, custom designed, integrated tax system. This system will be broad in its scope of processing with three major releases- Corp Tax, Personal Income Tax and Sales Tax. System is now capable of processing millions of tax returns, issuing refunds and payment processing of NYS Taxpayers. It includes the functions of Taxpayer Identification, Returns Processing, Taxpayer Accounting, Revenue Accounting, and Case Management.
• Gathered and participated in BRD and FDD review process. Participated in various meetings to understand operational and functional needs.

• Responsible for Coordinating Test team work product, Executing Testing Activities and assisting Sr. BA's/PM.
• Attended meeting with users and developers to gather information and to know the client processes. Wrote Use Cases on various processes from System level to User level such as ELF Electronic filing and Paper Tax return filings.
• Provided business clarification to technical staff and assisted Sr. BA in translating business requirements into statements of work, reviewing client processes, standards/guidelines and addressed business issues and recommended changes/additions.
• Assisted Developers in Writing Specs and Training team for functional details. Assisted design team with GUI modifications and wrote functional specs. Performed SIT, Regression testing and reported defects.
• Coordinated Testing efforts with selected End-users for UAT to execute real time Business scenarios to ensure e-MPIRE meets the NYS DTF business needs and functions correctly.

Environment:

Rational Manual Tester, Rational Robot, Functional Tester, Clear Quest, Requisite Pro, Rational Test Manager, MS Visio, IBM Mainframe, OOT Automation tool, Java, COBOL, DB2, WebSphere, Manual and Automated Testing, Cognos

CONFIDENTIAL

CONFIDENTIAL

TEST ENGINEER

• LD4T Long Distance 4 Telegance : The purpose of this project was to develop a bi-directional interface between SBC's Telecom billing Solution TBS and the Telegence LD Billing System TeLD using Middleware Services MWS to eliminate the current redundant data entry process, improve the accuracy of common data, and keep both TBS and TeLD data systematically updated.

• Worked with development team members and business analyst to understand system functionalities. Responsible for coordinating test team work product, executing testing activities and assisting Sr. BA's/PM.
• Recorded and played back the test scripts for the GUI, Functional and Regression testing using WinRunner and assisted in configuration of GUI maps for the standard and custom objects. Assisted developer in automating manual test script for the regression testing reusable functions and scripts.
• Worked with Automation Team to develop, maintain and execute the automated test scripts and regression test suites using HP Win Runner and Test Director.

Environment:

.NET, HP Test Director, Win Runner, TSL, MS SQL Server, Manual and Automated Testing, Middleware, MS Office, V Model