Data Analyst Resume Wilmington, DE - Hire IT People

PROFESSIONAL SUMMARY:

1 year of industrial 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 advancedSASprocedures includingUNIVARIATE ANALYSIS, REGRESSION, ANOVA, CHI - SQUARE TEST, T-TEST, GRAPH AND PLOT.
Hands on Experience in using various SAS report generating procedures likePROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
Hands on experience in SAS programming for extracting data fromFlat files,Excel spreadsheetsand externalRDBMS tablesusingLIBNAME.
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 usingPROC 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:

Confidential, Wilmington, DE

Data Analyst

Responsibilities:

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.

Confidential, Livermore, CA

Proctor (CSR) & Data Analyst

Responsibilities:

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.

Confidential

Project Assistant

Responsibilities:

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.

We provide IT Staff Augmentation Services!

Data Analyst Resume

Wilmington, DE

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship