Summary

• 8 plus years of IT Industry experience.
• 6 years of experience in Business requirement gathering, Analysis, Design, Data modeling, Development, Testing and Implementation of Data warehousing using Oracle Business intelligence 11.1.1.5.0,11.1.1.6.0, 10.1.3.2/3.3/3.4 and Siebel Analytics 7.5/7.7/7.8.

Experience in

• Working with SQL developer and SQL server management studio to create and maintain tables, schemas and joins in the back end.
• Working with CRM and ERP applications as Siebel CRM, Oracle apps, people soft and their integration with OBIEE.
• Creating complex and reusable mappings, transformations, and multiple file handling sessions in Informatica.
• Managing ETL mappings and executing workflows using DAC.
• ETL process using Informatica in extraction, transformation and loading from multiple data sources to Data warehouse.
• Performing data integration using ODI oracle Data Integrator
• Designing Interactive dashboards, incorporating dashboard prompts, navigation, drill down and web catalog objects using OBIEE.
• Creating report layout templates in BI publisher.
• OBIEE Answers, Dashboards, Delivers, i-Bots and BI publisher.
• OBIEE/Siebel Analytics security at the data and object levels.
• OBIEE/Siebel Analytics Repository .rpd development at three layers Physical Layer, Business Model Mapping Layer and Presentation Layer and configuring metadata.
• Business model development with facts, dimensions, hierarchies, measures, partitioning, Aggregation rules, time series and cache management.
• Installing, configuring and administering OBIEE/Siebel Analytics server, both in standalone and enterprise applications.
• Good understanding of database design, OLAP, OLTP and normalizations.
• Proficient in programming languages like java, C, C , python.
• Proven leadership qualities, strong technical, organizational and communication skills.

Technical Skills

• BI : OBIEE 11.1.1.x/10.x Administration tool, Analytics, Answers, Dashboards, Delivers and BI publisher and Siebel 7.x Administration tools and Analytics
• CRM :Siebel CRM
• ETL : Informatica 8.x/7.x/6.x, DAC
• ELT oracle : Oracle Data Integrator ODI
• Languages : Java, Python,c, c
• RDBMS : Oracle 10g/11g, SQL server
• OS : Windows 2000/XP/NT/7/Vista, UNIX and LINUX
• Tools :MS Visio, Eclipse, Glassfish, Oracle JDeveloper 11g/10.1.1.3, Autosys 4.x, VSS 2005

Professional Experience

Confidential

OBIEE Team Lead

Responsibilities:

• Wrote PL/SQL procedures and triggers in the database.
• Developed and modified star schemas in the Business Model and mapping layer to accommodate new requirements.
• Get user requirements and discuss with the team to plan report and dashboard development.
• Developed reports using drill through and view selectors, created Table view, bar chart, pivot tables, gauge, and pie charts.
• Developed interactive dashboard pages, created links to pages, created collapse and expand option for definitions using JavaScript, created hover over links using html.
• Specified prompts using SQL, presentation variable and columns.
• Validated all queries using physical SQL to improve performance.
• Worked with Administrator to add logical columns and repository variables in the repository.
• Edited Logical SQL in the advanced tab to modify the query.
• 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.
• Defined source and target tables, Created lookup tables, transformations, mappings and mapplets in Informatica Designer, created workflows using workflow manager, performed ETL runs and monitored them using workflow monitor.
• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Upgraded OBIEE from 10.1.1.3.4.1 to 11.1.1.7.1 and fixed all the issues at the time of upgrade.
• Triggered Informatica Mappings using DAC for the Full Load and Incremental Load processes.
• Worked in BI publisher to create customized template, defined data models and created reports using SQL and OBIEE analysis.
• Used VSS tool to maintain OBIEE reports in the front end.
• Created and maintained developer documentation contained details about complex features in OBIEE reports that new OBIEE users will not be aware and user training manual This manual was for dashboard users to learn how to navigate through the dashboards .

Environment: OBIEE 11.1.1.6, OBIEE 10.1.3.4.1,Microsoft SQL Server Management Studio, Informatica 8.6.0, HTML, JavaScript, Windows Server 2008, VSS 2005.

Confidential

Sr. OBIEE developer

Responsibilities:

• Understood user requirements and figured out the data to be extracted from Oracle EBStransactional database.
• Defined source and target tables, Created lookup tables, transformations, mappings and mapplets in Informatica Designer, created workflows using workflow manager, performed ETL runs and monitored them using workflow monitor.
• Imported required tables from oracle 11g data warehouse to the physical layer of the repository using predefined connection pools and created aliases for all the physical tables.
• Created new logical tables in BMM layer and did calculations using existing tables as expression.
• Defined foreign key join in the physical layer and complex join in logical layer to add dimension tables to star schema.
• Developed separate presentation folders for each subject area in the presentation layer.
• Created adhoc reports, drill down reports and reports using union operator. Used compound layout, pivot tables and charts.
• Validated the results of analysis using physical SQL in toad and verified the join conditions and filters to get exact results.
• Developed interactive dashboards, defined prompts as columns and presentation variable.
• Created new session variable and used it as a date in dashboard prompt.
• Created customized BI publisher templates to match Business user requirements.
• Defined data models in BI publisher, created reports, imported data as XML and published data in customized templates.
• Worked in Oracle E-Business suite to validate and modify existing HR data.

Environment: OBIEE 11.1.1.6, Toad 11.5, OBI Applications, Oracle 11g, Informatica 8.6.0, HTML,Windows Server 2008, BI Publisher 11.1.1.6, Oracle EBS R12

Confidential

OBIEE Team Lead

Responsibilities:

• Worked with the customer support team to gather requirements. Involved in their discussions to get a deeper understanding of their call management database Avaya .
• Worked with the DBA to create summarized tables for their raw data that was in the transactional database.
• Installed OBIEE 11g and RCU, created ODBC and imported tables from the database.
• Designed repository by importing metadata from the database Physical layer, Business Model and Mapping layer and Presentation layer.
• Performed transformation of data using Oracle Data Integrator ODI , by creating filters and expressions.
• Performed Data integration using ODI by transferring data from SQL server database and oracle 10G database to the central avaya database.
• Developed and modified star schemas in the Business Model and mapping layer to accommodate new requirements.
• Created logical tables in the BMM layer.
• Created Ad-hoc and standard reports/dashboards with different customized views as required by the user Drill down, gauge, column selector, ticker etc using OBIEE framework.
• Developed dashboards with drill down capabilities and applied local and global filters.
• Upgraded OBIEE from 10.1.1.3.4.1 to 11.1.1.7.1 and fixed all the issues at the time of upgrade.
• Designed BI publisher templates as per requirements.
• Worked in BI publisher to pull data from transactional database to customized templates.
• Implemented auto provisioning security model, by creating user roles, web groups, setting up LDAP for authorization.
• Prepared a training session and trained the customer support team on OBIEE 11g repository, Answers and Dashboards.
• Prepared documentation for each process in the project. This documentation contained minute details and screen shots of every step of OBIEE installation and implementation including repository, answers and dashboards.

Environment: OBIEE 11.1.1.6,OBIEE 10.1.3.4.1, Toad 11.5, OBI Applications, Oracle 11g, MS SQL Server 2005, Oracle Data Integrator ODI , HTML,Windows Server 2008

Confidential

Sr.OBIEEDeveloper

Responsibilities:

• Collaborated with Business analysts and Users to gather requirements. Actively participated in technical design and implementation of application.
• Worked in OFSA Oracle Financial Services module to add new logical columns in Business Layer.
• Created Physical layer, Business Model and Mapping layer and Presentation layer using Admin tool based on the requirements.
• Columns requiring calculations were determined and calculated in ETL using Informatica.
• Created connection pools, defined primary, foreign keys and created simple and complex joins between various dimension and fact tables.
• Implemented Business logic by creating dimension hierarchies, level based measures and aggregates in BMM, presentation catalogs and folders in presentation layer.
• Extensively worked on initialization blocks for user login security in the RPD. Created groups to add users, granted privileges explicitly and through group inheritance.
• Developed dashboards with drill down capabilities and applied local and global filters.
• Saved requests, moved them to dashboards and made them available to users.
• Validated reports by cross checking values using SQL.
• Created reports with appropriate views such as charts, pivot, legend, narrative and ticker.
• Applied filters, prompts, dashboard prompts, calculations and conditional highlighting for reports.
• Worked closely with the business team in understanding the BI publisher requirements and walked them through the output.
• Extensively worked on BI publisher for generating reports.
• Designed BI publisher templates as per requirements.
• Used BI publisher to design paystub template and generate paystub for employees.
• Worked on OBIEE Multi User Development Environment MUDE , implemented centralized repository development.
• Built reports with action links based on guided navigation functionality, where the user can query the records of a specific view on Siebel CRM.
• Implemented auto provisioning security model, by creating user roles, web groups, setting up LDAP for authorization.
• Prepared weekly status reports, worked on project plan with the coordinator to get the changes reflected.
• Performed ETL runs using Oracle Data Integrator.
• Worked on data migration using Oracle Data Integrator
• Trained end users by creating presentation sessions and documentation to get them familiar in OBIEE.

Environment: OBIEE 11.1.1.6/10.1.3.4,OBI Applications, Oracle 11g, MS SQL Server 2005, Oracle Data Integrator ODI , Informatica 8.6.0, HTML,Windows Server 2008

Confidential

Sr.OBIEE Developer

Responsibilities:

• Worked with Business users to create new relationship extract reports and modify existing reports.

• Designed repository by importing metadata from the database Physical layer, Business Model and Mapping layer and Presentation layer.
• Defined connection pools to source data mart tables in the physical layer.
• Developed and modified star schemas in the Business Model and mapping layer to accommodate new requirements.
• Created Ad-hoc and standard reports/dashboards with different customized views as required by the user Drill down, gauge, column selector, ticker etc using OBIEE framework.
• Implemented security using LDAP authentication and authorization by using external table by implementing dynamic session variables and initialization blocks in the repository.
• Implemented automated Business Intelligence using iBots. Used Delivers to deliver analytics content mail, phone to business users based on schedule.
• Created time series objects to compare current business performance to previous dates using Ago and ToDate functions.
• Implemented aggregate tables for better analytics performance.
• Configured facts, dimensions and hierarchies.
• Created repository variables for different purposes for use in reports for pulling the data.
• Applies cascading prompts and multilevel prompts in dashboards.
• Worked on ETL process using Informatica in Extraction, Transformation and loading from multiple data sources to data warehouse.
• Managed ETL mappings and executed workflows using DAC.
• Upgraded and migrated OBIEE 10.1.3 to OBIEE 11.1.1.3

Environment: OBIEE 11.1.1.3, OBIEE 10.1.3.4, Oracle EBS, Informatica Power Center 8.x,Oracle 10g, MS SQL Server 2005, Windows Server 2003