SUMMARY

• Around 7 years of IT experience in delivering Business Intelligence solutions by gathering requirements, analyzing, developing, testing and deploying Business Intelligence (BI) applications using OBIEE/Siebel Analytics.
• Around 4 years of experience in IT Industry and experience in Data Warehouse, Datamart and Business Intelligence using Informatica, Siebel Analytics, Oracle Business Intelligence and Oracle BI applications.
• Strong working knowledge in design and development of ETL (Informatica) Process,Data (Dimensional and Relational) modeling for Data warehouse (EDW) and scheduling DAC.
• Strong experience in Customizing the OOTB RPD file for Oracle CRM (CRM Sales, CRM Service Analytics)and Oracle Financials for GL, AP and AR Subject Areas.
• Technical knowledge on Oracle Applications 11i module (Account Receivable, Account Payables, Order Processing concepts, Shipment, Invoices, General Ledger).
• Experience in data modeling and DB normalization skills including OLTP and DW.
• Experience in Installing, configuring and customizing DAC (execution plans, subject areas, tables, and task) and monitoringETLprocess using DAC & Informatica workflow manager.
• Provided SDE Schema Delta among Oracle Fusion, EBS Adaptors using DAC forOBIA.
• Developed ETL Mappings (SDE/SIL/PLP), Sessions, Workflows using Informatica.
• Created Tasks, Assembled Subject Areas, Built, Ran and Monitored Execution Plans in DAC.
• Experience in developing Informatica Mappings/Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation, Time Series, Caching, authentication and authorization (data and objects).
• Extensive experience as Oracle Developer in utilizing PL/SQL procedures, functions, packages, triggers, unit testing and also involved in data extraction, transformation and loading operations on oracle using SQL Loader, Informatica.
• Customization of OOTB RPD by extending with custom database objects and extending the subject areas with new attributes/metrics.
• Created mappings to extract data from Cobol files, Flat Files, Excel and Access databases to be loaded into the Pre - Stage Schema.
• Involved in design of dimensional models like Star Schema and Snowflake Schema.
• Hands-on professional experience in Oracle Business Intelligence Enterprise Edition.
• Customized and configured OBIEE application using OBIEE Answers, OBIEE Dashboards, BI Publisher and Administration Tool.
• Developed the business model and mapping layer, Presentation layer and RPD using OBIEE administration tool set.
• Experience in configuring Interactive Dashboards with Drill-drown capabilities using global and local filters, OBIEE Security setup (Roles, groups, and access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Highly experienced in setting up Session Variables and Repository Variables using various Initialization Blocks.
• Created various analytic reports using global and local filters.
• Experience in modeling aggregate tables to speed up processing and building calculated measures for the Fact tables.
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL Loader, SQL Plus and TOAD.
• Ability to discuss and utilize various architectural components of the tool (Security, aggregation, logical columns, etc.)
• Highly experienced in Effort Estimations, Detailed Analysis of Business requirements and mapping those to technical Requirements.
• Experience in creating and modifying Business Intelligence requests using Oracle Business Intelligence Answers.
• Knowledge in Data Mapping, Data Conversion, and Data Cleansing.
• Experience in setting up security and architecture with OBIEE 11g by using web logic admin Console and Enterprise Manager.
• Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Hands on experience on admin tasks of OBIEE such as Security and Monitoring.
• Worked on different environments such as Development, UAT and Production and provided Production Support in various projects.
• Proven ability to work well with and lead others and quickly grasping new information and technologies.
• Highly reliable and productive, possess good interpersonal communication skills and leadership qualities.

TECHNICAL SKILLS

Business Intelligence: Oracle BI Applications 7.x, OBIEE 10g/11g, BI Publisher.

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

ETL: Informatica 8.x/9.x and Data warehouse Administration Console(DAC)

Data Modeling: Dimensional modeling, Star, Snowflake.

Languages: SQL, PL/SQL, C, C++, Java, C# .NET, HTML, XML, SQL Scripts.

Tools: Microsoft Visio, TOAD, SQL Developer, SQL Loader.

Operating System: Windows NT/XP/98, Windows Vista/7, HP UNIX, Linux.

Reports: BI Publisher.

PROFESSIONAL EXPERIENCE

Confidential, Clearwater, FL

OBIA Consultant

Responsibilities:

• The Financial Analytics subject area is configured to satisfy all their reporting needs.
• The Finance Team uses the Daily and Monthly balances Report for smooth operations.
• Oracle GL, AP and AR Data is loaded into OBA Warehouse using Informatica & DAC and reports were developed usingBI Apps (Financial Analytics)repository, BI Answers and Dashboards.
• Meetings with business representatives for gathering the Financials reports/dash board requirements.
• Involved in developingProject Planand the future scope of theFinancial Analyticsproject.
• Administrated BI Environment by debugging identified issues and delivered solutions.
• Customization of OOTB RPD by extending with custom database objects, updating the OOTB stars with new dimensional alias, creating new stars, defining the new hierarchies, and extending the subject areas with new attributes/metrics.
• Have been involved in customizingtables inService Analytics (Oracle CRM)andBalance and Ledger tables in Financial Analytics.
• DAC tasks and Informatica mappings were debugged and DAC parameters were changed to load multipleSubject AreasintoOBA Warehouse.
• Managed various concurrently running ETL jobs in different environments Confidential regular intervals using DAC.
• Configured Informaticacustom workflows&synchronized withDAC tasksfor routine scheduling.
• The central OBI Server runs the Informatica ETL on a nightly basis, pulling data from it’s Oracle source systems, modifying the data as needed, and placing the data in the Datawarehouse.
• The Informatica ETL is kicked from DAC on the OBI server or from a DAC command line prompt.
• Worked on createing various execution plans which are made up of individual tasks that run in a specific order to complete the ETL.
• Customized the mappings in the OOTB folder like PLP and SILOS.
• Applied the aggregation rules for the tables in the Warehouse which can be later used to develop reports.
• Involved in customizingAccount Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards.
• Created custom Indexes on OOTB Tables to improve dashboard Report performance.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Presentation Services.
• Provided DAC support and completed the configuration for Order Management Analytics and Financial Analytics.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power Center.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas
• Developed different kinds of Reports (Pivots, Charts, Tabular) using global and local Filters.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Enhanced performance of Reports / Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes and managing Cache

Environment: OBIEE 11.1.1.6/7, Informatica 9.1/9.5, BI Apps 7.9.6.3, DAC 10.x/11g, Oracle 10g/11g, TOAD, SQL Developer, Windows NT/XP.

Confidential, Irving, TX

OBIA Consultant

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the Business Model for generating reports as per the user requirements.
• Involved in co-coordinating onsite-offshore teams in various life cycles of the projects.
• Used Informatica for Extraction, Loading and Transformation of Data.
• Informatica was used totranslate the business rules into mappingsto include OLTP custom columns & tables from Billings application system into OBA warehouse.
• Involved in the Design of ETL process. Developed different mappings to transform data from source to target.
• Experience in BI Apps for AP, GL, Projects, Procurement and Human Resources.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• Worked with different stages of handling data viz. requirement gathering, identifying data sources/targets, data modeling, data cleansing, data loading, and building Star schema.
• Extracted data from COBOL files into Informatica and created new mappings according to the client requirement.
• Developed Informatica Mappings/Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookups, Update Strategy) and also in creating Workflows.
• Analyze Design and Development of Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, Presentation Layer.
• Performed fit-gap analysis on identifiedFacts and Dimensionsand made required changes to the Operations and Billings Datamart (OBAW Database).
• Worked with out of the box reports and customized them to suit the business needs.
• Customized OOTB Financial analytics dashboards as per client requirements.
• Customized the repository and created new Requests, developed Custom Reports/Ad-hoc queries, charts using Oracle BI Answers Created and configured the Dashboards.
• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger Dashboards in OBIEE.
• Modeled the repository which included customizing star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer.
• Established the logical joins/keys required to support drill-down hierarchies.
• Utilized session variables, repository variables and initialization blocks in the repository for Security and reports.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Tables).
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Implemented security tasks like creating user groups, users and managing users by setting up their privileges and profiles.
• Developed custom logical columns and calculated measures using expression builder. Created presentation catalog with restricted access to various business users.
• 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.
• Troubleshoot various ELT performance issues.
• Worked and coordinated with testing team for bug fixes and production change requests.

Environment: OBIEE 11.1.1.5/ 10.1.3.4.1, BI Apps 7.9.6, DAC 10.1.3.4.1, Informatica PC 8.6, Oracle11g, Windows Server, SQL.

Confidential, San ramon, CA

BI Consultant

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the Repository and extraction of Reports.
• Analyzed the specifications provided by the client, understanding the business.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, and BI Publisher.
• Designed Star Schema for fact & dimensional tables and created Alias for the dimension and fact tables when necessary.
• Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Physical, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Designed and Configured Dashboards in Analytics for different groups of users, which include like Managers, Functional Heads, Department Heads.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions
• Designed and developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Developed Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.
• Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector, View Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used the Catalog Manager and maintained the Analytics web catalog to manage Dashboards & Answers.

Environment: OBIEE 10.1.3.2/10.1.3.3, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, BI Apps 7.9.5, Oracle 10g, BI Publisher, Windows XP, Toad.

Confidential, Houstan, TX

OBIEE Developer

Responsibilities:

• Created reporting metrics and transferred key performance indicators to a process and database design.
• Created/modified Metadata repository suiting the company’s data requirements by using OBIEE Administration tool.
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.
• Defined Primary-Foreign key relationships, complex joins to bridge tables between dimension tables and Fact tables in the physical layer.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created Aggregate tables and fragmented fact tables for efficient query performance.
• Created and modified Sales Analytics dashboards and reports.
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
• Created workflows for the Initial load and refresh load.
• Created mappings to populate the aggregate, hierarchy and helper tables.
• Tested and Validated the Repository before making it available for queries.
• Configured query cache to reduce the cost of database processing and reduce the server-processing overhead.
• Defined session variables for users to enhance data level security.
• ImplementedBIPublisherand created bursting reports usingBIPublisher.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on BI Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of the end-users.
• Configured reports to deliver analytics content-based alerts as per user requirements.

Environment: Oracle Business Intelligence 10.1.3.2, BI Publisher 10g, Oracle 10g, TOAD.

Confidential

SQL Developer

Responsibilities:

• Involved in writing SQL, Stored procedures and debugging them.
• Generated server side SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Developed Database Triggers in order to enforce integrity constraints, and to enhance data security Confidential database level.
• Developed several user guides and different project guidelines.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages.
• Generated views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Developed Custom forms to view edit the data in custom interface tables and event handling tables using template forms
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling
• Optimized critical queries to eliminate Full Table scans.
• Analyzing Business requirements with product management for new release cycles.
• Created the Integrity Checks to clean erroneous data.

Environment: SQL, PL/SQL, Windows.