SUMMARY:

• Around 9 years of vigorous and energetic experience with a successful track record in all extensive HRMS ERP background from requirements gathering, investigation, analysis, estimation, design, configurations, management, development, testing, implementation, customization, upgrades to maintenance and support of business applications in most of the Oracle Fusion HCM Cloud, EBS releases, PeopleSoft, and large complex ERP systems application life cycles.
• Expert in giving introductory, familiarisation,, CRPs, workshops and design validation cycles to the high number of diversified business users.
• Good leadership and commination skills, on time deliveries, multi - tasking and assisting clients in the selection, implementation planning, fit/gap (As Is - To Be analysis) with alterative solutions for product limitations., Testing (test scripts, validations and POC’s) post-implementation support in mass updates, data loading and design changes of Oracle Fusion HCM cloud/SaaS solutions at various customer sites.
• Expert in analysing future and current process modelling, Data Structures, Design Specifications, Application Mapping, Unit, Integration and system testing’s.
• Expertise in all major Fusion HCM Offerings: Workforce Deployment (Global/Core HR, Profile, Securities, ESS/MSS, Absence, Payroll, Time and Labour (OTL) and Workforce Development (Talent Review, Performance, Goal and Succession Managements, Taleo, Compensation Management (Oracle Advance Benefits, Incentive, Individual and Mass Workforce Compensation.
• Designed Enterprise level solutions for both Global HR and Payroll along with Fusion HCM, Finance & Order Management architects in the initial designs and one time enterprise level setups including multiple legal entities, business units, data set assignments, common application configurations Positions and geography set ups.
• Experience in predefined and complex custom approval hierarchy flows, task configurations and BPM Management. ESS and MSS, Securities ( Data, Job and Duty roles, aggregate privileges and permissions ) and well versed in the configurations of OIM, OAM, APM and Security Console level setups.
• Excel in interacting with the project team members and responsible for coordination with team in developing reports, interfaces, data conversion programs requiring HRMS integration and conversion from legacy ERP to Fusion with various vendors.
• Worked on Enhancements, Service & Change Requests, Production Supports, Application Extensions and able to lead discussions during business requirement meetings and responsible for generating credible leads via customer presentations, assist in Pre-Sales efforts and project estimations.
• Experience in span business process like understanding and interpreting fast formulas, profile and workforce directory management, approvals and securities, SQL Loader, FBL and SSL, PBL, HCM Data Loader (HDL) Full Mode, HCM Extracts, Data Modelling, OTBI, OBIEE/BIP custom and predefined Report and Subject Areas (added hands on experience in ETL Informatica mappings with DAC loads and ODI functionality).
• Technical skill sets including Programming Skills, Application Designer, PS Query, JCL, SQL PL/SQL and PL/SQL Stored Procedures, Functions, Packages, Triggers, FNDLOAD scripts and Expression Builder Functions/Operations.
• Followed Agile/Scrum, AIM and OUM Methodologies and coordinated with offshore and onsite teams for client specified requirements and assignments, involved in day to day requirement sessions with distinguish team leads, business system analysts and business users. Worked with Oracle implementation specialists and Satisfaction Managers on complex decision making scenarios.
• Worked on Eligibility Profiles, Eligibility Criteria, Utilised all six types of Derived Factors for HR, Compensation, Absence, Payroll, OTL, OAB and workforce development modules as per the client requirements.
• Prepared and Worked on Functional and Technical documentations, Business/Mapping rules documentations, SOW, BP 80, 60, 100, BR 100, MD 50, 70, TE 20, 30. RD 11, RD 30, DS 30, MC 030 Configuration Workbooks, Action Item log trackers and all other PPT’s/Templates as per Oracle best approaches from inception to production.
• Strong understanding and expertise Oracle Applications Framework(OAF), Applications Development Framework (ADF), Application program interface (API) (Inbound and outbound using API'S and open interfaces for integrating other applications with Oracle Applications), Spreadsheet Data Loader(SDL), Service Oriented Architecture (SOA) and ETL/ELT.
• Involved in production configuration, data migration, periodical patch releases, migrations, updates, Go-Live support, coordinating with DBA’s infusion apps installation and assisted in applying patches through BSU in Weblogic and OPATCH in fusion middleware like SOA, OIM and OAM to resolve various bugs. SR to oracle and its business partners to solve the issues and migrating components from one pod to other (T to P or P to T refresh and migrations).

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, UNIX, Mac and Linux.

Databases: Oracle, DB2 and MS SQL Server.

Methodologies: Agile/Scrum, AIM and OUM.

Languages: SQL, PL/SQL and UNIX Shell script.

Application Tools: Peoplesoft, EBS, Cloud Fusion, Oracle Business Accelerator, Toad, SQL dev, Office Suite (Excel, Word, Project, PowerPoint, FrontPage), OIM, OAM, Security Console, FBL, SSL, HCM, PBL, HCM Extracts, BPM, OBIEE, RPD Data Modeling and knowledge in ETL tools like Informatica with Dac and ODI.

ERP: Oracle HCM Cloud Solution (R 9, 10, 11)Oracle Applications 11i./12x (Core/Global HR, SSHR, OLM, Payroll, OAB) up to EBS R12.2.4, PeopleSoft HCM 9.1.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Oracle Cloud HCM Lead Consultant

Responsibilities:

• Involved in estimating the SOW for Oracle implementations in pulling the history records as per the cut off dates from the legacy.
• Prepared and leaded familiarisation sessions for HR and Comp for the large and diversified business users.
• Opportunity to design Security tasks in the Release 12 and secured signoffs for custom roles and setups designs in the security console without APM and OIM interfaces.
• Involved in requirements gathering sessions, design review sessions and initial cycle validation sessions.
• Worked on Enterprise level designs and configurations. Mapped and solved the conversion issues related to the business units, salary basis and workforce structures.
• Implemented department and position structures and positons to GL cost allocation integrations and worked with Payroll leads in KFF’s, Enterprise Setups and Positions Synchronisations.
• Involved in design sessions with Auditors, Hyperion budget distribution departments and Compensation Managers to provide alternative solutions to fill the gaps on product limitations.
• Worked on unique individual (Sign on bonus, bonus, shift, overtime off cycle promotions, charity contributions, performance appraisals and individual’s ESOPs etc.).
• Implemented best Workforce Compensation foundation, Budgets, Worksheets designs, Model and Reports, Alerts setups. Validation, processing’s and distinguish approval scenarios.
• Designed fast formulas to pull the flexfield information to the workforce compensation statements and worked on expression builder setups and dynamic populations and element mapping setups accordable with the requirements.
• Implemented meaningful total compensations statement, Budget - pools, approvals, distributions, publishing’s and history tracking’s.
• Designed solutions for additional felxfields which requires complex approval flows, security and reporting formats.
• Worked on Departments and Positions and Position Tree structures and implementations.
• Worked with Oracle customer satisfaction managers, implementation specialists and Oracle internal teams for complex design solutions.
• Optimised utilisation of Oracle support, Enhancement and service request resolutions.
• Resolved convoluted tasks by providing less maintained setups in designing the custom reports by the data based on the EIT’s, Profile card interpretations and provided the best alternatives for the product limitations.
• Worked on department wise custom security roles for Employee and Line Manger privileges.
• Involved and Coordinated in conversion issues with the offshore Oracle GSD technical teams in building complex Fast Formulas and data loading activities with SSI connect tool extractions for one time extractions.
• Worked on Taleo, Kronos, Labour Distribution, Risk Management, ADP and other third party integration and flexfield setups with Fusion HCM.
• Involved in complex integration solutions among Performance, Benefits, Absence, Payroll and HR activities.
• Designed MC 50 for HR, Minutes, Mapping rules, Action Item Trackers, Conversion logs and Comp Configuration workbooks.

Confidential, Long beach, CA

Sr. Oracle HCM Tech/Functional Consultant

Responsibilities:

• Developing project plan in the middle of the cycle and deliver in line with Fusion Implementation road map, methodology and accomplished workbooks sign off on given time frame works.
• Analyse business requirements and developing effective configuration solutions, business consulting support and facilitates in workshops.
• Working as Oracle Fusion subject matter expert providing best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.
• Worked meticulously with technical resources on data integrity, data conversion, and data mapping from JDE and other integrations to Oracle Cloud.
• Gathering the requirements from various parties and working with multiple groups to carry out the development in the production.
• Experience in working Payroll design workshops, configuration workbooks changes and prepared Global payroll use case test scenarios and questionnaire survey's.
• Interpreted various geographies, action reasons, content types, context, flex fields, jobs and department setups.
• Helped technical team in extracting BI reports and data models for the payroll mass updates.
• Coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes.
• Hands on delivery of extensive historical data conversion solution leveraging Oracle File based Loader(FBL), SS Loader and Payroll Batch Loader.
• Experience in working with Oracle internal teams in various OWC’s for complicated issues and assisting the client in resolving them in time sensitive parameters.
• Worked and redesigned solutions relating to the failures in security, approvals and workforce structures.
• Worked on payroll deduction elements, element eligibility, salary basis and retroactive payments, third party payment method integrations, payroll definitions time definitions, run types and element classifications.
• Worked on business requirements setups related to Calculation Cards, Associations, Personal Payment Methods, Organisation Payment Methods and Payroll Relationships.
• Extracted custom reports and made mass updates for more than 40000 employees in FLSA and ACA changes in Prod instance. Made GT’s among multiple legal employers.
• Worked on FBL to HDL conversions and integrations from various third party integrations.
• Worked on modifications to the existing custom objects including custom interfaces viz., OAF, reports and forms.
• Supported in implementation of permanent contingent worker time entries.
• Configured time card, calendar, and web clock displays as well as third party time collection device export data based on client requirements.
• Configure device event mappings; repeating periods; time categories, consumers, and rules also worked on time entry and processing profiles.

Confidential, Chicago, IL

Oracle Fusion HCM Consultant

Responsibilities:

• Driving and documenting business requirements and procedures, obtain sign off to ensure Client alignment of proposed solution.
• Part of business process workshops/CRPs and requirements gathering sessions and support. clients in defining relevant processes. Provided business consulting support and facilitates discovery workshops.
• Coordinate with QA team and ensure the product is bug free and ensure all test cases and scenarios are covered.
• Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies. Set up and Maintained Enterprise structure and Workforce structures.
• Experience in working both tier and three tier employment models with single and multiple assignments.
• Configured tree hierarchies for the reporting and security purpose and custom workflow routing rules for all Manager self-services and Employee Self-services.
• Implemented Fusion shared modules Financials (GL/Primary ledger, AP and AR) for payroll configurations. Gaines added knowledge on Finance sales and order management functionality.
• Expert understanding and configuring legal entities, TRU, PSU, Legal employers LDG, Business unit set assignments, job configurations, employment models and distinguish tree setups.
• Worked on allocated checklists for the onboarding asset management and scheduled worker/managerial tasks. Interpreted areas of responsibility tasks in the Cloud HCM.
• Worked on Absence Integrations with Payroll, OTL and Workforce scheduling.
• Created various accrual and qualification absence plans and absence types where employees are restricted so that they can record absence only of a specific duration.
• Configured medical and personal leave categories and pulled the same to the HR and Payroll reporting purposes.
• Proficient in preparing E-Text template & RTF file formats for Absence, Core-HR & Talent modules.
• Configuring the performance templets and making the changes in to the template in multiple languages.
• Implemented Performance module and integrated annual and quarterly templates for the compensation workbench.
• Worked on profile rating models, review periods, questions and questioner templates also implemented annual performance process flow.
• Got opportunity to work on profile content, Goals, Questionnaire, Overall Summary, Worker and Managerial Final Feedback.
• Implemented end to end performance and goal management and extensively worked on adding and editing the goals, setting the status of goals and deciding the accessibility of goals.
• Worked on Goal Types, review periods, Multiple goal plans and plan sets and accurate target outcomes.
• Configured various levels of employee and manager portraits and dashboards. Specialised BI reports for talent management modules and helped in developing HCM Extracts for Global HR, Absence and Talent modules.
• Designed custom reporting and interfaces to meet client and audit requirements.
• Supported client in Oracle Cloud UI personalization's and customizations for end users and coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Import candidates (ready to hire) from Taleo Recruiting to Fusion HCM using the Import Oracle Taleo Recruiting Cloud Service Data process and Import export schedule process errors resolutions.
• Streamline Recruiting & On boarding processes with Core HR applications.
• Configure Requisition & Candidate files, Requisition approvals, Candidate Selection Workflows (CSW), Candidate Communication Agent (CCA), Configure Source Tracking, Evaluation Management, Recruiting Centre (welcome centre, Theme& Logo, Communications Channel in Taleo Recruiting.
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR and performed initial steps like implementation users, data roles and loading and managing the geographies, audit and scheduling.
• Write Absence Fast formulas, Coordination with Payroll Costing Team and provide all task details for absence element calculation, input values, Taxation, Pay Terms and Conditions, setting up Cost Allocation Key Flex field task to configure the structure for legislative data group.

Confidential, Elkhorn, NE

Oracle Functional HRMS/HCM Consultant

Responsibilities:

• Worked as Oracle functional consultant as part of Oracle HRMS implementation for Oracle Core HR, CWB, Absence, Performance and Succession.
• Enterprise level and lower level people group and cost structure flexfields. Configured EIT’s and DFF’s in most of the HCM pages.
• Experience in interpreting the salary basis by considering Legislative data group, Frequency of quoted base pay salary, Annualization factors, payroll element, input values, and currency conversions.
• Worked on Grades, Grade Rates, Salary Basis and Element classifications, recurring and non-recurring elements and input values for Compensation setups.
• Designed 4 Annual compensation plans and plenty of individual or off cycle compensation plans.
• Worked on complex absence plan types with the incremental loading of accrual plans and custom requirements for action items.
• Worked on Performance Template Sections, Performance Templates, Performance Document
• Experience working in Eligibility Batch Process, Target Rating Distribution and Potential box chart labels.
• Created the annual and quarterly performance templates and integrated same in compensation worksheets for performance related hikes.
• Utilized the entire absence functionality including concurrent entitlement, participation and accrual tabs, UOM's, plan terms, distinguish absence reasons, types, patterns and categories.
• Gather requirements, questionnaire sign off, MD 50 and MD 120 documentation. Involved in setting up key flex field segments (Job, Grade, People Group, Position, Cost Allocation and Competence).
• Propose Data Conversion strategies for inbound and outbound data interfaces. Create Integration documents for HCM Data load exchange strategy. Study the legacy system and built the Inbound Integration strategy.
• Development of HDL inbound Zip file which includes the different Business Objects dat files and Unit test the load data in test instance.
• Create HCM extracts to generate different assignment files for outbound interface to the third-party systems.
• Worked on Functional Setup Manager in Test Sandbox Instance and test the different assigned tasks of Core HR & Payroll.
• Coordination with the Web Services team to create web services to automate the export of data to downstream systems (for both HR and non-HR) and import data to update fields into Cloud HCM and Setting the details of HCM Data Loader Scope parameters.
• Involved in conversion requirements, converting people data, assignment data, salary data, converting history for people, assignment and salary records.
• Involved in conducting CRP1, CRP2, test data preparation and test scenario preparation.
• Gather requirements from the business users document the requirements and initiate the development process after requirement sign-off.
• Advise HRIS about the Oracle best practices, AIM methodology, minimize data redundancy, automate concurrent process and improve existing interfaces with external vendors.
• Verify existing PL/SQL packages and develop new ones as required by the HRIS team.
• Modify existing third party vendor interfaces and develop new vendor interfaces as required.
• Test & document the changes that are being made to Oracle HR system.
• Create WEB ADI integrators to upload and download data to and from Oracle.
• Identify the changes that need to be incorporated in each release and coordinate with change management and release management teams during deployment.

Confidential, Dallas, TX

Oracle HCM Functional Consultant

Responsibilities:

• Implementation and support for Oracle core HRMS and SSHR modules and HR and Comp in Fusion.
• Worked on Enterprise Structure one time setups, Geography setups, Workforce Structures, ESS/MSS, Security and approval tasks.
• Expert in how to use the fields in the Returned Rate Details, Override and Defaulting Rules, and Contributor Rules sections.
• Provided functional support for creating employees, defining salaries, terminate / retire employees, assign grade structure.
• HR related setups in Descriptive Flex Fields, Key Flex Fields, Validation Sets, Lookups and Specific Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility.
• Gather requirements for Oracle Advanced benefits implementation. Meet with users to gather requirements regarding various benefit plans including medical, dental, HAS and CORBA plans.
• Setup programs, plan types, plans for medical, supplemental and COBRA benefits.
• Setup eligibility profiles, enrolment requirements, life events, benefit groups at program, plan and option levels as required.
• Identify the data inconsistencies in Oracle HR including Date Tracking Issues, Payroll data issues, Benefit Life Event Issues and Conversion Issues.
• Involved in team discussion with customer and other functional and technical team members for analysing the impact on the inter module relationship.
• Worked on Eligibility Profiles, Eligibility Criteria, Utilised all six types of Derived Factors for HR, Absence, OAB and workforce development modules as per the client requirements.
• Support and maintain Human Resource Information Systems (HRIS) testing while maximizing the effectiveness of HR business operations. Identify and document test scenarios and build test cases.
• Setup self-service global contractor placement functionality with AME Approval Workflow customization for absence management and iRecruitment functions.
• Setup plan changes as ending the existing no offered plan and migrating the enrolled employees with dependents to newly offered plan and Set-up employee self-service to for updating employee personal data on-line.
• Worked on setting up of Work Structures - Location, Organization, Job, Grade in HR and discoverer reports for Comp and OAB.
• Setup all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centres, worker's compensation codes/rates, Global Values, Application Utility Lookups, Security Profiles and reports within the Oracle HRMS module for all applicable localizations.
• Provided a solution to allow users to enter cost allocation key flex fields thru self-service to synchronize with finance modules for general ledger.
• Configure profile Options, Goal Management Lookups, e-mail notifications and personnel goal plans settings in Oracle Fusion Goal Management.
• Manage entire ERP testing life cycle including requirement review (MD 50), technical design review (MD 70), Build test plans, test cases and test scenarios (TE 10, TE 20 and TE 40), review implementation documents (MD 120), change management review, log defects, perform component testing, modular testing, integration testing and regression testing. Assist end users in UAT, identify test data and perform UAT.
• Manage and successfully implement total software testing life cycle associated with new functionality and/or enhancements to existing functionality, including requirements analysis and test documentation, design/build test plans, testing and deployment and post implementation support and transition to ongoing operations.
• Analyse vendor interfaces requirements for testability and confer with outsourced vendors to ensure necessary test system support.
• Prepare test data for functional testing, interface testing and record defects using test director.
• Supported Fusion team in HCM Extracts for Benefits and Comp modules.

Confidential

HCM Tech/ Functional Consultant & Associate BA

Responsibilities:

• Worked on employee information and various needs of Reporting. This Project was focused extensively on the customization of HRMS using People Tools and the Reporting Tools.
• Involved in Retrofitting, Modification and Unit Testing of PeopleSoft FSCM and modification and Retrofitting of SQR, Application engine programs.
• Develop and design the PeopleSoft Ver 8.12 Upgrade project map definition and creation and modification of objects according business rules.
• Design and develop the Upgrade templates for PeopleSoft HRMS, for use with the Upgrade Assistant for Johnson & Johnson Control project.
• Review manuals and proof read the material before signing off the material.
• Work with change management team and coordinate migration of changes from Development, test and prod environments.
• Involve in functional testing, prepare test scenarios, test cases and test data for regression and functional test cycles.
• Pair-program with developers to enhance current PL/SQL packages to fix production issues, build new functionality and improve processing time through code optimization.
• Used Mercury Quality Centre bug tracking tool as the test repository for executing the test cases and scripts and logging and generating various reports and graphs for further analysis and to follow up the development team to verify bug fixes and update bug status.
• Customization and implementation of PeopleSoft applications and providing technical guidance to the team.
• Performing Internal Reviews to ensure quality.
• Communicate with clients about the post production support and issues.