We provide IT Staff Augmentation Services!

Quality Assurance Analyst Resume

NJ

SUMMARY:

  • In 13 years of expertise in Software Quality Assurance testing & Support -
  • Eight plus years of ETL testing using ODI, Informatica, Talend studio
  • Four plus years of hands-on automation testing with HP UFT, Selenium (Python)
  • 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
  • Tested SCDs (Slowly Changing Dimension) and performed Drill down and Drill Through approaches
  • 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 Order Management(OM), Account Payables(AP), Account Receivables(AR), Fixed Assets(FA), General Ledger(GL)
  • Exposure to testing web services with IBM MQs, JMS, BPEL Queues, Tokens, Subscriptions and Publisher
  • Emphasis in Point of Sale (POS) testing, reporting and application support
  • JDA trained and Solid understanding of JDA Point of Sale modules: Fulfillment, Master Planning
  • Experience in Defect management and Continuous Integration(CI) tools - JIRA, HP ALM, TFS, TestRail, Rally Tool, TTP, Foot Prints, 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 Smoke/Regression Testing, supported 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, JIRA, TestRail, Rally Test Case Management

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

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, Turnover, Hawkeye, DBU 60/70, Citrix, SQL Server Management Studio 2008, Visio, Visual Studio, TFS, SVN, GITHub, Teamcity, FileZilla, WINScp, PUTTY, WS-FTP, Alliance FTP Manager

ETL Tools: Informatica 8.1, Talend Studio, ODI

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

Operation 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, 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 ETL jobs using ODI
  • Testing various SCD (Slowly Changing Dimension) types, Surrogate keys
  • Develop & execute complex SQL queries during testing
  • Participate and Test Data Profiling, Data Cleansing, run ETLs for data migration
  • Validate Master and Transactional data for Initial load, Incremental load & Delta loads in ETL processes
  • 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, Inventory and Sub-Inventory transfers
  • Test User Profiles, User Roles & Responsibilities, Test AR Lockbox, Accounting entries and DFFs (Descriptive Flex Fields)
  • Used Postman/JMeter to perform Web service and Mobile API testing for ROADSTAR mobile app
  • Worked on web services testing and familiar with GET, PUT, POST, DELETE methods, Tokens, Authentications, end point URLs
  • Worked on testing web services with BPEL Queues and JMS
  • Assist users for UAT/Pre-Go-Live/Post-Go-Live support

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, JMS, JDeveloper, JMeter, Soap UI

Confidential, NJ

QA Analyst & Support

Responsibilities:

  • Design, develop, test and 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 the 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, File Zilla, 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 in to 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, Work flows, Tasks, Sessions with developers
  • Validated meta data, constraints, data integrity, duplicates and reconciliation counts
  • Tested various Active & Passive transformations, and Connected & Un-Connected transformations
  • Testing various systems involving 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 data for 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 Assurance Analyst

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
  • Sound knowledge on MQ Console, Queue Managers, Channels, Queues, Tokens and JMS messaging
  • Consumed IBM MQ messages, Data Areas, Data Queues and tested web services
  • 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 the 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, IBM MQ Series, Data Area, Data Queue, JAVA/J2EE, JAVA SCRIPT, 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 fixes in 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

Hire Now