Professional Summary

• Having 8 years of IT experience in Complete Software development Life cycle SDLC of Database, Data warehouse and Business Intelligence Applications using Informatica and Siebel Analytics which includes experience in OBIEE 10.1.3.x/11.1.1.x/Siebel Analytics 7.x, Administration tool, Intelligent Dashboards, Answers, Delivers, iBots, Oracle BI Publisher, and Oracle BI Applications 7.9.5 DAC , Oracle Data Integrator 11g
• Proficiency in developing OBIEE Repository at the Physical, Business and Presentation Layers Data Modeling , Time Series Objects, Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE/Siebel Security setup users/group, access/ query privileges , configuring OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog objects Dashboards, Pages, Folders, Reports and Scheduling iBots.
• Experience in Building Data Warehouses Star Schema and Snow Flake Schema from OLTP and ODS Databases performing ETL from different Data Sources using Informatica.
• Upgrade and Deployment experience from Siebel Analytics 7.x to Oracle BI 10.1.3.x
• Experience in performance tuning of reports
• Experience in Oracle Data Integrator development
• Strong Proficiency in Business Objects, Oracle database 11g, SQL, TOAD/SQL Developer and UNIX
• Exclusively worked on OBIEE Administration Physical, Business Model Mapping, and Presentation Layers , Answers, Dashboards, Job Manager, Catalog Manager, BI Publisher, Marketing and Disconnected Analytics.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse
• Working Knowledge of tables, processes and configurations
• In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, functions, procedures etc 11g,10g/9i/8i
• Highly experience in following standard Workflow structure WFS in development.
• Hands-on experience with the installation, configuration and management of Oracle and Microsoft SQL Server 2008/2005 databases running on various versions of Windows and UNIX platform
• Expertise in converting and using Oracle pre-build rpds Finance Analytics according to business requirements
• Technical Expertise Siebel Administration , Siebel Analytics, Siebel Tools, EAI, EIM, Actuate Reports, Workflow Manager and Siebel VB, eScript, Business Service.
• Strong understanding of OBIEE 11g concepts, especially in configuring Security settings using Weblogic Server Users and Groups , Oracle Enterprise Manager OEM for Roles and Privileges and Presentation Catalog, Score Cards, Key Performance Indicator KPI
• Worked in Telecommunications and Healthcare.
• Experience in configuring OBIEE Security integrated with Active Directory
• Experience in Implementing QA, Generating test scripts and Writing Test Case.
• Sound Knowledge and Experience on E-Commerce, Retail Market, ERP Enterprise Resource Planning , HR Human Resource SCM Supply Chain Management , CRM Customer Relationship Management sectors.
• Strong expertise in Implementing MUD Multi User Development Environment.
• Good hands on experience in using BI Publisher to create reports from BI Answers, BI server.
• Good experience in using Application Implementation Methodology AIM
• Strong understanding of the organization's goals and objectives.
• Good knowledge of applicable data privacy practices and laws
• Strong knowledge of business processes involved in Supply Chain Management.
• Highly Committed, Enthusiastic, Creative team player, possessing good interpersonal, written and verbal communication skills

Technical summary

PROFESSIONAL EXPERIENCE

Confidential

Confidential based bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. A member of the Fortune 500, the company helped pioneer the mass marketing of credit cards in the early 1990s, and it is now the fourth-largest customer of the United States Postal Service and has the sixth-largest deposit portfolio in the Confidential. It has its corporate offices in Tyson Corner, unincorporated Fairfax County, Virginia, near McLean.

OBIEE Developer

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Service Business Analysts and Users.
• Worked under Agile Methodology , delivering reports in each sprint
• Developed and customized the Oracle BIEE Metadata repository .rpd model by creating connection pools, physical / Alias Tables, defined joins and implemented authorizations in the physical layer, aggregates, dimensions, hierarchies time series functions in the BMM Layer, catalogs folders in Presentation Layer using Oracle BI Administration tool.
• Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors, catering to provide insight into the Sales / Marketing / Financial data.
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Implemented security by creating users web groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associating catalog objects and Web modules with the created groups.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, Oracle materialized views and making changes to reports.
• Created the OBIEE and OWB environment for Development, QA and Production environment.
• Migrated the code in different environments like QS, UAT, PROD..
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules Reports, Dashboards, Security and Star schema .
• Implemented Usage tracking reports which read statistics from the usage tracking database. These reports helped identify performance bottlenecks for further tuning.
• Involved in developing the Incremental ETL process Mappings Mapplets using various Transformation and Workflows with Sessions / Tasks.
• Extensively used DAC, to configure, monitor and schedule ETL routines.
• Created the Execution Plans, Subject Areas, Task groups, Tasks to schedule ETL loads in DAC.
• Created Execution plan to run only the required mapping as part of Daily, Monthly and Quarterly ETL runs

Environment: OBIEE 10.1.3.X, Siebel CRM 7.x Sales Analytics, Marketing Analytics, Service Analytics , Oracle 10g, BI publisher DAC, Informatica Power Center 8.x, ,Microsoft Windows Server 2003 and XP

Confidential

Confidential is a set of pharmaceutical, chemical, imaging, and respiratory equipment suppliers based in the St. Louis, Missouri, area. Founded in 1867 when the Mallinckrodt brothers formed G Confidential to manufacture pharmaceutical chemicals, Confidential was purchased by Tyco Health

Sr.OBIEE/ODI developer

Responsibilities:

• Interacted with Business analysts for gathering the Reports / Dashboards requirements and to define business and functional specifications for 11g/10g.
• Experience on OBIEE 11g Installation and Upgrade
• Configured and installed database using Repository creation utility RCU .
• Configured and installed Web logic console console , Enterprise Manager EM .
• Installed and Configured Siebel HR and financial analytics repository as per user requirements
• Configured Oracle Business Intelligence Application BIAPPS . Including setting up Oracle Business Analytics Warehouse OBAW , using Database Administration Console DAC .
• Installed Financial and SCM Supply chain Management analytics.
• Analyzed and recommended enhancements to Metadata Reporting in all 3 layers Physical, Business and Presentation by creating new models to support the business.
• Built 3 Subject Areas, for Different business requirements
• Successfully establishes the connectivity from Hyperion ESSBASE 11.1 cube to OBIEE 11g/10.1.3.4
• Successfully extracted the data from ESSBASE using DATAEXPORT command
• Integrated OBIEE Presentation Layer with BI Publisher and provided the capability to download the reports in the user defined formats
• Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/ iBots/Alerts, creating reports / Dashboards, Cache Management/Monitoring, and building Metadata consisting of three layers Physical Layer, Business Model Presentation Layer using OBIEE admin tool.
• Experience in configuring Interactive Dashboards with drill-down capabilities, using global and local Filters, Siebel Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Created different Dashboards/KPI for financial analysis using OBI Apps 7.9.6.3 from PeopleSoft transactional data
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers. Built 3 Subject Areas, for Different business requirements.
• Developed Oracle Procurement and spend Analytics to optimize supply side performance by integrating data from across the enterprise value chain
• Implemented Cache management by using Event-polling tables in database to optimize the performance.
• Worked on deployment of different OBIEE builds on LINUX, Production Server
• Responsible for migrating the web catalog and RPD from DEV, UAT and Training, Production environments.
• Implemented External table Authentication Data level and Object level Security
• Designing K-Shell Wrapper Scripts, Automate OBIEE Jobs by NQCMD Prompt, Purging of Cache by NQCMD script automated jobs..
• Involved in developing Initial and Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions/Tasks
• Developed many complex Informatica ETL process and Oracle Packages i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, analyzing data sources, creating interface documents etc.
• Well versed in using the security settings in OBIEE to set up Groups, Access Privileges and Query Privileges

Environment: OBIEE 11.1.5/10.1.3.4, Oracle11g, OBIA 7.9.6.3 BI Pub 11.1.1.6,PeopleSoft, PL/SQL, Toad, Oracle Data Integrator 11g, Informatica Power Center 8.6, Hyperion Essbase 11.1, MS-Excel,Visio, Windows XP, Solaris, Red hat Linux

Confidential

Confidential is currently ranked number 398 on Confidential Largest Companies and through our subsidiary companies and other investments is the leading provider of title insurance, mortgage services, and diversified services.

Sr. OBIEE /ODI developer

Responsibilities:

• Interacted with Operations and Subject Matter Experts SME , Business Analysts and Users in gathering and analyzing and designing the Business Reports Requirements.
• Performed the gap analysis, Identified Facts and Dimensions with levels hierarchy and made required changes to the Data Marts.
• Documented the Functional and Technical design documents in MS word and latter converted the Technical design document in to the report Field Mapping Document.
• Installed and configured ODI 11g
• Involved in designing and developing subject areas in Repository .RPD catering to the OLAP reporting needs of OBI Project.
• Customized/Modified by importing the newly designed fact and dimension tables and configured it in the 3 layers of the RPD. Created the required aliases, views in Physical layer. Implemented Level Based Metrics in the BMM layer. Implemented the Time Series Wizard for comparing measures in different time Periods. Created Compound facts in the BMM as per the client requirement.
• Created Repository Static and Dynamic variables. Also created Initialization blocks for Session variables which are used for authentication and security.
• Created Dimension Hierarchies in the BMM layer to drill down and drill across on various dimensions as per client requirement.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security.
• Created Catalogs in Presentation layer used for both ad-hoc and Dashboard users.
• Created OLAP requests in OBIEE/Siebel Answers and multi-level requests drill-downs and guided navigation . Developed and debugged many Dashboards using different Analytics Views Pivot Table, Chart, and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Performance tuning in OBIEE for star schema's by implementing aggregate navigation, cache management, Materialized Views and Database tuning.
• Created Management and Executive level Dashboards and KPI using OBIA from PeopleSoft data source for CRM analysis
• Involved in Unit, Integration testing and User Training of the generated reports.
• Worked with Quality Center for logging, tracking and fixing bugs in QA Testing.
• Involved in migrating of OBIEE/Siebel Analytics code from dev - UAT- Prod for deployment.
• Debugged and resolved data matching issues ranging from the base tables to BI dashboard reports.
• Worked in Production support.

• Developed complex new Informatica ETL process and Mappings Mapplets using various Transformations Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator and Workflows with Sessions / Tasks.
• Performed High performance Batch Load using Oracle Data Integrator

Environment: OBIEE 10.1.3.4.1/11.1.1.3, OBIA 7.9.6.3, PeopleSoft, Oracle 10g , Oracle data integrator11.1.1, SQL, PL-SQL, TOAD 9.5, Informatica 8.1, MS-Excel, MS SQL Server 2005, Windows NT

Confidential

Sr.OBIEE Developer

Confidential is a not-for-profit health care provider based in Confidential . The objective of the project is to provide information to the Executives and Managers about the hospital budget and resources. The reports and dashboards will be able to help the executive to control their budget and resources and to make business decision to maintain the labor productivity.

Responsibilites:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Created ODBC connections and imported the Physical tables, Views, keys and foreign keys as per the Business Requirements.
• Created the repository model with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Created Dimensional Hierarchy for all Dimensions, Level based Measures and Aggregate navigation in BMM layer.
• Developed Dashboards/Reports using the Oracle Business Intelligence platform for requirement analysis.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Static View, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Extensively used Guided Navigation for user friendly reports.
• Implemented Column Level security for specific users who can access a part of the tool, like just answers and Dashboards.
• Implemented Security by creating roles web groups using External tables Authentication.
• Enhanced performance of Reports / Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes and managing Cache etc.

Environment: OBIEE 10.1.3.4, Oracle 11g, SQL, PL/SQL, MS-excel, Windows XP Professional.

Confidential

Confidential is the world's largest home improvement specialty retailer with stores in the Confidential . In 2010 was ranked 29 in the fortune 500 list of companies.

Siebel Analytics Consultant

Responsibilities:

• Gathered, analyzed, and identified the GAP of Business Reports Requirements.
• Created Siebel Analytics Repository at 3 layers i.e. Physical Layer, Business Model Mapping and Presentation Layer level.
• 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.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• 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.
• Performed testing to validate reports and mappings.
• Involved in developing the Incremental ETL process.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
• 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.
• Extensively worked in fine-tuning of Informatica Mappings.
• Used different application development tools like TOAD Oracle .

Environment: Windows XP Professional, Linux, Siebel 7.8.4, Informatica Power Center 7.1,Oracle 10g, SQL, PL/SQL and TOAD,MS-Excel, PowerPoint.

Confidential

Confidential is one of the largest insurance claims processing companies in the world. It has 300 insurance company customers and delivers many of its applications based on the software as a service or hosted model. Create OBIEE metadata reports and dashboards and integrate the application with Oracle Mapviewer in a highly secure, extranet environment.

OBIEE/ Informatica Developer

Responsibilities:

• Designed and populated dimensional models both star and snowflake schemas for a data warehouse and Datamarts.
• Used Parallel extender Informatica 7.1.1 while running jobs for bulk data splitting and to pass the data into subsets to all available nodes for best job performance.
• Requirement analysis, Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle Business Intelligence OBI Analytics platform.
• Involved in the design of the BAL Business Analytics Layer designing the DW for the BAL.
• Involved in OBIEE administration and worked Configuring OBIEE with LDAP server for Security.
• Designed and Developed OBI Repository at 3 layers i.e., Physical Layer connecting to Data Warehouse imported objects with joins , Business Model / data mapping create Logical tables, Drill-Down Hierarchies complex joins and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
• Implemented security at Object Level Data Level for different level of hierarchies Subject Areas.
• Developed different kinds of Reports pivots, Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters using Siebel Analytics Web.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Installed and configured OBIEE. Admin tool and Siebel web components including Intelligence Dashboards, answers, delivers and Analytics web
• Developed strategy for migration from Siebel Analytics 7.9.5 to OBIEE 10.1.3.3.
• Performed the benchmark and SLAs for up gradation process and runtime of OTB and new reports while doing migration from Siebel Analytics to OBIEE.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Extracted data from heterogeneous sources for ETL process
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.

Environment: OBIEE 10.1.3.3, Informatica 7.1.1, DAC 7.8.5, Siebel Analytics 7.9.5, SQL Server 2005, Oracle 9i, TOAD, Windows XP

Confidential

Confidential is one of the world's leading suppliers of network engineering, agile operational intelligence and inventory management solutions to the telecommunications industry.GE supports over 100 communications customers' worldwide, providing innovative software and robust service solutions for their network infrastructure.

ETL-Informatica Developer, PL/SQL developer

Responsibilities:

• Involved in Software Development Life cycle starting from requirements gathering and performed object oriented analysis and design to implementation maintenance.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked on Slowly Changing Dimensions to update frequent data using lookup and update transformations.
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations.
• Used the SQL tables and records in transaction processing in the backend.
• Wrote PL/SQL procedures and triggers to carry out database maintenance tasks.
• Created and used views for different business needs.
• Extensively Used JOINS writing views in the Database.
• Created and used different type of Indexes and Sequences.
• Involved in Performance Tuning and Query Rewrite.

Environment: Informatica Power Center 7.1.4, TSQL, Oracle 10g, 9i, SQL, PL/SQL, SQL Plus

Confidential

Siebel Analytics Consultant

Confidential . is one of the world's leading manufacturers and marketers of quality skin care, makeup, and fragrance and hair care products. Estee Lauder always is in need of numerous web-based financial reports as well as their in-house financial reports for its widespread international markets and domestic businesses..

Responsibilities:

• Coordinated and presented deliverables to business teams and development teams.
• Sourced requirement documents and produced functional specifications.
• Presented functional and technical requirements information in-group settings.
• Created high-level and detailed design documentation.
• Implemented the best practices, which reduced the cycle time and improved profitability for the organization.
• Worked closely with the DBA and ETL Leads for gathering necessary data.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Configured Repository on the Physical, Business and Presentation levels.
• Identified data sources, corresponding Mappings and Logical Joins
• Configured tables and columns between Business and Presentation layers.
• Worked with development team to create and configure source data.
• Generated queries and placed filters in Siebel Answers.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.

Environment: Siebel Analytics 7.5, Oracle 9i, UNIX, Informatica 6.1, Windows XP