Data Analyst Sales

Page * of *

SHABNAM KHAN

Portland Avenue ● Burnsville, MN 55337 ● 385-***-****

******.***@*****.***

QUALIFICATIONS

Excellent leadership and communication abilities

Project Management

Creating Dashboards & Visualizations

Data Warehousing, Mining & Analysis

Risk Management

PowerBI, Tableau

EDUCATION

May 2016

Masters of City and Metropolitan Planning (3.9/4)

Reid Ewing Medal for Smart Growth & Transportation 2016 University of Utah, UT

Graduate Project: Assessing Streetscape Improvements in Improving Place Quality: A Case Study of the North Temple Corridor in Salt Lake City, UT May 2013 Bachelor of Science in Environmental Science Magna cum laude

Asian University for Women, Chittagong, Bangladesh SKILLS

T-SQL, PL-SQL, R, Python, C++, PowerBI, Tableau, Tableau Prep, SPSS, SSIS, SikuliX, ArcGIS, Sketch-up

WORK EXPERIENCE

July 2019- July 2020

Dec 2017 – July 2019

CRM Data Analyst, C.H. Robinson, Eden Prairie, MN

Industry- Transportation Management Solutions, Logistics & Supply Chain Management

• Analyzed CRM Sales data from Dynamics 365 using Common Data Service (CDS) connector and prepared dashboards using PowerBI

• Imported, extracted, and transferred data from heterogeneous data sources throughout the organization to support operational BI reporting.

• Gathered specifications and transformation requirements for reporting needs

• Communicated data results and analysis to the business to the end users

• Collaborated with the Enterprise Data Warehouse team to access the enterprise data and other data marts

• Performed quality assurance testing of reports and dashboards and facilitated user acceptance testing (UAT) sessions. Ensured quality of the reports prior to releasing to production.

• Wrote T-SQL queries, functions, stored procedures to ingest data in PowerBI

• Heavily utilized DAX, and m-queries in dashboard creation

• Deployed and embedded PowerBI reports to the MS Dynamic 365 CRM platform

• Prepared KB articles fand analytical documents or end users for references BI Report Developer & System Analyst, Clinical and Translational Science Institute (CTSI) University of Minnesota, Minneapolis, MN

Industry- Health industry

• Design, develop, and deliver business intelligence report both at management level and department level

• Performed analysis on patient, billing and scheduling data

• Troubleshoot production or application issues with reports

• Collaborate with team members on designing fact, dimension tables in datawarehouse using Inmon’s techniques

Page 2 of 3

Mar 2017- June 2017

• Write PL-SQL Queries

• Serve as a resource for Tableau report users

Utilize SSIS, TableauPrep for ETL, & wrote custom code in C#

Evaluate Hortonworks Big Data solution

Write Hive NoSql or HQL queries and ingested data via sqoop

Write python script in MIT’s SikuliX automation tool to help automate tasks

Implement monitoring and email alerts for our critical data assets BI/Data Analyst, KFAI, Minneapolis, MN

Industry- Community Radio (Volunteer and Fundraising data)

Analyzed data from the Sales Force Cloud Environment

Wrote queries using T-SQL

Built Dashboards & Visualization on Radio hosts, Marketing, Fundraising, & Volunteer base data utilizing PowerBI, & Tableau

BI/Data Analyst, Mathnasium-The Math Learning Center, Eagan, MN Industry- Education Business (Scheduling, Sales and Budget data)

Acquired data from the Sales Force Cloud Environment

Interpreted data, analyzing results using statistical techniques

Wrote T-SQL queries

Built dashboard using PowerBI

Utilized SSIS for ETL, & C# as needed

Oct 2016- Feb 2017 Joint Town/County Planner, Town of Wheatland/Platte County, WY

• Administered land use regulations for the Town of Wheatland & Platte County

• Coordinated development review process for Zoning Changes, Subdivision plats, Annexations, Special Use Permits, Variances, Boundary Line Adjustment

• Built R prototype projects to analyze data points from ArcGIS Jul 2016- Sept 2016 Planning Intern, City of Spearfish, SD

• Reviewed and analyzed development requests

• Co-ordinated different types of agreements between the city and private property owner April 2015-May 2016 Graduate Research Assistant, University of Utah, UT

Principal Investigators: Reid Ewing and Brenda Scheer Project: National Institute of Transportation and Communities (NITC) project titled “How does transportation affordability vary between TODs, TADs, and other areas?”

Programmed in R to analyze data points

Researched C++ libraries, object oriented programming and software patterns as an alternative solution

Jan 2015-May 2015

Student Researcher, University of Utah, UT

Evaluated the Smart City concept on Transit Oriented Design in San Diego, CA that included

• Cluster Analysis using population and employment data for traffic analysis zones (TAZ)

• Preformed Propensity Score Matching using household data

Performed T-test to analyze differences in travel behavior of the station areas Aug 2014 – May 2015

Teaching Assistant, University of Utah, UT

• Assisted faculty member with classroom instruction, record keeping, grading essays and provide student feedback

Page 3 of 3

Jun 2013- Jul 2014 English Language Testing Instructor, Innovative English Learning Center (IELC) Chittagong, Bangladesh

• Prepared lessons, teach reading, speaking, listening skills for IELTS test Jun 2012-Aug 2012 IT Intern, Clifford Chance, OSC, Delhi, India

• Reviewed about Library Services, Invoice Processing and Value Stream Mapping Identified critical issues in their contract with a software company Jun 2011 –Aug 2011 Safety and Health Intern, Group Four Securities (P) Ltd, Dhaka, Bangladesh

• Developed labor laws, health, safety & environment protocols ACCOMPLISHMENTS

Mar 2017 – Dec 2018

PUBLICATIONS

Co Host, Data Podcast, Greater Minneapolis-St. Paul Area, MN Educating and inspiring our listeners to be in touch with the cutting edge technologies Exploring nooks and corners of the dynamic Big Data, Data Science world Networking with experts in Software Engineering, Machine Learning (ML), & Artificial Intelligence (AI) fields

Follow us on https://soundcloud.com/data-podcast

Subscribe on https://itunes.apple.com/us/podcast/data-podcast/id1247751397 National Institute for Transportation and Communities (NITC) 1. How Does Transportation Affordability Vary Among TODs, TADs, and Other Areas? 2. Active and Public Transportation Connectivity between North Temple TOD and Jordan Park River Trail

COMMUNITY SERVICE Green Urban Lunchbox Salt Lake City, UT, at the University of Utah Environmental Action Team (EAT) for the Bennion Center on campus CERTIFICATIONS Issuing Org: SQLBI; Mastering DAX, Introduction to Data Modeling, Introduction to DAX

Contact this candidate