OBIEE Consultant

Summary:

• Over 7 years of IT experience with 4+ years of experience in Siebel Analytics / OBIEE.
• Expert in development and analysis of data warehouse applications using Siebel Analytics 7.7/7.8.2/OBIEE 10.1.3.x/ OBIEE 11.1.1.x.
• Experienced in Full Systems Development Life-Cycle Implementation of Various Oracle/ETL /OBIEE Projects.
• Proven experience in implementing complete software life cycle involving various phases of design, development and implementation of Data Warehouses & Data marts with OLAP Tools.
• Created physical data models for Teradata, SQL Server and Oracle.
• Extensively used Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Experienced in Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Experience in Performance tuning of Dashboards/reports and made recommendations for changes to database by implementing the materialized views, partitions.
• Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools and DAC in Banking, Financial, Insurance and Sales & Marketing domains.
• Customized and configured OBIEE application using OBIEE Answers, OBIEE iBots, OBIEE Dashboards, BI Publisher and Administration Tool.
• Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
• Experience in developing Dimensional Hierarchies/New logical columns/Filters/Variables per business requirements.
• Extensive experience and knowledge in Siebel Design, Upgrading and Development including Business Modeling, Requirements Gathering, Analysis, Configuration, Testing, Administration and Deployment for Siebel Enterprise (Siebel CRM as Front End application).
• Worked on Informatica tool’s Source Analyzer, Target Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Expertise in complete SDLC of Analysis, Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts.
• Expertise in designing and developing the OBI/Siebel Analytics Metadata Repository (.rpd) using OBI/Siebel Analytics Server Admin tool.
• tuning of database and Oracle E-Business Suite .
• Extensive experience in Oracle 10g/9i/8i - design and developing stored procedures/packages, database triggers, cursors using SQL, PL/SQL (Oracle Certified Developer).
• Strong knowledge of SQL*Loader for extraction of data from legacy databases to Siebel interface tables.
• Proficient in creating and managing Dashboards, Reports and Answers
• Good team player with excellent communication, written and presentation skills with strong aptitude to learn new technologies.

Education Qualification:

• Bachelor of Engineering, Computer & Sciences Engineering.

Skill Set:
Oracle 8i, 9i, 10g, 11g, SQL Server 2000,2005, MS Access., C,C++, SQL, PL-SQL, Informatica (Power center 8.1/7.1/ 6.2), Oracle OLAP, Siebel Analytics 7.8.5/7.7.1, OBIEE 10.1.3.x/11.1.1.x,Hyperion 9.3.X SQL Loader, TOAD, SQL developer , Unix Shell Scripting, Java, JavaScript, HTML, XML, Windows 98/2000/XP/Vista, Unix.

Professional Experiences:

Confidential, Pittsburgh, PA [02/12 - till date]
Lead Oracle Business Intelligence Consultant

Confidential, more commonly known asU.S. Steel, is an integratedsteelproducer with major production operations in theUnited States,Canada, andCentral Europe. The company was the world\'s12th largest steel producer in 2010.

Hardware/Software:
Oracle 11g, OBIEE (11.1.1.6/10.1.3.4),Hyperion 9.3.3, BI Publisher, UNIX Shell Scripting, MS Excel, MS Visio, Toad 9.1
Responsibilities:

• Lead an OBIEE configuration team or development team, ensuring design, development and testing work is completed to standard and on time.
• Captured and documented Management Information/Business Intelligence requirements from clients, via interviews or workshops, ensuring suitable balance of business needs and delivery feasibility.
• Co-coordinating on-shore and off-shore OBIEE Development Teams.
• Involved in business meetings and working closely with the business analysts to gather user requirements and did thorough Data Analysis.
• Worked on migration, deployment and performance tuning of repositories.
• Developing and maintaining the corporate data model, identifying and documenting data sources, and maintaining the meta data repository
• Involved and worked on Full life-cycle OBIEE administration (Physical layer, BMM, Presentation layer) on versions 10 and 11g in a MUD environment.
• Participated in upgrading OBIEE 10g to OBIEE 11g .
• Developed many reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).
• Based on the requirements identified the scope of new data, confirming dimensions between new and existing Warehouse tables, Drill Downs and data security and developed the business requirement document.
• Identified granularity level of the data required for analysis that exactly meets the user reporting requirements.
• Developed many reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).
• Developed new dimensions, facts and aggregate tables.
• Worked on Physical, BMM and Presentation layer of the Oracle Business Intelligence Admin tool to create the physical and business model diagram and the logical hierarchies.
• Created logical tables and defined the complex joins for a business model.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance using the Security settings in Oracle Business Intelligence Administration Tool.
• Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.

Confidential, Pittsburgh, PA [06/11 - 02/12]
Sr. OBIEE Consultant

Confidential is one of the most recognized and the world\'s largest package delivery company and a leading global provider of specialized transportation and logistics services that manages the flow of goods and information worldwide.CPC project developed to ensure all pickup stops are consistently made within the customer window. Goal of CPC reporting system is to develop and maintain numerous reports to the Sales, Finance, Customer Services, and Marketing departments for ongoing and analysis purpose.

Hardware/Software:
Oracle 11g,Teradata 12, OBIEE (11.1.1.5/10.1.3.4), BI Publisher, UNIX Shell Scripting, MS Excel, Toad 9.1
Responsibilities:

• Was responsible for design, development and management of daily, weekly and monthly reports, extensively used OBIEE (10.1.1.5) for generating web based sales reports for various executive and management individuals.
• Extensively used Oracle Business Intelligence Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Used the Security settings in Oracle Business Intelligence Administration Tool to set up groups, access privileges and query privileges.
• Works in conjunction with System Administrators for migration, deployment and performance tuning of repositories.
• Developed many reports/dashboards with different analytic views(Pivot table, charts, Column selectors, view selectors)
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Performance tuning of Dashboards/reports and made recommendations for changes to database by implementing the materialized views, partitions.
• Performed unit, Integration and Regression testing of various Dashboards/ Reports and repository
• Worked Extensively on Oracle Business Intelligence Answers to create various reports like Formulary Report and Direct Sales Report etc. as per the client requirements.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down, Aggregation.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created iBots and Delivers to send Alert messages to subscribed users.
• Did configurations for OBIEE (Multi User Development MUD, Usage tracking , iBot(scheduling) , Security Model using LDAP authentication) and Bi Apps ( Roles , responsibilities , security model)
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Configured and administered existing subject areas and created new subject areas to include new Star Schema information.
• Scheduled reports to different channels using BI Publisher.
• Benefits and HR base tables with employee benefits enrollments and changes.
• Involved in extracting data and transforming the data before loading the data into target (warehouse) Oracle tables. The transformations include generating unique sequence numbers and aggregations for the star schema target tables.
• Worked extensively on dynamic cache with the connected Lookup transformations for the update strategy.
• Extensively used PL/SQL Procedures/Functions to build business rules.
• Scheduled Workflows & Sessions tasks comprising of different mappings in order to load data into Target database.
• Extensively used mapping parameters, mapping variables and parameter files..
• Implemented external table security with session variables, tested and validated the business model and
• Interacted with Up-stream Developers and DW Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made implementing the changes to VT Repository.

Confidential, Memphis, TN [09/09 - 04/11]
OBIEE/Informatica Consultant

Confidential is the area\'s leading choice for personal and business banking. First Tennessee, a part of the First Horizon National Corporation family of companies does each day, serving families and businesses through about 180 locations statewide.The project involved creating business intelligence solutions for the various work streams (compensation, compliance, finance) by comparing and contrasting data from various sources and then consolidating them at the report/dashboard level.

Hardware/Software:
Oracle 10g, Teradata,Informatica 8.1.1, Informatica Power Center 7.1.1(Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), OBIEE 10.1.3.2, BI Publisher, Toad, SQL, SQL * Loader, PL/SQL Procedures, Windows 2000, UNIX, Shell Scripts.
Responsibilities:

• Involved in business meetings and working closely with the business analysts to gather user requirements and did thorough Data Analysis. Based on the requirements identified the scope of new data, confirming dimensions between new and existing Warehouse tables, Drill Downs and data security and developed the business requirement document.
• Identified granularity level of the data required for analysis that exactly meets the user reporting requirements.
• Involved in development of Informatica mappings and also in tuning of mappings for better performance.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Efficiently used Server Manager for Session Management, Database Connection Management, scheduling of Jobs and Server Assignment for speedier completion of Workflow Sessions in the Server Manager module of Informatica PowerCenter5.1.1.
• Developed new dimensions, facts and aggregate tables. Worked on Physical, BMM and Presentation layer of the Oracle Business Intelligence Admin tool to create the physical and business model diagram and the logical hierarchies.
• Created logical tables and defined the complex joins for a business model.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance using the Security settings in Oracle Business Intelligence Administration Tool.
• Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Created dimensional hierarchy and used shared child level when creating the sub level hierarchies.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Responsible in creating Alias and configured repository with logical dimensional modeling using star schema.
• Worked on deployment of different OBIEE builds on LINUX Production Server.
• Responsible for migrating the web catalog and RPD from DEV and PROD environments.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements and was also solely involved in delivering write back functionality.
• Building interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
• Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards.

Confidential, Tampa, FL [07/07 - 08/09]
Siebel Analytics Consultant

Confidential is committed to progressive public policy, superior public service, courteous public contact, judicious exercise of authority and sound management of public resources to meet the needs and concerns of our citizens today and tomorrow.

Hardware/Software:
Siebel Analytics 7.8.5, Informatica 7.1.2 (Power Center Designer, Workflow Manager, Workflow Monitor), Oracle 10g/9i, SQL, PL/SQL, SQL Server 2000/2005, Windows 2000/2003, ER Studio.
Responsibilities:

• Involved in creating the Star Schema, Logical and Physical Modeling.
• Part of a team involved in resolving the fallout from an upgrade to a 7.8.4 stand alone platform. The upgrade involved moving to the 7.8.4 version as well as making the repository more vanilla.
• Worked on resolving various data consistency issues from both the ETL and UI perspectives. Fixed close to 130 issues involving both the ETL and Analytics Repository.
• Actively involved in gathering business requirements and performing GAP analysis.
• Analyzing the requirements and proposing the required changes to the database for performance tuning.
• Installed and configured Siebel Analytics Suite on Windows and Solaris Servers.
• Fixed various reports by resolving the joins in the Physical and Business layer to ensure the vanilla model replicated the previous customized subject areas.
• Configured Analytics repository by setting up database objects, connection pools and creating new repository files.
• Created different report templates for BI Publisher.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Responsible for building effective Cache Management strategy by using Event Polling Tables and Siebel Analytics ODBC Call Functions to purge the cache and iBots to seed the cache.
• Importing physical tables and creating the required aliases, views and creating the joins in the physical layer.
• Developing the Facts, Dimensions, necessary hierarchies and the joins between the logical tables, adding aggregates in the BMM layer.
• Creating Presentation Catalogs in Presentation layer used for both ad-hoc and Dashboard users.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities data showing up on the Analysis Reports.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up reports.
• Worked on resolving various issues with visibility related to the roles and responsibilities of an individual.
• Fixed various performance issues after the upgrade by tuning the joins in the business layer. Slashed the running time of certain reports from 10 minutes to around 2 minutes.
• Installed and configured Informatica power center 7.1.4 client tools and ODBC connections.
• Created shortcuts for flat files and relational sources and targets.
• Extensively used ETL to load data from wide range of source such as flat files and XML to ORACLE.
• Loaded the data having complex calculations using aggregator and router transformations.
• Designed load the data by starting the batches using indicator files.
• Analyzed the query performance and designed the loading process schedules.
• Server Manager used for creating and maintaining the Sessions. Server Manger Also used to Monitor, edit, schedule, copy, aborts and deletes the session.
• Worked with Memory management for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager, PMCMD and also using scheduling tools. Generated completion messages and status reports using Workflow manager.

Confidential, Chennai, India [06/05 - 04/07]
Database Developer

Confidential provides a comprehensive suite of IT services and solutions with professional well versed in various technologies in demand by the current IT industry.
Hardware/Software:
Oracle8i, SQL, PL/SQL, XML, SQL*Loader

• Responsibilities:
• Involved in daily, weekly and monthly load of data from mainframe data set to Oracle database.
• Worked on very large database environment in terabytes and tuned queries for performance. Created and maintained parallel queries for very large datasets.
• Wrote several stored procedures/triggers in Oracle (PL/SQL) for the enterprise portal application and data merge.
• Worked on queuing for sending XML data to the calling java APIs.
• Creating temporary tables and indexes for loading and updating data.
• Imported/exported several databases through various environments
• Developed and maintained lot of batch scripts in KSH scripts for the production, like scheduled data loading, Create, databases, Tuning and backup and Recovery.

Professional Certifications & Training:

• Certified by Oracle as an Oracle Certified Associate on Oracle-11g RDBMS by Oracle University.
• Oracle Application Development Framework (OADF) Training from Oracle University.