Pro Ind Eng/Data Analyst Specializing in Access,Excel, VBA and SQL
Pro Ind Eng/Data Analyst Specializing in Access,Excel, VBA and SQL
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.
Marco has provided examples of their subject expertise by answering 9 questions submitted by students on Wyzant’s Ask an Expert.
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
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
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 scriptsRahul, 1 lesson with Marco
Marco is very patient -
I appreciate his help.Erin, 2 lessons with Marco
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
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
Response time: 45 minutes