Stuart Barnes Email & Phone Number

Remote/Seattle

The Woodlands, Tx

• Serve as the Global Business Intelligence Manager for 1400+ Planning Analytics users.• Responsible for managing and maintaining the on premise physical and virtual servers responsible for providing the Planning Analytics environment.• Responsible for migration the on premise Planning Analytics environment to the IBM Cloud, including installing and configuring Secure Gateway and Cognos Command Center.• Development lead on Project Renaissance to rollout Planning Analytics as the enterprise wide forecasting, planning and consolidation tool for all of Huntsman.

The Woodlands, Texas

• Served as the Director of Financial Reporting for the Business Intelligence suite of products consisting of IBM Planning Analytics (formerly IBM Cognos TM1) and Oracle Essbase used by both McKesson Specialty Health and the USON Oncology Network.• Built data extractions from a variety of source systems including SAP ECC, SAP BW, PeopleSoft HR, PeopleSoft Financials, SalesForce, Beeline, Essbase, SharePoint and SQL Server using a combination of SSIS, automated data feeds, NuBridges, IBM Websphere, TM1 Turbo Integrator processes and manual data pulls / flat files.• Built automated processes to reconcile data and send alerts and notifications if there were any variances or discrepancies.• Built system monitoring and alert mechanisms to notify system administrators of any failed load process or system issues.• Built, maintained and enhanced applications related to Income Statement, Balance Sheet, Cashflow, Employee Compensation, Allocations, Opex/COS Reclass, Subledger detail, Customer/Material (COPA) profitability, Travel and Expense, Program and Labor Allocation, Capital Spend, Freight, etc.• Built and maintained dynamic reports leveraging TM1 Active Forms, Explorations, Quick Reports and Custom Reports.• Managed and maintained infrastructure (both virtual and physical) to support the client and server environments.• Worked closely with the users to gather requirements on new projects and then designed, prototyped, developed and tested the new applications.• Developed training materials and documentation and provided both one on one and group training sessions.

The Woodlands, Tx

• Serve as the Global TM1 Manager for 1500+ users in US, Europe and Asia.• Manage a team of two employees, one developer and one administrator to support the environment.• Support and manage 3 production and 2 development servers comprising 27 distinct applications across 8 functional domains.• Plan, design, implement and maintain business models using OLAP databases related to financial consolidation, inventory, sales, manufacturing, headcount, tax, fixed costs, budgeting, forecasting, long range planning, strategic planning and management reporting.• Follow the entire development lifecycle in creating adhoc and static reports for different groups, including gathering requirements, defining scope, creating and managing projects, building prototypes, implementation, testing, obtaining approvals/sign-off, migrating to production and providing post implementation support. • Work closely with users to design, develop and support enhanced reporting using graphical user interface tools such as Arcplan, TM1Web and IBM Cognos Executive Viewer, as well as standard and adhoc Excel reports using advanced VBA code.• Create customized reports to allow users to perform data mining through variance analysis and waterfall charts.• Compose SQL statements to extract data from an Oracle data warehouse to build multi-dimensional models consisting of cubes, dimensions, hierarchies, attributes, rules, processes, chores and applications.• Streamline existing processes and automate repetitive manual operations wherever possible.• Maintain thin client Citrix environment to mitigate network latency issues for remote users.• Perform testing of new software releases and patches and perform software updates on the servers.• Define, implement and maintain disaster recovery strategy and infrastructure, including building and maintaining UC4 jobs to migrate data each night, documenting recover procedure, providing annual SOX testing.

• Act as the primary system administrator and developer to support and enhance the Business Intelligence and Reporting systems for the Finance department. These systems include: IBM Cognos TM1 (OLAP reporting database), ArcPlan (web-reporting and interface tool) and +EDM (master data management tool).• Provide client support for over 150 US, Canadian and European based TM1 users including finance directors and VP’s, financial analysts and accounting and HR personnel. • Build and maintain rolling forecast, budget and strategic planning models. • Source, manipulate and upload data from several source systems using the TM1 Turbo Integrator tool. • Build back-end SQL queries to source data from SQL Server databases to upload into SAP and TM1.• Create DTS packages and scheduled jobs to load data into SQL Server databases and provide routine system backups and maintenance.• Implement and maintain security models in TM1 using cube, dimension, element, chore and process level security, as well as the cell security cubes using TM1 rules.• Write complex TM1 rules and feeders to provide additional reporting capabilities.• Built and maintain a complex economic profit allocation model to allocate out administrative costs to various groups depending on their revenue, headcount and other key drivers.• Built and maintain a complex cross company allocation model to create a cross company P&L where all revenue and expenses are shared between two groups so that a complete P&L can be generated for each cross company initiative.• Created a bonus smoothing model where employee bonuses are adjusted each month according to the company’s quarterly EBIT.• Optimize business models and TM1 rules and feeders to minimize memory usage and reduce response times.

• Worked as a Business Information Systems Administrator to support the production systems at RTI International.• Served as the primary administrator on the following systems: Deltek Costpoint (Project Ledger system), IBM Cognos TM1, IT Actuals (in-house Access database), Deltek Time and Expense, Management Information Request System (MIRS) (in-house Cognos Impromptu reporting system).• Served as the case manager for production issues and either work directly on the issue or assigned work orders to the appropriate groups and case managed the work. • Built complex Excel reports using extensive VBA coding and TM1 API functions.• Upgraded TM1 system from TM1 8.4.3 to TM1 8.4.5 and then later to TM1 9.0. • Built and maintained websites for IBM Cognos TM1 and several in-house applications. These webpage’s were built using Microsoft Visual Studio .Net and ASP.Net and used a back-end Access database.• Wrote SQL queries to populate database tables and staging databases to upload data into Costpoint and TM1.• Performed Quality Assurance testing on software upgrades, scripts and fixes before they were implemented into the production systems.• Created and updated detailed technical and user documentation for production systems. • Upgraded and patched production systems.

Alpharetta, Ga

• Provided detailed analysis of business processes and requirements to design the optimal database implementation.• Implemented custom IBM Cognos TM1 solutions and helped maintain existing TM1 implementations. • Created customized reports using Excel and extensive VBA macro code as well as created wed-based reports using TM1’s web interface.• Created detailed documentation for TM1 system including data-flow diagrams and maintenance procedures.• Provided customized user training on implemented systems.• Implemented and upgraded existing +EDM solutions (Enterprise Dimension Manager – MDM database software). This involved modeling and analysis to identify dimensions and then determine the optimal design for the members, attributes, collections, derived and direct hierarchies and relationships.• Implemented customized views, tables, triggers, procedures and functions in SQL Server. Have extensive experience with SQL cursors and recursive function and procedure calls.• Converted applications from Oracle PL/SQL code to SQL code