APIs and Monitoring platform

Independent consultant for Information Technology, specializing in systems integration, process automation, workflow management, business intelligence, reporting, and dashboards. Cloud migration and cloud native application development, specializing in AWS but comfortable with Azure as well.

-Built various tools for restaurant operations and management of global operations-Built services for 3rd party integration into mobile and ordering applications using AWS API Gateway, Lambda (NodeJS) and DynamoDb and Kinesis-Built software that runs in restaurants to process and manage orders with Open API for POS integrations-Built Lighthouse (dashboard, customer service, analytics, and reporting) used by employees and customers to view orders, research and report issues, perform analytic, generate invoices, define billing rules, Quickbooks integrations.-Built CommandCenter (workflow, project management, and reporting tool) for tracking and onboarding new customers-Adhoc report generations and data processing to perform ETL from multiple services and API and aggregate to redshift for Tableau reporting.-Generate customer reports, track sales, workflow, customer service research and reporting, emails-Integrate existing POS systems into unified reporting database and expose information for reporting dashboards and customer service-.Net 4, MVC4, C#, HTML5, CSS3, jQuery, MSSQL, MySQL, Redshift, DynamoDB, AWS

-Built custom applications and integrations for HR activities with GreenHouse and SuccessFactors with reporting, notifications, imports, export, etc.

-Built workflow tool for creating/tracking/assigning appraisal requests and handling the entire appraisal workflow including bids review.-Built workflow tool for loan production tracking for multiple departments to process requests through all stages and integrate with existing core bank applications.-Built APIs and reporting systems to aggregate information from various bank vendors to allow for consolidated cross system reporting.-.NET C# MVC MSSQL IIS

-Built graphical HR dashboards to filter, drill, and export information-Built performance management system for employee assessments/evaluations-Built HR application for employee self administration of personal employee information-.NET 4, C#, ASP.NET, Silverlight 4, SQL Server 2008, SSRS, IIS7, WCF, ASHX, RIA Services, SAP Business One, Trimergo, Crystal Reports, SharePoint-Built a performance management system for employee self evaluations, manager reviews, and analytics-Build dynamic reporting solutions for SAP BO & Trimergo analytics-Build systems for workflow management, project status reporting and tracking, data cleanup/validation, expense entry and tracking, payroll management and reporting-Build productivity and collaboration tools for senior management

-Enhancements to existing software, integrations with vendors, reporting updates-Technology upgrades and migration from webforms to MVC-ASP.NET WebForms, MVC, MSSQL

-Consolidated core loan information using SQL/SSIS-Built processes for loading preconversion bank infromation-Built graphical Silverlight BI tool for daily loan reporting reporting with analytics, drill down, and export using ComponentOne charting tools-Built web forms ASP.net credit action tool for managing workflow, creating and tracking requests

-Built application to manage workflow and collect information related to patient orders and billing-Built Silverlight line of business applications for project status tracking and reporting-Migrated Oracle databases to SQL Server-Automate legacy reports from Dataline and Accpac

-Built ticket sync application using .NET 4 and web services with SQL backend.-Built front end to manage associations and view history and notes-Consumed Savvis and Numara Footprints web services to query and update separate systems

-Converting legacy Excel spreadsheet "applications" to iPad friendly web application.-Jobs to pull mainframe data to SQL Server-Custom mapping application displaying current and projected loads-Rating application to generate quotes

-ASP.NET, C#, VB, Oracle, Silverlight, jQuery-Build commercial applications for customers to process and collect payments, manage and sell documents.-Design and program SQL Server 2005/8 and Oracle 10/11g back-end relational databases-Code, test and maintain ASP.NET, Java, C#, VB.NET, VB6, and VBA software applications-Build dynamic reporting interfaces for mortgage, commercial, accounting/financial, appraisals, and loss mitigation departments-Build systems for tracking and managing workflows across departments-Streamlining various accounting processes for efficiency, accuracy, and accountability while implementing policies and guidelines-Design, implement, and automate ETL solutions and data warehousing-Identify requirements by establishing personal rapport, understand service requirements, design, develop and maintain applications and databases; evaluating client needs; analyzing requirements; developing software systems.-CondoCerts.com enhancements and updates from legacy Perl code to ASP.NET webforms then ASP.NET MVC3

-Built SQL Server database for healthcare patient management-Installed and configured production database-Utility to migrate existing Excel based dataset to normalized db

-Develop/maintain applications automating mainframe tasks in VB6 and VB.NET-Build relational database applications and reporting solutions using Access, SQL-Create ad-hoc reports using VB6, Access, Excel

-Designed SQL Server databases to fit customer needs as backend data source and created front-end applications using MS Access and Visual Basic 6-Created reports with MS Access and Crystal Reports, used T-SQL to automate data management through DTS packages and triggers-Developed and implement specific project plans for each customer that cover product and facility definition and requirements; application, script, database and reporting requirements; training requirements and schedules-Develop and test applications, scripts, databases and reports that satisfy the customer’s business requirements

-Created enhancements and performed maintenance to existing software applications using Visual Basic 6, VB.NET, and SQL Server 2000-Migrated existing VB6 applications to VB.NET-SQL stored procedures, views, functions, triggers, and transactions-Researched new development projects, designed proof of concepts, analyzed functionality and feasibility, implemented where appropriate-Designed Crystal Reports to interface with SQL Server and MS Access data

-Developed applications using MS Access and SQL Server 7.0/2000 as backend database and coded front-end Visual Basic 6, VB.NET, and VBA solutions-Migrated existing VB6 applications to VB.NET-Improved/analyzed database design methodology/structure as well as implemented relational database design, performed normalization, optimized execution strategies, and ported to the web-Created data mining applications and web crawlers to interface and connect old methods with new solutions allowing much more versatile use of acquired data and more simplified access-Automated report generation producing using Access Reports and Crystal Reports