Search
Marco H.'s Photo

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

3,587 hours tutoring

Your first lesson is backed by our Good Fit Guarantee

Hourly Rate: $55

Response time: 27 minutes

Marco H.'s Photo

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

3,587 hours tutoring

Your first lesson is backed by our Good Fit Guarantee

3,587 hours tutoring

Your first lesson is backed by our Good Fit Guarantee

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 (1,109 ratings)
5 star
(1,104)
4 star
(4)
3 star
(0)
2 star
(0)
1 star
(1)

Reviews

Show reviews that mention

See all reviews

Impressed and extremely lucky to work with Marco

I had a wonderful experience working with Marco! He is EXTREMELY smart, calm, and patient. Marco took the time to help me build a SSIS package from scratch. I am very impressed with his knowledge and demeanor!!! Marco is a phenomenal and very detailed tutor on this platform. I consider myself truly lucky to have the opportunity to work with him. He was 200% invested and went above and beyond! I have learned so much from him and am looking forward to working with him again! Thank you Marco!

Brittany, 2 lessons with Marco

Very Knowledgeable

Marco helped decipher a spreadsheet and the matching analysis for a work project. He pointed out a few items which clarified why I was so confused and gave me some tips for the future.

Andrea, 1 lesson with Marco

knowledgeable and patient tutor.

He showed me how to think, plan and write VBA on my data analyst assignment. He meet beyond my expectation. I will recommend Marco to others. I am so glad wyzant provides this site to help us who wants to continuously grow.

Jenny, 1 lesson with Marco

ON POINT!!!

Marco was awesome and I wish that we could have connected sooner!!! He showed me how to create a process that I was able to not only replicate, but was actually able to expand on with the best part being I UNDERSTOOD WHAT I WAS DOING :) I am definetly on Team Marco

Horace, 1 lesson with Marco

Incredible and incredibly patient!

Marco was super detail oriented and helped me make sure I was designing a quality database as well as helping me figure out the best format for my database. He was so patient when I didn’t quite understand things.

Leslie, 1 lesson with Marco

Marco is an amazing tutor!

I have over 10 sessions of Microsoft Access tutoring sessions with Marco and he is absolutely the best! He is patient and ensures that you understand the material before proceeding with the next topic.

Steven, 36 lessons with Marco

Knowledgeable and patient tutor.

Excelent tutor. His knowledge about the subject VBA code,helped me alot in understand everything I have doubts. He explained to me in a simple way so I was able to understand everything. 100% recomended.

Luz, 7 lessons with Marco

Excellent Access Tutor

Marco is very knowledgeable. He is very detailed, patient and kind. Very helpful!! Able to assist on short notice. Highly recommend!!

Cristina, 1 lesson with Marco

Knowldegable and Professional

Marco helped me find my answers quickly and in a way that made sense to me. I highly recommend him for his sheets prowess. He's a proven professional and it's much appreciated. Thanks Marco!

Gregory, 1 lesson with Marco
Hourly Rate: $55
Response time: 27 minutes
Contact Marco