Data Project

Siddarth Rajikumar

716-***-**** ***@*******.*** https://www.linkedin.com/in/siddarthrajikumar/

EDUCATION

UNIVERSITY AT BUFFALO, SUNY UNIVERSITY AT MUMBAI

Master of Science in Finance, Feb 2018, Master of Commerce, May 2016 (Advanced Accounting)

Financial Risk Management track (STEM) Bachelor of Commerce, May 2014 (Accounting and Finance)

SKILLS

Microsoft Excel-VB & Macros, Word, PowerPoint, Access, SPSS, R, SAS, Tally, Finacle, GAAP, MIS, SQL, SAP, ERP, Financial Modelling, Tableau, financial analysis, reporting, credit risk, AML/KYC, Bloomberg, leadership, Communication.

EXPERIENCE

‘Changing the present’ – Startup Non-Profit New York City, NY

Finance Intern July 2017-Aug 2017

Used Data manipulation and validation on excel to standardize donor data reports to create a usable data set for analysis.

Obtained 5000 donor profiles from past donor data using predictive analytical techniques (i.e. statistical analysis to create a model and performing model monitoring) an ensure Ad compliance with US charitable laws for nonprofits.

Created financial models from using common size analysis on MS Excel for business forecasting for the next 8 quarters.

Validated and analyzed financial data to create managerial reports using power point to communicate to other donors.

Oa-At-Ka Milk products Cooperative Inc Batavia, NY

Finance Academy project-team lead Feb 2017-Apr 2017

Extracted past 5-year CME data- Dairy forwards, on excel worksheets to analyze impacts of linking production to market.

Executed variance analysis reports to identify factors in order to create solutions to process excess raw milk availability.

Presented production alternatives to increase product profitability by 30%.

S.Jaykishan Chartered Accountants Mumbai, India

Financial analyst & Audit Assistant Aug 2012 -May 2015

Used Excel Macros to create ‘Credit Monitoring Arrangement’ reports for raising loans for real estate companies and SME’s after analyzing project appraisals, valuations, viability, cash flow and asset servicing.

Formulated MIS, ERP reports & P&L reports using V-Lookup extracting financial information for performance evaluation for global clients to formulate monthly strategies from the firm’s ROI, ROA and ROE.

Prepared quarterly targets and deviation reports using Pivot tables and MS-Access to analyze performance and budget control for multinational organizations based in the Europe, India, Middle Eastern countries and South-east Asia.

Handled advisory services, taxation issues and cases for individuals and companies on IFRS and GAAP compliance. Supervised bank reconciliations, accounting entries, A/R and A/P reconciliations.

Audited syndicated loans and group remittances by banks ensuring AML and KYC compliance with FATCA regulations.

Setup internal control process systems and responsibly lead audit teams on statutory audits, tax audits.

PROJECTS

Currency Risk Management

Sep 2016-Nov 2016

Designed ‘Currency risk management methods’ after researching and analyzing Currency market trends for multinational manufacturing organizations by developing a framework to compare present value of currency in each technique.

Equity Research project

Oct 2017-Dec 2017

Research to analyze the effect of PEAD (Post-earnings announcement drift) on standard Uneven returns by extracting data through SAS and analysis using data extracted using Wharton case study utility.

Intrinsic Stock Valuation

Jan 2016-May 2016

Used DCF, EPS, intrinsic, price earnings to growth methods to analyze the stock price of the company over 12 quarters and ascertain reasons for deviation from the actual price and doing comparative ratio analysis.

ACTIVITIES

Best Team- Special jury award -Finance Academy company project, Apr 2017.

UB Team member- Whitman school of management, Syracuse case competition.

REALM leadership program.

Certified in equities and derivatives module from ‘National Stock Exchange’, March 2015.

Contact this candidate