SUMMARY

• A seasoned dynamic professional having 8+ years of experience in analyzing, designing, developing, implementing, and testing associated with Oracle Fusion HCM, FINANCE & SCM Expertise in developing reports using BI publisher Expertise in the field of OTBI & BI, Data migrations, performing implementation of new projects and integrations
• Worked on Data Migration using File Based Data Import (FBDI approach) & HDL
• Experience in implementing Outbound Bursting through EMAIL, UCM and FTP servers
• Worked on Web services for migration of Data from Oracle Apps R12 to cloud
• Strong experience in loading data for Human Capital Management module like Employees, Persons, person names, Person email, Work Terms, Work relationships, Assignments, Jobs and User Information
• Strong experience in loading Data for various finance modules like General Ledger, Suppliers, Customers, Supplier bank accounts, AP Invoices and cash management module like Banks and branches
• Experience in developing Fusion Personalization/Customization
• Worked on transferring files from One FTP Server to another, migration from one integration to another and Automation of HDL by using Oracle Integration (OIC)
• Worked on creating various web applications by using Virtual Builder Cloud Service (VBCS)
• Having good exposure on Process cloud service
• Knowledge on Oracle Apps R12 ( XML, RDF reports, Forms, Alerts, Interface etc.,)
• Great command on SQL
• Expertise in writing PLSQL codes, stored procedures, views and tables with constraints

TECHNICAL SKILLS

• Oracle Cloud OIC Integration
• HCM: Payroll
• Benefits & Compensation
• Global HR
• AMS
• HDL
• HCM Extracts
• On - Prem - Microsoft Exchange
• Oracle EBS ERP
• Financials: General Ledgers
• Payables
• Receivables
• Fixed Assets
• Capital Management
• FBDI
• SCM: Procurement & Product management
• Accounts Payable and Accounts Receivable
• Technical Analysis
• Team Support
• BI & OTBI Reports Knowledge Base Training Materials Design

PROFESSIONAL EXPERIENCE

Oracle Cloud ERP / Techno Functional Consultant

Confidential, Birmingham, AL

Responsibilities:

• Worked on Automation of HDL in Oracle Integration Cloud Implementation of Payroll related Projects
• Experienced migration of data from one integration to another in OIC Created Supplier info applications using Virtual Builder Cloud Service Provided support in creating various applications using Virtual Builder Cloud Service
• Worked on building integration to load data into Oracle ERP using OIC Support for implementation team on Core HR modules
• Documenting user guides for Core HR modules
• Designed customization and extensions: SITs, and Flex fields.
• Implementation and documentation of HCM Payroll projects.
• Creation of HCM Benefits and compensation process functional documents.
• Developed certain technical objects like Alerts, complex value set validations. Performed data migration in production instances using Data load
• Developed numerous BI and OTBI Reports
• Responsible for developing and migrating all custom interfaces Enhanced and developed numerous OTBI/BI reports for module Prepared reconciliation reports for defects tracking
• Responsible for all post environment refresh activities
• Responsible for Project audit and status reporting related activities. Communicated and explained business requirements to team members to understand and implement functional demands.
• Applied knowledge of application components in conjunction with query tools to achieve business objectives.
• Transfer Oracle EBS ERP Data on Premises to Oracle cloud.
• Performed internal system acceptance to deliver well-tested enhancements and meet business requirements.
• Developed flowcharts and diagrams to describe and lay out logical operational steps.
• Collaborated closely with upper management to drive strategy through development and implementation of new processes.
• Facilitated front to back solution design value chain for accountable team members.
• Wrote effective documentation for each client system to deliver comprehensive sets of requirements and alignment with business objectives.
• Established priorities and drove accountability for assigned initiatives, providing leadership.
• Developed, configured and tested applications for accurate alignment with project standards.

Senior Consultant

Confidential, Chicago, IL

Responsibilities:

• Creation of Value sets in various Modules of the application Developed BIP Reports as per business Requirement Development of OTBI Reports in HCM,Finance and SCM Good Understanding of Financial and Procurement Modules
• Data Loaders using FBDI method for external file data into application Configured Suppliers, Customers, Invoice, Payment Options for Financial Modules
• Developed AP Invoice load using FBDI Approach
• Involved in Period Close activities and Postproduction Support Issues
• Developed Fastformulas in payroll and Absence on HCM
• Developed and configured new roles (Job, Duty and Data roles) using the Fusion Securities
• Data migration using FBDI and HCM data loader
• Developed infolets in Financial services and Procure to Pay offerings Developed custom reports and Dashboard reports using OTBI Publisher Developed OTBI-Reports based on client requirement
• Also configured enterprise structures, workforce structures, trees, profile options, Payroll definitions, elements, absence plans and types etc
• Resolving the issues and defects through ticketing tool
• Performed HCM Extracts and generating reports by using BI Publishers.

Senior Consultant

Confidential, Laurel, MD

Responsibilities:

• Involved in Employee, Jobs, Positions, Grades load and configurations Created HCM Data Loader Programs using .dat file approach Configured Employee, osition, Supervisor Hierarchy for HCM
• Developed HCM Data Extract Programs for Employee, Assignment Changes Only Worked on Items Load using FBDI
• Worked on Customization of seeded Reports as per changed business Requirement Created LOV, Parameters for OTBI
• Worked on Sandbox Changes on SaaS Model for various Application Changes Once in Transactions flows/Tables in Financial, SCM and HCM domain Involved in development and Customization of assigned Components Developed Reports as per client requirement
• Preparation of Unit Test Cases for Unit Testing, System Integration Testing and User Acceptance testing
• Creation of concurrent programs, executables, Responsibilities, request groups, menus, and value sets in AOL
• Involved in Oracle application framework personalization.
• Worked on Oracle Fusion BI Publisher reports
• Worked On Microsoft Exchange on Premises
• Designed MS Word Templates to use in report Layout
• Involved in writing Fast- Formulas, BI Extraction queries Worked on Data Migration by using FBDI Approach
• Getting the data from third party and uploading data to Oracle Fusion cloud Loaded data using HCM Data Loader and Spread Sheet Data Loader Actively Involved in creating Fusion Personalization