Summary

Strong developer with extensive experience in transactional databases and data warehouse design, analysis and implementation using Microsoft SQL server 2005/2008 with proficiency in delivering BI Solutions.

Education

Master of Science

• Logical and Physical data model design along with normalization/de-normalization
• Strong T-SQL programming
• Development of stored procedures, UDF's, Triggers, Views
• Performance Tuning using Indexes, table partitioning, execution plan analysis and SQL profiler
• ETL design and implementation using SSIS
• SSAS cube and cube object design, development and optimization
• Report development, optimization and delivery using SSRS

Sep 2011 - Current

Technologies:
MS SQL Server 2005/2008, SSIS, SSRS, BIDS, SYBASE, Rapid SQL, Crystal Reports,
MS Excel, SharePoint.

Dec 2010 - Aug2011

Technologies:
MS SQL Server
2005/2008,
SSIS, SSAS, SSRS,
ER Win,
BIDS, XML

May 2010 -Dec 2010

Technologies:
MS SQL Server
2005/2008,
SSIS, SSAS, SSRS,
ER Win, Windows Server 2003 / 2008

Oct 2008 - April2009

Technologies:
MS SQL Server
2000/2005,
SSIS, SSAS, SSRS,
ER Win, BIDS

Confidential, Meridian, ID
Sr. Data Warehouse/BI Developer
Implemented a new system for Blue Cross to bring dental process in house and created feeds and reports that would aid in financial analysis and processing claims in Facets.

Responsibilities:

• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Familiar with different SDLC methodologies like Waterfall, RUP, Spiral and XP also understanding of various phases in these methodologies.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Created database documentation for table and column dictionaries and other reference material.
• Responsible for the indexing and performance tuning of the queries.
• Analyzed physical data model for ETL mapping.
• Designed the ETL process using SSIS Packages in which the data sources include SQL, Sybase, and flat files.
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations as well as database maintenance tasks like defragmentation, re-indexing, and recompiling stored procedures.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Developed various automated as well as ad-hoc SSRS reports as per the business requirements.
• Migrated existing DTS packages to SSIS and Crystal Reports for Accounting into SSRS.

Confidential, Los Angeles, CA
Sr. BI/ETL Developer
Data Marts for insurance departments were created that would also drive the multidimensional cubes and generate reports that would aid in business analysis.

Responsibilities:

• Designed logical and physical models for star schema based data marts using ER-Win.
• Created objects such as: Stored Procedures, Triggers, User define functions, Indexes, Views.
• Optimized performance of the queries running against the data mart by creation of Table Partitions, Indexes and Indexed Views.
• Implemented various integrity constraints and triggers for data integrity and SQL features like complex joins, sub-queries, ranking functions etc.
• Managed the entire ETL process involving the extraction, manipulation, loading and presentation of data from heterogeneous data sources to aid financial analysis using SSIS.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Optimized the ETL process at extraction, transformation and loading levels and also incorporated error handling using event handlers, checkpoints and logging.
• Implemented custom SSIS functionality using the Script task component.
• Implemented the multidimensional cubes on Analysis Services (SSAS) and built Key Performance Indicators, actions and Calculated Members.
• Optimized cubes using proper partitions across storage modes, proactive caching and usage based optimization.
• Created multiple reports such as linked reports, sub, drill through and drill down reports depending upon the client's need.
• Hands on experience in managing Reporting Server and creating ad-hoc reports from OLTP and OLAP including its delivery using push and pull delivery methods.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.

Confidential, Los Angeles, CA
SQL/ETL Developer
The Project intended to introduce major enhancements in the existing data warehouse and create a new data mart dedicated to the Custom Relations and Marketing department that would allow them to better analyze their business strategies.

Responsibilities:

• Worked closely with Business Owner, Project manager, subject matter experts and system architecture to define business requirements and create business requirements documents as well as functional specifications.
• Remodeled existing DW as well as create logical and physical data model for the new data mart.
• Created objects such as: Stored Procedures, Triggers, User define functions, Indices, Views, and Index views.
• Created fact tables with new measures at different granularity levels and maintained a relation with the fact tables through alternate keys.
• Analyzed the historical data and extracted required data using both T-SQL and SSIS to support the management decisions.
• Added event handlers, loggings, checkpoints, transactions and configurations to SSIS packages for better error handling, manageability as well as performance.
• Involved in full life cycle of Reporting starting from the Authoring phase, the Management phase all the way to the Delivery phase
• Responsible for identifying and defining the Datasets for the report generation, writing the queries for the drill down reports, and identifying and adding the report parameters.

Confidential, India
Database Developer
The project included the development of a data warehouse and design of data mart cubes in support of retail and financial application. Project involved creation of Data Base objects right from designing the databases to the creation of its physical instance. The end result of the project included creation of custom interactive reports that could be appropriately sent to the end clients.

Responsibilities:

• Involved in design and development for Retail Inventory Management Project
• Design/develop database using SQL SERVER 2000/2005
• Created High level Normalized Database and Detailed Design using Erwin.
• Wrote stored procedures, tables, triggers, indexes and views using Detailed Design Specifications.
• Performance tuned queries, assigned proper Indexes for better performance.
• Prepared Patch and upgrade scripts for service packs and new releases
• Data Migration with MS Access, Excel and Text files and scheduling tasks using DTS/SSIS
• Used BCP and DTS utility for Meta data transfer across servers.
• Prepared trace files using SQL profiler to fine tune the application
• Used visual source safe as configuration management tool.
• Involved in the integration, system and User Acceptance testing phase.