We provide IT Staff Augmentation Services!

Lead Qa Consultant Resume

3.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY

  • 14 + years of software engineering experience in designing, developing, integrating and upgrading business application systems, systems & database design and strong client/server development skills.
  • 12 + years of experience in working with PeopleSoft Financial Applications,People Tools and related technologies, including new PeopleSoft implementations and upgrades.
  • Expertise with Accounts Payable, Accounts Receivable, Billing, Cash Management, Treasury, General Ledger - Order Management, Production Management, Quality Management, Inventory, Purchasing, Bills & Routings, and Cost Management
  • Expertise with eProcurement, Purchasing, Cost Management, Project Costing, Billing and Contracts in designing the Project Management and detailed Costing Functionality.
  • Strong Experience in implementing the Quest STAT tool for PeopleSoft change Management
  • Strong project management skills and ability to coordinate complex infrastructure initiatives.
  • Expertise in training business users with UserProductivity Kit(UPK).
  • Strong relationship and negotiation skills, customer service orientation, demonstrate effective communication and interaction with clients, peers, and vendors.
  • Worked with reporting tools such as Crystal Reports and XML Publisher.
  • Knowledge & exposure in Governance Risk Controls, Quality standards (ISO-9000), Environmental Standards (ISO-14000), Sarbanes Oxley etc.
  • Strong communication skills, well organized, and able to work individually or in a group.

TECHNICAL SKILLS
ERP Package : PeopleSoft (GL, AR, AP, Project Costing, PO, Inventory, Purchasing, eProcurement, Billing, Order Management, Asset Management, Cash Management, HR, Benefits, Payroll).
Reports : SQR, Crystal Reports, Query, nVision.
Databases : Oracle, DB2 UDB, SQL Server, Microsoft Access
Tools : PeopleTools, Integration Broker, Visual FoxPro
Languages : PeopleCode, Java 1.2, RMI, JDBC, Networking, EJB, J2EE,
SQL, PL/SQL, C, C++, FoxPro, Pro*C, Shell
Script
Operating Systems : UNIX, Sun Solaris, Windows 2000/NT/95/98, MS DOS
Internet Tools : HTML, DHTML, Applets, Servlets
Application Server : Tuxedo, Web Logic

Education:
Masters in Computer Application
Bachelors in Science

VISA: US CITIZEN

PROFESSIONAL EXPERIENCE

EXPERIENCE:

Confidential
Washington DC 02/2011 to Current Date

Functional / Lead QA Consultant
  • Working with Business People and Functional resources in getting the test analysis document.
  • Designed the test plans and designed the Version one's testing strategy.
  • Interfaced with end-users a lot to gather the requirements, clarified their functional and technical queries.
  • Designed the testing status and set the filters for every day defect meetings.
  • Extensively worked on Purchase to Pay process in eProcurement
  • Lead the defect meetings to keep all the functional leads, developers and business users on the same page regarding the testing progress.
  • Tested the applicability of Value added Tax(VAT) on the Europe implementation.
  • Expertise in generating test scripts and validating the data and also Interface testing.
  • Expertise in documenting business workflows, procedures, roles and responsibilities
  • Excellent working knowledge of SQL's and query tools like TOAD, PS Query

Environment: -, PeopleSoft Financials 9.1, eProcurement, Accounts Payable, Project costing, Asset Management , General Ledger , eSettlements, Accounts Receivables, Billing, HP quality center 9.2, Version one, SQL.

Confidential
Washington DC 09/2010 to 02/2011

Functional Lead Consultant
  • Working with Business People and getting their requirements and customizations
  • Performed business requirement analysis and development to facilitate re-engineering efforts
  • Interfaced with end-users a lot to gather the requirements, clarified their functional and technical queries.
  • Expertise in documenting business workflows, procedures, roles and responsibilities
  • Excellent working knowledge of SQL's and query tools like TOAD, PS Query
  • Drawing Process Diagrams (To be Vision) that helps other team members to understand system easily.
  • Extensively worked on Purchase to Pay process in eProcurement
  • Established a GL business unit and ledger, GL calendar, journal sources, and accounting entry templates to transfer journals from Asset Management to GL

Environment: - Microsoft Windows NT, Oracle 9i, PeopleSoft Financials 9.1, eProcurement, Accounts Payable, Project costing, Asset Management , General Ledger, UPK, HP quality center 9.2, SQL.

Confidential
Silverspring, MD
Business Analyst/Testing Lead 06/2009 to 08/16/2010

  • Worked with the Business Intelligence Development Studio to define, edit, and publish report models that are used in Report Builder.
  • Extensively used the SSRS(SQL Server Reporting Services) to generate the Reports for different levels of users and based on the application usage.
  • Involved with the testing processes both unit testing and system testing
  • Interfaced with end-users a lot to gather the requirements, clarified their functional and technical queries.
  • Involved with the testing of the modules billing, AR and GL.
  • Generated the test scripts for the Billing and AR modules had them approved by business users.
  • Involved in creating, managing, supporting, maintaining and enhancing business rules applications.

Environment: - Microsoft Windows NT, Oracle 9i, PeopleSoft Financials 9.0, Billing, Accounts Payable, Accounts Receivable, General Ledger, HP quality center 9.2, SQL, DB2, SSRS, BI, Excel and MS Access.

Confidential
Columbia, MD
PeopleSoft Consultant 08/2008 to 05/3009

  • Working with Business People and getting their requirements and customizations, Drawing Process Diagrams (To be Vision) that helps other team members to understand system easily\\
  • Extensively involved with the testing and maintain the status in the HP quality center.
  • Worked on rollout for Manager Self Service with emphasis on Peoplesoft eComp+
  • Interfaced with end-users a lot to gather the requirements, clarified their functional and technical queries.
  • Expertise in documenting business workflows, procedures, roles and responsibilities
  • Excellent working knowledge of SQL's and query tools like TOAD, Golden and PS Query
  • Generated reports using XML Publisher.

Environment: - Microsoft Windows NT, Oracle 9i, People Tools 8.45, PeopleSoft HCM 8.8, MSS, eComp+, Active Directory, Requisite Pro, SQL, Oracle, Excel and MS Access.

Confidential
Baltimore, MD
Functional Lead Consultant/Business Analyst 06/2007 to 09/2007

  • Defined the documentation for the Accounts Receivable business process
  • Help defined the Item Catalogs and catalog requirements.
  • Working with Business People and getting their requirements and customizations,
  • Worked on the Ledger processing and sending the journals through journal generator.
  • Extensively worked on the journal editing and posting in GL
  • Worked on reconfiguring the chart fields and edit combo rules

Environment: - Microsoft Windows NT, Oracle 9i, PeopleSoft Financials 9.0, Billing, Accounts Payable, Accounts Receivable, General Ledger, Cash Management and Treasury Management .

Confidential
Blue Cross Blue Shield, IL
Functional Lead Consultant 06/2006 to 02/2007

  • Defined the documentation process for the PO's and Contracts execution for the end users.
  • Help defined the Item Catalogs and catalog requirements.
  • Helped the User to associate the Suppliers with the Catalog Items.
  • Involved with training the end-users on creating requisitions, Creating PO's and submitting Contracts.
  • Configured the Accounts Payable Module.
  • Extensively worked on Purchase to Pay process in eProcurement
  • Worked on the functionality of Material Picking Feedback and generating the report for the depletion of items.
  • Involved with reviewing, approving, and correcting complete billing activity online, and simplify complex approval processes.
  • Worked on the process flow of the Inventory Replenishment
  • Worked on Inventory Putaway and Putting away both Purchase Order requisitions and non-purchase order req's by doing the Manual Stage Putaway
  • Worked on the functionality of Contracts enabling the functionality of billing from a project.
  • Performing customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that is already in stock.

Environment: - Microsoft Windows NT, Oracle 9i, People Tools 8.45, PeopleSoft Financials 9.0, Billing, Contracts, AP, Purchasing, eProcurement and Inventory.

Confidential,Washington, DC.Functional Lead Consultant 12/2005 - 05/2006
  • Defined the documentation process for the PO's and Contracts execution for the end users.
  • Help defined the Item Catalogs and catalog requirements.
  • Helped the User to associate the Suppliers with the Catalog Items.
  • Involved with training the end-users on creating requisitions, Creating PO's and submitting Contracts.
  • Involved with analysis of Post Production issues mainly concerned with eProcurement and Purchasing.
  • Defined the WorkFlow process for various Approvers as well as buyers.
  • Extensively worked on Purchase to Pay process in eProcurement
  • Worked on Commitment Controls while doing the budget checks.
  • Performing customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that is already in stock.

Environment: - Microsoft Windows NT, Oracle 9i, People Tools 8.45, PeopleSoft Financials 8.8, Peoplesoft 8.9, AP, Purchasing, eProcurement, General Ledger and Supply Chain Management.

Confidential, OWINGS MILLS, MDFunctional Consultant 08/2005 - 12/2005
  • Defined the new Business unit 00600 for Legg Mason to accommodate the newly merged Citi Group transactions.
  • Designed the Functional documentation for the eProcurement and joining the Staples to Legg Mason ePro for Punchouts.
  • Defined the Testing scripts for the eProcurement transactions with high dollar and Punchouts.
  • Involved with analysis of Post Production issues mainly concerned with eProcurement and Purchasing.
  • Defined the Template creation in eProcurement to the buyers.
  • Extensively worked on Purchase to Pay process in eProcurement
  • Defined the WorkFlow process for various Approvers as well as buyers.
  • Enabled and worked on Commitment Controls in GL and eProcurement.
  • Working with Business People and getting their requirements and customizations, Drawing Process Diagrams (To be Vision) that helps other team members to understand system easily.
  • Performing customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that is already in stock.

Environment: - Microsoft Windows NT, Oracle 9i, People Tools 8.4, PeopleSoft Financials 8.8, Purchasing, eProcurement, sProcurement, Accounts Payables and Supply Chain Management.

Confidential, South Portland, ME 10/2004 - 07/2005

Functional Lead Consultant

  • Involved in the Fit and Gap analysis/impact of the existing customizations to that of the functionality of the new release.
  • Involved with the documentation of the compare reports and making an assessment of the production database.
  • Strong project management skills and ability to coordinate complex infrastructure initiatives.
  • Strong relationship and negotiation skills, customer service orientation, demonstrate effective communication and interaction with clients, peers, and vendors.
  • Interfaced with end-users a lot to gather the requirements clarified their functional and technical queries.
  • Involved with the post production support, coordinating between endusers and the Development team.
  • Involved with the definition of hierarchy for the AP module while designing the business units and Voucher origin
  • Involved with the designing of business units for the Inventory system.
  • Defined Inventory terms including multiple item numbers, multiple unit of measure and multi-language item descriptions.
  • Worked on fulfill stock orders and Stock Requests in Inventory.
  • Conducted the User Acceptance testing and has given guidance to the users
  • Involved in Facilitating meetings, process mapping, and knowledge transfer

Environment: - Microsoft Windows NT, Oracle 9i, People Tools 8.4, PeopleSoft Financials 8.8, Cost Management, Manufacturing, Purchasing and Inventory.

Confidential, Albany, NY 03/2004 to 08/2004
Business Analyst

  • Working with Business People and getting their requirements and customizations, Drawing Process Diagrams (To be Vision) that helps other team members to understand system easily.
  • Validated the process designs, developed the business requirements and used both functional and use cases while developing interfaces and doing the data conversion.
  • Conducted the User Acceptance testing and has given guidance to the users
  • Involved in Facilitating meetings, process mapping, and knowledge transfer
  • Provided application knowledge sharing

Environment: - HP-UX, Windows 2000 Professional, Oracle 9i, People Tools 7.5 to 8.4, PeopleSoft Financials 8.4 AP, AR, GL, and Billing, Integration Broker, STAT , PeopleCode, SQL, SQR.

Confidential, MD11/2003 - 03/2004

Functional Consultant

  • Strong project management skills and ability to coordinate complex infrastructure initiatives.
  • Identify communication requirements, process flows, and procedures. Identify metrics and reporting requirements.
  • Strong relationship and negotiation skills, customer service orientation, demonstrate effective communication and interaction with clients, peers, and vendors.
  • Documented all the processes in accordance with the Information technology standards
  • Interfaced with end-users a lot to gather the requirements, clarified their functional and technical queries.
  • Worked on the explosion of BOM into various levels in Billing module.
  • Validated the process designs, developed the business requirements and used both functional and use cases while developing interfaces and doing the data conversion.
  • Conducted the User Acceptance testing and has given guidance to the users

Environment: - HP-UX, Windows 2000 Professional, Oracle 9i, People Tools 7.5 to 8.4, PeopleSoft Financials 8.4 AP, AR, GL, Billing SQL, SQR.

Confidential, PA 04/2003 to 10/2003

Functional Consultant

  • Fit gap analysis for various processes and helped users in finalizing various processes.
  • Worked on all the Books including STATES, BUDGET and TAX.
  • Interacted with other PeopleSoft financial Modules while generating the Purchase Order for the asset in PeopleSoft Purchasing and sending the PO to the vendor.
  • Transferred accounts payable voucher information into Asset Management using the Payables/Purchasing Interface.
  • Strong project management skills and ability to coordinate complex infrastructure initiatives.
  • Involved with the setting up of the PeopleSoft Financials along with the Tuxedo Server and WebLogic Server.
  • Established a GL business unit and ledger, GL calendar, journal sources, and accounting entry templates to transfer journals from Asset Management to GL
  • Involved in defining workflow roles, route controls for AR module.
  • Defined and Implemented Migration paths in STAT
  • Defined and Implemented user and role based security in STAT

Environment: - HP-UX, Windows 2000 Professional, Oracle 9i, People Tools 7.5 to 8.4, PeopleSoft Financials 8.4 AP, AR, GL, PC, PO, People soft SCM 8.4 - OM, Billing, Project Costing.

Confidential, IL 06/2002 to 04/2003

Functional Consultant

  • Working with Business People and getting their requirements and customizations, Drawing Process Diagrams (To be Vision) that helps other team members to understand system easily.
  • Implemented Quest Stat for People Soft change management
  • Design and development of automated reconciliation reports and procedures to validate data conversion.
  • Strong project management skills and ability to coordinate complex infrastructure initiatives.
  • Configuration OM, Inventory, AP, GL, AR, AM, PC setup data (like Business Units, Control data, Vendor Location, Origin, Items etc)

Environment: PeopleSoft Financials 8.4 AP, AR, GL, PC, PO, People soft SCM 8.4 - OM, Billing, Inventory, Projects costing. Crystal Reports 8.0, SQL, PL/SQL, Web Logic, QA Testing

Confidential, Corning, NY06/2001 - 05/2002
PeopleSoft Consultant (7.01/8.1/8.16)

Responsibilities:

  • Provided People Soft Technical/Functional consultation on Fit Analysis of Financials GL, AP, AR, eProcurement, Purchasing, billing, Inventory.
  • Involved in creating and modification of pages and components.
  • Setting up of all eProcurement pages, including an easy-to-use guide to direct step-by-step through the setup process.
  • Involved in setting up workflow and involved in defining workflow roles, route controls for treasury module.
  • Configured the PeopleSoft SetUp tables and assisted in installing WebLogic and Tuxedo Server.
  • Implemented Quest Stat for People Soft change management
  • Used archiving in PeopleSoft Payables, to archive vouchers, payments, and vendors to remove them from the production transaction tables to history tables for maintenance purposes.

Environment: PeopleSoft Financials 8.1, PC, GL, AM, People tools 8.13/8.16, People Code, SQR, Crystal reports, nVision, Process Scheduler, Workflow Administrator, Web logic, Windows NT, UNIX and Oracle 8.0/8i.

Confidential, CA 09/2000 - 04/2001
PeopleSoft Consultant

Responsibilities:

  • Uploading product-pricing data from Excel.
  • Generated Crystal Reports for creating Slow Moving Inventory Report, Shipping Container Labels, and Transaction Register Report.
  • Involved in the Development of SQR's for converting quantity of an Item one UOM to another, for creating Storage Location Report for PeopleSoft Inventory, to create Material Authorizations.
  • Involved in testing and implementation of PeopleSoft Financials and Distribution, Account Payable, GLModules, Order management and Inventory
  • Created new and customized existing PeopleSoft objects (Panels, Panel Groups,
  • Menus, People Code, Process Definition) and applied Security
  • Developed interface between Payroll and GL. Involved in the entire life cycle of the Account Payable i.e., Voucher Entry, Contract Tracking.

Environment: PeopleSoft Financials 7.5, GL, AP, AR, PC, PO, OM, Inventory, Supply Chain Management, nVision, Crystal Reports, Shipping, People tools, Workflow, Oracle.

Confidential, Denver, CO 2/1999 - 08/2000

  • Involved in analyzing the requirements and preparing the implementation strategy.
  • Modified various SQR programs, to retrieve data from the GL tables, to load data into Budget Tracker.
  • Developed an SQR that will produce a AMdepreciation expense report for current period, year to date, and life to date and also enhanced an existing AM report that will have salvage value in the output.

Environment: PeopleSoft 7.5, People tools, People Code, SQR, nVision, Crystal reports, Process Scheduler, workflow Administrator, Windows NT, UNIX and DB2

Confidential, Bangalore 04/1997 - 01/1999
Responsibilities:

  • As a member of the team involved in remediating the customized SQRs from 6.0 to 7.5v, and modified them to run in PeopleSoft (HRMS) 7.5v environment.
  • Developed lot of SQR Programs for the Conversion Process.
  • Written the Interfaces for the Payroll.

Environment: PeopleSoft 6.0/7.5v Oracle 7.3, HP UNIX 11.0, Windows NT, Win Frame/Meta Frame and

Confidential, Hyderabad 01/1996 - 03/1997
Open systems
Responsibilities:

  • The development of the communication code between EMS (Energy Management System) server and the DEC Alpha server.
  • Collection of various Data requirements from the client RTUs.
  • Database tables design.
  • Code development of advanced functions, i.e., State Estimator, Online Powerflow.

Environment: C, C++, FoxPro, UNIX IPC, UNIX Internals, HP-UNIX, Berkley sockets Pro* C, Shell Script

We'd love your feedback!