Sinai Beth Data Analyst

Fraz S. Siddiqui

516-***-**** *******@*****.*** East Meadow, NY 11554 linkedin.com/in/frazssiddiqui github.com/frazsam

I am an experienced Data Analyst with a background of financial corporations, education and health care. Skilled in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Tableau, Power BI, Data Warehousing, Agile and Waterfall Methodologies, SQL Server, SSMS (SQL Server Management Studio), Oracle Database, MySQL, HTML, CSS, Python, (Pandas, Seaborn, Matplotlib libraries) Linux Server, and Linux. Strong information technology professional with a Bachelor of Science

SKILLS

DATA ANALYST: Microsoft Excel, Pivot Tables, Tableau, SQL, SQL Server, MySQL, PostgreSQL, Oracle Database SSMS (SQL Server Management Studio), Python, Microsoft PowerPoint, Story Telling, ETL, Testing Cases, Data Warehouse, Jira, Agile and Waterfall Methodologies, Matplotlib, Seaborn, Pandas, MS Power BI, Statistical Inference, Revenue Analysis

PROGRAMMING LANGUAGES/ OPERATING SYSTEM: C++, Java, HTML, CSS, Windows 10, Linux, Unix, Android, MacOS

PROJECTS

Straight Line Source Insight

In this project, the Company Sales all over the USA were analyzed using Tableau Application

King County Houses' Price Factors

In this project, the prices of houses in King County were analyzed using Tableau Application

Video Games Sales Insight `

In this project, the sales of the video games around the world were analyzed using Tableau Application, and Python language

ChemCorp Insight

In this project, the insight of all the businesses in ChemCorp were analyzed using Tableau Application

Medical Project in SQL

In this project, the Data Analysis of Medical Products and Employees was analyzed using SSMS (SQL Server Management Studio)

Southern Water Corporation Statistical Analysis

In this project, the Statistical Analysis of Southern Water Corp was analyzed using Microsoft Excel

AEMR Corporation Visual Analysis

In this project, the Visual Analysis of AEMR Corp was analyzed using Microsoft PowerPoint

EXPERIENCE

02/2021-Present Straight Line Source Uniondale, NY

Data Analyst

Developed the Pace reports of Straight-Line Home Mortgage, Topdots and various businesses using Tableau and MS Excel

Extracted data from SQL Server, MySQL, Ricochet, and Top Dot Databases to create the report in MS Excel and Tableau

Attended meeting with executive and client to gather the requirement of projects and analyzed the weekly and MTD progress

Used SSMS (SQL Server Management Studios) developed operational and investigative analysis of large data sets using SQL into meaningful analysis and reporting.

Developed Seaborn and Pandas library python script to analyze the differential and inferential statistics of sales

06/2020- 12/2020 Mount Sinai Beth Israel New York, NY

IT /Junior Data Analyst

Imported Hospital’s Data from PDF file and then formatted professionally as given instruction to present in MS Excel

Created the inventory report of supplies using VLOOKUP, LOOKUP, SUMIFS, and IFS function

Created the Remote Epic Lab for Mount Sinai Beth Israel Hospital’s staff and nurses using Zoom and Cisco WebEx

Installed, maintained, configure and deploy the zebra printers, scanners and multifunction printers

Used SOM (Service Now) and resolve the issued tickets for hospitals, and gathered feedback from end users

Troubleshot, Installed, modified, configured, upgraded and repaired computer hardware and software systems

01/2020- 04/2020 Infosys Lone Tree, CO

ETL Tester

Developed test plans, test cases, test scripts, and test reports on multiple projects of varying size using SQL query and scripts on SQL Server Management Studio

Attending the business walkthrough meetings and scrum meeting to understand the requirements of the project

Created the Query surge to analyze source to target mapping on MS Excel sheet

Write SQL Queries to define, identity and validate the code written for the data movement into the database table ‘

Using JIRA to log the defects found during testing

Designed and populated specific tables, databases for collection, tracking and reporting of data

01/2017- 01/2020 City University of New York (CUNY), York College Jamaica, NY IT Support

Created tickets for the PCs, printers, and laptop using Kace Management Appliance Service System

Helped and Assisted 20+ students on network IP copiers, multifunction scanners and network printers

Installed and maintained the multifunction printers, copier and scanners

Organized and checked software, network connectivity and hardware installation of 100+ computers in library

Made IT report and pivot via MS Excel at the end of the day to update about Desktop Computer to library supervisor

Extracted the csv data file from CUNY database and then analyzed the number transfer of books, books borrowed

Created the weekly reports on MS Excel of all the expenditures in library

EDUCATION

Springboard Data Analytics Career Track, Certification 2019

6-month intensive course in data analytics technologies and methods.

Whizdom Training for QA ETLTester/SQL Course, January 2020

Certified as ETL Tester

City University of New York CUNY, York College, Fall 2017 Jamaica, NY

Bachelor of Science in Computer Science; 3.0/4.0 GPA

Concentration in Mathematics

Contact this candidate