SUMMARY:

• Around 9 years of professional experience in development, implementation and administration of database systems as a MS SQL Server Developer using Microsoft SQL server 2012/2008R2/2005/2000 in various domains including Health care and insurance.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS, SSAS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
• Excellent in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Skilled in creating virtualization reports using Power BI
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Thorough understanding of Kimball’s theory, KPIs and Perspective, Data mining structures.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• In depth understanding of SQL Server Migrations and problem management.
• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Responsible to maintain the efficiency of all the software and applications that run on UNIX system.
• On-call duty with teammates 1-2 weeks per month and active involvement in Go-live activities.
• Excellent communication skills, analytical skills, understanding of business requirements in various domains.

TECHNICAL SKILLS:

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

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

Database Modeling Tools: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas. Microsoft Visio 2007, Erwin Data Modeler 8/7/5

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 Services2005/2008 R2/2012, 2014 SSIS, SSAS and Share Point, Crystal Report

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, Berlin, VT

SQL/SSRS Report Developer

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables and Table valued Functions for data extraction, data load and transformations.
• Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab-delimited and pipe-delimited.
• Worked on several State Reports and used SSIS to create multiple destination files from single/multiple sources.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc. and scheduled SSIS packages.
• Created SSRS (SQL Server Reporting Services) reports having multiple Parameters and cascading parameters, Navigation to a sub reports and created book marks when report is exported to PDF or EXCEL File.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Responsible to build Reports for different Markets and ADHOC reports as per request.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS (SQL Server Integration Services)
• Documented Back out Implementation Plan for all the work done and also created the CMD files.
• Worked with Team foundation server version Control to maintain the different versions of Code, RDL Files, Back out Scripts, CMD files & SSIS Packages.
• Created Subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Worked with Oracle Application database to pull Claims, Providers, and Members information for various reports and extracts.
• Provided 24/7 Production Support for the maintenance & scheduling of reports.

Environment: SQL Server 2012/2014, Report Builder 3.0, Business Intelligence Studio (SSIS, SSRS), C#.NET, T SQL, MS Excel.

Confidential, Rochester, NY

SQL Server/BI Developer

Responsibilities:

• Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
• Worked on Installation and Maintenance of SQL Server 2014/2012 on Test, Development and for Production Environments worked closely with Admin teams.
• Stored Procedures, User Defined Functions, Views, TSQL for complex business logic.
• Design and implementation of SSIS/ETL process for the system.
• Data conversion from mainframe system and Oracle databases to SQL server.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Validated change requests and made appropriate recommendations, standardized the implementation of data.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Uses of power pivot, red gate tools for different purposes. Use of source control product such as Team foundation server.
• Modified stored procedures to meet current design and used them in SQL Server.
• Maintain security, assign logins, permissions and desk support for problems related to Active Directory.

Environment: MS SQL Server 2012/2014, MS dynamics 2013/2015, Red Gate tools, PowerPivotTFS 2013, Agile/SCRUM SharePoint 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio.

Confidential, Philadelphia, PA

MS SQL Server BI Developer

Responsibilities:

• Worked as a SSRS Reports Developer/Administrator and SQL Server Developer in support of Service Management System.
• Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SSIS package for Market Value Process feed.
• Used C# scripts in SSIS script task to run custom scripts in package flow.
• Creating various periodic reports for customers using SSRS, performance point server.
• Used event handlers to send custom e-mail notifications to business users as well as technical teams.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Performed user acceptance testing on new and modified reports.
• Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.
• Developed database triggers and stored procedures using SQL tables.
• Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.

Environment: Microsoft SQL Server 2008, Visual Studio 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Confidential, Charlotte, NC

MS SQL Server Developer

Responsibilities:

• Involved in Gathering end user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
• Composed user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.
• Programming in SQL server using stored procedures, triggers, views, user-defined functions
• Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
• Involved in query tuning by creating cluster and non-cluster indexes on tables, and used index tuning wizard.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Used event handlers for event handling which includes on pre- execute, post execute and error.
• Involved in package logging in both standard (SQL server and file based) and custom logging using customer stored procedure and tables.
• Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using dtexec utility, command prompt with .bat files etc.
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Created ad-hoc reports more often based on end user requirements.
• Performed daily DBA activities, security assignment, user setup, backup, restore and job monitoring on MS SQL Server
• Generated and formatted reports using global variables, expressions and functions.
• Involved in developing parameterized reports using single values, multi values and cascading parameters.
• Built effective queries for high performance reporting and rendered them to html, xml, pdf, MS word and excel formats using SSRS (2005/2008).

Environment: SQL server 2005/2008, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i, Enterprise Manager, ERWIN Data Modeler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLTP, OLAP, DTS, HTML, XML, C#, .Net, Visual Studio 2008, ETL, MS Access.

Confidential, Los Angeles, CA

SQL Developer

Responsibilities:

• Involved in the installation of SQL server and installed SQL server enterprise manager tools using SQL Setup.
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic.
• Optimized queries by looking at execution plan for better tuning of database.
• Designed and developed various complex reports using drill down, drill through, cross tabbed reports etc.
• Responsible for ongoing maintenance and management of existing reports. Also to optimize report performance.
• Used Report manager to deploy reports, schedule reports and created groups and users.
• Designed and developed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup, merge join, fuzzy lookup, derived columns etc.
• Involved in automating SSIS packages using SQL server agent jobs, windows scheduler and third part tools.
• Implemented event handlers & error handling in SSIS and notified process results to various communities.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2005/2008, SQL Server Management Studio, MS Excel, T-SQL.