Acerca de mi

Hi, I’m Edgar Macias Data Architect y web/mobile developer.

20 years of experience in IT.
Industry experience: finance, bank, brokerage house, health, automotive, administration, insurance, etc; working with foreign staff in real time.

education

Education

Ingineer Cybernetics and Computational systems
La Salle University, Patriotismo
Aug 1999 - Dec 2003
High School (preparatory)
La Salle University, Patriotismo
Aug 1996 - Jul 1999
High School
Frances Hidalgo College
Aug 1993 - Jul 1996
experience

Experience

Data Architect
TCS - Tata Consulting Services
Apr 2021 - Present

ETL Automation Tableau reports project
Develop and execution project plan regardind data area.
Planning, design and performed data wrangling, analysis & data quality.
Design ETL using IICS (informatica cloud)
Model DB snowflake cloudcomputing.
Agile, SCRUM & CRISP Methodologies.
Amazon Tech - AWS S3

Independent consultant
LabCitrico
Feb 2010 - Apr 2021

Raise client IT requirements
Create the pre-sales architect solution and technologies
Manage and interview team members, responsible for data team
Analyze, design and performed ETL & ELT solution. Design, implementing and documentation ETL workflows.
Create and performed test case
Support ETL workflows / taks.
Design solution with third party tools (vb, slq server, postman, etc)
Analyze, design new schema (DW, Data Lake, data marts) and implemented solution
Support to user regarding datasource layouts and performed test case end to end.
Optimize queries due to timeout or performance issues.
Implemented Oracle (DBMS, Infrastructure, app server, discovery) in Unix servers
I was part of a team and IT team leader.
Review status and times with PM regarding my team and activities.

Tools: Informatica powercenter, unix, windows server, oracle DB, oracle forms, oracle reports, linux, snowflake, snowpipe, snowCLI, snowsql, git, svn, JIRA, soap, postman, aws, informatica cloud, dbschema, erwin, MySql workbench, wordpress, css, js, java, ios (objective-c), cordova, native android, react native, visual basic, .net, sql server.

Contact me

Are you ready to

I’m always interested in hearing about new projects and opportunities. You can tell me about the professional challenges you are trying to solve. I’d love to listen and see if there’s anything I can do to help you.

Send a message
(+52) 55 3891 1899
hola@edgarmacias.me

Veracruz 55 Col. Condesa, Mexico City