PROFESSIONAL SUMMARY

• Around 8 years of extensive experience in Data warehousing and Data Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL and Reporting on Windows and UNIX platforms.
• Strong experience in OBIEE 11.1.1.6/10.1.3.x, which includes design and development of OBIEE repositories at three levels Physical Layer, Business Model and Presentation Layer .
• Involved in Data Modeling techniques like normalization, denormalization, Star Schema/Snowflake modeling, Fact and Dimensions tables, Physical and logical data modeling.
• Experience in Oracle BI Apps that include OBIEE,ETL Tools and in Banking, Financial and Insurance domains. Proficient in the Design and customization of BI Answers/ Analysis, Reports, Dashboards, Oracle delivers
• 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.
• 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 debugging, optimizing the Performance Tuning of Oracle BI Repository Dashboards / Reports and Informatica / Mappings / Workflows.
• Experience in setting up a Multi-User Development Environment MUDE .
• Experience in complete Software Development Life cycle SDLC including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing Dimensions for accessing the full history of accounts and transaction information.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Experience in integration of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, CSV files, COBOL files, XML, DTD, XSD files, legacy system files etc.
• Experience in configuring Security Settings groups, roles, access/query/report privileges and scheduling Agents for OBIEE 10g and OBIEE 11g.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading
• Involved in fixing bugs in production environment and was a part of the production support team.

TECHNICAL EXPERTISE

Confidential

Role: OBIEE Developer

Responsibilities:

• Analyze and document business process, user requirements, and functional needs and provide innovative solutions
• Translated the Functional Specifications to Technical Reporting Requirements.
• Design and Develop Metadata required for reports.
• Administered the OBIEE web catalog and repository.
• Installation of 11.1.1.7 on the Development and new training windows environments for initial evaluation.
• Configure Windows Native Kerberos Active Directory Authentication.
• Configure SSO with WNA.
• Experience in upgrading from 11.1.1.6.5 to 11.1.1.7.
• Set up Business End Users with appropriate application roles.
• Modified existing analyses, dashboards and creating new analyses.
• Consolidated and redesigned the existing dashboards and analyses.
• Documented the Design Standards used for presentation, repository elements. Presentation Folder Structuring, Measure alignment and format, Attributes alignment and format.
• Designed and Developed Data Load Status and Availability Reports for Operations and Maintenance.
• Created Usage Tracking Reports for monitoring the usage of the reports.
• Build test scripts to thoroughly test the accuracy and completeness of reports
• Understand the business process and the technical solution OBIEE reporting solution implemented to address the business needs.
• Work extensively with the ETL/DB team to improve the performance of long running queries.
• Analyze and determine the impact of technology capabilities and limitations, translate high level design to detailed design specifications, develop, test and deploy code/application in various environments.
• Perform effort estimation for various Data Warehouse activities meet project deliverables as per requirements, on time within budgets.
• Technical development of all OBIEE system objects needed, including developing OBIEE subject areas, measures, attributes, filters, dashboards and analysis.
• Monitored usage and performance of the reporting environment and suggest and help design and implement the steps to improve the performance.
• Responsible for 2nd level technical end-user support, which may include telephone technical support, complex user report creation, promoting end-user created objects to the sharable system level, managing the application server and web server software versioning, and troubleshooting any system failures.

Environment: OBIEE 11.1.1.6.5 Informatica 8.1.6, Oracle SQL Developer, SQL Server 2000, Windows NT.

Confidential

Role: OBIEE Developer

Responsibilities:

• Worked with End users and oracle support in resolving many product issues.
• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Analyzed the specifications provided by the client, understanding the business.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables 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, Aggregate levels for the dimensions.
• Developed different brand level 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 reports to fulfill the marketing needs and customized the views 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.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Siebel Analytics Web / Oracle BI Presentation Services.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards answers.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Implemented Multi User Development Environment MUDE forconcurrentrpd development
• Involved in System Integration Testing SIT , User Acceptance testing UAT and Production support.

Environment: OBIEE 11.1.1.5, BI Publisher 11.1.1.5, Oracle 11g, SQL, SQL Server 2005, SQL Developer, Windows XP, UNIX

Confidential

Role: OBIEE Consultant

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Analyzing and understanding different sources and target.
• Involved in daily, weekly loading of data from Flat files and other sources into the EDW by applying business logic on transformation mapping.
• Developing Mappings as per the design document with proper naming conventions for transformations and Mapping.
• Extensively worked on different types of transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Joiner Transformations and SQL Override.
• Created Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Extensively worked on Administration tool to build Physical Model, Business Model and presentation layer and established relationships.
• Created dimension hierarchies to achieve the drill down functionality.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled Slowly Changing dimension data.
• Extensively worked with BI Answers to create various reports such as Drill down, Chart, Pivot, Narrative Reports etc as per the client requirements.
• Created, modified, and administered BI Dashboards with links to web sites, HTML text, and links to documents and embedded content such as images, text, charts, and tables.
• Implemented Prompts to provide dynamic filter condition to End users.
• Used BI Publisher to create checks, sales and marketing letters, Financial Statements etc.,
• Created proactive agents iBots using BI Delivers and interactive dashboards to alert the agents.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Environment: OBIEE 11.1.1.5, BI Publisher 11.1.1.5, InformaticaPowerCenter 8.6/8.1.1, Oracle 11g, SQL, PL/SQL, TOAD, UNIX Shell Script, UNIX, Windows XP

Confidential

Role: OBIEE/ETL Consultant

Responsibilities:

• Creation of the design documents and test cases for Informatica mappings.
• Worked closely with executive sponsors and user decision makers to develop the transformation logic to be used in Informatica.
• Created different transformations for loading the data into targets like Source Qualifies, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expression, Aggregator.
• Worked on OBIA - Financial and Supply Chain and Order Management Analytics.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance gains.
• Created multiple aggregated tables and setup aggregated navigation to enhance performance.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Scheduling and Loading data process and monitoring the ETL Process using Autosys.
• Extensivelyused Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
• Performance Tuning of SQL queries, views etc.
• Scheduled and monitored jobs using UNIX Shell Scripting.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Used and developed Shell Scripts used for Pre and Post Session commands for the developed Mappings and scheduling

Environment: OBIEE 10.1.3.4,Informatica 8.1, Oracle 10g, SQL Server 2000,flat files, UNIX shell scripting, Windows XP, OBI Apps FI SCM

Confidential

Role: OBIEE Consultant

Responsibilities:

• Responsible for full life cycle implementation of OBIEE
• Participated in user meetings to understand the requirements
• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Created Alias Tables, Views and Dimensional Hierarchies.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Implemented external table security with session variables, tested and validated the business model and repository level calculations using Oracle BI Administration tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics.
• Developed standard and custom SAP BW reports in OBIEE
• Performed Customization of dashboards
• Developed 11 Dashboards / 53 Reports using different Views Table, Pivot Table, Chart and Column Selector , with guided navigation and dashboard and page prompts.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog
• Developed and modified reports in BI Publisher
• Performed unit testing of the reports
• Involved in UAT.

Environment: Oracle 11g, SAP BW, OBIEE 10.1.3.4, Oracle BI Apps Supply chain Analytics , BI Publisher, ODI 10.1.3.5, SQL Developer, UNIX.

Confidential

OBIEE Consultant

Responsibilities:

• Worked as a Discoverer Administrator by handling Move docs to Production, Registering Functions, Creating List of Values, Sharing, Scheduling Workbooks, Maintaining End User Layer, Resolving Connection Issues and Trained developers on move docs.
• Migrated many Discoverer reports and Oracle Custom Reports from 11.0.3 to 11.5.10 in AP, AR, GL and OM modules.
• Worked on creating Oracle Reports9i, XML Reports from scratch and customized lot of standard reports according to the client requirements.
• Creating star schemas, aggregates and general data architecting. Master data management MDM approaches metadata management.
• Migration of Discoverer Business Area to OBIEE Repository.
• Evolving standards and processes for customization of OBIEE RPD andETL of Informatica of out-of-the-box product.
• Educating Users and Development team on Oracle EBS Functionality to evolve solution integrated with EBS.
• Developing Security model by re-using Oracle EBS functionality for OBIEE and integration of Oracle EBS and OBIEE.
• Design, development and testing of new Informatica ETL adaptors for Oracle EBS to Analytics Data warehouse.
• Installed and Configured OBIEE platform, application, DAC and Informatica Power Centre 7.1.x and 8.1.1.
• Data reconciliation during ETL data load of Financials, Human Resource and Supply Chain data from Oracle Applications.
• Customized pre-defined dashboards as per the requirements given by the client.
• Worked with Oracle Engineering directly to resolve issues and bugs working with Oracle EBS 11i, Oracle BI Applications 7.9.3, Informatica, Oracle DB 10g, etc.
• Played an important role in the team and worked as a good team member.

Environment: Oracle Apps 11i 11.5.10 , GL, AP, FA, PO Oracle 10g, Pl/SQL, SQL Plus, SQL Loader, Forms 9i, Reports 9i, TOAD, Discoverer 10g, Performance Tuning, Windows XP, UNIX, OBIEE 10.1.3.2, Oracle BI applications 7.9.3, Informatica 7.1.4, DAC Data warehouse Administration Console .

Confidential

OBIEE Consultant

Responsibilities:

• Participated in User Meetings to understand the requirements.
• Worked closely with the data modeler in creating logical data model Star Schema .
• Built the OBIEE repository/metadata Physical Layer, Business Model and Mapping Layer and Presentation Layer and created the subject area where reporting and analysis are centered around.
• Developed calculated measures and dimension hierarchies in the Business Model and Mapping Layer
• Configured web catalog objects Dashboards, Pages, Folders, Reports
• Implemented data level and object level security.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization's and product's hierarchies
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generated Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog.
• Assisted in creation of pivot table requests allowing manager's to analyze the business/data from different perspectives.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Installed and configured Oracle BI Publisher and integrated it with Oracle BI Presentation services.
• Developed and modified reports in BI Publisher.
• Extensively used SQL queries, Procedures, Triggers.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Environment: Oracle 10g, Informatica 8.1.1, OBIEE 10.1.3.2, BI Publisher, Toad, SQL, SQL Loader, PL/SQL Procedures, Windows 2000

Visage mobile, India Aug 2006 - Feb 2008

Role: Informatica/ Oracle Developer

Responsibilities:

• Assisted in Design of physical logical models using Erwin Data Modeler
• Interface with Sales and Production Management Team to capture and analyze business strategic requirements.
• Developed many mappings / mapplets using various transformations for extract and loading the sales data.
• Created sessions and batches for executing the mappings. Scheduled the batches through cron job.
• Involved in the performance tuning of mappings.
• Provided support to report developers in developing the reports.
• Wrote Event Triggers, PL/SQL Program Units for Reports for Client Validations
• Wrote Database procedures, Packages, functions to handle data manipulations and Computations on Server.
• Designed and developed Oracle Monthly Reports.
• Created Materialized views to calculate aggregated data, such as a sum of monthly revenue.
• Developed Database Objects - Triggers, Packages, Procedures and functions.
• Modified, Maintained and Developed the SQL,PL/SQL codes to develop new enhancements
• Develop and maintain the documentation to support the team and business
• Responsible for the fixation of the errors in data as part of testing

Environment: Oracle 9i/8i, SQL Server 2000, Informatica Power Center 7.1, UNIX Scripting Ksh , Sun Solaris 7, Windows XP Professional