Scroll To View More
Hire the top 3% of freelance developers
Luis Angel Chamosa Aparicio

Luis Angel Chamosa Aparicio

Mexico City, Mexico
Member since September 12, 2012
As a senior software engineer, Luis has worked on all project phases, from gathering functional and technical requirements to designing and developing solutions. He has managed IT teams using Scrum. He can work efficiently with people under his command, as a contributing member of a team, or as a solo developer. He has 15 years of professional experience focused on innovating and creating custom applications.
Luis is now available for hire
Portfolio
  • Global HITSS
    Visual Studio 2015, ASP.NET MVC 4, SQL Server 2016, T-SQL, Entity Framework...
  • Reclu IT
    Visual Studio 2013, ASP.Net MVC, WebAPI, SQL Server 2012, SSIS...
  • DEINTEC
    Scrum, Team Foundation Web Access 2012, Team Foundation Server SQL Tools...
Experience
  • Microsoft SQL Server, 18 years
  • T-SQL, 18 years
  • Crystal Reports, 15 years
  • C#, 15 years
  • Database Modeling, 11 years
  • ASP.NET, 9 years
  • ASP.NET MVC, 6 years
  • jQuery, 5 years
Mexico City, Mexico
Availability
Part-time
Preferred Environment
Anything that works with .NET MVC and SQL Server
The most amazing...
...thing I've designed and coded is a mathematical system for automating management of authorization flows for a contract management system.
Employment
  • .Net Senior Engineer
    2016 - PRESENT
    Global HITSS
    • Worked for Esurance USA remotely using a VPN and a Virtual Machine located in Esurance’s headquarters in a multicultural team.
    • Developed and maintained improvements to the main system for policy administration.
    • Addressed existing support tickets and added bug reports to the system.
    • Created solutions related to Esurance services built in WCF and made several improvements to minimize production errors.
    • Analyzed data issues, writing queries on SQL Server 2016 and looking for data inconsistencies, to provide data corrections and check for bugs or logic errors.
    • Analyzed performance in stored procedures using SQL Server Execution Plan to improve them and changing the T-SQL code.
    • Implemented Team Foundation Server as the code repository.
    • Led technical projects, providing support, guidance and assigning tasks to team members from India and Mexico.
    • Attended meetings with Esurance managers and technical leads to discuss recurrent issues and how to solve them.
    • Attended team meetings to provide task status weekly.
    • Provided guidance/assistance to other teams to solve their incidents.
    Technologies: Visual Studio 2015, ASP.NET MVC 4, SQL Server 2016, T-SQL, Entity Framework, jQuery, Team Foundation Server, WCF, C#, XSLT, XML, JIRA
  • .NET Senior Developer
    2015 - 2016
    Reclu IT
    • Consulted for Walmart Mexico headquarters. The project’s objective was to migrate old ASP websites to ASP.NET MVC and WebAPI.
    • Analyzed code for ASP web pages with the purpose of migrate them to ASP.NET MVC.
    • Wrote technical documents to migrate ASP websites to Visual Studio Solutions for ASP.NET MVC and WebAPI.
    • Architected the new service layer, working closely with Microsoft consultants.
    • Developed WebAPI services for the service layer.
    • Developed web pages using ASP.NET MVC, jQuery, and CSS.
    • Developed the back-end and data access using Entity Framework, taking either a database-first or code-first approach, depending on context.
    • Designed databases, adding new tables to the current DB and improving some relations, indexes, and schemas, among other things.
    • Developed new stored procedures for SQL Server 2012 using T-SQL.
    • Wrote SSIS services to migrate data between databases; some were migrations from DB2 to SQL Server or Informix to SQL Server.
    • Implemented Team Foundation Server for code and database versioning.
    • Attended scrum meetings.
    Technologies: Visual Studio 2013, ASP.Net MVC, WebAPI, SQL Server 2012, SSIS, Entity Framework, jQuery, Team Foundation Server, T-SQL
  • Technical Project Manager
    2014 - 2015
    DEINTEC
    • Handled management of the development team and estimated the project scope for each sprint, as well as the general scope and product backlog.
    • Attended meetings to review the scope and deliverables with the customer.
    • Served as the scrum master and point of contact between developers and customers.
    • Provided technical direction for development, design, and on-site systems integration.
    • Provided technical direction to manage SQL Server databases and source code using the Microsoft Team Foundation Server.
    • Created and executed development plans and reviewed them as appropriate to meet changing needs and requirements.
    • Gathered user requirements and wrote user histories with the business analyst under my command for new projects.
    • Switched roles as necessary to DBA or IT architect. Worked with Scrum methodology.
    • Reviewed code quality and database design. Made the most important decisions related to DB design and coding.
    Technologies: Scrum, Team Foundation Web Access 2012, Team Foundation Server SQL Tools, SQL Server 2008 and 2012, Visual Studio 2012, Framework 4.5, C#, ASP.NET MVC, jQuery, JSON, JavaScript, Entity Framework, UML
  • .NET Senior Engineer
    2013 - 2014
    Softtek Mexico
    • Managed configurations and TFS, including version control, branches, and deliverable packages.
    • Developed web features using ASP.NET MVC but focused on back-end and WCF services.
    • Transferred knowledge of the full database model to developers. Made database changes and version control as the development DBA.
    • Developed SSIS packages for imports from Oracle to SQL Server 2008. Also worked on SSIS deployments and how to trigger them using SQL Jobs.
    Technologies: SQL Server 2008, Oracle 11g, SQL Server Integration Services, Visual Studio 2012, Framework 4.0, C#, ASP.NET MVC, jQuery, JSON, JavaScript, Entity Framework, Linq
  • Freelance Senior .NET Developer
    2012 - 2013
    American Mortgage Consultants, Inc. (via Toptal)
    • Analyzed and designed a database for business intelligence.
    • Improved the production database, adding indexes and reviewing the T-SQL code in stored procedures, functions, and views.
    • Migrated from DTS packages to SSIS packages.
    • Developed improvements in ASP.NET MVC.
    Technologies: SQL Server 2005, SQL Server Integration Services, Visual Studio 2012, Framework 4.0, C#, ASP.NET MVC, Microsoft Enterprise Libraries, UML
  • Senior .NET Developer
    2011 - 2012
    Pegaso Tecnologias
    • Designed and developed programs using WCF and ASP .NET MVC with jQuery, JSON, and Ajax.
    • Helped design and develop the core objects for the “Digital Billing Universal Mailbox” project.
    • Analyzed and designed new tables on SQL Server and developed stored procedures and functions.
    Technologies: SQL Server 2008, Visual Studio 2010, Framework 3.5, WCF, C#, ASP.NET, ASP .NET MVC, Microsoft Enterprise Libraries 5.0, JavaScript, AJAX, Linq to Objects, UML, Team Foundation
  • Technical Leader
    2007 - 2010
    XCOMIT Consulting
    • Worked with XCOMIT´s clients, focusing on the most important one, "Banco Compartamos."
    • Developed WCF services as part of SOA architecture to be consumed for several programs and web pages.
    • Developed stored procedures, views, and functions on SQL Server to be consumed in a data access layer to many projects.
    • Designed SQL Server databases as part of the core banking system.
    • Ensured code quality on some projects, following Microsoft best practices and customer standards. Developed a “parser” program to handle tasks promptly and accurately.
    • Designed an SOA architecture for the “payment management” project and designed a database for the same purpose, all under Microsoft consultants’ validation. Served as technical leader and worked with eight developers under me using Scrum methodology.
    • Did business analysis on several projects. Handled use case diagrams and use case documentations.
    • Configured and managed the SQL Server Reporting Services and coached other developers in report creation.
    Technologies: SQL Server 2008, Integration Services 2008, Reporting Services 2008, C#, Visual Studio 2008, Framework 3.5, WCF, Erwin, Project 2007, UML, Team Foundation
  • .NET Technical Leader
    2005 - 2006
    Consultoría TI S.A
    • Performed tasks related to requirements analysis and use cases. Defined the “Point of Sale” application’s architecture. This application was requested to be a “smart client.”.
    • Designed the database model for the point of sale application, using the third normal form.
    • Monitored my work team’s activities and quality of deliverables.
    Technologies: Visual Studio 2005, C#, SQL Server 2005, ASP.NET, Web Services, .NET Remoting, SOA, Microsoft Enterprise Libraries, Enterprise Architect, UML, Windows Server 2003
  • Project Leader
    2004 - 2005
    ITE Soluciones S.A
    • Led the “Billing and Inventory Management System” project.
    • Architected .NET functionality and modeled the database.
    • Monitored the development and quality of the development team deliverables using SQL Server .NET “best practices.”.
    • Developed ASP .NET pages and some stored procedures and functions.
    Technologies: SQL Server 2000, Visual Studio 2003, C#, ASP.NET, Microsoft Enterprise Libraries, Ajax, SAP, Source Safe, Enterprise Architect, UML, Windows Server 2003
  • Senior .NET Developer
    2003 - 2004
    INFOTEC
    • Developed ASP .NET web pages for different projects and developed stored procedures and views.
    • Did analysis and design for the “appraisal” project, diagramming use cases and writing technical documents with class diagram and sequence diagrams.
    Technologies: SQL Server 2000, Visual Studio 2003, C#, VB.NET, ASP.NET, JavaScript, Informix
Experience
Skills
  • Languages
    C#, T-SQL, CSS, VB.NET, JavaScript, Visual Basic 6 (VB6), UML
  • Tools
    Microsoft Team Foundation Server, Visio, Crystal Reports, Enterprise Architect, LINQ to SQL, ERwin
  • Paradigms
    Scrum, Model View Controller (MVC), Object-oriented Programming (OOP)
  • Platforms
    Windows, Oracle
  • Storage
    Database Modeling, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server 2012, SQL Server 2008 R2, SQL Server 2000, SQL Server 2008, SQL Server Reporting Services (SSRS), JSON
  • Other
    User Stories, System Design, Pattern design, IIS 7, IIS 8, Architecture, Project Management
  • Frameworks
    Entity, ASP.NET, ASP.NET MVC
  • Libraries/APIs
    jQuery
Education
  • Degree in Applied Mathematics and Computing
    1999 - 2004
    Autonomous National University of Mexico - Mexico City
Hire the top 3% of freelance developers
I really like this profile
Share it with others