Professional Summary

• Software professional with 6+ years of experience providing business solutions in the areas of Business Intelligence, Data warehousing, Data Analysis and Application Development.
• Capable of developing end to end Business Intelligence solutions using Siebel Analytics/Oracle Business Intelligence Enterprise Edition (OBIEE), Informatica and DAC with good understanding of Data warehousing and OLAP concepts.
• Extensive Dimensional Modeling experience in Star Schema/Snowflake schema design, Fact and Dimension tables.
• Worked Extensively on Oracle BI/Siebel Analytics Administration Tool, Oracle BI Answers, Oracle Delivers (iBots), Interactive Dashboards and Security Implementation.
• Developed Metadata Repository (.rpd) using Siebel Analytics Server Administration tool by importing the required objects (Dimensions/Facts/Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) and Logical/Facts/Measure objects inBusiness Model Layer, and created Presentation Catalog in Presentation Layer.
• Expertise in using Data Warehouse Administration Console (DAC) for scheduling and executing Incremental ETL loads.
• Experienced in building Interactive Dashboards with drill-down and drill-across capabilities using global and local filters, contextual navigation, guided analytics, business rules with user identity roles, profiles and personalization.
• Experience in implementing Siebel Analytics/Oracle BI security setup according to user requirements by setting up group/data access/query privileges, Metadata Objects, Web Catalog Objects (Dashboards/pages/folders/reports).
• Good experience in PL/SQL with the ability to develop and test stored procedures, triggers, functions and packages.
• Proficient at interviewing stakeholders and end users, and in translating users' statements of needed system behavior and functionality into Business and Technical Requirements.
• Worked with Business Analysts/Partners/Users to identify information needs and business requirements for reports and finalizing Requirement Specifications, Design Specifications, Traceability Matrix, Risk Analysis and Integration testing.
• Experience in identifying Test cases and writing Test Scripts, with the ability to communicate with cross platform teams during the Test and pre-production phases.

Education

• Bachelor of Engineering in Computer Science Engineering.

Technical Skills

BI Tools

OBIEE 10.1.3.x, Siebel Analytics 7.x

ETL

Informatica (Power Center 8.x/7.x/6.x), DAC

RDBMS

Oracle 10g/9i, SQL Server

Languages/ Technologies

SQL, PL/SQL, HTML, XML

Operating Systems

Windows NT/2003/XP, IBM AIX, Sun Solaris, UNIX

Tools

TOAD, SQL Navigator, Mercury Quality Center, PVCS, CVS

Modeling Tools Others

Erwin, Visio

Project Summary

Juniper Networks July 09 to Present

Sr. OBIEE Consultant

The project objective is to implement enterprise wide analytical solution for the sales and marketing teams to provide a single dataset for analysis and tracking of results comprising of various periodic scenarios for all the sales/marketing team managers worldwide. Benefits include identifying trends, pay for performance, demographics and delivering flexible business solutions. This project involved extracting the data from different sources and configuring and developing reports to suit the business need.

Roles and Responsibilities:

• Worked closely with the SME's to gather business requirements for reports and Dashboards and converted them into functional and technical specifications.
• Coordinated with all stake holders to define the Key Performance Indicators (KPI) for various score boards.
• Coordinated with the infrastructure teams during the data validation phase and deployment phase.
• Developed incremental loads using Informatica mappings & Oracle PL/SQL procedures as required.
• Extracted data from different sources such as Oracle, Fixed width and Delimited Flat files to load into Operational Data Store (staging area) using Informatica Power Center Designer and Workflow Manager.
• Configured DAC to run nightly data loads on daily basis.
• Designed and developed Metadata Repository (.rpd) using BI Server Administration tool by importing the required objects with integrity constraints into Physical Layer using Connection Pool.
• Created Aggregated Tables to improve the Performance of the Reports.
• Used Time Series Functions (Ago, ToDate) to generate trend analysis reports.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Involved in the Cache management, to improve the overall system performance.
• Developed end-user documentation outlining the features and capabilities of various reports with screen shots on how to schedule and execute them.
• Identified test cases and wrote test scripts for various standard and Ad-hoc reports.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular) with Global and Local Filters using Answers in OBIEE.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Created Filters and provided customized prompts appropriately to avoid excessive data showing in reports.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Adhoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.

Environment:OBIEE 10.1.3.4, Informatica PowerCenter 8.1, DAC, Oracle 10g, Windows XP.

Confidential, April 08 to June 09

Sr. OBIEE / Informatica Consultant

The project objective is to provide an Analytical overview for the day to day logistical related scenarios such as fuel optimization, routing, vendor trends and sales. Features include pre-built dashboards, score cards and Ad-Hoc reports. The overall application extracts the data from different sources and configuring and developing reports to suit the business need.

Roles and Responsibilities:

• Performed installation and configuration of OBIEE.
• Customized and developed Repository, configured metadata objects (Subject Area, Table, Column) and web catalog objects (Dashboards, Pages, Folders).
• Created connection pools, imported tables and defined physical key joins in the physical layer.
• Designed Star-Schema using Facts, Dimensions and Alias tables.
• Configured multiple sources for a logical table source in BMM layer.
• Used Calculation Wizard and Expression Builder to perform logical operations in BMM layer.
• Configured and calculated various measures in the Business Model & Mapping layer and mapped to multiple logical source tables.
• Created groups in the repository and added users to the groups and granted security privileges.
• Created the Dashboards by including global prompts, guided navigation links and drilldown features appropriately.
• Effectively involved in Cache management for an improved performance of the system.
• Developed several kinds of Reports such as Pivots, Charts, Graphs and Tabular using global/local Filters using Oracle BI/Siebel Answers.
• Customized Dashboards, administered permissions and privileges for Dashboard visibility and modifications to users.
• Developed many Dashboards using drill-down capability for summary and detailed information.
• Created proactive agents (iBots) using BI delivers to schedule Cache seeding.
• Configured iBots to deliver Analytics content based on schedule.
• Involved in using ETL processes for accommodating changes in source systems.
• Developed mappings & mapplets to build key interfaces using transformations (Filter, Router, Expression, Aggregator, Lookup) for loading data into Data Warehouse.
• Used Data Warehouse Administration Console (DAC) to schedule and run Full and Incremental ETL loads.

Environment: OBIEE 10.1.3.3, Informatica PowerCenter 7.8, DAC, Oracle 10g, Windows 2003, IBM-AIX

Confidential, April 07 to Mar 08

Sr. Siebel Analytics / OBIEE Developer

Rowan is an energy services provider specializing in Off-Shore drilling. The project objective is to provide an Analytical solution to keep track of the off-shore activity pertaining to Assets, performance of each rig, Sub-Contractor information, Field engineer performance, Inventory and warehouse management. Features include identifying inventory trends, Key Performance Indicators and identifying cost savings.

Roles and Responsibilities:

• Interacted with business representatives for gathering the Reports/Dashboards requirements.
• Effectively configured ODBC connections and imported physical tables and keys from databases.
• Identified the granularity level of the data required to be available for analysis.
• Created multiple connection pools in the physical layer in order to improve performance.
• Customized Star and Snowflake schemas by linking Fact and Dimension tables in BMM layer.
• Created Dimensional hierarchies in BMM layer and used aggregation rules.
• Effectively used Calculation wizard, Time series wizard and Expression builder for implementing business logic in BMM layer.
• Created several complex joins in BMM layer.
• Implemented External table security by creating users and web groups.
• Worked extensively on Siebel applications (Answers, Delivers and Dashboards).
• Developed Ad-hoc reports using Oracle BI Answers.
• Developed Dashboards/Reports with different Analytic views (Drill-Down, Pivot, Chart and Tabular) using Siebel Analytics Web.
• Used Siebel Analytics Delivers for sending real-time alerts via intelligence agents (iBots) for subscribed users.
• Used Filters appropriately to avoid excessive data showing up in Reports.
• Modified some of the existing Reports/Dashboards and fixing some of the issues related to performance, data quality etc. during production support.

Environment: OBIEE10.1.3.2, Siebel Analytics 7.8.4, Oracle 9i, TOAD, Windows NT.

Confidential, Oct 06 to Mar 07
Siebel Analytics / Informatica Consultant
The project objective is to provide an enterprise wide analytical solution for the sales, marketing and financial teams. Data was extracted from different sources using Informatica and reports were generated using Siebel Analytics, the application provides a set of analysis for tracking trends, sales, performance and predictions.
Roles & Responsibilities

• Interacted with functional & technical leads, SME's, marketing, finance, and other business groups to identify, analyze, and document business requirements.
• Developed the Initial and Incremental / Delta ETL process i.e., Mappings & Mapplets using various Transformations for new objects.
• Created mappings using different Transformations like Source Qualifier, Filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.
• Designed and implemented custom business intelligence solutions (MetadataandDashboards/Reports) using the Siebel Analytics 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.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables (LTS).
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• 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.

Environment: Siebel Analytics 7.7/7.8, Informatica PowerCenter 6.2, Oracle 9i, TOAD, Sun Solaris.

Confidential, Oct 05 to Sep 06
Informatica Consultant
Confidential, is a natural gas provider, the objective of this project is to keep track of various key metrics such as SLA's, Inventory, Operation Data and Assets. The ETL was developed using Informatica where the data was extracted from different sources and was loaded into a target database for report generation and analysis.
Roles and Responsibilities:

• Was responsible for designing the datamart and actively participated in the design sessions.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data into the data warehouse.
• Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client\'s operational databases, Transform and cleanse data, and Load it into data warehouse.
• Used the Informatica Designer, Source Analyzer, Warehouse Designer and Mapping Designer.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Used the update strategy to effectively migrate data from source to target.
• Designed several mappings to extract the data from the Flat file sources and Relational Sources.
• Wrote SQL Scripts for the reporting requirements and to meet the Unit Test Requirements.
• Used Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Created PLSQL procedures to help in data validations and triggers.

Environment:Informatica PowerCenter 6.2, Oracle 9i, PL/SQL, SQL Navigator, Windows NT.

Confidential, India Mar 04 to July 05
Oracle Developer
Roles & Responsibilities:

• Was responsible for gathering the requirements from the end users and converting the business requirements into technical specifications.
• Developed the user interface using Oracle Forms.
• Developed the backend functionality to handle the user events using Oracle PL/SQL.
• Extensively used both In-built and Explicit triggers for getting the desired functionality.
• Developed Oracle Objects including triggers, stored procedures and sequences that helped in automating the various operations in the database.
• Created indexes on tables to enhance performance.
• Developed several reports and provided user based filters for easier navigation and generation.
• Participated in unit integration and system testing and fixed defects in PL/SQL packages, Procedures, Functions, Oracle Forms, Reports and Shell Scripts.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Developed Shell Scripts in UNIX to schedule Cron jobs.

Environment: SQL, PL/SQL, Oracle 9i, Toad, SQL*Plus, Windows XP, UNIX.