Onshore-offshore Coordinator Resume
Alpharetta, GA
OBJECTIVE
- Looking for a challenging position where my technical, organizational, team playing and leadership skills will contribute to elevating teh quality and success of projects.
SUMMARY
- Experienced in successfully coordinating and leading small and large teams.
- Possess hands - on testing capabilities with n-tier, database-driven ecommerce systems and point-of-sale applications (both web and proprietary protocols).
- Extensive management capabilities in SQA of cross-platform client-server applications.
- Proficient at utilizing / customizing multi-user databases for monitoring test results and tracking follow-ups.
- Extensive expertise in writing project specifications, requirements, test plans, FAQ's, ReadMe/help documentation, and release notes for both beta testers and client populations.
- Expertise in Seibel (CRM), Mainframes, Web-based, Data Warehouse (DTS, EDW, ETL, Reporting), Database, SAP, ASP.NET, MQ-Messaging, POS, XML, EDI and Facets testing.
- Proficient at writing test plans and test cases for all testing methodologies and proofreading of HTML and XML files.
- Skilled in developing/maintaining technical and training documentation for teh team members.
- Proven success in managing multiple projects simultaneously.
- Extensive expertise in software development life cycle gained through managing a variety of projects successfully producing, testing, and releasing software products and websites.
- Skilled at establishing project structure, timeline, communications, and operations.
- Ability to successfully manage projects requiring contact with customers and strategic partners.
- Experienced in creating, maintaining and managing a technical support department beginning at ground zero.
- Hosting daily teleconferences with various stakeholders (Business, Dev, QA, UAT) to discuss teh status of teh project.
- Competent at managing ongoing relationships with outsourced agencies to ensure value added benefits.
- Proficient at supervising activities, day-to-day tasking, and mentoring medium to large project teams.
- Responsible for writing test plan, test approach, acceptance criteria, analyzing functional specifications, communicating risk.
- Managed QA team ranging in size 2-10 people.
- Attended Design Review Meetings and change control meetings.
- Built Unit test data for developers.
- Extensively worked with Share Point environment.
- Led teh QA automation team by monitoring and supervising teh automation test scripts in Quick Test Professional.
- Created QA Project Plans for Maintenance Phase of teh Life Cycle for Test Resources.
- Verified traceability of Test Conditions to Test Cases.
- Created Functional requirements for teh change requests/maintenance phase.
- Conducted Walkthrough of teh Test Plans and Test Cases.
- Provided testing sign-off at key stages of teh project.
- Created and presented Production Verification Strategies to members of Senior Management, Business, Developers, Production Support, Product Management and Security.
- Responsible for communicating readiness of project for go-live, as well as regular communication of defects, and weekly status reports, both internally and to teh client.
- Led bug triage meetings, and communicated risks to all necessary parties.
TECHNICAL SKILLS
Testing Tools: Mercury Interactive (ALM, Quality Center, Test Director, QTP, Win Runner, Load Runner), Rational Suite (Requisite Pro, Test Manager, Rose, Robot, Clear Quest, Clear Case)
Languages: SQL, PL/SQL, C, C++, Java, HTML, COBOL, JCL, Perl, CICS
Development Tools: VBScript, JavaScript, Shell Script, VB, XML, ASP, Power Builder, SAP, Microsoft .Net 3.5, ASP.Net 3.5, C# .Net 3.5, Microsoft visual studio 2008
Databases: Oracle 10g/ 9i/8i/8.0/7.x, DB2, SQL Server, Access, QMF
Database Query Tools: Aqua Data Studio, TOAD, SQL Squirrel, Spufi for Mainframes
Data Warehouse: Informatica, Data Stage, Ab Initio, Informix, Teradata, Business Objects
GUI Tools: Cooktop, XML Spy
Networking Protocols: TCP/IP, HTTP, HTTPS
Version Control/Defect Trackers: Quality Center, Test Director, Bug Tracker, Rational Clear Quest, Rational Quality manager. CVS, PVCS, Subversion, JIRA, Microsoft SharePoint
Content management systems: Documentum, Team Site, Share Point, Pivotal Tracker, MS Project
Operating systems: Windows (NT/2000/XP/Vista), Mac, Mainframes, AS/400, Solaris, Linux, Unix
Browsers: Internet Explorer, Netscape, Safari, Opera, Mozilla, and Firefox
Additional: HTML, review and debugging of apache server error logs, MS Office, Visio, MS PowerPoint, and Star Office/Open Office.
PROFESSIONAL EXPERIENCE
Onshore-Offshore Coordinator
Confidential, Alpharetta, GA
Responsibilities:
- Agile-Scrum methodology has been adapted to implement our Project successfully. Planned work has been split into user stories. Followed 3-Amigos approach to start and close teh Sprint stories we are working on.
- Participated in standups, scrum/sprint estimation meetings with a 2 week iterated sprint releases
- Story lifecycle tracking and matrix using Version One.
- Managed Functionality, Integration, GUI, Regression, Usability and System testing.
- Involved in creating a detailed System Test Plans, Test Cases and Test Scripts for different modules in teh Application according to teh Requirement Documentation.
- Coordinated with teh management in reducing duplication of effort and accelerate teh adoption of best practices across teh division through teh Enterprise Search feature in Office SharePoint Server.
- Worked on Ambulatory Provider Portal (Medical Management) & Payment Manager project consists of Medical Claims, reimbursement, Payment Gateways testing functionality.
- Maintaining a SharePoint Library for storing all teh Migration Reports.
- Managing post migration communication to end users, about teh new SharePoint site along with teh Migration Report which details all teh files that were migrated and teh files that was blocked/renamed due to limitations in SharePoint.
- Web service testing for SOAP clients using Apache Axis for different services and web methods.
- Tested reports on Share Point.
- Extensive data validation testing using SQL developer - proficient in inner join, outer join, group by, order by clauses etc.
- Defects logging and Defect tracking using HP ALM 11.00.
- Designed and created database for generating SSRS reports and graphs to compare different test runs and uploading results to share point.
- Used Jenkins and SVN monitor for teh build and coordinate with development if build fails.
- Creating Sql quires to generate reports on share point for bugs found by team / month / product.
- Used SVN monitor to track teh build and revision# across multiple test environments.
- Leading/Managing teh offshore team and coordinate with teh offshore team on daily tasks and review teh results and follow up on questions/issues.
Environment: HP ALM 11.00, Microsoft SharePoint, Version One, Jenkins, SOAP UI, Chrome Advanced Rest Client, SQL developer.
Senior Mainframe QA Analyst/Team Lead/Onshore-Offshore Coordinator
Confidential, Johns Creek, GA
Responsibilities:
- Test various Order management systems including FEDBUY (BUY), a2B (Affinity to BUY), MOU ( Confidential ’s Order Upload) and BOU (Bloomingdales Order Upload)
- Create PO’s (Purchase Order) and verify teh data retrieved for Item Basis, SKU, Department, Vendor, etc. tables match teh order management applications.
- Verify teh PO is created as per teh requirements using Order Management tools.
- Validate teh data on Mainframes (DB2).
- Wrote SQL statements to extract data from teh Tables.
- Verify teh Jobs on Mainframes have run successfully with teh expected result codes.
- Browse and compare files using File-Aid on Mainframes and check if they are in teh right format.
- Create test data using File-Aid.
- Coordinate with teh offshore team on daily tasks and review teh results and follow up on questions/issues.
- Common Product Hierarchy alignment of Department, Vendor, Class, Markstyle, Color and Size across channels was being supported through a new relational database structure which was tested and deployed successfully.
- Worked with JCL extensively to schedule and execute teh jobs.
- Validated teh data in Mainframes.
- A new user Interface, teh PDF Application was tested and implemented to support teh creation and maintenance functionality surrounding teh management of Brand level product definitions Responsible, etc.
- Legacy Item/Basics/SKU divisional system and other application interfaces have been validated for teh new changes.
- Extensively used and validated Teradata staging tables as part of teh ETL process for all teh data from all teh Order management applications and other interfacing applications.
- Validated FEDPLAN green screens which take teh existing Sales, On-hands, On-Order data to calculate and plan for teh upcoming seasons.
Environment: HP ALM 11.52, Mainframes, CICS, File-Aid, Various Order Management Applications including FEDBUY (BUY), a2B (Affinity to BUY), MOU ( Confidential ’s Order Upload) and BOU (Bloomingdales Order Upload), DB2, EDW, ETL, Teradata, Microsoft SharePoint
Senior Analyst/Team Lead
Confidential, Atlanta, GA
Responsibilities:
- Involved in successfully testing LATAM (Latin America) build project for AZTEC (Mexico) and EDISON (Brazil) programs.
- Boarded Merchants and Terminals in HIMMS (Highly Integrated Merchant Management system) as per teh merchant and terminal demographics needed for testing purposes in QA and UAT.
- Worked on Agile SCRUM approach implementation for teh whole testing life cycle .
- Tested Batch Programs developed by COBOL.
- Involved in testing SPOE (Program to send Merchants from HIMMS to MPS) and STRATQ (Process to send Merchants from MPS to Stratus) processes. dis includes adding of new Merchants in HIMMS and any updates done to merchant demographics in HIMMS or MPS (Merchant Processing System).
- Validated that teh Merchant’s boarded/updated in HIMMS are displayed correctly in MPS3 and Stratus and trouble shoot teh areas where teh merchant updateswere not reflected appropriately in teh downstream systems.
- Worked with JCL jobs to schedule jobs in Mainframes.
- Worked with TSO/ISPF and created test data on Mainframes using File-Aid.
- Involved in configuring POS devices used for testing purposes.
- Create and validate Credit and Debit card transactions (Purchase with and without EMV, Reversal, Void, Refunds, Installments, etc.) supported by Confidential for LATAM project as per specifications for various card types including Visa, MasterCard, Discover and Diners.
- Settled batches in Stratus using various batch close methods like Auto close, merchant initiated.
- Used SPUFI tool to perform backend DB2 table validation.
- Performed Database testing to verify teh data using SQL to ensure integrity and consistency of data.
- Tested Online CICS Mainframe screens and VSAM Files.
- Responsible for creation and validation of teh Stratus EDC (Electronic Data Capture) file and send them to MPS for Settlement, Billing, Funding, Reporting, etc.
- Extensively involved in Merchant Billing and Statement validation.
- Validated teh all teh types of transactions MPS supports from Stratus and making sure all teh DB2 tables using SPUFI in MPS are populated with teh right values.
- Validate green screens on Mainframes are getting populated with appropriate values.
- Validated various reports in MPS including statements to Merchants and Associations.
- Responsible for validating clearing to teh associations and teh response files which includes Disputes from Associations.
- Involved in creating Certification scripts and getting certified with Visa, MasterCard and Diners.
- Created various scenarios to test Reject processing and Dispute processing including Chargebacks.
- Validate data to TDS is flowing accordingly.
Environment: Rational Quality manager 3.0(RQM), Stratus, Mainframes, SPUFI, AS400, TDS, Oracle 10g on AIX, Microsoft SharePoint, In-house backend Emulators (Visa, MasterCard, American Express and Discover)
Senior Quality Assurance Engineer/Team Lead
Confidential, Atlanta, GA
Responsibilities:
- Tested various card issuer simulators configured to teh Tandem, Unisys and Stratus.
- Verify teh implement ETL code against teh corresponding mapping document. Confirm teh data loads from source files into teh Confidential tables.
- Examine sample record sets for consistency, data corruption and over all data quality
- Logged critical and ambiguous issues in Quality Center and worked with teh development team towards bug resolution as well as coordinated with Business Analysts in teh production of new change requests.
- Created test plans and test cases in Quality Center for Business Requirements from Caliber.
- Testing and QA processes including smoke, functional, regression, system integration testing (SIT) and system acceptance testing (SAT).
- Created and executed DAT files for numerous business scenarios based on market and card types to test teh various card interfaces.
- Entered, modified and updated test files in PVCS Tracker.
- Used teh TestNet/2 tool which is a computer based transaction simulation software package to stress test teh OLTP (Online Transaction Processing) system in-house.
- Created Gap Analysis by testing teh files against teh current host.
- Open, monitor and resolve defects using Mercury Quality Center.
- Validated all transaction types such as Credit, Debit, Check, EBT, etc.
- Worked on various message formats such as Central POS HDC, TDC, CTF on Central platform.
- Worked on some of teh complicated business requirements such as card present and card not present, etc.
- Created and executed DAT files in TEXT and ISO 8583 standard message formats used by Confidential to communicate authorization information between teh POS system and teh HOST.
- Responsible for creating test data in various message formats such as V0, V1 and V2 on East platform.
- Created and executed BIG Batch Authorization and capture files and Settlement Only files and documented results.
- Worked on creating and executing Batch Authorization files and POS message specification files for teh GLOBAL-HSBC HK Joint Venture.
- Created and validated and certified various clearing files such as EDS, Discover, Amex, Bonus Points, TSYS, etc.
- Validated test data using STPC and Testnet tools which are configured to OpeN/2.
- Wrote JCL and CICS procedures for batch and online testing.
Environment: Quality Center 9.2, Java; S2 System Open/2; EFT; Oracle 10g on AIX; Microsoft .Net 3.5, ASP.Net 3.5, C# .Net 3.5, Quality Center, Borland Caliber RM 6.0; PVCS; Windows; TOAD; STPC; Testnet; In-house backend Emulators (Visa, MasterCard, American Express and Discover), QTP
QA Analyst
Confidential, Milwaukee, WI
Responsibilities:
- Articulated and documented a comprehensive EDW testing approach and Test Plan.
- Also took an active part in data modeling and business modeling.
- Defined Entrance / Exit criteria and provided continual Risk Assessments to Senior Management.
- Created training material for teh latest software releases and enhancements.
- Planned / defined Test Strategies and coordinated test efforts for all Production Verification Testing efforts
- Involved in creating test cases and execution of teh XML - based testing.
- Validated teh web services (SOAP) for both request and response messages.
- Validated teh different protocols TCP/IP, HTTP and HTTPS.
- Performed cross browser and data driven testing with teh Regression test scripts using Win runner.
- Performed ETL testing to validate each independent program component individually against its desired behavior and performance with teh valid set of inputs (normal behavior) as well as with erroneous inputs (exceptional behavior).
- Created and executed teh whole ETL testing process and worked with teh data discovery/profiling tool Informatica Data Explorer.
- Tested ASP and ASP.NET pages to meet teh business requirements and also involved in testing teh application with ASP pages replaced by teh redesigned ASP.NET pages.
- Written SQL queries to validate data against teh Business Object Reports.
- Coded new JCL procedures for Executing Tests, validating output results.
- Tested various menus, options and utilities of teh CICS screens.
Environment: Mercury Suite (Winrunner 7.5, Quality Center), VB Script, ASP, ASP.NET, Web Services, XML SPY, Dream Weaver, Adobe Photoshop, XML, SQL, Oracle 8i/9i, ETL, Informatica, Business Objects, ToadWin XP, Unix, Mac, Mainframes, CICS, JCL, SOAP, TCP/IP, HTTP,HTTPS, SPUFI, IIS, IBM Utilities
QA Tester
Confidential, Dallas, TX
Responsibilities:
- Develop base line scripts for testing teh future releases of teh application using Win Runner.
- Test teh trade file extracts and request/response authorizations.
- Develop functional and regression testing scenarios based on XML and XSD schema validations.
- Software/hardware test on ISN platform for Telco telecom project
- Performed System Testing on applications of billing system and customer data.
- Tested teh integration and functionality of ARU (Automated Response Unit).
- Identified new process, finding out gaps in existing process, arranging training modules for new process development and implementation.
- Involved in documenting teh business process by identifying teh ambiguous requirements and also involved in finding teh deferring system requirements.
- Report bugs using Defect Track Management in Test Director, and participated in bug reviews by following up with development team to verify bug fixes and update bug status.
- Tested teh source database and Confidential databases in after teh ETL Ab Initio process.
- Tested teh migrated data using teh Data Transformation Services (DTS) process.
- Tested different SAP CRM and BW modules.
- Tested teh database integrity by writing SQL queries using QMF.
- Validated teh data on Mainframes and worked with JCL.
- Wrote SQL queries and PL/SQL procedures to ensure database integrity.
Environment: Winrunner, Test Director 8.0, Aqua Data Studio 4.7, Ab Nitio, SAP CRM, SAP BW, Windows 00/XP, Unix, Oracle, XML, Cooktop, XML SOA, SQL, DB2, QMF, WebSphere, Weblogic, ETL, QMF, DTS, Mac, COBOL, CICS, DB2, JCL, MVS OS390, ISPF, VSAM, DTS
WMOS Test Analyst
Confidential, St Paul, MN
Responsibilities:
- Involved in complete Testing Life-Cycle from analyzing Business Requirements.
- Involved in ever day Scrum meetings, 15 day Sprint review and Retrospective meetings.
- Translated teh technical requirements and facilitated testability review meetings with teh SME’s.
- Work with Business Analyst to understand and communicate issues related to business process
- Identified testing scenarios to make sure WMOS is working as per teh design and business expectation
- Testing all areas of WMOS Yard Management, Pre-receiving, Receiving, Putaway, Waving, Picking, Packing, Shipping, Loading, Sorting, Stock Select, Inventory management etc
- Tested Inbound interfaces to WMOS (Receiving, Putaway, Locate LPN, Split LPN)
- Testing Interfaces to WMOS (ASNs, POs, Cases, Orders) and PIXs
- Facilitated High level scenario meeting to review test cases with Business users and Technical team in providing clear solutions to requirements.
- Tested teh POS applications.
- Executed all kind of scenarios for User Acceptance Testing
- Tested Manhattan Warehouse management application for various projects
- Extensively Involved in writing SQL queries based on Source to Confidential mapping document, Verified Source and Confidential Record count and verified all column names associated with corresponding table in teh mapping document.
- Conducted Daily Defect Status Meetings with teh Developers and Business Analysts.
Environment: Quality Center 8.2,QTP, DB2, XML Spy, Manhattan's WMOS 2008/2010, SOAP, VB script, Share Point, MQ series, Windows 00/XP, MS-OFFICE, SELENIUM IDE.
QA Test Engineer
Confidential, Gaithersburg, MD
Responsibilities:
- Involved in creating Test Plan using Business Transaction rules, Test Cases and writing Test Specifications and Data Validations.
- Interacted with end users in collecting functional requirements for teh application using Rational Requisite pro.
- Used Visio to document teh process flow.
- Logged critical and ambiguous issues and worked with teh development team towards bug resolution as well as coordinated with Business Analysts in teh production of new change requests.
- Tested teh membership enrollment, employer group billing and processing different claims like Medical claims, hospital claims, pharmacy claims and dental claims using Rational Suite.
- Tested teh migration and conversion of data from legacy system to AS/400 and Facets.
- Wrote software validation plans to test FDA Approved 21 CFR part 11 compliance for electronic document storage.
- Efficiently created and maintained test cases using Rational Test Manager.
- Reported teh bugs using Bug Tracking tool like Clear Quest
- Performed build, version and configuration management using Clear Case
- Involved in IQ, OQ and PQ Validation of applications.
- Validated teh different Coverage and Claims EDI transactions.
- Worked with loading of data onto PowerMHS (AS/400).
- Tested teh local Transaction processing systems (me.e. claims and membership) for both BCBSM and Blue Care Network (BCN) with teh Trizetto Facets System.
Environment: C++, Rational suite, VSS, TOAD, Trizetto Facets 3.11, PL/SQL, MS-SQL, Oracle8.x, WinNT, Access, SQL Advantage, AS/400 (COBOL/400, DB2, RPG/400, CL/400, SQL/400), Visio, MS-office, Mainframes ES/9000, JCL, EDI, ASP.NET