SUMMARY

• 6+ years of experience in analysis, design, Application Development and production support using Oracle SQL, PL/SQL, and Developer Forms and Reports.
• Proficient in writing Packages, Stored Procedures, Cursors, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
• Data modeling and Design using Erwin and MS Visio.
• Comfortable working with Testing, Debugging, and Deployment of Applications.
• Working knowledge of Unix Shell Scripting and Remedy.
• Experience in bulk data loading using oracle utilities namely SQL Loader and external tables.
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Knowledge of Extraction, Transformation and Loading (ETL) process to load the database.
• Used DBMS PROFILER package which enables the collection of profiler (performance) data for performance improvement.
• Experience using TOAD, SQL Navigator under UNIX and Windows NT/2000/XP/Vista
• Good Communication and Interpersonal Skills, resulting in excellent rapport with employees and executive management.
• Competitive analytical, logical, and problem solving skills.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/ 9i, MS SQL Server 2005, MS Access, MS SQL, DB2

Languages: SQL, PL/SQL, C, C++, Java, ASP, .NET, Javascript, HTML, UNIX Shell Scripting

Operating Systems: Windows 98/ 2000/ XP/ 7, UNIX

Tools: TOAD, ERWIN, SQL *Plus, SQL *Loader, MS Office, MS Visio, WinSCP, ZOC SSH Client

PROFESSIONAL EXPERIENCE

Confidential, Freeport, NY

Responsibilities:

• Studied user requirements and functional specifications. Converted the user specifications into formal functional specification and interfacing with the client.
• Involved in technical documentation of user manuals for the end user.
• Involved in creating database objects like tables, views, procedures, functions and packages using oracle.
• Created cursors and referential cursors as a part of the procedure to retrieve the selected data.
• Fine - tuned procedures for the maximum efficiency in various schemas across databases using oracle hints, explain plan and trace sessions for cost based optimizations/.
• Written complex SQLs using joins, sub-queries and correlated sub-queries.
• Handled errors using system defined exceptions and user-defined exceptions.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Loaded the data into database tables using SQL *Loader from text and excel files.
• Developed SQL scripts for referential integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Involved in creating indexes to avoid the need for large-table, full-table scans and disk sorts, and for fast retrieval of data from database objects.
• Assisted the DBA in migration of the database from 10g to 11g and making the necessary changes to the UNIX scripts and job scheduler.

Environment: Oracle 11g/10g, SQL Navigator, SQL*PLUS, SQL*Loader, UNIX Shell Scripting, WinSCP, ZOC SSH Client

Oracle Developer

Confidential, Omaha, NE

Responsibilities:

• Create procedures and functions to automate the processes such as index rebuilds and partition management (Add, Drop, and Split & Merge Partitions).
• Created SQL scripts to monitor Daily load processes (complete/Incomplete loads, Time of completion, unusable indexes after the completion of loads).
• Implemented Security by creating different Users, and assigning Roles & Privileges to the Users.
• Worked on sizing of different schemas and created tables, indexes, views and synonyms as well as custom packages tailored to business requirements.
• Created Data models in Erwin and Visio.
• Wrote SQL scripts for reports as requested by the End users.
• Designed and implemented the Transaction log management tables and wrote procedures to show the details of product/user usage.
• Used Partitioning (Range & Hash) and Bulking techniques to improve performance while accessing large tables.
• Created billing scripts to provide an estimation of cost to Confidential clients for the product usage.
• Maintained a data dictionary of database objects.
• Created UNIX Shell scripts and PL/SQL scripts to publish data to relevant databases and log the process output.
• Worked with the DBAs and AIX Service Delivery Team to identify CPU usage peaks, monitored CPU idle time, identified contention issues, investigated the I/O waits and tuned the application and queries causing that issue.
• Created scripts to monitor table and index space usages to effectively manage the tablespaces.
• Designed and tuned custom queries for Confidential clients for data analysis using materialized views, correlated and sub queries.
• Performed production support functions - incident requests and defect reporting.

Environment: Erwin v4.1, Oracle 9i/10g, MS Access, One Administrator v7.0, Brio Intelligence v6.6, Toad v9.6, SQL*PLUS, SQL*Loader, MS office suite, AIX, PCVS, Unix Shell Scripting.

Oracle Developer

Confidential, Hoffman Estates, IL

Responsibilities:

• Analyzed business requirements, data flows & existing processes and created use case diagrams, system functional designs, and design specifications
• Designed logical and physical database models using ERWIN Data Modeling tool
• Created database objects such as tables, indexes, synonyms, sequences, packages, procedures, functions, contexts and triggers to implement complex business rules & integrity constraints
• Conducted data analysis to identify issues and devised an ETL process for conversion of data from legacy systems
• Created Triggers to log details of transactions for database administration.
• Created materialized views and complex join SQL queries for report generation for customer details
• Designed automation for batch job schedules, event & error logging and email reporting mechanism
• Performed the uploading and downloading flat files & jar files from AIX server using FTP.
• Enhanced application performance by 25% indexes, partitions, bulk bind techniques and explain plan
• Automated data loading, extraction, and error checking and report generation using UNIX Shell Scripting.
• Written Control Files for Loading ASCII/Flat files to upload bulk data using SQL * Loader
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Automated DBA jobs, and Oracle processes using crontab utility
• Detected and corrected bugs during unit, system integration and user acceptance testing
• Created testing and technical documentation
• Provided post deployment support to enhance, optimize and fix problems

Environment: Eclipse 3.2, Tomcat 5.5, Sun one Web server, HTML, XML, Oracle 10g, Toad v9.6, SQL*PLUS, SQL*Loader, MS office suite, AIX, Solaris, Erwin Data Modeling Tool, EDW, Visio, CVS, Unix Shell Scripting, ERWIN.

Oracle Developer

Confidential, Corona, CA

Responsibilities:

• Involved in requirements analysis, design and development of the system.
• The project involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Extensively used PL/SQL features such as procedures stored procedures, functions, packages & database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Loaded data from flat files into database tables using SQL* loader.
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Developed stored procedures, functions and packages for updating, inserting and deleting data from the tables
• Developed forms, menus, Object libraries and PL/SQL libraries using Oracle Forms 9i.
• Used Oracle Reports 9i to develop daily, weekly and monthly reports for customer details, products supplied, inventory information and details of customer complaints.
• Worked on SAS to deploy various reports
• Created Unix shell scripts to automate the batch jobs and perform error checking
• Worked on Business Objects (BO) to deploy various reports
• Involved in Unit level testing, Module level testing and System level testing.
• Documented the whole process flow, PL/SQL Packages, log files, locations and description, log tables and possible error messages, process codes and description.
• Detected and corrected bugs during system integration and user acceptance testing.

Environment: Oracle 9i/10g, SQL, PL/SQL, SQL*Loader, Forms 9i, Reports 9i, MS Visio, SAS, UNIX Shell Scripting.

Oracle Developer

Confidential, Springfield, VA

Responsibilities:

• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Designed and Created E-R diagrams for the entire process along with flowcharts using MS-Visio.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business rules that call for appropriate writing and deleting records from respective tables.
• Implemented the Referential Integrity constraints through different check constraints and triggers.
• Worked with driver command script on windows that will invoke Oracle stored procedures.
• Implemented Security by creating different Users, and assigning Roles to Users.
• Involved in developing Forms, Menus, Object Libraries, and PL/SQL Library & Reports using Oracle Forms Developer 6i.
• Conducted extensive performance tuning using TKPROF, EXPLAINS PLAN, and DBMS PROFILER.
• Used Partitioning technique to further improve the performance.
• Involved in developing various UNIX Shell Scripts to automate the routine tasks.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Involved in Code Review, Code Walk Through, and Unit Testing.
• Involved in creation of Implementation and Testing Documentation.

Environment: Oracle 9i, Forms 6i, Reports 6i, Windows 98, UNIX, PL/SQL, SQL, SQL*PLUS, SQL Loader.