SUMMARY:

• Highly motivated, dynamic professional having around 8+ years of experience in requirements gathering, design, analysis, configuration, development, testing, implementation, customization, maintenance and support of Oracle cloud HCM (Core HR, Payroll, OTL, Absence management and Oracle EBS HRMS suite and HR to HR coexistence with PeopleSoft, EBS and Fusion Cloud HCM
• Experience in building new reports and troubleshooting teh existing reports using Fusion reposting tool OTBI (Oracle Transactional Business Intelligence), BIP (custom RTF, e - text, XML templates) and HCM Extracts
• Well versed with Fast formulas, value sets and used HCM Extracts and BIP Extracts across core HR, Payroll and OAB
• Well familiar with fusion payroll reporting subject areas, job roles, customizing security by creating custom job roles and BIP secured list view
• Expertise in designing compensation plans, eligibility profiles and Compensation Worksheet configuration as per teh client requirement.
• Worked with payroll and core HR users and customize security by creating custom roles for BIP extracts
• Extensively worked on HCM integrations, which includes research, design and develop HCM integrations including HDL, HCM Extracts, Web services using OIC
• Extensively worked on OTL/Absence management implementation, which includes understanding of OTL and Absence management implementation requirements and configuration of Absence types, categories, patterns, plans, reasons, and s and development of fast formulas as needed across OTL and Absence management including fast formulas for Absence types and Accrual Plan Rules
• Worked as a HCM functional data integration expert and worked on designing and configuration of inbound and outbound interfaces with Oracle Taleo, ADP, Health care Providers and 401 financial institutions
• Worked on building outbound interfaces using HCM extracts/ BIP extracts across Payroll and Talent management
• Create custom data base items using balance dimensions for time/PTO balances and used them in teh OTL/Absence fast formulas
• Recent hands-on experience in PeopleSoft to Oracle Fusion Payroll conversions and involved in end to end implementation of Oracle Fusion Payroll including data extraction strategies from PeopleSoft to Fusion Payroll, configuration of Oracle Fusion payroll setups including Legislative Data Groups, Statutory Units, Legal Employers, and Tax Reporting Units, configuration of Payroll Fast Formulas, using data loaders like FBL, HDL, PBL and SSL and security profiles
• Worked on troubleshooting and fixing Fast formula performance issues including replacing or removing database items in teh formulas, which causing performance issues
• Proven hands on experience in designing of Fusion HCM test plan, test case creation, running UAT/SIT, production cut over planning and defect management
• Extensively worked Fusion HCM security modules and created various custom roles (data roles, functional roles, abstract roles) based on two-tier/ Three-tire employment model and based on customer HRMS security requirements
• Involved in end to end testing of Fusion HCM including monthly payroll patch testing and new version upgrade testing
• Designed and developed Fusion payroll outbound interface process using fusion global payroll interface and ADP PayForce period extract
• Participated in various open enrollment implementations and designed and developed various benefits interfaces, fast formulas, XML reports, OAF extensions, SSHR extensions, notification alerts using Oracle Alerts and AME configurations
• Rock solid experience in design and development of HRMS data conversions including both inbound and outbound interfaces and well versed with APIS’ and underlying base tables
• Good Expertise and implementation experience in Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and Security.
• Proven hands-on experience in using various fusion data loader tools including FBL, HDL, PBL and SSL
• Experience includes full lifecycle implementations of Oracle Applications release 12 covering HRMS modules: Core HRMS, Absence Management & Self Service and HCM Fusion Implementation for Compensation Management, Workforce Deployment, Workforce Development, and Talent Management.
• Strong Knowledge on Fusion Functional Setup Manager.
• Excellent analytical skills in Analysis and business requirements gathering from end users to teh client and experience in design using MD70 documents.
• Excel at translating business needs into application requirements.
• Assisting clients in teh selection, implementation planning, fit/gap analysis, conference room pilots, configuration, testing,, rollout and post-implementation support of Oracle Fusion HCM cloud/SaaS solutions at various customer sites

TECHNICAL SKILLS:

Operating systems: Windows, NT/ XP, Linux, UNIX

Fusion HCM Cloud: Oracle HCM Payroll, Workforce Deployment, Cloud Payroll Talent Management and Compensation Management and Security

ERPs: Oracle Applications R-12, (HRMS, HR, OAB, Payroll, CWB, Absence Management iRecruitment and AME)

Lang/ Tech: SQL, PL/SQL, Alerts, Java, Web Services, HTML and SML

Tools: TOAD, Eclipse, SQL Developer, and jDeveloper, HP ALM and Jira

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Oracle Cloud HCM Techno Functional Consultant

Responsibilities:

• Gathered reporting requirements and explored different options of development of reports across OTBI, BIP Extracts and HCM Extracts
• Troubleshoot and provide fixes across BIP/OTBI reports including report security, data model and performance issues
• Crated various BIP report output formats including RTF, eText, XML, PDF and other required formats
• Fixed and provided BIP report security as per multi org and multi-currency and org context report outputs
• Worked with Oracle support to resolve BIP/OTBI reports performance challenges across Core HR, Payroll and OAB
• Worked as a HCM data integration expert and worked on designing and configuration of inbound and outbound interfaces with Oracle Taleo, ADP, Health care Providers and 401 financial institutions
• Extensively worked on HCM security including customizing jobs and security profiles
• Worked on building outbound interfaces using HCM extracts/ BIP extracts across Payroll and Talent management
• Extensively worked on development of fast formulas across OTL/Absence management for developed formulas for Formulas for Accrual Plan Rules including Absence Vesting, Absence Proration, Absence Ceiling, Absence Carryover,Absence Accrual and OTL time validation rules
• Worked on development of OTIB/BIP repots and dash boards as needed across OTL/Absence management and Payroll

Confidential, Kansas City, MO

Oracle Fusion HCM Reports Developer

Responsibilities:

• Responsible for implementation of OTL/Absence management, coordination with users and other OTL functional consultants, prepare gap/fit reports, convert them into technical design, develop custom objects including fast formulas, data base items, inbound and outbound integrations using OTBI/BIP and HCM extracts and build OTL time cart layouts and approval process
• Build ICS/OIC integrations with internal apps and third-party vendors across HCM
• Gathered Fusion HCM R12 implementation requirements, coordination Oracle SR, reviewed security setups and recreated roles as part of user security setups, created a test plan, trained users as part of UAT and SIT
• Reviewed Oracle Fusion HCM standard reports that H&R Block using and build new OTBI/BIP reports as per user requirements
• Worked Fusion HCM UI changes, sandbox customizations, coordination with users on day to day operational issues including data loading using HDL, fast formulas and reporting
• Working with Payroll Administrators, stakeholder and gather requirements for country specific statuary reporting requirements, coordinating with Oracle SR on day-to-day implementation issues, conducting CRP, UAT and SIT and coordinating with internal QA team
• Created UAT test cases for fusion Payroll end to end testing including HCM extracts, integration with ADP and other Payroll partners

Confidential, Denver, CO

Oracle Fusion HCM reports developer

Responsibilities:

• Developed payroll BIP costing reports for project, which includes customizing security to restrict report access by project organizations
• Designed and developed BIP extracts for Payroll deductions to 401k financials and medical company’s, which incudes extracts values from payroll element values and generate data in different formats
• Involved in requirement gathering for data conversions, data mapping and development data conversion as part of Oracle Fusion implementation and data conversion from PeopleSoft Ch2m non-US entities
• Working with Payroll Administrators, stakeholder and gather requirements for country specific statuary reporting requirements, coordinating with Oracle SR on day to day implementation issues, conducting CRP, UAT and SIT and coordinating with internal QA team
• Created UAT test cases for fusion Payroll end to end testing including HCM extracts, integration with ADP and other Payroll partners
• Build BIP/OTBI payroll, Benefits reports using OTBI subject areas and BIP custom reports and halped users to understand OTBI and trained users to develop OTBI reports
• Extensively worked on payroll setups including deduction card, calculation card including various types of Unions and related prevailing wage determination, Union rates, Union eligibility rules, rates and related fast formulas
• Customized OAF SSHR pages part of custom payroll Pay Slip printing and benefits enrollment process
• Developed various custom xml reports, fast formulas, inbound and outbound interfaces as part of payroll and OAB and as part of 2017 open enrollment implementation
• Worked on AMX configuration for 2017 Benefits implementation and SSHR approval workflow for benefits processing
• Extensively involved in development of data conversions including work structures, locations, jobs, people and assignment information and ongoing build for Oracle Cloud HCM Fusion with EBS HRMS
• Setting up country specific fusion payroll extensions and balance definitions

Confidential, Boston, MA

Oracle PeopleSoft HCM/ Oracle Fusion Payroll Techno Functional Consultant

Responsibilities:

• Primary point of contact for OTL/Absence management implementation and responsible design, configure and development of HCM objects including Fast Formulas, DFF’, HCM Extracts, OTBI/BIP reports and publishing.
• Worked with global payroll users and documented payroll elements required for payroll processing of OTL time data transferred to teh Global Payroll time consumer, development of fast formulas for time card rules and formulas including formulas, rule templates, rules, and rule sets and build fast formulas for OTL time rounding and threshold and assign to OTL rule templates
• Understanding existing PeopleSoft HCM environment, documentation of migration plan, coordinating with Oracle Fusion support team, leading data extractions process and loading to Oracle fusion HCM modules using Fusion loaders, root cause analysis, data reconciliation, configuration fusion payroll setups and leading Fusion payroll testing process
• Designed and developed Fusion payroll outbound interface process using fusion global payroll interface
• Understanding Putnam Open enrollment requirements, coordinating with users to gather reporting requirements, design and develop reports as needed using XM/BI publisher
• Understanding fusion data conversion requirements, analyzing and setting up environment for data loading using FBL /HDL
• Customizing OTBI reports security by assigning different OTBI duty roles to a job
• Customized various payroll reports for line managers, payroll users by editing layout, data model and creating new reports by new data model
• Created brand new real-time reports using OTBI for payroll time card analysis and reconciliation
• Extensively worked on both onetime data conversions and ongoing integration between Oracle Peopelsoft and Fusion tenement management to load various attributes including people, assignment, salary, locations, and DFF
• Development of various OTBI Reports as per teh user requirements
• Creating Workforce Profiles, Job Profiles, Organization hierarchies, defining Positons, Jobs setting up HCM Key Flex fields as part of ongoing production support.
• Creating fusion security profiles and creating custom job roles based out of seeded job roles for Employee Self Service (ESS) and Manager Self Service (MSS).
• Designing workflow/Approval flow for HR transactions examples include Promotion, Transfer, Salary Change, New Hire etc.,

Confidential, Omaha NE

Oracle Fusion HCM Consultant

Responsibilities:

• Part of 2016 Open enrollment and developed various fast formulas, interfaces, OAF customizations, AME configurations for SSHR workflows, benefits report and alerts for benefit admins on benefit activity notification during enrollment period
• Part of year end support and worked on troubleshooting and fixing KBace APIS’, year end balances, reports and W2 issues
• Understanding fusion data conversion requirements, analyzing and setting up environment for data loading using FBL /HDL
• Extensively worked on both onetime data conversions and ongoing integration between Oracle PeopleSoft and Fusion tenement management to load various attributes including people, assignment, salary, locations, and DFF
• Development of various OTBI Reports as per teh user requirements
• Creating Workforce Profiles, Job Profiles, Organization hierarchies, defining Positons, Jobs setting up HCM Key Flex fields as part of ongoing production support.
• Created brand-new real-time reports using BIP for payroll time card analysis and reconciliation
• Creating fusion security profiles and creating custom job roles based out of seeded job roles for Employee Self Service (ESS) and Manager Self Service (MSS).
• Designing workflow/Approval flow for HR transactions examples include Promotion, Transfer, Salary Change, New Hire etc.,
• Creating Compensation Plans and configuring Compensation Worksheet design.
• Creating Compensation Worksheet Alerts.

Confidential, Columbus IN

Oracle EBS Fusion Techno Functional Consultant

Responsibilities:

• Implementing Workforce Deployment, Talent Management (Goal management, Performance management, Talent Review and Succession), and Security.
• Analyze business requirements perform Fit- Gap analysis and developing TEMPeffective configuration solutions.
• Configurations related to Fusion Core HR and Talent Management.
• Creating Workforce Profiles, Job Profiles, Organization hierarchies, defining Positons, Jobs setting up HCM Key Flex fields as part of ongoing production support.
• Part of 2016 Open enrollment and developed various fast formulas, interfaces, OAF customizations, AME configurations for SSHR workflows, benefits report and alerts for benefit admins on benefit activity notification during enrollment period
• Part of year end support and worked on troubleshooting and fixing KBace APIS’, year end balances, reports and W2 issues
• Configured Payroll definition, Payroll elements, element entries, fast formulas, and Payment Methods for different employee groups (represented, exempt, non-exempt) using File based loader and Payroll Batch Loader (PBL/FBL)
• Creating fusion security proles and creating custom job roles based out of seeded job roles for Employee Self Service (ESS) and Manager Self Service (MSS).
• Configuring Performance Management set ups like Performance process Flows, Talent Eligibility Profiles, and Performance Document.
• Setting up Talent profiles, al Establishments, Goal Plans, Talent Review Templates, and Succession Plans as per teh client requirement.
• Part of business process workshops, CRPs, requirements gathering sessions and support clients in defining relevant processes.

Confidential, Peoria, IL

Oracle EBS HRMS and Oracle Fusion HCM Consultant

Responsibilities:

• Along with production support of EBS HRMS, extensively involved in implementation of fusion HCM talent management and lessons learned as part of first fusion implementation, new terminology, new data loaders replacement of traditional interfaces, first time challenges, working with Oracle part resolving some critical issues, using FBL loader to load data to clod from various sources including EBS
• Techno - functional consultant supporting Oracle EBS R12 Oracle HR, SSHR, Payroll, Oracle Advanced Benefits, and implementation Fusion HCM Talent Management (HR to HR Coexistence)
• Writing PL/SQL stored procedures to handle business logic related to DB which includes Conversions, Custom Components, and Interfaces.
• Developing and Customizing OAF pages in iRecruitment as per teh client requirement.
• Good understanding of Benefits integrations with FSA and HSA vendors Conexis and Mellon respectively
• Experience in HRMS integration with third party payroll system like ADP.
• Configuring Workflow, AME Approvals in iRecruitment and Self-service Modules.
• Experience in integration with SABA Learning Management System.
• Creating UNIX scripting for SFTP and FTP for integrations with externals systems.

Confidential, Denver, CO

Oracle EBS HRMS Developer

Responsibilities:

• Coordinated in teh process of enhancement of Payroll, OTL and CoreHR.
• Developed various custom BI Publisher reports for HR/Payroll modules.
• Involved in Year End processes of Payroll.
• Implemented Vertex Returns for teh client.
• Assisted in implementation of EBTax including VAT, HST, GST and CST and integrated withVertexfor US Operations.
• Customized Fast Formulas for various elements in OTL.
• As a team member in OTL enhancement, was responsible for reengineering existing OTL setups and configuring teh system with new setups. Responsible for writing teh functional specification documents for teh setup changes required for OTL.
• Part of 2016 Open enrollment and developed various fast formulas, interfaces, OAF customizations, AME configurations for SSHR workflows, benefits report and alerts for benefit admins on benefit activity notification during enrollment period
• Part of year end support and worked on troubleshooting and fixing KBace APIS’, year end balances, reports and W2 issues
• Designed and configured new time entry rules to improve teh turnaround time to reject time entries. As a result of teh new time entry rules, teh timecards went to error status and were fixed before teh end of pay period hence improving teh turnaround time Involved in reengineering teh interface between teh time clocks system (Point of Sale) and OTL.
• Redesigned teh validations, rules and timecard statuses from a process perspective.
• Performed High Level analysis of People, Process, and Technology.
• Based on analysis performed an impact analysis of all proposed enhancements.
• Prepared Map/Gap for proposed enhancements.
• Conducted requirement gathering, MAP/GAP analysis, detail design, and build of all proposed enhancements.
• Customized SSHR workflow according to client specifications.
• Defined AME rules for HR functions.
• Developed SOE and SOW based on AIM methodology.
• Prepared MD50/MD70 for all suggested enhancements.

Confidential, Greenville, NC

Oracle HRMS Technical Consultant

Responsibilities:

• Gathered requirements, designed specifications and coded TOL time entry rules.
• Lead functional consultant for human resources end to end implementation and post production support.
• Documented business requirements and conducted teh MAP/GAP analysis.
• Configured benefits setup, configured benefits eligibility, self-service enrollment, self-service registration, plan copy and plan design wizard.
• Designed and constructed OAB for various unions.
• Part of 2016 Open enrollment and developed various fast formulas, interfaces, OAF customizations, AME configurations for SSHR workflows, benefits report and alerts for benefit admins on benefit activity notification during enrollment period
• Part of year end support and worked on troubleshooting and fixing KBace APIS’, year end balances, reports and W2 issues
• Configured active and COBRA programs for OAB. Developed interfaces for medical, dental and vision.
• Constructed and tested payroll for OTL elements.
• Directed communication and interaction between technical and functional team, management, HR, IT, and system administration.
• Re-engineered Performance Management processes for teh business.
• Conducted requirements gathering sessions with teh module managers.
• Created Map/Gap assessments on teh issues and pain points effecting teh business in carrying out Performance Management tasks.
• Developed a strategy to mitigate risks and designed cost-efficient plan to conduct teh performance review process TEMPeffectively throughout teh organization.
• Redesigned appraisal templates and created notification alerts.
• Re-configured AME workflow by streamlining complex approvals process to suit business requirements.
• Involved in Unit, System Integration testing of Interfaces.
• Involved in requirement gathering of Interfaces.

Confidential

Associate Oracle Apps Analyst

Responsibilities:

• Coordination with onsite consultant and gathering detailed technical requirements about teh development objects includes forms, reports, workflows, Alerts and interfaces
• Following up on production tickets and performed root cause analysis, documentation, user testing, approvals and migration to production
• Coordination with onsite DBA’s as part of development and production support projects
• Worked on development of OTL custom time entry templates and building blocks of teh time cards using apis hxc timestore deposit.create time entry