SUMMARY:

• Having 11+ years of IT professional experience in various stages of the Oracle EBS implementation, upgrade and support lifecycle in Oracle EBS (R11i & R12) and having strong and significant experience in solution design and development, implementation of Oracle EBS and development of SOA composite applications and Integration of EBS with Integrated SOA Gateway (ISG) for clients in the retail, high technology, banking and finance, manufacturing and Oracle Utilities segments.
• Involved in 6 full cycle implementations of Oracle Applications R11i & R12 with good exposure to Implementation Methodologies viz. AIM.3.1
• A solid understanding of functional and technical knowledge of Procure to Pay and Order to Cash business flows (General Ledger, Subledger Accounting, Receivables, Payables, Oracle iExpenses, Order Management, Oracle Inventory, Oracle Projects, Oracle Purchasing, Oracle iProcurement, Oracle HRMS, Approval Management Engine (AME), Oracle Service Contracts, Oracle Advanced Pricing)
• Strong technical experience on developing CEMLI/RICEW components in the sphere of Oracle EBS using SQL, PL/SQL, Forms and Reports development, Forms Personalization, OA Framework (OAF), Oracle Advanced Queuing(AQ), XML/BI Publisher, Oracle Discoverer 10g and hands - on experience of development of OAF pages by JDeveloper 11g and Oracle WorkFlow Customizations and good knowledge of OBIEE
• Development of SOA composite applications and Integrations with Oracle EBS using Integrated SOA Gateway (ISG)
• Demonstrated proficiency and has very strong experience on data analysis, interface design & development and migration activities related to R12 Financials/SCM/HRMS of the following from Legacy Systems
• Master Data: Suppliers, Customers, Items, Employees, PLs, ECOs
• Transactional Data: Open AP Invoices, Open POs, Open AR Transactions
• Design, development and Deployment of Custom Oracle Forms, Custom OA Pages, Oracle Reports/XML Publisher Reports, Forms Personalizations, OAF Personalizations, Discoverer Reports
• Data migration APIs
• Design and development of data integrations (Both Inbound and Outbound) through Oracle AQs (Advanced Queuing) from Oracle EBS to Third Party Systems and vice-versa
• Implementation expertise in data integrations between Oracle EBS on one side and Oracle WAM, CC&B (Oracle Utilities) on other side through SOA composite applications
• Strong technical knowledge of Oracle Data Integrator ( ODI ) and XML Gateway to integrate source and target by design mappings to get legacy data into Oracle
• In-depth knowledge of various core technical aspects of Oracle EBS (R11i and R12) including AOL, SYS ADMIN, Oracle Workflow, Oracle AQ, Oracle Alerts
• Demonstrated proficiency and has very strong experience in development of data Conversions, Interfaces, extensions & customizations (RICEW) in different modules of Oracle Financials, Supply Chain Management and Oracle HCM
• Extensively worked on Service Contracts - Transforming Sales Order Data to Service Contracts by Oracle Standard APIs call for Subscription based Items both Tangible and Intangible Items.
• Data migration of Oracle Service Contracts Data to TMS System and vice versa by Oracle AQ (Advanced Queuing) Mechanism
• Perform production Support, performance tuning of custom forms and reports and optimization activities and detailed technical trouble shooting of day to day production issues
• Responsible to identify, assess and mitigate risk during project execution and lead quality assurance reviews for own and team. Mentoring to juniors and trainees and effectively manages assigned project tasks according to plan, participate in proposals development and prepare/deliver presentations

TECHNICAL PROFICIENCY:

EBS: Oracle Applications R11i & R12

Modules: Application Object Library, Oracle Alerts, Sys AdminGeneral Ledger, Subledger Accounting (SLA), PayablesReceivables, Purchasing, Oracle Inventory, Order ManagementApprovals Management Engine (AME), Oracle iProcurementOracle iExpenses, Oracle HCM, Oracle Projects, Service Contracts

Technology/Languages: SQL, PL/SQL, OA

Framework (OAF) Customizations: Personalizations, SOA, Oracle ADF, Advanced Queuing (AQ), Workflow, Oracle Forms and ReportsForms Personalization, XML/BI Publisher, Core JavaOracle Discoverer, Tableau Reporting, UNIX Shell Scripting

Environment: s: UNIX, Linux, and Windows NT

RDBMS: Oracle 8i / 9i, 10g, 11g, 12c

GUI: Forms 6i/9i/10g/11g/12c & Reports 6i/9i/10g/11g/12cWorkflow Builder

Tools: and Utilities JDeveloper 11g/12c, Oracle Data Integrator (ODI)XML Gateway, SQL*Loader, Toad, Utl-file

Office Tools: MS Office suite (Word, Excel, PowerPoint)

PROFESSIONAL WORK EXPERIENCE:

Confidential, New York, NY

Senior Application Developer

Environment: Oracle Fusion Middleware 12c, Oracle Forms 11g/12c, Reports 11g/12c, JDeveloper 12c

Responsibilities:

• Development of data integrations as part of Oracle Technology Upgradation from 11g to 12c
• Design and development of Oracle Forms and Reports enhancements
• Redesign and development of System Reliability and Encroachment Oracle Forms
• Responsible for converting, migration and deployment of Oracle Discoverer Reports to Tableau System
• Production Support issues related to DBMS Scheduler Jobs
• Maintenance and production support of Gas Work Tracker Application
• Redesign and development of Data Integrations
• Responsible for building SOA composite applications and Design and development of data integrations of Gas Work Data with external third-party systems

Confidential, Teaneck, NJ

Oracle EBS Technical Integration Specialist

Environment: Oracle R12.1.3, R12.2.5

Responsibilities:

• Develop and testing of various integrations as part of Oracle Technical Upgradation from R12.1.3 to R12.2.5
• Deliver technical solutions to meet new business requests following the established SDLC process within the 15-week window for the upgrade initiative
• Develop interface components to support other systems such as Wide Orbit, Hyperion, Informatica, Workday and additional systems with Oracle EBS
• Participate in system development and facilitate design sessions for business solutions.
• Formulate test plans, and coordinate and perform testing using industry standard methodology. Work closely with the analyst and the business users when testing.
• Support and troubleshoot all Financial/Projects modules within the Oracle E-Business Suite (e.g., General Ledger, Projects, Project Contracts, Project Management, Project Costing, Project Billing, Revenue, Accounts Payable, ebTax, Cash Management, Accounts Receivable, Fixed Assets)

Confidential, Secaucus, NJ

Senior Technical Lead Consultant

Environment: Oracle 11.5.10.2, Oracle R12.1.3, Oracle AQ (Advanced Queuing)

Responsibilities:

• Design and development of Advanced Queuing mechanism for 25 Integrations/Interfaces - Inbound and Outbound AQ-MQ OTC R12 Upgradation
• Extensively worked on Service Contracts - Transforming Sales Order Data to Service Contracts by Oracle Standard APIs call for Subscription based Items both Tangible and Intangible Items
• Migrating Oracle Service Contracts Data to TMS System by Oracle AQ (Advanced Queuing) Mechanism as Outbound Interface
• Importing Updated Service Contracts data to Oracle EBS Service Contracts - To ensure data in Oracle EBS and TMS should be in Sync
• Resolve production support issues of Service Contracts Main Billing Program to make sure customers are billed for every period and data is migrated to Account Receivables to raise invoices periodically
• Design and development of OAF customizations and personalizations related to Standard Customer OAF Pages
• Implementing Export functionality
• Implementing Record History functionality to improve Audit Trail requirements
• Defaulting values in Customer Tax Exemptions OA page
• Customizations in OAF Customer Standard Form
• Implementation of Back-To-School (BTS) Project in Oracle EBS
• Identified and fixed gaps of Data integrations between Oracle EBS - TMS - EDW
• Performance tuning of PL/SQL based concurrent program ‘SCHL Invoice Print Program’ which process about 250K volume of records daily
• Implementation of Integration of import of SW Orders to Oracle EBS
• Support issues related to Data flow between Oracle EBS to TMS & EDW
• Design and development, deployment of OAF customizations of Confidential Customer Portal
• Performance Tuning of OM Tables Purge process
• Worked on production support issues of Revenue Recognition Process
• Development of XML/BI Publisher Reports to meet the Confidential Tax Audit requirements

Confidential, Fayetteville, NC

Technical Lead

Environment: Oracle R12.1.3, Oracle Fusion Middleware - SOA 11g, Oracle WAM 1.9.0.4.1, Oracle CC&B 2.3.1

Responsibilities:

• Troubleshooting the standard costing and FPWC HR Custom Costing Process and improve the performance of custom costing engine
• Extensive understanding and experience using personalizations and customizations to deliver solutions in both Oracle Forms and OA Framework
• Resolve the Document of Records functionality in Oracle HRMS using HRMS workflow
• Implemented OA personalizations and Customizations of HRMS Self services pages
• Implementation of HR Absence Management and made PLSQL APIs hook calls from Standard Absence Management OA pages
• Design and development of custom OA Pages to integrate Bank Information against each employee details
• Design and development of XML/BI Publisher reports to meet ACA requirements
• HR data conversions through PLSQL APIs - Bulk transfer of data from legacy system into Oracle HRMS - Employees, Assignments, Grades, Person Absences, Positions
• Resolve the issues pertaining to Oracle Payment Manager and issues related to CC&B and EBS Integration - Create Employee, Update Person,
• Redesign and development of Approvals Mechanism of AME for Requisitions, POs, AP Invoices and iExpenses based on Cost Centre Setup
• Resolve the issues related to FPWC Bank Reconciliation Process
• Development of Oracle Custom Forms and Custom FERC Derivation business process
• Addressing the issues pertaining to Oracle iProcurement
• Implementing Late-Charges functionality in Oracle Receivables
• Design and implement the FERC Derivation Rules by Oracle custom Form development
• Supported the issues of data migration between Oracle EBS to WAM and vice versa
• Item Org/Storeroom and average cost of item
• Item Master/Catalog
• Item Onhand Quantity
• Vendor Master
• Material Issue (Stock Checkout)
• Purchase Requisition - Service Requisition

Confidential, Sunnyvale, CA

ERP Technical Lead - Support Analyst

Environment: Oracle Apps 11.5.9, Oracle Apps 11.5.10.2, Oracle R12, SOA 11g

Responsibilities:

• Redesign and development of data extraction of Items, ECOs and Price Lists integration process between Oracle EBS 11.5.9 to SOA Integration Layer to R12
• Work with the team or as an individual contributor delivering enhancements to Oracle ERP
• Meeting with customers to understand their business processes and needs with the objective of determining solutions to support the business
• Ensure technical design aligns to overall enterprise architecture of the client & ensure scalability
• Defining technical best practices for the customizations, configuration and solution
• Perform code reviews and recommend remedial measures

Confidential, West Borough, MA

Senior Consultant Technical Lead

Environment: Oracle Apps R12.1.3, Oracle 11g

Responsibilities:

• Extensive development of Customizations of OA Pages using OA Framework in Oracle Financials Modules Purchasing, Payables, iExpenses and Oracle Projects
• Customization of iExpenses OA Page to display expense account description
• Extending Oracle Projects DFF in Projects OA Page and display of Project Attributes and WHO Columns in OA Page
• Developing technical specifications for OA Framework Customizations and Personalizations and Oracle Workflow modifications
• Development of Revenue and Billing Summary (R&B Summary) report to show Revenue and Billings details of all Projects as per given period and made accurate that report should tally with Oracle standard GL Trial Balance Report
• Worked with users to formulate the business requirements of corporate financial reporting related to General Ledger and Project Accounting
• Identifying the integration issues, investigating, and analyzing business processes, procedures and work practices between Oracle Financials and iExpenses modules
• Identifying and evaluating inefficiencies and recommending optimal business practices, and system functionality and behavior
• Using project management methodologies, principles and techniques to develop project plans and to cost, resource and manage projects
• Identifying technology limitations and deficiencies & gaps in existing systems and associated business processes, procedures and methods in support track
• Taking responsibility for deploying functional solutions, such as creating, adopting and implementing system test plans, which ensure acceptable quality and integrity of the system
• Creating user and training documentation, and conducting formal training classes

Confidential, CA

Sr. Techno-functional Consultant

Environment: Oracle EBS 11i, EBS R12 Upgradation, Oracle 10g, Discoverer 10g

Responsibilities:

• Lead the preparation of custom solutions for existing business processes related to Oracle HRMS and Oracle Discoverer Reports
• Development of Discoverer Reports in HRMS: HRMS: Employee Absences, HRMS: Employee Details, HRMS: Employee Department Changes, HRMS: HR Benefits, HRMS: Employee PTO Balance Listing, HRMS: Org Department Employee Listing(Org), HRMS: Employee Salary Listing
• Development of Customization of HRMS PTO Process across HR Organization Units
• Responsible for all development, conversions, and development support related to Oracle Financials track during the release schedule
• Using data and process modelling techniques to create clear system specifications for the design and development of system software
• Acting as a central reference and information source, providing guidance and assistance in the system project decision making process and quality audit
• Testing, debugging, diagnosing and correcting errors and faults in an applications programming language within established testing protocols, guidelines and quality standards to ensure programs and business applications perform to specification
• Writing and maintaining program code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards
• Writing, updating and maintaining technical programs, end user documentation and operational procedures
• Preparation of POCs and demonstrate to the business users and client.
• Coordinating between team and Quality team to meet the quality audit requirements
• Sharing the views and ideas related to the Project among the Team members and review the solution design and documentation.
• Provided mentoring to junior consultants and effectively manages assigned project tasks according to plan, participate in proposal development and prepare presentations.

Confidential

Lead System Analyst

Environment: : Oracle EBS R12.1.3, 11.5.10.2, Oracle 9i, Developer 6i

Responsibilities:

• Lead the Technical Team members to deliver quality technical solutions and preparation of Complete Business cycles to demonstrate to the clients.
• Responsible for development of OA Pages personalizations in Oracle iExpenses.
• Responsible for development of XML publisher reports and data conversions related to Oracle Service Contracts
• Sharing the views and ideas known on the Project among the Team members and accept the critical reviews.
• Provided mentoring to junior consultants and effectively manages assigned project tasks according to plan, participate in proposal development and prepare/deliver presentations.
• Testing, debugging, diagnosing and correcting errors and faults in an applications programming language within established testing protocols, guidelines and quality standards to ensure programs and applications perform to specification
• Writing and maintaining program code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards
• Writing, updating and maintaining technical program, end user documentation and operational procedures
• Preparation of POCs and demonstrate to the business users and client.