Sql Server Data

Phani Kumar

SQL BI Developer

Phone: 469-***-****

Email: *********.*****@*****.***

Summary:

Over 8+ years of IT experience in Database Administration/Database designing/ Data Warehouse Designing and Development using MS SQL Server 2000/2005/2008/2012/2014.

Experience in installing, configuring, managing, monitoring and troubleshooting.

Experience in code optimization and improving efficiency in databases including Re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.

Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.

Expert of MS SQL Server suite of Business Intelligence products SSRS, SSIS and SSAS.

Expertise in scripting T-SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.

Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL.

Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.

Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS).

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS-SQL Server by using BCP utility, DTS and SSIS services.

Expertise in creating Packages by SSIS/DTS for ETL work.

Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.

Experience in designing Ad hoc reports and different types of Drill Down, Drill Through reports, Tabular reports, Cross tabs, Matrix reports, Custom reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services SSRS.

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, Ad-hoc and Sub Reports.

Proficient in designing and developing cubes using SQL Server Analysis Services (SSAS) and leveraging the advanced BI functionality of SQL Server 2005.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies using SSAS.

Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.

Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.

Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

Education:

Bachelors in Electrical and Electronics Engineering.

Technical Skills:

Operating System

Windows, Ubuntu, Unix

Languages

C, C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL

Tools

DTS, SSIS, SSRS, SSAS

DATABASE

MS Access, MS SQL Server 2000/2005/2008/2012/2014, Oracle 9i/10g

Tools/Utility

Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, Analysis Manager, BCP, SQL Profiler, Visual Studio 2003/2005/2012

Software

MS Office, Visio, Adobe Photoshop, MS Excel, MS-Project 2013

Reporting Services

Excel, SQL Server Reporting Services 2005/2008/2012

Professional Experience:

Windstream Tele Communications, Dallas, Texas Jul 2015 – Till Date

SQL/SSIS/SSRS/SSAS Developer

Windstream Communications provide high-speed broadband Internet, Phone Service and Digital TV Packages to residential customers as well as products and services for small, medium and large business, and government agencies.

Responsibilities:

Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.

Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle database, flat files to SQL server 2012.

Conducted iteration kick-off meetings with Business Users, Project Manager, Development and QA teams to document Product Backlog Items (PBI), high level business process models and high level architectural models.

Analyzing PBI (Product Backlog Items); Sprint Planning, User stories, Converting into process flow diagrams for details analysis

Developed efficient SSIS packages for processing fact and dimension tables with complex transformations.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.

Used comprehensive knowledge of T-SQL code as well as SSIS, SSRS, visualization tools i.e. Power Bi and Tableau.

Creation of Excel/ Power BI Reports as and when needed and Worked with Power BI to develop enhanced and interactive excel sheets.

Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.

Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS and adding calculations using MDX.

Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented Cell Level Security in cubes using SSAS.

Created Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.

Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

Responsible for providing 24X7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.

Environment: SQL Server 2014/2012/2008 Enterprise Edition, SSRS, SSIS, SSAS, .NET Framework, C#, ADO.NET, Windows Advance Server, XML, MS Excel, Access and Team Foundation Server (TFS).

Physio Control, Seattle, WA Apr 2014 - Jun 2015

SQL/SSIS/SSRS/SSAS Developer

More than 55 years ago we introduced a medical device that launched an industry. Today we continue to set new standards for the design and manufacturing excellence of lifesaving tools for lifesaving teams in and out of the hospital. Physio-Control. The world leader in the development, manufacture, sale and service of external defibrillator/monitors and emergency medical response products and services.

Responsibilities:

Responsible for creating Databases, Tables, Clustered/Non-Clustered Indexes, Unique/Check Constraints, Views, Stored Procedures & Triggers.

Extensively worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target database using SQL Server Integration Services (SSIS).

Applied different transformations Lookups, Data Conversions, Conditional Split and Derived Column to easily migrate SSIS package from one server to another.

Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records.

Developed packages using SSIS and controlled its execution, by implementing the infrastructure that enables execution order, logging, variables, and event handling.

Scheduling Jobs and Alerting using SQL Server Agent.

Extensively involved in data transformations, validations, extraction and loading process. Implemented various Teradata Join Types like Inner-join, outer-join, self-join and Merge-join.

Created and integrated User Defined Functions and Stored Procedures for reporting purposes using SQL Server Reporting Services (SSRS).

Created Charts, Tabular and Matrix reports using SSRS, with/without Drill down.

Generating reports that can handle Dynamic Grouping and Dynamic Sorting.

Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

Developed data visualization reports and build dashboards using Microsoft Power BI.

Learnt & Used Sybase Power Designer as the modeling tool for the database migration

Monitoring of Sybase error log for all Data Server.

Troubleshoot problems related to Sybase to SQL Server conversion.

Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculation.

Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables.

Performed and assisted in DBA duties including: database backups, restores, performance tuning, and capacity analysis.

Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.

Environment: SQL Server 2008/2012 Enterprise Edition, Enterprise Manager, ERWIN, UML, MS Project, .NET, C#, ASP.NET, SSIS, SSRS, SSAS, Team Foundation Server (TFS), SQL Server Agent.

Caresource Inc., Dayton, Ohio Jan 2013 - Mar 2014

SQL/SSIS/SSRS/SSAS Developer

CareSource is a leading nonprofit managed care company based in Dayton, Ohio. CareSource has been meeting the needs of health care consumers for more than 25 years with Health Plans. Implementation of HIPAA Standards in Medicaid for OH, KY and IN states for Caresource.

Responsibilities:

Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Experience in Creating and Updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.

Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.

Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.

Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).

Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.

Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.

Created multiple reports (SSRS) like Drill-Down, Drill-Through, Sub Reports, Chart Reports & Matrix Reports.

Design, deployment, and maintenance of various SSRS Reports in SQL Server.

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.

Generated reports using the Reporting Services analyzed using Server analysis (SSAS).

Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Backing up, restoring system & other databases as per requirements, and also scheduled those backups.

Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008/2005, Visual Studio 2008/2010, Windows 7, SSIS, SSRS, Report Builder 3.0, SQL Profiler, SQL Server Agent, MS Excel, Power Pivot, TFS.

Corning Inc., Midland, NC Jun 2012 - Dec 2012

SQL/SSIS/SSRS Developer

Corning Incorporated is the world leader in specialty glass and ceramics. Corning creates and makes keystone components that enable high-technology systems for consumer electronics, mobile emissions control, telecommunications and life sciences.

Responsibilities:

Installed and configured MS SQL Server 2008 Enterprise Edition on multiple environments.

Gathered user requirements from users and managers to better understand the business logic of the company and create database that fits their needs.

Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views, CTE’s and other T-SQL scripts.

Developed and created logical and physical database architecture for servers and warehouses. All tables in database were normalized up to third normal form.

Migrated data from text files and Excel spreadsheets to SQL Server databases using SSIS.

Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.

Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File and vice versa.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.

Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.

Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.

Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.

Environment: SQL Server 2008, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows XP, Visual Source Safe (VSS), SQL server profiler, SQL Server Management Studio (SSMS).

Micron Technology Inc. Boise, ID Dec 2011 - May 2012

SQL/SSRS/SSIS Developer/DBA

Micron Technology, Inc. is an American multinational corporation best known for producing many forms of semiconductor devices which includes DRAM, SDRAM, flash memory, SSD and CMOS image sensing chips. Micron and Intel together created IM Flash Technologies, which produces NAND flash memory.

Responsibilities:

Managed the migration of SQL Server 2005 databases to SQL Server 2008.

Created Table, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.

Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.

Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Developed various operational, drill-through and drill-down reports using SSRS.

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

Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services SSIS) to overcome transformation constraints.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Involved in the Data modeling, Physical Design of Database using tools like Erwin.

Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.

Performing Replication (snapshot and transactional).

Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: SQL Server 2005/2008, Reporting Services (SSRS), Integration Services (SSIS), DTS, Oracle 9i/8i, T-SQL, XML, MS Excel and MS Access.

State Bank of India, Hyderabad, India Sep 2010 – Nov 2011

SQL/ETL Developer

Responsibilities:

Creation, manipulation and supporting the SQL Server databases.

Involved in the Data modeling, Physical and Logical Design of Database

Created tables, indexes, sequences, constraints, triggers and procedures.

Stored procedures and triggers were used to implement business rules.

Helped in integration of the front end with the SQL Server backend.

Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS) & SQL Server Integration Services (SSIS).

Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries

Created documentation as required.

Build efficient SSIS packages for processing fact and dimension tables with complex transforms.

Created SSIS package to get data from different sources, consolidate and merge into one single source.

Environment: MS SQL Server 2005, SQL Integration Services (SSIS), Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS), T-SQL, Visual Studio 2008, Windows 2007 Enterprise, MS Office 2007.

Hindustan Coca-Cola Beverages Pvt Ltd, Athmakur, India Jul 2008 – Aug 2010

Jr. SQL Developer/DBA

Responsibilities:

Actively supported business users for change in requests.

Created T- SQL queries for data retrieval and created other database objects like tables, views, Stored Procedures, Functions, Triggers and indexes.

Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Installed and configured SQL Server 2005 successfully.

Assisted the front end application developers with their queries.

Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Created the test file, which includes all the scenarios and complexities of the product.

Wrote distributed queries for Linked Servers.

Maintained the consistency of the client’s Database using DBCC.

Performed replication of data and planned backup strategy based on project requirements.

Environment: MS SQL Server 2000/2005, MS SQL Enterprise Manager, Visual Source Safe (VSS), SQL Profiler, SQL Server Management Studio (SSMS), T-SQL, VB, Java Script, MS Excel, SQL Server Agent.

Contact this candidate