Summary

• 8 years of IT experience including 6 years in Data warehousing Siebel Analytics, ETL Informatica and DAC .
• 5 years of exp in OBIEE 10.1.x/Siebel Analytics 7.x, which includes Oracle BI/Siebel Intelligent Dashboards, Oracle BI/Siebel Answers, Oracle BI/Siebel Delivers and Oracle BI/Siebel iBots, Oracle BI Publisher, Oracle BI Applications 7.9.5 ETL-Informatica 8.x/7.x, Reporting-OBIEE platform, Scheduling- DAC , Oracle Discoverer.
• Expertise in configuring Interactive Dashboards with drill-down capabilities and drill-across capabilities using Dashboard Prompts, Contextual Navigation, Guided Analytics, Business Rules with User Identity Roles, Profiles Personalization.

Key Differentiators

• Experienced in creating reports based on the data from Oracle EBS and PeopleSoft ERP and Siebel CRM systems
• Hands-on experience in installing and configuring OBIEE/Siebel Analytics, Informatica and DAC
• Expertise in BI Applications 7.9.5 and 7.9.6
• Experience in understanding business processes / requirements and translating them into technical requirements
• Expertise in creating metadata repositories .rpd using Administration tool
• Expertise in creating iBots in Delivers to send alerts to the recipients on occurrence of a business event or at the time specified
• Expertise in implementing the Oracle BI / Siebel Security Setup groups, data access/query privileges .
• Experience in developing and modifying reports in Oracle BI Publisher
• Good experience in designing Star/Snow flake schemas
• Expertise in creating Transformations, Mappings, Sessions, Workflows for ETL processing using Informatica
• Good Understanding towards Hyperion Smart view
• Expertise in data warehousing concepts like OLAP ,dimensional modeling, data modeling using Normalization, Ralph Kimball and Bill Inmon methodologies, Dimensional Data Modeling, FACT Dimensions tables, Physical Logical Data Modeling, Aggregate persistence wizard
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel, Analytical Dashboards / Reports.
• Installed and Configured BI Applications DAC to configure, monitor, manage OBAW star schemas. Customized preconfigured ETL routines, DAC repository, presentation catalog to load new columns and table.
• Extensive experience in customizing DAC objects like Execution Plan, Subject area, Tasks and other relevant objects to extract and load OBAW for any new columns, tables, SCD implementation for Type I and Type II.
• Extensive experience with various databases Oracle 8i/9i/10g, SQL Server 2000/2005, DB2 and Informix
• Experience in developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL.
• Knowledge and experience in OLAP cubes using Hyperion Essbase.
• Strong Experience in Technical Documentation and Training Users On Data Warehousing and Business Intelligence Products
• Results oriented, self starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.
• Profound Knowledge of SDLC and Software Testing Life Cycle.
• Participated in Integration, Regression, Performance and System testing.

TECHNICAL SKILLS:

EXPERIENCE

Confidential

Responsibilities:

• Analyzed the Business requirements and worked on the design and converted them into technical requirements.
• Created the detail technical design documents describing the complete design of the project.
• Designed, developed and edited the ETL mappings, transformations, and workflow sessions for data migration from OLTP system to Analytics Warehouse using Informatica and Data Warehouse Administration Console DAC .
• Developed the Full and Incremental ETL process i.e. Informatica Mappings Mapplets using various Transformations Update Strategy, Filter, Router, Expression and Lookup .
• Configured the DAC Subject Areas, Tasks, Task group, Indices and implemented Configuration Tag by adding new tasks to the current execution plan to load the intersection tables as a part of extending the ware house.
• Created PLSQL Scripts and executed them to populate the data for the backfill dates.
• Maintained and Monitored Incremental Full load on different environments through DAC.
• Edited the existing RPD and developed metadata for incorporating new BI reporting requirements and changes to existing requirements
• Designed joins between the facts and dimensions and created alias for the dimension, fact tables, views and materialized views when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Developed different levels of Reports, Filters, and Prompts using Oracle BI Answers.

Environment: OBIEE 11g, BIApps, DAC, Oracle 11g, SQL Developer, PL/SQL , Windows XP, UNIX

Cognizant Technology Solutions

Responsibilities:

• Developed rpd metadata for incorporating new BI reporting requirements and changes to existing requirements .
• Designed entity relation ship joins between the facts and dimensions and created alias for the dimension, fact tables, views and materialized views when necessary
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Specified Dimensional hierarchy , Skipped and Ragged hierarchies, Aggregate levels and Time Series function for dimensions/ Facts.
• Developed different levels of Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports
• Created various Analysis along with Cross column conditional formatting feature in order to meet the needs of end users and also customized the views using Oracle BI Answers.
• Implemented Fragmentation content technique, Aggregate Navigation and indexing in order to improve the query performance
• Implemented Adhoc tasks by creating new Analysis, Actions and Agents and by making changes to the existing design as per the business requirements.
• Customized the look and feel of the Front end using HTML and XML for attaining some UI requirements as per the end users
• Configured Data level and object level securities on roles and responsibilities of the end users.
• Created the detail technical design documents describing the complete design of the project
• Attended the KT sessions and documented all the KT Session related to the development of RPD, dashboards and reports
• Involved in the production support which involves resolving of the tickets from the Business users related to the Analysis and Dashboards related to Institutional Credit Exposure Reporting, Risk Mitigation Reporting, Legal Entity Reporting, Dodd Frank Exposure Reporting, New Business Acceptance Reporting Subject areas.
• Modified some of the existing reports and dashboards, and fixed of the issues related to performance, data quality etc., during production support
• Coordinated the Migration of the changes that are done in development to test and production environments by going through the meetings
• Worked with the People Soft and Datastage resources in monitering the jobs and scripts related to data load into the db2 tables from the source systems.
• Identified issues in the existing design and suggested improvements to the existing design to avoid performance issues in future.

Environment: OBIEE 11g, Oracle 11g , DB2, ALM Quality Center, SQL Developer, PL/SQL , Jira,

Confidential

OBIEE Analyst, Designer and Lead / Data Analyst

Responsibilities:

• Interacted with Director and users to understand business requirements and converted them into technical requirements.
• Created the detail Functional design documents and technical design documents describing the complete design of the project which involves heavy customizations of OBIEE and extending of the warehouse.
• Analyzed the complete data related to the project and estimated the pros and cons of the application and also created the POC as a part of the technical design
• Designed fact dimensional tables and created alias for the dimensional tables when necessary.
• Designed and created of new stored procedures and also modified the existing stored procedures to load the newly created dimensions and facts as a part of making enhancements to the ware house schemas.
• Assisted the offshore team in creating new mappings and subject areas and also in modifying the existing mappings and subject areas to incorporate the changes as per the technical design.
• Worked on the performance tuning of various long running mappings and made appropriate changes to improve the performance and reduced the ETL run time.
• Performed extensive defect fixing on existing ETL routines and .rpd layers and also identified the areas of improvement and suggested the required changes and best practices to client
• Fixed the Work Orders related to the production support from both end users and also the Director. Fixing of the Issues involves both technical and functional issues.
• Established ETL and Analytics development standards and mentored 5 offshore team members on technical and functional aspect.

Environment: OBIEE 10.1.3.4.1/ 11g, Oracle BI Apps 7.9.6.1, Oracle EBS, DAC 7.9.5.1, Oracle 11g , HP

Confidential

Tech Lead/Sr.BIAPPS Consultant

Responsibilities:

• Interacted with business analyst and clients to understand business requirements and converted them into technical requirements.
• Customized and implemented DAC data warehouse administration console for integrating Siebel source system and OBI repository and OOTB routines, build custom Subject Area, and Tasks for Type 1 and Type 2 customizations. Used DAC to load new columns and new additional tables based on the requirement
• Heavily worked on extending the Analytics Warehouse by creating new intersection tables and mappings for meeting the business requirements
• Configured the DAC Subject Areas, Tasks, Task group, Indices and implemented Configuration Tag by adding new tasks to the current execution plan to load the intersection tables as a part of extending the ware house.
• Designed, developed and edited the ETL mappings, transformations, and workflow sessions for data migration from OLTP system to OLAP warehouse application OBAW using Informatica and Data Warehouse Administration Console DAC .
• Developed the Full and Incremental ETL process i.e. lnformatica Mappings Mapplets using various Transformations Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator
• Maintained and Monitored Incremental Full load on different environments through DAC.
• Designed and developed new subject areas in the OBIEE Metadata Repository .rpd using OBIEE Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using OBIEE Presentation Services.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to existing system and made corresponding changes to OBIEE Repository, Informatica mappings and DAC Tasks and Task Groups.
• Performed extensive defect fixing on existing ETL routines and .rpd layers and also identified the areas of improvement and suggested the required changes and best practices to client and also implemented them.
• Worked on the performance tuning of various long running mappings and made appropriate changes to improve the performance and reduced the ETL run time.
• Prepared daily status and weekly status reports
• Troubleshooted the load failure cases, including database problems.
• Created technical design documents for design, implementation and testing OBIEE Analytics requests, Dashboards, Informatica Mappings and DAC tasks.
• Put together the strategies for Backup, Recovery data Purging Plans
• Established ETL and Analytics development standards and mentored 4 offshore team members on technical and functional aspect.

Environment: OBIEE 10.1.3.4.1, Siebel Financial Services 8.1, Siebel Tools 8.1,

Confidential

Sr.OBIEE Consultant

Responsibilities:

• Analyzed the business requirement reports written in SAS and converted into OBIEE reports
• Worked with Answers to create Requests, designed various report views like Table, Chart,
• Pivot Table and Narrative View, created local and global Filters and Prompts to filter the
• request and worked with column formatting functions
• Worked extensively on Answers, used the Subject Areas, Filters, Charts, Tables and Drill-downs
• for effective querying and reporting
• Analyzed the current data model and repository design and documented necessary changes and
• corrections to improve the performance of the system.
• Debugged and optimized the OBIEE Dashboards / Reports and Integrated Oracle BI Answers with
• HTML, ASP, .Net and Java Script codes in order to fulfill the reporting requirements.
• Involved in Design, Development and maintenance of catalogs, multiple ad hoc queries with
• complicated reports and different types of drilldown reports on multiple prompts selection. Troubles
• shoot and evaluated report effectiveness.
• Developed Test Plan for Unit and System Testing including resolution of bugs.

Environment: OBIEE 10.1.3.4.1, SQL ,Oracle 10g/11g, SQL Navigator, Performance center, Windows XP,

Unix

Confidential

Tech Lead/Sr.OBIEE Consultant

Responsibilities:

• Interacted with business analyst and clients to understand business requirements and updated the reports and ETL mappings as per the updated business requirements.
• Identified the changes in the Technical detailed design document TDD of both the ETL mapping and the Repository and Webcat reports/dashboards and made changes as per the updating Business requirements.
• Assisted the offshore in designing and developing the Metadata Repository .rpd using BI Server Admin
• Conducted status calls on daily basis with the Offshore team and assisted them in developing Reports / Dashboards with different Analytics Views using Answers in OBIEE.
• Implemented the changes in both object level and row level security based on roles and responsibilities of the end users and Performance Tuned of Dashboards/Reports and made recommendations for changes to database by working with the DBA's and implemented the materialized views, partitions, re-building of indexes.
• Extensively used Informatica Designer, Workflow manager and edited many complex Informatica ETL process i.e., Mappings Mapplets using various Transformations Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator and Workflows with Sessions / Tasks.
• Provide base support and trouble-shooted issues.

Environment: OBIEE 10.1.3.4.1/11g, Informatica 9.1, SQL ,Oracle 10g/11g, SQL Developer, HP

Confidential

Responsibilities:

• Assisted my supervisor in building the Inventory Management scorecards using Teradata and Informix database.
• Developed rpd metadata for custom BI reporting and designed entity relation ship joins between the facts and dimensions and created alias for the dimension, fact tables, views and materialized views when necessary OBIEE in order to improve the performance of the reports and to implement complex reports
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Created various reports along with Cross column conditional formatting feature in order to meet the needs of end users and also customized the views using Oracle BI Answers.
• Implemented Fragmentation content technique, Aggregate Navigation and indexing in order to improve the query performance
• Integrated Oracle BI Answers with HTML, ASP, .Net and Java Script codes in order to fulfill the reporting requirements and also worked with Java and HTML developers in customizing the Oracle BI reporting environment as per the client requirement.
• Migrated the changes that are done in development to test and production environments
• Performed Unit testing and load testing for both the RPD and web catalog
• Involved in the production support and Modified some of the existing reports and dashboards, and fixed of the issues related to performance, data quality etc., during production support
• Involved in maintenance and on-call support for process failures and outages
• Worked with the Main frame and unix resources both onsite and offshore teams in monitering the jobs and scripts related to data load into the db2 tables from the store database Infomix
• Assisted the Unix resources in identifying the defects in the perl scripts which were written in the Server for Accurate data load.
• Assisted the end users and explained the logic behind the calculated columns to the end users Store Managers and Market Managers
• Suggested some changes to the reports in order to improve the performance

Environment: OBIEE 10.1.3.4.1, SQL ,DB2, Teradata, Informix, Query man Teradata SQL

Confidential

Sr.OBIEE Consultant

Responsibilities:

• Worked with Business Analyst and analyzed and identified various KPI's for developing the repository and extraction of reports by meeting with the business users.
• Analyzed the specifications provided by the client, understanding the business.
• Install, configure, and administer the OBIEE platform
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include like Managers, functional heads , Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements and implemented the Cache management techniques at both Oracle BI Server and the presentation services levels as a part of performance tuning.
• Integrated OBIEE with Hyperion Essbase database.
• Involved in setting up methods of Usage Tracking and Multi User Development Environment MUDE for concurrent rpd development
• Involved in System Integration Testing SIT , User Acceptance testing UAT , Performance tuning and Production support and also Involved in leading the training sessions for the end users

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.2, Hyperion Essbase Administration Services

Confidential

Sr.OBIEE Consultant

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Validated Data Loaded by ETL Process
• Monitoring Incremental Full load through DAC.
• Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment.
• Created custom ad-hoc reports based on the data from Oracle Receivables, Payables and General Ledger
• Developed rpd metadata for custom BI reporting.
• Implemented security at the data and object levels.
• Utilized variables and initialization blocks in the repository and implemented caching to increase performance.
• Created the Interactive Dashboards, Pages and the requests.
• Worked in creating and scheduling OBIEE Reports requests using Answers and Dashboards and used BI Publisher in publishing and integrating reports with client templates from office tools
• Carried out Testing and debugging of reports
• Created OID connection using LDAP.
• Taking the backup of repository on regular intervals depending on the amount of work done.
• Scheduling iBots to the user as per the requirements.
• Provided Post Production Support

Environment: OBIEE 10.1.3.3, Oracle BI Apps 7.9.6, BI Publisher 10.1.3.3, Oracle EBS 11.5.10,

Confidential

OBIEE Consultant

Responsibilities:

• Worked closely with Business Analyst and analyzed the business requirements for new reports and modifications to old reports
• Configured Oracle Business Intelligence Application BIAPPS prebuilt repositories for Marketing sector. Including setting up Oracle Business Analytics Warehouse OBAW formerly SRMW, using Database Administration Console DAC .
• Built rpd metadata for analytical reporting on Marketing Analytics related metrics
• Created new custom reports based on the ERP Data model Order Management, Accounts Receivable, Inventory
• Created few operational reports using BI Publisher.
• Developed reports and layouts using various data sets in BI Publishers, Published various templates RTF PDF and e-text in BI Publisher.
• Involved in Administering the Physical Layer, Business Model Mapping Layer and Presentation Layer in Analytics repository.
• Used the Security settings in OBIEE Admin Tool to set up users, groups, access privileges and logging levels
• Worked in OBIEE Answers to create Requests, designed various report views like Table, Charts, Pivot, Created Column Filters and Prompts to filter the request and worked with column formatting functions.
• Created and granted privileges for the users using OBIEE Admin/ Presentation Catalog
• Configured published iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily weekly transactions to all the departments in the organization by Emails.
• Maintained extensive documentation for design, implementation and testing OBIEE Analytics requests, Dashboards.

Environment: OBIEE 10.1.3.2, BI Publisher 10.1.3.2, Oracle BI Apps 7.9.5, Oracle EBS 11.5.10, DAC 7.8

Confidential

Siebel Analytics Consultant

Responsibilities:

• Worked closely with Business Analyst, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository .rpd .
• Worked on the Time Series Wizard and implemented time comparison measures.
• Used Filters and provided Prompts appropriately to avoid excessive data showing up Reports.
• Developed many Reports / Dashboards with different Analytics Views using Answers in OBIEE.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked Extensively on Siebel Answers to create the reports as per the client requirements.
• Defined additional views narrative, pivot, chart views of the data returned by the request to visualize data in many different ways.
• Configured Intelligence dashboards by adding content such as links/images, HTML objects and folders.
• Configured published iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily weekly transactions to all the departments in the organization by Emails.
• Maintained extensive documentation for design, implementation and testing Analytics requests, Dashboards
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers.

Environment: OBIEE 10.1.3.2, Oracle EBS 11.5.9, People Soft v8.3, SQL Server 2005,

Confidential

Siebel Analytics/ Informatica Consultant

Responsibilities:

• Worked with technical project leads, marketing, sales, finance, and other business groups to identify, analyze, and document Business requirements.
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements.
• Worked extensively on Siebel applications Siebel Answers, Delivers, and Dashboards .
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Developed many Reports using different Analytics Views
• Involved in design and development of repository Creating / Modifying objects in Physical, Business and Presentation layer and the process of repository migration.
• Implemented data and object level security with the help of the Siebel Administration tool.
• Used ETL processes to accommodate changes in source systems and new requirements.
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units Update Strategy, Filter, Router, Expression, Lookup, Aggregator for loading data into Data Warehouse.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduled them to run at specified time with required frequency. Used Workflow Monitor to monitor the performance of the Jobs.
• Created and maintained metadata and ETL documentation that support business rules and detailed source to target data mappings.

.

Environment: Siebel Analytics 7.7, Informatica 7.1, Oracle 8i/9i, SQL, T-SQL, SQL Server 2005,

Confidential

Junior Oracle PL/SQL Developer

Responsibilities:

• Built a Software Requirement Specification report explaining the Application Architecture, Features and overall design.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Involved in the design of the Application using ER diagrams
• Used data modeling tools like Erwin to update the database regularly.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Created the Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms, database links, roles etc
• Created simple, complex create joins, calculated items and conditions.
• Created procedures, functions and triggers to validate and update data based user request.
• Prepared Monthly and Weekly Status Reports.
• Involved in troubleshooting the load failure cases, including database problems.
• Involved in testing, documentation and extensive support for the Implementation team

Environment: Oracle 8i/9i, SQL, PL/SQL, TOAD, Erwin, LINUX, Windows 98/2000/XP

References available upon request