Experience Summary:

• Anwar is an Information Technology consultant and a Database Programmer/DBA. He has above 9 years of experience in IT Industry includes developing software application using n-tier & client-server architecture.

Expertise in Oracle Development and PL/SQL programming such as:

• Successfully performed multiple roles: Business Analyst, Data Modeler and Programmer/Application Analyst.
• Extensive experience in Oracle RDBMS 9i/10g, design and developing Stored Procedures/Packages, Triggers, Cursors using SQL and PL/SQL.
• Strong experience in design and build medium to large scale client-server and n-tier applications using, Developer 2000, Forms/ Reports 6i/10g, PL/SQL and Stored procedures.
• Extensively used the oracle new features like Ref cursors, bulk bind, For all, RMAN and AWR etc …
• Developed complex projects on Oracle with Developer 2000/6i (Forms 4.5/6i and Reports 2.5/6i).
• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects XI r3/XI r2/6.5.
• Rectified, Modified and enhanced the existing projects on Oracle Developer2000/6i.
• Tuned SQL statements, Forms and Reports.
• Performed Data Migrations using SQL*Loader and PL/SQL scripts, UNIX SHELL SCRIPTS. Developed SQL Program to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Experienced working on logical and physical data models using ERWIN 6.0
• Involved in various activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing.
• Established connectivity between front-end and back-end.
• Strong Analytical knowledge with database design and coding for performance.
• Strong Math Fundamentals with problem solving and analytical skills.

Proficient in Oracle Architecture / DBA activities such as:

• Installed Oracle 9i/10g/ Oracle Application R12.0.4 on Windows NT4.0/Unix.
• Performed/monitored Database Backup and Recovery.
• Have knowledge about RMAN (disaster recovery, time base recovery), backup and recovery, monitoring & tuning etc.
• Strong knowledge about physical and logical database.
• Expert in using Database Tool like Import/Export and SQL loader.
• Efficient in planning data storage parameters.
• Good understanding of Oracle Architecture.

Hardware:Sun Ultra 60 (Multi processor) and Netra (Quad Processor).

Languages:C, C++, FORTRAN, FoxPro, VB, SQL, PL/SQL, T-SQL, Shell Scripting and Java Script
Databases: Oracle 10g/9i/8i, MS Access, SQL, PL/SQL, MS-SQL Server.

• Oracle certified Professional (Development Track Forms 6i)
• Oracle DBA Certified Professional in 9i

Education:M.C.S (Masters of computer Sciences).

PROFESSIONAL EXPERIENCE

Project#1: Confidential,
Client: Confidential,Ok Duration: Mar09 to sep09
Title: Sr. Database Developer/DBA
Environment:Oracle 10g, PL/SQL (stored procedures, functions, packages, Cursor, triggers, etc), SQL*Plus, SQL*Net, SQL Loader, TOAD, Business Object XI r3/XI r2/6.5, Erwin, Import/Export, UNIX scripting (KORN shell, Bourne shell and SED etc) , Quality Center 8.0 and Visual Source Safe 6.0.
Team Size: 18

Conoco Phillips Company is an international energy (Oil and Gas) corporation with its headquarters located in Houston, Texas in the United States, and has offices located worldwide ( i.e. Canada, China, Norway and UK etc) . My main duties were to maintain existing applications as well as develop new applications according to the requirements.

Responsibilities:

• Created database triggers, cursors, procedures/functions and packages using PL/SQL.
• Written complex SQL (Sub queries and Join conditions), in PL/SQL. Experience in trace errors from Stored procedures/functions, Packages and fixed. Used TOAD & Benthic to check Explain plan and Tune fun/proc and Packages to improve the performance.
• Involved in performance tuning (SQL, PL/SQL) using oracle tools Explain Plan, TKPROF, auto trace, AWR etc.
• Create Sequences for automatic generation of voucher numbers and views for hiding.
• Developed universes in business Objects from the existing data warehouse system. Mapping the universe from its complexities into user understandable the data that involves in the project is coming from two different data sources.
• Developed complex desktop intelligence reports from Flat file (XML files, free hand quires, store procedures) and from different Universes in Business Object XI r3/XI r2/6.5.
• Converted Desktop intelligence reports into Webi and published them into different formats (Acrobat. EXL, word etc.) According to the user requirements.
• Analyze and escalate the reports to higher management.
• Design logical and physical data models using Erwin 6.0
• Worked with Senior DBA’s in installation of Oracle 9i, 10g and 11g on Windows Vista/NT/2000. Created Database Tables, Global Temporary Tables, Cluster Tables, Partition Tables and Index-by Tables.
• Create Indexes (Bitmap, Btree), DB Links, Snapshots/Materialize Views and add tablespaces (temporary TS, undo TS).
• Create/drop users, grant/revoke rights as and when required.
• Involved in periodic imports and exports of Database for the backups
• Oracle Database Administration on 24x7 critical production and large databases(4TB) using Oracle 11g, 10g & 9i
• Developed Unix Shell scripts to automate repetitive database tasks.

Project#2: Confidential,
Client: Confidential,Duration: Dec07 to Jan09
Title: Sr. Database Developer/DBA
Environment:Oracle 10g, PL/SQL (stored procedures, functions, packages, Cursor, triggers, etc), SQL*Plus, SQL*Net, SQL Loader, TOAD, Business Object XI r2/6.5, Erwin, Import/Export, UNIX scripting (KORN shell, Bourne shell and SED etc) , Quality Center 8.0 and Visual Source Safe 6.0.
Team Size: 18

Sprint Communications is a leading Internet provider in USA. Sprint had multiple projects and my main duties were to maintain existing Commission application for the Wal-Mart client as well as develop new applications according to the requirements.

Responsibilities:

• Created database triggers, cursors, procedures/functions and packages using PL/SQL. Experience in trace errors from Stored procedures/functions, Packages and fixed. Used TOAD & Benthic to check Explain plan and Tune fun/proc and Packages to improve the performance.
• Involved in performance tuning (SQL, PL/SQL) using oracle tools Explain Plan, TKPROF, auto trace, AWR etc. Create Sequences for automatic generation of voucher numbers and views for hiding.
• Extensively written PL/SQL scripts to extract the meta data from flat files to a specific format and insert into Oracle database using SQL*loader.
• Developed universes in business Objects from the existing data warehouse system. Mapping the universe from its complexities into user understandable the data that involves in the project is coming from two different data sources.
• Development and deployment Business Objects XI r2/6.5 to create reports using multiple data providers, in accordance to the client needs.
• Use Business Objects to create reports containing complex charts to present the end users with a better graphical representation of the data.
• Used Business Objects report level functions like Alerts, Breaks, Customized filters to display relevant data
• Involved in production support by modifying and correcting production reports
• Design and Execute the DML queries using TOAD on target schemas.
• Design logical and physical data models using Erwin 6.0 Worked with Senior DBA’s in installation of Oracle 9i, 10g and 11g on Windows Vista/NT/2000. Created Database Tables, Global Temporary Tables, Cluster Tables, Partition Tables and Index-by Tables.
• Create Indexes (Bitmap, Btree), DB Links, Snapshots/Materialize Views and add tablespaces (temporary TS, undo TS).
• Create/drop users, grant/revoke rights as and when required. Involved in periodic imports and exports of Database for the backups
• Oracle Databases Administration on 24x7 critical production applications running on Oracle 11g, 10g & 9i.
• Developed Unix Shell scripts to automate repetitive database tasks.

Project #3:
Client:Confidential,San Ramon, CA Duration: Jan07 to Dec07
Title: Sr. Database Developer/DBA
Environment: Oracle 10g, PL/SQL (stored procedures, functions, packages, Cursor, triggers, etc), SQL*Plus, SQL*Net, SQL Loader, TOAD, Erwin, Import/Export, UNIX scripting (KORN shell, Bourne shell and SED etc) , Quality Center 8.0 and Visual Source Safe 6.0.
Team Size: 15

This company is related to internet. My main duties were to maintain the existing projects and to develop the new projects according to the requirement.

Responsibilities:

• Created database triggers, cursors, procedures/functions and packages using PL/SQL. Written complex SQL (Sub queries and Join conditions), in PL/SQL. experience in trace errors from Stored procedures/functions, Packages and fixed. Used TOAD & Benthic to check Explain plan and Tune fun/proc and Packages to improve the performance.
• Involved in performance tuning (SQL, PL/SQL) using oracle tools Explain Plan, TKPROF, auto trace, AWR etc. Worked on creation of Sequences for automatic generation of voucher numbers and views for hiding. Involved in generated work plans, and developed complex matrix reports.
• Design logical and physical data models using Erwin 6.0 Worked with Senior DBA’s in installation of Oracle 9i, 10g and 11g on Windows Vista/NT/2000. Create Database Tables, Global Temporary Tables, Cluster Tables, Partition Tables, and Index-by Tables.
• Create Indexes (Bitmap ,Btree), DB Links, Snapshots/Materialize Views and add tablespaces (temporary TS, undo TS).
• Create/drop users and grant/revoke rights as and when required. Import/Export data from/to different databases using utilities like SQL*Loader, Import/Export.
• Oracle Database Administration on 24x7 critical production and large DB over 4TB using Oracle 11g, 10g & 9i.
• Developed Unix Shell scripts to automate repetitive database tasks.

Project #4:

Client: Confidential,Wilsonville, OR Duration: Feb-06 to Dec-06
Title: Sr. Database Developer/DBA
Environment: Oracle 10g, PL/SQL (stored procedures, functions, packages, Cursor, triggers, etc), forms4.5/6i,10g, Reports6i/10g,SQL*Plus, SQL*Net, SQL Loader, TOAD, Erwin, Import/Export, UNIX scripting (KORN shell, Bourne shell and SED etc) , Quality Center 8.0 and Visual Source Safe 6.0.
Team Size: 10

Worked on data conversion project to convert Oracle 4.5 forms to Oracle 6i forms and participate in new development.

Responsibilities:

• Developed forms and reports.
• Created tables, indexes, sequences, constraints and snapshots.
• Developing packages and stored procedures using PL/SQL.
• Designed and developed system using Oracle Forms, Reports and PL/SQL.
• Developed GUI Screens( Forms and Reports) using Forms 6i and Reports 6i.
• Developed Reports as per Client Requirement.
• Extensively used stored procedures, functions and database triggers.
• Used import / export data.
• Performed development DBA activities like monitoring, identifying, estimating used & free space of data and index tablespaces, create needed indexes, synonyms, partitioned tables and security views.
• Tune PL/SQL programs using TKPROF and accelerated performance of refreshing data warehouses
• Performed code reviews as well as optimized code for better performance.
• Responsible for understanding, changes in business functionalities, add new elements in tables and accordingly enhancing PL/SQL stored procedures and triggers.
• Responsible for performing quality assurance, data analysis and unit testing.
• Remained on call for 24x7 to support scheduled jobs in production data warehouses
• Migrated entire project from Development to Test and Production environment

Project #5: Equity data management system

Client: Confidential,Chicago, IL. Duration: Feb05 to Jan06
Title: Oracle Developer/DBA
Environment: Oracle 10g, PL/SQL (stored procedures, functions, packages, Cursor, triggers, etc), SQL*Plus, forms4.5/6i/10g, Reports6i/10g, SQL*Net, SQL Loader, TOAD, Erwin, Import/Export, UNIX scripting (KORN shell, Bourne shell and SED etc) , Quality Center 8.0 and Visual Source Safe 6.0.
Team Size: 12
Automated a Property Registration System for Equity Office Properties Trust. Main responsibilities were to maintain data according to the states, cities, counties etc.
Responsibilities:

• Designed and developed system using Oracle Forms, Reports and PL/SQL.
• Created PL/SQL, Stored Procedures, Functions and created several database triggers for implementing integrity constraints.
• Developed GUI Screens and Reports using Forms 6i and Reports 6i.
• Wrote SQL statements, SQL Query tuning, views, cursors, schemas and PL/SQL code. Created SQL*plus reports as per client\'s various needs, and developed business objects. Involved in creating package, external and stored procedures and database triggers.
• Developed Reports(tabular, group above, group left, Matrix ) as per Client Requirement.
• Done the documentation, moved the code to production and provided on-site production support.
• Saved database space and reduced network traffic by creating temporary global tables in PL/SQL stored procedures and packages to hold runtime information
• Preparing Technical Documentation.
• Wrote SQL Scripts for reports and creating views for reports.
• Wrote triggers on tables for improving the performance.
• Performed SQL & PL/SQL tuning
• Used RAISE_APPLICATION_ERROR, PRAGMA EXCEPTION_INITto trap error messages.

Project #6: Healthcare management system

Client: Confidential,Owings Mills, MD. Duration: Aug04 to Jan05
Title: Oracle Developer/DBA
Environment: Oracle 10g, PL/SQL (stored procedures, functions, packages, Cursor, triggers, etc), SQL*Plus, forms4.5/6, reports6, SQL*Net, SQL Loader, TOAD, Erwin, Import/Export, UNIX scripting (KORN shell, Bourne shell and SED etc) , Quality Center 8.0 and Visual Source Safe 6.0.
Team Size: 18
Care First is a Healthcare company. The primary function is to support existing production project and to develop new phase of this project,

Responsibilities:

• Involved in creating database objects, database security and database tuning.
• Design and Development of PL/SQL Packages, Procedures and Functions.
• Data Conversion using SQL*Loader and PL/SQL.
• Tuning the SQL and the PL/SQL Procedures.Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Wrote SQL statements, SQL Query tuning, views, cursors, schemas and PL/SQL code. Created SQL*plus reports as per client\'s various needs, and developed business objects. . Involved in creating package, external and stored procedures and database triggers.