Customer Service Manager
Resume:
SAI VIJAY
OBIEE ARCHITECT
*****.********@*****.***
PROFESSIONAL SUMMARY
. Result Oriented IT professional with around 9 years of progressive
experience in the IT field and 7 years' experience in Oracle Business
Intelligence projects that span the full life cycle implementation of
Oracle Business Intelligence/Siebel Analytics, Informatica and Data
Warehousing.
. Expertise in Developing Oracle Business Intelligence Solutions, gathering
Business Requirements and implementing them using BI Tools such as Siebel
Analytics/OBIEE.
. Expertise in providing end-to-end business intelligence solutions using
OBIEE.
. Extensive experience in OBIEE Answers, OBIEE Intelligent Dashboards, BI
Publisher, OBIEE Administration Tool, Delivers and iBots with OBIEE
Applications.
. Experience in installation and configuration of OBIEE, DAC and
administering permissions, privileges to users based on their groups and
responsibilities.
. Extensive experience in OBIEE/Siebel Analytics, Oracle BI applications
and Informatica.
. Worked on upgrading OBIEE 10g to 11g.
. Upgraded the Informatica repository from version 8 to 9.
. Expertise in handling all phases of Software Development Life Cycle
(SDLC) of the BI Projects.
. Sound knowledge of database architecture for OLTP and OLAP applications,
Data Analysis, ETL processes in developing data marts and Enterprise Data
Warehouse.
. Practical understanding of the Data modeling (Dimensional & Relational)
concepts like Star-Schema modeling, Snowflakes modeling, fact and
dimension tables modeling of data.
. Expertise in design and development of three layers (Physical, Business
model and Presentation) of an OBI Metadata Repository using Oracle BI
Administration tool.
. Configured Answers (ad-hoc querying, reports), Interactive Dashboards
with drill-down capabilities (charts/tables/graphs), Delivers/iBots
(alerts) administered Web Catalog Objects (pages, folders).
. Involved in Business Model development with Dimensions, Hierarchies,
Measures, Aggregation Rules, Time Series and Cache Management.
. Participated in Security Setup at both Object and Data levels, which
involved creation of users/groups, LDAP authentication setup Single- Sign-
On of OBIEE.
. Actively involved in using Repository, Session variables and
Initialization blocks.
. Customized Oracle BI Applications and modified prebuilt solutions
according to the requirements.
. Extensively used the four basic Informatica Power Center client tools -
Repository Manager, Designer, Workflow Manager and Workflow Monitor
. Actively involved in Installing, configuring and customizing DAC
(execution plans, subject areas, tables, and task) and monitoring ETL
process using DAC & Informatica workflow manager.
. Proficient in working on production, development & test environments in
different RDBMS in Oracle 8i/9i,10g,11g, SQL Server, IBM DB2 8.2 and
strong troubleshooting skills
. Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to
11.1.1.6.0.
. Strong experience in back-end programming with Oracle PL/SQL and SQL.
. Soft skills include excellent communication, ability to understand and
analyze the client requirements and have the ability to work in a team as
well as independently.
TECHNICAL SKILLS
Reporting Tools OBIEE 11g, OBIEE 10.1.3.X, Siebel Analytics 7.5, 7.7, 7.8.X,Oracle BI Apps 7.9.X
ETL Tools Informatica, DAC.
Languages/Utili C, SQL, PL/SQL
ties
Operating Windows 95/98/NT/XP/Vista, Server 2003/2007, Unix
Systems
Other Tools SQL Plus, SQL *Loader, TOAD.
EDUCATIONAL QUALIFICATIONS
. Masters in Engineering, Texas, USA.
PROFESSIONAL EXPERIENCE
MEDICA, Minnetonka, MN
Jan 12-
Present
OBIEE/BI Publisher Architect.
Medica provides popular health plans and #1 rated service to business and
government employers, to labor unions, and to individuals of all ages -
from recent graduates to Medicare beneficiaries.
Responsibilities:
. Interacted with the business users for gathering the Reports/ Dashboards
requirements and to define business and functional specifications.
. Involved from scratch to building the reports for Phoenix IFB Project as
part of health care reform.
. Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle
Business Intelligence Admin tool by importing the required objects
(Dimensions, Facts & Aggregates) with integrity constraints into Physical
Layer using connection pool, developing Dimensions (Drill-Down
Hierarchies) & Logical & Facts / Measures objects in Business Model
Layer, and creating the Presentation catalogs in Presentation Layer.
. Developed reports using BI Dashboard and Answers, views & charts.
. Configured metadata objects (Subject Area, Table, and Column) and Web
Catalog Objects (Dashboard, Pages, Folders, and Reports).
. Developed many Analytical and Operational reports using different
Analytics Views (Pivot Table, Chart, Column Selector, and Narrative
View), Dynamic / Interactive Dashboards with drill-down capabilities,
charts, tabular using global and local Filters. Extensively used iBots.
. Analyzed the Health-Rules Application Data and created reports and BI
Publisher Templates for IFB business unit.
. Converted Crystal reports in to OBIEE Reports.
. Converted SAS Reports in to OBIEE Reports.
. Created several BI word Templates for Provider validations.
Environment: OBIEE 11.1.1.6.5, BI Publisher, Oracle 11g, SQL Developer,
AQT,SQL, PL/SQL, Toad 10.1,UNIX.
Imation Corporation, Oakdale, MN
Sep 10-Dec 12
BI Apps Architect
The company Imation is a 1996 spin off of 3M and is headquartered
in Oakdale, Minnesota. The company has been involved in the development of
many technological improvements in data storage, such as the introduction
of the first magnetic tape in 1947, the first quarter inch tape cartridge
for data storage (QIC) in 1984. As a BI Apps Consultant, I administrated
Informatica, DAC and OBIEE.Based on user requirements, some fit-gaps were
identified and customized to load the user required data and debugged
various issues.
Responsibilities
. OBI Apps, DAC and Informatica.
. Interacted with the business users for gathering the Reports/ Dashboards
requirements and to define business and functional specifications.
. Responsible for setting up the environment including installation of
OBIEE, BI Apps and Informatica.
. Worked in a multi user development environment
. Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle
Business Intelligence Admin tool by importing the required objects
(Dimensions, Facts & Aggregates) with integrity constraints into Physical
Layer using connection pool, developing Dimensions (Drill-Down
Hierarchies) & Logical & Facts / Measures objects in Business Model
Layer, and creating the Presentation catalogs in Presentation Layer.
. Managed presentation catalog groups and users settings to web group
folders.
. Developed reports using BI Dashboard and Answers, views & charts, created
filters to obtain weekly sales reports and send alerts to top management.
. Configured metadata objects (Subject Area, Table, and Column) and Web
Catalog Objects (Dashboard, Pages, Folders, and Reports).
. Developed many Analytical and Operational reports using different
Analytics Views (Pivot Table, Chart, Column Selector, and Narrative
View), Dynamic / Interactive Dashboards with drill-down capabilities,
charts, tabular using global and local Filters. Extensively used iBots.
. Development of many complex Informatica mappings and mapplets to build
key interfaces using transformations and reusable transformation units
(Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for
loading data into Data Warehouse.
. Performed Data Validation of data in the reports, Fixed all the errors
and warnings in the repository and web catalog.
. Worked on upgrading OBIEE 10 g to 11g.
. Created custom Reports in Usage tracking reports User Acceleration.
. Worked on Migration of OBIEE 10g to 11g and deployments of web app for
customizations.
. Worked closely with Oracle in resolving the bugs related to product.
. Worked extensively in Oracle BI Security, Web Object Security and Data
Level Security.
. Effectively managed migration of RPD and presentation catalog changes
across environments through catalog manager
. Modified Pre-built OBI Applications dashboards, Answers, Repository for
Sales, Finance, Supply Chain and Order Management Analytics
. Monitored the informatica jobs, which will load the data from OLTP to
OLAP.
. Upgraded the Informatica repository to Informatica 8 to 9.
. Worked closely with Users, Developers and Administrators to resolve
ongoing Production Problems by reviewing design changes made to
production systems and made corresponding changes to Siebel Analytics
Repository.
. Performed the Performance Tuning of Dashboards/Reports and made required
changes to repository and database.
. Performed Unit, Integration and Regression testing to validate reports
and mappings.
. Created the RPD, Reports and Dashboards for source JDA (Forecasting)
against OLTP with several BI functionalities to support forecast
reporting. And thus avoided development time and efforts.
. Integrated the custom EPAATS source with BI for reporting.
Environment: OBIEE 10.1.3.4.1,OBIEE 11.1.1.6.0, BI Apps 7.9.6, DAC
10.1.3.4.1, Informatica PC 8.6.1, Oracle 10g, SQL Developer, SQL, PL/SQL,
Toad 10.1,UNIX.
Verizon Communication, Dallas, TX
Jan 09-Aug 10 Informatica,
OBIEE Developer
Verizon Communications is a Communication giant which operates
internationally. This Business Intelligence application was intended to
develop a data warehouse and a reporting system, which effectively reports
customer behaviour for marketing campaigns, analyze sales from the website
and epos, it also monitors and reports order mgt issues at the sales call
centre and customer service. This improves decision making for financial,
marketing management, customer service teams.
Responsibilities:
. Oracle Business Intelligence (OBIEE), Informatica & DAC
. Interacted with business representatives for requirement analysis and to
define business and functional specifications
. Actively interacted with project managers & team members to discuss
timely deliverables, project status & documented technical specifications
from functional specifications in reporting point of view.
. Involved in gathering the requirements, performing scope analysis and
identifying gaps.
. Developed OBIEE Repository as per user requirements and available
information in Data Warehouse.
. Interacted with Business Users for gathering the Reports / Dashboards
requirements and to define business and functional specifications.
. Designed and developed the Metadata Repository (.rpd) using OBIEE Server
Admin tool by importing the required objects from the database using
connection pool.
. Developed many Reports / Dashboards with different Views (Drill-Down,
Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with
Filters) using OBIEE Presentation services.
. Configured iBots to deliver Analytics content based on schedule,
automated iBots queries to obtain daily and weekly reports.
. Implemented OBIEE Security, both Object level and Row level by creating
roles & web groups, checks with external tables and LDAP.
. Implemented data level security by Creating Users and Groups with
required Privileges and limited the Access to Subject Areas and
Dashboards
. Involved in the Cache management, to improve the overall system
performance
. Developed and debugged Dashboards/reports visibility with respect to
user's responsibility and web groups in an integrated environment.
. Involved in performance tuning of the Informatica ETL mappings like
increasing the caching size, overriding the existing SQL.
. Used Informatica Workflow manager and Workflow monitor for Workflow
sessions and database connection management and workflow monitoring.
. Create Update and tested customization DAC ETL execution plans.
. Identified and solved numerous technical and operational problems in the
Data mart design and ETL implementations.
Environment : OBIEE 10.1.3.4.1, Informatica Power Center 8.6.1,DAC, Oracle
10g, Oracle BI Apps 7.9.X, Toad, DB2,Flat files, Windows 2003 Server.
Pride Mobility Exeter, PA
Oct
07-Dec 08 OBIEE, Informatica Developer
Pride mobility Products Corp. is presently the world's leaders in
designing, developing and the manufacture of top quality mobility products,
including power lift chairs and mobility scooters, power scooters. The
company mission and vision statement clearly shows their strong desire to
remain world leaders in design, development and also the manufacture of the
highest quality, best performing mobility products. The Supply chain
project was intended to develop a data warehouse and a reporting system,
which effectively reports customer behavior for marketing campaigns,
analyze sales from the website, it also monitors and reports order
management issues at the sales call centre and customer service.
Responsibilities:
. Oracle Business Intelligence, Informatica & DAC
. Gathered and analyzed reporting requirements for the sales and marketing
departments
. Interacted with operations and billings subject matter experts (SME) &
business analysts in gathering and analyzing the report requirements for
the sales managers.
. Involved in the business user meetings and subject area layouts.
. Involved in developing and documenting technical specifications from
business requirements
. Configured metadata objects (Subject Area, Table, and Column) and Web
Catalog Objects (Dashboard, Pages, Folders, and Reports).
. Worked on Answers to build Interactive Dashboards with drill-down
capabilities
. Created reports and providing intuitive drilldowns and links to exploit
the full benefit of Analytics.
. Assisted in creation of pivot table request allowing manager to analyze
the business from different perspectives using column selector.
. Implemented dynamic dashboard prompts to zoom into particular segments of
the business in a performance-optimized manner.
. Configured iBots to deliver Analytics content based on schedule,
automated iBot queries to obtain weekly reports, delivery of reports
through email, hand-held devices and mobile phones.
. Implemented Security through external database table authentication and
authorization through session system variables, Initialization blocks and
groups.
. Involved in Data and Dimensional modeling creating Facts, Dimensions and
Measures
. Used Informatica Power Center tools for analysis, design, mapping and
workflow.
. Performed extraction, transformation, and loading (ETL) for data
warehouses by consolidating data from heterogeneous data sources.
. Worked closely with Users, Developers and Administrators to resolve
ongoing Production Problems by reviewing design changes made to
production systems and made corresponding changes to OBIEE Repository.
Environment: OBIEE 10.1.3.4,10.3.3.x, Informatica Power Center
8.6/8.5.1/8.1.1, Oracle 10g, Oracle BI Apps 7.9.X, DAC,MS SQL Server 2005,
DB2 Flat files, Toad, Windows NT.
Infosys, India
Jan 05-Sep07 SQL, BI Developer
Responsibilities
. Siebel Analytics, OBIEE, Informatica
. Interacted with functional & technical leads, SME's, marketing, finance,
and other business groups to identify, analyze, and document business
requirements.
. Designed and implemented custom business intelligence solutions (Metadata
and Dashboards/Reports) using the OBIEE platform
. Developed Metadata Repository (.rpd) with multiple business layers using
complex joins, presentation catalogs with access validations and external
table security repository and repository migration in BI Server.
. Designed and developed many Dashboards/Reports that are Dynamic &
Interactive with intuitive drilldowns, drill-across & flash-based
drillable charts (bar-charts, pie-charts, radars, and bubble-charts), and
local & global filters and cache monitor using Siebel Analytical Web.
. Used Smart View import, manipulate, distribute and share data in
Microsoft Excel, Word and PowerPoint interfaces, there by accessing data
from Relational or Multi-Dimensional sources.
. Configured iBots to deliver Analytics content based on scheduler,
automated iBot queries to obtain daily and weekly reports.
. Performed the Security management for users, groups and web-groups using
the various authentication systems.
. Enhance performance by requesting Aggregate tables, Indexes and managing
Cache after Benchmarking performance tuning strategies with business
model-level calculations versus database level pre-computations and
aggregations.
[pic]
Contact this candidate