Professional Summary:
Excellent 7 years of experience in IT Industry as an OBIEE developer, Designing and Implementing Data Warehouse/Data Mart and Data Modelling. Proficient in implementation and customization of Oracle Business Intelligence Enterprise Edition (OBIEE) packaged and non-packaged analytical applications.

• Extensive BI and Data warehousing experience using Siebel Analytics 7.x/OBIEE and Informatica 8.1/7.x/6.x Strong experience in creating star schema for OBIEE/Siebel Analytics Projects
• Excellent understanding of Data Warehouse Architecture, Star Schema, and Data Marts decomposing High-level design documents into ETL specification document.
• Designed and developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure
• Extensive experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Presentation Layer), Time Series Objects.
• In-depth understanding of RPD configuration, creation of connection pools, logical tables and columns, hierarchies, calculated measures, variables, users and groups, MUD environment.
• Expert in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Siebel Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports).
  Expert in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, iBots, Reports) using OBIEE Admin Tool and OBIEE Web.
  Efficient in creating dimension hierarchies and level-based measures for various business models.
• Strong experience in creating workflows and work lets using Informatica
• Extensively Worked on OBI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Hands on experience with data warehouse/data marts, building and designing OLAP cubes, dimensions and fact tables using Business Intelligence Development Studio.
• Strong experience in setting up a Multi-User Development Environment (MUDE).
• Expert in Performance tuning of dashboards and reports -- experience in developing caching strategy and implementation of Cache Seeding iBots, materialized views.
• Strong Experience in data Maintenance and Support which uses Oracle 9i database, SQL, PL/SQL, SQL* Loader, Shell Scripts, Business Objects in windows NT and Unix environment.
• Performed Server and client installations, database creation, creating users, assigning privileges, roles, quotas, profiles to users using all oracle versions.
• Strong RDBMS concepts including expertise in Transact-SQL queries like DML, DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers, and Cursors etc.
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.

Education Qualifications:
Master’s in computer science.

Skillset:
OBIEE 10.x, Informatica, BI Publisher, SQL Server, Oracle 8i/10g/11i, Teradata v7, 12 MS Access, MYSQL, MS Visio, MS Project, MS Excel, Erwin 4.0, SQL*Plus, TOAD, SQL, PLSQL, Windows NT/2000/XP, UNIX, Linux, HTML, XML and JavaScript.

Projects Summary:

Confidential,Illinois 3/2009 Present
OBIEE Sr. Developer
Walgreen’s is the largest drugstore chain in the United States. Walgreen’s provides access to consumer goods and services and pharmacy, health and wellness services in America through its retail drugstores, Walgreen’s Health Services division and Walgreen’s Health and Wellness division.
The project provides sales and order Analytics solution to enhance data analysis and track their products. It also focused on developing reporting services for a supported Data Mart and also supported high availability ad-hoc reportingand various detail and summary reports.
Hardware/Software:
OBIEE7.8.4, 7.x, Informatica 6.2/7.1.1, Oracle BI Applications 7.9.3, Oracle 10g, Oracle Reports 6i, PL/SQL Procedures, Putty, SQL*Plus, TOAD, Windows 2000.

Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical sourcetables, logical columns, and also validating repository level calculations done in the business model layer.
• Developed OBIEE Repository per user requirements and available information in DW.
• Implemented security by creating roles and web groups, checks with External tables and LDAP.
• Extensively usedOBIEEAdmin tool to import the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool
• Developed multiple Dimensions (Drill-Down Hierarchies) and Logical and Facts / Measures objects in Business Model Layer, and has successfully created the Presentation catalogs in Presentation Layer.
• Developed Dashboards such as Default Dashboard for the users when after login directed to a default dashboard based on the department they work
• Successfully developed row based calculations in a pivot table for the reports based on sales RPD.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Had developed chart and tabular reports for the to total sales for Quarterly, half-yearly and annually using global and local filters.
• Scheduled iBots and seeded server cache using Delivers to improve system performance.
• Developed iBots such as “Purje”to clear server cache using NQCmd utility and had developed Scheduled reports to be e-mailed using iBots.
• Developed and debugged Dashboards/ reports visibility with respect to user’s responsibility and web groups in an integrated environment.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Developed / modified mappings per gaps identified.
• Used TOAD for Oracle and SQL Navigator to connect to databases in Oracle.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Confidential, Georgia 3/2008 2/2009
OBIEE Developer
Alere is a leader in specialized health management services incorporating in-home monitoring devices for medium- and high-risk patients and complex case management. The purpose of project was to implement OBIEE analytics which would provide automated reports, dashboards and answers for ad-hoc reporting to the Sales Management for efficient and effective sales of the organization.
Hardware/Software:
OBIEE 10.1.3.4, DAC, Oracle BI Apps 7.9.5/7.9.6 (Financial Analytics), Oracle EBS, Informatica 8.1.1, Oracle 10g, Windows XP.

Responsibilities:

• Actively involved with Business team to gather user requirements.
• Developed proof of concept to check the functional feasibility of the project.
• Install, configure, and administer the OBIEE platform.
• Interacted with Systems Engineering team to design - Facts and Dimensions for Repository.
• Involved in RPD Development, Oracle BI Server, Oracle BI Answers, DAC Configuration, ETL Configuration, and Oracle BI Publisher
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Extracted data from Various ERP Systems like Siebel OLAP database, Oracle E business Suite (EBS).
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Identified granularity level of the data required to be available for analysis.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads.
• Prepared Detail Design Document for Repository.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
• Developed performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations, aggregate navigation, cache management, Oracle materialized views.
• Created measures in Administration tool for the requirements using expression builder and calculation wizard.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security.
• Developed simple and complex mappings using Informatica to load Dimension and Fact tables as per STAR schema techniques.
• Used filters and provided customized prompts to avoid excessive data showing up in the reports
• Created iBots such as “NAME” ibot to retrieve the details of the person and delivered it to target users.
• Installed and set up Informatica environment and responsible for administration and migration or repositories between various environments
• Loaded the data from flat files into oracle tables using Informatica with any data cleansing required.
• Worked for performance tuning by finding out the bottlenecks in various mappings.
• Developed complex mapping informatica such as SCD@ mapping for customer dimension to keep history of the account.
• Handled errors such as “source file doesn’t exist” while running various sessions..
• Expert in Developing the Dimensions and Time Series Objects in the BMM Layer with Security settings in Siebel Analytics Admin Tool to setup groups, access and query privileges.

Confidential, NY 8/2006 2/2008
Oracle Business Intelligence Developer
Citigroup Inc., is a major American financial services company based in New york, NY. A data warehouse was developed in line with the business strategy to perform advanced analysis of the customer data to help enhance and offer better service based on their needs. The purpose of the project is to obtain the data about the customers from different systems and aggregate within the data warehouse using Informatica and develop interactive reports for the users to keep track about the financial trends taking place in the company through OBIEE.
Hardware/Software:
OBIEE 10.1.3.4, Informatica Power Center 7.1, Oracle BI Apps 7.9.5, CRM, DAC, Oracle 10g.

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Interacted with client to understand/clarify requirements and suggest enhancements.
• Designed Star schema for fact and dimensional tables and created aliases for the dimensional tables when necessary.
• Developed Physical Layer, Business Model and Mapping and Presentation Layer using Oracle Business Intelligence Administration Tool.
• Specified dimensional hierarchy, aggregate levels for the dimensions.
• Developed reports such as “PAYROLL SUMMARY” for the employers using OBIEE Answers.
• Developed filters on” CREDIT REPORT” to restrict the data access for clients and users.
• Designed and Configured Intelligent Dashboards such as “MY BANK”for different groups of users which include business users from various parts of the world.
• Managed Web Catalog to set up groups, access privileges and query privileges.
• Created iBots to alert the Marketing team about business changes.
• Improved the Performance of the Reports by moving huge calculations to the Database and by using the Aggregate tables and Cache management.
• Involved in developing the Incremental ETL process by Informatica Mappings and Mapplets using various Transformations.
• Used Informatica workflow manager and work flow monitor to schedule and monitor sessions.
• Designed and Developed ETL strategy to populate the Data Warehouse from the various source systems feeds using Informatica Power Center.
• Imported Sources and Targets Databases, Created Mappings and developed Transformations using Informatica Power Center.
• Extensively used Transformations like Source Qualifier, Lookup, Expression, Router, Aggregator, Joiner and Sequence generator.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Designed and developed PL/SQL Procedures, Triggers and Packages for implementing business logic.

Confidential,CA 12/2004 7/2006
Oracle PL/SQL Developer
Kaiser Permanente is an integrated health care organization which is an association of three distinct entities groups; the Kaiser Foundation Health Pan,Inc.and its regional operating oraganizations,the Permanente Medical groups and Kaiser foundation Hospitals.
This Project mainly deals with worker compensation insurance used by the corporate companies. Scope of the project was to maintained different kinds of accounts with their premium, claims, and new accounts.Hardware/Software:
Oracle 8i, SQL, PL/SQL, SQL *PLUS, Forms 6.i, Reports 6.i, UNIX, Window NT.

Responsibilities:

• Involved in developing Complex SQL & PL/SQL code for developing various kinds of adhoc reports.
• Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL* Loader.
• Created external tables for loading data from flat files using Oracle Loader
• Created DTS packages for loading data from oracle tables to SQL Server.
• Created automated packages for daily, weekly & monthly backups.
• Identifying logs in case of errors in loading the data.
• Developed various PL/SQL stored procedures, functions and packages.
• Involved in loading the data to server using UNIX Reflections.
• Worked on Perl scripting to load the data file to tables.
• Interacted with various applications built on .Net.
• Worked on resolving complex adhoc issues that occur after each run of code.
• Developed PL/SQL scripts for regular maintenance and production support to load the data in regular intervals.
• Worked on performance tuning of the SQL code.
• Worked on Indexing and partitioning of the tables.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Involved in documentation of the code & packages developed

Confidential, India 6/2003 11/2004
Oracle developer
HSBC is one of the largest banking and financial services organizations in the world. Through an international network linked by advanced technology, HSBC provides a comprehensive range of financial services to individuals, businesses and institutions
Central Data Module is a financial services application dealing with data related to Online Banking, Equities, Fixed Income Mutual Funds, Bonds, etc. The application enables the customers to trade the stocks along with providing real time quote information and news
Hardware/Software:
Oracle 7x, SQL, PL/SQL, SQL* Plus, TOAD, UNIX

Responsibilities:

• Monitoring use of the system, troubleshooting problems, conducting
• Developed PL/SQL stored procedures, user defined functions for complex rating calculations and bundle them into stored package that could be invoked from the Forms triggers
• Developed various UNIX Shell Scripts to automate the routine tasks
• Designed interface for the system.
• Created PL/SQL scripts for data transformation in line with program specifications.
• Creating temporary tables and indexes for loading and updating data.
• Designed and Developed Stored Procedures, Packages and Functions using PL/SQL and SQL Scripts.
• Used SQL*Loader to load data using direct and indirect path.
• Developed database Procedures to handle Partition Deletion and Truncation automatically based on data loading criteria using Dynamic SQL.
• Developed shell scripts for database replication processes.
• Table layout design, table space management and user maintenance.