Analyst / Python Developer
San Pedro Garza Garcia, Nuevo Leon, Mx
• Originally hired as an analyst; from day 1, leveraged programming skills to improve internal firm processes and create advanced analyses for our clients. Transitioned to a full-time Python developer after 12 months.• Entrusted with creating and conducting a training seminar in Python skills for my colleagues, including consultants up to 10 years my seniors.• Used Pandas, Numpy, Statsmodels to create sales / logistics forecasting and planning tools for our clients.• Utilized Qt, PyQt5 and QtCreator to create simple GUIs, and fbs / NSIS to package the apps into installers.• Created SQLite and PostgreSQL databases with automatically triggering PL/SQL scripts and accessed them from Python using sqlite and psycopg.• Scraped many different data sources using Scrapy, BeautifulSoup / requests, and Selenium; communicated with various APIs to extract information / conduct analyses (e.g.: Bing Maps API).• Simulated a complex system through Object-Oriented modeling and optimized it using machine learning and heuristic algorithms. No machine learning library was used for this, since the methods required for simulated annealing were built into the custom object models.• Exported analysis results to Excel spreadsheets using openpyxl and created data-driven Powerpoint presentations using python-pptx.• Participated in the solution of business problems in the Manufacturing and Retail sectors, regarding commercial strategy, capability development, inventory management and corporate governance.