Design and develop ETL processes to extract data from a variety of sources, cleaning and transforming it and store it to be used in client's financial analysis and reports. Ensuring consistency and integrity of data and correction if required. Optimizing models in collaboration with business analysts for data quality. Integrating data from a variety of sources following the client's business logic Design, develop and maintain Power BI reports using different data sources generating enriched charts to help client's decision-making. Gathering requirements from business to generate "Business Requirement documentation" for new Developments and solution improvements. High-quality documentation for business logic and technical processes that meets client standards and assists client internal and external audits. Advise the client on best practices and process improvement opportunities, as well as the implementation of new technologies that best fit their needs. Help the client achieve their business goals using technology to generate solutions aligned with their mission. Organize weekly meetings to report the progress of tasks and discuss improvements in project management.

TegraGlobal | Apr 2020 - Sep 2022

Business Intelligence Engineer

Responsible for researching and analyzing company data to support analysis by the business. Examining the data company stores and studying how it affects business operations and profitability. Design data models Maintenance for data structures on companies’ Data Warehouse (SQL Server) Design and development of ETLs to migrate data from several databases to companies’ Data Warehouse Help users with PowerBI creating reports Create Data EDI Flows using DELL Bommi platform to communicate with clients

TegraGlobal | Feb 2017 - Apr 2020

Senior Analyst Developer

systems on every subsidiary for TegraGlobal in El Salvador, United State and Honduras. Maintenance for data structures on companies’ Data Warehouse (SQL Server) Design and development of ETLs using SSIS to migrate data from several databases to companies’ Data Warehouse Help users with PowerBI dashboard creating reports Create Data EDI Flows using DELL Bommi platform to communicate with clients: o Create inbound flow (receiving EDI files from clients and converting into json files) o Create outbound flow (converting json files into EDI files and sending to the clients) o Deployment and configuration of Atom host Get and Validate requirements of user needs Analyze and design solutions for process automation Detect problems and propose solutions and improvements of both current and developing systems Design data models Support and attention to users Maintenance for the current ERP in El Salvador, United States and Honduras, and WMS for the factories in USA Develop of new features for all the ERP in every factory and the WMS for United States

Universidad Centroamericana "José Simeón Cañas", UCA | May 2008 - Jun 2016

System Analyst

Both as an analyst-coordinator and software developer for the financial and human resources area of the Central American University 'José Simeón Cañas'. Leave and validate requirements of user needs Analyze and design solutions for process automation Detect problems and propose solutions and improvements of both current and developing systems Design data models Creation of technical and user documents Prepare and assemble production servers Trainings for the users Support and attention to users Management and coordination of work teams Project management

Universidad Centroamericana "José Simeón Cañas", UCA | Sep 2014 - Nov 2014

Free Software course Professor

Courses for the use of Free Software at basic level to perform the daily operational tasks of the administrative and operational staff of the University. To prepare classes and exams. To advise the students. Teaching classes.

Universidad Centroamericana "José Simeón Cañas", UCA | Nov 2013 - Aug 2014

Free Software Diploma classes Professor

Diploma for the use of Free Software with productivity objectives, part of the migration plan to Free Software of the administrative and operational area of the University. Prepare classes and exams To advise the students Provide modules of: Ubuntu operating system LibreOffice Productivity tools in GNU Linux

Universidad Centroamericana "José Simeón Cañas", UCA | Feb 2013 - Oct 2013

Graduation Work Counselor

Counseling multi-disciplinary graduation work. Advise for the successful completion of the graduation work to students of accounting and computer science Review and correct document in form and content

Universidad Centroamericana "José Simeón Cañas", UCA | Aug 2012 - Dec 2012

Professor

Professor of the subject "Fundamentals of programming" Teaching classes Prepare laboratory practices Prepare and review assignments and tests To control instructors Take student inquiries

SVNet El Salvador | Jun 2010 - Nov 2010

Analyst Programmer

System upgrade for collection and administration of .SV domains Design the solution Web interface design Programming and implementation of the web application

My Education

Take a look at my formal education

Bachelor’s Degree, Information Technology in Computer ScienceUniversidad Centroamericana 'José Simeón Cañas' | 2009

About Me

I'm a Data enthusiast, trying to improve my Data knowledge

Create Your Data Portfolio for Free