PROFESSIONAL SUMMARY

• 7 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

Title: Senior OBIEE Consultant

Responsibilities

• Worked closely with the governor's office and the budget analysts to gather requirementsand built reports and dashboards accordingly.
• 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.
• Designed and developed KPI's with the headcounts for the Office of Disability and equal Opportunities department.
• 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

Title: 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

Title: 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

Title: 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.