EXPERIENCE SUMMARY

• Over 8 years of experience in gathering Business Requirements, assessing & developing Business Intelligence Program strategies, and designing and implementing Business Intelligence information & analytical solutions.
• Expertise in providing end-to-end business intelligence solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Inter-active Business Intelligence Dashboards using 11g, OBIEE, Siebel Analytics.
• Worked Extensively on 11g/Oracle BI/Siebel Analytics Administration Tool, Siebel Analytics Web / Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Strong in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Caching & Mapping.
• Expertise in implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards/Reports.
• Expertise in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 7.x/ 6.x.
• Very good experience in developing Informatica Mappings / Mapplets and Workflows with Worklets & Tasks using various Transformations (Update Strategy, Filter, Router,
• Expression, Stored Procedure, Lookup, and Aggregator) for ETL of data from Multiple Sources to Data Warehouse.
• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel
• Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes.
• Multi-platform experience on UNIX / Linux and Windows Server family.
• Results oriented, self starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

EDUCATION

• BS in Computer Science and Information Technology

TECHNICAL SKILLS

• 11g, OBIEE 10.x, Siebel Analytics 7.x (Admin, Webcat/Presentation Services, Dashboards, Publisher, Delivers, iBots)
• Informatica 5.1/6.x/7.x (PowerCenter & PowerMart) , SSIS package
• Oracle 11g/10g/9i/8, Oracle Applications10.7
• MS SQL Server 2000, SQL Server 2005, T-SQL, Lotus Notes
• SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x
• C, C++, Java, JSP, EJB, HTML, XML, Perl, UML
• Windows 95/98/NT/2000, Linux, Unix

EXPERIENCE DETAILS

Confidential, Richmond, VA March 10 - Till Date
11g/10g OBIEE Consultant
Bank of America provides a comprehensive line of banking, brokerage, insurance, investment, mortgage, and trust and payment service. This project I managed single handed, involves integration of data from different sources to facilitate automated reporting process for Senior Executive Team using OBIEE tool.

Responsibilities

• Gathered, Analyzing and identifying the Gap of Business Reports Requirements.
• Identified Facts and Dimensions (with levels & hierarchy) and developed Siebel Analytics Repository (RPD) at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Installed 11g version on 64 bit windows, upgraded 10g RPD and Webcat.
• Worked with Oracle in debugging the issues.
• Installed some patches in the 11g version based on Oracle recommendation
• Developed many Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters. Extensively used Siebel Delivers and iBots.
• Implemented Security by creating roles, web groups, and external tables.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Developed the Initial and Incremental / Delta ETL process i.e., Mappings & Mapplets using various Transformations for new objects.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• 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.
• Worked extensively on performance tuning of reports in the application layer.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
• Extensively worked in fine-tuning of Informatica Mappings.
• Used different application development tools like TOAD (Oracle)
• 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.

Environment: 11g, OBIEE 10.x, Informatica Power Center 8.1, Oracle 10g

Confidential, NY Sep '08 - Feb'10
OBIEE Consultant
Cares Application:
Confidential, is implementing Cares Application for the Dept of Homelessness. The Database is Oracle 11g and application is Cares which is on Java Platform. OBIEE is implemented for generating reports. The ETL process involved extracting the data from Oracle database. There are about 30 reports generated as per client's requirement.

Responsibilities

• Creating and modifying Business Intelligence requests using Oracle Business Intelligence Answers.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Worked as a member of architect team in reviewing the code developed by different teams.
• Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using Agents.
• Performing administrative tasks related to the development and configuration of Interactive Dashboards
• Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.), test and validate the model
• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using LDAPAuthentication to setup groups, access and query privileges
• Customized the Oracle Business Intelligence Presentation Services interface.
• Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Created Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• Set up Usage tracking and Scheduler in OBIEE.
• Created Database Report Layouts Using BI Publisher Desktop (Template Builder) in MS Word.
• Integrating OBIEE and BI Publisher and Scheduling BI Publisher reports and Created BI publisher reports based on various data sources.
• Developed different levels of Security set-up are for the entities of the application (on both Repository file and Web catalog file).
• Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Developed Performance Tuning Strategies for optimizing the performance.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.
• Planned and supported end-user training sessions on the new product, prepared and managed operations run book for continued support.

Environment: OBIEE, Oracle 9i, Informatica 7.1, SQL server 2008

Confidential, Overland park, KS Apr '07 - Aug '08
Business Intelligence Consultant
Revenue & Sales Analysis (RSA)
Confidential, is a provider of software and services for billing, customer relationship management (CRM), operations support systems (OSS). Sprint is its traditional client for telecommunications. The project involved in creating Business Intelligent Solutions for various work streams by comparing and contrasting data from various sources and then consolidating them at the Report/Dashboard levels. The reports are generated by various users to cater the needs of all levels of sales organization from sales representatives to executives.

Responsibilities

• Involved in Analysis, Requirement gathering, Functional/Technical Specifications, Development, Deploying and Testing.
• Installed and configured OBIEE/Oracle Financial Analytics 7.9.5.
• Designed Physical Layer, Business Model, Mapping Layer and Presentation Layer in the repository after connecting to the database engine.
• Installed and configured BI Publisher and integrated with OBIEE Servers.
• Identified Facts, Dimensions & Hierarchies of the Business Model.
• Implemented various kinds of reports as per the client requirements using OBIEE Answers & Dashboards.
• Developed various kinds of Reports (Pivots, Charts & Tabular) using global and local filters.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Created groups in the repository and added users to the groups and granted privileges explicitly through group inheritance.
• Configured IBots to deliver Analytics content based on Schedule to obtain weekly reports and sent notifications Alerts.
• Implemented Cache Management techniques to improve the performance on both real time and non-real time reports.
• Implemented prompts to provide dynamic filter conditions to end users.
• Customized report look and feel using column formatting and conditional formatting.
• Tuned OBIEE Reports to improve the performance.
• Created Session & Repository variables to achieve desired functionality.
• Imported physical tables from SQL Server 2008 and defined relations between physical tables at the physical layer.
• Created complex stored procedures in SQL Server 2008 to retrieve the data required to generate reports.
• Involved in developing the testing documents like estimates, test strategy, test plan, use cases, test cases, test scenarios and test data according to requirement specifications, experience in preparing test execution reports.
• Implemented triggers in order to enforce complicated business logic and integrity constraints and to enhance data security at database level.

Environment: OBIEE 10.1.3.4, BI Publisher, SQL Server 2008, T-SQL, TOAD, Windows XP/Server 2003, Informatica 8.6.

Confidential, Dallas, TX Jul '06 - Mar '07
Sr. Business Intelligence Consultant
Sales Distribution Analysis (SDA)
Access Pharmaceuticals is a specialty pharmaceutical company engaged in the research, development, sales 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. Database warehouse was built in order to provide standardized reporting process for the sales force data. Oracle BI platform solutions were implemented for providing dashboard access to strategic business information from the company wide data warehouse.

Responsibilities

• Participated in complete life cycle of the project from project initiation to development and maintenance.
• Customized the Siebel Anaytics/OBIEE repository (Physical Layer, BMM and Presentation Layer).
• Modified Presentation layer to add presentation tables and defined joins in the physical layer of the repository.
• 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.
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.
• Created materialized views and aggregates to improve performance.
• 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.
• Created user level security for intelligence dashboards based on Business Requirement.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created iBots to send pre-processed reports using OBIEE Delivers.

Environment: Siebel Analytics 7.7/OBIEE, Oracle BI Application 7.9.4, Informatica 7.1.3, DAC, Oracle 9i, Toad, PL/SQL, Windows Server 2003/XP

Confidential, India Nov '05 - Jul'06
Siebel Analytics Developer
Revenue Accounting Management (RAM)
The Revenue Accounting Management project provides Customer Receipts Analytics solution to Pelco to enhance decision-making process, perform Data analysis and tracking with respective to their products and customers. This Siebel Analytics reports should include data from both Siebel and Non Siebel sources

Responsibilities

• Involved in gathering and analyzing the user requirements in coordination with Business.
• Identified Facts, Dimensions, and grain of the Dimensional modeling.
• Identified the source tables, source columns, and referential joins.
• Built Siebel Analytics Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs)
• Created Business Facts and Dimensions and defined Logical relation between them in BMM layer
• Created Drill Down Hierarchies and implemented Business Logics for Facts.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables (LTS), logical columns, and also validating repository level calculations done in the business model layer.
• Imported Physical Tables and Defined Relations in Physical Layer in Siebel Analytics
• Created Reports using different Analytics Views (Pivot Table, Chart, Table)
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Created Pivot Tables and manipulated Init Blocks for report analysis
• Configured out-of-the box as well as custom Analytics/Dashboard reports using Siebel Answers
• Implementing report Level Business Logic using Function editor.
• Performed Unit testing, Integration testing, and Regression testing to validate report and mapping functionality.
• Created mappings with PL/SQL procedures and functions to implement business rules while loading data
• Performed performance tuning by optimizing Target, Source, Mapping and Session
• Improved SQL query performance using TKPROF and EXPLAIN PLAN
• Involved in migration of mappings / workflows from Development to Testing and to production

Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.2, Oracle 9i, UNIX

Confidential, Mumbai, India Jul '04 - Sep '05
Informatica ETL developer
Performed requirement analysis, Designed a comprehensive export and import costing application. The Application keeps track of inventory information, sales analysis and delivery Details, Developed using Developer 2000 with Oracle 7.3 database in windows'95 using VBX controls.

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Identified the granularity level of the data available for analysis
• Extensively used transformations like Lookup, Aggregate, Joiner, Filter, Sequence Generator, and Expression to create complex mappings.
• Created mappings to load aggregate tables in the data warehouse.
• Customized workflows, worklets, and tasks using Workflow Designer.
• Used Workflow Manager/ Workflow Monitor to develop, validate and run sequential and concurrent batches and sessions.
• Created email tasks in workflows to send post session and suspension emails as per user requirements.
• Translate business requirements to design the ER model using ERWIN tool.

Environment: Informatica Power Center 5.1, Oracle 8i, PL/SQL, Windows NT

Confidential, India Nov '03 - Jun '04
Programmer/Analyst
Confidential, is India\'s world class, most comprehensive, fully parameterized, and integrated and fully web based HR & Payroll software. It automates functions right from staffing, induction, HRIS, attendance, leave, payroll, training, appraisals i.e. all such activities from candidate entry till employee exit.

Responsibilities

• Involved in requirement gathering and analysis of the project
• Developed many users interfaces (Employee/Payroll entry & inquiry and other information)
• Written PL/SQL Procedures, Functions and Stored Procedures for validations, calculation as well data changes and tuning of SQL Queries

Environment: Oracle8i, Forms5.0, Sun Solaris