James Ryan Wilder Email & Phone Number

British Columbia, Canada

Rochester, Mn

Responsible for managing, configuring, reporting on, troubleshooting, and supporting RPU's Customer Information System (Cayenta) and Mobile Work Management System (MWM). Integrated Cayenta and MWM with 3rd party vendors including our payment processor, customer facing portal provider, Distributed energy resource management system, customer kiosk provider, and community assistance provider through API's and file-transfers encrypted both in transit and at rest. Worked with stakeholders, led the technical integration, and mentored junior teammates in Electric Vehicle Time of Use rate program, Distributed Energy Resource, Service Assured Water, and AMI smart metering programs. Created both ad-hoc custom reports utilizing MS SQL Studio, and user generated reports using IBM Cognos Analytics and Framework Manager to ensure accurate and consistent metrics across the billing and usage domains. Trained teammates and key account holders using agile methodologies on new processes and Cayenta best practices. Provided security updates, patching, monitoring, reporting, and troubleshooting of servers utilizing; VMware, Java, Microsoft Windows Server 2012/2016, Ubuntu Linux, Apache Tomcat, openPgp, Itron FCS & ISM, VS Code, Sublime, JavaScript, HTML5, MSSQL, Azure DataLakes & Pipelines, PowerBI, goAnywhere, planetPress, and MS Excel.Key Accomplishments: Provided the technical skills to establish a prototype process w/Three Rivers Community Services to distribute funds throughout utility companies to help families struggling w/bills due to Covid-19. This process ended up recovering almost $1m of payments in arrears for RPU and ended up assisting many families both inside and outside of the RPU family.

Rochester. Minnesota

Full Lifecycle Application Development.Met with stakeholders to gather requirements, turned requirements into code in test environments, tested code and verified stakeholder approval, installed code on production cloud-based systems, supported products. Led Scrums and Mentored junior developers. Tech Stack: JavaEE, JSP, SQL (DB2, mariaDb, PostGreSQL, MSSQL, Oracle), JavaScript, jQuery, Visual Studio, Html, CSS, Apache Tomcat, RapidBiz, Docker, HIPAA, regulatory compliance, agile methodologies.Key Accomplishments: Creating Apps for Mayo Clinic and ACCRU (Academic Community Cancer Research United) to manage regulatory compliance and streamline Cancer research trials.https://accru.org/about/testimonials/Created a role-based UAC (User Access Control) component which was later integrated into RapidBiz. https://www.vacava.com/rapidbiz/

Rochester, Mn

Key-holding manager of Barnes and Noble Chateau (Rochester, MN) responsible for the influx, outflow, merchandising, and promotion of various physical and digital products. Provided guidance to department leads and handled reviews, hiring, grievances, and disciplinary actions all in a kind and supportive manner. Most importantly I established relationships with internal stakeholders, external vendors/publishers/authors, and customers who were the absolute best especially at the Chateau Location in Rochester, MN which has a very diverse population of residents and visitors due to being the home of Mayo Clinic.Key Accomplishments: Surpassing sales goals consistently year after year (Due to an amazing Staff). in 2012 (I believe) right as the industry was starting to contract, we were #2 in the company for percentage over sales goal. In 2013, whereas the majority of stores had reduced sales goals, ours had increased almost two-fold. Even-so, we managed to surpass sales goals 9 of the 12 months for which I am incredibly proud of the team-mates I had the honor of working with and the customers which frequented our location.

Rochester, Mn

Tap to Home Broadband Installation and Network Setup. Installed broadband from the pole into the home and ran cabling (Cat5/Cat6/Ethernet) inside the home to support both wired and wireless networks. Setup and configured routers and security. Trained users/businesses on networks, security, email, and browsers. Provided world-class and award-winning customer service over a diverse demographic of customers.

Los Angeles, California

Consulted for fortune 500 companies on a variety of solutions development. Worked on the SQL Database backend of the Royal Bank of Canada's online trading platform. Migrated the ESPN domain email database from an Oracle Server in Florida to a MSSQL Server in Washington. Created Modules for SalesLogix for various business entities and although I am a bit Loathe to admit It, I also developed and deployed applications that tracked and automated ISP Domain-Name purchasing through ICANN and accredited resellers for venture capitalist groups. Tech Stack: Visual Studio, MSSQL, Oracle, Toad, SQuirreL, Visual Basic, C++, ADO, OleDB, YeD, Enterprise Architecture, SalesLogix.