Dedicated IT professional with 7+ years of progressive expertise in design, configuration, development, testing and implementation of Data warehousing and Business Intelligence Applications.
Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools and DAC in Banking, Financial, Pharmaceutical, Insurance and Sales & Marketing domains.
Worked extensively in the analysis and development of Data warehousing applications using Siebel Analytics 7.x/OBIEE 10.1.3.x.
Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer)
Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.
Hands on experience in customizing reports, filters and charts in Oracle Answers.
Experienced in usage of Disconnected Analytics and Siebel/Oracle Delivers for sending alerts via intelligence agents (iBots) to the dashboards for the end users.
Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views .
Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL.
Proficiency in security management of all aspects of OBIEE (Siebel Analytics).
Knowledge in extracting data from Siebel CRM, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
Knowledge in Data warehousing development using ETL tools such as Informatica Power Center 8.x/7.x/ 6.x and developed Informatica Mappings and Workflows with Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
Knowledge of Data warehouse Application Console (DAC) Architecture
Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.
Excellent interpersonal and communication skills for efficient client interaction.
Bachelors : Electronics and Computer Engineering, India
OBIEE 10.1.3.x,Siebel Analytics 7.x,Oracle BI apps
Informatica Power Center 8.x/7.x/6.x
Toad, SQL Developer, SQL*plus, DAC (Data Warehouse Application Console)
Oracle10g/ 9i/8i, SQL Server , Siebel CRM, Oracle EBS, MS Access.
Windows, UNIX, Linux
SQL, PL/SQL, UNIX Shell Scripting, C,C++
Citigroup Inc, NY Apr’08-Till Date
Sr OBIEE Consultant
The Finance department of the bank categorizes customers based on a significant set of portfolio services that includes checking accounts, savings accounts, personal loans, credit cards etc. A data warehouse was developed in line with the business strategy to perform advanced analysis of the customer data to help enhance and offer better service based on their needs. The purpose of the project is to obtain the data about the customers from different systems and aggregate within the data warehouse using Informatica and OBIEE.
Effectively interacted 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 .
Identified & Created Facts, Dimensions, and Hierarchies of the business model.
Developed Segment 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.
Created Catalog 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 Ad-hoc report according to the client needs.
Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
Applied Cascading Prompts and Multi Level Prompts on Dashboards.
Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
Wrote Custom SQL Codes for the reports.
Applied Optimization Techniques for the better performance of the reports.
Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
Used external tables to Transform and Load data from Flat files into target tables.
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.
Implemented Security by authenticating against the LDAP and external table.
Trained End Users and Pilot Users about OBIEE Tools.
Environment: OBIEE 10.1.3.3, Oracle BI Applications 7.9.4(Financial analytics, HR analytics), Informatica 8, DAC, Oracle 10g, Oracle EBS, SQL Developer, SQL*Plus, Windows-XP
ENDO Pharmaceuticals, PA Jan’07 – Mar’08
Sr. OBIEE developer
Endo Pharmaceuticals is a speciality pharmaceutical company engaged in the research, development, sale and marketing of branded and generic prescription pharmaceuticals used primarily to treat and manage pain. The project deals in creating an Enterprise Data warehouse consisting of the Sales, Distribution, and Location subject areas as data marts. The sources being dealt are extracted from various databases and Flat files. Data warehouse was built in order to provide standardized reporting process for the sales force data. Oracle BI Platform Solutions was implemented for providing interactive Dashboard access to strategic business information from the company-wide data warehouse.
Primary responsibilities include gathering business requirements, designing the functional and technical specifications.
Involved in Creating and Administering the Physical Layer, Business Model & Mapping
Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
Managed security privileges for each subject area and dashboards according to user requirements.
Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
Managed Oracle Delivers, Scheduler & iBots.
Handled Full load and refresh load via staging tables in the ETL Layer.
Involved in Design and Data Modeling using Star schema.
Developed several mappings to load data from multiple sources to data warehouse.
Developed and tested Store procedures, Functions and packages in PL/SQL for Data ETL.
Environment: OBIEE 10.1.3.2, Oracle BI Applications 7.9.4(Sales Analytics, Order Management Analytics), Informatica 7.1.3, DAC, Oracle 10g, Siebel CRM, SQL Developer, SQL*Plus, Windows-XP
NCCI Holdings Inc, FL June’05-Dec’06
National Council on Compensation Insurance, Inc., based in Boca Raton, FL, manages the nation’s largest database of workers compensation insurance information. NCCI analyzes industry trends, prepares workers compensation insurance rate recommendations, determines the cost of proposed legislation, and provides a variety of services and tools to maintain a healthy workers compensation system. The purpose of this project is to create and maintain a central data warehouse and to create reports for the financial group for further business analysis. Siebel analytics was implemented for the generation of the reports.
Interaction with the end users for the requirements
Prepared Technical Design Documents (TDD) of the complete implementation of the Business Module and User Guides for the use of Siebel Analytics.
Participated in complete life cycle of the project from Project Initiation, to Development and Maintenance.
Designed repository, with complex Time Series Calculations, for prior months/ quarters/ years.
Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Siebel Analytics Administration Tool.
Involved in performing the Impact Analysis of Migration.
Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports.
Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
Enabled Siebel Delivers using iBots for delivery of reports to business users, by setting up Scheduler and configuring Job Manager.
Implemented Comprehensive Security Model, by creating User Roles, Web Groups and setting up External Table Authentication.
Environment: Siebel Analytics 7.7.4, Oracle 9i, Informatica Power Center 7.1, PL/SQL, Windows Server 2003/ XP.
Hindustan Lever Ltd, India Oct’03-May’05
Hindustan Lever Limited is the largest consumer products company in India. The Accounts and 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.
Evaluated business requirements against the Siebel CRM out-of-the-box capabilities and looked for opportunities to adapt the business needs to existing functionality.
Created Detailed Designs related to Siebel Applications using Siebel Tools.
Configured and modified the Siebel Applications as per the Detailed Design.
Responsible member of the Siebel Operations Support Team with rotational and on-call duties for Tier II and III support of the Siebel application.
Performed Unit Tests and Documents modifications made to the Siebel Applications.
Analyzed development or support requests in to technical design and developed appropriate solution on Siebel platform
Responsible for knowledge transfer/cross-training with other members of Siebel Application Development Staff.
Environment: Siebel Analytics 7.5.2, Oracle 9i, PL/SQL, Windows 2000, UNIX
Tata Teleservices Limited (TTSL)is a part of the REFERENCES: Available on Request