Brent Barnes Email & Phone Number

Greater Atlanta Area

• Lead and develop a team of business analysts who support the enterprise investment data repository• Create and maintain data quality checks and ensure the delivery of timely and accurate reports and files• Maintain relationships with internal customers within Portfolio Management, Operations, Investment Accounting, Information Technology, and others to facilitate enhancements to processes and reports• SME for Commercial Mortgage system data and interface design• Manage workstreams associated with system implementations and upgrades• Oversee the documentation, development, and testing of system enhancements

Greater Atlanta Area

• Create and maintain detailed specifications for source system interfaces into Eagle Pace. • Implement new calculations and deploy configuration changes within Eagle Pace.• Designed and tested Blackrock Analytics interfaces into Eagle Pace.• Research, resolve, and document unexpected investment performance results in the data warehouse and data mart.• Provide production support for client investment teams.• Utilize Oracle PL/SQL client tools to research issues and to design and test changes.• Experience with interfaces and datasets from CADIS, Portia, and Viaduct in addition to index data suppliers such as AMEX, RIMES, and Factset.• Design new processes in Autosys as well as researching and resolving issues with existing processes.• Mentor less-experienced staff in SQL interpretation/construction and testing methodology.

Greater Atlanta Area

• Reconciled and corrected data feeds into Eagle Pace.• Created and executed detailed test plans utilizing complex SQL scripts and stored procedures.• Functioned as primary Data Management technical liaison with IT department.• Mentored junior staff in business analysis and testing techniques.

Greater Atlanta Area

• Tested fixed income and commercial mortgage interfaces into Eagle Pace.• Designed and tested complex changes in the investment reporting system, general ledger interface, and general ledger reconciliation system via the use of MS SQL Server scripts and corresponding extracts. • Developed Office-based reporting applications and interface processes.

Greater Atlanta Area

• Elicited requirements from users and developed Office-based management reporting applications.• Led the design and development of a large-scale financial reporting system.• Developed and maintained MS SQL Server DTS processes utilizing VB Script for extracting, cleansing, and loading source data.

Greater Atlanta Area

• Key accounting resource in the implementation of the SmartStream accounting system.• Designed and tested general ledger interfaces and created Cognos Powerplay BI/OLAP models.• Demonstrated Powerplay capabilities for senior executives including the Chairman of Assurant.

• Managed a group with responsibility for regulatory reporting including NAIC annual statement schedules and premium taxes.• Implemented significant reporting system enhancements which greatly increased productivity and data quality.