SUMMARY:

• Anand Gopal is a Techno - functional SCM and is a member of the Apps Technical practice. With over 9 years of consulting experience, Mr.Gopal has designed and built forms, reports, interfaces and conversions in oracle application. With projects he has taken up many roles from a team member to a team leader and also has been a part of the client interaction team for few projects with clients from different continents across the globe. He has worked across industries from manufacturing of semi conductors, logistics, real estate and internet security. Mr. Gopal is a true user-advocate and leverages this passion, his user experience talents, a wealth of past experiences, and the knowledge of other thought leaders in this space to create user experiences that consistently exceed the expectations of his clients. These experiences with clients from different vertical gives him the edge to understand new challenges with new requirement.

TECHNICAL SKILLS:

Technologies:: SQL, PLSQL, FORMS, Reports, Workflow, XML Publisher.

Functional Expertise:: Oracle application Order Management, Inventory, AR, AP, PO, Property Manager.

Industry Expertise:: Semi conductor Manufacturing, Internet security, Network storage, Plastic manufacturing, Logistics, Real estate.

PROFESSIONAL EXPERIENCE:

FinisarTechnical Onsite

• EDQ implementation
• Deduplication Using EDQ DEDUP processor
• Integration with EDQP and EDQ
• Setting up of Jobs, scheduling jobs
• Setting up of notificaitons for JOBs,Schedules,issues and cases
• Writing reports automatically in the landing area and sending out alerts
• Design using data from different source like EBS and Agile
• Creating automated flows to validate purchasing, planning and supply chain attributes in EBS

Technical Onsite

Confidential

• Part of the team to design the interface the SAP and EMIS.
• Part of the discussion to find the GAP and mapping the requirements with the sap team
• Working on interface between EMIS and SAP.
• EMIS is a custom application and worked on inbound and outbound of data between this legacy system to SAP. IDOC is a doc type that sap can read automatically
• Designed the movement of file using the FTP utility package
• The modules worked are shipping, inventory,order management and inventory sync between both the systems
• Project task include unit testing, integration testing, user testing, code promotion to different instances and deployment activities .

Confidential

Technical Onsite Sunnyvale

• Worked in the hyperion financial reporting tool team
• Developed plsql packages to load data for hyperion
• Worked in tuning the code to make it more efficient
• The project involved writing packages which will feed information to financial reporting tools.

Confidential

Technical Offshore

• Working as a part of the support team for enhancements and fixes in Manufacturing Track.
• Worked in changes for BOM Routing changes which involves resources and departments to be updated for existing routing using interface tables.
• Worked in Quality reports COC,COC2,Batch and machine.
• Worked in XML barcode reports for labels and receipt travaller.
• The project involved work with modules OM, BOM,WIP and inventory

Confidential

Technical Offshore

• Worked for the implementation project Everest for integrating the process in Oracle 11.5.9 and oracle R12
• Worked in Item and BOM Integration which involved extraction from 11.5.9 and passing the load through SOA to R12.
• Worked in Interface for Item and BOM interface which was to map the changes happening live into R12 through SOA
• Worked on Business events for integration, to pass the load to SOA for integration.
• Worked on all the documents Technical Spec, Test documents and implementation documents for all the objects worked.
• Worked in designing of some solution for the integration process.

Confidential

Techno Fuctional Offshore

• 7 month role to design reports and forms for the realty company in Middle East.
• Development of XML reports for AR, AP, PO and Property Manager
• Testing the fix and interacting with the End Users
• Interacting with the onsite team to get requirement for new developments and creating the docs
• Migrating code to production using Harvest (Version control tool)
• Doing setups required in the production for fixes and developments
• Responsible for daily tracking sheet, Code review, Respective Documents Review

Technologies: Toad, SVN, XML publisher, Forms and report Builder.

Confidential

Technical Lead

• 26 month role to design, build, and leading a team for a support and enhancement team from offshore
• Assignment of Work request and trouble ticket
• Testing the fix and interacting with the End Users
• Interacting with the onsite team to get requirement for new developments and creating the docs
• Migrating code to production using Harvest (Version control tool)
• Doing setups required in the production for fixes and developments
• Responsible for daily tracking sheet, Code review, Respective Documents Review
• Technologies: Toad, Harvest, Forms and report Builder

Confidential

Technical offshore

• Handling Service Requests for enhancements of forms, reports, custom Registering the custom programs as concurrent programs
• Bug fixing in existing programs, forms and reports
• HRMS extracts
• Bug fixing on HRMS extracts detailing Employees and Appraisal and relieving details.

Confidential

Technical Offshore

• Developing forms, reports, interface programs and conversion programs
• Registering the custom programs as concurrent programs
• Unit testing the developed programs and assisting the QA team in testing
• Documenting the technical designs and test scripts
• Assisting in migration of the programs from one instance to the other
• Post production support that included issue resolutions and usage of Metalink
• Report on PO-s for Expense Items Analysis by org, by period
• Shell script to submit PO Receipts interface from the operating system. This was registered as a host type custom concurrent program
• Technologies: Toad, sql plus, Forms and Report Builder.

Confidential

Technical Offshore

• Preparation of technical specifications from the functional specifications received from the functional team
• Performing RICE assignments
• Outbound Interface for Obsolete Item
• Getting Obsolete Item data from Oracle Inventory for data analysis.
• Report Customization
• Customize the Open PO-s report so that it doesn't show PO-s that are already received.
• Custom report
• Report to print all open and closed PO's with high and low amount ranges.
• Form customization.
• Custom Garnishment form to zoom from vendors form to record garnishments for the vendor
• OM Holds conversion using API
• Converting holds from the legacy system to Oracle Applications using Public API.
• Technologies: Toad, sql plus, Forms and Report Builder.

Confidential

Technical Consultant

• Responsible for the Production Support such as resolving the issues, providing technical support to team members and escalating the issues.
• Worked on development of adhoc reports.
• Work included getting the reviews done by the review team.
• Technologies: Toad, sql plus, Forms and Report Builder