Summary

• Over 7 years of IT experience in all phases of Software Development Life Cycle and having comprehensive background in End-to-End implementation of Business Intelligence using Oracle Business Intelligence OBIEE/OBIA , Informatica and ODI.
• Experience in Business Requirement Analysis, Application Design, Data Modeling, Development, Reporting and Testing.
• Expertise in OBIEE 11g/10.1.3.3/10.1.3.2, Answers, Dashboards, Delivers, BI Publisher and Data Modeling tools.
• Good business knowledge on Logistics, Financial, Telecom, and Pharma domains.
• Expertise in gathering requirements and making them as Functional MD050 and Technical MD070 Specifications.
• Experience in creating Architecture Flow Diagrams, Report flow and BPA Flow Diagrams.
• Extensive experience in repository Physical, Business Model and Mapping and Presentation layers development/customization and in data/object level Security and performance tuning using Oracle BI Administration tool.
• Experience with configured metadata objects Subject Area, Table, and Column and web catalog objects Dashboards, Pages, Folders, Reports .
• Experience with OBIEE Installation on Windows environment and configuration.
• Extensive experience in building Interactive Dashboards with drill-down drill-across capabilities using global local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity Roles, Profiles Personalization.
• Experience with implementing Single Sign on SSO using LDAP services.
• Implementation of data level security for both position and geo based security for different user groups.
• Experience in the extraction, transformation and loading of data from multiple sources into a Data Warehouse using Informatica/ODI.
• Designed mappings using lookup, aggregator, joiner, router and stored procedure transformations.
• In depth knowledge on Data Mapping, Data Conversion, and Data Cleansing.
• Experience in working with different operating systems like UNIX and Windows.
• Involved in Unit Testing, Integration Testing and User Acceptance Testing.
• Experience in Developing Oracle Procedures, functions, packages and Triggers for enforcing the business rules using PL/SQL.
• Performed Unit testing and coordinated with Business users and testing teams for User Acceptance Tests UAT .
• Excellent communication, interpersonal, intuitive and analytical skills.

Projects

Confidential

Sr. BI Developer

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirement.
• Created technical specification for OBIEE report requirements based on the use case.
• Documented the reports layout and created mock up reports for business review and approval.
• Created dashboards for review by the business users. Incorporated their feedback and updated the report designs.
• Identified missing data elements and worked with the ETL team.
• Created connection pools, imported physical tables and defined joins in the physical and BM M layers of the repository.
• Designed and configured logical star schemas and level based hierarchies by using Essbase and oracle Data sources.
• Worked on dimension hierarchies, aggregates, and logical keys in the BMM layer.
• Implemented AD Authentication, object and data level security using session and dynamic variables and groups
• Setup Multi-user environment MUDE for other developers to work
• Configure the repository, Web catalogue and setup access rights to power users for ad-hoc reporting needs
• Developed and Designed OBIEE Analytics Metadata repository RPD by using GL and Sales cubes.
• Created and managed OBIEE dashboards such as AR, AP, GL, and GSR.
• Performed Unit and system testing for all components. Test cases were prepared and results documented.
• Migrated repository and web catalogue to QA, UAT and production environments
• Troubleshoot/resolve issues and maintain the development, QA, UAT and Production environments

Environment:

Windows, OBIEE 11g, Hyperion, Essbase, Smart view, ODI 11g, Toad, Sales Logic, Kronos, Oracle R12 and Jira

Confidential

OBIEE Tec Lead

• Performed Gap Analysis to aid the requirement spec and documented the reports layout and report mock ups for business approval.
• Developed conceptual, logical and physical Dimensional model to accommodate the MMC HR data and Subject Area design doc for client review and approval.
• Involved in ETL design document with Source to Target mappings.
• Configured the physical layer, business model and presentation layer for the MMC requirements.
• Implemented AD Authentication, object and data level security using session and dynamic variables and groups
• Setup Multi-user environment MUDE for other developers to work
• Developed reports and dashboards as per the business requirements.
• Implemented data level security using session and dynamic variables and groups.
• Optimizing the performance by query analysis, aggregation tables, fine tuning the repository, cache seeding.
• Configured the physical layer, business model and presentation layer to customize the HR analytics requirements
• Configured supervisor - employee and position hierarchies.
• Enabled HR dashboards, analysed and configured filters as per the requirement.
• Used BI Publisher with OBI Presentation Services and BI server to develop pixel perfect reports and configured the reports with new templates, parameters and LOV for top level executives.
• Created migration document for migrating code from development to test, pre-prod and prod environments.

Environment:

OBIEE 11g, BI Applications 7.9.4, ODI 11g

Oracle, Toad, Informatica, DAC, Kronos, Taleo and PeopleSoft

Confidential

OBIEE Tec Lead

Responsibilities:

• Requirements gathering, analysing the Functional and Technical specifications.
• Created Functional, Technical specifications and use cases for new CTMS Reports.
• Created Mock-up reports, Process and Architectural flow diagrams.
• Worked on setting the priority of incidents, Change requests by conducting sessions with User groups by providing the technical support.
• Worked on Report enhancements.
• Work closely with business users to ensure completeness of requirements.
• Designed Star-Schema using Facts, Dimensions and Alias tables to bring new required columns in to Reports.
• Worked on OBIEE Repository Changes Physical, BMM, and Presentation layers .
• Worked on repository variables and session variables.
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer.
• Developed Reports, Dashboards by implementing different Analytics Views
• Created new mappings in Informatica to pull CTMS data in to warehouse.
• Created new Tasks and included in subject area and in DAC Execution plans.
• Configured BI Publisher for DEV/TEST/PROD Environments
• Closely worked with Siebel team in understanding Siebel CTMS Data model.
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer.
• Implemented Data Level security to restrict users to see only their region /Site level Data.
• Worked closely with offshore team and lead them during the Support phase of the project.

Environment:

OBIEE 10g, BI Publisher 10g, Siebel CRM 8.0, SAP, Informatica, DAC, Argus and Jira

Confidential

OBIEE Consultant /Business Analyst

Responsibilities:

• Coordinate and lead business requirements gathering meetings with Executive Management and Business users of the company.
• Translate business requirements into easily understood reporting / analytical requirements and create functional Technical specification documents.
• Develop reports to support data analysis needs of business users within the company, including both ad-hoc and pre-defined reports.
• Created Architecture diagrams, BPA Flow and MDM/ Salesforce Veeva system documentation that can be understood and used by Business users and IT.
• Implemented cache management to optimize the performance.
• Built OBIEE Repository Physical, BMM, and Presentation layers .
• Worked with repository and session variables.
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer.
• Developed Reports/Dashboards by implementing different Analytics Views Drill-Down/Dynamic, Cascading Style Sheets, Pivot Table, Chart, and Column Selector.
• Created complete RPD documentation and migrated changes to Production environment.
• Configured iBots in order to deliver the reports based on Schedule and automated iBot queries to deliver at scheduled timings.
• Conducted user training to familiarize users to the new reporting environment.
• Configure and Create US Map to show State Level Sales Information.
• Change Style sheets to show Icons in place of HTML Links.
• Migrated Usage Tracking, Logo Changes from development to Test Environment
• Create Vertical Dashboard with Links for Demo.
• Worked for the migration of Repository Web Catalogs from Development to Test Production server.

Environment:

OBIEE 11g, ODI, MDM, Sales force Veeva, Argus and Oracle.

Confidential

Sr. OBIEE Consultant/Business Analyst

Responsibilities:

• Requirement analysis gathering, analyzing the Functional and Technical specifications.
• Work closely with business users to ensure completeness of requirements
• Prepared MD50 and MD70 documents for the new functional requirements.
• Worked on the BI publisher reports. Created mock reports as per user requirements.
• Developed liaison with the Business to translate Business issues into IT solutions.
• Created Ad-hoc reports and dashboard as per requirements.
• Worked on the design of Operational reports which included AR, AP, Capture Order, Shipment Billing, CVN, Cross dock, Route Assign, Move Freight, Claims, BOX, Service Provider Driver Equipment process areas.
• Interacted with the business users to understand the conversion and data migration requirements.
• Conversion process included data from Legacy systems into Siebel, OTM, and EBS.
• Part of Converting Accessorial for SCM and BULK Line of Business into EBS Invoice to Locations from Legacy into Siebel, EBS Customer Rate Contracts from Flat files into Rate Server Tendering and Liable Party, Location Contacts from Legacy into Siebel, OTM Portal User Access from Legacy into Siebel.
• Worked on Data mappings between Source and Target systems and also on field definitions for the Target systems.
• Worked closely with offshore team and lead them during the Design phase of the project.

Environment:

OBIEE 10.1.3.3/4, BI Publisher 10g, OTM, Oracle EBS R 12, Siebel CRM, ODI, PL/SQL, UNIX.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Participated in Requirement Gathering of the various work streams by meeting with the business user and base lining the details to identify appropriate tables.
• Implemented OBIEE 10.1.3.4.1 with all the required upgrade and updates for Development, SIT, UAT and Production.
• Designed metadata repository using OLTP tables.
• Integrated BI Publisher with OBIEE and created different BI Publisher templates using Microsoft Word Plug-in.
• Implemented multiple logical conditions in a single RTF template.
• Implemented Multi User Development in Dev and QA.
• Implemented cache management to optimize the performance.
• Performed Scheduler configuration.
• Trained Business Users/Power Users on how to create reports in Analytics Answers and instructed them in best practices for managing and sharing reports
• Documented and reviewed all the validation report documents for the entire dashboards.

Environment:

OBIEE 10.1.3.3/10.1.3.4, Oracle10g, Quest Toad, Windows, UNIX

Confidential

Role : OBIEE Developer

Responsibilities:

• Gathered Business requirements by interacting with the Business Analysts and the business users and created reports
• Worked with the Business Analyst to prepare Functional Design and Technical Design.
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer.
• Worked on repository variables and session variables.
• Used BI Publisher to create pixel perfect reports to satisfy user requirements.
• Modified the InstanceConfig.Xml in order to configure the maximum number of rows requires on the report.
• Enforced Row Level Security for Managers to View the Reports pertaining to their Region.
• Used the security settings in BI Admin tool to setup users, Groups and Access privileges.
• Performed SQL Tuning to improve the SQLs performance.
• Created materialized views and aggregates to improve performance.
• Migrated OBIEE .rpd and Web Catalog objects from Development environment to QA, UAT environments and then to the Production environment.
• Conducted user training to familiarize users to the new reporting environment.
• Participated in Production Support and resolved problems that occurred during this phase.

Environment:

OBIEE 10.1.3.3/4, Siebel OLTP 7.7, Informatica 8.1, Oracle, SQL Developer, Erwin, Windows

Confidential

Employer: i2t2

Responsibilities:

• Created customized reports using Siebel Answers from the existing Subjects Areas incorporated Global Prompts Filters.
• Configured Repository, Session variables to generate dynamic reports. Tested validated repository using Siebel Analytics ODBC Client Tool.
• Created Logical dimensions, Aggregates Hierarchies/levels using Analytics Admin Tool.
• Created Proactive Alerts /iBots using Siebel Delivers delivered using Scheduler services.
• Created users, groups using Web Admin Tool assigned different dashboards permissions as per data visibility rules defined by the client.

Environment:

Siebel Analytics 7.8, Oracle9i, Toad