PROFESSIONAL SUMMARY

• years' experience in implementing end-to-end business intelligence solutions, leveraging analytical and decision making systems against different enterprise data domains using OBIEE, BI Publisher, ODI, Informatica, SQL, PL/SQL against Relational and multi-dimensional data-structures.
• Expertise in data warehouse concepts likely Star and Snow flake schema, Dimensional hierarchies, Data federation and fragmentation, data denormalizationetc.
• Expertise in designing and developing of Oracle BI Metadata Repository .rpd using Admin tool at all the three layers Physical Layer, Business Model and Mapping Layer, Presentation Layer
• Expertise in defining logical cube in RPD using level based measures, Dimensional hierarchies, data fragmentation and federation techniques.
• Experienced in building reports using different views likely Table, Pivot table, Graphs, Narrative views, Column selector, Filters, Gauge, View selector, dynamic HTML/ Static texts.
• Experienced in building interactive reports and dashboards with guided navigation/action links, drill downs, master-detail linking, dashboard prompts, report switching and etc.
• Extensively worked in defining Object level, Data level, and User level security.
• Extensively worked on repository variables, session variables, presentation variables and request variables.
• Experienced in configuring and administering the BI Publisher, Map Viewer, BI Office and OBIEE system components BI Server, Scheduler, presentation server, Javahost and cluster controller .
• Experience in configuring Multi-user development MUD environment and utilizing Merge utility to facilitate enterprise scale deployment.
• Experience in creating aggregate tables, table partitions, indexes and cache management.
• Good Knowledge in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL.
• Experience in ETL methodology for supporting Data Extraction, Loading and Transformation processing using pre-staging, staging approach in Informatica Power Center.
• Experience in SCD 1,2,3 mappings using Informatica Power Center such as Source Qualifier, lookup, Filter, Expression, Router, Normalizer, Joiner, Sequence, Rank, Aggregator, Stored Procedure, Sorter, Pre-Post Mapping Process.
• Excellent Data Analysis skills and ability to translate business logic into mappings using complex transformation logics for ETL processes.
• Experience interacting with Business users and architecting high level requirements, high level design, detailed level design and GAP analysis documents.
• Team player and self-starter with good communication skills and ability to work independently orpart of a team.

TECHNICAL SKILLS

• Business Intelligence Tools: OBIEE 11.1.1.7.x, 11.1.1.6.x, 11.1.1.3, 10.1.3.4, BI Publisher
• ETL Tools: Informatica Power Center 8.1/7.1/6.2/5.1
• Databases: Oracle 11g/10g, MS SQL Server 2005/2008, DB2 LUW
• Languages: C, C ,T- SQL, PL/SQL
• SQL Tools: SQL Plus, SQL Developer, TOAD
• Applications: MS Word, MS Excel, Outlook, PowerPoint

PROJECTS

Confidential

Senior OBIEE Consultant

Responsibilities

• Designed and developed KPI's with the headcounts for the Office of Disability and equal Opportunities department.
• Created mockup reports and dashboards for review by the secretariats and the team of the Administration and Finance department both in regular mode and accessibility versions.
• Worked closely with the governor's office and the budget analysts to gather requirementsand built reports and dashboards accordingly.
• CreatedFunctional designdocumentsafter gathering and understanding business Requirements
• Created the Technical design documents, Requirements Traceability Matrix and Data source documents to define data mappings.
• Designed and developed the OBIEE Repository Physical, BMM, and Presentation layers as per end users requirements.
• CustomizedOBIEE to improve the screen reader mode for the users and also to enhance certain in built OBIEE features.
• Installed patches for chrome compatibilities and for various other bugs encountered in 11.1.6.2 and also installed point upgrades.
• Worked extensively on the BI Publisher reports, to build the budget books for the State of Massachusetts.
• Built RTF and excel templates involving various grouping functionalities and conditional formatting's.
• Configured security in Administration console for Authentication and created Application roles.
• Setup the visibility of dashboard reports to employees with respect to their responsibilities. Administered permissions and privileges for dashboard visibility and modifications to users based on their groups or responsibilities.
• Assisted in building the Functional and Technical test scripts for the regression testing of the dashboards and the publisher reports.
• Performed production support for the project, restarted and maintained the OBIEE Servers.

Confidential

Senior OBIEE Consultant

Responsibilities

• Worked in whole life cycle of the project from requirements gathering to deployment.
• Analyzed data and datamodelto developLogical Star Schema model
• Actively involved Data Modelers and Business Analysts to gather requirements and translating them to Functional Specs.
• Participated in Installation ofOBIEE 11g on Linux and worked on Weblogic Admin console and Weblogic Enterprise manager.
• Developed Time Series Objects using Ago and To Date functions for time series comparisons.
• Configured security in OBIEE Administration Tool and also managed security by setting up groups, access privileges and query privileges.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Worked onPerformance Tuning of Dashboards and Reports.
• Implemented Comprehensive Security Model, by creating User Roles, Initialization Blocks and setting up External Table Authentication.
• Worked on BI Publisher importing data from the data source and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Conducted User training for several dashboard/ Reports to help them improve metrics that help them drive critical decisions.

Confidential

OBIEE Consultant

Responsibilities

• Experience in gathering requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Created connection pools, physical tables, defined joinsin the physical layer of the RPD.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias tables and Extension tables
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source
• Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects, create, modify, filter results using OBIEE answers.
• Created and scheduledIBOTS in oracle BI to provide real-time, personalized data to subscribers.
• Used drilldown, presentation variables, and promptsto createreports and dashboards.
• Used different views in OBIEE like view selector, column selector, table, pivot, and chart.
• Tunedreports and dashboards performance by implementing the Materialized Views, Table partitions, re-building of indexes and managing Cache.
• Enhanced Query performance, by analyzing modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Experienced in installing and configuringOBIEE
• Provisioning the users with the required level of access to the OBIEE reports and dashboards.
• Fixing issues related to the joins in the RPD.
• Configured and Scheduled BIPublisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Migrated RPD and Catalog from Dev to QA and QA to Production.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Responsible for making the end users understand the features of Answers.
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of end-users.

Confidential

OBIEE Developer

Responsibilities:

• Used the OBIEE Administration tool to develop and enhance metadata
• Customized the Siebel Analytics Repository physical, BMM, and presentation layers .
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Configured and Created repository using Obiee Admin tool
• Created numerous executive level reports and Dashboards to provide insight intosales, marketing, and financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. managed day-to-day rpd, Scheduler iBots
• Managed security privileges for each subject area and dashboards according to user requirements
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

Confidential

PL/SQL and ETL Developer

Responsibilities:

• Gathered business requirements and created mapping documents based on the data model and source system analysis.
• Loading data from flat files into database tables using SQL loader.
• Writing PL/SQL Stored Procedures, Functions, views, Triggers for the application.
• Creating and maintaining triggers, packages, functions and procedures.
• Cleansing theheterogeneous source data, Standardize the Customer address, Extract and Transform data with business rules, and built re-usable Mapplets using Informatica Designer.
• Imported Sources and Targets created Mappings and developed Transformations using Power center designer.
• Created complex mappings and transformations using expressions, aggregators, filters, sorter, sequence generator, connected and remote lookups to develop and populate Data Marts.
• Created reusable transformations, Maplets and used them in the mappings.
• Fine Tuned Transformations and Mappings for better performance.
• Used Informatica Power Center Workflow manager to create sessions, workflow to run with the logic embedded in the mappings.
• Extensively used Informatica Power Center tasks like Decision, Command, Event Wait, and Event Raise, Email.
• Developed Sessions including complex batches and deployed in the Informatica Server, configured sever variables and analyzing log files for debugging.

Efficient Documentation was done for all phases like Analysis, design, development, testing and maintenance.