An Oracle Professional with 8 year’s experience in Systems Analysis, Design, Development, Testing and Implementation of application software.

• Developing client/server and multi-tiered applications using Oracle Database and PL/SQL on different platforms like Solaris, HP-UNIX and AIX.
• Very strong shell scripting skills on platforms like HP-UNIX, SOLARIS.
• Proficient in programming in Oracle 10g/9i/8.x using SQL, PL/SQL on HP-UNIX, SUN SOLARIS.
• Developed several PL/SQL Batch programs implementing transaction management using oracle features like SAVEPOINT, Rollback and Autonomous transaction on UNIX.
• Strong database concepts and experience on SQL, PL/SQL.
• Good understanding of server side programming (Stored Procedures, Stored Functions, and Database Triggers).
• Experience in creating Index, Views, complex Stored Procedures, appropriate functions and effective Triggers to facilitate efficient data manipulation and data consistency on HP-UNIX, SUN SOLARIS.
• Good exposure to entire Software Life cycle Phases (Feasibility, System studies, Design, Coding, Testing, Implementation and Maintenance).
• Good exposure on Data Modeling and Data analysis.
• Good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) model Methodologies.
• 1+ years of working Experience with OBI administration tool developing metadata repository and experience in working with Siebel/OBI answers, Siebel/OBI dashboards and Siebel/OBI Delivers.
• Having over Three years of strong ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center.
• Experience on tuning SQL queries with terabyte database.
• Experience in SAS Programming to generate the reports.
• Experience in Systems Programming and applications development using C, C++, Shell & Perl scripting.
• Huge experience on Ref cursor and Collections.
• Proficient in programming using SQL LOADER.
• Employed tools like TOAD, Oracle, SQL*Plus, SQL Navigator.

Technical Skills

Operating Systems

HP-UNIX, Sun Solaris, AIX, Windows 2003/XP/2000/NT.

Languages

C, C++, SQL, PL/SQL, SQL Server, Teradata, Data stage, HTML 4.0, XML.

Databases

Oracle 10g / 9i / 8i / 8/ 7x

Scripting

UNIX Shell Scripting, Basic Java script, Perl.

Primary tools and Utilities

PL/SQL Developer, PL/SQL, Toad, SQL Navigator, Vi Editor, SQL*Loader.

BI and ETL

OBIEE and Informatica Power Center 8.x.

Other Technologies

PVCS version manager, TKPROF, PVCS tracker, Auto sys, Control M, Clear case.

Other Skills

Requirements Analysis and Design, Code reviews, Testing, Production Support.

Confidential (Hopewell, New Jersey) November 2007 – Till date

Scope of the project: eDM application’s largest component is the base OC (Oracle clinical) piece. eDM represents the custom implementation based on the oracle clinical technology from oracle pharmaceutical application. The design of the application is a highly normalized structure, whereby the actual result data values for all entries are stored in a single table. The actual meaning and relations of the data are handled as third degree normalization. As such, the data model itself is very large and complex. 
Role: As a Senior Oracle PL/SQL Developer was responsible for:

• Written PL/SQL stored procedures and Triggers to retrieve relevant information from various tables into intermediate tables.
• Developed number of functions, which are used in the queries to develop reports.
• Worked on five plus terabytes database.
• Used dbms_job for scheduling the batch processes of procedures.
• Developed system test scripts, unit test scripts, detail design documents for the enhancements.
• Used Collections for efficient way to fetch data as well as SAS for generating Reports.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Wrote UNIX scripts and scheduled the jobs using Crontab utility.
• Wrote Perl and Shell scripts to improve the performance of application and reporting purpose.
• Written Perl scripts for bulk permission change for specific user.
• Tested stored procedures in different environments(DEV, UAT and PROD).
• Created materialized views and views for generating Warehouse Reports.
• Good Knowledge about Code of Federal Regulation (CFR).
• Knowledge about Case Report Form (CRF) of clinical Trial.
• Developed data Mappings between source systems and warehouse components.
• Used Informatica Power Center 8.1 for extraction, transformation and loading (ETL) of data in the Data Warehouse.
• Involved data Transfer from IBM Data stage to oracle 10g by using Informatica.
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup, Filter, Update Strategy, Stored Procedure, Router, Expression, Sql and Sorter.
• Worked on Informatica Power Center tool-Source analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer.
• Used simple to complex analytical SQL queries against the source databases to identify and analyze the authenticity of the data before importing to build the OBI repository. Laying out a strategy with senior management and technical team for building the metadata that presents the business model to support the business requirements.
• Identified the appropriate facts, metrics, hierarchies, and territories to structure the initial conceptual model of the business from the requirement documentation, the source and target schemas and the ER relationships to support the business reporting model and the lowest level of detail (Grain) and rollups drill mechanism.
• Involved and Interacted with the off shore team for the development of the enhancements.
• Attend NAVIGO Training for approach of CMM level 3 compliance.

Environment: Oracle 10g/9i, SQL, SQL Server,Teradata, Data stage, PL/SQL, TOAD, SQL Loader, AIX 5.2, Solaris 5.9, Unix Shell Script, Sed, Awk, SQL Navigator 5.0, PL/SQL Developer, Perl, SAS, Informatica Power Center 8.x, Oracle Business Intelligence suite (OBI EE 10.1.x).

Confidential (Duluth, GA) May 2007 – October 2007

Scope of the project: This is basically a Data warehousing Project. Electronic billing analytics (eBA) is a front end billing application that projects summary, usage data of each subscribers belonging to corporate accounts. This project involves in developing data layer for front-end application. Several Notifications were generated to send status of the cycle to maintenance teams.
Role: As a Senior Oracle PL/SQL Developer was responsible for:

• Involved in coding & designing of SQL, PL/SQL procedures and functions.
• Written PL/SQL stored procedures, functions and Packages for report generation.
• Created various types of views to project the data based on front end Requirement.
• PL/SQL coding for Exception Handling and Duplicate Data maintaining with three plus terabytes database.
• Written Stored Procedures with return type as Ref cursor that is easy to handle at front end Java coding.
• Writing SQL scripts to extract the data into a flat file from one server and transfer the data electronically to another server and load the data into target database-using SQL LOADER.
• Worked with DBA’s to correct problems with sequence, grants, Database Backup & recovery and for Materialized view creation.
• Wrote PL/SQL scripts for data uploading from one schema to another.
• Created UNIX shell scripts, which call the PL/SQL scripts.
• Created Dashboards and answers using presentation services, Pivot tables, views, charts on (OBIEE).
• Interacted with Amdocs to fix the data related issues.
• Worked partially as a database administrator and used partitioned table for better performance.
• Experience of debugging and coding in C++ (STL)for bugs fixing.
• Written CRON Jobs in UNIX to run Nightly, weekly cycle processes automatically.
• Worked extensively on tuning SQL queries and database modules for optimum performance.

Environment: Oracle 9i/10g, Teradata, SQL, PL/SQL, TOAD, PL/SQL Developer, Unix Shell Scripting, Sed, Awk, Scheduler (Cron), C, C++, PVCS Version Manager and Tracker, Informatica power center 7.2. 

Confidential, NJDecember 2006 – May 2007
Worked as an Oracle Developer. The aim of the project was to develop a testing tool by using Shell scripts. In the application there are collections of Oracle terabyte Database, which communicate with each other through Batch Programming. The Databases are remotely located. By using the cumulative data we run numerous Batch Processes to Generate Reports as well as to update the database. These Batch processes were run manually prior to this project. This project Tool was intended to monitor and check the dependency for the next cycle to run successfully. 
Environment: Oracle 9i, SQL, PL/SQL, TOAD, PL/SQL Developer, Unix Shell Scripting, Sed, Awk, Scheduler (Cron), Java JDBC, Informatica power center 7.0.

Confidential June 2005 – December 2006 
Worked as an Oracle Developer/Unix Developer. Developed the application using C as ‘Front Controller’ for the request processing and delegation for next menu or processes. UNIX scripts are used to render results and start/stop billing processes. Oracle is used for checking the status of rating and also for billing statistics as well as Generating Reports of all Rated process details. This process could be run in a batch or for an individual. Developedtest code in C++ for Unit Testing and generating Test Data
Environment: Oracle 9i, SQL Server, SQL, PL/SQL, TOAD, C, C++, HP-Unix, Shell Scripting, Sed, Awk, Scheduler (Cron).

Confidential November 2001 – June 2005

Programmer / Analyst /Unix developer

1) Title: Automated MIS Reports
Environment: HP-UNIX, Windows NT 4.0 Servers, Windows 98, SQL Server, SQL, PL/SQL, Oracle 8.0 and Toad.
Scope: This Process will help to generate MIS Reports on timely basis for various departments like Finance, Marketing etc. The system gets data from Various Database and is loaded into separate tables using SQL scripts by using Unix Shell Scripts on Scheduled cron jobs. Then at the end of the day the reports are generated based on the transactions performed on that particular day (EOD). Also these reports are generated for Monthly Basis. Initially this was done by manually. This project involved merging the two databases and optimizing the performance of the system to handle the large volumes of data. 
Role: As Programmer Analyst, responsible for fixing of all the bugs and operational problems. Creation of Procedure and Reports due to change in requirements of the various branches and modification of procedures and creation of new functions, views, tables. 
2) Title: Call Detail RecordsReconciliation 
Environment: HP-UNIX 11.0 (Server), Dummy Terminal (Client), SQL, PL/SQL, Oracle 7.3, Oracle 8i and Toad.
Scope: BSCS Vs Switch Reconciliation: This was developed to least the discrepancy in the subscribers data held in BSCS and that in mobile switch network, Filtration of pre-paid data from Value Added Services (VAS) files, Payment posting and adjustments to customer accounts through Payment Input Handler (PIH) and Generating different types of reports as per the requirements of different department, finally Developed scripts for processing TAPIN and TAPOUT files, SAS-cleanup, uploading of rejected CDRS into database, etc using shell scripting in UNIX. 
Role: As Programmer, responsible for:

• Involved in the Analysis, designing and development.
• Study and analysis of the existing system and devising out a migration methodology.
• Created new tables for special data loads.
• Involved Database backup/recovery.

Education

M. S. in Computer Applications.