Summary:

• Oracle Corp trained OBIEE developer with seven plus years of IT experience, with primary focus on Data Warehousing, Data Mining, BI, Data Modelling and SQL.
• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges) and scheduling iBots.
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.
• Involved in designing & implementing complex ETL/BI systems.
• Expertise in End to End system design, System Feasibility study, system redesign/engineering and implementation with significant experience in Data Modelling/Data Quality Analysis.
• Strong domain knowledge in Retail Industry - Involved in Marketing, Sales and Customer Analytics
• Developed and Implemented Market Basket Analysis and RFM Analysis forRetail Clients.
• Worked on ETL and BI tools like Informatica, MS DTS, Oracle Business Intelligence Enterprise Edition Plus (Siebel Analytics), Oracle OLAP, Microsoft BI Development Studio (SSRS, SSAS & SSIS) and Databases like Oracle 11g & MS SQL Server 2005.
• Got strong analytical & problem solving skills using Structured Query Language and MDX.
• Gathered Business requirements by interacting with the business users.
• Performed gap analysis and feasibility study for the given requirement.
• Strong knowledge in RDBMS.
• Extensive experience in testing the Data Warehouse and Business Intelligence applications.
• Got good pre-sales consulting skills.
• Worked on various RFI’s, RFP’s and POC’s.
• Self-motivated; able to work independently and in teams; can handle multiple projects while paying attention to details.
• Ability and desire to mentor/coach others in a team environment.

Technical Skills-
ETL Applications: Informatica Power Center 6.2, 7.1.3, SSIS, Microsoft DTS, DAC v10.1.3.4.1
BI Applications: Business Objects 5.1.7, 6.5, SSAS, SSRS, Oracle OLAP 11.07, OBIEE v10.1.3.4.0
RDBMS: Oracle 10g, 11g, DB2, MS SQL Server 2000 & 2005, MS Access 2000
Case Tools: ERwin, Visio, Oracle SQL Developer, TOAD
Languages/Other: SQL, MDX

APPLICATION DEVELOPMENT

• Business requirement gathering, Defining and documenting business, technical & functional specifications, Business and technical team coordination.
• Strong Knowledge in ETL and Reporting Architecture design/implementation with expertise in Informatica, OBIEE & MS BI Studio.
• Well versed with Data Modelling/UML/Data Quality Analysis/ETL/BI application design and implementation.
• Experienced in Data Quality Analysis, identification data issues and gap assessment.
• Proven track record of successfully delivering database application, system optimization and performance tuning of critical ETL and BI applications.

EDUCATION 
Master of Computer Applications 
Bachelor of Science in Computer Science

TRAININGS
Advanced Oracle Business Intelligence Analytics, Oracle Corporation
Oracle Olap 11.07, Oracle Corporation
Sandlers pre-sales training, Oracle Corporation

Work Experience-

Confidential
July 2008 to Current
Client: Oracle Corporation / Bank of America,First American, Care First, Click Commerce, University of Georgia
Role(s): OBIEE Analyst/Developer.
Responsibilities:

• Conducted research and analysis of business requirements, problems and available technologies to define systems solutions that increase efficiency and effectiveness.
• Involved in translating functional requirements into technical requirements.
• Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications.
• Analyzed and used various data sources – DB, XML, Excel, and OLAP.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modelling.
• Customized and developed RPD (Physical, BMM and Presentation Layer).
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics web.
• Configured OBIEE iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.
• Performed Unit, Integration, and Regression testing to validate report.
• Used MS office plug-in for analyzing data.
• Implemented write back functionality.
• Created pixel perfect reports using BI Publisher.

(March 2007 - June 2008) - ETL-B I Analyst/Developer
Confidential
Client:Confidential
Environment: OBIEE v10.1.3.2, Oracle 10g, MS SQL Server 2005, Windows XP
Roles: OBIEE Analyst/Developer
Project Description: Confidential founded and head quartered in Satsop, Washington, designs and rapidly deploys online support environments that transform and optimize customer support interactions. Since 1998, SafeHarbor has implemented more than 100 customer support solutions. The SHTC data warehouse provides information quickly and in a format that greatly enhances the decision making process. 
Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and feasibility study for the given requirement.
• Created mock-up reports and dashboards for review by the business users.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.
• Created materialized views and aggregates to improve performance.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Involved In Analyzing the ER-Diagrams.
• Optimized/Tuned the database design.
• Performed Data Validation of data in the reports and dashboards.
• Involved in Data migration and Data distribution testing.
• Extensively used SQL Tuning to improve performance.
• Created iBots to send pre-processed reports using OBIEE Delivers.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
• Documented the design for intuitive understanding and future reference.

(April 2006 - February 2007 ) - ETL/BI Developer
Confidential
Client: Confidential
Industry: Retail 
Organization: Third Wave Software Solutions 
Duration: December 2006 to Feb 2007
Environment: SQL Server 2005, SSIS, DTS, SSAS, SSRS, SAS ETL, Windows NT
Roles: ETL/BI Developer
Project Description: Confidential is a full-line manufacturer founded in Thomasville, North Carolina, in 1904. The high standards and vision exemplified by Thomasville have made it an unquestioned leader in home furnishings. Its furniture is sold through a network of more than 150 independently owned Thomasville Home Furnishings Stores, as well as over 400 leading independent retail stores. The Thomasville MIA identifies consumer trends, analyze sales data, measure marketing effectiveness, manage campaign, create mailing lists and create financial plans for the entire organization from store to supply chain.
Responsibilities:

• Involved in Analysis and design phase.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Performed Sales and Customer Analysis.
• Performed RFM Analysis and implemented CRM Module.
• Wrote complex SQL Sub-Queries to analyze and test the database.
• Developed OLAP Cubes using SSAS (SQL Server Analysis Services).
• Created various Ad Hoc reports using SSRS (SQL Server Reporting Services).
• Used MDX to test the cubes.
• Ensured accuracy of data in reports.
• Involved in Unit testing and Integration testing.
• Optimized/Tuned queries for better performance and efficiency.

Experian Data Warehouse:
Organization: Confidential
Duration: November 2006 to December 2006
Environment: SQL Server 2005, SSIS, DTS, Windows NT
Roles: ETL Developer
Project Description: Confidential providing value-added information solutions to organizations and consumers. It provides information, analytics, and decision making solutions and processing services. Using its comprehensive understanding of individuals, markets and economies, it helps organizations to find, develop and manage customer relationships to make their businesses more profitable. Experian promotes greater financial health and opportunity among consumers by enabling them to understand, manage and protect their personal information. Third Wave maintains a Data warehouse from the data provided by Experian every quarter.
Responsibilities:

• Utilized SSIS & DTS to produce a Data Mart for reporting.
• Involved in Data Modelling.
• Involved in Unit testing and Integration testing.
• Wrote complex queries to analyze and test the data warehouse.

GBDI System:
Client: Confidential 
Organization: Confidential 
Duration: October 2006 to November 2006
Environment: MS SQL Server 2005, DTS, Analysis Services, ASP.NET, SAS ETL, Windows NT
Roles: ETL & Database Developer
Project Description:
Established in 1919, Confidential is an independent, non-partisan voice working to address major threats facing the National Park System in America. The GBDI is an Intelligence Reporting System, which offers NPCA to mine various information such as Geographic and Business demographics surrounding a National Park and thus helps NPCA to address major threats facing the National Park System.
Responsibilities:

• Understanding the customer requirements.
• Analyze and test the raw data.
• Did Extraction, Transformation and Loading of data into the database using DTS and SAS ETL.
• Wrote complex SQL Sub-Queries to analyze and test the database.
• Developed OLAP Cubes using MS Analysis Services.
• Used MDX to test the cubes.

RC Willey MIA:
Client: Confidential 
Industry: Retail 
Organization: Confidential 
Duration: April 2006 to September 2006
Environment: SQL Server 2005, DTS, SSIS, SSAS, SSRS, SAS ETL, Windows NT
Roles: ETL/BI Developer
Project Description: Confidential is a leading home furnishings and electronics chain based in Salt Lake City, Utah. The company has grown into the biggest furniture dealer west of the Mississippi by offering a huge selection, convenient credit, and prompt delivery. R.C. Willey stocks its dozen stores from a nearly 900,000 square-foot distribution centre, said to be the largest of its kind in the country. The R.C. Willey MIA identifies consumer trends, analyze sales data, measure marketing effectiveness, manage campaign, create mailing lists and create financial plans for the entire organization from store to supply chain.
Responsibilities:

• Involved in Analysis and design phase.
• Did Extraction, Transformation and Loading of data into the database using SAS ETL, MS DTS & SSIS.
• Performed Sales and Customer Analysis.
• Performed RFM Analysis.
• Implemented CRM Module.
• Wrote complex SQL Sub-Queries to analyze and test the database.
• Developed OLAP Cubes using SSAS (SQL Server Analysis Services).
• Used MDX to test the cubes.
• Involved in Unit testing and Integration testing.
• Optimized/Tuned queries for better performance and efficiency.

(June 2003 - March 2006) - ETL Developer
S3 Offshore:
Client: Confidential 
Industry: Confidential 
Organization: Facets Technologies
Duration: February 2005 to March 2006
Environment: Oracle9i, Informatica Power Center 6.2, Windows NT
Role(s): ETL Developer
Project Description: South-West is a customer-focused, regional company providing a broad range of insurance and alternative risk management products and services. The South-West Insurance Group Data Warehouse is envisioned as the single, integrated relational database application that will be the repository for South-West Insurance Group\'s Decision Support data. The information in this repository will be reconciled at input with the source applications, standardized, and provided online to service personnel, business leaders and agents.
Responsibilities:

• Understand the Data Model for Enterprise Data warehouse and Data marts.
• Developed various Informatica Transformations, Mappings and Workflows for migration of data from various systems to the new system using Informatica Designer.
• Wrote complex sql queries to test the data warehouse.
• Involved in Unit testing:
• Involved in testing whether ETLs are accessing and picking up right data from right source.
• All the data transformations are correct according to the business rules and data warehouse is correctly populated with the transformed data.
• Tested the rejected records that don\'t fulfil transformation rules.
• Involved in Integration testing:
• Tested sequence of ETLs jobs in batch.
• Initial loading of records on data warehouse.
• Incremental loading of records at a later date to verify the newly inserted or updated data.
• Tested the rejected records that don\'t fulfil transformation rules.
• Optimized/Tuned mappings for better performance and efficiency.

Enterprise Telecommunications Data Warehouse (ETDW):
Client: Confidential 
Industry: Telecom
Organization: Facets Technologies
Duration: June 2003 to January 2005
Environment: Oracle9i, Informatica Power Center 6.2, Business Objects 5.1.7,Windows NT
Role(s): ETL/BI Developer
Project Description: The Confidential is a complete communications service and consulting company which offers a diverse line of products for many different communications needs. They have got various types of data related to Inventory, Purchase, Vendor, Call, Financial details and etc. A diagnostic Enterprise Data Warehouse System is built for the telecommunications company, which would provide proactive rather than reactive support capabilities help to avoid any future emergency situations and allow early detection of reductions in call volumes.
Responsibilities:

• Understand the Data Model for Enterprise Data warehouse and Data marts.
• Used Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Transformations and Informatica Repository Manager for ETL.
• Involved in Unit testing and Integration testing.
• Optimized/Tuned mappings for better performance and efficiency.
• Involved in requirements gathering, schema design and development using Business objects.
• Created BOMAIN using BO supervisor and added users and set profiles for each user.
• Configured BCA and Client Setup.
• Created Universe using BO designer, created joins between the classes, detected the type of joins, checked for cardinality and parsing of objects, resolved traps, did integrity check, exported the universe to the repository.
• Designed Reports and used Infoview to access documents.

(May 2002 to May 2003) -Programmer
Creation and Maintenance of Loan Accounts:
Industry: Banking
Organization: Confidential 
Environment: IBM S/390, Z/OS, COBOL VS II, JCL, CICS, DB2
Role(s): Trainee Programmer
Project Description: The main aspect of this project is about creation of loan accounts in the area of Enterprise Computing on IBM Mainframe Applications.
Responsibilities:

• Took part in documenting business requirements of the end user based on their functional and operational domains.
• Involved in Data modelling, design and implementation of the mainframe application.
• Created tables for various transactions in DB2.
• Developed various UI screens using CICS.