Manager Project
Resume:
A R VISWANADHAM Mail: *****.*****@*****.***
OBIEE Consultant
Mobile: +91-964*******
Professional Summary:
. Having 6+ years of Information Technology experience in that 4+ years
of experience in Design,
Implementation, Enhancements and Support of Business Applications
using OBIEE.
. Experience in OBIEE application using Administration Tool, Answers,
Dashboards & Delivers.
. Strong experience in providing end-to-end business intelligence solution
by configuring metadata and building OBI Repository consisting of three
layers (Physical Layer, Business Model & Presentation Layer).
. Experience configuring interactive Dashboards with drill-down
capabilities using global and local Filters, OBI Security Setup (groups,
access / query privileges), Metadata objects and Web Catalog Objects
(Dashboard, Pages, Folders, Reports).
. Expertise in providing end-to-end Business Intelligence solutions by
configuring metadata & building Analytics Repository, Dimensional
modeling, building business models, generating reports and creating
interactive BI Dashboards using OBIEE10.x/11.x.
. Strong in Business Model development with Dimensions, Hierarchies,
Measures, Aggregation Rules, Time Series, Caching & Mapping.
. Proficient in Merging/Importing Objects from Different Repositories using
OBI Admin Tool.
. Hands on experience with security manager, cache manager, variable
manager and join manager.
. Having good knowledge on Data warehouse Concepts.
. Strong knowledge on SQL .
. Expertise in Data Feed Reporting using Informatica Tool.
Professional Experience:
. Working as Sr.OBIEE Consultant for SAPIENT, Gurgaon from May' 2014 - Till
Date.
. Worked as OBIEE Consultant for Royal Bank of Scotland(RBS), Gurgaon from
Apr' 2013 - May' 2014.
. Worked as OBIEE Developer for NTT DATA Global Delivery Services Limited,
Hyderabad from Jul' 2010- Mar' 2013.
. Worked as Test Engineer for Muzigle India Pvt. Ltd., Hyderabad from Sep'
2008 - Jun' 2010.
Technical Skills:
BI Tools : OBIEE 10g/11g
Languages : C, SQL, PL/SQL, HTML, Java Script
Data Bases : MS SQL Server, Oracle 9i/10g
Operating Systems : Windows NT/2000/XP, Linux
ETL Tools : Informatica
Qualification:
M.C.A. from ANNA University.
Project Details
Project #5
Project name : Athena
Client : American District Telegraph(ADT)
Duration : May' 2014- Present
Environment : OBIEE 11.x, Oracle 11g, Informatica, Windows 7
Description:
ADT Security Services, Inc., a unit of Tyco Fire & Security, is the
largest single provider of electronic security services to more than five
million commercial, government and residential customers throughout the
United States. ADT's total security solutions include intrusion, fire
protection, closed circuit television, access control, critical condition
monitoring, electronic article surveillance and integrated systems.1874 In
1874, 57 diverse "district" telegraph delivery companies were joined to
create the new American District Telegraph Company - the forerunner of
today's ADT. In early 1998, ADT, Ltd. was acquired by Tyco International
Ltd. Today, ADT has residential and commercial coverage in about 230 major
U.S. markets.
Responsibilities:
. Gathered Business requirements by interacting with the business users,
defined subject areas for analytical data requirements.
. Created/Modified Metadata repository (.rpd) by using Administration Tool:
Physical, Business Model and Mapping and Presentation Layers.
. Created connection pools, imported the physical tables and then creating
aliases, defined joins and implemented authorizations in the physical
layer of the repository.
. Developed the necessary star schemas in the BMM layer and modified them
in order to accommodate the new business requirements.
. Created different Hierarchies, Levels and implemented Business Logic by
creating level based measures.
. Developed the Facts, Dimensions, necessary hierarchies and complex joins
between the logical tables, adding aggregates in the BMM layer .Creating
Users and Groups and managing the object level and data level security.
. Extensively used different performance tuning methods like Caching,
Aggregate tables and creating indexes on tables.
. Developed many Ad-hoc and standard Reports / Dashboards with different
Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column
Selector, Tabular with global and local Filters) using in the OBIEE
framework.
. Developed reports using Drill across, Drill down using hierarchies like
Geography, Position, product and also the dashboards based on (Groups,
Aggregated Navigation, Time series wizard, Slowly changing dimension,
caching strategy).
. Created iBots to send pre-processed reports using OBIEE Delivers.
. Involved in unit, integration testing and User Training of the generated
reports using Analytics.
. Developed Data Feed reports using Informatica tool.
. Provided Production Support.
Project #4:
Project name : Economic Capital Reporting
Client : Royal Bank of Scotland(RBS)
Duration : Apr' 2013- May' 2014
Environment : OBIEE 11.x, SQL Developer, Informatica, Windows 7
Description:
The Royal Bank of Scotland plc is one of the retail banking subsidiaries
of the Royal Bank of Scotland Group plc, and together with NatWest and
Ulster Bank, provides branch banking facilities throughout the UK and
Ireland. The Royal Bank of Scotland has around 700 branches, mainly in
Scotland though there are branches in many larger towns and cities
throughout England and Wales. The Royal Bank of Scotland and its parent,
The Royal Bank of Scotland Group, are completely separate from the fellow
Edinburgh based bank, the Bank of Scotland, which pre-dates The Royal Bank
of Scotland by 32 years. The Bank of Scotland was effective in raising
funds for the Jacobite Rebellion and as a result, The Royal Bank of
Scotland was established to provide a bank with strong Hanoverian and Whig
ties.
Responsibilities
. Created/Modified Metadata repository (.rpd) by using Administration Tool:
Physical, Business Model and Mapping and Presentation Layers.
. Created connection pools, imported the physical tables and then creating
aliases, defined joins and implemented authorizations in the physical
layer of the repository.
. Developed the necessary star schemas in the BMM layer and modified them
in order to accommodate the new business requirements.
. Created different Hierarchies, Levels and implemented Business Logic by
creating level based measures.
. Developed the Facts, Dimensions, necessary hierarchies and complex joins
between the logical tables, adding aggregates in the BMM layer.
. Extensively used different performance tuning methods like Caching,
Aggregate tables and creating indexes on tables.
. Developed many Ad-hoc and standard Reports / Dashboards with different
Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column
Selector, Tabular with global and local Filters) using in the OBIEE
framework.
. Developed reports using Drill across, Drill down using hierarchies like
Geography, Position, product and also the dashboards based on (Groups,
Aggregated Navigation, Time series wizard, Slowly changing dimension,
caching strategy).
. Involved in unit, integration testing and User Training of the generated
reports using Analytics.
. Provided Production support.
Project #3:
Project name : HMIL Analytics
Client : Hyundai Motor India Limited (India)
Duration : Jan' 2012 - Mar' 2013
Environment : OBIEE 11.x, SQL Developer, Informatica, Windows XP
Description:
Hyundai Motor India Limited (HMIL) is a wholly owned subsidiary of Hyundai
Motor Company (HMC), South Korea and is the largest passenger car exporter
and the second largest car manufacturer in India.HMIL's fully integrated
state-of-the-art manufacturing plant near Chennai boasts of the most
advanced production, quality and testing capabilities in the country. To
cater to rising demand, HMIL commissioned its second plant in February
2008, which produces an additional 300,000 units per annum, raising HMIL's
total production capacity to 600,000 unit. In continuation with its
commitment to providing Indian customers with cutting-edge global
technology, HMIL has set up a modern multi-million dollar research and
development facility in the cyber city of Hyderabad. It aims to become a
centre of excellence for automobile engineering and ensure quick turnaround
time to changing consumer needs.
Responsibilities
. Partnered with the OBIEE team in gathering and analyzing business
requirements from various sources, ensuring the business needs and
delivery feasibility.
. Worked with the ETL team to design the Star Schema and populate the Data
warehouse.
. Built the Physical Layer /Business Model and Mapping Layer/ Presentation
Layer of a Repository by using Star Schemas.
. Created Interactive Dashboards and dashboard prompts for dynamic
filtering.
. Implemented Auto-Complete Filters to provide more flexibility.
. Developed Calculated Measures and dimension hierarchies in the Business
Model and Mapping Layer.
. Configured Web Catalog Objects (Dashboards, Pages, Folders and Reports)
and Implemented different views of report i.e. Pivot table, Titles,
Graph, Filters etc.
. Extensively used different views like Column Selector, View Selector etc.
. Extensively used Prompts and Presentation Variables based on requirement.
. Configured RSS FEEDS for OBIEE reports.
Project #2:
Project name : SMIS
Client : Amara Raja Batteries
Duration : Mar' 2011 - Dec' 2011
Environment : OBIEE 10.x, Oracle 9i, Informatica, Windows XP
Description:
Amara Raja believes in influencing and improving the quality of life by
building institutions that provide better access to better opportunities,
goods and services to people all the time. With innovative engineering,
research and design, Amara Raja has grown with partnerships and information
sharing with world leaders. Amara Raja is committed towards latest
generation technologies by developing and manufacturing globally
competitive, customer focused products of world class quality and
responsibly introducing these products into relevant markets.
Responsibilities
. Worked on Oracle BI Answers to build Interactive Dashboards with drill-
down capabilities.
. Developed business reports using OBIEE Answers to display the reports in
Dashboards.
. Created Interactive Dashboards and dashboard prompts for dynamic
filtering.
. Developed Calculated Measures and dimension hierarchies in the Business
Model and Mapping Layer.
. Configured Web Catalog Objects (Dashboards, Pages, Folders and Reports)
and Implemented different views of report i.e. Pivot table, Titles,
Graph, Filters etc.
. Extensively used different views like Column Selector, View Selector etc.
. Extensively used Prompts and Presentation Variables based on requirement.
. Provided Production Support.
Project #1:
Project name : SRS
Client : JAMNA AUTO INDUSTRIES
Duration : Jul' 2010 - Feb' 2011
Environment : OBIEE 10.x, Oracle 9i, Informatica, Windows XP
Description:
JAI group is a leading manufacturer of multi leaf springs and parabolic
leaf springs for major OEM in India and abroad. The JAI Springs Group
consists of 3 manufacturing units in India. They are the 5th largest
manufacturer of automobile leaf springs in the world. Their customers
include world leaders like GM, Ford, Maruti Suzuki, Toyota, Isuzu etc.
apart from Tata Motors, Bajaj Auto, Asoka Leyland.JAI group is a leading
manufacturer of multi leaf springs its turnover is 6million usd. They are
the 5th largest manufacturer of automobile leaf springs in the world.
Responsibilities
. Created mockup reports and dashboards for review by the business users.
. Customized the OBIEE Repository (physical, BMM, and presentation layers).
. Created connection pools, imported physical tables and defined joins in
the physical layer of the repository.
. Created dimension hierarchies, aggregates, and keys in the BMM layer.
. Modified Presentation Layer to add presentation tables and columns to
meet the business user needs.
. Customized reporting with OBIEE Answers and integrated them into the
Dashboards.
. Generated Reports and Dashboards by using Report features like Pivot
tables, charts and view selector.
. Created dashboards with global prompts, column selectors, navigation, and
automatic drill-down.
Contact this candidate