SUMMARY:

• Over 8 years of IT experience as Oracle HCM Cloud consultant with ability to configure HR, Oracle Advanced Benefits, Compensation Workbench, and 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 labour (OTL), Compensation workbench (CWB), performance management system (PMS), Talent Management, Goal Management, I-recruitment and Oracle learning management (OLM) Modules have worked on implementation, production support, ongoing support (trouble shooting) and enhancement activities on oracle e-business suite applications.

TECHNICAL SKILLS:

Languages: PL/SQL, SOA, JAVA, 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, PeopleSoft, 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.2, Oracle Workflow 2.6.3.5 DBA Studio, RMAN, SQL* PLUS, Developer 2000, 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.

WORK EXPERIENCE:

Oracle HCM Cloud Consultant

Confidential, Costa mesa, CA

Responsibilities:

• Responsible for requirement analysis, design and architect of the business processes in Oracle Cloud and transition from 2 existing legacy applications for Compensation.
• Defined setups of Core HR, Self Service HR, Payroll, Oracle Time and Labour (OTL), Recruitment and Performance Management (PMS) modules to map the business requirements into Product functionality.
• Designed and DevelopedFastFormulas to compute for differentOraclePayroll processes.
• Provided solutions in Customizing and implementing different applications like OAF customizations and personalization,FastFormulas, XML publisher reports.
• Performed production support duties included a custom check writer andfastformulaand skip rules
• Develop and MaintainFastformulas inOraclePayroll.
• Create Payroll elements, element links and assign the element to itsFastFormula.
• Create new functions to use in Benefit rule'sFastFormula's.
• 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.
• Provided roadmap document, executive summary and strategy for upgrade to current release for two modules, Absence Management and Time and Labour.
• Coordinate with Fusion Time and Labour and Payroll Team to build a design that best suits the client.
• 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 like Core HR, SSHR, Payroll, Oracle advance benefits (OAB), Oracle time and labour (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, 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.
• Experience in Customizing Cloud HCM Security components like Data Role, Job Role, Duty Role, Security Profiles, Abstract roles and well versed with aggregate privileges and assigning duty roles.
• Extensively involved in Enterprise level design sessions and helped in HR and Payroll one-time setups and Involved in third party integration to and from Cloud HCM.
• Performed project activities related to requirements gathering and fit/gap analysis, system design, core table setup, testing in support of HCM core HR module.
• 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.
• Built Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Involved in Absence Integrations with Payroll, OTL and Workforce scheduling and organized testing process and Bug Reporting using ALM.
• ModifiedFastFormulas andFormulaResults.
• 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.
• 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.
• 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.

Oracle Consultant

Confidential, San Antonio, TX

Responsibilities:

• Support experience in Oracle Advanced Benefits (OAB) and Oracle Learning Management (OLM).
• Prepared functional designs for Core HR, Payroll and SSHR and prepared test cases for Payroll, Core HR and SSHR.
• 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.
• Tested XML for core HR and Payroll.
• Setup and maintained enterprise and workforce structures and involved in the designing of payroll inbound and outbound interfaces.
• In affiliation with Payroll and HR, management and execution of the pay-load process to ensure quality and timeliness of pay check distribution
• 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 migration guide for Absence and Time and Labour module to current environment.
• Implemented Co-Existence model for migration from Oracle EBS - R12 to Oracle Fusion HCM.
• Captured requirements and provided recommendations to the design of Fusion Absence Management.
• Involved in Data Conversion and migration include HRMS, Payroll, Oracle Advanced Benefits, Oracle Time & Labour (OTL), modules to Oracle Applications using Oracle API.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
• Configured Absence Management according to business requirements in test and production environments
• Proficient with TOAD, writing SQL queries to drill down for issues.
• Expertise in Oracle Payroll compensation management, Salary review, and designing of especial earning rules using Fast formulas.
• Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR.
• Manage Enterprise HCM Information and Legal Entity HCM Information.
• Configure new HR and Payroll whenever there's new benefits (i.e. new CBA benefits) including writing fast formulas.
• Extended and customized the OBIEE metadata repository including the physical, business model, and presentation areas.
• 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.
• 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 Absence Integrations with Payroll, OTL and Workforce scheduling and organized 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.

Oracle Business Analyst

Confidential

Responsibilities:

• Worked on Workforce Deployment, Compensation management, Talent Management (Goal management, Performance management, talent Review and Succession) and Security.
• Involved in requirements gathering and developed the documentation with company standards and performed GAP 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/CRPs and requirements gathering sessions and 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 offerings like workforce deployment, workforce development.
• Involved in data conversion effort to facilitate good quality of data from Oracle EBS to Oracle Fusion HCM.
• Implemented in PL/ SQL triggers for changes the Informatics mapping when OLTP data is updated/deleted from previous months.
• Developed customized real-time OTBI reports and Dashboards for Executive level roles like HR, Director, and 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.
• Solid experience in Database design, creation and management of schemas, APIs, writing stored procedures, functions, triggers, DDL, DML, SQL query performance tuning with hints. Proficiency in writing PL/ SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• 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.

Business Analyst

Confidential, York, PA

Responsibilities:

• 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.
• Worked on custom interfaces for Order Management module to create Buyer and Seller orders coming from Big Commerce as part of e-commerce project.
• 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
• Consistently delivered projects on time and under budget, Oracle Payroll production support
• 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 analysing 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 GAP Analysis to analyse the current system and worked with internal users to help define system requirements.