Nancy Roberts Email & Phone Number

Milwaukee, Wi, Us

Hanover, Md, Us

Providing data analysis-consulting services for the at Bimbo Bakeries. • Creating Power BI front-end visualizations for Bimbo Bakeries. • Supporting existing Power BI data model using Azure databricks utilizing standard Power BI M language and DAX formulas.• Data mine data warehouse and Azure databricks to understand critical tables and fields to optimize import performance.• Follow best ETL practices by separating the data layer from the visual layer.• Participating in Agile rituals.| Microsoft Power BI | Data Visualization | Azure Databricks | SQL |Star Schema | DAX | Dashboard Building | Data Analytics | KPI Dashboards | Data Modeling | Agile Methodologies | Supply Chain Management |

Hanover, Md, Us

Providing data analysis-consulting services for the Provider Team at Cencora (formerly AmerisourceBergen). • Creating Power BI front-end visualizations for Cencora (formerly AmerisourceBergen). • Supporting existing Power BI data model using Azure databricks utilizing standard Power BI M language and DAX formulas.• Data mine data warehouse and Azure databricks to understand critical tables and fields to optimize import performance.• Built Clinic Analytics Oncology data model and dashboard. • Follow best ETL practices by separating the data layer from the visual layer.• Participating in Agile rituals.| Microsoft Power BI | Data Visualization | Azure Databricks | SQL |Star Schema | DAX | Dashboard Building | Data Analytics | KPI Dashboards | Data Modeling | Agile Methodologies | Clinical Analytics |

Atlanta, Ga, Us

Providing data analysis-consulting services for the Provider Team at Cencora (formerly AmerisourceBergen). • Creating Power BI front-end visualizations for Cencora (formerly AmerisourceBergen). • Supporting existing Power BI data model using Azure databricks utilizing standard Power BI M language and DAX formulas.• Data mine data warehouse and Azure databricks to understand critical tables and fields to optimize import performance.• Built Clinic Analytics Oncology data model and dashboard. • Follow best ETL practices by separating the data layer from the visual layer.• Participating in Agile rituals.| Microsoft Power BI | Data Visualization | Azure Databricks | SQL |Star Schema | DAX | Dashboard Building | Data Analytics | KPI Dashboards | Data Modeling | Agile Methodologies | Clinical Analytics |

Chicago, Illinois, Us

Providing data analysis-consulting services for the IT department at Genus LLC. • Created data functional requirements for the global strategy stakeholders for Power BI dataset.| Microsoft Power BI | Data Analysis | Agile Methodologies | SQL |

Milwaukee, Wisconsin, Us

Security Compliance Power BI DashboardAutomated data extract; eliminating manual daily export, 1 labor hours per dayDeveloped data models and Endpoint Security Compliance reportsImproved Usability designCreated Visibility to Data refresh date/time and visual for file failures.Developed versioning model Technology Project Management OfficePartnered with teammate to develop project governance reporting for the Project Management Office Operations teamDeveloped 17 Power BI ReportsAutomated the existing PMO Operations ETL (Extract Transform Load)Eliminated manual time for PMO Operations team 4+ hours manual ETL time per weekReport refresh rate converted from weekly to Daily load Instrumental in the support of Power BI User GroupCo-Facilitator of Weekly Meetings to drive collaboration and socialization of Power BIDeveloped documentation of framework and best practicesCommunicate best practices to support enterprise governanceDeveloped and led Power BI 101 session for new users of the toolCollaborated across teams on development of the Fiserv Branded Power BI template to encourage adoption and standardizationRespond to Teams Activities/Posts and QuestionsAttended Microsoft Business Application Summit 2018| Power BI | Collaboration | Requirements Elicitation | Business requirements | Stakeholder Profile | Global business documentation | Functional design documentation | User Stories | Process flow diagrams | Data flow diagrams | SQL | Requirement specifications |

Zurich, Zurich, Ch

Providing business Business Analyst services for Carma Laboratories.| MS Office (Word, Excel, PowerPoint, Outlook) | Visio | ERP Microsoft Dynamics NAV |

Menlo Park, Ca, Us

Providing business data analyst services for Northwestern Mutual.Identifying opportunities to include Multi-Cultural Market Strategy targeted consultation in existing wholesaler and internal consultant reporting.Measure and report on targeted Multi-Cultural Market Strategy reps’ planning and sales results on a monthly basis (all HHLDs). | Data Analytics | Collaboration | Requirements Elicitation | Business Data Requirements | Netezza | Tableau | Toad | LeanKit | SQL | Agile |

Tampa, Fl, Us

Business Analyst providing IT support to Compliance, Audit, and Corporate Risk Management. | Collaboration | MS Office (Word, Excel, PowerPoint, Outlook) | Visio | Blueworks Live | BPM | SharePoint 2010 | SQL | Process Diagrams | Data Diagrams | Use Cases | Business Requirements Document | INNOTAS IT Project Portfolio Management |

Tampa, Fl, Us

Working on the conversion of the VB app to Java. | Project scope definition | Process flows | System diagrams | Mapping specifications | | Entity relationship diagram | Collaboration | Requirements Elicitation | Business requirements | | SDLC (Software Development Life Cycle) | screen mock-ups | Use Case documentation |

Menlo Park, Ca, Us

Project ManagerProviding Project Management consulting services to GENCO Pharmaceutical Services.Manage QlikView Business Intelligence software Project for rapid Implementation and Deployment. Impacting hundreds of internal and external users to improve user experience and performance. | Collaboration | Business Intelligence | MS Office (Word, Excel, PowerPoint, Outlook) | MS Visio | MS Project | Agile Project Management | Mariner | Toad |

Milwaukee, Wisconsin, Us

Global Business Analyst for integrated Front office application impacting 4,000 users. Bond Adapt integrated software utilized in 4 countries for order/assignment data to load to the Back Office Payroll/Billing system. As part of the Global Solutions Delivery team I had the great opportunity to work with some great people across the globe to build solid business enhancements. Translated business requirements into functional specifications for software solutions. | Collaboration | Business Requirements | MS Office (Word, Excel, PowerPoint, Outlook) | MS Visio | SDLC | SharePoint | Clarity Niku | Informatica | XML | Oracle SQL Developer | Software Implementation | Bond Adapt | Data Warehouse | Informatica |

Milwaukee, Wisconsin, Us

Business Analyst for North America JD Edwards back office application impacting 400 field offices. Worked on various aspect of JD Edwards from implementation of Payroll and Invoicing of application to Regression testing and Production Support. | Control-M job scheduler | IBM i-Series SQL | W-2 Year End Testing | SOX Compliance | Regression Testing |

Milwaukee, Wisconsin, Us

Coordinator for JDE Software Back Office Project. Oversaw on-boarding of up to 120 new project members. • Tracked project financials from Lawson through COGNOS Web Reporting.• (80-120 people) and acclimated the new member to Project with minimum downtime. • Due to the quick growth in the members it was not uncommon for new staff members to show up unannounced. • Reviewed and reconciled invoices prior to Project Director’s approval to identify discrepancies’ in the department budget. • Verified bank routing ACH numbers for franchises participating in JDE.| COGNOS | MS Excel | MS Project | MS Word | Lawson | MS PowerPoint | Scheduling |

Responsible for customer relations, daily processing and entering of orders, maintain customers file, increase clientele base for territory of Minnesota, North Dakota, South Dakota, and portions of Wisconsin.| MS Word | MS Excel |

- Maintain back office operation of Golf Pro Shops (Blackwolf Run & Whistling Straits) with $1.2million in retail sales including inventory management.- Implemented conversion from legacy paper process to Smyth Business Systems inventory. - ‎Merchandise Invoice Matching - ‎Open to Buy - ‎Physical Inventory. - Trained other Kohler Managers in Smyth Business Systems inventory software and established best business practices.- Created vendor reports based on inventory and sales analysis.- Consulted for the Woodlands operations in Houston, Texas with managing their Smyth Business Systems inventory software.Research and verify the payment status of invoices on AS/400| MS Word | MS Excel | Inventory Management | Report Analysis |

Supervised all operations of the $700,000/year Wauwatosa outlet and promoted to manage the Northridge location generating more than $1.5 million in annual sales.Responsibilities included:- Hire, train, schedule, supervise, and evaluate staff.- Interact with corporate buyers on quality assurance issues.- Serve on management team that developed and implemented the Assistant Manager evaluation program.- Exceeded sales goals by more than 5% during 1st year at Wilsons.- Company representative on Milwaukee Area Technical College Advisory Committee to evaluate academic programs for adherence to business needs.

Bachelor Of Science (B.S.)

Information Technology Project Management