SQL Data Analyst

AYUSH PANWAR

**** ******* ***, *********, ** ****0

Ph. 408-***-**** Email. *************@*****.*** LinkedIn. https://www.linkedin.com/in/ayush-panwar-1b3586108

PROFILE

Seeking a position as SQL Report Developer.

A new graduate with an Electrical Engineering degree from University of South Florida. Well versed in creating new data collection system that optimizes data management, capturing, delivery and quality. Special talent for acquiring data from different sources and develops data systems that support analysis and reporting. Advanced proficiency in all aspects of Excel, SQL and Python. Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities. Reliable and dedicated with the ability to grasp and apply new procedures quickly; organize and prioritize tasks to meet deadlines and adapt readily to new challenges.

EDUCATION AND TRAINING

University of South Florida, Tampa, FL 01/2015 to 12/2016

M.S. Electrical Engineering GPA: 3.5/4.0

University of California Santa Cruz, Santa Clara, CA 06/2016 to 08/2016

Certification Pass

Lovely Professional University, Jalandhar, Punjab 07/2010 to 06/2014

B.S. Electronics and Communication Engineering GPA: 3.7/4.0

SKILLS

Data Visualization

Excel, Access, PowerPoint

T-SQL queries

Data Analysis Techniques

Data Wrangling

C, C++

Python

Tableau

ETL

PROJECTS

1) Python Programming

Started learning python from scratch. Understand the basic concepts like Strings, Functions, List, tuples, Dictionaries and Classes. Currently proficient in converting CSV, html, XML, JSON forms of data into python understandable code using packages like pandas, numpy and matplotlib, making data analysis /visualization simple and presentable.

2) Excel, SQL & Tableau

Currently using these tools for Data analyzing and visualization. Excel is widely used for creating Pivot and vlookup tables. SQL is extensively used for querying and joining tables in order to come up with more creative data. Finally Tableau is being used for creating workbook and presenting data in more pictographic form so as to take better decisions more quickly.

3) Verification of 10GB Ethernet MAC Core using UVM (Universal Verification Methodology)

It was a hands-on project to design and build an industrial-strength UVM Verification Environment. Testbench Components like environment, agent, sequencer, driver, monitor, scoreboard and Objects like sequence and packets were used. They were connected through TLM ports. The designed was successfully verified by running few testcases.

4) Verification of 10GB Ethernet MAC Core using System Verilog

It was a hands-on opportunity to build a System Verilog class-based verification environment, otherwise known as the OOP Testbench, on a 10Gb Ethernet MAC Core design. The packet module of the testbench was random constraint. Even the components were connected through Mailbox.

PROFESSIONAL EXPERIENCE

PROCTORU 04/2017 to Present

Proctor

Currently working as an online Proctor and a Jr. Data Analyst. Perform daily data queries and prepare reports on the daily, weekly, monthly and quarterly basis. Use advanced Excel functions to generate spreadsheets, pivot tables, and vlookup tables. In addition to that Tableau is being used for data visualization.

PRAGATI MICRO INSTRUMENTS PVT. LTD. 06/2014 to 11/2014

Project Assistant

Design and development of ASIC using VLSI for specific digital signal processing applications.

DEFENCE ELECTRONICS AND RESEARCH LABORATORY 06/2013 to 07/2013

Design Trainee

Analyzed Radar and Communication signal through fast Fourier transform (FFT) and IQ technique using MATLAB.

ACHIEVEMENT

Outstanding Achievement Award for demonstration of the Electrical Engineering Graduate Portfolio at University of South Florida.

***

Contact this candidate