Harsha
Oracle Developer
PROFESSIONAL SUMMARY:
About 7 years of experience in the development of client/server and multi tired applications using
Oracle Database, SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and
Linux (Caldera).
Involved in Design, development, implementation, Data migration, Data conversion, testing
and documentation of business applications using Oracle technologies.
Proficient in Oracle 10g/9i/8i/7.3, PL/SQL Development Toad, SQL Plus, PL/SQL Developer,
UNIX and working knowledge of UNIX editors, Debuggers.
Strong Experience in data Maintenance and Support which uses Oracle 9i database, SQL,
PL/SQL, SQL* Loader, Shell Scripts, Business Objects in windows NT and Unix environment
Extensively used PL/SQL to built Oracle Packages, stored procedures, functions, triggers,
cursors, Oracle Reports and views for processing data, enforcing referential integrity and
needed business rules.
Knowledgeable in Client / Server architecture
Experienced in Tuning Queries for better performance with large volume of data.
Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V-
arrays, Records, Types, Dynamic SQL.
Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project
environment.
Solid hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit
Testing, Migration, Conversions, and Process Documentation.
Quick learner with ability to master new concepts and applications .
Very good team player and ability to work under tight project schedules
Excellent analytical, problem solving, communication and inter-personal skills to manage and
interact with individuals at all levels. Able to interact effectively with other members of the
Business Engineering, Quality Assurance and other teams involved with the System
Development Life cycle.
TECHNICAL PROFICIENCY:
Databases : Oracle 10g/9i/8i/7.3, Oracle Reports, Sql server 2005, DB-2 and MS-Access
Languages : DB2, Sybase, SQL, PL/SQL, XML, UNIX Shell script, Editors, Debuggers,
utilities and connectivity tools, Java, J2EE.
Tools & Utilities : TOAD, SQL* Plus, ETL, TK-Prof, UTL_File Packages, OLAP, Data flux
Operating Systems : HP-UX, Linux (Caldera), Windows and DOS
Web technologies: HTML, VB-Script
PROFESSIONAL EXPERIENCE:
Kaiser Permanente, Pasadena, CA Sep 2008 – Till date
Oracle Developer
This project includes Data migration and Data Conversion from oracle8i to oracle 10 g. Built a central
Database where data comes from different sources like oracle, SQL server and flat files. Actively involved
as a Developer for preparing design documents and interacted with the data modelers to understand the
data model and design the ETL logic.
. Responsibilities:
Involved in gathering the requirements and documented high level documentation for the
project.
Created stored procedures, functions, Packages, Data base triggers, constraints, indexes, grants
and sequences based on business requirements.
Performed backup and restore of database/schema
Handled database server tuning, application tuning and Normalized the database for better
performance.
Experience with FTP Protocol, System Analysis, Business Analysis, Documentation,
Implementation, Telecommunications, Windows NT, HTTP, TCP/IP, UNIX.
Involved in performance tuning using Explain Plan, Tk- proof utilities.
Involved in coding(PL/SQL) to migrate the data from oracle 8i to 10g.
Involved in code reviews and acceptance testing of the application
Involved in creating Index’s, passing hints, analyzing the table statistics and Table partitioning.
Improved performance of existing report views by using hints. The performance is increased by
100 percent in many of the reports.
Provided test data QA team to validate front end application and also involved in unit testing.
Involved in Data migration using SQL* Loader from flat files in to data base tables.
Solving day to day issues raised with the loading process.
Involved in Extraction transformation and Loading
Reorganized databases and sized database objects to meet standards and improved performance
by 20%
Environment: Oracle 10g, SQL, PL/SQL, SQL* Plus, SQL * Loader, ETL TOOLS, , TOAD, Unix shell
script, Editors and Debuggers.
Humana, Louisville, Kentucky Sep 2007 –June 2008
Oracle Developer
This project includes developing Data warehouse from different data feeds and other operational data
sources. Built a central Database where data comes from different sources like oracle, SQL server and flat
files. Actively involved as a Developer for preparing design documents and interacted with the data
modelers to understand the data model and design the ETL logic. Reports were generated using Business
Objects. The project aimed mainly at developing the utilities that can provide the status and can monitor
the Customers information. The application performs various functions like loading, segregation,
. Responsibilities:
Involved in gathering the requirements and documented high level documentation for the
project.
Created stored procedures, functions, Packages, Data base triggers, Reports and Cursors based
on business requirements.
Experience with FTP Protocol, System Analysis, Business Analysis, Documentation,
Implementation, Telecommunications, Windows NT, HTTP, TCP/IP, UNIX.
Involved in performance tuning using Explain Plan, Tk- proof utilities.
Involved in Data Migration and Data conversion.
Involved in creating Index’s, passing hints, analyzing the table statistics and Table partitioning.
Improved performance of existing report views by using hints. The performance is increased by
100 percent in many of the reports.
Provided test data QA team to validate front end application and also involved in unit testing.
Involved in Data migration using SQL* Loader from flat files in to data base tables.
Solving day to day issues raised with the loading process.
Involved in Extraction transformation and Loading
Experience in developing and modifying reports in Oracle Discoverer 10g/9i/4i and BI (XML)
Publisher 5.6.2.
Environment: Oracle 10g, SQL, PL/SQL, SQL* Plus, Discoverer 4i, SQL * Loader, Business Objects,
ETL TOOLS, XML, TOAD, Oracle Reports6i Unix shell script, Editors and Debuggers, Testing,
OLAP,HTML and Ms. Access.
McAfee, Santa Clara, CA April 2006 -Sep 2007
Oracle Developer
McAfee is an Antivirus software company. There are 3 modules Customer A/c Management,
Order management and Billing Consolidation System. The e-Bill system mainly emphasizes on consumer
utilizations and also customer relation executives of McAfee. This system also generates E-bills to
different types of customers. The database is maintained in Oracle9i.
Responsibilities:
Involved in writing data Migration scripts/create table scripts to load database successfully from
old schema to new structured schema.
Altering the database Objects to synchronize it with the new Schema created.
Creation of database objects like Tables, Views, Materialized views, Procedures, Packages using
Oracle tools like PL/SQL Developer, SQL* Plus, Toad
Understanding the business logic to modify existing SQL Code and Performance Tuning.
Involved in writing procedures, functions, triggers, and packages for new requirements.
Created Records, Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
Participated in Performance Tuning using Explain Plan and Tk-Proof.
Developed and customized number of reports using Oracle Reports 6i and Forms.
Created number of database Triggers according to business rules using PL/SQL.
Developed ad hoc reports using Discoverer 4i.
Involved in code reviews of other team members
Responsible for developing new reports in Oracle XML/BI publisher 5.6.2
Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
Involved in Production support for leg of the business.
Developed necessary data access programs using JDBC and Data Express and developed the
web pages using HTML and Java Scripting.
Environment: Oracle 10g, PL/SQL, SQL* Plus, SQL * Loader TOAD, Oracle Reports, SQL Plus,
HTML, XML, UNIX Editors and Debuggers
Call Wave, Santa Barbara, CA. Jan 2006 – March 2006
Pl/SQL Developer
Call wave is a communications company in providing various facilities. In order to provide high
quality services to their customers initialized the project to analyze and customize the database.
Project involves managing the internet e-business. The Call Wave Account (CWA) enables participants
from various clients to care needs. Project involves building automated batch processes to take care of
business.
Responsibilities:
Involved in analysis, Design, Development phases of the project.
Developed Requirement Specifications, Functional (Business Terms) and Technical Design
documents.
Extensively involved in Writing PL/SQL Stored Procedures, Functions, and Packages to meet the
business requirements.
Created custom partition tables for reporting.
Worked on performance tuning and used Explain Plan, TK-Proof, and Sql-Trace for tuning the
queries.
Used Refcursors and Collections for accessing complex data resulted from joining of large
number of tables.
Moved data from the old tables into the new tables using Sql*Loader
Used Exception Handling extensively for the ease of debugging and displaying the error
messages in the application.
Optimized existing queries for better performance and less impact on database.
Used Dynamic SQL for interface programs and exception handling routines.
Involved in the design and implementation of the process for loading the monthly loads coming
from flat files in to staging tables in the Oracle Data base using SQL* Loader.
Involved with QA team and reviewing their test cases and recommending changes if required.
Environment: Oracle 9i, SQL, PL/SQL, SQL* Loader, TOAD, SQL PLUS, XML, HTML, UNIX Editors
and Debuggers.
Time Warner & Cable (Roadrunner), Fort Lauderdale, FL. June 2005 – Dec 2005
PL/SQL Developer
Time Warner-PFS (Production Flow System) is a distributed data capture system that provides
the ability to capture package information of business. It has been integrated with many PFS systems to
facilitate in operational reporting, package routing, customs clearance, billing, and networking
simplification.
Responsibilities:
Involved in review of the database design.
Involved in Bulk loading of data from non-Oracle data sources using SQL * Loader.
Participated in system analysis, data modeling and database designing which included creating
tables, views, indexes, synonyms, triggers, procedures and packages.
Developed Shell and PL/SQL scripting for regular maintenance and production support to load
the data in regular intervals.
Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
Involved in the design, development, testing and maintenance.
Troubleshot production problems and worked effectively with other team members to identify
and address problems.
Provided input into project plans for database projects providing timelines and resources
required. Involved in SQL tuning using SQL-Trace, Tk-proof and Explain plan utilities.
Responsible writing UNIX shells scripts.
Environment: Oracle 9i, SQL, HTML, UML, SQL * Loader, PL/SQL, Crystal Reports, TOAD, XML and
UNIX Shell Scripting .
Global Payments, Atlanta, GA Oct 2004 – May 2005
Oracle Developer.
Global Payments is one of the world’s largest transaction processors and offers worldwide,
world-class electronic transaction processing services through our high speed, robust electronic
information networks. These networks process billions of business and consumer payment card and
money transfer transactions annually for customers in the United States, Canada, Europe and Latin
America.
Responsibilities:
Coordinated with the team to study and gathered system requirements.
Involved in designed the necessary table structures and table relations.
Participated in system analysis, data modeling and database designing which included creating
tables, views, indexes, synonyms, triggers, procedures, Reports , Forms and packages.
Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
Provided input into project plans for database projects providing timelines and resources
required.
Maintained the data integrity and security using integrity constraints and Data base triggers.
Involved in the application tuning of database by identifying the suitable Indexes.
Involved in Data migration using SQL * Loader from flat files into database tables.
Solved day to day issues raised with SQL * Loader. Wrote Unix Shell scripts in UNIX.
Extensive use of Bulk binds Bulk Collects and Partitioning.
Environment: Oracle 9i, SQL, SQL PLUS, PL/SQL, SQL * Loader, TOAD, Oracle Reports, HTML, Ms.
Access, UNIX Shell Scripting.
Dr. Reddy's Laboratories Ltd, India Feb 2003 – Sep 2004
Oracle Developer
Dr. Reddy Labs has expertise in the development and manufacture of pharmaceutical
intermediates, bulk actives and finished dosage forms. This system developed in order to handle sales
orders placed to the company.
STS (Sales order tracking system) categorizes the products into different groups and keeps track of their
inventory and prices and also tracks the customer information.
Responsibilities:
Development of user interface windows for sales order processing, invoicing, customer billing &
inventory.
Validation rules were implemented by writing procedures during data input.
Created stored procedures, Packages, Functions and triggers using SQL & PL/SQL.
Developed database triggers where ever necessary.
Involved in analyzing user/business requirements and mapping into technical specifications.
Performed in depth of data analysis and prepared weekly, biweekly, monthly reports by using
reports 2.5.
Implemented a whole new security for the reports in the oracle database to prevent confidential
data from being displayed to all users. The security is based on the standard concept of roles and
privileges.
All the security roles and privileges are stored in the database tables and the logic is implemented
using functions and views. Promoted the security feature to the existing reports with a very
minor code change in the actual reports.
Environment: Oracle 8i, PL/SQL, SQL * PLUS, Reports.
Astra Zeneca, Bangalore Mar 2001 – Jan 2003
Oracle Developer
With its headquarters based in UK, Astra Zeneca has its R&D facilities based in Sweden, USA,
Japan & India. Astra Zeneca in India has its R & D, Manufacturing and Marketing offices in Bangalore
where Oracle and C
Responsibilities:
Gathered the requirement from the client and translated the business design into Technical
design.
Involved in coding the libraries using UNIX and C to retrieve the information from the flat files
Coded middle layer component using C/C++ and Sybase DB-Library
Monitor performance and changing performance requirements through application of database
tuning and performance optimization techniques.
Triggers, procedures and functions are developed in this reports using PL/SQL.
Created database objects such as tables, views, synonyms, indexes, sequences and database links
as well as custom packages tailored to business requirements.
Prepared Mapping documents and design documents for data conversion.
Developed validation procedures and error reporting on the data in the intermediate tables.
Created user defined Exceptions while handling exceptions.
Troubleshooting production problems and worked effectively with other team members to
identify and address problem.
Developed Business layered components in C
Environment: Oracle 8i/7.3, PL/SQL, SQL * PLUS, SQL * Loader .
EDUCATION QUALIFICATIONS:
Masters in Computer Applications from Osmania University, INDIA.