[var] => content
[type] => preview
[var] => cut_url
years of effective experience in Complete Software development Life
cycle SDLC which includes Business Requirements Gathering,
System Analysis & Design, Data Modeling, Development, Testing and
Implementation of Data warehouse and Business Intelligence Applications.
Implemented BI solutions
in various domains such as Oracle Financial, Sales, Human Resources
and Health Care and worked on end to end implementation of BI
APPS which include OBIEE, INFORMATICA and DAC.
in installing, configuring of OBIEE/Siebel Analytics, Informatica,
Oracle g and DAC.
PreBuilts implementation BI Apps for various modules like Sales,
Finance, Order Management and HR analytics in with integrating the ERP
Systems like Oracle EBS, PeopleSoft and Siebel.
in building business models & analytical repository RPD
configuring Metadata, Answers, Delivers / iBots, developing dynamic
& Interactive Dashboards with drilldown & drillacross
capabilities, Security Setup, and Web Catalog Objects
using Oracle Business Intelligence.
of data warehousing concepts, dimensional modeling, designing Star
and Snowflake schemas.
Caching techniques to improve the performance of BI server and performance
tuning were done at Database level, Repository level and Dashboard
level to improve the efficiency of the system.
Developed and scheduled
I Bots using BI delivers to deliver Analytics
content based on schedule, automated IBot queries to obtain daily and
and installed BI Publisher and integrated with OBIEE server and
created Smart View Report Templates.
extensively worked in Multi User Development MUDE
and performed some Administration
tasks such as Creating users, groups, Projects and provide required
authentication as needed.
Expertise in Oracle
SQL and database Performance Tuning by implementing Parallel
Execution, Table Partition, materialized views with query rewriting,
creating appropriate indexes, usage of hints, rebuilding indexes.
by creating roles & web groups using LDAP Authentication
ETL methodology for supporting Data Extraction, Loading and Transformation
processing using prestaging, staging approach in Informatica Power
Center and Power Mart.
Data warehouse Administration Console DAC to Configure, Monitor
and Schedule ETL routines of Full and Incremental ETL
loads of the Oracle Business Analytics Warehouse.
in UNIX and writing shell scripts for execution of the
work flows and scheduling the tasks.
and diligent team member with strong technical background and good interpersonal
Electricals and Computer Engineering.
Siebel Analytics ././ ,Oracle BI Apps ..x.|
||Informatica Power Center ..x/..x/.x.|
||Data Ware Administration Console
||UNIX scripting, Linux, Windows.|
||Toad, SQL Developer.|
||HTML, DHTML, ASP, JSP, XML,
||Oracle g, g/i, Oracle
EBS, PeopleSoft. |
||Star Schema Modeling, SnowFlake
Sony Ericsson Mobile Communications
is one of the leading cellular companies. The project provides Oracle
Financial and Sales Analytics solution implemented with BI Apps.
It helped the company to enhance decision making process regarding the
GSM products and customers. The system will allow users to perform data
analysis and track customers and their details through reports developed
Used the OBIEE
...x, OBIEE Administration tool to develop and enhance metadata.
pools, physical tables, defined joins and implemented authorizations
in the physical layer of the repository
Configured and Created
repository using OBIEE Admin tool.
with Physical Layer, Business Layer and Presentation Layer.
executive level reports. ‘Dashboards’ were generated to provide
insight into the sales/marketing/financial data.
using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
types of Customized Reports Drilldown, Aggregation to meet
Built Business model
and established relationships & Foreign Keys Physical &
Logical between tables.
reports using BI Answers as per requirements.
& Full load through DAC.
Full and Incremental loads through DAC on different environments
like Development and Test environment.
Analytics Reports like Formulary Report and Direct Sales Report
using global and local filters.
Involved in modifications
of physical, business and presentation layers of metadata repository
using OBIEE Administration Tool.
aggregate levels for each source and created dimension sources
for each level of aggregates.
Involved in managing
appropriate security privileges on subject areas and dashboards
according to business requirements.
reports/Adhoc queries using OBIEE Answers and assigned them
to application specific dashboards.
kinds of Reports pivots, charts, tabular using global and local
agents IBots and interactive Dashboards to alert the Marketing
team about business changes.
Rpd, Scheduler & IBots.
privileges for each subject area and dashboards according
to user requirements.
Setting up LDAP
authentication to enable SingleSign on for Users in Development
environment leveraging Analytics Repository
Created groups in
the repository and added users to the groups and granted privileges
explicitly and through group inheritance.
Involved in developing
the Incremental ETL process by Informatica Mappings &
Mapplets using various Transformations.
OBIEE ..., Oracle BI Applications ..Finance Analytics,
Sales Analytics, Informatica, DAC, Oracle g,g, PeopleSoft
,Siebel CRM, SQL Developer, SQL*Plus, Toad, WindowsXP.
Jan ‘ –Feb’
department categorizes customers based on a significant set of portfolio
services that includes checking accounts, savings accounts, and personal
project was aimed at building an Investment Data Warehouse, which provides
Financial Statement, Capital Gain Analysis, Performance, Measurement
with the end users for requirement gathering and defined requirement
specifications document by access and retrieval of financial and personnel
data from one single source.
Created Facts, Dimensions, and Hierarchies of the business model.
Value Detail, Work Order Detail and OGA Repositories
RPD by importing metadata into Physical Layer, applied
Business rules in the Business Modeling and Mapping layer and
created customized user views in the Presentation layer.
Groups and set permissions for items in the presentation
catalog and privileges and rights to users and groups.
Designed and Tested
Reports in the Dashboards for the Oracle Financial Analytics
modules like GL, AP, AR and created the Adhoc report
according to the client needs.
Dashboard with drilldown capabilities using global
and local Filters, Metadata Objects and Web Catalog
Prompts and Multi Level Prompts
performance bottlenecks, and optimized the Business Intelligence
Dashboards and Reports.
kinds of reports pivots, charts, tabular using global
and local Filters.
SQL Codes for the reports.
Techniques for the better performance of the reports.
Involved in Monitoring
and Scheduling different process flows using Oracle Work Flow
Used external tables
to Transform and Load data from Flat files into
Used Debugger to
validate Mappings by creating break points to analyze and
monitor Data flow.
Involved in troubleshooting
the load failure cases, including database problems.
by authenticating against the LDAP
and external table.
Trained End Users
and Pilot Users about OBIEE Tools.
developing, support and maintenance
of the ETL Extract, Transform and Load
processes using Informatica Power Center.
OBIEE .../..., Oracle BI Applications ..
Financial analytics, HR analytics, Informatica.., DAC,
Oracle g, Oracle EBS,
SQL Developer, SQL*Plus, WindowsXP.
Medical Devices, India
Medical Devices is the largest Pharmaceutical products company in India.
The Administrative system deals with the overall functions of the accounts
department right from the initial input of the transaction to the final
presentation of the financial statements. The system was built to transport
data from these source systems into one integrated data warehouse, which
would allow for storage and reporting.