Summary

• 7 years of experience in complete life cycle gathering Business Users Requirements, System Analysis, Design Data Modeling, Development, Testing of Business Intelligence and Data warehousing.
• Expertise in providing business intelligence solutions by configuring metadata building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Interactive Dashboards using Oracle Business Intelligence Siebel Analytics .
• Worked Extensively on Oracle BI Siebel Analytics Administration Tool, Oracle BI Web / Presentation Services, Answers, BI Publisher, scheduling iBots using BI delivers.
• Excellent Aptitude in designing Star Schema / Snowflake Schema methodologies using OBIEE Administration tool.
• Expertise in Business Model development with various functionalities like Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Caching Mapping.
• Extensive experience in building Interactive Dashboards with drill-down drill-across capabilities using global local Filters, Business Rules with User Identity Roles, Profiles Personalization.
• Expertise in implementing the Oracle BI / Siebel Security Setup groups, data access/query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Siebel Analytical Dashboards / Reports to improve performance at Database.
• Experience in extracting data from Siebel, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
• Extensive experience in Oracle Back-end server-side PL/SQL Development i.e. Packages, Stored procedures, Functions Triggers using SQL Developer and Toad as development tools.
• Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 8.x/ 7.x.
• Knowledge on web logic server.
• Worked on oracle reports.
• Very good experience in developing Informatica Mappings / Mapplets and Workflows with Worklets Tasks for ETL data from Multiple Sources to Data Warehouse.
• Vast experience in designing, developing and tuning complex mappings from varied transformation logic like lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Rank etc.
• Expertise in Oracle PL/SQL and database Performance Tuning. Creating appropriate indexes, re-building indexes.
• Experience in implementing Slowly Changing Dimensions.
• Thorough Knowledge of User Management Creation of Users and their Privileges etc in Informatica.
• Knowledge of Data warehouse Application Console DAC Architecture.
• Multi-platform experience on UNIX / Linux and Windows Server family.
• Good Team player and an individual contributor with steep learning curve and good interpersonal skills.

Technical Skills:

Reporting Tools: OBIEE 11.1.x/10.1.X, Siebel Analytics 7.8/7.7/7.5/6.0, Oracle BI Apps,BI publisher.

ETL: Informatica 8.x/7.x/6.x/5.x PowerCenter PowerMart

Scheduling Tool: Data Warehouse Administration Console DAC

ERP: Oracle EBS, People Soft, Siebel CRM

DBMS/RDBMS: Oracle 11g/10g/9i/8i, Microsoft Access 2000/XP, MS SQL Server 2000/2005.

Languages: PL/SQL, SQL, UNIX Shell Scripting, C, C .

Tools: TOAD, SQL Plus, SQL developer.

Operating Systems: Windows 98/Me/NT/XP/VISTA, MS-DOS, UNIX, LINUX

Other Software: MS-Office, Adobe Photoshop, HTML DHTML.

Work Experience:

Confidential

Informatica Developer

Responsibilities:

• Installation/Configuration of OBIEE Server, Repository RPD and Responsible for setting up Development platform, Requirement Collection and Building Proof Concepts.
• Designed and Developed Metadata repository .rpd with star schema Business presentation in OBIEE administration.
• Imported data sources, Created connection pools, physical tables, defined keys and physical joins in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures in BMM layer. Created and modified Presentation layer objects.
• Scorecards and KPI are used.
• Developed custom reports/Ad-hoc queries using BI Answers.
• Implemented the delivery of iBots using Delivers to alert the associated groups.
• Implemented security by creating users and groups, Configured LDAP server to Authenticate users and implemented both object level and row level security based on roles and responsibilities.
• Configured many Dashboards with different Views Pivot Table, Chart, Tabular and View Selector , Alerts, dynamic dashboard prompts and guided navigation links.
• Informatica ETL tool was used to load source data to build the data marts. An operational data store was created. Metadata Build up was designed for performing data mapping.
• The Mapping Designer module is used for ETL tasks to upload the data from OLTP Systems to build Data Marts.
• Used aggregate, expression, lookup, update strategy, router, and rank transformation.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Essbase Studio will connect to Oracle BI Server as a data source
• Created Informatica parameter files with workflows and sessions.
• Scheduled sessions using workflow manager's scheduler in Informatica.
• Wrote Oracle PL/SQL procedures for processing business logic in the database.
• Tuned Database queries for better performance.
• Informatica Installation, DAC Installation, Configuration and Execution for populating data warehouse.
• Scheduled knowledge-transfer training within the team.

Environment: Windows XP, OBIEE 11.1.x/10.1.3.4, Oracle 11g/10g, Informatica 8.6, DAC 7.9.5, SQL Developer.

Confidential

Sr OBIEE Developer

Responsibilities:

• Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers and End users.
• Using admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
• Worked on layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
• Designed various reports i.e. Pivot, Narrative and Chart reports in Answers and Configured Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and Charts.
• Generated .RTF PDF as per the end user requirements using BI publisher.
• 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.,
• Implemented Security by creating roles web groups using LDAP Authentication.
• Created presentation catalogs for exposing both stored and calculated measures and dimensions to users for Adhoc Reporting
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Giving security permission / privileges as per the role of each user.
• Developed custom dashboards and reports using OBIEE Answers.
• Scheduling the Developed reports according to Client requirements
• Tested and validated the repository, reports and dashboards.

Environment: OBIEE 10.1.3.4, BI Applications 7.9.4/7.9.5,BI publisher, Informatica Power Center 8.1.1,Windows XP, and Oracle10g, SQL Server 2000/2005.

Confidential

Sr OBIEE Developer

Responsibilities:

• Worked with Financial representatives for Business Analysis and Requirements Gathering.
• Performed the setting up, installation and configuration of the complete Analytics platform environment.
• Effectively managed ODBC connections and imported the Physical tables and keys to the physical layer.
• Created Business Facts Dimensions and defined Logical relation between them in BMM layer.
• Created and modified Presentation layer objects.
• Extensively worked on Answers, Created Reports using different Analysis Views Pivot Table, Chart, Column Selector and Table .
• Developed Dynamic / Interactive Dashboards and pages by creating Dashboard Prompts.
• Organized pages reports into new dashboards: CORE, GL, AP, AR.
• Also worked with Security of the application to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions and Filters.
• Configured LDAP server to authenticate users and implement both object level and row level security based on roles and responsibilities.
• Configured Delivers- iBots to alert the users based on the requirement.
• Worked extensively in developing ETL for supporting data extraction, transformations and loading using Informatica Power Center.
• Expertise in Developing Mappings and Mapplets /Transformation between Source and Target using Designer.
• Created number of reusable transformation according to the same business needs. Majority of the transformations used are Normalizer, Joiner, Filter, Aggregator, Router, Sequence Generator, etc.
• Experience in preparing complex Sessions/tasks and Work Flows.
• Exposure to development, testing, debugging, implementation, documentation, user training and production support.
• Used customized workflow and ran them from DAC.
• Monitor the workflow from workflow monitor and made them work if any error occurred during full load.
• Oracle Warehouse Builder OWB and Oracle Data Integrator ODI implementation to enable building the OBIEE Logical Layer.

Environment: OBIEE 10.1.3.x, Informatica 7.1.14, DAC 7.9.5, Oracle 10g, TOAD, Linux server, Windows XP, UNIX shell scripting.

Confidential

Siebel Analytics/Informatica Developer

Responsibilities:

• Fully responsible for requirement gathering, installation upgrade, configuration and testing of the Siebel Analytic related tasks.
• Worked with the Physical layer to create joins between tables to build star schema.
• Created aliases for tables in the physical layer for analytics requirements.
• Worked extensively with BMM layer to develop various business models.
• Created dimensional hierarchies and assigned levels and custom aggregation rules for each level.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation Layer.
• Created various aggregate tables to improve the query performance.
• Worked with Siebel Answers to develop many Reports with different Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters .
• Created dashboards using analytics requests and assign Permissions to dashboards depending on their user group.
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and logging levels.
• Configured iBots using Siebel delivers to alert the management and sales teams regarding data consistency issues.
• Developed various Mappings Mapplets to load data using different transformations like Router, Aggregator, Lookup, Update Strategy, Source Qualifier, Expression, Stored Procedure and Sequence Generator to store the data in target tables.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the backend programs, Error Handling Strategies. Informatica mappings and update processes.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Participated in customizing the workflows according to Business requirements by using DAC.

Environment: Siebel Analytics 7.5, Oracle 10g, TOAD, Informatica 6.1, DAC, Windows XP.

Confidential

Oracle Developer

Responsibilities:

• A number of optimization techniques are used to determine the most efficient access plan for SQL queries.
• Written complex SQL queries and PL/SQL programs to retrieve/update the information from database.
• Developed procedures, functions and packages.
• Developed Conversion Programs to convert Payable Invoices.
• Developed Conversion Program to load Vendor data.
• Efficiently modified the SELECT statements to limit or modify result table to improve performance.
• Rewriting complex SQL queries with many queries and joins using SQL compiler for better system performance.

Environment: Oracle 9i, MS Access, SQL, PL/SQL, Windows NT.