SUMMARY:

• Database developer with 8+ years of experience in application design, development, testing, implementation and maintenance.
• Extensive knowledge of Oracle 7i/8i/9i/10g/11g, RDBMS concepts, including ETL process and ETL tools like Oracle Warehouse Builder, Informatica, Data Stage, as well as experience in extraction, transformation and loading from multiple sources into data warehouses.
• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER. Developed Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL. Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Write programming scripts, ColdFusion components to enhance functionality for company web application using ColdFusion 8, Dreamweaver CS4, Eclipse, Subversion, Trac, and Subversion.
• Enhancing Point of Sale legacy system written in asp and ColdFusion.
• Experience on GIS and also know how to use Arc GIS to create map and geographic information.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features
• Rewrote a sports stats project to cold fusion from ASP, modified queries and stored procedures. Tool/software used systems in ColdFusion
• Moved columns of data in and out of database tables using PL/SQL program units by passing collections as parameters.
• Experience in developing logical and physical database design, data modeling using Erwin. Extensively worked on the Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in database.
• Extensively worked on Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, and Hints. Well experienced in creating detailed design and technical design documents and worked with project management teams and business stakeholders to make modifications.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* LOADER, UTIL file loader and batch processing.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records. Strong Trouble - shooting, Problem solving, Analytical & Design Skills.
• Comfortable to work with a team or work individually. Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

TECHNICAL SKILLS:

Methodologies: Star Schema, Snowflake Schema

Programming: Visual Studio 6.0, C, C++, Visual Basic 3.5/6.0,PL/SQL

Internet Technologies: HTML, XML & VBScript

Database: Oracle 7i/8i/9i/10g/11g

Operating Systems: MS-DOS, Windows NT/2000/ XP Pro, UNIX

Other Tools: Toad, SQL Loader, PL/SQL Developer, Tortoise SVN, Informatica Power Center 8.6.X/6.1, Data stage

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Data Modeling Tools: Erwin, Power designer, oracle Designer, ER / Studio, Rational Rose, MS Visio, Embarcadero

PROFESSIONAL EXPERIENCE:

Confidential, Ft Worth, TX

Oracle PL/SQL consultant

Responsibilities:

• Gathered requirements from client and translated business details into Technical design document.
• Designed and developed Star Schema model for data warehouse.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Developed schema using SQL statements like all types of joins, create, primary key foreign key.
• Developing Conceptual (Star and Snowflake) logical and physical data modeling using ERWIN data modeler and MSVISIO.
• Created query operators supported by file geo data bases, shape files, coverages, and other file-based data sources by using Arc GIS
• Implemented Partition and sub partition concepts to fine tune Data Load and Data retrieving from Fact table with 2.5 Billion records.
• Re-engineered and optimized several sections of the existing ColdFusion, JavaScript and HTML code and MySQL queries which reduced the daily error rate by 80%.
• Involved in project planning, coordination and implementation of QA methodology.
• Designed and Developed Water fall ETL approach in PL/SQL to load incoming files efficiently into warehouse.
• Used ColdFusion front end to develop multiple web systems applications and automation tools.
• Ensured that the Rational toolset information accurately reflects the physical FPA structure, and the data dictionary, DDL, models, and any support documents produced from the toolset would correctly represent the physical structure and ensure a smooth transition if needed.
• Created pl/sql stored procedures, functions and packages for moving the data from Files to ETL staging area and then to Star Schema.
• Extensively used the advanced features of PL/SQL like records, tables, object types and dynamic sql.
• Developed and Implemented Encrypting Process for Secure data.
• Performed sql and pl/sql tuning and application tuning using various tools like explain plan, sql trace, tkprof.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between sql and pl/sql engines.
• Coordinated with different teams to smoothly migrate the code to QC or Production environments.
• Supported between developers and end users, functional managers and Oracle regarding issues with the database software,

Environment: Oracle 11g, ERWIN, MSVISIO Oracle Reports and Forms 11g, SQL, Oracle PL/SQL, SQL Navigator, Windows XP/7, BMC Remedy

Oracle PL/SQL consultant

Responsibilities:

• Understood the Customer Business System, worked with stakeholders to gather business requirements and created technical documents to map these requirements
• Used SQL Loader to load data from Old System to New System and performed Data validation on Staging tables before loading into Main Tables
• Relational Database Modeling and Dimensional Modeling-Star schema, Snow-Flake schema, and hands on experience in data modeling tools Erwin / ER Studio.
• Involved in Exporting and Importing tables to suit business needs
• Involved in writing PL/SQL blocks which implement business logic
• Developed and maintained ColdFusion 8, HTML, JavaScript and CSS code for two sites.
• Strong knowledge of ColdFusion design code and optimization
• Generate DDLs and provided them to ETL for FSD support and also to the DBA for database implementation
• Developed SQL Scripts, Stored Procedures, Functions and Packages using PL/SQL
• Developed complex triggers in reports before/after for validation of user input
• Developed UNIX Shell scripts to automate table creation and execute procedures
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes
• Tuned performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Performed unit testing and supported integration testing and end user testing
• Worked closely with QA testing resources to ensure Testing issues are resolved
• Involved in code reviews for the entire team and remediating issues
• Environment: PL/SQL Developer, Windows XP/7, UNIX, Oracle 11g, Erwin, Informatica Power Center 9.1.

Oracle PL/SQL consultant

Responsibilities:

• Developed, presented and implemented several Proof of Concepts to save load timings during ETL process; designed, developed and implemented several PL/SQL packages to load more than 1B records from multiple files.
• Humana heavily used Oracle Warehouse Builder for ETL but because of performance issues I had an opportunity to re-write entire ETL process using PL/SQL.
• Created Oracle database objects including tables, views, synonyms, materialized views, partitions and PL/SQL objects such as procedures, functions and packages to implement ETL Data flow.
• Used DML and DDL commands for creating records by using commands like select, insert, update and delete.
• Redesigned several sequential jobs to run in parallel; Improved the performance of ETL process by fine tuning queries, creating appropriate indexes and using temp tables.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Designing and modeling database according to Requirement. And made changes according to it.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
• Design and implement Oracle Database indexing and partitioning strategy to process and query large volumes of data.
• Developed and implemented common utility package to avoid recoding for auditing, error handling, gathering statistics and index maintenance.
• Prepare detailed design and technical design documents and work with project management teams and business stakeholders to make modifications.
• Resolve production data load problems, support daily/weekly/monthly data loads and track and resolve performance issues.

Environment: MS SQL Server 2000/2005, My SQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).

Oracle PL/SQL consultant

Responsibilities:

• Interacted with Subject Matter Experts (SME) to gather Business Requirements for the application, through one-on-one interviews as well as JAD sessions with development teams.
• Involved in gathering requirements through reverse engineering process.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Tuned multiple long running monthly loads to minimize the load time, including a warehouse redesign which reduced load time from 2 Days to 7 hours.
• Developed process to load flat files coming from Up-stream systems into Oracle using External Tables.
• Designed competent PL/SQL programs using PL/SQL collections, record types, and Object types.
• Supported data migration from different tables to data warehouse; designed and developed partition concepts for ETL data loads; maintained legacy, legacy incremental and monthly load processes; created procedures to implement ETL functionality with Oracle for Dimension and fact loads.
• Helped QA team to develop test scripts for the validation of the process. Also performed unit testing and system testing.
• Worked closely with various business teams and IT analyst in gathering the requirements; Transformation of requirements into Data structures using modeling tools.

Environment: PL/SQL Developer, Windows XP/7, UNIX, Oracle 11g, Erwin, Informatica Power Center 9.1.

Oracle PL/SQL consultant

Responsibilities:

• Developed, presented and implemented several Proof of Concepts to save load timings during ETL process; designed, developed and implemented several PL/SQL packages to load more than 1B records from multiple files.
• Used Oracle Warehouse Builder for ETL but because of performance issues I had an opportunity to re-write entire ETL process using PL/SQL.
• Created Oracle database objects including tables, views, synonyms, materialized views, partitions and PL/SQL objects such as procedures, functions and packages to implement ETL Data flow.
• Redesigned several sequential jobs to run in parallel; Improved the performance of ETL process by fine tuning queries, creating appropriate indexes and using temp tables.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
• Design and implement Oracle Database indexing and partitioning strategy to process and query large volumes of data.
• Wrote DDL scripts for creating, altering tables
• Developed and implemented common utility package to avoid recoding for auditing, error handling, gathering statistics and index maintenance.
• Prepare detailed design and technical design documents and work with project management teams and business stakeholders to make modifications.
• Resolve production data load problems, support daily/weekly/monthly data loads and track and resolve performance issues.

Environment: MS SQL Server 2000/2005, My SQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).