SQL Database & VBA
Anupam Mandal
Business Analyst (Finance)
Mumbai
Summary
Thorough SQL Developer with expert grasp of SQL code generation, analytics, reporting and business intelligence. Diverse knowledge of complex T-SQL coding instances. Conversant in up-to-date and legacy programming languages, standards and tools. Adept in leading all stages of software development and troubleshooting.
Overview
11
11
years of professional experience
Work History
Senior Analyst
Trafigura Global Services Pvt Ltd
Mumbai
04.2018 - Current
- Performed complex financial and budget analyses to determine requirements and developed forecasting tools to analyze cost/income variances (Multidimensional Database - Infor BI & Power BI).
- Researched and compiled tailored monthly analytics and reports for Directors with Microsoft SQL Server databases & Business Intelligence (Cubes & Dimension).
- Designed and developed customized extract, transform and load (ETL) applications per LOB specifications from MS Dynamics environment.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment.
- Used analytical models and mathematical analysis to create and maintain key performance metrics.
- Developed several Excel macros to mitigate manual efforts. Released approx. 3.2 FTEs per year.
Senior Associate
BNP Paribas India Solutions Pvt Ltd
Mumbai
04.2016 - 04.2018
- Planned and led administration of management information system for achieving threshold-level performance.
- Reconciled accounts and reviewed expense data, etc.
- Investigated daily variances and corrected errors to resolve discrepancies.
- Prepared monthly reconciliation of bank accounts and took corrective actions on deviations.
- Verified accurate recordkeeping processes, reducing financial inconsistencies.
Analyst
JP Morgan Chase
Mumbai
04.2013 - 04.2016
- Entered financial information and payments to guarantee accurate and on-time payments for employees and vendors.
- Investigated daily variances and corrected errors to resolve discrepancies.
- Verified postings to ledgers to confirm accurate entry and account balances.
- Organized and carried out proactive month-end, quarterly and year-end processes.
- Reviewed and processed employee expense reports and vendor invoices for payment.
- Reduced financial discrepancies through transaction monitoring and management.
Education
Bachelor of Commerce - Banking And Insurance
University of Mumbai
Mumbai 06.2008 - 05.2012
Higher Secondary - Commerce
Maharashtra Board
Dalmia College 06.2006 - 05.2008
SSC - Commerce
Maharashtra Board
Mumbai 01.2006 - 06.2006
Skills
Trend forecasting & Budgeting
Business Intelligence Analysis
Financial Management
Database Management (SQL)
Accounting Workflow (SAP)
Custom Reporting (Excel Macro)
Software
BI & OLAP Database (Infor, Tableau & MS Power BI)
SAP
Interests
Photography
Travelling
Timeline
Senior Analyst
Trafigura Global Services Pvt Ltd
04.2018 - Current
Senior Associate
BNP Paribas India Solutions Pvt Ltd
04.2016 - 04.2018
Analyst
JP Morgan Chase
04.2013 - 04.2016
Bachelor of Commerce - Banking And Insurance
University of Mumbai
06.2008 - 05.2012
Higher Secondary - Commerce
Maharashtra Board
06.2006 - 05.2008
SSC - Commerce
Maharashtra Board
01.2006 - 06.2006