PROFILE

• 7 YEARS OF TOTAL DW EXPERIENCE
• 6 YEARS OF OWB EXPERIENCE
• 4 YEARS OF ODI EXPERIENCE
• 6 YEARS OF DATA MODELING EXPERIENCE
• 4 YEARS OF BO / COGNOS EXPERIENCE
• 6 YEARS OF ORACLE, SQL, PL/SQL EXPERIENCE
• 7 YEARS OF EXPERIENCE WITH VARIOUS DATABASES / EXPOSURE TO ERP
• CLIENTELE: VERIZON, FAC LOGISTICS , GUY CARPENTER, ACT Inc , KENT STATE UNIVERSITY, BOA

SUMMARY

• Seven Plus 7 years of total IT experience in the Analysis, Design, Development, Implementation and Testing of Internet/Intranet/E-Commerce and Web Applications using Object Oriented Analysis, Design and Methodologies. Worked extensively with clients like Insurance, Finance, Telecom, Education and Pharma.
• Seven plus 7 years of Total Data warehousing / ETL experience.
• Seven Plus 7 Years of experience in providing Business Intelligence solution in Data Warehousing/Decision Support Systems using OWB 11g, Oracle 10g Warehouse Builder R1/R2, Oracle 9iwarehouse builder, Oracle Data Integrator 10.1.x, OEM, OWM, ETL, DB2, Oracle 9i/8i/8.0/7.x, OLAP, OLTP, MS SQL Server 6.5/7.0, MS Access 7.0/2000, Erwin, SQL, PL/SQL, SQL Plus, SQL Loader and T-SQL.
• Four Plus 4 Years of experience in Business Intelligence tools like Cognos Impromptu, Cognos Transformer, Cognos Power Play Cognos Series 7 and Cognos 6.x , Cognos Frame Work Manager, Business Objects XI/6.5
• Six Plus 6 Years of Data Modeling experience using Dimensional Data modeling, Star Join Schema modeling, Snow-Flake modeling, FACT and Dimensions tables, Physical and logical data modeling, ERWIN 4.x/3.x, Oracle Designer, Sybase Power Designer.
• Seven Plus 7 years of Data warehouse experience using Oracle Warehouse Builder, Oracle 11G/10g, Oracle 9i, Oracle 8i/8.0/7.3, SQL Loader, PL/SQL, SQL Plus, TOAD, Explain Plan, TKPROF, Stored Procedures, triggers, Materialized Views and cursors.

TECHNICAL SUMMARY

PROFESSIONAL SUMMARY

Confidential

OWB ETL DEVELOPER / PENTAHO BI DEVELOPER

ETL Responsibilities:

• Modified OWB Mappings that populated large fact tables 200 mil rows
• Analyzed the Business requirement for OWB and Mapped the Architecture
• Created packages with several interconnected mappings and variables to conform to the standard source to target mapping requirements.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents
• Modified shell scripts that were built to call custom procedures and report errors
• Modified custom PL/SQL packages to clean out redundant code and replace existing code with more efficient joins and procedure calls.
• Involved in the process of migrating mappings across environments - development to test and eventually to production and building migration documents transport documents
• Extensively used Oracle Analytic functions to select specific records based on predefined business rules.
• With the large data warehouse environment, any updates or back population were performed over the extensive partitioning applied on the tables.

Reporting Responsibilities:

• Designed and developed a series of complex Business Intelligence solutions using Pentaho Report Desginer
• Optimized and performance tuned existing reports to provide smooth user functionality.
• Analyzed, converted, tested, reconciled and implemented reports in the SchoolMax application.
• Implemented complex business requirements in the backend using efficient SQL queries and facilitated easy implementation of front end applications.
• Built efficient, complex, parameterized SQL queries and stored procedures to produce output data sets.
• Implemented best practices to reduce maintenance overhead and complexity.
• Created mapping specification documents to define and document source and target attributes
• Used Pentaho Data Integration Designer to create ETL transformations
• Developed ETL transformations that sourced from a variety of Heterogeneous sources including Microsoft Access, Text files, CSV files
• Developed several reports that exploited the use of Sub reports, report grouping, Pentaho Sub actions.
• Implemented user level security by creating a table that stored usernames, user groups and their specific permissions.
• Created dashboards in Pentaho using Pentaho Dashboard Designer.

Environment: Oracle Warehouse Builder 11gR2, Toad 8.5.1.6, Oracle 11g, Erwin, SQL plus, PL/SQL, Pentaho Report Designer 3.5/3.8, PL/SQL, Pentaho Data Integration PDI/Kettle , Pentaho Design Studio

Confidential

OWB / ODI DEVELOPER

RESPONSIBILITIES:

• Responsible for OWB / ODI Installation and configuration.
• Responsible for OWB / ODI Administration
• Responsible for Architecting the Data Warehouse
• Modified OWB Mappings that populated large fact tables 200 mil rows
• Analyzed the Business requirement for OWB and Mapped the Architecture
• Created packages with several interconnected mappings and variables to conform to the standard source to target mapping requirements.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents
• Modified shell scripts that were built to call custom procedures and report errors
• Modified custom PL/SQL packages to clean out redundant code and replace existing code with more efficient joins and procedure calls.
• Training client personnel in ODI Development and bring them to speed.
• Hands on with ETL Development using ODI.
• Built conversion scripts and modified ODI Mappings that populated large fact tables 100 mil rows
• Created packages with several interconnected interfaces and variables to conform to the standard source to target mapping requirements in order to link ODI with the user interface VSII.
• The VSII Verizon Services Integration Infrastructure interface was built to meet the batch and real time integration needs. The ODI interfaces, packages and scenarios were in turn modified to work cohesively with the VSII structure
• Modified shell scripts that were built to call custom procedures and report errors
• Modified custom PL/SQL packages to clean out redundant code and replace existing code with more efficient joins and procedure calls.
• Involved in the process of migrating code including ODI packages and scenarios from development to test and to production and building migration documents transport documents
• Provided recommendations on data conversion best practices that were implemented

Environment: ODI 11g, Oracle Data Integrator 10.1.3.4, Oracle 11g, Erwin, Flat files, SQL Server, Toad 8.5.1.6, Oracle 11g/10g/9i/8i, Erwin, SQL plus, PL/SQL

Confidential

Sr. OWB Developer

RESPONSIBILITIES:

• Architecture design, installation and setup of the warehouse builder repository and control centers
• Presented a proof of concept for and split repository architecture environment to the client and provided recommendations while implementing the design.
• Involved in the proof of concept development of ETL to populate an XML message to feed a Weblogic messaging service.
• Currently involved in the development of Dimensions and Facts for the Premium and Claim Datamart.
• Besides my responsibilities as a lead, my current role is as the primary point of contact for warehouse environment issues.

OWB RESPONSIBILITIES:

• Extensively used mapping operators Key lookup, Joiner, Sorter, Splitter, Filter, Aggregator, Expression, Mapping Sequence, Pre-mapping process and Post-mapping process
• Built ETL mappings to source from non Oracle source systems AS 400 leveraging OWB capability of extracting from heterogeneous sources.

• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated 6 hour nightly load window.
• Worked with business intelligence employees to gain a better understanding of the reinsurance domain and thereby giving me a better sense of data expected
• Implemented an inherent OWB version control mechanism to track mapping changes as we migrated code to and from our base development environment. Demonstrated the use of the OWB snapshot capability and the change manager to address the client's needs.
• Monitored nightly ETL production mappings through audit and runtime log tables.
• Involved in the documentation and gathering of mapping specifications based on interactions with data architect and reporting team
• Addressed and identified issues through an inbuilt ticket tracking system called Starteam.
• Tuned procedures and mapping through the use of Explain Plan and indexes.
• Extensively used the Oracle Analytic functions to develop and enhance existing procedures to meet the custom requirements of the client.
• Designed and developed packages, triggers using PL/SQL
• Database performance tuning using Explain Plan and TKPROF.
• Created indexes, Views, constraints.
• Used import, export and SQL Loader to load and backup data.
• Developed interface programs to load data into temporary tables using PL/SQL and SQL.
• Involved in the SQL tuning.
• Assisted in OBIEE reporting.

Environment: Oracle Data Integrator 10.1.3.4, OWB 10g Release 2, Toad 8.5.1.6, Oracle 11g/10g/9i/8i, Erwin, SQL plus, PL/SQL, SQL Server, Windows, Unix, XML, OBIEE

Confidential

Sr. Oracle ETL Developer

OWB RESPONSIBILITIES:

• Responsible for ETL using OWB
• Extensive use of mapping operators Key lookup, Joiner, Sorter, Splitter, Filter, Aggregator, Expression, Mapping Sequence, Pre-mapping process and Post-mapping process
• Involved in ETL tuning at the data-mapping level and database level.
• Developed snapshots for tables from source systems with limited or no timestamp information.
• Designed and built ETL mappings based on the client specified testing and deployment procedures. Extensive unit testing was performed before promoting all ETL mappings to test.
• Documented and built deployment plans to promote code from the test environment to Production following sign off from Testing operations.
• Involved in weekly meetings with Program Managers to identify issues and concerns and new requirements to completely harness the Datawarehouse structure.
• Built custom procedures that extracted data from XML source systems that eventually loaded the warehouse.
• Identified and deployed critical updates to ETL mappings with minimal turnaround time.
• With significant changes to the structure of the final reports and after several mapping iterations, I was involved in regression testing of the data end to end flow.
• Provided recommendations on the structure of the staging and the warehouse environment based on my knowledge of the source system table structures.

OTHER RESPONSIBILITIES:

• Generated reports using OBIEE.
• Requirements gathering for reports as well and data extracts on a day to day basis.
• Mentor IT personnel on design and development
• Based on client requirements all existing ETL mapping were to be translated to custom PL/SQL code.
• Tune ETL code packages using explain plan, hints and indexes.
• Monitor production runs and nightly ETL loads through job logs.
• Provide production support for mappings relevant to the Datawarehouse and the Datamart.
• Designed and developed packages, triggers using PL/SQL
• Database performance tuning using Explain Plan and TKPROF.
• Created indexes, Views, constraints.
• Used import, export and SQL Loader to load and backup data.
• Developed interface programs to load data into temporary tables using PL/SQL and SQL.
• Involved in the SQL tuning.

Environment: OWB 11g, , Oracle Data Integrator 10.1.3.4/10.1.3.3, OWB 10g Release 2, Toad 8.5.1.6, Oracle 11g/10g/9i/8i, Erwin, SQL plus, PL/SQL, SQL Server, Windows, Unix, XML, OBIEE

Confidential

ETL OWB DEVELOPER

RESPONSIBILITIES:

• Business Analysis - Business Analysis, End User Interviews, Requirements Gathering.
• Business Analysis Involved in the requirements gathering phase of the Datamart where we met with business users to gather their report requirements and tuned the design of the model based on these requirements.
• ETL Lead - Mentor the existing IT staff in the use and benefits of the ETL tool and provide data warehousing solutions to the client.
• Data Modeling - With my personal involvement and knowledge of the existing banner table structures I played an integral part in the modeling the data structures for the data mart.
• ETL OWB - The existing ERP system used the Oracle Warehouse Builder 10gR1 to perform most of the automated ETL tasks and most of my early designs were built and tested on this version of the tool.
• ETL - Developed procedures and functions within the tool to build custom extracts to meet the requirements of the client.
• ETL OWB - Extensive use of mapping operators Key lookup, joiner, splitter, sorter, filter, aggregator, expression, mapping sequence, mapping input parameter, pre-mapping process, and post-mapping process .
• ETL Migration R1 to R2 - Responsible for ETL migration process from 10gR1 to 10gR2.
• Business Analysis / ETL - Responsible for translating business logic into transformation logic for the ETL and implementing Source to Target mapping
• Architecture - Assessing current or proposed database architecture, database layout, initialization parameters
• Cognos - Assist with a Cognos Framework Manager semantic layer connection to the Oracle star schemas
• ETL Lead - Addressing performance issues as part of the post ETL best practices
• QA - Providing QA support as part of the User Acceptance Testing phase of the Datamart building process.
• Architecture / ETL - Analyzing the existing architecture for mapping source tables to target, implementing Best Practices that involves application of Transformation Rules, developing standards for reuse of business rules, Slowly Changing Dimensions besides architecting ETL for Initial load, on-going load and historical load.

Environment: Oracle Data Integrator, OWB 10g R1, OWB 10gR2, Oracle 10g/9i, ERP, OEM, OWM, Erwin, SQL, PL/SQL, QA, Cognos, Cognos Frame Work Manager.

Confidential

ETL OWB DEVELOPER

RESPONSIBILITIES:

• Provide data warehousing and business intelligence solutions to the client.
• Assist in Data Modeling Star and Snow Flake Schemas .
• Design/Code/validate/deploy ETL mappings using Oracle Warehouse Builder 10g Release 2 10.2 .
• Extensive use of mapping operators Key lookup, joiner, splitter, sorter, filter, aggregator, expression, mapping sequence, mapping input parameter, pre-mapping process, and post-mapping process .
• Develop SQL and PL/SQL code, migrate to test environment, and perform unit and integration testing.
• Extensive use of export/import utilities in OWB.
• Promote code into Production.
• Build SQL queries using Toad and SQL PLUS for data auditing and error checks.
• Write stored procedures, functions, and triggers.
• Validate packages and investigate performance issues.
• Tune code packages using explain plans, hints, indexes, and partitions.
• Provide QA support and sample data for QA and reporting teams.
• Monitor first-time schedule runs confirm/force/order jobs and perfect the schedule draft accordingly.
• Provide Production Support.

Environment: OWB 10g Release 2 10.2 /Release 1 10.1 OEM, OWM, Toad 8.5.1.6, Oracle 10g/9i/8i, Erwin 4.2, SQL Plus, PL/SQL, Unix, Windows.