SUMMARY:

• Having 7+ years of IT experience in Requirement gathering & analysis, designing, Development and implementing technology solutions.
• Oracle HCM Cloud Techno Consultant with experience in designing enterprise applications, implementing and enhancing Oracle HCM Cloud applications and with extensive skill set in Human Resources (HR), Payroll, Advanced Benefits, Compensation, Employee Self Service and Performance management.
• Oracle Certified HCM Cloud Technical Consultant.
• Having good experience on data loading and data conversion using HCM DL (HDL & SHDL), FBL and Spread Sheet Data loaders (ADF DL/SDL).
• Have good experience in Oracle HCM cloud role security and data security and configured several roles.
• Have very good experience in writing fast formulas in absence management, payroll and benefits modules.
• Have very good experience in writing HCM extracts for outbound interfaces and payroll extracts.
• Have very good experience on developing outbound interfaces using HCM Extracts and BI publisher reports.
• Experienced in cloud technology and on premise infrastructure integration for Oracle HCM Cloud.
• Experience with Web Services API Implemented SOAP and REST based Web Services and integrated the services with Oracle HCM cloud.
• Have very good experience in payroll flows and payroll batch loaders (PBL).
• Very strong experience in designing and developing OTBI Dashboards and analysis.
• Very strong knowledge on Fusion data model and OTBI subject areas.and DBI items for several modules such as Global HR, performance management, Absence management and Payroll.
• Good experience designing and developing the BI publisher reports using complex SQLs.
• Very strong experience Oracle SQL and building e - text templates and RTF templates.
• Very good knowledge on HCM cloud SOAP, REST API Catalog and Queues.
• Good experience in Oracle BI Cloud Connector (BICC) to synchronize the data between HCM Cloud and Enterprise Data ware housing.
• Having experience in integrating and automating HCM cloud integrations using middleware platforms like SOACS, ICS (OIC) and Mule soft and JAVA
• Have experience in automating the Fusion interfaces/integration using ADF Services (REST and SOAP).
• In that around 2 year of work experience in OA Framework projects, w.r.t development, extensions, and personalization.
• Having technical experience in Design, Customization and Testing of Oracle Application modules, which include HRMS, OTL, and Oracle Projects and finance modules.
• Good programming knowledge in PL/SQL, SQL, and Core Java.
• Written Interface, Migration and conversion programs for importing data from feeder systems to Oracle using SQL*Loader, PL/SQL.

TECHNICAL SKILLS:

Applications: Oracle Fusion HCM Cloud Global HR, Payroll, Benefits, Absence management and Performance management

Cloud Tools: HDL(HCM data Loader), Payroll batch loader(PBL), ADF DI, OTBI, BI Publisher, BPM workflow configuration, HCM extracts

Languages: PL/SQL, SQL, HTML, XML, .Net, JSP

Tools: SQL*Plus, SQL*Loader, TOAD, Oracle Discoverer, Data loader, Data Pump, Oracle Forms, Oracle Reports, XML Publisher, Putty, WinSCP, Visio, PVCS and Workflow Builder

PROFESSIONAL EXPERIENCE:

Confidential - Dayton OH

Oracle HCM Lead Technical Developer

• Designed and developed several outbound integrations/interfaces using HCM extracts and BI publisher templets.
• Worked with Security team, configured SAML SSO configuration, and developed the integration for user and role creation.
• Assisted the business for quarterly 18C upgrade and resolve the post upgrade issues.
• Leveraged HCM cloud PGP encryption to meet the client data security requirements.
• Worked on HCM Data Loader (HDL) for loading Worked, and Salary assignment in to Cloud from Oracle EBS.
• Worked on spread sheet loader to upload config data like Jobs and locations
• Designed and Developed benefit, payroll and HR technical design documents.
• Worked with business and HRIS teams to understand the requirements.
• Worked with PeopleSoft (Legacy) application team to understand the current technical components and come up with technical solutions in cloud.
• Extensively worked on Absence, Benefits, Payroll and HR Modules technical requirements.
• Worked with benefits administrator and written several fast formulas for Benefits eligibility profile.
• Worked with HRIS and written several fast formulas for absences accrual calculation and worked hours calculation.
• Worked with payroll team and created BI Reports for union deductions report.
• Written several fast formulas for retirement (401K) elements entry value calculation.
• Worked with HRIS team and security team to create several job, duty and data roles and HCM security profiles
• Worked with Legacy PeopleSoft team to extract the data in HDL.
• Worked on several Payroll Batch Loaders (PBL) for loading various payroll data.
• Responsible for writing new fast formula for new salary, bonus and loan elements.
• Responsible for creating Implementation Users, Data Role for Implementation Users, Manage Legal Entity, Manage Work Structures, Manage Salary basis, Manage Workflow approval.
• Design and developed various HCM Extracts for ADP Payroll Interfaces.
• Designed and documented various Fast formulas in Absence and payroll.
• Worked on BI publisher for reporting needs as per client requirements, like Action item report, absence reports, and HR, payroll and enrollment reports.
• Built Various OTBI Head Count and attrition Reports by Department, Location, Business Unit.
• Designed Various BI reports for HR Letters, Monthly wise absence reports.
• Integrated the other application with ADF Data services (web service) for HR information.
• Integrated the other application with cloud using JAVA services and ADF Data services.
• Integrated user creation service with LDAP through Mule soft.

Confidential - NYC

Oracle HCM Lead Technical Developer

• Developed several compensation dashboard like Op Comm report for assist the compensation planning and budgeting.
• Developed several reports like new hire and termination reports for HR operations.
• Developed global reports like HC by name Asia, Demographic report, Contractor Asia report to support global HR operations.
• Worked on HCM Data Loader (HDL) for loading Person, Assignment, and Salary data in to Cloud from Oracle EBS and Payroll Batch Loader (PBL) to process the payroll data.
• Designed and developed several OTBI dashboards for managers, HR performance management team and benefits administrators.
• Writing new fast formula for new salary, bonus and loan elements.
• Developed several HCM extracts and BI publisher e-text templates for outbound interfaces.
• Worked with legacy team to extract the data in HDL templates.
• Designed and developed integrations using HCM SOAP and REST services.
• Responsible for creating Implementation Users, Data Role for Implementation Users, Manage Legal Entity, Manage Work Structures, Manage Salary basis, Manage Workflow approval.
• Integrated the kronos time entry system with Oracle Absence management using SOA suite.
• Developed several outbound data extracts to integrate the data with downstream systems.
• Developed the benefits extract for several benefits vendors.

Confidential - Atlanta GA

Oracle HCM Technical Developer

• Worked with HRIS team to understand the business requirements.
• Prepared the technical design using AIM methodology
• Converted the several data elements using HDL data templates.
• Designed and developed Agnostic services to publish the employee and department information to multiple systems.
• Designed and developed several integrations using Fusion ADF REST and SOAP service.
• Designed and implemented the benefits integrations and HCM extracts for several benefits vendors.
• Designed and implemented the several legacy system integrations with Fusion HCM data.
• Designed and developed ESB service to distribute the employee data with multiple systems.
• Designed and implemented the integration between HCM with Coupa cloud application and other homegrown application.
• Developed several OTBI dashboards and BI publisher reports.
• Designed and developed several FAST formulas.

Confidential - NYC

Oracle HCM Technical Developer

• Lead the conversion team of three people and converted the large datasets using HCM Data Loader (HDL).
• Worked with functional team and legacy application team created data conversion mapping sheets.
• Functional and technical specification documents and conversion documents CV40 for conversion and interfaces.
• Involved in Design, Development and Testing of Conversions, Interfaces, Reports and Production Support.
• Created several HCM extracts for client reports and outbound interfaces
• Developed and designed several OTBI dashboards and BI Publisher reports for operational reporting requirements.
• Configured several HCM security profiles and data roles as part of access management.
• Configured the HCM approvals for serval HCM transactions such as life event, personal details update and address update
• Developed various Fast formulas in Absence and payroll.
• Developed Benefits and absence Fast Formulas.
• Assist in documenting and performing application set ups for test instances.
• Worked on BI publisher for reporting needs as per client requirements, like Action item report, absence reports, and HR, payroll and enrollment reports.
• Worked with Mule soft integration team to design outbound and inbound interfaces.
• Automated the conversion process using HDL and Mule soft ETL tool

Confidential - Houston, TX

Oracle EBS Consultant

• Develop several OAF applications & SOA integration composites and acted as SME for OAF and SOA.
• Designed and developed the several custom modules for International Shipment and Asset Retire functionality modules using OAF.
• Customized the several OAF business components (BC4J) to add custom business validations.
• Developed and customized several oracle workflows, Use Cases, and technical documents to capture functionality and end-to-end business processing.
• Designed and developed Deduction and Earning Interfaces to orchestrate services utilizing Oracle’s Business Process Execution Language and Enterprise Service Bus utilities.
• Developed an ESB service to retrieve a .CSV file and de-batch the file through the BPEL Process that would access a Java Web Service for detailed record validations.
• Collaborated with Government groups in order to develop and implement online payments using Oracle BPEL, Java interfaces, and BI Publisher services for generating various reports
• Developed and implemented an Oracle composite BPEL service that handled email notifications, event monitoring, data manipulation through translations and canonical models, as well as Oracle Database inserts/updates of custom SQL statements through adapters and PL/SQL calls
• Designed and developed the reports, interfaces and conversions.

Confidential

Oracle EBS Consultant

• Requirement gathered from business users understand them and perform the gap analysis.
• Conduct the several customer trainings and demos.
• Designed and developed the custom on boarding module using OAF that enables to perform the on boarding activities in Airtel.
• Customized and implemented the several new/custom business process and validations in iRecruitment, Self-service HR, Performance Management and several other HR modules
• Designed and developed the several RICEW components.
• Developed and implemented Oracle’s BI Publisher and OAF integration (web letters) in order generate pre-formatted reports for a given employees thus eliminating manual intervention.