Sign in

Sql Server Business Intelligence Developer -SSRS, SSIS, SSAS, Power BI

Bellevue, Washington, United States
October 23, 2016

Contact this candidate


Debanjan Majumdar

425-***-**** •

SQL Business Intelligence Developer: Technical Skills & Competencies

Experienced SQL BI Developer with skill sets in the areas of SQL Server, Data warehousing, Integration Services, Analysis Services, Reporting Services & .NET; has a degree in Business Administration with Finance concentration; able to implement business rules / requirements using SQL Server and SSDT-BI

Work Experience Summary: SQL Developer, Customer Service & Technical Support

Experience testing in UAT/DEV/PROD environments, database migration (on-premises to cloud); customer service, and technical support roles in retail and call center environments; Demonstrates critical thinking, problem solving / troubleshooting, & analytical skills;

Skill Sets & Tools Proficiency

RDBMS – SQL Server, Database Backup & Restore using T-SQL script & SSMS

Multi-dimensional databases – OLAP Cubes, Backup & Restore using XMLA script

OLAP, Reporting & ETL Tool - SSAS, SSRS, SSIS

Database programming – T-SQL; Aggregate and RANK functions; Bulk Insert

Database Tuning – SQL Server Database Tuning Advisor & Materialized Views

MS Office – MS Outlook email, calendar, scheduling & Skype for Business

Data Visualization / Dashboards – Power BI, SSRS, Report Builder, MS Excel Pivot Table, Tableau 8.1

.NET – C#, ASP.NET, ADO.NET, HTML5, CSS, Javascript

Data Modeling – Dimensional Modeling, Data warehouse, Entity Relationship (ER) Modeling, OLTP database; MS-Visio

Query & Database Design – SQL Server Management Studio (SSMS)

Data warehousing / BI Solution - Microsoft Visual Studio 2012 / 2013 & SQL Server 2012, 2014

Object Oriented Programming - C#

Collaboration – SharePoint for Excel, Bitbucket / Sourcetree

Work Experience:

Beyondsoft Consulting Redmond, WA

Associate, Data & Application Development May 2016 – Sept 2016

Role – SQL Server Developer

Gates Project – Created a SPROC that copies data from source to destination that was deployed in production server as a SQL Agent job step

Tested for data consistencies across the Staging, dbo and Star schema tables using SQL

Performed UAT testing (meta data consistency between upstream Microsoft UAT & Beyonsoft UAT servers using SQL); tested, executed and deployed SSIS packages successfully to DEV & PROD servers; tested and debugged SQL Agent jobs

Microsoft Learning Project (MSL) - Utilized data modeling and SQL to examine Entity relationships

Contributed toward migrating enterprise database from (legacy Feedstore to DataMall); ran API queries to pull tables from the cloud source

Performed data consistency checks after code changes in SQL Server and client side SharePoint Excel pivot tables; utilized VLOOKUP and CountIF functions in Excel

Performed updates on Windows 2012 server and VM’s

Utilized Bitbucket / sourcetree & Jira to create and track progress of tasks and issues

Documented code changes on bitbucket and SQL Server & also contributed to internal online knowledgebase on Confluence

Omni212 Redmond, WA

SQL BI Instructor Jan 2016 – May 2016

Role – SQL Server Business Intelligence Instructor

Provided training to students in Databases, SQL Server, T-SQL, SSIS, SSAS, and SSRS

Performed Software & Database Installations (SQL Server 2012/2014/2016), Visual Studio 2015 (Professional, Enterprise, Express), SSDT for Visual Studio 2015

Omni212 Redmond, WA

SQL BI Technical Support Oct 2015 – Jan 2016

Role – SQL Server / BI Software Installation Support

Attended in-house training sessions in SQL BI modules: T-SQL, SSIS, SSAS, and SSRS

Performed Software & Database Installations (SQL Server 2012/2014/2016), Visual Studio 2015 (Professional, Enterprise, Express), SSDT for Visual Studio 2015

ACS Xerox Federal Way, WA

Customer Care Representative July 2012 - Oct 2012

Role – Client Relations Management / Technical Support

Recommended Calling, Text Messaging, and Data Plans for Verizon Wireless smart phone users that saved $20 - $60 monthly per customer

Accomplished 485 seconds AHT (Average Handle Time) per customer call-in

Academic Project Experience:

Multidimensional Analysis using SSAS – Designed and developed OLAP Cubes and deployed to SQL Server Analysis (SSAS) server; created Calculated members, KPI's, Actions, Partitions and Perspectives; queried SSAS Cube using MDX language; utilized OLEDB and ADO.NET providers; developed SSAS Tabular models using DAX; deployed OLAP Cubes to Analysis Services Server in Visual Studio 2012 & 2013 environments

SQL Server Reporting Services (SSRS for Data Visualization) - Created single and multi-valued parameterized Reports; utilized components including tables, matrix, lists, images, sub reports, charts, indicators, maps, spatial data, and sparklines; deployed reports to Report Server; experience working with Report Manager and Report Builder 3.0

SQL Server Integration Services (SSIS) – Migrated data from text / csv / excel files to SQL Server; utilized various sequential and data transformation tools to logically sequence tasks and modify source data; created T-SQL ETL script and designed package for loading a data warehouse; worked with data access connection providers such as Microsoft Jet OLE DB 4.0 & Microsoft.ACE.OLEDB.12.0; utilized Checkpoints; Logging; Parameterized Connection strings & Environment variables; deployed packages to SQL Server 2012/2014

Dimensional Modeling - Created Enterprise Data warehouse (EDW) models business processes using Conformed dimensions, Transaction / Periodic / Accumulated Snapshot fact tables, Slowly Changing Dimensions (SCD) & Factless fact tables, Star & Snowflake schemas using Kimball dimensional modeling principles

Relational Database Programming (Transact-SQL) – Researched design and implementation of databases up to 3rd Normal form; utilized T-SQL (DDL, DML, Functions, Triggers, and Cursors within SQL Server); performed database tuning using tools including ‘Database Engine Tuning Advisor (DETA)’ and optimized queries using Views, Stored Procedures, Materialized Views and Update Statistics

Education & Honors:

Bellevue College Bellevue, WA

Associate in Applied Science Information Systems Degree / June 2013 - June 2015

Certificate of Achievement, Business Intelligence Developer

G.P.A. 3.89 with “High Distinction”

Phi Theta Kappa Honor Society member (June 2015)

Seattle Pacific University Seattle, WA

Bachelor of Arts, Business Administration (Finance concentration) Sept 2001 - June 2006

G.P.A. 3.06

Recipient of Wellspring General Scholarship & Dean's list (Spring 2003 & Winter 2004)

Contact this candidate