Jack Roberts Email & Phone Number

Charlotte, Nc, Us

Charlotte, Nc, Us

Charlotte, North Carolina, Us

Responsible for leading the technology initiatives that support Private Markets investment teams. Overseeing the development, implementation, and management of technology solutions that enhance investment processes, data management, and operational efficiencies. Managing external vendor integrations with internal platforms for private asset classes ranging from Fixed Income to Alternatives.Accomplishments:- Architected, developed, and deployed RMBS vendor API integration utilizing .NET 6 C# 10 Azure Functions - Constructed SharePoint-integrated Private Finance self-service reporting platform, utilizing the Microsoft Power BI platform and DAX (Data Analysis Expressions) query language integrated with Excel- Contributing to the modernization of the firms data ecosystem by migrating in-house applications to a cloud environment (Microsoft Azure). - Developed SQL queries to provide Power BI data models with key financial metrics contributing to the firm’s growing semantic layer. - Identification and reduction of significant technical debts associated with outdated reporting and asset analytics processes. - Cultivated strong relationships with Business and Operations personnel, identifying areas for improvement where my team could leverage our expanding technical expertise.- Utilizing Microsoft’s Power Platform to reduce operational overhead for support teams. Connecting Outlook with Azure Boards via Power Automate to streamline ticket intake and triage as part of our Agile process. - Established critical data interfaces between a third-party accounting platform and BlackRock Aladdin, automating daily cashflows and monthly valuations for private equity positions.

Charlotte, North Carolina, Us

Researching and implementing ETL processes to enhance materialization speeds/reliability, saving over 1,550 hours of processing time annually.Architecting and delivering Corporate Finance AUM reporting solutions.Developing Business Intelligence solutions (Microsoft PowerBI) to efficiently provide actionable insights in data to help business partners make well-informed decisions.

Charlotte, North Carolina, Us

Developing and deploying best-practice data warehouse solutions that support business reporting tasks. Optimizing SQL server queries to efficiently and effectively retrieve data for SSRS reports and investment management applications (Black Mountain Solutions).Architecting ETL solutions (Microsoft SQL Service Integration Services) for integration with internal applications.Overseeing production support tasks, and employing sound resolutions to business-facing applications/reports.

Charlotte, Nc, Us

Hickory, North Carolina, Us

Developed VB.NET web applications in conjunction with T-SQL stored procedures to automate the monitorization of production data. These web applications also perform statistical analysis on specific machines, tracking trends to predict future performance degradation. Engineered email alerts using SQL Server to inform senior engineers and quality personnel of the impending performance issues.Automated the production scheduling of indoor/outdoor fiber optic cables as well as scrap entry tasks with VBA, while using lean principles to lessen scrap created throughout the production process. These efforts also reduced labor costs by over twenty hours per week.Automated the collection and formatting of printable excel reports for morning production meetings using parameterized T-SQL stored procedures along with VBA.Established databases that store product specifications as well as accompanying VB.NET/DBMS web applications. These systems eliminated the need for paper product drawings, opening the door for the cross-platform usage of the information.

Atlanta, Ga, Us

Employed mechanical, communication, time management, and team-building skills as a member of a site-wide refinement team responsible for the rehabilitation of physical safety and fire prevention systems, as well as the construction of process improvement framework. Reconditioned visual hazard indication and fire prevention infrastructure in six separate functional areas, providing structure for inter-departmental applications of lean manufacturing principles, and accounted for over $13,000 in equipment which was organized for redistribution throughout the plant.