SUMMARY

• 13 years of expertise in Senior Quality Assurance testing & Support in (Manual and Automation)
• Confidential in Point of Sale (POS) testing, reporting and application support
• Eight plus years ofETL testing using ODI, Informatica, Talend studio, SSIS and iWAY
• Fourplus years of hands - on automation testing with HP UFT, Selenium
• Three plus years of Oracle Financials(EBS) testing
• Six years of Web Services(SOA)/API testing using Postman, SOA Console, JMeter and SOAP UI
• Five plus years of testing expertise in AS/400 applications
• Excellent database skills in Oracle 12i, SQL, DB2/400, DB Visualizer, TOAD, Teradata
• Sound knowledge on SCD (Slowly Changing Dimension) types in Informatica and ODI
• Tested Active & Passive transformations, and Connected & Un-Connected transformations
• Perform Data Profiling, Assessment, and Data Cleansing to meet data migration goals
• Validate source/staging/target tables, data reconciliations and various ETL transformations
• Oracle Financials- Reports, Interfaces, Conversion, Customizations and Workflow (RICEW)
• P2P (Procure to Pay), O2C(Order to Cash) flow in Oracle Financials
• Oracle Inventory Management/Order Management(OM), Account Payables(AP), Account Receivables(AR), Fixed Assets(FA), General Ledger(GL)
• JDA trained and Solid understanding of JDA Point of Sale modules: Fulfillment, Master Planning
• Experiencein Defect management and Continuous Integration(CI) tools -
• JIRA, HP ALM, TFS, TestRail, Rally Tool, TTP, Footprints, Confluence, TeamCity
• Agile/Scrum/Kanban experience in Development, Testing and Implementation
• Worked in Keyword-driven, Data-driven and Hybrid test automation frameworks
• Familiar with Test driven and Behavior driven agile development
• Experience in Health care EDIs, Claim Engines, Claims Adjudication, EoBs, RAs, and Reports
• Exposure on Corporate Actions, Stock-Split, Stocks/Fund Merger, Stock Acquisitions,
• Allocations, Rebalances and Restrictions
• Prepared test plans, test strategy, Requirements Traceability, Trend reports
• Performed report analysis with Drill down and Drill Through approaches
• Performed Smoke/Regression Testing, UAT Testing, Performance/Load testing, Penetration testing
• Experience as level-I/level-II production support analyst
• Worked in onsite-offshore model

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 9.0/10.0, QTP 9.0/10.0, HP ALM, HP UFT 12.02, RIDE, Selenium 3.x, JIRATestRail, Rally Test Case Management

Databases: Oracle 8i/9i/10g/11g, DB2/400, DB2 7.0, SQL Server 2005/2008, MS Access, Teradata

Utility Tools: Oracle SQL Developer, SQL Plus, DB Visualizer 6.x, TOAD, SQL Assistant, Oracle EBS (Oracle

Financials), API Wizard, Point of Sale (POS), ROBOT/400, Scheduler/400, SQL/400, TurnoverHawkeye, DBU 60/70, Citrix, SQL Server Management Studio 2008, Visio, Visual Studio, TFSSVN, GITHub, Teamcity, FileZilla, WINScp, PUTTY, WS-FTP, Alliance FTP Manager, Tealium:

ETL Tools: Informatica 8.1, Talend Studio, ODI

Reporting Tools: SSRS

Web services: SoapUI, Apache JMeter, SOA Console, Postman

Opr Systems: Windows XP/2000/2007, UNIX, AS/400, OS/400

Programming: Python 2.7/3.0, VB Script, PL/SQL, RPGLE, RPG ILE, CL/400

PROFESSIONAL EXPERIENCE

Confidential, Union, NJ

Sr QualityAssurance Analyst

Responsibilities:

• Follow Agile environment and involve in multiple projects
• Identify test coverage for smoke, regression and functional use cases
• Worked on Oracle Store Procedures to test Beyond Plus membership changes
• Used Oracle SQL developer to test Beyond Plus Renewals 3-to-1 step process changes
• Worked with Offer Management System (OMS), created and validated-Offers, Coupons, Wallets
• Used Teradata for Enterprise Data Warehouse (EDW) validations
• Involved in automation of Beyond Plus web UI using Selenium with Java
• Extensively used Tealium tools and validated User/Custom events

Environment:Oracle SQL Developer, Teradata client, TIBCO, SVN, UNIX, SQL Plus, Postman, ETL tools, HTML, XML, JSON, Java/J2EE, Selenium 3.x tools, Oracle BPM tools, Tealium tools

Confidential, New York City

Quality Assurance Analyst

Responsibilities:

• Follow SDLC in Agile environment
• Identify smoke, regression and functional scenarios for test coverage
• Validate ETL processes executed by iWay system and monitor logs, errors, email notifications
• Handle iWay configurations, adapters, channels and registries for testing purpose
• Use WinSCP (FTP client), trigger ETL processes and perform end-to-end validations
• Validate NEIM transformed XMLs, Schemas, XPATHs and JSONs for all data transformations
• Testing knowledge on ESB (Enterprise Service Bus)architecture and messaging
• Use Postman for API calls to validate data
• Validate ETL processes, MQ messages and Data share routing for NYC government exchanges
• Download MQ messages using RFHUTIL and validate against sources
• Develop queries to test data in Elastic Search client (target system)
• Develop and maintain VB Scripts, VB Macros and Python scripts for data validations

Environment: Microsoft SQL Developer, HP ALM/Quality Center, Azure, SVN, Postman, iWay, WINScp, MQ Explorer, ETL, RFHUTIL, HTML, XML, JSON, VB Script, VB Macro, STORM, Elastic Search, OpenData API

Confidential, NJ

Quality Assurance Analyst

Responsibilities:

• Agile Development, Testing, Defect reporting and Release management using JIRA
• Identified smoke, regression and functional scenarios for manual & test automation
• Tested P2P (Procure to Pay) and O2C (Order to Cash) flows
• Account Payables, Account Receivables, Fixed Assets, General Ledger and Cash Management
• Automated Oracle Forms using HP UFT 12.02
• Test Asset Groups, Asset Numbers during Oracle eAM, FA, Inventory and Install Base Sync
• Test Reports, Interfaces, Conversion, Customization and Workflow (RICEW) in EBS
• Data Profiling, Data Cleansing and ETL testing for all Conversions involved in implementation
• Validate & deploy SQL packages using SVN
• Schedule and monitor delta jobs using ODI
• Run concurrent jobs and validate reports
• Involved in EBS-MDM(EBX) Integration testing
• Uploaded invoice batches, asset groups/asset numbers, Pos using API Wizard
• Test Quality/Collection plans, EDI Mappings, Licensing & Titling, Tariff Plan, Remac & Refurb history
• Test Suppliers, Contacts, Quality, Assets, Locations& Invoice Workbench
• Validate Inventory and Sub-Inventory transfers
• Test User Profiles, User Roles & Responsibilities
• Test AR Lockbox (Auto Receipts), Accounting entries and DFFs (Descriptive Flex Fields)
• Assist users for UAT/Pre-Go-Live/Post-Go-Live support
• Used Postman/JMeter to perform Web service and Mobile API testing for ROADSTAR mobile app
• Extensively usedweb services - GET, PUT, POST, DELETE methods, Tokens, Authentications, end point URLs

Environment:Oracle EBS (Oracle Financials), Oracle eAM, Oracle SQL Developer, SQL Plus, PL/SQL, Oracle Data Integrator (ODI), API Wizard, Oracle SQL Navigator, HP UFT 12.02, HP ALM, JIRA, UNIX, SVN, FileZilla, Postman, JMeter, Soap UI

Confidential,NJ

QA Analyst& Support

Responsibilities:

• Design, develop, testand implement AS400 enhancements
• Identify smoke and functional scenarios,and automate using RIDE/Python 2.7/Selenium
• Developed and executed test cases for various ETL transformations
• Worked in Agile methodology for all Sprint deliverables
• Programmatic execution of - Corporate Actions, Stock-Split, Stocks/Fund Merger, Stock
• Acquisitions, Allocations, Rebalances and Restrictions
• Analyze teh issues and identify bottle necks
• Used Alliance FTP Manager/WINSCP for data exchange between Host and home systems
• Used TFS for Agile development and defect reporting
• Support for Month end, Quarter end and year end Jobs and billing jobs
• Prepare Traceability Matrices, Metrics and send Trend reports to management
• Worked as level 1/ level 2 production support

Environment:AS400, RPGLE, CL400, DB2/400, Talend Studio, PUTTY, WS-FTP, Alliance FTP Manager, DB Visualizer 6.x, Foot Prints, FileZilla, Python, QTP, Team City, Robot framework/RIDE, Selenium, Visual Studio, TFS, SQL Server Management Studio 2008, SQL Server 2008, C#, Confluence, JMeter, GITHub

Confidential ., MN

ETL Test Lead

Responsibilities:

• Understood and interpreted POS requirements created by external vendors and transformed them tointo Use cases and Test cases
• Responsible for reviewing Functional specs, Technical specs, test artifacts
• Prepared test cases using ETL data dictionary/mapping documents
• Reviewed and validated Mappings, Mapplets, Workflows, Tasks, Sessions with developers
• Validated meta data, constraints, data integrity, duplicates and reconciliation counts
• Tested various Active& Passivetransformations, and Connected & Un-Connected transformations
• Strong testing knowledgeon SCD (Slowly Changing Dimension) types, Surrogate keys
• Ability to develop & execute complex SQL queries during testing
• Validate between source to target tables in staging areas, Data Marts, Data Mining, ODS, EDW
• Execute& monitor scheduled ETL jobs using Informatica 8.6
• Participate in Data Profiling, Data Cleansing, Extraction, Transformation and Loading for data migration
• Validated Master and Transactional datafor Initial load, Incremental load & Delta loads in ETL processes
• Involved in Fact and Dimensional analysis with Data Architectural team for design of DataMart/EDW
• Exposure in SQL performance tuning and familiar to Cache mechanism
• Exported test cases from MS Excel to HP Quality Center
• Report analysis using Drill down, Drill Through & Data Centric approaches
• Executed test cases, created & tracked defects in HP ALM/QC
• Point of Sale (POS) and Mobile POS API Web-services testing with SOA Console, SOAP UI
• JDA trained and Solid understanding of JDA Point of Sale modules: Fulfillment, Master Planning
• Developed and executed test cases for service layers, APIs for both Web and Mobile applications
• Validate POS Transactions, Order Fulfillment, Inventory Reports, Sale-Trend reports
• Supported test activities associated with Product Point of Sales
• Identify, design & execute Smoke/Regression Test suite, support User Acceptance Testing(UAT)
• Lead multiple applications, worked in onsite and offshore model
• Immense involvement in Agile development and sprint ceremonies
• Prepare traceability matrix, log defects, support releases and Go-Live activities

Environment:Informatica 8.6, TOAD, DB2, HP Quality Center 10.0,HP QTP, Business Objects, SQL Server 2008,Java/J2EE, Agile Methodology, UNIX, UDB, Point of Sale (POS), Customer MDM, Soap UI, SOA Console

Confidential, VT

Sr. Software Engineer/Sr. Quality AssuranceAnalyst

Responsibilities:

• Effort Estimation and Planning for work requests
• Design automation framework using QTP, execute and test Claims module
• Coding enhancements in RPG, RPGLE, ILE RPG, CLP and perform Unit testing
• Responsible for enhancement and Development, Primary POC for FEP claims.
• Worked on embedded SQLs, triggers, Store Procedures and Cursors in SQLRPGLE programming
• Work with third party vendors for project specific activities
• Preparation of Unit Test Plans, Test cases, Code peer reviews and documenting test results
• Perform testing on Blue Exchange web pages and replicate customer issues
• Power MHS claims validation and adjudication
• Sending Release Notes (RN), Software Migration Report (SMR)
• Validate EDI 837, 834, BX 277, 278 transactions
• Validating SSRS reports - Canned and Custom
• Analyze teh issues and identify bottle necks

Environment: AS/400, RPG/400, CL/400, DB2/400, RPGLE, TURNOVER, HAWKEYE, XML, HP Quality Center, QTP, Load Runner, EXTOL EDI Integrator, CITRIX, Power MHS 7.x, Business Objects, SSRS,SQL Server Management Studio, SQL Server 2005/2008,C#, MS Visual Studio, HP Results Viewer

Confidential ., NY

Software Engineer/Tester

Responsibilities:

• Analyzed, fixed and tested change requests and bug fixesin RPGLE, CL/400
• Installed PTFs and configurations
• Performed impact analysis using HAWKEYE and prepared documentation
• Responsible for unit and system testing
• Responsible for Black Box and White box testing
• Track and report defects in MS ACCESS
• Send daily status reports

Environment:AS/400, RPG/400, CL/400, DB2/400, RPGLE, FTP CMD, SCHEDULER/400, HAWKEYE, TURNOVER, JAVA/J2EE, MS-Excel, SQL SERVER 2000/2005, Crystal Reports, Manual Testing, MS ACCESS