Summary

• 8+years of adept experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.
• Extensive Business Intelligence and Data warehousing experience using OBIEE 10g/Siebel Analytics 7.x,BI Publisher, Informatica7.x/6.x.
• Extensive Experience in OBIEE Administrative Tool, OBIEE Answers, OBIEE Dashboards, OBIEE Delivers and BI Publisher in designing, developing and with prebuilt.
• Very strong experience in developing Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Siebel Interactive Dashboards with drill-down capabilities using global & local Filters, Siebel Security Setup (groups, access / report level and object level), configured Analytics Metadataobjects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Expertise in database Performance Tuning by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing.
• Experience in working with different operating systems like HP UNIX, Solaris and Windows NT/2000/XP.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.
• Experience in all phases of the System life Cycle including project definition, analysis, design, coding, testing, implementation and Production support.
• Experience in HR and Financial analytics implementation.

Technical/Functional Skills

• OBIEE 10.1.3.4.1, Siebel Analytics 7.x (Admin, Web, Answers, Dashboards), Scheduler, BI Publisher,
• Informatica 8.X/7.x/6.x/5.1 (Power Center / Power Mart & Power Connect)
• Oracle 8.x/9i/10g/11g, MS-SQL, SQL Server.
• SQL*PLUS 8.x/9.x, PL/SQL
• C, C++, Java
• Windows 95/98/NT/2000/XP, Vista and Windows 7, Sun Solaris, HP Unix, MS Access, MS Outlook

Professional Experience

Confidential, IN Sep 2012- Till Date
OBIEE Consultant/OBIEE Business Analyst

Confidential, originallySecurity Life of Indiana, is a financial services organization based inCarmel, Indiana. Conseco\'s insurance subsidiaries providelife insurance,annuityand supplementalhealth insuranceproducts to more than 4 million customers in theUnited States. These products are distributed through independent agents, career agents and direct to customers through television advertising and direct mail.

Responsibilities:

• Gathered requirements, documented and delivered functional specification documents and configured CRM to meet requirement.
• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts.
• Involved in designing and development of building Physical Layer, Business model and presentation layer and report development.
• Created Answers, Dashboards, iBots as per user requirement.
• Developed Dashboards/Reports using the Oracle Business Intelligence Analytics platform for requirement analysis.
• Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Configured of Scheduler, Delivers and Cache Seeding by using iBots.
• Enabled Usage Tracking and Dashboards to track performance by updating the NQSconfig.INI file.
• Involving in Unit Testing, Validating Reports and production support.

Environment: OBIEE 11.1.1.6, BI Publisher, Siebel CRM, Oracle 9i, SQL Developer, Window XP, Windows server 2008, DAC.

Confidential, Aug 2011- Sep 2012
OBIEE Consultant/OBIEE Business Analyst

Business/Systems Analyst for leadingelectronic design automationsoftwareand engineering services company. Assignment involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service, documenting the business process by identifying the requirements and also in finding the system requirements.

Responsibilities:

• Gathered requirements, documented and delivered functional specification documents and configured CRM to meet requirement.
• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Validated technical design created by developers against functional specifications.
• Worked with QA team to design test plan for user Acceptance Testing (UAT)
• Wrote SQL queries for data manipulations.
• Provided formal project presentations to the client, executive management and line staff as required
• Worked closely with sales, marketing, and production business units to perform business and system analysis.
• Developed weekly forecasting report.
• Created Answers, Dashboards, iBots as per user requirement.
• Develop Answers using advance scripting RTF, XML, XLS, XSLT Languages.
• 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 Presentation Services.
• Generated Drill down Reports, Drill down Charts, Summary Reports, Navigational Reports, Subreports, Linking Reports etc
• Customized out Of Box Dashboards and Reports as per the User requirements given by the client.
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports.
• Enabled Usage tracking in NQSconfig file and also imported prebuilt Usage Tracking Repository.
• Configured and tested source DB connection and target DB connection in DAC.
• Actively involved in deployment and post release support.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers

Environment: OBIEE 10.1.3.4.1, BI Publisher, Siebel CRM, Oracle 9i, SQL Developer, Window XP, Windows server 2008, DAC.

Confidential, PA Mar2011- Aug2011
OBIEE Business Analyst/Consultant

Confidential, is a highly diversified and growing financial services organization spanning the retail, business and corporate markets.
The objective of this project is to provide PNC Mortgage LOB leadership with the ability to track the organizations performance and provide measurement consistency across the management team. The scope of this project is to create the dashboards for the mortgage and to create a data warehouse to support the dashboard. This Project was jointly developed PNC, CSI and CIBER.

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Created Technical Requirement based on BRD functional document for (Order Management, Order Fulfillment and Inventory Etc)
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Involved in designing and development of building Physical Layer, Business model and presentation layer and report development.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and Presentation layer. Also created hierarchies and variables in the repository
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Created Time Series Metrics by using Ago and Todate functions.
• Modified many logical Metrics/Columns by duplicating as per the requirements.
• Involved in implementing the Security by creating the Users, Groups, Web Groups In RPD and Web Catalog
• Implemented external tables for Authorization and LDAP for Authentication.
• Created Complex Reports by using Pivot, Table, Chart, Column selector, View Selector and Union view for POS and Performance Reports/Dashboards.
• Enabled Usage Tracking and Dashboards to track performance by updating the NQSconfig.INI file.
• Migrated RPD and Catalog from Dev Windows's environment to QA Linux environment by using the WinScp and Catalog Manager.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies.
• Configured and tested the Informatica connections, source DB connection and target DB connection in DAC.
• Involved in HR and Financial analytics implementation.

Environment: OBIEE 10.1.3.4.1, Informatica 8.6.1, Siebel CRM, SQL Developer, Linux and Windows Server 2003.

Confidential, MA Dec 2010-Feb 2011
OBIEE Consultant

Executive Report Automation deals with the financial reporting like Assets & Flows, Fund of Funds, Data Programming, Monthly, Income-Statements and Fidelity Cost and Profitability of Fidelity. The project involved in development of reports in OBIEE and also in modifying the Metadata (RPD).

Responsibilities:

• Installed OBIEE 10.1.3.4.1 on Windows Server 2003 Environment.
• Installed Repository Creation Utility on Oracle 10.1.3.4.1 Database
• Upgraded RPD and Catalog by using ua.bat file. Performed Any Required Post-Upgrade Manual Steps for Oracle BI EE.
• Deployed OBIEE 10.1.3.4.1 RPD and Catalog by using Enterprise Manager.
• Added new Tags into the OBIEE 10.1.3.4.1 instanceconfig.xml file resolve the report and dashboard issues like Graph engine is not responding, pivot table/charts display twenty five rows by default etc.
• Opened Service Requests (SR's) for RPD and Reports issues.
• Regularly coordinated with Oracle support team for resolution of the Issues.
• Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.
• Created Application Roles and Policies using Fusion Middleware Control and mapped Application roles to the Groups.
• Implemented Security by using External table Authentication.
• Created different Views like Table, Pivot, Graph, Narrative, Static, Filter for testing purpose.
• Cleared cache through manually and running the Cache scripts.
• Good knowledge in developing Scorecards and KPI's.
• Given Suggestions and solutions to the Developers for up gradations issues and also documented.

Environment: OBIEE 10.1.3.4.1, BI Publisher, SQL Developer and Windows Server 2003.

Confidential, NJ Mar 2010 - Oct 2010
Sr. OBIEE Developer

Confidential, is a world leader in the design, development, manufacture and marketing of protective gloves and condoms. Ansell has a rich tradition in the medical glove industry.
Confidential, partnered with KPI Partners for rolling out their enterprise wide Business Intelligence Application Solutions for Supply Chain and Order Management (SCOM), Point of Sale (POS)

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Involved in designing the dimensional model and I have given suggestions as per the reporting requirements.
• Implemented Dimensional modeling in the database and created appropriate views along with DBA to acquire the Metadata for the given requirement.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and Implicit Fact Column in the repository.
• Developed Dashboards/Reports using the Oracle Business Intelligence Analytics platform for requirement analysis.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Guages, Static View, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Extensively used Guided Navigation for user friendly reports.
• Implemented Security by creating roles & web groups using External tables and LDAP.
• Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Worked extensively with Custom Style Sheets in the Reporting Environment.
• Duplicated S_Oracle10 and SK_Oracle10 folders to S_Mortgage and SK_Mortgage folders and modified CSS Tags as per the Report and Dashboard requirement.
• Deployed Map Viewer and Integrated Map builder with OBIEE by creating the Spatial Data in database and Created different Maps using Different Themes, Colors and Markers.
• Created Data source and Map Meta data Cache in Map viewer console.
• Created Different Themes, Colors, Lines and Advanced Styles in Map Viewer by using Spatial Data.
• Created Bas Maps by Using the Different Themes.
• Extensive Experience in testing and Production Support.

Environment: OBIEE 10.1.3.4.1, BI Publisher, Oracle10g, SQL Developer, Map Builder, and Windows XP.

Confidential, CA Dec 2009 - Feb 2010
Sr .OBIEE Consultant

Confidential, is the IT performance company. Riverbed provides the only comprehensive WAN optimization solution to a host of severe problems that have effectively prevented enterprises from sharing applications and data across wide areas. By wide area, we mean anywhere in the world. There are a number of business related issues at Riverbed that are being caused due the lack of an enterprise wide Business Intelligence Application.
Riverbed Technology partnered with KPI Partners for rolling out their enterprise wide Business Intelligence Application Solutions.

Responsibilities:

• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
Gathered requirements from the users and generated prototype reports to help the business to visualize the design.
• Worked with all three layers in the repository - Physical, Business, and Presentation Layer.
• Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Implemented the Implicit Fact column for all Subject areas
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Created Summary and Detail reports according to user requirements and also created corresponding dashboards for the reports.
• Customized out Of Box Dashboards and Reports as per the User requirements given by the client.
• Actively involved in deployment and post release support.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.

Environment: OBIEE 10.1.3.4, Informatica 8.1.1, Oracle10g, SQL Developer, TOAD.

Confidential, MA Dec 2008 - Oct 2009
Sr. OBIEE Consultant

Confidential, is a leading global provider of medical devices for the hospital, emergency, home and specialist environments.
Confidential, partnered with Apps Associates for OBIEE solution. Smiths Medical implemented OBIEE based reporting solutions, dashboards for GlobalSales Force, Global Marketing, Global Finance and ManagementExecutive Subject Areas.

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Applied Additional joins between facts and dimensions as per requirements.
• Created new logical columns as per reporting requirements.
• Created new logical columns by using the Time series functions as per specifications.
• Implementing comprehensive Security functionality by importing users and groups from OID, setting up LDAP (OID) authentication and associating catalog objects and web modules with the created users and groups.
• Implemented Authorization by using VPD and External Table.
• Created different reports by using Table, Pivot, Chart, Narrative Views etc.
• Designed Dashboard as per specifications.
• Configured of Scheduler, Delivers and Cache Seeding by using iBots.
• Implemented Write Back Facility for entering the User names and group names into the Database.
• Onsite/Offshore Coordination.
• Migrated Catalog's and RPD's from different environments by using PSFTP, Putty.
• Involving in Unit Testing, Validating Reports and production support.
• Working closely with Users, Developers, Administrators and Testers to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.

Environment: OBIEE 10.1.3.4, Oracle 10g, Windows XP and UNIX.

Confidential, GA May 2008 - Nov 2008
Sr. OBIEE Consultant

Confidential, is the third-largest cable entertainment and broadband services provider in the country, Cox Communications Inc. is best known for pioneering the bundle of television, Internet and telephone services together, offering consumers the ability to consolidate their services with one provider.

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.
• Involved in modifications on the Repository Metadata.
• Developed Logical Columns in Business Model Layer based on Business Requirements by using Time Series Objects and business logic's, and creating the Presentation catalogs in Presentation Layer.
• Developed different kinds of Reports using Table and Pivot Views, ViewSelectors, Column Selectors, Narrative Views, Static Views, Chart and Plot Views, Title Views and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.
• Developed different kind of reports using BI Publisher.
• Extensively used Dynamic Section Prompts and Guided Navigation in dashboards.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Involved in Upgrade process of the entire infrastructure from OBIEE 10.1.3.3.2 to OBIEE 10.1.3.4.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Performed Unit testing to validate report.
• Involved in UAT and post Production Support.
• Migrated Web Catalog and RPD from different environments by using PVCS.
• Worked closely with Users, Developers, Administrators and Testers to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle E-Business Suite, Oracle 9i/10g, PVCS, Windows XP and UNIX.

Confidential, MA Nov 2007 - Mar 2008
Sr. OBIEE Consultant

The Case Management Analytics solution will enhance decision-making process regarding Operation Enhancements. The system will allow Customer Relation Management Team to perform data analysis and track the solutions provided to subscribers.

Responsibilities:

• Interacted with Business users for gathering Reporting Requirements.
• Designed Dimensional modeling based on Requirements and E-R model using Erwin Tool.
• Designed and Developed the OBIEE metadata Repository using OBIEE Admin tool by importing the required objects with integrity Constraints into physical layer using connection pool
• Created Aliases for all physical tables to avoid circular joins and self joins.
• Imported objects from different data sources like Excel and Text files and further created logical columns with them as per the requirement.
• Created Drill-Down Hierarchies and set the estimated levels in Hierarchies, Logical columns & manipulated Fact column in BMM Layer as per requirement using Calculation Wizard like Percentage Change and Index Columns.
• Created Time Series objects for comparing business performance with previous time periods using Ago and ToDate Functions.
• Implemented Security by creating Users and groups and setting the Logging levels for each user.
• Integrated LDAP Server with OBIEE by creating servercert.perm, serverkey.perm and serverpwd files in Config folder and also updated Config file then created LDAP connection. Imported users and synchronized users with LDAP server.
• Enabled Usage tracking in NQSconfig fileandalso imported prebuilt Usage Tracking Repository.
• Developed Different Reports with different Analytic Views (Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services.
• Generated Drill down Reports, Drill down Charts, Summary Reports, Navigational Reports, Subreports, Linking Reports etc.
• Configured Scheduler by creating Scheduler tables in database
• Configured iBots by running Crypto tools and delivered reports to users through different devices like email, mobile etc.
• Integrated and Created BI Publisher Reports.
• Imported SAP BW cubes into the RPD and generated reports as per the specifications.
• Installed Briefing Books, Excel Add-In and customized Login screen.
• Performance Tuning of Repository and Reports by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database, setting the NQSConfig.ini parameters.
• Performed Unit, Integration Testing to Validate the Report.
• Worked closely with Users, Modelers and Administrators to resolve ongoing production Problems by reviewing design changes made to production systems.

Environment: OBIEE, BI Publisher, Oracle 10g, Windows XP

Confidential, MI Mar 2007 - Sep 2007
OBIEE Consultant

Competitive Marketplace Insight enables more effective decisions that drive profitable market share growth through simple, accurate, timely access to marketplace intelligence data for all levels and functions at whirlpool and for our trade customers.

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Designed and developed the OBIEEMetadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Developed many OperationSolutionsTime Series objects for comparing the usage variations between the quarters
• 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 Presentation Services
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
• Implemented security by creating roles & web groups, checks with External tables and LDAP
• 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
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• 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 the OBIEE Repository

Environment: OBIEE, Siebel Analytics 7.x, Informatica Power Center 6.x/7.x, Oracle 9i/10g, HP UNIX

Confidential, ALMar 2005 - Nov 2006
Siebel Analytics / Informatica Consultant

Confidential, is a diversified energy company headquartered in Birmingham, AL. Through its two subsidiaries Energen Resources and Alagasco, Energen acquires and develops domestic American oil and gas properties and distributes energy-efficient natural gas in Alabama.

Responsibilities:

• Gathered user requirements from business representatives and convert them into functional and technical specifications
• Created/Modified Metadata repository (.rpd) and Configured Metadata Objects using Siebel Analytics Server Admin tool
• Configured measures in the Business Model Layer and mapped to multiple logical source tables
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems
• Developed Mappings/Mapplets and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator)
• Designed and documented the validation rules, error handling and test strategy of the mapping
• Tuned the sessions for better performance by implementing the partitions

Environment: Siebel Analytics 7.x, Informatica Power Center6.x, Oracle 9i

Education:

Bachelors of Science Computer Information Science
Bachelors in Computer Science