SUMMARY

• Over Eight years of progressive experience in the IT industry with prime focus on Analysis, Design, Deployment, Development, Customization, and Maintenance of various Business Intelligence Applications in an effective way to deliver leading edge software solutions.
• Involved in all phases of design, development, and implementation of Business Intelligence solutions and my areas of expertise include BI Apps 7.9.x, Business Analysis, Dimensional Modeling, Repository Management (RPD), Testing Processes, Extraction Transformation and Load (ETL) using tools like Informatica Power Center 8.6.1/8.1.1/7. x, expertise in Data Warehouse Administration Console (DAC) 10.1.3.4.1 /7. x to configure, monitor and schedule ETL and implementing Business Intelligence reporting solutions using Oracle BIEE10.1.3.x, Siebel Analytics 8.x/7.x.
• Expertise in complete Systems Development Life Cycle (SDLC) Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology.
• Good Knowledge of Web Application Development Technologies such as HTML, DHTML, CSS, XSLT, XML (SAX, DOM), Custom Tags, PHP, JAVA SCRIPT.
• Strong skills in Requirement Study, Gap Analysis, Scope Definition, Disconnected Analytics, Synchronization, Recommendations to Business Process Improvements, Documentation, Project Tracking, UAT and Change Control Management.
• Working knowledge on different data sources ranging from flat files, Teradata, Oracle, SQL Server, DB2 databases and Sybase.
• Experience in OBIEE ADMINtasks Such as Web logic installation configuration / troubleshooting / performance tuning / monitoring etc.
• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer), Time Series Objects, Interactive Dashboards with drill - down capabilities using global & local filters, Security Setup (groups, access/query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Expertise in implementing Security Models for Dashboards using Row level, objects Level and Role Level.
• Developed reports in GL like Bonus Accrual-Units, Bonus Accrual-Area Supervisor, Intercompany transaction detail report, Hyperion Trial Balance using BI publisher.
• Experience in creating Aggregate tables using materialized views and Aggregate Persistence wizard.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Expertise in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of the Box prebuilt mappings, Designing ETL, Metadata Management using DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE Reports and Dashboards.
• Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Data Warehouse Administration Console (DAC), Informatica Power Center.
• Strong experience in developing and customizing Reports using OBIEE 10.1.3.x, Oracle Reports 6i/4.5, BI Publisher 10.1.3.4.1 .
• Technical expertise in General Ledger, Accounts Payables, Accounts Receivables, Purchasing, Inventory, Order Management and Shipping, Service Contracts, Install Base, HRMS, Payroll, Advanced Benefits, Oracle Time and Labor, System Administrator and SCM modules.
• Experience managing and coordinating onsite/offshore Model.
• Overall strength lies in precise translation of business requirements into technical documents. Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

Oracle BI Apps: Financial, Procurement and Spend, SCM, HR Analytics, General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Install Base, Fixed Assets, Cash Management, Service Contracts, Purchasing, System Administrator. BI apps 7.9.6/7.9.5 /7.9.4

BI Tools: Oracle BIEE 10.1.3.4.x/10.1.3.3.x/10.1.3.2.x, Siebel Analytics 7.8.x/7.7, Reports 6i/4i, Discoverer 10g/6i/4i, XML/BI Publisher 10.1.3.4.1 /5.6.3/5.6.2.

ETL: Informatica Power Center 8.x/7.x/6.x, DAC 10.1.3.4.1 /7. xSQL Loader.

Database: Oracle 11g/10g/9i/8i, SQL Server, Teradata, MS Access.

Data Modeling & Query Tools: TOAD, SQL*PLUS, SQL Developer. Erwin, ER/Studio, Visio

Languages: SQL ((ANSI), PL/SQL, XML, HTML, C, C++.

Operating System: Unix, Linux, Windows 7/Vista/XP/2003/2000/98/NT.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. OBIEE/OBIA Consultant

Responsibilities:

• Ran customized SQL cuts of the standard pay period reports through SQL Developer on a bi-monthly basis to meet certain requirements.
• Created pivot tables and ran Vlookup’s in Excel as a part of data validation.
• Working with DAC, Informtaica ETL architecture and OBIEE pre build data models
• Working with Upgrading from 10G to 11G
• Managed third party resources for production maintenance and back-end support.
• Created standard pay period reports namely Compensation, Termination, Position and New Hire in OBIEE 10g.
• Created executive dashboard for the end users and customized their tabs and report as per their specifications.
• Created pay band reports with a previous 3 year comparison.
• Created annualized turnover reports for the HR Governance audit team.
• Included prompts in the executive dashboard that enabled end users to select a certain year and a comparison range of their choice.
• Creating reports using BI Publisher reporting infrastructure and Integrating BI Publisher reports.
• Developed Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Validating report through BI Publisher using xml payload.
• Design and develop repository and security controls
• Create dashboards, customize BI Apps (HR Analytics) & utilize DAC as well as ETL Design
• Created various headcount and diversity related reports and included them in the dashboards.
• Created separate dashboard and customized reports for international data and business users.
• Managed the security settings and access for all the users through the RPD.
• Managed data migration from Development to Production as well as various changes to the domain files.
• Ran full loads on a bi-monthly basis and scheduled incremental loads to run each night through DAC in both Development and Production environments.
• Validated and signed off on the data after every full load run as a measure to keep it accurate in comparison with the old reporting system.
• Organized webcasts and created documents to educate and support end users on how to use OBIEE 11g Answers.
• Interacted with business Management representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications
• Understanding the Client requirements, source data, business objectives and key performance indicators.
• Installed and Configured OBIEE 10g and 11g on Windows Environment.
• Modified existing reports in Finance intelligence Dashboards in accordance with the client specifications.
• Administered Permissions and Privileges forDashboard visibility and modifications to Users based on their groups or responsibilities.
• Responsible for configuration of iBots to deliver content based reports on schedule, automated iBots queries to obtain daily and weekly reports.
• Thorough understanding of Business Intelligence and security modeling.
• Modified and tested the reports for Active Staff, New Hire, Terminated, etc.
• Created dimension hierarchies and level based measures to drill down to the most detailed level of data as per the business requirements.
• Designed and developed dashboard/page prompts for various financial reports.
• Customized Dashboard pages like Overview, Product Detail, Forecast vs. Actual, Asset usage, Financial Structure.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.

Environment: DAC 10.1.3.4.1, Teradata, Teradata SQL Assistant 14.1, OBIEE 11.1.1.6.1, Oracle BI Apps 7.9.6.3 (Procurement, HR Analytics, Spend Analytics), Informatica Power Center 9.1, Oracle 11g/10g, DAC 10.1.3.4.1, General Ledger, Accounts Payables, Accounts Receivable, Java, Essbase, DB Artisan, SQL Developer

Confidential, Bowie, MD

Sr. OBIEE/OBIA Consultant

Responsibilities:

• Performed the Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the Data Warehouse.
• Implemented OBI Apps OOB Supply Chain and Order Management, Procurement and Spend, Finance and HR Analytics.
• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Experience in Preparing Design Specification documents based on functional requirements and involved in the preparation of Technical Design Documents.
• Installed and Configured OBIEE, Informatica and DAC on Windows Environment.
• Developed HR intelligence Dashboards, used KPI’s which provides powerful Metrics, Alerts and Reports to HRMS professionals and line managers, enabling them to understand how workforce factors are affecting individual departments and take appropriate actions.
• Worked on pre-packaged HR Analytics Applications
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Worked on extracting data from Oracle EBS, OLTP flat files and loading data to Data Warehouse (OLAP) system.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Implemented incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Strong understanding of SDLC, RDBMS, OLTP, ETL Processing, OLAP, and DW Concepts.
• Performed Informatica, DAC, OBI RPD and Web catalog from one environment to another.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Designed, developed and tested the reports for HR terminations, Active Staff, Hire/Re-hire, etc.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica WorkFlow Monitor.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Created and Customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in Physical Layer, Tuning Reports.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables in RPD for the new dimension and Fact tables.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and Snowflex Schemas.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Involved in customizing out of the box reports to support the business requirements.
• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.

Environment: Oracle R12/R1211, Oracle BI Apps 7.9.6.1, OBIEE 10.1.3.4.1, BI Publisher 10.1.3.4.1, Informatica Power Center 8.6.1, Oracle 10g, Teradata, DAC 10.1.3.4.1, Toad and Windows 2003.

Confidential, Bloomington, IL

Sr. OBIEE/OBIA Consultant

Responsibilities:

• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Worked on integrating and configuring BI Publisher with OBIEE.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Upgraded and Configured OBIEE from Seibel Analytics Environment including DAC and Informatica.
• Involved in development of Data mapping process, functional design, technical design, integration test, acceptance test and schedule creation of tasks and milestones.
• Did Gap Analysis for Financial Analytics and implemented OBI Apps financial analytics module.
• Used ETL processes to load data from Flat files, Oracle Databases into the target OLAP databases.
• Designed and Developed Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• To implement incremental logic for Stage load mappings and Insert/update logic for all Fact Mappings.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power Center.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• Creating and maintaining OBIEE HR Analytics reports, dashboards
• Responsible for extracting Data from Oracle Apps Modules & loading into stage system and warehouse system.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding extra columns to the Existing Facts and Dimensions.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Implemented row and data level security on subject areas, dashboards and reports.
• Performed Informatica, DAC, RPD and WEBCAT migration tasks

Environment: Oracle 11i/R12, BI Apps 7.9.6/7.9.5, HR Analytics, OBIEE 10.1.3.4, Informatica 8.6.1, DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, SQL((ANSI), SQL*PLUS, SQL*Loader, TOAD, Unix, Linux and Windows 2003.

Confidential, Charlotte, NC

OBIEE Consultant

Responsibilities:

• Implemented Supply Chain and Order Management, Procurement and Spend, Financial Analytics.
• Conducted meetings with Subject Matter Experts (SME), Business Analysts and End-Users in gathering and analyzing the Business Reports Requirements.
• Performed the setting up, Installation, Upgrade and configuration of the complete OBIEE platform from Seibel Analytics Environment including Infromatica, DAC and the required connectivity for seamless integration with the data warehouse.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Implemented LDAP security in OBIEE for authenticating users.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down/Dynamic, Pivot Table, Chart, and Column Selector with global and local Filters using Oracle BI Presentation Services).
• Was involved in the installing and configuring of Financial Analytics.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
• Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Created new mappings, Sessions & Workflows to load the data into the Data warehouse.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Worked on multiple projects at a time to meet the dead lines of the tasks.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Created custom reports in Payables in OBIEE according to user requirement.

Environment: Oracle 11i, General Ledger, Account Payables, Accounts Receivables, BI Apps 7.9.4, OBIEE 10.1.3.2.x, Informatica 8.1.1, DAC, TOAD, Unix and Windows XP.

Confidential

Siebel Analytics Developer

Responsibilities:

• Interacted with Subject Matter Experts (SME), Business Analysts and Users for gathering the business, reports/dashboards requirements.
• Participated in the walkthroughs of the data models, ETL specifications, identification of dimensional attributes, Facts and Star Schema to fulfill requirements.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Providing High level estimate of the Gap Analysis and effort for Informatica and Siebel Analytics Report development.
• Map Dashboard field requirements to Siebel OLTP/OLAP Physical/Business Model.
• Design & Develop: Data warehouse (Informatica) ETL.
• Created templates for presenting results, Analytics and modified the Siebel Dashboard using cascading style sheets.
• Propose/Recommend design alternatives to confirm to the business requirements, Interact with Business Owners/end-users.
• Created Materialized Views to fasten slower queries with complex joins in them.
• Identify Data Sources (Siebel & Enterprise DW) & Extension columns - Identify Siebel OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP’s Physical layer tables/schemas.
• Established access rights for pages in the Dashboard for different user groups.
• Performed custom formatting with html tags in Dashboard.
• Create/Modify Metadata repository (.rpd) as per the data requirements by using Siebel Analytics Server Admin tool.
• Build Repository at 3 layers - Physical Layer (connecting Data sources & import schema), Business Model & data mapping (create Logical tables & data source mapping) & Presentation layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Design & Customize Siebel Answer Views & charts, Create & save Filters, Create Charts & Tables, Bins in Siebel Answers
• Created presentation layer catalog folders to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Experience in providing Security Privileges (Object level & Data level Security) for each Subject area and Dashboards according to user requirements.
• Created Users and user groups in Siebel Analytics web.
• Configure & Publish iBots to deliver analytics content based on schedule, automate iBot queries to obtain Daily & weekly Transactions to all Departments in Organization by Email.
• Maintained extensive documentation for design, implementation and testing Siebel Analytics reports, Dashboards and Informatica mappings.

Environment: Siebel Analytics 7.8.x/7.7, Siebel, Informatica 7.1/6.2, SQL Server, Oracle9i, and Windows NT.

Confidential

ETL Developer

Responsibilities:

• Gathered business requirements and created mapping documents based on the data model and source system analysis.
• Cleansing the heterogeneous source data, Standardize the Customer address, Extract and Transform data with business rules, and built re-usable Mapplets using Informatica Designer.
• Imported Sources and Targets created Mappings and developed Transformations using Power center designer.
• Created complex mappings and transformations using expressions, aggregators, filters, sorter, sequence generator, connected and remote lookups to develop and populate Data Marts.
• Created reusable transformations, Maplets and used them in the mappings.
• Fine Tuned Transformations and Mappings for better performance.
• Used Informatica Power Center Workflow manager to create sessions, workflow to run with the logic embedded in the mappings.
• Extensively used Informatica Power Center tasks like Decision, Command, Event Wait, and Event Raise, Email.
• Developed Sessions including complex batches and deployed in the Informatica Server, configured sever variables and analyzing log files for debugging.
• Efficient Documentation was done for all phases like Analysis, design, development, testing and maintenance.

Environment: Informatica Power Center 6.2, Oracle 9i/8i, SQL, PL/SQL, SQL Server 6.5, UNIX and Windows NT.