SUMMARY

• Oracle E - Business Suite Certified Implementation Specialist over 10+ years of experience as an Oracle Fusion HCM Cloud Consultant and Workday HCM. Extensive experience in different areas of Development, Production System Support, Data Conversion techniques, Implementation, System Configuration and Customization of Oracle Fusion HCM modules
• Experience in full end to end implementation, Support, Rollout and upgrade Oracle Cloud Applications in Fusion HCM Modules - Workforce Deployment (Core HR), Talent management, Performance Management, Goal Management and EBS HRMS Modules
• Experience in full end to end implementation of Compensation Module, creating compensation plans, bonus plan, Compensation year-end activities.
• Experience in Customizing/Creating Fusion HCM Security components like Abstract Role, Data Role, Job Role and Custom Security Profiles based on Clients operational requirements.
• Worked on performance management and goal management specific configurations for pilot population as per client’s requirement and enterprise deployment.
• Involved in the preparation of project management deliverables using AIM, OUM Methodology and AGILE Methodology.
• Experience in UI Testing, Test Design, Test Development, implementation of Test Plans and writing Test Cases for SIT and UAT.
• Work closely with development and QA teams to complete various test cycles and perform end to end functional testing.
• Data Loading/Conversions using Oracle HCM Data Loader, File Based Loader and Spread Sheet Loader
• Experience in Managing & creating Flex fields, DFF, Value sets & KFF in Fusion Cloud HCM.
• Hands on experience in working with Fast formula & HCM Extract to extract fusion data in different formats using database items (DBIs) & extract rules.
• Hands on experience in development of both Inbound & Outbound interfaces using HCM Extract, BI publisher & Data Modelling.
• Extensive experience in writing SQL queries using BIP and SQL Developer.
• Conversion of Oracle BI publisher reports and interfaces in OCA (Oracle Analytics Cloud) as part of global workday implementation
• Worked with Oracle support on high prioritized Open Service Request’s (SR) and conduct Oracle Web Conference (OWC) to resolve application issues and bugs; maintained follow-up with Oracle technical support team.
• Ability to prioritize and execute tasks in a high-pressure environment.
• Demonstrate excellent interpersonal and communication skills to interact effectively with both technical and non- technical members of staff.
• Worked extensively on onsite, offshore model and expertise to guide coordinate and assist team members to provide deliverables.
• Knowledge on Fusion financials modules GL, AP and AR like preparation of COA, Ledger, Reporting Currency Ledger, Requisition, Manual invoice, Debit Memo, Credit Memo, Payment Setups (Bank, Branch, Bank Account), Prepayment, Interest invoice etc.

TECHNICAL SKILLS

ERP-Functional Modules: Fusion HCM (R10, R11 and R12) - Workforce Deployment (Core HR),Workforce Development (Talent Management), Compensation Management Oracle EBS 11I and R12

RDBMS: Oracle8i/9i/10g, 11g

Tools: TOAD, SQL Developer, BI, OTBI, FBL (File Based Loader), HDL (HCM data Loader), Web ADI, HCM Extracts

Methodology: Oracle AIM, Oracle Unified Methodology (OUM), AGILE Methodology

Operating System: Windows

PROFESSIONAL EXPERIENCE

Confidential, Boston MA

Oracle HCM Cloud Techno Functional consultant

Responsibilities:

• Responsible for design, development of SABA(SanLearn) integration from SanConnect for daily employee, department, job, Cost center feeds using extracts
• Worked on the design and development of TALEO integrations like TCC which is a recruiting tool for Santander. Worked on feeds like job, cost center, Department feed, Job description, Job functions, Locations, LUDS(Lookups), TCC SmartORG, Worker details, etc using extracts
• Worked on the Integration for compensation tool (Compensation helper) which is a consolidated employee feed using BIP reporting
• Worked on design and development of Ignite feed which is an outbound integration for reward program.
• Worked on the design and development SANIAM integration for SailPoint tool using HCM extracts
• Worked on ADP outbound extract and maintained the inbound extract that we received from ADP.
• Scheduling the reports in different formats like excel, csv, text files through FTP and through emails.
• Development and customizations of OTBI Analysis and Dashboards for HRBP’s and HRBD’s and HR leadership teams.
• Analysis of the impact for adding new legal entity in Oracle Fusion Applications
• Development and customizations of dashboards as per the business requirement.
• Support and maintenance of connector feeds from Oracle fusion to PeopleSoft to support network ID generation.
• Managing lifecycles of quarterly patches for Oracle Fusion Applications
• Manage OTBI and BI Security requirements with thorough knowledge on Fusion Security Administration
• Design, development of ERP Fusion HCM extracts for various outbound integrations
• Worked on developments of Workflows for different level approvals and notifications.
• Managed the mass global transfer’s initiative for the bank based on the business decisions.
• Configured the job, location, department assignment Flexfields as per business requirements.
• Development of user manuals for managers and HR Business partners users
• Trained support team for multiple HR functionalities
• Implemented mobile responsive pages for compensation and core HR applications
• Knowledge of expression language required for RTF template.
• Development of salary/promotion revision letter as part of compensation year end cycles
• Support legal requirements by providing on time and accurate reporting.
• Involved in resolving day-to-day issues in the support environment.
• Conversion of Oracle BI publisher reports and interfaces in OCA (Oracle Analytics Cloud) as part of global workday implementation
• Worked on the data migration extracts in fusion through building the reports in BIP for WD implementation

Confidential, Boston MA

Oracle HCM Cloud Techno Functional consultant

Responsibilities:

• Worked on Career Framework project to address the several key goals related to the structure of jobs, job families and job levels in addition to associated regularity requirements. This project defines a revised career structure and definition approach for the bank.
• Worked with Business closely to gather the requirements of Career framework project. Understood the current state and future state of the project to include LOB agnostic functions/families, a broad band approach, core competencies and sub-competencies
• Worked on Impact analysis on all the integrations (inbound and outbound), reports, extracts etc.
• Worked on impact analysis of workflow notifications and approvals
• Worked on new reports that are supporting to build the HDL loads using BI publisher reports with SQL and OTBI intelligence reports using subject areas.
• Worked on proof of concept and unit testing for the job code, job family, job function, job profile, job description, Job profile items etc.
• Mass uploaded job families, job title, job function and valid grades through HDL. Mass loaded job profile changes, Talent profile descriptions, Talent profile items, created talent profile relation to job code.
• Worked on the changing the job code structure for all the workers in the organization using worker.dat files in HDL loader
• Design, development and customization of Oracle Business Intelligence Reports for various complex reporting and outbound integration requirements
• Development of SABA (SanLearn) integration from SanConnect for daily employee, department, job, Cost center feeds with new changes from career framework.
• Changed all ERP Fusion HCM extracts for various outbound integrations with Career framework changes
• Worked with Compensation business team for configuration of salary ranges based on the career bands which are newly introduced in Career framework.
• Updated the workflow approvals and notifications to include career bands introduced in career framework.
• Trained support team for multiple HR functionalities
• Worked on Pilot wave, wave 2, wave 3, wave 4
• Worked closely with Business while UAT Testing in each wave and received approvals from business for all the waves
• Involved in resolving day-to-day issues in the support environment.

Confidential, Boston MA

Oracle HCM Cloud Techno Functional consultant

Responsibilities:

• Implemented Oracle Fusion HCM(ERP) Goal Management, Performance Management in Talent Management.
• Gathered business requirements using standard questionnaire and performed fit-gap analysis by taking feedback from the business users iteratively.
• Configured Profile Management, Goal Management, Performance Management in Talent Management.
• Preparation of configuration document
• Configured Eligibility profiles, Goals, Goal Library, Goal Plan, Rating models, Performance review periods, Performance Documents.
• Involved in conducting workshops for the client during requirement gathering.
• End to End configuration of Talent Management.
• Have been responsible to maintain issue logs, bug fixes for system issues and finding resolution for the same during Configuration, testing and production stage.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data etc.
• Configured the approvals for various business processes as per business requirements for assignment changes and absence management.
• Worked on fast formulas in absence management offerings.
• Involved in performing CRP1 and CRP2 cycles.
• Worked closely with Business while UAT Testing.
• Used OTBI Reports.
• Tested all the task and business process flows related to Global HR and Talent Management.
• Build Custom Security to HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles, and Duty Roles.

Confidential

Senior Oracle Cloud HCM Functional Analyst

Responsibilities:

• Configured the tasks US geographies Structure, Enterprise Structure, Legal Jurisdictions, Legal authorities, Legal Addresses, Legal Entities, Legal Reporting Unit, Legislative data groups, Business Units.
• Configured the Workforce Structure related tasks i.e. Jobs, Positions, Grades, Grade rates, Locations, Departments, Position trees, Organization trees and Department Trees.
• Modified Approval rules in BPM for an Employee hire, termination, Promotion, transfer
• Configured Work force Schedules, Shifts, Work day patterns and assigned to employee based on Eligibility Profile
• Workforce Deployment, Profile Management, Talent Review, Workforce Directory, Performance Management and Goal Management. FBL (FILE BASED LOADER) HDL (HCM DATA LOADER)
• Configured workforce profiles tasks Content Library, Content type, Content items for Talent Management
• Defined Performance and Proficiency Rating Models.
• Configured the Goal Management tasks i.e. Worker goal setting lookups, Goal library, Goal Plans, Eligibility Profiles
• Configured the process flow for employee performance Evaluation
• Defined Questionnaire for Employees, Managers and Participants
• Configured the performance template with all the sections, Performance document
• Assigned Performance documents to Employees through customized/created Eligibility Profiles.
• Configured the Talent review and meeting templates.

Confidential

Senior Oracle Functional Analyst

Responsibilities:

• Business requirement gathering, requirement definition, mapping to future business models, solution design and testing deliverables.
• Developed and reviewed functional designs and solution architecting.
• Provided analysis, design and rollout of Oracle Accounts Payable and Internet Expenses for onshore project. Delivered operational analysis, business process re-evaluation, user training, and testing of modules.
• Worked with the end users and business owners to map Oracle Application standard processes to business requirements.
• Defined System Options, Payment Terms, Auto Accounting, Transaction Types, Transaction Sources, Remittance Banks, Receivables Activities, Receipt Classes, Receipt Methods, Receipt Sources, Profile Options in Oracle Receivables.
• Defined Financials Options, Payables System Setup Options, Payables Options, Payment Terms, Banks, Suppliers, etc in Oracle Payables.
• Define Asset Key Flex field, Asset Category Flex field, Location Flex field, System Controls, Calendars, Book Controls, Depreciation Methods and Rates, Prorate and Retirement Conventions, Asset Categories, Profile Options, etc in Oracle Fixed Assets.
• Preparing and updating the MD50 Prepared Mapping document BR.030 and setup document BR.100 Performed GAP analysis and prepared solution presentation for review.
• Configuring the modules, designing reports and add-ons and coordinating with the technical team to monitor development and implementation progress, designing and implementing various tests.
• Post Implementation support.

Confidential

Oracle Functional Consultant

Responsibilities:

• Addressed various mass data requests with HDL on day-to-day basis for varying business requirements.
• Gathering customer requirements to provide optimum solutions meeting with standard business processes and regulatory guidelines.
• Translate customer requirements into formal requirements, drive functional specifications and guide the team throughout the lifecycle of the work items.
• Translate customer requirements into formal business requirements, drive functional specifications and guide the team throughout the life cycle of the work items.
• Extensive coordination with Oracle (OCMS, Product support and OCS) for regular system maintenance activities.
• Manage Sandbox to address various customization requirements like updating field labels and hiding fields.
• Designed and development of dashboards for HR Business Partner, employee relations for rolling trends with OTBI.
• Design, development of ERP Fusion HCM extracts for various outbound integrations.
• Creating Fast formulas for various business requirements.
• Supported multiple business processes/workflows for various transactions like terminations, promotions, salary changes
• Configure and manage assignment Flexfields for multiple business requirements
• Created user manuals for Human Resource Business Partners and maintained the same for various features added as part of the quarterly patches released by the Oracle.
• Support legal and audit reporting for various data requirements from time to time.
• Designed, develop and scheduling of multiple BI Publisher reports with various outputs like csv, .txt, excel.
• Service now ticket resolutions and effective communication with client.

Confidential

Oracle Functional Consultant

Responsibilities:

• Worked on Oracle HRMS Approvals Management to build the workflows and notifications
• Configured a library of competencies and uploaded competency definitions.
• Define core competencies for a business group or organization.
• Defining competency profiles, Suitability Matching, qualifications, Succession Planning.
• Defining job-based career paths using the Oracle HRMS Map Career Path function
• Develop Test Cases for testing integrations Standard Application, Custom objects and OBIEE validation points for the reports.
• Tested OBIEE reports
• Test the solutions and custom process in Development, SIT environments and help users while doing CRP test by the business key users.
• Work on new requirements, defects for new or existing functionality and help in production support team in troubleshooting the issues.
• Prepared configuration BR 100 documents, DDR