SUMMARY

• Around 6 years of experience in the field of Software Design, Development, Implementation with proficiency in Oracle 8i/9i/10g/11g, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Worked with query tools like TOAD, SQL*Plus, SQL Developer.
• Created ER Diagrams on Erwin using Normalization techniques.
• Exposure to concepts of Data warehouse like Design, Data Modeling, OLTP, ETL.
• Have knowledge and understanding of Database Architecture and Concepts.
• Experience in data migration from legacy system to Oracle RDBMS.
• Proficiency in relational databases (RDBMS), data modeling and in building Data Warehouse Data Marts using Star Schema and Snowflake Schema.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning and Optimization of SQL statements.
• Extensively worked in Oracle database environments of up to 10 terabytes in size including large data sets and partitioned data.
• Experience in identifying Business requirements, Technical requirements, Database Design and writing interfaces between various applications. Created materialized views like primary key, row id and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries.
• Domain knowledge in utilities, CRM, banking systems.
• Involved in Migrating Database from text files to Oracle database using SQL * Loaders.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work environment.

TECHNICAL SKILLS

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

Languages: C, C++, Java, SQL, PL/SQL

Tools: ANSI SQL, SQL *PLUS, TOAD, iSQL *PLUS, SQL *LoaderSQL Developer, Eclipse, Visual studio

Scripting Languages: Java Script, UNIX Scripting

Web Technologies: HTML, CSS

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Oracle PL/SQL Developer

Responsibilities:

• Written DDL scripts to create and update objects like tables, views, indexes, triggers, synonyms and sequences.
• Used SQL*Loader scripts to load legacy data into test environment.
• Written Stored Procedures and Functions to perform complex calculations like currency conversion.
• Written procedures to populate missing interval data for multiple data sets with default data.
• Written procedures, which get triggered periodically by the event manager to perform various tasks like market gate open and close, refreshing the registration data to snapshot view to be consumed by daily transaction processing system.
• Written complex views combining multiple tables to show on the market operator displays.
• Performed SQL Tuning using SQL Trace Explain Plan for better performance.
• Used various SQL Expressions and Conditions in standalone procedures and functions.
• Used Smart File Transfer Protocol (FTP) tool to transfer market reports to external sub systems.
• Written procedures to generate different reports for participants, contacts, users and unit data sets.
• Written procedures to transfer the settlement ready data to external sub system.
• Wrote complex SQL scripts and was responsible for performance tuning of SQL queries.
• Created Unit Test plans and involved in primary unit testing.
• Responsible for the development and maintenance of end - user documentation.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer, UNIX

Confidential, DC

Oracle Developer

Responsibilities:

• Involved in gathering requirements as SME for Oracle migration and New Estimation system projects.
• Involved in the logical and physical modeling using Erwin.
• Involved in creating specification documents, mapping documents, data flow diagrams, ER diagrams, dependency documents.
• Developed UNIX shell scripts.
• Worked on table partitioning (Range) and deploying various methods of indexing like local indexes on partitioned tables.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created Pl/SQL Tables, Record Types, Indexes on tables to improve performance.
• Extensively worked on Cursors, ref Cursors, Nested Conditional Statements, Co-Related sub-queries, DB Links.
• Worked extensively in PL/SQL and developed complex packages, procedures and functions using SQL Developer as well as SQL PLUS.
• Performed Database Tuning - SQL Tuning using Oracle’s regular performance tuning methods like Explain Plan, SQL*Trace, TKPROF, ADDM and AWR.
• Migrated the data from Excel sheets, text files into the respective Oracle Database tables using SQL *Loader scripts.
• Identified potential inefficient queries using Explain Plan and worked on Performance Tuning using hints.
• Involved in intensive Unit Testing and in writing Test plan document for QA.
• Made use of DML triggers for updating sequences.
• Worked with large tables and databases which are sized in terabytes.
• Involved in User Acceptance Testing also involved in various other test efforts in a data warehouse environment like data validation, data integrity, functional testing, integration testing and system testing.

Environment: Oracle 10g, SQL, PL/SQL, SQL*PLUS, TOAD, UNIX

Confidential, SAN DIEGO, CA

Oracle Developer

Responsibilities:

• Involved in gathering requirements as GME for ONSTAR module, enhancement in phase 3 dealerization methodologies like NCOA and redealerization (sales and service dealers)
• Was involved in development of logical as well as physical data model for enhancements in Clarify (Visiting Owner).
• Designed technical specification document and developed ONSTAR process for GM which involves preferred dealer, recalculating due dates and Vehicle Data Analytics etc.
• Developed jobs to maintain and automate various source feeds using oracle10g, PL/SQL, SQL *Loader, Unix Shell scripts
• Created SQL*Loader scripts to load data to Oracle staging tables.
• Worked extensively in PL-SQL and developed complex packages, procedures and functions using TOAD as well as SQL PLUS.
• Developed PL/SQL batch jobs using collections/Dynamic SQL
• Triggers have been used for processing bulk transactions at a time for efficient performance.
• Supported development effort by providing SQL statement tuning and optimizing procedures and removing load and query performance bottlenecks by using utilities and tools like Explain Plan, SQL Trace, TKPROF, and TOAD.
• Worked on Snapshot creation, Work Load Generation and Tuning with StatsPack and ADDM.
• Gathered Optimizer Statistics using DBMS STATS for Cost Based Optimization, and used Optimizer Hints with SQL statements to Alter Execution Plan.
• Worked extensively on creating Clusters and Indexes
• Creating the Bit Map Indexes for the fast accessing of OLAP queries.
• Created PL/SQL Tables, Record Types, Indexes on tables to improve performance
• Extensively worked on Cursors, ref Cursors, Nested Conditional Statements, Co-Related sub-queries, DB Links
• Assisted in identification and resolution of application issues.
• Developed Unix Shell scripts to automate repetitive database processes.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in intensive Unit Testing and in writing Test plan document for QA.

Environment: Oracle 9i, windows XP, Toad, Erwin, SQL Loader, SQL Developer, Unix scripting.

Confidential, Stamford, Connecticut

Oracle PL/SQL Developer

Responsibilities:

• Developed, Tested and Tuned stored procedures and packages for the CRM re-engineering project.
• Coded and debugged triggers
• Involved in tuning existing SQL queries for better performance.
• Handled large databases and created Ad-Hoc SQL queries for data manipulation and data fixes.
• Developed PL/SQL procedures that handle key business logic
• Created procedures using dynamic PL/SQL
• Migrated Data from MS Access to Oracle.
• Wrote PL/SQL procedures, packages, functions and triggers.
• Developed database triggers which check the data integrity.
• Coordinated with first level production support team for executing SQL scripts and creating new objects,
• Developed UNIX Shell scripts.
• Wrote UNIX shell scripts to download files from the server and to decrypt the flat files that were downloaded.
• In corporate the SQL*Loader scripts into the UNIX shell scripts to read the data from the decrypted file and loaded the data into staging tables.
• Wrote new Procedures, which are triggered by UNIX shell script to process the staging data and do the required process.
• Involved in Unit Testing.

Environment: Oracle 9i, UNIX, WINDOWS XP, Shell Scripting, TOAD, PL/SQL developer.