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
• Bachelors in Computers Engineering

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, Confidential,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, Confidential,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, Confidential,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, Confidential,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, Confidential,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.