PRANAV PATEL

*** *. ******** ****** *. Pekin, IL 61554

309-***-****

abooz7@r.postjobfree.com

OBJECTIVE

Seeking a challenging position as a Business Analyst, which encourages growth and

leadership opportunities while utilizing technical expertise, innovative abilities, and

interpersonal skills.

TECHNICAL SUMMARY

10 years of IT experience as Business Analysis & Database Design,

Programming and

Implementation of Commercial Applications using database packages and tools.

Experienced in Database Administration including Architecture, Installation,

Configuration, Networking, and Backup of Database Servers on UNIX and Win-NT .

Proficiency in PL/SQL programming to develop complex Stored Procedures,

functions

Packages and triggers.

Experienced in using Developer 2000 tools to design/develop client-server

applications

on Windows, and various UNIX platforms.

Expert in tuning the systems for better performance by tuning Memory structures

and SQL statements.

Strong programming, technical, communication and leadership skills.

Experienced with complete project life cycle including business analysis and

enterprise model development.

PROFICIENCES

• Business Analyst

• Oracle Experience: Oracle 7.x, 8.x, 9i

Developer 2000 (Forms 6i, 5.0, 4.5 & Reports 6i, 3.0, 2.5)

PL/SQL, SQL *Reports, SQL *Plus, SQL*Net, SQL *Loader, Pro *C

Designer 2000 (6i, 2.1), Oracle Web server

• Languages: Java, C, Visual Basic, JavaScript, UML, JSP, ASP, HTML, XML, OOP

• Operating Systems: UNIX, Windows NT/98/2000, and MS-DOS.

• UNIX Skills: UNIX Shell Scripts and AWK Utility of UNIX.

PROFESSIONAL EXPERIENCE

EXPERIENCE

Dec `03 – Present Shreeji Oil, Inc. Creve Couer, IL

Job Position: Business Analyst

Accomplishments:

• Implemented numerous business optimization projects and reporting tools that

improved efficiency, reduced expenses, labor costs and maximized profit bu automating

manual process

• Created slide presentations for quarterly business review for corporate level

management documenting business status, performance, and pending business incentives.

• Helped resolved critical control and operational weaknesses; identify problems,

recommended improvements and worked in collaboration with middle office, Risk and

Finance to implement issue resolutions

• Increased sale and growth of business each of the last 6 years

Responsibilities:

• Manage HR activities as well as train employees and oversee their work

• Create a structure to increase business by innovative ideas and advertising campaign.

Jan`02 – Dec `02 P & K Contracting Inc. New Hyde Park, NY

Job Position: Database Developer/Database Administrator

Tools/ Platform: Oracle 9i, Developer 2000, PL/SQL, Unix, Windows NT

Accomplishments:

• Reduced, eliminated consulting fees by conducting Oracle upgrades and test in

conjunction with the company's D.B.A and developers.

• Reduced 80% overhead and printing cost in the creation of financial reports by

implementing the use of Oracle ADI.

Responsibilities:

• Responsible for Oracle database and Oracle application functions installation,

development, performance, architecture, and infrastructure per business requirements.

• Served as application system administrator to setup and maintain Oracle

application.

• Troubleshooting on SQL and PL/SQL to developers and users.

• Design and development of the data migration and conversion strategy used to

convert

the production database to the new data model.

• Developed procedure with SQL technology and performed data conversion with

SQL*Loader to transfer historical data to Oracle.

Sep `01 – Jan `02 SYNECTICS Consulting Chicago, IL

Client: Anexsys (A Bank One Company)

Job Position: Programmer/Analyst

Tools/ Platform: Oracle 8i,Developer 2000 (Forms & Reports 6i), PL/SQL, Unix

Accomplishments:

• Created Forms and Reports allowed agents and customer service representatives

immediate access to information, so calls are handled in minutes-if not sooner.

• Estimated a 30% improvement in productivity.

Responsibilities:

• Created reports in Oracle Reports 6i, for Management, Sales, Marketing & end

user

• Designed and Created front-end screens for user inputs using Oracle Forms 6i.

• Installed and Configured Oracle and Oracle Forms on the end-user’s machines.

• Created Store Procedures and DB Triggers.

Apr `01 – Jul ‘01 RHI Consulting Orlando, FL

Client: Curascript Pharmacy

Job Position: Database Developer

Tools/ Platform: Forms 6i, Reports 6i, Oracle 8i, PL/SQL, Windows NT

Responsibilities:

• Developed PL/SQL Stored Procedures and functions for Centura Application.

Created database queries and reports for information retrieval.

• Testing and ensuring that the data is entered in the ORACLE plans and captured

from

the database is correct.

Aug `00 – Mar`01 Walgreens Deerfield, IL

Job Position: Programmer/Analyst

Tools/ Platform: Oracle 8i, Centura (SQL Gupta), Unix.

Accomplishment:

• Reduced I.S. expenditures 30% while maintaining headcount and increasing end-user

capability and satisfaction.

• Provide technical expertise, status reporting, documentation and test condition to

insure project success.

Responsibilities:

• Help users analyze and design the information system. Instruct them to use our OO

tools (Centura) and database products from the 3rd party to implement system.

• Development, enhancement, and support of GUI, UNIX, and C for Client server

applications.

• Developed Unix Shell Scripts manipulating the flat file using Unix AWK Utility.

• Created Stored Procedures, Packages and DB Triggers.

May `98 – Aug `00 Walgreens Orlando, FL

Job Position: Programmer/Analyst

Tools/ Platform: Oracle 8i, Developer 2000, PL/SQL, Unix, SQL*Loader

Accomplishment:

• Designed and implemented customer usage and forecast data consolidation project

for vendor pricing. Cost saving estimated at 2+ million a year.

• Tuned inventory system resulting in a 25% increase in product shipment with system

availability of nearly 100%.

Created product development manual that included design, development, software

•

configuration control, release, and test procedures.

Responsibilities:

• Worked on Store, Supplier and Warehouse projects using Oracle Developer 2000.

• Developed complex views, writing SQL queries, Stored Procedures, and Functions.

• Developed various Oracle Forms and Reports.

• Created Stored Procedures and DB Triggers.

• Used SQL*LOADER to load data from flat file to Oracle Tables.

• Created Pro*C programs to generate Flat files in Unix OS, from Oracle tables. Also

updated Oracle tables using Pro*C & UNIX.

Jun `96 – Apr `98 Southern Farm Insurance Orlando, FL

Job Position: Programmer/Analyst

Team Size: 1

Tools/ Platform: FoxPro, Dbase lll, Windows 3.1 and Netware.

Accomplishment:

• Developed Client Management System for Life Insurance Agents. System for Life

Insurance agents maintains their client’s details and provides reports for next due

premium, periodic business etc.

• Developed Programs for small businesses using Dbase III plus and FoxPro. Designed,

developed and implemented Inventory Control System and Payroll System for small

businesses. Also participated in writing certain modules of payroll system using C.

EDUCATION

Aug `98- May `00 Webster University

BS in Computer Science

Jan ‘93 – May `95 Valencia Community College

Associate Of Arts Degree

Contact this candidate