About
I am a professional who is passionate about learning and using new technologies. Since the world and technology are constantly evolving, it is important to be updated to provide the right services to our customers, so they can transform data into useful knowledge that allows timely decision making for the business.
Data Scientist & Full Stack .Net Developer.
General Information
- Birthday: April 6, 1965
- Website: franciscomercado.eco2.mx
- Phone: +525517821422
- City: Mexico City
- Degree: Master's in Data Science
- Email: fmercado00@hotmail.com
- Employee: Agilethought
Facts
In my professional career I have had the opportunity to contribute with different companies and types of projects including software development, technological infrastructure and outsourcing of the systems department supervising the development, technical support and database deparments.
Companies I've worked for
Projects
Current Certifications
Skills
Below are listed the different tools I have worked on in my professional career.
Programming Languages
- C#
- Python
- Visual Basic.Net
- ASP Classic
- ASP.NET WebForms
- ASP.NET MVC 5
- ASP.NET Core 3
- ASP.NET Core 5
Frameworks
- React JS
- Entity Framework
- JQuery
- Bootstrap
- Durandal JS,
- Knockout JS
- Kendo
Methodologies for Data Science Projects
- CRISP-DM
- Catalyst
- TDSP
Web Services
- WCF
- WebApi
- Restful
- Service Fabric
DataBases
- Microsoft SQL Server 2000 - 2019
- Informix 11
- Oracle 9i
- MySql
- SQLite
Source Control tools
- Git
- TFS
- SVC
Data Science tools
- Python
- R
- Anaconda
- PyCharm
- Pandas
- Numpy
- PySpark
- Databricks
- Microsoft Azure Machine Learning
Microsoft Cognitive Services
- Computer Vision
- Speech to Text
- Speaker Recognition
- Text Analytics
- Speech Translation
Resume
Deep background in artificial intelligence, machine learning, human-computer interaction, technology, cognitive science, analytics, product and user experience, and consumer insights.
Sumary
Francisco Javier Mercado Colunga
I am a data scientist and .Net developer with extensive experience in the Backend side, I have developed Restful Web API and with experience maintaining applications in the Frontend specially with React. On the data science, I have extensive knowledge in Azure Databricks, PySpark, Azure Machine Learning, Azure Cognitive Services. And I have provisioned, set up and managed resources in Microsoft Azure Cloud. In addition, I have supervised teams with sizes from 3 to 9 members.
Agilethought
- Marina Nacional 60 piso 3, Tacuba, Miguel Hidalgo, 11410 Ciudad de México, CDMX.
- francisco.mercado@agilethought.com
Education
Master of Data Science
2021 - 2022
Universidad del Valle de México
Software Engineer
2016 - 2018
Centro Nacional de Evaluación para la Educación Superior
Certifications
Microsoft
Scrum
To see the complete transcript click here
Other Courses
- Introduction to Spark SQL in Python, Datacamp, 04/2022
- Machine Learning with Python – from Linear Models to Deep Learning, MITx, 12/2021
- Intro to Machine Learning, Kaggle, 10/2021
- 6.00.1x: Introduction to Computer Science and Programming Using Python, MITx, 08/2021
- Introduction to Python, Datacamp, 12/2019
- Scrum Master Certification Course, Stratominds, 2019
- Cleaning Data in R Course, Datacamp, 02/2019
- Importing Data in R (Part 2) Course, Datacamp, 02/2019
- Importing Data in R (Part 1) Course, Datacamp, 01/2019
- Introduction to the Tidyverse, Datacamp, 01/2019
- Intermediate R, Datacamp, 12/2018
- Introduction to R, Datacamp, 12/2018
Professional Experience
Net Developer Sr.
October 2020 - Present
Agilethought, Mexico City
- Online and Mobile Banking application development for a client in USA. I developed web service endpoints for one-time and recurrent transactions and stop payments.
- Internet Banking Application. I implemented the integration with Meridian Link to avoid repetitive user logins.
- FIS SSO integration.I implemented the functionality for getting the SSO Packet to integrate Online and Mobile Banking app with FIS to avoid repetitive user logins.
- Login Tracking Dashboard. I implemented several visualizations in Power BI to provide relevant information about login access from OKTA and new enrollments from MISER system. Technologies
- C#Web ApiAPI Management ServiceAzure DevopsCI / CD
Jira
Net Developer Sr.
April 2019 - October 2020
Jenkon, Cancún, Quintana Roo, México
- Support to software applications adding new features to the corporate portal, the business portal, and the personal website for Yanbal, their customer in Perú Technologies:
- C#WCFDurandal.jsKnockout.jsjQuery
SQL Server 2017GitJiraAzure ReposJenkins
Technical Partner.
July 2002 - April 2019
E-Integrators Consulting, Mexico City
Client: Servicios de Evaluación en Línea SEL
- Migration from Colocation Services to Azure Cloud
- Vitual Machine Creation, Internet Information Services Configuration, Web Sites setup, and application developmet
- Supervision of development of several portals to evaluate employees.
- Development of Web API to export candidates results.
- Supervision of development of BEPENSA performace evaluation system.
- Supervision of development of IENOVA performace evaluation system.
- Supervision of development of Online Recruitment System.
- Supervision of the redesign of the SEL Web Site.
- Integration with Corporativo Peña Verde thru WCF services.
- Supervision of development of Upload your remume system. Technologies:
- C#ASP NET Web FormsWCFWeb APINet Framework 4.7.2jQuery
SQL Server 2017GitNet Core 3.1Azure Virtual Machines
Client: Tax Editores Unidos
- outsourcing of the IT Department
- Lead the team to support the DataBase, Development and Technical Support deparments
Client: AztlanDigital
- Development of Axa Insurance Benefits and notification system for 4,200 employees. SAML was used as SSO to integrate AXA Security System to the Benefits system.
- Development of the Axaboo and find the password game. To promote the importance of using strong passwords.
- Development of Guía de Expertos web site. To create a directory of qualified speechers of the Universidad Pedagógica. Technologies:
- ASP.NET MVC 5SQL Server 2016 Standard
Client: Walmart de México y Centro América
- Support of Credit System, Payment Services System.
- Update applications to support TLS 1.2
- Support to the Sales IT Department by configuring its server to certify the TVP payment process and by adding the proper logic to the existing programs.
- Setup of five servers for the kiosks systems that support the billing system for more than 2,000 shops. Technologies:
- Classic ASPASP.Net Web Forms
Client: TV Azteca
- Support of the Schedule transmition system for Azteca America
- Reduce loading information time from Nielsen’s CSV into Oracle Database from two hours to five minutes.
- Development of prototypes (ASP.Net Web Forms, Genexus, Silverlight, MVC) using Active Directory Federation Service authentication.
- Provided support to the setup of Business Objects Server and minor changes to existing reports.
- Development of security best practices when coding using HP Fortify.
- Migration of Schedule TV applications using Java, JBoss and Angular JS. Technologies:
- Classic ASPASP.Net Web Forms
Client: Pepsico
- Development of the Training Administrative System.
- Development of the Live Healthy Content System.
- Adding new features to Fundación Sabritas application.
- Development of the evaluation and optimiation model for Quaker, Pepsi, Sabritas and Gamesa products.
- Development of the PORHTAL application for HR. Technologies:
- Oracle 9iInformixJRUN 3.0JSPJavaBeans
Freelance Consultant
June 2001 - July 2002
WINT
- Developement of logistic wokflow for Sabritas Distribution Centers. Technologies:
- Ultimus 5.0Activex Controls
Microsoft Certified Trainer
April 1998 - June 2001
Compueducación - Intersoftware Training
- Training on Microsoft Products as Visual Basic, Windows 2000 Server, SQL Server 2000 Technologies:
- Visual BasicWindows 2000 ServerSQL Server 2000
Project Lider
June 1987 - April 1998
Sabritas S DE RL
- Support of Administrative Systems as GL and AP
- Development of the Industrial Spare Parts
- Development of the Factory Maintenance System
- Lead the network installation in Obregon Plant, Merida Office, Poniente 128 Office and Research and Development Office
- Set up of the Active Directory infrastructure
- Deployment of the Interamigo application in five plants and the corporate. Technologies:
- Visual BasicPower House for HP3000Windows NT 4Cobol 3000HP OpenView
Developer
April 1986 - May 1987
Instituto Nacional de la Nutrición
- Support of Hospital Administration System Technologies:
- Cobol 3000HP OpenView
Portfolio
Here you can find some projects and repositories I have worked with. I am presenting them in chronological order.
Testimonials
Francisco Javier Burkle
Dir. Sistemas y Planeación Estratégica
Demostró un gran sentido de responsabilidad y probidad, por lo cual no tenemos inconveniente alguno en recomendarlo.
Eduardo Alarcón
Coaching & Counseling in IT & HR.
Posee un alto espíritu de innovación y creatividad lo cual aplicó en forma excepcional a los proyectos en los que participó; además acomete con un alto sentido de responsabilidad y compromiso los proyectos de desarrollo de soluciones informáticas en los que ha participado, excediendo siempre las expectativas de calidad y servicio previamente definidas para sus proyectos.
Carlos González
Partner en Servicios de Evaluación en Línea SEL
Realizó un excelente trabajo dentro de nuestra organización.
Sherri Mead
Dir Client Portfolio Mgmt
Just wanted to touch base with you to let you know who disappointed I am to see that you are departing our team. You have been a great asset to the Yanbal project and have significantly contributed to our overall progress.
Erik Lindgren
Senior Consultant
Paco loves to solve problems. No problem is too large. He has shown versatility in his ability to help various teams at VyStar resolve bugs and contribute to solutions.
Kenneth Sitjar
Digital Experience Product Analyst
I look forward to watching you on LinkedIn as you continue to gain new skill sets and achieve new heights in your career! It was a pleasure working with you. You are definitely a valuable asset and anyone who gets to work with you will be super lucky.
Spark repositories
Examples from basics to advaced topics on Spark
Text Analitycs Services
Language Detection and Transalation Services