We provide IT Staff Augmentation Services!

Mssql Bi Developer Resume

3.00/5 (Submit Your Rating)

Rockville, MD

SUMMARY

  • Microsoft SQL Developer / BI Developer/ Data Analyst with Over 6 years of experience at designing, analyzing, adapting, developing, implementing, testing, and maintaining database solutions through business Intelligence usingSQLServer 2014/2012/2008 R2/2008/2005,SQLServer Integration, Analysis, and Reporting Services (SSIS, SSAS, SSRS) including Power BI and Tableau.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types,effective functions,Cursors, and Indexes using T - SQL.
  • Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating ComplexStored Procedures, Triggers, User-defined Functions, CTE's Views and Cursors.
  • Strong experience in developing drill down, click through, parameterized, chart, matrix, Ad-Hoc, and sub reports using SSRS.
  • Proficient in various Extracting, Transforming, and Loading (ETL) tasks, using different transformations like Conditional Split, multicast, merge, union all, audit, Derived Column, look up, and slowly changing dimension to manage data.
  • Experienced increating Job, Alert and scheduling execution ofSSIS Package usingSQLServer Agent.
  • Experienced in creating stored procedure for generating reports usingSQLServer Reporting Services (SSRS).
  • Well versed in Normalization/ De-Normalization techniques for optimum performance in relational and dimensional database environments, and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
  • Good knowledge of Data Marts, Data warehouse,Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, OLTP Relational Schema and OLAP Dimensional Modeling.
  • Able to communicate effectively with multifunctional teams, programmers, and technical staff at all levels. Strong customer service orientation.
  • Experienced in consulting with users, resolving problems, and meeting specific technical and business needs.
  • Participated in requirements analysis reviews and Design sessions to understand the requirements and designing Reporting Solutions.
  • Committed team player with excellent communication skills and capable of working independently. Good problem-solving skills, initiative and judgment.
  • Good business understanding and effective at working across multiple teams within an organization.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2005/2008/R2/2012/2014, MS Access

Platforms: Windows XP/Vista/7/8, Windows 2003/2008/2012 server, Microsoft SQL Server 2016/2014/20012/2008/2005

Tools: MS Visual Studio 2008/2010/2012/2015 , SQLServer Business Intelligence Development Studio (BIDS), SSMS, SSIS, SSAS, SSRS, Tableau, Power BI, SQL Report Builder, SQL Query Analyzer, SQL Profiler.

Software: Microsoft Office 2003/2007/2010/2013 , Microsoft SQL Server

Programming Languages: T-SQL,C++, Visual Basic, Java, HTML

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

MSSQL BI Developer

Responsibilities:

  • Wrote stored procedures, triggers, and queries for creating reports from data marts, also worked with various report items like tables, matrices, indicators, images, and eventually formatted reports to export to Excel as well as to print.
  • Created SSIS packages to extract data from OLTP to OLAP systems.
  • Worked with different control flow items like Execute SQL, Execute package, Bulk Insert, send mail, and script tasks.
  • Extensively used conditional split, multicast, merge, merge join, union all, audit, Derived Column, lookup, copy column, row count in SSIS packages.
  • Responsible for creating SSIS packages to load data to dimension and fact tables inSQLServer data mart.
  • Created configuration files, enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS.
  • Created reports with drill down, drill through, cascading parameters, conditional formatting, interactive sorting, dynamic grouping functionalities and custom assembly.
  • Created multiple reports using Tableau and Power BI.
  • Developed different kinds of reports such asSub Reports,Charts,Matrix andLinked reports while using cascaded parameters to generate reports from two different Data Sets about potential risks and benefits of probable locations of new branches.
  • Responsible for resolving report defects in the dashboard application, and published reports to testing and production environments and facilitated the testing process.
  • Responsible for Data Modeling, created data models using Microsoft Visio, and objects like tables, views, indexes, user defined functions and triggers.
  • Performed daily tasks includingbackup and restore by usingSQLServer 2012 tools likeSQLServer Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.

Confidential, Atlanta, Georgia

SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Creating and modifying Business Intelligence analytical reports using Tableau.
  • Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends at various geographic locations.
  • Creating and managing schema objects such as tables, views, indexes, stored procedures and triggers and maintaining referential integrity.
  • Creating different types of user-defined functions using T-SQL.
  • Implementing error handling in SQL Server 2012.
  • Developing Tabular Reports using SSRS Report Designer.
  • Generating several types of drill down and drill through reports using SSRS
  • Designing and implementing parameterized and cascading-parameterized reports using SSRS.
  • Deploying reports, creating report schedules and subscriptions. Managing and securing reports using SSRS.
  • Migrating SSRS Reports from SQL Server 2008 to SQL Server 2012.
  • Building ad-hoc reports using SQL Server Reporting Services (SSRS).
  • Worked on Business Intelligence standardization to create database layers with user-friendly views in SQL that can be used for development of various Tableau reports/ dashboards.
  • ETL, data profiling, data quality and clean ups for SSIS packages.
  • Creating SSIS packages to populate data from various data sources.
  • Created SSIS packages to extract data from flat files, Excel files, Teradata, DB2, and OLE DB to SQL Server.
  • Configuring SSIS packages using Package Configuration Wizard to allow packages to run in different environments.
  • Worked with Metadata-Driven SSIS Packages to pull the data from different sources and loaded them to the DataMart.
  • Worked with project teams for upgrading SQL Server 2008 to SQL Server 2012.
  • Backing up, Restoring system and other databases as per requirements and scheduled those backups.

Confidential, Bloomington, IL

BI Developer/ Data Analyst

Responsibilities:

  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
  • Created packages using MSSQLServer Integration Services (SSIS) for dataextraction from Flat Files, Excel files, OLEDB source to data warehouse.
  • Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports inSQL Server Reporting Services 2008.
  • Scheduled the reports daily, weekly, monthly reports to run automatically and delivered them to the subscribed users.
  • Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
  • Worked with BCP utility and Bulk Insert to load data from different data sources toSQLServer.
  • Migration of existing data to CRM dynamics.

Confidential

SQL Server Developer

Responsibilities:

  • Performed code and tested activities for Business Intelligence project using the Microsoft suite of products, including SSIS, SSAS.
  • Designed and developed SSIS packages to move data from different environments within the organization.
  • Created and modified views and stored procedures according to technical specifications and business requirement.
  • Created configuration files in order to deploy packages in different environments.
  • Developed, maintained and executedSQLscripts/queries and validated completeness, integrity and accuracy of data.

We'd love your feedback!