PROFESSIONAL SUMMARY:

• Over 10 years of experience as an Oracle Applications R12/11i (E Business Suite) Techno Functional consultant, with expertise in Oracle Financials modules (AP, AR and GL), Manufacturing Modules(OM, INV, Shipping, PO) and Service and Depot Repair module
• Hands on experience to upgrade Oracle On - Premise solution to Oracle IAAS Cloud based solution which involves lot of coordination, analytical skills, complete architectural knowledge of application and strong technical skills.
• Expertise in implementing RICE (Reports, Interfaces, Conversions, Extensions) components in the area of technical design, development, Integration testing and deployment using open interfaces and APIs.
• Plan and integrate architectural frameworks for Oracle applications with other applications and translate to Oracle intelligence
• Strong Knowledge and full hands on experience in Order to Cash (O2C) and Procure to Pay (P2P) Cycle and other Oracle Application modules like OM, PO, AP, AR, WMS and GL.
• Extensively worked on changing the reports according to client requirements and Optimizing the Report Performance using XML publisher and Oracle report builder
• Strong Knowledge in creating Analytical reports/KPI/Dashboards using Power BI, Discoverer Reports and working knowledge of Oracle Analytics Cloud(BICS).
• Sound knowledge on EDI implementations and integration with Oracle apps.
• Full knowledge on Loftware labeling system where managed and created new labels for shipping, packaging material for different vendors
• Solely managed the activities like design, development, coding, testing and End-user .
• Substantial development experience in creating stored procedures, Packages, Triggers, Functions, Indexes etc.
• Proficient in Performance Tuning SQL statements using EXPLAIN PLAN, AUTOTRACE, SQLTRACE and TKPROF.
• Good working knowledge in designing technical documents using AIM Methodologies (MD50 and MD70).
• Experience in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND LOAD, SQL developer and TOAD.
• Automation by writing PLSQL scripts to trouble shoot the bugs.
• Good experience in Remote database administration using WinScp software, remote desktop, Filezilla and Putty
• Good hold on Unix commands and shell scripting
• 24x7 Production Support, customer interactions, team-player, and ability to handle multiple tasks independently.
• Understanding the gaps between systems and providing the analysis and solution for same
• Acted as the primary liaison between the client departments and the Information systems department to collect requirements, business process information and documented them in BR Document post analysis of all risks associated with them and mitigate them.
• Keen learner of new technologies includes Artificial Intelligence, Python and Block Chain etc.

TECHNICAL SKILLS:

ERP: Oracle E-Business suite R12/11i Accounts Receivables AR, Accounts Payables AP, Order Management OM, Shipping, Purchasing PO, General Ledger GL, WMS, Service

Application Tools: Oracle Reports, XML Publisher Reports, Discoverer Reports, Oracle Forms 6i/9i/10g, Form personalization, Microsoft Power BI

Databases & Tools: Oracle 11g/10g/9i, TOAD, SQL*Loader, SQL* Developer, TFS, HP Quality Center, JIRA, Serena, Subversion, Winscp

Operating Systems: Windows XP/7, UNIX

Languages: SQL, PL/SQL

Scripting Languages: Unix Shell scripting

ETL: Oracle ODI 10g

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Key member and accountable for oracle R12 upgrade from On Premise solution to Oracle IAAS cloud based solution. Responsible for Oracle EBS integrity with various third party application after IAAS move, requires good analytical, technical and interpersonal skills for stable business operations.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis, designed new process flows, documented the Business Process, various Business Scenarios and activities of the business from the conceptual to procedural level.
• Provided Customized End to end solution with EDI integrations like EDI 850, EDI 856 that will spans from developing custom EDI Edit form which enables used to import data to EBS after corrections, custom reports that will ensure the consistency across systems, ASN extensions and Unix scripts that will automate import from EDI to Oracle and developed labels using Loftware systems software.
• Worked with various Business stakeholders to gather reporting requirements, understand the intent of reports and attended meetings to provide updates on status of the projects.
• Implement strategies to migrate discoverer report to Microsoft Business intelligence Power BI.
• Development of financial reports using XML publisher, discoverer and oracle report builder as per accounting requirements from AP/AR and GL.
• Customized complex Packing Slip, Pick Slip and other EBS reports as per requirement to support business
• Existing EBS support to fulfill day to day user requirements for all modules Service, CRM, Sales, Finance, Purchasing (OM, AP, AR, GL, PO, Service, INV, Depot Repair)
• Present deliverables, risks, issues and status to senior stakeholders and managers
• Managing and following up on Oracle SRs
• Accountable for MS Power BI reporting implementation as well as new solution deliverables.
• Development many reports to support JSOX Audit company wise
• Maintained documentation for all change requests and code versions using SVN

Confidential

Oracle Application Tech Lead

Responsibilities:

• Work on Designing interfaces as per the requirement, Performance and Index tuning.
• Extensively worked on ETE shipping interfaces to receive the inbound ASN interface data to oracle apps and then outbound to third party warehouses for receiving Vendors and PO by mapping the data, writing oracle stored procedures, packages and oracle seeded packages
• To correct the ASNs in EBS, created one customized ASN correction form and open up the functionality to reprocess the ASNs in error.
• Worked on AP /AR and GL outbound interfaces for sending the invoices, credit memos, debit memos and GL related data to SAP on business requirements by writing PL/SQL, stored procedures and packages
• Worked on the development of SOA, EDI and Batch based Interfaces, Customizing Oracle Reports in finance touching various modules such as GL, AR, INV and OM.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL Packages developed.
• Prepared many Functional and Technical documents for requirements, design, and implementation steps, test plans and functional user guides for all the phases of the project
• Code review of all components before they deployed to any environment
• Developed various oracle alerts to notify users for any error in interface or standard programs

Confidential

Oracle Application Tech Lead

Responsibilities:

• Worked on backend of container management workbench for OM module and delivery system in WMS to load the truck delivery details in EBS
• Worked on HFM(Third Party) outbound interface to get the GL data
• Form personalization on AP module
• Prepared technical specifications documents MD70, test scripts, assembly test documents and deployment documents based on the functional requirement specifications MD50.
• Registered concurrent programs in Application Object Library (AOL).
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location

Confidential

Oracle Application Tech Lead

Responsibilities:

• Developed Oracle Alerts and set up vacation rules
• Involved in application testing, deployment and production support.
• Performed Unit Testing and captured the results.
• Performed Knowledge Transfer to end users on how to submit the jobs and check the flat file contents.
• Development of inbound and outbound interfaces in AR module
• Helped End-Users performing User Acceptance Testing (UAT).

Confidential

Technology Analyst

Responsibilities:

• Analysis of modules, task distribution, Client calls, Coding, Unit testing, Bug fixing and delivering Execution document, Technical Specification to client.
• Development of form personalization, forms and reports in AR, AP, OM modules
• Enhancements in PLSQL packages
• Enhancement in .rdf reports, .fmb forms and writing unix scripts for interfaces
• Deploying application in all environments (Dev./Test/Staging/Production).

Confidential

Senior systems developer in Oracle Apps

Responsibilities:

• As Senior Systems Eng. Functional Specification gathering, Coding, Bug fixing and delivering Execution document, Technical Specification to client.
• Responsible for End to end Conversion of Ship and debit and sourcing rules entities in oracle R12 from legacy system
• Preparing and Publishing fallout details for the application.
• Deploying application in all environments (Dev./Test/Staging/Production).
• Writing reconciliation scripts in pl/sql as per the requirements.

Confidential

Technical Associate in Oracle Apps

Responsibilities:

• As Technical Associate Requirement gathering, Application Interface Design, Coding, Bug fixing and delivering notes to client.
• Writing scripts in PLSQL as per requirement.
• Bug fixing
• Automation to find stuck orders
• Responsible for P1/P2 Ticket resolution
• Learned various modules such as order management, accounts receivable and accounts payable while working on support project
• Participate in walkthrough and Preparing Project related Documents