Muhammad Haris Khan

1-914-***-**** adizw5@r.postjobfree.com www.linkedin.com/in/mhariskh/

AUG 2020

DEC 2018-

AUG 2019

OCT 2013-

JAN 2015

Education & Experience

B.S in Technological Systems Management(Specialization in Computer Science) STONY BROOK UNIVERSITY, STONY BROOK, NY

Object Oriented Programming Data Structures Web Development Probability and Statistics Design Innovation Applications Software Project Management Agile Development Management for Engineers Business Intelligence Engineer-Intern

KSUC SUPPLIES LLC, SYOSSET, NY

• Designed data models by translating business needs for supporting long-term solutions.

• Developed ETL(extract, transform and load) processes in SSIS (SQL server integration - services) packages for data wrangling using MSBI tools in Visual Studio.

• Worked on various sources, destinations and transformations in SSIS using API’s and multiple components.

• Developed OLAP(online analytical processing) solutions using SSAS.

• Created reports using SSRS and presented them to the stakeholder’s that helped them to make decisions, that drove up the product sales by 15%. Junior Database Developer

SAFAVIEH LLC, HARTSDALE, NY

• Designed and developed database-centric solutions within a distributed team of T-SQL and .NET developers based on the business requirments in Microsoft SQL Server.

• Designed databases using normalization systematic approach (1NF,2NF,3NF,4NF) to reduce data redundancy and ensuring that the data is stored logically.

• Wrote complex queries for ad-hoc requests and data analysis, developing store procedures, views, triggers, and functions across varied platforms.

• Wrote multiple scripts using CRUD functionality(create, read, update, delete) to keep the database up to date.

• Maintained the integrity of the database by reading complex queries, troubleshooting failing queries, spotting queries that may return wrong results.

• Assisted with system support, customization, and database administration of all enterprise applications (ERP, CRM and WMS) providing cross-functional team support. Skills

JAVA C++ Java Script

HTML CSS Postgres SQL

T-SQL VBA MATLAB

Visual Studio (ETL) Jira

Honors & Awards

Academic Excellence

Phi Theta Kappa (Honors Society)

Model United Nations (MUN)

3 Position (Representing Austria)

Organizations

Founder and President

Pakistani Students Association

Stony Brook University

Founder and President

Music Society

Beaconhouse School

Public Relations

Stony Brook Cricket Club

Stony Brook University

Projects

LIRR Train Managing Application in Java - Data Structures

• Developed a train managing application for the MTA to manage their LIRR division.

• The application would be used for adding, removing, and scheduling trains on tracks.

• Developed multiple classes, methods, sorting algorithm and API’s to create an interface using LinkedList that would interact with all the trains in the same station. Decision Support System and User Forms in Excel - Group Project

• Designed and developed the DSS model and user forms(VBA) for Hawk Airways.

• The DSS was implemented using sum, product, average and VLOOKUP functions.

• The user forms were programmed using VBA that took inputs from the users and provide them with flight timings, ticket pricing and booking status. Work Authorization

US Citizen

Contact this candidate