Alonso Zúñiga Business intelligence

Z

Semi senior dba

Zeal Tech Corp

Jan 2023 - Current (3 years 10 months)

- Execution of Datalake: Learning and using of this system for data cleanse processes required by Ops.
- Data Import: Learning and using of this system for import the cleaned data in Referwell.
- Reporting: Learning and using of Metabase to know how to create reports for the client for different purposes.
2. Development of:
a. Datalake:
● Read and contribute the documentation of the engineering behind this system.
● Propose technical approaches and time calibrations for new implementations.
● Craft and deploy the system making use of good practices.
b. Geospatial Indexator:
● Contribute to the documentation based on the different pieces of code we created for this purpose.
● Propose t

Business intelligence consultant

Media Marketing Lab

Sep 2022 - Jan 2023 (5 months)

- Project: Nothing Bundt Cakes (Mar 2022 – Dec 2022)
- Develop the functionalities of the Nothing Bundt Cakes project.
- Document Data Governance artifacts/deliverables
- Participate in the definition of the architecture of the new features.
- Project: RevSys Pre-Adjustments Invoice (Feb 2022 – Mar 2022)
− Build code to gather, refine, and transform large diverse datasets into simplified, meaningful, and actionable aggregations.
− Analyze data, to provide information that supports.

Data engineer

Zoluxiones

Apr 2022 - May 2022 (2 months)

- Responsible for providing the necessary reliability in the information used by the corporation for decision-making and use in reports at the different hierarchical levels in the company.
- Support for ETL processes and multidimensional models. Advice to internal users in the tools: Tableau and Snowflake. Construction of dashboards in Tableau.
- Survey of needs with end users that summarize or generate commercial
indicators (KPIs) to support business models. Analysis and proposal of improvement opportunities in the processes within the area.

Senior data engineer

Encora Inc.

Nov 2021 - Jan 2023 (1 year 3 months)

- Develop the functionalities of the Nothing Bundt Cakes project.
Document Data Governance artifacts/deliverables. Participate in the definition of the architecture of the new features of the Nothing Bundt Cakes project
- Support certification tests for UAT-TI, UAT-DF, Dev environments.
Business support with prioritization file upload to production environment. Participation in the newspaper. Perform and design database queries through Snowflake
- Design dashboards in Tableau and Power BI. Track and update tasks in Jira. Building and optimizing 'big data' data pipelines, architectures, and data sets.

Deputy manager of business intelligence

Banco de Crédito BCP

Jan 2020 - Nov 2021 (1 year 11 months)

- Manage and comply with the requirements of the PLAFT area.
Functional Leader of the Operations Registry project. Develop dashboards of international lists crossover indicators with lists black
women in the fight against corruption.
- Presentation in committees on topics related to agility and transformation digital. Monitoring of the work team managing growth and / or evolution professional of each collaborator of the team.
- Facilitate and promote the scrum framework to the compliance team.
Preparation of strategic reports for the regulatory entity (ISOC).
Data model development in Oracle and SQL Server consumables through. Dashboards in Power BI and Qlik Sense.

Scrum master

Banco de Crédito BCP

Jun 2019 - Dec 2019 (7 months)

- Manage agile projects using SCRUM Framework. ISOC automatization Report. Dashboard cash control
- Dashboard data quality of operation report. Creation of small teams
- Managed daily projects using Kanban board

Senior MIS & data quality

Banco Falabella Perú

Jun 2018 - May 2019 (1 year)

- Participation in monitoring and control meetings of the requirement of the area of users. Design and implementation of queries in SQL Server, SPSS engine and go to production.
- Optimal performance of the risk area indicators through the implementation of the data mart. Creation of guides and user manuals that are kept up to date.
- Implementation of procedures and best practices to the database and
Business intelligence information for the area.

Database administrator

Yanbal International

Oct 2016 - Mar 2018 (1 year 6 months)

- Compile, interpret and capture business indicators in presentations and
process statistics related to the area. Database administration (SQL-Server / Microsoft access). Georeferencing external clients using zonal data (Mapinfo).
- Implementation of peripheral applications in favor of process automation. Coordination of procedures with different areas within the organization. Elaboration of policies and guidelines of the processes of the area.
- Total administration of zonal data of the FFVV (Creation of Urbanizations, creation of zones, creation and modification of freights - charges for dispatch, loading of dispatch times for certain geographical areas of Peru, etc).

Business intelligence consultant

DWConsulware

Jun 2016 - Oct 2016 (5 months)

- Definition of the logical and physical model of the DWH model.
Development of parallel and sequential Jobs. Debugging warning (ETL)
Validation of measurements by data set.
- Preparation of documentation for passes to production. Generation of inputs. Unit tests. Mesh creation. Technical data mapping.
- Support to the different DWH data mart. Technologies: IBM DataStage 8.5, IBM DB2, IBM COGNOS, Oracle (PL/SQL)

Technical lead

GORA

Mar 2016 - May 2016 (3 months)

- Advise on the implementation of integration and / or exploitation solutions in the Bank's Data Warehouse. Elaboration of data models according to the specific need and updating of existing models to meet new requirements.
- Certify that the integration components (ETL) comply with the Data
Warehouse standards, as well as that these are optimal for the current
architecture of the bank.
- Certify the exploitation components comply with the standards defined in the Data Warehouse, as well as that they have high availability and have good response times when displaying the information.

Business intelligence consultant

GORA

Dec 2015 - Mar 2016 (4 months)

- Implementation of the Commercial Intelligence Datamart. Implementation of adjustments in the DataMart of CRM campaigns using Oracle and DataStage.
- Information gathering and coordination with users from different areas
of Interbank, for the definition of KPIs and design of the ETL flow of the
Commercial VP DataMart.
- Integrate customer information in the various sources of the bank.
Execute the cleansing of the information for the various customer contact details (Telephone, email, and addresses).
Datamart for the VP Commercial Area, this project had a great impact in the daily workflow. Senior BI Consultant
- Implementation of the Commercial Intelligence Datamart.
- Implementation of adjustment

C

Business intelligence consultant

Celeritech Brasil

Aug 2015 - Nov 2015 (4 months)

Alonso Zúñiga

About

Detail

Timeline

Résumé

Alonso Zúñiga new_releases

About

Detail

Behavioral traits

Alonso Zúñiga