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

  • 2,638 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


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.

Ratings and Reviews


Rating

5.0 (802 ratings)
5 star
(798)
4 star
(4)
3 star
(0)
2 star
(0)
1 star
(0)

Reviews

Show reviews that mention

All reviews

Rating not big enough.

Marco was there and gave me better familiarity with how to implement a search across multiple columns. There was also a problem I had with the login and extra parts where he gave me a good idea on where to go. If I can do more than five stars, I would. Definitely recommend him, especially with how he can back up the experience with his work ethic and comprehensive approach to the student.

Liam, 2 lessons with Marco

Awesome!

He's very smart, kind and so easy to learn from. His ability to teach Excel and any formulas related to the process is perfect. It's like being in a college classroom with a professor.

J, 8 lessons with Marco

Great teacher!

Macro really help me out with VBA work. He knows what he is doing well. He gives you enough time to understand and explain everything.I highly recommend him.

Abdullah , 3 lessons with Marco

Marco H. is a great Microsoft Access tutor!

Marco H. is undoubtedly a seasoned and experienced tutor. His demonstrated professionalism, knowledge expertise, and ability to pace lessons in teaching Microsoft Access are superb and respectable. In every lesson, Marco would prelude me on the targeted learning for next lesson, so that the best preparation can be made in advance. As a college student, it is crucial that my education is left in the hands of a reliable tutor, and this - is Marco. Through his effective guidance, I am able to show exceedingly high levels of accomplishments in my course. Thank you, Marco! At the same time, my gratitude to MAST for all the assistance and facilitation.

Elizabeth, 8 lessons with Marco

Computer classes, Word, Access, PP and Excel!

Marco, A phenomenal instructor with exceptional computers skills. I have better understanding of Microsoft word, Excel and Access, as he came alongside side ensuring learning occurred. Great job!

Rafael, 4 lessons with Marco

Teaching SQL, excellent Tutor on Wyzant

he is patient, nice, knowledgeable, and willing to help after class! absolutely recommend!! I never really write reviews, only write for outstanding or extremely bad, and apparently, Marco is the outstanding one!!

Marina, 1 lesson with Marco

Very patient very knowledgeable

He was very helpful and knowledgeable, he showed me how to build a macro. And was able to answer all my questions. I definitely record him. He is very patient too.

Aida, 3 lessons with Marco

knowledgeable and patient tutor

Marco is a very patient tutor and very knowledgeable and he has been able to help me learn excel very well. I highly recommend him to anyone who is stuck on a project or needs help with MIS

Julio, 5 lessons with Marco

Formulas

Mr. Marco is the guru king for formulas. He taught me various documents for my work assignment. I plan on using him again in the near future to teach me more advance formulas and formatting.

Sara, 2 lessons with Marco
Contact Marco

Response time: 35 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: 35 minutes