SUMMARY:

• Over 9+ years of experience in Oracle applications both in 11i and R12.
• Worked extensively business and worked in small to big teams for fortune 500 clients.
• Very strong in Oracle Financials, SCM, HRMS modules.
• Worked in all phases of Oracle EBS rollouts and well versed in AIM methodology and SDLC.
• Having Good Experience on RICE/ CEMLI components.
• Expertise in reporting using various oracle reporting tools includes Oracle Reports, XML publisher, Oracle Discoverer (Desktop, Administrator, Plus, Viewer), Crystal Reports, knowledge in tableau.
• Conversant in Development methodologies including Waterfall, Agile and Strong knowledge and understanding of ITIL.
• Developed financial Discoverer rep orts with departmental level security for P&L (profit and Loss). These reports joined accounting period GL (General Ledger) balances to GL JE (Journal Entry) batches, headers, lines and AP (Accounts Payable) and PO (Purchasing) information if applicable.
• Developed Expenditure Discoverer reports based on PA (Oracle Projects - Project Accounting) information.
• Good understanding of new SLA process by R12
• Experiencedin Order-to-Cash (O2C) and Procure-to-Pay (P2P) implementations.
• Expert in customizations and experienced in OAF customizations. Expert in developing medium to complex workflow customizations.

TECHNICAL SKILLS:

ERP Tool: Oracle Apps 11i, R12

Database: Oracle9i, Oracle 10g

Languages: C, C++, SQL, PL/SQL, Shell Scripting,HTML,XML,CSS

Tools: TOAD, Sql Developer SQL *Plus, SQL *Loader, SQL Server, JIRA, Rally, Kintana, PVCS, Artifactory, SharePoint Administrator 2007,Remedy, SVN

GUIs: Developer 2000 (Forms 6i and Reports 6i), Reports 10g, Oracle Discoverer 4i, XML Publisher, OAF, Crystal Reports XI

Financials: Accounts Payables (AP), Accounts Receivables (AR), General Ledger(GL),

SCM: Order Management (OM), Inventory, Purchasing(PO)

CRM: Install Base (IB), TCA.

HRMS: Oracle Human Resource(HR),Oracle Time and Labor (OTL), Payroll, Oracle Advance Benefits (OAB)

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Oracle Techno Functional Consultant

Responsibilities:

• Worked on Core HR, Absence Management, Talent Management, Payroll modules.
• Configured the Absence Management module to enable the Vacation and Sick plans. 
•  Written Accrual fast formulas to support the vacation and sick absence plans. 
•  Written Accrual fast formulas to support the vacation and sick absence plans. 
• 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 Input Values load. 
• Element Eligibility Profiles load using Payroll Batch loader.
• Developed HCM Extracts to to extract the data from  Oracle  Cloud systems in HR Achieve 
• Expert in integration of OM module with third party tools like custom Configuration Tool and Custom Pricing engine.
• Phones and Job DFF information load using FBL. 
• Tested Core HR, Interfaces and Reports for Rel.10 Upgrade. 
• Implemented Workforce Compensation in  Oracle  Cloud for a global company 
• Conducted extensive testing cycles and solution design workshops 
• Designed custom reporting and interfaces to meet client and audit requirements 
• Supported client in  Oracle  Cloud UI personalization's and customizations for end users 
• Configured custom security and data roles for different employee populations 
• Part of business process workshops/CRPs and requirements gathering sessions and support clients in defining relevant processes. 
• Driving and documenting business requirements and procedures, obtain sign off to ensure Client alignment of proposed solution. 
• Configured HR and Absence management modules. 
• Coordinating with  Oracle  for SRs, new product releases, upgrades/patches/fixes. 
• Provided business consulting support and facilitates discovery workshops. 
• Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies. 
• Manage Enterprise HCM Information. 
• 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. 
• Fusion with Workforce Deployment (Global HR), Workforce Development (Talent Management). 
• Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities. 
• Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits. 
• Coordinate with QA team and ensure the product is bug free and ensure all test cases and scenarios are covered. 
• Defined and designed Order to Cash inter-company business process.
• Responsible for overseeing the day-to-day operations of the team, distributing the workload amongst the team and making sure motivation & performance are maintained. Lead a Team of 10 People.

Environment: Oracle Applications R12, PL/SQL,TOAD, XML Publisher, CCW, Egenie, ConnectDots, MDM, Rally, Jive, PVCS, SVN, Arti factory, Kintana, AppsDB, Quality Center.

Confidential, Atlanta GA

Technical Consultant

Responsibilities:

• Understand client business requirements and Assist client in providing solutions.
• Worked on development and upgradation of XML/BI Publisher, Form Personalization, Interfaces, and Conversions in Order Management (OM), O2C,Oracle Process manufacturing (OPM), Purchasing (PO), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), OKC/OKS.
• Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash (O2C) and Procure to Pay (P2P) cycles
• Worked on UNIX Shell Scripts, Workflow and Intrusive Customization of Standard PL /SQL Programs.
• Development and Personalization of Purchasing Forms using Oracle Application Framework (OAF)
• Extensively worked on Performance Tuning.
• Developed Automatic Customer Credit Hold Inbound Conversion in (Accounts Receivables )AR module to upload the customer data from flat file to Oracle apps base tables.
• Developed Customer Hold Inbound Conversion in AR module to upload the Customer data from flat file to Oracle apps base tables.
• Developed Inbound Conversion in AP module to upload the Banks data from flat file to Oracle apps base tables
• Worked on the Eis reporting tool in the support and maintenance of the reporting cases.
• Participated in detailed Payroll requirement information gathering needed for Reports Customization
• Developed Custom OTL and integrated with Oracle Projects
• Developed Fast formulas for OTL and absence management modules. Developed various inbound and outbound interface in HCM modules
• Assign AME Roles and Responsibilities
• Training new team members.
• Lead a Team of 6 People along with individual contribution on development.
• Preparation of MD070s, Design Level Documents, Test Plans.
• Reviewed and Modified Functional Design Documents (MD-050)
• Provide Customer Training as required & Dealt with variety of client issues related to system design as well as to business.

Environment: Oracle Applications R 12, TOAD, PL/SQL, Eis Reporting Tool, Forms & Reports 10g, OAF.

Confidential, NJ

System Analyst

Responsibilities:

• Coordination with Functional Team and Client Key users for Gathering requirements, analyzing, solution design & deliverables.
• Development and Personalization of Purchasing Forms using Oracle Application Framework (OAF)
• Worked on development and upgradation of XML/BI Publisher, Form Personalization, Interfaces, and Conversions in Order Management (OM), Oracle Process manufacturing (OPM), Purchasing (PO), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Service Contracts
• Planning and Managing Service life cycle that mainly includes 1) Creating Contracts 2) Approving Contracts 3) Extending and Renewing Contracts 4) Terminating Contracts
• Worked as a system business analyst for the final 6 months of a project to expand the implementation of Service Contracts (SC/OKS/OKC) and Install Base (IB/CSI). Involved in testing (both standard functionality and custom functionality), working with Oracle on bugs, developing new business processes, writing training documentation, and configuring the application during go-live.
• Worked on UNIX Shell Scripts, OAF, and Workflow Customizations.
• Worked on go-live post-production troubleshooting and enhancement activities.
• Preparation of Technical and Functional documents based on User Specifications.
• Worked on the Change Requests (CRs) given by business.
• Developed an interface program to load data from custom tables to interface tables and then created journals into Oracle General Ledger as per business requirements.
• Prepared Test scripts for specific flows in OM (Sales Order Creation) and PO (Purchase Order Creation).
• Provided Functional Support for developing New Forms
• Preparing Functional Design Documents (MD-050) for the New Forms
• Reviewed and Modified Functional Design Documents (MD-050)
• Worked on Control Account restriction forms Personalization
• Worked extensively on AOL Objects
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Designed application framework and developed Oracle APEX Application.
• Used Oracle APEX 4.0 for designing application structure
• Worked with Oracle APEX on APEX.ITEM CHECKBOX, APEX.ITEM RADIOGROUP.
• Worked with Oracle APEX EMAIL, interactive and classic reports.
• Developed various shell, sql and pl/sql scripts for verification.
• Designed and developed various PL/SQL packages, stored procedures, functions, cursors and triggers and shell scripts to meet business requirements.
• Creation of JIRA for any bug or changes in the existing code or data fixes.
• Creation of Technical Documentation and User Test Cases.

Environment: Oracle Applications 11i, TOAD, PL/SQL,Oracle Forms & Reports 6i, XML Publisher

Confidential, Philadelphia, PA

Software Engineer

Responsibilities:

• Worked in Kenexa In-house projects in Oracle Applications worked on AR/AP/GL/PO,OTL modules for all day to day help with end users on technical side
• Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Procure to Pay (P2P) cycles
• 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.
• Log, monitor, and follow up on service requests (SRs) online- Oracle MetaLink
• 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.
• Worked at Onsite location Wayne to understand the business needs and functionalities of the project
• Developed and customized reports in Oracle Reports 6i, Oracle DiscovererReports for OracleTimesheets(OTL), XML Publisher Reports
• Developed Fast formulas for OTL and absence management modules. Developed various inbound and outbound interface in HCM modules
• Developed AP invoice Interface.
• Developed Account Receivable Auto Invoice interface.
• Involved in Quality Audits.
• Performed logical backups using Oracle Import / Export
• Crystal Reports Developer experience: Converted project specifications and statements of problems in order to create and modify programs. Development experience with customized in-house applications provided applications.
• The report had security based on a registered SharePoint that returned the user’s current application responsibility.
• SharePoint Administrator: Responsible for administering & managing the Share Point farms and databases, Ensure the integrity and security of Share Point data in accordance with business needs and industry best-practices regarding privacy, security, and regulatory compliance

Environment: Oracle Applications 11i, TOAD, PL/SQL, Oracle Reports, Conversions, Interfaces, Discover Reports, Crystal Reports, SharePoint Administrator

Confidential, Herndon, VA

Technical Consultant

Responsibilities:

• Development & customization of Reports, conduct Technical analysis for developing new reports.
• Preparing Technical Documents and Preparing Unit Test Scripts.
• Developing interfaces in purchasing and payables modules as per business requirement.
• Responsible for preparing procedures, functions, packages as per requirements.
• Developed PO requisition interface.
• 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.
• Developed Extensions to custom business flow from Order management, install base to service contracts for raising credit memos and invoices in AR.
• Part of production as well as enhancement team on support
• Mapping functional specifications to technical for customizing existing reports
• Other issues related to reports in Production.
• Developed OM interface

Environment: Oracle Applications 11i, TOAD, PL/SQL, Oracle Reports, Conversions, Interfaces