SUMMARY:

• Over 17 years of experience in the Information Technology as a Lead Oracle Developer with complete project life cycle experience, including Systems analysis, Design, Development, Testing, Implementation and Production support with the experience in Utility, Retail/Wholesale, Construction, Financial, Travel and Confidential industries.
• Good understanding of Oracle Architecture.
• Experience in Designing Relational, Star Schema, and Snowflake Schema using Data Modeling tools Designer 2000.
• Has extensive experience in developing Stored procedures, database triggers.
• Experience in developing batch programs by using PL/SQL and Shell scripts.
• Very well versed in using SQL*Loader for loading data from flat files into Oracle tables.
• Experienced in developing Forms and Reports using Forms 6i/4.5, Reports 6i/2.5, Crystal Reports and Data Reports.
• Strong Expertise with Data warehousing and in ETL (Extraction, Transformation and Loading) tools like Oracle Warehouse Builder (OWB), Informatica.
• Supported administrative functions using Oracle Data Query, Discoverer 10g/4i/3i and Cognos Impromptu.
• Supported administrative functions using Oracle Discoverer Admin 4i/3i/3.1.
• Expertise in extracting data from Legacy Systems.
• Expert in working with databases - Oracle, MS-Access and MS SQL Server.
• Experience in communicating with business partners and vendors and, training end users.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. Oracle Developer

Environment: Windows XP, Unix, LINUX.

Tools: Oracle 11g, PL/SQL, SQL, Oracle Designer 10g, Oracle Reports 10g, SQL Programmer, Tuxedo, Toad, Clear Case, Maestro and xECM.

• Managing and leading MPSC Rate case implementations in Customer Service and Billing since 2010 including but not limited to: Major Rate Unbundling in 2011, Rate Reduction Credit, Securitization Bond Charge, Gas Cost Recovery, Power Supply Cost Recovery, UETM, Rate Realignment Surcharge, Self-Implementation Surcharge, Energy Optimization, Renewable Energy Portfolio Surcharge, Residential Income Assistance Credit, School Rates, and Cents for Energy.
• Worked on CSB screens needed for maintenance of HPP, Green Currents, Electric and Gas Choice Customers.
• Designed and developed multiple home appliance plans under Home Protection Plans.
• Created multiple Oracle reports for the business partners.
• Coordinated with different groups to streamline the process flows for the batch processes.
• Primary CSB contact for all Electric and Gas Choice changes
• Part of production support team providing 24x7 support for CSB application.
• Worked as build coordinator for scheduled monthly CSB releases.
• Migrated 36Million legacy invoices Oracle to C360 (SAP) system.
• Assisted SOX team in the yearly audit process.

Confidential, Manchester, NH

Database / Data Warehouse Developer

Environment: Windows XP, LINUX.

Tools: Oracle 10g, PL/SQL, SQL, Oracle Designer 10g, Oracle Reports 10g, OWB 10gR2, XML, SQL Programmer and PL/SQL Developer.

• Designed and deployed the database using the Oracle Designer 10g and deployed the all the objects directly to the databases.
• All the Date columns are defined as Timestamp data type in order to get the advantage of time zones local to the browser when retrieving the data.
• Created the views and triggers for the DML operations for the web application screens.
• Implemented the row level security by creating the policies on the tables using the Fine Grained Access Control (FGAC) also known VPD.
• Created the packages and stored procedures using PL/SQL for the backend services to get the data into the tables.
• Assisted in creating the mappings for the data migration from SQL Server to Oracle.
• Assisted in setting the control locations to deploy the object and mappings using Oracle Warehouse Builder 10g R2, in multi environments.
• Involved in creation of the End User Layer using Oracle Discoverer 10g. Created the views on the tables by converting the timestamp columns to date columns as a work around (Timestamp data types are supported in Oracle Discoverer 11g).

Confidential, Jackson, MI

Environment: Windows NT, HP Unix and Linux.

Tools: Oracle 10g/9i, PL/SQL, SQL*Plus, SQL, Oracle Warehouse Builder 10g r1, Oracle Reports 9i, Oracle Designer 9i, SQL Developer, Oracle AQ, Pro*C and XML.

• Involved as data warehouse developer in a project to implement the Decision Support System.
• Involved in Requirement, Analysis and Design the data warehouse which involved interaction with the users.
• Involved in the designing and developing process of creating a data warehouse for ABC from the new application i.e. 1st Anesthesia using Oracle Warehouse Builder 10g.
• Created Fact and Dimension tables using the Star Schema and Snow Flake schemas.
• Created Summary tables for faster execution of queries in Oracle Discoverer.
• Set up the business areas in Oracle Discoverer using Oracle Discoverer Admin.
• Created workbooks for the end users to analyze the data using Discoverer 10g.
• Implemented the security using the Roles.
• Created stored procedures to update the data in the tables on regular basis.
• Involved in Oracle B2B application, so that ABC can communicate with other clients electronically using XML tables.
• Involved in Data Migration to get the data from legacy system into Oracle tables.
• Created reports for the account managers using Oracle Reports 9i.
• Used the Oracle Advance Queueing to get the updates on the data warehouse tables.
• Involved in the implementation of the portal using Weblogic.
• Developed the shell scripts for the automation of the batch process.

Confidential, Greeley, CO

Environment: WindowsNT, HP UNIX and Linux.

Tools: Oracle 9i, PL/SQL, SQL*Plus, SQL, Oracle Warehouse Builder 2.1/3i/9i (OWB), Oracle Designer 6i, Oracle Discoverer 10g/4i, Oracle Reports 9i, Pro*C, Cognos ReportNet and CMMI.

• Worked as Data warehouse engineer and support person for a large Fertilizer and Chemicals manufacturing and distribution company (UAP)
• Designed and Developed ETT (Extract, Transform and Transport) scripts using Oracle PL/SQL stored procedures to load the data into the existing data warehouse form the new source i.e. Intuit Eclipse system.
• Implemented star schema and snowflake schema in modeling the data warehouse.
• Implemented changes in the architecture so that there won't be any redundancy in the data for the universal customer database and now they are able to track the complete details of a customer.
• Involved in writing Oracle Stored Procedures, Packages, Pro*C files, SQL LOADER Control files and Unix Shell scripts for automation of batch jobs.
• Created mission critical reports for the upper management and middle management about the sales staff performance using Oracle Reports 9i.
• Improved the performance of the queries for the running by discoverer users, by adopting the new features in Oracle 9i like Bitmap join indexes and Constraint enforced views etc.
• As an Oracle Discoverer administrator responsible for creating new users and granting the access to different Data marts based on their user level and updating the EUL for the changes requested by the users.
• Supported the business users on their problems with the Oracle Discoverer tool.
• Worked on the Cognos ReportNet tool for building reports for the end users as alternative to Oracle Discoverer.
• Documented all the changes and the issues with the data warehouse loadings, issues with business intelligence tools and the end user issues for free flow of the knowledge transfer.

Confidential, Petoskey, MI

Sr. Programmer/Analyst

Environment: Windows 2000, HP UNIX.

Tools: MS SQL Server 2000, T-SQL, DF Power Studio, MS Excel 2000, Cognos Impromptu 6.0 and Cognos Power Play 6.6.

• Designed and Developed Report Mart using MS SQL Server for ECS to in corporate the report mart into their software for the Confidential authorities.
• Gathered the requirements for the report mart by talking to the business users.
• Came with the data mapping structure from Source data to the target data.
• Designed and developed data model using Star schema and snow flake schema when creating the dimensions and fact tables.
• Created stored procedures to Extract, Transform and Load the data from source tables to the target tables in the report mart.
• Used DF Power Studio to profile, cleansing and Integrate the customer data using different modules.
• Developed database procedures, functions using Transact SQL to load stage tables.
• Involved in Physical and Logical Design of Database.
• Fine-tuning the server to achieve best performance.
• Created Catalogs and Reports using Impromptu 7.0/6.0.
• Created cubes using Cognos Powerplay 7.x/6.x..

Confidential

Environment: Windows 98, HP UNIX.

Tools: Oracle 9i/8i, MS SQL SERVER 2000, PL/SQL, SQL*Plus, SQL, Developer 6i, Reports 6i, Oracle Designer 6i, Oracle Discoverer, Clear case.

• Designed and Developed Entity relation diagram, case diagrams using Designer 6i.
• Created the Data Warehouse for the dental Confidential company with nearly one-terra bytes of data on Oracle 9i/8i using Oracle Warehouse Builder 3i/2.1 (OWB).
• Used different Data Warehouse techniques like Star-Schema, snowflake schema.
• Created Dimensions, Fact Tables, Summary tables, attributes and hierarchies.
• Understanding the user's requirements from Business Analyst and translated the business requirements into the technical once.
• Played key role in finding out the Key Performance Indicators, the users are interested in.
• Data mining and dataflow analysis from multiple sources of data
• Responsibilities included data modeling, analysis of data, DBA function.
• Developed database stored procedures, functions using PL/SQL.
• Played a key role in the common effort for the porting of data from the IDMS database to Oracle database in the Unix environment.
• Developed multiple interfaces using MQ* Series and Oracle Advance Queueing.
• Created EUL, Business areas and users are assigned to particular business areas using Data Query Administration Utility.
• Trained the business users with Oracle Discoverer to analyze the data and to create reports on their own.
• Created multiple screens for the users to manipulate the data into the tables using Oracle Forms 6i.
• Created ad-hoc reports for the middle management using Oracle Reports 6i.
• Created shell scripts for processing data in batch.