Financial Analyst And Data Platform Architect
CurrentFinancial analysis and reporting on all business lines, including profitability, ROI, attrition rates, transaction analysis, tracking of individual as well as pooled investments, asset monitoring, and cash flow. This includes data cleaning and reconciliation of raw reporting data from a third-party source to ensure the accuracy and standardization of disparate data portfolios in a simple to use yet sophisticated and dynamic database and web reporting platform of my design.Design and manage the development of the front and back-end infrastructure for providing a web-based platform including creating the design documentation for the development staff coding the platform, UI/UX, reporting, and financial analysis, including a monitoring system for rapid identification of poorly performing securitized investment pools and the ongoing purchases of investment assets which add new yield-bearing pools on an ongoing basis.Created a system for integrating disparate but critical reporting data into a standardized format across all business lines for rapid analysis and report building.Developed reconciliation reference process for integrating new data as it is added to SQL databases, including the identification of missing and/or erroneous data that requires correction or additional information.Special situations troubleshooting and investigation of data inconsistencies and inaccuracies critical to the business. This offers accuracy and uptime access to key financial metrics in order to monitor business investments.Managing and directing the development team members, prioritizing development queues, tasks, and workflow.