SUMMARY

• Over 9 years of IT experience involving in teh 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 teh 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 has 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 teh 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 teh 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 teh 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 teh 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, Pittsburg, PA

Lead BI Consultant

Responsibilities:

• Participated in gathering and analyzing teh Business Requirements form Subject Matter Experts (SMEs), Business Analysts and Users and created teh business model for generating reports/ dashboards as per teh requirements.
• Primary person responsible for teh development, testing, deployment and in teh 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 teh phases like Pre Upgrade, Upgrade, Repository Merge, Post Upgrade, Testing of teh upgraded system, Performance testing and modifying teh batch jobs to work in teh 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 teh issues, errors in reports/dashboards and rpd. Provided support to business in using teh 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 teh 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 teh 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 teh business requirements.
• Made Configuration changes to configuration files and uploaded external documents as requested by business to meet their requirements and Prepared Documents to teh End users.
• Customized User Interface according to teh Client Standards by creating separate skins and styles in OBIEE.
• Created Data Warehouse Reconciliation Dashboard to monitor teh 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 teh 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 teh performance after report go-live.
• Configured new tasks, parameter files and Execution Plan in DAC for incremental and fill load.
• Streamlined teh Execution Plans with their respective tasks in DAC.
• Monitored teh Incremental & Full load throughDAC.
• Maintained teh Full and Incremental loads throughDACon different environments like Development, QA and Production environment.
• Tuned sources, targets, mappings and sessions to improve teh performance of data load.
• Designed and developed UNIX scripts for creating, dropping tables used for scheduling teh 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-teh-box Analytics Reporting Functionality of Data mart Reporting. Incorporating Analytics will help users especially Recruiters, employer to analyze teh performance of organization by Market, Finance, Manager.
• ConfiguredConnection Pools, defined joinsand implemented authorizations in teh physical layer of teh 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 teh repository and added users to teh 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 teh 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 teh Dashboard and configured teh adhoc report according to teh client needs.
• Configured numerous executive level reports.‘Dashboards’were generated to provide insight into teh Human Capital Metrics/Headcount and Turnover/Recruitment data coming from PeopleSoft.
• 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 teh technical team and managers about business changes.
• Used Analytics Scheduler to configure Delivers and iBots to notify teh corporate managers and region managers immediately about teh messages. Generated iBot alerts for reports to be delivered by email.
• Expertise in implementing teh 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 teh Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Loaded teh data in incremental fashion by using batches & sessions on Informatica Server Manager.
• Configured several Informatica Mappings to populate teh data from Oracle,DB2,and SQL Server into dimensions and fact tables.
• Tuned sources, targets, mappings and sessions to improve teh 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 teh administration of creating new ids, Account modification of existing users, Password reset and Deletion of accounts.
• Monitored teh Mainframe jobs, NDM status review jobs and production ETL’s incremental and full load run during teh post production.
• Validated teh 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 teh Recruitment
• Responsible for updating/ tracking and documenting teh 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 teh Execution Plans with their respective tasks in DAC.
• Monitored teh Incremental & Full load throughDAC.
• Maintained teh 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 teh issues and defects raised by teh tester during SIT and UAT testing phrases.
• Attended daily status meetings, department meetings and defect review meetings.
• Documented teh 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 gatheird teh requirement, completed teh 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 teh performance of teh 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 teh Siebel/OBI dashboard using cascading style sheets.
• Implemented Performance tuning of Dashboards/Reports and made changes to database by implementing teh materialized views, re-building of indexes, overwriting teh 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-teh-box Analytics Reporting Functionality of Siebel CRM Data mart Reporting. Incorporating Analytics will help users especially Sales and Installation Managers to analyze teh performance of Sales Rep, Installers and Leads generated by Market.
• Configured teh 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 teh predefined Criteria / Business Rule and Update Strategy to update tables.
• Developed, Configured and implemented Mapplets and Repeated functionalities.
• Configured Event Polling for clearing teh 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 teh three layers: Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Implemented teh 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-teh-box analytics reporting functionality and successfully implemented OBIEE delivers/configured proactive agents (iBots) and configured interactive dashboards to alert teh Business/Field users as per teh requirements.
• Used analytics scheduler to configure Delivers and iBots to notify teh corporate managers and region managers immediately about teh messages. Generated iBot alerts for reports to be delivered by Email.
• Set up LDAP and SSO on security for users and groups based on teh individual and group responsibilities.
• Experienced in deploying Informatica workflows to teh 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 teh 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 teh repository building and modification procedures.
• Implemented logical column measures and calculations with well expertise in teh Business Model and Mapping layer.
• Implemented caching and aggregate table techniques to improve teh 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 teh business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in teh 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 teh business requirements.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequence, grants and synonyms.
• Wrote Stored Procedures to encapsulate Business processes
• Wrote procedures, Database Triggers, functions and package using PL/SQL,
• Formatted teh reports with different fonts dynamically using SRW Package.
• Optimized teh 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 teh 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.