Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Senior Data Engineer
Mercado LibreSenior Data Engineer
Mar. 2023ColombiaSupport existing solutions for credits Meli and create new modules for the new products on Big query. Orchest the solutions on DataSuite - Data flow. Perform Data QA on solutions.
Senior Data Engineer
WizelineSenior Data Engineer
May. 2022 - Dec. 2022Remote Colombia-Design and implement product features in collaboration with product owners, report developers, product analysts, architects, and business partners within an Agile / Scrum methodology. -Design and implement data platforms for large-scale, high performance and scalable requirements, integrating data from several data sources, managing structured and unstructured data while melding existing warehouse structures. -Analyze, diagnose and identify bottlenecks in data workflows -Participate in demos to clients as well as requirements elicitation and translation to systems requirements (functional and nonfunctional). Tech: Cloud Services (AWS, Azure), Python, Sql, ETL, SSIS, Tableau, Scala
Business Intelligence Consultant
UAP Inc.Business Intelligence Consultant
Nov. 2021 - Jan. 2023Canada● Create and optimize ETL (SSIS) processes to map, cleanse and standardize multiple source systems of data to populate the enterprise data models for business consumption, develop routines to determine changed records when they are not provided by the source system. ● Map source system data structures into the data mart data model (source-target mapping) and enhance the data mart data model as needed to meet the business needs ● Develop scripts, queries with Structured Query Language (SQL) to analyze large datasets. ● Work closely with business stakeholders to build reports and dashboards to allow decision support ● Create python sentences to analyze data. ● Run sql process on different warehouses in snowflake cloud platform.
Business Intelligence Consultant
National Bank of CanadaBusiness Intelligence Consultant
Jun. 2020 - Sep. 2021Montreal, Quebec, Canada-Develop ETL using DataStage. -Develop ETL using Databricks -Develop on Azure Data Lake -Develop ETL jobs within the IBM DataStage environment. -Manage file system with UNIX/LINUX. -Design, coding, unit testing of ETL packages, triggers, and stored procedures, views, SQL transactions(Oracle, toad)
Senior Business Intelligence Consultant
Commission de la construction du QuébecSenior Business Intelligence Consultant
Jul. 2019 - Apr. 2020Montreal, Canada Area-Liaise with internal stakeholders to identify, validate and document full business and technical requirements. -Conceptualize reporting; identify needs of the business and develop an approach and format that best addresses those needs (SQL, PowerBI). -Develop ETL with SSIS. -Starting data lake to respond a client needs, create and test ETL on Databricks. -Data modeler for different data marts depending on business requirements. -Strong Agile project experience with proven ability to prioritize and manage time. -Ensure the quality of the implementation (code review, compliance with standards, reuse of services, performance,documentation)
BI Consultant
TELUSBI Consultant
Jun. 2018 - Jun. 2019Montreal, Canada Area• Analyze and document strategies for converting and loading data with SSIS. • Support the development of data conversion tools SSIS- SQL • Create reports SSRS, Power BI. • Handle all tests, validations and mapping activities related to the execution of clinical data conversions • When the need arises, validate data directly with customers • Import converted data for our customers on a timely basis • Assist colleagues in the continuous improvement of processes and tools by sharing best practices and working on required improvements • Work with all teams responsible for delivering clinical solutions to our customers
Technical Recruiter
Intellio Capital HumainTechnical Recruiter
Sep. 2017 - Jun. 2018Montreal, Canada Area• Contact and recruiting technical professionals for consulting and direct hire opportunities within client organizations. • Utilizes multiple internet resources, including the Technical Recruiters own creative networking techniques to source candidates • Conduct phone and in-person interviews to evaluate candidates “fit” and technical competence • Present career opportunities to qualified applicants • Negotiate candidate’s contracts and terms of employment • Build and maintain strong relationships with contract employees and assigned clients.
Business Inteligence Advisor
National Bank of CanadaBusiness Inteligence Advisor
Apr. 2016 - Sep. 2017Montreal, Canada Area• Develop ETLs in Datastage to manage all the data from different sources (Departments). • Create and maintain stores procedures in TSQL (Oracle) to support reports. • In order to accomplish different projects I analyze and code some database enhancements. • Develop SQL scripts to profile the data and create reports about de data QA. • Develop Tableau reports using data QA information provided for our sql scripts. • Interact with different Bank sectors and managers in order to influence them and convince them to cooperate to take certain measures • Require a good grasp of business issues, be able to identify users' data processing needs and propose technological strategies to support their activities • Respond to complex requests from users, and ensure they are satisfied with the solutions and quality of services offered • Diagnose problem situations and participate in solving complex problems by ensuring the implementation of permanent corrective measures in a context of continuous improvement • Minimize the impact of projects on day-to-day operations by managing, supporting and carefully planning system implementation activities and steps involved in making changes
BI Analyst
Yellow Pages Group / Groupe Pages Jaunes – CanadaBI Analyst
Jul. 2013 - Apr. 2016Montreal, Canada Area• Collaborate with business analyst in order to propose appropriate and optimal solution; • Deliver functional specification document; • Ensure the docking and integration of different data sources using ETL-SSIS; • Develop operational and management dashboard using TSQL, SSRS and Power BI; • Develop operation reports USING SQL/TSQL; • Manage data base SQL server 2008-2012, create tables, triggers, and store procedures depending on the projects (New products, modifications). • Ensure the availability of data (reports) made available to users. • Prepare the Test plan to ensure the ETLs results. • Assist the QA and UAT testing team. • Prepare deployments plans; • Take part in deployments activities to ensure the integrity of the reports in production; • Preapre and document the operation and support guide; • Level 2 support for all reports and dashboard develop by the team.
Senior Business Intelligence Analyst & Developer
Banque NationaleSenior Business Intelligence Analyst & Developer
Dec. 2011 - Jul. 2013Montreal, Canada Area• Work with stake holders to identify and gather business requirements for new applications and reports. • Develop and maintain Business Intelligence applications using Data Stage (ETL), Oracle (SQL/TSQL), TOAD. • Develop and maintain extraction, transformation, and load (ETL) routines for importing data from heterogeneous data sources into the database. • Design and develop Data Stage Projects and conduct query performance tuning. • Create reporting solutions to include requirements, concept, design, development, testing, and deployment. • Ad-hoc data requests, Oracle 10-11 TSQL/SQL. • Optimize and improve the performance of existing databases Oracle and Business Intelligence applications Data Stage. • Ensure that the development of Data Warehouse and Business Intelligence solutions follow the establish business process.
Student
Cegep du Vieux-MontrealStudent
Apr. 2011 - Dec. 2011French Student
Data Warehouse Specialist - Project Ecopetrol
IndraData Warehouse Specialist - Project Ecopetrol
Dec. 2010 - Mar. 2011ColombiaWork with the ministry of social protection migrating information with their business rules, fix bugs in their applications using .Net C#, then work in the design of help desk service processes, receiving new application to install in production and manage the way to support it. - Work in business intelligence creating ETL\DTS, preparing data, loading, transforming and sending. Migration plan designed to obtain only the necessary information - Work with complex queries and stored procedures Database definition and programming. DDL, DML, triggers, functions - Migrate data to different databases.
Data Warehouse Specialist - Project Department of Social Protection - Fosyga
IndraData Warehouse Specialist - Project Department of Social Protection - Fosyga
Jun. 2010 - Dec. 2010Colombia- Work in business intelligence creating ETL\DTS, preparing data, loading, transforming and sending. Migration plan designed to obtain only the necessary information - Work with complex queries and stored procedures Database definition and programming. DDL, DML, triggers, functions - • Migrate the information of the ministry of social protection, repetition processes.. - Fix bugs in applications made in .Net C#. - Coordinate Help desk service. - Manage the application’s servers. - Manage de database servers.
Engineer developer
LiSim MexicoEngineer developer
Nov. 2009 - May. 2010ColombiaParticipated in the design, development, implementation and maintenance of several data warehouses projects, debugging information in the databases to create the analysis and integration processes, create cubes about the client’s requirements, Transform the information with ETL and show it in Reports. - Data analysis - Design of the data warehouse architecture and design of the ETL process, create cubes, dimensions, load data, and transform information to send it. - ETL programming with DTS, SSIS and complex stored procedures - Database definition and programming - Implementation of cubes and dimensions - Database and data warehouse administration - SQL Server performance tuning, troubleshooting and daily DB maintenance - Data warehouse and process migration from SQL 2000 to SQL 2005 - Write project documentation
Computer engineer
sfi pdpComputer engineer
Jul. 2008 - Jun. 2009ColombiaManage the Production database, built store procedures with good performance. Create Queries in the client’s databases, create reports, Create DDL, DML queries. Participated in the implementation and maintenance of client/server applications using C#, ASP, SQL Server. The processes in the database were transactional and the applications were designed for the insurance company covering all the aspects of the business, including finances, reinsurance, brokers commissions, customer management, internal and external reporting. - Application design using UML - Multi tier applications using SQL Server and Sybase - Work in business intelligence creating ETL\DTS, loading information from our clients, fixing, and show that information in different reports using Reporting services. - Work with complex queries and stored procedures Database definition and programming. DDL, DML, triggers, functions - Work together with business people to define project requirements - Write project documentation

Requests

Touchpoint image
0
Looking for a Job
Experienced Data Analyst Seeking Opportunities
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
See more people like Andres on Intch
IT
451129 people
25
Project Manager @ Halliburton
27
Sr. Specialized Project Manager @ Lean Solutions Group
17
Mobile solutions Architect
ITData Engineer
35616 people
19
Marketing colsuntant & Web developer @ Sundayness
15
Industrial Engineer
23
Data analyst data engineer @ Independent