Oracle Sales

ANKUR PATEL

**************@*****.***

Cell: 848-***-****

Summary:

. Accomplished software engineer specializing in database programming

and front-end development.

. Extensive background in full life-cycle of software development

process including requirements gathering, design, coding, testing,

debugging and maintenance.

. Proven track of record of designing and implementing flexible

solutions which support UI and database changes.

. Extensive experience in ERP customization and implementation comprised

different modules.

. Hands-on experience with full Systems Development Life-Cycle.

. Skilled in determining, documenting, presenting, and communicating

requirements to technical and non-technical audiences.

. Motivated, articulate, and dynamic leader, researcher, developer,

speaker, and instructor.

. Hands on experience in Oracle BI EE testing, unit testing, report data

validation, report data testing based on SQL results, OBIEE query log

data validation

Technical Skills:

Languages PL/SQL, SQL, SQL*Plus, SQL Loader, SQL Net, Developer

2000, C, C++, COBOL, Java, Unix Shell Scripting.

Development Tools Oracle Form Report Developer, OBIEE,MS VisualBasic6.0,

MS VisualInterdev6.0,

MS FrontPage, J-Builder7.0

Databases Oracle 10g, Oracle 8.1.x, Oracle 8.0.5, Oracle 7.3, MS

-Access2000.

BI Oracle Business Intelligence Enterprise Edition (OBIEE)

10.1.3.4, Oracle BI Publisher,

Application Oracle10gAS

Servers

CASE Tools MS Visio

Operating Systems Windows 98/NT/2000/XP, Linux ( Red Hat )

CMM Practices SQA Team Member for e-Governance Project of Government of

Gujarat, India.

Education:

Masters in Computer Application (Major - Computer Science)

Bachelor of Science

Professional Experience:(8 Years)

MICROS SYSTEM INC. Naples,FL

Mar 2006 to Till Date

1) Project : Opera Information/Reservation System.

Module Profile Management, Reservation Management

Team Size 3

Tools PL/SQL; SQL; SQL*Plus; Oracle 10g; Oracle Forms 10g;

10gAS; Oracle Designer 10g; Linux; Windows XP; TOAD;

Oracle Reports 10g; Oracle Developer; PVCS Tracker; PVCS

Version Manager

Duration 4 Years

Description The OPERA Reservation System (ORS), a true centrally

managed central reservation system, is at the heart of the

hotel industry's first enterprise-wide room inventory

management system. The ORS hotel reservation system is

designed for seamless integration with the entire OPERA

product family - the OPERA Customer Information System

(OCIS), the OPERA Property Management System, OPERA Sales

and Catering, and OPERA Sales Force Automation. This

comprehensively managed central reservation system offers

reservations agents and global sales staffs the tools to

maximize bookings and increase revenue in any size chain

or multi-property environment. ORS easily handles all

types of reservations - individual, group and party,

company, travel agent, multi-legged, multi-rate, and

waitlisted.

Roles and . Involved in requirement gathering, data modeling

Responsibilit designs, normalization, query tuning, Coding and Unit

y Testing of OPERA.

. Responsible for conversion of logical to physical data

model for the application.

. Cleaned the database to remove unwanted tables and data

as per new system requirement.

. Developed Custom PLSQL packages, stored procedures and

functions for complex Business requirements using

Toad/PLSQL Developer.

. Performed Data Analyst role, to analyze the data and to

clean the DB schema.

. Developed Database objects like Views, Materialized

Views, Indexes, Sequences, and Synonyms.

. Fine-tuned, the SQL queries in order to improve the

overall system performance.

. Monitoring database and verifying completion of

scheduled jobs also done database schema differences.

. Coded and modified, core java programs, and used JDBC to

connect Oracle Database.

. Designed rules and extracted the data from Data Mart for

the application need.

. Updated workflow packages and path according to the new

system requirements.

. Work with Explain plan for SQL tuning and Hints for

changing the query optimization plan.

. Having good knowledge in fixing the Enhancements and

Bugs to previously developed reports, done with System

Testing and documented the entire report

TORRENT CABLES LIMITED, Ahmedabad, Gujarat, India

Feb 2005 to Dec 2005

2) Project : TORRENT ERP PACKAGE.

Module HR Payroll, Personnel, Purchase, Asset Management

Client TORRENT CABLES LIMITED, Ahmedabad, Gujarat, India

Team Size 3

Tools Oracle9i E-Business Suite (Oracle Forms 6i, Reports 6i &

Oracle 9i DB Server), Oracle 9i AS & Visio 5.0,ERWIN

Duration 10 months

Description The ERP package developed was for Medium Size Enterprise

and will provide complete integrated e-business solution

for entire organization. It will cover different areas

like Finance, Procurement, Sales, Marketing, Production,

HR and Payroll Administration, Equipment Maintenances etc.

Roles and Client communication and Interaction.

Responsibilit Analysis and prepared documentation of System Requirement

y Catalogue, System Requirement Study

Functional Specification And Database Design

Software Development and Implementation

User Manual

QAM and UAT before implementation at client side.

APPLITECH SOL. LTD(CMMLEVEL-5),Gujarat, India

Aug 2002 to Feb 2005

3) Project : Sardar Patel Institute of Public Administration

Module Online Entrance and Periodical Examination for IAS

Training Students

Client GAD, Government Of Gujarat, Gujarat, India

Team Size 3

Tools Oracle9i E-Business Suite (Oracle Forms 6i, Reports 6i &

Oracle 9i DB Server), Erwin, UNIX

Duration 4 months

Description The administrative head of the Government of Gujarat is

the Sachivalaya, which is located at Gandhinagar, Gujarat.

The Sachivalaya comprises of 23 departments, which are

responsible for implementing various policies, rules etc.

framed by the government.

The Institute conducts pre-service and qualification

examinations for the compulsory programs and preparation

exams for civil services study at the main center in

Ahmedabad. Results of employees of GoG are kept

confidential and repeat trials are also organized as per

the rules and regulations. A history of the examination

records of candidates is proposed to be maintained within

the system. The study branch is mainly involved in

Entrance Exam of IAS Training, Evaluation of the students,

Arranging weekly/periodic Online Exams, Time table and

Maintain Daily Attendance sheet of students etc.

activities..

Roles and Installation, Configuration and Administration of Oracle

Responsibilit Database and OAS. Installation of Developer 2000, Designer

y 2000 and Oracle Clients.

Planning and implementing various Backup and Recovery

strategies, used cold physical backups and logical backups

using Export/Import

Database Design and Modeling (ERD and SMD) for the entire

Module using Designer 2000.

Database Sizing using ERWIN tool

Creation of Common Packages, Procedures, Functions and

Triggers, Views for Application Development.

Contact this candidate