Andy David Email & Phone Number

Providence, Rhode Island, United States

Marlborough, Ma, Us

Marlborough, Ma, Us

Framingham, Ma, Us

Lead a team of 30 managers, business analysts, BI developers, trainers and support analysts dedicated to enterprise business intelligence and data warehousing programs. Team develops and supports applications in MicroStrategy, Tableau, SQL Server, DB2, Teradata, Essbase, Hyperion Financial Reports, VBA, and Alteryx.Current infrastructure produces over 20,000 reports and hundreds of dashboards per week that are published to executives, corporate management, analysts, field management, stores and contract customers. MicroStrategy environment has 4,000 direct interactive users and over 50,000 recipients of reports.Led initiative to drive self-service BI, and transformed team to become the Center of Excellence for the new technology. This increased the number of BI developers supported by team from 20 to 200.Created an innovation culture with monthly hackathons that are rarely seen outside IT organizations. Developed the first internal mobile app at Staples that drove additional mobile BI apps and set the infrastructure needs for many other apps.Established Data Governance at Staples. Garnered support top-down and bottom-up, and made significant cultural changes. Developed the first corporate data dictionary at Staples and initiated the creation of a Data Quality team in IT.Developed onshore/offshore model with partner to expand capacity and to bring in specific skills when needed. Team ranges in size from 2 – 20 depending on current project demands.Manage software and professional services vendor relationships with contracts totaling $3M annually.

Framingham, Ma, Us

Directed all requirements gathering, data analysis and documentation for enterprise BI projects.Drove the customer and sales rep reporting and analytic requirements for the integration of a $4 billion acquisition. Ensured that customers did not lose insight to their purchases as they were transitioned from the Corporate Express to Staples ordering platforms.Evolved financial planning solutions to align with changing business needs. Retired Cognos Planning, and led development of Essbase solution. This cut the hours spent by users in creating budgets in half, and reduced budget consolidation times from 4 hours to 20 minutes.Directed the expansion of the Oracle Essbase environment from 4 cubes to 15 cubes, now supporting key analytic solutions within ecommerce and financial services.Created standard BI discovery, define, design, develop, support processes that work for the business and still ensure appropriate stability.

Framingham, Ma, Us

Took on ownership of corporate budget and forecast systems. Managed full life-cycle development and support of enterprise performance management solutions based on the Oracle Essbase platform. Reduced systemic month-end forecast process time from 8 hours to 2 hours.

Full sales, management, and operations responsibility for business intelligence consulting firm with 4 staff members. Firm provided rapid-development, robust solutions that required little IT support to maintain.Defined, designed, developed & managed application and database development projects from beginning to end always coming in on schedule and on budget. Applications included reporting systems, task management systems, statistical modeling systems, and analytic interface systems.Utilized both business and technical skills to create high-level vision of applications prior to requirements development. Acted as Project Manager for major system development projects with other vendors on behalf of clients.Full responsibility for projects supporting all aspects of business including Marketing, Merchandising, Inventory Control, Strategy, Store Operations, Sales & Promo, Accounting, Customer Service, and Ecommerce.Provided analytical support to many business units and functional areas.Managed maintenance of applications on a daily, weekly, or monthly basis, and created updates as needed due to growth.

Providence, Rhode Island, Us

Large Retail / Online Client – Decision Support System*Implemented a Merchandising Promotion system to set up, report and analyze the effectiveness of offers. *Managed the development of a Decision Support System for the new .com business unit. *Developed a customer acquisition and sales model used to forecast sales and help form strategies for acquiring new customers.*Implemented a Marketing Promotion system to set up, report and analyze the effectiveness of offers.Large Jewelry Client – Process Flow Definition, Inventory Control and System Selection*Documented all operational processes and analyzed process flow to determine inefficiencies.*Determined capability of existing ERP system and defined requirements for new system. Designed software selection process and created rating templates.*Simplified inventory transaction process for work-in-process by removing duplicate manual processes.Mid-Size Manufacturer – Plant Layout*Designed full plant layout for giftware manufacturer relocating from 3 buildings into 1.*Created high-level material flow, along with detailed locations of all equipment.

Framingham, Ma, Us

Managed Finance and IS resources to create company-wide database system for monthly calculation, reporting and analysis of 250 financial and operational measures at store level. Evaluated software packages to support system functionality and user requirements.Created financial and operational models for internal benchmarking of stores. Developed training manual and delivered twelve 3-hour training sessions to users. Defined user interfaces for a variety of users ranging from analysts to senior management.

Dallas, Tx, Us

Process and Cost/Benefit Analysis and Modeling – Major Airline Client*Developed proposal to win project that analyzed the financial impact of reservation call blocking. *Acted as client contact and project manager; led team to complete work uncovering $200+ million of value lost annually. *Identified potential “quick hit” and strategic long-term process improvements.*Performed detailed cost/benefit analysis for solution implementation. Customer, Market Sizing, and Investment Planning Analysis – Call Center Client*Developed financial and operational models for customer and market sizing forecasts. *Reviewed call center operations to identify gaps and develop solutions to enable strategic initiatives. *Performed financial analysis for a 5-year investment plan to grow company by $1.5B.*Developed several new service offerings by conducting market research, constructing models to determine business viability of offerings, and designing implementation plans.

Newport, Ri, Us

Prepared, submitted, and presented torpedo test procedures. Designed and developed a $10 million unique test cell with a team of 3 engineers.

Mba, Finance And Operations, With University Honors

Bachelor Of Science, Mechanical Engineering, Magna Cum Laude

High School