Summary:

• Excellent Techno-Functional consultant with 8 years of strong experience in Developing and Consulting in Oracle/PeopleSoft Applications. Vast technical experience in PeopleSoft Financials and PeopleTools
• Experienced with Implementations, Integrations, Enhancements and Maintenance and Production Support
• Extensive experience working with PeopleTools such as Application Designer, PeopleCode, Application Engine, Data Mover, Component Interface, PS Query and PeopleSoft Internet Architecture PIA
• Experience in working with Object Security, Permission Lists, Roles and User Profiles.
• Experience in Working with all PeopleSoft objects such as Fields, Records, Pages, Components, Menus, File Layouts, Application Engine and PeopleCode.
• Extensive experience of Analysis, Design, Development, Testing, Implementation, Maintenance, and Business Analysis in the PeopleSoft Financial Environment
• Expertise in working with Finance Modules Accounts Payables AP , Purchasing PO , Services Procurement, Inventory, General Ledger GL , Asset Management AM , Contracts CA , Billing BI , Account Receivables AR and Supply Planning
• Experience in working with Reporting Tools SQR and Crystal Reports
• Experience in working with Process Scheduler and Process Monitor
• Knowledge on applying PeopleSoft Maintenance Packs
• Experience in Implementing and configuring Trackwise and Trackwise Analytics for Quality applications
• Experience of developing Microsoft Access application and SQL Server Management Studio, SQL server Integration services and SQL Server Reporting Services
• Experience with HP Quality Center 9.0 and Quest STAT
• Actively involved in Maintenance and Production Support
• Worked in Business Environments Involving Finance, Insurance, Supply Chain and Quality
• Strong analytical and problem solving skills
• Excellent written, oral and presentation skills and good team player
• Excellent Work Load Handling and Time Management Skills
• Strong Decision Making and Organizational Skills

Technical Skills:

Professional Experience:

Confidential

PeopleSoft Technical Consultant

• Confidential Coffee Roasters is a publicly traded brand of coffee and single serve Keurig brewers based at
• Waterbury in the Confidential of Vermont. The brand specializes in organic, fair trade, and specialty gourmet
• coffees. Keurig is a wholly owned subsidiary of Green Mountain Coffee Roasters, Inc., and sells Keurig
• brewers and many of their coffee Varieties as K-Cups and Vue packs. This project is to implement new
• business solutions and support existing processes related to supply chain module that includes purchasing,
• Procurement, Order Management and Inventory.

Responsibilities:

• Design and develop Oracle/PeopleSoft based software solutions to support new enhancements and business process changes in GMCR supply chain group.
• Customize Master Item data to specific to the coffee business at GMCR
• Customize Purchase Order printing and dispatching as per business requirements
• Design and develop solution for new item request initiation and approval process
• Developing Integration solutions for Purchasing and receiving between GMCR and third party locations
• Design and develop solution for GMCR order shipping confirmation to customers
• Supported Implementing new Corporate Purchasing Business unit
• Maintenance and production support of Inventory Putaway and fulfillment jobs
• Design and develop solutions for Green Coffee Contracts, Samples roasting/testing, Tasting and Scoring.
• Implementing Trackwise for GMCR to track Non-Conformances and CAPA's Corrective and Preventive action
• Design and develop quality solutions for non-conformance and customer complaints
• Analyze the user requirements across business units, Evaluate multiple design options, Industry standards and recommend a preferred approach
• Provide subject matter expertise on PeopleSoft Applications and provide advice to Supply Chain Management users
• Participate in peer/code/design reviews to verify that quality standards and functional/technical requirements are met
• Develop and author validation and all SDLC deliverables for all Trackwise releases/upgrades using Trackwise Software/Trackwise Administrator/Trackwise Coordinator/Trackwise Migrator
• Provide support and enhance Trackwise application system for tracking and Brewer and Beverage Non Conformance and Correct and preventive actions
• Develop solutions and provide support for GMCR Quality and Green Coffee applications using Microsoft Access, SQL Server management studio SSMS and SQL Server Reporting Services SSRS as per prioritized requirements
• Develop auto import process using SQL server Integration services for loading Beverage Partners quality data from external systems
• Develop Daily and weekly quality reports using SQL server Reporting services
• Develop solutions for Canada Green Coffee procurement onboarding to existing US system

Environment: PeopleSoft Financials 8.9 Purchasing, procurement, Inventory and Payables , PeopleTools 8.49 - Application Designer, PeopleCode, Application Engine, Integration Broker, PIA, Component Interface, SQR, Crystal Reports, PS Query, Trackwise 8.5/8.51, Trackwise Administration, Migrator and Coordinator, MS Access 2010/2007, SQL Server 2012/2008, SQL server Integration Services, SQL server Reporting Services, Oracle 11g, and Quest stat.

Confidential

Software Programmer/Analyst

• The Implementation of PeopleSoft sPro at Confidential has two distinct phases. A Pilot Rollout Phase, where
• a subset of the functionality is deployed across a subset of the business Marketing with no automated
• conversion. And the Full Rollout Phase incorporates the use of Services Procurement deliverable and multi
• resource functionality as well as includes an automated conversion of open work order balances and all
• related suppliers and service providers.

Responsibilities:

• Fulfillment - Single Resource/Multiple Resource Requests/Work Orders/Purchase Orders
• On-Boarding - Portal Bidding
• Extensions - Single Resource/Multiple Resource
• Settlement - Timesheet Expense Report transactions
• Off-Boarding Ability to off-board all PS on-boarded resources
• Enhancements to Deliverable work orders, Milestone Schedule page, Progress log pages
• Incorporating onboarding tasks by modifying the Track resources page
• sPro Verity search setup for Service Providers and Service Provider contacts
• Participate in code/design reviews and in testing to verify that quality standards and functional/technical requirements are met
• Working with Oracle on bug fixes

Environment: PeopleSoft Financials 9.1 sPro, ePro, Purchasing, AP , PeopleTools 8.5 - Application Designer, PeopleCode, Application Engine, PIA, SQR, , Crystal Reports, PS Query, Oracle 11g, and Quest stat.

Confidential

Software Programmer/Analyst

• Confidential Coffee Roasters is a publicly traded brand of coffee based at Waterbury in the Confidential of
• Vermont. The brand specializes in organic, fair trade, and specialty gourmet coffees. Keurig is a wholly
• owned subsidiary of Green Mountain Coffee Roasters, Inc., and sells Keurig brewers and many of their coffee
• Varieties as K-Cups and Vue packs.
• This project is to implement an enterprise level Purchasing requisitions and approval workflow for specialty
• Coffee, keurig and Canadian business units. This project will help to minimize the communication overhead
• And provide audit compliance requirements.

Responsibilities:

• Analyze the delivered oracle/PeopleSoft requisitions and workflow process
• Design and develop Oracle/PeopleSoft based software for creating and approving requisitions for Purchasing/Procurement at GMCR
• Standardize approval levels and approver roles across GMCR enterprise
• Design and Develop an approval workflow process to automate requisition approvals
• Design and Develop a notification process to notify buyers once the requisitions are sourced to purchase orders
• Analyze the user requirements across business units, Evaluate multiple design options, Industry standards and recommend a preferred approach
• Develop support documentation to facilitate understanding of the new application and processes
• Develop user documentation to facilitate implementation of the new functions developed
• Provide support to restore any failure after new applications are deployed for production use

Environment: PeopleSoft Financials 8.9 Purchasing and procurement , PeopleTools 8.49 - Application Designer, PeopleCode, Application Engine, PIA, Component Interface, Approval Framework/Workflow , PS Query, SQR, SQL, Oracle 11g, and Quest stat.

Confidential

PeopleSoft Technical Consultant

• Confidential , established in 1915, is a 4 billion a year not-for-profit health care
• organization situated Detroit Michigan. Confidential is rated among the leading health care providers in Confidential
• and their flagship Henry Ford Hospital is recognized for clinical excellence and innovation in the many
• specialty fields. HFHS provides health insurance and health care delivery, including acute, specialty, primary
• and preventive care services backed by excellence in research and education. HFHS operate a network of 7
• hospitals and nearly 300 medical centers in South Eastern Michigan.
• Incorporate Global Location Numbers into PeopleSoft system. This will give users the flexibility to use either
• the Location or GLN numbers for Purchasing/Procurement/Inventory.

Responsibilities:

• Design and develop Oracle/PeopleSoft based custom software for maintaining the global locations for Purchasing/Procurement/Supply Chain Management at HFHS
• Analyze the user requirements, Evaluate multiple design options and recommend a preferred approach
• Customize pages and components in Oracle/PeopleSoft using People Tools
• Develop support documentation to facilitate ongoing support of the applications
• Develop user documentation to facilitate implementation of the new functions developed
• Provide support to restore any failure after new apps are deployed for production use
• Provide subject matter expertise on PeopleSoft Apps and provide advice to Supply Chain Management users

Environment: PeopleSoft Financials 8.8 AP, PO, GL and CA , PeopleTools 8.51 - Application Designer, PeopleCode, Application Engine, PIA, Component Interface, ExceltoCI, Process Scheduler, PS Query, Crystal Reports, SQL, Oracle 10g, HPQC and Quest stat.

Confidential

PeopleSoft Technical Consultant

• Confidential established in 1915, is a 4 billion a year not-for-profit health care
• organization situated Detroit Michigan. Confidential is rated among the leading health care providers in the USA
• and their flagship Henry Ford Hospital is recognized for clinical excellence and innovation in the many
• specialty fields. Confidential provides health insurance and health care delivery, including acute, specialty, primary
• and preventive care services backed by excellence in research and education. Confidential operate a network of 7
• hospitals and nearly 300 medical centers in South Eastern Michigan.
• Analyze the business requirements and needs of the various customer groups and create a flexible custom
• software that will allow Supply Chain Management to administer contracts in a secure and user friendly

Responsibilities:

• Design and develop Oracle/PeopleSoft based custom software for managing the legacy contracts for Supply Chain Management at HFHS
• Analyze the user requirements, Evaluate multiple design options and recommend a preferred approach
• Design and develop prototypes for maintaining contract data specific to different contract groups
• Develop a custom notification process for contract expiry and renewals
• Develop custom pages and components in Oracle/PeopleSoft using People Tools
• Develop support documentation to facilitate ongoing support of the applications
• Develop user documentation to facilitate implementation of the new functions developed
• Work with the IT teams/users to fine tune the application and make recommendations
• Participate in peer/code/design reviews to verify that quality standards and functional/technical requirements are met
• Make recommendations on functional and technical improvements to the application

Environment: PeopleSoft Financials 8.8 AP, PO, GL and CA , PeopleTools 8.47 - Application Designer, PeopleCode, Application Engine, PIA, Component Interface, ExceltoCI, Process Scheduler, PS Query, Crystal Reports, SQL, Oracle 10g, HPQC and Quest stat.

Confidential

PeopleSoft Techno Functional Consultant

• Aon Corporation purchased Hewitt associates.
• Aon Corporation is a provider of risk management services, insurance and reinsurance brokerage, human
• capital and management consulting, and specialty insurance underwriting.
• Hewitt's operations were merged with some elements of Aon's consulting arm to become a new subsidiary of
• the Aon Group called Aon Hewitt. As part of this both the financial systems needs to merged and maintained
• as a single entity.

Responsibilities:

• Supported the AP, PO, GL, CA, BI and AR modules for all Testing cycles
• Implementing the French language for Quebec customers
• Developed Custom Contract email notification process
• Addressed technical, Configuration and functional issues on the finance modules for unit , QA and UAT test cycles
• Supported the security related issues
• Review of Technical Design documents and Test plans
• Problem Solving on existing modules / Functionality / Programs

Environment: PeopleSoft Financials 9.0 AP, PO, GL, CA, BI and AR , PeopleTools 8.49 - - Application Designer, PeopleCode, Application Engine, PIA, Process Scheduler, PS Query, SQR, Crystal Reports, SQL, DB2, AQT, HPQC and Quest stat.

Confidential

PeopleSoft Techno Functional Consultant

• Confidential is one of the world's leading HR consulting and outsourcing companies. Hewitt manages their
• Financial business processes using PeopleSoft that includes all the Financial modules GL, AP, PO, AM, AR,
• BI, CA and PC. This project is to replace their existing PeopleSoft 8.4 system and to merge into the India's
• System which was already in 9.0.

Responsibilities:

• Supported the AP, PO, GL, CA, BI and AR modules for all Testing cycles and defect resolution
• Design and Development of Vendor Conversion, Item Conversion from 8.4 to 9.0
• GL Conversion process to move the Ledger data from 8.4 to 9.0 using sqr
• Developed Custom Accrual process
• Addressed technical, Configuration and functional issues on the finance modules for unit , QA and UAT test cycles
• Supported the security related defects
• Review of Technical Design documents and Test plans
• Problem Solving on existing modules / Functionality / Programs

Environment: PeopleSoft Financials 9.0 AP, PO, GL, CA, BI and AR , PeopleTools 8.49 - - Application Designer, PeopleCode, Application Engine, PIA, Process Scheduler, PS Query, SQR, Crystal Reports, SQL, DB2, AQT, HPQC and Quest stat.

Confidential

PeopleSoft Techno Functional Consultant/Team Lead

• This project is to integrate the financial systems of AIX into Hanover's Financial System by building a
• Sub-ledger in Hanover's financial system. This sub-ledger will have the detailed transactional information
• that will be used for AIX reporting. From this sub-ledger all the information will be posted to Hanover's main
• ledger through a customized summarization process. Informatica will be used as an interface process to load
• and retrieve information from Hanover's system to AIX.

Responsibilities:

• Gathering requirements in support of the Integration
• Understood the existing financial systems of both the Hanover and AIX
• Completing the feasibility study of the Hanover's systems to support the integration related to creating a new sub-ledger and adding more chart fields to the system.
• Developing Functional Specification Document and Technical Specification Document.
• Developing the end to end overall integration of AIX GL system into Hanover GL system by creating a sub-ledger within PeopleSoft and using ETL as PeopleSoft inbound/outbound interface.
• Developing and testing a sqr program which will summarize the financial information from the sub-ledger to the main ledger.
• Developing the end-user training and preparing training manuals.
• Prioritized and assigned tasks to the team on a scheduled basis
• Co-ordination with the clients and off-shore team involving regular meetings and weekly status updates
• Ensuring and implementing the deliverables in time

Environment: PeopleSoft Financials 8.8 sp1 GL, AP , PeopleTools 8.45 - Application Designer, PeopleCode, Application Engine, PIA, SQR, SQL, Oracle 9i, and TOAD.

PeopleSoft Developer/Team Lead

• Hanover Insurance Group is a successful Insurance Company having main line of business in Property and
• Financials PeopleSoft Product at Hanover ranges from General Ledger, Accounts Payables, Asset
• Management and Purchasing. As Part of this we were involved in new Enhancements , Integrations,
• Production Support, User Support, Customizations, Patch Implementations and Server Administration. The
• Hanover Management also involves Keane in participating and executing key initiatives with regards to

PeopleSoft Initiatives.

Responsibilities:

• Gathering requirements from business in support of or as an enhancement to existing systems
• Developing Functional Specification Document and Technical Specification Document for Code development
• Developed the end to end overall design for the General Ledger archiving process using Application Engine and SQR.
• Implementation of AM automated interface using Excel to CI functionality as per Hanover requirements
• Supported the implementation of Common Payer project which involves co-ordination with Informatica and mainframe systems
• Implementation of Asset Mass maintenance program as per Hanover requirements
• Designed and developed row level security process as per Hanover's requirements using customized application engine program
• Supporting the GL and AP application that includes Journal Edit and post, pools summarization, Journal generator, Ledger Balancing, Voucher build, Voucher Post, Payment Post and Paycycle processing
• Involved in providing maintenance and production support to GL, AP, AM and PO modules
• Problem Solving on existing modules / Functionality / Programs
• Modifications of existing functionality to fix the reported problem
• Involved in applying Maintenance Packs to PeopleSoft Financials 8.8 SP1
• Involved in Infrastructure upgrade that includes Oracle, Linux and Cobol Compiler
• Running the compare reports
• Fine-tuning the code for better performance, Tune SQL queries based on Cost
• Providing Clarification/Information on Request on existing Applications / Data
• Development of documentation for the existing or new modules
• Supporting the User acceptance testing
• Planned and assigned assignments for the team on a scheduled basis
• Co-ordination with the business involving regular meetings, status updates
• Involved in Multiple projects and delivered on schedule
• Proposed the effective solutions to make best use of the test environments
• Supporting the users with the Unit Testing and Regression Testing in the Testing Environment
• Supporting the monthly releases for each enhancement and bug fixes.

Environment: PeopleSoft Financials 8.8 sp1 GL, AP, AM and PO , PeopleTools 8.45 - - Application Designer, PeopleCode, Application Engine, PIA, Process Scheduler, PS Query, SQR, Crystal Reports, SQL, Oracle 9i, and TOAD.

PeopleSoft Developer

This transition happened in two phases. As a part of this Hanover has to transfer all its Life related financial information to Goldman Sachs. This includes all the Historical and current transactional data should be moved from Hanover's General Ledger into the Goldman Sach's General Ledger system.

Responsibilities:

• Gathering requirements related to Goldman Sachs General Ledger system.
• Developed the Functional Specification Document and Technical Specification Document to complete the transition.
• Developed the end to end overall PeopleSoft design to transfer General Ledger transactional data
• Developed the process to extract data using App Engine and File Layout to flat files.
• Developed Data Mover Scripts to export GL transactional data as per the client requirements into DAT files
• Developed Data Mover Scripts to import GL transactional data into the PeopleSoft tables
• Involved in testing and post-transition tasks with the Goldman Sachs.

Environment: PeopleSoft Financials 8.8 sp1 GL , PeopleTools 8.45, Data Mover, SQL and TOAD