SUMMARY

• Over 9+ Years of IT experience in enterprise - wide Oracle Applications design, development, systems analysis, defining system standards and database administration and 11i / R12 implementations, Upgrade from 11i to R12.
• Good Experience in major R12 Implementations, R12 Upgrade and 11i / R12 and Production Support especially for Oracle HRMS Modules like Core HR, Self Service (SSHR), Payroll, OTL, Advance Benefits (OAB), Compensation Workbench (CWB), iRecruitment, Projects and Oracle Performance Management.
• Implemented Fusion HCM Module along with CWB.
• Effectively used HCM Extracts, Fusion BI Reporting Tool and FBL Loads for Data Migration from apps to fusion and data validation.
• Expertise in Client Interaction, Requirement Gathering, Process walkthrough, Functional Mapping, GAP Analysis and Functional and Technical Design documentation and Full lifecycle implementations, Upgrades and Production Support.
• Support of Production and Test instances for upgrade/regression/integration/User acceptance testing. Test Plan Preparation, Technical design and Coding, UAT, Production Migration and documentation in Oracle Applications.
• Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.
• Sound understanding and expertise in Oracle E-Business Suite architecture and integrations between modules especially for HRMS areas.
• Excellent in preparing functional and technical specifications like BR.030, BR080, BR.100, BR.110, CV.010, CV.040, MD.020, MD.050, MD.070, TE.020, TE.040 using AIM Methodology
• Well experienced in understanding and using various migration tools like Kintana, SVN, UNITASK from test environment to Production environment.
• Experience in design of RICE (Reports, Interfaces, Customizations and Extensions) objects to as per the custom business process within Oracle HRMS implementation.
• Proficient in System Administration, Application Object Library, Web ADI.
• Expert in OTL Implementations in US for Exempt and Non Exempt employees and integrations to Projects.
• Excellent command over various reporting tools like Discoverer, Reports10g, XML/BI Publisher.
• Deep experience in analysis, design and development of business solution analysis from a full life cycle perspective and capable of guiding others in solution analysis.
• 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.
• Proficient in defining Users, Responsibilities, Creating Functions, Menus, Request sets, Request groups, Registering Concurrent programs, Lookup types and defining Value sets.
• 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
• Proficient in Alerts, Oracle Workflow Builder and AME for managing Approval Authorities and Business Flow.
• Ability to manage complex projects and to resolve significant business and systems issues.
• Outstanding expertise in gap analysis, application design, application configuration, application customization and personalization, CRP and UAT run and production support.
• Managed all implementations with a high degree of client satisfaction. Projects were completed on schedule and met all utilization and profitability targets.

TECHNICAL SKILLS

Applications: Oracle Fusion HCM, Fusion CWB, Oracle Apps HRMS(11i and R12), Oracle HCM Suite, Core HR, SSHR, Payroll, Advance Benefits, CWB, OTL, iRecruitment, Projects, PMS, Oracle Talent Management, OLM, iExpenses, FA, Service Oriented Architecture(Oracle SOA)

Framework: OAF, ADF

ETL Tools: SSIS, EDI, Informatica

Database: Oracle 9i/10G/11g

Operating System: windows (NT/ 2008/2007/2000/2003/ XP), Unix, Linux

Languages: SQL, PLSQL,C, C++, Java, J2EE, Unix Shell Scripts

Reporting Tools: Discoverer, Report builder(6i/10g), XML Publisher, BI Publisher, OBIEE, Fusion HCM Extracts, Fusion BI Reports, OBTI, Cognos Reporting Tool

Utilities: Toad, SQL Developer, jDeveloper10g/11g, Putty, WINSCP, Workflow Builder, AME, Data Loader, Form Builder 6i and 10g, Reports 6i and 10g, HTML Javascripts, Visio, Discoverer, BI Publisher, XML, Java, Oracle SQL, PL/SQL, Microsoft OfficeVisier Analytics Reporting, Taleo Connect client (TCC), Appworx, Web Methods, HP-PPM, Quality Center(QC)

Interfaces: Taleo, ADP, JDE, Success Factors, Corner Stone, Ceridian, BOA, BCBS, Positive Pay, Harbor flex, Eyemed, Liberty Mutual, American Express, Cognos, OBIEE

Migration/Data Source: Orion, Kintana, PVCS,SVN

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle HRMS Lead Consultant

Environment: R12.1.3 with Oracle 11.2.0.1.0 , Taleo Connect Client(SCORE) and Corner Stone (LEAD) in SAS model.

Responsibilities:

• Functional Analyst for the inbound and outbound interface configuration for data extracts to vizier.
• Employee Profile, Cost center Hierarchy, Organization Hierarchy, Supervisor Hierarchy, Hire Event, Pay Event, Compensation profile outbound interfaces were designed and developed.
• Involved in business requirements finalization process, assisted functional team in design, gap assessment, and process redesign sessions
• 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.
• Web methods used for ftping the file to the third party servers
• Worked on Taleo connect client(TCC) for creating the sq.xml and cfg file for the Requisition profile, Requisition Offer event, Requisition Event, Requisition Applicant Profile using projections fields including date projection, different function projections(such as concat, to char, Average, cast etc) and multilingual field projections.
• Used complex projections to segregate columns that have values from one field. Developed csv,xml,text files using Taleo Connect Client (TCC) as per client requirements.
• Designed and developed a new hire interface from TCC to Oracle.
• Assisted in all the issues related to Rup7 and Year end phase 1 and phase 2 patches for US and Canada legislations.
• Completed the Year end process for the W2 generation successfully for all employees.
• Fixed the issues related to Incentive runs and worked on generating the compensation projected and final statements.
• Responsible for preparing the functional and technical specifications for the RICEW components.
• Responsible for Apps User Training Documents and Test Script Documents
• Code version is maintained using PVCS and migration is automated using HP-PPM.
• Ensured all test cases are recorded in the quality center(QC).
• Designed employee date tracked report, new hire report, employee assignment report, organization wise summary report to show regular earnings, over time earnings, sick leave earnings, regular hours worked
• Acted as solution architect from the initial phase of the project providing functional and technical expertise wherever needed.
• Responsible for Functional Setup of the OTL Module
• Implemented OTL Module to track the time entered by the employees. Different timesheet layouts were used for Exempt and Non Exempt employees and OTL Explosion setup is performed to provide additional allowances and Overtime for the employees.
• Validation is performed on the timecard to enter time on all days for casuals in order for the 6th and 7th OT rule to work. Future Overtime hours are also avoided by performing the time entry validation using custom fast formula.

Confidential, Chicago, IL

Oracle HRMS Lead Consultant

Environment: R12.1.3 with Oracle 11.2.0.1.0 , Oracle Fusion CWB in SAAS model.

Responsibilities:

• Team Lead for implementing Oracle R12 HRMS modules HR, SSHR, 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.
• Participated in detailed Payroll requirement information gathering needed for Reports Customization
• Maintenance of Employee Information through Oracle Apps including Personal Details, Educational Qualifications, Skill Profile, Work Experience and Joining Data.
• Worked on Conversions for Jobs, Extra Information Types, Personal Payment Methods and Elements
• Designed and developed the interfaces to transform the data from Oracle HR and Payroll Systems to OneSource data warehouse to load the data to Staging tables using ETL tools like SSIS Packages.
• Implemented Oracle Time and Labor for US, Canada and Australian Legislations.
• Implemented Oracle Fusion HCM Module along with CWB. Here Oracle R12 is upgraded to Fusion. Mapped the existing oracle legacy tables to the fusion columns and GUIDS. Generated xref from fusion and placed in temp tables within oracle which is used for data extraction.
• All the HR and Payroll related data is mapped as per the FBL Mapping sheet and data is loaded to Oracle Fusion using the FBL V8.0 (File Based Loads) and Spreadsheet loader concepts in Fusion.
• Data is validated using HCM Extracts, Fusion BI Reports and OTBI Reports.
• Configured Lookups, Enterprise Structure, Legislative data group, Legal Entity, departments, business units, locations, jobs, assignment status, salary basis, payroll and elements in oracle fusion environment. Workforce Management, Payroll, Compensation, Manager Resources, Career, My Information are configured as per the business needs.
• Created Workforce structures using data roles, person security profile and organization security profile.
• Developed OTBI reports using the existing subject areas and also used OBIEE to create custom subject areas for HR reporting.
• Created HCM Extracts for outbound and inbound interfacing in fusion. Used Reports and Analytics effectively to create custom BI Reports in Fusion for data validation and data extraction.
• Compensation plans/ Workforce Compensation and eligibity is configured in fusion and an xml file is generated as output which can be sent to payroll for processing the bonus for the financial year.
• Designed and developed a web application interface for the users to enter the data related to the acquired employees, validate the data and upload them into oracle applications system. Person, Address, Phones, EIT, Contacts, Assignments, Salary, Elements, SIT, Benefits, Taxes and Direct Deposit data is loaded in a single stretch using the Web ADI's .
• Implemented the data mapping, data conversion plan, interface of oracle with Taleo, Success Factors, Corner Stone, Ceridian payroll software, JDE, Positive Pay
• Developed OTBI reports using the existing subject areas and also used OBIEE to create custom subject areas for HR reporting.
• Headed the Remedy tool for Tracking and Solving the Incidents logged post production.
• Instrumental in providing the training to the oracle end users to use the system effectively.
• Effectively managed the change management process using the custom developed tool called iCapture to submit and acknowledge the tickets, service requests, enhancements and issues in the existing production environment.

Confidential, San Ramon, CA

Oracle HRMS Functional Lead

Environment: R12.1.3 with Oracle 11.2.0.1.0

Responsibilities:

• Designed and documented Work structures and Key Flexfields, Descriptive Flexfields, Special Information Types and Extra Information Types setups.
• Designed, setup, tested and documented sysadmin and security related setups.
• Designed core Recruitment processes, Employee Personal Information processes, Employee Assignment Information, New Joinee process, Exit process, Appraisals & Talent Management, Payroll processes and other Workforce Management processes.
• Setup and tested Manager Self-Service and Employee Self-Service responsibilities and menus
• Defined complex personalization’s and customizations for MVC based OA framework to meet business requirements
• Gathered requirements for the OTL Module implementation and designed solution for various OTL interfaces to Payroll, Projects and third party vendors.
• Participated in detailed Payroll requirement information gathering needed for Reports Customization.
• Worked on Conversions for Jobs, Extra Information Types, Personal Payment Methods and Elements.
• 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.
• Conducted meetings and presentations to make the client aware of the balances to be converted from legacy to Oracle for mid-year payroll process.
• 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 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.
• Managed a team of functional & technical consultants to deliver RD50, BR 30, BR100, TE20, MD 50 and MD 70 documents
• Designed functional specifications for out of box technical components such as a) alerts b) AME c) OA customizations d) Reports (PL/SQL, Discoverer & XML Publisher) e) Fast Formulas f) Workflow
• Implemented OTL with special earning rules for Earning policies. Created workplans, rotation plans, earning policies, holiday calendar, OTL Approvals, Alerts and OTL Custom reports.
• Designed and developed interfaces from OTL to Payroll and other third party systems.
• Created custom time entry rules to validate the time card, Approvals to send the time card for approval and various notifications to notify the managers and employees about the timesheet.
• Customized the timecard layout to remove certain fields like cost center from the payroll time card layout. Used OTLR and defined Earning policies to perform the time card explosion.
• Ran the Transfer time from OTL to BEE, Validate BEE, Transfer to BEE Process to import timesheet data from OTL to Payroll.
• Assisted end users with documenting new business procedures and test scripts for CRP & UAT

Confidential, San Ramon, CA

Solution Architect

Environment: PeopleSoft 8.9, Oracle 10g DB.

Responsibilities:

• Thoroughly studied the requirements for the process re-engineering
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Involved in design of Customizing the PeopleSoft Scheduler, replacing the compatible Autosys scheduler.
• Developed various shell scripts to meet the ftp/sftp requirements for various banks (private servers).
• Encryption and decryption is performed by pl/sql custom code to protect passwords and successfully called them from PeopleSoft scheduler.
• Testing of the entire system and release for UAT.
• Created a Traceability Matrix to maintain the Traceability of the requirements.
• Created Impact Analysis documents after discussions with development team which included roll back plan in case of any issues while being merged into production.
• Held weekly meetings with developers and QA/testers (On site & Off shore) to ensure project deadlines were being met.

Confidential

Oracle Applications HRMS Lead Consultant

Environment: R12.1.0 with Oracle 10.2.

Responsibilities:

• Team Lead for 11. version upgradation. Responsible for planning, co-coordinating, meetings, coding, testing and release of the cemli to customer. Highest achievement was go live occurred 15 days prior to the planned schedule due to automation of certain activities like upgrade impact assessment, patch impact assessment, proper testing strategy with a 0.001% defect logs.
• Responsible for preparation of User Manual and Test Scripts and delivery of all Custom Components.
• Involved in coding for almost all modules.
• Managed as a Lead Consultant for Implementing SSHR, iRecruitment, iExpenses and CWB modules on R12 environment.
• Defined and documented business requirements for Oracle Human Resources including HR Self Service, Recruiting, Appraisals and Compensation, etc
• Designed, configured and documented HRMS security setups including Responsibilities, Request Groups, Custom Forms, Task flows, Menus, Functions and Security Profiles
• Defined personalization’s within the Self-Service framework including removing fields/regions, adding tips, modifying field prompts and modifying field characteristics
• Facilitated and managed communication with Oracle Support/Development regarding TARs from problem inception to resolution
• Effective change management by liasioning with end users, technical developers, security, audit, data centers and customer support teams
• Identified and delivered 62 technical objects in a Customize-Off-The-Shelf approach including custom forms, OA objects, reports and alerts
• Coordinated/communicated requirements between the client and technical developers to ensure accurate deliverables such as AME rules, Discoverer reports, Workflow customizations and OA pages
• Assisted the client in developing new procedures for processing various HR transactions including new hires, transfers, terminations and payouts
• Extensively worked in Security Administration on creating application users, responsibilities and securing access to forms and reports for different hierarchy of users.
• Managed salary and grade related pay and progression. Mapped market compensation surveys to the jobs and positions. Set up and administer Individual Compensation Distributions (ICD)
• Maintain a vehicle repository and allocate company vehicles to employees
• Use absence types, categories, and reasons to track and report employee absences.
• Extensively worked on OAF extensions, Interfaces and ftp servers.
• 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
• Interacted with users to resolve any issues during the production, development and enhancement phases in both Technical and Functional aspects.

Confidential

Techno Functional Consultant

Environment: Oracle Applications 11.5.10 with 9i

Responsibilities:

• Created Business Requirement Document, Use Cases, UI Document and Functional Requirement Document for documenting the requirements and functionalities.
• Performed System Study, Design and Implementation of the system.
• Performed testing and Quality Assuring with client as per the business requirements.
• Designed processes for time & salary element maintenance, time entry, time approval, time administration
• Created rules for overtime, shift differential, holiday premium elements for different set of employees consisting of Hourly and Salaried.
• Modified timecard layouts & templates to capture mileage and location information.
• Implemented different approval rules to meet all the business requirements.
• Interfaced with Technical consultants to develop reports such as Missing Timecards, Hours reconciliation from Timecard to Payroll, Timecards with Errors.
• Identified scope, process, requirements, solutioning, build, testing, rollouts, knowledge transfer and support mechanism for a) Competency framework b) KRA setting c) Competency assessment
• Identified scope, process, requirements, solutioning, build, testing, rollouts, knowledge transfer and support for a) hiring solutions b) employee management c) employee development d) employee exit
• Identified fitment and gap areas and advised client on implementation strategy
• Created RD50, BR30, BR 100, TE20, MD 50 and reviewed MD70 for the module
• Effective change management by liasioning with end users, technical developers, security, audit, data centers and customer support teams
• Assisted in re-engineering end user training documentation and business procedures

Confidential

HRMS Analyst

Environment: R12.0.6 with Oracle 11.1

Responsibilities:

• Understanding BAA current business processes and setting up the current business base line to identify the impact of R12.0.6 on the current system.
• Change existing Fast Formulas for all pro-ratable salary components.
• Designed and Developed Payroll Accounting interface to distribute Labor Costs across various cost centers inOracle Payroll. The costing file was sent by Rebus, which was apportioned across to Cost Centers & PayrollElements using Oracle Element Entry API's. Over 1 Million transactions were processed using this each month.
• Developed a bespoke process to interface selected element entries from BEE, so as to update Payroll Balances.
• Wrote functional specifications for custom processes needed to update employee salary records
• Developed Fast Formula in Oracle Payroll to transfer values from one payroll balance to another.
• Analysis and Bug Fixing of Incident Reports by Client. Production Support
• Preparation of Test Cases, Test Scenarios for Custom Components and Payroll module.

Confidential

Techno Functional Consultant

Environment: 11.5.10 with 10g

Responsibilities:

• Designed the PF Module (bolt on)
• Documentation for ‘Requirements gathering’, ‘Functional design documents’, ‘Testing scenarios’.
• Configuration set-ups for HR, SSHR, Irec (Key and Descriptive flex fields, Organizations, Hierarchies, Security profiles, Lookups, Menus, Responsibilities, Functions).
• Preparation of deliverable documentations using Oracle AIM templates.
• Responsible for preparation of User Manual and Test Scripts.
• Coding for almost all modules and Complete PF Bolt on.
• Prepared the Bug Reports for the project.
• Assisted in database Design
• Extensively Worked On Alerts, SIT Validation, AME and Workflows, Reports with D2k and Discoverer, Custom Forms, Interfaces, Custom Processes, UserHooks, WEB ADI Letters and XML Letters.
• Developed scripts for Data conversions/Data Migration. Migrated the Employees and Assignment Data for more than 50k records
• Created impact as a member of the “Global Service delivery team” in support of global deployment of OTL to 28 agencies within the Department of Royal Jordan Airlines. Successful delivery of Oracle HRMS solutions and performed integration for complex, cross-functional systems in a multi business group environment. Own the delivery of the release items, modifications, enhancements, personalization and extensions to programs and interfaces. Identify opportunities for improvements to meet customer needs in a repeatable, scalable way while improving quality
• Functioned as a trusted technology advisor and accountable for delivering the strategic technology plan of the OTL module, worked closely with the agency to understand requirements and to ensure that the business is aware of technology implications relating to business plans. Provided administrative support for data conversion, additional responsibilities include trouble-shooting problems documenting and reporting back after corrective measures have been taken, software configuration, and for the planning, communicating, prioritization, and overall project management for the applications supporting the global OTL model as well as measuring the overall activities and effectiveness.
• Was also involved in the Payroll setups:
• Setup/ Creation of Elements, Salary Basis, Links, Element Sets and Assignment Sets
• Used BEE (Batch Element Entry) to upload the bulk element entries.
• Involved in Payroll Creation Setup and running Payroll, Retro Pays, Prepayments, Costing and Transfer to GL programs.
• Wrote the Fast formulae and User defined functions, wherever required.
• Developed an Interface from PF to Payroll and generated reports.
• Involved in reconciliation of payroll.