Data Analyst

AYUSH PANWAR

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

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

PROFESSIONAL SUMMARY:

* **** ** *********l experience in SQL Development, Reporting and Business analytics.

Hands on experience in using TABLEAU, created advanced chart types, visualization and complex calculations to manipulate the data and developing work sheets for intuitive and innovative presenting by Tableau.

Extensive knowledge of advanced SAS procedures including UNIVARIATE ANALYSIS, REGRESSION, ANOVA, CHI-SQUARE TEST, T-TEST, GRAPH AND PLOT.

Hands on Experience in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.

Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS tables using LIBNAME.

Using Data pre-processing libraries performed Data cleaning, dealing with missing data and taken care of Categorical Variables, Splitting the data set and Feature scaling.

Strong ability to write SQL queries using PROC SQL.

Hands-on experience writing SQL queries and Stored Procedures in Microsoft SQL Server Management studio.

Experience with Data Visualization using Tableau, Excel and Python.

Good knowledge and hands-on experience on using different libraries in Python for Data Analytics like Numpy, Pandas and Matplotlib.

Knowledge in predicting most impactable variables and trim the unwanted variables by feature extraction and feature selection algorithms.

Knowledge of SDLC’s like Waterfall, and Agile.

Good team player and quick-learner. Highly self-motivated person with good communication and inter-personal skills.

TECHNICAL SKILLS:

Technologies: Predictive modeling, Statistical Analysis, Data Mining, Data Analytics, Data Visualization.

Programming Languages: SQL, SAS, Python.

Data Analytics/Visualization: SQL, SAS-Base, SAS-Macros, SAS-SQL, SAS-ODS, Tableau Desktop, PowerBI, Excel.

Database: Microsoft SQL Server.

Operating Systems: Windows, Linux

PROFESSIONAL EXPERIENCE:

Integra Technologies LLC February 2018 – Present

Data Analyst Wilmington, DE

Imported data from different sources in different formats such as Excel, CSV, and database file.

Helped create efficacy and safety analysis ready datasets for oncology studies.

Generated tables, listings, and graphs using PROC REPORT and PROC GPLOT.

Produced SAS outputs in RTF, PDF, CSV and HTML formats using Output Delivery System (ODS) facility.

Created interactive dashboards using input from different cross-functional teams through Tableau to identify problem areas and initiate action for improvement.

ProctorU April 2017 – January 2018

Proctor (CSR) & Data Analyst Livermore, CA

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.

Heavy SQL queries including complex joins, nested queries, stored procedures, common table expressions (CTEs) etc. were being used for Integration and Management of data.

Data migration tasks were accomplished via SQL Server Integration Services (SSIS). Featuring tool for data Extraction, Transformation, and Loading (ETL).

Additionally, SSRS & Tableau were being used for data visualization and tracking KPIs.

Pragati Micro Instruments Pvt. Ltd. June 2014 – November 2014

Project Assistant Hyderabad India

Gained working experience in writing SQL queries for different validation Purposes.

Writing the test cases and executing them.

Developed functions, procedures and packages to implement the system’s business logic using Microsoft SQL.

Created different spreadsheets and dashboards to visually analyze data using Tableau and Excel.

PROJECTS:

1) MSBI – SSIS, SSMS & SSRS January 2018

Currently using Microsoft Business Intelligence-MSBI suite that helps in providing solutions for Business Intelligence and Data Mining Queries.

MSBI categorizes 3 Microsoft Development Environment Packages SSIS-Integration Services, mainly used for Extraction, Transformation and Loading (ETL) of data.

SSMS-Management Studio, used for configuration, management and administration purpose and SSRS-Reporting services, used mainly for creating reports.

2) SAS Programming February 2018

Imported data from different sources in different formats such as Excel, CSV and database file and performed concepts like data extraction, auditing and analysis.

Generated tables, listings and graphs using PROC REPORT and PROC GPLOT. Produced SAS outputs in RTF, PDF, CSV and HTML formats using Output Delivery System (ODS) facility.

3) Python Programming November 2017

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.

EDUCATION:

University of South Florida, Tampa FL January 2015 – December 2016

M.S. Electrical Engineering GPA: 3.5/4.0

University of California Santa Cruz, Santa Clara, CA June 2016 – August 2016

Certification in UVM & SV Pass

Lovely Professional University, Jalandhar, Punjab July 2010 – June 2014

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

ACHIEVMENT:

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

***

Contact this candidate