SSl, SQL SSIS SSRS SSAS BI

SHARATH CHANDRA

Senior SQL Server/ SSIS/ SSAS / SSRS Developer

Email: ****.***************@*****.*** Cell #972-***-****

PROFESSIONAL SUMMARY

8+ Years Microsoft BI Professional with experience in Database (OLTP), Data ware house (OLAP) Design, Programming, Development and Implementation of Client-Server Applications

Proficient in writing T-SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors and Query Optimization.

Sound knowledge of SQL server administrative skills including, backups, user roles authentication and authorizations and database creation.

Experience in Installations, Up-gradations, Configuring and Maintenance of Microsoft SQL Server 2008/2012/2014/2016, Microsoft Visual Studio 2010/2012/2013/2015.

Good Understanding of Kimball warehouse modeling and usage of modeling tools such as Erwin in designing Snowflake schemas, Star schema, fact and dimension tables.

Strong experience in logical, physical database design and development, Normalization and data modeling.

Extensive experience in BI suite comprising integration services (SSIS) for ETL (Extraction, Transformation & Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.

Skilled in High Level Design of ETL Packages using SSIS for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

Hands on experience in Dimensional Modelling.

Expertise in writing MDX Scripts to create datasets, reports and dashboards.

Expert in designing Enterprise reports using SSRS and Report Builder which includes drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and charts.

Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems in SSRS.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Extremely motivated, diligent, conceptually strong team player with ability to take new roles and adapt quickly to new technology.

Good communication skills paired with expertise analytical skills to help deliver successful results in the projects.

Certifications:

Microsoft Certified Programming in HTML5 with JavaScript and CSS3

Six Sigma Corporate Certification

Domains:

Banking, Healthcare and Telecom

Technical Skills:

BI Tools

MS BI (SSIS, SSAS, SSRS), QlikView, Tableau, Report Builder, Google Analytics, Google AdWords, Business Objects, Power BI

Database

MS SQL Server 2008/2008R2/2012/2014/2016, Oracle 11g/10g, MS-EXCEL, MS-ACCESS

Data Modeling

Erwin, Visio

Programming

C#.Net, PL/SQL, T-SQL, VB.Net

Productivity Applications

MS Word, MS Excel, MS Access, Visio, MS Outlook

Web Technologies

HTML, XML, CSS, JavaScript

Operating System

Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

PROJECT SUMMARY

T-Mobile, Atlanta, GA July 2014 – Present

Sr. SQL Server/ SSIS/ SSAS / SSRS Developer

Responsibilities:

Participate in all phases for building a Data Warehouse for analysis, requirement gathering, Design and Development of code

Understanding the report requirements

Consolidation of all the requirements and identifying the unique variables required per scope

Data analysis based on the data dictionary for various source systems and CDR files

Identifying the gaps between the requirements and data analysis

Involved in ETL design documentation

Developed ETL packages using SSIS which involves applications of various transformations

Ensure the ETL code delivered is running, conforms to specifications and design guidelines and analyze the data in the source to look for data quality problems and write code to fix data quality issues

Unit testing the ETL code to ensure it can be delivered and run in a system testing environment

Monitor Scheduled ETL Jobs & reports and resolve issues if any

Developed stored procedures and functions in SQL Server

Created jobs, schedules and performed other DB related tasks in SSMS.

Monitored the jobs activity through the job activity monitor.

Extensively involved in SSAS cube creation, storage and partitions, and Aggregations, calculation of queries with MDX.

Created and maintained dashboards in SSRS and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirements.

Developed reports and dashboards in Power BI.

Migrated existing self-service reports and ad-hoc reports to Power BI.

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

Maintained check lists at various stages of the project

Developed audit scripts for integrity check and reconciliations

Performed unit testing, system integration testing, UAT, stress test and operational readiness test.

Performed root cause analysis for the issues raised and fixed them

Environment: SQL Server 2014, SQL Server Data Tools for Visual Studio 2015 (SSIS, SSAS, SSRS), MS Office, Power BI

Citibank, Singapore Jan 2013 – April 2014

Senior MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Slowly Growing Target, and Simple Pass through Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.

Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.

Worked with different methods of logging in SSIS.

Developed stored procedures and functions in SQL Server

Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.

Migration of code from one environment to other. Ex: development to SIT

Designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc

and Sub-reports using Report Designer and Report Builder based on the requirements.

Deployed SSRS reports in MS-CRM Dynamics Solution.

Created specific ad-hoc reports and dashboards in Tableau 8.0.8.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Developed Tableau workbooks from multiple data sources using Data Blending.

Environment: SQL Server 2014, SQL Server Data Tools for Visual Studio 2013 (SSIS, SSAS, SSRS), MS-CRM Dynamics, Tableau 8.0.8

GSK, Philadelphia Aug 2011- Dec 2012

MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

Created the Cubes and Dimensions.

Created partitions and designed aggregations in Cubes.

Defined relationships between Measure groups and Dimensions.

Defined granularity with in a measure group and drill through actions.

Implemented the calculations to aggregate physical measures.

Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.

Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.

Created ETL package for data conversion using various transformations tasks.

Created partitions (employed storage modes and usage based optimization), calculated members, KPI's and perspectives to enhance the cube's utilization. Also used MDX to query them.

Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

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

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

Created dash board to show the business performance.

Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

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

Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.

Environment: SQL Server 2012, SSIS (2012/2008), SSRS (2012/2008), SSAS 2012/2008, Visual Studio 2010/2013, MS Excel 2010

Molina Health Care, Irving, Texas July 2010-Aug 2011

MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and other complex SQL statements.

Developed the SQL programs and optimized stored procedures, queries for faster retrieval.

Created jobs, alerts to run SSAS, SSRS packages periodically. Created automated processes for activities such as database backup processes.

Implemented failure alerts using email in SSIS.

Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server Analysis Services (SSAS).

Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).

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

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports, Drill-through and Drill-down using SSRS/Report Builder 3.0

Created dashboards for Inpatient, outpatient, finance and safety using benchmarked data to provide an analytical snapshot of point in time data.

Deployed various SSIS Packages, SSRS Reports and SSAS Cubes as per the business requirements.

Environment: SQL Server 2008 (SQL Server Management Studio, SQL Profiler, Integration Service (SSIS),Reporting Services (SSRS NET, C#

Reddy Labs, India Jun 2009 - May 2010

SQL Developer Intern

Responsibilities:

Involved in configuring and converting MS SQL Server 2005 database to MS SQL Server 2008.

Partially involved in Database design and Database objects.

Created backups for databases.

Partly Involved in Performance tuning.

Created ActiveX DLL COM Components using Visual Basic 6.0.

Responsible for Developing GUI Screens

Involved in developing E-R diagrams, logical & physical data modeling, development and

implementation of the system.

Responsible for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.

Developed various management reports using SSRS.

Maintain the application as per the user requirement.

Environment: SQL Server 2005/2008, ASP .Net, VB Script, SSRS, Access, Excel

Contact this candidate