Mark M Fera

Mark M FeraMark M FeraMark M Fera

Mark M Fera

Mark M FeraMark M FeraMark M Fera
  • Home
  • Blank
  • More
    • Home
    • Blank
  • Home
  • Blank

412-877-7863

SQL Server–Based Automation & Reporting Solutions

SQL Server–Based Automation & Reporting SolutionsSQL Server–Based Automation & Reporting SolutionsSQL Server–Based Automation & Reporting Solutions

 Access • VBA • Python • and more  chosen based on fit, scalability, and cost 

Learn More

412-877-7863

SQL Server–Based Automation & Reporting Solutions

SQL Server–Based Automation & Reporting SolutionsSQL Server–Based Automation & Reporting SolutionsSQL Server–Based Automation & Reporting Solutions

 Access • VBA • Python • and more  chosen based on fit, scalability, and cost 

Learn More

Who I am - Helping businesses work smarter with automation

Experience

At Bulldog Office Products, I helped modernize an established business by using automation and data to improve efficiency and decision-making.


Over my 33 years as part owner, I developed custom systems that connected our sales, inventory, and accounting data — giving our team the information we needed to act quickly and accurately.


I built many of these tools myself using Microsoft Access, Excel, VBA coding and Python, which allowed me to automate reports, simplify data entry, and eliminate hours of manual work each week.


 I’ve always focused on choosing tools that fit the business — balancing capability, usability, scalability, and cost rather than pushing unnecessary complexity. 


When we sold the company to Staples in 2019, Bulldog had grown into a multi-location operation with over 100 employees and $35 million in annual sales. I also served as Key Operator for our ECI2/DDMS and OPUS platforms, creating specialized reports and automations that improved accuracy and productivity across departments.

Education and Skills

I graduated from Carnegie Mellon University with a degree in Industrial Management and hold a certificate in Business Intelligence Analytics from TripleTen.


I specialize in automating business processes with Microsoft Access and Excel, often using VBA programming and Python to connect systems, build forms, and generate reports automatically using a combination of tools selected based on business needs and cost .  I frequently use built-in Windows tools such as Task Scheduler to run updates and deliver reports on a schedule — so clients don’t have to lift a finger.


I’m also experienced with SQL Server Management Studio (SSMS), Power BI, Tableau, and other reporting tools, helping clients turn their data into clear, actionable insights.

Services

  •  Automation Solutions: Eliminate repetitive manual tasks by connecting Access, Excel, and SQL using VBA, Python, and Task Scheduler — selecting the right tools based on business needs and cost.
     
  • Custom Access Development: Convert spreadsheets into user-friendly Access databases with forms, queries, and reports designed to fit your business needs.
     
  • Data Integration & Reporting: Consolidate and analyze data across multiple systems using Access, SQL, Power BI, or Tableau to deliver clear, actionable insights.
     
  • ECI2/DDMS Consulting: Solve complex operational and reporting challenges, including PROCS, OPUS updates, and month- or year-end processing.
     
  • Business Intelligence: Build dashboards and analytics tools that help decision-makers see the full picture and act quickly.

How I Work

 

I approach every project with a simple principle: use the right tools for the problem, balancing capability, usability, scalability, and cost. I start by understanding how a business operates and where automation will have the greatest impact. For many small and mid-sized organizations, Microsoft Access is a strong option because it offers a built-in user interface and solid reporting at a very low cost. When requirements call for more complexity or scale, I pair or replace Access with SQL Server, using SQL Server Management Studio (SSMS) to manage data updates and integrity behind the scenes. I also use VBA, Python, and Windows Task Scheduler to automate recurring processes so systems run reliably with minimal manual effort. My goal is always to deliver practical, maintainable solutions that help businesses work more efficiently and trust their data.

LinkedIn
LinkedIn
LinkedIn
LinkedIn
LinkedIn
LinkedIn

Contact me

Contact Form

Attach Files
Attachments (0)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Mark M Fera

412-877-7863 mark@markmfera.com

tESTIMONIALS


Copyright © 2025 Mark M Fera - All Rights Reserved.

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept