SAHIL KHULLAR
** ******** ****** *** *, Boston, MA 02115
617-***-**** ****************@*****.*** linkedin.com/in/skhullar
• Strategically and Analytically skilled in Financial Modelling, Reporting and Forecasting
• Proficient knowledge in Statistics, Multinational Finance and Global Trade Environment EDUCATION
Boston University, Boston, MA Sep 2015 - May 2017
Master of Science: Concentration in Financial Economics Relevant courses: Financial Accounting, Managerial Accounting, Multinational Finance & Project Management Manav Bharti University, India Aug 2013 - May 2014 Associate Diploma: Concentration in Financial Management Relevant courses: Portfolio Management, Corporate Finance, Financial Accounting and International Trade & Business Guru Gobind Singh Indraprastha University, India Aug 2010 - May 2013 Bachelor of Business Administration
Relevant courses: Business Innovation, E-commerce, Accounting and Financial Markets & Institutions SKILLS
Analytical & Reporting Tools: Microsoft Access, Excel (VLOOKUP, Macros and Pivot table) Microsoft Office Suite: Microsoft Project, WordPress, Outlook, Microsoft Power Point Databases: Oracle 11g, MySQL
Business Intelligence Tools: Tableau, Power BI
Web Technologies: Dreamweaver, HTML
Disciplines: SDLC, Agile, Waterfall
PROFESSIONAL EXPERIENCE
Globe Civil Projects Pvt. Ltd. (Financial Analyst) Jun 2013- Aug 2015
• Prepared and analyzed Financial Reports and Models for Variance and Trend analysis, consolidated reporting using Tableau and analysis across the projects by querying Oracle database
• Reconciled financial models including Account receivable, Account payable, Balance sheet, Profit & loss account, to convey actionable insights using Excel
• Performed Ad-hoc analysis and developed solutions to key business problems
• Presented analysis in an easy-to-understand format for non-financial colleagues to ensure effective financial management, drive business decisions and identified issues and opportunities for continuous quality improvement. Technologies Used: Excel (vLookup, Pivot table & Macros), Oracle 11g, Tableau, Microsoft Power Point Globe Civil Projects Pvt. Ltd. (Assistant Accountant) May 2012 – Jun 2013
• Helped with creating monthly budgeting and forecasting, and conduct interviews for detailed review of revenue forecast
• Managed collection of past due accounts by analyzing the accounts receivable Aging report
• Assisted in year-end closing by compiling and reconciled accounting reports
• Worked with Senior Accountants on the day-to-day accounting for development projects
• Reconciled financial models including Account receivable, Account payable, Balance sheet, Profit & loss account, to convey actionable insights using Excel
Technologies Used: Excel (vLookup, Pivot table & Macros), Microsoft Access, Microsoft Power Point Blue Star Pvt. Ltd. (Intern - Finance) May 2011 - Sept 2011
• Created the daily Ledger transactions for the Company which helped the management in foreseeing the performance of domestic and international operations to take corrective steps
• Responsible for preparing detailed P&L monthly forecasts
• Depreciated fixed assets which helped company in cost recovery and tax deduction
• Compiled information for internal and external auditors Technologies Used: Excel (vLookup, Pivot table & Macros), Microsoft Power Point ACADEMIC PROJECTS
Acquisition of Glu Mobile by Zynga (Merges & Acquisition) Jan 2017 – May 2017
• Analyzed and researched on customer base, daily users and financial stability for both gaming industries
• Worked in a team to build a Discounted Cash Flow model using Excel to reach at the current valuation
• Analyzed pros and cons of the acquisition to assess the future opportunities and risk associated
• Collected all the facts and figures for pricing and funding, come up with the recommendation for successful acquisition E- Commerce Business Plan (E-commerce – Business Model ) Sep 2015 - Jan 2016
• Researched on all the tourist website within four countries which included Bulgaria, China, India and Taiwan
• Analyzed the collected information and market trends in all the four countries
• Created a business model for a startup tourist company with the focus on online transactions
• Facilitated with advance booking of tickets, tourist guides, one click and 360-degree view of the locations
• Constructed a website using Dreamweaver with enhanced user experience