• Insightful, result driven senior BI consultant with 8 years of IT experience.
• Over 6 years of Experience in OBIEE 11g/10g, BI Publisher, Oracle BI Applications 7.9.6, Informatica, DAC
• Strong experience on analysis, design, development, customization and maintenance of various business Applicationsz in an effective way to deliver business solution.
• Experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence OBIEE , including full life cycle implementations.
• Expertise in installation, configuration and administration of OBIEE platform.
• Expert in working with OBIEE administration tool developing metadata repository and strong experience in working with Siebel/OBIEE Answers, Siebel/OBIEE Dashboards and Siebel/OBIEE Delivers, Scheduler, BI Publisher
• Proficient in building an OBI repository Physical, Business and presentation model to create Dashboards, Answers, and iBots.
• Extensive experience in configuring Answers, Interactive Dashboards with drill-down capabilities using Prompts, Filters, OBIEE Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Expertise in OBIEE repository management, building business model, Presentation catalog, web catalog, and extensive knowledge in providing guided navigation in the reports and scheduling ibots.
• Worked on Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment MUD .
• Expertise and hands-on experience in creating aggregations and managing metadata using OBIEE to optimize performance
• Extensive knowledge on MDM / ODS / Siebel CRM / Siebel OLAP / EDW / Legacy Systems
• Experience in Dimensional Modeling, Data Modeling, understanding of Kimball's star and snowflake schemas.
• Experience in writing, testing and implementing SQL/PL-SQL, Stored Procedures, Triggers and functions.
• Excellent Data Management skills with extensive experience in Data Quality Assessment, quality control and process implementation, monitoring and executive reporting.
• Expertise in Data Warehousing development and designing of ETL Process for supporting data transformations and processing in a corporate wide environment using Informatica Power Center / Power Mart.
• Experience in Configuring Data Ware House Application Console DAC , Informatica servers Analytics Bridge.Experienced in Performing end to end testing, creating Test Plans including Data Validation, Unit Testing and User Acceptance
• Very strong analytical and presentation skills, problem-solving techniques.
• Excellent Team player and can work on both development and maintenance phases of the project and Ability to provide timely solutions and work within specified time frames.

TECHNICAL SKILLS:

• ata warehouse Tools: OBIEE 10.x/11.x Administration Tool, Analytics, Answers, Dashboards, Delivers, Oracle Enterprize Manager, Console, Web Logic , BI apps 7.x ,
• Oracle BI Publisher /Delivers iBots/Agents . ETL: Informatica Power Center 8x/7.x , File-Aid CS/EX RDBMS: Oracle 11g/10g/9i, MS SQL Server, Teradata, MS Access Languages/ Technologies: C, C , SQL, PL/SQL, HTML, XML, Java, VB.NET Visual Basic Operating Systems: Windows XP/2000/NT/2003 4.0/Vista, UNIX. Tools: SQL Plus, SQL Loader, TOAD, SQL Developer, HP Quality Center,
• MS Visio.

Areas of Expertise:

Data Warehousing / BI-OLAP- Siebel Analytics OBIEE / ETL / Informatica /DAC/ BI Applications / Oracle / DAC / SQL Server / SQL / PL-SQL / Data Modeling / TOAD / Analyst/ Data Encryption Methods / MDM / ODS / EDW / OLAP / OLTP

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE Consultant

• Ingersoll Rand is composed of a diverse array of business and market-leading brands including Club Car, Ingersoll Rand, Thermo King and Trane - serving customers in global commercial, industrial and residential markets.
• Role: Working as an OBIEE Consultant / Developer, involved in implementation of various OBIEE Projects/reports starting from requirement analysis to migration to Production , involved in major development in Inventory and Finance modules including OBI Answers, Dashboard, RPD Modeling, Integration with Oracle DB Oracle Stored Procedure, Package and Function. As part of SMART BI technical team, I am responsible for dev eloping new reports and changes to the existing reports.

Responsibilities:

• Work closely with project SA and BSA to understand the requirements and convert them into technical solution.
• Technical Feasibility of the business requirements
• Detail design for Inventory Reports/Finance reports and dashboards
• OBIEE repository modeling and web-catalog configuration.
• Development of Repository/web catalog objects/Oracle reports.
• Unit and integration testing of reports/dashboards/Oracle reports.
• Business Analysis and requirement gathering.
• Status Reporting and Metrics generation for weekly status reports.
• Conducting Gap analysis between As-Is and Out of Box OBIEE Applications
• Identifying all the customizations and documented all the customizations.
• Responsible for designing the Facts, Dimensions, Hierarchies, and Aggregates.
• Designing the BMM Layer to better configure the business model in OBIEE.
• Designed caching strategy for better report performance.
• Tuning of OLAP database for better reporting performance.
• Effectively managing onsite and offshore resources throughout the maintenance phase of the project.
• Review and approve deliverables throughout the project duration
• Proactively anticipate project design changes and be responsible for taking immediate corrective
• Action
• Very good experience in building and configuring repository, creating and managing Oracle Intelligent Dashboards.
• Worked in all the phases, which involve requirement gathering, documentation, High Level Design, Low Level Design, Development, Unit Testing, Integration Testing, System Testing and deployment of the same into the LIVE production environment.
• Implementation of Security based on roles.
• Release Coordination

Environment: OBIEE 11.1.1.7.x, EBS Release 12, Oracle 11g, HP PPM, Serena Dimex, Unix, Oracle SQL Developer.

Confidential

OBIEE Consultant

• Confidential has been helping those in the academic, medical, cultural and research fields plan for and live in retirement. Providing retirement and savings plan design, consultation and administration to the medical, education, research, cultural and governmental communities. Do this with a full array of financial products and services to help them live to and through retirement and invest for life's other goals along the way. The project has seen exponential growth in terms of users and usage during my tenure. As part of data management team, I have designed, developed and deployed OBIEE and supported other projects.
• Role: Working as an OBIEE Consultant / Analyst, involved in implementation of various OBIEE Projects starting from Project planning to Production Warranty Support, involved in major development like Database Design Oracle, Teradata Sql Server , OBI Answers, Dashboard, RPD Modeling, Integration with Oracle DB ETL jobs, Oracle Stored Procedure, Package and Function. Also supported various projects to identify the financial data upon ad-hoc requests.

Responsibilities:

• Analyze business functionalities and prepare high level design document for initial development. Work closely with senior Quality analysts, senior Data Modeler and Database Architect during the design and development of OBIEE Answers and Dashboards.
• Involved in developing the OBIEE process design document.
• Involved in identifying the data sources and the granularity level of data populated in the sources.
• Analyze business functionalities and prepare high level design document for initial development. Work closely with senior Quality analysts, senior Data Modeler and Database Architect during the design and development of OBIEE Answers and Dashboards.
• Create and Administer the Physical Layer, Business Model Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Create connection pools, physical tables, define joins and implement authorizations in the physical layer of the repository.
• Manage security privileges for each subject area and dashboards according to user requirements.
• Create groups in the repository and add users to the groups and grant privileges explicitly and through group inheritance.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Designed and developed the OBIEE/ Metadata Repository .rpd using Siebel Analytics 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.
• Created templates for presenting results and Analytics and modified the Dashboard using cascading style sheets.
• 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.,
• Implemented Security by creating roles web groups using LDAP Authentication.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• 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.
• Configure and modify Oracle Business Intelligence answers/reports to meet the goals of users.
• Imported new tables and columns from the Data warehouse, created Physical and Logical Joins, created Dimensional and Level Based Hierarchies.
• Worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement Execute OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Use Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience
• Enabled usage tracking in NQSconfig file and also imported pre-built usage tracking reposiotry
• Designed ETL process to extract the data from sources to target
• Worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement.
• Worked extensively on security model users, groups, application role creations.
• Involved in security management - Created web groups for security purpose with access privileges and also assigned data Level and object Level security to users.
• Actively involved in cache management Implemented event polling cache refresh strategy to cache reports and improve performance of long running reports.
• Worked on automation of bursting process for BIP reports using java weblogic.
• Worked on migration of BI reports, rpd, web catalog from one environment to another.
• Demonstrate end users on the usage of Oracle Business Intelligence answers /Dashboards.
• Involved in the process of refreshing test databases with the production data.
• Directly involved in test data de-identification process that requires analysis, scrambling and verification of sensitive data.
• Create and execute XML scripts in File-Aid to encrypt sensitive data.
• Develop generic PL/SQL scripts to manipulate encrypted test data to be consistent throughout test environments.
• Provide Interface Service Support with appropriate DBA and Operations Support team for all Test Environment Data repositories across all platforms including Oracle, SQL Server and Teradata.
• Provide Support for all Data de-identification Scrambling requirements, ensuring obfuscation of Personal Identification Information PII across all testing platforms.
• Provide support to subset MDM/ODS/Siebel Data
• Develop and execute XML scripts in File-Aid tool to De-Identify sensitive columns.
• Review meta data to identified by Compliance as sensitive and requiring de-identification in the Test Data Handling SOP.
• Provided consistent, subset extraction of Production Data across all platforms, de-identification scrambling and migration to parallel databases in all environments of the SDLC ensuring data integrity is maintained and participant information is complete across all applications.
• Provided AD-Hoc support to testing teams and business teams to find the required data
• Extensive experience in troubleshooting SQL queries, Performance tuning, identifying bottlenecks and resolving to improve performance at Database, reporting and ETL level - Creation of Materialized views, Indices, Aggregate tables.

Environment: OBIEE 10.1.3.4/11.1.1.5, Oracle 10g/11g, MS SQL Server 2008,Teradata 12.0/14.0, Oracle SQL Developer 2.1.1.64, MS SQL Query Analyzer 8.00, Teradata SQL Assistant 7.2, Quality Center, File -AID/CS Release 4.2/5.0, Rochade Metadata, Windows Server 2008 R2, DAC

Confidential

OBIEE Consultant

Consumer Experience Management CEM HUB is a project which involves gathering information from various marketing strategies developed by Epsilon team and the Task Force Team. Using this information certain groups are targeted, in turn increasing the hit ratio and reducing the expenditure spent on campaigns.

Responsibilities:

• Full project life cycle implementation for Oracle Business Analytics Warehouse OBAW
• Performed Project Scoping, Project Organization and Management including Business IT Requirements, Priorities, Project Execution Plan and Resource Plan.
• Created Custom SDE Adaptors and built new Subject areas and Execution Plans in DAC for new customized subject area.
• Expertise with Siebel Base tables and EIM workflows.
• Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships Foreign Keys Physical Logical between tables.
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Created executive level Reports and Dashboards catering to provide insight into the sales / marketing data.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Developed BI Consumer reports using OBIEE 11g.
• Configured Informatica connections source DB connection and target DB connection in Dataware House Application Console DAC .
• Designed and added Customized Mappings to DAC and scheduled the Loads to run on regular basis.
• Imported new tables and columns from the Data warehouse, created Physical and Logical Joins, created Dimensional and Level Based Hierarchies.
• Worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement Execute OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Expertise in SQL check and List pulls.
• Developed new Informatica mappings for enhancement and bug fixes for various brands as per various requirements.
• Worked on Informatica Performance tuning methods like various ways of using lookup caches depending on the size of source and lookup tables.
• Added new facts and Dimensions to the OBAW and created new execution plan in DAC for dial load into these table.
• Proficient in working with HP Service center and Quality center.
• Worked in production support and seen through the phase of the developments in the production and done various bug fixes.

ETL DAC Administrator:

• Informatica Power center 8.6 is used to load the PeopleSoft 9.0 HCM data into OBAW using Source dependent adaptors SDE PSFT 9.0 , source independent adapters SILOS , PLP and Custom Folders
• Based on user requirements, DAC tasks and Informatica mappings were debugged and DAC parameters were changed to load multiple PeopleSoft Trees into OBA Warehouse as hierarchies
• Identified Data warehouse and staging tables, Informatica workflows/mappings and DAC tasks related to PS E-Performance data and customized Informatica mappings to load historical data
• Updated Informatica Processes to normalize performance ratings as per QVC requirements
• Created Customized Category 2 11 level Position Dimension Hierarchy Table into OBAW using Informatica and Integrated with DAC for routine scheduling as per Client requirements - SDE PSFT 9.0 Adaptors did contain out of box mappings to load Position Hierarchy
• Modified existing Category 1 Informatica mappings to load the HCM Data - GL Code, Company etc
• Created custom subject areas, custom tasks to load Internal finance data from flat files into OBAW
• Migrated BI Objects from UAT to Prod and actively supported all Production environments
• Took back-up of DAC, BI Informatica repositories and BI Web catalogs
• Involved in Knowledge transfer to internal QVC IT Developers on various issues and Product maintenance

Environment: OBIEE 10.1.3.4, BI Publisher, BI Apps 7.9.6, DAC 10.1.3.4.1, Siebel 7.x, Informatica Power Center 8.1.1, Oracle 10g, Oracle R12, TOAD, DAC, MS SQL Server 2005, UNIX , Oracle SQL Loader, Teradata.

Confidential

OBIEE Consultant

Responsibilities:

• Conducted meetings with business representatives for gathering the Finance Team's Reports / Dashboards business requirements.
• 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.
• Performed Data Warehouse analysis and identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Designed and developed Analytics Metadata Repository using Oracle BI by importing the required objects into Physical Layer using connection pool, developing multiple Dimensions Drill-Down Hierarchies , Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Extensively worked with BI server log files to resolve the issues.
• Developed many Accounting and Collection Time Series objects for comparing the Billings, Collections and Adjustments between the different time frames.
• Implemented comprehensive security functionality by creating users web groups, setting up LDAP authentication and associating catalog objects and Web modules with the created users and groups.
• Configured iBots to deliver content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Configured new customized mappings and work flows in DAC for new customized subject area.
• Configured DAC to run nightly data loads on daily basis.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Captured the business requirements, worked on gap analysis, and prepared the gap analysis document.
• Developed many incremental ETL using Informatica mappings.
• Performed Unit Testing and worked with the end user at various stages of the test cycles.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes .rpd, Dashboards, Security etc .

Environment: Oracle Business Intelligence EE 10.1.3.4, OBIA 7.9.6, Informatica Power Center 8.1, Oracle 10g, Teradata, TOAD, SQL Navigator, Web Logic 8X, UNIX.

Confidential

Siebel Consultant / Analyst

Responsibilities:

• Designed and developed the Metadata Repository .rpd using server Admin tool by importing the required objects into Physical Layer, developing multiple Dimensions Drill-Down Hierarchies , Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed and debugged many intelligence Dashboards using different Analytics Views Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View , Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Gathering, analyzing and identifying the gaps of business reports requirements.
• Worked on Apple data mart and enhancement of application in ETL Tool which loads forecast data from flat files to data base tables in data warehouse after validations as per business requirements.
• Worked on admin tool to configure the business model based on the end user requirements.
• Created various aggregate tables to improve query performance.
• Created Dashboard prompts and criteria prompts for better understanding of the trends and projections.

Environment: Oracle Siebel 7.8, Informatica 7.1.2, Oracle 9i/10g, Toad, SQL Server, SQL Plus, TOAD, Windows 2000.

Confidential

Oracle/PL/SQL Developer

Responsibilities:

• Worked on a trading project for a client to develop an application to trade coal, gas and power.
• Gathered user requirements and created the business requirements documents.
• Documented the technical specification for the reports and tested the generated reports.
• Created and managed Database.
• Used the technical document to design tables.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created Database triggers to maintain the database security.
• Created stored procedures and functions to be called by the application.
• Created Packages to be called by Visual Basic modules
• Created trading reports using Crystal Reports.
• Involved in testing of the reports.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Prepared test plans for various modules.

Environment: Oracle 8i, SQL Loader, PL/SQL, Windows NT.