PROFESSIONAL SUMMARY:

• 11+ years of experience in Software Industry with comprehensive knowledge through all phases of software development lifecycle from requirement analysis to maintenance of the project.
• 7 years’ experience in all phases of SDLC on PeopleSoft using PeopleTools/SQR
• Has Experience in Oracle - PeopleSoft EPM and Finance.
• Primary Technical Skills: Integration Broker, Approval Workflow Engine, Application Engine, Component Interface, XML Publisher, Excel to CI, PS Query, Process Scheduler, Data Mover, Tree Manager, Query Manager and SQR.
• Primary EPM & FSCM Functional Skills: Funds Transfer Pricing, Accounts Payable, Accounts Receivable, Billing, Contracts and General Ledger.
• Has worked on PeopleSoft EPM and FSCM Versions 8.9, 9.0,9.1 and 9.2. People Tools …
• Thorough experience on ERP implementation, upgrade and support methodology and benchmarked at the CMMI level. Worked in variety of engagements spanning all phases of the SDLC including system study, analysis, design, development, testing and implementation.
• Involved in development of many tools and accelerators to improve productivity and standards.
• Has knowledge in STIBO-STEP PIM system.
• Ability to learn new technologies with minimal time period.
• Good at No SQL databases like Mongo DB, Cassandra and MongoDB.
• Has satisfactory experience in developing a data conversion tool using Microsoft Visual Basic. • Extensive experience in Peoplesoft HRMS and FSCM Upgrade handling the upgradable objects and non-upgradable objects analysis of the upgrade along with new requirements.

TECHNICAL SKILLS:

PeopleSoft Modules: PeopleSoft HRMS 8.8, Payroll, Time and Labor

Development Tools: Process Scheduler, Application Engine, Batch Processing, Data Mover

Programming Languages: PeopleCode, COBOL 11, ASP, JavaScript, SQR, HTML

Operating Systems: Windows XP/7, MVS, ESA

Databases: Oracle, DB2 OS390, SQL Server 2008 SQL databases Mongo DB, Cassandra and MongoDB.

PROFESSIONAL EXPERIENCE:

Senior PeopleSoft Developer

Confidential, New York City, NJ

Responsibilities:

• Provide production support and month close support for PeopleSoft finance module such as Billing and Contract.
• Provide technical support in design, development, testing, and deployment of PeopleSoft applications.
• Implement change requests as per change management policies and procedures.
• Perform system modification and enhancements based on business needs.
• Review and recommend improvements to current PS processes.
• Coordinate with Project Manager to develop project plan.
• Develop interfaces, understand table structures, run month-end PS batches and generate reports.
• Maintain project technical documentations for management review.
• Analyze and resolve problem tickets in a timely manner.
• Provide support in UAT and bug fixing activities.
• Project migration using Quest stat.
• Use Quest Stat to manage the version control of PeopleSoft application development objects
• Co-ordination with offshore team.
• Involved in the User meetings for gathering requirements for User Interface
• Involved in providing solutions for the problem requests arising out of testing of releases and live issues.
• Develop PeopleSoft query to retrieve different tables data, verify and analyze.
• Execute Data Validation with PeopleSoft extracts for different reports.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.

PeopleSoft Developer

Confidential, Philadelphia, PA

Responsibilities:

• Analyzing functional requirements and developing technical solutions using PeopleSoft program
• Designing and developing workflow process for reviewing, adjusting and approving budgets
• Building components for cost and budget functionality integration
• Using XML publisher and crystal for creating reports
• Carry out testing according to the test standards and procedures
• Examining systems applications issues, problems, improvements and presenting options for resolution
• Preparing the documents for internal design according to the department standards and business requirements
• Assisting other team members and provide on-call support

Peoplesoft Techno functional Consultant

Confidential - South Portland, ME

Responsibilities:

• Upgraded/Converted PeopleSoft financial system from v8.8 tools v8.48 to v9.2 tools v8.53.11.
• Applied Cutomizations, Enhanced Reports, Rebuilt Appengines, Exported and Imported Data, Unit tested Daily PSFIN Job Schdeule and ReBuilt ExceltoCI's as part of Upgrade to v 9.2.
• PeopleSoft Financial GL module was integrated with New Zealand based IFCS, ICP systems to load Accounting entries.
• Implemented FLEX CARD (Fuel Credit Card) in PeopleSoft Financial AR system with PeopleSoft v8.8
• Collaborated and Implemented Customer Alert Frame work in AR (Account Receivables) module to send various Alerts to the customers.
• Archived PS Audit, PS Journal header and line Tables using delivered Archival setup.
• Implemented Asset Management and E-procurement (ePro) as part of upgrade.
• AP (Account Payables) Payment Automation with Banks using SEPA, BACS, MT109 and MT9 file Layouts.
• Worked on Pipeline requests from Business users to enhance Pages and Appengines to better serve their purpose.
• Involved in Production Support during Stabilization Phases of the Project.
• Developed 4 Appengine processes from scratch by utilizing File Layout and Component Interfaces.
• Developed SQr's from scratch to load a files into peoplesoft Transaction tables.
• Designed and Build Mapping /Cross Reference tables to load third party accounting entries into Peoplesoft.
• Enhanced Fineft.sqc to add new AP Bank Payment Layouts.
• Developed new SQC's to support New Bank Integrations.
• Developed UNIX shell scripts to run Peoplesoft Appengines from Control-M.
• Built SQL views to provide LookUp for third party applications.
• Built ExceltoCI to Load Data into PeopeSoft.
• Configured Integration Broker to send and Rcevive SOAP based XML messages.
• Build a Bolt on multi Level Component to support Flex Card Functionality.
• Developed Data Mover Scripts to Export and Import Data.
• Converted custom Crytsal reports to XML publisher reports.
• Built File Layout to Map the fields in a file.
• Migrated Projects from Development, Test, Stage environments into Production.
• Developed Fileds, Records, Pages, Components, Component Interfaces, and Menus to satisfy user requirements.
• Developed Run-Control Page, Run-Control record and State Records as part of custom App-Engine.
• Used Peoplecode create process request function to dynamically call FSJGEN process to Generate Journals.
• Documented Low Level Designs using High Level Requirement Documents.

Environment: Peopletools 8.48, 8.53, FSCM 8.8, 9.2 (AR, Customers, BI, GL, AP, AM, ePro), peoplcode, SQL, Orace11, CI, IB, nVision, Control-M Datamover, Excel to CI..

PeopleSoft Developer

Confidential

Responsibilities:

• Developed an Application Engine to coordinate with a third-party demand forecasting software application for Inventory Planning.
• Ran Compare Reports and identified the objects that had to be reapplied.
• Custom wrote an Application Engine and generated a flat file pulling out FSIs for a particular physical year in GL.
• Worked with DDDAUDIT and SYSAUDIT reports in analyzing the Orphaned data redundancy and identifying the inconsistencies and orphaned objects.
• Customized the OMBILL SQR process as per the business requirements.
• Reapplied People Code, application engines, sections, actions, People Code, 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.
• Executed and prepared test scripts for Integration Broker (xml messages) to load data from third party systems (Ops Technology) to AR/BILLING modules.
• Introducing XML publishing and BI for the first time in the company.
• Provided product assistance/training to end user and assisted users in performing UAT.
• Responsibility includes design and developing Stored Procedures, performance tuning. Development of complicated sql for PeopleSoft application engine and SQR.
• Conducted training on SQL.
• Acquired knowledge on EXCEL to CI.
• Provided Production support for own developed and existing Finance modules like Projects, BI, PO etc.,
• Worked on analyzing multiple BI related delivered and customized SQRs to adopt the same logic in later designed reports.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Mentored the junior resources trained them on PeopleSoft Application Designer, Peoplecode, Application Engine, SQR.
• Expertise in PeopleSoft Security, creating permission lists and roles, assigning them to users.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins and sub-queries.

PeopleSoft Techno Functional Lead

Confidential

Responsibilities:

• Performed Fit Gap Analysis for Core HR, Self Service and Payroll.
• Demo for Delta and New Functionalities of HCM 8.9 System for Upgrade.
• Developed Scripts for Manual conversion from 8.3 to 8.9 for Separate instance.
• Updated Technical and Functional Design Documents from Upgrade perspective
• Developed Test Scripts for System Testing and performed Functional Unit Testing.
• Supported UAT and worked with Users for resolution of UAT related Defects
• Application HRMS security for 8.9 based on department tree and SJT was designed and build
• Manual Conversion of Security was performed from 7.5,8.3 to 8.9
• Setup LDAP and Implement Single Sign on
• Assisted Technical Team When required for the Upgrade Process. Air-Canada Application Support & Enhancement
• Coordinating with Business Users and Confidential team towards understanding the issues and providing quick turnaround
• Monitoring production issues and prioritizing the based on the impact and work towards resolving the issues and providing emergency support
• Working with Client Business Analysts in resolving critical Incidents Confidential PeopleSoft Innovation Lab
• Lead the innovation lab for the development of Accelerator tools for Upgrade.
• Architect for accelerated Solutions for PeopleSoft Upgrades delivering value to the customer.
• Assisted and contributed successfully in various upgrade projects like IHG, Merck and SGB in last one year.
• Developed Assessment tools for upgrade like Customization analyzer, Security configurator and DML Analyzer.
• Performed upgrade Assessment for Broadcom, Keppel Shipyard Singapore and ITE Singapore from upgrades perspective and made recommendations for the upgrade project.
• Developed Reusable Components for upgrades based on Project Pain point’s experience.
• Customized User Training Kits Development
• Developed Integration Packs with other ERPs & Third Party Applications.