Data Analyst - Engineering Graduate - Analytics & Visualization

To build a prosperous new career and exploit my excellent analytical, mathematical skill to gathering data from various source and transforming it into insightful reports and dashboards. Passionate about data analytics with a degree in Engineering. Seeking opportunities where I can utilize my analytical, mathematical and technical skills to solve real life problems related to analyzing a datasets to draw insights that can help with business decisions. I want to be an active part of this growing industry by putting my knowledge into other people’s service.

\EDUCATIONAL MERITS

Bachelors of Engineering, NED University and Technology

TECHNICAL EXPERTISES

Programming

Python,SQL

Visualization

Power BI,Tableau, Jupyterbook

Database

MySQL

Soft Skills

Excellent verbal and written communication skills

CERTIFICATIONS

SQL: Data Reporting and Analysis

Power BI – Data Analytics Essentials with Power BI from Udemy

Data Visualization using Tableau from Udemy

Website

https://mjahan11.github.io/jahanAnalyst.github.io/

portfolio project:

Pizza Place Analysis Report:

Downloaded Pizza Place restaurant data from Maven Analytics website for more than 48,000 records.

Analyzing a dataset related to pizza places in Power BI can provide insights into various aspects of the pizza industry, including popular toppings, customer preferences, and geographical distribution.

Import Pizza Place restaurant dataset into Power BI and performed ETL to clean up bad records.

For analysis of Pizza Place restaurants, I have used Power BI to create the calculated measure and calculated column. Use a card or KPI visualization to display the total number of customers, total sales, total order etc in the dataset.

Used Power BI to build various BI dashboards that can show customers per days and month.

Analyze the time of day or day of the week with the highest order frequencies using line charts.

Airbnb Dataset Analysis:

The dataset, downloaded from the Data World website, spans from 2008 to 2012, encompassing information from five major cities in New York.

The primary objectives of this project include understanding pricing dynamics, identifying key features influencing booking rates, and visualizing geographic trends in Airbnb listings.

The analysis involved data cleaning, exploratory data analysis (EDA), and the creation of interactive visualizations using Power BI.

Key findings:

Understanding the connection between pricing and specific Neighborhoods.

Investigating how the region influences the availability of beds in Airbnb listings.

Exploring how the geographic location within New York correlates with Airbnb listing ratings.

Twitter Dataset Analysis:

This project presents a Twitter Analytics Dashboard created with Power BI, designed to offer detailed insights into tweet data.

The dashboard focuses on key engagement metrics such as impressions, media views, and user interactions through clicks.

It features a range of interactive visualizations, allowing users to explore tweet performance from multiple perspectives.

It involved extensive data preprocessing, cleaning, and visualization using Power BI, DAX, and Power Query, with a strong emphasis on real-time filtering and interactivity for enhanced data analysis.

Udemy Dataset Analysis:

This Udemy Courses Analysis Dashboard is created to provide valuable insights into the performance metrics and trends of Udemy's educational content.

By incorporating key performance indicators (KPIs) and visual analytics, the dashboard acts as a strategic resource for stakeholders to improve course development, marketing efforts, and overall business decisions.

Zomato Restaurant Dataset Analysis:

This repository features a Power BI dashboard that analyzes Zomato restaurant data.

The analysis provides insights such as the number of restaurants by city, cuisine types, ratings, average cost for two, top 10 restaurants, and Percentage of restaurants offering online food or not.

The goal of this project is to uncover valuable insights into customer behavior, preferences, and industry trends.

PROFESSIONAL EXPERIENCE

Brocade § Santa Clara CA

NETWORK TEST ENGINEER

Jan 2015 to DEC2015

Hands-on experience on test sets such as IXIA.

Test network hardware and software (routers, switches, firewalls, servers).

Identify and fix network issues (connectivity drops, bandwidth problems, configuration errors).

Prepare test plans, test cases, and procedures.

Work with software developers, QA teams, and security teams.

Support network upgrades, installations, and migrations.

Document test results and network performance reports.

IBM/Lenovo § Santa Clara CA

NETWORK TEST AND L3 SUPPORT ENGINEER

May 2014 to DEC2014

Hands-on experience on test sets such as IXIA.

Experienced with configuring IBM Switches 8264, 8124, 8052, IBM BladeCenter Chassis and PurefLex Chassis, etc.

Troubleshot and resolved customer issues occurring on different protocols such as STP, LACP, VRRP, VLAG(Virtual link aggression),etc.

Help the team with internal lab maintenance.

Create and update trouble tickets using corporate ticketing system (OTRS) and Web Retain.

Customer issues include identifying software bugs, network design and configuration, and interoperability/compatibility assistance.

L3 technical support engineer and performing troubleshooting of network related issues.

Receive escalations case from Tiers1 & 2.

Replicate customer's issues in the lab setup for troubleshooting and problem duplication.

Use ClearQuest for filling software defects.

Work with our software developers to help identify and fix bugs.

Performed systematic troubleshooting steps to isolate network problems.

Good understanding of Lab build and Network topology.

Network analysis experience using tools like Wireshark.

Installed and Configured ESXi 5.5 and VMware V Sphere.

Creating virtual PCs, installing OS and software using VM ware.

Hazenops § Santa Clara CA

Network Test Engineer

June 2011 to AprIL2014

Layer 2 and Layer 3 Protocol configuration

Routing Protocols- EIGRP, OSPF and BGP

Performed Network Testing using Spirent SmartBits 600B

Installed and setup Spirent Smartbits 600B

Documentation experience in documenting user guides and technical reports for the project

Used Microsoft Word and Visio for Network Documentation

Used SmartWindows and SmartApps for testing

Performed Packet Loss testing by sending different number of packets and Frame size

Verified the packet loss by verifying the packets sent and recieved.

Performed Vlan tests and created Postive and Negative Test scenarios for testing the VLAN tags in the frames and whether the L2- DUT is functioning well.

Responsible for configuration and testing Hazenops' network project deployments at customer locations.

configuring ACLs, NAT, PAT etc in cisco firewall.

Establish and troubleshoot site-to-site VPN tunnels on cisco routers.

Knowledge of Intrusion Prevention System, IPS, IDS.

Configured ether channel link bundling using PAgP and LACP protocols to eliminate issues related to congestions and manual load balancing associated with allowing specific VLANs on trunks. Created tests with specific set of subnets to ensure that the load balancing as happening as desired.

Expert in L2 and L3 features like VLAN, STP, intervlan Routing, NAT, PAT, DNS.

\EDUCATIONAL MERITS

Bachelors of Engineering, NED University and Technology

TECHNICAL EXPERTISES

Operating Systems:

Windows 2003/2008 Server, Red Hat Linux5.0/6.1, and Windows 7/8

Programming

Python, TCL

Networking Protocols:

TCP/IP, UDP, VTP, STP, VLAN, ISL, Trunking, Etherchannel, NAT, PAT, IPSEC VPN, CDP, RIP v.1&2, OSPF, IGRP, EIGRP, BGP, & DNS

Networking Hardware:

Routers (Cisco 4000, 3600, 2800, 2600, 2500, 1700.

Cisco Switches ( 3500, 2900)

Contact this candidate