OBJECTIVE

• To work smart in a technically competitive and motivated firm involving technical / functional development of ERP projects where I can be an asset to the company’s growth by exercising my skills, which includes Research, Design, Development and Support where I can exercise my existing skill set, gather wide range of new skills.
• To put my abilities to the zenith towards achieving the organization’s values and goals and to see myself as a mature and thoroughbred professional in the industry.

SUMMARY

• Having 11 plus Years of rich IT experience in ERP implementation and Enterprise Applications Practice with proven experience in Developing, Customizing, Supporting/Maintenance and Migrating / Up gradation of Oracle Applications E - business Suite R12 & R11i.
• These includes Analysis, Customizations, Design, Development and Implementation for applications based on Relational DBMS and in the field of Oracle e-business Suite and customer oriented, multitask professional with excellent analytical and logical skills possesses.
• Excellent experience in development & maintenance of Oracle Applications R12& R11i
• Expert in developing RICEW or CEMLI Components in the domain of Oracle E-Business Suite
• Highly conversant with various modules of Oracle Applications Release R12 & R11i (SCM, MFG, Distribution, FIN, CRM & HRMS)
• Areas of expertise technical developments and having functional knowledge in Multi-org, MOAC, SLA, MRC, INV, PO, AP, OM, Shipping, Advance Pricing, AR, GL, FA, CM, ZX, WIP, BOM, WMS, Trading Community Architecture(TCA), Installable(CSI), Service Contracts(OKS)& Service Requests(CSF&CSD) & HRM modules
• Having 5 full life cycle implementations, 1 Migration and Sustaining Support experience with exposure to viz. AIM 3.0, Agile and OUM methodologies
• Excellent work experience on MD and CV documents for various components, good experience in development of functional/technical design documents
• Rich work experience with Procure to Pay (P2P), Quote to Order (Q2O), Order to Cash(O2C) & Plan to Manufacturing (P2M) processes
• Having excellent work experience with Oracle Business Intelligence Standard Edition Oracle Discoverer 10g and having knowledge on generating reports with XML / BI Publisher
• Good at development of interface and conversion programs for EDI using ODI, PLSQL and Oracle Standard APIs
• Having Knowledge on Data Warehouse Concepts (Informatica, ODI, OWB, EDQ & Reporting tools like OBIEE)
• Experience in importing data from legacy systems to Oracle Applications using SQL LOADER, UTL FILE, ODI, SOA, Oracle packaged APIs & Oracle Web ADI etc.,
• Expertise in Requirements Analysis, System Design, Data Flow Designs, Support, Development, Testing, Documentation and Design reviews
• Strong experience in Data Engineering on the Oracle Database Platform to support the development, customization and implementation
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120)
• Excellent experience in writing technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs)
• Rich experience in development and customization of Oracle Work Flow (WF), Approval Management Engine(AME), Oracle Application Framework (OAF), Application Development Framework (ADF), Oracle APEX, Oracle Alerts & Oracle Business Events according to business needs
• Having knowledge on development of Business Process Engineering Language (BPEL) using Service Oriented Architecture (SOA)/FMW Concepts
• Having good experience in development process which includes Business Intelligence (BI), Enterprise Performance Management (EPM), WebCenter, Service-Oriented Architecture (SOA), Application Integration Architecture (AIA), Business Process Management (BPM), Enterprise Integration and Custom Software.
• Strong in UNIX shell scripting and performance tuning of several objects using hints and several other processes, analyzing TK-Prof files and Explain Plan
• Having good expertise in Preparing Technical Documents, Unit Test Scripts (UTS), Code Review Checklist (CRC), Test Plan and Test Results documents based on the user/customer requirements
• Having Experience on Oracle Fusion Middleware 11g with ADF and JDeveloper and Oracle Cloud Fusion
• Rich Experience on documentation adhere to the JSOX, SOP & participated in Class Room Prototype (CRP)
• Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the issues
• Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming, and performs testing and debugging of applications
• Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management, team building and adopting new technologies. Very flexible and perform tasks are ad-hoc basis
• Team Player with Excellent Technical, Communication, Interpersonal skills & Leadership abilities

TECHNICAL SKILLS

OS/Environment: Ms-Dos, Windows, Linux and UNIX.

RDBMS (Database): Oracle 9i, 10g, 11g & 12c.

Oracle E-Biz Suite (EBS): Oracle Applications R12 & R11i.

Manufacturing, DistributionSupply Chain Management (SCM): Inventory (INV), Work In Progress (WIP), Bills of Materials (BOM), Purchasing (PO), Warehouse Management (WMS), Order Quote, Order Management (OM/OE/ONT), iStore, Shipping Execution (WSH), Project Accounting (PA), Advanced Pricing, iProcurement, iSuppliers, Human Resource (HRMS), Sys. Admin & Appl. Dev (AOL).

Financials: Accounts Payables (AP), Accounts Receivables (AR), iReceivables, Cash Management (CM), Fixed Assets (FA), General Ledger (GL) & Oracle E-Business Tax (ZX).

CRM Modules: Installbase (CSI), Service Contracts/Contracts Core (OKS/OKC), Service Requests (Field Service (CSF/CFS), Depot Repair (CSD) and Tele Services)/Customer Support/Customer Care (CS/CSS/CSC), Billing, CRM Foundation (JTF), Trading Community Architecture (TCA/HZ).

Languages, Scripts & Frameworks: SQL, PL/SQL, SQL*LOADER, Data Loader, JAVA, OAF, ADF, SOA, HTML, DHTML, XML, XSD, XSLT, XPath, WSDL, ODI, Oracle APEX, C, C++, Shell, Java and SQL Server.

Middleware: Oracle Fusion 11g (ADF & SOA (BPEL,WSM & ESB))

Front-end Tools (GUI): Forms 6i, 9i,10g & 10gR2, Reports 6i, 9i &10g, Jdeveloper10g, Work Flow Builder.

Business Intelligence (BI): Oracle Discoverer 10g, XML Publisher and OBIEE.

Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*PLUS, Winscp, Putty, FTP, WSFTP, JIRA, Lotus Notes, STATS, HP PPM, FileZilla, MS-Office, Open Office, SQL Mgmt Studio & RStudio. Version Controls: SVN, GIT, SCM, Vault, SCCS & PVCS.

Key Competencies& Skills: Client Relations, Business Analysis, Functional & Technical Analysis, Product Mapping & Consultancy, Data Migration Mapping & Testing(Plans, Cases, UAT & Testing).

PROFESSIONAL EXPERIENCE

Confidential, MI

Senior Oracle EBS Consultant

Responsibilities:

• My role is to adapts existing methods and procedures to create possible alternative solutions to moderately complex problems
• Worked for multiple region deployments & support in Europe, China, APAC and Latin America(GIS)
• Involved in design analysis and process changes for interfaces between EBS to third party systems
• Gathering and analyzing user requirements and interacting with business users to resolve issues
• Developed and updated Standard Operating Procedures manuals and helps to management that on different projects and applications.
• Interact with technical teams & business analysts to fulfil the requirement & help to signoff respective documents
• Participate in Class Room Prototype (CRP) meetings for gap analysis
• Created functional design documents (MD.050) for customizing to address business requirements and to address the labeling requirements and prepared respective MD070
• Leading the team who are all in different places globally and giving solutions to resolve the issues.
• Day to day status track of issues & Issue Tracking and Resolution and Involved in the post go-live support
• Help users to establish month-end procedures for closing and posting to GL
• Designed Technical Design for Oracle EBS inbound interfaces, extensions & reports
• Involved in Oracle EBS Upgradation from 12.1.3 to 12.2.6
• Worked on ODI, UTL PACKAGE, SQL*LOADER & SOA for the interfaces and conversions from legacy systems
• Working on Interface validations for third party system Hybris & AS400 systems for Customers (TCA), Orders(OM) & Receivables (AR)
• Worked on Oracle CRM Modules Installed Base, Service Contracts, Service, CRM Foundation &Product Contracts (OKC) with respect to conversions and interfaces using APIs
• Working as OM& AR Modules Expert Resource at Client site to Review and Define Functional Setups, Development and Enhancements various customizations of Oracle Receivables Module.
• Created New DFF's and Lookups in Oracle Receivables Module.
• Ensuring full traceability of deliverables throughout the project lifecycle using various tracking tools and Oracle AIM documentation
• Responsible for Interfacing systems and Master Data Management (MDM) to ensure appropriate synchronization and provision of data
• Worked in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 11g.
• Involved in JSP & JAVA object oriented related applications, customization and creation of JSP files & java classes.
• Involved in Quote to Order(Q2O) and Order to Cash (O2C) Validations & developed bank related reports to avoid duplicate bank records in the system
• Developed Intergraded Test Scripts for testing Oracle Order Management and Oracle Contracts: Orders, Contacts, Quotes, EDI and Return Orders
• Developed custom OAF search page for in customers that shows unmasked Bank Account details. Only handful of users were given access to unmasked banking details
• Involved Data Migration and Cutover tasks
• Involved in real time actions of Orders & Customers integration using SOA and Webmethods.
• Supporting Oracle Cloud Fusion for Supply Chain and Financials.
• Assisted with Service Contracts and other CRM solutions with support, interfaces, upgrades and implementations
• Worked with Application Developer on data interfaces for Creating Service Requests, Install base and Contract/Warranty information.
• Involved in conversion validations (Items, Suppliers, Customers, Orders, IB & Service Contracts)
• Developed Custom Reports such asService Contractsby Status Report,Service ContractsDetail Report,Service ContractForecast Management Report
• Assisted in period closing and also daily production support by resolving system & user issues. Following up with Oracle Support on service requests.
• Reviewed and submitted performance test results & Production Support to users globally

Confidential, Portland, OR

Senior Oracle EBS Consultant.

Responsibilities:

• Working as Senior Oracle EBS Applications Consultant
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow
• Daily support to users based on service requests and tickets
• Performed GAP analysis to ensure that the requirements are captured properly
• Documentation for Unit Test Scripts, Test Plans, and Test Results
• Analyzed business requirements, designed, implemented business solution design and development.
• Prepared the Functional (MD 050), Technical (MD 070), Installation & Unit Test Case documents.
• Closely worked with users to understand business needs and objectives
• Post GO LIVE & Month End Support
• Invokedstandard API'swithin custom packages for creating and updating Customer, Sites and Contacts
• Imported new, changed and completed sales orders from legacy system to oracle usingorder import (order management open interface)
• Development of customer interfaces using Oracle standard TCA APIs including DQM rules
• Developed programs for GL Detail Journal Entries as per user requests
• Developed programs to extract Suppliers & Customers List Reports based on recent activity details
• Developed program for JE Tracker Report
• Responsible for validating data in temp table and importing data to GL interface table and runningGL BalancesImport
• ImplementedAP Invoice importthroughPayables Open Interface Import Program.
• Developed anoutbound interfacefor open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc.,
• SubmittedService Request with OracleSupport in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support
• Developed Dash Boards, Pages for custom interfaces using Oracle APEX
• Developed Reports for Service Requests Summary and Details in Date Ranges
• Written anAPIfor ConvertingResources/SalesReps (OM)activities from Legacy System into R12 Production
• Developed program to get Supplier and Customer activity for 12 months
• Customized iStore reports as per user requirements
• Developed program to load external data from legacy system using SQL*Loader and Oracle APEX into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE Interface Tables
• Customized multiple reports and forms in GL, AP, PO, AR and OM modules according to the requirements.
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports inAccount Receivables (AR)
• Used Custom PL/SQL API’S for converting Customers using TCA, Open AR Invoices,Open Purchase Ordersfromlegacy system to Oracle

Confidential

Senior Oracle Applications Techno Functional Consultant.

Responsibilities:

• Senior Oracle Application consultant and Hands-on Team Lead at offsite
• Active involvement in data gathering and processes study with functional team
• Gathering and analyzing functional requirements and Interacting with team and business users to clear the Requirements from different OpCos (Operating Countries)
• Post go live support to different countries (CN, HK, KR, MY, PH, SG, TH, TW, VN, AU and NZ)
• Support to FX-AU, FX-NZ implémentations
• Identifying functional and technical gaps and adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion
• Involve to providing functional specifications for customizations and developments
• Responsible for the overall design and implementation of Oracle ERP modules at technical end
• Involved to support workflows and frame work
• Documentation for Unit Test Scripts, Test Plans, and Test Results
• Involved to support business users in live
• Designing interfaces and integrations between modules in Oracle EBS
• Code Reviews for Vendor and Vendor Management
• Designed and developed reports using combination of Report 10g and XML publisher for modules like Purchasing and Order management
• Documented the training material, requirement gathering(RD20),setups (BR100) AS-IS, TO-BE (BP80)documents
• Enhancement on Forms, Performance tuning on Forms, Reports and PL/SQL
• Implemented several custom logics for Form Personalization using ZOOM Functionality
• Developed the programs for SOA to get the readings from Machines
• Worked on Unit/Functional Test ofCRM like Install Base, Service Contracts, Field Service, while developing the customized pages
• Technical analysis of existing RICEW components of existing components functionality
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher
• Customization and Development of forms, workflows and worked on Forms Personalization
• Worked on Oracle Reports & Discoverer reports to support based on user requirement
• Development of custom interfaces using Oracle standard TCA APIs including DQM rules
• Fully involved in CRM conversions for Migration & developed custom packages for migration
• Developed PL/SQL Procedures to convert data in custom tables to service contracts using APIs
• Developed conversion programs for Employee, Supplier, Items Masters, Service Contracts and Service Requests
• Developed the Service and Contracts (SC) parts of the Population Report, monitored the report performance and handled data issues like missing contracts, invalid contract end date, null territory id
• Design and Development of Contract Inbound Interface for Oracle Service Contracts (SC) & Oracle Service Requests(Field Service & Depot Repair)
• Procure to Pay (P2P) and Order to Cash (O2C) Validations
• Experience in customizing oracle workflows such as the PO approval process, Order/Line Flow to send user notifications based on the business requirement
• Developed program to import Orders and Customers to Oracle through Oracle API Order & Customer Import
• Customized the Invoice Aging Report to display only not paid Invoices with invoice status should be approved
• Customized Invoice History Report by adding few more details related to Bank details
• Extensively used TCA (Trading Community Architecture) to create customers in Oracle Receivables
• Involved in Journal Import with validations
• Design, debug, code and maintain Oracle APEX application
• Develop Oracle Application Express solutions to enhance the usability and adoption of the Analytics and Reporting Central application
• Customization ofOAF pages, extensions, personalization and creation of new OAF pages
• Design & developed UI components using ADF Rich Faces and worked with ADF View Criteria’s, LOV’s & Testing
• Worked on GL interfaces for balances Conversion, SQL, PL/SQL, stored procedures and packages
• Creating and Registration of Procedures, Concurrent programs and Reports through AOL
• Designed and implemented custom Summary Billing Utility in AR with integration to TCA and Receivables
• Designed and customized the following reports using Oracle Reports Builder 10g in OM and Service Contracts:

Confidential

Oracle Applications Techno Functional Consultant

Responsibilities:

• Application consultant and Hands-on Team Lead
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow
• Development of technical design and installation documents
• Documentation for Unit Test Scripts, Test Plans, and Test Results
• Coordinated with key users and other key staff to resolve issues
• Helped users to establish month-end procedures for closing
• Involved fully on migration and production support
• Involved in the post go-live support
• Designing interfaces and integrations between modules in Oracle EBS
• Worked on Custom API’s in PL/SQL (Business Logic)
• Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL FILE package
• Developed a program to load external data from legacy system into PO HEADERS INTERFACE and PO LINES INTERFACE
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system
• Developed a program to inactivate the vendors
• Supported AP Supplier Conversions (Vendors, Vendor Sites and Vendor Contacts) and Invoice Conversions using AP Interface Tables, PL/SQL packages, API’s
• Technical analysis of existing RICE components of existing components functionality
• Customization and Development of forms and workflows and worked on Forms Personalization
• Worked on Oracle Reports to support based on user requirement
• Development of custom interfaces using Oracle standard TCA APIs including DQM rules
• Fully involved in developed custom programs to support to user requirement in both CRM and SCM
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs
• Procure to Pay (P2P), Quote to Order(Q2O) and Order to Cash (O2C) Validations and Form Personalization
• Developed various Custom reports, Customized existing reports (PO Purchase Order, Releases Detail & Purchase Requisition Status Report) according to the functional specifications using Reports 6i & XML publisher
• Conversion and reconciliation of Legacy AP Invoices and Payments into Oracle Applications
• Designed and developed Payables interface import program and interface tables to load invoices from the legacy systems into the oracle payables base tables
• Scheduled various concurrent programs and reports to run on a specified time daily without interfacing other standard programs using System Admin Responsibilities
• Creating and Registration of Procedures, Concurrent programs and Reports through AOL
• Support to modify Work Flows and Oracle Application Framework (OAF) based on business requirements

Confidential, Sterling, VA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked as Techno Functional Consultant
• Gathering and analyzing user requirements and interacting with onsite team and business users
• Day to day status track of issue logs
• Involved in the project meetings to define/direct project goals and objectives
• Architecting and developing customer specific solutions
• Design, Code, Test and code review Preparation of test scenarios/cases for all technical components bases on functional designs
• Quality Control and Quality Assurance
• Involved in the post go-live support
• Developing PL/SQL code to obtain the required functionality
• Worked on Custom API’s in PL/SQL (Business Logic)
• Involved in setup and implementation of Service Contracts depending on functional setup
• Customized Item Instance Query Report in Install Base IB using Template.fmb
• Involved in Field Service Setups for CRM Foundation, Install Base IB, and Service Contracts SC
• Worked on enhancements of Customer Facing Document Reports in Quoting and Service Contracts SC
• Customized and developed the forms and reports based on requirements
• Developed custom programs to interface the data into service contracts tables using Standard APIs
• Developed ADF Data Controls from Web Services & User Interface components using ADF Rich Faces
• Creating and Registration of concurrent programs, forms and reports through AOL
• Responsible for new development and change requests
• Customization and Development of forms and workflows