Rose Cummins Email & Phone Number

Tracking of Sales, Trends, KPI, and Training for consumer and commercial electronicsStaff management and metrics reporting Creation of tools in Excel and Visual Basic for Application Business Intelligence Reporting using Visualization tools in Power BI and Microsoft ExcelPower query / MMultiple sourcesSecurity focusedCalculated columns, measures, and tablesPivot tablesCreation of Sales and KPI Data Model using data set extraction, transformation, load (ETL) from multiple sourcesData source connections: Microsoft SQL Server OLAP Multi-dimensional model “cube”  Tabular Data models Web/HTML scrape CSV XLSX filesQuery and markup languages: DAX MDX SQL M Dynamic Row level security controlled by Microsoft Active Directory groupsUser Experience development Advanced dynamic metric selection Report Automation by scheduled data source refreshPower Point Deck creationo Coalescing visualized data and key insightso Shared with multiple organizational level from direct supervisors to geographical regional managers in the Business management groups.Consulting work on security and DAX implementation inside of Power BICreation and maintenance of Version Control serviceo Initialization of on-premises GIT repositoryo Management and merging of multiple repository forks created team membersFrequent work with the 20+ members of our Data entry team o Identification of Quality Assurance problems Recommendations on how to fix problems and prevent in future data entry Development of efficiency and utilization metrics for Data entry teamHiring and Candidate interviewingTraining manager for Reporting teamo Teaching SQL for analysis to new memberso Teaching Power BI fundamentalso Teaching advanced use of MS Excelo Teaching the use of Version control systems (GIT)Consultation on MS Teams creation and managemento Sharing steps on document retention aligning with client policyo Managing access

Coaching and development of future leadership within a customer service oriented business.

Greater Salt Lake City Area

Greater Salt Lake City Area