Certified Oracle OBIEE 11G Consultant
8+ years of IT experience including expertise in Requirements Gathering, Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications.
Extensive experience in using ODI 18.104.22.168/22.214.171.124.x/126.96.36.199 tool for implementation of ELT methodology in Data Extraction, Loading and Transformation.
Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ELT processes and providing data mining features for data warehouses.
Extensive experience on creating BI reports in different subject areas, critical analysis and upgrade of the existing reports.
Hands-on experience in using BI reporting tools like Oracle Business Intelligence Enterprise Edition (OBIEE) 188.8.131.52/184.108.40.206.0/10.1.3.4, Siebel Analytics 7.7/8, Oracle BI Publisher.
Configured OBIA 220.127.116.11.1 HR Analytics, Financial Analytics, Sales & Marketing Analytics, and Supply chain, Retail and Procurement & Spend Analytics, Pharma Analytics.
Involved in the OBIA 18.104.22.168.1 to OBIA 22.214.171.124.1 upgrade and tested ODI ETL objects and OBIEE reports
Created Proof of Concept on OBIEE 126.96.36.199 and provided demo on the advanced features including Geospatial Reports in OBIEE
Possess clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL/ELT and life cycle development Using Oracle Data Integrator (Repository Manager, Designer, Load Plan Generator and Operator).
Worked on Slowly Changing Dimensions (SCD’s) and its implementation to keep track of historical data.
Actively involved in Performance Tuning, Error handling and production support for various projects.
Experienced in coding using SQL, SQL * plus, PL/SQL procedures/functions, triggers and exceptions and have good exposure to Relational Database concepts, Entity relation diagrams.
Implemented different Caching techniques to improve the performance of BI server.
Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica power center.
Experienced in troubleshooting installation issues, production issues and production support for projects.
Experienced in analyzing the needs of the user and creating new BI reports according to the user requirement in OBIEE.
Experience in creating executive reports with BI Publisher integrated with OBIEE.
Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
Very good in Debugging, Optimizing the Analytics Dashboards/ Reports and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.
Extensive experience in building Interactive Dashboards with drill-down, drill-across capabilities using global, local Filters, Guided Navigation, Business rules, selection steps, prompts, etc
Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
Experience in UNIX working environment, writing UNIX shell scripts for ODI pre & post session operations.
Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.
Microsoft Windows 7/Vista/XP/2000/NT, UNIX
SQL, PL/SQL, XML, UNIX Shell Scripting
Oracle 12c/11g/10g/9i/8i RAC, SQL Server, DB2 z/OS
Tools & Utilities
PLSQL Developer, TOAD, SQL Developer, Erwin, Microsoft Visio, Talend 5.3.1
OBIEE 10g/11g/188.8.131.52, BI Publisher 10g/11g, EBS Financial
ODI 184.108.40.206/220.127.116.11/18.104.22.168/10.1.3.5 (Repository Manager, Topology manager, Designer, Operator, Load Plan Generator and ODI Server)
Crystal Reports, Tableau
OBIEE, EPM 22.214.171.124, IBM Cognos
Control-M, AutoSys, Active Batch 7, ESP Scheduler
Client : Exterran
Role : Sr. OBIA Consultant (OBIEE/ODI Developer)
Location : Houston, TX
Duration : Apr 2014 - Present
ODI 126.96.36.199/188.8.131.52.x (Repository Manager, Designer, Load Plan Generator, and Operator), OBIEE 184.108.40.206/220.127.116.11.0, OBIA 18.104.22.168.1/22.214.171.124.1, Oracle 12c/11g, SQL Developer 4.x, Toad 10.x, PLSQL, SQL
Responsibilities: (Enhancements and Prod Support)
Analyzed business requirements of the project and wrote technical specs for the implementation.
Analyzed the user requirements and created BI reports in different subject areas.
Performed the source to target domain configurations in OBI Apps 126.96.36.199.1/188.8.131.52.1 Financial Analytics and implemented GL, AP and AR modules in OBI Apps by extracting data from Oracle EBS 12.1.3.
Involved in the Installation of OBIEE 11g (BI Administration Tool, Oracle BI Enterprise Manager, Weblogic server and BI Publisher) in Linux environments.
Used OOTB RPD and created new measures, calculated items and calculated groups.
Worked on RPD Development, Oracle BI Administration, Oracle BI Answers and Agents.
Created Logical Tables, Logical Columns and calculated measures and metrics as per the business need.
Created complex requirements like Dimension hierarchies, time comparisons and share measures along with ranks.
Developed Month Ago, Year Ago Measures for Comparison of Facts and Used Time Series Functions and To Date Functions Extensively.
Developed new Balance sheet, income statements, AP aging and AR aging reports and dashboards, etc as per business requirements.
Implemented Oracle BI security at the data and object levels and utilized variables and initialization blocks in the repository.
Utilized BI Delivers for sending real-time, personalized alerts via intelligence agents (IBots) to intelligence dashboards for subscribed users.
Created operational reports with BI Publisher integrated with OBIEE.
Created variables in OBIEE for use with reporting - Repository Variables, Session Variables, Presentation Variables and Initialization blocks.
Managed and provided permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
Created multiple data sets in the data model for BI Publisher reports and grouped them, linked them and put them into the hierarchies needed to the establish the groups in XML as needed in the report template.
Used group functions like aggregate, count, sum, etc and created separate measures within the data model and used the group variables in the reports
Developed report templates in RTF and Excel and coded different groups of the same data in an organized fashion to enable the exact rendering of report requirements.
Used bursting feature to burst the report output to different roles/users within the organization.
Used ODI 184.108.40.206.x designer and implemented knowledge modules like LKM, IKM, CKM, RKM and JKM when needed.
Created complex Interfaces and implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3) for data loads.
Created Interfaces to implement one time as well as Incremental loads.
Used Interface Variables, Interface Parameters and Session Parameters to increase the re-usability of the Interfaces.
Implemented performance tuning logic on targets, sources, interfaces, sessions to provide maximum efficiency and performance.
Used ODI knowledge modules to implement SCD logic and Update logic.
Developed load plans using Load Plan Generator and monitored the results using ODI Operator.
Client : IBM
Role : OBIEE/ODI Developer
Location : Overland Park, KS
Duration : Aug 2013 – Mar 2014
ODI 220.127.116.11.x(Topology manager, Repository Manager, Designer, Load Plan Generator, and Operator), Oracle 11g, OBIEE 18.104.22.168.x, PLSQL Developer, SQL, PLSQL.
Functional Areas: This solution involved OBI Apps 22.214.171.124.1 using ODI 11g and OBIEE 126.96.36.199.x
Gathered requirements from the customer, designed the technical specs and technical documentation, developed Interfaces and Workflows as per the business requirement, tested the application and deployed it to production.
Built the Interfaces with ODI 11g Designer using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored procedures.
Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads and Data Transformations.
Worked with the OBIA Financial Analytics Suite using OBIEE 188.8.131.52.x and customized the dashboards and metrics for reporting.
Conducted data investigations and assisted the business partners with complex data analysis and ad-hoc queries
Designed, documented and tested logical and physical data models optimized for operational and analytical reporting
Created Income Statements and Balance Sheet reports from GL, Top 10 supplier and Invoice reports from AP, Aging Reports from AR.
Used BI Publisher and created complex pivot table reports and cross tabular reports using connected queries of data models with parameters passed from data model as well as parameters.
Performed the changes to the physical layer, Business Model and Mapping Layer and Presentation Layer in an OBIEE Repository for all new objects that needed to be added.
Started/Stopped BI and Weblogic Servers using OPMNCTL commands and also start/stop shell script.
Performed security administration for the entire organization, mapping Peoplesoft roles and LDAP configuration and Weblogic roles.
Used various templates in BI Publisher to publish the reports as per user requirements.
Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
Performed tuning on OBI Apps system by creating materialized views and using partitioning, compression and aggregation techniques with a combination of bitmap indexes and gathering statistics.
Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.
Presented demo sessions of the BI tool in many offsite locations of the client and won appreciation from the executive teams.
Reconciled the data in the reports to tie numbers back to PeopleSoft which was the system of record.
Conducted thorough Unit Testing, System Integration testing, UAT, MTP and Production Support Co-ordination effectively.
Effectively communicated and collaborated with cross-functional business partners and made them love the flexibility the OBIEE tool has to offer.
Used PLSQL Developer for running SQL queries.
Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
Performed extraction, Loading and Transformation of data from RDBMS tables and Flat File sources into Oracle 11g in accordance with requirements and specifications
Responsible for creating interfaces, procedures, packages and load plans using ODI and monitored the workflow run and statistic properties on ODI Operator.
Involved in Performance tuning for sources, targets, interfaces and sessions.
Client : Seattle Children's Hospital
Role : OBIEE Developer
Location : Seattle, WA
Duration : Jun 2012 - Jul 2013
OBIEE 184.108.40.206, OBIEE 220.127.116.11, Informatica 9.5.1, Linux, Oracle 11g, SQL
Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Mart.
Worked on oracle 11g database, used 11g's usage tracking to keep updated of all the ongoing processes.
Analyze, Design, and Develop OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer
Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, and Security using External Table Authentication, Session Variables, and Initialization Blocks.
Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
Trouble shooting the issues related to repository models and report development.
Developed process and business rules around setting up new users (Logins, Responsibilities and Positions etc)
Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
Administered the Cache parameters and implementing the cache feature for improving the BI Server performance Create users and groups and assigning the security privileges
Client : PNC Bank
Role : Informatica/OBIEE Consultant
Location : Pittsburgh, PA
Duration : Feb 2010 – May 2012
Informatica Power Center 8.1.1(Power Center Repository Manager, Designer, Workflow Manager, and monitor), Power Exchange, Erwin, Oracle 10g, Windows NT, Flat files, Sybase, SQL, PL/SQL, SQL*Loader, Cognos 7, Autosys, UNIX, UNIX Shell Scripts
Worked on Informatica - Source Analyzer, workflow designer, mapping designer & Mapplet and Transformations.
Developed ETL mappings to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ELT procedures using ODI Power Center.
Implemented logical and physical data modeling with STAR schema techniques in Data Mart.
Performance tuning of ODI sessions for large data files has been done by increasing block size, data cache size and, sequence buffer length.
Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
Used Informatica Power Center Workflow monitor for session management, database connection management and scheduling of jobs to be run in the batch process.
Responsible for the definition, development and testing of the processes/programs necessary to extract data from the client's operational databases, Transform and cleanse the data, and Load it into the data marts.
Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
Implementation of SCD type1/type2/type3 in existing ETL interfaces for capturing slowly changing dimensions.
Performed planning and execution of large data conversion.
Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion interface.
Customization of the Oracle out of the Box ETL interfaces using ODI for extracting various data from OLTP systems.
Implemented Change data capture and incremental logics in inventory ETL mappings by identifying the audit columns for the data.
Performed extraction, Loading and Transformation of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
Worked with Business analysts and the DBA for gathering requirements and for project coordination
Creating and modifying Business Intelligence requests using Oracle Business Intelligence Answers.
Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
Worked as a member of architect team in reviewing the code developed by different teams.
Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using Agents.
Performing administrative tasks related to the development and configuration of Interactive Dashboards
Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data interface (create Logical tables & data source interface) and Presentation Layer level (create presentation catalogs.), test and validate the model
Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using LDAP Authentication to setup groups, access and query privileges
Client : Toshiba
Role : OBIEE/ETL Consultant
Location : Wayne, NJ
Duration : Jun 2008 - Jan 2010
Informatica 8.1.1, Informatica Power Exchange, Business Process Modelling (BPM), SAP R/3 7.1, Oracle 9i, Mainframe, DB2, Flat files, TOAD, Visio, PL/SQL, SQL, UNIX (AIX), Unix Shell Scripting, Windows XP
Responsible for developing Complex Informatica interfaces using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
Responsible for Defining Interface parameters and variables and Session parameters according to the requirements and performance related issues.
Responsible for creating Workflows and sessions using Informatica workflow manager and monitoring the workflow run and statistic properties on workflow monitor.
Responsible for Unit and Regression testing of the Informatica mappings created according to the business requirements.
Used Version control provided by Informatica on each and every object used. In this way, each and every version of the process will be available for recovery or research purposes.
As an ODI consultant streamlined and tuned accounting related ETL to be more efficient using Teradata.
Migrated data from existing Teradata and other legacy systems.
Using of SQL tools like TOAD to run SQL queries to validate the data.
Assisted in Designing database solutions to meet both business and technical requirements.
Developed Unix Scripts for updating the control table.
Responsible for providing first level operational support for development and production database systems
Participated in complete life cycle of the project from project initiation to development and maintenance.
Customized the Siebel Analytics/OBIEE repository (Physical Layer, BMM and Presentation Layer).
Modified Presentation layer to add presentation tables and defined joins in the physical layer of the repository.
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.
Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.
Created materialized views and aggregates to improve performance.
Customized reporting with OBIEE Answers and integrated them into the Dashboards.
Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
Created user level security for intelligence dashboards based on Business Requirement.
Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
Created Dashboards with Dashboard prompts, Charts, Pivot tables.
Performed Data Validation of data in the reports and dashboards.
Created iBots to send pre-processed reports using OBIEE Delivers.
Client : Edven Soft
Role : SQL Developer
Location : Hyderabad, India
Duration : June 2007 - May 2008
OBIEE 10.1.3.2, Informatica 8.1, Oracle 9i/10G, TOAD, PL/SQL
Attended training classes in OBIEE and Informatica.
Extensively involved in T-SQL programming on Microsoft SQL Server 2005 database engine.
Provide database design support for new system development set standards for object names and usage.
Worked with SQL stored Procedures, Functions, Triggers & Packages in SQL Server.
Used TOAD as an Oracle developer tool.
Proficient in using SSIS to transfer data from Operating System Flat files to the MS SQL Server database.
Extensively worked on database cursors in MS SQL Server database.
Developed triggers with conditional predicates to restrict data manipulation events to certain business hours.
Responsible for enhancements development performance tuning trouble-shooting debugging & independent unit-testing.
Tuning SQL queries & use of range/list partitioning and materialized views.
EDUCATION: Bachelors in Engineering, India