Sql Server Manager

Sai Kumar

MS SQL Server/ SSIS/SSRS Developer Email:**************@*****.***

Mobile-860*-****-**

Professional Summary:

•Over 7+ years of Experience in Microsoft Business Intelligence Technologies SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).

•Extensive knowledge and Experience in dealing with Relational Database Management Systems (RDBMS) including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Views, Data Import/Export, Triggers and Cursors.

•Experience in dealing with high volume transactional data in SQL.

•Experience in IT, Financial and Healthcare environments with primary skill on the Analysis, Design, Development and Support of Client/Server Applications using Microsoft SQL Server 2012,2008, 2005, 2000 and MS BI suite.

•Experience in working with Agile, Scrum Process in software development.

•Hands on experience in making AJAX based web applications to improve the response time and extensively implemented update panels, script manager and triggers.

•Installed, configured and maintained SQL Server Integration Services (SSIS)

•Good experience in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object to access databases like SQL Server 2005/2008/2008R2.

•Very good experience in Creating, Deploying SSIS Packages and Migrating DTS Packages from 2000 to 2005/2008.

•Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2and SQL2012.

•Expertise in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

•Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.

•Experience in troubleshooting SQL Issues by using SQL Tools, Execution Plans, Trace, Statistics, Index tuning wizard.

•Extensive experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.

•Worked with Project team during deployment of SSIS Packages from development server/QA server to production server.

•Experience in Performance Tuning and Query Optimization

•In-depth knowledge of Transact-SQL (DDL, DML, DCL), Design and normalization of the database tables and Relational Database Management Systems.

•Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

•Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

Technical Skills:

Web Technologies

HTML5, CSS3, JavaScript, JQuery, Angular JS, Node JS, JSON, Bootstrap, AJAX, ASP.NET, ADO.NET, MVC

GUI Editors:

Visual Studio 2005/2008/2010,2012, SQL Server Management Studio and Toad

Languages

Transact SQL,PL/SQL, C,C#,ASP.Net, ADO.Net

ETL Tools

SQL Server Integration Services (SSIS) 2012/2008R2/2008/2005, DTS, Data Stage

Debugging Tools

Firebug, Chrome inspector tools, Visual Studio Tests

Operating Systems

Windows : XP/7/8/8.1, MAC OS

Web Servers

IIS, Apache Tomcat, WAMP server

Databases

MS SQL Server 2000/2005/2008, SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager and Reporting Server. Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP (Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Version Control Tools

Visual Source Safe (VSS), Team Foundation Server (TFS)

Desktop Tools:

MS Office, MS Visio, Rational Rose

SDLC Process Modules

Waterfall, Iterative, Incremental, Scrum, Agile

Professional Experience:

Client: MFS, Boston. MA Feb 2016 - Present

Role: MS SQL Server/ SSIS/SSRS Developer

Description: Massachusetts Financial Services (MFS) system is an active, global investment manager with a uniquely collaborative approach to build better insights for clients. Its investment approach has three core elements – Integrated Research, Global Collaboration, and Active Risk Management. Through the combined application of these three principles, the firm works to deliver sustainable investment solutions for the individual and institutional investors it serves. Primary responsibilities include custom application development, application lifecycle management, enterprise content management, web content management, workflow and ongoing maintenance and management of existing applications and business initiatives.

Responsibilities:

•Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

•Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, User defined data types and Functions in SQL Server.

•Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008/2012.

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

•SSRS experience with extensive report development experience, dash boarding and development of cubes for reporting.

•Done Performance tuning to optimize the run time.

•Changed stored procedures according to the new hierarchy.

•Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.

•Used SQL Server Agent for scheduling jobs and alerts.

•Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

•Worked with various SSIS packages which involve Transactions, Restart ability and roll back techniques.

•Configured SQL Mail Agent for sending automatic emails when SSIS packages fails or succeeds.

•Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

•Used SQL Server Integrating System(SSIS) and SQL Server Reporting System(SSRS)

Environment: MS SQL Server 2005/2008 R2/2012, MS SQL Server Reporting Services 2005/2008 R2/2012, MS SQL Server Integration Services 2005/2008 R2/2012, MS Visual Studio 2010/2008, Oracle 10g.

Client: United Healthcare, Trumbull, CT Oct 2014 - Feb 2016

Role: Sr. SQL BI Developer (SSIS/SSRS/SSAS)

Description: United Health is a leading insurance company; I have worked on Product management system that deals with addition, modification or removal of Insurance products. PMS helps to manage the products in a professional manner by allowing the user to specify the specifications for a product. It also helps to track the number of subscribers/members for a particular product with an ability to group it region wise.

Responsibilities:

•Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.

•Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2

•Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

•Experience in developing reports using SSRS 2008 and SSRS 2008 R2

•Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.

•Performed the task of data transfer from files in remote server to folders in another server using FTP.

•Created database maintenance plans and deleting of history data using SSIS packages.

•Deployed SSIS packages and Reports to Production Servers.

•Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.

•Generated reports from the cubes by connecting to Analysis server from SSRS.

•Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created Interface Stored Procedures used in SSIS to load/transform data to the database.

•Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.

•Created SSIS Packages from various data sources.

•For the data warehouse Analysis services and develops the different reports for the analysis.

•Developed various reports using SSRS, which included writing complex stored procedures for datasets.

•Involved in building cubes for production application, Partitioned Cubes to reduce the processing time and increase the performance of the queries running on front end application using SSAS2008.

•Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models developed Reports using MDX and SQL.

•Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.

•Transform the data from the staging database and perform the transformation using the Data Flow Tasks.

•Developed complex stored procedure using T-SQL.

•Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

•Build database queries and test cases for the testing team to test the reports.

•Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MSExcel, PDF, HTML, and XML etc.

•Lead the team of developers to write efficient code.

Environment: SQLServer 2008/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T-SQL, Erwin, MDX, Oracle 10g, ProClarity, MS Excel.

Client: United Health Group,Hyderabad,India Dec 2013 - Sep 2014

Role: SQL Server BI Developer (SSIS/SSRS)

Description: UHG is a healthcare company, provides technology solutions to the healthcare market in the United States and internationally. UHG enables healthcare solution development that improves clinical outcomes, financial outcomes, and patient engagement by intelligently and securely connecting mobile applications, healthcare expertise, and healthcare data.

Responsibilities:

•Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

•Created partition tables for very large database to improve performance.

•Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

•Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-Threading Concepts with Synchronous and Asynchronous transactions.

•Created logging, custom logging and error handling packages.

•Deployed SSIS packages and Reports to Production Servers.

•Maintained system monitoring jobs and provide high availability support.

•Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).

•Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).

•Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.

•Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

•Deployed and configured the reports in the Report Server.

•Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.

•Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.

•Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.

•Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, C#, T-SQL, VisualStudio.net, XML, MS Excel, MS Access, Visual Studio 2008.

Client: CtrlS, Hyderabad, India May 2012 – Dec 2013 Role: SQL Server SSIS/SSRS Consultant.

Description: The complete ERP package for Security Services with different kinds of Modules named as Bidding, Project, Employee Management, Services, Products, Attendance, Payroll, Price Books, Purchase Order, Sales Quotation, Requirements, Inventory, Warehouse and etc… The main purpose of this product is, the client would like to introduce computerization in his services instead of Manual process. With the help of this product, Client will have the ability to maintain the accountability of his services and contracts with his customers.

Responsibilities:

•Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

•Generated database monitering and data validation reports in Proclarity and SQL Server Reporting Service (SSRS).

•Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS).

•Deployed SSIS packages and Reports to Production Servers.

•Upgraded databases from SQL Server 2000 to SQL Server 2005.

•Responsible for the design and development of .Net web applications for firm's Solutions.

•Migrated data using ETL Tool in SSIS.

•Maintained system monitoring jobs and provide high availability support.

•Created partition table for very large database for good performance.

•Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).

•Participated Databases Architecture and data Modoling design.

•Performing DBA functions, installing, configuring and supporting database systems.

•Reported all events and requirements through established reporting mechanisms in SSRS.

•Fully supported change management procedures.

•Reviewed and developed data models and database designs with development teams

•Wrote store procedures for some job automations.

•Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.

•Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS

•Designed and developed OLAP using MS SQL Server Analysis Services.

•Involved in converting SQL Server 2005 data using SSIS.

•Designed and developed MS SQL ServerReporting Services(SSRS) under SQL Server 2000 and SQL Server 2005.

Environment: MS SQL Server 2005 and 2000, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, MS SQL Server Analysis Services 2000, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS.

Client: BirlaSoft, Hyderabad,India Jan 2010 – May 2012

Role: SQL Server Developer

Description: Customer Relationship Management is a sophisticated system designed especially for the Business users. Every Business has multiple angles, new approaches, Separate strategies, Set of Rules, Risk, Maintenance, Financial Operations, Accountability, Status, Project Information, Task details, Time lines and many other functions. To manage all this kinds of functionality every Business user needs a system. The system itself is called CRM (Customer Relationship Management). For every business “Customer” is the heart and the God as well. The major typical task is maintaining a good Relationship with the Customer. The system of CRM creates the platform for the business users for their customer as like ready to occupy with all facilities.

Responsibilities:

•Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.

•Involved in Design, Development and testing of the system.

•Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).

•Developed User Defined Functions and created Views.

•Created Triggers to maintain the Referential Integrity.

•Implemented Exceptional Handling.

•Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.

•Creating and automating the regular Jobs.

•Tuned and Optimized SQL Queries using Execution Plan and Profiler.

•Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

•Involved in performing database Backup and Recovery.

•Worked on Documentation using MS word.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5.

Contact this candidate