J
José Arturo Rodríguez Alcántar
About
Detail
Mexico City, Mexico
Contact José regarding:
work
Full-time jobs
Timeline
work
Job
school
Education
Résumé
Jobs
verified_user
0% verified
- AData Engineer/ModelerAlioFeb 2021 - Current (4 years 5 months)
- AData Engineer SSIS/Azure/Snowflake and Data ModelerAlioFeb 2021 - Current (4 years 5 months)• Developing ETL packages on SSIS to populate datamarts • Developing Power BI Reports using DAX • Extracting and making data ingest using Azure Databricks • Activities as DBA on SQL Server • Querying using with PostgreSQL, SQL Server, Databricks • Developing simple pipelines using Azure Data Factory • Developing queries on Snowflake using SQL language • Modeling Conceptual, Physical and logical DB Models Tools and Technologies: SQL Server, PostgreSQL, SSIS, SSAS, SSRS, Power BI, Python, Azure (Databricks, Data Factory, Snowflake), ER Studio
- Data Analyst/ModelerAgile ThoughtOct 2020 - Feb 2021 (5 months)• Extracting information from different sources such as SQL Server and Data files • Research and training about technologies related with extraction, handling and projection of information • Activities as DBA on SQL Server • Developing and Mantaining ETL Packages using SSIS • Mantaining Power BI reports • Modeling Conceptual, Physical and logical DB Models Tools and Technologies: SQL Server, SSIS, SSAS, SSRS, Power BI, Python, IPC, ER Studio
- Data AnalystAgile ThoughtOct 2020 - Feb 2021 (5 months)
- BI Project LeadAgo ConsultoresDec 2015 - Oct 2020 (4 years 11 months)• Co – Founder of BI Department • Database administrator installing SQL Server instances • Providing permissions and privileges to Java developers to SQL Server databases • Administration of different projects related to developing and deploying of BI solutions • Users and sub sites Administration on Sharepoint for clients such as Kimberly Clark, Pepsico, Soriana, Walmart, among others • Deliveries to clients internal and external base don BI • Designing, developing and deploying reports on Power BI • Designing, developing and deploying reports on SSRS and publishing at Sharepoint • Desinging, developing and deploying and administration of Data marts • Designing, developing and deploying ETL Packages (SSIS) • Designing, developin
- BI Project Lead/Data ModelerAgo ConsultoresDec 2015 - Oct 2020 (4 years 11 months)
- DDatabase AdministratorDigiproDec 2012 - Dec 2015 (3 years 1 month)
- DDatabase AdministratorDigiproDec 2012 - Dec 2015 (3 years 1 month)• Database Administration activities such as Granting Permissions about schemas and users roles • Developing of database objects such as Jobs, Tables, Stored Procedures, Functions, Triggers, etc • Desinging and developing Database objects focused on a systems called "Valija Digital" • Deploying and realease of databases versioning on Citibanamex and Scotiabank
Education
verified_user
0% verified
- Bachelor's Degree as Computer EngineeringInstituto Politécnico NacionalJan 2006 - Jan 2010 (4 years 1 month)
- DDatabricks
- PPython
- LD-30 Developing LeadersICAMI
- SSQL Server oC#
- AAzure
- AAzure (AZ-900)
- PPower BI
- GGCP
- UUdemy: Power BI
- PPython