Candidates About

 

Milind Sawant

----------------------------------------------------------------------------------------------------------------------------

SUMMARY

12 Years of Experience as PeopleSoft Techno Functional Consultant in Analysis, Implementation, Design, Development, Upgrade, Production Support and Testing of PeopleSoft Finance and PeopleSoft HCM applications.

 

¨        12 years of progressive technical experience in Customization, Conversions, Interfaces and Implementation of PeopleSoft 9.2/9.1/9.0/8.9/8.8 Finance (GL, AM, AP, AR, PO, Expense) and HCM (Core HR, Time & Labor, Benefits Administration, Base Benefits and e-modules.)

¨        Experience with all PeopleSoft developing tools which includes PeopleCode, App Engines, Application Packages, XML BI Publisher, SQR’s and others.

¨        Experience in building pages using Fluid User Interface

¨        Experience in Batch Processing, Upgrade, Migration and Interfaces Development.

¨        Extensive experience in Integration, well versed in Web Services and Application Messaging

¨        Acquired in-depth knowledge of PeopleSoft modules working on production support.

¨        Developed various interfaces using applications such as SQR’s and Application Engines.

¨        Experience in building new components and customizing existing applications.

¨        Proficient in all phases of the systems development life cycle including requirements definition, data conversion, data mapping, system implementation, system testing and acceptance testing.

¨        Extensive experience in reporting using various reporting tools such as SQR’s, Crystal Reports and PSQuery and Xml Publisher.

¨        Customized various PeopleSoft objects according to the client’s requirements.

¨        Documented the processes developed and updated for future references.

¨        Efficient team player, ability to multitask with excellent communication and interpersonal skills.

 

TECHNICAL SKILLS                                                                                                                                                  

 

ERP	PeopleSoft 9.2/9.1/9.0/8.9/8.8
PeopleSoft Tools	PeopleTools 8.55/8.54/8.53
PeopleSoft HCM Modules	HR, Benefits Admin, Time & Labor, Base Benefits and e-modules
PeopleSoft Finance Modules	GL, AM, AP, AR, PO, Expense
Reporting Tools	PS Query, Crystal Reports, Xml Publisher, SQR
Debugging Tools	SQL Trace, PeopleCode Debugger, Application Engine Trace
Integration Tools	Web Services, Application Messaging, File Layout, Component Interface
Databases	Oracle 11g/10g, SQL Server,DB2, Sybase
Data Management & Batch Processing Tools	Data Mover, Application Engine, Process Scheduler
Administration Tools	Portal Administration, Object Security, Workflow Administration and Query Security
Operating Systems	Windows 95/98/2K/NT/XP, UNIX
Programming Languages	Java, Visual Basic

 

 

 

 

 

 

 

 

 

PROFESSIONAL EXPERIENCE:

 

Department of Sanitation, NYC, NY                                                                                                        Jun’ 13 – Oct’17

Sr. PeopleSoft Technical Consultant

PeopleSoft Finance and HCM 9.1 to 9.2 Upgrade

 

Technology Stack:

PeopleSoft  FSCM 9.2 (GL, AM, AP, AR, PO), Oracle, Component Interface, Application Engine, PeopleCode,, XML BI Publisher

PeopleSoft HCM 9.2 (Core HR, Absence Management, Recruitment, Safety & Training), Web Services, Application Messaging, Approval Workflow, Fluid UI, Interaction Hub

Role & Responsibilities: 

¨        Integrated PS FSCM and PS HCM with custom Java application (SMART) using Inbound and Outbound web services.

¨        Developed custom Application Messages to integrate HCM and FSCM applications

¨        Developed custom Fluid pages in PS HCM application.

¨        Developed application engine interface to load assets from legacy SCAN system to PS FSCM 9.2

¨        Developed application engine interface to load citywide NYCAPS employee data into PS HCM 9.2. Developed interface for both one time and incremental load.

¨        Developed application engine interface to load CityTime absence data into PS HCM 9.2.

¨        Developed application engine interface to load eligible candidates from legacy DCAS system to PS HCM 9.2

¨        Developed several custom XML BI Publisher reports for PS HCM and PS FSCM applications

¨        Involved in comparison between 9.2 demo and Copy of production for upgrade.

 

AIMCO, Denver, CO                                                                                                                                 Mar’ 12 – May’13

Sr. PeopleSoft Technical Consultant

PeopleSoft Finance 8.9 to 9.1 Upgrade

 

Technology Stack:

PeopleSoft v 9.1 (GL, AM, AP, AR, PO), Oracle, Component Interface, Application Engine, PeopleCode, Workflow, Crystal Reports

Role & Responsibilities: 

¨        Responsible for categorizing the PS objects into RICEW (Reports, Interface, Conversion, Enhancements and Workflow) objects.

¨        Developed several custom SQRs for AM, AP, AR and GL modules

¨        Involved in comparison between 8.9 demo and Copy of production to analyze the technical environment.

¨        Involved in analyzing the retrofitting work and retrofitted several objects required.

¨        Involved in analyzing the existing technical environment (FSCM) and filter out the unnecessary objects.

¨        Created Technical Design Specifications for interface, customization, data conversion and reports.

¨        Unit and Integration Test Plan Preparation prepared Test Plans and Test Cases

¨        Involved in resolving the upgrade issues from PeopleSoft 8.9 to v9.1

¨        Involved in upgrade and customization of SQR's.

¨        Analyzed and assessed organizational requirements, in order to successfully develop and customize Workflows for PO approval, Payment approval, monitor overdue accounts.

¨        Designed and configured 9.1 AWE (Approval Workflow Engine) to set up multi-level PO approvals based on the amount and PO type (Asset, Expense)

¨        Designed and Developed Custom AP workflow for Vouchers with different origins.

¨        Designed and developed user test scenarios, test scripts and test data

¨        Documented Functional Design specifications and Technical design documents for the business requirements.

¨        Involved in setting up the delivered Excel to CI utility to load the data into Asset Management staging tables, AP ship to Locations.

 

                                                                                                                                                                                      

Toyota Motors, Erlanger, Kentucky                                                                                                 Sep’ 11 –Feb’ 12

Sr. PeopleSoft Techno-Functional Consultant                                     

PeopleSoft Finance 8.9 to 9.1 Upgrade

 

Technology Stack:

PeopleSoft v8.9 to v9.1 (GL, AM,. AP, AR, PO, Expense), Xml Publisher, Oracle, Component Interface, Application Engine, PeopleCode, Workflow.

Role & Responsibilities: 

¨        Developed Metadata documents for records to help upgrade project team understand record changes in V8.9 and V9.1

¨        Documented Design specs and Technical Specs for the custom created modules.

¨        Extensively used Change Assistant to apply Patches, Fixes and Bundles.

¨        Developed multiple AP Extracts for multiple countries with details like Voucher and payment for a particular day.

¨        Coordinated development and testing efforts between functional, technical and user groups.

¨        Designed and developed an interface to load the bank details of Global Employees. The bank information comes in the form of flat file and custom programs loads the information in Expense related tables.

¨        Involved in troubleshooting AR_UPDATE process, which is used to process and update customer balance and history information, corresponding item information and item activity.

¨        Customized the Application Engine AP_PAYSELECT so that it picks up the vouchers only after the accounting entries have created.

¨        Designed and developed user test scenarios, test scripts and test data

¨        Developed SQR programs to convert customer set up data from legacy system to PeopleSoft in Accounts Receivables.

¨        Developed Payment Interfaces to load payment data into PeopleSoft Receivables from bank transaction files. Designed and implemented payment-invoice matching algorithms to automate payment matching process in PeopleSoft Receivables.

 

 

Miami Dade County, Miami, FL                                                                                                             July’ 10 – Aug’11

Sr. PeopleSoft Technical Consultant

 

Technology Stack:

PeopleSoft Upgrade and Re-implementation 9.0/9.1(Core HR, Time &Labor, Security), Oracle, Component Interface, Application Engine, PeopleCode, Workflow, Application Messaging, Integration broker, People Tools 8.52., Crystal Reports

Role & Responsibilities:

¨        Used People Tools in carrying over the customizations from the existing version to new upgrade version. Extensively used Application Designer for creating new objects, modifying the existing customizations and bringing them over successfully.

¨        Developed a SQR’s process which creates hierarchy for employees and contractors based on supervisor to create an outbound file.

¨        Worked on various inbound and outbound interfaces based on business requirements.

¨        Worked on customizations for delete user, add user, clone user which uses a component interface and application engine for security.

¨        Modified the MSS termination transactions for only voluntary terminations and added international logic.

¨        Used PeopleSoft delivered Time and Labor rules and also developed and custom Time and Labor rules which included Holiday, Weekly Threshold, Daily Threshold, Day Breaker Rules.

¨        Developed outbound interfaces for third party vendor’s, which consisted of employee benefit related data.

¨        Fit and Gap analysis/impact of the existing customizations to that of the functionality of the new release.

¨        Designed Technical Specifications for both Online and Batch/Interface Programs in client specified format based on the functional requirements

¨        Modified existing SQR’s, SQC’s, Views to incorporate and implement the changes.

¨        Performed design of reports for the HR, Payroll and Benefits Administration modules using SQR, PS/Query and Crystal Reports based on organizational needs.

¨        Retrofitted custom SQR reports for payroll.

¨        Analyzed the customizations to the delivered SQR reports and worked with the functional analyst to determine if the customizations need to be reapplied or retired.

 

 

Commonwealth of Massachusetts, Boston, MA                                                                                  Aug’09 – Jun’10

Sr. PeopleSoft Technical Consultant

 

Technology Stack:

PeopleSoft Upgrade and Re-implementation 9.0/9.1(Core HR, Time & Labor, Benefits, MSS), Sybase, Component Interface, Application Engine, PeopleCode, Workflow, Application Messaging, Integration Broker, People Tools 8.52., Crystal Reports

Role & Responsibilities:

¨        Worked on integration broker to send Accounting line data PAYROLL_ACCTG_TRANSACTION from HR to Finance.

¨        Created a Component Interface to insert a row into UHC_NEW_HIRE Component when an employee is rehired.

¨        Retrofitted PAY003 (Online Check Print) based on UHG requirements.

¨        Added logic for Post job save Processing.

¨        Worked on retrofitting of custom sqrs like TALX Employment Verification Interface

¨        Worked on Integration broker configuration to receive DEPT_SYNC data from HR to Finance.

¨        Retrofitted and migrated Time and Labor rules from v9.0 to 9.1.

¨        Involved in creating an Application Messaging Programs, in order to send an email to the Benefits Administrator, Payroll Administrator when a new employee is hired.

¨        Adhere to SDLC steps of Plan, Design, Develop, Test and Migration of the projects.

¨        Worked on reapplying the customization in ESS Timesheet.

¨        Retrofitted a lot of custom sqr’s Census Report, Anniversary Report and Anniversary Notification to Managers for Table changes in 9.1.

¨        Developed, unit tested programs using SQR, Application Engine, Component Interface and Integration Broker for HR, Benefits.

¨        Developed Interfaces for Payroll, such as Deduction Calculation: this SQR generates deduction codes for each employee’s benefit plans elected for that particular year; these deduction codes are used by the payroll department to process (Benefits Billing Process) the pay of employees.

¨        Created Workflow in order to send information as a Notification when a new employee hired into the company.

¨        Documented Unit testing scenarios.

 

 

Milacron, Cincinnati, OH                                                                                                         Apr ’09 – July ‘09

Senior Technical Consultant

PeopleSoft Finance 8.9

 

Technology Stack:

PeopleSoft v8.9 (GL, AM, AP, AR, Cash Management), SQR, Xml Publisher, Workflow, Component Interface, Application Engine, PeopleCode

Role &Responsibilities:

¨        Responsible for preparing technical design document, TDD review, code walkthrough, TDD sign off and formulating the design for interfaces and Conversions.

¨        Involved in development/enhancement, support, conversion, security and interface design.

¨        Developed various PO and AP reports for as part of the roll out.

¨        Developed custom AP application to load the service invoices into AP. The custom App Engine makes use of file layouts to read the data, process and load Voucher staging tables. VCHRBLD loads the AP voucher tables during nightly batch process.

¨        Modify the application engine to communicate with employees the payment made during the day as well as notify prepay auditors about the expense reports due for approval by 15 working days.

¨        Coordinated development and testing efforts between functional, technical and user groups. 

¨        Worked on requirement gathering, documenting process flow and configuring the Cash Management module and related configuration of AP and GL modules.

¨        Lead the business users through design workshops and validation, configuration, testing, and deployment cycles.

¨        Set up accounting templates in Cash Management for various accounting events to create accounting entries to send to GL.

¨        Set up AP, Cash Management Banks for EFT, Bank Transfer and their Transfer Templates.

¨        Configured for Bank Reconciliation (Semi and Automated) and set up the rules to reconcile the Bank Statements with Payables and Receivables and other external transactions and Book to Bank Reconciliation.

¨        Integrated AP, AR and Cash Management with external banks and configured settlement through Financial Gateway.

¨        Set up Workflow to approve the Settlements and created security Roles and Permission lists for Cash Management Modules.

¨        Set up Cash Position Trees and Cash Position Worksheets to analyze the cash positions. Created new queries and reports to view the Opening and Closing Balances and total EFT, Check, ACH amounts of each Bank account.

¨        Set up process to load the Bank Statements in BAI2 format to Cash Management, Automated Accounting Process and Fiscal Period end close.

¨        Support day-to-day operations.

 

 

Neustar Inc, Sterling, VA                                                                                                     Aug’08 – Mar’09

PeopleSoft Finance Consultant

 

Technology Stack:

PeopleSoft Finance 8.9 (PO, AP, AR, GL), Application Engine, Component Interface, Application Messaging, PeopleCode, SQR

Role &Responsibilities:

¨        Responsible as a primary contact for all production support related issues in FSCM system.

¨        Handling the urgent production support activities as and when required.

¨        Worked on several enhancements for Account payables, Account receivables and GL.

¨        Developed Conversion program using Application Engine and Component Interface for loading open Vouchers from legacy system into PeopleSoft Accounts Payable.

¨        Written Technical Design Specs for all of the Interfaces and Reports those were customized or newly developed.

¨        Responsible for requirement gathering, preparing the test cases and coordinating with users.

¨        Designed developed a custom SQR program to load billing data from mainframe application in to PeopleSoft billing interface tables.

¨        Worked on AR_DUNNING Application Engine process and performed troubleshooting and fixed issues.

¨        Modified POPO005.SQR to get the line and Header comments printed properly.  Modified the program to print the Logo and Signatures.  Helping user in overcoming issues with PO Build Process.

¨        Customized AR Aging reports like AR30001, 30002 as per the User Requirements.

¨        Developed Test scripts for additional processes in PS AR such as Pending Items creation, Receivables update, Deposit Entry and Payment application through worksheets.

¨        Customized queries inside BIIVCEN.sqr when it's extracting from extract invoice tables before printing crystal reports like BIPRNT00 in Billing.

 

 

APS--Arizona Public Services, Phoenix, AZ                                                                              Jun‘06 – Jul ‘08

PeopleSoft Finance 8.4/8.9 (Upgrade and Customization)

 

Technology Stack

SQR, PeopleCode, Application Engine, Component Interfaces, SQL, PS/Query, Query Manager, Sybase

Role &Responsibilities

¨     Responsible for development work for this upgrade project.

¨     Closely interacted with the customer and business analysts during fit-gap analysis between the as-is and to-be systems.

¨     Was involved in analysis of compare reports and identification of customizations to the existing system.

¨     Was involved in providing valuable inputs in preparation of the technical design documents for multiple development work and the retrofitting of existing customizations.

¨     Resolved several challenging issues encountered during the multiple phases of project execution. 

¨     Was accountable for the design and development of several critical deliverables.

¨     Designed the interfaces between AP Banks and Cash Management for Bank Reconciliations and configured AP External Banks for Checks/ACH/Positive pay.

¨     Customized process and reports in Application Engine, PeopleCode, Component Interface, Integration Broker, SQR, Crystal Report, XML Publisher, DMS and SQL.

 

 

St. Petersburg University, Tampa, FL                                                                                                Feb’05– May’06

Implementation of HR 8.8

 

Technology Stack

PeopleSoft HCM 8.8, HR, Payroll, Time & Labor, Benefits, SQR, PeopleCode, SQL, Oracle, Windows, PS/Query, Query Manager, Query Viewer and Toad.

Role & Responsibilities

¨     Responsible for Implementation of HCM Modules Payroll, Benefits, Time and Labor.

¨     Wrote SQR reports right from Scratch in Benefits.

¨     Modified the existing interface reports using SQR’s to interface Benefits with AR.

¨     Designed, implemented strategy for loading data from Legacy HR system into PeopleSoft HR core tables.

¨     Involved in Customization of Health Plan, Disability Plan, and Life & AD/D plan Benefit panels in Benefits.

¨     Wrote Interface reports using SQR’s to interface Payroll with GL.

¨     Created Pay Groups for employees with different sets of earnings benefits and attached PeopleCode in the record definitions and at panel levels for validations.

¨     Wrote conversion reports using SQR’s for mapping and dumping data from Legacy Systems into the existing system.