Oracle Project

Around * yrs experience in Oracle Applications as a Technical consultant and Qlikview consultant with good knowledge in coding and testing of software applications and having in-depth knowledge in Oracle Application Framework, Oracle Forms Personalization’s, XML Publisher, Discoverer, Oracle9i, Reports 6i, Reports 10g, Oracle Alerts, Oracle Jdeveloper, Oracle Applications (Technical and Financial Modules).

Summary

• Experience in Oracle Applications R12 and 11i Modules like iExpenses, Purchasing, Payables, Projects, Receivables, Sys Admin and Application Object Library.

• Developed Reports, Packages, Custom Objects related to AP, PA,AR, PO, HRMS, Order Register and iExpenses.

• Strong Working Experience on Qlikview Development and Administration.

• Strong Working Experience on Oracle Applications Framework, Oracle JDeveloper.

• Strong Working Experience on XML Publisher.

• Strong Working Experience on Oracle Forms Personalization’s.

• Strong Working Experience on Oracle Discoverer, Oracle Reports.

• Proficiency in development of interfaces, conversions, triggers, reports, and forms.

• Good Working knowledge on Oracle workflow.

• Worked on Oracle Alerts.

• Worked on FND Loader Scripts.

• Self-motivated, result oriented and a good team player.

• Good interpersonal, communication and presentation skills ability to deal with the business users diplomatically.

Skills

Languages SQL, PL/SQL, Core Java

GUI XML Publisher, Oracle Reports, Discoverer, Oracle Jdeveloper, Qlikview, Oracle Workflow.

Tools TOAD

O.S. Win-95/98/2000 Server, UNIX, MS-DOS

RDBMS Oracle 8i/9i and Oracle 10g

ERP Oracle Applications 11i (iExpenses, AP, PO, PA,AR, HRMS, Order Management & SysAdmin) and Oracle Applications R12

EDUCATION:

• Master in Computer Applications (M.C.A) from Nagarjuna University.

• Bachelor degree (B.sc) from Nagarjuna University.

Professional Experience

• Working as Senior Technical Consultant in Raqmiyat, Abu Dhabi from 3rd May 2009 to till date.

• Worked as Senior System Executive in Fujitsu Consulting Pvt Ltd, Hyderabad from 6th August 2008 to 29th April 2009.

• Worked as Associate Consultant in Wipro Technologies, Hyderabad from 8th August 2005 to 23rd July 2008.

Project 1: Mubadala Development Company

Organization: Raqmiyat, Abudhabi

Client: Mubadala, Abudhabi

Description

Mubadala Development Company (Mubadala) is a catalyst for the economic diversification of Abu Dhabi. Established and owned by the Government of Abu Dhabi, Mubadala strategy is built on the management of long-term, capital-intensive investments that deliver strong financial returns and tangible social benefits for the Emirate.

Mubadala brings together and manages a multi-billion dollar portfolio of local, regional, and international investments. It partners with leading global organizations to operate businesses across a wide range of industry sectors including aerospace, energy and industry, healthcare, information communications and technology, infrastructure and real estate. By doing so, Mubadala accomplishes its mission to expand the economic base of the Emirate and contribute to the growth and diversification of its economy.

Duration: May 09 To till date

Role Senior Technical Consultant

Environment: Oracle Applications 11i, Qlikview 9, Oracle 10g, SQL *PLUS 8.0, PL/SQL, TOAD, Oracle Reports, Oracle Discoverer, FTP, WINSCP, XML Publisher and OA Frame work, Star Command Center.

Contribution o Developed the Qlikview dashboard for the P&L accounts, Balance sheet, Opex & Capex accounts by using the Hyperion

o Developed the Qlikview dashboards by connecting different data sources like Oracle, Excel and HFM (Hyperion Financial Management)

o Generating QVD files

o Qlikview Security Administration

1. Adding/deleting users

2. Create Folder Hierarchy

3. Assign users to folders specific to project

4. Active directory Integration

o Move applications (qvw files ) manually for publishing (Qlikview Access Point)

o Administration and Monitoring of server using QMC

1.Recycling of services

2. Manual Data Refresh/Reload during any failure

o System Clean-up and Maintenance

o Install/Un-install the QlikView software patches

o Manage adhoc project support requests

Qlikview consultant. Creating management dashboard and reporting for Portfolio management , Finance, HR departments.

o Creating the BU Metrics and Blue Book Qlikview applications for higher management.

o Developed the Trail Balance, HRMS, Projects and other finance applications by using the Qlikview.

o Strong Knowledge on Qlikview developer, Management Console and Enterprise Management Console.

o Applying security of the data to different BU’s in Qlikview Applications.

o Developed the Change request process by using the OAFramework.

o Developed OAFramework customizations on iExpenses, PO, HRMS and PA.

o Customized the Budget workflow.

o Worked on Various Forms Personalization’s.

o Worked on Various reports in AP, AR, PA, PO, HRMS modules.

o Developed Oracle Alerts in HRMS , AP .

o Developed Interface program for Hyperion Consolidation.

o Automatic process of creating the users, end users, add a key members and delete the key member from the project when the employee terminated.

o Prepared MD.070, MDC.120 and MD.050 documents.

o Rollouts of Mubadala subsidiaries like ATIC, MIG,CCAD.

o

Project 2: Qatar Petrochemical Company

Organization: Fujitsu Consulting India Pvt Ltd, Hyderabad

Client: Qapco, Qatar

Description QAPCO (Qatar Petrochemicals company) is a 2 billion QAR Petrochemical company. It’s a company under the control of government of Qatar.

The main Product of the company is LDPE (Low density Polyethylene), Ethylene and sulphur. The main raw material is ethane gas and its sourced from Qatar Petroleum. R12 Implementation of Supply Chain Modules, Maintenance, HRMS, Financials and Order Management.

Duration: Aug 08 To Apr 09

Role Technical Consultant

Environment: Oracle Applications R12, Oracle 10g, SQL *PLUS 8.0, PL/SQL, TOAD, Oracle Reports, FTP, WINSCP, XML Publisher and OA Frame work.

Contribution o Customization of the PO Document, Check Printing.

o Developed the RFQ, Standard PO Conversion Program, AP Invoices, Item Import Conversion Programs.

o Developed the Employee, Assignment, Jobs and Job Positions conversion.

o Developed the Conversion program for the Automatic Receipts, Apply and Adjustments.

o Developed Oracle Reports in HRMS, Purchasing and Payables.

o Developed Oracle Alerts in HRMS, Purchasing.

o Customization of the Order Register by using the OAFramework

Project 3: Merichem Offshore Support and Enhancements

Organization: Wipro Technologies, Hyderabad

Client: Merichem, US

Description Merichem, a privately held company supplying chemicals, technology, and services to the Hydrocarbon Processing and Pulp and Paper Industries worldwide, located in Houston, Texas. The implementation timeframe of just 32 weeks for 19 modules of the Oracle E-Business Suite represents one of the fastest implementations on record for the broad Oracle® E-Business Suite footprint by Wipro.

Duration: May 07 To July 08

Role Team Lead.

Environment: Oracle Applications 11i, Oracle 8i,SQL *PLUS 8.0,PL/SQL, Discoverer, Oracle Reports, Citrix, FTP, Putty

Contribution o Developed some Oracle Reports, Discoverer Reports.

o Prepared MD070 which gives the basic idea of technical design of the RICE components, MD0120 which gives the complete installation document .

Project 4: Sony Digest, US

Organization: Wipro Technologies, Hyderabad

Client: SONY Electronics Inc.

Description SONY Electronics Inc. is a World leader to provide innovative electronic solutions for commercial and industrial markets.

Duration: Dec 07 To Apr 08

Role Technical Consultant

Environment: Oracle Applications 11i, Oracle Framework, Oracle 8i,SQL *PLUS 8.0,PL/SQL, Reports 6i, Citrix, FTP, Putty

Contribution Developed the new OAFramework Pages. On-line confirmation of tool exists at vendor or not and also he can provide comments along with tool exist.

Project 5: Sony iExpenses, US

Organization: Wipro Technologies, Hyderabad

Client: SONY Electronics Inc

Description SONY Electronics Inc. is a World leader to provide innovative electronic solutions for commercial and industrial markets.

Duration: Nov 06 To Dec07

Role Technical Consultant

Environment: Oracle Applications 11i (AP and iExpenses), Oracle Framework, Oracle 8i,SQL *PLUS 8.0,PL/SQL, Discoverer, Reports 6i, Citrix, FTP, Putty

o Added the Description Field on the General Information Page by extended the Controller.

o Defaulting the Project Number and Task Number from the Header Page to Lines Page and Details Page.

o Project Number and Task Numbers are Mandatory depends on the Specific business Purpose.

o Defaulting Credit Card Transaction details to the Expense Report lines DFF Fields.

o Customize the List of Values to list only INDIRECT Projects at the Expense Report Line Level.

o Developed a Custom form to update the Invalid Cost Center and Approver.

Project 6: COLT Telecom Implementation and Upgrade Project

Organization: Wipro Technologies, Hyderabad

Client: COLT Telecom, UK

Description COLT Telecom is a leading provider of data, voice and managed services to business and government customers in Europe is in the process of implementing Oracle E-Business Suite 11i applications. There are 3 waves in the Project In wave 1 the project is implemented for United Kingdom and Ireland In wave 2 objects were roll out to other European countries like Germany, Austria, Swirtzerland, Denmark, Norway, Finland, SSC India In wave 3 the objects were roll out to France, Belgium, India, Italy, Portuguies, Spain and SSC India. This project included the P2P, R2R, O2C and HRMS Tracks.

Duration: Nov 05 To Nov 06

Role Technical Consultant

Environment: Oracle Applications 11i, Oracle 8i,SQL *PLUS 8.0,PL/SQL, Discoverer, Reports 6i, Citrix, FTP, Putty

Developing and Migration of Discoverer Reports

o Developed Discoverer 4i Reports in Discoverer Viewer Edition in Oracle Purchase, AP, AR,GL and HRMS.

o Developed Unix Shell Script to submit this Concurrent Request Set using CONCSUB.

o Developed and Migrated the D2k Reports in PO,AP,HRMS and INV modules

o Creating the Concurrent Program Script, Value Set Creation Scripts for D2k Reports.

Project 7: Sony 11i Upgrade Project

Organization: Wipro Technologies, Hyderabad

Client: SONY Electronics Inc.

Description SONY Electronics Inc. is a World leader to provide innovative electronic solutions for commercial and Industrial markets.

Sony 11i is the Upgrade project for Televisions operating from sandiego US. This includes customization and migration of different objects like Reports, Forms, Shell Scripts and PL/SQL procedures.

Duration: Sep 05 to Nov 05

Role Technical Consultant

Environment: Oracle Applications 11i

o Migrating Reports from Oracle Applications 10.7 to 11i.The contents of the Reports Upgrade document include the Pre-requisite Software, Upgrade steps, testing steps.

Project 8: Dun & Bradstreet Oracle Apps iReceivables Implementation

Organization: Wipro Technologies, Hyderabad

Client: Dun & Bradstreet, US.

Description

Dun and Bradstreet is Sales and Marketing Solution is US.

• Oracle iReceivables to help in reducing the cost of billing and collections while improving overall customer service.

• To provides customers with the self-service ability to manage their own accounts and pay, print, and dispute invoices online.

Duration: Aug 05 to Oct 05

Role Technical Consultant

Environment: Oracle Applications 11i,OA Framework Personalization’s

Contact this candidate