Christopher Bartolone Email & Phone Number

Greater Los Angeles Area

• Support the CTO on the applications side of IT to implement, enhance, and document our internal applications to stay on top of business standards and current technology• Maintain, upgrade, and improve all internal applications which includes our trading systems, Charles River for equity and Bloomberg for high yield, our attribution reporting systems, Bloomberg for both equity and high yield, our customer relationship management system, Salesforce, our client reporting system, SS&C Vision FI, and our internal reporting systems which is built in house using Microsoft and Azure Technology• Direct tasks to groups of outsourced consultants which includes our application support, IT, and accounting department• Manage and participate, includes coding and testing, in the move of our trading system, Charles River, to SAAS and have previously participated in several version upgrades in the past• Create a transparent internal infrastructure in Azure Devops by documenting our standard conventions, preparing application wikis and Visio charts, checking in code to our repositories, releasing changes via pipelines, etc• Manage daily automation and reconciliation processes and fix any application issues or prioritize with IT, trade analysts, compliance, and back office• Utilize and understand a wide range of data including, but not all, performance, attribution metrics, position, transaction, broker, proxy, and commission to create in house reports built using T-SQL, Power BI, SSRS, Microsoft Excel with VBA, and Azure Power Automate• Transitioned our attribution system from Factset to our new attribution system, Bloomberg, which required reconciliation of KPI’s between systems and building out the new attribution reporting in Bloomberg via PREP and JMGR• Lead the data implementation into our newly designed website and built out an internal application using sharepoint that allows the end user to move data between our data store and the websites staging and production

Non Location Based

• Pitched to multiple organizations to find funding for an mapped based event locator• Coordinated with several programmers to build a working product• Assisted in building from the ground up all aspects of a data driven .NET website in VB.net using SQL Server 2012• Constructed a relational database to manage user logins, profiles, a messaging system, user inputs, and data integrity of user inputs• Used DML triggers to insert, update, and delete records• Set up scalar-valued functions in SQL Server to calculate columns• Integrated BLL layers to enforce business rules• Filled datasets to output information from BLL to form views, grid views, details views, and repeaters• Implemented the use of Google maps API v3 and display data sent to JavaScript via datasets• Utilized JavaScript and AJAX to create auto-populating text boxes and lists• Extracted XML data using DOM and XML Reader through API calls to Google, Yelp, and Eventful

Greater Los Angeles Area

• Discovered potential for improving processes and worked with management to build out and act as the Product Manager for the Midwest project management tool which supported over 800 employees• Attributed to a 30% increase in project completion time by working with first, second, and third level managers by providing specifically tailored tools used to manage nearly 15,000 projects yearly to various builds• Replaced manual processes with mechanization to save thousands of hours of tedious work• Solely developed full scale project management tool in SQL server, SSIS, and Excel VBA• Lead team by training with using SQL Server and assisting with transitioning over 50 separate MS Access databases to SQL Server• Mechanized the extraction and import of hundreds of data sources in different formats into SQL server using SSIS• Optimized the creations of query’s from large datasets using temp tables and user created functions• Both coded T-SQL and utilized Microsoft Query Designer in SSMS to create queries, views, stored procedures, functions, and temp tables• Programmed reports in Adobe ColdFusion Builder to display data from SQL Server on the internal company website• Processed change requests to update the Midwest portion of the Southeast Project Management tool using ColdFusion, JavaScript, T-SQL, HTML, and CSS• Set up and emailed alerts for errors within SQL Server Agent and SSIS• Created and maintained live reports and tools in MS Excel using VBA to link to SQL Server and MS Access• Constantly upgraded code and re-engineered systems to run more efficiently

Greater Chicago Area

• Programmed and utilized reports from Microsoft Access to forecast equipment costing nearly one hundred million dollars in yearly purchases and responsible for improving the Midwest to the best forecast accuracy for all regions and also led to all-time lows of inventory levels• Analyzed data to assist the budget group to make critical build decisions such as funding cuts and build deferrals• Redesigned and mechanized the reports on the Midwest Unit Cost and Work in Progress

Greater Chicago Area

• Researched, carried, and corrected reconciled items in bank statements such as checks and wires sent in error, deposits, transactions, dividend errors, etc.• Bought, sold, transferred, and created entries for treasury bills by working with bankers, management, and the Rolfe and Nolan system• Executed daily investment and redemption transactions and various projects associated with money market• Dealt with on average 40 million dollars in transactions for treasury bills as well as another 15 millions dollars in money market on a weekly basis