SUMMARY:

• Over 8 years of IT experience as a Microsoft SQL Server/BI Developer in diverse sectors.
• Extensive experience in all phases of project life cycle requirements, analysis, architecture, design, building, unit & integration testing, migration and training, deployment, production support and help desk support.
• Expertise in writing T - SQL, working on DTS, SSIS, SSRS, data cleansing, data scrubbing and data migration.
• Knowledge of RDBMS and Data warehouse concepts, OLTP & OLAP.
• Proficiency in designing highly flexible database architectures and data modeling, data mapping, table normalization, optimization and tuning.
• Experience with SQL Server 2008 and 2012 and worked extensively on Integration Services(SSIS) and Reporting Services(SSRS).
• Hands-on development of drill-down, drill through, drop down, parameterized, sub-reports and linked reports.
• Experience in on-report sorting, defining subtotals and designing report layouts.
• Proficient in building tabular report, matrix report, chart report, parametric reports, linked reports using SSRS.
• Experience in writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.
• Expert in high level design of ETL packages for integrating data from heterogeneous sources like Oracle, Excel, CSV, flat file, text format data.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Experience in creating master and child package, package configurations and logging.
• Excellent knowledge of using variables and expressions in packages.
• Experience in writing C# scripts in script component task.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning SQL Server performance.
• Experience in Admin tasks such as taking backups, restoring databases and scheduling.
• Expertise with job scheduling using SQL Server agent to perform hourly/daily/nightly updates.
• Expert in performing database consistency checks using DBCC utilities.
• Good team building skills; acute ability to interface with senior management utilizing well-developed communication and interpersonal skills.

TECHNICAL SKILLS:

• MSSQL Server 2014/2012/2008R2/2008/2005
• SSRS
• SSIS
• SSAS
• DB2
• MS-Access 2000
• MS Excel
• Team Foundation Server
• Erwin 8.0/7.2/7.1
• MS Visio 2010/2007/2005
• MS Dynamics
• Oracle 11g/10g
• Unix
• T-SQL
• Red Gate tools
• HTML5
• XML
• Java script
• VB Script
• C#
• Visual Studio 2012/2008 R2/2008/2005/2000
• MS office
• Windows NT/ 2000 Server/ XP

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

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.
• Develop complex SSIS packages with different data sources incorporating script task (VB scripting or C# scripting), etc. to deliver data reports to business users.
• 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, Green Bay, Wisconsin

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.
• Used c#.net asp web pages to show the deployed reports as required by the user
• 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, PowerPivot, TFS 2013, Agile/SCRUM SharePoint 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio.

Confidential, Trevose, 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, Orlando, FL

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, Kansas City, MO

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,