SUMMARY

• Over 7+ years of extensive hands - on experience in Design, Development, Implementation, Analysis of Oracle/Siebel Analytics, Administration tool, RPD Development, Dashboards, Configuring Dashboard, BI Delivers Configuring security at metadata and Report level, Metadata tools and User interface designs, including 3 full life cycle implementations.
• Core competencies include data modeling, design and development of ETL Data mart, Informatica and OBIEE 11g repositories, and building OBIEE 11g Dashboards/Reports.
• Experience on OBIEE Apps 7.9.6 (OBIA) like OBIEE Financial Analytics, Supply chain Analytics, HR Analytics.
• Experience in creating materialized views, partitions and bitmap join indexes for data warehouse.
• Experience in all phases of Data Modeling - Conceptual, Logical and Physical modeling.
• Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Created mappings using various transformations like Lookup, Aggregator, Expression and Normalizer Transformation etc.
• Extensive experience working with Answers (Chart, Pivot, Radar, Pie, Scatter), Dashboards (Prompts, Reports, Embedded Contents, Images, guided navigation links etc.), BI Publisher, Delivers and Agents.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUDE).
• Migrated Reports from 10g to 11g.
• Worked on RPD in 11g
• Expertise in using joins in both BI Publisher and OBIEE 11g
• Experience in scheduling the reports by using ibots and alerts.
• Consumed Web service to present the current stock price on the dashboard
• Expert in writing complex SQL queries, creating different PL/SQL Objects, Fine Tuning the code, and also in using SQL*Loader for loading data into Data Warehouse/Data Mart.
• Skilled communicator, ability to convey technical information at all levels, analytical thinker and excellent problem identification and solving capability.
• Preparing documentation all the phases in SDLC
• Ability to provide timely solutions and work within specified time frames.

TECHNICAL SKILLS

Business Intelligence: Oracle Business Intelligence (OBI) EE 11.1.1.6, OBIA 7.9.x, Oracle BI Publisher, (Web, Answers, Dashboards), Scheduler (iBots).

ETL Tools: Informatica 8/6,7.x/6.x.

Databases: PeopleSoft, Oracle 8i/9i/10g/11g, DB2.

Data Modeling: Erwin 9.0, 4.5

Other Tools: TOAD, Oracle SQL Developer

Languages: Java, HTML, XHTML, XML, VBScripts, Javascript, C++

Operating System: Windows NT/2000/2003/XP, UNIX, Linux and Mainframes, IIS, Apache.

Solution Areas: Sales, Marketing, Customer Relationship Management (CRM), Financial Management (Banking & Insurance), Inventory Management, Enterprise Performance Management.

PROFESSIONAL EXPERIENCE

Confidential - Jacksonville, FL

OBIA Developer

Responsibilities:

• Expertise to the technical team in Oracle BI Server, Oracle BI Answers, oracle BI Application, Oracle BI Interactive Dashboard and Delivers.
• Excellent technical skills in Oracle Business Intelligence (OBIEE), including OBIA, BI Repository development, reports and dashboards creation, and catalog/security administration in presentation services and iBot Configuration.
• Developing and plan executive level dashboards, complex reporting, and metadata modeling.
• Participating in the configuration, and documentation of all OBIEE, OBIA components.
• Extensively working in creating hierarchies and aggregates in the BMML, data and object level Security in OBIEE 11g.
• Working on Financials - AR Transactions, Financials - AP Balances, Finanacial - HR Analytics subject areas in Financial Analytics.
• Extensive experience in customizing OBIEE 11g dashboards and reports / Dashboards with different analytic views (Drill-Down/Dynamic, Pivot Table, Chart, Column selector, Tabular with local and global filters) using OBBIE 11g.
• Working on Customization of Out of box reports.
• Working on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer with Source PeopleSoft.

Environment: OBIEE 11.1.1.6, OBIA 7.9.6, Oracle EBS, Informatica 8.6, ODI, SQL Developer, DAC, TOAD, Sql Server2005, Oracle 10g/11g,HP Quality Center, Unix, Erwin 9.0.

Confidential - Englewood, CO

OBIEE 11g Developer

Responsibilities:

• Created Physical joins on table alias and named the tables based on BI Best practices
• Created Dimensional hierarchies, Level based measures, and calculated measures and set its aggregation based on Hierarchy.
• Involved in gathering the requirements from end Users.
• Involved in Data modelling and designed Star and Snowflake schemas.
• Extensive experience in OBIEE 11g repository (Physical, Business Model and Mapping and Presentation layers) ie Cache management, Usage tracking, Dimensional hierarchy, Aggregate navigation, variable initialization blocks configuration etc.
• Extensively worked in creating hierarchies and aggregates in the BMML, data and object level Security in OBIEE 11g.
• Worked on OBIA Analytics 7.9.6.3 like Financial Analytics.
• Created new Dashboards in Financial Analytics based on user requirements.
• Worked on Financials - AR Transactions, Financials - AP Balances, Finanacial - HR Analytics subject areas in Financial Analytics.
• Created new level based measures and variables in Financial Analytics.
• Extensive experience in customizing OBIEE 11g dashboards and reports / Dashboards with different analytic views (Drill-Down/Dynamic, Pivot Table, Chart, Column selector, Tabular with local and global filters) using OBBIE 11g.
• Wrote/Modified custom Java Script code to restrict users to select only one date prompt selection.
• Wrote custom Script to show only one Go/Clear button.
• Created new reports and dashboards, saved filters, navigations using Go URL and dashboard links using OBIEE best practices.
• Created OBIEE Roles based on the projects and assigned users to it.
• Created OBIEE 11.1.1.6 Agents and Scheduled according to the regions and Users
• Creates the users and configured security in web logic console of OBIEE 11g
• Done the fit-Gap analysis comparing OBIEE 10g to 11g.
• Involved in the OBIEE upgrade from 10g to 11g.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Created Action Links in OBIEE 11g.
• Used DAC tool to schedule ETL jobs.
• Involved in OBIEE 11g performance testing on multiple browsers.
• Build the BI Reports based on the BI Best Practices and Perform Unit Testing.
• Initiate Migrations from one environment to other.
• Coordinate with testing team, analyze and resolve assigned defects and deploy fixes accordingly.
• Built the Project Component Inventory and is up-to-date and in sync with code changes.
• Develop the implementation plan and resolve technical issues during warranty.
• Very strong analytic and presentation skills and problem-solving techniques with emphasis on individual and team effort backed by excellent communication skills.

Environment: OBIEE 11.1.1.6, OBIA 7.9.6, Oracle EBS, Informatica 8.6, ODI, SQL Developer, DAC, TOAD, Sql Server2005, Oracle 10g/11g,HP Quality Center, Unix, Erwin 9.0.

Confidential - Rosemont, IL

OBIEE 11g Developer

Responsibilities:

• Requirement Gathering and Analysis of existing source system and documenting the Technical Design.
• Gathering Requirements from business users and designed proof of concept.
• Involved in designing of data modeling (star schemas, snow flake schemas) and worked in identifying facts and dimensions.
• Designed BI publisher reports by using BI Answers.
• Used the OBIEE 11.1.1.6 Administration tool to develop and enhance meta-data.
• Migrated OBIEE 10g repositories into OBIEE 11.1.16.
• Implemented LDAP Security and External Security.
• Worked on many operational and analytical reports which include creation of many interactive dashboards.
• Busted the reports by BI Publisher 10g
• Successfully created reports in multiple formats and delivered them to multiple destinations(Email, Fax, and Printer) using BI Publisher
• Used both the BI Publisher Standalone 10g and Integrated with OBIEE 10g to answer business questions.
• Worked on Financial Analytics, HR Analytics and Supply Chain Analytics in OBIA.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Worked with the Business Analyst during the functional design and technical design phases. Designed the mappings between sources (external files and databases) to operational staging targets.
• Extensively involved in ETL testing, Created Unit test plans and Integration test plans to check whether the data has been loaded into the target is accurate, which was extracted from different source systems according to the user requirements.
• Configured and Created repository using OBIEE 11.1.1.6 Admin tool.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Worked with functional analysts and stakeholders to ensure that theOBIenvironment supports the implementation plan and future requirements of the business.
• Created numerous executive level reports. Dashboards were generated to provide insight into the sales/marketing/financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables. Created business reports using OBIEE 11.1.1.6 Answers as per requirements.
• Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Worked on the Init Blocks to suffice the report business requirements and worked on security profiles to create complex security model.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
• Updated the mapping logic according to changes in the requirements.

Environment: OBIEE 11.1.1.6g/Siebel Analytics Configuration/ Batch processing, OBIA 7.9.6, Informatica 8.6, SQL Developer, TOAD, Sql Server2005, Oracle 10g, Sun Solaris Linux, Erwin 9.0.

Confidential, Baltimore, MD

OBIEE Developer

Responsibilities:

• Created Gap Analysis document from Siebel environments to Edward data ware systems.
• Involved in developing and customizing Conversions and Interfaces in Order Management, Receivables, Inventory and Payables modules.
• Worked with Business teams for gathering requirements, Identified Analytics Report requirements.
• Extracted data from different type of sources (ORACLE and Flat Files).
• Involved in creating and designing mappings using various transformations.
• Developed Stored Procedures in PL / SQL to implement some data cleaning.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Designed, configured and documented Logical and Physical Data Model.
• Configured and extensively used Siebel Delivers, Schedulers and iBots.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions Facts & aggregate tables, Measures and Hierarchies
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Designed and busted the reports in BI Publisher 10g
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and query privileges
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Developed aggregated fact tables using the content tab and fragmentation
• Configured Repository and session variables to get dynamic reports and dashboards
• Added new Dimensions and Columns to the Subject Areas to full fill the Additional Requirements of the Business Analysts.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities
• Implemented security by creating roles & web groups, External tables and LDAP
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems Integration Test, UAT Phases.
• Extensive experience in configuring Siebel Applications using Siebel Tools.
• Experienced in various Siebel product lines including Siebel Healthcare, Siebel Marketing, and Siebel Call Center Applications.

Environment: OBIEE 11g/Siebel Analytics Configuration/ Batch processing, Informatica 8.6, Sql Server2005, Oracle 10g, Sun Solaris Linux, Erwin 9.0.

Confidential 

Database Developer

Responsibilities:

• Imported the data from legacy system into application tables using SQL*Loader. The data was first loaded into interface tables. Then after verifying the error logs, the data was inserted into applications tables by running the concurrent program.
• Extensively involved in testing of Interfaces and development of standard error reporting package.
• Customized the workflow for the PO Approval process.
• Involved in data modeling and creation of E-R diagrams.
• Created and maintained Stored Procedures, Functions, Packages, Views, Materialized views and Tables
• Participated in building business areas, workbooks according to user’s requirements and also involved in creating Ad-hoc reports using Discoverer.
• Developed budget reports, variance reports, forecast plans, approved supplier list in Reports 6i.
• Customized Pending Order Approval Report in Reports 6i.
• Done heavy PL/SQL programming for customizing Reports and Forms.

Environment: Oracle Applications 11i (General Ledger, Payables, Receivables, Purchasing, Order Management), SQL Loader, Discoverer 4i, Oracle 8i, Reports 2.5/6i, UNIX, Windows NT.