Sql Server Data

Sidhartha

MS SQL BI Developer

Professional 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.

EDUCATION:

●Bachelors

Technology & Testing Proficiencies

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:

Client: Blue Cross Blue Shield - Detroit, MI March 2012 – Current

Role: Sr. MS BI Developer/C#.NET Developer

Description: Blue Cross Blue Shield Operates in the entire United States providing excellent Medical Services for more than 100 million Americans. The project mainly involved in extraction of Claims and integrates them according to business requirements. Worked closely with Health Care Data Analytics team.

Responsibilities:

●Understanding the business requirements.

●Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.

●Transformed Complex business requirements into ETL 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 and data conversion Procedure 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.

●Conducted data migration processes in the SQL Server environment using SQL 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 using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2008R2.

●Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.

●Wrote complex Stored Procedures, coding and triggers to 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 the SSIS Packages to the MSDB as well as File System based on the requirements

●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 and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.

●Created copies of operational Databases using the Import/Export Wizard.

●Developed Cross-Tabbed and Sub-Reports in SSRS2008R2.

●Designed and Developed matrix, tabular and parametric Reports in the SQL 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.

Client: NRT LLC, Edina, MN. March 2010 - Feb 2012

Role: MS SQL BI Developer/C#.NET Consultant

Description: NRT-LLC is one of the Nation’s largest brokerage company handling over 35 largest Metropolitan areas. The Project mainly involved in creating new Databases, Performance Tuning, T-SQL coding, Migration of data, Performing Back-up and also it included Extract, Transform and Loading (ETL) of data from Flat file, Excel sources etc. by using SSIS Packages. Creating, Deploying and Scheduling Reports. Generated various Operational, Drill-Through and Dynamic Reports using SSRS.

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.

Client: Capital One - Richmond, VA Oct 2008 - Feb 2010

Role: SQL Server Developer

Description: It is one of the largest banking organizations, serving a broad range of consumer, commercial, corporate and institutional clients. The purpose of project was to develop an interface to provide information on employee details at branch level, comparison reports of branch activity, performance of each branch to the employee level, number of branches that have reported data and those which did not report any data, status of each application from each branch. As a MS SQL Server Developer, I was responsible for Migrating data from OLEDB sources into MS SQL Server 2008R2 and Designing reports using SQL Server Reporting Service.

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.

Client: Nationwide Insurance - Columbus, OH Nov 2006 - Sep 2008

Role: SQL Developer/ETL Developer

Description: This project deals with various management activities of Nationwide Auto Insurance policies within the organization and assists them by providing various interfaces and reports to ease their decision-making process. The project involved creating Corporate Data Warehouse and migrating data from the OLTP systems to the Corporate Data Warehouse. SSIS was used as an ETL tool for extracting the Data from various sources running on Oracle, DB2 and MS SQL Server databases.

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.

Contact this candidate