Skills: UKG, Data Diagramming, Data Definitions, SQL, Cognos, Excel, Executive Engagement, Communication, Benchmarking, KPI’s
Enabling a complete human resource data cycle
Stanley Consultants employed Amy to work with the Systems Analyst and human resource leadership to solve their human resource data challenge. Previously, Stanley Consultants could not connect applicant and core employee data, as they were maintained on separate and siloed systems. After shadowing the human resource manager, Amy observed that every applicant had an applicant ID, which could serve as a unique identifier to connect the two datasets. The human resource manager could add a custom field to the employee side of the application and include the applicant ID, creating a data bridge between the two systems.
Working with the systems analyst, Amy delivered a comprehensive data set for full-scale reporting on Enterprise human resource trends. In addition to creating valuable data on retention and hiring trends, Amy was able to save human resource managers an estimated 40 hours per report for Affirmative Action requirements.
When the data was fully available, Amy collaborated with the Operations and Human Resources team to define a set of best practices and consistent data calculations for turnover and retention reporting.
Skills: Azure, SAP Hanna, JSON, Parquet, SQL, ERD Diagrams, Data Dictionary, User Access Management, PowerBI
Transforming a siloed data warehouse into an efficient tool
As part of a long-term consulting contract, Amy worked with Bii Consulting to inventory the massive data warehouse for Mosaic Co, a Fortune 500 fertilization producer.
Mosaic needed to optimize its data warehousing to facilitate networking between systems and lighten its heavy technical burden. Amy did extensive querying of the siloed database system to document redundancies and identify areas for cross-linking. Additionally, the documentation created through this process created the first Enterprise database dictionary, a pivotal tool for the data engineering team.
After working with the Bii Consulting team to test various data architectures, additional inventory was completed within the Mosaic Co PowerBI reporting library.
Impact Investing: Metrics to drive Foundational Giving
The Kenneth King Foundation is on a mission to transform lives through employment opportunities and entrepreneurship education. Amy worked with the leadership to redesign the foundation’s online digital presence. An improved user experience design helped prospective partners understand their best fit within the organization before meeting to begin funding approval.
The site educates others on the foundation’s work and has played a crucial role in enhancing impact investing in the Denver Metro area.
The work done to enhance the digital presence of the Kenneth King Foundation has helped facilitate the growth of impact investing in the Denver Metro area. Impact investing offers both monetary and societal gain, and this unique pathway for investment is gaining in popularity.
Skills: eCommerce, Marketing analytics, Google Analytics, Cyber Security, API, O Auth, server scaling, MailChimp, Trello
eCommerce: Securing and optimizing a growing environment
Healthy Hildegard hired Amy to develop eCommerce solutions. A series of online store environments were deployed and tested. Data was gathered to determine the most effective sales strategies, and the eCommerce process was then aligned with the optimal options to ease the management of processing sales.
As Healthy Hilegard quickly grew in popularity, Amy additionally helped scale the original website to accommodate the 10,000 monthly unique visitors. With the added traffic, security became a concern. Amy programmed settings to prevent fraudulent website logins. Additionally, she protected the payment gateway with a series of logic rules that automatically blacklisted any bots that tried to attack their payment processor.
Partnering with marketing, Amy worked with drip campaign data in order to optimize timing and digital content strategy. Analytics were used to define key customer demographics, optimize the timing of advertisements, and identify the benefit of adding a cart abandonment campaign.
More than GPS: Embracing data in asset tracking
Lat-Lon was adopting a new marketing campaign to embrace data analytics with its patented IoT tracking devices. Amy partnered with the head of marketing to create A/B testing for LinkedIn ads to increase sales of their B2B (business-to-business) asset management products.
In addition to doubling engagement in web content through thoughtful web design, Amy assisted sales by curating content to clearly define the business value of the asset tracking and software solutions provided for clients.
With her background in graphic design, Amy was able to create trade show designs and product manuals. Amy rebranded marketing materials for the companies they partnered with, including BSM Technologies and AT&T.
Lat-Lon benefited from having an adaptable IT generalist to manage a full-stack digital presence.
Customer Data Management & Scheduling Automation
Denver Dream Dog needed a solution to manage customer data but it was not large enough to be able to justify the cost of a traditional customer management application. Amy created a series of forms that integrated into the Denver Dream Dog website that gathered client data and automated scheduling. This system of forms simultaneously generated a back-end platform for the owner and her employees to search and manage records.
When Covid hit, Denver Dream Dog needed to make a sudden pivot. Amy quickly integrated an online scheduling platform that enabled online, Zoom based training sessions. Beyond Covid, this new feature has enabled Denver Dream Dog to reach a much wider client base and increase their revenue as a result.