SUMMARY

• Software professional experienced in developing and implementing information systems in high tech business environments.
• He has over 14+years of experience in all phases of design, development and implementation.
• He has lead more than 5 BI Apps project implementation including JDE & Oracle EBS as source and is Oracle BI certified.
• Expertise includes conducting workshop to collect business requirement from CXO’s, Operational Managers, and Business Analysts.
• Extensive experience in implementing OBIEE 11g. Has lead several upgrade projects from OBIEE 10g to 11g.
• Expertise in design & implementation of Oracle Applications R.11/12i Workflow, Mod/plsql, Oracle Warehouse Builder 10.2, Rice Elements, Custom Workflow, Oracle Process Manufacturing,
• Oracle Shipping, Mobile Supply Chain, Order Management, Depot Repair, BOM, INV, WIP, Discrete Manufacturing, Defaulting Rules, Discoverer 4.1 and Reports 6i, BPEL, Apex, PL/SQL, Java Script and XML.
• Specialized in Data Warehousing and Web - based OLAP solutions.
• He is highly organized, thorough and innovative in his approach to technical solutions.
• He is a professional with excellent communication skills and an ability to be a great team player.

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Technical Manager

Responsibilities:

• Confidential completed his BI certification in Oracle Business Intelligence Applications 7 for ERP Essentials.
• Confidential has been responsible for setting up Oracle EBS R12 along with Oracle BI for Confidential .
• Some of the core responsibilities include running weekly ETL jobs and setting up training material so that Confidential can go into offering training courses.
• Confidential is also assisting Confidential along with Oracle in sales of Oracle BI and Oracle EBS solutions.
• Confidential has successfully sold upgrade project from R11 to R12 and is currently involved in assisting Sleepy's upgrade their system to OBIEE 11g.

Confidential, Roseburg, OR

Senior Technical Manager

Responsibilities:

• Confidential was brought in to enhance the functionality of an existing OBIEE system. Confidential brought in additional Essbase cubes into OBIEE physical layer by importing Essbase cubes. Then quickly converted measure dimensions to flat measures as by default measures are imported as measure hierarchies.
• The cube contains a single measure column that represents all the measures. After the conversion, all measures were being displayed as individual columns. Dragged and renamed the objects into the BMM layer and then created a presentation layer so that the users can build BI Analysis.
• In additional to that, Confidential also made some changes to the configuration files so that more rows can be exported to excel rather than the default of 2500 rows as provided by Oracle. Confidential also created users in the weblogic console as per the customer’s requirements.
• The trick here was that Confidential had to create a role similar to the BI consumer role but with additional policies applied. Thus the new role was created and the users were assigned to them. One other issue that the customer was facing was that they were building reports and saving them under their personal folder.
• Instead of sharing the reports or saving them under the shared folder, the customer was coping and pasting the reports under the shared folder. Thus the other users were unable to view the reports generated by other users as the copy paste functionality retains the same security properties as in the personal folders.
• This issue was quickly resolved after Confidential instructed the users to save the report in the shared folders and not use copy paste functionality.

Confidential, Arlington, VA

Senior Technical Manager

Responsibilities:

• Confidential is one of the very few customers which went live with OBIEE 11g and EBS on the same day. Confidential was sent by FCS to quickly work with the EBS team to build custom reports using BI Publisher and BI Analysis.
• Confidential lead a team of 3 resources and got it delivered on time. Confidential implemented the OBIEE security model using OID with scaled out option on a high availability environment. He was also very instrumental in training on how to build webservices, scorecards, create action items so that the in-house team can build them in the future.
• This implementation on Financial modules helped the company analyze the spending behavior. The solution was developed so that Confidential can analyze the amount of money spent on each supplier. The top 10 costlier suppliers came into the picture and thus enabling Confidential to further fine tune their spending patterns.
• Supplier and Cost analysis was very effective for Confidential and lead to a huge reduction in their cost. AP and AR for financial analytics are Oracle’s out of the box product. But building a solution that really solves the company’s need is more effective by analyzing a given Companies current situation.

Confidential, Charlotte, TX

Senior Technical Manager

Responsibilities:

• Confidential lead a team at Confidential in upgrading from OBIEE10g to OBIEE11g. Mr Gill came up with a well defined project plan and also conducted several training sessions.
• Confidential was very pleased with the work and since the project got implemented prior to the expected go live date, Confidential introduced Confidential to the new features of OBIEE11g. Besides the upgrade of OBIEE, the upgrade of the catalog was also done.
• Out of the 1700 hundred reports that were upgraded, 413 were erroring out. Confidential worked to quickly resolve the issue. Confidential also provided hands on training to the in-house developers on the new architecture of OBEE and created several documents on how to administer OBIEE.