SUMMARY

• 11 years of extensive operational, functional,Technical, and IT project management experience in Oracle Applications - Rel 11.5.10 through 12.1.3 implementations, upgrades, and maintenance projects.
• Expertise in implementation, upgrades, and production support with iRecruitment, Core HR, OSB,OAB, Payroll, ESS,MSS, OTL, LD, Grants, AP, AR, GL, PSB, and UPK.
• Excellent project and team leader with expertise in project management, implementations, rollouts, conversions, production support, open enrollments, and vendor interfaces.
• Expert in developing fast formulas, extensions, and reports on various iRecruitment, HR, OAB, OTL and Payroll requirements.
• Skilled in client interactions and involved in defining the system scope, analysis and designing effective solutions to meet requirements.
• Proficient in project management by conducting all roles from Feasibility, GAP analysis to Project Planning to Requirements Gathering through Execution, Maintenance, and Closing.
• Designed and developed User Training guides using Oracle User Productivity Kit (UPK).
• Good exposure to SDLC, AIM, Six Sigma, and SEI-CMM methodologies.
• Cross-Industry experience in, Public Sector, Energy, Food, Transport, Electronics, and Automotive.

TECHNICAL SKILLS

Training Development & Delivery Tools: User Productivity Kit (UPK), AIM, Camtesia, PVCS, and TOAD.

ERP Technologies: SQL, PL/SQL, Workflow Builder 2.6, Reports 10g, and OA Framework

Languages: C, C++, PERL, JAVA, SQL, PL/SQL, UNIX Shell Scripting

Databases: Oracle 10g/11g, MS - SQL Server, MYSQL

Business Intelligence: Discoverer 10g, BI Publisher

Operating System: Windows, UNIX/Linux/Sun Solaris, MAC

Microsoft Office: 2003/2010 - Project, Visio, Excel, PowerPoint, and Access

PROFESSIONAL EXPERIENCE

Confidential, TX

Oracle HCM Lead

Responsibilities:

• Gather requirements; perform technical/functional setups design using AIM documentation templates such as RD.050, CV.040, MD.050, BR.030, BR.100 and TE.040.
• Design, configure, test, and administer CRP3, UAT, Parallels Payroll Testing, and go-live setups. Provide status on Parallels Issue resolution by doing required setup/code changes and following with Oracle Support on various payroll issues from 25 payrolls across 5 states.
• Conducted requirement gathering workshops and gap analysis.
• Configure Manager Self Service function(Hire, Change Pay, Termination, Change Job, transfer) for new acquisitions
• Develop some 401k and Aetna outbound interfaces.
• Designed OTL and Payroll interfaces.
• Review and modify technical designs, code for various interfaces such as Bank interfaces, Third Party Systems, WebADI Time Entry interface, conversions, and custom BI Publisher reports.
• Prepare BR100s for Core HR, ESS, MSS, OSB, PTO Accruals, and OTL.
• Perform Form Personalization’s; develop fast formulas and OA Framework/Workflow design for various HR, Benefits, Payroll, and OTL requirements.
• Perform End to End functional testing on HR to Benefits to OTL/Payroll to SLA Accounting through Financials GL Journal posting reconciliation along with vendor Interfaces.
• Setup and test Payroll Elements, OTL Time Validation rules, and custom OTL/Payroll FFs.
• Create Oracle SRs on various HR, Benefits, Payroll, and OTL issues, and follow-up with Oracle Support on required OWCs and information for a potential bug or issue resolution.
• Provide post-production support on HCM modules.

Confidential

Oracle HCM SME

Responsibilities:

• Review RD.050, MD.050, BR100, TE.050 documents for Oracle HR/ESS/Payroll/OTL modules.
• Design, Configure, review, and test Oracle HR, Payroll, and OTL designs for US and Canadian business groups, and advice ACS Benefits team with Oracle HR, Payroll, and OTL integration best practices.
• Develop and load salary changes using API’s
• Review and verify that OTL data transferred correctly into Project Accounting.
• Review Oracle HR/Payroll/OTL and ACS dbConnect, hwConnect system interface layouts.
• Employee self-service personalization and built custom security for employee and Manager self service responsibilities

Confidential

HCM Lead/System Analyst

Responsibilities:

• Enhance iRecruitment for complete automation of vacancy approval, offer process using AME.
• Implement Manager Self-Service using supervisor hierarchy and HR Position control.
• Review OLM, OTL, OAB, CWB setups; enhance them per new R12 features.
• Review OTL processes and provide suggestions for improved business processes.
• Prepare/update UPK procedures for OAB/OTL /OLM, and train the users.
• Gather oracle R12 features along with its impact on existing RICEW components.
• Document new features in oracle database 11gR1 and R12.0.6, R12.1.3 HRMS, Financials, and Projects modules that could be incorporated by the client.
• Identify new modules/functionality that could be implemented after upgrading to R12.
• Prepare an assessment document to which R12 version/environment that the Client should go.
• Development, Enhancements and Daily support of Oracle HRMS, Finance, CRM modules using Oracle Setups, Discoverer, BI Publisher, and System Admin/DBA activities.
• Coordinate cloning and patching activities with hosting vendor.
• Review and deploy code objects, setups to Production.
• Bug Reporting (SR) to Oracle Support, and coordination to Closure
• Perform various daily System Admin related and monitoring activities.
• Implement iRecruitment/Employee Self-Service instructions revamp and UPK Videos.
• Implement Process Improvements Enhancements using personalizations and extensions.
• Re-define and Customize Hire and termination process in Manger Self Service module(MSS)
• Implement HR Year End Temporary Employee Termination/Rehire Process Automation.
• Implement City, Library Retirement Statement Calculations Automation.
• Administer, Test, and Implement Payroll Year-End tasks such as W2/1099s generation with interface changes pertaining to Year 2010, follow-up file transfer feedback with IRS.
• Setup new earnings, deductions, time entry validation rules, rotation policies, and WebADI.
• Develop/test OTL fast formulas for various time entry validations.
• Setup WebADI interface to upload Employee time hours into Time Entry/Batch Element entry screens.
• Develop various Payroll and OTL reports using BI Publisher and Discoverer.
• Work on various OTL validation programs, and improve performance by modifying the code.
• Develop CRM Service Request Summary Analysis graphs dashboard using XML Publisher.
• Evaluate leading cost-effective BI Dashboard solutions currently available.
• Integrated Barcode in Oracle XML Finance Reports for integration with .Net web application for City’s Contracts and Bidding tracking website.
• Project testing and support for CRM Community Enhancement rollout.
• Conduct Biweekly Oracle Issues Meeting, and train users on new UPK Procedures.

Confidential, TN

Functional Lead/Project Lead

Responsibilities:

• Manage City Open Enrollment Projects, and Self Service Benefits Project by Preparing Project Plan, gathering Business Requirements, and conducting CRP Demos, UAT, and user meetings.
• Create Open Enrollment Implementation documents
• Implement 2009 Open with Retiree Plans Reimplementation, and Self-Service Benefits Rollout.
• Develop various OAB Fast Formulas, Dependent, and Beneficiary Carry Forward Programs.
• Design and Setup Self Service Personalization’s and Confirmation Statement changes.
• Conduct Self Service Benefits Demo during Confidential Annual Health Fair.
• Train Benefits Staff and Service Desk on Self-Service Open Enrollment using UPK procedures.
• Design, Setup, and Validate Carrier Extract changes with AIM documentation.
• Implement Oracle Talent Management to replace Performance Impact software.
• Implement Oracle CWB for Bonus and Salary increases.
• Implement solutions as Oracle Setups, PL/SQL packages, and Fast Formulas.
• Train Users on various Oracle HRMS modules.

Confidential, TN

Oracle HR/OTL/OAB Lead

Responsibilities:

• Prepared project plan and managed team task assignments.
• Developed Technical/Functional documents for HR, OAB, OTL, and Payroll Data Conversion using AIM RD.050, MD.050 and CV.060 templates. Setup new plans, eligibility, and rates for Library employees.
• Configured Employee Self service functions (Personal information,Payslip,Leave of Absence, Tax form and SIT)
• Develop Payroll/OTL/OAB fast formulas for Library requirements.
• Gathered Report requirements and developed using Oracle Reports 6i and Discoverer.