Chert Pellett Email & Phone Number

Lewisville, Tx, Us

Englewood, Colorado, Us

Solutions/Software Architect for the Safe Harbor Marinas project (1.4 million lines of code) for 6.5 years. Led teams in converting data from over 140 marinas, each with unique data and practices. Delivered a full reservation system with features like daily rentals, overbooking, pricing rules, inventory management, discounts, and more, completing the project in just 8 months, including the conversion of two legacy systems. Handled production support, solving complex issues across over 1.3 million lines of code. Conducted security audits on C#/VB.NET/SQL code. Led the conversion of 880K lines of VB.NET WinForms code to modern C#/Web/API. Supported and maintained continuous integration systems (TeamCity, Octopus, ADO/Azure pipelines).Deployed and managed SSRS reports, creating complex SQL (XML, Cross Apply, Dynamic SQL, PIVOT, tuning). Built a delayed deployment app for WinForms that scheduled app updates, ensuring smooth transitions between versions. Developed a branching and merging strategy in GitLab, enabling mandatory code reviews and controlled releases.Created CI/CD pipeline in Azure and also in Octopus and TeamCity, including Runbooks to populate non production systems with updated data and other tasksPerformed in-depth analysis of system requirements and data fields for conversion. Conducted deep database analysis to fix software or repair data issues, automating backup/restores and creating procedures to pull production data to UAT/QA while sanitizing it. Integrated and configured ADFS for role-based access using SQL Server data and JWT tokens. Created role-based permission handling that varied by marina, with minimal recoding of the API/Angular app.

Software Consulting in .net/C# over a long period handling many contracts, ranging from 2 months to over a year.

This company's assets and employees was acquired by CSG in 2020, as such I listed everything under that company that I did at either of them

Irving, Tx, Us

• Created Single sign on (SSO) and identity storage using Auth0, WinAPI 2.0, SendGrid, Visual Studio online, Mass transit, MimeKit, AutoFac, Async, REST, Cosmos DB, Enchilada, TopShelf, remote Azure debugging, X509 certificates over SOAP, Azure Key Vault, Nito, Angular JS, Plunker and Application Insights and others.• Built email processing system to process inbound emails using SendGrid, Azure, Mass Transit, Cosmos DB, and Service Bus. Received, queued, parsed, filtered, and re-mailed the messages. Handled entire domain’s email. Highly scalable design and technology.• Rapid learner of new tech: In 23 days learned 19 new technologies that I didn’t know• Technical leader for File and Serve: Texas, Illinois, and Indiana - Remote teams and local QA.• Using VSTS/Git helped to train team on Git, continuous integration and deployment. Handled code reviews, pull requests, builds/deployments.

Irving, Texas, Us

Leading architecture board Driving change in procedures and systems including:• Architected, implemented and deployed continuous integration / deployment solution using TFS• Assisted in getting our company to pass SSAE16 requirements, got certified• Created coding standards and best practices document for C# and SQL to improve reliability and performance of database and applications• Redesigned and recoded service rewards program to remove needless complexity and make it supportable• Designed solution to improve SQL to AS400 performance to be over 400 times faster.• SSRS/SSIS/ Reports, Jobs and Stored Procedures – Fixing defects and improving performance• Reduced time for a SQL query data by 99.995% that was timing out. Without code modifications or redeployment of application• Designed, and implemented C#/MVC web interface to Microsoft Service Manager using API allowing users to view and edit tickets, service requests and work orders• Fixed defects in C# and database apps in a rapid response, research, debug and fix cycle.• Hired, and trained and mentored engineers fresh from college bringing them up to the level of excellence - raising them to senior software engineers

Plano, Tx, Us

Designed, implemented Web UI and backend systems (MongoDB/MySQL) for www.orcsmustdie.com, a thread-safe, massively multi-user (1M+ users) high-performance platformDeveloped data simulator to load test databases and simulate game actions such as account creation, gameplay, and transaction logsArchitected and coded a leave-in profiler with only 8.1 us of overhead per call, including database I/O, enabling real-time profiling with web-based graph and chart visualizationBuilt a full analytics system to track and store statistics in MongoDB with minimal overhead, featuring 30+ graphs across 16 data categoriesDesigned MySQL queries for 350K+ transactions, bucketized by any time zone and time period, returning results in under 300ms.Implemented an error log query and filtering system with flexible date ranges and export options.Developed a generic query system for MongoDB/MySQL with support for complex nested queries, written in just 4 days, used by the CSR system to manage siteCreated a dynamic content system to manage in-game content like videos, images, and offers, assignable to various dashboard screensDesigned a store offer system, including internationalization, dynamic form controls, pricing in multiple currencies, and a drag-and-drop sales calendarImplemented server and client-side validation with complex conditions, and reusable popup selection for item managementBuilt a player data viewing systemDeveloped a web admin system for user editing, role management, and player event awardsWrote a popup dialog system using Bootstrap.js and AJAX, simplifying custom modals with HTML extensionsAutomated configuration file generation for multiple partners and deploymentsDesigned a game code redemption system for batch code generation and reward assignmentBuilt a player event award system to grant rewards based on in-game eventsRewrote deployment system to handle 2500 servers at onceCreated news/email template editing tools for in-game communications

Mclean, Va, Us

Maintaining Empower system in C# and MSSQL. Support of home loans division.Agile/SCRUM Training

Dallas, Texas, Us

C# / MSSQL/ .Net development.Short term contract.

Frisco, Texas, Us

• C# and Oracle• Working with client and other departments to maintain a high transaction rate system (1-11 million per day) with billions of rows in the tables. On call 24/7 for issues that could arise. • Performance tuning of Oracle queries, and API calls to maintain or SLA• Wrote custom queries to process things outside of automated system.• Created automated processes as needed to insure timely transfer of data.

Irvine, Ca, Us

Refactoring Javascript/JQuery/Fancybox based code to improve perfornace, reduce queries to server and streamline the entering of data into the system.Reduced page load time by 80% or more.Writing Stored procedures for MS SQL that would normally be assigned to a DBA.

Irving, Texas, Us

C#, VB.Net, and some old fashioned ASP development using TFS. Reskinning Websites using CSS. Porting apps to IIS7MS SQL Speed improvements (Improved report time from 5+ minutes to 50 to 200ms!)Using .Net versions 2.0 through 4.0, Linq, Entity Frameworks.

Fort Worth, Texas, Us

• Working in C# on threading, TCP/IP communication (made it run over 8,000 times faster than before I arrived)• Positive Train Control System o Designed and implemented permission-based Security system using encrypted database records and flexible reflection-based permissions. This allowed a permission to be added by simply adding it to the Permissions object, adding a custom attribute and using it in the code. The UI and database auto-adjusted for the new permission. o Maintained, and enhanced Socket based TCP/IP transport system. Improved performance by 600%. Stabilized code to remove disconnects, retransmissions and implemented auto reconnect system. o Ported several systems from existing systems into new codebase.• Systems configuration website o Took over a project with a massive number of exceptions, was able to quickly resolve those issues and work closely with QA to get the site stabilized and functional. o Aided with the implementation of the bug tracking system o Vehicle Checkout o Implemented screens to send commands to remote Vehicles and to verify commands from them.

Plano, Texas, Us

Working in VB.NET, Oracle, VB6 to VB.NET Conversion, ASP.Net

Dallas, Tx, Us

Production Break-fix teamWhen something breaks in anyone's code, they called me.• Directed build teams, regression testing team, and deployment team to resolve and release tickets.• Created documentation on procedures for resolving tickets.• Created documentation outlining procedures for building, testing and release of patches to production systems.• Verified production systems were correctly patched and systems were operating correctly.• Creative solutions to problems relating to processing financial transactions.• Tracked down problem with SQL Server updating returning data from one query as the result of the next. This was a critical problem that resulted in cross posting transactions. Problem involved connections, threading and C#’s implementation of using.• Tracked down login problems, billing issues, Voice Response system problems, database problems.• Found SQL configuration problem that DBAs missed.• Contributed to design for conversion to Perforce Version control.

Carrollton, Texas, Us

3-4 month project to rewrite of their customer management system.• Interfaced to Oracle, MySQL, MsSQL – all feeding into a single web page

Everett, Wa, Us

Consulting working in Delphi and C++

Mountain View, California, Us

Managed teams technical direction. • Worked with Product Management to create project requirements, designed, scheduled and implemented significant portions of 11 million line project. • Managed performance reviews.• Design and code reviews of all code checked in by team.• Designed systems, protocols and components.Technical Lead, Project Manager and Senior Staff Software Engineer – 9 ½ years. 4 years in a managing role• Interacted with nearly every department during the development and release.• Time estimates for team I lead were within 2% of actual times, completing ahead of schedule• Very low defect rates.• Released product on schedule, and $180K under budget.• Interacted with nearly every department during the development and release.• Developed automated testing platform that uncovered defects in our desktop version.TECHNICAL LEADER OF QUICKBOOKS, FIXED ASSET MANAGER• Managed a team to develop Quick Books’ Fixed Asset Manager product and managed project from the start, to finish.• Team worked normal hours during development and many people were able to take vacations, which were not originally planned. Came in two weeks ahead of schedule, and under budget.TECHNICAL LEADER OF LACERTE TAX FRAMEWORK GROUP• Led a team to develop and maintain the underlying object framework for Lacerte Tax.• Led project from the initial requirements through post release.• Code complete date was three-months earlier than in previous years - a first.• Product ship date was moved three-weeks sooner than any previous year, saving the company money on seasonal employees and improving our reputation for excellence.

Mountain View, California, Us

Consultant from ISI, working with Dupey during creation of RF picking system

Gb

Ames, Iowa, Us