OBIEE / ODI Consultant Resume Profile

Experience Summary:

Around 8 years of Business Intelligence implementation experience using Oracle Business Intelligence BI , Siebel Analytics
Expertise in OBIEE 10g /11g configuring repository, creating Intelligent Dashboards / reports, Answers
Extensive experience in Oracle Analysis and BI Intelligent Dashboards with BI Analytics stand-alone/integrated implementation
Extensive expertise in OBIEE Repository Admin Tool, Analytics Web, Dashboard and Scheduler
Worked on OBI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services
Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the OBIEE platform Developed Metadata Repository .rpd with multiple business layers using complex joins, presentation catalogs with access validations and external table security repository and repository migration in BI Server
Expertise in developing all 3 layers of the Analytics Repository Physical Layer, Business Model Presentation Layer .
Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management
Experienced in configuring OBIEE Reports Dashboards, OBIEE Delivers, Narrative views, Maps
Experienced in laying roadmap for identifying BI Components based on client's requirement and Installing, Configuring Oracle BI components
Performed configuration of Oracle BI Processes, Data sources, Presentation services and Scheduler.
Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
Experience working with OBIA Supply Chain and Order Management Analytics for Great Dane Trailers a large manufacturing company based out of Chicago reputed in building trailers
Experience working with Deutsche Bank Ltd. with their cash-equity settlements systems, British Telecom Infosys with their telecom billing and order management systems and Clearline Group in General Ledger Analysis
Strong exposure to the domain of Capital Markets and Telecom
Thorough understanding of Business Process Analysis Engineering, Business Requirements gathering and documentation
Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Business Modeling
Proven ability to work as a technical lead, team player as well as an individual. Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.
Complete and thorough knowledge of testing delivery processes for the entire SDLC, Agile including version and change control and new build rollouts
Highly organized, detail-oriented professional with strong business and technical skills
Excellent analytical and problem solving skills
Excellent communication, gap analysis, negotiation and documentation skills
Experience working with cross-functional team

Technical Skills:

Programming and Scripting Language	Java, J2EE, SQL, PL/SQL
Database	RDBMS: Oracle10g/ 11g, Essbase, MS SQL Server 2008, MS Access MDBMS: ESSBASE 9/11
Business Intelligence / Reporting Technology	Oracle Business Intelligence Suite Enterprise Edition OBIEE 10g/ 11g , BI Apps, Informatica 9, Oracle Data Integrator ODI , OBIEE Maps, BI Publisher
Operating systems	Windows 2007/ 2008 64-bit
Tools	MS Office Suite MS Work, Excel, PowerPoint and VISIO
Project Management	HP Quality Center, Microsoft Office

Professional Experience:

Employer	Confidential
Period	Confidential
Designation	OBIEE / ODI Consultant
Description	Concert Tech Corporation is a professional Information Technology Service Company headquartered in Sterling, VA. It provides specialized solutions and services to address wide range of Business Initiatives. I am currently working on a project with Resolute Technologies/ Whitelight Group a consulting company specializing in JD Edwards implementation for Great Dane Trailers, a large manufacturing company headquartered in Chicago reputed for building trailers. Project involves building an Order Management and Supply Chain Analytics by souring data from transactional OLTP system and loading them to the Oracle Business Analytics Warehouse OBAW and creating user friendly Dashboards.
Role	Gather and Analyze requirements from the SME and Business Users Analyzing the OLTP Systems and the Oracle Business Analytics Warehouse and documenting the mapping for appropriate columns. Design and Implementation of OBIEE Repository, Dashboard/ Reports using the Oracle Business Intelligence Suite Enterprise Edition OBIEE platform 11.1.1.7.1 Creating sample reports as a proof of concept POC and presenting it to the Business Users Using Oracle Data Integrator ODI as an ETL tool to Extract, Load and Transform data from OLTP system to Oracle Business Analytics Warehouse OBAW Creating critical reports using BI Publisher Status Reporting to Project Management
Solution Environment	OBIA 7.9.6.4 Supply Chain and Order Management Analytics , OBIEE 11g, Oracle 11g, Windows 2008 Server 64-Bit , Oracle Data Integrator ODI , BI Publisher, Adobe Professional, JD Edwards
Domain	Manufacturing
Employer	Confidential
Period	Confidential
Designation	Consultant Business Intelligence
Role	Analysis and Requirement Gathering by meeting the business user and base lining the details Design and Implementation of OBIEE Repository, Dashboard/ Reports using the Oracle Business Intelligence Suite Enterprise Edition OBIEE platform 11.1.1.6/ 11.1.1.7 Built Business model and established relationships Foreign Keys Physical Logical between tables. Integrated data from various data-sources viz. Essbase, SQL Server, Oracle and generated high-level and detailed General Ledger, Journal Entry Reports for the Store Managers across the retail chain Developed Reports using different Views Pivot Table, Chart, and Column Selector , Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts Deployment of Repository and Dashboard Reports from TEST to PROD environments Created Fixed Asset and Maturity Reports using BI Publisher Providing Post Production Support Finding solutions for Process/ Report Optimization Created functional specification document Status Reporting to Directors and Managing Directors
Solution Environment	OBIEE 11g, Oracle 11g, Windows 2008 Server 64-Bit , Essbase, SQL Server
Domain	Retail
Employer	Confidential
Period	Confidential
Designation	Programmer Analyst Business Intelligence Consultant
Description	Sunpower Consulting is a consulting company headquartered in Elgin, Illinois. It provides specialized solutions and services to address wide range of Business Initiatives. I was part of their consulting group, which provided technology services mainly in the Business Intelligence Area to the clients of Sunpower Consulting.
Role	Design and implement custom-based Business Intelligence Solutions using Oracle Business Intelligence OBIEE / Informatica platform Utilize Entity framework to handle Object Relational mapping layer Create Unit Test Plan, Unit Test Cases and Unit Test management Reports.
Solution Environment	OBIEE 10g/11g, Informatica Power Center 9.0, Oracle 10g, Windows XP/2007 Server
Domain	Healthcare
Employer	Confidential
Period	Confidential
Designation	Programmer Analyst Database and Reporting
Description	Deutsche Bank AG is a global banking and financial services company with its headquartered in Frankfurt, Germany. It has a large presence in Europe, the Americas, Asia-Pacific and the emerging markets. In 2011, Deutsche Bank was the largest foreign exchange dealer in the world with a market share of around 22 percent. I was a part of the Euro-next technology team in Deutsche Bank who were primarily responsible for providing technology support to the cash-equity Portfolio Managers based out in US and Europe. My project was generation of automated reports for regular/ failed trades and settlements on a regular basis, many critical End of Day reports, storing and sourcing data from the data-warehouse for ad-hoc reports.
Role	Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details Designed and implemented custom Business Intelligence solutions Metadata and Dashboards/Reports using the Oracle Business Intelligence Suite Enterprise Edition OBIEE platform Worked extensively with Physical Layer, Business Layer and Presentation Layer, created numerous executive level reports. Dashboards were generated to provide insight into the financial data Created different types of Customized Reports Drilldown, Aggregation to meet user requirements. Built Business model and established relationships Foreign Keys Physical Logical between tables. Created business reports using Oracle BI Answers as per requirements. Involved in the detailed design of the reports/dashboards and data model Created backend SQL Queries, Stored Procedures, Functions, Triggers and Views using SQL PLUS and PL/SQL Participated in the installation and configuration of Oracle BI EE 11g in the windows environment Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository Enhance performance by creating Aggregate tables, Indexes and managing Cache. Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc. during production support Interaction with the QA Team and the Business Team referencing the defects found, finding the root cause Continually performed as a key contributor and leader displaying intellectual leadership on highly complex initiatives Conducted walkthroughs with the clients for the various business and technical matters Interacted with various third party vendors and business organizations to interface the system and make it work according to the requirements specified by the clients Conducted meetings with the client's project management team to negotiate and agree upon various project deliverables and baseline criteria Created functional specification and technical specification document Mentoring new team members in the team
Solution Environment	Oracle Business Intelligence Suite Enterprise Edition OBIEE 10g/ 11g , BI Apps, Oracle Database 10g/ 11g , Windows XP
Domain	Equity Markets
Employer	Confidential
Period	Confidential
Designation	Programmer Analyst Database and Reporting
Description	Infosys Limited is an Indian global technology services company headquartered in Bangalore, India. It specializes in business consulting, technology, engineering and outsourcing services to help clients in over 30 countries. I was a part of team who were responsible for developing and maintaining Order Renewal and Billing Confirmation applications for the department for the Wholesale/ Retail and Global customers of British Telecom, one of the largest telecommunications services companies in the world. I was mostly involved in Reporting, Database and Business Intelligence side of the team.
Role	Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design Designed and developed OBIEE Metadata repository .rpd that consisted of Physical layer, business model and Mapping layer Aggregates, Dimensions and time Series functions and presentation Layer Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins Created numerous executive level reports and Dashboards to provide insight into the HR reporting Developed many Reports using different Views Pivot Table, Chart, and Column Selector , Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts Extensively used Delivers and iBots for delivering personalized reports to users, the management and sales teams as per the business requirements. Worked extensively with dashboard prompts to filter dashboards and populate variables Implemented and introduced the Answers capability of OBIEE to the users. Created dimensional hierarchies, assigned levels and custom aggregation rules for each level, and configured cross-dimensional drill downs to get more detailed views of the data Implemented security by creating users web groups, setting up External Table, creating session variables and initialization blocks and associating catalog objects and Web modules with the created groups Created comprehensive and easy-to-understand Oracle Answers Dashboards User Guide, and provided intensive Training to business users. Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement Performed Regression testing for the reports generated in the earlier phases Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users Interaction with the Development team and the business team referencing the defects found and finding a root cause Providing Post Production Support Finding solutions for Process Optimization Conducted walkthroughs with the clients for the various business and technical matters Conducted and facilitated many joint requirements, planning and brainstorming sessions with the business to understand their needs for the future global expansion Worked as a SPOC for solving major critical issues
Solution Environment	Oracle Business Intelligence Suite Enterprise Edition OBIEE 10g/ 11g , BI Apps, Oracle Database 10g/ 11g , Windows XP
Domain	Telecom Billing and Order Management
Employer	Confidential
Period	Confidential
Designation	Junior Programmer
Description	NIIT Technologies Limited is a global information technology solutions organization, servicing customers in North America, Europe, Middle East, Asia and Australia. It offers services in Application Development and Maintenance, Managed Services, IP Asset or Platform Solutions, and Business Process Outsourcing to organizations in the Financial Services, Travel Transportation, Manufacturing/Distribution, Healthcare and Government sectors. My client was Reliance Broadband and Internet Services RBIS . We implemented and maintained a Data-mart used to analyze the usage metrics and also to measure performance of equipment's.
Role	Responsible for the conversion of Brio EIS/reports to Siebel Analytics Dashboards/Reports Designed and developed the repository model for RBIS with the necessary logic that involved creating the Physical layer, BMM layers with aggregates, dimensions time series objects, Presentation layers with catalogs folders and external table security with session variables using Siebel Analytics Admin tool and Brio reports for reference Developed many Reports / Dashboards with different Analytics Views Drill-Down Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global local Filters using Siebel Analytics Web Performed sanity check / data validation by comparing the Brio reports output with Siebel Analytics report
Solution Environment	Siebel Analytics 7.x, SQL PLUS 8.x/9.x

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship