THAPASYA M

SQL BI Developer

ac34w7@r.postjobfree.com

469-***-****

PROFESSIONAL SUMMARY:

5+ Years of IT experience in the design, development, support and migration of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 database in Finance, Manufacturing and Healthcare industries

Strong SQL Server developer Skills including writing user defined functions, views and query writing

Strong knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP

Solid Knowledge of Data warehousing (Star Schema and Snow Flake Schema)

Proficient in MS SQL Server suite of products like SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, and SQL Server Reporting Services SSRS of MS SQL Server

Experience in developing ETL (Extract Transfer Load) interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions & features in Business Intelligence

Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, and Fuzzy lookup, Fuzzy Grouping, Pivot and Un-Pivot)

Strong experience in creating dashboards, KPI’s and scorecards using gauges and charts for analysis using SSRS 2016/2014/2012/2008 R2 and SharePoint 2013

Experience in SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports

Created and deployed data driven, user specific and parametrized drilldown reports using SSRS, Tableau and SAP crystal reports

Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS)

Excellent Knowledge on architectures of Business intelligence tools MSBI, Pentaho, Tableau, SAP BI, Microsoft Power BI and Crystal Reports

Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2, XML and Flat file using Bulk Copy Program (BCP), Bulk Insert & Data Transformation Services (DTS) utility

Good Knowledge and Experience in building Multidimensional OLAP cubes and Info cubes in SQL Server

Extensive experience with Transact-SQL (DDL & DML) statements, Data Integrity (Constraints), Rules, and Validation issues

Proficient in Implementing & Developing RDBMS concepts such as Table, Stored Procedures, User Defined Functions, Indexes, Triggers, Nested Queries, Joins, Cursors, Views, CTE’s, Pivot, and Table Variables

Good knowledge in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks

Good knowledge of Data modeling, E/R diagrams, normalization and de-normalization and physical database schema design using CA Erwin data modeler as per business requirements

Good knowledge on creating Runbooks in Azure Automation

Good knowledge of Scheduling Jobs and Alerts using SQL Server Agent

Good experience working in both Inmon and Kimball methodologies

Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2016/2014/2012/2008 R2/2005

Worked extensively on system analysis, design, development, testing and implementation of projects SDLC (Software Development Life Cycle) and Agile Methodologies

Working experience in a Scrum team as a Scrum Master to facilitate the communication between Product Owner and other Scrum team members as well as ensuring sprints were accomplished in a timely manner

Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high-pressure environment

TECHNICAL SKILLS:

Operating Systems

Windows vista/XP/2003/Windows7/Windows 8, Unix

Tools & Packages

SQL Server Management Studio, Enterprise Manager, SQL Profiler, Index Tuning Wizard, SQL Server Data Tools, SQL Server DBA Dashboard, Toad for SQL, Data Quality Services(DQS), Master Data Services(MDS), Query Analyser

BI Tools

SSIS, SSAS, SSRS, Microsoft Power BI, Tableau 10.0, Pentaho Data Integration (Kettle), Excel 2010, Cognos 8.3/8.4, QlikView

Databases

MS SQL Server 2005/2008/2008R2/ 2012/2014/2016, Oracle 12c/10G/9i, Teradata

Developmental Skills

SQL, Transact SQL (T-SQL), PL/SQL

Programming Language

C, C#, HTML, XML, MDX

Application Packages

MS Office Suite, MS Outlook, Windows SharePoint 2010/2013

EDUCATION:

Vellore Institute of Technology (VIT), Bachelor of Technology Tamilnadu, India

Major: Computer Science and Engineering GPA: 3.5 May 2012

University of Bridgeport, Master of Science GPA: 3.8 Bridgeport, CT, USA

Major: Technology Management Minor: Database Management December 2016

PROFESSIONAL EXPERIENCE:

Client: Parallon Jul 2017 - Dec 2017

Location: Nashville, Tennessee

Role: SQL BI Developer

Responsibilities:

Involved in project planning, requirement gatherings, technical designs and documented functional requirements

Involved in complete Software development life cycle SDLC of the project

Designed, developed and managed SSIS packages for the extraction of data from different data sources like Oracle, CSV files, Flat Files and load them on to respective data marts

Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.,

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS). Designed various operational, drill-through, drill-down, sub reports and parameterized reports and developed these reports using the Global variables, Functions.

Delivered intuitive and innovative Data visualisations using Tableau and SSRS

Worked closely with the development and support to trouble shoot any technical issues on SSAS/SSIS/SSRS and Tableau dashboards

Designed the new DWH in Azure by creating the cubes with measures for analysis, decision making based on historical data

Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports

Maintained and Supported Microsoft Team Foundation Server (TFS) to allow for a secure code, SSIS Packages and reports

Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases

Developed MDX queries against SSAS Cubes to generate reports for analysis

Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and snapshotting via SharePoint User Interface

Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions

Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning

Have developed processes for the new Implementations, support activities and Change requests and to update the Business Process Management (BPM) document accordingly

Co-ordinated with project control teams and DBA for the Weekly production deployments and testing

Effectively worked with the team members, while handling change requests, issue tickets

Documented User-end manuals and provided user-end training for the ad-hoc analysis, SSRS and Tableau

Environment: Microsoft SQL Server 2016, SQL Server Integration Services SSIS 2016, SQL Server Reporting services SSRS 2016, SQL Server Analysis Services SSAS 2016, Tableau 10.4, Excel 2013, Windows 8, Oracle 12c, SQL server profiler, Visual Studio 2013, Share point 2013, PerformancePoint Services, TFS, Power BI, Tableau 10.2

Client: Silgan Plastics Jan 2017 - Jul 2017

Location: Chesterfield, MO

Role: SQL BI Developer

Responsibilities:

Designed and implemented the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems using SSIS.

Designed SSIS ETL packages to extract and load from different data sources including SQL Server, Flat Files, Excel Files, and XML Files etc

Developed packages using Control Flow Task like For Loop Container, for Each Loop Container, Sequence Container, Execute SQL Task and Data Flow Task to load the Data

Created deployment utilities to deploy the package using File System Deployment and SQL Server and Implemented Error handling using Event Handlers and Schedule the SSIS packages through SQL agent jobs

Designed and Developed Business Intelligence data model using SSAS and created Dimension and Fact table in Data Warehouse systems

Worked on Kimball methodology to develop data warehouse

Generated Ad-hoc reports and designed attractive report pages based on clients' request

Developed matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using SSRS

Created Matrix Reports with all aggregate functions and expressions, dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server

Developed T-SQL stored procedures, functions, Views and data load scripts for the product development team

Created reports in Power BI preview portal utilizing the SSAS Tabular and prepared dashboards using Tableau to make it more attractive

Followed agile development methodology for development and conducted Scrum meetings

Environment: MS SQL Server 2014, T-SQL, MS Excel 2013, SQL Server Management Studio (SSMS), Visual Studio, SQL Server Integration Services (SSIS 2014), T-SQL, PL/SQL, Query Analyzer, Tableau 10.0

Client: (m)PHASIZE Aug 2016 - Dec 2016

Location: Westport, Connecticut

Role: MSBI Developer

Responsibilities:

Installed SQL Server 2014 with the latest service packs

Migrated Database from SQL Server 2008R2 to 2014

Created tables, indexes and designing constraints

Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse

Worked with ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse

Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers

Enhanced and deploying the SSIS Packages from development server to production server

Wrote stored procedures for report generation in SQL Server 2014

Created Alerts for successful or unsuccessful completion of Scheduled Jobs

Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI

Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data

Developed custom visuals using Power BI based on user requirements

Administrated the created Reports by assigning permission to the valid user for executing the reports

Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache

Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2014

Created and Maintained Database Maintenance Plans

Environment: Microsoft Business Intelligence Studio, SQL Server 2014, SQL Server 2008R2, Oracle 11g, SSAS 2014, SSIS 2014, SSRS 2014, C#, Windows server 2008, Power BI, MS Excel 2010, SQL server profiler.

Company: Cognizant Technology Solutions Inc, Mar 2013 - Jul 2015

Client: CNA Insurance

Location: Bangalore, India

Role: SQL BI Developer

Responsibilities:

Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data

Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables

Designed ETL SSIS packages to process data to target databases

Develop the Documents for Logging/Error Handling for SSIS Packages

Developed Stored Procedures to support ETLs and Reporting

Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users

Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2012 as assigned

Wrote T-SQL for the retrieval of the data. Identified the Data Source and defining them to build the Data Source Views

Developed Query for generating drill down reports in SSRS 2012. Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts

Created insert and update script to fix data problem, created database objects like View, Stored Procedures, and Functions.

Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 20012 as assigned

Designed Enterprise reports using SQL Server Reporting Services (SSRS 2012) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.

Worked on build star schema and snowflake schema in Analysis Services (SSAS)

Environment: Microsoft Business Intelligence Studio, SQL Server 2012, SAS Enterprise studio, SSIS 2012, SSRS 2012, SSAS 2012, T-SQL, MS Excel 2010

Company: Cognizant Technology Solutions Inc, May 2012 – Feb 2013

Client: Prudential Financial Inc.

Location: Bangalore, India

Role: MSBI Developer

Responsibilities:

Actively involved in creating SSIS 2008 packages to transform data from OLTP database to respective data marts

Performed ETL capabilities on SSIS 2008 like develop new packages, configure packages, deployment of the packages from development to production, scheduling and debugging

Configured and maintained huge OLTP and OLAP databases

Querying and manipulating multidimensional cubes data through MDX Scripting

Migrated data from Oracle to SQL Server data warehouse and developed OLAP cubes using SSAS 2008 and make them available for the end-users and reporting services

Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL

Loading data from various sources like flat files, Oracle database, Access, mdb files to SQL Server database Using SSIS Package

Using SQL server reporting services (SSRS) delivered different types for all functional groups

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

Improved the performance of the ETL process and reports by tuning the SQL database, SSIS packages and SSAS cubes

Environment: Microsoft Business Intelligence Studio, SQL Server 2008, SAS Enterprise studio, SSIS 2008, SSRS 2008, SSAS 2008, T-SQL, Windows server 2008, MS Excel 2007, SQL Profiler, SQL Query Analyzer, Replication, Backup/ Recovery

Company: BlueBook Inc Nov 2011 – April 2012

Location: Hyderabad, India

Role: MSBI Intern

Responsibilities:

Worked on SQL Server 2008 Management Studio

Created multiple join statements to retrieve data from several tables and views

Developed complex T-SQL Queries and SQL Scripts for efficient data load, based on complex Business rules

Created several SSIS jobs and packages and executed tasks based on client requirements

Develop dynamic reporting solutions using SQL Server 2008 Reporting Services and validated them

Extensively worked on drill-down and drill-through reports and created Charts, Pie-Charts, Bar-graphs, series in SSRS

Worked on building Dashboards in SSRS

Experience working with Change Data Capture

Developed Income statement and other financial reports using SSRS

Worked Interactive sorting on reports

Extensively worked on expressions and filters

Deploying reports into SharePoint and involved in subscriptions

Experienced in troubleshooting and repairing SharePoint failures from the server side

Environment: MS SQL Server 2008, MS SQL Server Reporting Services 2008, T-SQL, PL/SQL, SSIS 2008, SharePoint.

Contact this candidate