Miguel Angel Heredia Moreno

Miguel Heredia Net developer/SQL Developer Merida, Mexico (GMT-6) (--https://www.linkedin.com/in/miguel-heredia-mx As a Net Developer with over 20 years of experience, I have extensive knowledge of the Microsoft stack, including C, C++, C#, and Microsoft SQL Server. I have successfully completed various AWS projects, following Agile methodologies and utilizing Jira for efficient project management. Throughout my career, I have held various roles in management, development, data engineering, and infrastructure, enabling me to gain a holistic understanding of the IT landscape. My expertise lies in designing, troubleshooting, monitoring, tuning, and scaling infrastructure, which has been instrumental in delivering high-quality projects on time and within budget. As a passionate mentor and team player, I thrive in collaborative environments and enjoy sharing my knowledge and expertise with others. Additionally, I am a self-learner and have a proven track record of integrating new tools to solve project problems. I am committed to staying up-to-date with emerging technologies and trends and have a genuine passion for Information Technologies. EXPERIENCE Net developer as freelance — January 2023 – Present Developing new features for ASP .NET and SQL projects ● ● Porting .net 4.5 code to .net core ● Replicating a production AWS environment to a developer environment ● Document parts of AWS production environments on Confluence ● Following agile methodologies and using Jira Data Engineer support for Qentelli — November 2022 – April 2023 Document, design, and implement workflow pipelines (ETL) using Tidal Enterprise, Informatica Power ● Center, Redshift, Snowflake, and AWS Glue ● Design and implement monitoring tasks for ETL jobs using DataDog and AWS Cloudwatch ● Remote, 100% English position Tech lead at La Bolita (Lottery betting company) — May 2016 – September 2022 I lead the IT workforce on a nationwide lottery sales force, a heavily IT-dependent business for 1,5000 ● POS terminals, and a 250 people operation team in 28 states. ● I have worked on improving the response times multiple times a year from seconds to milliseconds, a key factor for lottery systems, mainly on the database and backend. ● Coordinate and implement measures needed for scalation demands. ● Responsible for the on-premise backend business continuity ● Design and lead the software development team to introduce new features ● Participated in the design and implementation of the cloud web sales portal using AWS infrastructure, and technologies like Sybase on the database, F5 load balancing, and firewall, and EC2 to expand our sales channels. ● Built a monitoring system to watch the infrastructure of VMWare, Windows Servers, and Linux Servers, using software like LibreNMS, PRTG, and Nagios ● Participated in the design, development, and deployment of the Android Client version of the main lottery application including the porting of the main C library for the ISO8583 protocol ● As a manager, I coordinated the growth of the operations, call center and technical support departments and implemented a Redmine instance to manage it. Core Support Manager at Stablehost— June 2015 – May 2016 ● I worked as a level 3 support technician replying to the escalated support and abuse queues on the graveyard shift, also delegating and teaching some of the repetitive duties to the level-1 technicians. ● Monitoring, managing, and supporting the infrastructure for Linux Centos, cPanel/WHM, WHMCS, and CloudLinux servers. ● A completely remote position 100% in English ● I have learned a lot about working with highly demanding servers for hundreds of users at a time. It's an opportunity to watch live loads for hundreds of users for many different systems Senior Developer and SQL Server DBA at La Bolita — February 2013 – June 2015 ● Worked with a development team to develop a transactional switch using the ISO8583 protocol on C# for a lottery and sales backend to offer better concurrency (also ported the main protocol library from C to C# and Android Java). ● Expanded our POS devices fronted software communicating with ISO8583 protocol ● Worked on the operations frontend on a Winforms C# application and an ASP.NET portal for sales ● Our team implemented a series of PowerBi dashboards to provide a better insight into sales. Because of this, we had a better understanding of our market and their betting habit and implemented new ways to play. Infrastructure Manager at La Bolita — January 2012 – January 2013 ● Implemented a complete lottery system involving VMWare infrastructure, Microsoft Windows Server, Microsoft SQL Server, and Linux servers running on HP Enterprise hardware. ● Designed a complete backup strategy using Veeam, Synology, and DataProtector ● Supervising the network team to fulfill our communication deployment and security policies SKILLS Programming Languages: ● Advanced: .NET C#, MS SQL Server (10 years), C for Ingenico Devices (Telium PLUS SDK, T2, and Tetra platforms), C++ ● Intermediate: Informatica PowerCenter, AWS Glue, Airflow, PHP, jQuery Mobile, jQuery, CSS, HTML, and Android Development ● Beginner: Python Data Base: Advanced: SQL Server (10 years) (stored procedures development, profiling, tuning and managing), OLTP Systems (8 years), Data Integration (8 years), ETL Jobs (6 years) Intermediate: MySQL and Sybase Languages: Fluent: English (C1); Native: Spanish Other: Git (5 years), Networking firewalls (Fortinet, Mikrotik, Hillstone, Cisco), Electronics enthusiast (Arduino, Raspberry PI, Embedded hardware), Crypto enthusiast (Tradingview API, Binance API, other crypto API for trading purposes) EDUCATION Instituto Politecnico Nacional, IPN: – CDMX, Mexico, Software engineer, May 2016 Instituto Tecnologico de Merida,ITM: – Merida, Mexico. Computer systems engineer May 2000 Certifications ● AWS Cloud Practitioner in training (2021 Udemy and AWS) ● Routing and Linux networking experience (2005) ● Ingenico Telium SDK training (Tetra T+ framework) (Ingenico 2017) ● Udemy training: Learn C++ (Basic/Intermediate/Advanced), Git for Geeks, Leadership essentials for career development, Python A to Z ● Other training: AWS Glue, SAP FI Module, Budgets design, Parallelism and distributed computing, Security awareness foundations 🞂 Page 2 |-