SUMMARY:

• Over 7 years of IT experience as Oracle HCM Cloud consultant with ability to configure HR, Oracle Advanced Benefits, Compensation Workbench, Talent as well integrate with Oracle HCM cloud, file/worksheets based loaders for HCM components.
• 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.
• Strong expertise in Oracle HCM modules such as 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.

TECHNICAL SKILLS:

Languages: PL/SQL, Oracle Forms 4.5,6.i, 9i, Oracle Reports 3.0, 6i, 9i, Oracle Portal 3.0, UNIX, Shell Script.

Development Environment And applications: Oracle Cloud R11, Oracle Identity Manager,, Oracle HCM, OTL, GL,PPM,AR,AP, Oracle BI Publisher, Oracle Fusion HCM, Oracle HCM Data Loader, Oracle 10.2.0.2, R12,11i (Financial), Oracle EBS - R12, Oracle Workflow 2.6.3.5 DBA Studio, RMAN, SQL* PLUS, Erwin, TOAD, SQL Navigator, Reflection for Unix, Tarantella, BI Publisher, APEX 4.0,5.1, Data Loader 5.4.1.0, PL SQL based extensions (RICE objects), ERWIN7

Software: Oracle 6.0,7.2, 7.3, 8.0.5, 8.1.5, 8.1.6, 8.1.7, 9.2,10.2.0.1,10.2.0.2, 11g RAC, Oracle9i Application Server, Access 97, 2000. UNIX SUN, AIX, and HP-UX11i, Linux, Windows XP, NT, 2000, 2003 and DOS, Windows Server 2003.

EXPERIENCE:

Confidential, San Francisco, CA

Oracle HCM Cloud Consultant

Responsibilities:

• 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 pay check 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.
• 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.
• Implemented Co-Existence model for migration from Oracle EBS - R12 to Oracle Fusion HCM.
• Built 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 Absence Integrations with Payroll, OTL and Workforce scheduling and organized the testing process and Bug Reporting using ALM.
• As Oracle HCM Analyst, provided best-practice guidance on HCM business processes on OTL, Payroll integrations and mass updates.
• Analyzed 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.
• Created Oracle Fusion BI Reports and Analytics and tested existing BI Reports and creation of ad-hoc OTBI reports.
• Assisted in running daily integration jobs from Workday to Oracle HRMS and investigating/resolving data reconciliation issues related to the integrations.
• Worked on the Integration of Oracle Fusion HCM with other modules like Taleo Recruitment and on boarding.
• Integrated Oracle new Human Resources (HR) Technology, which was transitioned from Workday HR, into Oracle Finance as a single reporting functional structure.
• 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.
• Implemented Workday HCM Core HR, Talent Module, on boarding & Recruiting modules testing. Review, test, and implement system upgrades or patches rules.
• Developed Outbound PL/SQL Packages, Procedures, and Functions for validating the Purchasing, Receipts and Invoice Payments and inserting in staging table to transfer data to third Party.
• Provided technical/functional support for various Oracle E-Business Suite implementations with different Oracle Partners.
• Acted as a lesion for OAB Custom Inbound and Outbound Interfaces and Configurations between Oracle EBS Applications and their Integration with legacy applications.
• Configured Workflow routing rules for all Employee Self Service actions and Manager Self Service actions.

Confidential, Bannockburan, IL

Oracle Cloud Payroll Analyst

Responsibilities:

• Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labor (OTL), Recruitment and Performance Management (PMS) modules to map the business requirements into Product functionality.
• Provided roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labor.
• Involved in the Data Loading/Conversions using HCM Data loader (HDL) which includes Workforce structure data, Worker data, Work relationships data, and Salary information.
• Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
• Analyzed current Time and Labor rules eliminated those not needed anymore, and provided guidance for change or consolidation for those currently not producing desired results.
• Managed the global HCM employee record database.
• Captured requirements and provided recommendations to the design of Fusion Absence Management.
• 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.
• Provided solutions for ad hoc queries on Core HR, Benefits, Talent Management and Compensation STIP plan.
• Responsible for implementation of HCM Cloud Time and Labor.
• Worked 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 reports.

Confidential, Houston, TX

Oracle HCM Analyst

Responsibilities:

• Implemented different phases of Software Development Life cycle (SDLC) including Strategic Systems Planning, Designing, Programming, Testing, Documentation, and presentation to clients and preparing customer specifications as part of software technical requirements and Customer support
• Produced various business documents such as business Requirements Document (BRD), Functional Requirements Document (FRD), and Non-Functional Requirements Document (NFRD), business Process Documents, business Flow Documents, User Training Manuals, User Interface Specifications.
• Reviewed the business requirements document with the business and development team to understand the architecture and functionality of the application. Ordering entry applications, billing systems and data flow to provisioning systems and interfaces between them.
• Requirement elicitation and analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document.
• Received and analyzed the tasks from BA lead, requirements from Board of Directors, Department of Marketing, Department of Logistics & Operation, and Department of Customer Service.
• Analyzed and did SRS (System Requirement Spec), transfer to developers, QC (Quality Control).
• Worked in an Agile/Scrum environment which poses initiating the JAD sessions and active integration with business, technical and engineering terms.
• Excellent understanding of the software methodologies such as Agile, Waterfall, Waterfall-scrum, Agile Scrum, and RUP.
• Created Impact Analysis documentation to address issues with moving to new HCM platform
• Develop and implemented plans for formal testing events (Conference Room Pilots, User Acceptance Testing, etc.)
• Worked on Queries related to database size, space related queries and database version.
• Created Database objects like views, columns and tables as per requirement.
• Worked on functions, Stored Procedure and Triggers for Validation.
• Worked on relevant queries to get ad hoc data required by various Oracle users such as payroll, operations, tax and compliance in a techno-functional support role for both Oracle Payroll and OTL.
• Created SQL scripts to automate the manual process.
• Supported UAT (User Acceptance Testing) and solved issues from customers and other departments.
• Conducted requirement gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD) and the Functional requirement Document (FRD).
• Involved in Requirement scoping and analyzing high priority Requirement.
• Created BRD documentation along with various workflow diagrams and functional diagram for business process on MS Visio to provide a deeper understanding of the various systems involved.
• Performed Confidential Analysis to analyze the current system and worked with internal users to help define system requirements

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Requirements gathering and developed documentation with company standards and performed Confidential analysis.
• Designed HCM Extracts for Inbound & Outbound Interfaces using FBL and HDL familiar with Fusion Cloud data model and build various BIP in fusion cloud environment.
• Part of business process workshops and requirements gathering sessions; support clients in defining relevant processes.
• Setting up application for Workforce Compensation - which includes Creating of New compensation plans, new plan budgets, Eligibility profiles, Fast formulas, running batch processes etc.
• Hands-on full lifecycle project delivery and go-live experience.
• Setup Fusion Compensation plans, budget, worksheet, Total Compensation Statement and budget sheet customization
• Used Oracle Fusion Functional Setup Manager (FSM) to implement workforce deployment and development.
• Involved in data conversion effort to facilitate good quality of data from Oracle EBS to Oracle Fusion HCM.
• Developed customized real-time OTBI reports and Dashboards for Executive team.
• Involved in creation of Custom Security for Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Configured workforce compensation plans, Plan Eligibility, Plan Cycles, Compensation Budgets, Compensation components, Global Models, performance ratings, Workforce compensation approvals and Total Compensation Statements.
• Coordinate with QA team and ensure the product is bug free and ensure all test cases and scenarios are covered.
• Analyzed complex cross functional business processes and defines integrated requirements.
• Manage business stakeholders, plan and manage steering committee meeting.
• Prepare project estimations, project budgeting, project schedules and resource allocations and execute projects successfully within budget and estimated timeframe.
• Work with Management, Business Users and third party vendors to understand the requirements and guide the team on designing and mapping the requirements to Fusion HCM system.
• Prepare the documentation for Business Requirements, Functional specifications, Business Requirements, Functional Requirements and Test case documents and get sign-offs from the business users and Management.