Summary

• Over 8 years of IT experience in System Analysis, Design, Development, Maintenance and Support using Oracle Database 8i/9i/10g/11g, SQL, PL/SQL, SQL * Loader, Query Optimization, Performance Tuning, and Trouble Shooting
• Expertise in writing Database Stored Procedures, Functions, Packages, Triggers, Cursors, Exception Handlers, Dynamic Cursor programs, Native Dynamic SQL and Data Collections using SQL & Oracle PL/SQL
• Good working experience with the usage of Collections, Bulk Insert, Global temp table, Nested tables, External tables, Advanced queuing, Materialized Views, Inline Views, Analytical functions and REF cursors.
• Executing, monitoring various UNIX ksh scripts, escalating and bug fixing the related issues as required, providing solutions, implementing code logic as per functional, adhoc requirements.
• Expertise in implementing Data modeling, Erwin, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
• Expertise in designing, developing Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.
• Extensive experience in integration of data from heterogeneous sources (ERP, RDBMS, Flat Files and Web Applications).
• Extensively worked on Data Migration using Flat files and Data Mapping through SQL* Loader Imp/Exp utilities, UTL-File Package on Oracle 9i and 10g Databases.
• Experience in Performance tuning, Application tuning and Query Optimization using Hints, Explain plan, TKPROF
• Understanding of ERP Systems (SAP, Oracle Applications) and worked with Manufacturing, Sales and Distribution, Inventory (Material Movement), AR and AP modules’ Rapid Mart Customization / Development.
• Expert level understanding of Oracle database capabilities and DW best practices including appropriate use of indexing, material views, partitioning, snapshot capture and referential integrity.
• Expertise in implementation of Data Warehousing and Decision Support systems in UNIX/Windows environments.
• Hands on experience with tools like SQL Navigator, Toad, Sql*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM).
• Expertise in writing Wrapper/Scheduler jobs and hands on experience in Autosys Tool.
• Also worked on MS SQL Server, Access Databases and developed T-SQL, SQL, Stored Procedures, Cursors, Triggers, Views, Indexes and Constraints, Query Optimizer
• Proficient in working and conceptual knowledge of Oracle Forms 6i/10g, Reports 6i.
• Expertise in writing Crystal Reports and SQL Server Reporting Services.
• Commercial experience in Data Modeling using design tools like ERWIN and MS VISIO, created ER Diagrams, Data Flow Diagrams using Design tools.
• Hands-on experience with source control tools like Visual Source Safe (VSS)
• Major strengths are familiarity with multiple software systems, tools and the ability to learn quickly new technologies and adapt to new environments
• Excellent interpersonal and communication skills, self-motivated and good team player.
• Worked through all phases of System Development Life Cycle (SDLC): requirements gathering, analysis, design, development, testing, UAT, production and post-production support

Education

• Bachelor of Engineering (B.E) in Computer Science, India

Technical Skills

Languages

PL/SQL, Oracle SQL, C#, VB.Net, VB 6.0, C, C++, Java

Databases

Oracle 7.x/8.x/9x/10g/11g, DB2 8.2.2, MS SQL Server, Sybase, MS Access, Hyperion Essbase

ETL Tools

Business Objects Data Integrator XI, Informatica, Oracle Data Integrator, Oracle Warehouse Builder

OLAP Tools

Business Objects 6.0/6.5.1, Cognos

GUI Tools

Forms and Reports 6i, Developer suite 10g, Oracle E-Business Suite 11.5.10

Query Tools

TOAD, SQL Developer, SQL Navigator, SQL* Plus and PL/SQL Developer

IDE Tools

Visual Studio, Visual Studio .NET 2005

Web Technologies

ASP. Net 1.1/2.0, ASP, HTML, XML, Java Script and VBScript

Reporting Tools

Crystal Reports and SQL Server Reporting Services

Other Tools

Visual Source Safe, Team Foundation Server (TFS), Microsoft Visio, ER-WIN, FTP

Operating Systems

Windows , Solaris, Unix, Linux

Professional Experience

Confidential,
Houston, TX Sep 08 – till now
Sr Oracle Developer

Fountain Incident Management (FIM) is a Shell global IT system for reporting and follow-up of all incidents
And near-misses. It contains all health, safety and environmental (HSSE) incidents, plus incidents involving
security and fuel product quality.

Responsibilities:

• Responsible for creating and developing highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Involved in migration of Oracle 9i database to Oracle 11g.
• Analyze System Requirements to create a Technical Design with the assistance of other Sr. Developers/Architects/Tech. Leads.
• Responsible for helping set development standards for database development within PL/SQL.
• Act as a technical resource, with a high level of technical and analytical expertise in programming languages, data communications and a strong understanding of the business operation/customer. Implement and support code migration into production.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD)
• Created Views and Triggers required for the Incident, Investigation, Consequence and Action Items modules based on the business requirements.
• Designed, developed and tested Oracle PL/SQL packages, stored procedures, and functions to push the incident data from SCIPR to FIM.
• Developed automated SQL scripts to schedule the load of employee/contractor user information from active directory on daily basis.
• Extensively worked on ETL (Extraction, transformation and loading) using PL/SQL to Extract, transform and load incident data into MIS (Downstream HSSE Management Information Systems) data warehouse.
• Played a pivotal role in the migration of open Incidents from legacy application databases to Oracle 10g in a planned manner
• A reporting data mart was created to support the MIS capabilities by designing and developing Oracle PL/SQL packages, stored procedures, functions, and triggers.
• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures
• As part of performance tuning, used TKPROF, and Explain Plan in tuning PL/SQL code and SQL queries
• Created Unit and Assembly Test Scripts and performed the test cases.
• Provided Ad-hoc Reports when ever the business requested and maintained a good relation with Business Customer
  

Environment: Oracle 11g, Oracle 9i, PL/SQL, SQL, SQL*PLUS, SQL Loader, TOAD, Visual Studio.Net 2005, C#, ASP.NET 2.0, ADO.NET, Java Script, Crystal Reports.NET, IIS 4.0/5.0, Windows 2000, and Team Foundation Server (TFS)

Confidential,
Houston, TX Jun 07 – Aug 08
Sr Oracle Developer

SHARE is an application used by the Shell refinery accounting departments to manage yield and stock accounting at the respective sites. Share provides a vendor neutral view of all of its data through user customizable web based reports as well as the ability to manually enter transactions to supplement the data obtained from other systems.

Responsibilities:

• Analysis of the specifications provided by the client, Design and Development, Conducted Use Case scenarios and translated the problem domain to UML diagrams utilizing Microsoft Visio
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD)
• Developed various packages, stored procedures, Views, and triggers using Oracle10g
• Created Views and Triggers required for the Incident, Investigation, Consequence and Action Items modules based on the business requirements.
• Designed, developed and tested Oracle PL/SQL packages, stored procedures, and functions to push the accounting data from GSAP to SHARE.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Performance monitoring and tuning of SQL developed by various developers.
• Designed and developed various classes to construct the business logic using C# and ADO.NET. The middle tier contained all the business logic. The data access layer was designed on the middle tier, which would connect to Oracle10g
• Developed Web Forms using C# Language with event handling, exception handling and Logging
• Developed COM components in VB 6.0 for business rules and integrated with database
• Developed various accounting reports using Crystal Reports. NET

Environment: Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL Loader, SQL Developer, SQL Navigator, Visual Studio.Net 2005, C#, ASP.NET 2.0, ASP, ADO.NET, VB 6.0, ADO, Java Script, VB Script, Windows Scripting Components, Crystal Reports.NET, IIS, Windows 2000, and Visual SourceSafe.

Confidential,
San Francisco, CA Nov 06 – May 07 Sr Oracle PL/SQL Developer

NPF Import – Provider: Delta Dental is the largest and most experienced dental insurance system in the United States. The company provides coverage to almost 50 million people, enrolled in over 88,000 groups. The ESP core conversion project is part of the migration of Delta Dental claim’s processing system from various processing platforms to the Electronic Data Services (EDS) Metvance system. The scope of NPF IMPORT is to import non-enterprise provider demographic and contract data from the National Provider File (NPF) file and export Provider Information into Metvance (MTV). The NPF demographic data will be supplied in a daily Name and Address extract file from the Delta Dental Plan Association (DDPA). These business requirements fall under the scope of the NPF Import sub-project of the ESP Core project within the ESP portfolio

Responsibilities: As a Programmer Analyst, am responsible for

• Developed and Modified the PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced techniques Bulk Processing, En-queue and De-queue, Collections.
• Develop the jobs to extract, transform and load, populating and refreshing Staging Tables from flat file and then export to Transaction Files using DI and export the files to Metvance target tables using MTV Provider Load Utility.
• Write the scripts with in the jobs to automate the process, parameter setting / initialization for the flat files.
• Validate the source data being processed through DI Jobs to ensure accuracy using a set of SQL queries and MTV client.
• Analyze data in source systems to assess data cleanliness and make recommendations for addressing within the source systems or as part of the ETL process.
• Responsible for end to end Testing and Fixing the Defects.
• Communicate with Management and evaluating the DI Job Execution Status to guarantee the consistent performance
• Optimizing PL/SQL code and SQL queries (Using Explain Plan, Analyze, Indexes and Hints).
• Provide timely Production Support by quickly analyzing the root cause and by providing work around to resolve issues.
• Assisted in maintaining and improving ETL processing efficiency for improved data quality, impact analysis and data validation. Ensured data availability to the departmental data marts on a requirement-demand basis.

Environment: Oracle 9i, Toad for Oracle, PL/SQL, Business Objects Data Integrator, Hyperion Essbase, Metvance (MTV), Clear Case, Clear Quest, Flat Files, UNIX and Microsoft Office Visio, Tidal

Confidential,
Detroit, MI Mar 06 – Oct 06
Oracle PL/SQL Developer

STJOHN HEALTH has an existing data and needs to enhance that for hospital Operational Data Store (ODS) from three hospitals using code development using Informatica, Unix shell scripting, SQL loader scripts and Oracle Pl/SQL routines (DB-Packages/Procedures/Triggers). The data is to help the STJOHN HEALTH Executive team to take decision on improving their business

Responsibilities:

• Identified and analyzed requirements.
• Develop ETL process to load the data from .DAT files
• Develop programs, scripts, and procedures for data load in ODS
• Document all development process and methods (ETL operations) based on St John Health Standards
• Worked on various backend Procedures and Functions using PL/SQL
• Created various SQL and PL/SQL scripts for verification of the required functionalities
• Created various Database triggers using PL/SQL
• Generated a number of reports for management to review for system functionality as against the old legacy system
• Test the programs, scripts, and procedures for data load in the test environment
• Worked on optimizing existing procedures and functions using PL/SQL

Environment: Oracle 9i, TOAD, Informatica, PLSQL, Sql Loader, ERWIN, UNIX

Confidential,
India Aug 04 – Jan 06
Oracle Developer

BSNL Portal is a medium through which BSNL caters to provide value added services to its customers.
The project focuses on features like Web Search, a vast content section, Mailing system for its officers, FAQs for the general public. There is some focus on the telecom industry specific features like Telecom Site Search and Telecom News. Also, the Value Added Services is an important section, which allows a BSNL Landline/Cell One Subscriber to pay his bills online.

Responsibilities:
Played a pivotal role in the migration of the BSNL Portal Database from MS Access to Oracle in a planned manner.

• Worked on various backend Procedures and Functions using PL/SQL
• Created various SQL and PL/SQL scripts for verification of the required functionalities
• Created various Database triggers using PL/SQL
• Generated a number of reports for management to review for system functionality as against the old legacy system
• Worked with various functional experts to implement their functional knowledge into working Procedures
• Worked on optimizing existing procedures and functions using PL/SQL
• Used Object Libraries and Form Template using Oracle Forms5.0
• Designed and attached toolbar and menu bar to forms in Oracle Forms5.0
• Involved in setting up Business Area for Oracle Objects on Discoverer, granting access to users
• Created and registered Discoverer queries in Oracle Discoverer Administration 3.1
• Used Oracle Reports Builder to create various Report Formats including Sub Reports, Cross Tab Reports, Standard Reports and Master/Detail Reports

Environment: Oracle 8.x, SQL, PL/SQL, Developer2000 (Forms5.0, Reports3.0), Discoverer3.1, Sun Solaris and WindowsNT/97, Erwin.

Confidential,
India Apr 01- Jul 04
Oracle Developer

Online Transaction Processing (OLTP) is developed for all the government departments working under one Revenue Division. This Project covers 12 various departments including Revenue, Municipality, Agriculture, police, PHC, Panchayat Raj Engineering, and MPDO etc. This project is to customize the various activities of Bhuvanagiri Municipality located in Nalgonda District. These activities include Building Permissions, Births, and Deaths Registrations, Property Tax, Advertisement Tax, Trade Licenses, Tap Connections, Water Charges and etc.

Responsibilities: As a Developer responsible for

• Extensively involved in requirements gathering and data gathering to support developers.
• Involved in designing and of functional specifications for the development of user interfaces.
• Involved in designing of Entity Relationship Diagrams.
• Created tables, indexes, sequences, constraints and snapshots.
• Developed packages, procedures, functions and PL/SQL blocks for data validation.
• Developed PL/SQL scripts to validate and load data into interface tables.
• Fixed software bugs and interacted with developers to resolve technical issues.

Environment: Oracle 8, ASP, VB 6.0, VB Script, JavaScript, Windows Scripting Components, IIS 5.0, HTML, Crystal Reports, Windows 2000