Nandhan

Certified SQL BI Developer (SSIS/SSRS/SSAS)

Summary:

7+ Years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R2/2008/2005 in Development, Test and Production Environments on various business domains like Financial, Insurance and manufacturing.

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

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

Developing reports on SSRS on SQL Server (2012/2008/2008 R2/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Experience in SQL Server 2012 Self Service BI tools like Powerview, BISM Tabular models and SQL Server Data tools.

Strong experience in creating dashboards using gauges and charts for analysis using SSRS 2008 R2.

Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).

Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio

Involved in developing reports from SSAS cubes using client tools like SSRS 2008, Excel 2007 and Report Builder.

Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.

Worked Extensively on ETL process using SSIS package.

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

Experience in Performance Tuning and Query Optimization.

Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.

Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.

Experience in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.

Experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

Technical Skills:

SQL Server Tools

SSDT, SSMS, BIDS, Report Builder, DTS, Profiler, DTA, Upgrade Advisor

Monitoring & compliance Tools

LiteSpeed, Spotlight, SCOM, SQL secure

ETL & Reporting Tools

SSIS, SSRS, SSAS, Excel 2013, Power View, PowerPivot, PPS, Tableau

Databases

SQLServer 2014/2012/2008R2/2008/2005/2000, Oracle 9i,10g,11g,Teradata,SAP

Programming Languages

SQL,T-SQL,PL/SQL,C,C++,JAVA,C#,VB

Operating System

Windows 95/98,NT,Windows XP/2003/2000,Unix,MS-DOS

Web technologies

Angular Js,HTML, XML, VBScript, SharePoint 2010,C#,ASP.NET,VB.NET

Tools

ERwin, VS 2008/2005,Visio,TFS,Visual Source Safe, Sub Version

Professional Experience:

CVS Health - Woonsocket,RI Sep 2014 – Till Date SQL BI Developer (SSIS/SSRS/SSAS) Responsibilities:

Design and develop Business Intelligence solutions using MSBI tools (SSIS, SSRS, SSAS).

Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers.

Write and debug T-SQL Queries, SSRS Reports, SSIS Packages and Stored Procedures.

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Created SSIS packages to capture the Incremental changes for the Data warehouse.

Designed and developed SSIS packages to load data from Flat files, Excel to Data warehouse using C#.NET.

Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle database,DB2 and Teradata database, Excel, Flat files into the SQL 2012 Server target staging database.

Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.

Extensively worked in the performance tuning of programs, ETL procedures and processes.

Developed Dashboards, Gauges, Tabular, Matrix, Charts,Crystal reports Parameterized and Sub-reports in SSRS 2012/2008 R2.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Developed various operational Drill-through and Drill-down reports using SSRS.

Using SSRS creating well-formed reports and web-based reports for health related applications and transactions.

Supported, modified and maintained Crystal Report currently in the production environment.

Developed complex formulas in Crystal Report for reporting calculations and metrics.

Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Involved in performance tuning the slow running reports and stored procedures by creating appropriate indexes and analyzing execution plans.

Created data-driven subscriptions in SSRS using windows file share as well as Email subscriptions

Used complex queries and Stored Procedures for generating real-time operational SSRS reports.

Used Excel Pivot tables to manipulate data in order to perform data analysis.

Used angular js framework and integrated with Sql Server DB.

Developed reports with cascaded parameters from SSAS Cubes using MDX queries and Calculated Members.

Developed SSAS Cubes using Star Schema with partitions, aggregations, hierarchies and perspectives.

Developed SSRS and Excel Power pivot table based on OLAP Cubes.

Used Subversion (SVN) for source control, to deploy the code from Dev to QA, QA to Prod.

By using ADO.NET Extracted data From database.

Working on LINQ for query the data objects in C#,VB.net.

Responsible for Servers in Sharepoint. Installed and configured SharePoint2010, maintenance of Web Front End Servers, Indexing Servers, and maintaining Database servers.

Participated in Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Participated in SQL Server 2014 installation, Violin Flash Memory and POC on new features.

Troubleshoot and resolve issues reported by business users.

Develop and direct software system testing and validation procedures, programming, and documentation.

Used Team Foundation Server (TFS) for central repository as a versioning control.

Environment: SQL Server 2014/2012/2008 R2/2008, Oracle 11g,Teradata, SAP, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, SQL Server BIDS,Tabular,Excel 2013, Power view, TFS,Power pivot, Performance Point, MDX, Tableau, Report Builder 3.0,Crystal Report 8.0, DTS, C#, VB.NET,JSON, Erwin 4.0,XML, Violin Flash Memory, Windows Server 2008,.NET 3.5

T.G Mercer - Dallas,TX Apr 2013 –Aug 2014 SSIS/SSRS/SSAS Developer

Responsibilities:

Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed UNIX Shell scripts to automate table creation, execute procedures.

Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.

Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.

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

Worked on different kinds of Transformations in SSIS like Slowly changing dimension (SCD’s), Lookup, Merge, Derived column, Multicast, Conditional split, Aggregate, Fuzzy lookup, Pivot and UnPivot as per the client requirement.

Created Configuration Files for Packages and SSIS logging on XML Files.

Developed different kind of reports such a Dashboards,Sub Reports, Charts, Matrix reports,Crystal reports Linked reports Using SSRS.

Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2008R2.

Scheduled SSRS 2012 Data alerts on mission critical reports to send alerts based on business rules.

Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.

Participated in the design and development of the Data Warehouse using Star Schema and Snowflake Schema.

Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspectives using SSAS 2008 R2.

Setup and monitored jobs for loading and processing SSAS Cubes.

Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.

Created ETL technical specification documents describing ETL design and load strategies to populate operational data store and datamarts.

Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.

Used SSRS reports with parameters from PerformancePoint Services deployed in SharePoint 2013.

Participated in code-review sessions on existing SSRS report’s performance and Dataset query tuning.

Designed and created Crystal Reports based on technical specifications provided.

Developed MDX queries for SSRS reports from SSAS Cubes.

Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.

Developed powerview reports using Tabular Models in SQL Server Data Tools.

Installed SQL 2012, TFS 2012. Migrated all the scripts and objects from SQL 2008 to SQL 2012

Created standard and data driven subscriptions for weekly, monthly and daily reports.

Involved in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Environment: SQL Server 2014/2012/2008 R2/2008, Teradata,SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, BIDS,Tabular,Excel 2013,XL-Cubed, Power view,TFS, Power pivot, Performance Point, MDX, Report Builder 3.0,Crystal Report 8.0, DTS, C#, VB.NET, Erwin 4.0,XML, SVN, Rally, Windows Server 2008,.NET 3.5.

Emigrant Savings Bank – New York City, NY Jan 2012 – Mar 2013 SQL Server Developer /BI

Responsibilities:

Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.

Created SQL server Reports using SSRS. Identified the data source and defined them to build the data source views.

Created SSIS packages to capture the Incremental changes for the Data warehouse.

Built SSIS packages to process Cubes, Dimensions and partitions.

Created and managed SQL Server login, database users and Roles.

Involved in Data modeling to develop the database design using Erwin 4.0.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Involved in designing Flow charts, office layout for the business users and professionals using VISIO.

Created SQL reports, data extraction and data loading scripts for different databases and schemas.

Wrote Transact SQL utilities to generate table insert and update statements.

Assisted in designing and creating website for the system using ASP.NET, HTML, and CSS.

Participated in different testing and debugging for the system.

Environment:SQL Server 2008 R2/2008/2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), Windows 2000/XP, ASP.NET, ProClarity, SSAS, SharePoint services, Erwin.

SP Soft Private Limited - India Mar 2009 – Dec 2011

SQL Server Developer / DBA

Responsibilities:

Involved in Physical / Logical design of database, creating and managing the database and all the database objects.

Created ER diagrams (physical and logical using Erwin) and mapping the data into database objects.

Worked with Implementation team and closely moved with end users to implement manufacturing solutions.

Worked with various SSIS packages which involve Transactions, Restart ability and roll back techniques

Worked closely with developers, end users and Administrators in designing and creating databases and other objects.

Actively involved in designing databases for the system.

Created new tables, written stored procedures for Application Developers and some user defined functions.

Created SQL scripts for tuning and scheduling.

Performed data conversions from flat files into a normalized database structure.

Created Triggers to enforce data and referential integrity.

Configured Server for sending automatic mails to the respective people when a DTS process failure or success.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Creation/ Maintenance of Indexes for fast and efficient reporting process.

Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights.

Environment: SQL Server 2000, OLAP Services, T-SQL, Windows 2000 Server, Query Analyzer, DTS,MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler.

Virtusa Private Limited - India Aug 2007 – Feb 2009

SQL Developer/ DBA

Responsibilities:

Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.

Develop and support reports built with Microsoft Reporting Services on SQL 2005 SSRS.

Migrated access objects to SQL Server 2005.

Created tables, indexes and constraints.

Created Indexes, Views, Triggers, Stored Procedures in T-SQL and DTS Packages.

Wrote database triggers in T-SQL to check the referential integrity of the database.

Defined stored procedures for module integrity and application.

Involved in performance tuning of the database and T-SQL queries using Explain Plan.

Designed and implemented several complex reports.

Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.

Preparation of project documentation.

Environment: SQL server 2005, SSRS, SSIS, Visual Basic 5.0, Win NT, Crystal Reports 8.0.

Education:

Bachelors in Computer Science and Engineering, JNTU-India.

Contact this candidate