Summary

• Creating complex and reusable mappings, transformations, and multiple file handling sessions in Informatica.
• Working with CRM and ERP applications as Siebel CRM, Oracle apps, people soft and their integration with OBIEE.
• 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
• 8 plus years of IT Industry experience.
• 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

Professional Experience

Confidential

Sr.OBIEE Developer

Responsibilities:

• 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.
• 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.
• Worked in BI publisher to create customized template, defined data models and created reports using SQL and OBIEE analysis.

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

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.

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

Confidential

Sr. OBIEE developer

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.
• 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,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.
• 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

Confidential

Sr.OBIEE Analyst

Responsibilities:

• Participated in all phases of software development including requirement analysis, client interaction, design, coding, testing and documentation.
• Created and modified metadata repository .rpd and configured metadata objects using Siebel analytics administration tool.
• Designed and developed dashboards or reports that were dynamic and interactive with intuitive drilldowns, drill-across and flash-based drillable charts pie, bar, bubble and radar , capabilities split reports for summary and details information, local and global filters and cache monitor using Siebel analytics web.
• Performed security management for users, groups and web groups using various authentication systems.
• Created and scheduled iBots to deliver personalized reports to users.
• Developed multiple dimensions drill down hierarchies , logic and facts/measures in Business model and mapping layer and created presentation catalogs in the presentation layer.
• Involved in ETL mappings or mapplets and workflows using transformations update, strategy, router, expression and aggregator .
• Designed and documented the business validation/rules, error handling and test strategy of the mapping.
• Tuned the sessions for better performance by implementing partitions.
• Developed reusable transformations and mapplets.
• Implemented debugging and performance tuning of targets.
• Used time series wizard to create aliases fact table in the BMM and physical layer to compare measures and spot trends.

Environment:OBIEE 10.1.3.3,Siebel CRM Informatica 6.2,Oracle 9i, Teradata, SQL, PL/SQL, Erwin, Linux, Windows Server 2003

Confidential

OBIEE Developer

Responsibilities:

• Migrated from Siebel Analytics to OBIEE 10g

• Gathered and analyzed requirements from business users and wrote functional documents and technical specifications.
• Created Siebel Analytics metadata in the analytics repository with analytics administration tool.
• Developed data models and entity relationship diagrams.
• Wrote data loading stored procedures, functions using PL/SQL from source systems into operational data storage.
• Created logical columns based on other logical and physical columns, defined dimensional hierarchy and dimensional levels for drill downs in the Business Model and Mapping layer.
• Hands on experience in Siebel Analytics Server Administration setting up repository, administering the query environment, scheduler, query caching
• Worked on dashboards and reports.
• Extensively used Siebel delivers and iBots.
• Implemented dynamic dashboard prompts to zoom into particular segments of a business in a performance optimized manner.
• Performed optimization/tuning in physical layer as well as in database.

Environment: OBIEE 10.1.3.3,Siebel Analytics 7.7.2, Oracle 8i, SQL Server, Toad, Windows 2000, Linux and MS visio

Confidential

Siebel Analytics Developer

Responsibilities:

• Analyzed new Business requirements and defined their relationships with existing Business entities.
• Created data flow diagrams and data models star schema .
• Responsible for the analysis, design and implementation of the systems and network infrastructure needed to support all aspects of the Siebel development, testing and production environmental requirements.
• Performed GAP Analysisrelated to Data Models and ETL defined efforts involved in addressing gaps and rated the gaps on complexity involved.
• Hands on experience with configuration of repository using Siebel Administration tool Physical, Business Model and Mapping and Presentation layers .
• Worked extensively on Siebel Answers to create reports as per client requirements.
• Performed administration tasks related to development and configuration of intelligence dashboards.
• Defined additional view narrative, pivot, chart views of the data returned by the request to visualize data in many different ways.
• Involved in installation, configuration and administration of Siebel analytics server, Siebel analytics repository RPD , DAC client and server.
• Created high level and detailed design documentations, mapping client requirements into Siebel analytics.
• Assisted in creating reusable and non-reusable mappings and mapplets using filters, aggregators, look-ups, expression aggregator, sequence generator, joiner and update strategy transformations.
• Customized Siebel analytics web user interface.
• Implemented Siebel recommended data warehouse design principles and best practices.
• Worked very closely with cross functional business areas and functions to ensure smooth daily operations and effective communication of project deliverables.

Environment: Siebel analytics 7.5, Siebel CRMOracle 9i, Informatica 6.2, SQL, PL/SQL, Windows 2000, Erwin 4.0, Solaris and MS visio.