PROFESSIONAL OVERVIEW:

• Above 6 years of experience in gathering Business Requirements, GAP Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Business Intelligence and Data Warehouse / Data Marts in consumer goods, cable and communication and financial industry.
• In depth knowledge of Software Development Life Cycle (SDLC) with thorough understanding of various phases which includes Requirements Analysis, Design, Development and Testing.
• Expertise in Oracle Business Intelligence EE (OBIEE) 11.x, 10.x (Administration, Presentation Services) and Siebel Analytics (Admin Tool, Analytic Web and Scheduler), SAP Business Objects 4.1.
• Thorough knowledge of complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology.
• Strong track - record of developing OBIEE Repository (RPD ) at three layers (Physical Layer, Business Model & Mapping Layer and Presentation Layer), Time Series Objects, and configuring Analytics Metadata objects (Subject Area, Table, and Column).
• Proficient in Interactive Dashboards with drill-down capabilities using dashboard and page prompts, Web Catalog Objects (Dashboard, Pages, Folders, Reports), pivot table, chart view and Column selector.
• Strong experience in designing security model (groups, access / query privileges), data level security, object level security, External Table/LDAP Authentication.
• Proficiency in configuring and scheduling iBOTs to deliver analytics content to obtain different type of reports.
• Experience in performance tuning of Analytics Repository and Interactive Dashboards by Bench-Marking various strategies with business model level calculations versus database level pre-computations of aggregations, re-organizing the data, creating indexes and making changes to dashboards/reports itself.
• Experience in developing ETL specifications and data mapping documents for database, application tuning and data warehouse development .
• Expertise in Data warehouse/ Data mart implementations including project scoping, requirements gathering, dimensional modeling (Star Schema design and snowflake), FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter etc.
• Used Data Warehouse Administration Console (DAC) to configure execution plans, manage, and run ETL routines and monitoring the results.
• Experience in creating reports via BI Publisher application and creating templates using Microsoft Word Plug-in.
• Expertise in working with senior level managers, business users and developers across multiple disciplines.
• In-depth knowledge of the newer version of Oracle BI 11.1.1.x.
• Results oriented and Self-starter looking for challenges.
• Ability to rapidly learn and apply new technologies and improve processes.

TECHNICAL SKILLS:

Business Intelligence: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.x, 11.1.1.x, SAP Business Objects (4.1), Crystal Reports, BIPublisher, QlikView 11.0.x, SQL Server Reporting Services (SSRS), Data Warehouse Administration Console (DAC),Siebel Analytics 7.x (Admin, Web, Answers, Dashboards), Scheduler (iBots), Oracle BI Applications (OBIA) 7.9.5.

Data warehousing Tools: Informatica Power Center 8.6.1/8.1, Power Mart (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Mapping Designer, Warehouse Designer), SAP Information Design Tool.

Testing Tools: HP Quality Center, Microsoft Test Manager.

Additional Software: MS Office Suite 2007, 2010, Microsoft Visio, Microsoft Visual Studio.

Operating Systems: Windows NT/2000/XP/98, UNIX

Databases: Oracle, MS Access

Languages: C/C++, Java, SQL, PL/SQL, MATLAB,SAS,HTML

SQL Tools: SQL Developer, TOAD

Methodologies: Star and Snowflake Schema

WORK EXPERIENCE:

Confidential, Sacramento, CA

Business Objects Reports Developer

• Creating standard reports and providing Adhoc reporting solution for Voter Registration, Political Party, Investigations, Registration Processing, Public Voter Registration Data Requests and Voter Activity.
• Working through the design specifications for pre-defined reports.
• Working extensively on creating reports using Business Objects Web Intelligence Rich Client.
• Designed catalog for sharing, saving various reports and assigning proper permissions to it.
• Hands-on experience on Central Management Console (CMC), Universe, Launch Pad.
• Developed Global, hierarchical and cascading prompts, Filters and creating default parameters using Information Design tool.
• Experience in designing and migrating Business Objects universes, web intelligence, Crystal and BO reports.
• Creating standard templates for reporting.
• Working closely with Business Analysts for gathering and better understanding the requirements.
• Documenting and implementing the changes to reports per client needs.
• Participating in client collaboration sessions to provide an efficient reporting product.
• Involved in writing test scripts for reports and relationships in the Information Design tool.
• Testing Reports and adhoc scenarios using Microsoft Test Manager.

Skill Set: SAP Business Objects Web Intelligence (4.1), Central Management Console (CMC), Web Intelligence Rich Client, Information Design Tool, SQL Server Management Studio 2008 R2, MS Office 2007, 2010, MS Visio, Microsoft Visual Studio, Microsoft Test Manager, SOAP UI.

Confidential, Rancho Cordova, CA

OBIEE & BI Publisher Developer

• Prepared the Analytical Functional Specification and detail Design documents within a team of data modeling, ERP and BI experts for developing Adhoc Reporting.
• Working on developing Sentence Calculation, Programs & Classifications modules for SOMS.
• Supporting Inmate Movements and Counts (IMC) and Holds, Warrants, Detainers and Visitations (HWDV) modules.
• Involved in RPD development for new Reports and Dashboards from scratch.
• Created Analytics Repository by importing required objects into Physical Layer using connection pool, developing multiple dimensions (drill down hierarchies), and logical objects. Created Level based Measures and Aggregate navigation in BMM layer and created presentation catalogs in Presentation Layer.
• Deployed RPD on Weblogic Enterprise Manager and added users to the application through Administration console.
• Extensively worked on Answers tool for creating different reports per customer needs.
• Created Dashboard with KPIs, Alerts, Reports and implemented IBot’s for Business users.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers to achieve performance optimization and easy navigation of reports.
• Configured security from Answers tool by managing privileges as advised by business.
• Designed catalog for sharing, saving various reports and assigning proper permissions to it.
• 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.
• Involved in upgrading the tool from 11.1.1.3 to 11.1.1.6.2 and customizing the skins.
• Experience working in a data warehouse environment, including data design, data integration, database architecture, metadata, reporting and application tuning at the Operational, Tactical and Strategic levels.
• Experience in creating reports using BI Publisher application, hands-on experience on Microsoft word Publisher plug in for creating various templates.
• Created SQL programs to create and validate data based on the business requirements.
• Involved in all phases of testing the modules from Unit testing, Integration Testing, User Acceptance Testing, to Regression and Performance testing.
• Interacted with various other application groups worked collectively on the module deployment and tracked changes using Service Manager Tool.
• Participating in numerous client meetings to provide an efficient reporting product.

Skill Set: OBIEE 11.1.1.3, 11.1.1.6.2 , BI Publisher, Oracle Warehouse Builder (OWB), SQL Developer, HP Quality Center 9.0, HP Service Manager, Weblogic Administration Console, Weblogic Enterprise Manager, MS Office 2007, 2010, MS Visio.

Confidential, Vista, CA

ETL Developer /OBIEE Consultant

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Designed the ETL processes using Informatica to load heterogeneous source data from Oracle, MS SQL Server, Flat Files and Excel files to target Oracle Data Warehouse.
• Developed complex Mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Union, Aggregate, Update Strategy, Joiner, Filter and Router.
• Created/Modified Informatica ETL mappings in various stages folders like Staging area and production area for development and production environment that transfers data from Flat Files, Oracle Source systems to Oracle Target system.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).
• Customized the OBIEE Repository (Physical, BMM, and Presentation layers).
• 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.
• Developed the Oracle BIEE Metadata repository (.rpd) model with for Sales & Marketing subject areas that involved creating Physical, BMM layers with aggregates, dimensions, hierarchies & Time series functions, Presentation layer with catalogs & folders using Oracle BI Administration.
• Used the Security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.
• Developed 3 dashboards and 20 reports. The reports were used by the business to identify most profitable customers and analyze Revenue trends by Customer to identify opportunity / risk.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards with extensive use of BI PUBLISHER.
• Created User level security for intelligence dashboards based on Business Requirement.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Created iBots to send pre-processed reports using OBIEE Delivers.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Environment: OBIEE 10.1.3.4.2 , 11.1.1.6, Oracle 10g/11g, Informatica (mapping), Windows XP, 7, SQL*PLUS, Toad.

Confidential, Newport Beach, CA

Datawarehouse Developer /Sr. OBIEE Consultant

• Worked closely with Business Analyst, Discussed and Gathered the Analytics requirements from different user groups and created the Business Model using Star and Snowflake schemas.
• Installation, Configuration and Administration of Oracle Business Intelligence.
• Exposure to Oracle financials AR, GL modules.
• Developed complex Mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Union, Aggregate, Update Strategy, Joiner, Filter and Router.
• Creating Repositories, Physical Layer, Business Model and Mapping Layer and Presentation Layer using Oracle Business Intelligence Administration Tool
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Configured the Security settings in OBI Administration Tool to set up groups, access privileges and query privileges.
• Configuring repository & session variables to get dynamic reports and dashboards.
• Implementing Cache management to handle performance issue in report generation.
• Developed Global prompts, Filters, Customized Reports and Dashboards using OBI Presentation services.
• Merging of OBI repository and webcat files using Catalog Manager.
• Creating Users and Groups and assigning permissions depending on the user using Oracle Business Intelligence Administration Tool.
• Configuring, Developing reports using BI Publisher.
• Configuring OBI scheduler and generating ibots alerts for delivering the reports to different users.
• Configured OBIEE Repository to provide Analytical Reporting solutions to business.
• Implemented Security & Cache features to accommodate business requirements.
• Performed Performance Tuning of Dashboards/Reports by aggregate navigation, cache management, Oracle materialized views and making changes to reports it.
• Registering tables, tasks, preparing execution plans and scheduling daily loads using DAC.
• Worked with users and development team to ensure the reports deliver in time.
• Responsible for production support for the ongoing jobs they run every day.

Environment: OBIEE 10.1.3.4.1 , Oracle Business Intelligence Applications 7.9.5, BI publisher, Data warehouse Administration Console (DAC), Informatica 8.6, SQL Developer, Oracle EBS Financials (AR, GL), Windows 2003 Server.

Confidential, CA

Informatica Developer/OBIEE Consultant

• Worked in data analysis and data conversion and analyzed the source and target Databases.
• Involved in Gap Analyses and requirement gathering with the Business.
• Prepared the Analytical Functional Specification and detail Design documents within a team of data modeling, ERP and BI experts.
• Worked on customizing Procurement and Spent Analysis in Oracle BI Apps.
• Worked with PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Involved with development of Incremental ETL process with the ETL Team for enhancements to Facts/Dimensions.
• Involved in RPD development for new Reports and Dashboards from the scratch.
• Created Analytics Repository by importing required objects into Physical Layer using connection pool, developing multiple dimensions (drill down hierarchies), and logical objects. Created Level based Measures and Aggregate navigation in BMM layer and created presentation catalogs in Presentation Layer.
• Implemented and resolved MS-Office Excel plug in issue for OBIEE.
• Developed Daily Snap Shot OBIEE Report and implemented IBot’s for Business users.
• Worked extensively with ERP personals, ETL Developers in building and customizing OBIA reports.
• 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.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers to achieve performance optimization and easy navigation of reports.
• Experience in working in a data warehouse environment, including data design, data integration, database architecture, metadata, reporting and application tuning at the Operational, Tactical and Strategic levels.
• Created SQL programs to convert data, based on the business requirements.
• Modified / Customized OTB mappings for Activity contact, Call Contact and Syndicated Data.
• Created new mapping for Extension and Bridge tables for OTB Call contact and syndicated data.
• Involved in daily production Support and customizing the Source Qualifiers to resolve the issue.
• Scheduling daily loads using Informatica Workflow manager and monitoring them on Workflow Monitor.
• Worked with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.
• Scheduling daily loads and maintaining daily and archived data.

Environment: OBIEE 10.1.3, Oracle 10g, Oracle Business Intelligence Applications 7.9.5, Informatica PowerCenter 8. 1, Microsoft Active Directory, SQL Server.

Confidential, Herndon,VA

OBIEE Developer

• Implementation of Logistics Analytics system that is used by all Executive Members to the Drivers to keep track of their scores for each metric they are responsible.
• Interviewed Stake-Holders to get a better understanding of client business processes.
• Gathered Business Requirements and documented them unambiguously as Business Requirements, Functional Requirements and User Requirements Documents.
• Designed and Developed Logistics custom business intelligence solutions (Metadata and Dashboards/Reports) using Siebel Analytics platform.
• Developed the Logistics Analytics Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions & time series functions, Presentation layer with catalogs & folders and external table security.
• Using Siebel Analytics Administration tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Logistics Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle materialized views.
• Involved in developing Informatica Mappings & Mapplets during enhancements.

Environment : Siebel Analytics 7.x, Informatica PowerCenter 6, Oracle 9i/10g.