Rob Nesta Email & Phone Number

Prospect, Ct, Us

Westport, Connecticut, United States

• Planned, Designed, Coded, Project Managed and Coordinated team to transition all Business Intelligence and reporting systems sourced from Legacy ERP system (Solomon) to source data from the NetSuite ERP system• Implemented automated notifcation for BI processing failures• Coordinated team to implement automated EDI (846) feeds and reporting for monthly inventory reconciliation• Various support, improvements, upgrades to existing BI reporting systems

Livonia, Michigan, United States

• Documented all existing BI and Reporting systems, worked with additional third party to begin the design of a consolidated data warehouse, reporting and BI solution at Mastronardi Produce• Project Managed, gathered requirements, coordinated contractors(on-site and remote), designed, coded and implemented the transition of all existing BI systems to integrate with the New ERP system being implemented at Mastronardi• Stabilized and improved accuracy of existing Business Intelligence environments. Implemented automated balancing processes to ensure data integrity daily.• Designed interfaces and supporting systems for the Consolidated Financial Reporting system• Provided break/fix and enhancement support for several existing business intelligence and reporting systems• Ran smaller projects to provide additional reporting/analytics capabilities• Deigned and coordinated the development and implementation of SSRS and Power BI reports that provided analytics sourced from multiple business systems• Implemented software version upgrades to all Business Intelligence software at Mastronardi

Trumbull, Ct

Senior Manager, Information & AnalyticsLead international team of subject matter experts (SMEs) in requirements gathering and design of global sales reporting system with Teradata RDBMS back end and Tableau / Datazen front end • Guided team that delivered systems for collection, enhancement, and reporting of electronic point-of-sale (ePOS) data from major customers providing business community with cleansed, harmonized, and fully prepared data for reporting and analytics. • Headed development of analytics solution for collecting and reporting on shopper loyalty data for major customers, identifying synergies between products based on consumer buying patterns and providing key insights on product assortment and promotional activities.• Saved annual projected $600k – 1.2M by leading team that developed reporting suite, replacing contracted reporting services from external suppliers.• Maintained control of financial interests by managing annual project planning and budgeting.Technologies - Teradata, Tableau, SSRS, Datazen

Trumbull, Ct

Led IT / business relationship with customer development business community. Delivered software enhancements and process improvements aligned with annual business plans.• Coordinated systems implementation of business changes to disposal of unsaleable products, resulting in savings of $40M annually.• Held leadership role in data warehousing evaluation proof of concept (POC), enabling selection of Teradata as data warehouse for Unilever Global.• Participated in evaluation of data visualization tools, resulting in selection of Tableau as global tool for data visualization.

Trumbull Ct

Leadership role in multi-year business/systems consolidation projects. Supported sales reporting application suite and provided high quality service to business.• Managed team, oversaw design, development, and implementation of all changes made to sales reporting in support of annual business objectives.• Led integration of sales reporting of Foods USA and HPC USA, running projects to merge customer and product hierarchies and provide consolidated sales reporting, reducing headcount, costs, and support requirements approximately 40%.• Achieved 50 – 60% reduction in overheads by heading 3-year effort to consolidate all North American sales reporting to single platform (US Foods and HPC, US Ice Cream and Canadian Business).Technologies - Oracle RDBMS, Hyperion Essbase

Trumbull, Ct

Business Area Manager, Customer & Channel Development HPCManaged overall project delivery, design, and business user support for all applications considered part of IT customer development portfolio.• SAP integration – Customer Development Systems Lead: Led design and coordinated conversion of all CD system interfaces from legacy order management as part of larger project to move to SAP ERP order management.• Led project that transitioned 90% of customer development master data maintenance to web-based maintenance system, facilitating larger project to transition from mainframe-based systems to UNIX/Windows systems.• Guided project to build sales reporting system and data warehouse that provided foundation for warehousing all open order, invoice, and customer and product-related data at HPCUSA, facilitating future consolidation projects and cost savings.Technologies - Oracle RDBMS, Business Objects, VB, VBA, Power Builder

Trumbull, Ct

Managed support and enhancements to global trade promotion planning systems. Managed field sales force technology rollout and conducted business application development and support. Also participated in projects to implement executive information systems and integrate customer development systems for multiple US companies. Developed systems and performed analytics in support of category management.Technologies - Power Builder, Oracle, Nielsen Workstation & Syndicated Data, IRI Sales Analyzer. PC Operating Systems, UNIX

Trumbull Ct

Planned, designed, developed, and implemented migration of mainframe-based DB2/Metaphor database to Oracle/Nielsen workstation for invoice / shipments reporting. Participated in projects to implement payroll, purchasing, and fixed assets management systems.Technologies - COBOL, Mainframe OS 3270, MVS, JCL etc, VB, VBA, Oracle

Mba, Business Management, 3.9 Qpr

Bs, Business Management, 3.8 Qpr

As, Computer Science

3.8 QPR