Gary Cully, MBA, PMP, CPA

Senior Business Analyst / Project Manager

Technical Business Analysis • Business Process Improvement • Solution Design

Accomplished professional with proven record of managing and contributing to IT projects that exceed client expectations. Skilled in identifying and clarifying business requirements, performing gap analysis, designing data, process and system solutions. Strong interpersonal skills for facilitating decisions with stakeholders. Contribution areas:

Project Management Processes

Data Analysis

Data Modeling

Business Systems Analysis

Process Analysis & Solutions

KPI / Scorecard Reporting

Functional Specifications (FSD)

Agile / Scrum

SQL / Excel

Business Requirements (BRD)

BI / Data Warehousing

Enterprise Business Analysis

BUSINESSES

Wireless / Telecom • Software • Travel • Financial Services • Aerospace • Tech Manufacturing

• Games • Construction • Real Estate

Sr. IT Analyst and Project Manager Apr 2008 - present

Consultant

T-Mobile (client) Feb 2015 – Jul 2015

Sr Business Analyst, Corporate / Supply Chain Accounting

Developed and reviewed nearly 200 test scenarios for upcoming accounting system (SAP) enhancements. Applied queries using SAP GUI and Microsoft SQL Server for creation and validation of test scenarios. Project phase coming to a close in July 2015.

Microsoft (client) Jun 2014 – Dec 2014

Sr. Data Analyst, ASG Finance BI

Completed rollover / update for Excel financial and operational reporting (over 100 worksheets) that source data from SSAS tabular databases. Performed validation of new entitlement and usage data across ASG and MS Sales platforms. Leveraged Excel (query sets) and PowerPivot to build MDX queries that reduced query response times. Created data dictionaries on SSAS cubes for quick identification of data attributes and measures. Developed set of automated SQL queries for team to build data dictionaries across multiple databases.

Gates Foundation (client) Mar 2014 – May 2014

Sr. Business Analyst, Business Intelligence Team

Developed business / functional requirements documents for data extraction and reporting from data warehouses. Engaged with development / QA team and business users to put in place significant data model changes driven by new accounting system implementation. Quickly digested complex SQL queries to document data lineages (source to target) for multiple data feeds into and out of data warehouses.

Microsoft (client) May 2012 – Feb 2013

Sr. Data Analyst, MSCloud Business Intelligence Team

Contributor to implementation of MS Cloud data warehouse for performance / metrics reporting. SQL-based deliverables enabled client to evaluate growth and actual vs. target performance across Office 365, Dynamics CRM, Windows Azure and other offerings. Primary users were business analytics teams and their senior management. Work products entailed requirements analysis, determining new data relationships and implementing SQL code to meet requirements. Analysis included relational (OLTP) and dimensional (OLAP, cube) databases.

Notable Results

Implemented SQL extraction of cloud products revenue from MSSales platform into MSCloud data warehouse.

Delivered multiple fact / dimension tables for metrics reporting.

T-Mobile (client) Feb 2012 – Apr 2012

Sr. Functional Analyst, Customer Analytics

Engaged business users to determine data attribute and data model changes required for customer insight and campaign management data platforms. Developed source system analysis and functional requirements documentation. Evaluated complex business requirements documents. Created as-is and to-be artifacts such as workflow and data flow diagrams, logical data models and user stories. Employed Teradata metadata queries and Visio reverse engineering to determine as-is data models.

Getty Images (client) Sep 2011 – Jan 2012

Sr. Business Systems Analyst / Project Manager

Developed and conducted / facilitated business process improvement initiative (including data model changes) across 5 (five) enterprise business processes and resulted in painpoint / gap evaluations, business case justifications, prioritized business requirements.

Notable Results

Engaged SMEs in highly interactive group processes that increased enthusiasm for change and created buy-in for next steps.

Developed methodology that visually integrated data flow and workflow views for quick identification of painpoints / gaps and their corresponding costs and risks.

Delivered workflow / data flow analysis / data model packages that formed foundation for business and IT process improvements.

Starbucks Coffee Company (client) Feb 2011 – Sep 2011

Sr. Project Manager

Developed and deployed IT issue management process for the enterprise cost accounting group with responsibilities across all supply chain processes. To support Oracle ERP implementation, developed and managed agile / scrum issue tracking system that integrated defect descriptions, business requirements, business impact and blocking issues from various sources: Quality Center, Remedy, stabilization work logs, solution track meetings and superusers.

Notable Results

Launched issue tracking whiteboard and agile / scrum stand-up meetings, resulting in increased focus on business impact, accountability for follow up and resolving blocked issues.

Created weekly issue dashboard reporting, resulting in integrated view across multiple resolution work streams.

Documented business requirements for defect correction and enhancements, resulting in increased levels of effort from IT groups on cost accounting / supply chain issues.

Redbox / Coinstar (client) Nov 2010 – Jan 2011

Sr. BI Business / Functional Analyst

Developed and implemented MS SQL Server applications for updating sales data mart. Analyzed complex data models / structures and database applications. Implemented solutions (SQL and script workflows) to cleanse data anomalies for data warehousing and business intelligence applications.

Expedia (client) Jun 2010 – Nov 2010

Sr. Business Analyst / Data Analyst

Contributed to business and data model requirements for enterprise customer order management, billing system and ERP implementation on Oracle and MS SQL server platforms. Worked across business and IT groups to identify legacy and new data model attributes from multiple systems for implementation of new data models and solution platform. Deliverables included documentation for developing use cases, UAT plans and road map for end-to-end testing.

Notable Results

Created foundation for new logical data model on new solution platform.

Documented complex data relationships ranging from e-commerce and order management systems through backend accounting transactions and financial statements.

Microsoft (client) Jan 2010 – Apr 2010

Sr. Business Analyst

Created business intelligence implementation requirements (data, functional and operational) for Microsoft’s Entertainment and Devices group ($7.8B annual sales). One of three solution architects that created conceptual and logical data models for BI / data warehouse implementation. Deliverables also focused on designing KPIs and business metrics around customer insight and campaign effectiveness. Project scope included Xbox and Zune product and on-line businesses, Xbox Live, Windows Live, Games for Windows and Windows Mobile. Original 8-month project accelerated into 4-month delivery time.

Notable Results

Created foundation for implementing improved data models for enterprise BI data warehouse.

Developed data structure and functionality requirements for OLAP and data mining.

Produced deliverables that aligned BI / data warehouse with E&D business strategy.

Implemented documentation framework for traceability from E&D business processes through UAT design and implementation.

Getty Images (client) Apr 2009 – Nov 2009

Sr. Functional / Data Analyst

Collaborated with sales, e-commerce and infrastructure groups to support ETL process that created 10 million revenue-producing assets. Contributed to process improvement in enterprise data flows from portal input through e-commerce websites. Documented complex data model. Performed ETL of massive data sets across Oracle, MySQL and SQL Server platforms in UNIX and Windows environments. Created complex queries (10+ tables with 10+ criteria). Agile / Scrum team contributor. Performed UAT and results reporting.

Notable Results

Built scorecard reporting for ingestion process with focus on improving data quality and decreasing time to achieve asset ready-for-sale status.

Potential for $25M+ annual revenue increase from meeting target delivery times for 10M+ image ingestion and process documentation.

T-Mobile (client) Apr 2008 – Apr 2009

Sr. Business Systems Analyst

Performed discovery and verification of AMDOCS (industry-leading telecom CRM and billing system) data model for implementation of sales commission management system and related business intelligence tools. Scope affected 2,500 users and 20+ source systems (Amdocs and other systems).

Conducted interviews with technical and business team to document data models / flows from source systems through commission payments. Contributed to UAT and end-to-end testing as scenario creator, tester and analytical modeler. Recognized as subject matter expert on AMDOCS and related system data structures and flows regarding subscriber activities (activations, deactivations, migrations). Created complex Oracle and SQL Server queries (10+ tables and 10+ joins) to validate data structures and prepare data sources and targets for ETL process.

Notable Results

Designed and conducted timesaving process for analysis and documentation of Oracle PL/SQL code that resulted in discovery of deeply buried business rules regarding subscriber activations.

Recognized for high-quality business requirements and functional specification documents, including ERDs, use cases, ETL data mappings, test plans and cases.

Developed analytical tools for timesaving validation of UAT and end-to-end test results.

Sr. Business Analyst and Project Manager Jan 2005 – Apr 2008

Jefferson Wells International

Nintendo (client) Jun 2007 – Apr 2008

Sr. Business & Financial Analyst

Collaborated with Corporate Controller to develop roadmap for two (2) high visibility projects. Conducted revenue-recognition gap analysis between emergent GAAP standards and existing policies. Created significant update to revenue recognition policies for $1B in annual revenue for compliance with SABs 101, 104 and SOP 97-02. Performed IT system security gap analysis between COBIT best practices and existing policies and controls. Created IT system security policies and control requirements that closed gap.

Notable Results

Reduced risk of financial statement errors involving $1B in annual sales of hardware, software and support services.

Prevented unauthorized access to corporate data assets involving 500+ end-users across Novell, Windows and AS400 platforms.

KeyBank (client) Jan 2007 – Jun 2007

Project Manager / Sr. Business Process Analyst

Trusted advisor to Senior VP Operations in developing solution roadmap. Scope included analysis, re-design and documentation of core business processes generating $50M annual revenue.

Project crossed multiple systems from CRM and workflow management through financial reporting. Deliverables included gap analysis and remediation actions with regard to anti-money laundering (AML) reporting. Conducted weekly project status briefings to Senior VP Operations.

Notable Results

Deliverables included definitive responses to 75+ audit questions cross-referenced to risk-ranked internal control points to leverage resources into highest risk areas.

Process improvements created potential ($1.0M+) annual revenue increase.

JP Morgan Chase (client) Sep 2005 – Dec 2006

Project Manager / Sr. Business Systems Analyst

Developed project roadmap with VP Accounting Operations for integrating transaction processing and migrating databases for multiple acquired companies into corporate systems (GEAC and Documentum).

Facilitated JAD sessions and conducted interviews with key stakeholders to forge agreement on detailed requirements, scope and WBS definition. Conducted project team meetings and managed scope through multiple changes. Performed business process and data analysis, discovered and documented business requirements. Created business use cases, functional specifications; developed UAT plans, scenarios; documented UAT and integration test results.

Notable Results

Delivered project scope, touching 1000s of vendors and millions of transactions.

Achieved high-level of customer satisfaction and loyalty resulting in VP Accounting Operations volunteering to be “reference client” for firm’s professional services.

Boeing Technologies (client) Jun 2005 – Sep 2005

Sr. Business Process Analyst

Partnered with Finance Director of $100M division to plan and conduct controls design effectiveness and operational effectiveness testing regarding client’s technology investments. Performed gap analysis for compliance with SEC Fin 46 regarding reporting and assessment of off-balance sheet risks.

Notable Results

Completed SEC Fin 46 compliance review spanning 30+ private equity investment entities that prevented material misstatement in client’s SEC financial reporting.

Performed knowledge transfer to client for employing tool for analyzing $100M investment portfolio.

Weyerhaeuser (client) Jan 2005 – Jun 2005

Project Manager / Sr. Business Analyst

Drove process with Controller of Corporate IT Services and outsource vendor’s account managers to design project roadmap for audit of contract compliance and billings related to $150M annual IT outsourcing contract.

Demonstrated skills in interviewing senior business and technical leaders. Facilitated project team status and problem resolution meetings with client and outsource vendor. Conducted data structure analysis of vendor is billing system. Built data warehouse for deep drill-down to transaction details. Performed complex queries (10+ tables and 10+ joins), linking databases to Excel pivot tables tools.

Notable Results

Developed client’s business case for $30M+ cost recovery from outsource vendor.

Process improvements and data analysis tools created potential for $15M+ annual cost reduction.

Sr. Business Analyst and Project Manager Mar 2002 – Jan 2005

Protiviti / RHI

Nokia (client) Sep 2004 – Jan 2005

Sr. Business / Data Analyst

Created and managed transaction data warehouse ($1B transaction value), performed complex queries (10+ tables with 10+ joins), updates, extraction, analysis and error corrections. Became project’s subject matter expert on statistical sampling and complex data analysis. Discovered and remediated gaps in client’s order-to-cash cycle (inventory, shipments, billing, cash receipt and application).

Notable Results

Closed internal control gaps and reduced risks affecting $1B in annual revenue; prevented material misstatement in client’s public financial reporting.

Delivered primary data source and analytical tool set for resolving (and preventing) multi-million dollar disputes with clients (mainly AT&T Mobility).

Fisher Broadcasting (client) Jan 2004 – Sep 2004

Project Manager / Interim Controller

Trusted advisor to President of $120M business to implement KPI / scorecard reporting, improve internal controls and to prepare for SOX audit. Elicited requirements designed and constructed solution that extracted and loaded transaction data from client’s ERP system to data warehouse.

Notable Results

Initiated corporate performance metrics including monthly KPI / scorecard reporting, requiring no new IT investments.

Delivered potential for $10M+ in annual revenue increase from better capacity utilization.

AT&T Mobility (client) Mar 2002 – Dec 2003

Project Manager / Sr. Business Analyst

Collaborated with senior operations directors to determine project roadmap for audit of $2B construction contract (infrastructure build-out). Conducted multiple on-site audits, working closely with vendor’s senior management and other organization levels. Performed business process and data analysis. Implemented solution design centered on new data warehouse of 1M billing transactions for audit and data mining.

Notable Results

Created business case for $12M cost recovery from vendor.

Prevented potential $40M over charges ($2B contract value) by creating and implementing database audit tool and improving internal control processes.

PRIOR EXPERIENCE

Chief Financial Officer 2001 - 2002

Alerton Technologies, Redmond (Electronics Manufacturer)

Created corporate valuation model that formed foundation for advising owners to increase corporate valuation by $30M. Developed new supply chain contracts and channel partner distribution agreements. Set stage for multiple $1000s in profit improvement from supplier cost reductions and increased channel throughput from under-performing partners. Created proof-of-concept and platform for ERP system implementation to support profit improvement initiatives.

Chief Financial Officer / Chief Information Officer 1998 - 2001

RecordLab Corporation, Issaquah (Software Developer)

Trusted advisor to CEO in rising $8M in private equity investment; profit management; corporate valuation; capital restructuring; and merger and acquisition process. Project-managed MS Dynamics ERP implementation; managed accounting systems and SEC investor reporting. Directed supply chain operations; negotiated supplier and distribution contracts to reduce costs by multiple $1000s.

Sr Financial Manager and Technologist

Tektronix, Inc (Fortune 500 Electronics Manufacturer) 15 years

Finance Director, International Subsidiary

Financial Planning and Analysis Manager

Senior Programmer / Systems Analyst

EDUCATION & CERTIFICATION

MBA, Finance and Information Management

Portland State University

BA (with honors), Political Science, minors in Accounting and Statistics

Portland State University

Project Management Professional (PMP)

Project Management Institute

Certified Public Accountant, current license Washington State

Oracle Application Development / Database Administration Certificate

University of Washington

Data Warehousing and Business Intelligence Certificate

University of Washington

MS SQL Database Developer Certificate

Microsoft Certified Training Center

MS Business Intelligence Developer Certificate

Microsoft Certified Training Center

Certified ScrumMaster

ScrumAlliance

Total Quality Management (TQM) Boot Camp

Philip Crosby Associates

Certified Information Systems Auditor (CISA) exam completion

Languages: Spanish and Arabic

TOOLS PROFILE

Database: SQL Server, SSAS

Data Modeling, Business Requirements, Process Modeling: ERWin Modeler, Visio, Excel, PowerPivot

Project Management: MS Project, Excel, Visio

ETL, Integration, Analytics: SQL Server Integration, Analysis and Reporting Services; Excel PowerPivot

Development & Testing: SQL Server Management Studio, MS BI Development Studio, Test Director, Quality Center, Remedy

Programming / Scripting: SQL Server T-SQL

Accounting System: SAP

Contact this candidate