SUMMARY:

• Having 10+ Yrs. of extensive experience in Oracle Applications and Fusion Cloud (Procure to Pay and HCM) in the fields of Manufacturing, Utilities, Retail, Consumer Products, Health care (Pharmaceutical) and Information Technology as a Techno Functional expert and currently working as a Senior Oracle Applications Developer for various assignments and performed Business Analysis, configuring, customizing and implementing Oracle Applications across various industries.
• Having seven full life cycle implementation, upgradation and support experience in Oracle Applications R12/11i and Fusion Cloud modules like Procurement (PO), Inventory (INV), Order Management (OM), Accounts Payables (AP), Core HR, Self Service (SSHR), Payroll, Advance Benefits (OAB), Compensation Workbench (CWB), Bill of Materials (BOM), Work in Process (WIP), Shipping (WSH) and Accounts Receivable (AR) Modules and having good knowledge on Oracle Trading Community Architecture (TCA).
• Strong experience of HCM Data Loader, File - Based Loader, File Encryption and Decryption.
• Managed and led multiple global Cloud implementation projects on Oracle Fusion HCM Cloud.
• Extensive experience in developing RICE components (Reports, Interfaces, API’s, Conversions & Extensions) in Oracle Applications E-Business suite 11i and R12.
• Extensive experience on Fusion Procure to Pay Implementation, Global Human Resources Implementation, Advanced Benefits and Compensation implementation.
• Worked on HCM Extracts & FBL Loads for Data Migration from Apps to Fusion.
• Extensively worked on OTBI and OBIEE Reports in Fusion Cloud using RTF, Sql and Subject areas.
• Expertise experience on Workflows & Fusion Form Personalization using Sand Box.
• Engaged with Benefits Administration, HR Processes and Workflows, Roles and Tasks, Reports and Interfaces
• Proficient in importing data from Legacy systems to Applications using Interfaces.
• Identify business requirements, translate to Oracle Cloud functionality, identify functional gaps and develop solutions for them. Configure the Oracle Cloud HCM applications and common cloud setups to meet the requirements.
• Configure, Design, Develop and Implement the HR systems.
• Responsible for ensure security and integrity of data within all HR systems.
• Set up Roles, Permissions at data and function level across all HR systems.
• Provide expertise and guidance to the HR staff on usage of HR software.
• Responsible for overall architecture of the HR systems (HCM, ATS, Performance Management, Compensation and Benefits etc.,)
• Responsible for ensuring integration across the HR and enterprise platforms.
• Set standards for configuration, design, development and identify business requirements within internal offices & align them to Oracle Fusion HCM.
• Extensive Experience on Designing Fast formula’s as per the client requirement.
• Expertise on Oracle Metalink functionality in resolving application problems

TECHNICAL SKILLS:

ERP: Oracle Fusion Cloud

Modules: HR, Payroll, Compensation Workbench, Advanced Benefits, SSHR

Application: Oracle Fusion Cloud

Reporting Tools: Discoverer, Report builder(6i/10g), XML Publisher, BI Publisher, OBIEE, Fusion HCM Extracts and Fusion OTBI Reports

Languages/Packages: SQL, PL/SQL, shell scripting and Java

Databases: SQL *Loader, SQL Developer and TOAD for Oracle 9i & 10g

Migration/Data Source: Kintana, Star Team and PVCS etc.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Technology Architect

Environment: Oracle Fusion Cloud

Responsibilities:

• Configure the Oracle Cloud HCM and Procurement solution.
• Developed Benefits file formats Pl/Sql interfaces for different vendors, Inbound/Outbound & BEE process interfaces such as Employee demographic info, Payroll deductions, Payroll info to/from third party systems, Time card Info etc...
• Written many formulas for Compensation and Benefits eligibility profiles, Coverage calculations, Post-Election rules, Payroll calculation formulas, etc..
• Worked on Fusion HR Form Personalization using Sand Box.
• Worked on Employee Profile, Cost Center Hierarchy, Organization Hierarchy, Supervisor Hierarchy, Hire Event and Pay Event
• Worked on Compensation profile outbound interfaces.
• Demonstrate the configurations through the development of prototype systems And assist the client in testing the solution.
• Assist the integration consulting team in helping to build, configure and test integrations between Procurement and third party/custom solutions
• Designed Fast Formula’s to provide solution for business requirements.
• Worked on Payroll integration, Benefits, Benefits 3rd party integration, Employee Self Service, Manager Self Service, Workflows and approvals, Reports
• Worked on Fusion HCM - Workforce Deployment, Benefits and Compensation Functional Setups, Identity Manager, BPM Worklist, etc.
• Created Workforce structures using data roles, person security profile and organization security profile.
• Developed OTBI reports using the existing subject areas and also used OBIEE to create custom subject areas for HR reporting.
• Provide Customer Training as required & Dealt with variety of client issues.
• Created Custom Roles and implemented Data Security as per the requirement.

Confidential, Orange County, CA

Fusion Cloud Architect

Environment: Oracle Apps Fusion Cloud.

Responsibilities:

• Coordination with Functional Team and Client Key users for Gathering requirements, analyzing, solution design & deliverables.
• Worked on Setup configuration for Fusion Procurement and Financial modules which involves
• Worked on go-live activities/post-production troubleshooting. AOL, OM & SYS Admin Tasks.
• Worked on Development of OBIEE and OTBI reports id different methodologies like using Subject Area, getting Data by writing SQL queries, Using RTF template etc.,
• Expertise knowledge on writing Fast Formulas based on client business.
• Developed various shell scripts to meet the ftp/sftp requirements for various banks (private servers).
• Worked on Setup configuration for Fusion Procurement and Financial modules which involves Procurement Approval Hierarchy, AP Invoice Rule configuration, Purchasing Catalog setups, Manage Mapping Sets, GL Cross Validation Rules, Procurement Change Order Rules, AP Period closing etc.,
• Optimization and simplification of the existing custom objects.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Provide Customer Training as required & Dealt with variety of client issues related to system design as well as to business.
• Designed and developed interfaces from OTL to Payroll and other third party systems.
• Development of new enhancements as and when need arises from the business and proficient in Post-production activities.
• Created custom time entry rules to validate the time card, Approvals to send the time card for approval and various notifications to notify the managers and employees about the timesheet.
• Build and maintain repository for deliverables & business development documents
• Responsible for Analyze, Design, Develop, Unit test the components.
• Provide Customer Training as required & Dealt with variety of client issues related to system design as well as to business.
• Assisted end users with documenting new business procedures and test scripts for CRP & UAT
• Worked on Conversions for Jobs, Extra Information Types, Personal Payment Methods and Elements

Confidential, BREA, CA

Senior Developer Oracle Applications

Environment: Oracle Apps release R12, Developer 10g and Oracle 10g.

Responsibilities:

• Senior developer for Manufacturing and SCM track enhancements, developments and issues mainly dealing with modules Core HR, Compensation and Benefits, Payroll, OM, INV, PO, AP, BOM, WIP, Planning and Quality.
• Analyze, Design, Develop, tested several migration projects like Carls Brea Phase I, Indy Phase I, Prague OU, Indy Phase II which involves several components like Conversions, Interfaces, XM/BI Reports, Forms, Workflow and UNIX Shell Scripting.
• Handled the conversion of Optio reports to XML reports includes, Design, develop, testing and delivery of the objects.
• Coordination with Functional Team and Client Key users for gathering requirements, analyzing, solution design & deliverables.
• Worked on development and modification of XML/BI Publisher, Optio Reports, Form Personalization, Interfaces, Conversions, Unix Shell Scripts, Intrusive Customization of Standard PL /SQL Programs, AOL, OM & SYS Admin Tasks.
• Responsible for Analyze, Design, Develop, Unit test the components.
• Did many conversions on PO, OM, Customers, and Vendors which can re-usable across all the projects for data migration.
• Used TKPROF and Explain Plan utilities to analyze poorly performing PL/SQL packages. Modified several program structures to introduce Performance Tuning techniques like Global Temporary Tables, Bulk Processing and Parallel Execution Methods to improve the performance by 90%.
• Developed Outbound Interface in several modules using UTL FILE utility to generate extract and FTP file to different server locations.
• Optimization and simplification of the existing custom objects.
• Provide Customer Training as required & Dealt with variety of client issues related to system design as well as to business.
• Development of new enhancements as and when need arises from the business and proficient in Post-production activities.
• Build and maintain repository for deliverables & business development documents.
• Actively involved in day-to-day support activities for Oracle EBS 11i Finance Multi-Org stream by troubleshooting, providing solutions and communicating with the users through Support tickets.
• Analyze, root cause analysis, Applying fixes, providing solutions for Prod Issues.
• Extensive Experience in OM API's like order creation, order updating and pricing.

Confidential

Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 10g.

Responsibilities:

• Collecting Confidential Business requirement and Leveraging with Oracle Applications
• Worked on different modules like PO, OM, Inv, BOM, AP, AR, Quality & Planning.
• Worked on development and modification of XML/BI Publisher, Optio Reports, Form Personalization, Interfaces, Conversions, Unix Shell Scripts, Intrusive Customization of Standard PL /SQL Programs, AOL, OM & SYS Admin Tasks.
• Worked on Enhancements and bug fixes
• Developed Technical Design Documents as per the Client coding standards & Project Quality plan.
• Developed the code and Completed Unit testing for Interfaces and Reports as per client requirements.
• Created Procedures, Functions, Triggers, Values Sets, Lookups, Descriptive Flex Fields (DFF) and other AOL/database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables. Request Sets.
• Writing Unit Test cases and testing after completion of the Object.
• Supported all go-live activities and post-production troubleshooting.
• Preparation of MD070 Technical specification documents based on Functional Specifications.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Development of new enhancements as and when need arises from the business and proficient in Post-production activities.
• Build and maintain repository for deliverables & business development documents.
• Actively involved in day-to-day support activities for Oracle EBS 11i Finance Multi-Org stream by troubleshooting, providing solutions and communicating with the users through Support tickets.
• Analyze, root cause analysis, Applying fixes, providing solutions for Prod Issues.
• Extensive Experience in OM API's like order creation, order updating and pricing.
• Optimization and simplification of the existing custom objects.
• Responsible for Analyze, Design, Develop, Unit test the components.

Confidential

Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 9i.

Responsibilities:

• Worked on different modules like PO, AP, AR, OM and INV.
• Worked on Supplier Conversion
• Worked on a custom interface on the Tax information of the sample products which don’t have any revenue.
• Involved in the design of Technical Documents (MD64’s and MD 70’s) preparation.
• Worked on the development and testing of Forms, Conversions, Interfaces and Shell Scripts in the stipulated time frame with a quality output.
• Developed the Reports like PO Print Report and Sales Order Acknowledgement report using XML Publisher.
• Prepared the Unit Test Scripts Document to mention Test Cases and Scenarios for the developed components.
• Developed Barcode Reports.
• Reviewed the Technical Design Documents and Codes prepared by the project team members and taken Confidential process trainings to the team members which are newly joined into the project.
• Initiative in revisiting and optimizing the quality of the components developed.
• Developed some other conversions and interfaces other than the specified and fixed issues at the time of UTA phase.
• Provided post go-live support for developed components as well as for other components.
• Created Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables.
• Writing Unit Test cases and testing after completion of the Object.
• Involved in end to end testing from Quote Creation to Order.
• Customizations, personalization and Extensions on Quoting web pages using Oracle Application Framework as per client requirement.
• Collecting Confidential Business requirement and Leveraging with Oracle Applications.

Confidential

Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 9i.

Responsibilities:

• Involved in designing and developing Technical Documents for Interfaces, Forms and Reports.
• Developed the code and Completed Unit testing for Interfaces, Forms and Reports as per client requirements.
• Worked on Modification of Forms, Reports, PL/SQL Programs and Shell Scripts.
• Modifying and testing of the RICE components in the stipulated time frame with a quality output.
• Worked on Enhancements and bug fixes for all Data Controller components.
• Used PL/SQL for validating the data from legacy system to interface tables. Run journal import to load the data into Oracle application tables.
• Frequently interacted with Client for gathering the requirements and arranged client meetings to accomplish the task given.
• Prepared the Documents as per the Client coding standards, Project Quality plan and followed CMMi process.
• Doing Custom Developments and support scripts on business requirements.
• Developed Extensions to custom business flow from Order management, install base to service contracts for raising credit memos and invoices in AR.
• Developed and Customized the Discoverer by using Discoverer tool as per the client requirement.
• Developed and customized the Forms and worked with the Custom.pll for doing modifications to the Standard Forms.
• Coordination with the Associate Consultants for resolving the issues raised by client as per their business requirements.
• Successfully completed the build and Unit testing from the Technical design document prepared by the developers as per client standards
• Involved on designing and developing Technical Documents.
• Reports development of Account Payables, Account Receivables modules based on client requirements.

Confidential

Associate Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 6i.

Responsibilities:

• Developed and Customized the Interfaces like Price List, Item Import, Order Import and so on as per the client requirement.
• Developed and Customized the Reports in Oracle Applications using Reports 6i.
• Developed and Customized the Discoverer by using Discoverer tool as per the client requirement.
• Developed and customized the Forms and worked with the Custom.pll for doing modifications to the Standard Forms.
• Coordination with the Associate Consultants for resolving the issues raised by client as per their business requirements.
• Reviewed the Technical Design Documents and Codes prepared by the project team members and taken Confidential process trainings to the team members which are newly joined into the project.
• Initiative in revisiting and optimizing the quality of the components developed.
• Developed some other conversions and interfaces other than the specified and fixed issues at the time of UTA phase.
• Provided post go-live support for developed components as well as for other components.
• Created Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Defining Concurrent Programs, Executables.
• Writing Unit Test cases and testing after completion of the Object.
• Involved in end to end testing from Quote Creation to Order.
• Customizations, personalization and Extensions on Quoting web pages using Oracle Application Framework as per client requirement.
• Collecting Confidential Business requirement and Leveraging with Oracle Applications.

Confidential

Associate Consultant

Environment: Oracle Apps release 11i, Developer 6i and Oracle 6i.

Responsibilities:

• Involved on designing and developing Technical Documents.
• Reports development of Account Payables, Account Receivables modules based on client requirements.
• Worked on AP and AR Modules.
• Delivered all the Reports within the expected time lines.
• Successfully completed the build and Unit testing from the Technical design document prepared by the developers as per client standards.
• Developed and Customized the Interfaces like Price List, Item Import, Order Import and so on as per the client requirement.
• Developed and Customized the Reports in Oracle Applications using Reports 6i.
• Developed and Customized the Discoverer by using Discoverer tool as per the client requirement.
• Developed and customized the Forms and worked with the Custom.pll for doing modifications to the Standard Forms.
• Coordination with the Associate Consultants for resolving the issues raised by client as per their business requirements.
• Reviewed the Technical Design Documents and Codes prepared by the project team members and taken Confidential process trainings to the team members which are newly joined into the project.
• Initiative in revisiting and optimizing the quality of the components developed.
• Developed some other conversions and interfaces other than the specified and fixed issues at the time of UTA phase.