David Willett Email & Phone Number

Plymouth, Mn

• Defining, advising on, scoping of business intelligence needs and set-up business intelligence projects to support the company's key strategic and tactical decision-making.• Manage execution of business intelligence/market research needs by assessing and analyzing markets, customers and Abbott performance for key product lines globally.• Manage a team of Analyst responsible for: the execution of business intelligence research and market data analysis to support the company's key strategic and tactical decision-making• Establish BI tools: organization of data collection, storage and dissemination systems, which facilitates easy business intelligence access to the international and local management teams.• Identifying business intelligence gaps and recommending strategies to close those gaps. • Pro-active assessment of business intelligence/market research partnering with marketing management and executive team (marketing directors, sales management and executive management)• Proposing market data research including advise on methodology and obtaining budget agreements for agreed projects• Transforming a range of data into strategic knowledge and intelligence for use and decision making within the organization• Distilling complex issues into critical components to ensure clear and concise messages• Quantitative market information by major product line and geographies/countries including current market size, market dynamics and Abbott performance. Key financial data covers volume, revenue, pricing, and market share.• Customer and hospital information for major product lines and therapies for the international geography with direct Abbott operations. Customer analysis supporting product and program development. Allow customer segmentation to steer product positioning and account targeting, and for tracking effectiveness of marketing and sales programs.

Plymouth, Mn

Team Lead – BI IntelligenceProvide oversight and direction in the creation of a robust, sustainable data warehouse architecture which supports Mosaic’s information requirements and provide for needed expansion. Coordinate with various Mosaic business and technical groups to build data warehouses. Ensure Mosaic IT standards for technology and development practices are adhered to.•Responsible for supervising the day to day project activities of the Mosaic BI team and provide subject matter expertise in the areas of information delivery, which includes providing solution alternatives and estimates, gathering and interpreting of requirements, designing, documenting and delivering solutions. •Direct a team of six internal Mosaic employees and based on project requirements, leading the staff augmentation of external consultants.•Manage analytic reporting projects for Finance, Sales, Supply Chain and Operations groups.•Work with business partners to gather and refine requirements. Build a Business Cases and develop ROI for the projects which considers both hard and soft dollars.•Manage production support team, either assigning minor production fixes or enhancements to the support team or converting larger requests into development projects.•Strengthen internal procedures to improve quality and accountability. •Ensure that project and development standards are adhered to and the technical designs meet corporate standards. •Team development through training, team meetings, one on one meetings and peer reviews.•Conduct employee performance reviews.

SAP BI / BOBJ Developer •Lead internal BI / Business Objects developer working with independent consultants•Responsible for complete projects. Implement numerous reporting projects for Sales, Finance, Quality, and Manufacturing areas.•Managing ongoing end user support for existing solutions. •Technical expertise in the following areas: BI Front End Development•Business Objects Reporting tools XI 3.1 Universe Designer Web Intelligence Explorer•Complex Query design, BEx workbooks, Web Application Designer •Netweaver Portal with Visual Composer •Global Restricted and Calculated Key Figure definition•Variable creation•Job broadcasting •Performance tuningBW Backend Development•PSA, Transfer Rules, Transformations, Data Storage Objects, Cubes, Multi Providers•Process Chains•Transporting Objects •Source Connections, BI Content Activation, BW Run Statistics

•Managed a team of four individuals which was responsible for the development and maintenance of Deloitte Services LP financial reports with SAP BW/BI•Assigned projects to and coordinated with an offshore development team •Synthesized resource plans and assignments ensuring full utilization of the team•Fostered individual motivation, supported performance management, scheduled and tracked project tasks and ensured cross-training of department resources•Developed estimates and plans for projects and reviewed technical designs submitted by the team•Responsible the development of multiple simultaneous projects of various sizes •Assisted business product owners with indentifying and scoping future projects•Analyzed business requirements of new projects to ensure alignment with existing business applications • Proposed alternative solutions for data, processes, user interfaces, infrastructure, tools and testing• Outlined testing scenarios to validate an application’s functionality and integrity •Ensured firm standards, procedures, and methodologies in the development life cycle were followed•Conducted code reviews to guarantee that all solutions met predefined architectural specifications•Approver of project schedules, tasks and estimates•Responsible for communicating status of both production and project development to management

•Senior Developer for SAP BI (3.5 and 7.0 ) reporting projects•Managed multiple projects through complete lifecycles•Represented the reporting development role during requirements gathering phases•Recommended different development options and challenges to Management•Developed proof of concepts for new projects and wrote technical specifications •Conducted report development using SAP’s BI tools (Query Designer, BEx, Web Application Designer)• Coordinated cross functional team activities•Created and executed test plans, arranged user testing, and provided production support / training Major ProjectsExecutive Operations Dashboard; Internal ITS Project Reporting; Finance and Organizational Management BI Upgrade from 3.5 to 7.0 (NetWeaver 2004s)

• Developed a software application in Visual Basic which used a SQL Server database assisted in mandatory SEC reporting. The application made extensive use of stored procedures, class modules, and crystal reports• Assisted in the development of a corporate action and pricing application

Education record

Associate'S Degree, Computer Science