Banner Image

All Services

Business & Finance

Excel VBA,SQL,Access

Experience in building intelligent applications/templates in excel and VBA for company analysis,industry analysis,portfolio analysis,process improvements and efficiency enhancement. Integrating SQL programming with Excel VBA to fetch, process and present the data so that it can be used as an information for decision making. partial list of previously built applications: 1. Portfolio Analyzer: A tool (in Execl VBA) which analyses the portfolio performance, Indicates worst performers based on daily and monthly returns. Tool has facilities to prepare dynamic charts for performance visualization, prepare a report of the analysis and mail it to management. 2. Competitive capacity analysis for Airline industry: This tool(Using Excel VBA and Access) is used to automatically generate analysis regarding capacity of peer group as well as industry on given company's airline routes. Input included Raw periodic data of Airline companies extracted from https://www.diio.net/ 3. Management Reporting: A tool ( using Excel VBA and SQL) to fetch data for all the recent recommended valuations updating them as per the new recommendation files submitted by management, reflecting new valuations back to database, prepare an automatic report for the same and mailing it to management and intended clients.

About

$5/hr Ongoing

Download Resume

Experience in building intelligent applications/templates in excel and VBA for company analysis,industry analysis,portfolio analysis,process improvements and efficiency enhancement. Integrating SQL programming with Excel VBA to fetch, process and present the data so that it can be used as an information for decision making. partial list of previously built applications: 1. Portfolio Analyzer: A tool (in Execl VBA) which analyses the portfolio performance, Indicates worst performers based on daily and monthly returns. Tool has facilities to prepare dynamic charts for performance visualization, prepare a report of the analysis and mail it to management. 2. Competitive capacity analysis for Airline industry: This tool(Using Excel VBA and Access) is used to automatically generate analysis regarding capacity of peer group as well as industry on given company's airline routes. Input included Raw periodic data of Airline companies extracted from https://www.diio.net/ 3. Management Reporting: A tool ( using Excel VBA and SQL) to fetch data for all the recent recommended valuations updating them as per the new recommendation files submitted by management, reflecting new valuations back to database, prepare an automatic report for the same and mailing it to management and intended clients.

Skills & Expertise

AccessData VisualizationExcelSQLVBA

0 Reviews

This Freelancer has not received any feedback.