Financial Modeler,Financial Analyst,Excel Expert,Data Entry Expert,MBA
A Highly Skilled Financial Analyst & Excel Expert having an MBA major in Finance. Currently working with a financial advisory company where i am responsible for:
✔) Building Simple and Complex Financial Models Using Excel for Startup Businesses, Existing Private Companies and Public Listed companies
✔) Projecting financial statements based on assumptions provided by client/industry standards/historical trends
✔) Flexible Dashboard Development to control the whole model
✔) Highlighting micro & macro-economic changes that can significantly impact the profitability and other financial ratios of company
✔) Designing PowerPoint Presentations to support the models developed
✔) Other day to day tasks like financial statements conversion from PDF to Excel, Consolidating existing financial models
During my job tenure, I have developed financial models for Wholesale/Retail Store Business, PVC (Chemical) Manufacturing Company, Spinning Mill, Real Estate Construction/Sale/Rental and Bus Transportation Company
I have transformed large sets of data into meaningful and insightful information by using excel functions. I have more than 3 years of professional Experience in Advanced MS Excel. I have full command over MS Excel functions and features, can perform the following tasks with ease.
✔) Data Analysis (Sales, Financial, Marketing and HR Data Analysis)
✔) Dashboard Development
✔) Inserting Excel Formulas ( V-Lookup, H-Lookup, Simple Lookup, If Condition, Logical Tests, Sum-if, Count-if, Array, Index, IRR, NPV, PV, FV, Concatenation and many other functions )
✔) Inserting Pivot Tables
✔) Interactive Charts Development ( Bar Chart, Thermometer Chart, Speedometer Chart, Line chart, Pie Chart, Area Chart, Waterfall Chart and many Other as per requirement )
✔) Data Sorting, Splitting and Merging
✔) Duplicate Entries Removal and Highlighting
✔) Advanced data Filtration
✔) Macros Inserting
✔) Validating Data
✔) Locking and protecting cells
✔) Automating the excel sheet
✔) Use of Developer Tools
✔) Conditional Formatting
I am not limited to perform the above mention tasks, can perform many other complex tasks as well, through the combination of different functions in MS Excel.
I pursue problem solving & Analytical Skills, always try to find innovative solutions to problems that can be helpful in future as well, I am a quick learner have urge to learn new things, very good with numbers & numerical analysis, ability to find required data through internet research.
I am pleased to offer my help. Thank You!