SUMMARY

• Around 8+ years of IT experience as SQL developer in design and development of various applications for Financial, Insurance and Manufacturing Industries.
• Experience with scripting in T - SQL, constructing tables, joins, user functions, views, indexes and user profiles.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective Triggers to facilitate efficient data manipulation and data consistency in MS SQL Server 2008 R2/2005/2000
• 3 years experience in ASP.NET 2.0, C#, AJAX, Web services and SQL Server 2005.
• Experience working on Normalized Databases and designed database/tables and the requisite relationships, designed partition tables and partition views.
• Implemented cursors for rebuilding indexes.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008.
• Expertise in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2000/ 2005
• Proficient in merging data from various data sources using SSIS.
• Developed Tableau visualizations to support ad-hoc analyses.
• Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008 R2.
• Experience in creating Multidimensional cubes using SSAS.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• Implemented a well-planned backup and restore strategy for databases against data loss due to damage caused by a variety of failures.
• Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Strong individual with Technical, organizational, analytical and design skills.
• A skilled problem-solver and an efficient Team player, collaborative and self-starter, excellent oral and written skills.

TECHNICAL SKILLS

Languages: T-SQL, XML, HTML, C#.Net, ASP .Net.

Data Application Software: SQL Server 2000/2005/2008 R2/2012, MS Access (2000/2003) and UML.

Database Modeling: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas.

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services.

BI Tools: SSIS/SSRS/SSAS, SSBI Development Studio, Crystal Reports.

Reporting Tools: MS Access, Excel, and MS SQL Server Reporting Services 2000/2005/2008 R2/2012, SSIS, SSAS and Share Point.

Operating Systems: Windows 7/Vista/XP/NT/2000/2003/2008.

Version control tools: Visual Source Safe (VSS), Subversion (SVN), Team Foundation Server (TFS)

Others: ER-Win, MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Sr. MS BI Developer

Responsibilities:

• Understanding the business requirements.
• Extracted the data from the different sources and stored the data into the intermediate Staging Database using theSSIS ETL tool.
• Transformed Complex business requirements intoETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
• Maintained all the SQL documents which included installation anddata conversionProcedure documents.
• Wrote business logic code in C# code behind files to read data from database stored procedures.
• Created a user friendly interface where the user can see the detailed report based on his selection of Sector.
• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• Conducteddata migrationprocesses in the SQL Server environment usingSQL Server Integration Services 2012.
• Developed VBA scripts for periodic P&L (Daily, Weekly) reports using Excel, Access (Reports, Forms).
• Created SQL Server Reports for Management usingSSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports usingSSRS 2008R2.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Wrote complexStored Procedures, coding and triggersto capture updated and deleted data from OLTP systems.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Experienced in implementation of strong referential integrity and auditing with the use of triggers.
• Deployed theSSIS Packagesto the MSDB as well as File System based on therequirements
• Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers.
• Created the automated processes for the activities such as database backup processes andSSIS, SSRSPackages run sequentially usingSQL ServerAgent job and windows Scheduler.
• Created copies of operational Databases using theImport/Export Wizard.
• DevelopedCross-TabbedandSub-ReportsinSSRS2008R2.
• Designed and Developedmatrix, tabularandparametricReports in theSQL Server Reporting Services 2012.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created complex SSIS packages using various transformations.
• ETL process was documented for future references.

Environment: Microsoft SQL Server 2008R2/2012, SQL Server Reporting Services (SSRS), VBA, Management studio, XML,Excel, SQL Server Integration Services (SSIS), Windows Server XP.

Confidential, Edina, MN

MS SQL BI Developer/C#.NET Consultant

Responsibilities:

• Actively interacted with end users, team lead, and business analysts to fully understand the requirements.
• Developing database and data feed solutions; administering databases and database servers.
• Participating in the build and deployment cycle.
• Web Form design in Asp.Net using CSS, Server Controls, JavaScript and coding using C#.net.
• Coded in C# to display a specific color code based on a Capacity Threshold value.
• Contributing in all phases of development projects while providing support to existing clients.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules.
• Performed Data modeling organizing the data and provide proper structure to database by implementing constraints to tables.
• Extensively involved in debugging and tuning of T-SQL queries, SSIS packages and SSRS reports.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally loaded into the Database.
• Implemented full text indexes for property address searches.
• Involved in database backup and restore mechanisms.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries
• Created SSRS report templates for ease of report development.
• Created daily, weekly, monthly, quarterly, semi-annual and annual SSRS reports for Military commanders.
• Used TFS to Check in and check out SSIS packages, SSRS Reports and database code (Version Control).
• Documented all the coding standards and procedures.

Environment: SQL Server 2008R2/2012, Microsoft Business Intelligence Development Studio, VBA,Excel,T-SQL, SSIS, SSRS, SQL Profiler.

Confidential, Richmond, VA

SQL Server Developer

Responsibilities:

• Created and maintained the database for all the products.
• Teamed with developers to create the most optimal code and database connectivity to meet client-timing requirements.
• Worked on stored procedures, triggers and also on large number of business analytical functions.
• Add and modify all required tables/databases to support the requests from the system analysts and the systems Integrator and provide daily production support for the operations of databases.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from Excel Spreadsheet to SQL Server 2008R2.
• Scheduling the SSIS packages and Jobs.
• Aided in development and management of Access database solutions using SQL Server, including macros and reports
• Hands-on training in the use, maintenance, and development of databases using MS SQL Server 2000.
• Created different hierarchical, interactive reports using C# for Streams, Sectors.
• Wrote business logic code in C# code behind files to read data from database stored procedures.
• Wrote classes to implement display format in gridview, Export to Excel, Export to Zip.
• Used dataset, data reader, data view to read data using .Net ADO objects.
• Involved in supporting and maintaining the database servers, performing database installation, configuration, and upgrade.
• Involved in designing, implementing of database backup and restore procedures.
• Responsible for creating summary Reports, Sub Reports, Drill down Report, dynamic grouping.
• Created automated reports using SSRS (SQL Server Reporting Services).
• Monitored server performance, creating user logins and granting security privileges.
• Create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, and hardware errors.
• Migrated stored procedures and databases from one server to another.

Environment: Windows 2003 Server, MS-SQL Server 2000/2008R2, HTML, XML, and MS Office 2003.

Confidential, Columbus, OH

SQL Developer/ETL Developer

Responsibilities:

• Involved in analysis, design, development, and enhancement of the data warehousing application.
• Installation and configuration of MS SQL Server.
• Created DTS packages for the data cleansing/transfer and transformation.
• Responsible for design and Normalization of the database tables.
• Modified the current stored procedures to meet current design.
• Created indexed views, and appropriate indexes to cut the complex query time.
• Provided day-to-day administration tasks like space and log management.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package.
• Design and implementation of Replication solution for SQL Server 2008R2.
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Performed Performance tune SQL statements, queries, triggers and stored procedures using SQL profiler.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Developed SSIS packages using different types of Error Handling for various events.
• Involved in report creation using SQL Server Reporting Services (SSRS), and Excel spreadsheet as per the client Requirement and for the periodic analysis.
• Created Tabular and Matrix Reports Quarterly, Semi-Annually and annually by using SSRS.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.

Environment: MS SQL Server 2008, SSIS 2005/2008, Crystal Reports 7/8, MS Excel, and MS Office.