Search
Marco H.'s Photo

Marco H.

Pro Ind Eng/Data Analyst Specializing in Access,Excel, VBA and SQL

Pro Ind Eng/Data Analyst Specializing in Access,Excel, VBA and SQL

$55/hour

5.0 (678 ratings)

  • 2,251 hours tutoring

About Marco

Bio

I have a BSc. degree in Industrial Engineering and two MSc. Degrees in Industrial Technology and Industrial & Systems Engineering. My academic life concludes in 9 years of study and research. During my graduate study at Texas State University, I researched actively into the development of complex algorithms for Rapid Manufacturing Process using VBA within Autodesk Inventor. My research resulted in the publication of 12 International Papers and 3 book chapters at prestigious journals....

I have a BSc. degree in Industrial Engineering and two MSc. Degrees in Industrial Technology and Industrial & Systems Engineering. My academic life concludes in 9 years of study and research. During my graduate study at Texas State University, I researched actively into the development of complex algorithms for Rapid Manufacturing Process using VBA within Autodesk Inventor. My research resulted in the publication of 12 International Papers and 3 book chapters at prestigious journals.

Between 2000 and 2005 before I pursue my higher education, I took Industrial and Process Improvement Engineer positions in detergent and automaker industries and extensively utilized Excel, Access, Visio, VBA and SQL coding for the development of custom applications needed for the improvement of various processes. I was also passionate about computer programming and became a self-educated computer programmer, did coding in VBA, Visual Basic, Turbo Pascal 7, C#, etc. My mixed Engineering-Computer skills helped me a lot to become successful data analyst and engineer in workplace and find solutions for highly difficult problems.

During my professional career, I have designed many databases such as Inventory Control, Production planning and Control, Costing tools, Material Movement and Exception process, NAAB accreditation program, etc. using VBA, SQL coding in both Access and Excel. During my work for Harley-Davidson as an Exception Analyst with Operation Data Management group, I have automated the number of reports on material movement processes in SAP using VBA and SQL coding in Access, Excel, and Outlook. Pulling data automatically from SAP and remotely exchanging data between Access, Excel and Outlook helped us significantly reduced man-hour, increased efficiency and accuracy of reports.

Currently I work full time for Hallmark as Production Planning Analyst and I have designed and developed several custom applications for production and our own department. At workplace, I extensively use SQL and VBA to automatically pull data fr

Read more

Education

Texas State University
Masters
Universiti Putra Malaysia
Masters

Policies

Schedule

Loading...

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Subjects

Business

Microsoft Excel,

Microsoft Excel

I have been using Excel since 2002. I have extensive knowledge in various aspects of Excel, ranging from building dashboard, data analysis, utilizing advanced formulas, linear programming, statistical analysis through VBA coding within Excel. I have designed and developed the number of applications that required some degree of office automation between Excel, Access, Word and Outlook. As a Production Planning Analyst at Hallmark, I am actively involved in the development of custom reports using VBA and SQL Coding, and other advanced data analytic techniques. I would love to teach and share with you my years of professional experiences as to how utilize Excel in an easy-to-understand and efficient manner.
Microsoft PowerPoint

Computer

Microsoft Access,

Microsoft Access

Since 2002, I have been designing and developing several custom Microsoft Access applications (e.g. Production Planning and Control, Inventory Control, Costing Tool, Production available-to-run, NAAB Accreditation Program, etc.) for various industries sectors and University. All applications that I have developed consisted of two parts, front-end GUI and back-end databases. To create Forms, Queries, and Reports for front-end GUI apps, I have deployed VBA, SQL coding, and other advanced techniques. Back-end databases consisted of MS Access and SQL Databases which have been resided on either server or local networks. Currently I work full time as a Production Planning Analyst for Hallmark where I have developed a number of programs packed in one front-end Access app which is remotely connected to many back-end databases (millions of data records). This custom Access app is used by over 50 users on the local network. So I would love to be challenged by difficult problems and help students and experienced persons solve their technical problems in an easy-to-understand and comprehensive way.
Microsoft Excel,

Microsoft Excel

I have been using Excel since 2002. I have extensive knowledge in various aspects of Excel, ranging from building dashboard, data analysis, utilizing advanced formulas, linear programming, statistical analysis through VBA coding within Excel. I have designed and developed the number of applications that required some degree of office automation between Excel, Access, Word and Outlook. As a Production Planning Analyst at Hallmark, I am actively involved in the development of custom reports using VBA and SQL Coding, and other advanced data analytic techniques. I would love to teach and share with you my years of professional experiences as to how utilize Excel in an easy-to-understand and efficient manner.
Visual Basic,

Visual Basic

I have been writing Visual Basic for Application (VBA) code for over 10 years. I have extensive knowledge in VAB coding within Excel, Access, Outlook, Word and Autodesk Inventor. I have designed and developed the number of custom applications in Microsoft Office Suit that required extensive knowledge of VBA coding for the purpose of remote database connection, remote data exchange between Office apps, designing front-end GUI environment, solving complex production and CAD/CAM problems. As a Production Planning Analyst at Hallmark, I actively involve in the development of custom reports using VBA and SQL Coding, and other advanced data analytic techniques. I would love to teach and share with you years of my professional experiences as to how write VBA code in an easy-to-understand and efficient manner.
Microsoft PowerPoint, SQL

Corporate Training

Microsoft Excel,

Microsoft Excel

I have been using Excel since 2002. I have extensive knowledge in various aspects of Excel, ranging from building dashboard, data analysis, utilizing advanced formulas, linear programming, statistical analysis through VBA coding within Excel. I have designed and developed the number of applications that required some degree of office automation between Excel, Access, Word and Outlook. As a Production Planning Analyst at Hallmark, I am actively involved in the development of custom reports using VBA and SQL Coding, and other advanced data analytic techniques. I would love to teach and share with you my years of professional experiences as to how utilize Excel in an easy-to-understand and efficient manner.
Microsoft PowerPoint, SQL

Examples of Expertise

Marco has provided examples of their subject expertise by answering 10 questions submitted by students on Wyzant’s Ask an Expert.

See all of Marco ’s answers ›

Ratings and Reviews

Rating

5.0 (678 ratings)
5 star
(674)
4 star
(4)
3 star
(0)
2 star
(0)
1 star
(0)

Reviews

Show reviews that mention

All reviews

Featured review

Highly recommend Marco to tackle your analytics questions!

Marco helped me tremendously on an advanced (graduate level) business analytics course I was taking. I did not come from a analytics background, so I found it quite challenging to digest the content and complete certain requirements of the course. However with Marco's support in this process, I was able to proceed smoothly. He's patient, diligent and very knowledgeable in using excel tools to tackle business scenarios. He tried his very best to make himself available for me on top of a hectic schedule. I am very thankful for all of his help in this process and will certainly come back again if I have further challenges.

Shuhan, 16 lessons with Marco

OUTSTANDING TUTOR!!

Marco is an outstanding tutor! He was able to help me understand Excel in a much better way. I strongly recommend him! He is able to break subjects down in a way that is easy to understand.

Ernest, 4 lessons with Marco

If and Vlook formulas along with IFERROR.

It was awesome. Learned so much and solved my issues with excel. I have been working on document for 8 hours and couldn’t figure it out. He fixed it in 20 minutes. Awesome

Ashley , 3 lessons with Marco

Excel VBA Guru

Marco can help you with any operation you want to be automated in Excel using VBA. I am highly satisfied.

Matt, 7 lessons with Marco

Knowledgeable and patient tutor

Marco is ideally suited for teaching Microsoft Excel advanced formulas. We covered vlooups, sumifs, sumif, match, index, averageifs, countifs etc. He was very good at explaining.

Caroline, 3 lessons with Marco

Excel VBA Guru

Marco can help you with any operation you want to be automated in Excel using VBA. I am highly satisfied.

Matt, 7 lessons with Marco

Very knowledgeable

Marco is an awesome tutor. He is very knowledgeable in sql. His teaching is very easy to understand because he shows you different ways to solving the problem and guide you through the solution. Thank you Marco, looking forward to more classes with you.

Ashley, 1 lesson with Marco

Very knowledgeable and expert.

It was lot of new and useful information how I can’t start my career as a new candidate I didnt know how should I start and from where now he did instruct how I can’t start it was very helpful I am very thankful

Roza, 1 lesson with Marco

AWESOME!

I start new Job , Marco is my Angel. I purchased books and online lesson, itsn't work. But with Marco my dream come thru. I Highly reccomend. He is a Master! And I want more lesson to make better!

BEATRIZ, 2 lessons with Marco

Patient and excellent tutor!

Marco is an excellent tutor with great experience. He is patient, and kind, and doesn't mind repeating things. He was able to quickly come up with an example to illustrate a very complex concept. THANK YOU SO MUCH!

Joni, 4 lessons with Marco
Contact Marco

Response time: 33 minutes

$55/hour

Marco H.'s Photo

Marco H.

$55/hour

  • No subscriptions or upfront payments

  • Only pay for the time you need

  • Find the right fit, or your first hour is free

Contact Marco

Response time: 33 minutes