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.

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.

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.

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.

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 |.

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.

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.

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.

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.

Bachelor Of Science (B.S.)

Information Technology Project Management