James M.

Business Intelligence Analyst and Marine Corp Veteran

Aiken, South Carolina, United States

About

Analytics Engineer with a proven track record of turning complex data into clear, actionable insights that guide strategic decision-making. Adept at bridging technical and non-technical teams to build scalable analytics solutions that drive efficiency and innovation. Recognized for leadership, mentorship, and delivering measurable results in fast-paced, high-stakes environments.

Experience

  • Business Intelligence Analyst at Lincoln Financial Group
    Jul 2021 - Present · 5 yrs 1 mo

    AWS & Spark Optimization: Modernized data processing workflows (SparkSQL, Python) in AWS and Dataiku, reducing operational overhead across multiple business units. Full ETL Pipeline Ownership: Designed and deployed a reusable ETL pipeline from scratch, ingesting data from multiple sources and delivering enriched outputs to marketing, finance, and compliance teams. Overcame a perceived “impossibility” by the IntelliSense team by creating sophisticated campaign segmentation directly in SFMC, enabling more targeted, dynamic marketing efforts. Harnessed AMPscript—Salesforce’s scripting language that treats Data Extensions like database tables—to enable dynamic content personalization and real-time campaign triggers. Built advanced segmentation lists and automations, leveraging Synchronized Data Extensions to offload complex SQL tasks and reduce error rates to near zero. Marketing Acceleration: Cut segmentation SLA from 7 days to 4 hours by creating modular SQL libraries, enabling rapid campaign launches for 150,000+ financial professionals. Data Storytelling: Developed interactive dashboards (Tableau, Power BI) informing strategies for 100+ annual marketing initiatives and enabling executives to pinpoint high-impact opportunities. Team Leadership & Training: Onboarded and mentored junior analysts in SQL best practices, data engineering fundamentals, and visualization approaches.

  • Business Intelligence Developer at L3Harris Technologies
    Aug 2016 - Jul 2021 · 5 yrs

    Designed and maintained 319 production and 783 prototype BI Reports to per business requirements. •Design and implemented 65 SAP Universes on top of a Microsoft SQL Server 2016 data warehouse. •Managed and supported Business Objects Central Management Console for users, reports and universe repositories. •Proficient with change management software: ALM-HPQC, Service Now and JIRA. •Managed Report Center for all BOBJ reporting and customer facing report catalogue. •Set groundwork for self-service analytics with training courses, best practices R&D, data science, and customer facing engagements. •Trained and implemented SAP dashboard best practices. •HANA modeling for Corporate side Analytics Cloud w/ Digital Board room. •Analytics cloud w/ Digital Boardroom Dashboard development. •Tableau Site Administrator for 2000 employees focusing on sales, contracts and general business needs. •Designed and maintained SQL server database and semantic layers. •Created Views, Stored Procedures and temporary tables for ad hoc and tactical data. •Software Development Languages: Python, SQL, C++ HTML, JAVA

  • Support Manager at Walmart
    Dec 2014 - Jul 2016 · 1 yr 8 mos

    Worked closely with Customers within a wide branch of the store, ranging from electronics, warehousing, check out, and merchandise pricing/locations. My main focus area to get the store ready for over night stocking to include, managing a team to clean, zone and stock the store. Merchandising feature items and restructuring old features back to the home.

  • Trainee at NS2 Serves
    Mar 2016 - Jun 2016 · 4 mos

    Received the following training/certifications in the SAP disciplines outlined below: Certified Application Associate - SAP BusinessObjects Web Intelligence • Design Web Intelligence documents • Restrict data with Complex Query Filters • Combine data from multiple sources • Enhance presentation of data in report blocks • Manage distribution of Web Intelligence documents • Perform ad-hoc analysis • Manipulate data with Web Intelligence formulas Certified Application Associate – Data Integration with SAP Data Services • Install and Configure SAP Data Services • Manage ETL process with SAP Data Services • Design, Test, Optimize and Troubleshoot ETL jobs • Apply advanced transformations in data flows • Implement Change Data Capture (CDC) strategies SAP Certified Application Associate - SAP HANA • Comprehensive understanding of the core SAP HANA Architecture and different implementation scenarios. • Knowledge of advanced modeling techniques to create flexible analytical models based on real-time data originating from business applications. • Skilled as an SAP Certified Application Associate in SAP HANA • Working knowledge of implementing an end to end scenario, from data acquisition, to creating reporting models, and then consumption through BusinessObjects tools. • Knowledge of SAP HANA security and authorizations • Knowledge of advanced modeling techniques using SQL Script, procedures, spatial data processing, text analytics and rules based decision tables. • Comprehensive understanding of best practices to create performance optimized reporting models. • Data Acquisition technologies including SAP Landscape Transformation Server, SAP Data Services, SAP Replication Server, Smart Data Integration, Smart Data Streaming, Direct Extractor Connection and flat file loading.

  • Sergeant - Quality Control at United States Marine Corps.
    Aug 2004 - Sep 2013 · 9 yrs 2 mos

    •Supervised the induction, repair and quality control of 56 pieces of communications equipment for the DoD with an estimated value of $30 million while under restraints such as time sensitivity, funding and personnel. •Worked on the development testing for the $1 billion DoD project provided by Oracles’ ERP systems developed for the DoD in order to stream line maintenance administration and logistical processes from paper based system to electronic systems. • Worked with a team of 13 fellow service members in running script based protocols to establish accurate test results for DoD consideration and implementation. •Daily activities with Oracles’ Enterprise suite consisted of creating, reconciling and updating all aspects of service request and maintenance trouble tickets. •Assigned new roles and responsibilities to fellow service members as well as provide reconciliation with supply chains and maintenance management personnel in order to ensure proper log keeping of parts requisitions and labor hours. •Supervised a platoon of 15 technicians from different sections during Joint Task Force Weapons and Training exercise in Yuma Az working on over $10 million worth of DoD communications equipment. •Held accountability for personnel, situation report meetings, maintenance briefings, mission standards meetings and after action/lessons learned reporting. •Approved or denied all processes and testing brought up for consideration, evaluation and implementation.