Sql Oracle

JINAY DEDHIA

646-***-**** / ***********@*****.***

SUMMARY

• 6 years of experience in Analysis, Design, Application Development and production

support using Oracle SQL, PL/SQL.

• Migration of Data from one database to another new or existing database or up

gradation of Facets (4.71) Database using SQL Loader Tools.

• Wide knowledge of Facets Data Model in Membership and Billing.

• Pre-Analysis and Testing of Clients requirements in to Mapping Documents.

• Extensive work experience in SQL and PL/SQL in Oracle by writing Packages,

Stored Procedures, Cursors, Functions, Views, Database Triggers, User-Defined

Types, Dynamic SQL, Bulk binding techniques using Rapid SQL and SQL Server

Management Studio.

• Oracle in-built packages like UTL_FILE, DBMS_SQL etc.

• Extensive experience in analysis and design of database including ER Diagrams, data

dictionary techniques, data flow diagrams, Normalization and de normalization

techniques.

• Strong in Database Architecture, Database Development, and Data Modeling using

MS Visio.

• Extensive work experience in Oracle 11i, Oracle 10g, Oracle 9i, Oracle 8i databases

to develop user interfaces and Customized Forms and Reports.

• Working knowledge in ETL development, Data Migration concepts using native tools

of Oracle (SQL LOADER, PL/SQL).

• Familiarity with Oracle data warehousing features such materialized views, bitmap

indexes, Index Organized Tables, external tables etc.

• Fulfilling daily DBA activities like: setting up user management (creating users,

synonyms, privileges, roles, quotas, table, index, sequence etc.) and Disk space

management (Table space, rollback segment).

• Experienced in writing SQL queries, PL/SQL Collections and Exception Handling,

understanding requirements and developing plans.

• Experienced in Database Optimization by making use of various Performance Tuning

techniques.

• Experienced in Partitioning Administration. Creating and Managing Partitioned

Tables and Indexes.

• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.

• Experienced in Normalized Database Design and Modeling (Logical and Physical

design of database).

• Working knowledge in Dos batch programming and UNIX shell programming.

• Experienced to translate reporting and analytical needs into technical solutions.

• Strong interpersonal & communication skills, Competitive analytical, logical, and

problem solving skills, Strong management, administrative and leadership skills to

work in team.

EDUCATION

• Masters in Information System (IS), Pace University, NY

• Bachelors in Computers Engineering, Shah and Anchor Kutchhi Engineering College,

Mumbai, India.

SKILLS

• Programming Languages SQL, PL/SQL, C, C++, Java, VB.Net.

• Databases Oracle 11i/11g/10g/9i/8i, MS SQL Server

2000, DB2,

MS Access, MS SQL, SQL * PLUS, MYSQL

• Design Languages HTML, UML, ASP.Net, DHTML, CSS, PHP

• Tools Rapid SQL, SQL Server Management Studio, TOAD,

SQL* Loader, MS Office, Front Page, MS Visio

• Operating System Linux, Windows 95/98/2000/NT/XP/Vista/7, Mac,

UNIX

EXPERIENCE

December’ 11 – Present PL/SQL Developer, TechnoSoft, Denver, CO

Data conversion team migrate data from one database to another that means migrating data from

existing database to the new database or up gradation of Facets database from previous version

to new one. In Trizetto (Client) Data Conversion module, we are migrating data from Legacy

database to Facets Database. I am working on TriZetto Client CVS, UHC, HAP.

• Conversion of Clients Data from old existing database to the new database which consists

of 10 million records.

• Analysis of mapping fields and changing the business logic of program as per

requirements.

• Creating PL/ SQL stored Procedures, views, functions, packages, MS SQL SERVER

stored Procedures and functions using Rapid SQL and SQL Server Management Studio.

• Pre Analysis of the Clients Data and the requirements for new database.

• Working on PL/SQL, T-SQL to migrate data into (Facets) application.

• Core Coding and unit testing using the old database.

• Run batch jobs for loading database tables from Flat Files using SQL*Loader.

• Spooling out the data in the .dat format.

• Defect fixing according to Clients requirement and mapping document.

• Knowledge transfers session to the new comers in the team.

• Analysis of System (Facets) Requirement.

• Involved in development and testing from offshore and onsite.

• Built the workflow having interaction with database.

• Error handling related issues.

• Running of batch jobs using Tidal Services.

• Managed the reporting and Unit Testing activities (running the queries) of the team.

• Tuning the data and improved the performance of the application using Indexes.

• Successfully did the GO-Live for loading of the CVS data of 10 million records into the

Facets.

Environment: Oracle 11i, Rapid SQL 7.6.4, SQL Server Management Studio, PL/SQL, SQL *

Loader, SQL, UNIX shell scripting, MS Excel, Tidal Service

May’ 10 – November’ 11 Oracle Developer, CLICK SQUARED, Scottsdale, AZ

This project is intended to develop a customer data warehouse to understand customer behavior

to various Loans related programs and identify critical customers in support of improved

decision-making across the organization.

• Designed and developed the interface program to Import item master using SQL*Loader,

PL/SQL package and Import through Concurrent program.

• Involved in customization of Oracle Forms, Oracle Reports.

• Created views, procedures, and functions, packages in the Oracle Database using PL-

SQL, SQL/PLUS, and TOAD.

• Developed many complex reports using Oracle Reports 6i.

• Run batch jobs for loading database tables from Flat Files using SQL*Loader.

• Involved in the analysis of the existing database.

• Maintained and developed user requested features to a web based Warehouse Catering

System.

• The system allowed users to schedule, edit, and manage the corporation’s entire

upcoming warehouse catering events.

• Extensively used SQL Developer for database access and PL/SQL Development and SQL

tuning.

• Worked on SFTP to transfer files from remote server

• Developed Ad-hoc reports as per the requirement in Oracle Reports.

• Used HINTS to improve performance of the SQL.

• Optimized the queries to improve the performance of the application.

• Process payments automatically and manually in case of exceptions.

Environment: Oracle 10g, SQL * Loader, ERWIN, Oracle Reports 9i, SQL, PL/SQL, Toad,

UNIX shell scripting, Putty.

September ’09 – April ’10 Oracle Developer, Align Technology Inc., San Jose, CA

Align Technology Inc. is a global medical-device company that is involved in production of

Invisalign Tooth Aligners. The purpose of this project is to extract data from Operational

Systems in to the RDBMS and building new cubes using analysis services 2008. The project is

on creating a Data Mart and to develop reports to the client using Report SSRS.

• Responsible for writing SQL queries, Pl/SQL Procedures, Functions and Triggers.

• Created tables, indexes and sequences in Oracle

• Provided Production support for various batch processes and also created the schedule for

newly incorporated batch programs and processes.

• Extensively used Explain Plan, SQL Optimizers, Partitioning Tables, gather Statistics to

analyze and improve the performance of the Queries.

• Involved in Implementation of the application at the client site. During this tenure

involved actively in BUG fixing of the modules that are being implemented.

• SQL tuning using SQL Trace and TKPROF, explain plan and SQL Analyze.

• Managed the business relationships associated with reports delivery.

• Managed the reporting and unit testing activities of the team.

• Involved in uploading of reports into the web based Real-time Query servers.

• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.

Environment: Windows 2000/XP, HP-Unix 11.0, OA, Oracle 10g/9i, SQL, PL/SQL, UNIX

Shell script, Toad, SQL *Loader,Import, Export, SQL SERVER 2005/2007.

Dec ’06 – May ‘09 Oracle Developer, Microtech Solutions, Mumbai, India

The purpose of this project is to develop a Financial Application System in Oracle. The

application has been developed as an extension to the existing legacy system. Developed and

customized some of the main modules in the system like Customer and Accounts maintenance,

Interest and Tax Calculations, Other Banking Transactions and Calculations.

• Analyzed the Business requirements of the project by studying the Business Requirement

Specification document.

• Interact with business analysts to develop modeling techniques

• Developed E-Business Suite programs for databases supporting supply chain management,

order management

• Involved in database development by creating Oracle PL/SQL Functions, Procedures,

Triggers, Packages, Records and Collections.

• Run batch jobs for loading database tables from Flat Files using SQL*Loader.

• Designed and implemented the interfaces for Sales Order information from legacy system to

staging tables using SQL loader and wrote various procedures and function to perform

validations to populate the data in the tables.

• Customized and developed Oracle Forms and Reports using Oracle Forms 6i and Reports 6i.

• Created Records, Tables, Objects, Collections (Nested Tables) and Error Handling.

• Created number of database Triggers using PL/SQL.

• Involved in Performance Tuning.

• Creation of database objects like Tables, Views, Procedures, Packages using Oracle tools

like PL/SQL, SQL*Plus, SQL*Loader.

Environment: Oracle 9i, SQL, PL/SQL, Oracle Forms 6i, Reports 6i, TOAD, SQL*Plus, UNIX

December ‘05 – November ’06 Oracle PL/SQL Developer, Hewlett Packard, Mumbai,

India

This project was part of HP's Supply Chain portfolio. The Object of this project is to design a

OLAP solution which would provide ad-hoc, dashboard reporting, capability to view Supply

chains order and shipment data along with Finance data. To combine Sales order, Customer

information with pipeline and Account data, End to End Dash Board and to generate user

interface that would provide HP’s pipeline information.

• Involved in analysis, design, development, and testing of the application.

• Used FTP/Telnet to transfer .rdf files from UNIX box onto local machine.

• Developed PL/SQL batch processing jobs using UNIX Shell scripting.

• Involved in writing PL/SQL, stored procedures/packages, triggers, constraints,

cursors, views and indexes using TOAD.

• Used forms and Reports 6i that would meet the needs of users and that show the

Monthly transactions.

• Worked on Relational Databases in Oracle.

• Worked on Data Backup and Data Recovery using RMAN.

• Generated Paper Layout and Web Layout reports with the html template of the

site using Oracle Reports 6i.

• Hands on experience in using database designing tools like Erwin and

PowerBuilder.

• Strong knowledge in using views, Materialized views, Export and Import Utilities

provided in Oracle TOAD.

• Performed data load and unload tasks using the APEX utilities.

• Experience in Dynamic SQL, Records, Arrays and Exception Handling.

• Proficiency in understanding clients needs and generate, modify reports existing

in Oracle Applications according to the requirements and specifications.

• Experienced in using Oracle Utility programs like SQL*Loader and External

Tables.

• Used JDBC to Connect Java Applications to Oracle Database.

• Worked on EJB and deployed them on Web Logic and Sun Server

• Extensively involved in performance tuning for various oracle based application

using various methods like EXPLAIN PLAN, TKPROF etc.

• Experienced in Tuning SQL statements and procedures for enhancing the load

performance in various schemas across databases.

Environment: Oracle 8i, SQL PLUS, PL/ SQL, SQL*Loader, Java, J2EE, JDBC, XML, Korn Shell

Scripts, FORMS & REPORTS, SQL Navigator, Windows XP, MS-Excel.

Contact this candidate