SUMMARY:

• 15 years of IT Experience as Oracle and SQL Server developer for system development and implementation of Oracle 8i, 9i, 10g, 11g and SQL Server 2008 and 2005.
• Created database objects like tables, views, sequences, synonyms, indexes, integrity constraint and database triggers using programming tools like SQL*Plus, SQL Developer, PL/SQL Developer, Toad and SQL Server Management Studio.
• Expert in creating SQL Queries, PL/SQL packages, functions, stored procedures and cursors.
• Expert in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables, Dynamic SQL and Exception handling .
• Experience in SQL tuning and query optimization.
• Experience in working a variety of analytical functions.
• Extensively used of ETL for loading flat files and other data formats, loading validation end error capturin g.
• Extensive experience in writing Linux shell script and Cron jobs. knowledge with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).

TECHNICAL SKILLS:

Databases: Oracle 8.x/9.x/10g/11g, MySQL 5.x, SQL Server 2008, 2005.

Programming Languages: SQL, PL/SQL, T - SQL, Shell Scripting, PHP.

ETL: SQL Loader, External Table.

Operating Systems: Windows, UNIX, Linux.

Web Languages: HTML, XML, JavaScript.

Tools: SQL Developer, PL/SQL Developer, TOAD, SQL Server Management Studio (SSMT).

Knowledge: Logical/ Physical Data Modeling, SQL Server 2012, core java.

EXPERIENCE:

Confidential, Sterling, VA

Oracle/ SQL Server Developer

Environment: Oracle 11g, PL/SQL, SQL Server 2008,, PL/SQL Developer, SQL Loader, SSMT, Windows, Linux.

Responsibilities:

• Worked on Inventory System where some of the tasks accomplished by this system include the ability to create inventory parts definitions, stocking locations, ability to retrieve availability information and purchase orders.
• I involved in development of database dictionary, back-end logic for Inventory System database through designing and implementing of tables, views, stored procedures and packages. Responsible of SQL and PL/SQL performance tuning.
• SQL-Developer for review and deploy DML/DDL scripts for the creation of tables, indexes and constraints, aggregate functions, and case statements.
• Oracle PL/SQL using cursors, for, next and open fetch loops, select into, raise application error, autonomous transactions, dynamic SQL and SQL Loader for loading flat files into oracle tables and validating loaded data.
• Implementing of Call-Support .NET web-based system database (hardware and software accidents tracking system).
• Responsible for writing queries for necessary requirements, SQL Server procedures, triggers, views, report generation, testing, and optimization and performing query optimization using SQL Server 2008.

Confidential, Gaithersburg, MD

PL/SQL Developer

Environment: Oracle 11g, SQL, PL/SQL, SQL-Developer, Linux, Shell Scripting.

Responsibilities:

• Worked on development and maintaining of the Medicaid Enterprise Restructuring Project (MEPR) system for the sake of DHMH with tasks of: Supporting the application team with PL/SQL functions procedures and packages.
• Participating in code review and unit testing. Responsible of performance tuning of SQL and PL/SQL code and code reviewing.
• Utilizing Oracle SQL-PL/SQL for writing DML/DDL scripts, cursors, for, next and open fetch loops, select into, raise application error, pragma exception, autonomous transactions and case statements, aggregate functions and dynamic SQL.

Confidential, Germantown, MD

Oracle PL/SQL Developer

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, PL/SQL-Developer, Shell Scripting, ETL.

Responsibilities:

• Designing of data mapping for the NH-DOT Toll Road System.
• Used SQL* Loader for loading flat files into oracle tables.
• Developed validation scripts for the loading process using shell script.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Developed PL/SQL procedures, SQL* ad-hoc reports for the Toll System loading process.
• Responsible of performance improvement for the load process and optimized the SQL queries for performance improvement. Apart from that used the collection, BULK Collect /FORALL and other method to enhance the performance.

Confidential

SQL Server Developer

Environment: SQL Server 2008, SSMT, Windows.

Responsibilities:

• Participated in development the of Auto Process .NET web system database (IT services management system that involved in setting control and governance on the business processes).
• Translating physical data models, implementing database dictionary for Auto Process System through designing, implementing and updating tables, views, triggers, stored procedures and development of multi-functioned, leveled and grouped, summary functionality reports. Involved in performance tuning and testing using SQL Server 2008.

Confidential, Vienna, VA

Oracle PL/SQL Developer

Environment: Oracle 10g, SQL, PL/SQL, Toad, PL/SQL-Developer, Windows, UNIX.

Responsibilities:

• Simplified the company’s HR processes and reduced amount of time that it takes to do many routine tasks by developing of back-end logic for HR System and SQL* ad-hoc reports.
• Responsible of performance tuning of SQL and PL/SQL code and code reviewing.
• Saved company’s money through designing and development database dictionary, back-end logic for Refuel System.
• The system used to document and control company’s sites refueling operations using Oracle and PL/SQL.
• Toad and Oracle PL/SQL-Developer: DML/DDL scripts for the creation of tables, indexes constraints, aggregate functions, and case statements.
• Oracle PL/SQL using cursors, for, next and open fetch loops, select into, raise application error, autonomous transactions and dynamic SQL.

Confidential

Oracle\ SQL Server Developer

Environment: Oracle, PL/SQL, SQL Server 2005, PL/SQL Developer, SSMT, Windows, UNIX.

Responsibilities:

• Developed scripts for data loading flat files from SQL Server to Oracle 10g.
• Developed the database of the Site Info, a company specific system, that collect information, creates reports and statistics using data drawn from the company’s sites across the country, generates information regarding: subscribers’ growth according to region, the quality of services, the loaded areas.
• Responsibilities were supporting the .NET team with procedures, functions and views using SQL Server-2005.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 8i, 10g, SQL, PL/SQL, PL/SQL-Developer, Windows, UNIX.

Responsibilities:

• Reduced company’s independency on paper work by 100% through participating in designing, development of Payroll System using Oracle SQL, PL/SQL.
• Maintained Sales System Data Dictionary using Oracle SQL/ PL/SQL.
• Reduced company’s independency on paper work by 100% through designing, development of Assets System using Oracle SQL, PL/SQL.
• Migrated DB tables from Oracle 8i to Oracle 10g and altered tables with new data types.