Sr. Business Analyst
Resume:
PRANAV PATEL
*** *. ******** ****** *. Pekin, IL 61554
***************@*****.***
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