SUMMARY

• Responsible and highly motivated professional with 7+ years of Data warehousing, ETL experience and 5+ years of experience in BI tools (OBIEE/ Siebel Analytics/ Hyperion Essbase).
• Expertise in complete SDLC of Analysis, Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts.
• Expertise in designing and developing the OBIEE/Siebel Analytics Metadata Repository (.rpd) using OBIEE/Siebel Analytics Server Admin tool.
• Over 3 years of experience as an BI Publisher 10g/11g / XML Publisher 5.6.3/5.6.2 (E - Business Suite) Report developer in developing Custom Reports.
• Extensive Experience in developing BI Publisher Reports in 10G/11G
• Good Knowledge in Developing OBIEE Reports using 10G.
• Well versed with using SQL and PL/SQL for BI Publisher and XML Publisher.
• Developed different types of reports including RTF, EXCEL, ETEXT TEMPLATES.
• Expertise in Oracle BI Publisher, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server.
• Implemented Best Practises in BI Publisher/XML Publisher.
• Active involvement in developing designs for software enhancements and making recommendations for improved business-customer relations.
• Expertise in creating, modifying and administering OBIEE/Siebel Analytics Intelligence Dashboards using OBIEE/Siebel Answers, creating iBots using OBIEE/Siebel Delivers.
• Expertise in configuring Interactive Dashboards with drill-down capabilities using global and local Filters. Expertise in Implementing Object level as well as Data level Security.
• Expertise in Performance tuning of OBIEE/Siebel Analytics by implementing Cache management and Aggregate Navigation techniques. Implementing Database tuning as well.
• Extensive experience in installing and setting up OBI Apps, Configuring DAC and Informatica servers.
• Extensive experience in customizing .RPD and Web catalog of OOTB Implementation of various OBI Applications like Financial Analytics.
• Experience Integrating OBIEE with OBI Publisher and Hyperion Smart view through Provider Services.
• Expertise in debugging and optimizing the OBIEE/Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
• Experience in troubleshooting Complex SQL queries and improve data delivery performance
• Extensively used Informatica Power Center 8.1/7.x/6.2.2 for Extract, Transform and Loading of data from multiple data sources to Data Warehouse and creating various mappings, sessions and Workflows.
• Working knowledge on different data sources ranging from flat files, Teradata, Oracle, SQL Server, DB2 databases and Sybase.
• Worked extensively on different Informatica transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup Strategy, Update Strategy, Sequence generator, joiner transformations, Router etc.
• Expertise in implementing complex business rules by creating re-usable transformations, robust Mappings/Mapplets, Sessions and Workflows and Worklets.
• Excellent communication skills, ability to meet tight deadlines and prioritize tasks.

TECHNICAL SKILLS

OLAP/BI Tools: OBIEE 11g/10g, Siebel Analytics 7.8.x/7.7.x/7.5.x, Essbase 9.x/7.x/6.xOBIEE Publisher 10.1.3.4, Hyperion 9.3.1/11.1.3.

ETL Tools: Informatica Power Center 8.1.1/7.1.2/6.2/6.1/5.1, Power Mart 5.0/4.7.

Tools: Toad 4.0.3, Erwin 4.1.4/3.5.2, MS-Access, MS-Visio.

Methodologies: Ralph Kimball’s Star Schema and Snowflake Schema.

RDBMS: MS-SQL Server 2005/2000/7.0/6.5, Oracle 10g9i/8i/7.3.

Languages: PL/SQL, SQL, C, C ++, Java 1.2, XML.

O/S: Windows XP/2000/NT/98/95, UNIX, MSDOS.

PROFESSIONAL EXPERIENCE

Confidential, Boston,MA

BI Consultant

Responsibilities:

• Interacted closely with Functional Analysts and Business Users in the client side, and designed the system accordingly.
• Performed the gap analysis, Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Model (Physical, Business and Presentation layer).
• Migration to OBIEE 11.1.1.3
• Experience on OBIEE 11.1.1.3
• Involved in setting Up MUDE in the organization.
• Configured Agents to send the Reports through Emails to the user group.
• Used Action Framework to see the linking of invoice details to Invoice number.
• Developed Parent Child Hierarchies in the repository.
• Identified granularity level of the Financial data required to be available for analysis.
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements.
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc report according to the client needs.
• Used Table and pivot table to display hierarchical columns.
• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Customized Meta Data Repository (RPD) to work with PeopleSoft Financials (AP, AR, GL and CAM). Pulled new physical tables to physical layer of RPD, joined them with dimension tables, developed hierarchy and presented them to presentation layer.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE Answers.
• Used conditions to determine whether agents delivered their content and executed their actions, whether actions links are displayed in dashboard pages, and whether sections and their contents are displayed in dashboard pages.
• Created Time- Series calculations using AGO and TODATE functions on BMM layer of Repository.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE Answers to build the query.
• Used presentation variable in OBIEE Answers to save prompt values and use them for conditional formatting.
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Worked with Cache persistence Wizard to efficiently handle cache
• DevelopedMaster Detail Report in OBIEE.
• Worked with properties such as changing the ownership of a folder or viewing the creation date of an object.
• Used the Oracle BI Presentation Catalog in order to a Perform basic tasks such as creating, deleting, and copying objects and folders. b. Performed object-specific tasks like modifying settings using the associatededitorCreating/ assigning an agent.
• Archived the entire catalog, folders, or objects to unzip them in another directorylocation.
• Specified permissions that determine the folders and objects that users can view.
• Sorted data values, applied sorts to members, measures, and rows in views such as tables, pivot tables, graphs, and maps.
• Used Java script to disable the dashboard prompts in the dashboard page using OBIEE Answers.
• Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.
• Worked extensively on Oracle BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats (PDF, CSV, HTML, EXCEL and XML DATA).
• Scheduled IBots and seeded server cache using Delivers to improve system performance. Scheduled reports to be e-mailed using BI Publisher Scheduler.
• Coordinated the RPD and Web Catalog objects migration from Development environment to QA environment and then to the Production environment using OBIEE Catalog Manager.

Environment: OBIEE 11g/10g, BI Publisher 10.1.3.4.1/11.1.1.3.0, Oracle 11g/10g, TOAD, SQLWindows XP.

Confidential, Detroit, MI

OBIEE BI Consultant

Responsibilities:

• Interacted with Business Analysts and Users in gathering and analyzing and designing the Business Reports Requirements.
• Performed the gap analysis, Identified Facts and Dimensions (with levels & hierarchy) and made required changes to the Data Marts.
• Involved in designing and developing subject areas in Repository (.RPD) catering to the OLAP reporting needs of Bank BI Project using OLAP Multi Dimensional Essbase Cubes.
• Developed various Essbase cubes with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Developed MaxL scripts, data load rules (DLR), Business rules, Calculation scripts and Report scripts for outline in Essbase cube.
• Implemented the Time Series Wizard (YTD, QTD, MTD) for comparing measures in different time Periods.
• Created Repository Static and Dynamic variables. Also created Initialization blocks for Session variables, which are used for authentication and security.
• Created Dimension Hierarchies in the BMM layer to drill down and drill across on various dimensions as per client requirement.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security.
• Created Catalogs in Presentation layer used for both ad-hoc and Dashboard end users.
• Created OLAP requests in OBIEE/Siebel Answers and multi-level requests (drill-downs and guided navigation).
• Created multiple reports reflecting region hierarchy based on roles - VP, Director and Account executive.
• Worked on cache purging strategy using Event-polling table. Worked on IBots using OBIEE/Siebel Delivers for caching and delivering the reports to subscribed users.
• Documented the Functional and Technical design documents in MS word and latter converted the Technical design document in to the report Field Mapping Document.
• Performance tuning in OBIEE for star schemas by implementing aggregate navigation, cache management, Materialized Views and Database tuning.
• Created new templates for BI Publisher to display in PDF or excel format.
• Generated Order submission summary and Detail reports and Order submission summary by email Report using BI Publisher.
• Developed/Converted most of the existing text reports to excel format using BI Publisher.
• User Manual for the usage of Oracle BI Publisher
• Trained Module (On How to Create BI Publisher Reports) to internal IT Team.
• Registered the new BI Publisher report as concurrent program.
• Debugged and resolved data matching issues ranging from the base tables to BI dashboard reports.
• Loaded the data to fact and dimension tables from ODS to STG and STG to FCT and DIM.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed complex Informatica mappings and tuned them for better performance

Environment: OBIEE 10.1.3.4, Essbase 9.3.1, Informatica 8.1.1, Oracle 10g, windows XP.

Confidential, San Jose, CA

OBIEE Developer

Responsibilities:

• Collaborated with Business contacts & Business Analysts in the analysis and preparation of OBI data requirements.
• EPCO Inc has implemented OBIEE to migrate dashboards and the functionalities from Ms ProClarity and xcelcius platform to OBIEE platform.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Creating dimensions, aggregations and keys using admin tool. Customizing Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
• Content settings, Complex joins fragmentation content and defining of Most Economical Source as per business requirement.
• Creation of presentation layer tables by dragging appropriate BMM layer logical columns.
• Developed Global prompts, Filters, Customized Reports and Dashboards using OBI presentation services.
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements.
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc report according to the client needs.
• Creating Users and Groups and managing the object level and data level security.
• Managing the intelligent dashboards by using dashboard, page and report level security.
• Creation of views like Pivot table, Column Selector, Compound layout.
• Identified the granularity level of the data required to be available for analysis.
• Involved in fine-tuning the reports by working extensively on the Caching Strategy.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Extensively used Oracle Delivers and iBots so as to provide alerts.
• Worked on OBI presentation Answers to build Interactive Dashboards with drill-down capabilities.
• Created RTF templates in MS Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher.

Environment: OBIEE 10.1.3.2, Informatica 8.1.1, Oracle BI Publisher, Oracle 10g, SQL, Windows XP.

Confidential, TX

OBIEE Developer

Responsibilities:

• Coordinated in the client installations and integration of OBIEE 10.1.3.3, DAC and Informatica 7.1.2
• Interacted with business representatives for requirement analysis, and to define business and function/technical specifications.
• Customized OBIEE OOTB metadata repository for AR, AP and GL.
• Created the new columns in existing fact and dimension tables and creating all together the new dimension and fact tables.
• Imported the custom fact and dimension tables and configured it in the 3 layers of the RPD. Implemented Level Based Metrics in the BMM layer. Created Compound facts in the BMM as per the client requirement.
• Written RRD (Report requirement document) RDD (Report development document) TDD (Technical design document).
• Designed Schema using custom fact, dimensions, physical, logical, Alias and extension tables
• Created Dimension Hierarchies in the business model and mapping Layer to drill down custom Store and product dimensions.
• Implemented conditional formatting using OBI Publisher.
• Customized the out of the box Informatica SDE and SIL mappings to include mappings for new columns created in the existing facts/Dimensions or created new SDE and SIL mappings for new facts/dimensions.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges.
• Performance tuning in OBIEE for custom made star schemas by implementing aggregate navigation and cache management.
• Developed different reports using Siebel Dashboard and Answers like views & charts, pivot and narrative, tabular used global and local filters.
• Created the Custom Dashboard for the custom reports and aligned the reports with in the dashboard according to client requirement.
• Tuned Performance for the reports by implementing aggregate navigation and cache management.
• Configured iBots and Delivers to send alerts to subscribed users.
• Ran the test scripts logged the bugs in elementool and fixed the bugs.

Environment: OBIEE 10.1.3.2, OBIEE Publisher 10.1.3.2, EBS, OBI Applications, Informatica 7.1.2, Oracle 10g, SQL, Toad, windows XP

Confidential, Wilmington, DE

Siebel Developer

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Created/Modified/ Customized Metadata repository (.rpd) and configured metadata Objects using Siebel Analytics Server Admin tool.
• Created dimension hierarchies for various dimension tables.
• Developed time series object for comparing between the months, quarters sales.
• Configured measures in the business model layer and mapped to multiple logical source tables.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Responsible for the Production and Maintenance Support Siebel Analytics.
• Responsible for unit, system and integration testing and performed data Validation for all the reports that are generated from Siebel Analytics.
• Trained end users to build ad hoc reports using Siebel Analytics.
• Developed different kinds of Reports pivots, interactive dashboards with drill-down capabilities, charts, tabular using Siebel Analytics Web.
• Created Charts, report specifications for all the reports generated.
• Created report prototypes (mockup of reports in excel) and presented to user to get the approval.
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• Worked closely with users, developers and administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.

Environment: Siebel Analytics 7.8.5, Informatica 7.1.1, Oracle 9i, SQL Server 2000, TOAD Comcast.

Confidential, Philadelphia, PA

PL/SQL Developer

Responsibilities:

• Worked on Database design with the team
• Measured the performance of the shell scripts by getting the expected results
• Writing PL/SQL code using the technical and functional specifications
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms
• Involved in writing Packages, Functions, Stored Procedures and Database Triggers
• Created stored procedures, functions, packages, data base triggers and cursors based on requirement
• Developed complex queries to retrieve the data
• Created partitions for performance improvement of queries
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Created indexes for faster access of data
• Documented business rules, functional and technical design, test cases and user guides
• Extensively used UTL FILE an oracle built in function to transfer data from the source system to flat files to conversion staging area
• Extensively used bulk collect to fetch large volumes of data from the table
• Created Jobs and stored procedures using Dynamic SQL for refreshing materialized views
• Involved in debugging and error handling
• Involved in creating Index’s, passing hints, analyzing the table
• Monitored the database growth on daily basis. Established backup and recovery strategies
• Worked on Database tuning and performance monitoring
• Detected and corrected bugs during system integration and user acceptance testing
• Created UNIX shell scripts for FTP batch jobs, creating SQL reports and email notifications

Environment: Oracle 10g, UNIX shell scripting, TOAD, SQL*Plus.