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

• Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
• Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
• 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, SUN 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.
• 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.
• Testing and modifying codes for quality.
• 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.
• 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.

Technical Skills :

Operating Systems:

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

Languages:

C, C++, SQL, PL/SQL, HTML 4.0, XML.

Databases:

Oracle 10g / 9i / 8i / 8/ 7x, Access, SQL Server, Teradata.

Scripting:

UNIX Shell Scripting, 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 Technologie

PVCS version manager, PVCS tracker, Auto sys.

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 Data warehouse Developer/Data Analyst, was responsible for:

• Data Architect/Modeler/Analyst Data Warehouse.
• Perform data modeling, data source analysis, data sourcing specifications, ETL design & specification.
• Create conceptual, logical, and physical data models to define the informational needs of the DW.
• Perform physical database design to implement the physical data model.
• Develop data extraction, transformation, and loading strategies and document the data movement through data flow diagrams.
• Collaborate and communicate with DBA, BA, and ETL teams to correctly implement the projects.
• Communicate with business users and source data owners to gather reporting requirements and to access and discover source data content, quality, and availability.
• Develop and maintain data architecture artifacts and standards, including data naming, data dictionaries, naming conventions, etc.
• Design automated processes to capture data quality and reasonability parameters of loaded data and for comparing those against baseline versions of data.
• 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.
• Used Collection concept to validate the data.
• Used dbms_job for scheduling the batch processes of procedures.
• Developed system test scripts, unit test scripts, detail design documents for the enhancements.
• Used Business Objects for reports.
• Used analytical function to generate default sequence.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Wrote UNIX scripts and scheduled the jobs using Crontab utility.
• Written perl scripts for manipulation and validating reports.
• 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.
• Worked closely with DBA for DB creation etc.
• Involved and documented writing system test script, unit scripts and production memo.
• 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.
• 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 Business Intelligence suite (OBI EE) ,Oracle 10g/9i, SQL Server, SQL, PL/SQL, TOAD, SQL Loader, Unix Shell Script, Sed, Awk, SQL Navigator 5.0, PL/SQL Developer, Perl, Informatica Power Center 8.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 Data warehouse Developer/UNIX Developer, was responsible for:

• Develop Data Profiling and Data Quality Monitoring & Management strategies and their integration with the Data Processing and ETL Life Cycle within an Enterprise Data Warehouses.
• Perform physical database design to implement the physical data model.
• Used materialized views for generating Data warehouse reports on OBIEE.
• Involved creation of extended dimension modeling tables like snowflake for OBIEE.
• Worked on BMM layer to create new columns for generating reports which are not available at database tables.
• Responsible for troubleshooting and resolving issues related to data sourcing, data quality, ETL development, system performance, Quality Assurance and User Acceptance.
• 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.
• 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.
• Used analytical function like row_number to generate default sequence number.
• Created UNIX shell scripts, which call the PL/SQL scripts.
• Worked on Informatica power center tool.
• Worked partially as a database administrator and used partitioned table for better performance.
• Worked like UNIX admin for user group management and adding disk space etc..
• Discussed with Amdocs Regarding Ensemble applications.
• Worked 24x7 environments which require on-call rotation.
• Written CRON Jobs in UNIX to run Nightly, weekly cycle processes automatically.
• Used SQL Loader to upload flat file into database tables.
• Worked extensively on tuning SQL queries and database modules for optimum performance.

Environment: Oracle 9i/10g, SQL Server, Teradata, SQL, PL/SQL, TOAD, PL/SQL Developer, Unix Shell Scripting, Sed, Awk, Scheduler (Cron), Oracle Business Intelligence suite (OBI EE) , XML, PVCS Version Manager and Tracker, Informatica power center 7.2.

Confidential, NJDecember 2006 May 2007
Worked as a Sr 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 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), Informatica power center 7.0.

Idea Cellular Ltd, India 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.
Environment: Oracle 9i, SQL, PL/SQL, TOAD, PL/SQL Developer, HP-Unix, Shell Scripting, Sed, Awk, Scheduler (Cron).

Confidential,India November 2001 June 2005

Programmer / Analyst /Unix developer

1) Title: Automated MIS Reports
Environment: HP-UNIX, Windows NT 4.0 Servers, Windows 98, 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.