Data Analyst

Nimesh W. Jayasekara

** ********* **, *******, ** 01960

978-***-****, ********@*****.***

Professional Summary

Experience in successful project management with local and international affiliates, employing business data analysis,

forecasting, root cause analysis, data audits and impact assessments

Expertise in analyzing, modeling and forecasting business, financial and economic data using SAS, SQL, Excel

(vLookup, Pivot tables), Eviews, Stata, Limdep, SPSS and JMP

Economics graduate level course work covering Economatrics, Mic roecomonics, Macroeconomics, Economic

Forecasting, Data/ regression Analysis and Financial Analysis

Education

Master of Art, Economics August 2010 - May 2013

Wayne State University, Detroit, MI

Master of Art, Applied Economics March 2007 - May 2009

University of Cincinnati, Cincinnati, OH

Concentration : Data Analysis

Bachelor of Science, Mathematics and Physics March 2002 - May 2005

University of Peradeniya, Sri Lanka

Minor : Economics, Management

Work Experience

Consultant Business / Data Analyst

A.T. Cross Company, Lincoln RI September 2014 - Present

Being instrumental in merging database of a newly acquired company to A.T. Cross database using SQL and

Excel

Successfully combining several local ERP systems into one global ERP system using data mining,

consolidation, merging and other techniques

Leading Technical discussions, e-meetings and reporting the conclusions to the project management through

presentations and weekly reports

Unearthing discrepancy over $ 2 million worth of inventory and raw materi al using data audits

Internship – Business / Data Analyst

August 2013 – September 2014

Blackstone Valley IT Consultants, Douglas, MA

Prepared data for different projects. Performed business / data analysis, prepared reports using SQL and MS

Excel.

Performed data mining, combining databases, data audits, data consolidation and impact assessments

Evaluated business process and doing Gap Analysis

Graduate Teaching Assistant September 2010 - May 2013

Department of Economics,

Wayne State University, Detroit, MI

Conducting macroeconomics and microeconomic courses for senior undergraduates, preparing course o utlines,

exams, student performance analysis reports and mentoring final projects

Teaching Assistant August 2009 - May 2010

Department of Mathematics,

University of Dayton, Dayton, OH

Conducting computer lab sessions - Data Analysis, modeling and interpretation using SAS, Stata, SPSS,

Eviews and Excel

Data Analyst September 2008 - May 2009

Applied Economic Research Institute, Department of Economics,

University of Cincinnati, Cincinnati, OH

Forecasting a deficit of $ 40 million for City of Cincinnati Tax Revenue 2008/2009- Forecast the monthly tax

revenue for the city of Cincinnati with Vector Autoregressive Model (VAR) in order to determine the

estimated budget deficit using Stata and Eviews.

Graduate Assistant March 2007 - September 2008

Department of Economics, University of Cincinnati, Cincinnati, OH

Conducted computer lab sessions - Data Analysis, modeling and interpretation using SAS, SPSS, Eviews,

Stata and SQL.

Tutored undergraduate students on various topics of economics.

Mentored senior undergraduates on their final year projects.

Volunteer Data Analyst

Department of Economics, University of Cincinnati, Cincinnati, OH Sep 2006 - March 2007

Successfully maintained the Economic database, using SQL and Excel. Held the responsibility for preparing

data and consulted analysts for multiple projects.

Data Analyst May 2005 - July 2006

Department of Agricultural Economics and Business Management, University of Peradeniya, Sri Lanka

Project on Human-Elephant conflict in rural Sri Lanka funded by the Asia Development Bank.

Designed data survey, performed data analysis, interpreted results and reported findings.

Analyzed and presented project data using SQL, Limdep and SPSS.

Investment Advisor January 2001 - January 2002

Asia Securities (Pvt) Ltd, Colombo, Sri Lanka

Assisting customers with investment decisions in the Colombo Stock Exchange

Advised investors with information generated by the analyst

Publications/ Conferences

Jayasekara, Nimesh and Passty, Benjamin (05/15/2009). Forecasting City of Cincinnati Tax

Revenue 2008/2009 Department of Economics Faculty Symposium, Cincinnati, OH

Conference in Mathematical Finance and Partial Differential Equations, Rutgers University, NJ, 2009

Relevant Subject Skills (MS/ PhD Level)

Economic Data Analysis I, II, III SAS for Economists

Applied Economic Forecasting Financial Analysis

Investment Analysis Optimization Models for Managers

Financial Mathematics I, II Microeconomics/ Macroeconomics

Marketing-Pricing Options and futures Analysis

Arc GIS Transportation Demand Forecasting

Awards and Scholarships

August 2010 – May 2012

Recipient University Graduate Scholarship / Graduate Assistantship

Wayne State University, Detroit, MI

Recipient Taft Graduate Fellowship, March 2007 - June 2007

University of Cincinnati, Cincinnati, OH

Recipient University Graduate Scholarship / Graduate Assistantship,

March 2007 – June 2008

University of Cincinnati, Cincinnati, OH

Certifications and Proficiencies

Proficient in SQL, SAS, Stata, JMP, Eviews, SPSS, MS EXCEL (vLookup, Pivot tables), Eviews,

Stata, Limdep, SPSS and JMP

Diploma in Business Computing, Bankers Institute of Sri Lanka

Certificate in Business Accounting, Charted Institute of Management Accountants, UK

Contact this candidate