PROFESSIONAL SUMMARY:

• Over 9+ years of experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008/2012 in Development, Test and Production Environments
• Having exposure in working various domains like Resources Energy Systems (RES), Banking Financial Services and Insurance(BFSI), Healthcare and Telecom
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2.
• Having good knowledge and experience in reporting technologies like SQL Server Reporting Services (SSRS) And Microsoft Power BI
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2008 R 2/2012/2016.
• Having knowledge and experience in implementing SQL Server Integration Services (SSIS)
• Extensive knowledge in commercial RDBMS such as MS SQL Server and MS Access.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions and Indexes using T - SQL.
• Great ability to create and manage various database objects like tables, views.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases
• Experience in SQL SERVER Services SSIS, SSAS, SSRS, DTS, ETL, Creating Packages and Data Visualization using Microsoft Business Intelligence Tools.
• Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• In-depth understanding and experience in building server applications using C#, ASP.Net, ADO.Net, XML Web Services, HTTP modules and handlers based on .Net Framework 4.6.2/4.5/4.0/3.5/3.0/2.0.
• Expertise in developing various applications using .NET Technologies like C#, ASP.NET, VB.NET, ASP.NET MVC, ADO.NET, ENTITY FRAMEWORKS, WCF, WPF, ORM, IIS, XSD, XML, SPA, windows forms and REST WebPIs.
• Understanding and experience in building server applications using C#, ASP.Net, ADO.Net, XML Web Services, HTTP modules and handlers based on .Net Framework 4.6.2/4.5/4.0/3.5/3.0/2.0.
• Commercial experience in Azure, C# & VB .Net, Entity framework, CSS, LINQ, TFS, Git, Jenkins, Node JS.
• Excellent understanding of Object Oriented Programming Concepts, ASP/ASP.NET, C#, Visual Basic, Web Services
• Experience in working with Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF) and Windows Workflow Foundation (WWF) in .Net Framework 4.0/3.5/3.0 and Language Integrated Query (LINQ) in .Net Framework 3.5.
• Having good experience on architecting software design using Tiered architecture
• Having good knowledge and experience on new technologies like WCF, LINQ.
• Excellent understanding of Object Oriented Programming Concepts, ASP/ASP.NET, C#, Visual Basic, Web Services
• Having good knowledge and experience on new technologies like WPF, LINQ
• Involved in IIS migration. From IIS 5.0 / 6.0 to IIS 6.0 / 7.0.
• Experience in Designing, Developing and Maintaining Web Applications using Visual Studio .NET, ASP.NET, C#, VB.NET, ADO.NET.

TECHNICAL SKILLS:

• MS SQL Server 2005/2008/2008 R2/2012
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• BIDS
• DTS
• BCP
• SQL Profiler
• SQL Query Analyzer
• Enterprise Manager
• Management Studio
• SQL Agent
• Sybase
• MS Visual Source Safe 6.0/8.0/2005
• C
• C++
• Visual Basic 6.0
• ASP
• T-SQL
• HTML
• CSS
• XML
• C#.Net.
• Oracle 10g/11g.

PROFESSIONAL EXPERIENCE:

Confidential, Snellville, GA

Sr. MSBI DEVELOPER (SQL SERVER/SSIS/SSRS.Net)

Responsibilities:

• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
• Worked on the backend development of new features using C#, ASP.NET MVC and Web API.
• Worked on designing and developing Win forms and Web forms ASPX pages for Web Applications.
• Added new business logic, fixed defects using C#, and used TFS to check in those changes.
• Migration of existing ASP application to .NET application using ASP.NET, C#.NET.
• Developed application using MVC design pattern.
• Involved extensively in developing components for Business and Data tier using C#.NET and involved in creating controllers/View Models to handle the events raised on the Razor views/Partial Views in ASP.NET MVC framework.
• Used ASP.NET MVC Data annotations and JQuery to do validations on the Model Data.
• Added new business logic, fixed defects using C#, and used TFS to check in those changes.
• Created WCF services to implement the 3-tier service architecture involving data access layer with ADO.Net components, business layer and service layer.
• Developed application using MVC 5.0, C#, WEBAPI, HTML 5 using Visual Studio 2013 and Entity Framework.
• Worked on application performance by passing SQL bulk, data tables to the Stored Procedures, JQuery and AJAX for asynchronous calls on the web page rendering.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Migration project to migrate the database from Access database to SQL Server.
• Creation of ETL's for validation of data.
• Create ETL and SSRS reports to automate the adhoc reporting.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Involved in applications Deployment in IIS 8.0.
• Performance tuning of SSIS packages to load large data files.
• Creating tables, functions, and stored procedures as part of automation.
• Moving objects from development to test to production environments.
• Designing and reviewing the migration strategy, database and database objects.
• Migration of ETL from SSIS 2008 to SSIS 2012.
• Worked on complete SDLC right from requirement gathering, analyzing, documentation, design, development, unit testing and deployment.
• Deployment of SSRS reports to report manager.
• Deployment of SSIS packages to SQL server.
• Creating jobs to automate SSIS packages.

Environment: MS SQL Server 2005, SQL Server 2008 R2, 2012, MS SQL Server Reporting service, MS SSIS Access(Mdb), T-SQL, SSAS, SSRS, MS Visual Studio 2005, C .NET 4.0, ADO.NET, WCF, WPF, XML, MVVM, TFS, CSS, JavaScript, JQuery.

MSBI DEVELOPER (SQL SERVER/SSIS/SSRS.Net)

Responsibilities:

• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Developed E-Commerce functionality in ASP.NET MVC.
• Developed application using MVC 4.0, C#, WCF and WebApi using Visual Studio 2013 and SQL server 2012
• Worked on SOAP and RESTFUL Service API using WCF 4.0 which return XML and JSON data using WCF attributes.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.
• Developing new web application as part of change and service requests.
• Developed test-driven development (TDD) strategy guiding use of the N-unit testing framework.
• Used Team Foundation Server (TFS) for continuous integration and version control.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Responsible for Database design, and creation of Stored Procedures using T-SQL, triggers to perform.
• Used ASP.NET web controls and HTML control in the design of web pages and integrated Reports with ASP.Net Web application.
• Involved in creating web site pages using AJAX, JavaScript, JQuery, HTML and CSS. Created the Editor and Display templates for MVC controls.
• Extensively used ASP.NET web server controls like Grid View for displaying the records.
• Experienced in developing and consuming Web Services and n-tier web applications.
• Used ADO.NET for data interaction between the web application and the Database using Data reader, Datasets, and Data Adapters controls.
• Created database objects using SQL Server including complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Environment: MS SQL Server 2008/05, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, ASP.NET, C#.NET, XML, Clear Quest, C#, ASP.Net 2.0/3.5 SQL Server2005/2008, WCF AJAX, JavaScript, XSLT, C#, ASP.NET, TDD, .NET Framework, ADO.NET.

MSBI DEVELOPER (SQL SERVER/SSIS/SSRS.Net)

Responsibilities:

• Developed the application using ASP.NET MVC with Razor syntax, C#.NET, AJAX, JQuery, JSON, HTML, JavaScript, and CSS.
• Analysis, preparing technical specs, developing and implementation of changes and testing on the programs given by onshore
• Worked as a .NET developer and SSRS Report developer
• Writing UI & Functional logic in C# and ASP.Net with back end support, Unit testing and creating .msi file.
• Involved in preparation of Detail Design document with prototypes and screen shots based on the requirement documents.
• Developed using Event driven Web Forms using ASP.NET MVC that runs on IIS 7.0 using Visual Studio 2012.
• Designed the win forms, WPF framework using C#.Net.
• Created Stored Procedures to extract data for generating reports by using SQL Server Reporting Services (SSRS), Triggers, Indexes and Views for performance tuning and retrieval of data.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Used SQL Server Integration Services (SSIS) for extraction transformation and loading data.
• Developed ASP.NET pages using C# on the approved Design Document.
• Used java script to handle Client - Side validations.
• Created generic secure and reusable data access components using the ADO.NET objects such as Dataset, Data Adapter and Data Reader.
• Extensively used SQL Server Reporting Services (SSRS) for generating reports populated by data in databases.
• Implemented the ASP.NET security features like Forms Authentication.
• Fixing of problems and issues which come across during various stages of implementation like development and bug fixing.
• Performed the unit testing for the application and resolving technical issues, writing and modifying code.

Environment: C#, ASP.Net 3.5 SQL Server2005/2008, SSRS, AJAX, JavaScript, XML, XSLT, Nunits 2.0.

MSBI DEVELOPER (SQL SERVER/SSIS/SSRS.Net)

Responsibilities:

• Developed logical and physical data models for schemas using Erwin, and designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio and extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Handled slowly changing dimensions to maintain the history of the data.
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Worked with VB6, Visual Studio 2003-2012, VB.net, C#, ASP (classic), ASP.NET, Oracle, Microsoft SQL Server and Mongo DB, did work with Web services, MVC and WCF.
• New program to handle all material flow, including returns and store to store transfers. Written in C# 2012 using MVC, WFCF and REST.
• Developed using C#.NET 4.0 to in corporate business logic and ASP.NET 4.0 for GUI and implemented.
• Designed, developed and deployed Sub-Reports, Drill-Down, Drill-through and Parameterized reports in MS SQL Server environment using SSRS-2005.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a time horizon and stored in script.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server.

Environment: MS SQL Server 2008R2/2008, SSIS, SSRS, SSAS, Visual Studio 2005, VSS 2005, Erwin v7.3, Windows NT/2003, Microsoft .NET framework 3.5.

MSBI DEVELOPER (SQL SERVER/SSIS/SSRS.Net)

Responsibilities:

• Responsible for tuning T-SQL procedures, triggers and other database objects
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer
• Used ASP.NET MVC Data annotations and JQuery to do validations on the Model Data.
• Build and maintain systems with .NET/C#, shell scripting and windows power shell.
• Developing SSRS reports and deploying reports to other environments (UAT, PS and production).
• Generated various List Reports, Grouped Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Requirement gathering, impact analysis and design document creation for the existing SSIS, SSAS cubes and SSRS reports.
• Developed Application layer using ASP. Net, Server controls, HTML Controls and Validation controls.
• Created different Parameterized Reports (SSRS 2008/2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created packages to load data from various sources like Flat File, Excel and OLEDB in SSIS 2008 R2
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Created SSIS packages using .NET and C# as a custom code in Script task.
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Developed Queries for generating reports in SSRS 2008 R2.
• Added new business logic, fixed defects using C#, and used TFS to check in those changes.
• Developed drill down, drill through and Parameterized reports using SSRS 2008 R2
• Created Subscriptions, Data driven subscriptions and managed security for reports on SSRS Report Manager
• Migration of existing ASP application to .NET application using ASP.NET, C#.NET.
• Experience in creating Ad-hoc and static reports using SSRS (SQL Server Reporting Services) from BIDS.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Working knowledge of .Net Framework 3.5 (VB.NET and C#.NET).
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Experience in designing a database design strategy and database for optimal performance.
• Designing and Optimizing Database Solutions with Microsoft SQL Server 2008.

Environment: Microsoft Windows 2008 Advanced Server, Microsoft SQL Server 2008 Enterprise Edition, Microsoft Visual Basic 6.0, SSIS, SSRS, SSAS, SharePoint 2007, OLAP, OLTP, Erwin, TFS, CSS, Visual Studio.Net 2010/2012, C#, ADO.NET, WCF, WPF,