HETAL VANKANI
Mobile: +1-323-***-**** ** Newport Parkway, Apt # 2412,
Jersey City, NJ 07310 Email: ************@*****.***
EDUCATION:
BARUCH COLLEGE, Zicklin School of Business (GPA - 3.71)
New York, NY
Master of Science, Business Computer Information Systems
August 2010 - May 2012
UNIVERSITY OF MUMBAI (GPA - 3.70)
Mumbai, India
Bachelor of Management Studies, Concentration in Finance and International
Finance June 2003 - June 2006
SKILLS/EXPERTISE:
. Applications: MS Office Suite (Excel, Word, Powerpoint), MS Visio,
Rational Rose, Eclipse, MS Project
. Advanced knowledge in data reporting and data summarization tools like
Advanced Excel, Pivot Tables, Vlookup
. Database: MS Access, MySQL
. Programming Languages: C++, Visual Basic (VBA and Macro), SQL
. Web Technologies: PHP, HTML, XML, CSS, Javascript
. Other Skills: Business Analysis, Times Series Analysis, Statistical
distribution, Market Research/Analysis, Forex arbitrage, Gap Analysis,
Excel Modeling, NPV Analysis
WORK EXPERIENCE:
BARUCH COLLEGE, Zicklin School of Business
New York, NY
Graduate Assistant
February 2011 - May 2012
. Maintained and updated the real estate department website on a daily
basis (using HTML)
. Performed usability testing on the web pages (Manual Testing) and
quality audit
. Interacted with the Information Systems Associate from time to time to
report defects on the real estate website
. Prepared data sheets, performed documentation and handled large
volumes of data to meet the requirements of the department
. Consolidated the enrollment data in pivot tables and provided
meaningful analysis
. Coordinated with the advisor to perform daily gap analysis for the
website
. Scheduled events, meetings and seminars with various companies
. Assisted students with their queries on the website and courses
. Researched articles over the web to assist the Chairman to compile his
journals that were to be distributed across 600 universities in USA
NATIONAL WIRE PRODUCTS
Gujarat, India
Analyst
June 2006 - June 2010
. Managed information gathering, documentation and analysis of client
requirements
. Supported the coordination of project schedules right from order
acquisition to fulfillment
. Facilitated resource allocation in terms of project budget and
workload using MS Project
. Communicated and interacted with the business development manager
during different stages of order fulfillment for regular project
performance analysis and cost report preparation
. Analyzed existing business processes so as to give recommendations for
improvements (Streamlined the payroll process for the company by
automating it so as to increase efficiency of the company)
. Assisted with required data analysis and interpretation of the
financial statements, sales revenue and expenses of the company
. Generated reports on the online visibility of the company as well as
project progress
. Developed detailed spreadsheets to identify trends and develop
forecasts, consolidated and analyzed monthly results and budgets
. Assisted the manager in studying the contracts with clients with
regards to the company's policies and guidelines
. Met with international/local clients so as to assist in building
business partnerships for the company
ACADEMIC PROJECTS:
Developed Use Cases, UML diagrams, Activity flow diagrams,
Class diagrams, User Requirement Specification document,
System Design Specification document, etc. as part of
Systems Analysis and Design projects
Built a Company's Web-based Information System using PHP,
CSS, HTML, Javascript as well as Model-View-Controller
Architecture
. Was part of 5 member teams working on projects related to courses in
Excel Modeling, Financial Management, International Finance,
Quantitative Modeling, Database Management, Micro-Macro Economics,
Globalization and Technology, Entrepreneurship
. Awarded 'Outstanding' for undergraduate project work on the growth of
private sector life insurance industry in India
EXPECTED CERTIFICATIONS: Bloomberg, FRM