SUMMARY:

• 6+ Years of progressive IT Experience which includes experience in Implementation, Customization, Upgrade and Maintenance of Oracle HCM Fusion cloud and Oracle HCM Applications.
• Experience with analysis design, development, customizations and implementation of PeopleSoft application.
• Experience in HCM Cloud in engagements involving Core HR and other modules.
• Understanding of technical architecture of Oracle HCM fusion - how to build interfaces, reports, extensions.
• Experience on Oracle Fusion HCM Cloud Implementation and support.
• End to end implementation experience in Global HR, Compensation, Performance Management, Payroll, Talent Management, Profile Management and Absence management modules.
• Expertise in setting up Approvals for Global HR and Compensation
• Expertise in identifying functionality gaps and builds extensions.
• Experience in developing functional and technical design and documentation for Oracle HCM data conversions, interfaces.
• Expertise in implementing Grade Step Progression and Handling issues.
• Expertise in developing integrations between EBS to Fusion and Fusion to EBS.
• Expertise in automation of these processes.
• Developed/Automated EBS to Fusion and third party to Fusion inbound interfaces using custom java packages to invoke and load file to Fusion UCM server.
• Experienced in configuring Workflow routing rules for all Manager Self - services and Employee Self-services.
• Worked on Fast formulas and able to write fast formulas individually.
• Experience in retrieving Data using SQL queries.
• Strong functional documentation skills, created BR110, BR150, MD50, MD70 and TE040 for the implementation of HCM Modules
• Solved the issues for UAT Training as per Priority and updated status Sheet.
• Prepared User training materials (SOP) with screenshots for each module.
• Responsible for interacting with business partners to identify information needs and business requirements for Setups.
• Worked on databases like SQL Server, Oracle.
• HDL Data Migration experience in migrating data pertaining to employee, payroll data using PBL from legacy applications such as PeopleSoft.
• Interacted with clients during the Implementation process, Involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle cloud and Application.
• Expert in identifying business requirements and map them to the Oracle Fusion Cloud functionality.
• Experience in Creating HCM Extracts and Delivery Options for Extracts.
• Experience in Creating Custom reports related to Global HR, Performance Management, Compensation, Payroll modules.
• Experience creating reports using subject areas in Oracle HCM Cloud BI.
• Excellent experience in Data loading into Oracle HCM Cloud using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Contacts data, Work relationships data, Payroll data and Salary info.
• Experience in developing fast formulas, writing Oracle SQL/PLSQL code, BI Publisher, OTBI, XML Publisher, HDL.
• Experience in building custom OBIEE reports for HCM Cloud.
• Expertise in Configurations, Personalization, and fusion role based Security, HCM Data loaders (HDL), Spreadsheet loader, OTBI Reports, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Absence Management and Payroll modules.
• Excellent written and oral communication, leadership, team management, and people skills.

PROFESSIONAL EXPERIENCE

Sr. Oracle HCM Consultant

Confidential, Seattle, WA

Responsibilities:

• Involved in successful implementation of HCM Cloud (Talent Management - Goals, Performance, Profiles, Talent Review & Succession Planning).
• Requirement gathering for the BI and OTBI reports and Documentation.
• Data loading/Conversions using HCM Data Loader (HDL) which includes the Workforce Structure Data, Worker Data, Work Relationship Data, Salary, Jobs and Locations.
• Writing Absence Fast Formulas for Absence Type validations and accruals.
• Conducted requirement gathering sessions for Global HR, Performance, Compensation modules, Sessions for Technical objects like Conversions, Reports, HCM Extracts and Integrations/Interfaces.
• Migrated Worker and payroll data using FBL, HDL and payroll batch loader (PBL).
• Involved in Unit Testing for all upgraded SQR programs and tuned them to resolve performance base issues related to them.
• Modified SQR's to Application Engine programs according to client requirements.
• Worked on incident based on People code, SQR, Application and Integration broker.
• Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.
• Configuration functionality includes user lists, criteria, email template assignment and SQL binding to send the emails.
• Extracted high Volume of HCM data from Oracle Fusion HCM database in CSV format.
• Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports which needs to be delivered to Email (Business Users) and FTP sites.
• Managing Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Verify existing PL/SQL packages and develop new ones as required by the HRIS team.
• Created SQL scripts to automate the manual process.
• Involved in Design, Development, Testing, Customer Support for Oracle E-Business Suite APIs (PL/SQL, SQL, Package Codes), Forms, Reports & Batch Processes.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
• Responsible for implementation of HCM Cloud Time and Labor and Technical lead for Oracle support for Oracle HR, Payroll and OTL Time and labor.
• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Worked on creating BI publisher reports.
• Used Data Managing using tools OTBI Reports, BI Publisher reports, HCM Extracts.
• Created the data model and hcm extract based on the same.
• Created HCM extracts for Fusion to EBS integration for person details, Contacts, Phone numbers.
• Created HCM extracts for Third party system interfaces and updated fields status after extracting data by integration HDL with Extract.
• Developing HCM Extracts/OBI Reports/OTBI Analytics for Global HR, Payroll Interface and Fusion Benefits.
• Created HCM extracts for New Hires and updated the New hire status by integrating HDL with Extract.

Oracle HCM Consultant

Confidential, Houston, TX

Responsibilities:

• Build Custom Security for Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Worked extensively on Application Designer, Application Engine, Peoplecode, Application Package, Integration Broker, Component Interface, PS Query, and XML/BI Publisher.
• Retrofitting objects - Peoplecode, SQL, SQRs, UNIX Scripts and AEs based on the requirement and Build the objects.
• Leading the Oracle HCM Cloud HR & Benefits from SIT through go live.
• Helped and supported new HR end users, to maintain the employee's information effectively in Oracle HCM Cloud application.
• Gather Core HR (Enterprise), Compensation, Absence business requirements (BRD) and map them to Oracle HCM Cloud functionality.
• Involved in the Integration & support to ADP applications used by client (e-TIME and Payforce) with Oracle (11i and R12).
• Extensively worked on SQR and Application Engine retrofits. Created XML/BI Publisher reports,D2k Reports, Discoverer, RDF reports as per the client requirements on AP, AR, OM, GL, PO, INV, Core HR modules.
• Developed Multi Layouts and Multiple layouts, Dynamic Images in BI Publisher.
• HDL Data Migration experience in migrating data pertaining to employee, payroll data using PBL from legacy applications such as PeopleSoft.
• Worked on Data load HDL from functional standpoint and helping to get the mapping related issues resolved.
• Worked on HDL to create and Update Worker history like Assignment details, Salary for both active and Terminated Employees.
• Created value sets and using them in flex fields (Descriptive/Extensible/Key) and scheduled Processes and Batch Process for Mass updates along with Data Exchange.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Determined all Cloud Global HR and Absence Management requirements for an ERP implementation project where a Mass Global Transfer was to occur.
• Managed configurations, process mapping, and issue remediation for Core HR, Employee/Manager Self Service, and Absence Management in an implementation and Provided functional design for all Absence Management Fast Formulas.
• Communication and co-ordination with Oracle support teams on regular basis.
• Troubleshoot/debug, performance tuning and Production Support.
• Functioned with Fast Formulas, reports and extracts needed for the client.
• Provided technology leadership and defines integration architectures for complex or strategic initiatives, cloud computing, automation process for different software services, including business, information, application, platform and infrastructure.
• Integrated the Oracle Fusion HCM cloud system in to client business applications and provided input on best practices and developed the reports using SQL and BI publisher.

Business Analyst

Confidential, Dallas, TX

Responsibilities:

• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports.
• Involved in implementing of Oracle HR/Payroll (ADP), OAB, SSHR, CWB, OTL, IRC, Performance Management, OLM modules.
• Worked cross-functionally with different teams to ensure effective execution of Oracle HCM Software such as Oracle HCM Fusion & Taleo Applications.
• Created requirement Specification (SRS) and FRD/FDS capturing Process Flows, Use Case Document, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams. Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Created and managed Use Case project templates and test plans utilizing the customer request documents for identifying specific business requirements to be created and maintained numerous automated functional regression tests from the ground up and delivered on time working within an Agile (SCRUM) process.
• Worked on Metalink to raise and track Service Requests to Oracle.
• Customized Oracle EBS Flex fields according to the requirement.
• Involved in the development of Stored Procedures and PL/SQL Packages.
• Customized and extended fast formulas.
• Worked on Converting Crystal to BI Publisher reports.
• Created requirement Specification (SRS) and FRD/FDS capturing Process Flows, Use Case Document, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams.
• Facilitated team processes; writing and reviewing Unit Testing and UAT test plans and scripts when necessary.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Functioned effortlessly and efficiently, as a liaison between four work streams and its task leads, SMEs, QA team, and management group.
• Actively participated in Joint Meetings with the various teams involved in the development process.