Professional Summary:

• Over3 years of experience in IT as a professional specializing in MS SQL Server 2008/2005, Physical/Logical design, T-SQL, Optimization, Troubleshooting, SSIS Package Designing, SSRS and SSAS.
• Extensive experience in performance tuning, query optimization, database optimization and data integrity.
• Experience in Microsoft SQL Server 2005/2008 BI Studio, SSAS, SSIS and SSRS.
• Strong experience creating data models for relational schemas (OLTP) and dimensional schemas (OLAP) with proper normalization and de-normalization techniques.
• Extensive Experience T-SQL to write Stored Procedures, Batches, Views and complex queries.
• Created complex ETL strategies to support various organizational needs depending upon the requirements.
• Managed the SSIS packages to the fullest depth and successfully executed the packages using various execution techniques.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Supported the migration of data from heterogeneous sources and different formats to relational data warehouses , staging databases using complex stored procedures , SSIS packages as well as command prompt scripts
• Created SSIS packages to maintain the source databases as well as the data warehouse and processes cubes using SSIS tasks.
• Experience in auditing SSIS packages using SSIS logins or custom log, as well as responding programmatically to errors using several work flows in the event handlers.
• Excellent experience in creating reports like drill down reports, sub reports, parameterized reports, cascading reports as well as ad-hoc reports using report builders.
• Solid practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables modeling of data at all the three levels: view, logical & physical.
• Adaptive and quick learner with excellent communication & interpersonal skills.
• Excellent Analytical and Problem Solving Skills.

Technical Skills

DATABASES: Microsoft SQL Server 2000, 2005, 2008/R2
DATABASE TOOLS: Management Studio, Profiler, ER-Win
DATABASE LANGUAGES: SQL, T-SQL
PROCEDURAL LANGUAGES: C, C++
BUISNESS INTELLIGENCE: BIDS, SSIS, SSAS, SSRS
DATABASE MODELING: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas
WEB LANGUAGES: HTML, XML
OPERATING SYSTEMS: Windows XP, Windows 2000/2003/2008 Server

Work Experience

SQL/BI Developer

Responsibilities:

• Worked with Business Analysts and end users for gathering detailed requirements and specifications.
• Analyzed functional specifications and designed dimensional data models using star schema for the data warehouse.
• Created various SQL server objects like stored procedures, functions and views as per the logic to be implemented.
• Optimized T-SQL scripts and stored procedures used to feed reports and implemented ETL logic for faster loading and processing.
• Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle, excel, flat file etc. into the SQL Server staging area.
• Designed SSIS packages for implementing the ETL process with proper error handling and optimization.
• Developed SSIS templates which included loggings and error notifications for implementation into final packages to fasten the development of packages.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Automated the execution of packages by implementing a Master Child package model and scheduling jobs using SQL Server Job Agent.
• Involved in managing Reporting Server and creating ad-hoc reports from OLTP and data warehouse.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Optimized reports by optimizing the embedded queries and using caching and snapshot features of SSRS.
• Configured Report Server and scheduled report delivery using Data Driven Subscriptions in SSRS.

Confidential, Pasadena, CA (Healthcare Company) January 2010 - January 2011
SQL/DW Developer

Responsibilities:

• Extensively involved in gathering business requirements as endeavor that will facilitate the planning and implementation phase of a data warehouse / data mart.
• Supervised in designing Logical data models for the Data Mart and in implementing the logical design to the physical design by creating tables.
• Created databases objects like stored procedures, views, user-defined functions and triggers to implement the business process logic.
• Optimized and restructured the Approval Workflow Stored Procedure for the application by evaluating Execution Plans, indexing and Partitioning large tables.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Designed, Created and Implemented complex ETL Strategies using SSIS Packages that extracted the data from different heterogeneous sources like Flat Files, Excel Files and dumped it into a centralized Data mart.
• Made use of Event Handlers, Loggings, Breakpoints and Data Viewers for effective debugging of packages.
• Created cubes and scheduled cube processing from staging database table using SQL Server Agent
• Created Drill Down, Drill Through, Sub and Linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Optimized reports by setting proper caching, snapshots, subscriptions

Confidential, Ahmadabad, February 2007 - March 2008
MS SQL Server /ETL Developer

Key Results:

• Extensively involved in gathering business requirements as endeavor that will facilitate the planning and implementation phase of a data warehouse / data mart.
• Designed, Created and Implemented complex ETL Strategies using SSIS Packages that extracted the data from different heterogeneous sources like Flat Files, Excel Files and dumped it into a centralized Data mart.
• Implemented complex stored procedures to perform data-profiling in the pre-staging databases.
• Modeled Data-Marts for business-specific areas using Dimensional Modeling (Star / Snowflake schema)
• Participated in the full implementation of SDLC of the system, designed the conceptual, logical, and physical model of the underlying relational database.
• Worked closely with business partners and internal development team to acquire a deep understanding of the system requirements.
• Prepared the software requirement specification document.
• Presented prototype, technical solutions and analyzed functional requirements
• Implemented independently modules of the project.
• Prepared comprehensive test plans and performed testing.

Education

• M.S in Computer and Electrical Eng
• B.Tech in Computer Science
• Diploma of Science in Computer Science

Availability

• Permanent residence of United States of America.
• Available for immediate employment.