- Design and maintain reporting and analysis database. - Design integrations with external and internal platforms and applications. - Perform analysis and reporting of information (forecast, cost, KPI).

Responsibilities: • Designed and developed database applications and solutions. • Database performance tunning. • Application support for mission critical applications. • Application migration from on-prem to cloud based. Project 1 - Virtuoso • Maintained Azure SQL database (user creation, backup restore, permissions, partitions). • Created Azure Data Factory pipelines to feed information from Agencies to VMS Azure SQL database. • Developed a validation engine to validate data being feed into VMS database. • Developed a partition engine to coordinate execution of ETLs to feed VMS database. • Researched on Neo4j graph database and its application to Virtuoso data mining process. • Coded new functionality for an iOS and Android app using ionic framework. • Resolved bugs raised by application user on the app. • Proposed and developed improvements to current algorithms. Project 2 - Atlantic57 • Migrate a web application from physical infrastructure in vendor's location to AWS. • Configure AWS VPC public and private subnets. • Set up EC2 instances to execute a MongoDB cluster, a Kafka cluster, a Storm cluster and a Rosoka natural language processing service. • Configure EC2 instances to execute java processes to implement backend services. • Provide support to AWS infrastructure and work in bug fixes. • Write draft of failover and disaster recovery plans.

Project: Design and Implementation of Spy Optic data warehouse using dimensional models. Apply significant professional experience and training in information technology and computer programming to the analysis, design, modification, and maintenance of application programs, integrated systems, and/or software solutions. Responsibilities: • Develop SSIS ETLs using SQL Server and Visual Studio. • Help define the strategy, architecture and vision of the organizations technology initiatives alongside the Director, IT. • Provide leadership in areas of the development process, including development standards and practices and architect, design and develop web applications. • Perform administrator and development functions as dictated by the needs of the business within web applications. • Partner with business units to understand their current and future needs, then collaborate with vendors and in-house team members to ensure those needs are met. • Partner with the ERP, Business and Technology teams to develop processes, improve reporting, and provide system enhancement. • Work with the team to develop features for existing service- orientated .NET application using C# and Object Orientated programming. • Add functionality to web services either SOAP or REST and integrate API’s. • Build out data access layer components using T-SQL stored procedures and SQL Server. • Web Application support new applications including JS/XML/JSON. • Realize database design, data feeds and data exchange. • Oversee the implementation, performance and maintenance to internal, ,external and third- party integrations. • Creation and execution of SQL scripts against Great Plains databases. • Administration and Tuning of database environments.

Project: Create and validate architectures and database designs for applications aimed to automate and streamline Nearshore's and Nearshores's client's processes. Technologies: SQL Server, MySQL, Aqua Data Studio, C#, Visual Studio, PowerShell, SSIS, HTML, CSS, Analysis and Design of Algorithms.

Reporting and BI Consultant 08/2012 – 05/2015 Design and implent custom reporting solutions for United BioSource Corportation (UBC) to report on client health, status and service to several UBC clients. Architect solutions to automate manual work in order to streamline the complete reporting process. BI Leader /Architect 05/2010 – 08/2012 Architected custom-coded solutions for the Medco Warehouse that enabled them to enter the European market. The solution consisted of two data warehouses. One transactional for analysis and daily operations and the other data warehouse was implemented using a dimensional approach for reporting. Consultant 10/2008 – 05/2010 The performance team reviewed all PL/SQL code written for Accredo Health Care and complied with performance standards, which included execution time, disk access and optimization of Oracle resources. BI Consultant 02/2008 – 10/2008 The Global Business Intelligence project implemented the entire suite of Oracle Business Intelligence Enterprise Edition across multiple functional areas including Supply Chain, Order Management, Finance, Human Resources and Sales Technologies: Informatica PowerCenter, Ab Inito, Multithreading, Analysis and Design of Algorithms.

Project: Managed a team of developers and testers that migrated the GE Treasury Debt and Derivatives Information from the Infinity system to WTC Systems. Responsibilities: • Managed the project plan and oversaw the fulfillment of the plan goals. • Elicitated business requirements and converted them into functional specifications. • Created documentation using relational models and UML notation. • Designed, implemented, tested and deployed migration modules. Debt and Derivatives (EAI): Managed and mentored a technical team of consultants working on developing custom applications. • Translated business requirements into functional specifications. • Provided risk analysis. • Created documentation using UML notation. • Designed, implemented, tested and deployed applications to grow the debt and derivatives platform for GE Treasury. • Deployed the applications by using layered, repository and MVC architectures as well as several design patterns. • Provided oversight and mentoring to an offshore development team. Application Support: • Managed a project that provides global support to the GE Treasury Debt and ,Derivatives Platform. • Led a team of three application support members near shore and five more offshore. Technologies: Waterfall and GE development life cycle, Analysis and Design of Algorithms.

Project: Assisted the associate professor in class preparation and grading of students’ projects. Responsibilities: • Gave exams and homework to students. • Provided assistance to the students in the development of their projects and homework.

Application Development: Developed a custom application for the personal use of the Secretarial of Social Development. • Translated business requirements into functional specifications. • Created documentation using relational models and UML notation, design, implementation and testing of applications using object technology. • The applications developed were used in the analysis and processing of social and economic information, and managing personal information and they used MVC and repository architectures. Data Processing: Generated programs to arrange information about Mexican poverty measurement and evolution in order to present it to the Secretarial. • Compared various methodologies for the measurement of poverty. • Modeled repositories by applying relational models to efficiently access the information processed.

Institutional Department of Training: Managed a team of three developers that developed an application for managing the training process of INEGI’s employees. • Provided documentation using OMT notation, analysis, design, implementation, testing and deployment of applications using object technology. • Designed modules to keep information about courses, grades, employee information; modules to follow up employees inside a career path; modules to analyze and produce statistical information of the training process. Data Processing and Research: Developed and delivered a Visual C++ application to assist in the research of Mexican poverty. • Developed this application with layered and MVC architectures. • Included modules to process statistical and historical information from several sources concerning vital statistical information about Mexican poverty. • Ran simulation modules to tune up public assistance and modules to present information in different formats at different levels. Payroll and Human Resources: Developed a custom application to assist the human resource process and to generate payroll for INEGI’s employees. • Developed modules for the hiring process and working affairs. • Generated payroll and reported payroll information for other governmental institutions.