xSUMMARY

• 15 years of IT Experience, 12 years of experience in as Oracle Techno Functional Consultant in system analysis, development, customization, implementation, upgrades, rollouts, production support, and integration of Oracle EBS Application 10.3, 11i (11.5.9, 11.5.10) and R12(12.1.3, 12.2.6). Over 2 years of experience in Oracle cloud applications.
• Full life cycle implementation experience in Oracle Applications Supply Chain & Manufacturing modules (PO, INV, BOM, WIP, iSupplier, Sourcing, iProcurement, OM, Advance Pricing), and Finance modules (GL, AP, AR, iExpenses, FA, CM, and PA).
• Extensive pre and production support experience in managing client issues, and provide quick around solutions, On - site/Offshore co-ordination, people management and project management.
• Good exposure in design of high level flow charts of business processes, and IMS (Incident management system).
• Extensive experience in business meetings with business users to gather requirements, to create design document and perform impact analysis for Oracle EBS functionalities.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, reports using Report builder 6i, BI Publisher, Workflow, Oracle Discoverer, OAF JDeveloper (9i /10g), and development of business reports using OBIEE.
• Good exposure on procure to pay, order to cash, quote to order business cycles.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL, and built-in APIs.
• Experience in EDI integration to Order Management (EDI 850, EDI 856).
• Sound knowledge in costing, receipt accounting, SLA from SCM modules to GL.
• Good exposure in month end activities in PO, OM, INV, WIP, AP, AR modules.
• Having lead experience with 15-20 team size, for requirement gather from business users and provide technical design document to technical team. And, guide technical team in development of reports, conversions, interfaces, and extensions for Oracle Applications.
• Having experience in design documents (BR100), and functional design documents (MD050).
• Well versed with Oracle standards and AIM methodology.
• Rich experience in environments requiring direct customer interaction during specifications, documentation, design and development and implementation phases
• Strong analytical and diagnostic skills and ability to work in a fast-paced and team-oriented environment.
• Conducted System Integration Testing (SIT), and User Acceptance Testing with business users.
• Expertise in functional setups for Oracle Supply Chain & Manufacture modules (PO, OM, INV, BOM, WIP, Advance Pricing, iStore).
• Having solid experience in P2P, O2C, and Quote to Order.

TECHNICAL SKILLS

• INV, BOM, WIP, PO, OM, iSupplier, Sourcing, iProcurement,
• MES, ASCP, Demantra, Advance Pricing, GL, AP, AR, FA, CM, iExpenses, and iStore.
• 10.7, 11i (11.5.9, 11.5.10), R12(12.1.3, 12.2.3,12.2.4,12.2.5).
• LINUX, HP UNIX, SUN Solaris, and WINDOWS NT/2000/XP, Oracle 8i, Oracle9i/10g/11g, MYSQL, MS Access
• SQL, PL/SQL, Shell Script, Dev6i, HTML, Java Script, XML, and Java
• Oracle SOA, OAF, ADF, JDeveloper, SQL *Plus, SQL *Loader, Workflow Builder 2.6, Dev 6i/2000, Discoverer 4i, XML Publisher, JDeveloper, Demantra, and OSB

PROFESSIONAL EXPERIENCE

Confidential, PA

Senior Oracle Technical Consultant

Responsibilities:

• Designed technical solution for Project accounting including project billing, and project costing.
• Integrated solution for legacy project billing, and costing to Oracle EBS.
• Design and develop conversion, and interface in PA billing, PA costing and GL modules.
• Conversion of 3 years historical data from Oracle 11i to Oracle R12.
• Integration solution legacy time entry based project hours to project costing, and cloud payroll systems.
• Analyzing integration touch points with different systems.
• New workflow design and customization in OM, PO, PA modules.
• Providing and Designing the Solutions Responsible for Delivery in Cloud,Fusion, EBS HCM Modules
• Customers, parties, party relationships conversion using TCA API’s.
• Enhancements of reports for long running, by tuning sql queries, and creation of indexes at custom table level.
• Performance and tuning of SQL queries for long running.
• Design materialized views for dash board based reports.
• Strong exposure in Oracle EBS database tables, views, open interface table, and API’s

Confidential, PA

Senior Oracle Technical Consultant

Responsibilities:

• Designed sourcing rules, Item master setup, Inter org items return setup, and Inventory custom SLA rules modification.
• Leading technical team size of 8 to 10 members.
• Provided CRP2, CRP3, and UAT session for client demo and testing.
• Provided all functional setup of Inventory, and Cost management.
• Provided custom business process from Inventory to Fixed asset and Projects.
• Designed technical solution for Project accounting including project billing, and project costing.
• Integrated solution for legacy project billing, and costing to Oracle EBS.
• Design and develop conversion, and interface in PA billing, PA costing and GL modules.
• Conversion of 3 years historical data from Oracle 11i to Oracle R12.
• Integration solution legacy time entry based project hours to project costing, and cloud payroll systems.
• Analyzing integration touch points with different systems.
• New workflow design and customization in OM, PO, PA modules.
• Providing and Designing the Solutions Responsible for Delivery in Cloud,Fusion, EBS HCM Modules
• Customers, parties, party relationships conversion using TCA API’s.
• Enhancements of reports for long running, by tuning sql queries, and creation of indexes at custom table level.
• Performance and tuning of SQL queries for long running.
• Design materialized views for dash board based reports.
• Strong exposure in Oracle EBS database tables, views, open interface table, and API’s

Confidential, Sunnyvale, CA

Senior Oracle Business Analyst

Responsibilities:

• Designed technical solution for Oracle Project Accounting, and integrated with legacy systems.
• Extremely designed complex report in Oracle Project Costing, and Fixed Assets using BI Publisher, Oracle Discoverer tools.
• Customized Oracle SLA as per business needs for Fixed assets, and Inventory modules.
• As part of Inventory module, designed custom business process for accounting purpose.
• Designed month end automated process tools in Fixed Assets module.
• Involved technical solution for Royality Automation implementation.
• As team lead to provide technical design documents to technical team, and guided tables, API’s to technical team.
• Coordinating meetings with Business team and functional team for technical specification based on functional document.
• Provided technical design solution to integrate cloud CRM (Sales force) to Oracle ERP.
• Design and develop GL consolidation process and report using R12 Accounting setup concepts.
• Extremely provided technical design solution in Oracle project costing and integrate to legacy systems, and other modules like Payroll, AP, PO, GL modules.
• Did page personalization, and extensions in Oracle iProcuremt module using Oracle OAF technology.

Confidential, Round Rock, TX

Senior Oracle Business System Analyst

Responsibilities:

• Extensively designed product configuration, BOM structures in PIM based on legacy data.
• Performed all the required setup for Oracle PIM, and PLM.
• Automation of configuration setup for different environments.
• Designed and developed complex product information, product structure, and product UDA to Oracle PIM from legacy systems.
• Provided simplified solution to business for complex issues like high volume data import and integration to legacy OM from Oracle EBS.
• Build OAF page personalization, and ADI customization in PIM.
• Setup and configured Oracle modules INV, and OM.
• As team lead to provide technical design documents to technical team, and guided tables, API’s to technical team.
• Coordinating meetings with Business team and functional team for technical specification based on functional document.
• Published item information to upstream systems like legacy OM system, and Oracle OM using OSB (Oracle Service Bus).
• Good exposure on agile methodologies.