C Sharp XAML VBA Developer with Accounting / Banking background
I have over 12 years of financial accounting experience in the banking industry including month end and year end consolidation, budgeting and forecasting, variance analysis and cost allocations.
I have proven background in Excel-based VBA to design, analyze, and deploy programs for finance industry. Extensive experience in implementing software user interface improvements based on client needs.
I am a highly skilled .NET Developer with experience in designing & developing user-friendly database-driven applications using Microsoft technologies such as C#, WPF, XAML, SQL Server and Windows Forms. My experience in patterns and practices like MVVM, PRISM etc helps in creating loosely coupled software which is easily testable and maintainable.
Following are some of the major projects I have undertaken:
Adap.TV Weekly Reporting tool [VBA, EXCEL]
This project involves automatically crunching millions of numbers on excel to build a dataset and splice it in bunch of ways. The program retrieves relevant data into a temporary storage from the csv data file and prepares the required reports. Report generation is fully customizable.
WINRT Accounting Application [C#, XAML, SQLite and MVVM Light]
Windows 8 Accounting application using C#, XAML, SQLite and MVVM Light
Hi-Octane Scorecard [VBA, EXCEL, OLAP CUBE]
Developed a Scorecard which compares all key measures including P&L, Balance Sheet, External and Internal Market data. The user can select a business unit and the application automatically loads the respective data and compares the same with prior year, budget and forecast figures. This scorecard gives a three dimensional view of the business by comparing actual with Budget/Forecast, Prior Year and the Best In Class numbers.
Weather Report[VBA, EXCEL, OLAP CUBE]
Developed a macro to prepare commentaries for the scorecards. This application automatically writes the variance analysis forcing the end user to explain the reasons rather than the variance. This was prepared as a reusable module and the same was used to prepare the commentary for other business submissions.
Report Designer [VBA, EXCEL, OLAP CUBE]
Developed a fully customizable report designer. The user has full control in designing the summaries of scorecards. The system stores data in an external file and in the Design Module the user can drag and drop the required rows and columns and design a summary in any format.
Budget De-risk Allocation Tool [VBA, EXCEL]
Budget De-risk Allocation Tool: This tool automatically allocates the De-risk numbers by month or by quarter or half year basis to all Business Units.
Chart of Accounts mapping tool for BI Implementation[VBA, EXCEL]
Developed a tool to create a consolidated Chart of Accounts. Chart of accounts from five different systems were consolidated using the mapping key and hyperlinks were created for easy navigation between the relationships created by the application.
Budget Cost allocation Tool [VBA, Excel]
Developed a Budget Pack in Excel to automatically allocate costs based on Head Count, Area, prior year ratio to the individual departments and then to the respective business segments. This system consolidates all information collected from the departments after considering internal allocations to arrive at the final Budget by P&L, Department and Segment.
Investor Relations Tool [VBA, Excel, Access]
Developed a system in excel with access database as backend to manage Investor Relations.
OBIE, OFSAA implementation [ORACLE]
Successfully completed the business requirement for Oracle OFSAA5.6 project for MIS Unit.
Global Markets MIS [Excel, VBA]
Developed a new MIS for Global Markets which includes product-wise revenue trends, top ten customers by product and various other analysis and trends
Global Markets Transactions Tracking [Access, VBA]
Re-engineered the ZMIS system for Global Markets, UAE to comply with the Equinox standards and developed the same for Bahrain, Qatar and Oman.
Budget Validation Tool [Excel, VBA]
Actively participated in the Budget 2006 process for MEPA, developed a system to track errors and validation checks in the GBS system (SCB Budget system).
Budget Validation Tool [Excel, VBA]
A package in MS-Excel supported with macros written in Visual Basic, used for the monthly Forecast & MIS reports. User can select any country or month and the system will load appropriate data including the monthly as well as year to date actuals, budget, and forecast, with variance analysis and commentary
You will find me to be a positive, motivated, and hard-working person who is keen to learn and contribute. My technical skills are combined with excellent communication skills that allow me to work effectively and positively and get along well with others.