SUMMARY:

• Over 15 years of experience in developing and maintaining Business Intelligence and ETL processes to support the data warehouse and Reporting Solution, using Oracle Data Integrator (Sunopsis), OWB, Informatica, Oracle Discoverer, Oracle Portal, Oracle Report and OBIEE (10g - 11g). Involved in metadata management and implementing Data Quality processes.
• Have monitored workflows and performance tuning in a data warehouse environment. Have also been involved in data modeling for expanding data warehouse.
• Over six years of an extensive experience with the complete suite of Oracle Business Intelligence Enterprise Edition (Siebel Analytics).
• Experienced on Informatica Power Center 5.x/6.x. excellent knowledge of SCD, CDC and dimensional modeling (Star and Snowflake schema).
• Excellent knowledge of data modeling and normalization techniques. Excellent knowledge of modeling tool ER Studio etc.
• Acted as a leader of the technical ETL team that is responsible for delivering the warehouse migration effort
• Led a team of data modelers that designed data warehouse table structure.
• Actively participated in requirement gathering and analysis.
• Designed and Developed ODI components
• Designed and Developed the ETL data flow approach using ODI, OWB, Informatica and PL/SQL.
• Experience with the full breadth of OBIEE tools (BI Server, Answers, Interactive Dashboards, and BI Publisher, metadata, DAC, Informatica, and ODI etc.)
• End to end implementation with Oracle Utility Business Intelligence (OUBI) 2.4
• Implemented the integration with Customer Care & Billing (CCB) and Meter Data Management (MDM) Application for OUBI 2.4
• Experienced on Oracle Utility Business Intelligence 2.4
• Experienced on Oracle Business Intelligence Application
• Experienced on Informatica Power Center 5.x/6.x/7.x/8.x/9.x
• Excellent knowledge of SCD, CDC and dimensional modeling (Star and Snowflake schema)
• Excellent knowledge of data modeling and normalization techniques
• Excellent knowledge of modeling tool Erwin

PROFESSIONAL SKILLS:

Software and Tools: OWB 11g Release 1/2. OWB 10g Release 2, OWB 10g Release 1, PowerCenter5.1/6.1/8.x/9.x (Informatica), Oracle Data Integrator, OBI EE

Databases: Oracle 8.0.5 / 8i / 9i / 10g/11g

Hardware: ISB PC

Operating Systems: Windows 2000 / NT 4.0, UNIX, Linux

Other: Oracle Application Express, Discoverer 10g, OLAP Analytical Workspace, BI Publish, Oracle BI EE, HTML DB

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Senior Technical BI/DWH Solution Architect

Responsibilities:

• Proposed on Migration project from Hyperion IR to BI Publisher
• Proposed Supply and demand Enterprise Data Warehouse
• Proposed Oracle BI Application for Financial, Supply Chain and few other modules
• Implemented Oracle BI Apps for Finance, Supply Chain and Procurement Analytics
• Helped team defined Data Warehouse best practice
• Interviewed Supply and demand users and gather the requirements
• Interviewed Financial users and gather the requirements
• Provided multiple user trainings to make users comfortable with Oracle BI tool
• Worked with DBA on seting up Golden Gate replication
• Interacted with business analysts for better understanding of individual subject areas and modified specifications to reflect accurate user requirements.
• Configured and setup ODI, master repository, work repository, Models, sources and Knowledge Modules.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse OBAW .
• Creating and customizing ODI interfaces, mapping, joins, filters lookups to implement business rules.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Essbase, Relational Database Management servers including Oracle RDBMS, SQL Server, and IBM DB2 and flat files including CSV, Excel, XML file formats .
• Worked on Topology Manager module to manage the data describing the information systems physical and logical architecture.
• Responsible for Metadata Administration, managed Data models and reverse engineering.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data and integrating it.
• Part of STEP ERP project by implementing Oracle BI Apps using ODI and OBIEE application tools .
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Maintained security by assigning permissions to reports and dashboards based on users and groups.
• Performance tuning in OBIEE repository level and reporting level.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Created different types of Customized Reports Drilldown, Aggregation for Sales and Product to meet client requirements.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger GL .
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Implemented LDAP authentication and configured application roles for authorization.

Confidential, Ashburn, VA

OBIEE-OBIA / Data Warehouse Lead Architect

Responsibilities:

• Created the Project plan
• Hired resources
• Distributed worked based on the activities
• Helped understand Data Warehouse concepts
• Walked through the ETL data flow with their data
• Defined the timeline for the ETL activities
• Existing Reports/Dashboards analysis
• Existing Database structure analysis
• Defined Dimensional Data model
• Define Logical/Physical Star Schema based on their existing data source
• Worked with client to defined the ETL approach using PL SQL
• Wrote PL SQL scripts to load Dimensions and Facts
• Install and Configure OBIEE Standlone
• Build RPD to support their entire Business requirements
• Evaluated Tera Data for building RPD to support Production environment
• Built RPD with Teradata as source
• Tested the features and reports on Teradata platform
• Setup and configured GARM security with OBIEE
• Defined defferent Seesion variable to support row level security
• Setup Dev environment for Oracle Pricing Analytics
• Installed and Confifured BI Apps 7.9.6.4
• Installed DAC (Data Warehouse Administrator Console) and configured
• Worked with DBA setup Golden Gate replication for one schema to use as source for ETL
• Installed Informatica 9.5.1 and configured
• Created the Data Warehouse with pre-build Dimensions and Facts
• Installed OBIEE 11.1.1.7.0
• Installed and configured ODI and Analytics Data Warehouse
• Setup and configured Usage Tracking
• Configured BI Apps for Oracle Pricing
• Create and setup OBIEE different Roles and Policies
• Defined Row level security
• Defined and created the Dimensional modeling for OBIA Data Warehouse
• Modified exiting Dimensions and Facts in Informatica Powercenter and loaded
• Configured the DAC Server and setup Informatica repositoryInformatica Workflow
• Configued Versioning in Informatica
• Setup Informatica Security
• Groups
• Users
• Roles
• Designed appropriate Architecture for Informatica Server
• Configured Oracle BI Applications Informatica, DAC and OBIEE, implemented Oracle out of the box Prebuilt Apps.
• Customized Business Intelligence BI Applications, prebuilt BI solutions. Oracle Financial Analytics delivers, implemented for the financial services.
• Experience in extracting data from Oracle EBS, OLTP, flat files and loading data to OBAW-OLAP systems.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
• Designed and built Oracle BI Analytics data model, designed customized Star and Snowflake schemas by extending Fact and Dimension tables.
• Created Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer.
• Developed and debugged many Dashboards / Reports with different Analytics Views Pivot Table, Chart, Tabular and View Selector
• Developed Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Implemented Security by creating roles web groups, External tables and LDAP.
• Analyzed, Designed, and Developed OBIEE Metadata repository RPD that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Developed many delta / incremental complex Informatica ETL process and Oracle Packages i.e., Mappings Mapplets using various Transformations and monitoring Incremental Full load through DAC.
• Worked extensively to customize DAC Execution Plans, Subject areas, Task Definitions and Tables for OBIEE Financial Analytics.
• Developed various kinds of Reports Pivots, Charts Tabular using global and local filters.
• Security management for users, groups and web-groups using the various authentication systems such as Active Directory authentication using Session Variables to create Row-level security, as well as Dashboard / Report-level security.
• Created Session Repository variables to achieve desired functionality.
• Implemented prompts to provide dynamic filter conditions to end users.
• Customized report look and feel using column formatting and conditional formatting.
• Tuned OBIEE Reports to improve the performance.
• Implemented Cache Management techniques to improve the performance on both real time and non-real time reports.
• Configured IBots to deliver Analytics content based on Schedule to obtain weekly reports and sent notifications Alerts.

Confidential, Cherry Hills, NJ

OBIEE Technical Lead Architect

Responsibilities:

• Defined OBIEE Architecture.
• Installed OBIEE component.
• Managed OBIEE Weblogic and Enterprise Manager.
• Created RPD for different subject area.
• Help ETL team to defined the Fact data grain based on the requirement.
• Worked on OBIEE report Performance.
• Helped DBA to create Table Partitioning.
• Worked on existing DWH Data Model and quested required changes and addition.
• Created multiple reports.
• Help BI team to understand how to manage OBI Weblogic and EM.
• Defined Sales, Inventory, Consumer and Finance Dashboard layout.
• Created Manufacturing Dashboard.
• Deployed Sales, Manufacturing Dashboard to UAT.
• Helped ETL team to create summary table.

Confidential, Colchester, VT

DWH/BI Technical Lead Architect

Responsibilities:

• Install and configure OUBI out of the box.
• Install and Configure OBIEE.
• Install and Configure Oracle database.
• Configure Oracle demo data into database.
• Install and Configure Oracle Warehouse Builder (OWB).
• Configure Extract Process for CC&B and MDM.
• Created Service scripts in CCB and MDM per requirement for the Data Warehouse Configuration.
• Gather CC&B and MDM requirement.
• Modified ETL based on the requirement.
• Migrated OBIEE RPD in multiple environment.
• Modified OBIEE RPD based on the report requirement.
• Created more than 100 reports and 10 dashboards except OUBI out of the box.
• Managed the entire environment single handed.
• Setup and configured the OBIEE security.
• Setup and configured Active Directory with OBIEE Default Oracle Weblogic LDAP security.
• Created the project plan.
• Interview and built the BI team.
• Loaded initial and incremental data and unit tested.
• Unit tested the OBIEE reports.
• Created the development design document.
• Defined the end to end integration test process and created the documentation.
• Installed and configure ODI.
• Designed and developed a data mart using ODI for OUBI enhancement.

Confidential

BI/DWH Lead and Architect

Responsibilities:

• Designed and Implemented ETL Architecture
• Gathered the requirements with Analyst
• Understand the Report requirements
• Designed and Created detailed ETL specification documents
• Created Detailed ETL Design document
• Designed and Created the ETL Process Flow
• Designed and Created the Data Warehouse Architecture Document
• Defined the DWH Partitioning
• Defined the DWH sizing
• Interviewed and hired ETL Developers
• Installed and Configured OWB
• Created the Repository and user for OWB
• Working closely with user to capture the ETL logics
• Helped creating OBIEE RPD
• Helped PM in creating ETL project plan

Confidential, Alexendria, VA

ETL Lead

Responsibilities:

• Analyzed the existing environment
• Data Quality for the manual ETL loads
• Modify their existing ETL process as per the client requirement
• Running daily ETL load and monitor
• Refresh the entire Reports
• Development of new subject area in existing EDW
• Design and created Logical and Physical Data Model
• Analyzing of the data
• Gathering requirement for new development
• Create connect with Business Object (BO) and Dev environment
• Created Universe using Business Object Designer
• Setup repository on Dev (Oracle DB) environment
• Exported & Imported the Universe to create reports in BO InfoView

Confidential, Washington, DC

OBIEE & APEX Lead

Responsibilities:

• Analyze different source.
• Gathered requirements.
• Solved relationship issues and created dimensioning model using OBIEE Admin tool.
• Created VCOP reports and Dashboard as per the requirements.
• Demonstrated the reports to the CVOP team.
• Installed and configured OBIEE as per the requirement
• Installed and Configured OBIEE Application on top of Oracle E-Biz Suite (Financial Apps)
• Installed and Configured DAC & Informatica
• Customization on their pre-build mapping using Informatica and DAC server
• Created an Confidential connection with Oracle Database
• Created the Subject area in OBIEE Administrator tool
• Imported the meta data in the Physical Layers
• Created the star schema
• Created the relationship between Dimension and Fact table
• Installed & Configured Apex Development Environment in Linux for EPA
• Gathering EPA requirements

Confidential, Kansas City, MO

ETL Developer Lead

Responsibilities:

• Created ETL project plan
• Created the entire design template for the project
• Resource and work planning
• Client meeting and requirement gathering
• Managed to build a good synergy that helped to deliver data marts with efficiency
• Analyzed existing shell and PL/SQL scripts and created high and low level design documents for developing ODI interfaces
• Did initial estimation of the effort required for migrating all the data marts from Informix to Oracle by rewriting ETL process in ODI
• Involved in discussion with data mart owner’s to understand current process and design to be process in Oracle
• Developed and tested interfaces, procedures and packages in ODI for historical data load and daily incremental load process
• Developed ODI interfaces for extracting the data from files and database tables and load them into Oracle database
• Customized ODI knowledge modules for specific requirements
• Created scenarios in ODI for scheduling purpose
• Defined ETL strategy for handling large volume of data for history load and ad-hoc data process
• Performed initial tool setup and testing of ODI installation
• Configured agents at local and remote server
• Mentored junior team members and trained team members on ODI
• Identified bugs in ODI tool, identified limitations and suggested areas of improvements to Oracle
• Participated in the requirements gathering phase
• Drove the solution architecture of the ETL solution
• Provided subject matter expertise around OBIEE
• Led a team of 10 ETL developers in the development of over 100 ETL programs using ODI
• Developed and tracked the project plan for the ETL team
• Designed and developed the most complex ETL process
• Enforced development standards
• Provided technical quality assurance on all ETL programs

DW/BI Lead

Confidential, St. Pettersburg, FL

Responsibilities:

• Gathered Business requirement
• Created the logical and physical Data Model
• Created Users in Oracle Portals and Discoverer
• Developed new Portal pages
• Maintained EUL, Business Area and Workbook in Discoverer
• Migrated Workbook and Discoverer with Portal
• Created Publics Connection
• Created OBIEE repository
• Created Physical layer, BML/BML and Presentation layer
• Created reports through Oracle BI Answer
• Created OBIEE Dashboards
• Created complete documentation
• Defined the ETL architecture
• Loaded the star schema using OWB 10G R2/11 G R1
• Migrated complete Data Mart and Data Warehouse to OWB 11g R1
• Defined and Created Process flow

Confidential

Senior Staff Consultant

Responsibilities:

• Built data warehouse for multiple clients using OWB
• Built the Physical Layer of a Repository
• Built the Business Model and Mapping Layer of a Repository
• Building the Presentation Layer of a Repository Testing and Validating a Repository
• Created Calculation Measures
• Organizing the Presentation Layer
• Used Initialization Blocks and Variables
• Added Multiple Sources
• Executed Direct Database Requests
• Used Aggregates
• Created Time Series Measures
• Built charts sales for the last 12 months by channel, country region, and product category with the help of BI Answers and BI Interactive Dashboard and provides trend analysis data as well as narrative highlights of categories that have declined in sales in the last month.
• Created Confidential Connection
• Restored Business Intelligence Presentation Catalog and Updating Metadata
• Created a Query and a Chart
• Worked With a Pivot Table
• Created a Narrative View
• Created Column Selectors and View Selectors
• Created an Interactive Dashboard
• Also involved in developing two projects for two different Customers on Oracle Business Intelligence Enterprise Edition (Siebel Analytics)
• Used Oracle BI Server for the business models and abstraction layer
• Used Oracle BI Server Administrator for handling metadata
• For the Ad-hoc query and reporting I have used Oracle BI Answers
• Loaded all data into the Warehouse as per the customer requirement
• Involved in Validation, Generation and Execution using Oracle Warehouse Builder Release 2
• Developed data Mappings, Transformations between source systems and warehouse using Oracle Warehouse Builder Release 2
• Created OLAP cube with the help of Oracle Warehouse Builder Release 2
• Developed and tested all the backend programs, Oracle Warehouse Builder Release 1 mappings and update processes
• Created few reports with the help of Oracle 10g Discoverer based on the sample report which we received from the customer
• Generated several reports using Oracle 10g Discoverer
• Created Star Schema as per the user requirements.
• Involved in Validation, Generation and Execution using OWB
• Developed data Mappings, Transformations between source systems and warehouse using Oracle Warehouse Builder 10g R1/R2
• Created Analytical Workspace i.e. OLAP CUBES through Warehouse Builder and AWM
• Developed and tested all the backend programs, Oracle Warehouse Builder Release 1 mappings and update processes

Environment: Compaq Servers, IBM PC, Windows NT, Linux, Unix, Oracle 10g, Oracle Warehouse Builder Release 1, Discoverer 10g

Confidential

Software Engineer

Responsibilities:

• Involved in requirement gathering
• Created and Monitored Batches and Sessions using Informatica Power Center Server Manager
• Developed data Mappings, Transformations between source systems and warehouse using Informatica Designer
• Developed and tested all the backend programs, Informatica mappings and update processes
• Created, Maintained Repositories and deployed Informatica transformations, Mappings, Sessions, batches from Development to Production
• Created Mappings and Transformations like Aggregator, Expression, Filter, Update Strategy etc. as per the Design