Rick Wargo Email & Phone Number

Architect and build control systems for regulating energy between EV charging, solar, and utility power.

As an independent consultant, I specialized in the application of leading-edge technologies and implementation processes to both low- and high-tech businesses.• Provided custom process optimization solution for a key business process, designed to minimize reporting execution and consumption time, and to increase accuracy.• Architected, developed, and delivered solutions for EV car charging and Solar Energy.• Created a Node.js development environment to support BDD of Amazon Alexa Skills authored in JavaScript and hosted locally for testing and in AWS Lambda for production with support for AWS DynamoDB, complete with test scripts and development and deployment tasks in gulp.• Developed a Ruby interface to county-specific property records information, hosting data in MySQL with analytics in R.• Developed a web-based application in Node.js, ExpressJS, Bootstrap, and Jade to pull QuickBooks Online data into a RedShift data warehouse.

Washington, Dc, Us

San Francisco, Ca, Us

Philadelphia, Pa, Us

The Philadelphia SQL Server User Group (PSSUG) is a charitable organization [501(c)(3)] that focuses on training and knowledge sharing for Microsoft SQL Server in the areas of Database Administration, Database Development, and Business Intelligence topics. PSSUG is an official chapter of the Professional Association of SQL Server (PASS).Responsibilities include:* Running the Business Intelligence sub-chapter* Assist in organization and running of the annual SQL Saturday Philadelphia meeting* Soliciting speakers and sponsors for the monthly events

West Conshohocken, Pa, Us

South Jordan, Ut, Us

Lead multiple high-performance teams of business systems analysts and data analysts that are an integral part of the audit team and are focused on improving auditor productivity and streamlining business processes through technology. The teams create maximum business value through collaboration, innovation, and process improvement. The teams also develop tools that facilitate advanced data mining and provide our auditors with a competitive advantage in the marketplace.Collaborate with the business to refine and support critical business metrics regarding inventory availability and exhaustion. Perform the duties of a system owner, having overall responsibility of the largest internal technology system.Maintain programming, data-mining/analytical, and SQL skills through hands-on experience with the development systems and medical claims data yielding in a solid understanding of our technology and information.

• Designed and implemented a web-based application in Ruby on Rails 3, MySQL, Oracle, and jQuery to provide real-time reporting and data entry for business-critical process monitoring with a rich, interactive user-experience. Created an object-oriented Domain-Specific Language (DSL) for specification of business logic.• Provided scrubbed and validated information for an online parts catalog using MS SQL Server, Ruby, and web-scraping technologies, creating processes that perform ten-times better than currently existing ones.• Assisted start-up companies design and implement their social media presence, including Facebook applications and SEO mentoring.• Coached small businesses in designing web sites using Drupal and Joomla, maximizing available resources with virtualization utilizing Microsoft Hyper-V R2, and evaluating and implementing appropriate open-source technologies for business use.

Conshohocken, Pa, Us

Responsible for design, development, and maintenance of Budgeting, Forecasting, Dashboarding and Reporting applications on MSSQL data warehouse and OLAP data store, utilizing MS Excel as the UI.

Specialized in the application of leading-edge technologies and implementation processes to both low- and high-tech businesses and startups.

Helped grow company from start-up to acquisition. Responsible for the cutting-edge technology created in-house to deliver highly customized information management systems to the legal market.

Csm

Electrical Engineering