SUMMARY

• 9 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse, Data Marts, Business Intelligence and Transactional applications
• Extensive experience in Business Intelligence and Data warehousing: Kimball and Inmon Methodology using OBIEE/Siebel Analytics 7.x
• Proficient within the Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.
• Extensive experience in providing end - to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, creating reports / Dashboards, Delivers/iBots, cache monitor, and building OBIEE/Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer)
• Worked Extensively on OBIEE/Siebel Analytics RPD, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation
• Expertise in Data Analysis, Performing Gap Analysis, Identification of Dimensions, Associative tables, Facts, and Aggregate tables, Measures and Hierarchies
• Experience configuring Interactive Dashboards with drill-down and drill through capabilities using global and local Filters, Siebel Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports, Filters, Prompts)
• Expertise in Debugging and Performance Tuning of Siebel Analytical Dashboards for minimum run time reports
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.
• Expertise in Creating Filters, Global Prompts in Dashboards and Analytic Reports, Presentation Variables, and Legend, Narrative Views to filter the data.
• Managed and Resolved the issues which occurred in 11g BI Server
• Worked on MUD Environment and moved the repository to Development, Test, QA and Prod
• Expertise in implementing LDAP and External table Authentication
• ImplementedData Level Security and Object LevelSecurity.
• Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level, Dashboard Level, Section Level etc..
• Implemented Object LevelSecurity at rpd level and Web catalog level.
• Experience 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) and setting up office integration for BI publisher.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Informatica Power Center
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Good Documentation Skills for writing Use Cases, Functional Requirement Documents (FRDs), business requirements documents (BRDs)
• Strong in developing Informatica Mappings/Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows, Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts (using pmcmd )
• Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, Aggregator.
• Expertise in Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL.
• Good at database Performance Tuning of Data Warehouses by implementing the materialized views, bitmapped indexes and partitions
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, Star Schema, Data Modeling, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Experienced in Extracting Data from different source Systems i.e. Oracle, SQL SERVER, Flat Files, Mainframe Files, Excel etc
• Very strong in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level using Oracle PL/SQL
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL * Loader, SQL * Plus, Data Loader, TOAD
• Involved in working closely and effectively with a variety of Business/Technical analysts and a Variety of Business users to meet their Business Objectives.
• Excellent problem solving skills with strong technical background

TECHNICAL SKILLS

Reporting Tools: OBIEE 11.1.1.6/10.1.3. x, Siebel Analytics 7.8/7.7/7.5, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL Developer

ETL Tool: Informatica Power Center 9.1/8.x/7.x, Informatica Power Mart 6.2/5.1/4.7, SSIS, SSRS

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, DB2, MS Access

Languages: PL/SQL, UNIX Shell Scripts, VS COBOL II, MF-COBOL

Utilities/Tools: SQL*NET, SQL*Plus, SQL*LOADER, TOAD, Putty, PL/SQL Developer, TIDAL Scheduler, Control M

Operating Systems: UNIX, Windows 7/XP, LINUX, DOS, OS/390

Development Methodologies: Agile methods (Lean, XP, Scrum) and Rational Unified Process and their variations, Waterfall Methodology

Data Modeling Tools: ER Win, ER/Studio, Visio

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. OBIEE Consultant

Responsibilities:

• Gathered Business requirements by interacting with the business users/client and translated the business details into Technical design documents and defined subject areas for analytical data requirements.
• Created mockup reports and dashboards for review by the business users.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• 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.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Used Hierarchy Object in the Presentation Layer
• Worked on repository and session variables.
• Used the security settings in Siebel Analytics 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.
• Performed validation of data in the reports and dashboards.
• Created iBots to send pre-processed reports using OBIEE Delivers.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
• Documented the design for intuitive understanding and future reference.
• Creating and modifying Business Intelligence requests using Oracle Business Intelligence Answers.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Performing administrative tasks related to the development and configuration of Interactive Dashboards
• 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).
• Worked on OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer).
• Configured LDAP / Single Sign-on / in OBIEE Console
• Developed different levels of Security set-up for the entities of the application on Repository 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.
• Integrated Ldap With OBIEE for Implementing security for both Authentication and Authorization
• Data Level Security for Region and Product dimensions, Routing Groups using Session Variables.
• Worked with data modelers and Users to define the Joins between tables in the RPD.
• Developed Performance Tuning Strategies for optimizing the performance.

Environment: OBIEE 11.1.1.6.5 , Informatica PowerCenter 9.1, Oracle 11g, Netezza, PL/SQL Developer, Toad 10.5, Putty, Tidal Scheduler, UNIX, Windows

Confidential, Smithfield, RI

OBIEE Consultant

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.
• Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using Agents (iBots).
• Performing administrative tasks related to the development and configuration of Interactive Dashboards
• 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).
• Worked on OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer).
• Configured LDAP / Single Sign-on / in OBIEE.
• 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.

Environment: OBIEE 10.1.3.x, Informatica Power Center 8.6/8.1, Oracle 10g/9i, UNIX, SQL*Plus, SQL*Loader, Windows, PL/SQL Developer 7.1, Toad 10.5, Putty

Confidential, Louisville, KY

OBIEE Consultant

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business requirements and functional specifications.
• Identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Translated the user requirements into data structures designs into Relational 3N format and then into the Star Schema Database format.
• Designed and developed the OBIEE/ Metadata Repository (.rpd) using OBIEE 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.
• Worked in BI Publisher and Windows environment with OBIEE writing SQL and PL/SQL queries along with the Data Warehousing concepts.
• Developed Time Series objects for comparing the usage variations between the current and previous years and months.
• 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, checks with LDAP.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Used many Repository and Session Variables to obtain the user requirement and make the reports.
• Developed various Analytical and Operational OBIEE 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.
• Responsible for setting up the framework architecture from front end perspective from high level to detail level reporting that include page/dashboard prompts, local/shared filters etc.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Worked on Siebel Answers to build OBIEE Interactive Dashboards with drill-down and drill through capabilities.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Cache management.
• Involved in developing complex ETL process i.e., Mappings & Mapplets using various Transformations (Source Qualifier, Aggregator, Rank, Router, Update Strategy, and Look-Up) and Workflows with Sessions / Tasks.
• Debugged reports and OBIEE Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.

Environment: OBIEE 10.1.3.x, Informatica Power Center 8.6/8.1, Oracle 10g/9i, PL/SQL, UNIX, SQL*Plus, SQL*Loader, Dollar Universe scheduler, Windows, Lotus Notes 6.5, PL/SQL Developer 7.1, Toad 10.5, Putty

Confidential, Louisville, KY

Sr. ETL Developer/OBIEE consultant

Responsibilities:

• Gathered the requirement from the client and translated the business details into Technical design document.
• Analyzed impact of proposed system solutions for each line of business and identified risks, priorities, and alternatives.
• Involved in creating the HLD, LLD and Data mapping documents for ETL processes.
• Designed and Built Siebel Analytics 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 LDAP Authentication to setup groups, access and query privileges
• Creating/Developing reports in Siebel Answers / Dashboards and trained the Super Users to create reports in Analytics and also led them to best practices in managing and sharing reports
• Developed different kinds of Reports Pivots, View Selectors, Column Selectors, and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts. Extensively used Siebel Delivers and iBots
• Developed several complex mappings in Informatica, a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter andUsed Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and Sql Server to the Data mart on Oracle database.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Developed complex Mappings using Transformations (Filter, Router, Expression, Joiner, Connect Lookup, Unconnected Lookup, and Updated Strategy) on the extract data according to the Transformation Business Rules and User requirements.
• Built re-usable Mapplet using Informatica Designer.
• Involved in creating logical and physical data models using Erwin tool.
• Performance tuning the long running queries.
• Wrote Integrity Checks, Data Cleansing scripts, SQL Queries to fetch data from multiple tables using Joins that produced Reports & Logs.
• Generated PL/SQL Packages, Functions and Procedures to implement the Business Logic. Monitoring daily scheduled job which loads data from Flat Files to Oracle Database.
• Wrote SQL, PLSQL programs required to retrieve data from the Data repository using cursors and Exception handling.
• Used SQL*Loader to load data from various sources into an Oracle database.
• Using Oracle 10g created numerous Stored Procedures, Functions, Packages and Triggers, Views.
• Extensively Used Analytical Functions for the various complicated business logics.
• Extensively used Oracle SQL Loader, External Tables for loading huge data into the target tables.
• Created database objects like Tables, Synonyms, Views, Indexes, and Sequences.
• Proficiently developed Functional Requirement Documents, Design documents, Test Cases and Project documentation (user guides, standard report instructions, demos).
• Used SQL*Loader to load data from various sources into an Oracle database.
• Part of Production on call support on a 24/7 basis.
• Involved in creating the HLD, LLD and Data mapping documents for ETL processes.
• Implementing Slowly Changing Dimension (SCD type II) design for the Data Warehouse.

Environment: Informatica Power Center 8.1, OBIEE 10.1.3.3, Oracle 10g/9i, Windows NT, UNIX, SQL*Loader, $ Universe scheduler, Lotus Notes 6.5, PL/SQL Developer 7.1, Toad 10.5, Putty

Confidential, Richmond, VA

ETL Developer/Oracle Developer

Responsibilities:

• Creating and managing table, Indexes, table spaces, triggers, db links and privileges.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Generated and maintained Keys, Constraints and Relationships between the tables for OLTP, Test, Development, PV and Archieve instances.
• Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.
• Interacted with Business Analyst to understand the data warehouse requirements
• Involved in developing dimensional data model for the PowerCenter datamart using star schema models.
• Involved in gathering requirements from the Engineering Team, who maintains and uses the Engineering Bill of Materials
• Involved in designing the Datamart and preparation of technical design documents
• Developed many Informatica Mappings using various transformations (Update Strategy, Router, Expression, Stored Procedure, Lookup, and aggregator) for ETL of Items, BOM, Components Cost and Vendor Information
• Created many reusable transformations and mapplets to create surrogate keys, filter, transform data which is extracted from various sources
• Developed scripts to execute the batches/workflows using pmcmd
• Developed many Oracle packages for calculating the item cost using various cost types, components as well as vendors
• Implemented the reconciliation process for data consistency between source systems and the warehouse
• Fine-tuned the long running reports by re-organizing the data re-building of indexes and creation of new indexes (if required) and making changes to reports itself
• Performed the Unit and Integration testing of mappings
• Identified and resolved numerous technical and operational problems in the data Mart
• Identified and created different source definitions to extract data from input sources like Flat files, SQL Server and load into relational tables like Oracle.
• Scheduled Sessions, Batch Process based on demand, run time, run only once in workflows using Workflow Manager.
• Involved in optimizing the performance at various levels Mapping Level, Session Level and Database Level.

Environment: Informatica Power Center 6.1, Oracle 9i, SQL*Plus, SQL*Loader, Toad, Autosys, UNIX (Solaris), Windows

Confidential

Oracle Developer

Responsibilities:

• Developed PL/SQL Packages, Stored Procedures, Functions, Triggers.
• Developed the Procedures, Packages, Functions and Triggers as per business requirements.
• Developed scripts to generate the database tables, constraints, triggers etc.
• Created Views as per the client requirement.
• SQL* Loader was used to load data from various sources like Flat Files, XML into target tables.
• Extensively used SQL, PL/SQL and Shell Scripting.
• Developed user manuals and documentation for the application.

Environment: Oracle 8i, SQL*Loader, Toad, PL/SQL, Unix, Putty, Windows.