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.
• TEMPEffectively 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 teh 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 teh team
• Good understanding of data flow in teh 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 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 teh 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 teh design, implementation and unit test of new development, enhancements, bug fixes and production updates.
• Web methods used for ftping teh file to teh third party servers
• Worked on Taleo connect client(TCC) for creating teh sq.xml and cfg file for teh 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 dat has 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 teh issues related to Rup7 and Year end phase 1 and phase 2 patches for US and Canada legislations.
• Completed teh Year end process for teh W2 generation successfully for all employees.
• Fixed teh issues related to Incentive runs and worked on generating teh compensation projected and final statements.
• Responsible for preparing teh functional and technical specifications for teh 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 teh 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 teh initial phase of teh project providing functional and technical expertise wherever needed.
• Responsible for Functional Setup of teh OTL Module
• Implemented OTL Module to track teh time entered by teh 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 teh employees.
• Validation is performed on teh timecard to enter time on all days for casuals in order for teh 6th and 7th OT rule to work. Future Overtime hours are also avoided by performing teh 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 teh 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 teh 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 teh 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 teh interfaces to transform teh data from Oracle HR and Payroll Systems to OneSource data warehouse to load teh 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 teh existing oracle legacy tables to teh fusion columns and GUIDS. Generated xref from fusion and placed in temp tables within oracle which is used for data extraction.
• All teh HR and Payroll related data is mapped as per teh FBL Mapping sheet and data is loaded to Oracle Fusion using teh 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 teh business needs.
• Created Workforce structures using data roles, person security profile and organization security profile.
• Developed OTBI reports using teh 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 TEMPeffectively 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 teh bonus for teh financial year.
• Designed and developed a web application interface for teh users to enter teh data related to teh acquired employees, validate teh 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 teh Web ADI's .
• Implemented teh data mapping, data conversion plan, interface of oracle with Taleo, Success Factors, Corner Stone, Ceridian payroll software, JDE, Positive Pay
• Developed OTBI reports using teh existing subject areas and also used OBIEE to create custom subject areas for HR reporting.
• Headed teh Remedy tool for Tracking and Solving teh Incidents logged post production.
• Instrumental in providing teh training to teh oracle end users to use teh system TEMPeffectively.
• TEMPEffectively managed teh change management process using teh custom developed tool called iCapture to submit and acknowledge teh tickets, service requests, enhancements and issues in teh 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
• Gatheird requirements for teh 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 teh client aware of teh 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 teh time card, Approvals to send teh time card for approval and various notifications to notify teh managers and employees about teh timesheet.
• Customized teh timecard layout to remove certain fields like cost center from teh payroll time card layout. Used OTLR and defined Earning policies to perform teh time card explosion.
• Ran teh 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 teh requirements for teh process re-engineering
• Prepared Business Requirement Documents (BRD’s) after teh collection of Functional Requirements from System users dat 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 teh PeopleSoft Scheduler, replacing teh compatible Autosys scheduler.
• Developed various shell scripts to meet teh 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 teh entire system and release for UAT.
• Created a Traceability Matrix to maintain teh Traceability of teh 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 teh cemli to customer. Highest achievement was go live occurred 15 days prior to teh 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 teh 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
• TEMPEffective 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-Teh-Shelf approach including custom forms, OA objects, reports and alerts
• Coordinated/communicated requirements between teh client and technical developers to ensure accurate deliverables such as AME rules, Discoverer reports, Workflow customizations and OA pages
• Assisted teh 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 teh 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 teh 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 teh requirements and functionalities.
• Performed System Study, Design and Implementation of teh system.
• Performed testing and Quality Assuring with client as per teh 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 teh 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 teh module
• TEMPEffective 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 teh current business base line to identify teh impact of R12.0.6 on teh 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. Teh 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 teh 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 teh Bug Reports for teh 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 teh Employees and Assignment Data for more than 50k records
• Created impact as a member of teh “Global Service delivery team” in support of global deployment of OTL to 28 agencies within teh 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 teh delivery of teh 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 teh strategic technology plan of teh OTL module, worked closely with teh agency to understand requirements and to ensure dat teh 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 has been taken, software configuration, and for teh planning, communicating, prioritization, and overall project management for teh applications supporting teh global OTL model as well as measuring teh overall activities and TEMPeffectiveness.
• Was also involved in teh Payroll setups:
• Setup/ Creation of Elements, Salary Basis, Links, Element Sets and Assignment Sets
• Used BEE (Batch Element Entry) to upload teh bulk element entries.
• Involved in Payroll Creation Setup and running Payroll, Retro Pays, Prepayments, Costing and Transfer to GL programs.
• Wrote teh Fast formulae and User defined functions, wherever required.
• Developed an Interface from PF to Payroll and generated reports.
• Involved in reconciliation of payroll.