SUMMARY:

• Over 7 years of IT experience involving Analysis, Design, Development and Implementation using standard SDLC methodologies.
• Core competencies include design and development of OBIEE repositories, and building OBIEE Dashboards/Reports, BI APPS and Informatica.
• Over 5 years of experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence (OBIEE).
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Ability to work with various stakeholders on their reporting needs to produce appropriate reporting.
• Experience in Dimensional Data Modeling using Star Schema, Snow-Flake Schema, Fact and Dimensional Tables.
• Expertise in building Metadata Model (rpd), building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool along with development of dynamic and interactive Dashboards, Answers and IBots.
• Proficient in defining Key Performance Indicator (KPI’s).
• Developed several Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters) using OBIEE Analytics Web.
• Familiar in PL/SQL Procedures, Packages, Functions, Triggers and other objects
• Experience in migrating the Web catalog developments by using the Catalog Manager and Repository developments to Production from the Test environment.
• Configured Oracle BI Scheduler Configuration for Alerts / iBots.
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUD).
• Experienced in BI Publisher, MS Office Plug-in for rich reporting and Expertise inCache, Usage tracking, Aggregate navigation, Variables/Initialization Blocks configuration etc.).
• Worked on various database sources like Oracle, SQL Server and Flat files.
• Execution of Jobs using DAC, Informatica & Unix
• Experience in Oracle 10g/9i/8i - design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL and PL/SQL.
• Extensively worked in the performancetuning of the programs, ETL Procedures and processes.
• Highly adept in working under pressure and around large volumes of consumers.
• Well-organized, very thorough, detail oriented, and has good followed through skills.
• Team player with excellent analytical, communication and technical skills

TECHNICALSKILLS:

Methodologies

Dimensional Data Modeling Logical / Physical

Reporting Tool

Oracle BI EE 10.1.x, Siebel Analytics 7.x

ETL Tool

Informatica 5.1/6.2 (Power Center).

Databases

MS SQL 2000, MS Access, Oracle 9i, Oracle10g

Languages

C/C++ Java, Visual Basic, JavaScript.

Operating Systems

Windows 98/00/XP, Unix, Windows Server 2005,2008

Other

Visio, MS Office, Adobe Acrobat.

PROFESSIONAL EXPERIENCE:

Confidential ,OakBrook,ILNov’11 –Till Date 
OBIEE 11GArchitect
Confidential is continuously recognized as a premier franchising company around the world. More than 80 % of its restaurants world wide are owned and operated by Franchisees. McDonlds is implementing various OBIA Analytics modules (Financial, Project Analytics) and customizing the same depending on the user requirement. The purpose of this project is to create reports for the financial group for further business analysis.
Responsibilities

• Interacted with the business analyst and business users to understand the customer requirement documents.
• Worked extensively on OBIEE 11G new features
• Upgraded OBIEE10g Application to OBIEE11g.
• Configured OBIEE components for reports Performance Tuning
• Diagnosing and troubleshooting BI Reports ability to articulate configuration and technical issues.
• Worked on OBIEE 11g tool evolution and recommendations.
• Tuned weblogic application server and its managed servers to run deployed applications fast.
• Analyzed reporting requirements for dashboard reports and adhoc reports.
• Involved in Analysis and Design of the BI data warehouse.
• Fix the ETL load issues because of the data or ETL mappings.
• Execute Incremental test loads.
• Validated and customized reports.
• Incorporate all the customizations require for the initial requirements in to the ETL mappings.
• Test ran the load for a complete data load.
• Design the test cases for all the initial requirements.
• Involved in configuring, creating and modifying repository for various modules for necessary customizations.
• Involved in Performance tuning of sessions and mappings for better performance.
• Designed performance effective star schemas and replicated complex snowflake schemas from BO
• Used DAC to schedule and run the full incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups
• Integrate Custom warehouse table with the OBI Apps tables for extending the business analysis capabilities.
• Migrating/merging Repository and web-cat and documented migration procedure and best practices to be followed during migration from development to test and then to production.
• Documented processing times for each module, developed test cases and used them to run through each process.

Environment:OBIEE 11.1.1.3/11.1.1.5, Informatica Power Center 9.1 , Windows XP, Oracle 10g , Oracle BI Apps v.7.9.3, UNIX, Windows Server 2003 & LDAP Security Management.

Confidential,Minneapolis,MN Jan’11-Oct’11
OBIEE 11G Architect
Confidential is implementing various OBIA Analytics modules (Financial, Project Analytics) and customizing the same depending on the user requirement. The purpose of this project is to create and maintain a central data warehousing and to create reports for the financial group for further business analysis.
Responsibilities

• Interacted with the business analyst and business users to understand the customer requirement documents.
• Installed and Configured OBIEE 11.1.1.3.0/11.1.1.5.0
• Worked extensively on OBIEE 11G new features
• Upgraded OBIEE10g Application to OBIEE11g.
• Configured OBIEE components for reports Performance Tuning
• Diagnosing and troubleshooting BI Reports ability to articulate configuration and technical issues.
• Worked on OBIEE 11g tool evolution and recommendations.
• Tuned weblogic application server and its managed servers to run deployed applications fast.
• Configure the initial configurations for Finance and Project Analytics.
• Analyzed reporting requirements for dashboard reports and adhoc reports.
• Involved in Analysis and Design of the BI data warehouse.
• Execute the initial test full load for a subset of data.
• Fix the ETL load issues because of the data or OOTB ETL mappings.
• Execute Incremental test loads.
• Validated and customized OTTB reports.
• Incorporate all the customizations require for the initial requirements in to the ETL mappings.
• Test ran the load for a complete data load.
• Design the test cases for all the initial requirements.
• Involved in configuring, creating and modifying repository for various modules for necessary customizations.
• Used DAC to schedule and run the full incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in Reports to improve performance
• Integrate Custom warehouse table with the OBI Apps tables for extending the business analysis capabilities.
• Migrating/merging Repository and web-cat and documented migration procedure and best practices to be followed during migration from development to test and then to production.
• Documented processing times for each module, developed test cases and used them to run through each process.

Environment:OBIEE 11.1.1.3/11.1.1.5, Informatica Power Center 9.1 , Windows XP, Oracle 10g , Oracle BI Apps v.7.9.3, UNIX, Windows Server 2003 & LDAP Security Management.

Confidential, Duluth, GA Apr’10 – Nov’10
Sr. OBIEE Developer

Description: Confidential is division of Euramax where Euramax International, Inc.is an international producer of aluminum, steel, vinyl, copper and fiberglass products for original equipment manufacturers, distributors, contractors and home centers worldwide. Confidential is implementing various OBIA Analytics modules (Supply chain and Order management, Procurement and Spend Analysis, HR Modules) and customizing the same depending on the user requirement. The purpose of this project is to create and maintain a central data warehouse and to create reports for the financial group for further business analysis.

Responsibilities:

• Interacted with the business analyst and business users to understand the customer requirement documents.
• Developed the RPD using the OBIEE Admin tool and extensively worked on all the three
• From a single dimension for RPD development, level based measures.
• Worked with DBA and SQL developers to create jobs and schedules to build materialized views.
• Supervised the DAC and Informatica design mapping the Siebel OLTP to a Siebel OLAP data warehouse using out of the box and customized mappings.
• Created new logical columns layers physical, business and presentation layers.
• Created multiple hierarchies, calculated columns using the expression builder and created presentation Catalogs in presentation Layer.
• Extensively worked on the Initialization blocks and variables like server variables and session variables to get the dynamic values.
• Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements
• Configured dashboard prompts and page prompts for different type of reports like Revenue Shipments, Sell through, Open Orders, Inventory, Shipments reports to zoom into particular segment of the Confidential business.
• Created the reports using different views like table, chart, pivot table, column selector, and View selector to satisfy the requirements.
• Experience as a Database developer using Oracle SQL, PL/SQL Versions 9i, 10gR1 and 10gR2, SQL Server 2005/2000 and Teradata, Sybase.
• Developed PL/SQL Packages to monitor revenue earnings and expenses and to maintain the general ledger of the organization.
• Strong understanding of the major business functions associated with Oracle Financial, Order fulfillment Applications, as well as the associated underlying application technology architecture and tables.
• Involved extensively in Siebel Answers, Siebel Delivers, and Siebel Intelligent Dashboards with Siebel.
• Experience in Sales, Financial, Order Management and Fulfillment Analytics
• Used saved Filters, Case statements and provided customized functions appropriately in Oracle Answers.
• Created the dashboards and used guided navigation and Link or Image objects.
• Involved during pre and post releases, participated in UAT (User Acceptance Testing)
• Configured Event Polling for better Cache management
• Used Analytics Scheduler to configure Delivers and IBots to notify the corporate managers and region managers immediately about the messages and generated IBots alerts for reports to be delivered by e-mail.

Environment: OBIEE 10.1.3.4.1/10.1.3.4, Informatica Power Center 7.1.4, PL/SQL, Windows XP, Oracle 10g , Oracle BI Apps v.7.9.5, UNIX, Siebel, Windows Server 2005 & LDAP Security Management

Confidential, Morrisville, NCMar’09 – Mar’10
Sr. OBIEE Developer

Description:Confidential is the only fully integrated biopharmaceutical services company offering clinical, commercial, consulting and capital solutions worldwide. The objective of this project was to provide information technology solutions through its range of solution. Oracle Business Intelligence (BI) Applications are complete, prebuilt BI solutions that deliver intuitive, role-based intelligence for everyone in an organization. These analytics helps close business faster and increase overall sales revenue.

Responsibilities:

• Gathered requirements of the various work streams by meeting with the business user and base lining the details.
• Designing ETL functional Specifications and converting them into technical specifications.
• Worked with data architects to translate business requirements into technical specifications and logical & physical data models.
• Evaluated and implemented data governance, data retention and data archiving strategies and business intelligence and reporting tools.
• Created Repositories by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using OBIEE Admin Tool.
• Created Dimensional Hierarchies, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Created pivot table requests allowing managers to analyze the business in different perspectives
• Developed stored procedures and functions using PL/SQL for complex updates and audit trails.
• Developed many Oracle PL/SQL packages for Meter Management Data mart.
• Analytics Integrated implementation (Siebel Business Analytics Applications).
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
• Led a team of three developers in the design, build and testing of the application based on business requirements.
• Liaised with third party vendors to ensure that all the necessary data was brought into the data warehouse using Informatica, DAC and Relational Junction to replicate data from the Salesforce.com into the data warehouse.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Involved in performance tuning by enabling the cache to improve the query performance.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from development environment to QA environment and then to the Production environment.
• Extensively worked in the Performance tuning of the programs, ETL Procedures and processes.
• Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Windows XP Informatica Power Center 8.1, UNIX, Windows Server 2005 Data Warehouse Administration Console (DAC), Oracle Delivers, PL/SQL, BI Publisher & Oracle 11g/10g.

Confidential, St Louis, MO Aug’08– Feb’09 
OBIEE Developer

Description: Confidential is a Missouri State special purpose political subdivision that is responsible for the St. Louis area’s storm water and sewer collection and treatment. Confidential ranks in the nation’s top wastewater utilities, and is a major contributor to the health and environment of the St. Louis area.The purpose of this project is to create and maintain a central data warehouse and to create reports for the financial group for further business analysis.

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Knowledge and expertise in quickly implementing a KPI dashboard, which analyze key metrics in a fast, reliable manner, helps to make quick and efficient decisions.
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• To create Connection pools, import physical tables and define joins in the Physical Layer.
• Developed and customized some of the existing Dimensions (Drill-Down Hierarchies)& Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Written Data loading stored procedures, functions using PL/SQL from Source Systems into operational data storage.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Used OBIEE Delivers to automate IBots queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Used DAC (Data warehouse Application Console) for both incremental and full loads.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Created & saved several BI Publisher reports by selecting an Answers request as Data Source.
• Built multiple execution plans in DAC for weekly and daily loads.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.2, Informatica Power Center 7.1.4, Data Warehouse Administration Console (DAC), PL/SQL, Oracle BI Publisher, Oracle Delivers, Windows XP & SQL.

Confidential, Reading, PA Jul’07– Apr’08
OBIEE Developer

Description:Confidential provides offers a full range of financial solutions for individuals as well as businesses and institutions.The project was aimed at HR and Financial Analytics implementation, which provides Financial Statements, Capital Gain Analysis, Human Resource Management, Performance, Measurement analysis.

Responsibilities:

• Customized OBIEE Applications Financial management module based on the business requirements.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Created numerous executive level reports. ‘Dashboards’ were generated to provide insight into the marketing/financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements
• Designed and customized RPD’s, Oracle Answers (webcast), Dashboardsand Cache.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Implementing Oracle BI Applications (OBIA), the BI application content being BI, ETL and DWH metadata and application integration with the E-Business Suite for ERP (FI, HR, SCM) and CRM also known as Oracle Applications, EBS.
• Involved in the implementation of Oracle E-Business Suite including the Oracle Install Base leverages existing CRM and ERP applications, Financials (AP/AR/GL) and Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships among them.
• Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
• Implementing Oracle EBS where Oracle HR is a key component of the fully integrated Oracle HRMS suite of Applications, comprising of Oracle HR, Oracle Payroll, and Oracle HR: Self-service, Oracle Time and Labor, Oracle iRecruitment, Oracle HR Intelligence, Oracle iLearning EBS, Oracle Advanced Benefits, and Oracle Labor Distribution.
• Worked on Fixed Income Management strategies like Non-investment grade securities, commonly called high-yield or junk bonds
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models like revenue-opportunity and inventory management models using Star Schema and Snowflake Schema.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard.
• Performed Repository Testing and Validation before exposing Business Models in the Presentation Layer.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Configured iBots to alert the management and sales teams as per their requirements.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up reports.
• Slice and Dice data using filters and used pivot tables and charts for better presentation.
• Worked on transformations like Source Qualifier, Expression, Filter, Lookup, Update Strategy, Sequence generator, Joiner, Router, Aggregator transformation.
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Checked the source, target and mapping bottlenecks to tune the ETL process performance.
• Built custom analyze scripts for DAC to reduce the time for table analysis.
• Migrated the Tested Code from Dev to QA and QA to Production of Repository, Dashboard Reports and Informatica mappings and workflow and DAC Entities.
• Creating bunch of Data Marts which can be easily accessible for the required data.
• Performed Unit tested for mappings before adding new developed sessions into the existing batch.
• Integration tested the entire batch after including the individual sessions.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.

Environment: OBIEE 10.1.3.1, BI Apps, Informatica Power Center 7,PL/SQL, Oracle 10g, Windows XP, LDAP Security Management

Confidential, Boca Raton, FL Jan’07 – Jun’07 
Software Engineer

Description: Confidential., based in Boca Raton, FL, manages the nation’s largest database of workers compensation insurance information. The purpose of this project is to create and maintain a central data warehouse and to create reports for the financial group for further business analysis. Siebel analytics was implemented for the generation of the reports. 

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements.
• Worked closely with the data modeler in designing the logical data model/physical data model (star schema).
• Configured and created repository using Siebel Analytics Administration Tool.
• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation.
• Layer in a Siebel Analytics Repository using Siebel Analytics Administration Tool.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Involved in Data Modeling and Data Mapping review, including sources, staging areas, and target database.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Suggested and implemented Siebel recommended Performance tuning practices to improve Siebel Analytics server performance by implementing Query Caching, using aggregate tables, tuning & reorganizing database indexes and configuring NQSConfig.INI files performance parameters.
• Involved in developing different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboard.
• Created Security settings in Siebel Analytics Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in Siebel Answers.
• Used filters and provided customized prompts (filtering options) appropriately to avoid excessive data visibility in reports.
• Involved in unit testing, integration testing of the reports generated using Siebel Analytics.

Environment: Siebel Analytics 7.5 Oracle 9i, Erwin & Windows 2000.

Confidential Aug’05– Dec’06 
Data Warehouse Developer

Description:I worked on project called Accident Detail Preventer/Tracker: The primary jobs included tracking accident details like personal injury, cost, rail, time, location etc and allows planning, distributing and updating of the companies safety policy to aid accident prevention.

Responsibilities:

• Involved in Creating tables with different types on constraints
• Using all kinds of SQL Server Constraints like Primary, Foreign, Unique, and Check etc.
• Involved in database programming in writing stored procedures, triggers and indexes very frequently.
• Installation and configuration of SQL Server 2000 components
• Extensively used ETL to load data from wide range of source such as flat files, oracle and XML to ORACLE.
• Extensively used PL/SQL Procedures/Functions to build business rules.
• The project involved extracting data from various sources, transforming the data from these files before loading the data into target (warehouse) Oracle tables.
• Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools. Security and user management, repository backup was also done using the same tool.
• Designed and Developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (Fact/Summary) data identified by dimensions using Informatica Power Center tool.
• Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
• Server Manager used for creating and maintaining the Sessions. Server Manger Also used to Monitor, edit, schedule, copy, aborts and deletes the session.

Environment: MS SQL 2000, Windows 2000/XP, SQL Query Analyzer, ORACLE 8.0, PL/SQL,SQL Server,  Informatica, Power Center 5.1 & SQL.

EDUCATION:
Bachelors Degree in Computer Science & Engineering