SUMMARY:

• Having 9+ years of strong experience in Complete Software development Life cycle, which includes Business Requirements Gathering, System Analysis & Design, Data Modeling, Development, Testing and Implementation of Data Warehouse and Business Intelligence Applications.
• More than 8 years of experience in complete suite of Oracle Business Intelligence Enterprise Edition OBIEE.
• Elicitation and gathering of business and system requirements, analyzing the business processes and identifying the KBQs related to reporting and converting the requirements to BRDs and FSDs and project a plan for rolling out the deliverables.
• Excellent Team Management Skills with good business acumen, effective communicator, good team mentoring and training skills, experience in working with Business Users, Controllers, Directors, Senior Managers, Executives, Department Heads .
• Excellent problem solving skills with strong technical background and good inter - personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Good experience of Data integration using ETL tools Oracle Warehouse builder(OWB), ODI, Informatica Power Center.
• Strong understanding of Transactional and Dimensional Data Modeling, Data Warehousing Concepts, and Designing Star & Snowflake Schemas for OLAP Systems
• Expertise in developing OBIEE repository with Physical, Logical and Presentation layers build reports/dashboards from the repository using OBIEE Answers and troubleshoot various technical issues and bugs.
• Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns
• Oracle BI Scheduler Configuration for Alerts / iBots.
• Expertise in OBIEE features (Clustering, Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/ initialization Blocks configuration)
• Assisted in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling using Workflow Manager
• Experienced in performing end to end testing, creating Test Plans including Data Validation, Unit Testing and User Acceptance.

TECHNICAL SKILLS:

Business Intelligence Tools: OBIEE Suite (12c/11g/10g), Oracle Application Express, Oracle Warehouse Builder(OWB), Informatica, MS Excel, Microsoft One Note, MS Project, Visio, Lucid Charts

Project Management tools: Smart tasks, MS project, JIRA, BMC Remedy, Confluence

Databases: Oracle 10g/11g, SQL Server, MS Access, DB2

Languages: C, C++, SQL, PL/SQL, Java, HTML, XML, VB, UML

Operating Systems: Windows, MS DOS

SQL Tools: SQL Developer, TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, Palo Alto CA.

Lead Business Intelligence Business Analyst

Responsibilities:

• Lead the RFP process from feasibility analysis to creating the requirements and posting it to elicit a response as formal bids from a shortlisted set of vendors. Walkthrough with the management on decision making by organizing in-person demos and Q&A sessions, creating an evaluation criteria matrix on which the proposals were assessed thereby resulting in an SOW with the procurement.
• Lead the elicitation and gathering of business and system requirements, scope and define requirements for new functionality including review of existing applications and business processes.
• Able to bridge functional and technical resources by communicating effectively with individuals of varying systems expertise and business needs.
• Collaborate with application developers, end users, vendors, and management to ensure the creation and delivery of business intelligence solutions. Facilitate working sessions with central and distributed end users and management to identify and document current information flows, data models, reporting systems, user populations, and coordinate with current and future initiatives impacting reporting.
• Analyzed the legacy reporting solutions and use cases that are driving the shadow systems and documented them for accountability when designing the new environment.
• Created a BIRD(Business Intelligence Requirements Document) to list the business processes related to reporting and a set of 15-20 key business questions per subject area that support these processes and a list of requirement in the form of user stories that tie back to the KBQs.
• Created VHLD and conceptual diagrams to identify the major entities and the relationships.
• Created the Business Process Taxonomy and contributed to the design and data for shared documentation that correlates across these business units using Confluence and Box.
• Tracked the user stories using JIRA, Project components using Smart tasks and helped with the project plan and decision logs using MS Visio and One note.
• Identified User Groups and their hierarchy for championing the change management and workshops.

Confidential, Concord CA.

Application Developer/ BI Analyst

Responsibilities:

• Responsible for providing third level support and worked on enhancements for RMDW as part of a small support team.
• Work directly with end users to troubleshoot and fix issues.
• Primary role in the upgrade and migration of the entire OBIEE 10g platform (with all the objects) to OBIEE 11.1.7.0 and configurations.
• Extensive use of iBots to deliver time sensitive information about Gate logs and Time sheet reporting to refinery management to aid in billing.
• Implemented a writeback solution on OBIEE to facilitate random vendor code updates.
• Elicit requirements using various channels of collaboration including virtual and onsite meetings.
• Organize, translate, and simplify business requirements and document business processes with recommendations on integrating people, technology, and data for optimum results
• Manage the assignment and delivery of tasks to a 15+ Site Representative working team across 8 refineries
• Work directly with all stakeholders, which include resources of varying levels of leadership, to define business process and system requirements, identify areas of change, propose key opportunities of improvement, training documentation and curriculum design.
• Worked on Aggregate models for the existing rpd design to improve performance.
• Built Reports and Dashboards for Business cases and created intuitive drilldowns.
• Created reports using templates as used by the organization using BI Publisher and scheduled the delivery on a bi-monthly basis.
• Periodical meetings with the CAB to resolve design and development issues and prioritize work.

Confidential

OBIEE Developer

Responsibilities:

• Worked on Aggregate models for the existing rpd design
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / Oracle BI Presentation Services.

Confidential

OBIEE Developer/ Analyst

Responsibilities:

• Working for many BIAC projects in different phases (Requirement Analysis, Architecture, Design, Development, and Testing) wearing different hats.
• Setup Usage Tracking on OBIEE 10g.
• Gather requirements and build technical and design specifications.
• Design and develop repositories by importing physical layer object and creating necessary complex joins and created corresponding presentation layer objects.
• Built Reports and Dashboards for Business Users, created intuitive drilldowns
• Created reports using templates as used by the organization using BI Publisher.
• Periodical meetings with the client to resolve design and development issues.
• Production support by making requested changes to the existing design after a CR.
• Responsible for creating KPI dashboard using the metrics provided by the client using BI dashboard design best practices.
• Developed many Reports or Dashboards with different Analytics Views Drill-Down and Dynamic, Narrative View, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters
• Used HTML and Java script to produce hover over and access to the Apex pages and other dashboards with the user credentials embedded in the Go URLs.
• Implemented Dynamic dashboard prompts to zoom into different segments, to achieve performance optimization and easy navigation of 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.
• Performed debugs and fixes to suit the business user needs.
• Created customized documentation for the project’s OBI section of Application Owners Guide including the steps with Installation of OBIEE 10g.
• Followed Agile methodology.
• Performed Unit testing and worked with the end user at various stages of the test cycles. Involved in UAT and post production support.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.
• Actively participated in the OBIEE 11g upgrade. Fixed many issues with the upgraded 11g dashboard reports and graphs.

Environment: OBIEE 11g, OBIEE 10.1.3.4, BI Publisher, Oracle Application Express, Informatica Power Center 8.1.1, Oracle 10g, TOAD, Windows XP Professional, MS Excel, Microsoft One Note, MS Project, Visio

Confidential, Alpharetta, GA

BI Developer/Analyst

Responsibilities:

• Interacted with business representatives for gathering the Reports or Dashboards requirements and to define business and functional specifications.
• Performed GAP analysis to understand AS IS and TO BE System.
• Performed Data Analysis and Data Validation and created the logical data model.
• Analyzed data sources of legacy systems.
• Understand business requirements and translate the same into IT requirements
• Created prototype of the requirements and functional requirement documents.
• Interacted with database team to understand the Physical Schema and used Erwin to create Data models.
• Identified the required Facts, Dimensions, Levels or Hierarchies of Dimensional and referential joins
• Designed and developed OBIEE/Siebel Analytics RPD using OBIEE/Siebel Analytics Server Administrator tool by importing the required objects Dimensions and Facts into Physical Layer, Created the Logical model in the BMM Layer with Multiple drill down dimensions to support various business requirements and created the User friendly Subject Areas in Presentation Layer
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
• Developed many Reports or Dashboards with different Analytics Views Drill-Down and Dynamic, Narrative View, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters
• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports
• Implemented Security Groups and Roles using LDAP Authentication.
• Performed Unit Testing and worked with the end user at various stages of the test cycles.
• Written down all the test cases & the test scripts for the client as part of the QA Support.
• Involved in UAT and post production support
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIEE 10.1.3.4, Oracle BI Server, BI Answers, BI Administration, BI Dashboards, Informatica PowerCenter 8.1.1, Oracle 9i, TOAD, SQL Navigator, Web Logic 8X, Windows XP Professional.

Confidential, Houston, TX

OBI Analyst

Responsibilities:

• To analyze the specifications provided by the client, understanding the business.
• Prepared Business Requirement Document (BRD) and Functional Specification Documents (FSD) as per the Business requirements.
• Install, configure, and administer the OBIEE platform
• Involved in RPD Development, Oracle BI Server, Oracle BI Answers, DAC Configuration, ETL Configuration, and Oracle BI Publisher.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables.
• Extracted data from Various ERP Systems like Siebel OLAP database, Oracle E business Suite (EBS).
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters (Global & Local); provided customized prompts to avoid excessive data showing up in reports
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / Oracle BI Presentation Services.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
• Debugged reports and Dashboards visibility with respect to user‘s responsibility and web groups in an integrated environment.
• Involved in implementation of Pre built OBI analytics (Financial Management and Procurement Analytics)

  Used Analytics Web Catalog to set up groups, access privileges and query privileges.

• Used various transformations like Source qualifier, Aggregators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement.
• Worked for performance tuning by finding out the bottlenecks in various mappings.

  Trained and worked with the end-users in developing their own ad-hoc reports using OBIEE Answers.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Oracle BI Server, BI Answers, BI Administration, BI Dashboards, BI Scheduler, Oracle BI apps 7.9.5, Informatica 8.1, Oracle 10g, PL/SQL Windows XP Prof

Confidential, NJ

BI Developer/Analyst

Responsibilities:

• Developed Solution Designs and Detailed Design Documents based on Siebel Analytics Requirements and Business reviews.
• Configured Column & Dashboard Filters in Siebel Analytics Requirement validation of reports & drilldowns.
• Expert in Siebel Analytics Physical, Business and Presentation Layers.
• Extensively worked on physical, business and presentation layers
• Developed Assets, Opportunities, Entitlements, Partner Authorizations, Service Requests subject areas using Siebel Analytics/Answers.
• Expert in Siebel Analytics components - Clients, .RPD, Presentation Services, server, repository and data sources.
• Extensively worked on RPD, Webcat and Dashboards.
• Created logical tables and assigned levels and custom aggregation rules.
• Used Catalog manager to do work between folders.
• Developed Uploading process of the FEA and all data types, field sizes and formats.
• Worked on Siebel Analytics Administration tools - online and offline.
• Analyze the ETL procedures and developed mappings, mapplets, and using most of the transformations.
• Written SQL queried to test the OLTP & OLAP Databases based on changes of the functionality.
• Did ETL - Data Load Process “Full Load and Incremental Load” testing.
• Created logical tables and assigned levels and custom aggregation rules.
• Worked and used most of the Informatica Transformations in Mappings.
• Verified logical tables and validated levels and custom aggregation rules.

Environment: Siebel Call Center 7.7, Siebel Integrated Application 7.8.2, Test Director 7.6, Win XP Professional, Oracle 9i, Informatica 7.1.1 and MS Access, TOAD.

Confidential, IN

SIEBEL ANALYTICS Developer

Responsibilities:

• Participated in User Meetings to understand the requirements.
• Worked closely with the data modeler in creating logical data model (Star Schema).
• Built the Siebel Analytics repository/metadata (Physical Layer, Business Model and Mapping Layer and Presentation Layer) and created the subject area where reporting and analysis are centered around.
• Developed Calculated Measures and dimension hierarchies in the Business Model and Mapping Layer
• Configured Web Catalog Objects (Dashboards, Pages, Folders, Reports)
• Generated different kinds of reports using Siebel Answers and assigning them to application specific dashboards.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities based on organization’s and product’s hierarchies
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generated Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Assisted in creation of pivot table requests allowing manager’s to analyze business/data from different perspectives.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Environment: Siebel Analytics 7.8.5, Informatica Power Center 6.2 and Power Center 7.1.2,SQL Server 2000, SQL Query Analyzer, Windows 2000/2003

Confidential

ORACLE Developer

Responsibilities:

• Gathered the requirement from the client and translated the business design into Technical design.
• Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.
• Triggers, procedures and functions are developed in this reports using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Created user defined Exceptions while handling exceptions.
• Troubleshooting production problems and worked effectively with other team members to identify and address problem.

Environment: Oracle 8i, PL/SQL, SQL * PLUS, SQL * Loader, Windows 2000.