We provide IT Staff Augmentation Services!

Peoplesoft Financials/scm & Hcm Techno Functional Consultant Resume

NewyorK

PROFESSIONAL SUMMARY:

  • Total 13+ years of PeopleSoft Experience.
  • Experience in leading Onsite/Offshore model.
  • Post Production Support for PeopleSoft Applications.
  • Experience in Analysis, Designing, Developing, Testing, and Integrating modules.
  • Extensive experience with PeopleSoft Implementations and Upgrades.
  • Working knowledge of PeopleSoft Portals, Java, C/C++, Visual Basic, XML, Web Services Unix/Linux, Object Oriented Design and Patterns.
  • Excellent communication and presentation skills.
  • Ability to be an effective team player, work under time constraints and easily adaptable to new environment.

TECHNICAL SKILLS:

PeopleSoft Development Tools: PeopleTools 8.x, PeopleCode, Application Engine, Security,PS Query

Modules: GL, AP, AR, Billing, Asset Management, Purchasing, Order Management, Inventory, Expenses, Project Costing,eProcurement,Contracts, Budgeting, Payroll, Benefits, Time and Labor.

PeopleSoft Reporting Tools: SQR, Crystal Reports, PS/Query & nVision.

PeopleSoft Integration Tools: Integration Broker, Component Interfaces, WorkFlow .

Other Programming Languages: HTML5,CSS,PL/SQL, SQL, Java, C/C++, COBOL, IBM Assembler 370, JCL, PASCAL, VB6, VB.net and Shell Scripting

Other Tools: Visio

RDBMS: Oracle 11.x/10.x/9.x and MSSQL Server 2000.

Operating Systems: UNIX, Windows NT/Win2K.

WORK EXPERIENCE:

Confidential, Newyork

PeopleSoft Financials/SCM & HCM Techno Functional Consultant

Environment: PeopleSoft 9.2/PeopleTools 8.55,(GL, AR, AP, Inventory, Purchasing,Billing,Order Management,AM,eProcurement,Project Costing,Payroll, Benefits, Time and Labor ), Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Oracle 11g,Unix.

Responsibilities:

  • Worked in Onsite/Offshore Model and lead a team of 3 Developers in Offshore Location.
  • Implemented security by creating User Profiles,Roles and Permission Lists.
  • Interacted with Business Users and prepared the Functional Specification Documents.
  • Worked as part of 24/7 Production Support Team.
  • Have exposure to PeopleSoft HCM - Base Benefits, Benefits Administration.
  • Extensively worked on the inbound/outbound interfaces between PeopleSoft and third party systems using Application Engines, File Layouts and CI.
  • Extensively worked on the inbound/outbound interfaces between PeopleSoft and third party systems using Application Engines, File Layouts and CI.
  • Modified custom Annual Enrollment statement program (BAS004) as per customer specification.
  • Developed an Application Engine to coordinate inter unit transfers to handle Inventory.
  • Modified PeopleCode in Integration Broker in PeopleSoft inventory while doing Express Issues.
  • Updated the PO DISPATCH Integration Broker process to send additional fields to third party system.
  • Created multiple BI Reports and trained End Users to create their own reports.
  • Updated CNTPAY01 Contract Projected Payment SQR Process to include the updated Business Logic in making the payments.
  • Updated Pre Calculation Audit Report to get additional Employee Data.
  • Developed Component Interfaces to use them in Excel To CI to upload the Cost Profiles.
  • Customized Application Engine program in Expenses.
  • Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
  • Extensive experience in People Tools, Reporting Tools and integration methodologies.
  • Developed a report to list labor, material and service costs in Project Costing.
  • Extensively worked on performance tuning of SQL in SQR and Application Engines.
  • Custom developed an SQR to list the daily transactions that effect inventory.
  • Converted Job Data, Benefits Data which included Dependents, Health Benefits, Life Benefits, Disability Benefits,etc using SQR’s.
  • Addressed production issues related to HR, Payroll, Benefits and Time and Labor.
  • Custom wrote SQR Reports to print various Open Order Reports.
  • Developed a SQR Process from scratch to load flat files into PeopleSoft AM interface tables.
  • Developed an SQR to list the work order material to be dispersed in Inventory.
  • Custom wrote an Application Engine to load data from a flat file into Interface tables in Project Costing.
  • Custom wrote several SQRs to print sales reports in Billing.
  • Custom developed an nVision Budget vs Actual Report along with Drilldown to check details at Account Level.
  • Involved with setting up default options for GL Processing.Creating and processing journals.Importing VAT Data (set up data and Journal Data).
  • Processing multiple currencies. Preparing revalue account balances, translate ledger tables. Defining translation steps and preparing with ledger process.
  • Custom developed a Template in Excel using VB to validate the Data and generate a clean file which should be loaded without any format errors.
  • Developed multiple Component Interfaces to use them in ExceltoCI for loading data into the tables.
  • Extensive experience on STAT used for Project Migration.

Confidential, Kansas City

PeopleSoft Financials/ SCM Techno Functional Consultant

Environment: PeopleSoft FSCM 9.2/PeopleTools 8.54((GL, AR, AP, Inventory, Purchasing,eProcurement ), Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Oracle 10i, Unix.

Responsibilities:

  • Interacted with the Business Users to understand the requirements and presented the Functional Specification Documents.
  • Retrofitting of objects as part of FSCM 9.1 to 9.2 Upgrade.
  • Performed Fit Gap Analysis as part of the Upgrade Process.
  • Bug fixing and object migrations to the upgraded environments
  • Analyzing compare reports and clean up the data and orphan objects.
  • Transformed the business requirements in Inventory and Purchasing Modules to resources.
  • Developed CIs and used ExceltoCI to load data from legacy systems to PSOFT.
  • Prepared the interface strategy that also handled the ‘Region-code’ Sub-CST-Qualifier to send out notifications to users whenever a new ‘Region-code’ was added.
  • Custom wrote an SQR to generate a flat file to be sent to the bank for garnishment vouchers.
  • Custom developed an nVision Budget vs Actual Report along with Drilldown to check details at Account Level.
  • Developed an SQR to get the Procurement Credit Card Transaction details.
  • Developed an SQR to provide the PO’s where Items are Substituted.
  • Customized the INS7000 as part of getting the Inventory Usage.
  • Custom wrote an Application Engine to update the receipt quantity to Voucher Quantity for receipts older than 9 months as part of avoiding the receipts from not accruing.

Confidential, Hartford

PeopleSoft Financials/SCM Techno Functional Consultant

Environment: PeopleSoft FSCM 9.1/PeopleTools 8.52((GL, AR, AP, Grants, Inventory, Purchasing,eProcurement ), Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Oracle 10i, Unix.

Responsibilities:

  • Interacted with the Business Users to understand the requirements and presented the Functional Specification Documents.
  • Transformed the business requirements in Inventory and Purchasing Modules to resources.
  • Set up the Advance Shipment Receipt process and trained the users on how to use it.
  • Created multiple queries for the Business Users
  • Custom wrote an SQR to get the usage of items by Department.
  • Customized AP Match Exception Crystal Report to take out some of the exceptions from the report.
  • Customized the Receipt Accrual Process in Accounts Payable.
  • Worked on Integration with Project costing and Customer Contracts modules. Worked on performance issues CA BI INTFC.
  • Developed Grants Vs Billing reports using Pivot charts in BI Publisher by Grants Bill by IDs on PROJ RESOURCE.
  • Custom Developed an Application Engine to send a file for positive payments.
  • Developed an Application Engine to load data from flat file into Procurement Tables.
  • Customized the process with the new tax rates while creating Journal entries in Payroll.
  • Customized the Process to provide the check details along with Pay sheet information in Payroll.

Confidential, Newyork

PeopleSoft Techno Techno Functional Consultant

Environment: PeopleSoft 9.1/PeopleTools 8.52, (GL, AR, AP, Inventory, Purchasing,Billing,Order Management,AM,eProcurement,Project Cost Management,Payroll, Benefits, Time and Labor ) Application Designer, People Code, Application Engine, PS/Query, Crystal Reports, SQR, Component Interface, Oracle 10i,Unix.

Responsibilities:

  • Interacted with the Business Users to Understand the Requirements and took part in preparing the Business Requirements Documents.
  • Interacted with the Business Users to understand the requirements and presented the Functional Specification Documents.
  • Retrofitting of processes and objects as part of FSCM 9.0 to 9.1 and 9.1 to 9.2 Upgrades.
  • Lead an onsite/offshore team and delivered the quarterly releases.
  • Provided training to end users on how to use the Peoplesoft application
  • Provided multiple Visio presentations for Senior Managers.
  • Custom Developed Application Engine to upload Benefits Data.
  • Custom wrote an SQR to provide the Payroll Summary by Country.
  • Custom developed a Template in Excel using VB to validate Data and generate a clean file which should be loaded without any format errors.
  • Created multiple nVision Reports for regulatory reporting.
  • Developed shell scripts for file transfers between partner systems.
  • Developed multiple Application Engines to send Data Feed to various other Groups within Citi.
  • Extensively worked on Peoplecode as part of the Portfolio Maintenance Process.
  • Developed multiple reports to check the Data Quality.
  • Developed Pages to show the status of the Feeds being sent to other groups.
  • Developed the Login screen as per Citi standards..
  • Conducted Sessions to train the End Users to make them understand the system.
  • Production Support team member to support users. Resolved issues like missing sellers, truncation of amounts, loan numbers, failure of interfaces, processes, reports, etc. Resolved issues on priority basis.
  • Extensively worked on performance tuning of SQL in SQR and Application Engines.
  • Developed multiple Component Interfaces to use them in ExceltoCI for loading data into the tables.
  • Developed Workflow as part of the Data Signoff process.
  • Designed and developed data conversion programs to convert and load legacy data into PeopleSoft.
  • Upgraded GCBC from Solaris 8 to Solaris 10.Taken care of the changes to be done by Application Developer. Changed multiple files on the Web bank server as part of it. Used Hermes Tool for migrations.
  • Compiling and clean up of SYSAUDIT, DDDAUDIT reports.
  • Involved in Pre and post upgrade activities
  • Bug fixing and object migrations to the upgraded environments
  • Analyzing compare reports and clean up the data and orphan objects.
  • Extensive experience on STAT used for Project Migrations.

Confidential, Kansas City, Kansas

PeopleSoft HCM,Financials, SCM & EPM Consultant

Environment: PeopleSoft Financials/SCM 8.4, PeopleTools 8.43 (GL, AR, AP,AM, Project Costing

Responsibilities:

  • Prepared Techno Functional documentation for various functions based on business requirements.
  • Developed multiple monthly expense check and Income reports using nvision.
  • Involved in Development and Testing of Interfaces, Online Customizations and Conversions using SQR’s.
  • PeopleCode, Component Interfaces and Application Engine for PeopleSoft HR, Benefits and Payroll modules.
  • Modified the OM BACKGRND Application Engine to resolve issues during Post Production.
  • Developed an Application Engine to coordinate inter unit transfers to handle Inventory.
  • Modified PeopleCode in Integration Broker in PeopleSoft inventory while doing Express Issues.
  • Coordinated with end Users and modified the system as per their Usage.
  • Extensively worked on performance tuning of SQL in SQR and Application Engines.
  • Custom developed an SQR to list the daily transactions that effect inventory.
  • Developed a report to get the Cancelled Requisitions in Inventory.
  • Developed Application Engine to execute the DTS Packages and load the items from various vendor tables into staging tables.
  • Custom wrote SQR Reports to print various Open Order Reports.

Confidential, Troy, Michigan

PeopleSoft HCM,Financials & SCM Techno Functional Consultant

Environment: PeopleSoft Financials/SCM 8.4, PeopleTools 8.43,(GL, AR, AP,AM, Project Costing, Inventory, Expenses, Order Management) Application Designer, PeopleCode, Application Engine, PS/Query, SQR 6.0/4.x/3.x, SQC, nVision, SQL, Oracle 9I, Crystal, HP-UNIX.

Responsibilities:

  • Part of the upgrade team for upgrade of system from 7.5 to 8.4.
  • Worked with DDDAUDIT and SYSAUDIT reports in analyzing the Orphaned data redundancy and identifying the inconsistencies and orphaned objects.
  • Worked on TAM component interfaces that help you load data from your existing system into PeopleSoft Enterprise
  • Talent Acquisition Manager Integration’s tables. Use the Excel to Component Interface utility with the component interfaces to populate the tables.
  • Ran Compare Reports and identified the objects that had to be reapplied.
  • Developed an Application Engine to coordinate with a third-party demand forecasting software application for Inventory Planning.
  • Custom wrote an Application Engine and generated a flat file pulling out FSIs for a particular physical year in GL.
  • Customized the OMBILL SQR process as per the business requirements.
  • Reapplied PeopleCode, application engines, sections, actions, PeopleCode, SQL’s, Queries, Pages, Components, SQRs and Crystal Reports.
  • Developed an Application engine to interface Asset management and General Ledger Module.
  • Used Process Scheduler for creating SQR reports for the purpose of General Ledger reports.
  • Created nVision, Crystal reports.
  • Developed search capability on location based on certain criteria.
  • Worked on the Depreciation calculation and accounting entry calculation using SQR.
  • Automated the business processes using workflow by creating roles, rules and routings thereby sending the right information to the right person at the right time.
  • In Asset Management involved in applying PeopleSoft patches.

Hire Now