PROFESSIONAL SUMMARY:

• 15 years of IT experience in System Analysis, Design, Development, Conversion, Production Support, Customization, Interfacing, Implementation of business applications using Oracle EBS, Client/Server and Internet Technologies. Specialized in Oracle Applications (Financials, Supply Chain/Distribution, Procure - to-Pay, Order-to-Cash and HRMS Payroll) skills with sound knowledge of their integration. Worked on versions R12/11i
• Having Strong technical skills on Implementation, Integration and customizing Oracle Financial Accounts receivables, Payables, General ledger, Procure to Pay And Order to cash with Conventional data loads and SOA integrations, approx. and Control M scheduling application,
• Strong Technical skills in Oracle SQL & PL/SQL, RICE Components Development, XML BI Publisher, Personalization, AME rules setup, Oracle SOA, BEPL, Java, Oracle Workflow, Unix Shell program, Oracle 9i/10g Developer Suite, Oracle Discoverer.
• Experience in Oracle R12/11i E-Business Suite Applications such as GL,SLA(Sub ledger Accounting), AP, AR, OM, PO, INV, HRMS, Self-Services, HRMS, Payroll modules including development and migration of RICE elements, OA Framework Customizations and extensions and Setting up the AME rules and Oracle workflow customizations and Developing XML publisher reports.
• Having Sound understanding of all phases of end to end ERP implementation such as Business Process Studies, Gap Analysis - with respect to as is & To Be, Design, Development and Testing and Go Live and Maintenance.
• Experience in AOL and System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for technical issues.
• Developed functional & technical design documents (MD50, MD70) by interacting with management and analysts. Also being a consultant has gained valuable exposure to the project life cycle (SDLC), AIM methodology.
• Experience in communicating with end users, application specialists, network consultants, functional consultants, design architects, developers management levels of hierarchy.

TECHNICAL PROFICIENCY:

Technical Expertise: Oracle Applications Financials and Supply Chain Management, OA Frame work, Oracle SOA, BPEL

Tools: JDeveloper, TOAD, Pl/Sql Developer, SQL*Plus, Oracle Applications AOL,SYSADMIN, Work flow builder, Oracle Forms, Oracle Reports, XML BI Publisher, Hyperion Reporting Tool, SQL* Loader, UNIX Shell Script,, Oracle Discoverer

Environment: UNIX, Linux and Windows.

WORK EXPERIENCE:

Confidential, California

Sr. Oracle Applications Developer

Responsibilities:

• Identify scope, business and functional requirements and create process flow for Confidential Oracle EBS Integration with RAMCO application
• Design and Developing the Oracle GL interface program for RAMCO inventory miscellaneous transaction associated with Financial transactions
• Developing Outbound Interface programs on GL Accounts, Price list, Customers, Suppliers, Items Master and other Oracle EBS standard data which required for RAMCO to sync up with Oracle EBS SCM and Financials Data
• Design and Developing Custom program API’s for Sales order integration with RAMCO and process the data which received from RAMCO and load the staging tables in Oracle EBS and create Sales orders and Sales orders Attachments
• Design and Developing Custom program API’s for Inventory Transactions integration with RAMCO and process the data which received from RAMCO and load the staging tables in Oracle EBS and create Misc. Receipts, Issues for Inventory On hand Updates
• Build Solution path for Data conversion and interface requirements of AP invoices and Purchasing review solution with client leads obtain approval and signoff on the accepted solution
• Build solution documents such as technical and functional solution design documents, solution testing documents, business process documents and setup documents review technical solution with functional and development team review the code, test cases developed by offshore team to ensure that the solution is getting implemented as required

Confidential, Texas

Sr. Oracle Techno functional Consultant

Responsibilities:

• Identify scope, business and functional requirements and create process flow for Confidential Accounts Payables, Purchasing, HRMS, Payroll & benefits and iExpense modules
• Design that include customizing iExpense receipts images attaching to expense report Accounts payables invoice imports and attachments, and Oracle Purchase orders import for Confidential specific, Integration with external and internal Confidential applications
• Developing Outbound Interface programs on Payroll & benefits
• Developing API programs for AP invoices import and importing the Invoice image into UCM(Universal content Management)
• Customizing Invoice approval work flow to send an email notification with Invoice attachment
• Build Solution path for Data conversion and interface requirements of AP invoices and Purchasing review solution with client leads obtain approval and signoff on the accepted solution
• Build solution documents such as technical and functional solution design documents, solution testing documents, business process documents and setup documents review technical solution with offshore development team review the code, test cases developed by offshore team to ensure that the solution is getting implemented as required

Confidential, CHICAGO, IL

Techical and Functional Consultant (Oracle Financials (AR,GL))

Responsibilities:

• Identify scope, business and functional requirements for commercial credit card business
• Design Technical and functional solution for new org setup on Accounts Receivables module review solution with client leads obtain approval and signoff on the accepted solution
• Build solution documents such as technical and functional solution design documents, solution testing documents, business process documents and setup documents review the code, test cases developed by offshore team to ensure that the solution is getting implemented as required mentoring the team on production issues and ongoing project developments and enhancements
• Lead ERT calls with higher management and business owners and troubleshooting business critical issues
• Participating client call with business users and client managers on the new developments
• Providing weekly status updates to client leads on overall project

Confidential, CINCINNATI, OHIO

Techical and Functional Consultant

Responsibilities:

• Identify scope, business and functional requirements and create process flow for Honda Operating unit OM,AR,AP, INV and Advanced Pricing modules
• Design that include setup, customizing the Oracle applications product for Confidential specific process, Integration with external and internal Confidential applications
• Build Solution path for Data conversion and interface requirements review solution with client leads obtain approval and signoff on the accepted solution
• Build solution documents such as technical and functional solution design documents, solution testing documents, business process documents and setup documents review technical solution with offshore development team review the code, test cases developed by offshore team to ensure that the solution is getting implemented as required
• Plan for production cutover activities status reporting to onsite leads
• Follow software quality process and comply with SOX requirements
• Manage Customer relationship

Confidential, Fairfield, CT

Techo functional (General Ledger)

Responsibilities:

• Coordinating with functional users and business user and opening and closing the monthly and quarterly periods
• Scheduling Monthly and quarterly journal imports which have been received from various other Confidential business units
• Maintaining the chart of accounts
• Customize and maintain various Discoverer reports
• Resolving critical business issues and migrating the production
• Maintaining the CMA (Custom maintenance application) form.

Confidential, Losangeles, CA

Oracle Technical Specialist

Responsibilities:

• Create detailed project plan and ensure deliverables met on time, risks are appropriately mitigated, and status is communicated regularly
• Understand business use cases, integration business process, analysis of integration requirements, write business & technical requirements documents, logic diagrams, process flow charts, and other documents to aid in the NBCU Media RTS Time and Pay applications project; work to obtain required sign off.
• Responsible for managing analysis, design and development of various integration Interface tracks between Time and Pay allocation and SAP application And IVR Application with rest of the project team
• Coordinate and facilitate integration design, testing and implementation tasks. Manage expectations and partner with (and not limited to ) core NBCU Media RTS Time and Pay and SAP project team, business uses, Stakeholders, traffic & Sales system vendors, GDC’s and other NBCU application & technology teams
• Responsible for onsite/offshore team relationship and coordination
• Responsible for generating employees pay and new hire reports & trend summary on bi-weekly basis and urgent Ad-hoc reports on user specific criteria
• Bi-weekly review meetings with business department heads to get to know about the process changes in the business and to provide all possibilities to changing the application to adopt the new process
• 24/7 On-call Level 1 support for Confidential Universal Media RTS Time and Pay applications, Resolving business critical production issues and migrating to production and Monitor Daily/Weekly/Monthly production jobs

Confidential

Oracle Applications Technical Lead

Responsibilities:

• Reviewing the Requirements and identifying any Gaps in the requirements (Gap Analysis).
• Studying current Business process model and integrating the custom logical Apps Rules
• Developing PL/SQL API for Defaulting the shipping method in Oracle Order Management
• Developing Logical apps rules and Holding and releasing the order API using PL/SQL
• Developing PL/SQL API for creating invoice and Receipts from Supra NET to Oracle Accounts Receivables
• Production Supporting on Accounts receivables and Customers Standard
• Preparing the MD60, Migration Docs, Managing and mentoring Team

Confidential

Oracle Applications Technical Lead

Responsibilities:

• Reviewing the Requirements and identifying any Gaps in the requirements (Gap Analysis).
• Studying current Business process model and integrating the custom Confidential (invoice) functionality for Invoice Transactions.
• Developing invoice, Productivity and DSO Reports
• Preparing the MD64, CRC and UTS Documents.
• Preparing production installation scripts.
• Following up Oracle Service request for WHO columns updating and guiding the team technically.

Confidential, Atlanta, GA

Oracle Applications Technical Lead

Responsibilities:

• Studying current Business process model of Financial and Order to Cash and Procure to Pay process
• Reviewing the Requirements and identifying any Gaps in the requirements (Gap Analysis).
• Reports and Forms Customizations
• Developing various PL/Sql components for their customized Oracle apps.
• Developing Java and Jsp components using J Developer for their Self services Applications which are integrated with Oracle Applications.
• Validating the custom objects at Oracle R12 Environment and updating the objects at R12 Instance.
• Prioritizing Fixing the issue base on the Tickets creating and managing assigning the tickets base on the priority to team members
• Testing the Application

Confidential

Systems Analyst & Developer

Responsibilities:

• Reviewing the Requirements and identifying any Gaps in the requirements (Gap Analysis)
• Developing Various Conversion interface programs and preparing migration scripts for country specific org’s
• Developing Component on CRM to create automatic warranty generation from Oracle Order Management
• Developing Components to Direct Debit and Paymul for accounts receivable and payables to transfer funds with banks accepted format
• Enhancing XML Reports according to country specific.
• Testing the Application
• Proposing the Future/To-Be process model
• Post production Support