Roy Gibson Email and Phone Number

• Analyzing performance data collected by the performance agents from Unix and Wintel servers. • Provide monthly reports as well as ad hoc reports from data collected.• Provide monthly Trending Reports on the performance and capacity for the systems (Servers, SAN, Network, Databases, Mainframe).• Provide design input and test new technical solutions to meet business requirements.• Create and run ad hoc queries against the database to collect and perform trend analysis.• Troubleshoot and resolve data extraction related issues.• Create and analyze reports for management decision making.• Create and maintain Capacity Standard Operating Procedures

• Administered the compliance database• Developed and maintain automated processes to identify sites not compliant with content governance standards and provide notification when appropriate• Identify processes that could be improved• Developed all the views, stored procedures, triggers and maintenance jobs to support the SQL applications

• Developed and Administer the quality assurance database• Identify processes that could be improved• Developed all the views, stored procedures, triggers and maintenance jobs to support the SQL applications• Developed and deployed the SSIS packages for performing ETL operations from OLEDB sources and load all data into the target tables• Managed Testing and Change Management• Created mail notifications using SSIS to alert management on data issues and sites not within content governance standards. Mail notifications were written in HTML• Participate in agile team meetings to discuss data requirements and the management of the data• Analyze all business reporting needs to provide the business with their customized reports• Created the stored procedures within Tableau to pull in data from the source tables which is used to display trend charts on the Tableau dashboard• Developed and enhanced the business reporting needs• Communicate to the business recommendations on data requests• Created dashboards in Tableau that showed business units not in compliance

ARGA Project:• Oversee all projects, application design, development, documentation, staff hiring and training.• Upgraded database from MySQL to Microsoft SQL 2012.• Developed all the views, stored procedures, triggers, etc.to support the SQL applications.• Use SSIS packages to port in all data into the tables. • Use Microsoft .ASPX to develop the website. • Use VBA to create an excel addin to allow users to extract data from the database.Samsung Project:• Oversee all database projects, database maintenance, system upgrades and performance tuning.• Designed, Developed and Implemented a screening tool using VBA to allow users to run queries and filter data from the Sybase database.• Designed, Developed and Implemented modeling tools which facilitated the collection, tracking, and manipulation of price and fundamental data.Credit Suisse Project:• Compiled system requirements and develop requirement specifications for the Equity and Fixed Income Department.• Coordinate with the global development team, LCD, SA, and research support for systems implementation.• Provided technical support on Equity Research and Fixed Income systems.• Performed Analysis on the Fixed Income, Compliance and Research System.Eight Partnership Project:• Designed, Developed and Implemented the Research and Production reporting tools. • Designed, Developed and Implemented the Excel Charting Tools using VBA.• Designed, Developed and Implemented the Word Table Tools using VBA.JI-Asia Project:• Designed, Developed and Implemented a multilingual “turnkey” Equity Research System platform.• Automated the Production Report process.• Assisted senior management with technology-related decision making.• Designed, Developed and Implemented the Chart Wizard, Report Templates and Word Tools using VBA.• Designed, Developed and Implemented the Production system using VBA

• Responsible for staff hiring and training.• Managed a team of 16 support and development staff in Asia.• Team lead for all Asia projects.• Adjust schedules for deliverables and work commitments based on resource availability.• Coordinate and manage customer relationships between clients, vendors, and stakeholders.• Implemented all global Research initiatives in Asia.• Implemented the Research Production and Distribution System is Asia.• Upgraded the Client Relationship Management System for all users in Asia.• Managed Testing and Change Management for the Asia region.• Implemented the Citrix VPN system and the Common Desktop Workstation.• Designed and Implemented the Disaster Recovery and business continuity plan.• Developed the Company Fundamental models (Industrial, Banks, REIT, Insurance).• Developed the Compliance Web Site using .ASP.• Developed the Quantitative Web site using .ASP.• Developed the Asset Management REIT Models and Database.• Developed the Corporate Finance Models and Database.• Developed and administered the Asia Database.• Developed the Morning Meeting Notes System.