Portfolio
Arizona Public Service is the largest electric utility company in Arizona. With 4,000 MW of generating capacity, APS serves more than one million customers in 11 counties throughout most of the state, but mainly concentrated in northern and central Arizona. APS is one of the two major suppliers of electricity to the Phoenix metropolitan area.
CHALLENGE
APS needed to improve the up-time of their Advance Metering Infrastructure (AMI) and Meter Data Management (MDM) systems.
SOLUTION
To increase the availability of their key systems, Sona Data developed monitoring tools and alerting mechanisms, as well tuned up their terabyte database for optimal throughput. The tools we developed for APS have been utilized by various analytics and operations teams to optimize their efficiency to facilitate their customers.
TECHNOLOGY
Oracle, Microsoft .NET toolset, ASP.NET, SQL Server
Award-winning, Naya Energy, provides transparent insights into energy usage to save their clients money, time, and resources. Using innovative technology and collaboration, Naya Energy uses their expertise to bring environmental awareness and business efficiency to the forefront.
CHALLENGE
Naya Energy wanted to improve their development throughput. They had an efficient in-house development team but as the company grew, they needed enhanced production, and a trusted team to work with. Sona Data became an extended wing for development.
SOLUTION
With our customized technology solutions, Naya’s throughput increased and their business goals were achieved. We worked seamlessly with their product manager and architect to implement best-data-warehouse practices, optimization in database, and improvements in web systems. Now they can rely on us as an extended team which can expand and collapse in terms of resources as needed.
TECHNOLOGY
PHP, Amazon Aurora MySQL, Microsoft .NET
3rive provides a specific communication platform designed for the medical environment. Their services provide two-way communication between the medical provider and the patient via appointment reminders, referral programs, and educational emails, allowing the provider to keep tabs on their business, effortlessly.
CHALLENGE
3rive’s goal was to provide an educational and nurturing platform to help their clients with patient retention. With their growing business came a need for personalized software to maintain and enhance their business goals. Their platform was based on integrations with multiple PMS (Physician’s Management Systems) and they were facing issues in maintaining the quality and stability of the system.
SOLUTION
Sona Data’s solution included improving some components of the existing system, while replacing others completely. Initially, Sona Data worked as an extended development wing to their in-house developers, but eventually 3rive management saw more consistency and stability in our team, and decided to hand over the full development project to Sona Data. Five years later, Sona Data continue to work with 3rive’s sales and marketing team to improve and enhance their systems.
TECHNOLOGY
PHP, Python, MySQL, Microsoft .NET, SqlLite
Power One Data executes leading-edge, global market penetration strategies for synergistic energy market solutions including solar energy and other solutions.
CHALLENGE
Power One Data (a smart meter vendor to Arizona Public Service) requested our services to create a software system to facilitate the installations, maintenance, and monitoring of their smart meters. APS used these meters to measure electricity usage for their residential customers.
SOLUTION
Sona Data developed web applications and data architecture to support their needs. Sona Data also developed a Power Outage Management system to proactively monitor and notify of possible outages. Sona Data also implemented remote firmware upgrades to 150,000 smart meters and successfully implemented it with APS.
TECHNOLOGY
ASP.NET, Microsoft SQL Server
Sonoran is a full-service maintenance company dedicated to serving owners and managers of commercial properties. Sonoran’s customers include individual investors, portfolio managers, institutional owners, developers, REITs, and corporate retailers.
CHALLENGE
Sonoran had a simple web application which catered to their needs successfully until their business expansion initiatives required additional resources and more advanced technology. They invited Sona Data to evaluate their processes and propose a solution to grow with their company.
SOLUTION
We prepared a technology-forward layout to best cater to their increased business needs. On approval, we develop an intuitive, user-friendly, and informative web-based application capable of functioning on both desktop browsers and tablets/smart phones. With support from the Sonoran team, Sona Data implemented the system successfully.
TECHNOLOGY
Angular, PHP Laravel, MySQL
OpenTech Alliance is a leader in automation and call-center services for the self-storage industry. They help storage owners work smarter by increasing productivity, profitability, and customer satisfaction with innovative technologies designed from the ground up.
CHALLENGE
With their business growing quickly, OpenTech Alliance was not able to support their end-customers in the same capacity as they were accustomed to. They needed a customer support portal to better communicate with their growing customer base and invited Sona Data to take on the project.
SOLUTION
Sona Data dialed into their needs and created a unique customer support portal that could co-exist with their Cisco phone system, to optimize and organize incoming calls with an easy-to-use dashboard. The dashboard shared lead ties, service times, and other variables for the agent and caller. The portal distributed calls to specific agents, could auto load customer details based on an incoming phone number, and provided predetermined scripts for the agents. Each aspect of the portal was created to allow the support admins to manage the portal with ease after the installation was complete. After successfully implementing the portal, OpenTech Alliance hired additional support agents and were able to effectively keep up with their customer demands.
TECHNOLOGY
Microsoft .NET, Silverlight
HipDash assisted business managers in making accurately informed decisions by visualizing the most critical areas of their business through thoughtfully designed and meaningful real-time metrics.
CHALLENGE
With a growing need for this type of service, HipDash wanted to enhance their services with the help of Sona Data for Infusionsoft (now known as Keap) users. HipDash’s goal was to create a one-stop, intelligent, dynamic, customizable, and actionable dashboard to assist business managers in achieving their business goals.
SOLUTION
Sona Data created a multi-phase development plan for HipDash including a web-based and mobile-responsive dashboard product. The first phase of the dashboard product would allow users to define filters, formulas, and other customizable variables, along with sharing histories and trends via charts and other visuals. The second phase allowed the dashboard to communicate with other sources like QuickBooks, Google Docs to cater to a variety of users. Furthermore, Sona Data introduced an indicator feature, allowing the user to view their data in various ways. Later, Sona Data facilitated customer integration needs, allowing customers to use this product seamlessly.
TECHNOLOGY
Microsoft .NET, ASP.NET, Angular, SQL Server
Firefuze provides a social media management tool, allowing a brand manager to post and track results for multiple social profiles on a single dashboard.
CHALLENGE
Firefuze wanted to give digital marketers a single place to manage their social media presence, so they tasked us with creating a social media management portal where users can connect their social media profiles, maintain their content and campaigns, respond to comments, and dive into campaign results.
SOLUTION
This multi-faceted project was equipped with several features, including auto-refreshing content from searches based on tags, users, and RSS feeds, a fully-functional scheduling mechanism to schedule and queue posts for future dates, an “engagement” aspect which gave users the ability to comment on, delete, like, etc. their submissions, and a dashboard which shared easy-to-read stats for users to view and improve campaign performance.
TECHNOLOGY
Microsoft .NET, Angular JS, SQL Server
CHALLENGE
Redirect Health did not have correct enrollment data for its 15K member base. The company suffered from a claims backlog of $2.3M and growing, with its average days to pay consistently above 60.
DI IN ACTION
We migrated Redirect Health’s data processing and claims processing tasks to a team of 9 DI personnel. We then implemented a “ZERO REPORT” exception handling process to ensure the company’s issues were resolved within 24 hours.
RESULTS
With the help of our DI services, Redirect Health boasts 5 consecutive months and counting of clean rosters input into its claims and medical records systems. We eliminated their claims backlog, and now all claims are current within 30 days.
CHALLENGE
Silvercreek’s office manager—a role critical to daily workflow—was at risk due to poor job satisfaction. The company’s strong customer service focus was misaligned with collections responsibilities. As a result, Silvercreek couldn’t hire competent personnel below $30/hour.
DI IN ACTION
We migrated AR, collections and claims processing to a team of 4 DI personnel including a supervisor with strong Dentrix experience. This took pressure off the office manager and increased job satisfaction.
RESULTS
With the help of our DI services, it became easier and cheaper to find and retain office managers, and we saw an accelerated rate of acquisition. We eliminated a 45-day claims backlog, which increased reimbursement rate from 89% to 95% (an annual profit boost of $350k per office).
CHALLENGE
Stenson Tamaddon worked with three outsourced staffing companies in Mexico, India, and the Philippines, with an average productivity rate of only 0.5 FTE. The company struggled with a 90-day fulfillment delay from sales to first action.
DI IN ACTION
We implemented a team of 5 DI personnel, and we subsequently grew Stenson Tamaddon’s productivity during the first month to 2.2x US FTE. We grew the DI team to 60 based on unit economics.
RESULTS
With the help of our DI services, Stenson Tamaddon cleared their fulfillment backlog in 6 weeks. Every implementation was completed in 24 hours. Topline sales grew from $367K to $1.2M in 4 months, and average productivity grew more than 3 months’ worth to 3.1x US FTE.
CHALLENGE
RP Capital had difficulty verifying premium subscriber data for its product, RP Marketplace. They struggled with inconsistency, as data feeds, reports and delivery dates for APIs from AppFolio and Buildium would change without notice.
DI IN ACTION
Created processes for sales, onboarding and monthly verification of data for 3 resources. Implemented exception handling process including escalation and feedback loops.
RESULTS
RP Marketplace scaled from 10 beta users to hundreds of properties with accurate data across 4 APIs and numerous
data sources. Premium users received curated monthly analytics with key
insights and recommendations. We reduced development expenses by $45K over 6
months.