SUMMARY

• Over 8 years of development experienceas an Oracle PL/SQL Developer in Analysis,Design and Implementation of Business Applications using Oracle Relational Database Management System(RDBMS);
• Strong experience in translating business requirements into creation of Database Objects;
• Strong experience in writing Complex Database Objects like Stored Procedures,Functions,Cursors,Triggers and Database Administration;
• Strong experience in SDLC including Water fall and Agile Scrum environments in Data Migration projects in government sectors;
• Experience inClient - Server application development using Oracle 11g/10g/9i,PL/SQL,SQL*PLUS,TOAD AND SQL DEVELOPER;
• Experience in working all the stages of Data Migration;
• Worked extensively on Ref Cursor,External Tables and Global Temporary Tables;
• Experience in Dynamic SQL,Exception handlingand Analytical Functions;
• Experience in Indexing, Bulk Collection, Table Partitioning;
• Experience in Bulk Binding, VARRAYS, Nested Tables;
• Experience in data Normalization and data modeling using Rational Rose;
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB andRecords;
• Experience in migration of Data from Excel, Flat files to Oracle database tables using UTL FILE;
• Experience in handling DBA activities such as Granting Roles and Privileges and performance tuning;
• Experience in Developing and supportingWEB Applications using Java, JSP and Struts;
• Experience in Developing and supporting Crystal Reports;
• Good at using SCM tools such as SVNand Visual Source Safe;
• Knowledge of OBIEE 11gincluding installation on Windows 7/8;
• Knowledge in .NET(C#, VB.NET) and Visual Studio 2008;
• Excellent multi-tasking capabilities including multiple client interaction; and
• Excellent communication, analytical, interpersonal, presentation, project management skills and ability to work with minimum supervision in large and small teams.

TECHNICAL SKILLS

Operating Systems: Windows8/7/Vista/Server 2003/XP/2000/NT

RDBMS: Oracle 11g/10g/9i, MYSQL and MS Access

Database Tools: SQL Developer, Oracle Toad10g, OBIEE 11g,JDEVELOPER, SQL *PLUS and MY SQL

Reporting Tools: Crystal Reports

Data Modeling: Rational Rose and exposure to ER-Win

Graphic Editors: GIMP 2.4/2.6/2.8

Languages: SQL, PL/SQL,Java, JSP, Struts, Java Script, CSS, C++, C and PHP

Agile &PM: Rally for Agile Development and exposure to TFS

PROFESSIONAL EXPERIENCE

Confidential, Plano TX

ORACLE Database Designer and PL/SQLDeveloper

Responsibilities:

• Gathered requirements and designed normalized and de-normalized tables and relationships using agile methodology;
• Developed Database for VTOUCHBASE all the modules of the product such as Admin Manager,Campaign Manager,Menu Manager, Payment Manager and Template Manager;
• Designed Complex Database Objects,User Defined Functions,Stored Procedures and Triggers in SQL DEVELOPER 11g followed by analysis and testing those database objects before deployment to the server;
• Maintained Change Control and Release Management process for all database objects;
• Generated server side PL/SQL scripts for data manipulation and validation;
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL;
• Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart;
• Created indexes on the tables for faster retrieval of the data to enhance database performance;
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching;
• Loaded data using PL/SQL and UTL FILE package;
• Created External Tables as part of the file loading process to load tables;
• Extensively used bulk collection in PL/SQL objects for improving the performance of the database;
• Involved in the continuous enhancements and fixing of problems;
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application;
• Set Physical Security of SQL DEVELOPER to prevent unauthorized users from accessing the servers;
• Research and validate OBIEE including installation on Windows 7/8;
• Worked in a team of 6 which includes Business Analyst, Data Architect, Database Developer and J2EE Developers.

Environment: SQL DEVELOPER 11g, J2EE, Weblogic12c, Windows XP/vista/7,Tomcat and Rally.

Confidential

Web Designer, Developer and PL/SQL Developer

Responsibilities:

• Involved in designing and developing About US, Services and Resources modules through CSS and JSP programming.
• Involved in designingthe images for the website.
• Gathered requirements and designed normalized and de-normalized tables and relationships using agile methodology.
• Created scripts to create new tables, views, queries for new enhancement using ORACLE SQL DEVELOPER 11g.
• Writing complex stored procedures and User defined functions and enforced business rules via Checks and Constraints.
• Worked in a team of 3 which includes Data Architect, Database Developer and J2EE Developer.

Environment: ORACLE SQL DEVELOPER 11g,Windows Vista/7,J2EE and Rally.

Confidential, Denver, CO

Database Developer and Web Designer

Responsibilities:

• Developed the website for FOCUS organization.
• Designed, Developedand maintained database and the website www. Confidential .org
• Created scripts to create new tables, views, queries for new enhancement using MYSQL.
• Designed and created the images of the website.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created records, tables for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on converting MYSQL to ORACLE 10g;
• Coordinating post-implementation events such as testing.
• Worked as an individual with Business Analyst.

Environment: PHP, MYSQL, ORACLE 10gand Windows XP.