Resume

Sign in

Data Analyst Trainee

Location:
Morgantown, WV
Posted:
April 22, 2021

Contact this candidate

Resume:

Gargi Roy

Contact Information

Phone: 304-***-****

Email: adlv2t@r.postjobfree.com

Experience

Data Analyst Trainee

KVRA Tech, NJ Mar 2020 to Sept 2020

Responsibilities:

Assisted with the validation of the data currently being developed into the data warehouse

Created reusable Macros and used existing macros for Data Cleansing, Validation analysis and Report generation

Prepared new Datasets from raw data files using Import techniques and modified existing datasets using Set, Merge, Sort, and Update statements, functions and conditional statements

Generated professional reports using PROC REPORT

Created models to identify trends using SAS, SQL, and Python

Extracted data from oracle database using SQL pass- through facility, retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis

Effectively used many SAS functions like Scan, Substr, Put, Input, Trim, and applied simple descriptive statistics on datasets using Std, Mean and Sum

Extensively used various SAS ODS techniques to generate complex reports

Coded SAS programs with the use of Base SAS, SAS/SQL, and SAS/Macros

Maintained large data sets, combining data from various sources in varying formats to create SAS data sets by using Set and Merge, Sort, and Update, Formats, Functions and conditional statements for generating Reports

Joined multiple tables using SQL

Education

West Virginia University (WVU)

M.S. in Applied Mathematics

GPA:3.3, 2019

Area of Emphasis: Applied Mathematics

Research Emphasis: Astronomy and Astrophysics

New Jersey Institute of Technology (NJIT)

M.S. in Applied Mathematics

GPA:3.7, 2016

Area of Emphasis: Applied Mathematics

Vidyasagar University, India

M.Sc. in Applied Mathematics with Oceanology and Computer Programming, 2011 Area of Emphasis: Applied Mathematics

Research Emphasis: Operations Research

University of Calcutta, India B.Sc. in Mathematics, 2009 Major: Mathematics (Hons) Minors: Physics and Statistics

Publications

G. Roy. Phased Array Feed Beamforming and its Application in Mapping Extended Sources.

The Research Repository@ WVU. (2019)

B. Sarkar, A. Majumder, M. Sarkar, B.K. Dey, and G. Roy. Two-echelon supply chain model with manufacturing quality improvement and setup cost reduction. Journal of Industrial and Management Optimization. (2016)

B. Sarkar, B.K. Sett, G. Roy, and A. Goswami. Flexible setup cost and deterioration of products in a supply chain model. International Journal of Applied and Computational Mathematics. (2015)

B. Sarkar and G. Roy. Two echelon supply chain model with reliability. Proceeding of Industrial Engineering and Service Sciences. (2013)

Presentations

“Phased Array Feed Beamforming and its Application in Mapping Extended Sources”, Oral defense of Master’s Thesis, Department of Mathematics, WVU, Nov. 2019

“Effects of quality improvement and setup cost reduction in a production inventory system”, UGC sponsored National Seminar on “Recent Aspects in Mathematics and their Applications”, Vidyasagar University, Midnapore, India, Feb. 2014

“Supply chain model with reliability, deterioration, and single supplier multiple delivery policy”, Department of Mathematics, National Institute of Technology, Durgapur, India, Nov. 2013.

Workshops & Conferences

Recent Aspects in Mathematics and their Applications (Vidyasagar University, India, Feb. 2014)

International Conference on Recent Aspects in Mathematics and their Applications (Vidyasagar University, India, Feb. 2013)

One week Short Term Course on Advanced Optimization Techniques (National Institute of Technology, Durgapur, India, Nov. 2013)

Academic Activities

Research Assistant (Summer 2019): Hoover Chemistry Research Laboratory, West Virginia University

Teaching Experiences

Graduate Teaching Practicum (Math 590), WVU

Regular classroom observations of experienced instructors Weekly meetings

Written and video case studies

Graduate Teaching Assistant (Mathematics), WVU

Fall 2018 and Spring 2019: Calculus 1 (Math 155) recitation leader. Fall 2019: Pre-Calculus (Math 154) recitation leader.

Mathematics Lab Tutor/Mentor, WVU

Fall 2017 and Spring 2018: College Algebra, Trigonometry, Calculus 1, Calculus 2.

Honors

Top 6% rank in Graduate Aptitude Test in Engineering (GATE) for Mathematics in India, 2014

Technical Skills

SAS: SAS/Base

Proc Contents, report-specifying where expressions, contains operator, customized layout with by group and ID variables, temporarily and permanently assigned labels and formats, descriptive statistics- Proc Means, Proc Report, combining SAS data sets- one to one reading, concatenating, interleaving and match merging, calculations with date and date-time values, do loop and arrays, output delivery system.

SAS: SAS/SQL

Proc SQL, specifying columns and rows, Select statement, clauses Where, Group by, Having, Order by, Case, inner and outer SQL joins, Cartesian Product.

SAS:SAS/Macro

Macro statement, macro variable, macro variable references, automatic and user- defined macro variables, macro function.

Other Relevant Skills

Computer languages: Matlab, R, Python, Tableau

Tools: LaTex, Minitab, Mathematica, Gaussian, Avogadro

Operating Systems: Ubuntu Linux

Strengths

Good interpersonal & communication skills.

Hardworking, able to work under pressure, and a consistent performer.

Self-motivated, sincere, and committed to excellence.

DECLARATION:

I hereby declare that the information provided above is correct to the best of my knowledge.

Date: 3.23.2021

Gargi Roy



Contact this candidate