Cary Lapoint Email & Phone Number

Dallas, Tx, Us

I lead a small development team in a corporate IT department. Our development efforts (enterprise reporting, custom extensions, external system integrations, support utilities, etc.) are centered around a ERP system for the construction industry called CMiC, but we perform a variety of other functions as well.Languages/Tools: SQL, PL/SQL, Python, C, Jasper JRXML, Power Automate, Power BI, Toad, SQL*Plus, iReport, Oracle Forms/ReportsHighlights:• Developed 50+ database tables, views, and packages to support business-critical custom enterprise Jasper Reports.• Designed/developed 25+ new custom enterprise Jasper Reports and personally converted or managed the conversion of scores of existing custom enterprise Oracle Reports to Jasper Reports.• Profoundly enhanced data visualization and decision-making capabilities of senior management by developing 50+ database views for numerous Power BI and predictive analytics initiatives.• Designed/developed solution to generate payroll-based ADP tax files using database tables, views, and a package.• Designed/developed solution to import CMiC ERP markup data using an external database table, stored procedure, and Azure Power Automate Flow.• Researched API’s for integrations between CMiC ERP and multiple 3rd-party systems using Postman.• Developed license tracking solution for large (20+ database) hybrid Oracle/SQL Server Primavera ecosystem using Oracle Gateway for ODBC, Oracle PL/SQL, and Jasper Reports.• Publicly acknowledged for leading project to carry out compatibility modifications on 450+ custom Oracle Forms/Reports for major CMiC ERP upgrade.• Maintained/enhanced Dell Boomi-based integration between UKG/UltiPro HRIS and CMiC ERP systems.• Fundamentally improved/professionalized custom software module change management process by establishing SVN-based version control system and associated usage procedures.

In addition to being a student of tae kwon do at Team Chip, I served as an instructor, leading classes, mentoring students and assistant instructors, and helping senior instructors.

I functioned as a senior developer at Carrier Management Systems, Inc. (CMSI) located in Abilene, TX. CMSI provides hardware/software solutions for telephone companies - primarly small independents but a few larger carriers as well. CMSI's flagship NAMS Firefly product is designed to collect various types of telephone switch data (call records, billing records, SS7 messages, traffic reports, etc.), parse it, import it into an Oracle database, analyze it, and provide reporting, search and fraud detection capabilities.Languages/Tools: C, Oracle Pro*C and OCI, SQL, Oracle PL/SQL, Oracle Forms/Reports, Perl, sh/ksh/bash/csh/tcshHighlights:• Dramatically improved customer ability to provision facilities by developing Oracle PL/SQL-based solution to dynamically generate low-order polynomial regression call volume prediction models from historical data.• Reduced Oracle database call record storage requirements by 30% via table structure optimization derived from detailed analysis of customer call data profiles.• Provided company significant competitive advantage by developing Oracle database PL/SQL package to correlate SS7 ISR’s and SIP sessions with associated BAF/UMTS/SMDR/EMI call/billing records.• Disrupted call collection and analysis marketplace by developing Unix/Linux-based C program to construct novel SS7 ISUP Session Records (ISR)’s from associated ISUP messages.• Directly contributed to introduction of new company product/revenue stream by developing Unix/Linux-based C program for the real-time collection, analysis, and in-transit modification of SS7 ISUP messages.• Prevented unauthorized use and distribution of core components of company flagship product by designing/implementing sophisticated encrypted licensing system.• Transformed company flagship product into viable, modern, Unix/Linux-based solution by designing/implementing Oracle schema and developing 300+ Oracle Forms/Reports modules and 10+ Pro*C and multithreaded OCI C programs.

Summer job at the SSC Research Laboratory in Waxahachie, TX. At the laboratory I served as a research assistant working on the proton source for the collider and acquired some useful experience with big science.

Ph.D., Physics

B.S., Physics