Debanjan Majumdar

Debanjan Majumdar

• 425-698-7321 • debanjan.majumdar@bellevuecollege.edu

SQL Business Intelligence Developer / Data Analyst: Technical Skills & Competencies
Recent graduate from Bellevue College with a degree and certificate in Information Systems with specialization in Microsoft Business Intelligence (SQL Server, SSAS / OLAP Cubes / KPI’s, SSRS, SSIS / ETL, C#, Excel Pivot Table, Data Modeling, T-SQL, Data warehousing, Data Mining)
Experience in customer service, account management, client relations management, and technical support roles in retail and call center environments
Demonstrates critical thinking, problem solving / troubleshooting, & analytical skills

Multidimensional databases – Data warehouse, OLAP Cubes
OLAP, Reporting & Data Migration Tool – Microsoft SSAS , SSRS, SSIS
Data Mining / Analytics – SSAS component
Data Visualization / Dashboards  – SSRS, MS Excel Pivot Table, Tableau 8.1
Data Modeling –Dimensional Modeling, Entity Relationship (ER)
Relational Databases – OLTP
Query & Database Design – SQL Server Management Studio (SSMS)
Data warehousing / BI Solution  – Microsoft Visual Studio & SQL Server 2012
Business Statistics – Excel Data Analysis component
Database programming – T-SQL
Database Tuning – SQL Server Database Tuning Advisor & Query Execution Plan
NET framework  – ASP.NET, ADO.NET
Web Development  – HTML, CSS, JavaScript (Client-side); ASP.NET (Server side)
Object Oriented Programming – C#
.Microsoft Office – Word, Excel (VLookups & Macros), Visio, PowerPoint, Access

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

§  SQL Server Reporting Services (SSRS for Data Visualization) – Created parameterized SSRS Reports; utilized SSRS components  including tables, matrix, lists, images, sub reports, charts, and indicators

§  SQL Server Integration Services (SSIS) – Designed SSIS / ETL packages using elements under ‘Control Flow Task’  and  ‘Data Flow Task’ components including ‘Execute SQL Task’, ‘File System’ task and ‘Script Task’,  ‘Conditional Split’, ‘Data Conversion,’ ‘Lookup’, ‘Merge Join’, ‘Sort’, ‘Union All’, source and destination adapters such as Excel, Flat File, OLEDB and connection  managers; analyzed patterns, statistics and inconsistencies in SQL Server database table with SQL Server Data Profile Viewer; utilized ‘Script Component’ and REGEX for input row validation and transformation; created and executed Transact-SQL ETL script and package for loading data warehouse

§  Dimensional Modeling – Modeled Enterprise Data warehouse (EDW) 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) – Designed databases and solved problems with T-SQL programming (DDL, DML, Views, Stored procedures, Functions, Triggers, Cursors, & Indexes within SQL Server); performed database tuning using tools including ‘Database Engine Tuning Advisor (DETA)’ and SQL Server ‘Query Execution plan

§  Web Development using Microsoft .NET framework – Created an ASP.NET web application with linked pages using web forms and master page that accessed SQL Server database using ADO.NET classes; displayed and manipulated data from the application code using C# and ASP.NET front-end control objects such as Repeaters and Data Lists.

§  Web Development – Created an interactive dice game using HTML,  CSS & JavaScript

§  C# – Created simple console based applications that accepted and validated user inputs; performed mathematical computations and displayed results to the user; utilized variables, functions, ‘switch case’, ‘while’ & ‘for’ loops, properties and methods of objects; created and accessed data from a two dimensional array

§  Excel – Analyzed pivot tables with data imported from SSAS Cubes

§  Tableau 8.1 – Created and analyzed Reports & Dashboards with relational and multidimensional database data sources

§  Relational Data Modeling – Worked on small business projects and created data models that fit the business requirements based on normalized data structures

Education & Honors:

§  A.A. Information Systems, Bellevue College (06/2013 – Present)

G.P.A. 3.9

§  Business Intelligence Developer Certificate, Bellevue College (June 2015)

§  B.A. Business Administration, Seattle Pacific University June (2006, GPA 3.1)

Recipient of Wellspring General Scholarship & Dean’s list at Seattle Pacific University

Work Experience:

ACS Xerox                                                                                                                                                         Federal Way, WA

Customer Care Representative                                                                                                        July 2012 – October 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

§  Achieved 80 – 100% Resolution on after-call customer surveys on a daily or weekly basis

Office Depot                                                                                                                                                              Bellevue, WA

Customer Service Specialist                                                                                                              August 2010 – June 2011

Role – POS Retail Sales Support

§  Awarded with ‘Employee of the Month’ recognition for high volume ‘rewards’ membership enrollment

§  Achieved daily sales goals and sold add-on ‘product protection plan’ services in $5 – $40 range in addition to the product cost on printers and routers

Ekaria (VOLT)                                                                                                                                              Redmond, WA

Operations Specialist                                                                                                            October 2006 – December 2006

Role – Account Management

§  Provided back-end customer support for American Express B2C clients

§  Resolved issues with American Express (AMEX) credit card transactions on client accounts at a  rate of 80 – 120 / day

Saul & Dayes G. Haas Foundation                                                                                                                           Seattle, WA

Marketing Intern                                                                                                                                          April 2006 – September 2006

Role – Executive Support

§  Acted as a Point-Of-Contact for the Foundation’s speaking engagements at local Rotary clubs

§  Successfully coordinated and scheduled 8 – 12 Rotary events a month