SUMMARY

• Over 15 years of experience as Functional / Technical Analyst in implementing PeopleSoft Financials (FSCM) and HRMS
• Experienced with Leadership, Project Management, and Customer Satisfaction
• Experienced in Client Interaction, Providing Technical Support and Knowledge Transfer
• Experienced using Microsoft Project, PowerPoint, Visio
• Solid understanding of Business Process Re - engineering
• Ability to Lead and handle multiple projects simultaneously
• Exposure to agile methodology for Development and Implementation of Software applications
• Able to work independently without direction
• Experience working in a team environment as well as independently.
• Strong problem solving skills
• Expertise working on Oracle, Informix and SQL server databases.
• Specialized in performance tuning for PeopleSoft application
• Recognized by management for dedication, customer service, consistent record of quality performance and time management
• PeopleSoft Certified Consultant

TECHNICAL SKILLS

Operating System: Windows 7 Enterprise / Vista / XP /, Unix, Novell NetWare 4.x

Software: PeopleTools, Developer/2000, PowerBuilder 4.0, Visio Professional, MS Project, MS Office, PowerPoint, MS Publisher

DBMS: SQL Server, Oracle, Informix, SQLBASE, MS Access, FoxPro, DBase

Language: PeopleCode (Object Oriented), SQL, SSIS, ETL packages, PL SQL, SQR, XML, HTML, Java, MS C, C++, COBOL, Clipper

ERP: PeopleSoft 9.2 / 9.1 / 9.0 / 8.9 / 8 / 7.5 / 7.0 / 6.0

Modules: Financials - GL, BI, AR, PO, AP, AM, Proj, Contracts, Expense HR - Payroll, Administer Workforce, Recruitment, Training, Staffing, Compensation, Benefits

PeopleTools: Up to Ver. 8.54 App. Designer, App Engine, App. Package, Integration Broker, PeopleCode, Security Administrator, Utilities, Import Manager, Process Scheduler, Tree Manager, Query, Process Monitor, nVision, Workflow Administrator, Application Upgrade, Data Mover, SQR

Other: Tidal, Serena Version Manager, STAT, Clearcase, Visual Source Safe, SQA Robot

Hardware Platforms: IBM Compatibles, Sun SPARC

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

PeopleSoft Techno-Functional Senior Consultant

Responsibilities:

• Currently incharge of the IoT busines unit (Sensor project) implementation in the PS Financial. Developed an App Engine to load Customer Addresses as part of enrolment info using PS-CI
• Implementation of Consumer Market business for Secure Services in PS AP.
• Implementation of Global Purchasing system ProCat’s real time Integration with PS Purchasing and also real time integation with Vendor (Office Depot) using IB. Accomplished by synchronous messaging between the ProCat and PS using On Notify App Package.
• Completed the integration of Office Depot invoicing to PS AP. Developed FTP process and App Engine, used PS CI to create Vouchers in PS
• Implemented a robust and versatile system for archiving and backup for all Financial modules. Developed App Engine, to read files and copy/move to folders as setup online.
• Implemented US Bank Credit Card payments in PS AP. Setup new Payment file PPLUS for bank.
• Completed intergation of Guidewire Billing Center with PS AP. Developed App Engine to load voucher staging.
• New integration of Guidewire Claims payments with PS AP using App Engine to load Claims payment info as vouchers in AP.
• Lead the PS Upgrade in the area of AP, PO, BI, AR, Projects, GL.
• Supported travel and expenses in PeopleSoft integrating with Concur.
• Built custom Application Engine program to stage expense and time entries to PC EMP RES TM table that is to be pulled into Projects
• Created custom email messages to notify employees about their expense report status.
• Developed a custom Application Engine and XML Publisher to generate the Monthly Expense Reports for given Business Units.
• Developed process to send confirmation of Expenses paid to Concur system.
• Worked on applying 1099 changes and performing year end activities.
• Implemented user friendly way of printing daily and nightly reports, saved batch cycle time.
• Actively performed production support role.
• Worked on GL reporting and SSIS packages.
• Lead the effort of single signon to MyTMD, a Performance Management system. Provided information and support from PS HR to the SAP.
• Lead the effort in integrating PS Time & Expense to SAP HR, PS AP, BI, AR and GL.
• Key person in providing Production Support to PS HR, Time & Expense and AP system.

Confidential, Washington, DC

PS Techno-Functional Consultant

Responsibilities:

• Implemented new modules in Dev, Test, Demo and UAT environment
• Designed the data conversion effort from legacy systems
• Wrote SSIS packages for SQL server database and tested for data conversion
• Wrote design document for needed customization to fit the existing requirents

Confidential, Hartford, CT

PS Techno-Functional Consultant

Responsibilities:

• Estimated, Designed and developed custom chartfields. Modified Journal upload using Excel, online Journal Entry, queries, App Engine (Journal Generation) and sqr processes. Modified VB Macro and Data Sheets for the Journal Upload
• Integration of Chartfields, Vendors, Payroll Trans request & reply with HR system using IB
• Worked with XML publisher in some GL reports like Jrnl Entry Dtl Report (GLX7501 )
• Successfully consolidated Banks and External Bank Accounts into one page as per Treasury Requirements. Most of External Bank Account pages along with some custom specific requirements were combined in to one page
• Successfully automated creation and refreshment of Materialized views, automated file load process. Also modified Express Purchase Order
• Worked on process reengineering for applying GSA (General Services Administration), OIG (Office of Inspector General), Specially Designated Nationals (SDN) lists (Financial Sanctions) on Vendors using features of ver 9.0 with some customization
• Worked on extracting particular GL transactions for feed to AR/BI system.
• Worked on many PS Queries, created some new queries, converted from 8.0, tuned, replaced or removed as per the requirements for all the 4 financial modules.
• Worked on production support after golive to resolve outstanding / ongoing issues.
• Helped Data Conversion from 8.0 to 9.0 and tuning processes to run efficiently

Confidential, Glastonbury, CT

PS Techno-Functional Consultant / Analyst

Responsibilities:

• Initiate, plan, execute, control and closeout the project.
• Set-up process and Technical governance to meet the business objectives on-time, within budget and having high solution quality
• Key person in requirement Gathering for all the integrations
• Key person in designing the integrations of GL, AP, Billing / AR thru Proj / Contracts
• Developed technical design doc for GL, AP and Billing/AR thru Proj / Contracts
• Reviewed all the technical design documents with the team and users
• Integrations using CI, App Engine, File Layouts, Pages, Comps, Prcs Defns, and SQRs
• Managed loading data for Projects/Contracts and AR transactions using Data Mover scripts
• Managed load and maintenance of Product and Customer crosswalk using CI, File Layout, App Engine and maintenance pages.
• Designed the Direct Debit requirements for Confidential US & Canada operations
• Designed structure requirement with BOA and setup the Direct Debit accordingly in PS.
• Managed the customized required in the App Engine for the Direct Debit Response file processing
• Set up Payment Predictor for Canada BU
• Modified Invoice Print SQR process for BISYS invoices and Canada Invoices
• Modified Customer Account Statement Crystal report for Canada customers
• Managed QA Testing by a team of 6 people for all the integrations and Customer Direct Debit
• Performance tuning done on CA BI INTFC, PC BI TO PC, Billing Interface processes.
• Performance Tuning, Enhancements and Support proided to various modules in PS.
• Helped generating 1099 for the vendors during the year end
• Provided support to PS AP integration with Taxware, PO, AP, Billing, AR, GL, Empl time and Exp, Project costing and Contracts.
• Desgined the and managed the Data archiving for Projects, Billing/AR and GL

Confidential, Hartford, CT

PS Techno-Functional Consultant / Analyst

Responsibilities:

• Managed the re-engineering of process of Central Vendor system in PS. Proposed, designed and lead the development of the first messaging application using IB for central Vendor information. Vendors were maintained in AP and any new updates are sent to all the front end systems in real time by sending XML messages using PS Integration Broker.
• Designed and implemented the architecture for implementation of IB piece in PS. Designed implementation of MQ Series and message server for the IB to work efficiently.
• Developed a real time call from PS for address validation with a java application using Web Service call from PeopleCode. For all MSV type Vendor address a WebService is called from PeopleCode to validate the entered address and get the geographical location in the universe in X and Y coordinates from the GIS database.
• Managed the development of component interface for Vendor pages. Managed CI from different places, like online panel and App Engine to load central vendor information.
• Developed App Engine prcs to load Vendor info, send messages to front end systems.
• Modified Voucher interface process SQR for integration with SOURCE, which receives data from various front end systems.
• Developed new panels, App Engine process. Modified existing panels, App Engine and SQR processes. Created messages, message channels, and nodes. Modified IVT setup file (for MQ) for integration with the SOURCE system.
• Developed Tech Design documents for Vendor Interface, Claimant/Insured and MedBill Vendor Interface, SFH (system fraud hold) functionality for SOURCE, EOB (explanation of Benefits) and EOR (explanation of Reimbursement) for the SOURCE and MedBill Vendors.
• Performance of Bank Reconciliation process improved by tuning SQLs in the delivered process. Also there were few customizations done, that needed modifications to improve the performance. Performance tuning resulted in the process to run more than 10 times faster.
• Developed integration of Vendors, Claimant/Insured and MedBill Vendor Intfc, SFH (system fraud hold) functionality for SOURCE and Vchr Intfc with the SOURCE.

Confidential, Hartford, CT

PS Technical Consultant / Analyst

Responsibilities:

• Managed and lead the effort of conversion and comparison of data between PS ver 7.5 and 8.43 database. This was done using 50 most optimal queries in SQL as well PS Queries
• Managed & maintained application assistant with the new steps to perform at various stages.
• Lead the effort to develop the Database agent queries in version 7.5 to generate reports.
• Managed applying customizations on panels and resolved PTNs(defects) during the testing
• Provided production support and resolved issues in the daily batch cycles and online panels.
• Performance tuning was done for various processes including voucher load (one of the most complex process) by adding additional indexes and fine tuning SQLs.

Confidential, Portland, OR

PS Tax Integration Consultant

Responsibilities:

• Managed the implementation of the integrating Confidential software with Calpine's PS AP.
• Performed customizations required to the integration software.
• Supported the integration for any issues arose after golive

Confidential, Hartford, CT

PS Technical Consultant / Analyst

Responsibilities:

• Designed and developed customized Direct Debit application (modified App Engine process, developed sqr, records and panels).
• Designed and developed customized interest charge application (developed App Engine process, inquiry, and run control pages and related PS objects)
• Design Zero balance closing
• Design and implemented Payment Tolerance in Payment Predictor
• Designed and Modified the Lockbox process to process multiple lockbox files from the same bank, bank account, lockbox id and bank trans id.
• Developed Oracle Stored procedures and Triggers for Datamart, to feed the downstream systems.
• Performed assembly test for release 5.4
• Used Autosys, automated tools for System Test.
• Debugged and modified App Engine for AR Update, PGG SERV (for generating AR Acctg entries, called by AR Update), Payment Predictor, Billing Intfc, Invoice Print, Interest Charge Invoice and Direct Debit.
• Modified Load GL process
• Provided key support to System test team in testing the complete AR and Billing implementation of 8.0 custom modifications.
• Applied PS patches.
• Providing production support to Go-live issues.

Confidential, CT

PS Senior Technical Consultant / Analyst

Responsibilities:

• Upgrade PS x7 to 8.
• Designed fully customized customer account statement application.
• Designed account statement delivery system.
• Designed fully customized interest charge invoice system.
• Developed new Records / Panels for Cust Acc stmt and Int.Chg. invoice.
• Developed and Implemented SQR for the Customer Account statements.
• Developed Oracle Stored procedures and Triggers for Datamart, feeded downstream systems.
• Customize further in PS 8 to accommodate customized Interest Charge Invoice, Consolidated Customer Account Statement and more.
• Involved in Design, development and Testing of the customization.
• Involved in upgrade of PS x7 to 8 and Development in x8.

Confidential, San Francisco,CA

PS Technical Consultant / Analyst

Responsibilities:

• The project also involved an upgrade analysis from PS 7 to PS 8.
• Impact analysis for any customization required in PS; Suggest most ideal soln.
• Provided customized PS tables for Edify/Workscape to show data and to accept manager input on the web browser.
• Wrote SQR process to consolidate all the required information for the front end to show; The SQR process is run every night to get the latest information of all the employees; The data was stored in a de-normalized PS table.
• Panels were created for maintenance of Program parameters, security information, Program specific information like comp. guidelines, etc, to Maintain Phantoms, Proxies, Program Specific Data panels to use after the program freeze date etc.
• Designed, created and maintained tables, panels, PeopleCode, SQR processes.
• Generated reports using SQR, writing PS Queries.
• Wrote complex SQL's to generate reports from the front end.
• PS Data mover for maintaining training related data; The PS projects are used for migration of the developed work to the production.
• Prepared documents for all the technical work related to comp.; The general process for most of the comp. program had a nightly refresh SQR that keep refreshing data of the simplified table using many HR tables; The challenge here was, the SQR was to run in a very much-predefined short time frame; Also at the end of the process the SQR was to generate an output summary report and send it to a defined list of emails.
• Analyzed the work involved in upgrade of all the modules from PS 7 to PS 8; PS 8 was considered as an option to replace Lotus Notes, the current workflow tool used for all the compensation programs with the PS 8 workflow.

Confidential

Techno-Functional Consultant (Team Lead)

Responsibilities:

• Customized the GL-ChartFields, AR for payments at sub-customer level, Intc to BI
• Led a team for the implementation of GST in to the area of PC - BI- AR - GL.
• Performed a requirement study of the GST (Goods & Services Tax) in Australia.
• Customized GL chartfields to add Location as one chartfield. It required change in PeopleCodes, Panels, Record Definition.
• Modified App Engine for Payment Predictor, AR Update and Aging process to match the payments at Sub-customer level the requirement was to have the balances at the sub-customer level; It required modifications in Load AR process, related tables, panel and App Engine process to match payments at sub-cust level.
• Customized Panels, SQR reports and processes, invoice printing.
• Performed a fit/gap analysis with PS Financials for GST.
• Modified nVision reports.
• Attended PeopeSoft conferences for GST updates.
• Performed GST setup required in PS GL.
• Customized GST requirements in Project Costing, Billing, AR (Prepayments), GL.
• Billing was done using PS module as well as external systems; The external systems interface to PS billing required customization for GST implications.
• Studied GST requirements for the external interfaces to PS AR and AP.
• Testing performed using Rational Automated testing utility SQA Robot.

Confidential, Chicago, IL

Techno-Functional Analyst

Responsibilities:

• Involved in the design and development of this user-request-based reporting system for PS-GL; The system dynamically mapped a user requested data model into the PS data model before generating reports; Features included dynamic calculation of values, regeneration of output if data values changed, generating formatted reports as text files or generating database tables that could then be used for generating actual reports.
• Designed and developed a program generator in SQR to dynamically generate SQR code for insertion of records, and calculations.
• Also provided support for conversion of report maps from mainframe to the new PS system