SUMMARY

• Over 8 years of software development experience in the field of Data Warehousing using the Informatica ETL tool and OBIEE/Siebel Analytics/BI Publisher reporting tool, possessing superior analytical skills and the ability to meet deadlines.
• 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.
• 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).
• 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.
• 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).
• Experience in Tuning OBIEE Reports and designing Query Caching and Data Caching for Performance Gains.
• 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 Writing Technical Design Document and converting Functional Specs to Technical Specs.
• Experienced in Performance Tuning of Source, Targets, Mappings, Sessions and Transformations.
• Experience in writing Database Objects like Packages, Stored Procedures, Functions and Triggers.
• Experienced in Software Analysis, Design, Development, Testing and Implementation phases of Data Warehousing using Oracle 10g, MS SQL Server, Teradata and DB2.
• 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

ETL Tools: Informatica Power Center 8.6/8.5.1/8.1.1/7.1/6.2/5.1 (Repository manager, Mapping Designer, Workflow Manager), Power Exchange.

OLAP Tools: Siebel Analytics 7.5.x/7.7.x/7.8.x, OBIEE 10.1.3.x, ODI, OBI Publisher 10.1.3.4, Business Objects 6.5/6.0, XI R2.

Databases: Oracle 11g/10x/9x, IBM DB2 UDB 8.1/7.0, SQL Server, Teradata, Sybase.

DB Analysis Tools: SQL Developer, TOAD 10, SQL*Plus, ODBC

Data Modeling Tools: Erwin 4.5/4.0/3.5.2.

Scheduling tools: DAC 7.8.5 (Data Warehouse Access Control)

Revision Control Tools: IBM Rational ClearCase, Win SCP, Putty, Xming, VSS.

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

Web Technologies: HTML, JavaScript, XML.

Operating Systems: Windows Vista, 2000, XP, NT, 98, 95 and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Mountainview, CA

Sr. OBIEE Developer

Responsibilities:

• Interacted with business representatives for need analysis and to define Business and Functional specifications. Participated in the design team and user requirement gathering.
• Worked with OBIEE Installation, Oracle BI Server, Presentation Server, Oracle BI Administration Tool and Oracle BI Publisher.
• Developed OBIEE repository to on top of sales, marketing data warehouse.
• Configured dimensional Hierarchies, Aggregate Navigation, Level Based Measures and Time Series.
• Involved in security configuration to provide data level as well as object level security. Created Variables, Initialization blocks for security configuration.
• Customized presentation layer to match user requirements.
• Worked in BMM layer of Oracle BI repository to implement business logic.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Created Oracle BI Publisher reports based on Oracle BI Answers request and designed using Microsoft Word.
• Worked on Multi-user development environment (MUDE) and created different projects for each location.
• Configured on cache purging strategy using event-polling table.
• Configured and administrated Usage Tracking and developed usage tracking related dashboard and reports.
• Configured OBIEE scheduler and worked on delivers and iBots to notify the corporate managers and region managers immediately about the different trends and alerts. Generated iBot alerts for reports to be delivered by email.
• Involved in unit testing and production support as well as documentations.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Informatica Power Center 8.1, Oracle BI Publisher, Oracle Delivers, OBIA 7.9.5.1, Windows XP, UNIX/LINUX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential

Sr Obiee Developer

Responsibilities:

• Understanding the Client requirements, source data, business objectives and key performance indicators.
• Worked with Retail analytics to make sense of business performance by adding context to real-time business measure
• Interacted with business Management representatives for gathering the Reports/ Dashboards requirements and to define business and functional specifications.
• Designing the Technical Design documents by understanding the Functional Design documents for the sales performance.
• Experience in Dimensional Data Modeling and Technical documentation and presentations.
• Identified the Gaps by analyzing the Data mart Instance and provided alternative solutions as well recommended changes to Database.
• Analyze data components and document Data Strategy to identify Key Metrics for Reporting.
• Installed and configured Oracle BI EE 10.3.3.4
• Responsible for Installing, Configuring and Administration of OBIEE 10.3.3.4 Repository for Physical, Business Model and Presentation services..
• Responsible for setting up the environment including installation of OBIEE and Informatica in all the environments.
• Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle users.
• Responsible for implementing OBIEE for the modules Retail and Sales.
• Built the Physical Layer /Logical Layer/Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Worked with historical depth and subject-area breadth sets the data warehouse apart from other information (files, application databases, report caches, content stores, data marts)
• Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
• Built Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
• Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.
• Testing and implemented Stored Procedures, Triggers, Functions, and Packages at database level.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Also worked with Security of the application/solution to define users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
• Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
• Implemented Security by creating roles & web groups, checks with External tables and LDAP.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Designed Executive Dashboards to provide Business Critical Analytical view of the Written Sales for a set of Power Users
• Create/Manage Repository/Web Users and Groups and assigning permissions using OBIEE Administration Tool.
• Designed and implemented Informatica Power Center 8.1 for ETL to load target Oracle 11g database.
• Extensively used Transformations like Lookup, Router, Normalize, Aggregator, Source Qualifier, Joiner, Expression and Update Strategy.
• Created Mappings to Demoralize data form a Normalized format
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIEE 10.1.3.2 Siebel Analytics 7.8/7.7.1, Informatica 8.1, Oracle 9i/10G, TOAD, PL/SQL, Windows2000.

Confidential, San Diego, CA

Siebel Analytics/Oracle BI Consultant

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters using Oracle BI/Siebel Analytics Web.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and user Security.
• Developed Accounting and Collection Time Series Object (Oracle BI Time-Series Functions) for comparing the Billings, Collections and Adjustments.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed many complex Informatica mappings and mapplets to build key interfaces using reusable transformations (Source Qualifier, Lookup, etc.) for loading data into Data Warehouse.
• Worked on OBI Delivers and Configured iBots to deliver Analytics content based on a schedule.
• Created Filters and provided customized prompts appropriately to avoid excessive data.
• 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.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Used Informatica transformations like Normalizer, Expression, Filter, Aggregator, Update Strategy, Lookup, Joiner, etc. extensively to create complex mappings and mapplets.
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.

Environment: Siebel Analytics 7.8.2/ Oracle Business Intelligence 7.8.4, Informatica Power Center 7.7.1, Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/Linux, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential, Chicago, IL

Siebel Analytics/Informatica 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.
• Created mappings for initial load and daily updates using Informatica.
• Developed and tested stored procedures, functions and packages in PL/SQL for data ETL process.

Environment: Siebel Analytics 7.5.2, Informatica 6.1, Oracle 8i, UNIX, SQL server, Windows NT 2000.

Confidential

PL/SQL Developer

Responsibilities:

• Worked with a team of IT developers in JAD sessions and peer-peer meetings in the Initial Database Design/Data Modeling/Data approval.
• Creating database objects including tables, indexes, clusters, sequences, roles, and privileges.
• Loading data from flat files into database tables using SQL* loader.
• Calculating and monitoring size and space for tables, clusters and indexes.
• Creating and maintaining triggers, packages, functions and procedures.
• Created users and established the application security by creating roles.
• Developed complex SQL queries and fine-tuned the SQL queries for performance
• Used Indexes and Hints for fixing the performance issues.
• Troubleshooting the performance issues with the help of Explain plans.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
• Used TOAD for faster application design and developments.

Environment: Oracle 9i, Flat files, MS Access, SQL*Plus, SQL*LOADER, PL/SQL, Toad, Windows 2000 Server.