PRASHANTH R HOLLA acchc7@r.postjobfree.com

805-***-****

Summary:

Around 8 years of IT experience in Software Development life cycle and in analysis, design, modeling and

implementation of business logic. I have been involved in the implementation of various projects and client

end support.

A good Team player with excellent communication and time management skills and able to resolve issues

quickly and efficiently.

Extensive experience in creating packages, stored procedures, Functions, Triggers, Views and other

database objects using SQL, PLSQL

Worked on oracle PLSQL constructs nested tables, associative arrays, records, arrays and dynamic SQL and

analytical functions, Hierarchical queries, Bulk Binding.

Good work experience in different operating systems UNIX, Windows 95/98/NT/XP/2000

Expertise in the management of SQL scripts and documentation of the work.

Experience in Performance tuning and writing complex sql queries, Partitioning.

Strong in working on UNIX environment and working with FTP and SCP to transfer files to remote servers.

Experience in installing Oracle 9i/10g software and creating databases using manual scripts and database

configuration utility.

Expertise in MS office tools, Visio, SQL*loader, Import/Export and Import/Export dump utilities.

Exposure to Pharma, Automobile, Manufacturing, Banking and Telecom Domain

Technical Skills

Operating System Unix, Windows 98/ NT/ 2000/ XP/VISTA/7, DOS

Programming Languages SQL, PL/SQL, C, Assembly Level Languages(8085 & 8086),

Shell Scripting.

RDBMS Oracle 8i,9i,10g,11g

Tools and Utilities Import/Export Utility, Import/Export Data pump, Sql*Loader,

Putty/Unix, Toad 9.5/8.6.1, UTL_File packages,

Informatica(8x, 9x), SQL Developer, SQL*Loader, TOAD, Star

Team, SVN, Finacle(Banking Solution Software from Infosys).

Micro Controller 8051 architecture based ATMEL controller

Education College/University Year of Class Place

Passing

2003 65% Nitte (Udupi Dist.)

B.E. N.M.A.M. Institute of technology

- Page 1 -

PRASHANTH R HOLLA acchc7@r.postjobfree.com

805-***-****

PROFESSIONAL EXPERIENCE:

AMGEN

THOUSAND OAKS, CA JAN 2013 – PRESENT

BANGALORE, INDIA APR 2010 – DEC 2012

Role: Onsite Lead/Coordinator/Sr. Oracle Developer

Description: Customer Master & Alignment (CMA) application

CMA is a business critical application which facilitates consolidation, centralization, acquisition, management and

distribution of Individual customers / customer groups information and Amgen field force alignment

information to those customers data.

Roles and Responsibilities:

• Handling the Onsite team and coordinating with the offshore lead/team.

• High Interacting with the Clients/business team to resolve the issues.

• Writing Queries, Complex SQL Queries/DML Statements, PL/SQL

packages/procedures/functions/triggers as per the requirement.

• Loading of the data in bulk using SQL Loader and validating the data as part of Semester Load process.

• Working with the DBA and other Java support teams to identify the issues and help to resolve the same.

• Troubleshoot the issues in the code and performance impact queries.

• Performance Tuning of the impacted Queries.

• Executing of the Unix scripts for generation of reports/standardization of addresses.

• Handling/managing several processes in CMA and also fixing the bugs.

• Guiding/Assisting other Junior developers to check the code and reviewing the code.

• Coordinating the weekly project status meetings.

• Used JIIRA to access and log defects.

GENERAL MOTORS

BANGALORE, INDIA APR 2008 – MAR 2010

Role: Sr. Oracle Developer

Description: Vehicle Content and Price System (VCPS) application

VCPS is a cross functional tool for General Motors with requirements to primarily support Marketing, Order

fulfillment and Finance for automobiles. VCPS eliminates the Excel based solutions to create and manage market

offers. The system uses the upstream data from Engineering and product management to create market offers

and are then propagated to the order fulfillment and finance modules. The system is developed using Java

technologies and uses Oracle 10g as the backend.

Roles and Responsibilities:

• Developing Queries, packages/procedures/functions/triggers as part of the development.

• Responsible for implementing changes and debugging/fixing bugs in the packages/procedures.

• High Interaction with the Clients/Onsite team to resolve issues in quick time.

• Loading of the Test data into Database using SQL Loader.

• Helping the DBA to export/import the databases.

• Involved in the weekly project status meetings.

2

PRASHANTH R HOLLA acchc7@r.postjobfree.com

805-***-****

VERISIGN

BANGALORE, INDIA DEC 2006 – APR 2008

Role: Oracle Developer

Description: NEXTGEN 2.0 application

NextGen 2.0 is a mobile billing application developed using Java technologies and uses Oracle 9i as the backend.

The product consists of functionality mainly written in PL/Sql for calculating customer usages and responsible for

providing an Invoice. It also has a CRM tool called Speed Suite for customer care. It takes care of the entire life

cycle starting with receiving user data from the switches (Network Elements), calculating usages and discounts

until providing the user with the invoice.

Roles and Responsibilities:

• Maintaining the Billing & Rating Module.

• Involved in the production support activities of the previous releases and responsible for solving the

critical issues on time.

• Development of packages, procedures and triggers as part of the enhancements.

• Responsible for implementing change requests (CRs) for customers and clients.

• Data modeling and writing complex queries for reporting team.

• Customization of the product for different customers (users).

• Interacting with clients and the onsite team to solve issues.

• Updated and maintained all the DDL and DML scripts for production release.

• Work on the billing cycle modules which require constant post production enhancements to accommodate

diverse calling plans and rates.

VIJAYA BANK

BANGALORE, INDIA JAN 2006 – DEC 2006

Role: Oracle Developer

Description: Customization of Bank Reports using Finacle tool

Finacle is the core banking solution software from Infosys Technologies Ltd. It has the capacity to handle any kind

of transactions of bank from account creating to loan delivering etc. The objective of the project is to Customize

‘Finacle’ according to various requirements of the Bank. Well versed with Infosys Proprietary tool ‘MRT’ which is

used to display the output from Sql in the required Format as specified by the Bank.

Roles and Responsibilities:

• Involved in the development of packages, procedures and triggers as per the requirements.

• Involved in Fetching of the data from Database using SQL Queries and displaying using MRT.

• Interacting with the bank staff to fetch proper reports(Loans/advances) for the bank.

• Involved in writing Unix Shell scripts and unit testing.

WORLDWIDE ONLINE SERVICES

BANGALORE, INDIA JUN 2005 – SEP 2005

Role: Developer

Description: System Call tracker

- Page 3 -

PRASHANTH R HOLLA acchc7@r.postjobfree.com

805-***-****

The system call tracking module is meant to allow a system administrator or a programmer to define a set of

system calls invocations to be tracked by the module.

Roles and Responsibilities:

• Was involved in writing System Call Hijacking Component. The component is responsible for hijacking

system call and releasing hijacked system call.

• Was involved in designing the Application and writing Test Cases for Testing .

• Following the processes and maintaining the scripts in Star team tool.

• Providing the Status update on a regular basis.

Personal Details

Name Prashanth R Holla

Name as in Passport Prashanth Rajarama Holla Venoor

Father’s Name K. Rajarama Holla

Designation Ex Deputy General Manager(Retd.), B.S.N.L., Mangalore

Nationality Indian

Languages Known English, Hindi, Kannada.

Passport Number E5720616 Issued at : Bangalore

Visa US H1B Visa Valid till 10th November, 2014

US Business B1/B2 Visa (Valid till May 2020).

Permanent Address ‘Sowrabha’, 3 65/84, 1st Main,

6th Cross, Lohithnagar,

Derebail,

Mangalore, Karnataka State,

India – 575006.

1890, W HILLCREST DR,

Present Address

APT 531, NEWBURY PARK,

THOUSAND OAKS,

CA 91320

Contact Number 805 – 490 1049

4

Contact this candidate