We provide IT Staff Augmentation Services!

Onshore-offshore Coordinator Resume

2.00/5 (Submit Your Rating)

Alpharetta, GA

OBJECTIVE

  • Looking for a challenging position where my technical, organizational, team playing and leadership skills will contribute to elevating the quality and success of projects.

SUMMARY

  • Experienced in successfully coordinating and leading small and large teams.
  • Possess hands - on testing capabilities wif 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 the 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 wif customers and strategic partners.
  • Experienced in creating, maintaining and managing a technical support department beginning at ground zero.
  • Hosting daily teleconferences wif various stakeholders (Business, Dev, QA, UAT) to discuss the status of the project.
  • Competent at managing ongoing relationships wif 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 wif Share Point environment.
  • Led the QA automation team by monitoring and supervising the automation test scripts in Quick Test Professional.
  • Created QA Project Plans for Maintenance Phase of the Life Cycle for Test Resources.
  • Verified traceability of Test Conditions to Test Cases.
  • Created Functional requirements for the change requests/maintenance phase.
  • Conducted Walkthrough of the Test Plans and Test Cases.
  • Provided testing sign-off at key stages of the 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 the 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 the Sprint stories we are working on.
  • Participated in standups, scrum/sprint estimation meetings wif 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 the Application according to the Requirement Documentation.
  • Coordinated wif the management in reducing duplication of effort and accelerate the adoption of best practices across the division through the 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 the Migration Reports.
  • Managing post migration communication to end users, about the new SharePoint site along wif the Migration Report which details all the files dat were migrated and the files dat 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 the build and coordinate wif 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 the build and revision# across multiple test environments.
  • Leading/Managing the offshore team and coordinate wif the offshore team on daily tasks and review the 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 the data retrieved for Item Basis, SKU, Department, Vendor, etc. tables match the order management applications.
  • Verify the PO is created as per the requirements using Order Management tools.
  • Validate the data on Mainframes (DB2).
  • Wrote SQL statements to extract data from the Tables.
  • Verify the Jobs on Mainframes has run successfully wif the expected result codes.
  • Browse and compare files using File-Aid on Mainframes and check if they are in the right format.
  • Create test data using File-Aid.
  • Coordinate wif the offshore team on daily tasks and review the 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 wif JCL extensively to schedule and execute the jobs.
  • Validated the data in Mainframes.
  • A new user Interface, the PDF Application was tested and implemented to support the creation and maintenance functionality surrounding the management of Brand level product definitions Responsible, etc.
  • Legacy Item/Basics/SKU divisional system and other application interfaces has been validated for the new changes.
  • Extensively used and validated Teradata staging tables as part of the ETL process for all the data from all the Order management applications and other interfacing applications.
  • Validated FEDPLAN green screens which take the existing Sales, On-hands, On-Order data to calculate and plan for the 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 the merchant and terminal demographics needed for testing purposes in QA and UAT.
  • Worked on Agile SCRUM approach implementation for the 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. This includes adding of new Merchants in HIMMS and any updates done to merchant demographics in HIMMS or MPS (Merchant Processing System).
  • Validated dat the Merchant’s boarded/updated in HIMMS are displayed correctly in MPS3 and Stratus and trouble shoot the areas where the merchant updateswere not reflected appropriately in the downstream systems.
  • Worked wif JCL jobs to schedule jobs in Mainframes.
  • Worked wif 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 wif and wifout 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 the data using SQL to ensure integrity and consistency of data.
  • Tested Online CICS Mainframe screens and VSAM Files.
  • Responsible for creation and validation of the 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 the all the types of transactions MPS supports from Stratus and making sure all the DB2 tables using SPUFI in MPS are populated wif the right values.
  • Validate green screens on Mainframes are getting populated wif appropriate values.
  • Validated various reports in MPS including statements to Merchants and Associations.
  • Responsible for validating clearing to the associations and the response files which includes Disputes from Associations.
  • Involved in creating Certification scripts and getting certified wif 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 the Tandem, Unisys and Stratus.
  • Verify the implement ETL code against the corresponding mapping document. Confirm the data loads from source files into the 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 wif the development team towards bug resolution as well as coordinated wif Business Analysts in the 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 the various card interfaces.
  • Entered, modified and updated test files in PVCS Tracker.
  • Used the TestNet/2 tool which is a computer based transaction simulation software package to stress test the OLTP (Online Transaction Processing) system in-house.
  • Created Gap Analysis by testing the files against the 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 the 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 the POS system and the 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 the 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 the 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 the XML - based testing.
  • Validated the web services (SOAP) for both request and response messages.
  • Validated the different protocols TCP/IP, HTTP and HTTPS.
  • Performed cross browser and data driven testing wif the Regression test scripts using Win runner.
  • Performed ETL testing to validate each independent program component individually against its desired behavior and performance wif the valid set of inputs (normal behavior) as well as wif erroneous inputs (exceptional behavior).
  • Created and executed the whole ETL testing process and worked wif the data discovery/profiling tool Informatica Data Explorer.
  • Tested ASP and ASP.NET pages to meet the business requirements and also involved in testing the application wif ASP pages replaced by the redesigned ASP.NET pages.
  • Written SQL queries to validate data against the Business Object Reports.
  • Coded new JCL procedures for Executing Tests, validating output results.
  • Tested various menus, options and utilities of the 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 the future releases of the application using Win Runner.
  • Test the 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 the 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 the business process by identifying the ambiguous requirements and also involved in finding the deferring system requirements.
  • Report bugs using Defect Track Management in Test Director, and participated in bug reviews by following up wif development team to verify bug fixes and update bug status.
  • Tested the source database and Confidential databases in after the ETL Ab Initio process.
  • Tested the migrated data using the Data Transformation Services (DTS) process.
  • Tested different SAP CRM and BW modules.
  • Tested the database integrity by writing SQL queries using QMF.
  • Validated the data on Mainframes and worked wif 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 the technical requirements and facilitated testability review meetings wif the SME’s.
  • Work wif Business Analyst to understand and communicate issues related to business process
  • Identified testing scenarios to make sure WMOS is working as per the 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 wif Business users and Technical team in providing clear solutions to requirements.
  • Tested the 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 wif corresponding table in the mapping document.
  • Conducted Daily Defect Status Meetings wif the 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 wif end users in collecting functional requirements for the application using Rational Requisite pro.
  • Used Visio to document the process flow.
  • Logged critical and ambiguous issues and worked wif the development team towards bug resolution as well as coordinated wif Business Analysts in the production of new change requests.
  • Tested the membership enrollment, employer group billing and processing different claims like Medical claims, hospital claims, pharmacy claims and dental claims using Rational Suite.
  • Tested the 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 the 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 the different Coverage and Claims EDI transactions.
  • Worked wif loading of data onto PowerMHS (AS/400).
  • Tested the local Transaction processing systems (me.e. claims and membership) for both BCBSM and Blue Care Network (BCN) wif the 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

We'd love your feedback!