SUMMARY

• Over 9 years of IT experience involving in the architecture, design and development of Data Warehousing and Business analytics Application, Data Analysis, Data Mapping, Reporting and ETL.
• Experienced in Installing, Configuring, Administering and Managing the repository (rpd), creating and configuring complex reports and role based Intelligence Dashboards using OBIEE (Siebel Analytics/ PeopleSoft).
• Experience in implementing OBIEE 11.1.1.3.0/10.1.3.4. X, Oracle BI Applications 7.9.X which include hands on expertise in RPD development, Siebel/Oracle BI Answers, BI Dashboards, BI Delivers and Reports.
• Experience in configuring Data Warehouse Administration Console(DAC) and ETL (Informatica Power Center 8.6.1/8.5.1 ) jobs.
• Worked extensively with Oracle Business Intelligence Applications that have completely pre - build BI solutions.
• Extensive experience in Object and Data levels security setup for creation of users/groups and LDAP authentication setup as per the client requirement.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local filters.
• Expertise in converting and using Oracle pre-build Rpd’s (Financial, HR, Sales, Supply Chain, Order Management, Marketing Analytics, etc.) according to business requirements.
• Expert in configuring the Dimensional modeling (Star Schemas, Snowflakes and Aggregates), Metadata Configuration, and design ETL data extraction processes apart from prebuilt.
• Expertise in configuring and scheduling BI publisher reports based on ORACLE database.
• Highly proficient in Extraction, Transformation and Loading (ETL) of data from various sources(such as OLTP Systems, Oracle E-Business Suite, Flat files)/data marts into the target systems(such as OLAP Systems, Business Analytics Warehouse(BAW)) using various tools and utilities which include Informatica Power Center 8.6.1 and DAC.
• Worked extensively in developing ETL Transformations, Informatica Designer, Informatica Workflow Manager, Informatica Workflow Monitor, and Repository Manager.
• Efficient in trouble shooting performance tuning and optimization of ETL and reporting analysis.
• Extensive experience in Oracle 11g/10g/9i, SQL Server 2000/2005 and specialized in developing, designing of Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL to improve query performance.
• Extensive experience in improving the performance of data load.
• Extensive experience in PL/SQL procedures and UNIX Shell Scripts, Data Import/Export and Conversions
• Strong Conceptual, Business Analytical skills with ability to provide work estimate and meet deadlines.
• Excellent interpersonal and technical skills to communicate with users validate requirements and excellent documentation skills with ability to learn and adopt new ideas and technologies.
• Self-Starter looking for challenges, ability to rapidly learn and apply new technologies and improve processes, Self-motivated and results-oriented.
• Highly motivated team player with good communication skills and excellent problem solving abilities and would be willing to work independently or as part of a team.

TECHNICAL SKILLS

BI Tools: OBIEE 11.1.1.3.0/10.1.3.4/10.1.3.2 Siebel Analytics 7.8.4/7.7, Oracle BI Applications 7.9.6.

ETL: Informatica Power Center 8.6.1/8.5.1 /8.1.1/8.0.7/7.1.4, Power mart 6.1/5.1.1/4.7.2.

RDBMS: Oracle 11g/10g/9i/8i, Teradata, SQL Server, MS Access, MS SQL Server 2005/2003/2000.

Oracle Tools: SQL*PLUS, SQL*Loader, SQL Developer, Oracle Reports 6i/9i/10g, BI Publisher (XML).

Scheduling tools: DAC (Data Warehouse Administration Console).

Languages: SQL, PL/SQL, XML, C, Pro*C, C++, HTML/DHTML.

Platform: Windows 98/2000/NT/XP, Windows Vista/7, UNIX, MS-DOS.

IDE: SQL Navigator, TOAD, Teradata SQL Assistance, MS Visual Studio, Erwin 7.1/4.5/4.0.

Data Modeling: Dimensional Data Modeling, Star and Snowflake Schemas.

Application Server: Web sphere Application server, OC4J, IIS, Web Logic server 10.3.3.

PROFESSIONAL EXPERIENCE

Confidential, Morristown, NJ

Lead BI Consultant

Responsibilities:

• Participated in gathering and analyzing the Business Requirements form Subject Matter Experts (SMEs), Business Analysts and Users and created the business model for generating reports/ dashboards as per the requirements.
• Primary person responsible for the development, testing, deployment and in the event of production issues related to Informatica /OBIEE.
• Experience in extracting data from Siebel CRM, Oracle EBS, OLTP, flat files and loading data to OLAP systems.
• Designed and Tested Reports in theDashboardsfor theOracle HR Analytics, Siebel Analytics and Pharma Analytics (Core and Disconnected).
• Upgraded OBIEE Version, Rpd’s, Catalogs from OBIEE10g to OBIEE11g by performing Upgrade Assistant.
• Worked on upgrade activities in all the phases like Pre Upgrade, Upgrade, Repository Merge, Post Upgrade, Testing of the upgraded system, Performance testing and modifying the batch jobs to work in the new upgraded system.
• Developed Proof of Concept reports/dashboards for review by business users and stabilized OBIEE application after upgrading to 11g by solving all the issues, errors in reports/dashboards and rpd. Provided support to business in using the latest enhancements/UI Changes in OBIEE11g.
• Managed new security model introduced in OBIEE 11g. Implemented security using Weblogic Server Administration Console by creating and setting up users and groups. Used Enterprise Manager Middleware control to create and setup Application Roles and Application Policies.
• Configuration of OBIEE Security parameters at Object level, Data level, Row level and setup Dashboard privileges based on their groups or responsibilities.
• Build Level Based/Dimensional, multiple hierarchies on single table (Time Dimension Fiscal/Calendar) and Parent-Child hierarchies, where Parent child hierarchy is introduced in OBIEE 11g.
• Configured new ODBC Connection on Linux environment for progress database (Source Database) in OBIEE 11g.
• Created a new JDBC Connection to connect to the source database (Progress Database) from BI Publisher and trained end users in creating Datasets and BI Publisher reports in different views.
• Built Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Maps Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Implemented Usage Tracking to monitor user statistics and provided simple solutions for complex/long running queries.
• Created Briefing Books and scheduled Agents/IBots to run all Dashboards and send emails after the incremental run.
• Installed and configured Oracle BI Mobile App on iPad/iPhone for executives. Technically Supporting and Providing Solutions to Ongoing Production Issues Encountered by Business Users while developing Ad-hoc Reports, Dashboards and Agents (IBots).
• Extensively used system and session variables as per the business requirements.
• Made Configuration changes to configuration files and uploaded external documents as requested by business to meet their requirements and Prepared Documents to the End users.
• Customized User Interface according to the Client Standards by creating separate skins and styles in OBIEE.
• Created Data Warehouse Reconciliation Dashboard to monitor the incremental run which includes loading files and Variances.
• Supported existing Metadata (rpd) for Multiple Projects Consumer Care, Diabetics Care and Logistics and Pharmaceuticals.
• Followed Best Practices while implementing changes and enhancements to the OBIEE Application and in order to Improve Performance worked with Cache Manager and performed load testing to test.
• Worked on Full Life Cycle of OBIEE including Answers, Intelligence Dashboards and Supporting end users in dealing with various functionalities like prompts, views, aggregates, guided navigation, customization, conditional formatting and drill-down capabilities.
• Defined training requirements for end users impacted with process re-engineering and Initiating and conducting follow up detailed workshops with business and functional teams. Mentor and trained IT staff by sharing best practices and lessons learned from past implementation efforts
• Supported system and user acceptance testing activities, including issue resolution.
• Design, developed and Debugged Extract Transform and Load (ETL) solutions for complex functional and technical requirements using Informatica PowerCenter.
• Extensively worked on performance issues related to reporting.
• Responsible for creating benchmarks for OLAP reports against which to measure the performance after report go-live.
• Configured new tasks, parameter files and Execution Plan in DAC for incremental and fill load.
• Streamlined the Execution Plans with their respective tasks in DAC.
• Monitored the Incremental & Full load throughDAC.
• Maintained the Full and Incremental loads throughDACon different environments like Development, QA and Production environment.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Designed and developed UNIX scripts for creating, dropping tables used for scheduling the jobs.
• Designed and developed PL/SQL procedures and UNIX Shell Scripts, Data Import/Export and Conversions

Environment: OBIEE 10.1.3.4.1 /11.1.1.5 , Informatica 8.6.1, DAC, Teradata, Oracle 11g databases, Siebel 8.1, UNIX, TOAD, Teradata SQL Assistance, HP Service Center

Confidential, Pittsburgh, PA

Lead BI Apps Developer

Responsibilities:

• Extensively worked on OBIEE Administrationtool to develop and enhance metadata.
• Involved in modifications ofPhysical, Business and Presentation layersof metadata repository usingOBIEE Administration Tool.
• Worked on Multi-User Development Environment (MUDE) and configured different projects.
• Implemented Out-of-the-box Analytics Reporting Functionality of Data mart Reporting.
• Incorporating Analytics will help users especially Recruiters, employer to analyze the performance of organization by Market, Finance, Manager.
• ConfiguredConnection Pools, defined joinsand implemented authorizations in the physical layer of the repository.
• Configured Schema/Diagramsusing Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Configured different types of Reports Drilldown techniques, Aggregationrules to meet client requirements.
• Configured groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Involved in managing appropriatesecurity privilegeson subject areas and dashboards according to business and User requirements.
• Implemented caching and aggregate table techniques to improve the performance.
• Identified theaggregate levelsfor each source andconfigured dimensionsources for each level of aggregates.
• Customized business reports usingBI Answersas per requirements.
• Developed, configured and tested report in the Dashboard and configured the adhoc report according to the client needs.
• Customized variousAnalytics Reportsand Dashboard Pages like Candidate Diversity, Vacancy Analysis, Recruitment Pipeline in recruitment Dashboard and Summary, Executive Summary in WFP.
• Implemented different kinds of Reports pivots, charts, tabular usingglobal and local Filters.
• Configured proactive agent’s iBots and interactive Dashboardsto alert the technical team and managers about business changes.
• Used Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.
• Expertise in implementing the Oracle BI Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica PowerCenter 8.6.1.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Loaded the data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Configured several Informatica Mappings to populate the data from Oracle,DB2,and SQL Server into dimensions and fact tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Migrated Test Code from Development to QA and QA to Production of Repository, Dashboard Reports, Informatica mappings and workflows and DAC entities.
• Hands on experience in the administration of creating new ids, Account modification of existing users, Password reset and Deletion of accounts.
• Monitored the Mainframe jobs, NDM status review jobs and production ETL’s incremental and full load run during the post production.
• Validated the data/Reports each and every time a migration occurs from Dev to QA and QA to Production environment.
• Managed dashboard flow of existing employee transfers, salary increases, adjustments and terminations to insure processing as well as process new hire in the Recruitment
• Responsible for updating/ tracking and documenting the development changes at both ETL level and rpd level.
• Configured new tasks, parameter files and Execution Plan in DAC for incremental and fill load.
• Streamlined the Execution Plans with their respective tasks in DAC.
• Monitored the Incremental & Full load throughDAC.
• Maintained the Full and Incremental loads throughDACon different environments like Development, QA and Production environment.
• Performed Unit and Regressive testing during development of reports and dashboard.
• Actively resolved the issues and defects raised by the tester during SIT and UAT testing phrases.
• Attended daily status meetings, department meetings and defect review meetings.
• Documented the complete project details like Best Practices, development standards, promotion and demotion policies and migration standards.

Environment: OBIEE 10.1.3.4,Oracle BI Applications, PeopleSoft HR Analytics, Informatica 8.6.1, DAC 10.1.3.4.1 , Oracle 10g, UNIX, SQL Developer, SQL*Plus, Toad, Windows XP, PUTTY, Host Extreme.

Confidential, Mountain View, CA

Sr. OBIEE Developer

Responsibilities:

• Installed and Implemented OBIEE 11g in Development and QA Environment.
• Involved in gathered the requirement, completed the proof of concept, Designed, Developed/Implemented and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE 11g.
• Worked extensively on various Cache Management techniques to increase the performance of the reports.
• End to End repository creation, reports creation, prompts, dashboards and data modeling in OBIEE 11g on Oracle 11g database.
• Configured templates for presenting results and analytics views modified the Siebel/OBI dashboard using cascading style sheets.
• Implemented Performance tuning of Dashboards/Reports and made changes to database by implementing the materialized views, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Worked on Multi-User Development Environment (MUDE) and created different projects.
• Developed and debugged many dashboards using different analytics views (Pivot Table, Pie/Bar Chart, View/Column Selector and Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local filters.
• Extensively used OBIEE Delivers and iBots.
• Experience in extracting data from Siebel CRM, Oracle EBS, OLTP, flat files and loading data to OLAP systems.
• Designed and Tested Reports in theDashboardsfor theOracle HR Analyticsmodules likeCompensation, HR performance, Retention and Workforce Profile.
• Assists in Self Service HR and Self Service benefits configuration and troubleshoot customization issue.
• Provided HR, Benefits and Salary base table and column information to technical team and assists them in defining OBIEE Repository requirements, and defines design and content requirements for Dashboards.
• Implemented Out-of-the-box Analytics Reporting Functionality of Siebel CRM Data mart Reporting. Incorporating Analytics will help users especially Sales and Installation Managers to analyze the performance of Sales Rep, Installers and Leads generated by Market.
• Configured the OBIEE environment for Development, QA and Production environment.
• Worked on High Level Design and Detail Design for OBIEE 11g.
• Implemented, Configured and Tested Data security and Dashboard security in OBIEE 11g.
• Implemented Security by configuring roles and web groups using LDAP Authentication in OBIEE 11g.
• Configured Workflows to Schedule and Trigger Mappings.
• Implemented Look Ups to Identify Data as per the predefined Criteria / Business Rule and Update Strategy to update tables.
• Developed, Configured and implemented Mapplets and Repeated functionalities.
• Configured Event Polling for clearing the stale cache.
• Implemented different transformations to develop Mappings such as Joiner, Aggregator, Router and Expression.
• Attended defect review meetings and weekly status meeting.

Environment: OBIEE 11.1.1.3.0/10.1.3.4. 1, Informatica 8.6.1, DAC 10.1.3.4, Oracle BI Apps 7.9.6, Oracle 11g, Siebel Call Center(CRM), BI Publisher, Windows 7, TOAD, SQL Developer.

Confidential, New York, NY

OBIEE/ Informatica Developer

Responsibilities:

• Developed OBIEE Repository (.rpd) with all the three layers: Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Implemented the business rules such has Dimensional Hierarchies, Aggregate Navigation, Level Based Measures and Cache Management in Business Model and Mapping Layer.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Configured global filters, complex queries, prompts, reports (charts, tables, graphs) in Answers.
• Used Catalog Manager to maintain Analytics web catalog to manage dashboards and answers.
• Implemented Out-of-the-box analytics reporting functionality and successfully implemented OBIEE delivers/configured proactive agents (iBots) and configured interactive dashboards to alert the Business/Field users as per the requirements.
• Used analytics scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by Email.
• Set up LDAP and SSO on security for users and groups based on the individual and group responsibilities.
• Experienced in deploying Informatica workflows to the DAC and build dependency and dependent hierarchical tasks.
• Involved in Unit testing and documentation.

Environment: OBIEE 10.1.3.2, Informatica Power Center 8.6.1, Erwin, Oracle 10g, Oracle R12 TOAD, DAC, MS SQL Server 2005, UNIX, Windows XP, Siebel Call Center(CRM),DB2, Oracle SQL Loader.

Confidential, Dallas, TX

OBIEE Consultant

Responsibilities:

• Involved with management professionals, analysts as well as other business teams on requirement gathering.
• Customized and developed the OBIEE Physical Layer, Business Model and Mapping layer.
• Implemented complex requirements like dimension hierarchies, time comparisons, share measures along with rank measures and change data capture, slowly changing dimension design.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Implemented logical column measures and calculations with well expertise in the Business Model and Mapping layer.
• Implemented caching and aggregate table techniques to improve the performance.
• Created, modified and formatted requests, along with charts and filters in OBIEE Answers.
• Created, modified, and administered analytics intelligence dashboards with links to web sites; HTML text; links to documents; and embedded content such as images, text, charts, and tables.
• Worked with Informatica Designer tool in customizing and developing mappings in SRMW to extract and load data.
• Worked with Transformation developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Environment: OBIEE 10.1.3.x, Siebel Business analytics 7.8.9, Oracle 10g, Informatica Power Center 7.1.

Confidential

Siebel Analytics Developer

Responsibilities:

• Imported Physical Tables and defined relations in Physical Layer in Siebel Analytics.
• Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.
• Created Drill down Hierarchies and implemented Business Logics for Facts.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table)
• Created Pivot Tables and manipulated Init Blocks for report analysis
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Performed performance tuning by optimizing Target, Source, Mapping and Session.

Environment: Siebel Analytics 7.X, Oracle 8i, Informatica Power Center 6.2, MS-Access, Windows 2000.

Confidential

PL/SQL Developer

Responsibilities:

• Studied and analyze the business requirements.
• Wrote Stored Procedures to encapsulate Business processes
• Wrote procedures, Database Triggers, functions and package using PL/SQL,
• Formatted the reports with different fonts dynamically using SRW Package.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Prepared test plans for various modules.
• Design and implementation of Reports.
• Added the triggers in form level, block level and Item level.
• Prepared user manual and technical support manuals.

Environment: Oracle 8i, SQL*Loader, PL/SQL, Windows 2000.