Professional Summary:
7 + years of IT Experience as MS SQL Server Database Developer in Database Design, Testing and business intelligence of Microsoft SQL Server 2000/2005/2008(R2) in Development and Production Environments with various business domains like Financial, Healthcare, Manufacturing and Insurance services.

• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Good understanding of (SDLC) software development life cycle process methodologies and principles.
• Expert Knowledge of Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
• Experience in creating snapshots of reports to reduce the load on the server. Managed subscriptions to provide timely reports to the clients and end users and also worked on integration of SharePoint with SSRS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Technical Skills:

Database: MS SQL SERVER 2008 / 2005 / 2000, MS Access 97/2000/2003.
Operating Systems: UNIX, Windows XP/2000/2003.
Programming Languages: Transact SQL, C.
Web Technologies: HTML, XML.
Productivity Applications: MS Word, MS Excel, MS Access, MS FrontPage.
DB Tools: SQL Server Management Studio, SQL BIDS, SQL Enterprise Manager,
Query Analyzer and SQL Profiler, Team foundation Server.
ETL Tools: DTS, SSIS.
Reporting Tools: MS Access, MS SQL Reporting services (SSRS), Crystal Reports,
Microsoft Excel.
Data Modeling Tool: ERWIN, Visio.

Professional Experience:
Confidential,Mar 2011 – June 2012
4025 Kinross Lakes Parkway,
Richfield, OH 44286
SQL Server SSIS Developer
Description: Snap-on Business Solutions designs productivity solutions that provide practical access to actionable information. We design and deliver electronic parts catalogs, accessory sales tools, warranty process management solutions, and manufacturer network development services. We are focused on helping vehicle and equipment manufacturers and their dealership networks increase sales, reduce structural costs, and improve customer experiences. SBS designs information tools that center on improving productivity in franchised dealerships and the supply chain.
Responsibilities:

• Create and maintain clearly written technical, user, and system documentation.
• Worked with complex SQL, Stored Procedures, Triggers and packages in very large databases from various servers.
• Created User Interface reports for validating the Data through Reporting Services.
• Highly responsible for development and management of SSRS and SSIS projects.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from SQL Server database to flat file source.
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Designing SSIS packages to migrate data from database(Hierarchial) to database(Relational).
• Created Mapping, Design and technical Documentation for complex SSIS packages.
• Experience in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Involved in Maintaining Database with Backup, Restore Strategies and Scheduling those backups using SSIS packages as a Developer.
• Deployed many packages on different servers using SSIS package Configurations.
• Involved in Backup and Restoring the Databases.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, lookup, Derived Column task and Script Task in SSIS Designer.
• Responsible for scheduling the packages through Jobs.

Environment:
MS SQL Server 2005/2008 R2, MS Excel 2003-2007, MS SQL Server Reporting Services, MS SQL Server Integration Services, Team Foundation Server, Share Point Server 2007/2010, SQL Profiler, Windows 2003 Advanced Server, Oracle SQL Developer, Crystal Reports 10.

Confidential,Upper saddle river, NJ Sep 2010 – Mar 2011
SQL Server SSIS/SSRS Developer

Description: ALERE is a health care company which provides different medical solutions from health management, monitoring to diagnosis. It also provides many health care products which treat infections, disorders and provide remedy for chronic and solutions to clinical care. Work revolved around the department which acts as liaison between the government and the health care receivers. Worked in the department to help maintain and provide effective solutions to manage the data.

Responsibilities:

• Involved in gathering requirements, worked closely with business users and implemented logical and physical modeling using Erwin.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Created complex queries involving CTE’s, Sub-queries and Joins.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
• Created the SSIS /DTS packages and scheduled them using Sql Server agent.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Used Vb.net and C# in Script task of SSIS 2008 Packages.
• Deployed SSIS Packages from Dev/Staging/Production using Package Configurations
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Developed drill-through and drill-down reports using SSRS. Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
• Created Subscriptions and Data-driven subscriptions using SSRS 2008.
• Created snapshots of reports to reduce the load on the server using SSRS 2008.
• Deployed SSRS reports to Share Point Server 2007/2010.
• Created Dashboards and Scorecards using Share Point Server 2007/2010
• Performed Identification, analysis and resolved report defects within time scope and established development guidelines.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

Environment:
SQL Server 2005, SQL Server 2008 R2, MS Excel 2003-2007, Share Point Server 2007/2010 SQL Profiler, ETL, T-SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services.

Confidential,Aug 2009 - Aug 2010
Chicago, IL.
SQL Server SSIS/SSAS Developer

Description: Redbox Automated Retail, LLC, a wholly-owned subsidiary of Coinstar, Inc. offers new-release DVD, Blu-ray Disc and video game rentals through its network of conveniently located, self-service kiosks. Redbox has rented more than 1.5 billion discs and is available at approximately 34,400 kiosks across over 28,000 locations nationwide, including select McDonald’s restaurants, leading grocery, drug and convenience stores, select Walmart locations and Walgreens locations across the United States.

Responsibilities:

• Participated in gathering User Requirements and System Specifications for dimensioning modeling of data warehouse.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Improved the performance of the slow running queries.
• Created partitions to improve the performance of data retrieval.
• Created Cubes using SSAS 2008 that are used by business users
• Defined KPI’s, Actions and Calculations in SSAS 2008 using MDX
• Improved the performance of Cubes by creating partitions and defining proper attribute-relationships and hierarchies.
• Deployed SSAS cubes and managed the security.
• Created SSIS packages to process cubes on scheduled basis.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Used Checkpoints to implement the restart ability of the packages in SSIS.
• Implemented Custom logging in SSIS using event handlers and execute sql task.
• Deployed SSIS packages to file system, sql server and automated the packages.
• Created SSIS Packages to load data from Oracle Database with various transformations in Sql Server database.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Experience in creating snapshots of static reports and configure subscription.

Environment:

Windows 2000/2003 Advanced Server, MS SQL Server 2005/2008, SQL Server Management Studio (SSMS), T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential,Madison, Wisconsin July 2008 - July 2009
SQL Server Developer / BI Developer

Description: DHS is a Health Service focus on specific strategy and guiding principles in all of our work for the people in Wisconsin. The Department supports policies vital to a fair and vibrant marketplace that delivers affordable, high-quality healthcare to our citizens and leverages our state\'s tradition of strong health outcomes, innovation and world-class provision of healthcare.
Responsibilities:

• Experience in creating reports on SQL server reporting services 2005.
• Experience in building reports through REPORT BUILDER and REPORT DESIGNER.
• Experience in creating reports using REPORT MODEL and applying row level security filters.
• Experience in designing CRYSTAL REPORTS visualizing them Exploring and delivering the reports via the web.
• Designed, Developed OLAP Cubes in SSAS
• Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal (SSRS).
• Experience on creating drilldown reports from analysis services cubes.
• Worked on PROCLARITY to create cost effective reporting and analytical solution.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model
• Involved in migration of sql server 2000 reporting services to SSRS 2005.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS)
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Migrated DTS packages from SQL Server 2000 to 2005 and scheduled their execution time.
• Created SSIS packages using Script tasks and with Error Handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Performance Monitoring with SQL Profiler, Windows System Monitor and using a monitoring tool called Embarcadero DB Artisan and Performance Center.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.

Environment: SQL server 2005, Windows 2003 Standard Edition, Windows 2000 Advanced Server, Microsoft Share point Portal Server, SQL Diagnostic Manager, SSIS, SSRS, SSAS.