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

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, FCONFIDENTIAL 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.

EDUCATION & CERTIFICATIONS

• Masters in Engineering,
• Bachelors in Engineering,

TECHNICAL SUMMARY

Data Warehousing:OWB 11g, Oracle 10g Warehouse Builder R1/R2, Oracle 9iwarehouse builder, Oracle Data Integrator 11g/10.1.x, OEM, OWM, Informatica Power Center 7.0/6.2/5.1.2/1.7/1.5 (ETL, Metadata, Data Mining, OLAP, OLTP, SQL*Plus, SQL*Loader

Data Bases:Oracle 11g/10g/9i/8i/7i, IBM DB2 UDB 8.0/7.0, MS SQL Server 8.0/9.0/10.0, MS Access 7.0/2000

Reporting Tools:SSRS, Cognos Impromptu, Cognos Transformer, Cognos Power Play (Cognos Series 7 and Cognos 6.x), Cognos Frame Work Manager, Reportnet, Business Objects 6i/6.0/5.1, MicroStrategy, Data Reports, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), MS Access Reports

Dimensional Data Modeling:Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FCONFIDENTIAL and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3.5.2/3.x, Microsoft Visio.

Programming:T-SQL, PL/SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, HTML, DHTML, C, C++, Unix Shell Scripting

Miscellaneous:MS Office, Microsoft FrontPage, Macromedia Dream weaver, Macromedia Flash, Macromedia Fireworks.

Environment:Sun Solaris 10/9/8/7/2.7/2.6, AIX 5.1/4.3.3, SCO-Unix, Linux, HP-UX, MS DOS 6.22, Win NT/2003/2000/XP

PROFESSIONAL SUMMARY

Confidential, LOS ANGELES, CA MAR’11-Present
OWB ETL DEVELOPER / PENTAHO BI DEVELOPER

Confidential is the second largest school district in the United States. The school district comprises of over 700 schools that serves over 800,000 students teachers and staff annually. The IT department is the primary data source for student enrollment, attendance, test score and demographic reports. The data warehouse is approximately 5-6 TB and has been in production for over 11 years. The district has quarterly releases through which the department addresses Change Requests raised by either the users (teachers, vendors) or by independent businesses. My role during this release was to address these CR’s and modify the existing ETL or in some cases build new mappings.

ETL Responsibilities:

• Modified OWB Mappings that populated large fConfidential 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 prConfidentialices 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 Confidentialions.
• 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, IRVING, TX FEB’10-MAR’11
OWB / ODI DEVELOPER

Confidential is a global leader in delivering innovation in communications, information and entertainment. The Confidential Communication and IT services groups were involved in a large scale data conversion effort. The conversion required the mapping of existing line of business hierarchies to a single stream parent – child hierarchy that would address past issues with reports related to line of business and the process of slicing and dicing the reports.

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 fConfidential 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 fConfidential 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 prConfidentialices 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, HOBOKEN, NJ JAN’09 – FEB’10
Sr. OWB Developer

Confidential is the world’s leading risk and reinsurance specialist and a part of the Marsh & McLennan Companies. Confidential creates and executes reinsurance solutions and delivers capital market solutions for clients across the globe. The firm’s full breadth of services includes line of business expertise in Agriculture; Aviation; Casualty Clash; Construction and Engineering; Excess and Umbrella; Life, Accident and Health; Marine; Medical; Political Risk and Trade Credit; Professional Liability; Property Surety; Terrorism and Workers Compensation

Confidential began producing Experience Reports from a limited Experience Data Mart which was created with data sourced from an existing Enterprise Repository. The major limitation of this Data model was that it only included data from a single data source. Guy Carpenter chose to initiate a project to add global premiums and claims data to the Enterprise Repository and to build a Data Mart to support Premiums and Claims reporting

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 FConfidentials for the Premium and Claim Datamart.
• Besides my responsibilities as a lead, my current role is as the primary point of contConfidential 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 extrConfidentialing
• 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 interConfidentialions 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, IOWA CITY, IA MAR’08 - JAN’09
Sr. Oracle ETL Developer

CONFIDENTIAL is an independent, not-for-profit organization that provides more than a hundred assessment, research, information, and program management services in the broad areas of education and workforce development. CONFIDENTIAL introduced the Work keys test program in the earlier part of 2008. Candidates, on successful completion of the program would qualify for three different certificates (Gold, Silver, Bronze) based on their scores from three aptitude tests- Applied Mathematics, Reading for Information and Locating Information.

Following the introduction of the program, customers requested reports that included Certificate and Test information. The first phase of the project was to build a Data warehouse that encompassed all programs within the CONFIDENTIAL program. Each program within CONFIDENTIAL had different reporting requirements although the core data source structure remained the same. To meet the reporting needs, it was proposed that Datamarts would be built over the data warehouse. The Datamarts (second phase) were built for individual programs thus accommodating different business reporting requirements and supporting ad hoc extrConfidentials that customers requested. The entire ETL process from warehouse to Datamart was developed over a period of a year, using the Oracle Warehouse Builder.

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 extrConfidentialed 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 extrConfidentials 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, KENT, OH JAN’07-MAR’08
ETL OWB DEVELOPER

Confidential, one of the public Ohio universities for undergraduate and graduate students, is ranked among the nations top public research institutions with a student population of more than 34,000 University wide.

The initial phase of the project was mostly directed towards data movement between the existing ERP system (Banner) to a more traditional Operations Data Store from which the reporting team built reports based on requirements from the business users. With the ETL process being at its very infancy part of my responsibilities also included mentoring the existing in house resources in the benefits and the use of the ETL tool.

The second phase of my project involved the building of a very large Human Capital and Finance Datamart. Both of these Datamarts were meant to replace and simplify the existing high normalized table reporting structure within the ODS. Designed and developed a reporting solution that included report development using SSRS and initial ETL development through SSIS.

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 extrConfidentialsto 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 prConfidentialices
• 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 PrConfidentialices 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.