We provide IT Staff Augmentation Services!

Oracle Developer Resume Profile

4.00/5 (Submit Your Rating)

UsA

Summary:

16 years of progressive experience in the information systems industry. He has strong technical and functional skills in Workday HCM Service utilizing Custom report, Calculated Fields, EIB, Core Connector, Studio and PeopleSoft utilizing SQL, SQR, PeopleCode, PeopleTools, App Engine, and Crystal Reports. He has extensively worked in PeopleSoft Installation Installing Software , Upgrade, development, conversion, integration, and implementation of HCM, Payroll, Financials, CRM and Distribution systems. He possesses solid interpersonal and communication skills, which lead to productive user relationships and timely achievement of project deliverables.

Technical Skills:

Cloud

Workday Integration Core - Workday HCM Service utilizing Custom report, Calculated Fields, EIB, Core Connector, Studio, XSLT, XML

ERP

PeopleSoft Ver 9x HCM, Payroll, Financials, Purchasing, Inventory, Billing, Project, eRecruit, ePay, Time Labor, eBenefits, Portal, CRM Portal.

Internet Application

CommerceOne, I2 Technologies -RightWorks, SABA.

Internet Product

Websphere, Visualage, JSP, Servlets, J2EE, Java, JavaScript, EJB, Bean, HTML, JFC Swing GUI ,JNDI.

Operating Systems

SCO UNIX, HP-UX, Windows Advance Server 2000, ILINK,windows NT 4.0 server, Windows NT service pack 3 and 6a, NT 4.0 Option Pack. - Clint 2.0.4.0, Oracle 8i on windows and Unix.

Languages

SQL, PRO C

RDBMS

Oracle 8x , Sybase, SQL Server 7.0

Tools

HTML Access Terminology, Jolt, Application Server, Web Server, JMAC,PeopleTools, SQL/SQR, PeopleTools, Integration Tools, PeopleCode, SQR, Crystal Reports, PS/Query, nVision layouts , Business Process Designer, Workflow, Convoy Conversion Tool, EDI, Winframe, PL/SQL, SQL Forms 3.x. SQL Plus, SQL Report 1.x.

PROJECT EXPERIENCE

Confidential Environment Responsibilities

HCM/FSCM

Workday WD23

Services

Integration/Reporting lead of an implementation/support team that is involved in rolling out Workday HCM/FSCM to University of Miami. This phase of the project consisted of implementing/maintaining Workday 23 HCM and build outbound integrations configuring Workday 23 Tenant based architecture.

Worked on Fidelity-RSP-Contributions-Out, Fidelity-RSP-Eligibility-Participants-Out and Wage Works COBRA-Event-Eligibility-Out US integration using calculated fields, report, Core Connector, Document Transformation, XML and XSLT. Output transferred to server using SFTP.

Created employee demographic report/flat file information and transfered those files to different server using SFTP using report/EIB.

Created outbound integration for Gempay Demographics-Out, ADP-EMPL-Verification-Demographics-Out which produces change only file on daily basis.

Created outbound integration to Bank-of-America-Direct-Deposit-and-Note-Out and Bank of America Positive Pay-Out using EIB/Core Connector.

Created/Modified several custom reports and calculated fields for HCM and FCM.

Confidential Environment Responsibilities

HCM

Workday WD23

Services

Integration technical Lead of an implementation/support team that is involved in rolling out Workday HCM to Tower Watson. This phase of the project consisted of implementing/maintaining Workday 23 HCM and build outbound integrations configuring Workday 23 Tenant based architecture.

Worked on Benefit Focus US/Canada integration using calculated fields, report, Core Connector, Document Transformation, XML and XSLT. Output transferred to server using SFTP.

Created outbound TLM integration using studio, produced different output files based on the pay group and transfer those files to different server using SFTP.

Created outbound integration for Concur and Amerilert which produces change only file on daily basis.

Designed/Developed outbound integration for Organization change only feed using report/EIB.

Confidential Environment Responsibilities

HCM

Workday WD21

Services

Integration technical Lead of an implementation/support team that is involved in rolling out Workday HCM to DOMTAR. This phase of the project consisted of implementing/maintaining Workday 21 HCM and build outbound integrations configuring Workday 21 Tenant based architecture.

Worked on the DOMTAR/Aon Hewitt Pension interface to send employee demographic data from E20, Y41 HR Systems to Aon Hewitt for EMP

Created interface between SAP system and General Ledger system of record. A file will be generated containing info for all journals in WD for a transaction and the resulting data file will be sent to the EAI Hub via SFTP.

Worked on DOMTAR interface to pay and hours full file containing payroll data sent from Domtar payroll to Aon Hewitt on each pay reporting period on cycle / off cycle for actual pay and hours occurred in the period. It is used to determine benefits for current or future participants in the Domtar US pension plans. Aon Hewitt is a third party vendor that Domtar utilizes to process employee payroll. E20 and Y41 are domtar HR SAP systems.

Created integration using templates Cloud Connect for HCM, Benefits, Worker Sync and Payroll between workday and external systems.

Created custom reports, EIB, Calculated Field and XSLT.

Created Outbound and Inbound Integration between workday and external systems using Studio.

Confidential Environment Responsibilities

HCM, CRM

Peopletools 8.5

Services

Oracle

Member of an implementation and support team that is involved in rolling out Peoplesoft HCM, CRM Field Services to NEC, Dallas. This phase of the project consisted of maintaining peoplesoft HCM, CRM application 9.0 and PeopleTools 8.49.24 configuring PeopleSoft for n-Tier WAN based architecture.

Implemented and worked on Employee Self Service functionality to NEC HR system.

Worked/Implemented on Time Tracking system and NEC Time line system TAM where employees can enter their time on wkly basis and make sure both the system sync with HR.

Supported the development of customized reports and queries. Some of these reports are currently in maintenance phase and often call for trouble shooting and problem identifying skills.

Wrote numerous interface SQR's which will convert, Validate data and insert in to peoplesoft tables and creat flat files.

Worked on the CRM month end process where the entire Project account and SO activity in sync with FSM.

Worked on the CISCO B2B process which brings all the IP/Agreement changes from CISCO to keep Psoft system up to date by transfer data from CISCO to PSOFT on daily basis.

Worked on the Agreement Contract , Install Product, Service Order and Projects.

Managed daily production support issues list for HRMS/CRM and provided mentoring for functional/Technical staff.

Platform: Oracle on Advance server, PeopleTools v8.5, Application v9.1.

Confidential Environment Responsibilities

HCM, Payroll 9.0

Peopletools 8.4.9

Manufacturing

Oracle

Application Lead Technical functional of an implementation and support team that is involved in rolling out Peoplesoft HCM, NA Payroll, Global Payroll to Pentair, MN. This phase of the project consisted of implementing Peoplesoft NA, Global - HCM, Payroll application 9.0 and PeopleTools 8.49.24 configuring PeopleSoft for n-Tier WAN based architecture. This phase has been successfully implemented.

Responsibilities include leading the Configuration, data mapping and conversion process, interfaces and reports for all of the Technical teams, assisting with modification specifications regarding multiple components of pay as well as variable compensation and creating and managing Technical task lists with metrics that relate back to the overall project plan.

Developed all conversion design strategies/Technical design, code as well as oversaw all development efforts as well as design, test case scenarios and ultimate production configurations and sent to offshore.

Lead the project team through a database conversion from Tress Legacy systems to Peoplesoft. Co-ordinate the fit/gap analysis to implement HCM, Payroll for AM2 and Global Payroll.

Worked on developing the Conversion, Interface and reports code, Testing SIT, QA, Parallel and go live as well.

Prepared Materials and Conducting all daily/weekly Status Meetings.

Reporting the status of the project to Senior Management on timely basis.

Prepared integrated project plan for all Phases of this Project.

Platform: Oracle on Advance server, PeopleTools v8.4.9, Application v9.0.

Confidential Environment Responsibilities

HCM, Payroll 9.0

Peopletools 8.4.9

Manufacturing

Oracle

Technical functional member of an implementation and support team that is involved in rolling out Peoplesoft HCM, Payroll to HPEDS. This phase of the project consisted of upgrading Peoplesoft NA - HCM, Payroll application 9.0 and PeopleTools 8.49.15, configuring PeopleSoft for n-Tier WAN based architecture. This phase has been successfully implemented.

My team was responsible in ensuring that the front-end enhancements, interfaces and modifications done to the system were brought forward.

Participated in the initial start up of a Human Resource, Payroll and Benefits PeopleSoft implementation. to the new version. The work compromised of enrolling high level executives from EDS into Position Management and converting their data into Peoplesoft tables.

Created new interface process for HPEDS to ADP to ensure that for each new company that files sent to ADP will pick up each new company.

Created new interface process for HPEDS to Wells Fargo to setup new Wells Fargo accounts for 6 new legal entities to include outbound direct deposit files and check recons.

Modified the online PeopleCode to allow the Final Check Program to handle refunding specific Benefit deductions as well as the reimbursement of outstanding leave time for employees that either transferred to other companies or moved from Full Time to Part Time status.

Created multiple batch process to run AE, SQR, COBOL process from the Server.

Platform: Oracle on Advance server, PeopleTools v8.4.7, Application v9.0.

Confidential Environment Responsibilities

HCM, Payroll 9.0

Peopletools 8.4.9

Retailer

Oracle

Technical/Functional member of an implementation and support team that is involved in rolling out Peoplesoft HCM, Payroll to JCPenney. This phase of the project consisted of upgrading Peoplesoft NA - HCM, Payroll application 9.0 and PeopleTools 8.49.02, configuring PeopleSoft for n-Tier WAN based architecture. This phase has been successfully implemented.

Worked on JCPenney Company HR Succession planning for home office and store associates. That involves AE, Peoplecode and online customization.

Worked on the Service Awards process to communicate to the associates, JCP management and HR on milestone anniversaries for associates.

Worked on JCPenney new recruiting system for Home Office and Field Management recruiting. This project requests for additional functionality within eRecruit, enhanced reporting, the collection of additional survey data, and enhancements to the Careers page.

Worked on HR/Payroll/ Benefits Administration SQR/COBOL Year-End Processing

Worked on the Equity Grant Tracking EGT System to use for supporting the Compensation Department to administer the equity award process.

Platform: Oracle on Advance server, PeopleTools v8.4.7, Application v9.0.

Confidential Environment Responsibilities

WFA, Payroll

Peopletools 8.4.7

Health Care

Oracle

Application Technical Lead of an implementation and support team that is involved in rolling out Peoplesoft WFA, Payroll to Cardinal. The first phase of this project consisted of implementing Peoplesoft NA - WFA, Payroll application 8.9 and PeopleTools 8.47, configuring PeopleSoft for n-Tier WAN based architecture. This phase has been successfully implemented.

Responsibilities include leading the Configuration, data mapping and conversion process, history data conversion for all of the Technical teams, assisting with modification specifications regarding multiple components of pay as well as variable compensation and creating and managing Technical task lists with metrics that relate back to the overall project plan.

Developed all conversion design strategies/Technical design as well as oversaw all development efforts as well as design, test case scenarios and ultimate production configurations.

Lead the project team through a database conversion from ADP to Peoplesoft, starting with PeopleSoft's Payroll Version 8.9. Co-ordinate the fit/gap analysis to implement Payroll.

Developed and Maintained Project Plan and Scope Documents.

Evaluated Project Risk and Establishing Project Assumptions.

Prepared Materials and Conducting all daily/weekly Status Meetings and Monthly Steering Committee Meetings.

Evaluated Functional and Technical Skill Sets of Leads and Staff

Identified Goals and Objectives as well as Project Scope

Reporting the status of the project to Senior Management on timely basis.

Prepared integrated project plan for all Phases of this Project.

Managed issues list and payroll project plans and provided mentoring for functional/Technical staff.

Prepared formal project plan and resource requirements for the Configuration, Conversion for the Payroll implementation phases of the project.

Identifying Business Process areas for improvement.

Platform: Oracle on Advance server, PeopleTools v8.4.7, Application v8.9.

Confidential Environment Responsibilities

Financials 8.9 GL, AP, AR, Expense, CM, eProc, TE

Peopletools 8.4.7

Health Care

SQL Server

Technical member of an upgrade and support team that is involved in rolling out Peoplesoft FSCM GL, AP, AR, Billing, CM, eProcurement, Travel Expense and Support Package to Broadlane. The first phase of this project consisted of upgrade Peoplesoft Software application 8.4 to 8.9 and PeopleTools 8.47, configuring PeopleSoft for n-Tier WAN based architecture. This phase has been successfully implemented.

Worked and configured punch-out standard process for implementing Procurement System to Supplier Website Integration.

Making sure that the batch process was modified to account for the change in the table structure with the new version.

Installed, upgraded and maintenance pack 2 for FSCM application 8.9.

Worked on App Server, process scheduler and web server configuration.

Worked on Import Bank Statement, Reconciliation application engine process to load data from external bank to the staging table and then to peoplesoft tables.

Configured eprocurement in FSCM 8.9 to create requisition, receive and approval process

Worked on change assistance template manual and automated process and did complete upgrade from 8.4 to 8.9 This include more that five iterations .

Reporting the status of the project to Senior Management on timely basis.

Platform: SQL server on Advance server, PeopleTools v8.4.6, Application v8.9.

Confidential Environment Responsibilities

CRM 8.9 Field Services and Support

Peopletools 8.4.6

Insurance and Inspection Company

SQL Server

Integration Technical Lead of an implementation and support team that is involved in rolling out Peoplesoft CRM Field Services and Support Package to Hartford Steam Boiler, Hartford. The first phase of this project consisted of Installing of Peoplesoft Software application 8.9 and PeopleTools 8.46, configuring PeopleSoft for n-Tier WAN based architecture. This phase has been successfully implemented.

Created AppEngine, CI and Peoplecode batch process which transfers data from WMS system and Lotus Notes homegrown systems to create service order in PeopleSoft CRM database and back to WMS and Lotus Notes database on real time daily basis.

Reporting the status of the project to Senior Management on timely basis.

Created error maintenance pages process which display data from the staging table with error code after each daily process.

Created AppEngine, CI and Peoplecode batch process for Company, Site and contact data - LPS load which convert data from LPS system to peoplesoft.

Created relationship between Company/Site, Site/Contact and Company/Contact in BO REL table in Peoplesoft CRM application by using AppEngine, Peoplecode.

Identifying Business Process areas for improvement.

Worked on the initial data load of Company, Site and contact from legacy system to peoplesoft after creating the relationship to create service order.

Created process, pages, peoplecode, component and functionality for Dash board, End of Day, Trunk work.

Data conversion and testing.

Identifying options, as well as making recommendations based on the client requirements.

Creating multi-level documentation for both executives as well as Business Analysts.

Platform: SQL server on Advance server, PeopleTools v8.4.6, Application v8.9.

Confidential Environment Responsibilities

Peopletools 8.4.3

Retail Industry

Financials / SCM AM, PC, GL, AP,AR, PO, INV, Order Management

Oracle 9i

Member of an implementation and support team that is involved in rolling out Peoplesoft Financials, GL, AP, AR, AM Package to FedExKinkos. The first phase of this project consisted of Installing of Peoplesoft Software, Converting from Lawson system to Peoplesoft 8.43 Tools and 8.8 applications, configuring PeopleSoft for n-Tier WAN based architecture. This phase has been successfully implemented.

Worked on FTP process, which run SQR on the Batch mode to transfer files to several other servers.

Designing and writing the GL, AR interface from Lawson homegrown legacy system to Peoplesoft system.

Actively worked on preparing Application Engine Programs from data migration for he tables like PS ITEM, PS ITEM TOTAL, PS ASSET, PS DEPRECIATION, PS LEDGER, Journal Line, BI LINE, BI HDR from legacy to development environment and then to production.

Extensively worked on nVision report layouts Matrix and Tabular .

Platform: Oracle 9i on 2000 Advance server, PeopleTools v8.4.3, Application v8.8.

Confidential Environment Responsibilities

Peopletools 8.4.3

Dotcom Industry

CRM Portal 8.8 Order Capture

Superpages.com

Oracle, Unix

Technical member of an Implementation team that is involved in rolling out Peoplesoft CRM Vision module to Verizon. The first phase of this project consisted of implementing of Peoplesoft CRM for n-Tier WAN based architecture. This phase has been successfully implemented. My work involved in the second phase of Peoplesoft CRM Vision maintenance and Superpages.com.

Worked on designing, writing Free Basic Hot Link interface from Peoplesoft CRM Vision to a homegrown legacy system Infohub system both for the vision and Infohub population .

Worked on bulk load interface process, which load data from flat file from customer on wkly basis to Peoplesoft vision tables.

Developed Fullservice process, which include credit card validation with Cyber Source server for Self Service Administration on Superpages.com.

Modified CRM Portal Home Page by adding several Sponsor Link, Business Profile and Categories. Also customized , maintained CRM portal page as required on day-to-day basis.

Working on bug fix on daily basis, Business project, Daily App engine processes and SP1 upgrade on both application and tools.

Platform: Oracle 8x on 2000 Advance server, PeopleTools v8.4.3, Application v8.8

Confidential Environment Responsibilities

Peopletools 8.4.1

Communication Industry

Project

Financials

SCM

DB2, Unix

Member of an Implementation team that is involved in rolling out Peoplesoft Financials, Billing, Project Package to Sprint Corp. The first phase of this project consisted of implementing Peoplesoft Version 8.4 Financials and Distribution Modules configuring PeopleSoft for n-Tier WAN based architecture. This phase has been successfully implemented. My work involved in Financials, Billing, Project Modules.

Responsible for maintenance, development during implementation phase, instruct handing of the application to client's developers and creating documentation

Designing and writing the Billing interface from the Peoplesoft Billing and Project system to a homegrown legacy system.

Supported the development of customized reports and queries. Some of these reports are currently in maintenance phase and often call for trouble shooting and problem identifying skill

Leading the bug fixing team and assigning bugs to the developers to get it done in appropriate time frame.

Maintain affiliations and security: developed custom components, pages from scratch to maintain trade allys, customer offerings, territory, regions, service center, storage locations, worked on security using log on peoplecode, dynamic view, search record and edit table, prompt tables based on user and his roles on all the components.

Platform: DB2 - Unix, PeopleTools v8.4.1, Application v8.4.

Confidential Environment Responsibilities

Peopletools 8.17

Upgrade 7.5X to 8.17

Retailer Industry

HRMS

Payroll

Time Labor

Benefits

DB2, AS400

Member of an Upgrade team that is involved in rollout Peoplesoft HRMS Package to Biglots Inc. The first phase of this project consisted of migrating from AS400 to DB2/AIXUNIX for n-Tier WAN based architecture. This phase has been successfully implemented.

Responsible for maintenance during implementation phase, instruct handing of the application to client's developers and creating documentation

Worked on DMS scripts to move migrate data from one database to another.

The Second phase of this project consisted of carried out Peoplesoft Upgrade from 7.5x to 8.17. My team was responsible in ensuring that the front-end enhancements and modifications done to the system were brought forward Participated in the initial start up of a HRMS PeopleSoft implementation. to the new version.

Reviewed and ran scripts to install databases, Peopletools upgrade, application upgrade and for Update fixes and patches.

Worked on Time Admin process

Going over the comparison reports and selecting the necessary enhancements for rollover to the new version.

Ensuring that the interface files and programs were Y2K complaint.

Platform: DB2 - Unix, AS400, PeopleTools v8.17, Application v8.14.

Confidential Environment Responsibilities

Peoplesoft 7.5

Public Sector

HRMS

Mainframe,DB2

Member of an Implementation team that is involved in rolling out Peoplesoft Package to State of Indiana State Government . The first phase of this project consisted of bringing on 40,000 hourly and salaried employees in to peoplesoft. This phase has been successfully implemented.

Worked on GSA General Salary Increase for 40,000 employees for multiple union groups. Maintained the GSA planing process for year 2000. Wrote multiple sqr's for the process and developed panels to facilitate the process . The work involved in

ensuring that the interface files and programs were Y2K complaint.

sizing the database to account for the increase in volume.

Confidential Automobile Industry Environment Responsibilities

Peoplesoft 7.5

Human Resources

Payroll

Sybase, Unix.

Member of an Implementation team that is involved in rolling out Peoplesoft Package to Chrysler Mexico and other South American Countries like Brazil, Venezuela and Argentina. The first phase of this project consisted of bringing on 10,000 hourly and 2000 salaried employees from Mexico. This phase has been successfully implemented. The work involved in.

Determining business processes existing in the current system and the union rules existing in Mexico with respect to labor law and NAFTA.

Maintained the merit planing process for year 99. Wrote multiple sqr's and developed panels to facilitate the process.

Lead Member of the team that carried out Peoplesoft Upgrade from 7.0 to 7.5. My team was responsible in ensuring that the front-end enhancements and modifications done to the system were brought forward Participated in the initial start up of a Human Resource, Payroll and Benefits PeopleSoft implementation. to the new version. The work compromised of

enrolling high level executives from Daimler Benz into Position Management and converting their data into Peoplesoft tables.

reporting the status of the project to Senior Management on timely basis.

sizing the database to account for the increase in volume.

Converting these processes into technical design and specification for the technical team to work and code. Also assisted the technical team in coding front end in Peoplecode and batch process by writing sqrs .

Confidential

Nuclear Power Plant

Environment Responsibilities

Peoplesoft 6x

Public Sector

Human Resources

Training

SQL Server, Unix

Technical/Functional consultant to perform PeopleSoft HRMS/Payroll support of version 6.1 and upgrade to version 7.0.

Provided technical and functional knowledge on issues that related to peoplesoft functionality in version 7.0.

Modified the Masschange capabilities to fit the business requirements. Wrote scripts to back up the data on periodical basis.

Wrote SQR programs that generated several reports depending on user input and sort criteria.

Also customized the payroll, Tax and direct deposit SQRs as per the requirement of the customer

Confidential

Health Care

Environment Responsibilities

Peoplesoft 6x

HRMS

Convoy Conversion Tool

Oracle, Winframe

Technical/functional consultant to perform HRMS implementation on peoplesoft version 6.1.

Worked on CONVOY PEOPLESOFT supporting conversion tool to transfer, and validate data from the legacy system into peoplesoft tables.

Created data dictionary, data mapping, stored procedures and functions in convoy tool.

Created Psquery, documentation, modified the tree structure, SQRs.

Work was performed on winframe/windows95/Oracle platform.

We'd love your feedback!