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, Benefits, Absence management and Oracle EBS HRMS suite and HR to HR coexistence with EBS and Fusion Cloud HCM
• Extensive experience in Oracle HCM reporting including OTBI, BIP and Oracle fusion HCM Analytics, BICC and Oracle Analytics Cloud (OAC)
• Worked with Oracle support to setting up Oracle Fusion HCM Analytics and worked on budding data visualizations KPI using Oracle Fusion HCM Analytics
• Worked on BICC to extract data to load EDW and build custom BICC/HCM extracts as per the requirement
• Developed major integrations between Kronos WFC/WFD and Oracle Cloud HCM integrations using HDL and web services using OIC and loaded time card data to Oracle Payroll element entry values
• Part of implementation of open enrollments of benefits and provided technical solutions including reports, integrations and security
• Experience in building new reports and troubleshooting the existing reports using Fusion reposting tool OTBI (Oracle Transactional Business Intelligence), BIP (custom RTF, e - text, XML templates) and HCM/Payroll/Benefits 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 the 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 certifications and development of fast formulas as needed across OTL and Absence management including fast formulas for Absence types and Accrual Plan Rules (Global Absence Type Duration, Global Absence Entry Validation, Global Absence Plan Enrollment Start, Global Absence Ceiling and Global Absence Accrual)
• Extensively used OIC as part of file-based integrations and web services across Benefits, core HR and Payroll
• Worked as an 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 the 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 the 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 the client and experience in design using MD70 documents.
• Excel at translating business needs into application requirements.
• Assisting clients in the selection, implementation planning, fit/gap analysis, conference room pilots, configuration, testing, training, 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:

• Part of production support of Oracle HCM (Payroll, Core HR and Benefits), Kronos and designed and developed reports and integrations
• Developed major HCM integrations including Krono’s to Payroll integration to load time card data to Payroll element entry’s, Core HR integration with OKTA and third party ATS integration with Oracle Core HR using HDL, HCM API’s and OIC
• Part of open enrolment of Oracle cloud Benefits and developed reports to help users on open enrollment activity and enrolment activity
• Part of post-production support of Oracle HCM core HR, Payroll and Benefits and Kronos integrations and responsible for troubleshooting and fixing day to day production tickets including security, reports, integrations and custom UI changes
• Part of implementation of Oracle Fusion HCM Analytics and worked on building data extracts from HCM and BI data visualization dash boards
• 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 an 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

Oracle Cloud HCM Techno Functional Engineer

Responsibilities:

• Part of open enrolment of Oracle cloud Benefits and developed reports to help users on open enrollment activity and enrolment activity
• Part of post-production support of Oracle HCM core HR, Payroll and Benefits and Kronos integrations and responsible for troubleshooting and fixing day to day production tickets including security, reports, integrations and custom UI changes
• 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
• Worked on BICC extracts and created a data pipeline to EDW data base across Oracle Cloud ERP and HCM
• 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 an 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

Confidential, Kansas City, MO

Oracle Fusion HCM 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
• Developed inbound and outbound integrations using HDL and REST api’s and OIC and HCM Extracts, Payroll Extracts and OIC for outbound interfaces
• 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 Confidential &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, Dallas, TX

Oracle HCM 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 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 helped users to understand OTBI and trained users to develop OTBI reports
• Extensively used OIC as part of Oracle HCM integrations (inbound and outbound interfaces)
• 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 HCM Technical Developer

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 the 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 the 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 HCM Technical 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 the 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, 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 the 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

Oracle HRMS Developer

Responsibilities:

• Coordination with onsite consultant and gathering detailed technical requirements about the development objects includes forms, reports, workflows, Alerts and interfaces
• Part of open enrollment of Oracle OAB and developed custom oaf pages for SSHR and reports using Oracle XML/BI publisher reports
• 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 the time cards using apis hxc timestore deposit.create time entry