Expert Excel, Access, SQL, and VBA

4.6 (14)
From Lawrence, KS
SinceSeptember, 2021

About
My academic background includes a BSc. degree in Industrial Engineering, as well as two MSc. Degrees in Industrial Technology and Industrial& Systems Engineering. Over the course of nine years, I have dedicated myself to both studying and conducting research. During my time at Texas State University, I actively researched the development of complex algorithms for Rapid Manufacturing Process with VBA within Autodesk Inventor. This research resulted in the publication of 12 International Papers and 3 book chapters at notable journals.

Prior to pursuing higher education, from 2000 to 2005, I occupied Industrial and Process Improvement Engineer positions in detergent and automaker industries. During this time, I made extensive use of Excel, Access, Visio, VBA, and SQL coding for the improvement of several processes. I also indulged in computer programming, teaching myself VBA, Visual Basic, Turbo Pascal 7, C#, and other notable languages. This combination of engineering and computer skills enabled me to succeed as an analyst and engineer in the workplace, effectively overcoming complex problems.

Throughout my professional career, I have designed several databases such as Inventory Control, Production planning and Control, Costing tools, Material Movement and Exception, NAAB accreditation process, etc. using VBA, SQL coding in both Access and Excel. For Harley-Davidson, as an Exception Analyst, I automated several reports on material movement processes in SAP using VBA and SQL coding in Access, Excel, and Outlook. This resulted in significantly reduced man-hours, increased efficiency, and accuracy of reports.

Currently, I work for Hallmark as a Production Planning Analyst, where I have developed several custom applications for both production and our department. I regularly make use of SQL and VBA to automatically pull data from SAP and populate various back-end databases that feed the front-end program I designed in Access and Excel, used by over 50 remote users.

Given my knowledge and professional experiences, I would love to tutor and share my expertise with both college/graduate students and experienced individuals looking to improve their skills. I specialize in a "Learning by Doing" teaching style, which emphasizes applying practical knowledge during the learning process. Thank you for taking the time to review my profile, and I look forward to working with you soon.
Profile isn't claimed yet
Available services

Reviews

Service as described 4.6
Communication 4.6
Punctuality 4.6
AT
Thanks to Marco, I received exceptional tutoring and gained a vast amount of knowledge in a brief period. He was instrumental in guiding me through a significant project and ensuring that I submitted a high-quality work product. Sincere appreciation goes out to Marco!
March 16, 2023
SJ
Marco exceeded my expectations with his impressive knowledge and professionalism. Opting to work with him will undoubtedly be a decision you won't regret.
January 21, 2022
RC
Our MS Access database was virtually non-functional. Thanks to Marco's expert guidance through Zoom screen sharing, we were able to pinpoint and eliminate the issue causing the system to crash within an hour, and he even provided us with helpful tips to optimize our database for faster operation. Marco impressed us with his excellent technical knowledge, professionalism, and interpersonal skills, and I highly endorse him!
January 4, 2022
JJ
Marco is an outstanding guide who promptly addresses my inquiries. He imparts ample knowledge, enabling me to learn something new every day. I highly recommend him!
November 8, 2021
WM
I was taught SQL by Marco, who proved to be incredibly supportive and accommodating of my schedule. His assistance proved invaluable, leaving me with no hesitation in recommending him wholeheartedly. He is truly the best.
October 9, 2021