Patrick Hoban Email & Phone Number

Saint Paul, Mn, Us

Manage a team of highly skilled and talented Data Analysts and Data Scientists.

Saint Paul, Mn, Us

Lead for a team of 12 experienced data analysts, assist with project assignments and planning. Responsible for final review of work for accuracy and implementation.Collection, manipulation, transformation, interpretation and analysis of data from multiple SQL sources (Teradata, MS SQL Server, Oracle and Sharepoint).Utilize Alteryx to join and transform varied data sets for analysis and deliver data visualizations in Tableau.

Saint Paul, Mn, Us

Collection, manipulation, transformation, interpretation and analysis of data from multiple SQL sources (Teradata, MS SQL Server, Oracle and Sharepoint).Utilize Alteryx to join and transform varied data sets for analysis and deliver data visualizations in Tableau.Experienced user with LIS/ELMS, NetStudy 2.0, SSIS, MMIS, MAXIS and DEED systems.Led project to create SQL reporting database structure for NetStudy 2.0.

Minneapolis, Mn, Us

Client: Fortune 300 Business to Business Service Leader in Food and Energy Markets- Cleaned and assessed internal client data and compared with external marketplace data to identify key correlations using Jupyter (Python) and presented findings to client utilizing Microsoft Power BI. - Facilitated and led weekly meetings between international team and client. Managed weekly deliverables using agile and scrum project management methods. Led team to on time project delivery in role as Engagement Manager and Product Owner.- Utilized internal customer and external geographical, weather and population data to build a predictive model that calculates individual customer risk probability based on over 143 identified factors.Client: Hospitality and Gaming Industry- Analyzed direct marketing data and customer response rates using clustering to identify potential growth markets and appropriate incentives.- Utilized external census and online review data to run sentiment analysis and identify key business opportunities.- Selected to present recommendations to c-suite executives and board members, awarded 3rd place overall in live case competition.Client: Mall of America- Led team of 5 analysts to identify key opportunities for improvement in current employee staffing best practices. Utilized R and Tableau to created interactive dashboard visuals. - Awarded 2nd place overall by MOA senior staff, out of 20+ teams in live case competition.

San Francisco, Ca, Us

Program web applications using SQL, Python, Ruby and JavaScript.Led 4 person team through weekly projects with deadlines developed with agile workflow, TDD and daily stand-ups.

Minneapolis, Mn, Us

Description:Sr. BPC / Product Owner representing Social Compliance (SC), Product Safety & Quality Assurance (PSQA), and Global Trade (GTSP) business teams working on a project to replace the current network of custom EUC tools and reporting with a fully functional Metric Stream software platform solution.Achievements:- Received quarterly SVP award for the 'quietest' system launch in history. Following the successful completion of the Prospace replacement project and launch of JDA Space Planning.- Partnered with cross-functional team of business analysts (BAs), engineers and Subject Matter Experts (SMEs) map out the current end user reporting database structure and integrations. Documented requirements and communicated them out to the project team.- Led requirements gathering effort to define and document system security, visibility and workflow status with subject matter experts from GTSP, PSQA, and SC teams. Partnered cross-functionally to find similarities in process and reduce the number of business specific differences in requirements. Led meetings with Target Technology Services (TTS) analysts, engineers, Tata Consultancy Services (TCS), and Metric Stream partners to review scenarios and design an approach for system configuration aligned with client needs.- Successfully challenged TTS and TCS partners to better understand the workload implications of the solutions being proposed for user setup and system access. Collaborated with analyst and engineering partners to identify alternate options, gather data and weigh cost-benefits associated with each. Resulted in 2 additional user setup options that saved user workload and better aligned with company standards.- Led team growth in role as captain for fast, fun, and friendly committee. Created a new Halloween decorating contest event with a focus on opt in participation with 13 groups choosing to decorate and a little more than half of all MPSD division team members choosing to trick-or-treat.

Minneapolis, Mn, Us

Description:- Business Process Consultant (BPC) / Product Owner, representing Merchandise Presentation Division (MPD) business working with engineers and developers to decouple JDA Prospace software from custom built system integrations and upgrade to the latest JDA Space Planning software platform.Achievements:- Identified key product discrepancies in stage data conversion process. Logged defect, created change request (CR) and gathered key partners. Escalated the issue to leadership and formed focus groups. Defined requirements for additional reporting needs. Created reporting mockups to showcase reporting needs to technical partners. Resulted in savings of $70 million in lost inventory in the small 5% store pilot launch alone.- Drove requirement gathering for Business Rule Validations resulting in documentation of 123 validations to ensure data integrity was maintained during migration to the new IKB database.- Collaborated with Target Technology Services (TTS) and Tata Consultancy Service (TCS) partners on the creation and on-time approval of 18 functional specifications. Created a process to ensure user interface consistencies were documented across various functional specifications.- Estimated business workload impact for 113 different defects and CRs. Prioritized list of CRs and on-boarded business clients. Led project leaders through the proposed process. Narrowed list to top 23 fixes and gathered requirements. Created test plan and defined resource needs for 86 hours of stage testing. Completed testing on schedule. Able to avoid 15,000 hours of incremental annual business workload for MPD, 897,000 hours total across all teams, in exchange for only 2,700 hours of development effort.- Delivered project testing. Ran 750 test cases run in 3 different environments and logged 129 defects. Completed business user testing time study showing 30% overall reduction in time associated with functionality affected by Space Planning Project.

Minneapolis, Mn, Us

Description: - Responsible for providing Women’s Ready-to-Wear (RTW) & GO International fashion floor-plan layout and product placement direction to all 1760+ store teams. Partnered with Sr. Buyers, Merchants, In-Store Marketing (ISM), Designers and Business Analyst (BA) team members to outline rack goal buying plans and design aesthetically pleasing, cohesive floor layout designs using Visual Adjacency (VA) and CAD Microstation Tools.Achievements: - Led project innovation pilot roll-out for the Ready-To-Wear (RTW) team improving block-flow capture rate by 35% for stores and received the Apparel & Accessories (A&A) monthly team award.- Led apparel team through Merchandise Presentation Division (MPD) sharepoint pilot and LAN drive clean-up projects, provided essential feedback to larger MPD team and achieved successful on-time rollout for Apparel.- Collaborated with In-Store-Marketing (ISM), MPD analysts and Buyer captains to create and test a new ISM process which represents an annual cost savings opportunity of $165,000.- Concepted and drove implementation of the RTW Floor Flip test identifying a 3% seasonal sales shift that occurs between brands, a sales lift of $399,360 in the 60 test stores alone over the course of a 3 month period.- Piloted 2010 BME / BCE fabric buy business model for RTW. Developed MPD specific training and timing and action. After successful testing, rolled the new process out to all apparel teams in quarter 1 of 2011.- Mentored summer intern through fixture project, identified $685, 353 in cost savings and resulted in full-time offer.- Captained Wiki project for A&A, created the Visual Adjacency Best Practice wiki site.- Led complete overhaul of the A&A best practice material as captain of the VA Best Practice committee. Partnered with Operations Effectiveness team to rewrite the corresponding system knowledge assessment test.- Achieved Green Presentation scores on all 11 scored transitions published while in position.

Minneapolis, Mn, Us

Achievements:- Mentored two new business analysts providing developmental feedback to help both become successful in role.- Executed 6 different test concepts totaling $4,676,711 in increased sales and cost savings.- Analyzed info-retriever space to sales data for Desserts and Breakfast categories uncovering a potential opportunity to increase sales by $251,000.- Led team offsite creating a 'team development plan' updated quarterly to track progress, resulted in 23 different team wins.- Improved revision process for Dairy by creating a revision grid that details both Timing & Action and item changes by category. Resulted in reduced workload and personal recognition in the form of an annual division 'MPD Supra' award.- Established the Merchandise Presentation Division best practice for approving revision exceptions to ensure stores workload is balanced, leading to continued efficiency in on time revision sets.- Established grocery financial focus committee. Solicited feedback to understand team's current level of knowledge. As a result introduced recurring Presentation Manager financial sharing and scheduled monthly guest speakers. Facilitated 6 presenters to date.

Minneapolis, Mn, Us

- Executed new test initiative intercepting signing elements in the planogram room. Succeeded in identifying and implementing and improved process which has eliminated the need for sign flows and resulted in reduced workload for both merchandise presentation and in-store marketing teams.- Drove cross functional feedback sessions between Hardline goods A & C teams regarding Solutions Platform software as HLA Clustering Captain to generate valuable feedback to improve current processes and reduce workload. Received Team Value and Reliability award.- Partnered with merchant team to analyze turnover in specific markets and executed strategy prior to Holiday freeze. Resulted in lower inventory and improved turnover performance for department 094. Received Director's award.- Partnered with merchandise presentation analysts and store support as MPD revision captain to evaluate and approve appropriate revision changes. Researched and communicated upcoming revision workload to all stores in Weekly Workload Highlights allowing store teams to plan team member schedules, leading to continued efficiency in on time revision sets.- Assisted in training a September new hire, providing opportunities for growth included ownership of department 094 Cough Cold category which has resulted in increased confidence and performance abilities.- Supported store clustering pilot initiatives, partnered with Merchant and Planogram Optimization teams to expand store clustering tests forecasted to drive sales by providing optimal item assortment and availability to guests.- Managed Back to School (BTS) transition; owned and built the first BTS Flat to scale in Visio. Resulted in increased efficiency and decreased workload for the stores during the set. Delivered a Green Scorecard.- Effectively tailored floor wide email communications, as co-captain of the communication committee for United Way and helped MPD achieve it's division Giving Goal.

Master Of Science - Ms, Business Analytics

Web Development

B.A., Marketing

B.S., Economics

Education record