Search

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

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 from SAP and populate many back-end databases in order to feed front-end program I have designed in Access and Excel which is being used by over 50 users remotely.

Having such knowledge and professional experiences explained above, I would love to share my knowledge and help both college/graduate students and experienced persons through tutoring to be successful in academia and workplace. My teaching style is "Learning by Doing" by which I encourage a student to gain practical knowledge in the process of learning.

As a patient and detail-oriented tutor, I would love to teach you in the following subjects:
-Database design from concept through logic model and building ERD.
-SQL coding from writing simple SELECT statements through complex queries.
-T-SQL in Microsoft SQL Server.
-Developing any reports and business analytic tool in Excel.
-Developing custom applications in Access.
-Microsoft Office Automation between Word, Excel, Access, PowerPoint and Outlook.
-VBA programming within Access, Excel, Word, Outlook and PowerPoint.
-Visual Basic and C# programming.
I appreciate the time you have taken to view my profile. I am looking forward to working with you soon.


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 9 questions submitted by students on Wyzant’s Ask an Expert.

Ratings and Reviews


Rating

5.0 (389 ratings)
5 star
(385)
4 star
(4)
3 star
(0)
2 star
(0)
1 star
(0)

Reviews

Show reviews that mention

All reviews

The Best

Marco responded to a last minute request i made for help with excel. He was able to quickly jump online and assist with my assignment. He is Incredibly knowledgeable, attentive and insightful. I hope to continue working with him in the future. Highly recommended thank you Marco!

ashley, 1 lesson with Marco

Great! 5 star

Linear programming. He is very knowledgeable, patient, polite, very detailed. He is the best of all and I would like to work with him at all times. I will even recommend him to my friends and relatives. Great job!

Katie, 1 lesson with Marco

Perfect

Very passionate about the subject and extremely helpful. I highly recommend him for tutoring because he is very patient and good at explaining things. We did an erd and sql scripts

Rahul, 1 lesson with Marco

Marco is very patient -

I appreciate his help.

Erin, 2 lessons with Marco

Excel Tutor

Helped with complicated Excel date formats in a schedule template. Marco explained the best formula to enter. Marco showed me the formula and how it worked. Gave me the information to take the template to the next level.

David, 6 lessons with Marco

Amazingly helpful and knowledgeable

The instructor not only helped on short notice but answered ANY and ALL questions with a great depth of knowledge and insight. He is a perfect instructor for my beginning VBA questions and I will absolutely use him again in the future!

Markus, 1 lesson with Marco

Good and patient tutor, not for beginners

I honestly don't know much about computers as I am 59, and never even saw one before age 38. Marco did help me enough to get my class assignment done, but I understood very little of the terminology, like "data sets," and had a very difficult time following the instruction. I think Marco's expertise is best utilized by people more familiar with computers than I. I just didn't know what he was talking about most of the time, and I will specifically request someone experienced with beginners or older people next time. He was not familiar with Macs, and I only have Macs, so the instruction of "right click," which does not exist on a Mac, was frustrating.

Blair, 1 lesson with Marco

Highly Knowledgable

Forecasting average in Analytics and worked on numerous formulas that helped identify the answer to the problem. I find Marco to be a great tutor and would recommend him to anyone trying to learn about Advanced Analytics.

Paul, 1 lesson with Marco

Very knowledgeable and helpful tutor.

Very helpful with my specific questions and took time to review actual work scenarios. Also, he was very patient and spent a little extra time to ensure I was able to successfully execute a few different formula scenarios.

Jason, 6 lessons with Marco
Contact Marco

Response time: 45 minutes

$55/hour

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: 45 minutes