We provide IT Staff Augmentation Services!

Senior Oracle Business Analyst Resume

Santa Rosa, CA

SUMMARY

  • Around 7+ years of experience in Design, Development, Administration and Implementation of Oracle HCM Cloud and Oracle Applications process design of HCM - Core HR,EBS,Payroll,TAX updates/Patches/Bundles, Migrations, General Ledger,Absence Management, Talent management,Time and Labor, Compensation Management (benefits, Incentive and Total Compensation) and implementation of Oracle EBS HRMS and Cloud HCM Fusion applications.
  • Successfully implemented Global HR, Compensation, Payroll, Time and Labor,Absence management module, General Ledger, Taxes, Benefits.
  • Judicious on HR Business Process Hierarchies.
  • Having good knowledge on 2-Tier and 3-Tier employment models.
  • Configured Elements (various types recurring and non-recurring) and Defined Salary Basis
  • Involvement in the Configuration of VBCS with Oracle and Oracle EBS Applications.
  • Solid knowledge on ESC, Job,Position Structure Creation and Deployment.
  • Integrated various cloud based SAAS and On - premise applications like Salesforce, Workday, Oracle HCM Cloud, ERP Cloud, Success Factors, Concur, Ariba, ServiceNow, Siebel, Oracle EBiz. And SAP systems using Oracle Integration Cloud
  • Comprehensive knowledge of oracle SOACS, ICS and Oracle Integration cloud, with strong background in implementing business solutions for various clients
  • Expertise in working with Oracle cloud, ERP cloud, Compensation,HCM cloud, Process Cloud service
  • Defined Banks, Bank branches, Bank accounts and Payment methods in Payroll.
  • Proven ability to complete projects on schedule, plan strategically, work with attention to detail and to use.
  • Expertise Oracle Integration Cloud in Human Tasks, Mediator, Sub Process, Business Rule and Component Templates, Custom activity templates.
  • Practical / business like approach towards problem solving.
  • Involved in Oracle Payroll Cloud for HR process with tax reporting and regulatory rules to ensure compliance
  • Functional solid experience with Design, Development, Implementation, Customization and Production Support of Oracle Applications.
  • Prowess in defining Users, Responsibilities, Creating Functions, Menus, Request sets, Request groups, Registering Concurrent programs, Migration, Lookup types and defining Value sets.
  • Solid experience in all aspects of software development life cycle such as performing gap analysis, writing functional specifications, implementing/customizing oracle applications to suit client requirements.
  • Worked with oracle support, using metalink, to resolve issues using knowledge base.
  • Work jointly extensively on PL/SQL in developing the queries and on open interfaces in Inventory.
  • Actively engaged in finance in sourcing to assist in the successful operation of Procure to pay cycle
  • Experienced in designing business processes, documenting standard operating procedures and training business users in these procedures. Also training client users at various levels from clerks through superusers.
  • Experienced in functional testing, integrated testing, setups, Migration,design validation and conducting conference room pilot.
  • Prowess communication and verbal skills at both User and Management levels.
  • Ability to work in a team environment with matrix reporting structure, actively participate in projects meetings, walkthroughs within work groups.
  • Involvement in the workshops conduction and suggest Oracle offerings to the clients.
  • Involvement in the conduction of the new technologies in the team to improve the team members skill sets according to the Trend.

TECHNICAL SKILLS

Databases: Oracle, MS SQL Server, MS Access,Oracle 9i.

Languages: SQL, PL/SQL, C, C++

BI: OBIEE, ODI

ERP: Oracle HCM Cloud Solution (v10, 11). Oracle Applications 11i./12x (Core HR, SSHR, OLM, Payroll, OAB), Oracle Fusion Applications(R10,R11), Oracle fusion Application, Oracle Payroll cloud.

11i/R12: HRMS (Global HRMS, Payroll, Time and Labor, Absence Management) Purchasing, i-Procurement, Inventory, Order Management, Accounts Payable, Accounts Receivable,General Ledger,Taxes, i-Supplier, Compensation, Fusion Benefits.

Fusion Cloud: Core-HR, Payroll, Absence Management, Talent Management

Methodologies: Oracle AIM/OUM Methodology & Systems Development Life Cycle

Business Apps: MS- Project, Outlook, Visio, Word, Excel, PowerPoint.

Migration: (HDL, Payroll Batch Loader, Spreadsheet Loaders)

Interfacing: (HDL for inbound, Extracts for outbound, Web Services)

Reporting: (as many of OTBI, BIP, SQL, XML/XSL, Extracts, Logical SQL)

PROFESSIONAL EXPERIENCE

Senior Oracle Business Analyst

Confidential, Santa Rosa, CA

Responsibilities:

  • Implemented Oracle HCM cloud Global HR, Compensation, Absence Management and Goal Management, Payroll offerings and EBS.
  • Gathered business requirements using standard questionnaires and performed fit-gap analysis by taking feedback from the business users iteratively.
  • Conducted Sessions to demo the out of box functionality on Oracle EBS Core-HR, Payroll and Performance Management modules.
  • Involved in data conversion effort to facilitate superior quality of data from Oracle EBS to Oracle Fusion HCM.
  • Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR and Payroll.
  • Performed Starter steps like Create Implementation Users, View All data roles, Load/Manage Geographies.
  • Set up and Maintained Enterprise structure and Workforce structures.
  • Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
  • Involved in defining eligibility profiles, time periods, absence types and absence plans as per the client requirement both Accrual absence and qualification plans.
  • Configured the approvals for various business processes as per business requirements for assignment changes and absence management.
  • Worked on fast formulas in Payroll and absence management offerings.
  • Configure Fusion Functional Setup Manager.
  • Involved in extracting data from EBS data mapping transformation and data migration through oracle cloud.
  • Configuring Fusion Sub ledger Accounting (SLA)
  • Configuring Fusion Payables - Supplier Model, Create Payment Term,Cut-off Strategies,manage invoice options and payment options
  • Configuring fusion payments - payables - Payments Activities, Payment System, Payments and submitting a payment process request.
  • Configuring Fusion Receivables - Receivable Activities, Receivables System Options, Receipts, Customer and Profile Class.
  • Configuring fusion payments - Receivables - Payments for funds Capture Activities, Setting Up Funds Capture for Receivables
  • Set up and Maintained Enterprise structure and Workforce structures.
  • Involved in the Designing of interfaces and integrations between modules in Oracle EBS.
  • Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
  • Involved in defining eligibility profiles, time periods, Time and labor,absence types and absence plans as per the client requirement both Accrual absence and qualification plans.
  • Prepared Test Scripts, Test Scenarios and Test results documents.
  • Excel in Oracle Human Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.
  • Expertise in payroll balance configuration and conversion, year-end and mid-year balance adjustment, execution of payroll processes, generation of Payslip, W2 and government reports for Oracle Payroll.
  • Expertise in writing and modification of Fast formulas used in Oracle Payroll.
  • Experience in configuring and setting up of OBIEE Security configuring object level and database level security.
  • 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.
  • Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
  • Expertise in Oracle Payroll compensation management, Salary review, designing of especial earning rules using Fast formulas.
  • Developed an OTL report to identify missing time cards and approve them using a custom program.
  • Performed maintenance on existing HCM configurations and worked with the users and defined standards on using Descriptive Flex fields from reporting and integration perspective.

Senior Oracle Business Analyst

Confidential, Culpeper, VA

Responsibilities:

  • Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR.
  • Experience with configuration, testing, cutover and production support.
  • Manage Enterprise HCM Information and Legal Entity HCM Information.
  • Set up and Maintain Enterprise structure and Workforce structures.
  • Involved in the complete testing of the Employee Transfers and 2-Tier and 3-Tier employment model.
  • Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
  • Worked with the business in understanding the HCM cloud features and analyze the feature that best fits the business requirements.
  • Experience in Oracle HCM (EBS/Fusion), including workflow and alerts, PL/SQL and Fusion Middleware Object Design, Development & Testing.
  • Involved in resolving Production Support issues relating to creation of Characteristic Fields, Value Fields, and assigning value to Value Fields.
  • Develop HCM Extracts/OBI Reports for Global HR.
  • Involved in end to end test cycles and prepared the test scripts and scenarios required to test various business cases.
  • Written Accrual fast formulas to support the vacation and sick absence plans.
  • Developed new BI reports to extract the absence details and related other reports.
  • Developed and configured new roles (Job, Duty and Data roles) using the Fusion Security model.
  • Developed complex person security profiles, organization security profiles to support the complex custom criteria while configuring the job and data roles.
  • Written a Payroll Batch Loader transformation formula to load the Element Entries.
  • Element Configuration using Payroll Batch Loader.
  • Element Eligibility Profiles load using Payroll Batch loader.
  • Developed HCM Extracts to to extract the data from Oracle Cloud systems in HR Achieve
  • Developed BI publisher reports in Absence,Time and Labor, HR and Payroll area and developed 2 HCM extracts, one of them is a changes only extract.
  • Configured Fusion Applications for the End-to End Performance Cycle.
  • Tested all the tasks and business process flows related Payroll, Global HR and Talent Management.
  • Handled regression testing and file path migrations for inbound and outbound processes.
  • Tested all the task and business process flows related to Payroll, Global HR and Talent Management.
  • Involved in End-to-End testing of Global HR, Payroll 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.

Oracle Business Analyst

Confidential, Boston, MA

Responsibilities:

  • 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 clients (e-TIME and Payforce) with Oracle.
  • Developed functional designs in support of global system implementations. Recently completed Oracle HR implementation for Singapore.
  • Configurations related to Absence Management and Talent Management.
  • Identified business requirements for Core HCM, Absence, compensation, Performance and map them to Oracle HCM Cloud Application functionality.
  • Conversant with Oracle e-Business Suite- Core HR, Payroll and HR Self-Service, Oracle HCM cloud - Core HR modules with expertise in providing functional solutions for Oracle Applications and technology-based solutions for enhancing functional efficiency of the organization & achieving business excellence.
  • Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports to be delivered to Email and FTP sites.
  • 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.
  • Use Oracle Fusion Functional Setup Manager (FSM) to implement enhancements.
  • Build Custom Security to Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles at APM, OIM and Security Console.
  • Developed OTBI reports for HR users to view and validate employee data using existing subject areas.
  • Excel in Oracle Human Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.
  • Expertise in payroll balance configuration and conversion, year-end and mid-year balance adjustment, execution of payroll processes, generation of Payslip, W2 and government reports for Oracle Payroll.
  • Expertise in writing and modification of Fast formulas used in Oracle Payroll.
  • Experience in configuring and setting up of OBIEE Security configuring object level and database level security.
  • 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.
  • Involved in end to end test cycles and prepared the test scripts and scenarios required to test various business cases.
  • Tested all the tasks and business process flows related Payroll, Global HR and Talent Management.
  • Handled regression testing and file path migrations for inbound and outbound processes.

Oracle Analyst

Confidential

Responsibilities:

  • Implemented Performance Management by creating roles for eligible participants to access the performance document to provide feedback.
  • Work cross-functionally with IT and LOB teams to ensure effective execution of Oracle HCM software such as Oracle HCM Fusion & Taleo Applications.
  • Maintained integrations between Oracle/Taleo Recruiting and internal/external partners including background check, assessment, tax credit, CRM, and virtual interview.
  • Performed benefits and work structures data population within Fusion HCM using spreadsheet based loaders.
  • Perform Configurations as per the design for HR, Payroll, Self Service, Learning Management, Approvals Management and OAB modules.
  • Developed multiple HCM Extracts for outbound interfaces to integrate with other systems and designed some extracts for Payroll Interface.
  • Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and Fusion Middleware Object Design, Development & Testing.
  • Performed gap analysis between business requirements and Fusion Compensation and Benefits functionality.
  • Working as Oracle Fusion subject matter expert providing best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates.
  • Gather requirements and deliver information using Oracle Business Intelligence (OBIEE) and Oracle Noetix reporting software.
  • Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.
  • Use Dynamic SQL and Execute Immediate functionality to perform DDL in PL/SQL blocks and procedures.
  • Use Collections like variable arrays, nested tables in PL/SQL programming.
  • Provide on-call and daily production support of APEX applications and Oracle PL/SQL ETL processes.
  • Manage User Acceptance Testing of new applications and new versions of existing applications.
  • Manage the packaging and release of applications to the training and production environments
  • Analyzed all issues in migration processes and resolved issues.
  • Documented all Oracle designs and associated functional and technical requirements.
  • Coordinated with clients and performed tests on all software applications.
  • Administered everyday activities of the program by the project boards.
  • Analyzed and recommended improvements to the software development process
  • Developed high-level Requirement Documents Business Requirements Document (BRD) and FRD.
  • Set up work flowcharts using UML, and worked with Business Process Modeling tools for users for the procedures in claims.
  • Facilitated business requirements gathering sessions and overlooked the creation of Use Cases/Activity Diagrams, Functional Specifications using UML.
  • Participated as business partner in configuration of performance goal management processes.
  • Manage Payroll operations for growth while providing outstanding customer service.
  • Performed relational database design and Modeling and conducted multiple SQL querying.
  • Worked on Absence Integrations with Payroll, OTL and Workforce scheduling.
  • Developed and documented OTBI reports for payroll and Absence management.
  • Worked on gatherings for configuration, conversion and enrolments in Fusion Benefits.

Oracle Analyst

Confidential

Responsibilities:

  • Analyzed and implemented several Oracle provided patches to fix the bugs in the Production Environment and upgrade instances.
  • Tested and maintained Oracle payroll module software for enhancements and complete new conversions.
  • Hands-on experience in Fusion HCM Applications (Core HR, payroll, Talent Management, Compensation and performance management).
  • Developed custom reports using Business Objects in Oracle-Taleo for leadership, human resources, and talent acquisition teams.
  • Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
  • Customized management self-service for viewing and updating multiple employee status data. RMS modules HR, Advance Benefits, OTL and Payroll.
  • Worked on Oracle HCM modules Core HR, SSHR, Performance Management, iRecruitment and Compensation Workbench.
  • Involved in data conversion effort to facilitate superior quality of data from Oracle EBS to Oracle Fusion HCM.
  • Developed the Fast formulas for Applaud time entry, Accrual plans and Input validations- Approval setup for the leaves based on the leave types.
  • Designed programs to upload time from Time force to OTL data conversion including time and attributes for OTL module.
  • Worked closely with SMEs in Merchandising and various departments like sales, operations, finance, research group, shipping to ensure timely and accurate requirement gathering.
  • Created an Inventory process and synchronized data integration in coordination with a third party vendor.
  • Skillfully conducted a cost analysis and feasibility matrix to select appropriate third party vendors for the project.
  • Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis.
  • Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Vision.
  • Performed Unit Testing and User Acceptance Testing and documented detailed results.
  • Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan.
  • Work cross-functionally with different teams to ensure effective execution of Oracle HCM Software such as Oracle HCM Fusion & Taleo Applications.
  • Functional, Integration, Technical and Transitions lead for Oracle Taleo/Fusion implementations.
  • Performed active role in analyzing, designing, testing and implementing several interfaces/ customizations to implement core HR.
  • Mainly involved in upgrading the system by performing the pre-upgrade and post upgrade steps.
  • Involved in feasible analysis and setup for Standard and Customized workflow as per business requirement.
  • Strong Exposure to Data Conversion and migration include HRMS, Payroll, Oracle Advanced Benefits (OAB), Oracle Time & Labor (OTL), modules to Oracle Applications using Oracle API.

Hire Now