SUMMARY

• Overall 7+ years of professional experience in IT industry with an Oracle Fusion HCM Consultant and implemented Oracle Fusion HCM using offerings like Workforce Deployment (Global HR, Payroll), Workforce Development (Talent/Performance/Goal/Management) and Compensation Management (Compensation and Benefits).
• Proficient in all phases of Oracle Applications R12/ 11i implementation with major focus in HRMS of Oracle Applications including Oracle HR, Oracle Payroll, Self Service Human Resource (SSHR), Oracle Time and Labor (OTL).
• Implementation, Configuration and supporting Oracle Cloud HCM implementations, Oracle Applications 11i/R12.
• Gather requirements from internal and external clients, provided documentation design, performed gap analysis and personalized pages based on the requirements using Oracle HCM.
• Working knowledge on ORDS REST API.
• Strong expertise in oracle HCM modules like Core HR, SSHR, Payroll, Oracle advance benefits (OAB), Oracle time and labor (OTL), Compensation workbench (CWB), performance management system (PMS), I - recruitment and Oracle learning management (OLM) Modules.
• Good Expertise and implementation experience on Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and, Security.
• Experience in Creating HCM Extracts and Delivery Options for Extracts and Experience in Creating Reports and Analytic using Fusion HCM.
• Expertise in Configurations, Personalization, Fusion Data Security, File-based loaders (FBL), Spreadsheet loader, PeopleSoft Payroll Batch Loader, OTBI Reports, BI Publisher reports, HCM Extracts.
• Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.
• Experience of end-to-end HRMS implementations and post-production support and SOX compliance.
• Strong understanding of Software Development Life Cycle (SDLC). Knowledge of both Agile and Waterfall Software development methodology.
• Expertise in working with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and integration.
• Hands on experience in configuring Fusion HCM Applications (Core HR, Talent Management (Goals and Performance management).
• Knowledge on both Inbound & Outbound interfaces using HCM Extract, BI publisher & Data Modelling.
• Hands on experience in working with Fast formula & HCM Extract to extract fusion data in different formats using database items (DBIs) & extract rules.
• 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.
• Strong functional documentation skills, created BR110, BR150, MD50, MD70 and TE040 for the implementation of HCM Modules
• Interacted with clients during the implementation process, involved in requirement gathering, preparing AIM and OUM documentation, business requirement documents, understanding current business process and mapping with Oracle cloud and EBS Applications.
• Expertise in developing integrations between EBS to Fusion and Fusion to EBS. Expertise in automation of these processes.
• Experience in Creating Reports and Analytics using OBIEE and ODI tools in 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, Work relationships data, and Salary info.
• Experience in developing functional, technical design and documentation for Oracle HCM data conversions, and interfaces.
• Worked on Fast formulas and able to write fast formulas as per the requirement.
• Experience in retrieving Data using SQL queries.
• A highly creative, energetic and results driven HR professional with progressive full-cycle recruiting, and employee relations experience.
• Configuring RightNow Customer Portal. Updating/creating templates, pages and CSS.

TECHNICAL SKILLS

Fusion Modules: -Core HR, Absence Management, Talent Management, Goal Management, Performance Management, Payroll, Benefits, Compensation.

Integration Tools: HCM Extract, HCM Data Loader (HDL), Functional Setup Manager (FSM),, File Based Loader (FBL), Payroll batch loader PBL

Reporting Tools: OBIEE, OTBI

Databases: Oracle 11g/10g/9i, MYSQL

Application Tools: MS Office, SQL Developer, Oracle SQL plus.

Scripting: SQL, PL/SQL

Languages ERP: Oracle Fusion HCM Cloud Solution (v8, 9, 10, 11, 12).

PROFESSIONAL EXPERIENCE

Sr. Oracle HCM Cloud Consultant

Confidential - Seattle-WA

Responsibilities:

• Responsible for Implementation Support / Configuration of Oracle Fusion HCM Global Payroll, Absence, Performance Management and Workforce Modeling modules.
• Worked on creating custom java program in EBS to invoke HDL file and load it to UCM server(Automation).
• Provided solution to use EBS as a platform, to generate HDL files for third party systems data integration with Fusion (inbound to Fusion) to avoid usage of SOA suite.
• Identified business requirements for Core HCM, Absence, compensation, Performance and map them to Oracle HCM Cloud Application functionality.
• Worked on End to End Conversion process from EBS to Fusion on data related to Global HR, Compensation and Payroll data.
• Involved in upgrading Oracle HCM from 11i to R12 and then implementing Oracle Projects module and Integrating said Projects module with Oracle Financials and Oracle Time and Labor modules.
• Complete understanding of Oracle Apps Implementation in R12 and 11i and Upgrade Projects from 11i to R12.
• Application SME for R12 technical upgrade (from 11i to R12.2.3).
• Maintained integrations between Oracle/Taleo Recruiting and internal/external partners including background check, assessment, tax credit, CRM, and virtual interview.
• Implemented and managed the firm's CRM (Client Relationship Management) database.
• Implemented Talent Management and Compensation Management in R12 including Employee Self Service, Manager Self Service, Security Administration, Workflows & approvals, Reports & Analytics, Email Alerts/Notifications, Application Customization and Data Migration, etc.
• Integrated Oracle data store with backend billing systems using MQ, Web Methods and SQL and performed development activities using Java,.NET, XML, XSD's, SOAP WS, SOAP UI, EJB's, ETL Tools, GIT, JENKINS, SQL, PL/SQL, RDBMS, JESI, DEVOPS, J2EE solutions Stored procedures, API's for DB2 and Oracle for complex high availability systems.
• Responsible for File Based Loader (FBL) for worker details includes loading of person data, employment data, experience, skills & competencies, Training etc.
• Worked meticulously with PeopleSoft team related to issues with data integrity, data conversion, and data mapping from PeopleSoft to Oracle HCM Cloud to support Coexistence model.
• Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Configured Absence Management to comply with changes in business requirement in Test and full configuration in the production environment.
• Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.
• Developed OTBI reports for HR users to view and validate employee data using existing subject areas.
• Determined all Cloud Global HR and Absence Management requirements for an ERP implementation project where a Mass Global Transfer was to occur.
• Customized management self-service for viewing and updating multiple employee status data, RMS modules HR, Advance Benefits, OTL and Payroll.
• Configured Fusion Core HCM, Payroll, General Ledger, Payables and Receivables.
• Created end user documentation for all Financials, HCM and Payroll modules
• Worked on Oracle HCM modules Core HR, SSHR, Performance Management, recruitment and Compensation Workbench.
• Worked on Absence Integrations with Payroll, OTL and Workforce scheduling and organized the testing process and Bug Reporting using ALM.
• Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Security Administration, Workflows etc.
• Performed Configurations as per the design for HR, Payroll, Self Service, Learning Management, Approvals Management and OAB modules.
• Involved in writing interfaces using HCM extract and BI publisher to move data between oracle cloud and external systems like ADP.Install, configure and build Oracle s pre-built analytics applications.
• Understand and customize delivered Oracle Analytics functionality.
• Performance tuning of analytics processes to meet requirements of reports and ETL jobs.
• Source Systems - Oracle HCM and PeopleSoft.
• Worked on basic core java to read file name and Unix scripting to do ad-hoc tasks.
• We used Tibco as middleware and ESS jobs were called by SOAP web service request. POC of sending file to UCM server, loading, importing, downloading file using SOAP was done by me using SOAP UI tool.
• Worked on basic core java to read file name and Unix scripting to do ad-hoc tasks.
• We used Tibco as middleware and ESS jobs were called by SOAP web service request. POC of sending file to UCM server, loading, importing, downloading file using SOAP was done by me using SOAP UI tool.
• Got basic knowledge on other Integration tool of Oracle Integration Cloud(OIC).
• Oracle EBS Worked on REST API POST, GET etc. methods.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse OBAW.
• Translate BI requirements into analytic BI subject areas.
• Worked on sending response in JSON format by calling OneTrust/TIPS API.
• Technologies Used: JSON, PHP, ROQL.

Oracle Cloud Payroll consultant

Confidential - Richmond,VA

Responsibilities:

• Implemented Co-Existence model for migration from Oracle EBS - R12 to Oracle Fusion HCM.
• Managed the global HCM employee record database.
• Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor (OTL), iRecruitment and Performance Management (PMS) modules to map the business requirements into Product functionality. Support experience in Oracle Advanced Benefits (OAB) and Oracle Learning Management (OLM).
• In affiliation with Payroll and HR, management and execution of the pay-load process to ensure quality and timeliness of paycheck distribution
• Provided roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
• Configured Absence Management to comply with changes in business requirement in Test and full configuration in the production environment.
• For a large hospital system in South Florida that has a robust OBIEE 11g implementation of OBIA 7.9.6.4 led technical effort to upgrade to OAC.
• Worked with this client before implemented OBIA 7.9.6.4, so I had a deep understanding of client's OBIEE environment and process so I was able to developed recommendations to achieve similar goals in OAC also developed alternate solutions when a desired goal cannot be achieved with out of the box OAC products.
• Involved in the Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Created roadmap document as well as migration guide for Absence and Time and Labor module to current environment.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
• Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
• Configured Absence Management according to business requirements in test and production environments.
• Analysed current Time and Labor rules, eliminated those not needed anymore, and provided guidance for change or consolidation for those currently not producing desired results.
• Extended and customized the OBIEE metadata repository including the physical, business model, and presentation areas.
• Analysed and Resolved production support issues in PeopleSoft HCM, custom/vanilla modules and interfaces, solved integration issues between HCM cloud and external/legacy systems to help deliver a seamless product.
• Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• Responsible for implementation of HCM Cloud Time and Labor.
• 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 Fusion R10 and R9 configuration (workflows, DFF, EFF, KFF, Business unit, LE, Compensation elements, rules, notifications, workforce management).
• Worked on Absence Integrations with Payroll, OTL and Workforce scheduling and organized the testing process and Bug Reporting using ALM.
• Worked as Oracle HCM Analyst and provided best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.
• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reportsEnvironment: OBIEE 11.1.1.7, EBS 11, R12, Informatica Power Center 9, OBIA 7.9.6.4 and DAC, Oracle 11g, Discover, SQL Developer, SQL*Plus, Windows-XP.

Functional Oracle HRMS Consultant

Confidential

Responsibilities:

• Provided support for Oracle core HRMS and SSHR modules.
• Provided functional support for creating employees, defining salaries, terminate employees, assign grade structure. Managing both employee and manager's self-service portal.
• Setup HR related Descriptive Flex Fields, Key Flex Fields, Validation Sets, and Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility.
• Involved in team discussion with customer and other functional and technical team members for analyzing the impact on the inter module relationship.
• 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 Approvals. 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.
• Developed HCM Extracts for Global HR, Benefits and Payroll Interface. End to End configuration for Talent Management and Core HR
• Created Oracle Fusion BI Reports and Analytics and Involved in testing existing BI Reports and creation of ad-hoc OTBI reports
• Setup all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centers, 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.
• 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.