20+ years as Business Intelligence Consultant with responsibilities such as Project Manager, Developer, Database Administrator working with BI tools like Snowflake, DBT, Datastage, Informatica PC, Cognos, Qlikview and Microstrategy. 5 + Years as Data Base Administrator installing, configuring and administering MS SQL Servers (Starting with 2000, 2008, 2012 and 2022. 8+ years as Project Leader, analyzing, designing, building and implementing quality assurance solutions. 12+ year as Software Engineer, designing, developing, and implementing software solutions, Installing Servers (as MS 2000, 2008, 2012 Server and MS SQL Server 2000, 2008, 2012 Server).
Hi, I’m
Edgar Alejandro Martinez Aguiar
Data Engineer
Zapopan, Jalisco
Summary
Overview
27
years of professional experience
6
years of post-secondary education
2
Languages
Work History
TATA - USAAGuadalajara
EDES Applications Support
11.2023 - Current
Job overview
- Business Intelligence Support, Cloud Support, EDES APP Support. The principal activities are to support applications that give data to main areas on Business Intelligence, Snowflake and DBT for report generation.
- Attend and solve issues using Service Now related to any issues reported to Informatica Power Center, Snowflake, DBT or Datastage using Control - M Workflows and Jobs.
- This processes needs good knowledge of Snowflake, DBT, Control M, Hadoop, Hive, Splunk, Informatica Power Center, MS SQL Server, Mainframe, Unix commands and Agile Methodology.
- Functional Experience: BI Applications Support. Agile, RIO, Service Now and other Apps of Corporate Services Applications of USAA.
- Tools: Snowflake, Control M, Datastage, Hadoop, Hive, Splunk, Informatica PC, MS Project, SQL Server, Putty, Unix Shell and other cloud technologies like Azure, AWS and Google Cloud.
Universidad de GuadalajaraGuadalajara
Business Intelligence Administrator
06.2006 - 04.2011
Job overview
- Business Intelligence Administrator of 'Data On Line Analysis'.
- The principal activities were to take requirements from diverse user areas in order to do the Database Design (Datawarehouse – Star and Snowflake Models) and build the Datamarts suggesting minimum granularity for Specific Areas for performance reasons.
- In some specific areas was needed a new Rational model in order to automate data inputs, so, knowledge as Data Architect was required to build some Tables normalizing it for SIIAU, 'Escolar', HR and Finance areas.
- This process needed the Data Cleansing solutions, Cognos, QlikSense and Oracle 10g Suite on Solaris environment.
- Supercomputing Projects. Clustering. Visualization. HPC Technologies. Grids.
- Functional Experience: Business Intelligence Administrator. Supercomputing Manager.
- Tools: Cognos 8 Suite, QlikSense, ER Studio, Solaris, Unix, Oracle 10g Suite, MS SQL Server, MS Project, UML, Java, Visio. Windows Server. Rocks Clusters. Sun Grid. Visualization Software.
TATA - MetlifeGuadalajara
EOS Data Support
06.2023 - 11.2023
Job overview
- Business Intelligence Support, Cloud Support, EOS API Support. The principal activities are to support applications that give data to main areas on Business Intelligence.
- Attend and solve issue on Service Now related to any issues reported to Informatica Power Center, Workflows and Jobs.
- This processes needs good knowledge of Hadoop, Hive, Splunk, Informatica Power Center, MS SQL Server, Postman, Mainframe, Maestro IBM and Agile Methodology.
- Functional Experience: BI Applications Support. Agile, RIO, Service Now and other Apps of Corporate Services Applications of Metlife.
- Tools: Hadoop, Hive, Splunk, Maestro IBM, Informatica PC, MS Project, SQL Server, Putty, Unix Shell and other cloud technologies like Azure, AWS and Google Cloud.
TATA - Pfizer
Business Intelligence Administrator, ETL Developer, Support
08.2021 - 05.2023
Job overview
- Business Intelligence Support, Analyst and Developer. ETL Developer on Informatica Power Center.
- The principal activities are to support applications that give data to main areas on Business Intelligence.
- Attend and solve issue on Service Now related security, workflows issues and any issue related Informatica Power Center.
- This processes needs good knowledge of Informatica Power Center, MS SQL Server 2014, Oracle, Putty, Shell Unix, Project Management and Agile Methodology.
- Functional Experience: BI Applications Support. Agile, RIO, Service Now, Service Manager (Pfizer) and other Apps of Corporate Services Applications of Pfizer.
- Tools: Informatica PC, MS Project, SQL Server 2014, Oracle, Putty, Unix Shell.
TATA - Kaiser
Business Intelligence Developer, ETL Developer, Support
11.2018 - 08.2021
Job overview
- Business Intelligence Support, Analyst and Developer. ETL Developer on Informatica Power Center.
- The principal activities are to support applications that give data to main areas on Business Intelligence.
- In some specific areas was needed a new Workflow in order to automate data inputs or update some existing, so, knowledge of ETL and queries are required to analyse data.
- This processes needs good knowledge of Informatica Power Center, MS SQL Server 2014, Oracle, Putty, Shell Unix, Project Management and Agile Methodology.
- Functional Experience: BI Applications Support. Agile, RIO, Service Now, ATLAS, Kiosk Dashboard, Readyset, Primavera and other Apps of Corporate Services Applications of Kaiser.
- Tools: Informatica PC, MS Project, SQL Server 2014, Oracle, Putty, Unix Shell.
IBM
Business Intelligence Analyst
04.2011 - 11.2018
Job overview
- Business Intelligence Analyst of Financial Area.
- The principal activities were to take requirements from diverse user areas in order to do the Database Design (Datawarehouse – Star and Snowflake Models) and build the Datamarts and suggesting granularity from user’s requirements build some dashboards as well as do full BI support for Specific Financial Area Applications.
- This process required good knowledge of Cognos TM1, QlikSense, Essbase, MS SQL Server 2014, DataStage, QMF, Dbase, Project Management and Agile Methodology.
- Project Manager. Achieve the Project Manager Foundation Certification as Secondary Profile.
- Functional Experience: Business Intelligence Administrator. Project Manager and Financial Support.
- Tools: Cognos TM1, QlikSense, Linux, QMF, MS Project, MS SQL Server 2014, Datastage, Dbase and Essbase, IBM - InfoSphere Data Architect.
C&A
Business Intelligence Administrator
10.2005 - 05.2006
Job overview
- Business Intelligence Administrator the principal activities was analysis, designs, developing and implementations of BI solutions for any area.
- This process needs Data Cleansing solutions.
- Microstrategy Course taken on Mexico City covering Advanced User knowledge like Data Connection, Desktop, Data Management, Build Dashboards, Metrics, Filters, Users, Key Indicators, etc.
- Functional Experience: Project Management.
- Tools: MS SQL Server, Microstrategy, MS Project, UML, Visual Basic, Visio, ERWIN Data Modeler.
ASCI
Quality Assurance Engineer
06.2004 - 10.2005
Job overview
- Quality Assurance Engineer with diverse activities including analysis, designs, developing and implementations of QA solutions for HP.
- The tests was made on HP hardware and software.
- Functional Experience: Quality Assurance Engineer.
- Tools: Java, Visio, MS Project, UML, Eclipse, HP-Unix.
AM-PM
Project Leader and DBA
02.2003 - 06.2004
Job overview
- As Database Administrator I was responsible to Install a MS SQL Server 2000 in order to migrate Access Database, doing data testing and verify data consistency to work in a clear mode for users on production environment.
- Granting Access to the new MS SQL Server to users and create functions, Stored Procedures and Data Disaster Recovery Plan creation and do Backups and Restore of complete Production Database.
- Hands-on Project Leader with diverse activities including analysis, designs, developing and implementations of software solutions.
- This solutions was made searching automatized logistic processes.
- Functional Experience: Project Management, Database Administrator.
- Tools: Visual Basic, MS SQL Server 2000, MS Access, Clarion, Windows 2003 Server, Crystal Reports, Artus, Visio, MS Project, UML.
GOPAC
Quality Assurance and Software support Engineer
06.2001 - 01.2003
Job overview
- Quality Assurance Engineer and Software support engineer with diverse activities including analysis, design, developing and implementations of QA solutions for NIKE and GOPAC.
- The tests was made on GOPAC software.
- Software support to Mexico, Argentina, Chile and Brazil on GOPAC software.
- Functional Experience: Quality Assurance Engineer / Software Support Engineer.
- Tools: Pervasive, MS Access, Clarion, Windows 2000 Server, Crystal Reports, Artus, Visio, MS Project, UML.
IPSUM
Business Intelligence Administrator / Developer
06.2000 - 06.2001
Job overview
- Business Intelligence Administrator with activities including analysis, design, developing and implementations of Business Intelligence Solutions, including the consolidation of 7 corporations, software solutions and sql server implementations.
- Functional Experience: Business Intelligence Consultant / Datawarehouse and Software Engineer.
- Tools: Artus, E-R Studio, MS SQL Server, Visio, MS Project, Cognos Software, Oracle 8, Satellite Forms, ZPL.
Sinergia
Software and Support Engineer
06.1998 - 06.2000
Job overview
- Software and Support Engineer with diverse activities including analysis, design, developing and implementations of software solutions for diverse companies such as HP and Kodak.
- This Software and Support need the implementation of Microsoft Servers (2000) and Data Base Servers (MS SQL).
- Functional Experience: Software Engineer / Support Engineer.
- Tools: Visual Basic, MS SQL Server, Crystal Reports, Visio, MS Project.
Education
Universidad Martha AbreuLas Villas, CUBA
Master from Computer Science (Database Mention)
01.2000 - 01.2002
University Overview
Universidad De GuadalajaraGuadalajara, Jal MX
Ingeniería from Computación
01.1994 - 01.1998
University Overview
Skills
Technical Managerial Skills
Technical Managerial Skills
Project Management, Leadership, Communication, Interpersonal Skills, Business Intelligence Administrator, Software Engineer, ETL Developer, Windows 10, HP-UNIX, LINUX, Mac OS, Visual Basic, Clarion, Delphi, Java, HTML, C++, Essbase, MS SQL Server, Oracle, MySQL, DBASE, Pervasive, Informatica Power Center, Qlikview, Qliksense, Cognos, Datastage, Microstrategy, MS Project, MS Office, Visio, Rational Rose, ER-STUDIO, QMF, ER/WINProfessional Development
Professional Development
- Business Intelligence Administrator, ETL Developer and Support, TATA, 01/01/18, Present
- Business Intelligence Administrator and DBA, Freelance, 01/01/17, 01/01/18
- Business Intelligence Administrator, IBM, 01/01/11, 01/01/17
- Business Intelligence Administrator, Universidad de Guadalajara, 01/01/07, 01/01/11
- Business Intelligence Administrator, C&A, 01/01/06, 01/01/07
- Quality Assurance Engineer, ASCI, 01/01/05, 01/01/06
- Project Leader, AM-PM, 01/01/04, 01/01/05
- Quality Assurance and Support Engineer, GOPAC, 01/01/02, 01/01/04
- Business Intelligence Consultant, IPSUM, 01/01/00, 01/01/02
- Software and Support Engineer, Sinergia, 01/01/98, 01/01/00
Timeline
EDES Applications Support
TATA - USAA
11.2023 - Current
EOS Data Support
TATA - Metlife
06.2023 - 11.2023
Business Intelligence Administrator, ETL Developer, Support
TATA - Pfizer
08.2021 - 05.2023
Business Intelligence Developer, ETL Developer, Support
TATA - Kaiser
11.2018 - 08.2021
Business Intelligence Analyst
IBM
04.2011 - 11.2018
Business Intelligence Administrator
Universidad de Guadalajara
06.2006 - 04.2011
Business Intelligence Administrator
C&A
10.2005 - 05.2006
Quality Assurance Engineer
ASCI
06.2004 - 10.2005
Project Leader and DBA
AM-PM
02.2003 - 06.2004
Quality Assurance and Software support Engineer
GOPAC
06.2001 - 01.2003
Business Intelligence Administrator / Developer
IPSUM
06.2000 - 06.2001
Universidad Martha Abreu
Master from Computer Science (Database Mention)
01.2000 - 01.2002
Software and Support Engineer
Sinergia
06.1998 - 06.2000
Universidad De Guadalajara
Ingeniería from Computación
01.1994 - 01.1998
Similar Profiles
Cheng Wen-HsinCheng Wen-Hsin
Pixel Lab Ops at TataPixel Lab Ops at Tata
Akash NandawanaAkash Nandawana
Data Visualisation Analyst at TataData Visualisation Analyst at Tata
Kapil SharmaKapil Sharma
Nurse Assistant at TataNurse Assistant at Tata
Gustavo Martín Escobedo VázquezGustavo Martín Escobedo Vázquez
Game Developer at School ProjectsGame Developer at School Projects
Juan Pablo Fletes CoronaJuan Pablo Fletes Corona
Technical Support Representative at HelpwareTechnical Support Representative at Helpware