Oracle Data Warehouse

Anil P. Sharma

Cognos ReportNet Level * Certified

** *********** ****** *. 908-***-****

Edison, NJ 08820 C. 908-***-****

E-mail ***********@*****.***

Objective:

IT professional, seeking a challenging career in Architect, Model, Design, Development of Data Warehouse, Database, Project Management and Business Intelligence reporting.

Professional Summary:

Oracle Certified Professional (Application Developer), Cognos ReportNet Level 1 Certified

• IT professional with ten years of full life cycle experience in model, design, development of data warehouse (OLAP) applications, transactional database (OLTP) development, utilizing Business intelligence tools, Cognos Framework Manager, ReportNet, Business Objects, Teradata warehouse 7.0, Oracle 8i/9i/10g/11g, Oracle Designer 6i, Sun Solaris, HPUX, & Windows NT/2000/XP platforms. Assume responsibility, work independently in a result oriented, time-critical environment.

• Experienced in Data Warehouse Kimball methodology, dimensional modeling, ETL, database concepts, SQL tuning, materialized views, index strategies.

• Excellent communication skills, able to explain and document the Enterprise Information Architecture.

• Experience translating functional specifications to technical specifications into development estimates

• Report Development utilizing ReportNet Cognos studio and Cognos ReportNet Metadata Modeling, Cognos Impromptu, Business Objects.

• Excellent programming skills in PL/SQL, SQL, C, and Visual Basic.

• Database tuning, optimization, indexing, partitioning, parallelism.

• Data validation, cleaning, analysis and tuning of Oracle applications

Technology Summary

Hardware / Platforms Windows NT/2000/XP, UNIX

Software / Applications: Erwin 7.x, ER Studio, Business Objects Designer / Reporting 6.0,

Cognos, Report Net Report Authoring, Framework Manager,

PowerPlay series 7, Oracle 8i, 9i, 10g, 11g, Teradata, Sybase, Informatica,

Oracle Forms 4.5/6i, Designer 6i, Oracle Enterprise Manager

Programming Languages: PL/SQL, C, ProC, Visual Basic, Shell Scripting (K, Born, & C),

Tools: SQL Navigator, Toad, SQL Loader, MS Visio, Rational Clear Case,

Clear Quest, Erwin Data modeler 7.x

Professional Experience

02/2009-Present Arch Insurance Group Jersey City, NJ

Data Architect/Modeler

Enterprise data warehouse store’s financial data.

Responsibilities:

Instrumental in complete architecture, re-design and development of data warehouse using Kimball dimensional model. Designed, model and implemented new fact grains, SCD, Conform dimensions, degenerate dimensions.

• Actively participated in requirement gathering sessions with business stake holders, business users, business analysts and project manager.

• Organize business requirements into conceptual, logical and physical (OLAP) data warehouse model.

• Design, model, implemented fact table grain, dimensional tables, dimensional hierarchy.

• Liaise with off shore configuration and support team and provide specs, directions, worked with them to implement release and provide appropriate documents.

• Design business intelligence solutions including ETL, staging and calculations required to support specific related business requirements and information flows.

• Created source to target mapping, validation rules, transformations, and business rules.

• Physical data warehouse design, table partitioning, indexing strategy, materialized views, hands on with PL/SQL, SQL development using packages, program units.

• Designed, developed, made valuable addition to each aspect of physical data warehouse design and development, PL/SQL stored procedures, packages, procedures, SQL tuning, indexing strategies, partitioning, parallel processing, materialized views.

• Developed, interpreted, infomrtica mappings, mapplets, transformation, workflow rules.

• Led dimensional modeling effort working with business analyst, source system designer, business users.

• Manage project tasks, handle dependencies, co-ordinate with business users, inter-departmental teams.

• Involved in ETL tool evaluation, selection, data management strategies, standards, best practices.

Technology Used: Oracle 10/11g, Modeling tool CA Erwin 7.3, PL/SQL, SQL

tuning, Informatica 8.11, MS Visio, SQL Loader.

06/2008- 01/2009 Liquidnet New York, NY

Data Warehouse BI Consultant

Sales application for ATS deals with member-users, global Sales professionals, trades, executions, proceeds.

Responsibilities:

• Responsible for gathering requirements, worked with project sponsors to gather, analyze, and document requirement definitions.

• Developed and maintained data models, data architecture, data management standards and conventions.

• Develops ETL specifications, source to target mapping and other documentation required for ETL development.

• Involved in logical and physical design using dimensional and ER methodologies.

• Designed and developed PL/SQL stored procedures, packages, external tables to extract, transform, load data for data warehousing and business intelligence applications.

• Collaborate with the DBA and Development Team in successful implementation of data warehouse release.

Technology Used: Oracle 10G, Embarcardo ER Studio, PL/SQL, SQL, SQL tuning. SQL Loader,

Informatica 7.0

04/2008- 05/2008 Bank of America New York, NY

Data Warehouse BI Consultant

Investment Data warehouse, stores Institutional and Private Wealth Managements data.

Responsibilities:

• Business requirement analysis, data analysis and specification writing.

• Developed, enhanced PL/SQL packages perform SQL tuning, use SQLLDR.

• Utilized all aspects of Oracle SQL, analytical functions, ranking, rollup, Lag, Lead, Case, merge.

• Maintains data warehouse by archiving and removing old data.

• Enhanced and maintained reports, ad-hoc reports using Business Objects.

• In depth knowledge of database concepts, SQL tuning parameters, materialized views, Indexing strategies.

Technology Used: Oracle 10G, PL/SQL, SQL, Mercury Quality center, Clear Case,

Clear Quest, Business Objects XI, SQL Loader.

03/2007-03/2008 Lord Abbott & Company Jersey City, NJ

Data warehouse Architecture

This data warehouse manages mutual funds investment data; the data warehouse is continues changing to accommodate Investment strategy and business needs. The data is utilized for asset management reporting, portfolio management, client business analysis and external marketing website.

Responsibilities:

• Review, analyze and evaluate business requirements and transform business requirements into software requirements.

• Responsible for maintaining, enhancing data model.

• Developed scripts to process and load mutual fund pricing, performance, holdings data for various Investment applications including fixed income, marketing external web application and equities analytics.

• Migration of Bloomberg Gateway 2.0 JAVA based application to Gateway 3.0. Involved in all aspects of planning, designing and implementation of the project.

• Design, development, and support, SNP, Russell, FTSE, MSCI benchmark data loading and processing utilizing PL/SQL program units.

• Developed, enhanced and maintained reports using Business Objects, ad-hoc reports.

• Data administration involving data analysis, troubleshooting problem in hand, application of DCRF (data change request).

• Load data into warehouse utilizing SQL loader, shell scripting, and Oracle PL/SQL.

• Developing SQL, SQL tuning, database objects creation, indexes, views and synonyms.

• Provided Data warehouse production support during and after work hours on escalated tickets.

• Responsible for reviewing and implementing critical data change request.

Technology Used: Oracle 10G, Rapid SQL, CA Erwin, Quest Toad, Unix Sun

Solaris, PL/SQL, SQL, SQL Loader, Control M scheduling tool,

Knowledge of Data stage 5.0, Bloomberg Gateway 3.0,

Business Objects XI.

07-2005-02/2007 Knight Capital Group, Inc. Jersey City, NJ

Knight Capital Markets LLC (KCM)

Operates as a market maker in the New York Stock Exchange Market

Knight Equity Markets, L.P. (KEM)

Operates as a market maker in OTC (over-the-counter) Equity securities, primarily those traded in the NASDAQ market.

Project Summary:

Pricing Data Analysis: Historical data load, tool that provides impromptu analysis of Stocks.

Financial Report Implementation

Oasys Global: International Trading system implementation.

Brokerage Application: Application calculates prime brokerage by applying client specific Business rules, generates monthly Invoices and delivers invoices to the Clients.

Responsibilities:

• Responsible for the design and instantiation of the physical data model, design data models to meet the analytical requirements of the data warehouse

• Designed and development of ETL scripts for large data warehouse of 4.5 terabytes utilizing oracle 9i functionality, packages, procedures, functions, SQL, PL/SQL, Unix shell scripting.

• Responsible for implementation of business rules using PL/SQL, performance tuning and optimization of database applications, report generation, and Data Analysis.

• Experience loading flat files utilizing SQLLOADER, UTL File, and Bulk load.

• Conversion of logical system design to physical database design. Sizing, partitioning and placement of database structures.

• Responsible space management, batch monitoring, space managements SQL tuning, assist in database synchronization process.

• Extensively interacted with Sybase databases that include developing Sybase SQL, data analysis, and distributed procedures.

• Mentor and newer team members in all phases of their assignments.

• Trading system reporting support, data analysis and data cleaning, validation.

Technology Used: Cognos ReportNet, CA Erwin, Oracle 9i, PL/SQL. Sybase, SQL. Unix

Shell Scripting, Cognos Report Net Studio, ReportNet 1.1,

Framework Manager, Sybase, SQL Loader

03/2005 – 07/2005 KFORCE

Dayton, OH

This system pulls out data from multiple oracle based transactional databases to the Teradata Data warehouse. Data warehouse aims to provide data analyses and ad-hoc capabilities to large group of users though web portal.

• Architect a plan to design and implement a Business Intelligence model to develop standardized and ad hoc reporting utilizing BI tools.

• Transformed Business requirement into technical guidelines.

• Coordinate with DBA and ETL team members to design summary tables and views.

• Designing, developing, implementing and maintaining Business Objects universe and reports.

• Coordinate with ETL team members to design, load summary tables and

Views.

Technology Used: Cognos Report Studio, ReportNet 1.1, Framework Manager, and Business

Objects Designer 6.0, Business Objects reports6.1, Erwin Data modeler

4.0, Oracle 9i, Teradata 5.0, PL/SQL, SQL.

04/2004-03/2005 Theoris Consulting Client- Eli Lilly Indianapolis, IN

Lilly Safety System: System records adverse event associated with product and report to

the responsible authority. Application has global clients and approach.

• Collected business requirements, identified and prepared interviews, documented findings.

• Create and publish packages and develop complex reports based on the published packages by utilizing Cognos ReportNet, Report Studio products

• Multidimensional data analysis, created nested crosstabs, graphics to discover trends and forecasting, calculation, drilling dice and lice utilizing the Power Play Web tools

• Developed complex SQL, database tuning focused on SQL, pl/sql tuning and utilizing standard methods i.e. explain plan, tkprof, Quest Software, Toad. Results noticeable performance improvements.

• Designed and developed a process to verify all the required reporting business rules for a particular report before mailing to the responsible agency.

• Developed a dynamic process to migrate data from other databases to the Lilly Safety System DataMart.

• Developed new objects (Table, indexes, materialized views, PL/SQL Packages, synonyms).

• Designed, developed oracle store procedures, packages, functions and procedures.

• Led team to develop installation procedures and plans, code review, and to improve system performance.

Technology Used: ETL, Cognos Report Studio, Report Net Reporting,

Framework Manager, Power Play 7.0, Business Objects

Designer / Reporting 6, Oracle 9i, PL/SQL, SQL, Unix Shell

Scripts. Relational Clear Case, Relational Clear Quest,

10/03-04/2004 Accenture Consulting / PDD Inc. Indianapolis, IN

Revenue Processing System: System processes taxes, performs tax accounting,

validates registration information, sends refunds

• Enhancing the existing application to validate business rules associated with specific account.

• Designs and develops GUI to input or view taxpayers account information, liabilities, transfer funds, pending accounts, process refunds.

• Extensive data cleaning and data validation involve scripts writing to speed up processing of refunds.

• PL/SQL, SQL tuning, review and modify existing application to improve efficiency.

• Assign work and work with other team-members to resolve any issue associated with the task.

Technology Used: UNIX Shell Scripts, C, ProC, PL/SQL, Oracle 9i, and Forms 6i.

07/03-10/03 TXU Energy Granbury, Texas

Contractor

• Designed, implemented, and supported data warehousing. Responsible for Oracle PL/SQL Development of Data Warehouse’s ETL processes.

• System analysis, designed and developed PL/SQL structured database auditing process, developed packages to validate the business rules.

• Designed an ETL processes to move data from source to destination, perform required data validation and data cleaning.

• Developed inter-session message logging process, system tuning, indexing, building new tables.

• Developed various reports utilizing Cognos Impromptu Tools.

Technology Used: Unix (Sun Solaris), Windows NT/XP, Oracle 9i, Forms 6i, Designer

6i, PL/SQL, and Shell Scripting (Born, Korn).

09/02 to 06/03 RCG Inc. Indianapolis, Indiana

Data Warehouse Developer

• Designed, implemented, and supported data warehousing. Responsible for Oracle PL/SQL Development of Data Warehouse’s ETL processes.

• Designed and developed Cognos-specific solutions, PowerPlay and Impromptu reports, PowerCube building.

• Designed and developed an application to dynamically extract data from the data mart, generated flat files, and exported to the defined destination.

• Physical database design including indexing, partitioning, and data aggregation strategies, creating and managing tablespaces.

• Developed various data mapping, source and target table definitions, creating and modifying repositories, folders using Informatica tools.

• Analysis and tuning of Oracle, SQL and PL/SQL to improve performance.

Technology Used: Unix (Sun Solaris), Windows NT/XP, Oracle 9i, Cognos PowerCube, PowerPlay and Impromptu version 6.0, Forms 6i, Designer 6i, PL/SQL, and Shell Scripting (Korn), Informatica Power Mart, Power Center .

09/00 to 09/02 EDIT /KFORCE/ EDS Inc. Indianapolis, Indiana Oracle Developer

Defense Joint Accounting System

• Developed a process to export and import data to central disbursement data bank.

• Automated the system to process prior fiscal year customer orders resulting in unallocated funds being rolled over to a current financing appropriation.

• Involved in the conversion of Forms 4.5 to Forms 6i.

• Provided production support for reports and forms issues.

Technology Used: Oracle Forms 4.5 / 6i, PL/SQL, Oracle 8i, HPUX.

Check in Check out

• Enhanced code management and submission software, Automated the process to validate user’s login information, validate naming conventions, provide a list of all checked out CI and the identification for the user who has control of the CI.

• Led team for successful implementation of the application.

Technology Used: UNIX Shell Scripts, C, ProC, PL/SQL, Oracle 8i, and Forms 4.5/6i

07/99 to 08/2000 Severn Trent Labs Inc. Houston, Texas

01/99 to 07/99 SPL Inc. Houston, Texas

Education

05/98 Master of Science

University of Houston, Clear Lake, Texas

08/93 Bachelor of Science, Jiwaji University, India

Contact this candidate