Page * of *

RUDRAXI MITRA MAJUMDAR

Portland, OR 97229, adh0gc@r.postjobfree.com, 347-***-****

EDUCATION

Portland State University, Portland, OR

Graduate Certificate in Business Intelligence and Analytics Sep 2017 - October 2018

St. John’s University, Jamaica, NY

Master of Science in Data Mining and Predictive Analytics Aug 2016 - May 2017

State University of New York at Albany, Albany, NY Master of Science in Economics

Aug 2013 - May 2015

PROFESSIONAL EXPERIENCE

Evraz NA (contracted by Aerotrek), Portland OR

BI Developer, Zack Keith

• Performed ETL procedures by Informix server to load data in local computer

• Wrote SQL query to load data in Power BI from data warehouse like IBM Informix, and Sharepoint.

• Data Analysis in Power BI to visualize injuries in steel mill, monthly, and yearly claims and heat treat processes by product ID Microsoft SQL course in Udemy

Professional Student in UDEMY, Instructor: Bruce Knowlton Apr 2020 – Aug 2020

Dec 2019 - Apr 2020

• Performed ETL procedures by Microsoft SQL server to load data in local computer

• Used SQL keywords, such as select, alter, insert into, update, from, and, or, having, order by, where, any, all, etc. to create tables and retrieve query Thermo Fisher (contracted by Compunnel Inc.), Hillsboro, OR Feb 2019 – Nov 2019 R&D Intern in Global Portfolio Group, Dr. Scott Haight

• Analyzed business data to calculate project phase, state, duration, and last update date using Power BI

• Modeled the lead BU contribution

• Devised DAX code to model and identify other BU allocations

• Identified disconnected projects in database using Power BI

• Identified incomplete projects using Pareto Chart in Power BI

• Modeled the time horizon of projects in a Matrix visual in Power BI

• Formulated T-SQL query to identify projects’ last improvement and update

• Composed design rules for the Power BI report to ensure quality and consistency Cornell University, Ithaca, NY June 2017 - Aug 2017 Intern in Statistical Analytics, Dr. Johanne Pelletier

• R programming in Econometric Analytics for Agricultural Economic data in Africa UNICEF, New York, NY Aug 2015 - Dec 2015

Intern, Mr. George Adjei Laryea

• Conducted literature review in children’s health, education, and inequality New York State Assembly, Albany, NY Jan 2011 - May 2011 Intern, Mr. Mark J. F. Schroeder

• Conducted legislative research for over-the-counter birth control pills COURSE/RESEARCH PROJECTS

Factors that affect current account balance in USA using SAS and Excel Advisor: Prof. Hiro Ito, Portland State University

• Found that crude oil imports to total real imports ratio, terms of trade growth to real GDP ratio, and real GDP growth rates are significant in influencing current account balance in the US.

• Budget balance to real GDP ratio and real trade-weighted exchange rate are insignificant in influencing current account balance in the US.

Spring 2018

Page 2 of 2

Gun violence project using Tableau

Prof. David Gerbing, Portland State University

• Visualized data in Tableau to demonstrate casualties of gun violence. Spring 2018

Data analysis project in R

Prof. David Gerbing, Portland State University

• Created bar graph, line graph, box-plot, correlation plot, time-series plot.

• Formulated forecast of series, map of location, and Confidence Interval at 95%. Spring 2018

Toyota’s operation as a multinational company

Prof. Charles Grant, Portland State University

• Examined why Toyota is a multinational company with the help of a theoretical model.

• Performed theoretical analysis to examine why Toyota is outsourcing its activities. Fall 2017

Data visualization of houses in King County using Tableau Prof. Fazel Ishtekar, St. John’s University, New York, NY Spring 2017

• Designed and developed data visualization of house prices and types of houses in King county. Econometric analysis of factors that affect interest rate using R Prof. Manuel Russon, St. John's University

Spring 2016

• Developed a regression model to predict the interest rates of US economy. Does Republican presidency affect stock prices?

Prof. Norris J. Larrymore, St. John’s University, New York, NY Fall 2016

• Analyzed the effect of stock prices for two different periods of presidency o Small technology companies are sensitive to change in presidential administration based on the full regression analysis during Democratic administration. o Technology stock prices of small companies are affected by the rate of change in S&P 500 and S&P100 volatility index.

o Stock prices of large technology companies are insensitive to change in presidency period based on the p-value of the overall regression model at 5% significance level. ARIMA modeling in SAS

Prof. Denis Kwiatkowski, SUNY Albany, NY

Spring 2015

• Identified if the data series is stationary or non-stationary.

• Estimated the stationary series in different lag lengths.

• Forecasted data series for future years.

Econometric analysis in SAS

Prof. Zulkarnain Pulungan, SUNY Albany, Albany, NY Fall 2014

• Developed regression models, graphs, and tables for the health care dataset in SAS. TECHNICAL SKILLS

Software Power BI, SAS, R, Tableau, S-Plus, STATA, Occam, SQL, T-SQL, Python, and Microsoft Office. RELEVANT COURSE WORK

Graduate Business Intelligence and Analytics, Analytics and Communication Management, Operation Research, Multinational Enterprise, Applied Regression, Predictive Analytics, Big Data Analytics, Computer Applications in Economics, Data Analytics, Quantitative Methods in Economics, Macroeconomics, Microeconomics, Mathematics for Economists, Game Theory, Financial Management and Financial Analysis. Undergraduate Econometrics, Money and Banking, Macroeconomics, International Economics of Relation, Microeconomics, Economics of Development, Probability Theory and Statistics, Principles of Management. AWARDS

• Dean’s List in the year of 2010 at SUNY Albany, and in the year of 2009 at SUNY Plattsburgh.

• Empire State Scholarship awarded in Jan 2009 - Dec 2009 by SUNY Plattsburgh. IMMIGRATION STATUS

• Work Authorization: Permanent Resident (Green Card)

• Citizenship: Bangladesh

Contact this candidate