Sql Server Data

L TALLURI

SQL Server/BI Developer

Phone 219-***-**** Email:********.*@*****.***

Summary

* ***** ** ********* ***** MS SQL Server 2014/2012/2008 R2, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services)

Extensive programming, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2014/2012/2008and Business Intelligence Studio.

Excellent in working on SSIS,SSAS, SSRS, OLAP, OLTP, Reporting and Analytics, Data Cleansing, Data Scrubbing, Data Migration and writing T-SQL.

Experience in creating/deploying MS SQL Server Integration Services (SSIS) packages, Analysis Services (SSAS) and Reporting Services (SSRS).

Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services (SSIS).

Experience in transforming data from Excel, Flat file, Oracle, MS Access to MS SQL Server by using SSIS 2012/2008/2005.

Experience in creating MDX, DAX queries in SSAS cube for various calculated members, KPI, Actions, Aggregation, Perspectives and various actions such as drill through, reporting etc.

Experience in building various types of reports like table, matrix, charts and gauge using various reporting tools such as SSRS, Tableau

Experienced in using Normalization and De-Normalization techniques.

Experience in creating complex Stored Procedures, Indexed Views, appropriate Triggers to assist efficient data manipulation and data consistency. Hands on using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).

Technical Skills

Programming Languages

C,My SQL, MS SQL, PL-SQL

BI and ETL tools

Microsoft SQL SERVER 2014/2012/2008/2008R2, SSIS, SSRS, SSAS

Reporting Tools

Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0, Crystal reports 10, ProClarity, Tableau, Logi Analytics

Relational Databases

SQL SEVER 2014/2012/2008R2/2008

Office and Other Tools

Microsoft Word 2013, Microsoft Excel2013, Microsoft Power Point 2013, Microsoft Visio, Microsoft Access

Professional Experience

Client: Telligen, West Desmoins,IA Sep 2016 – Present

Role: SQL BI Developer

Telligen Provides the Healthcare IT Business intelligence solutions for the consumers and providers to improve the quality and cost effectiveness healthcare, and dedicated itself for providing the healthcare solutions for more than 30 years

Experience in writing the SQL and My-SQL Queries and optimizing the SQL queries in SQL Server 2014 and Workbench 6.3 as part of Data Migration Project

Experience working with the RDBMS Concepts and working with the Triggers, Views, Stored Procedures, Functions, Indexes

Extensive knowledge and experience in producing tables, reports, graphs and charts using various procedures and handling large databases to perform data manipulations.

Experience in creating the Dashboards using Logi analytics reporting services and delivering the solutions to end users

Designed, coded, tested and debugged custom queries using Microsoft My-SQL and SQL Reporting Services

Experience with the Agile scrum methodologies, JIRA life cycle management for Project implementation and tracking

An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project

Retrieved data from data warehouse and generated a series of meaningful business reports using Logi Analytics.Validated and tested reports, then deployed the reports to the report server

Conducted and performed complex custom analysis as needed by the end users, and designed and developed specific databases for collection, tracking and reporting of data.

Experience in creating the Ad-hoc reports and defining the security for the user access to the reports and dashboards

Documenting the process and preparing the test scenarios and updating the stories accordingly for the future reference

Environment: SQL Server 2014, My-SQL Workbench 6.3,Logi Analytics 12. Subversion, JIRA 6.3.3, Quick Build, Novel, Integration Services (SSIS), Analysis Services (SSAS)

Client: Micron Technology, Inc. Boise, ID Nov 2014 – Aug 2016

Role: SQL SSIS/ SSAS Developer

Micron Technology is the global leader in the semiconductor industry for more than 30 years, and dedicated itself to collaborating with engineers that drives innovation, and building some of the worlds most advanced memory and semiconductor technology.

Roles and Responsibilities:

Data gathering and importing into SQL Server and writing queries in the SQL Language, and from heterogeneous sources

Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2012.

Worked on various tasks and transformations like Execute SQL Task, DFT, Execute Package Task, and Conditional split, Script Component, Row Count, Unpivot, Merge and Lookup while loading the data into Destination.

Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server Analysis Services

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

Experience working with the Share point environment for the data storage and sharing across the company and with TFS for implementation of the business priorities

Experience in working with the Agile Methodology keeping track of tasks progress and road blocks in the implementation of the business needs

Generated Sub-Reports, drill down reports, drill through reports, Parameterized reports using SSRS and created various types of reports like chart, tabled, matrix and linked reports and maintained accurate and complete documentation for all packages.

Experience in analyzing the data using Tableau, SSAS, Excel and creating the reports and dashboards using the data for the business analysis

Responsible for the data integrity of the databases and creating the cubes on the top of the databases and developing the dashboards connecting to the Analysis server

Environment: SQL Server 2012/2008, SSRS, SSIS, SSAS, SSMS,MDX, ProClarity, Subversion, TFS, Active Batch, Rational Clear Quest, BMC Service Request Management, CPS, RCTOOLS.

Client: Argus, NYC, NY July 2013 – Oct 2014

Role: SR. SSIS/SSRS/SSAS/Tableau Developer

Argus Group is a leading provider of independent commercial real estate consulting and advisory services, software and data solutions. Operates five interrelated Business Units, bringing together years of experience and a broad range of expertise into one comprehensive platform

Roles and Responsibilities:

Migrated the existing database from SQL Server 2005 to SQL Server 2008 and worked on improving the performance of the system.

Developed report specifications, created and modified reports using SSRS 2008, deployed, and maintained of various SSRS Reports in SQL Server 2008.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Experience working with the SSAS Cubes using Sql server Analysis Services and writing the MDX queries

Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Experience in analyzing the data using SSMS, Excel, SSAS, SSRS reports for maintaining the data integrity

Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.

Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers

Environment: SQL Server 2012/2008/2005,Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS),Tableau 8.0.1, Crystal Reports, Team Foundation Server, Agile.

Client: Humana, Lexington, KY Mar 2012 – June 2013

Role: SQL BI (SSIS/SSAS) Developer

Humana is a Health insurance provider concentrates on the Medical, Dental, Vison pharmacy, and Medicare. Humana is standing as one of the most trusted insurance company in the United States offering the plans covering the needs of the customers.

Responsibilities:

Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan in SSMS

Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005/2008/2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all

Experience in creating stored procedures, triggers, Views, cursors, CTE’s, T-SQL scripts, schemas, permissions and performance issues with client/server database design

Defined Check constraints, Business Rules, Indexes, and Views

Experience in creating and managing stored procedures, indexes, views, UDF’s, Database Constrains, to meet business requirements and policies.

Good Knowledge in Designing and Building the Dimensions and cubes with star schema and writing MDX queries using SQL Server Analysis Services (SSAS)

Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts

Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes

Experience in writing the SQL Statements, PL SQL, SQL* plus Commands for modifying and retrieving the data.

Client: Minacs Marketing Solutions, Flemington Hills, MI Sep 2010 - Feb 2012

Role: SQL Server, SSIS/ SSRS Developer

Minacs marketing is a premier Channel direct marketing and specialist incomplete marketing optimization and enablement solutions providerto the notable array of client includes world largest automakers and industry manufacturers

Roles and Responsibilities:

Developed, modified, and optimized complex SQL Queries, stored procedures, triggers to handle complex business rules, history data and audit analysis

Created triggers, views, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective

Experience in developing the Cubes using SQL server analysis services (SSAS), with star schema and snow flake schemas

Experience in working with power pivot for report building and creating the dashboards for the business needs

Knowledge in the IBM Cognos tool for the changes in the packages and reports using the Framework Manager and Report Studio

Experience in collecting the user requirements and documenting by creating the use case and flow activity diagrams

Responsible for creating constraints, Indexes, and Views

Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary

Experience in working with creating adhoc, drill down, drIll through, parameterized reports using SSRS

Experience working with the SSIS integration services for ETL loads from one environment to other

Experience in creating the OLAP multidimensional cubes and writing MDX expressions using SQL Server Analysis Services

Responsible for MS SQL Server 2000 in Production, Test, Development and Replication &Cluster Server Environments

Environment: SQL Server 2000, Windows 2000 Advance Server, Windows 2003 Server, XML, T-SQL, MS Excel, MS Access, SSIS, SSRS, SSAS, MS SQL.

Client: ENKAY TELECOM, Pune, India July2009– June2010

Role: Application and SQL Server Developer

Enkay telecom is an Internet service provider and also develops telecom-billing software for telecom companies and resellers.

Roles and Responsibilities:

Data transfers between various servers using BCP and DTS

Actively involved in different stages of Project Life Cycle

Installation of MS SQL server on multiple environments and Creating tables and databases, defining entity, attributes relationships using constraints

Followed and maintained standards and best practices in database development

Involved in tuning of database by creating efficient stored procedures and T-SQL statements

Involved in database programming in writing stored procedures, triggers

Created Clustered and Non-Clustered Indexes for improved performance

Created Tables, Views and Indexes on the Database, Roles and maintained Database Users

Documented the data flow and the relationships between various entities

Actively participated in gathering of User Requirement and System Specification

Created new Database logical and Physical Design to fit the new business requirement and implemented the same using SQL Server

Provided assistance to development teams on Tuning Data, Indexes and Queries

Developed new Stored Procedures, Functions, and Triggers

Implemented Backup and Recovery of the databases

Actively participated in User Acceptance Testing, and Debugging of the system

Environment: MS SQL 2000, Windows 2000/XP, SQL Query Analyzer and Enterprise Manager. MS Access 2000 & Windows NT platform

Education:

Bachelor of Science in Computer Science Engineering. (J.N.T.U)

Contact this candidate