Sql Server Data

SUDHEER KUMAR

Gmail/Phone: ****************@*****.***, +1-805-***-****

Summary:

Over 6+ years of experience in Database Administration and BI/SSIS Developer and under SQL Server environment, with thorough knowledge of SQL Server 2005/2008/2008R2/2012 R2 in OLTP/OLAP environment.

Experienced in Health care, Energy services and logistics domains.

Well versed with SQL Server 2005/2008/2008R2/2012 Installation, Administration, Monitoring, Database Backup and Recovery and day-to-day database monitoring activities.

Involved in moving databases between servers using attach/detach, backup/restore and import/export methods.

Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets. Created all kinds of reports like sub-reports, drill-down, drill-through, snapshot, cache, Linked-reports, Ad-hoc, Click through and Parameterized reports.

Good working experience in Power BI for creating reports, Dashboard’s and publish them in Power BI web browser.

Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.

Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views and User Defined Functions.

Moved databases across servers using Attach/Detach, Backup/Restore and Import/Export methods.

Experience in developing and extending MS SQL Server Analysis Services 2005 Cubes, Data Mining

Models, Deploying and Processing SSAS objects, and writing MDX queries.

Very good at creating Packages using SQL Server Integration Services (SSIS).

Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues. Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, and Oracle.

Experienced in ongoing maintenance and change management to existing reports and optimize report performance (SSRS).

Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.

Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.

Designing and Deployment of Reports for the End-User requests using Web Interface, Power-BI and Sql Server Reporting Services.

Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

Technical Skills:

Operating System : Window 2000, Windows XP, Windows 2003, 2008, 2010

Languages : SQL, T-SQL, HTML, Pl/SQL, Hadoop-HIVE

Databases : MS-SQL Server 2000, SQL Server2005, SQL Server 2008, SQL Server 2012

Reporting Tools : SQL Server Management Studio, Profiler, Query Analyzer, Tableau,

Power-BI, MS-Excel, Visual Studio.

Applications : Visual Studio 2012/2010/2008, Excel, Word, PowerPoint

Miscellaneous : Stored Procedures, DTS Packages, SQL Functions, SSIS, SSAS and SSRS,

Education:

Master’s in Computer Science in San Jose, California 2016 (Computer).

Projects Summary:

United Parcel Service, Alpharetta, GA May 2017 to Present

Sr. MSBI Developer

United Parcel Service (UPS) is the world’s largest package delivery company and a provider of supply

Chain management solutions. The global logistics company is headquartered in the city of Sandy

Springs, Georgia. Mission on Ups is, Growing global business by serving the logistics needs of customers, offering excellence and value in all that we do. Maintain a financially strong company-with broad employee ownership-that provides a long-term competitive return to our shareowners.

Responsibilities:

Creating and maintaining various databases on Production and development environments using SQL Server 2012/2008R2/2005.

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

Created Stored Procedures, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.

Defined the report layout and identified datasets in all reports for the report generation.

Writing SQL Server Integration Services packages and deploy it in Development/Testing and production server.

Created reports like linked reports, sub reports and filters in SQL server reporting services.

Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.

Work with the developers, data quality analysts and customer support and operations technicians to troubleshoot all databases.

Deploy, upgrade and configure new database and Coordinate database migrations with developers and other stakeholders.

Instrumental in development of BI solutions for complex business applications within HP that involves deep understanding of technical and business requirements.

Creating jobs for scheduling the SSIS packages.

Worked extensively on SSIS Packages for extracting the data of the file system and transformed that data and load it into OLAP.

Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.

Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.

Extensively utilized SSIS packages to create complete ETL process and load data into database which was to be used by Reporting Services.

Developed datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports

Trouble shooting various SQL server 2012/2008/2005/2000 Database connectivity issues from the web applications.

Experience on working in Agile/Scrum environments.

Environment: MS SQL Server 2012/2008R2/2005, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS), SQL Profiler, Windows XP/2000 and Windows 2003/2008 Server.

United Health Group August 2014 to September 2015

SQL/Reporting Analyst

United Health Group is the most diversified health care company in United States and a leader worldwide in helping people live healthier lives and helping to make the health system work better for everyone. We work with health care professionals and other key partners to expand access to quality health care so people get the care they need at an affordable price. UnitedHealth Group enhances the performance of the health care system and improves the overall health and well-being of the people we serve and their communities.

Responsibilities:

Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.

Extensively managed and administered SQL Server 2008/2005 and 2000 servers.

Analyzing and Understanding the business requirements.

Developed Employee scorecard reports which track all the employees hours spent in different projects, track time, break span and all other major information needed for the business.

Designed new SSIS packages and deployed them.

Converting SQL Server 2000 DTS packages to SQL Server 2005 SSIS packages.

Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.

Extensively worked with SSIS tool suite, designed and created mapping using various SSIS transformations like OLEDB command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Created Power-BI reports for the customers which are related to employee’s performance and published them in Power-BI web.

Expertise in creating various types of reports such as complex drill down reports, drill through reports, parameterized reports, matrix reports, sub reports, non-parameterized reports and charts using reporting services based on relational and OLAP databases.

Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.

Scheduled and executed SSIS Packages using SQL Server Agent.

Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and statistics updates.

Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems like MS SQL Server.

Transferred data (ETL) to Data warehouse environment using SSIS.

Monitoring SQL server performance using profiler to find performance and deadlocks.

Worked on database design for Query optimization, performance tuning and Indexing.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Windows XP/2000 and Windows 2003/2008 Server

Computer Solutions and Software International January 2014 to August 2014

SQL/MSBI Developer

VUE Compensation Management is a powerful, flexible and intuitive tool that makes it easy for insurance organizations to organize and streamline complex commission and incentive programs. VUE - is a suite of software components that provides support and management for all the aspects of the Home office. The system will create the reports and information necessary to manage the business and build strategic business knowledge. Agent Management, Agent License, Agent Appointment, Agent Contract, Carrier, Product, Insured, Plan, Financial, Reports, Tracking and Controlling, Admin & Document Management are the different components Present in VUE.

Responsibilities:

Developed T-SQL (DDL, DML) statements using SQL and defined Referenced relationships with the measure groups and fact tables.

Good in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.

Writing Stored Procedures, Triggers, cursors and creating indexes.

Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks to analyze CPU, Memory and Disk usage patterns.

Planned the complete backing up of Databases and Disaster Recovery /Restore procedures

Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking, Tempdb utilization on Production servers.

Responsible for database development in SQL Server 2008, worked on T-SQL functions and SQL syntax.

Transferred SQL Server Objects from QA to Production Using SSIS Packages.

Used DTS Packages to move logins and jobs from one server to another server.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, SSRS, Report Builder, SQL Server Analysis Services (SSAS),, SQL Profiler, Windows XP/2000 and Windows 2003/2008 Server

Dhanush InfoTech,( (http://www.beis.com/us/) India October 2009 to January 2014

SQL DBA/MSBI Developer

Brand Energy and Infrastructure Services is the leading diversified provider of specialty multi-craft industrial services to the North American downstream energy infrastructure market. Industrial services includes industrial scaffolding for work access, industrial coating and painting, abrasive blasting, industrial insulation, refractory, corrosion protection weatherproofing and other related crafts. Brand operates in four key energy sectors: refining, Canadian Oil Sands, petrochemical and power generation. The company also serves the infrastructure construction markets throughout North America and in strategic international regions.

Responsibilities:

Installation of SQL Server 2005/2008 on production, development and testing environments.

Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Services (SSIS) 2005.

Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink), Parameterized Reports(single valued parameters, multi-value parameters) etc.

Created Stored Procedures, DTS packages, tables, views and SQL joins and statements for applications.

Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle.

Created Perspectives & defined security, roles for different group of users.

Installing and configuring the SQL Server 2005 and SQL Server 2008 on windows 7 servers.

Creating New SSIS packages and Migrating SSIS packages from SQL Server 2005 to SQL Server 2008.

Implementing Backup and recovery process and Replication process.

Developed Queries for generating drill down reports in SSRS and prepared AD HOC reports through report builders. Defined the report layout and identified Datasets for the report generation.

Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.

Transferred data (ETL) to Data warehouse environment using SSIS.

Writing SQL Server Integration Services (SSIS) packages and deploy it in Development/Testing and production server.

Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.

Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Designed and Implemented the Stored Procedures for automating tasks.

Environment: SQL Server 2000/2005/2008, SSIS, Oracle, Enterprise Manager, Windows 2000/2003, SQL Profiler, T-SQL.

Contact this candidate