Sql Server Data

KISHORE REDDY

Mobile : 323-***-****

Email : acv6qd@r.postjobfree.com

Experience Summary:

5+ years IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008/2005/2000 in Development, Test and Production Environments with insurance, sales domains.

Experience with T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and working knowledge of Analysis Services (SSAS).

Experience in Database Development, modelling, Data Warehousing, Design and Technical Management.

Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2005 to 2008/2012.

Experience in creating and developing different types of reports using SQL Server Reporting Services and Crystal reports and migration of Data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server by using BCP and SSIS utility.

Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, schedule reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, mailing label.

Migration of SSRS reports from SQL 2005 to SQL 2008.

Extensive experience with data modelling techniques, logical and physical database design.

Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.

Experience in working/migration of data with SSIS (SQL Server Integration Services) as an ETL tool for Data integration services and business applications. Creating SSIS packages using various Data transformations like conditional splitting, Derived column, Fuzzy Look Up, for each Loop, Multi Cast, column conversion, Fuzzy Grouping.

Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.

Used MDX to interact with the back end OLAP Services.

Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.

Created Reports with complex formulas and to query the database for business Intelligence.

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors, relational database models, data dictionaries, and maintaining data integrity and Indexes using T-SQL.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

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

Expert in ETL designing.

Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.

Experience in Creation and deployment of cubes on SSAS.

Good understanding in Oracle 9i/10g Database.

Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database

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

Experience in Analysing Execution Plan and managing indexes and troubleshooting deadlocks.

Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.

Worked Extensively on ETL process using SSIS package.

Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.

Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.

Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.

TECHNICAL SKILLS

RDBMS

MS SQL Server 2005/2008 R2/2012, MS-Access

Web Technologies

HTML, ASP.Net, XML, Java Script and VB Script

Languages

C, C++, JAVA, C#, T-SQL, VB.NET, XML

Operating Systems

Windows server2005/ 2008R2/2012

Version Control Tools

Visual Source Safe and SVN

Reporting Tools

Microsoft Reporting services SSRS, Report Builder 3.0, Tableau tool

ETL Tools

SSIS 2008R2/2012, Informatica Power Center 7.x/6.x and PowerMart 8.x/7.x

Packages

Microsoft Office and Microsoft Business Intelligence

Modeling Tool

Microsoft Visio

Employment Summary:

Career Profile:

SQL BI Developer (T-Sql/SSRS/SSIS)

MetLife - Morristown, NJ

August 2015 to Present

Responsibilities:

Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development and testing.

Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions

Designed the Data warehouse and done the mappings from Source to the Target tables.

Worked extensively on SSIS packages to implement the data load strategy

Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.

Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.

Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse

Identified the dimension, fact tables and designed the Data-Mart using Star schema.

Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.

Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs

Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.

Worked with SQL queries using MS Access for data manipulations.

Wrote T-SQL queries, Stored Procedures and used them to build packages.

Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.

Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012

Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.

Created and Maintained various database in MS Access to track activities and progress.

Involved in Dimensional Data Modeling and Cube partitioning in SSAS.

Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus making them user friendly.

Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.

Created and Maintained various database in MS Access to track activities and progress.

Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.

Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.

optimized the queries by creating various clustered, non-clustered indexes and indexed views

Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution

Involved in testing, bug fixing and documenting the work for the project at each and every phase

Skills Used

MS SQL Server 2012/2008/R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

VMT Technologies India Pvt ltd. May 2010 – June 2013

Role: SQL/MSBI Developer

On a major merger & acquisition initiative by PruHealth & Discovery, the group acquired Standard Life’s Healthcare business. Post buyout of Standard Life Healthcare, PruHealth manages the acquired book of business (from Standard Life) under the legal entity “PruHealth Insurance Limited” (PHIL). Standard Life currently hosts Policy admin and claims systems and the associated infrastructure for PruHealth, on the basis of a time-bound service contract. PruHealth launched its new product line code named “EVE”, covering personal healthcare, business healthcare & corporate Healthcare products in March 2011. The business drivers for the transformation program are –

Remove dependency on Standard Life and host HEAL 2.0 & PAPILLON 1.5 applications in PHL data centre to remove existing dependencies on Standard Life there by leading to cost savings on service contract with SL.

Improve operational efficiencies, by bringing together the best application features from PARADIGM & HEAL 1.0 into HEAL 2.0

This leads to develop a new strategic data warehouse to support existing reports on the new platform.

Responsibilities:

Development of SSIS ETL packages in optimal way using package execution trees

Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Making a Report as per user requirement using MS Reporting Services 2008 (SSRS).

Created SSIS Packages to migrate slowly changing dimensions.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

Worked on improving the performance of the system.

Involved in the tuning of the existing Database Objects.

Development of SQL procedures, SQL function implementing business logic

Development of OLAP cubes for users reporting

Performance tuning of the application SQL Queries

All Database Administration activities include Index maintenance, Database consistency check, Updating Database Statistics, Backup strategy of databases and DR strategy

Improving Stored Procedures performance by using SQL profiler and Database tuning advisor

Improving the OLAP Cube performance by implementing Measure Group Monthly partitions for faster reports generation and faster cube processing

Came up with different test scenarios for automating Unit test cases, Build verification test cases and Environment test cases

Developing deployment and build document for the application

Taking Care of Database File groups and Files growth

BI Application migration from SQL Server 2008 R2 to a SQL Server 2012

Grant/Revoke permissions for login accounts as per request

Handling new change requests and defects for the existing phases in the production environment

SQL Server Developer

Automotive Axles Ltd, India - Bangalore, Karnataka

March 2009 to April 2010

Responsibilities

• Installed SQL Server 2008 on development and production servers setting up databases, users, roles and permissions.

• Upgraded all SQL Server 2000 to SQL Server 2008 without any service interruption.

• Involved in the all the stages of Software Development Life Cycle (SDLC).

• Involved in the normalization and de-normalization of the databases.

• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2008.

• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008.

• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.

• Created SSIS packages to transfer data from different data sources load it to data warehouse.

• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.

• Migrated DTS packages to SSIS packages using package migration wizard.

• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.

• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services. Wrote MDX queries according to the business requirements.

• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2008 Reporting Services (SSRS).

• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.

• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies and scheduled jobs using SQL Server Agent.

• Deployed code into the production environment. Provided 24/7 production support for the production database.

Skills Used

MS SQL Server2008, SQL, and T-SQL.

Education

Bachelor of Technology (Computer Science & Engineering) - JNTU-ANANTAPUR

Master of Science in Electrical & Computer Engineering (3.3+) -California state university Los Angeles - june-2015

Contact this candidate