SUMMARY

• Highly motivated SQL Server/BI Developer with Around 5+ Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2014/2012/2008 , SSRS and SSIS.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Experience in debugging the SSIS packages using breakpoints and checkpoints.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SSRS and Tableau.
• Strong experience in developing parameterized, Sub Reports, Matrix Reports, Charts, Drill down, Drill Through reports, using SQL Server Reporting Services (SSRS) and Tableau.
• Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar Graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and Global filters according to the end user requirement.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

TECHNICAL SKILLS

Operating Systems: Windows2010, 2008, 2007, Server, Windows NT, Unix.

RDBMS: MSSQL SERVER 2016/ 2014/2012/2008 R2

BI TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL, Tableau, Self BI with Excel, Power BI.

Languages: C, Java, T-SQL, Dynamic SQL.

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2013/2015/2017 , SQL Profiler, DQS.

PROFESSIONAL EXPERIENCE

Confidential, Indiana

SQL MSBI Developer

Responsibilities:

• Interacted with a team of business analysts, data architects, application developers and testers. Created SSIS packages to extract data from various sources including SQL Server, Excel, Flat file, CSV, transformed the data and loaded into the target data warehouse.
• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used MS Visual Studio to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Loaded data from ODS to data warehouse using SSIS packages.
• Used Tableau Desktop to design interactive reports and data visualization.
• Developed Tableau reports and dashboards from multiple data sources using data blending.
• Used multi-dimensional models such as star schemas and snowflake schema for developing cubes.
• Designed and developed matrix, tabular and parametric reports using SSRS 2016.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.
• Wrote new stored procedures for new system and optimized old store procedures and functions on production server. Improved data load performance by analyzing database design and query plans.
• Modified and created joins to improve the database and execution speed.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Expert in data visualization using Tableau to create complex, intuitive and innovative dashboards.
• Involved in performance tuning using SQL Server Profiler and SQL server hints.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source and Excel spreadsheet to SQL Server 2016.
• Designed ETL packages dealing with different data sources (SQL Server, flat files, and XMLs, etc.) and loaded the data into target data sources by performing various kinds of transformations using SSIS.
• Created Complex ETL Packages using SSIS which upsets data from staging table to database tables.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Microsoft SQL Server SSRS, SSAS, SSIS 2016/ 2012, T-SQL, MySQL, PL/SQL, MS Visio 2008, SharePoint 2010, Tableau, Windows Server, Power Map, Power Pivot, Power View, MS Office, Microsoft Visual Studio 2008, Reports Builder.

Confidential, OH

MSBI (SSIS, SSRS, SSAS)/ Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Interacted with a team of business analysts, data architects, application developers and testers. Created SSIS packages to extract data from various sources including SQL Server, Excel, Flat file, CSV, transformed the data and loaded into the target data warehouse.
• Working with different business users to adopt the data visualization - Tableau in the Organization and get insights from the data.
• Experience in creating SQL data models/Queries for Tableau and Ad-hoc Reports.
• Develop Tableau reports & effective dashboards after gathering and translating end user requirements.
• Experience in writing stored procedures and functions on numerous SQL server.
• Extensively used different transformations i.e., looping, data formatting, check points, error handling, email notification in SSIS packages.
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2014.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups and Implemented Event Handlers and Error Handling in SSIS packages.
• Responsible for building reports in Tableau from the Scratch.
• Responsible for creating and changing the visualizations in Tableau reports and Dashboards on client requests.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Tableau and generate reports with different visualizations.
• Created reports by using Joins in multiple tables from multiples database using complex SQL queries.
• Design and development of SSAS Tabular cubes to satisfy the end user reports by creating different types of Reports and Dashboards in Tableau.
• Worked on Identifying the slow running ad-hoc reports and came up with the performance improvements.

Environment: MS Visual Studio 2015, SSAS (Tabular), SQL Server Management Studio2016, SQL Server Reporting Services (SSRS), Tableau, SQL Server Integration Services (SSIS), MS SharePoint, GIT Hub.

Confidential, MI

SQL Server/SSIS/SSAS/SSRS

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Installed and configured SQL Server 2008 and 2008 R2 Enterprise Edition Environment.
• Designed, Developed and tested packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Developed advanced ETL import packages using SSIS, T-SQL to transform and import raw index data into database tables.
• Developed SSIS packages to Migrate data to staging server and then to production server.
• Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system through SSIS packages and custom procedures.
• Created various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Tableau.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS and Tableau.
• Added new facts and dimensions to the data warehouse.
• Reviewed cube changes and documented according to the requirement based on product valuation and revenue opportunities.
• Developed cubes by defining data sources and data source views and using SQL Server Analysis Services (SSAS).
• Worked in cooperation with other teams and business analysts for achievement of efficient database access and for processing applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL scripts to application development teams.

Environment: MS Visual Studio 2012, SQL Server Management Studio, SSRS, Tableau, SSAS(Tabular), SQL Server Integration Services (SSIS), AZURE, MS SharePoint, IIS 7.5/7.0/6.0, Visual Source Safe (VSS), Team Foundation Server (TFS), GIT Hub.

Confidential

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Perform database development that includes Schema development, Stored Procedures that could be used by different Windows Services.
• Used SSIS variables, parameters, & expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Lookup, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging, and Development.
• Creation of ETL packages to load data from files into database by performing different kinds of transformations using SSIS
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Involved in development & amp; Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Creating SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Extensive reporting skills using SQL Server Reporting (SSRS).
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Worked on TFS for performing tasks.

Environment: Windows Server 2012 Operating System, MS SQL Server 2012, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, MS Visio, MS Excel 2010

Confidential

SQL Server Developer

Responsibilities:

• Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving. Multiple tables & calculations from different databases.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Used various SSIS tasks such as Conditional Split, Script Component Task, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data Warehouse.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Used Bulking techniques, Table partitioning to increase database performance.
• Consistently worked and communicated with CMS (Center for Medicare & Medicaid) to ensure data received met the company expectations.
• Wrote complex expressions and calculations for SSRS reports with Conditional Formatting.
• Responsible for the design and deployment of the report using SSRS and MS Excel.
• Created Ad Hoc reports by building models in Report Builder using SQL 2008 Model Designer and Report Builder.

Environment: SQL Server 2008, Oracle 10g, T-SQL, BIDS, SSRS, SSIS, SSAS, Crystal Reports, MS Excel, Erwin, SharePoint.