Professional Summary:
7 years of solid database experience on Oracle 10g/9i, PL/SQL, SQL*Loader, Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization.. Back-end programming experience using PL/SQL, SQL, T SQL, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes (B-tree Index, Bitmap Index), Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL. Expedition of Oracle 11g/10g/9i, MS Access. Data Cleansing experience using PL/SQL, SQL Coding, UNIX Shell scripting. Experience in working on Oracle Discoverer. Creating OLAP Worksheets, Modifying OLAP Worksheets. Knowledge of data modeling techniques includes virtually every flavor of Entity-Relationship (ER) modeling, Physical and Logical data modeling. Strong exposure in writing simple and complex SQL, PL/SQL Functions and Procedures, Packages, Triggers, Materialized views etc. Proficiency in using Analytical functions, UTL_FILE and DBMS_LOB packages. Experienced in environments requiring direct customer interaction during design specification, development, and acceptance testing and implementation phases. Proficiency in solving issues after an application release in production. Capable in leading a team by providing them direction, knowledge transfer and assistance in work. Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Ability to learn new technologies at rapid speed. Extensively usedOracledata warehousing features such as materialized views, bitmap indexes, Index Organized Tables, external tables etc. Hands on experienced in Tuning SQL Statements using Execution Plan, HINTS, TKPROF and Procedures for enhancing the load performance in various schemas across databases. Expert in Database Optimization by making use of various Performance Tuning techniques. Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production. Ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member. Excellent written and oral communication skills with a result-oriented attitude. Proven ability to interface and coordinate with cross functional teams and cultures, analyze existing systems, wants and needs, design and implement database solutions. Education & Certification:
Master of Computer Science
OCP certification of Oracle
Business/Technical Skill:
Oracle 8i/9i/10g/11g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Erwin 3.5/4.0/4.1/7.1/7.2/7.3,, TOAD 7.6/8.0/9.1/9.5/10.1, MS SQL Server 2000/2005, Oracle Reports 9i/6i, Crystal Reports XI, XML, Unix Shell Scripting, CVS, PVCS, Windows 98/2000/XP, Windows 2000/2003 server, UNIX, LINUX, SUN Solaris, MS Office, MS Visio.
Projects Summary:
Confidential,NYC, NY Jan 2012 – Present PL/SQL Developer
Merrill Lynchis one of the world\'s leading financial management and advisory companies, providing financial advice and investment banking services. The aim of the project was to collect the data, understand the new data requirements and increasing overall performance as a part of performance tuning.
Responsibilities:
Managed and resolved design issues during development. Involved in application tuning of database by defining the indexes tuning SQL queries. Optimized and enhanced the existing procedures and SQL statements for the better performance. Used EXPLAIN PLAN, SQL TRACE, HINTS and TKPROF to tune SQL queries. Wrote SQL*Loader script file for reading data from text file and loading into oracle table. Used Export/Import utility for backup and transferring data from one database to another. Used UTL_FILE package to load the data from external files that is exported from Server. PL/SQL Database triggers to implement business rules. Created Test Cases, Technical Design Documents and Install Plans. Created indexes as a part of tuning. Worked with DBA on logical and physical data models. Making the Mapping documents for the SAP objects. Wrote the SQL scripts for extracting the OMS (oracle) data for migrating in to SAP. Used Cursors, Exception Handling, Throwing Exceptions, and Nested Loops, and also used the Pragma_Exception_Init in order to associate our own created error messages with the error codes. Tools & Technologies: Oracle 11g, PL/SQL, Ftp, Telnet, Toad 9.0.1.8, SQLPlus
Confidential,Plymouth, MI Feb 2011 – Dec 2011 PL/SQL Developer
Based in Detroit, Michigan and specializing in computer aided engineering (CAE), finite element analysis (FEA), training, staffing and software services. The aim of the project was to collect the data, understand the new data requirements and increasing overall performance as a part of performance tuning.
Responsibilities:
Gathered requirements from business users and performed analysis. Reviewed and Analyzed Business Specification Documents. Extensively involved in the requirement analysis, development, writing test cases, and unit testing. Designed and created Database objects. Used oracle discoverer for logical grouping of tables & views. Creating a new work book and open an existing workbook Created and Modified OLAP worksheets using IDS Analyzing and sharing data using Discoverer viewer. Wrote PL/SQL procedures and packages as per requirement. Implemented complex SQL queries. Created views for better performance. Performed indexes for faster access of tables. Worked on Materialized Views and Query Rewrite. Wrote scripts to merge data from one system to another system. Used SQL*Loader to load data from flat files (excel/access) to Oracle database. Explain plan to improve database performance. Involved extensively in the analysis and tuning of the Application code (SQL). Increased performance by fine-tuning PL/SQL Procedures. Wrote shell scripts for scheduling jobs. Used PVCS for source code configuration management. Assisted in testing and deployment of the application. Tools & Technologies: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, UNIX
Confidential,Richmond, VA Sept 2009 – Jan 2011
PL/SQL Developer
JPMorgan Chase & Co. is an Americanmultinational banking corporation ofsecurities,investmentsandretail. Thehedge fund unit of JPMorgan Chase is one of the largest hedge funds in the United States. The project aimed to gather various data and synthesize data into a centralized database.
Responsibilities:
Gathered and analyzed business requirements from end users. Worked with applications specialists to understand the new data requirements. Collaborated with the DBA in creating tables required for the application. Used oracle discoverer for run the query conformation. Get the time estimation from oracle discoverer. Building Execute Dash boards and BI Portals. Creating Rational Work Sheets Used SQL*loader to load the data from the files provided by the interfacing applications. Wrote high level specifications and detailed specifications. Used ETL software to extract, transform and load needed data. Performed staging, and cleansing on data per requirement. Wrote PL/SQL Stored Procedures, Functions, Packages to implement Business Rules. Trained analysts and developers in design tools and data modeling techniques. Extensively used SQL to create Insert programs for loading data. Modified existing procedures according to new enhancements. Performed data partitioning. Used explain plan to increase performance of SQL statements. Modified SQL statements to increase the overall performance as a part of performance tuning. Merged data from one database to another database. Documented every phase like Technical specifications, source to target mappings, data models (using Erwin), UAT (tests cases and results), and release notes. Migrated enhancement from appropriate Dev Area to Test Areas/prod Areas. Issued Grants to the business users for appropriate DM tables to design their Universes. Wrote UNIX shell scripts to load data. Interacted with production support team regarding production issues. Documented and transferred knowledge regarding the various projects. Attended meeting with business analyst to get new requirements for the application. Tools & Technologies: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, Erwin, UNIX, BODI
Confidential,NYC, NY March 2008 – Aug 2009
PL/SQL Developer
GEICO is anauto insurancecompany. It is a wholly owned subsidiary of Berkshire Hathawaythat as of 2007 provided coverage for more than 10 millionmotor vehiclesowned by more than 9 millionpolicyholders.
The Project was to build Data Warehouse and develop the Reports and to develop an Intranet Application that provides extensive reports.
Responsibilities:
Gathered and analyzed requirements from business users. Created database objects like tables, synonyms, sequences and views. Edited procedures and functions for improved business requirements. Used SQL Loader to load data into the database coming from Metavance and Standby Databases. Wrote complex PL/SQL packages for Customer Interfaces, Payment Interfaces and Broker Commissions for Oracle Applications. Used Materialized Views, Hints, SQL Trace / TkProf, Indexes for query tuning and optimizations. Used BULK COLLECT and External Tables for improving performance on the Enterprise Data Warehouse. Used ClearCase, ClearQuest, and SharePoint for defect creation/resolution, documentation, development tracking and Code repository. Worked with BOXI universe and Webi Reports along with Discoverer reports. Collaborated with Data Warehouse Architect in writing SQL scripts, Shell Programs, Data Flows, and more. Worked with Oracle Forms 6i and Reports 6i. Supported development, test and the production databases. Used SQL Developer and TOAD to develop code. Tools & Technologies:Oracle 9i, PL/SQL, PL/SQL, Forms 6i, Reports 6i, Shell scripts.
Confidential,Penfield– PA Dec 2006 – Feb 2008
Oracle Developer
Hertz Global Holdings Inc is an Americancar rentalcompany with international locations in 145 countries worldwide. The project was focused on gathering Marketing and Sales Data and loading it into Data mart for analysis by Sales managers.
Responsibilities:
Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation. Involved in Database Design and development. Worked on SQL*Loader to Extract, Load and Transform data from varied data sources like Flat files and Oracle. Performed Data Upload for all static tables using SQL*Loader. Used extensively Export/Import Utilities for performing logical backups and transferring data between other Applications. Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL. Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export. Performed Data Conversions and Data Cleansing. Worked on Packages to encapsulate procedures and functions. Dropped and recreated the indexes on tables for performance improvements. Provided 24X7 Production Support of multiple database systems deployed on UNIX and NT platforms. Designed and developed UNIX Shell Scripts to handle pre and post session processes. Created and executed Crontab jobs. Involved in writing test scripts, unit testing, system testing and documentation. Performed performance tuning on Production, QA and Development Servers. Tools & Technologies: Oracle 9i, PL/SQL, SQL, Forms 6i, Reports 6i, HP UNIX Shell Scripting, Developer 2000, Crontab
Confidential,China June 2005 – Nov 2006
Sr Consultant
SGCC is a government-owned enterprise approved by the State Council to conduct government authorized investment activities. SGCC was ranked the 8th in the Fortune Global 500 in 2010,seven ranks higher than 2009, and is the largest utility in the world. The aim for the project was to design, develop and implementation to improve business processes.
Responsibilities:
Reverse engineered database into Erwin repository. Designed and developed backend PL/SQL packages in database layer, stored procedures, functions and triggers using SQL*Plus. Created stored sub programs with dynamic SQL at both client and server side. Developed UNIX Shell Scripts and PL/SQL Procedures to extract and load data. Successfully developed complex queries, functions, store procedures and triggers using PL/SQL. Involved in table redesigning with implementation of partition table and partition indexes to make database faster and easier to maintain. Fine-tuned application logic for better performance. Tools & Technologies:
Oracle 8i, PL/SQL, SQL * Plus, SQL Navigator, Erwin 4.1, Oracle Designer 6i, Windows 2000