Data Analyst Trainee
Resume:
Gargi Roy
Contact Information
Phone: 304-***-****
Email: *****.*****@*****.***
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