OBIEE Consultant

Professional Summary:

• Having 4 years and 6 months of experience in IT support, implementation and consultancy, of which 1 year in Crystal Reports,18 months in ETL Transforms and 2 years in developing OBIEE Reports and interactive Dashboards
• Technical experience in dealing with Business Intelligence applications using BI tools like ETL Tools and OBIEE Analytics
• Working with Business users as an Analyst to translate requirements into the OBIEE Analytics reporting structure.
• Understanding and experience with data modeling, data warehousing, ETL processing, database design, and performance tuning
• Strong in Object Oriented and DW concepts
• Good Analytical, logical, communication & problem solving skills
• Can work independently, and as a team player
• Good in Microsoft Office tools - Excel, Word, Access
• Good in writing SQL queries

Technical Skills :

Hardware : Intel Pentium 4
Operating Systems : Ms-DOS, Unix,Windows 95/98/2000/NT/XP
Languages : C, C++,PL/SQL,Java
Databases : Oracle 10g,MS Access, SQL-Server 7.0
Reporting Tools : Crystal Reports 8.*, OBIEE 10.1.3.4.1
ETL Tool : Datanet (Confidential Internal ETL Tool), Concepts of Informatica

Educational Qualification:

• Master of Computer Applications (MCA).
• Bachelor of Computer Science (B.Sc Comp).

Work Experience:

Confidential SEP '06 -PRESENT

Confidential Analytics Dashboard-Kindle Analytics
Client - Confidential

Description: kindle analytics Dashboard was separately built to analysis kindle collection, newly added asins, approved asins and suppressed asins for a publisher. After kindle was launched in more than 200+ countries, measuring kindle collection across countries and publishers who publish the kindle version of the books was really important.
This Dashboard solves the purpose of collection of kindle asins
Responsible for

• Created Dimensional Hierarchies in Logical Layer to achieve Drill down Functionality dynamically.
• Implemented prompts to provide dynamic filter condition to end users.
• Configured Repository variables to generate dynamic reports.
• Configured session (system & non-system) variables to implement data level security.
• Business requirements gathering data source analysis report dashboard analysis user subject area analysis all which involves detailed defining of fact and dimensions tables (star schema dimensional modeling is used) defining the hierarchies defining the aggregate levels transforming the business requirements to technical requirements and defining the security model.
• Development includes to: - Get the data base connectivity and design the physical layer the business model and mapping layer (BMML) and the presentation layer in the repository (rpd).
• Create the reports like Table, Chart, Pivot, filters and Narrative views and publish them in dash board using answers and dash boards.
• Responsible in developing aggregate DW tables for reporting.
• Using BI publisher delivered requests to users.

Environment: OBIEE 10.1.3.4, Oracle 10GR2

Confidential Analytics Dashboard-Vendor Lead Time
Client - Confidential

Description: This Project calculates the lead time for a Vendor from the time when PO is placed by Confidential, till it reaches Confidential fulfillment Center. Reports developed were basically used to find the glance views, demand for a hot product which is out of stock. Reports can be used to calculate the amount of freight needed to satisfy unplanned customer demand spikes. Business users can quickly view the information as data is categorized into different Organizations, Product Group category etc.
Responsible for

• Created Dimensional Hierarchies in Logical Layer to achieve Drill down Functionality.
• Implemented prompts to provide dynamic filter condition to end users.
• Configured Repository variables to generate dynamic reports.
• Configured session (system & non-system) variables to implement data level security.
• Business requirements gathering data source analysis report dashboard analysis user subject area analysis all which involves detailed defining of fact and dimensions tables (star schema dimensional modeling is used) defining the hierarchies defining the aggregate levels transforming the business requirements to technical requirements and defining the security model.
• Development includes to: - Get the data base connectivity and design the physical layer the business model and mapping layer (BMML) and the presentation layer in the repository (rpd).
• Create the reports like Table, Chart, Pivot, filters and Narrative views and publish them in dash board using answers and dash boards.
• Define ibots/delivers for various requests if needed.
• Add users to the new group and apply the data level and object level security at Repository level as well as web level

Environment: OBIEE 10.1.3.4, Oracle 10GR2

Confidential Analytics Report migration
Client - Confidential

Description: Migration of Reports from Cognos to OBIEE without changing all the functionality of the reports
Migration of Reports from existing Cognos version to OBIEE involves entire process of analytics Data sets again and building repository and developing reports from scratch. Building reports without changing the functionality of the existing reports. Building Dashboards out of reports and deploying them. Involved in migration of DSF Dashboards, 3P selection, Warehouse Deals, Blackberry Reports etc.
Created internal Reports to track performance of queries, errors, TOP Usage of Dashboards, subject Areas, Users etc which will be helpful to track performance and Error tracking etc
Responsible for

• Created Dimensional Hierarchies in Logical Layer to achieve Drill down Functionality
• Implemented prompts to provide dynamic filter condition to end users.
• Configured Repository variables to generate dynamic reports.
• Configured session (system & non-system) variables to implement data level security.
• Business requirements gathering data source analysis report dashboard analysis user subject area analysis all which involves detailed defining of fact and dimensions tables (star schema dimensional modeling is used) defining the hierarchies defining the aggregate levels transforming the business requirements to technical requirements and defining the security model.
• Development includes to: - Get the data base connectivity and design the physical layer the business model and mapping layer (BMML) and the presentation layer in the repository (rpd).
• Create the reports like Table, Chart, Pivot, filters and Narrative views and publish them in dash board using answers and dash boards.
• Define ibots/delivers for various requests if needed.
• Add users to the new group and apply the data level and object level security at Repository level as well as web level

Environment: OBIEE 10.1.3.4, Oracle 10GR2

Confidential Datanet Platform Operations
Client - Confidential

Description: Developing and maintaining of one of the world Largest Data warehouse.
Confidential\'s data warehouse is the historical, integrated data repository where we consolidate browse, sales, fulfillment and replenishment data for all the sites.
Confidential uses Datanet platform to create and use DW. Datanet is the gateway to the data warehouse. Datanet is a collection of web pages and applications used by most groups around the company for extracting data to gain a deeper understanding of the Confidential business, support product development as well as generate reports for our partners. Any Confidential employee willing to abide by the terms of our non-disclosure and trade restriction agreement can be given access to Datanet.
Data warehouse servers load data around the clock from remote instances. Snapshots commence once the local instance\'s work day has transpired--end of day. The data is extracted from SOURCE Tables and temporarily loaded in STAGE Tables, where major transformations take place, unwanted data which is not used for Business analysis will be eliminated here and later loaded into DW tables. These Tables are denormalized and can be used to run aggregate transforms. Aggregated data can be used for by business analytics for decisions, Adhoc querying etc.
Responsible for

• My Role includes executing and monitoring day to day operations.
• Confidential has a set of Jobs which are scheduled to run on periodic basics and load Aggregate tables.
• Tracking long running jobs and involved in performance improvement of the Jobs.

Environment: Datanet (Confidential Internal ETL tool), Oracle 10GR2

Confidential SEP '05 - SEP '06

Tobacco Farmer Partnering Program
Client: Confidential

Description: This project mainly deals with the procurement of the Tobacco (Burley and Fluecured) from the farmer till it reaches Production. This project maintains the details starting from the contracts made by the farmers, Purchasing of Tobacco at Receiving stations, Various types of test performed to identify the quality of tobacco like Percentage of moisture present in tobacco, waste materials etc. based on which price varies. Later all the tobacco will be shipped to tobacco. Client can generate various reports using crystal reports tool.
Major types of Reports include:
New Farmers added to the business this year, for a particular Receiving station and the type of contract made.
Total amount of lbs purchased on a particular day for a particular Receiving station

Responsible for

• Creating procedures which will group data from various sources at desire level and filter out unnecessary data at data base end.
• Developing reports.
• Maintenance of reports

Environment: Visual basic, Oracle 9i, Crystal Reports 8.x