SSIS,SSRS,SSAS,Sql Server,Power BI, Dotnet

SANDEEP VUTUKURI

MSBI/Power BI Lead 916-***-**** *******.********@****.***

PROFESSIONAL SUMMARY

Over 8+ years of experience in Microsoft Development with SQL Server environments. Thorough knowledge of SQL Server 2008R2/2012/2014 databases.

Extensive experience in Database Design and development of applications with Business Intelligence using SQL Server 2008/2012, Integration Services(SSIS), DTS Packages, Reporting Services 2005(SSRS), SQL Server Analysis Services(SSAS), MDX Queries, OLAP Cubes, Star Schema and Snow Flake Schema.

Good communication skills with excellent work ethics and a proactive team player with a positive attitude. Domain Knowledge of Legal, Finance, Logistics and Health insurance.

Have excellent skills in Data Warehouse, Relational and Multi-Dimensional databases, Data Migration, System & Data Integration, Reporting, Analysis and Software Development and Data Management.

Strong experience on T-SQL and query optimization, developing ETL strategies.

Strong skills in Power BI, Microsoft Excel - formulas, Pivot Tables, Charts and DAX Commands.

Delivered BI reporting solutions in Power BI, Reporting Services (SSRS).

Excellent communication skills bridging Client Interaction and Team Management.

Self-motivated individual with strong analytical and problem-solving abilities, Proactive, Dedicated, enjoy learning new technologies and willing to take on extra responsibilities to get work done.

Handled the tasks of providing technical direction for developing, designing and integrating systems for customers

Handled the responsibilities of managing technical risks throughout the project

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

Designed and created databases, tables, views, store procedures and triggers.

Suggest index tuning and performance optimization techniques.

Expertise in various phases of project life cycles (Design, Analyzing, Implementation and testing).

Expertise in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert, and Merge Join.

Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert and BCP.

Expert in migration of databases from Oracle and non-oracle sources to SQL databases using SSIS (SQL Server Integration Services).

Expert in creating various types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Expert in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services (SSIS) with C#.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP

Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent.

TECHNICAL SKILLS:

Operating System: Windows XP/2003/7, UNIX

Languages: C#, ASP.NET, VB.NET, C, C++, Java, VB6,

Databases: MS SQL Server2005/2008/2008 R2/2012/2014, Millennium Database, Oracle

Data Warehouse Tools: SSIS, SSRS, SSAS, Discern Explorer, SAP BO WEBI

Web Technologies: HTML, DHTML, VB Script, Java Script and ASP

EDUCATION:

Master of Science at University of Central Missouri, 2014 (3.5 GPA)

Post-Graduation Diploma in Software Development, 2011 (3 GPA)

CERTIFICATIONS:

Certified Microsoft SQL Server 2012 Developer (MCSE Exam 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012). (MS ID: MS0615939816)

Power BI EDX Certified

PROFESSIONAL EXPERIENCE

Company: Aptude, Chicago IL

Nov 2016 – Till Date

Client: Hub Transportation

Role: Senior BI/SQL Lead

Responsibilities:

Develop SSIS packages, SQL Scripts for loading data across various Sources.

Create meta-data tables and transformed the data from Staging to Production environment.

Involved in meetings with business users and analysts to gather the requirements.

Involved to prepare technical design document for developers based on fictional flow.

Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, UAT and Production Environments.

Actively giving supporting to business users in the day to day operations.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

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

Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.

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

Managed SQL database user accounts, user logins, permissions, database and server roles

Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.

Created Job Monitoring and Financial Dashboards using Power BI and DAX quires.

Integrated Custom Visuals based on business requirements using Power BI desktop.

Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

Created Job Monitoring and Financial Dashboards using Power BI and DAX quires.

Developed complex calculated measures using Data Analysis Expression language (DAX).

Embedded Power BI reports on SharePoint and managed access of reports and data for individual users using Roles.

Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Company: Tek Systems, Houston TX

Sep 2015 – Oct 2016

Client: Gexa Energy

Role: BI/SQL Developer

Responsibilities:

Obtained user approvals from the client for the collected requirements to ensure similar understanding between development team and business.

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

Creating EDI files from the Source data and loading them in to destination datawarhouse.

Performed operations like sorting, merging on the source data in order to clean the data and remove duplicates.

Design and implement Stored Procedures, Complex Queries using Joins & Sub Queries for inserting the customer data, to get the customer details and get the Category Plans.

Wrote (T- SQL) and fine-tuned complex stored procedures using control of statements (Case, if else and While).

Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.

Experience in writing MDX queries for Performance optimization of the SSAS cubes.

Used Performance Point Server to create interactive reports with an ability to drill down into details.

Company: Cognizant, Long Beach CA

Aug 2014 – Sep 2015

Client: Molina Health Care

Role: BI/SQL Developer

Responsibilities:

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

Developed SSIS Templates which were used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).

Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2012.

Created OLAP applications with OLAP services in SQL Server and build cubes with many dimensions using both star and snow flake schemas

Extracted and transformed Data from OLTP databases to the specific database designed for OLAP services (was involved in the creation of all objects for that database) on off-peak hours

Created stored procedures and performed index analysis for slow performing SSRS reports to bring down the report rendering time from 15 mins to 30 seconds.

Developed Enterprise wide cascading reports in SSRS that were used throughout the agency to monitor the performance of the cube, logging of the nightly ETL loads and also to monitor most active users of the cube.

Migrated existing self-service reports and adhoc reports to Power BI.

Developed custom calculated measures using DAX in Power BI to satisfy business needs.

Used Team Foundation Server (TFS) for source control and sprint planning. Designed cubes with star schema using SQL Server Analysis Services (SSAS).

Company: NTT Data, Hyderabad

Feb 2012 – Aug 2013

Client: National Life Group

Role: Lead BI Developer

Responsibilities:

Installation and Upgradation of SQL Server 2008 and SQL Server 2012 on Production Environments.

Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL Server 2008

Created stored procedures, views, indexes and joins as needed. Involved in Performance Tuning of databases to optimize existing applications and processes.

Worked with different Types of files like UPD, PCF, VMF, and RCF.

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

Created Cubes using SSAS to analyze data in different dimensions, such as based on location or time.

Company: Polaris, Hyderabad

Oct 2010 – Feb 2012

Client: Citi Bank

Role: BI Developer

Responsibilities:

Creating New SSIS packages and Migrating SSIS packages from SQL Server 2008

Deploying the code, SSIS packages sin production servers.

Exclusively worked on Script task (C#.NET, VB Scripting), File System Task to read the excel files and updating the excel files in ETL package.

Applied knowledge of Normalization and De-Normalization techniques. Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions).

Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).

Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries. Performance tuning of Stored Procedures and T-SQL Queries.

Company: Kansolve Technology, Hyderabad

May 2008 – July 2010

Client: HDFC Bank, HP

Role: BI Developer

Responsibilities:

Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.

Installed SQL Server 2005 Servers, multi instances.

Responsible for security and roles.

Responsible for development of Procedures, Functions and database Triggers.

Designed Data was stored in MS SQL Server. Created indexes and analyzed its role

Contact this candidate