SUMMARY:

• Over 7.5 yearsof IT experience involving in the architecture, design and development of Data Warehousing and Business analytics Application, Data Analysis, Data Mapping, Reporting and ETL.
• Experienced inInstalling, Configuring, AdministeringandManagingthe repository (rpd), creating and configuring complex reports and role basedIntelligence Dashboardsusing OBIEE (Siebel Analytics/ PeopleSoft).
• Experience in implementingOBIEE 11.1.1.3.0/10.1.3.3.X,Oracle BI Applications7.9.Xwhich include hands on expertise inRPDdevelopment, Siebel/OracleBI Answers,BIDashboards,BIDeliversandReports.
• Experience in configuringData Warehouse Administration Console(DAC)andETL(Informatica Power Center 8.6.1/8.5.1) jobs.
• Worked extensivelywithOracle Business IntelligenceApplicationsthat have completely pre-build BI solutions.
• Extensive experience inObjectandDatalevelssecurity setup for creation of users/groups and LDAP authentication setup as per the client requirement.
• Extensive experience in configuringInteractive Dashboardswith drill-down capabilities using global and local filters.
• Expertise in converting and usingOracle pre-build Rpd’s(Financial, HR, Sales, Supply Chain, Order Management, Marketing Analytics, etc.) according to business requirements.
• Expert in configuring theDimensional modeling(Star Schemas, Snowflakes and Aggregates), Metadata Configuration, and design ETL data extraction processes apart from prebuilt.
• Expertise in configuring and schedulingBI publisherreports based on ORACLE database.
• Highly proficient inExtraction, 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 includeInformatica Power Center8.6.1andDAC.
• 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 inOracle 11g/10g/9i, SQL Server 2000/2005and specialized in developing, designing of Stored Procedures/Packages, Database Triggers, Cursors usingSQL, PL/SQLto improve query performance.
• 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 skillswith 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:OBIEE11.1.1.3.0/10.1.3.4/10.1.3.2Siebel Analytics7.8.4/7.7, Oracle BI Applications7.9.6.
ETL:Informatica Power Center8.6.1/8.5.1/8.1.1/8.0.7/7.1.4, Power mart6.1/5.1.1/4.7.2.
RDBMS:Oracle11g/10g/9i/8i, 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, MS Visual Studio, Erwin 7.1/4.5/4.0.
Data Modeling:Dimensional Data Modeling, Star and Snowflake Schemas.
Application Server:Websphere Application server, OC4J, IIS, Web Logic server10.3.3.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA June 2011- Present
BI Apps Developer (HR Analytics)

Confidential is a highly diversified and growing financial services organization spanning the retail, business and corporate markets. One of the largest financial services companies in the country, who offers personal banking services, asset management, residential mortgage banking and corporate and institutional services for organizations. With recent acquisitions, CONFIDENTIAL’s reach has significantly expanded, further enhancing of career opportunities.
Primary CONFIDENTIAL operations include Retail Banking, Corporate and Institutional Banking, Mortgage, Global Investment Servicing, Asset Management, and Midland Loan Services.

Responsibilities

• Extensively worked onOBIEE Administrationtool to develop and enhance metadata.
• Involved in modifications ofPhysical, BusinessandPresentation layersof metadata repository usingOBIEE Administration Tool.
• Worked onMulti-User Development Environment(MUDE)and configured different projects.
• Implemented Out-of-the-box Analytics Reporting Functionality ofData martReporting. 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.
• ConfiguredSchema/Diagramsusing Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Configured different types ofReports Drilldowntechniques,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 andconfigureddimensionsourcesfor each level of aggregates.
• Customized business reports usingBI Answersas per requirements.
• Developed, configured and tested report in the Dashboard and configured theadhocreport according to the client needs.
• Configured numerous executive level reports.‘Dashboards’were generated to provide insight into the Human Capital Metrics/Headcount and Turnover/Recruitment data coming from PeopleSoft.
• Customized variousAnalytics ReportsandDashboard Pageslike 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’siBots and interactive Dashboardsto alert the technical team and managers about business changes.
• Used Analytics Scheduler to configureDeliversandiBotsto notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.
• Expertise in implementing theOracle 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 Nov 2010- May 2011
Sr. OBIEE Developer

Confidential provides tax and accounting software solutions to both Full-Service and Tax-Driven Accounting Professionals. Confidential's Accounting Professionals Division (APD) is a leading provider ofprofessional tax and accounting products andsolutions. The APD IT is an enabling partner that teams with the business to provide platforms and infrastructure that enable accounting professionals tobe more productive and grow their practices.
The aim of this project is to constantly implement and support OBIEE Application in production environment and regular enhancements as needed by end users.

Responsibilities:

• Installed and Implemented OBIEE 11g in Development and Test Environment.
• Configured LDAP authentication.
• 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.
• Designed and implemented an interactive dashboard to launch enterprise reports based on user privileges.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• 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.
• Developed Configured and Tested Report in the Dashboard and configured the adhoc report according to the client needs.
• Configured the OBIEE environment for Development, QA and Production environment.
• Migrated the 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 id’s, Account modification of existing users, Password reset and Deletion of accounts.
• 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 Update Strategy to update tables.
• Implemented Look Ups to Identify Data as per the predefined Criteria / Business Rule.
• Developed, Configured and implemented Mapplets and Repeated functionalities.
• Configured Primary keys using Sequence Generator.
• 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, NYC, NY Sept 2009 –Oct 2010
Sr. OBIEE Developer
Confidential is a major global financial services provider engaged in retail banking, credit cards, corporate banking, investment banking, wealth management and investment management services, with an extensive international presence. Confidential implemented OBIEE for the development of the financial analytics data warehouse for developing dashboards and reports for analysis of General Ledger, Payables and Receivables.

Responsibilities:

• Interacted with business representatives for gathering requirement analysis and to define business and functional specifications.
• Build OBI Metadata Repository (.rpd) using OBIEE Administrator tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool.
• Build multiple Dimensions (Drill-Down Hierarchies), Logical and Facts/Measures objects in Business Model Layer.
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Developed time series objects for comparing the usage variations between the current and previous years and months.
• Build the presentation catalogs in Presentation Layer.
• Configured presentation catalogs for exposing both stored and calculated measures and dimensions to users for Ad-hoc reporting.
• Administered Nqsconfig.ini and Instanceconfig.xml configuration files.
• Used BI Publisher to configure various interactive financial analytics related drillable by region, customer and time. Reports were provided in several Confidentialive and visually appealing formats such as Charts, Graphs, Tables, PDF.
• Build BI Delivers to implement E-Mail alerts that depend on various measures and metrics.
• Worked with Financial Analytics Subject Areas:
• Financials - AP Balance, Financials - AP Invoice Aging, Financials - AP Transactions, Financials - GL Balance Sheet, , Financials - GL Cash Flow, Financials - GL Detail Transactions.
• Worked with Financial Analytics Dashboards:
• General Ledger: Overview, Balance Sheet, Cash Flow, Budget vs. Actual, GL Balance.
• Payables: Overview, AP Balance, Payments Due, Effectiveness, Payment Performance.

Receivables: Overview, AR Balance, Payments Due, Effectiveness, Payment Performance, Customer Report Invoice Details, All AR Transactions.

• Core HR – Business Group and Key Flexfield definition, Job Design and Benchmarking, EEO Reporting, Positions, Grades, Grade Steps, People Group, Costing, Individual Compensation Distribution, Assignment setup, Salary Management, Elements, Element links, Fast Formula, Special Information types (SITs), Extra Information types (EITs), Attachments, Absences and Accruals, FastFormulas, Salary Basis and Payroll, Organization Design, Position Hierarchy, Custom Reports, Lists, OBIEE Dashboard and Repository
• Self Service HR (SSHR) and Manager Self Service (MSS) – Self Service functions configuration, Supervisor approvals, Framework Personalization, Employee Self-Service, Manager Self-Service and Benefits Self Service Rollouts.
• HR Intelligence (HRI): Knowledge of basic setup of the HRI including Manager, HR Manager and Chief HR Officer Dashboard.
• Developed Mappings and Workflows using various transformations (Update Strategy, Router, Expression, and Aggregator) for extracting the billings data from Oracle Applications.
• Performed unit, integration, and regression testing to validate report and mapping functionality.
• Worked closely with users, developers and administrators to resolve ongoing production problems by reviewing design changes made to production systems.
• Experience in using DAC to configure, monitor and schedule ETL routines.

Environment: OBIEE 10.1.3.4.1, DAC 10.1.3.4, Oracle BI Apps 7.9.6, Oracle 10g, Informatica 8.6.1, BI Publisher, Windows XP, SQL Developer, SQL*Plus

Confidential, New York, NY June 2008 - Aug 2009
OBIEE/ Informatica Developer

Confidential is one of the nation's largest international insurance and financial services operations and is a leading provider of automobile and homeowners coverage’s commercial property and casualty insurance, investment products, employee benefits. The project was to centralize decision making system as part of data management which involved integrating and simplifying by using OBIEE and providing composite and meaningful views to users.
Responsibilities:

• Coordinated with Business Analysts in gathering and analyzing the user requirements.
• Developed physical and logical star schema using OBIEE administration tool.
• Developed OBIEE Repository (.rpd) with all the three layers: Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Developed dimensional hierarchies based on the business requirement of an attribute.
• Used the Expression Builder utility to configure new logical columns in the BMM layer and configured various calculation measures.
• Configured repository and session variables to get dynamic reports and dashboards.
• Implemented the business rules such has Dimensional Hierarchies, Aggregate Navigation, Level Based Measures and Cache Management in Business Model and Mapping Layer.
• Setup and administered usage tracking using the direct insert process.
• 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.
• Configured Interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• 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.
• Expertise in implementing the Oracle BI Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experienced in deploying Informatica workflows to the DAC and build dependency and dependent hierarchical tasks. Streamlined the Execution Plans with their respective tasks in DAC.
• Extensively used ETL to load data from multiple sources to staging area (Oracle) using Informatica Power Center 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.
• Worked with pre and post sessions, and extracted data from transaction system into staging area with the knowledge of identifying facts and dimensions tables.
• Worked on 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.
• 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
• Involved in Unit testing and documentation.
• Migrated from development to production, production to test environment.

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 October 2007- May 2008 OBIEE Consultant
Confidential is dedicated to leading our industry - in customer satisfaction by providing consistently high-quality service; in innovation by developing and marketing new systems, products and services; in profitability by demanding efficiency; and in growth by searching out domestic and international opportunities.

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.
• Effectively managed ODBC connections and imported the Physical tables, keys and foreign keys.
• Identified facts and dimensions according to the design specification.
• Architected and implemented change data capture and slowly changing dimension design.
• Implemented complex requirements like dimension hierarchies, time comparisons and share measures along with rank measures.
• 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.
• Tested and validated the repository integrity with global consistency check feature.
• Worked extensively on OBIEE Presentation Services to create the reports as per the client requirements.
• Created, modified and formatted requests, along with charts and filters in OBIEE Answers.
• Developed various kinds of reports in various views for better user readability.
• 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.
• Created various user groups and assigned them appropriate permissions and privileges.
• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• 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.
• Monitored the Informatica jobs which will load the data from OLTP to OLAP.
• Fine-tuned Informatica jobs by optimizing all transformations.

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

Confidential, Framingham, MA November 2006-September 2007
Siebel /OBIEE Developer

The project was in sales department to develop and provide better decision in sales analysis, on developing reports for measuring sales activity of products. The project involved customizing sales application by implementing reporting system by using OBIEE, Informatica and Oracle database.

Responsibilities:

• Gathered requirements, functional and technical specifications and interacted with business managers and end users.
• Used Oracle BI administration tool to create repository (.rpd) and build Physical Layer, Business Model and Mapping Layer and Presentation Layers.
• Identified and created aggregate tables to improve query performance.
• Created dimensional hierarchies and level based measures in the BMM layer.
• Designed various reports i.e. Pivot, Narrative and Chart views reports in Answers and developed intelligent dashboards for different groups of users to view across regions, customer demography with the facility to drill downs and charts.
• Configured Intelligence dashboards by adding content such as links/images, HTML objects and folders.
• Developed custom dashboards and reports using OBIEE Answers.
• Scheduled the developed reports according to client requirements.
• Created proactive agents called iBots to alert the related team to notify about the business changes.
• Tested and validated the repository, reports and dashboards.

Environment: Oracle/Siebel 7.8, Informatica Power Center 7.1, Windows XP, and Oracle10g, SQL Server 2000/2005.

Confidential, April 2004-September 2006

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.
• Involved in migration of mappings / workflows from Development to Testing and to production.

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

Confidential Dec 2003 - March 2004
PL/SQL Developer

Responsibilities:

• Studied and analyze the 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.
• Developed Stored Procedures to encapsulate Business processes
• Writing procedures, functions and package using PL/SQL.
• Writing Database Triggers, Program units.
• Formatting 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.
• Designing and implementation of Reports.
• Adding 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.

EDUCATION

• Bachelor’s in Electronics and Communications Engineering