Alejandro Villagómez Email & Phone Number

Zapopan, Jalisco, México

Create SQL queries for Health sector and use Pentaho to create reports.

Ciudad De México, México

• Used Amazon Redshift and Postgres to create queries to get nancial and client information for other parts of the company toconsume, ensuring that the information is current and correct.• Used DBT to Extract, Load and Transform data into other tables using best practices.• Created monitoring of data sources with Bash and Python to maintain quality and integrity.• Automated scripts and queries excitations to free users from these manual tasks.• Used Git to control data pipeline and update teams on code changes.• Gathered requirements, created tasks and documentation and for several processes.

Guadalajara, Jalisco, México

• Ensure positive customer experience, about their production environment.• Resolve tickets within the agreed SLA.• Create and maintain reporting documentation and user guides• Working with stakeholders to understand requirements around a new report.• Communicating with different members on different time zones to improve processes.

Guadalajara Y Alrededores, México

• Deliver IT Business intelligence and Analytics Projects using Oracle Essbase and Cognos TM1 platforms.• Cube development, maintenance, security and administration.• Ensure the deployment and support of global applications using standardized process for all of the geographies. • Extract and transform data ensuring integrity. • AIX server administration• Manage global team activities.• Financial support during monthly close (forecast, month end.)