# Laurence Gerard

> Senior Application Developer | RPA | ETL | Power Automate | SharePoint | Power Apps | Python | SQL Server | MS Access/VBA | Process Optimization

Location: Hillsborough, New Jersey, United States
Profile: https://flows.cv/laurencegerard

I am a seasoned IT professional with over 25 years of experience in driving innovation and efficiency across diverse industries. As a technical lead, I have most recently specialized in 𝐑𝐨𝐛𝐨𝐭𝐢𝐜 𝐏𝐫𝐨𝐜𝐞𝐬𝐬 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 (𝐑𝐏𝐀), 𝐄𝐓𝐋 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭, and legacy system migrations. My expertise extends to technologies such as 𝐏𝐲𝐭𝐡𝐨𝐧, 𝐒𝐐𝐋 𝐒𝐞𝐫𝐯𝐞𝐫, 𝐏𝐨𝐰𝐞𝐫 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐞, 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬, 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈, and other automation tools.  I have also consistently leveraged 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐀𝐜𝐜𝐞𝐬𝐬 and 𝐕𝐁𝐀 as invaluable tools throughout my career.

In my recent endeavors, I have made substantial contributions, including:
•  Engineering a cutting-edge purchase ordering system integrating Python, SQL Server Stored 
    Procedures, and Power Apps. This system revolutionizes the Supply Chain team's decision-making 
    process, ensuring optimal overseas container order selection. By balancing product rates of sale, 
    current inventory, warehouse capacity, and incoming orders, the implementation of this system is 
    forecasted to yield an annual cost saving of nearly $4,000,000 compared to domestic ordering costs. 
    Additionally, it streamlines operations by eliminating numerous worker hours previously spent on 
    manual processes.
•  Designing and implementing dozens of Robotic Process Automation (RPA) processes leveraging Power 
    Automate, SharePoint, MS Forms, Excel, and Power BI. These processes have successfully streamlined 
    and automated obsolete, repetitive, and error-prone manual tasks across all departments, eliminating 
    waste and allowing employees to redirect their focus toward more profit-generating activities.
•  Developing Extract, Transform, Load (ETL) processes using Python to seamlessly import external data 
    into our local databases. Employing a variety of methods such as API calls, SFTP file transfers, and 
    email, these processes contribute to a more streamlined and efficient data integration framework.

My commitment to excellence, coupled with a deep understanding of various technologies, positions me as a valuable asset for any organization looking to optimize its IT infrastructure and embrace innovation. Let's connect and explore opportunities for collaboration and growth.

𝐥𝐚𝐫𝐫𝐲𝐠𝐞𝐫𝐚𝐫𝐝@𝐜𝐨𝐦𝐜𝐚𝐬𝐭.𝐧𝐞𝐭

## Work Experience
### Software Engineer @ Cotiviti
Jan 2024 – Present

### Process Automation Analyst @ Ashley Furniture Homestores
Jan 2017 – Jan 2024 | Edison, New Jersey, United States

### Senior Programmer Analyst @ Chubb Insurance
Jan 1996 – Jan 2017 | Whitehouse Station, NJ

### Programmer Analyst @ Paragon Computer Professionals
Jan 1995 – Jan 1996 | Iselin, NJ

### Programmer Analyst @ Bankers Trust
Jan 1993 – Jan 1995 | Jersey City, NJ


## Education
### University of Delaware

### Computer Programming
The Chubb Institute

### Bachelor of Science in Business Administration
University of Delaware


## Contact & Social
- LinkedIn: https://linkedin.com/in/laurencegerard

---
Source: https://flows.cv/laurencegerard
JSON Resume: https://flows.cv/laurencegerard/resume.json
Last updated: 2026-04-13