PROFESSIONAL SUMMARY:

• An accomplished professional with 12+ years of IT experience as Oracle Applications Techno - Functional / Solution architect in implementation, upgrade and support of e-Business Suite Manufacturing (BOM, WIP, Inventory, PJM and MRP), Financials (AR, AP, SLA, Costing and GL), OM, PO, Alerts and Sys Admin Modules.
• Experience in reviews of requirements, business specifications, business processes and recommends proposed solution, Development and post production stabilization
• Experience in developing MD70, MD50, BR100 documents as per business requirements.
• Experience in Configurations, Testing, UAT, production deployment and post production support.
• Strong experience in designing and developing the Inbound & Outbound real-time/batch Interfaces and integrating the Oracle applications with the third party systems using middleware SOA/BPEL, Web methods and Informatica.
• Extensively worked on Oracle SQL, PL/SQL, Report, Forms, Workflow Builder, XML/BI Publisher, UNIX shell script, Personalization and having knowledge SOA (Oracle SOA11g) and OAF.
• Extensive experience in back end programming with a sound understanding of Application Object Library (AOL), Standard APIs and utilization of hooks to implement custom logic. Experience in developing Stored Procedures, Functions, Triggers and Packages.
• Possesses strong knowledge of the Oracle Open Interface tables. Held positions where major responsibilities included coding, interfaces, conversions, reports, enhancement programs and testing in an Oracle Applications environment.
• Extensively involved in troubleshooting, debugging and fixing the codes/scripts, Month-end activities and production support
• Experience in Order to Cash(OTC), Procure to Pay(PTP) and Plan to Manufacture(PTM) cycles.
• Experience in raising service request (SR) with Oracle support to get the fixes/patches for the issues.
• Certified Project Management Professional (PMP), Strong knowledge in AIM methodology, Change Management process, Agile methodology, Lean, Kaizen and Six sigma process.
• Strong experience in onsite offshore model and lead offshore / remote teams.

TECHNICAL SKILLS:

ERP: Oracle Applications / EBS R12.2.5, R12.1.3, 11i.

Database: Oracle 12c/11g, Toad

Languages: SQL, PL/SQL, Unix shell scripting, Core Java

Tools: Oracle Developer Reports, Forms, XML Publisher and OAF

PROFESSIONAL EXPERIENCE:

Confidential, Mentor, OH

Senior Oracle applications SCM techno-functional

Responsibilities:

• Upgraded from 11i to R12.2.5
• Implement/integrate new sites/acquisitions to EBS
• Developed integrations with cloud based export compliance system (Integration Point)
• Actively work with BPOs to understand the business needs, prioritize requirements, design, develop and implement innovative solutions
• Requirement gathering in SCM areas, analyze current process and automate/improve the processes
• Map the requirements to standard Oracle and design, develop and implement solution for identified gaps
• Worked with Zebra printers to print thermal labels directly from Oracle EBS Forms
• Worked on interfaces - Items, Transactions, IR and ISO Receipts and developed new reports, interfaces, PL/SQL Programs, forms/OAF personalization, Alerts, depends on business requirement
• Support PO, iProcurement, Shipping, Inventory, BOM, WIP and Costing modules
• Raise SR for any standard oracle issues and implement solution
• Work with offshore team for production support and enhancement requests
• Support shipping systems like Clippership, Flagship and FedEx and integrations with multiple manufacturing ERP systems
• Participate in Kaizen and Lean events and suggest to improve systems / processes

Confidential, Cincinnati, OH

Manufacturing/Costing Functional consultant - Solution architect

Responsibilities:

• Functional consultant for Manufacturing, Costing & Sub ledger accounting modules
• Document the Business requirements and map with the standard functionality
• Prepare and maintain BR100, BR050, MD50, MD70 documents as per requirements
• Configure the instance as per business requirements and responsible for CEMLI
• Responsible for performing Unit testing, Regression testing, SIT, Coordinating UAT
• Integrate Proficy with Oracle EBS R12 using Webmethods
• Implemented actual costing process with custom solution for its repairs business
• Gather requirement for multiple EBS, OBIEE reports and work with development team
• Design solution for gaps and perform POC and build solution
• Conduct CRP sessions and test end to end business scenarios

Confidential, Erie, PA.

Manufacturing Techno-Functional consultant - Solution architect

Responsibilities:

• Document the Business requirements and map with the standard functionality and perform the POC and show it to the business.
• Solution design for the identified gaps.
• Extend the Inventory, BOM and WIP modules to the support the new facility and build the integration with MES/Proficy system with near real time transactions
• Functional and Technical design documents to integrate with the third party applications.
• Integrate the BOM and WIP modules with the GE IP - Proficy with near real time transaction processing.
• Worked with Oracle SOA / BPEL team to design, develop and implement integration with Proficy.
• Worked with developers and integration team to deliver the solution.

Confidential, Cincinnati, OH.

Finance Techno functional lead - System Analyst

Responsibilities:

• Finance Techno functional lead, onsite coordinator.
• Lead offshore technical team to deliver components.
• Responsible for quarterly enhancement release rollouts for Finance track RICEW components .
• Go-live support and project stabilization.
• Identifying the key gaps in the system and proposing the solution.
• Design and development of Technical documents/objects.
• Re-structured Discount accounting process.
• Enabled Manual invoicing process and enhanced invoice delivery process.
• Simplified journal entry posting process in summary in shared environment.
• Worked on custom module called Revenue sharing program and Joint venture.

Confidential

Techno-Functional lead - System Analyst

Responsibilities:

• Worked as offshore technical lead and managed 8-10 technical resources.
• Design solution for identified key gaps.
• Design and development of Technical documents/objects.
• Lead the technical team to deliver the technical objects and co-coordinate with the onsite team.
• Design & development of common modules which can be used across the project.
• Customized OM COGS Workflow to generate COGS Account on Material Transactions.
• Customized INV COGS Workflow to generate Intercompany AP Account.
• Developed Revenue AFF custom program to generate revenue account in Auto Invoice interface.
• Worked on Payables interface to create invoices for AR invoices based on business criteria (Intercompany payable for $0 intercompany invoices).
• Worked on intransit report to identify cost differences for the items which are in transit
• Worked on custom reports, XML Reports & custom interfaces to integrate with the third party systems/ companies.
• Worked on intercompany GAP solutions.

Confidential

System Admin/ Oracle Application support analyst

Responsibilities:

• Analyze the issues/bugs/enhancements and provide the resolution.
• Monitor the schedule jobs and responsible to provide resolution in case of failure of any requests.
• Closely worked with the Oracle to get the fix for any issues in the standard Oracle.
• Closely worked with the 3rd party application teams which are integrated to Oracle applications and resolving the issues.
• Closely worked with the Citibank to resolve any issues with the electronic bank statement, Payments, Receipts and Direct Debit files.
• Worked on XML publisher reports.
• Gathered enhancement/new requirements requested by business and worked with development team and once they deliver the solution doing UAT with the user and migrate the solution to appropriate environments.
• Configuration as per BR100 document provided by the functional consultant.
• Provide the data extract to the users whenever they request for particular data.

Confidential

Technical Consultant

Responsibilities:

• Developed Technical Design Documents from Functional specification.
• Worked on the below interfaces as part of integration.
• Auto Invoice interface in Receivables.
• Developed the package to load the data migration invoices using Auto Invoice.
• Lockbox interface in Receivables.
• Bank statement interface in Cash Management.
• Getpaid outbound interface to extract AR information to the third party system
• Developed below reports
• Bank statement reconciliation report to show the details of each reconciled line with the sub ledger (AR, AP) and ledger (GL) information in single report.
• Developed Surcharge report.
• Developed transaction detail report.
• Created the shell scripts to FTP the files and to send email notifications.
• Created Oracle Alerts like new inventory item and AR periods open/close.
• Worked on Descriptive flex fields.
• Personalized the Lockbox form to submit the custom concurrent program automatically whenever the user submits the standard Process Lockboxes program.
• Customized CUSTOM.pll to enable the ZOOM functionality on AP invoices for to view the invoice image.

Confidential

Role: Technical Consultant/ Support Analyst.

Responsibilities include:

• Efforts include Analysis, Bug and data fixes, Enhancements and resolution of problems faced by the customer, enveloping all Oracle Manufacturing and OM modules with the length of Applied’s customizations.
• Customized Reports
• Shipped Not Invoiced Report
• Cancelled Orders Report
• Order Import Process Exception Report
• Promised Date Changes Report
• Invoice Adjustments Printing
• Implemented new Update promise date functionality as per client requirement