SUMMARY:

• Eight years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse, Data Marts, BI and Transactional applications
• Five years of extensive Business Intelligence and Data warehousing experience with Kimball and Inmon Methodology using OBIEE/Siebel Analytics 7.x and Informatica 7.x.
• Expertise in providing end - to-end business intelligence solutions using OBIEE and Knowledge of working in all phases of the Data Warehouse Development Life Cycle.
• Strong understanding of logical and physical database designs and also dimensional modeling schemas like Star and Snowflake schema.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool.
• Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), Delivers/iBots (alerts) and administered Web Catalog Objects (pages, folders).
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse
• Experience in working with business intelligence architect and team to translate business requirements into an effective data warehouse design.
• Experience in Writing Technical Design Document and converting Functional Specs to Technical Specs.
• Development strategies for Extraction, Transformation and Loading (ETL) of data from various sources into Data Marts and Data Warehouses using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Experienced in Performance Tuning of Source, Targets, Mappings, Sessions and Transformations.
• Experience in writing Database Objects like Packages, Stored Procedures, Functions and Triggers.
• Experience in Informatica and DAC.
• Used DAC (Data Warehouse Administration Console) to configure, administer, load and monitor modular data warehouse applications.
• Worked with technical team members to develop, deploy and support powerful dashboards and reports in OBIEE.
• Experience in implementing Seibel analytics with BI Publisher.
• Worked with Creating Report Layouts in BI Publisher.
• Expertise in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets.
• Proficient in all the phases of the Software development lifecycle, including requirements Definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Production Support.
• Active team player with excellent communication, organization and Interpersonal skills, self motivated and quick learner.
• Ability to work independently as well as in a team, fun-filled and challenging environment.

TECHNICAL SKILLS:

BI Tools/Analytics: OBIEE 11g, OBIEE 10.1.3.x, Siebel Analytics 7.8.2/7.7.1/7.5

ETL Tools: Informatica 8.1/7.x/6.x, Oracle Data Integrator(ODI)

Database: Oracle 11g/10g/9i, SQL, MS Access

Data Modeling Tools: DAC (Data warehouse Administration Console), Autosys

Languages: SQL, PL/SQL, C, HTML, XML

Scheduling Tools: ERwin, Oracle Designer, and Microsoft Visio

Oracle Tools/Utilities: SQL*Loader, Oracle Designer, SQL Developer, TOAD, SQLNavigator, JDeveloper, Oracle Developer 2000

Scripting Languages: JavaScript, VBScript and UNIX shell script

Operating System: Windows Vista, Win 95/98/2000/XP, Win NT 4.0, Linux, Unix

Knowledge: Oracle Discoverer, Oracle Warehouse Builder (OWB)

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

OBIEE Developer

Responsibilities:

• Created Repositories by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Developed and customized some of the existing Dimensions (Drill Down Hierarchies) and Logical Objects in Business Model and Mapping Layer and Presentation Catalogs in the Presentation Layer.
• Created Aggregations and Logical Based Measures in Business Model and Mapping Layer.
• Created Analytical Views (Compound Layout, chart, pivot etc.,) and Global/Local Prompts to design the Dashboards.
• Created Security Settings in Oracle Administration Tool to setup Groups and Provide Access Privileges and Query Privileges and also managed security for Groups in BI Answers.
• Developed Dashboards for each of metrics by embedding reports and providing intuitive drill- downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Used DAC (Data warehouse Administration Console) for both incremental and full loads.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Enhanced performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Involved in developing the Incremental ETL process (Mappings & Mapplets) using various Transformation and Workflows with Sessions/Tasks, executed workflows through shell scripts using pmcmd.
• Created & saved several BI Publisher reports by selecting an Answers request as Data Source.
• Built multiple execution plans in DAC for weekly and daily loads.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Participated in analyzing ETL mappings using Informatica 8.6.1, used Transformations like Aggregator, Update, Filter, Lookup, Sorter.
• Worked and developed Repository (.rpd), configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Did attend the every day Follow up calls about the OBIEE Business Processes with End Users and Team Members.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Informatica 8.6.1, Data Warehouse Administration Console (DAC) 10.1.3.4.1, Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX Oracle 11g/10g, SQL,ODI, PL/SQL, and TOAD 6.3/7.0.

Confidential, Newport Beach, CA

OBIEE Developer

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details and translate those requirements into a datawarehouse design.
• Worked with System Engineering team to design Facts, Dimensions, ERD, Dimensional data model, Data Structures (relational and OLAP) and Hierarchies of the business model.
• Worked with Oracle BI Applications, Oracle BI Publisher to build custom applications leveraging existing data sources and infrastructure.
• Worked with Generation of XML data and Create Upload the Templates in BI Publisher.
• Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica in all the environments.
• Responsible for implementing OBIEE for the modules Financial Analytics and which includes General Ledger, Accounts Payable and Accounts Receivable.
• Worked with creating RTF templates in MS Word by connecting to BI Publisher, and publish these templates for the reports to view data in BI Publisher.
• Created Repositories by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Experience in working with PL/SQL in OBIEE Through a pipelined function.
• Created Dimensions, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images and HTML objects.
• Used DAC to schedule and run the full incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Developed Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Involved in performance tuning by enabling the cache to improve the query performance.
• Built custom analyze scripts for DAC to reduce the time for table analysis.
• Involved in preparing/executing Test scripts, executes Test plans establishing Test Data, and recording defects, assembles and document the results.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from Redevelopment environment to QA environment and then to the Production environment.
• Experience in working with End users in defining and preparing System requirements.
• Conducted user training to familiarize them to the new reporting environment.

Environment: Oracle Applications R12,General Ledger, Account Payables, Accounts Receivable, Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.1, Informatica Power Center 8x, Data Warehouse Administration Console (DAC),Java Script, Oracle BI Apps, Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX, Shell Scripting, Oracle 11g/10g,Oracle 11i, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential, Alpharetta, GA

OBIEE Developer

Responsibilities:

• Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
• Designed Technical documents for the conversion programs and Interfaces from Functional documents.
• Designed and Developed OBI Repository at 3 layers i.e., Physical Layer, Business Model and Mapping Layer and Presentation Layer level.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Developed Time Series object for comparing between the months, quarter’s sales.
• Developed complex reports involving complex SQL filters.
• Worked with ERD and dimensional data models and Data Structures with Relational and OLAP cubes within OBIEE and ETL processes using Informatica.
• Experience in working with Supply chain Analytics for the Employee Expenses Dashboard which provides Employee Expenses, cash expensive outstanding.
• Extensively used presentation variables to develop the logic for the reports.
• Implemented the variables in the repository to import them in the presentation layer.
• Implemented Security by creating roles & web groups, checks with External tables and LDAP.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services/Siebel Analytics Web.
• Experience working on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks, Oracle BI Applications, Oracle BI publisher etc.
• Experience in working with PL/SQL while creating views in physical layer.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Involved in building and migrating the DAC metadata across DEV/ST environments.
• Used Informatica Power Center to develop ETL mappings, transformations, and to load data.
• Enforced Row Level Security for Managers to View the Reports pertaining to their Region

Environment: OBIEE 10.1.3.4, Informatica Power Center 8.6/8.5.1/8.1.1, Oracle 11i,Oracle 10gR2, Oracle BI Apps, DAC, MS SQL Server 2005, DB2,Hyperion 8.3, Erwin 4.3, Oracle BI Publisher, PL/SQL, Java Script, UNIX Shell Scripting, Toad, Windows NT.

Confidential, Blue Bell, PA

Siebel Developer

Responsibilities:

• Designed and Developed the Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Developed many Reports / Dashboards with different Analytics Views (Pivot Table, Chart, Tabular, etc.) for performing the Marketing Trend analysis using Siebel Analytics Web.
• Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions (AGO and TODATE functions) based on the Requirements.
• Designed & Added Customized Mappings to DAC & scheduled the loads to run on weekly basis.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business.
• Developed complex mappings by extensively using the Informatica transformations and flagging the records using the update strategy for populating the desired SCD tables.
• Customized new and existing ETL plans in DAC by importing Sessions and Workflows.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, and Cache Management.
• Created & saved several BI Publisher reports by selecting an Answers request as Data Source.

Environment: Siebel Analytics 7.1.3, Informatica Power Center 6.2, Data Warehouse Administration Console (DAC), Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX, Oracle 11g/10g, SQL, PL/SQL.

Confidential

Siebel Analytics/PL SQL Developer

Responsibilities:

• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in a Siebel Analytics repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Developed different kinds of reports (pivots, charts, tables) using global and local filters.
• Configure Interactive Dashboards with delivers/iBots to alert the marketing team about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Handled full load and refresh load via staging tables in the ETL Layer.
• Designed and developed new Aggregates using Informatica ETL processes.
• Developed and tested stored procedures, functions and packages in PL/SQL for data ETL process.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Developed PL/SQL Stored procedures, Functions, Packages, Cursors, Triggers, and Records to implement business rules into the application.
• Involved in tuning several SQL queries by using indexes, hints and EXPLAIN PLAN.
• Used SQL*Loader to load the data from flat files and CSV files into the database.
• Developed user interfaces, menus, and coded different PL/SQL objects for Forms and Reports.
• Design & create new forms using Oracle Forms 6i, and bug fixing with the existing forms.
• Developed new reports from scratch using Oracle Reports 6i.

Environment: Siebel Analytics 7.5.2, Informatica 6.1, Oracle 8i, UNIX, SQL server, Forms, Reports, SQL*Plus, SQL, PL/SQL, Windows NT 2000.