SUMMARY OF QUALIFICATIONS:

• SEVEN years of experience as an IT professional with prime focus on Research, Analysis, Design, Development, and Testing under Business Intelligence, Data Warehouse Design and Client-Server environment.
• SEVEN years of progressive experience as a Database Developer, FOUR years of experience as an OBIEE Developer and THREE years of experience as a SQL Server Developer.
• Hands on experience in relational and dimensional, conceptual, logical and physical data modeling in both OLTP and OLAP systems using ERwin tool.
• Experience in creating and Scheduling BI publisher reports based on ORACLE database.
• Experience in architecting the data flow including data modeling. Expert in Dimensional and Relational Data Modeling Schemas like Ralph Kimball’s practices in designing Star Schema.
• Experience as a Data Architect in Data Warehouse (DWH) Design.
• Utilized Informatica to integrate data within the data models and implemented transformations (join, lookup and filter).
• Some experience in Oracle RDBMS, Oracle Warehouse Builder, Informatica, and Oracle Data Integrator in Oracle 10g.
• Expert in developing repositories and modeling metadata in the Oracle BI Administrator Tool layers (physical, business model and mapping, presentation).
• Highly experienced in designing and implementing Oracle Business Intelligence web catalog objects - dashboards, pages, answers and front end designs.
• Worked Extensively on Oracle BI Administration Tool, Oracle BI Web / Presentation Services, Answers, BI Publisher, scheduling iBots using BI delivers.
• Experienced in analyzing the data quality of the system. Excellent in performing tuning activities for improved efficiency of the database.
• Proficient in SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
• Experience in implementation of Extract, Transform and Load (ETL) Strategies to populate Data Warehouses and to perform Incremental Loading using Informatica Power Center.
• Experience in logical database design, normalization and forward engineering in ERWin Data Modeler.
• Experience in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.
• Generated complex T-SQL queries using features like Joins, sub-queries, CTEs and dynamic SQL.
• Optimized SQL Server performance using SQL Server Profiler and Database Engine Tuning Advisor
• Good skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined functions.
• Good understanding of SQL Server Analysis Services (SSAS).
• Experience creating Ad hoc reports with SQL Server Reporting Services (SSRS).

TECHNICAL SKILLS
Business Intelligence Tools : OBIEE 10.1.x, SQL Server 2005,
ETL Tool : SSIS 2005, Informatica Power Center 8.x
Databases : Oracle 9i/10g/11g, SQL Server
Data Modeler : Erwin Data Modeler
Languages/ Technologies : T-SQL, PL/SQL, MS Visual Studio
Operating Systems : UNIX (Sun Solaris, HP-UX, Linux), Windows server, 2003 Windows
XP/2000/Vista/Win 7

PROFESSIONAL EXPERIENCE

Confidential,Florham Park, NJ Aug ‘10 – Present
OBIEE Developer

Confidential,is a privately owned, dermatology-focused pharmaceutical company focused on specialty pharmaceuticals in dermatology and is the leading manufacturer of topical pharmaceutical products in the U.S. The project was to develop a BI Solution for their sales and marketing department.
Roles and Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Developed OBIEE Repository as per user requirements and available information in Data Warehouse.
• Analyzed and validated the business model in OBIEE Administration Tool and also validated repository level calculations done in the business model layer.
• Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Developed many Reports / Dashboards with different Views (Drill-Down / Dynamic, Pivot Table, Chart, Tabular with global and local Filters) using OBI Answers.
• Worked on Enterprise, Manufacturing and Project Management Dashboards to show KPI, stoplight indicators and view selectors.
• Recommended enhancements in ETL processes and Business Models to suite user requirements.
• Created highly formatted reports using BI Publisher based on requests from Answers to output in pdf and HTML.
• Trained Users on Ad-Hoc Reporting and documented the work.

Environment: OBIEE 10.1.3.4.1, Oracle 10g, Oracle BI Publisher, Oracle BI Dashboards, Informatica 8.6,
DAC, UNIX, SQL*PLUS

Confidential,Tampa, FL Jan ‘09 – Aug ‘10
OBIEE Consultant

Confidential,is a Fortune 500 company that provides a wide array of financial products and services to individuals, small businesses, and commercial clients. Capital One\'s major business areas include credit cards, auto financing, branch banking, small business financial services, commercial banking products, and personal loans. The aim of the project is to design and develop a single Metadata Repository for their integrated Data Warehouse for reporting.
Roles and Responsibilities:

• Worked with the Business Analysts for requirements gathering, testing, metrics.
• Inspected and recommended workflows for the ETL processes which are used to extract historical and latest Transaction, and FDIC information from ODS tables.
• Involved in running procedures to get the data refreshed as per last update date.
• Designed Custom Star Schema for Related Loans and merged with the existing subject area.
• Involved in enhancing Business Models for improved request performance
• Used MUD to create the RPD.
• Analyzed and added enhancements to Metadata in all 3 layers (Physical, Business and Presentation).
• Developed Reports using Answers to build application specific Dashboards.
• Scheduled ibots to deliver daily emails on updates of Related Loans.
• Involved in Setting up Security, Users & Groups.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the reports that are generated from BI Analytics.
• Trained end-users to build Ad-hoc reports using OBIEE.

Environment: Oracle BI (10.1.3.x), Oracle 10g, Oracle BI Publisher, Oracle BI Dashboards, Informatica 8.1

Confidential,Vincennes, IN Jan ‘08 – Nov ‘08
OBIEE Developer

Confidential,is an Illinois-chartered, privately held, full-service bank with nearly 50 Chicago area locations and more than $2.5 billion in assets. First American has the strength and stability that come from a consistent, diversified earnings stream, strong internal equity generation, sound asset quality, and a liquid and conservative balance sheet. The goal of the project was to analyze and enhance the growth opportunities in terms of online banking.
Roles and Responsibilities:

• Involved in the design and set up of Dev, Test and Prod environments.
• Worked with the Financial Services staff and Business Analysts for requirements gathering, business analysis, testing, metrics and project coordination.
• Used Informatica to extract data from OLTP source to OLAP destination.
• Customized and developed Repository, Configured Metadata Objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Monitored ETL mappings as per report requirements Developed Custom Reports/Ad-hoc queries using OBI Answers and assigned them to application specific Dashboards
• Created Custom Star Schema as per the business requirements Configured and Created repository using OBIEE Admin tool.
• Created hierarchy based Dashboards for different Business units and end-users.
• Used BI Publisher to customize Answers requests to output in pdf and html formats
• Involved in Unit, System and Integration Testing and Performed Data Validation for all the reports that are generated from BI Analytics.

Environment: OBIEE 10.1.3.4, Oracle10G, Oracle BI Publisher, Oracle SQL developer, Informatica 7.1

Confidential,Greenwood, IN June ‘06 – Dec ‘07
MS SQL Developer

Confidential,is a global pharmaceutical company. Eli Lilly\'s global headquarters is located in Indianapolis, Indiana, in the United States. The purpose of this project is to create the Data warehouse, set up SQL Server to perform partial and full load of extracts and produce customized reports.
Roles and Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business users.
• Improved the performance of production reports by analyzing the underlying query and report objectives.
• Documented the existing and newly created production reports and shared them through the share point server.
• Created SQL server Reports on different plans using SSRS for the manager and the brokers involved.
• Interact with the business community to functionally analyze requirements and design reports either from Legacy data sources or from the data warehouse.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created parameterized reports and ado reports using Report builder for the users and management.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
• Using SSIS effectively to grab the required data to create and test the reports.
• Performed debugging and resolved data issues occurred while accessing the reports in QA and Production environments.
• Designed various test cases for migrated reports testing.
• Created views for security purposes, implemented rules, defaults, and user defined data types.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: MS SQL Server 2005, SSRS, SSIS 2005, T-SQL, Visual Basic 6.0, Performance Point,
Data Analyzer, Visual Studio 2005, MS Access, Excel, SQL Profiler, Windows XP, Erwin

Confidential,Carmel, IN April ‘05 – May ‘06
MS SQL Server Developer

Confidential,is one of the largest life insurance companies in the U.S. The project was to create a database for the Manager Incentive Plan (MIP) which was used to calculate the incentive for the managers during the fiscal year based on the revenue and sales.
Roles and Responsibilities:

• Created Logical and Physical data models using ERWIN data modeling tool.
• Developed complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Tested the reports and fixed bugs in Stored Procedures, Tables and Triggers.
• Schedules and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
• Extensively handled the issues like risk management and P&L with the help of reporting services.
• Developed and edited reports with Crystal Reports 9.0.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Planned the complete back-up of databases for disaster recovery scenarios.

Environment: MS SQL Server 2000 Enterprise Edition, MS Access, DTS, T-SQL, Query Analyzer, BCP,
SQL Profiler, Windows 2000 Server, ASP .Net, Erwin 4.0, Crystal Reports 9.0

EDUCATION:
Bachelor of Science in Electrical Engineering
Bachelor of Science in Mathematics