SUMMARY

• Over 6 years of IT experience with over 5 years of experience in Implementation of Oracle HRMS Applications.
• Expertise on the following Oracle HRMS modules. Human Resource Management System (HRMS) of Oracle Applications including Oracle Human Resources(HR), Oracle Payroll, Oracle Advanced Benefits(OAB), Oracle Time and Labor (OTL), Oracle i - Recruitment, Oracle Learning Management and Oracle Self Service Human Resources(SSHR).
• Excel in preparation of Functional Design (MD.050), Fit/GAP Analysis (BR.040), Conversion Design (CV.040), CRP and Go-Live Test Scripts (TE.040) documentation using AIM standards for HR, SSHR, Oracle Payroll and OAB modules.
• Assisted in Oracle E-Business Suite’s BR100 preparation and used Application Implementation Methodology (AIM).
• Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.
• Experience in design of RICE (Reports, Interfaces, Customizations and Extensions) objects to as per the custom business process within Oracle HRMS implementation.
• Sound understanding and expertise in Oracle E-Business Suite architecture and integrations between modules especially for HRMS areas.
• Excel in Oracle Human Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.
• Excellent ability to support multiple simultaneous technical assignments in a fortune organizations as well as leading the team.
• Sound experience Oracle E-Business Suite R12 new features including Multi-Org Access Control.
• Outstanding expertise in gap analysis, application design, application configuration, application customization and personalization, CRP and UAT run and production support.
• Expertise in Oracle Payroll configuration with Oracle Time and Labour and Oracle Benefit modules in Multi-Org environments.
• Expertise in designing of payroll inbound and outbound interfaces and which and related to non Oracle Payroll entrainments like ADP, Integral or Ceridian payroll as well and Oracle Payroll base environment.
• Expertise in payroll balance configuration and conversion, year-end and mid-year balance adjustment, execution of payroll processes, generation of Payslip, W2 and government reports for Oracle Payroll.
• Experience in Multi-Org Global Oracle E-Business Suite implementation.
• Expertise in writing and modification of Fast formulas used in Oracle Payroll, Oracle Advanced Benefits and Oracle Time and Labor for US, Canada and UK legislation.
• Expertise in Oracle Payroll compensation management, Salary review, designing of especial earning rules using Fast formulas.
• Proficient in defining Users, Responsibilities, Creating Functions, Menus, Request sets, Request groups, Registering Concurrent programs, Lookup types and defining Value sets.
• Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.
• Excellent ability to support multiple simultaneous technical assignments in a fortune organizations as well as leading the team.
• Good understanding of data flow in the different modules of Oracle Applications & Excellent problem-solving skills and ability to multi-task.

PROFESSIONAL EXPERIENCE

Confidential

Sr Oracle HRMS Consultant

Responsibilities:

• Part of a team implementing Oracle R12 HRMS modules HR, Advance Benefits, OTL and Payroll. Assisted in Business process mapping and prototyping, gap analysis, solution design, HRMS setup, testing and user training.
• Setup all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centers, worker’s compensation codes/rates, Global Values, Application Utility Lookups, Security Profiles and reports within the Oracle HRMS module for all applicable localizations, Setup HR related Descriptive Flex Fields, Key Flex Fields, Validation Sets, Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility
• Set-up employee self-service to for updating employee personal data on-line. Customized management self-service for viewing and updating multiple employee status data. Did set-up for employee self-service for reviewing job descriptions and applying on-line. Performed set-up on on-line position management for overseeing the entire hiring process from posting to interviewing to hiring
• Set up career and succession management functionality including identifying employee needs and training program enrolment. Set up Health, Safety, and Labour Relations Management functionality including tracking labour relation issues, incidents, accident investigation, compensation claims, and medical examinations.
• Participated in detailed Payroll requirement information gathering needed for Reports Customization
• Customized Self Service Time Expenses responsibilities using the Time and Expense Self Service Menu with menu exclusions, Mass Timecard Approval using the OTL Self Service Approval Menu and Work list Timecard Approval using the OTL Work list Timecard Approval menu
• Performed configuration and setup for predefined approval styles and approval process “OTL Auto Approve” and “Projects Override Approver” as per the business requirements
• Involved in defining Elements, Element sets, Assignment sets, Consolidation set, Element links & Worked on Transferring Timecards to BEE.
• Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
• Was involved in defining Compensation Work Bench setup like Defining Distribution Budget, Budget Reserve, Worksheet Budget, Worksheet Amount, Recommended Amount, And Eligible Salary.
• Extensively worked on 401K interface for payroll bi-weekly employees & Was involved in process of setting up Hiring Applicants and Terminating employees.
• Maintenance of Employee Information through Oracle Apps including Personal Details, Educational Qualifications, Skill Profile, Work Experience and Joining Data.
• Worked on Open Enrolment process and defined Flex credit programs & on Conversions for Jobs, Extra Information Types, Personal Payment Methods and Elements.
• Extensively involved in setting up Date tracking modes and termination process & Designed M50 documentation for payroll and HR conversions.
• Designed applications extensions for custom retro pay process based on time skip in OTL and payroll interface.
• Worked on functional design for conversions of Jobs, Extra Information Types, Personal Payment Methods, Elements using Oracle seeded API’s.
• Scheduled and executed the design, implementation and unit test of new development, enhancements, bug fixes and production updates

Confidential

Oracle HRMS Consultant

Responsibilities:

• Worked on Oracle E-Business Suite R12 implementation which includes Core HR, Oracle Payroll, Oracle Time and Labour and Oracle Advance Benefit modules.
• Assist Functional team in Business Requirement Specification (BR100) for HR and Payroll.
• Designed legacy data conversion strategy for HR, Payroll, OAB and OTL modules and performed lead rule for configuration in CRP1, QA and cut-over phases.
• Involved in business requirements finalization process, assisted functional team lead in design, gap assessment, and process redesign sessions.
• Performed OTL setup by defining Approval rules, Hours types, Time entry rules, Approval styles and Setting up the Preferences.
• Configured mapping of timecards elements of OTL with Oracle Payroll earnings for Multi-Payroll environments.
• Developed functional specification and performing actual conversions from legacy system to Oracle applications.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Analyzed and mapped legacy balances with Oracle payroll elements and prepared technical specification for Payroll Balance Upload.
• Created Crosswalk table between Legacy and Oracle elements, balances and geo-codes.
• Conducted meetings and presentations to make the client aware of the balances to be converted from legacy to Oracle for mid-year payroll process.
• Resolved issues with fast formulas, Elements, setup, year-end processing, tax with holdings, balances conversion and maintenance, employee W2, online pay slips, Employee and Tax balances, involuntary elements, Payroll-Benefit related issues.
• Created new elements with compliance to FLSA, PTO plans and fast formulas were created.
• Assisted functional team and end user for Payroll Pre-processing, Payroll Processing, Process Payroll Using subsets (Assignment set, Consolidation set, Element set), Elements creation, Payroll Post processing, Costing, Year End Process, Federal/State W2, Employee W2, NACHA, Deposit Advices, Direct Deposit, Adjust Balances, Check writer, Quick pay, Rollbacks, Retries, Reversals, Run various reports, Retro pay Process and Absence Management (PTO).
• Designed Spec. for month-end Benefit Balance validate and update to Oracle payroll, developed programs to upload time from contingent worker time system to OTL which includes time and project attributes for OTL module.
• Designed employee date tracked report with payroll balance, new hire report, employee work history report, organization wise payroll summary report which match expanse accounts and prorate regular earnings, over time earnings report for payroll, sick leave report to show payroll deduction history, regular hours worked and earning using PL/SQL, Oracle Concurrent Manager and UNIX Shell scripts.
• Designed various inbound interfaces (person import, Email import, Absence import Encryption SSN and IRC autohire import) and outbound interfaces (TROWE extract 401k, EMEA payroll extract and Ultra link Census Extract).
• Was responsible in defining Advanced Benefits, Eligibility Factors, Eligibility Profiles, Programs, Plan types, Plans and Options, Enrolment Requirements, Flex credits, Benefit Pools, and Standard Rate Calculation & Was involved in Setting up US Regulatory plans like Imputed Income and COBRA.
• Involved in setting up Key Flex fields, Descriptive Flex fields, Special information types, extra information types for HRMS module and mapping of Costing fields with Oracle financial.
• Was involved in setting Salary Administration setup and absence management & Worked on Catalogue security and managing enrolments in oracle Learning Management.
• Modified the seeded HR workflow processes as per the their needs for Oracle Self Service and Payroll.
• Created Alerts to send emails to employees on new hired, enrolment or termination of benefits, open enrolment, timesheet entry issues and year-end processing notices.
• Was involved in Unit testing, System Testing and in phase of UAT across multiple environments.

Confidential

Oracle Business Analyst

Responsibilities:

• Providing functional support, administration and configuration of the eBS 11.5.10 based CRM system including Sales Online, Telesales, Marketing, Advanced Pricing, CDM and Partner Management modules. Participate in existing projects to expand our deployment of the partner modules adding CRM, telesales and integrated marketing in an indirect, B2B tiered sales model. Support the integration of the Oracle applications with other global systems to provide a consolidated business intelligence platform, employee and partner facing web services
• Supporting reporting, analysis and business intelligence needs including developing SQL queries and using both Oracle and other (eg Cognos) reporting tools.
• Working with functional users to analyze business processes and align with existing software capabilities and data structures, deploy new features, adjust configurations or specify customizations or enhancements as needed. Create requirements and training documentation for following Modules - Marketing Online, Telesales, Advanced Pricing and i-Store (Partner Facing)
• Demonstrated functionality of Oracle Sales and Marketing modules like - Collateral Fulfillment, Events Setup and Registration, Campaign Setup and Flow, Email Blasts and Lead Generation, Advanced Pricing Setups, Sales Forecasting, i-Store Partner facing setups.
• Designed solution for lead to email campaigns, Conducted end user testing with business users for above Modules preparing test cases
• Performed setups for above modules in test and Production environment and Roll-out to production instance
• Worked with Oracle Support / Metal ink to resolve bugs and defect management.
• Provided production support, Evaluate and escalate support issues as required internally for modules Sales Online, Marketing Online, Telesales, Universal Work Queue, Partner Management, Advanced Pricing and iStore (1000+ external users and 50 internal users)
• Evaluated R12 version of oracle, feature comparison, effort estimation for upgrade, redesign - conversion effort

Confidential

Business Analyst

Responsibilities:

• Involved in reviewing the current business model BP040 and had presentation of future business model BP80 during CRP phase.
• Presented demos of new features of R12 financials to key stakeholders during design workshops.
• Prepared application setups BR100 and applications extensions functional design documents MD50.
• Configured the chart of accounts structure based on the current company's structure of the as-Is process of the business post CRP session with finance team IT team process champions.
• Involved in setup for AP, PO, GL based on deep understanding of the functional processes & Set up AP bank accounts, bank documents, bank codes and expense report templates.
• Setting up PO matching option, invoice tolerances, distribution options, terms, holds etc and setting up payment methods, payment format and payment process profile etc.
• Created responsibilities, functional securities, user assignments and set the profile options in FND.
• Set up suppliers, locations, and purchasing quick codes in AP & payment terms, invoice distribution, matching of invoices against PO.
• Defined profile options to specify certain implementation parameters.
• Configured user management using FND to setup users and assign responsibilities and set profile options.
• Testing of all functionalities like creation of journals, posting the journals, reversing the journals, creation of asset, and depreciation calculations etc in the testing environment.
• Trained business users and troubleshooting during user acceptance Test UAT & Prepared end user training material with specific business cases and conducted end-user training.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities.
• Worked with the system administrator and DBA to resolve issues like concurrent manager queues, conflict etc..
• Prepared system integration test scripts TE.040 for UAT sessions and training documents with screenshots for end users.
• Participated in testing, user accepting testing in test instance and worked with certain key super users.