Lloyd Gauthier

Business Analyst supporting enterprise data modernization, process mapping, and integration work across IT delivery teams. Translates client needs into requirements gathering, SQL-based data quality checks, and UAT scripts that keep migrations and report testing on plan. Delivers automated solutions, compliance-ready data support, and clear progress reporting for technical stakeholders and management.

Sr. Business Analyst at LMG Technology Services LLC (2025-10 – Present)

Sr. Business Analyst supporting confidential client (NDA)

• Design automated IT solutions that increase customer efficiency and produce quantifiable cost savings
• Trained AI models including Anthropic Claude Sonnet 4.5, OpenAI GPT-5, Google Gemini 3.1 Pro, and Microsoft Copilot to enhance complex technical operations
• Analyzed and designed process and data mapping for a process optimization project
• Implementing data support services while adhering to data governance compliance and standards
• Architect and direct AI-enhanced engineering workflows by training and operationalizing advanced models—including Claude Sonnet 4.5, GPT-5, Gemini 3.1 Pro, and Microsoft Copilot—to support high-complexity mobile application development within the Cursor AI ecosystem
• Designed automated IT solutions that streamlined customer operations and delivered measurable cost savings
• Designing and developing React Native mobile apps for Apple iOS and Google Android devices
• Analyzed and designed process and data mapping to optimize workflows and enhance operational efficiency

Business Analyst/Unstructured Data Team Co-Lead at LMG Technology Services LLC (2024-01 – 2025-10)

• Business analyst on a global ERP digital transformation enterprise project upgrading SAP ECC 6.0 to S4/HANA, GEP, and Workday. Project involves migrating 800+ million records of data of the current EDW from Teradata 17.10 to Snowflake, and 550+ Spotfire and Power BI reports from ECC to the new EDW
• As part of the ERP Data Modernization Team, ensured that all critical data reports were successfully migrated, confirmed via pre-migration testing
• Worked regularly with Data Governance Team to ensure all compliance requirements had been enforced within data management
• Collaborated with DevOps team to ensure stakeholder deliverables met standardized solutions aligned with Enterprise Data roadmap
• Project created a 60% reduction in duplicate data, reports, and applications, 80% reduction of tables, and 70% reduction in database objects
• Developed and managed comprehensive data migration plans and templates for M&A projects, facilitating seamless integration
• Conducted process mapping and data mapping between the source and target systems for data management
• Ran SQL queries in source and target systems for data quality assurance testing
• Designed workflow visualization for data management process to ensure compliance with data governance
• Within data migration project, worked with data team to ensure critical metadata was captured for any data deleted so that it could be restored if necessary for business resumption purposes
• Created Excel and Power BI metrics to report project progress to leadership, enhancing visibility into project status
• Utilized VLOOKUP, XLOOKUP, and other Excel functions to process 10s of thousands of rows of data
• Coordinated with scrum master for backlog refinement during sprint planning meetings
• L48 Reports Workstream Deployment/Cutover Lead
• Led daily scrum meetings to resolve report/daily related defects
• Gathered system requirements, conducted analysis, planned and developed integration solutions for client environment
• Authored and executed SIT, UAT, and regression test scripts
• Performed UAT report testing for functionality and data quality between Teradata and Snowflake data
• Participated in integration testing to ensure consistent data quality and functionality
• Coordinated performance testing with DevOps team to ensure optimum reports performance during development cycles
• Tracked progress of all work throughout the project management lifecycle in Jira

Sr. Business Analyst at LMG Technology Services LLC (2020-03 – 2023-12)

Sr. Business Analyst supporting confidential client (NDA)

• Collaborate with clients to assess their IT needs, conduct comprehensive analysis, and recommend the appropriate technology solutions
• Collaborated with clients to assess IT needs, conducted analysis, and recommended technology solutions that aligned with client objectives
• Developed customized IT strategies that addressed stakeholder goals and improved project outcomes
• Utilize Perl and Python programming to analyze raw data and databases and produce custom reporting for decision-making purposes
• Analyzed raw data and databases using Perl and Python, producing custom reports that informed key decision-making processes
• Supporting client in IT sector within operational services

IT Data Modeler at LMG Technology Services LLC (2018-03 – 2020-03)

IT Data Modeler supporting ExxonMobil

• Delivered technical application support to upstream drilling stakeholders for complex engineering design applications, ensuring effective usage and resolution of issues.
• Worldwide point-of-contact for multiple industry and custom applications that managed well data, including but not limited to well control, well planning, well integrity, and well simulation
• Proactively researched and presented statistics and proposals to upper management that led to global change in employee/contractor application access management that resulted in +$100K / year cost savings as well as enhanced financial transparency to better satisfy IRS software cost sharing regulation compliance
• Conducted daily meetings in both Kanban and scrum (agile) frameworks for global support team on Microsoft Azure DevOps to ensure IT projects were on schedule
• Created information roadmaps using Microsoft Office tools, including Excel, PowerPoint, SharePoint, and Visio, to effectively communicate project progression and status.
• Developed and conducted UAT testing for DevOps group for custom applications
• Researched and presented statistics and proposals to upper management that drove global changes in employee/contractor application access management, achieving over $100K annually in cost savings and improving financial transparency for IRS compliance.
• Global communications designee for software updates and planned systems outages

Sr. Business Analyst at LMG Technology Services LLC (2016-12 – 2018-03)

Sr. Business Analyst supporting confidential client (NDA)

• Collaborated with clients to assess their IT needs, conduct comprehensive analysis, and recommend the appropriate technology solutions
• Collaborated with clients to assess IT needs, analyzed requirements, and recommended tailored technology solutions
• Developed customized IT strategies aligned with stakeholder goals
• Designed automated IT solutions that enhanced customer efficiency and delivered measurable cost savings

GGRE Application Support Analyst at ConocoPhillips (2013-11 – 2016-12)

• Collaborated with cross-functional teams to assess IT requirements and propose system upgrades, improving system stability and functionality
• Collaborated with cross-functional teams to assess IT requirements and propose system upgrades for enhanced stability and functionality
• Maintained well data integrity and reliability, designed and processed detailed daily and End of Well reports based on the data gathered during operation
• Wrote business logic for well data migration from Well View 9 to Well View 10. Engaged in cross-team collaboration to ensure data compatibility with Well View 9 and Halliburton OpenWorks data, as well as data integrity testing after Well View 10 upgrade
• Developed and conducted UAT testing for data validation after migrations
• Routinely ran SQL queries to extract well datasets for the purpose of data integrity checks
• Worked with stakeholders to ensure that principles of data governance were enforced within the transfer, storage, data integrity, and analysis of data
• Planned and executed a 1000+ historical well data import project for KPI analysis, achieving over $200k in consulting savings
• Developed IT business standards, mitigating risk and enhancing stability of IT infrastructure
• Maintained documentation on SharePoint and provided global communications for software updates and scheduled system outages
• Researched and presented statistics and proposals to upper management that drove global changes in employee/contractor application access management, achieving over $100K annually in cost savings and improving financial transparency for IRS compliance.
• Global communications designee for software updates and planned systems outages

Application Support Analyst at Chevron (2012-10 – 2013-11)

• Delivered technical guidance and support to Upstream stakeholders, enhancing issue resolution and user satisfaction
• Performed customer data loads to Upstream 3rd party analytical tools
• Developed custom applications to integrate various systems for streamlined user and group management reporting
• Updated, imported and exported well data using Petra, Petrel and ArcGIS
• Captured historical well data changes to enable advanced forecasting analytics, improving data accuracy and decision-making
• Participated in steering committees responsible for identifying best tools for stakeholder issue reporting

Bachelor of Science in Computer Science – Southern University A&M College