Senior Business Analyst (MIS Executives-VBA Excel Macros developer) (Aug, 2011
–Feb, 2015) at Evalueserve Tech. Pvt. Ltd.
• Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concern Department.
• Developing numerous macros using VBA with Excel and MS Office Suites (Excel, PPT, Word, Access, Visio, Outlook and Internet explorer) to solve day to day activities of Business Analyst/Research/Associate/Executives /Manager/Group Manager and Upper management in globally.
• Developing various Excel tools, dashboards, pivot tables, financial reports, complex formulas, charts, templates and WebCrawler (web based) through VBA Excel Macros code.
• Responsible for all project lifecycle phases, from specifications, coding, testing, documentation, deployment and maintenance.
• To retrieve the data from SQL Server and MS Access for analysis (Using ADODB) and preparing final financial report or dashboard in client specific format.
• Analyzing raw data and provide the metrics and meaningful data to the stockholders and end users.
• Assisted with automation of finance department’s manual processes by writing VBA code and formulas to speed up the processes and maximize accuracy.
• Create various daily, weekly, monthly, quarterly and yearly reports.
• Automation of Internet Explorer (Newsletter, RSS, Web Crawlers, Fetching data from web sites).
• Analyze, redesign (Re-engineering) and maintenance of existing macros.