Doug Barmore Jr
Senior Data & Reporting Analyst
ABOUT ME
Being a Marine means I am loyal, hardworking, work well in a team, responsible, reliable, arrive for jobs/tasks early, able to adapt to changing circumstances, trainable, teachable, and much more.
I thrive on challenges, both mentally and physically. For example, I earned my Associate's degree as a full-time student, while serving more than full time in the Marine Corps (60-80-hour work weeks). After leaving (honorably) at the end of my contract, I finished up my Bachelor's degree, while working, and maintained a 3.4 GPA. Similarly, I earned my MBA in only 5 semesters, at times taking quadruple the recommended credit hours, while also completing an unpaid internship, volunteering with a religious organization, and still achieving a 3.5 GPA.
I am a very advanced computer user and learn new programs very quickly and easily. I am an expert Excel and PowerPoint user, have been a system administrator for Neocase HR Case Management Software, and have experience with ServiceNow, SAP, TALEO, ABAS, SABA, SQL (T-SQL), HTML, CSS, JavaScript, Google Analytics, Adobe Photoshop, and many other systems, software, and languages.
I am an honorably discharged Veteran of the United States Marine Corps and work well individually, as a team member, and while leading a team.
I love being challenged at my job and thrive under pressure, never compromising quality, yet innovatively seeking greater efficiency in everything I do. I have a knack for seeing the big picture and how all the little pieces work together to achieve that purpose.
I live with honesty and integrity, not just at work, but in my personal life too. I treat others with dignity and respect, even when they do not treat me in kind.
In addition, it's important to me that I give back to my community. I have consistently volunteered my time and money assisting others in need. In 2004, I began mentoring through The Navigators and continue to mentor still.
SUMMARY
Subject matter expert in driving process automation and optimization projects aimed at increasing efficiency and effectiveness. Over 20 years of leadership experience in automation, optimization, and analytics, with an aim at reducing costs and waste in processes, increasing productivity and customer relations. Deep understanding of technology, including databases, systems, reporting, and quality control and assurance. Significant experience in cross functional teamwork and leadership. I am the employee assigned to the most valued clients and difficult tasks.
CERTIFICATIONS
- Microsoft Certified Power BI Data Analyst Associate, June 2022
- Microsoft Certified Power Platform Fundamentals, April 2021
- Certified Scrum Master, Scrum Alliance, September 2018
- Microsoft C# Specialization, Level 2, Houston Community College, May 2017
- Microsoft C# Specialization, Level 1, Houston Community College, August 2016
- Certified Six Sigma Green Belt, SKF Six Sigma Academy, December 2015
JOB HISTORY
THE PENNSYLVANIA STATE UNIVERSITY,
remotely from Houston, Texas
Oct 2017 – Current
Senior Data Analyst Duties
- Lead the design and development of reports in Power BI, Microsoft SQL Server 2016 Report Builder, SQL Server Reporting Services (SSRS) to give all levels of management visibility of work processes.
- Extraction, Transformation, and Loading (ETL) of data from various systems into SQL Server & Power BI.
- Create Dataflows from on-premises SQL Server databases via data gateway to Power BI web service.
- Create, modify, and schedule various business Power BI reports for managers and directors.
- Create and Schedule Extraction, Transformation, and Loading (ETL) processes with Power Automate.
- Create various HR tools and forms (Suggestion Box, Change Request, etc.) using Microsoft Power Apps.
- Lead the design and development of Google Analytics reports for the Penn State Worklion HR Portal.
- Power user of SQL (T-SQL / TSQL), SQL Service Integration Services (SSIS) - ETL Tool, Microsoft Power BI, Microsoft Visual Studio, and Microsoft SQL Server Management Studio (SSMS).
Senior Human Resources System Analyst Duties
- Implementation of Neocase HR Power Case Management System with 16 complex business processes.
- Provide post-go-live support including troubleshooting, problem resolution, enhancements, upgrades, etc.
- Provided support to HR & liaised between them and the case management software vendors/developers. Use ServiceNow ticketing system to manage and track work relating to Neocase system issues. Troubleshot and fixed issues with the Human Resource case management software / system.
- Analyzed trends in the system to look for problem areas and determine if it is a training issue, bug, etc.
- Use JIRA to manage and track project work relating to Neocase modifications and enhancements.
- Coding with JavaScript, jQuery, CSS, and HTML.
Financial System Analyst Duties
- Assisted with integrations between SIMBA (SAP) and both Workday and Penn State Health system (Lawson).
- Automated numerous manual and error prone tasks, resulting in a savings of over 40 hours per week.
- Documented all errors in integrations and worked on the manual fixes needed to resolve all errors.
- Updated SIMBA HCM (SAP) when corrections are needed for Workday and/or PSH HCM data.
- Worked with SAP Developers to Automate the exportation of integration files.
- Worked with the Workday integration team on integration and data transformation logic/issues
CORPORATE TRAVEL MANAGEMENT (CTM) NA,
Houston, Texas
Oct 2015 – Oct 2017
Senior Data Analyst
- Automated numerous manual and error prone tasks, resulting in a savings of over 40 hours per week.
- Lead a process automation project for very error prone, manual process. Saved over 8 hours/week, provided greater data consistency, and reduced billing errors causing first pass yield to increase from 75% to 95%.
- Utilized Excel and Visual Basic for Applications (VBA) to create and run complex macros.
- Organized and analyzed sales, operations, and finance data by building reports from databases.
- Created, modified, and scheduled sales, operating, & financial reports for customers, managers, and directors.
- Contribute to special projects as assigned, usually centered around automation, streamlining, & data integrity.
- Automate data processes to reduce labor hours needed, eliminate errors, and make data easier to report.
- Collaborate with internal and external customers of all positions, until customer satisfaction is achieved.
- Power user of ManageEngine ServiceDesk Plus and Zoho Support Help Desk (Ticketing Systems), SAP BI, Interbase, Trams Back Office, Grasp, iBank Financial/Bookkeeping Services, and SAP Lumira.
SKF USA,
Houston, Texas
July 2014 – July 2015
Business Process Analyst
- Created paperless process, which improved record keeping, reduced errors, saved work hours, and saved money spent on supplies for an estimated savings of 8+ hours per week and $1,000 per week.
- Delivered cost savings and profit maximization through various process improvements.
- Ensured internal processes are setup / modified to create the best possible experience for customers.
- Regularly updated, reviewed, & analyzed business data to ensure business operated efficiently & effectively.
- Created and tracked key performance indicators (KPI’s) across multiple SKF Solution Factories.
- Power user of Microsoft Excel – Pivot Tables, Pivot Charts, VLOOKUP, Conditional Formatting, Macros, etc., ABAS (ERP), Siebel (CRM), and Price & Quote (SKF system used to generate quotes).
BAKER HUGHES,
Houston, Texas
Nov 2012 – July 2014
Lead System Analyst
- Performed System Analysis, System Integration, Project Implementation, Process Automation, Complex Business Rule Configuration, Change Management, System Configuration, and Quality Assurance (QA).
- Power user of Neocase, SQL, CA Service Desk Manager, Crystal Reports, TALEO, & SAP.
- Coordinated User Acceptance Testing (UAT) globally for patch releases and process improvements.
PROSOFT,
Camp Lejeune, North Carolina
April 2004 – March 2010
Lead Learning Resource Facilitator
- Performed Quality Assurance (QA) testing on courseware for MarineNet Learning Management System.
- Troubleshot and provided feedback to MarineNet & the Marine Corps Training and Education Command.
- Generated and updated 3+ daily reports to communicate employee work progress to senior management.
UNITED STATES MARINE CORPS,
Camp Lejeune, North Carolina
July 1997 –July 2002
Supervisor, Corporal, Electronics, Radio, & Radar Repair, Process Improvement, Data Analysis, Reporting
- Maintained a Secret security clearance for working in electronics maintenance company.
- Improved repair order processes so zero orders (previously 20-30) were being carried over from day-to-day.
- Troubleshot radios, radars, minesweepers, power supplies, and various other electronic systems.
- Provide reporting on daily, weekly, & monthly basis documenting performance, priorities, issues, etc.
EDUCATION
EAST CAROLINA UNIVERSITY,
Greenville, North Carolina
December 2011
Master of Business Administration with a Certificate of Finance
3.5 GPA
CAMPBELL UNIVERSITY,
Buies Creek, North Carolina
May 2004
Bachelor of Business Administration with enough credits for Computer Information Systems Major
3.4 GPA