SUMMARY:

• Over 18 years of extensive experience in information technology and enterprise business applications, performing roles of project manager, implementation expert, technical and functional analyst and developer.
• Over 18 years of experience implementing, managing and supporting Oracle EBS HCM and Financials Applications (Release 10.7 SC to 12i) in various capacity.
• Project Manager, Implementation Lead, Change Manager, Team Player, Result Oriented, Effective Communication and Coordination, Strong Analytical, Quality Assurance, Customer Focus.
• Full Life Cycle Implementations, Application Integration, Application Enhancements, Production Support, Conversion.
• 18 years of experience of working with Oracle HRMS(HR, Payroll, CWB, OLM, performance and Compensation system) and Oracle Financials(GL, AP, AR, purchasing, fixed assets, i - Expenses), comprising of application development, Set up and Configuration, Business Process Analysis, Fit-Gap analysis, System Analysis, functional and technical design, data conversion, interfaces, customization, development and testing.

SKILL:

Oracle Applications Release 11i, 12i: HRMS, Compensation Workbench, Payroll, Advanced

Benefits, Self Service HR, Oracle Learning Management, OTL, Oracle Financials

Business Process Analysis, Fit Gap Analysis, Functional and Technical design, Development and QAProject Management, process management and compliance

Setup and configuration of Oracle HRMS application: Key and Descriptive Flex Fields, earnings and

Deduction elements, Accrual plan set up, Fast Formulas.

Compensation Workbench, Custom Talent Assessment and Compensation management module

Data Conversions and Interfaces using APIs, Fast Formula, Custom Reports, Discoverer reports

Tax Balances, Payroll Costing, Self Service HR, Oracle Alert, System Administration, Application Security Set up.

RDBMS and Tools: ORACLE 8i-11g, SQL Plus, PL/SQL, Workflow, Oracle Developer (Forms, Reports), SQL NavigatorTOAD, Oracle Discoverer, OA Framework, Oracle Utilities (Oracle Sql Loader), AIM (Oracle

Implementation Methodology BR100, MD: 50, MD-70 etc,), ITIL V3, Project Management.

Operating Systems: Sun Solaris, HP/Digital UNIX, Linux, AIX, MS Windows XP/7

PROFESSIONAL EXPERIENCE:

HRMS & Financial Applications Lead/Manager

Confidential, Montvale, NJ

Responsibilities:

• Successfully upgraded Oracle application from release 11i to 12i, leading and managing technical updates, development, setup and configurations, User Acceptance Testing, Regression testing and deployment.
• Managed upgrade projects of multiple applications (TM1, Bottomline, REAP, TRECS etc.) involving preparing and executing project plans, managing vendor/provider contracts, overseeing technical upgrades, user acceptance and regression testing, training, deployment and change management.
• Carry out continuous enhancement to Oracle HRMS and Financial applications involving business requirement analysis for new initiatives, design and develop technical solutions and release management.
• Implemented Oracle i-Expense, a fully integrated expense management solution.
• Leading the team of analysts and developers for enhancements, support and project activities of Oracle HCM and Financials application, with robust and effective design/approach to ensure quality deliverables in time.
• Design and development of interfaces between Oracle application and other in house and vendor applications, including ADP, Kronos, RETEK and benefit vendors.
• Prepare and review functional and technical design (MD50, MD70) for enhancements and upgrade of Oracle HRMS and financial applications.
• Provide production support to resolve operational issues in timely manner for HR, payroll, benefit and financial applications.
• Perform regular upgrade and patching of Oracle application to maintain supportability.
• Manage change migration and deployment process to ensure compliance and mitigate associated risks.
• Coordinate all phases of SDLC process including UT, UAT, QAT, deployment and cut-over activities to ensure quality, effectiveness, high availability and minimum disruption/outages of applications and services.

Senior Analyst and Manager

Confidential, Parsippany, NJ

Responsibilities:

• Configured, set up and implemented Oracle EBS-HRMS applications including CWB and OLM.
• Implemented and managed enhancements, projects and production support activities for Oracle HR, CWB and OLM applications involving entire SDLC processes and change management.
• Performed business requirement analysis and prepared functional and technical design for enhancements and upgrade of Oracle HRMS application.
• Designed, developed and implemented Oracle HR integration with ADP payroll system, Kronos application and other benefit vendors.
• Managed onsite and offshore team of analysts and developers to design and implement quality solutions to support changing HR business processes.
• Managed and deployed major Oracle EBS upgrade projects for major technology and family pack releases for HRMS and financials applications, including ATG RUP7 and HR Family pack K RUP6, to ensure sustained supportability of the application and take benefit of enhanced functionalities.
• Designed and implemented processes for SDLC and code migration that are in compliance with corporate policy on data security and SOX requirements.
• Developed and reviewed system test plans and managed regression testing of HRMS suite of applications during major upgrades and enhancements to ensure application continue supporting functionalities and business processes.
• Designed and developed automated process for Oracle application user management for CWB application.
• Implemented custom user security using security profile for Oracle HR.
• Customization, personalization and set up of Compensation Work Bench module.
• Performed assessment for implementation of Oracle EBS release 12.
• Lead technical team of on-site and off-shore resources on a major HRMS integration project for an acquisition.
• Successfully completed data conversion and interfaces building with an extremely aggressive schedule.
• Gathered business requirement for HR system integration of acquired company including data analysis, data mapping, set-up and configurations.
• Established off-shore development team and coordinated all design and development efforts with them.
• Developed and effectively executed data conversion approach and strategy for the very aggressive implementation schedule.
• Prepared program designs, performed code review and testing for all conversion processes.
• Lead technical efforts by the team of on-site and off-shore resources on an HRMS implementation.
• Prepared instance management plan and strategy.
• Developed conversion approach and plan.
• Prepared technical designs for conversion and interfaces and extensions.

Confidential

Sr. Analyst/Lead - Oracle HRMS, OAB, OTL, Self Service HR

Responsibilities:

• Designed, developed and implemented new PTO plans for the company’s new HR policy.
• Converted employees into new PTO plans.
• Designed and developed customization to employee self service and manager self service applications.
• Developed enhancement to Oracle HR and Payroll, OSB and OTL modules
• Customized workflow for self service applications.
• Supporting Oracle HR and payroll system.
• Developed custom interfaces and reports.
• Set up custom security for controlled user access, including responsibilities, security profiles etc.
• Converted data into Oracle HR Payroll - including design, development, data validation and integration testing
• Designed and developed inbound and out bound interfaces from Oracle HR Pay roll modules.
• Developed HR and Payroll reports using Discoverer.
• Designed and developed interface to load invoices into Accounts Payables.
• Customize reports for responsibility based secure access using secured views.
• Production support to resolve all HR and payroll system issues including tax balances, reports, interfaces.
• Developed Oracle coding standard for development and customization in Oracle application environment.
• Mid-Year Payroll Balance Conversion: Identified required balances to be converted. Designed and developed processes to upload balances. Prepared Test plan for validation of balance conversion.
• Customized fast formulas to pay correctly for mid pay period rate changes.
• Designed and developed processes for conversion of accrual balance.
• Designed and developed inbound interface to import time entry hours from Kronos system through BEE.
• Re-engineered process to update Kronos time keeping system with accruals and entitlements in Oracle HR.
• Designed and developed interface to generate data file of saving bonds deductions and purchase information.
• Gathered business process requirements for the implementation of Oracle HRMS at a large retail client.
• Performed Fit-Gap analysis of Oracle HRMS application Vis a Vis client’s current business processes and future state expectations.
• Identified and analyzed required interfaces between Oracle HRMS and other in house and outsourced systems for inclusion in the project plan.
• Gathered data conversion requirements and developing conversion strategy for this Oracle HRMS implementation.
• Gathered reporting requirements, identifying gaps, and estimating custom development needs.
• Tested, debugged and fixed Oracle HRMS customization work for upgrade from 10.7 to 11i.
• Developed and upgraded Oracle HRMS reports using Brio-Queries.
• Developed and set up custom templates using Forms Configurator to enable one screen entry of new hire.
• Managed patching of applications: identification and testing of mandatory, year end and other patches.
• Set up custom responsibilities and securities involving use of custom PLL.

Confidential, Allentown, PA

Responsibilities:

• Application set up and configuration for flex fields, jobs, grades, competencies, earning elements.
• Gathered business requirements and performed fit-gap analysis to design Oracle HR set up
• Developed process to auto load set up and reference data like look up codes, jobs, grades, organizations, locations etc. for different business groups.
• Reconfigured Oracle HR so as to meet revised business requirements and completed required data migration.
• Implemented additional payment process in Oracle HR-ADP Payroll environment involving gathering business requirements, set up and configuration of Oracle HR as well as ADP payroll, customization of ADP views/connection, unit testing and parallel testing.
• Implemented additional payments for terminated employees involving gathering business requirements, set up and configuration of Oracle HR as well as ADP payroll and testing.
• Customized Oracle HR - ADP Payroll connection interfaces, customized ADP views.
• Designed and developed mass update capability for Organization and cost center.
• Designed and developed automated process to maintain Organization managers and employee supervisors.
• Led team of Consultants designing and developing interfaces and conversion process.
• Gathered business requirements, prepared technical design documents and tested interfaces with vendor systems for 401k administration, Pension plan administration, payroll, mass batch element entry etc.
• Prepared conversion strategy document for data conversion in to Oracle HR using APIs.
• Led successfully, development and implementation of custom ‘Talent Assessment and compensation systems’ an add on to Oracle HR using JAD(Joint Application Development) approach involving following responsibilities:
• Business process analysis to gather, analyze detailed requirements for design use.
• Set up of Oracle HRMS to host final talent assessment and compensation treatment data.
• Application design involving table structure, Forms - user interfaces, security and access, data extract and upload processes (from and to Oracle HRMS).
• Troubleshooting, expediting, unit testing and scheduled completion of development work.
• Actions on feedback from testing, user acceptance tests and user training to address user concerns, enhance functionality and remove bugs.
• Developed reports and processes to clean up Oracle HR data necessary for this application.
• Post implémentation support.

Confidential, Mellville, NY

Responsibilities:

• Developed process to update/alter local tax deduction information for field employees to correct a tax deduction problem
• Set up custom elements for tax balance adjustment and refund.
• Implemented Costing transformation process to convert payroll cost segments into GL cost segments
• Developed process for cost segment validation in GL to identify the invalid segments
• Developed report to detail individual cost elements with invalid segments for GL
• Generated Bonus Information Report
• Led team of technical consultants and provided guidance in their efforts to develop custom reports and interfaces.

Confidential

Responsibilities:

• Developed inventory to GL interface to create Journal Entries for Storeroom labor and expenses
• Developed process to auto create blanket purchase order from quotations
• Developed AP Invoice details report
• Developed inventory transaction listing reports
• Customized user interface to display item DFF on receiving transaction screens
• Customized fast formulas for payroll deduction elements for client specific business rules.
• Developed various custom HR and Payroll and Financials reports.
• Developed HR alerts to send emails automatically on certain events like new hire, terminations etc.
• Developed Purchasing system alerts to notify automatically changes in PO approving jobs or assignments.
• Developed interface programs to create various data files to generate mail merge letters for HR requirements.
• Customized AP check printing, NACHA and remittance advice reports.
• Customized Fixed Assets reports.
• Converted Employees, History, Assignments, Addresses, Salary, Elements and taxes from legacy Servico and ADP system to Oracle HR Payroll using APIs.
• Developed procedure to create batches to convert balances using balance conversion interfaces.
• Troubleshot problems in existing productions environment in payroll process, reports etc.
• Set up and updated payrolls, elements, user defined balances, element links etc.
• Developed various custom HR and Payroll reports.
• Developed an interface programs to create weekly data file of 401k and Stock Purchase deduction
• Designed and Set up earnings and deduction elements, user defined balances, element links.
• Developed highly customized 401k system using customized elements, fast formulas, user defined balances, formula result rules and global values.
• Customized Fast Formulas, wrote custom skip rules and validation rules for Input values for the unique business process of the client.
• Converted Employees, Employee History, Assignments, Addresses, Contacts, Pay Proposals from legacy cyborg system to Oracle HR Payroll using APIs.
• Developed custom interface between retail system and Oracle Payroll to upload retail deduction amount and send back the deduction data and related reports.
• Converted balances, elements and payment methods from legacy system into Oracle.
• Developed custom 401k interface to create and send outbound data file to 401k plan managers.
• Developed custom Cigna inbound and outbound interfaces to send the deduction data and upload the changes in insurance coverage information.
• Set up and Created Concurrent Programs.

Confidential, New York, NY

Senior Analyst and Manager

Responsibilities:

• Set up elements and developed custom fast formulas for Earnings and Deductions to meet the company specific business rules including 401k implementation. Created various global values, custom user defined balances and formula result set up
• Carried out fit gap analysis for Oracle HRMS modules v/s client’s business requirements for HR and payroll functions.
• Implementation of Compensation and Benefits part of the core HR/Payroll.
• This included configuring the various earnings, deduction, workers compensation elements required. Created all the required objects like balances, global values and element links depending upon the functional requirements.
• Converted legacy payment methods data from ceredian system into Oracle Payroll
• Creating new users, responsibilities, defining new applications, defining new reports, defining printers and drivers. Creating new concurrent programs, Creating descriptive and key flex fields.
• Functional and Technical Design of Payroll Register Report
• Designed and created W2 report
• Created custom Fast formulas for Earnings and Deductions including paid leave of absence.
• Converted employee and address data from legacy into Oracle HR Payroll using APIs.
• Prepared functional and technical design for customized invoice printing from Oracle Receivable and custom pricing system. involving understanding user needs, data mapping, layout design etc.
• Developed custom invoice printing system using Oracle Reports 2.5
• Converted purchase orders from legacy application into Oracle Purchasing
• Developed EDI system for outbound purchase orders using Oracle EDI Gateways
• Converted and interfaced Item master in Oracle inventory
• Customized Oracle Accounts Receivable and Oracle Payable reports
• Developed customized process for Electronic Funds Transfer (NACHA) for direct deposit payments from Oracle Payable
• Developed and implemented new custom reports for Oracle manufacturing modules
• Used Oracle Application Implementation Methodology ( AIM ) for approach, design, documentation and implementation of Oracle applications.
• Coordinated and expedited tech nical assistance requests (TARs) with Oracle Support
• Developed interfaces to populate summarized data from the existing applications into new data mart application in networked, Oracle 7.1/Windows NT environment
• Designed and modeled interfaces and cross reference tables for data mart project on Production Sales & Inventory
• Coordinated with users for their requirements and validation of data sources
• Performed testing of interface and validation of data for new procedures scheduled job runs and dependencies to extract data from different sources and interfaces

Programmer

Confidential, NY

Responsibilities:

• Converted programs written for existing DOS environment into MVS environment.
• Developed new application programs in COBOL for financial application.
• Tested converted programs in new MVS environment.
• Developed job streams using JCL to port all the converted programs into new MVS environment from then existing DOS system.
• Developed documentation for recovery and restart procedures in case of process failure.
• Developed and tested systems to upload data files from off site client PCs to mainframe.