Data Analyst Resume Profile
2.00/5 (Submit Your Rating)
NY
PROFESSIONAL EXPERIENCE:
Data Analyst / Financial Analyst
Confidential
- Coordinate scheduling and generation of weekly/monthly reports for the Associate Director, Director, VP of Enrollment Management, and other external and internal constituents.
- Familiarity with concepts such as cash flow, NPV, ROI, IRR,EPS,LIQUIDITY,RATIO ,EBITDA and other financial modeling
- perform analysis including cash flow and debt/equity, net present value and discounted cash flow analysis , interest rates on loan payment, determining future cash flows, forecasting future growth, IRR analysis
- Experience with macros, switchboard, import, export, extracting and merging match and unmatched records and audit data, mail merging etc.
- Update/change and evaluate effectiveness of current reports add new reports as needed troubleshoot issues related to data quality and integrity.
- Respond to all database needs especially as they relate to reporting, statistical information, and letter production.
- Analyzing cash flows using Excel , calculating leverage ratios, analyzing bond investment, all ratios, amortized loan, depreciation, leverage , forecasting future growth
- Researching property specific demographics and economic trends to support financial assumptions via internal programs and internet research
- Performed data manipulation and management using advanced Excel functions to consolidate reports from multiple sources, improving efficiency
Data Analyst/Financial Analyst
- Experience with Sales Force Reporting,Quickbooks accounting , MYOB, MS Excel and Access macros , VBA and Data Analysis, Reports
- Experience with basic financial and accounting analysis , creating and managing budgets ,income statement, balance sheet, cash flow statement etc.
- Experience with creating ,auditing reports, forms , query, switchboard, security with Ms access
- Experience with advance sql queries to retrieve data and analyze
- Creating from basic to advance form and reports publishing on the Sharepoint
- Worked with Excel advance functions and formulas to analyze and auditing reports
- Creating from basic to advance form using Ms Info Path and publishing on the sharepoint.
- Understanding of financial statement analysis, company valuation techniques discounted cash flow analysis, public company multiples,
- Experience with creating dashboard , financial data analysis etc
- Conducted resolution of incidents and problems to ensure requests are regularly updated and realistic resolution times are provided
- Experience with sql query , programming , views, store procedures, triggers, data extraction, Odbc connectivity etc
Data Analyst
- Analyzing cash flows using Excel , calculating leverage ratios, analyzing bond investment, profitability ratios
- Advanced use of Pivot Tables both on spreadsheet and created/adjusted programmatically solutions for application environment.
- Creating Prepare reports, studies, and documentation. Deliver presentations and lead meetings.
- Troubleshoot Developed company-wide database for human resources department, including forms, filters, reports,
- tables, and queries front end supported by MS-SQL Server.
- Support Design of user interfaces, forms and report , complex query and VBA coding development
- Developed reports in Excel using data extracts from Access enhanced with VBA automation.
