Enabling a complete human resource data cycle
Stanley Consultants employed Amy to collaborate with their Systems Analyst to resolve a critical human resources data issue. Previously, applicant and employee data were stored in separate, siloed systems, preventing seamless integration.
By shadowing the HR manager, Amy identified that unique applicant IDs could bridge the two datasets. She proposed adding a custom field in the employee database to store applicant IDs, effectively linking the systems. This breakthrough enabled a full-cycle dataset, unlocking valuable insights into hiring and retention trends.
With the data fully integrated, Amy worked with operations and HR executives to establish best practices and standardize turnover and retention reporting. This ensured consistency, long-term usability, and compliance efficiency. Her solution streamlined affirmative action reporting, saving managers an estimated 40 hours per month, while also providing deeper workforce insights to drive strategic decisions.
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.