SUMMARY:

• Senior BI/DW Consultant with more than 10.3 years of software development experience in IT Industry.
• Experienced in Data Warehousing development ETL Design and Development using Informatica Power Center 9.x/8.x and ODI 12C.
• Proficient in DW Concepts, Data Modeling, Star Schema, Dimensional Modeling, Creating Dashboards and Reports using Tableau and OBIEE.
• Experienced in handling PCM
• Worked on defining governance for Tableau/OBIEE Security setup, defining capabilities and Access. Creating Custom Roles and defining their policies, Object level security, Row level security and Data Masking in Tableau/OBIEE.
• Proficient in Debugging, Optimizing and Performance Tuning
• Good understanding of Table level calculation and Secondary level calculation in Tableau, Good understanding of implementing SET, Groups, Variables, Drill Drown and Drill Through.
• Experience in multiple Databases including Oracle, DB2 and SQL Server as Back - end. PL/SQL Development.
• Multi-platform experience on UNIX / Linux and Windows Server family.
• Proven ability to convert business requirement in Technical Solution and acceptable solution. An effective team player with exceptional planning and execution skills coupled with systematic approach and quick adaptability.

SKILL:

Reporting: Tableau 9.0/10.0, OBIEE 11g / 10g, Oracle BI Publisher 11g /10g

ETL: Informatica 9.x/, ODI 11g/12c

Languages: SQL, PL/SQL, XML

RDBMS: Oracle11i/10g, SQL Server 2000/2005, DB2, Hyperion Essbase

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and dimension Tables

Environment: RHEL (Red Hat Enterprise Linux), Windows

Tools: DAC, Tivoli, JIRA, Confluence, SharePoint, HP Quality Center, HP ALM, Visio, Toad, SQL Developer, WinSQL, WinScp

PROFESSIONAL EXPERIENCE:

Confidential, Pasadena, CA

BI Consultant

Responsibilities:

• Configure OBIEE 12c and ODI Components. Build the Standard Practice for ETL and Reporting Development.
• Implemented CDC and SCD Type 2 to maintain History data.
• Configure MUD for OBIEE and Migration Process for DEV to Test and Test to Prod.
• Monitor Domain Load and Data warehouse load using ODI Console.
• Trouble shoot Load process using ODI Console.
• Worked on Interface, Package and Scenario Customization.
• Validation OBIEE Reports after data load process is done and did changes in reports where ever required.
• Working on Designing Data Warehouse Star Model and Subject Area and Customization

Environment: OBIEE 12c, ODI 12c, Oracle DB 11g, Oracle App 12.1.3, PL/SQL Procedures, Linux, Windows 8.1.

Confidential, Des Moines, CA

BI Consultant

Responsibilities:

• Interact with business users and translate the business requirements into conceptual and detailed technical design.
• Responsible for Principal HR Data Integration and Reporting Process.
• Take care of all Inbound and Outbound data feeds from external vendors through FTP for HR Process like W2 Data, 401K, Benefit Data, Payroll (BW, SM), Compensation.
• Support and maintenance of HRDW daily load process on Production and Pilot environment for ETL and Tableau Reports.
• Created Unix scripts to FTP files using FTP Command task in Informatica for Inbound and Outbound files
• Worked extensively on Developing Worksheets, Dashboards, Story Books, Dynamic Filters, Table Level Calculation and Secondary Calculation.
• Implemented Tableau Security and governance. Created Custom Roles, Object Security and Row level Security.
• Involved in merging & migrating applications from Development to Pilot and from Pilot tot production for deployment.

Environment: Tableau Desktop/Tableau Server 9.0, Informatica 9.5, Oracle, SQL Server, PeopleSoft 8.9, Fusion, UNIX, Windows, Shell Scripts.

Confidential

BI Consultant

Responsibilities:

• Worked from initial stage of the project which includes environment setup for Tableau 9.0 for Development, UAT and Production on Windows and Linux.
• Worked with Core Finance Team to gather requirements, Building Report layout, Calculation logic and getting it approved for development
• Closely worked with Finance Team to understand data and their reporting requirements. Created Technical Design document to capture reporting need and take sign off
• Worked on Data Modeling to retrofit the custom tables in Star Model.
• Developed various kinds of reports in various views like Pivot Table, Chart, Tabular reports, Geographical Reports, Trend reports

Environment: Tableau 9.0, Oracle 10g, SQL plus, SQL*Loader, Windows 2003, Red Hat Enterprise Linux

Confidential

Siebel Analytics Developer

Responsibilities:

• This Project was done in a very short duration and complete number of workflows were divided into 6 Waves.
• Hundreds of tables having 500 billion or even more for which we first did History load and then incremental data load workflows were built.
• Prepared Informatica Process for History data load.
• Worked extensively on Creating One time load mapping and Incremental mapping and also enable Auditing logic to track the data load.
• ETL load process was fully audited, ETL process was designed to check for existing Indexes, Drop them before loading and recreate them once data load is completed. ETL process capture details like Target table name, Load Date, Load Id.
• Created Unit Test Document and shared with Client for their Integration testing and approval and then proceed with Promotion Plan.

Environment: Red Hat Enterprise Linux, Informatica 8.x, Oracle 10g, HP Neo View, SQL Developer.

Confidential, Santa Clara, CA

Senior Consultant

Responsibilities:

• Interact with business users and translate the business requirements into conceptual and detailed technical design.
• Supporting and maintaining ETL load process using DAC.
• Worked on Customizations of Type 1 and Type 2.
• Designed the custom STAR Schema for Sales Opportunity & quote in Siebel Data Warehouse (OLAP).
• Design Warehouse Table Creation Script with company naming standards and design the keys which to populate in the Table and send for approval
• Created the blended warehouse architecture for SOD data with existing analytical Booking Billing & Backlog Actuals information.
• Developed rpd metadata for custom BI reporting based on Sales Opportunity and Actuals.
• Built security model in rpd & presentation catalog for corporate data visibility of various Market Segments.
• Responsible for JDSU ADSI (LDAP) integration with OBIEE for corporate user authentication.
• Responsible for generating alerts and e-mail notification to business users through iBots.

Environment: OBIEE 11.1.1.7, PowerCenter 7.1.1, Power Exchange for Web Services, DPA, TOAD, Oracle EBS 11.5.10, Siebel 7.5.3, Siebel CRM on Demand Web Services API, Linux AS4

Confidential, Palm Beach Gardens, FL

Senior Consultant

Responsibilities:

• Extensively involved in requirement gathering & analysis, creation of functional requirement (MD 50) document and in translating it into the technical design (MD 70) document.
• Interacted with Hyperion Essbase to understand the cross section of the cube, Structure and working aliases.
• Built Hyperion Financial Reports on top of Essbase Cubes (ASO, BSO).
• Created Profit and loss report, Variances report, Assets and Liability Reports
• Configured Reports to have drill to details, Drill Through and LRO (Linked to Report Functionality).
• Report Script for Cube Data Validation with Financial Reports.

Environment: Hyperion Financial Reports 11.1.2.1, Hyperion Essbase 11.1.2.1, Smart View, Report Script, Oracle Fusion Apps, Oracle 10g, UNIX Box

Confidential, Sunnyvale, CA

Senior Consultant

Responsibilities:

• Responsible for developing BI Publisher Reports, support and its maintenance.
• Designing RTF Template which generates output in PDF, Excel, MS Word.
• Designed .xlf File for support multi lingual report.
• Created reusable Templates which can be called at run time and reduce the support and maintenance.
• Report hold conditional formatting, multiple loops and Hide column on conditions.
• Worked on High level Design approach and Low level Design approach.
• Worked on Layout designing and format designing.

Environment: BI Publisher 10g, Oracle Application R11.5.9 to R12, PL/SQL, XML, RTF Template Designing, .XLF file creation, Oracle 10g, Unix Box.

Confidential

Senior Consultant

Responsibilities:

• Responsible for developing OBIEE and BI Publisher Reports, support and its maintenance.
• Setup Production Servers in cluster to support failover mode.
• Designing and Creating ODS using materialized View as per the reporting.
• OBIEE Reports cover all the three stages of Loan ( Origination, Collection and Management Modules)
• Worked with Oracle BI Repository like, Presentation Layer, Business Model and Mapping Layer (BMM), Physical Layer and migration of the Code, Repository (RPD),
• Dashboard Reports from Dev to Test/QA and to Production and developed Folders, Dashboards, Pages Columns, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts.
• Worked on High level Design approach and Low level Design approach.

Environment: OBIEE 10g (Dashboards, Answers, Delivers, Scheduler, RPD), BI Publisher 10g, Oracle Application R11.5.9 to R12, PL/SQL, XML, RTF Template Designing, Oracle 10g, UNIX Box

Confidential, Mountain View, CA

Senior Consultant

Responsibilities:

• Preparing and Creating Warehouse Tables, Synonyms and Indexes.
• Responsible for developing OBIEE Reports, their support and maintenance.
• Worked with Oracle BI Repository like, Presentation Layer, Business Model and Mapping Layer (BMM), Physical Layer and migration of the Code, Repository (RPD),
• Dashboard Reports from Dev to Test/QA and to Production and developed Folders, Dashboards, Pages Columns, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts.
• Worked with Oracle BI (OBIEE) Installation, Oracle BI Server, Presentation Server, Oracle BI Repository (RPD), Oracle BI Administration.

Environment: OBIEE 10g (Dashboards, Answers, Delivers, Scheduler, RPD), Informatica Power Center 8.1.1 (Designer, Workflow Designer, Workflow Monitor), PL/SQL, Oracle 10g, UNIX Box

Confidential

Consultant

Responsibilities:

• Preparing and Creating Data Model in Hyperion IR based on the SQL.
• Hyperion Report was automated to fetch 3 Month old and Next 3 month Data from current month.
• Summary report was fetching data from Hyperion Essbase Cube (ASO).
• Worked on High level Design approach and Low level Design approach.
• Cascading Report Selection have Save Selection was implemented in the Reports.
• Working on Layout designing and format designing, discuss the layout with client and finalize the layout.
• Publish Hyperion IR Reports on Hyperion Server.
• Working Unix scripting to automate the process to FTP files and Cron Jobs to schedule the jobs.

Environment: Hyperion Workspace 9.2, Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio, Essbase Analytic Services, PL/SQL, Oracle 10g, Unix Box

Confidential

Developer

Responsibilities:

• Interacting with Module lead to understand the Reporting Requirement.
• Preparing and Creating Data Model in Hyperion IR based on the SQL.
• Configure Access table to access Reports base on the URL navigated from Web page.
• On Cell click it fetches Detail data from RDBMS (Hybrid Analysis).
• Worked on High level Design approach and Low level Design approach.
• Cascading Report Selection and Save Selection was implemented in the Reports.
• Working on Layout designing and format designing, discuss the layout with client and finalize the layout.
• Publish Hyperion IR Reports on Hyperion Server.

Environment: Hyperion Workspace 8.5, Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio, PL/SQL, Oracle 10g, Unix Box