Renato Galvez Castillo Data Engineer

Senior data engineer

Ex2 Outcoding

Mar 2022 - Nov 2022 (9 months)

- Develop queries in AWS Aurora (MySQL, PostgreSQL) - Develop queries in AWS Redshift - Work with monitoring tools such as Datadog and New Relic - ETL design and development. - Work with containerization like Docker or Kubernetes - Make AWS Performance Insights - Set up an environment in Terraform and AWS CloudFormation. - Handle DevOps tools and principles including version control, Infrastructure as code and deployment pipelines in AWS Lambdas, K9s and CircleCi. - Work with data analytics application administration (Tableau, Metabase, etc.) - Elaborate ML pipelines with python.

Senior consultant

Deloitte

Dec 2021 - Feb 2022 (3 months)

- Build automated reports and dashboards with the help of Power BI and other reporting tools - Understand business requirements to set functional specifications for reporting applications - Worked with tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX - Develop operational reports - Shape data into reporting and analytics solutions - Create functional reporting

Data engineer

Tata Consulting Services

May 2021 - Nov 2021 (7 months)

- Carry out the information gathering on the needs of the business areas. - Interpret business requirements and document them through functional and technical specifications. - Analyze data from different sources to extract information. - Model the collected information into efficient data structures. - Design, develop, test and deploy processes of extraction, transformation, and loading (ETL) of structured and unstructured data to the cloud (GCP). - Develop and maintain robust and reliable data pipelines. - High volume information processing using big data technologies in the cloud (GCP).

V

Big data architect

Valtx Perú

Nov 2020 - Apr 2021 (6 months)

- Coordinate with work teams from the internal areas of the company and from external clients about implementation and support of data analytics solutions of requirements and expectations of clients. - Work and collaborate in the activities of implementation, deployment, maintenance, and improvement of data analytics systems, as well as integration with other solutions and platforms. - Maintain updated information on the scope, time, and budget of the different assigned projects, by following the schedules or boards established for each project, in order to complete tasks and activities on the indicated date.

P

Lead Data Analyst

Peru Hop SAC

Jan 2020 - Nov 2020 (11 months)

- Maintained a State Bar Departments' database master files, including resolving split records, entering corrections, verifying database update reports, monitoring registration systems, case management and performing systematic searches for incorrect d - Work with standard computer tools, designs, develops and executes queries of State Bar databases and develops additional databases as necessary to complete queries. - Review and check how statistics and information, that pertain to a Department, are gathered, organized and processed. - Supervise the design and preparation of various statistical reports.

P

Data Analyst

Peru Hop

Jul 2018 - Jan 2020 (1 year 7 months)

- Transformation and analysis of data into useful, timely, and reliable information that will serve for decision-making, supported by the use of available IT tools (Google Big Query, PL / SQL, Google Cloud Storage) - Analysis, design, and development of indicators for the areas that request support with information extracted from the various computer systems implemented in the institution - Extraction and selection of different variables, creation, and optimization of classifiers through machine learning. (Python / R) • Process, clean and verify the integrity of the data used for the analysis processes. Construction and improvement of pipelines. • Build operational, tactical and managerial management dashboards (Google Data Studio, Power BI

V

Business intelligence analyst

V & D Corporación – Zonia

Jul 2017 - Oct 2017 (4 months)

- Analysis and exploitation of data to show useful information (SQL Server 2016). - Preparation of statistical reports and reports to support management (Power BI). - Measurement, analysis, and monitoring of management indicators. • Development of solutions through automated processes (Macros VBA Excel). • Attention to the information requirements requested by the various areas. • Carry out other functions related to the position commissioned by the immediate boss.

C

Technical analyst

CCR S. A.

Oct 2015 - Oct 2016 (1 year 1 month)

- Establish product universes and sample design through sampling techniques - Database management for establishing sales projection through statistical models of time series (SQL Server 2016, Tableau) - Statistical support in data consistency/analysis of variables / Coverage Analysis (Python, R, SPSS) • Implementation of process improvement projects under Six sigma methodology • Responsible for the statistical control of the processes in the area (Minitab). • Statistical support in meetings with external and internal clients

Global Feasibility Specialist

INC Research

Jan 2015 - Jun 2015 (6 months)

- Provide support in the realization of reports based on statistical models in order to simplify and synthesize any information obtained from the database (SQL Server, SPSS, R) - Identify opportunities for improvement and innovation in current processes/products made by the company globally and locally - Design, prepare and propose the sample and weights requested according to the objectives of the study previously coordinated with the managers in charge of each unit • Generate reports based on the percentage of studies assigned to researchers in order to validate and size the assigned projects for their correct fulfillment (VBA Macros Excel)

Quality Assistant

Laboratorios AC FARMA

Mar 2013 - Dec 2014 (1 year 10 months)

- Management of information from the database for the analysis of statistical control of the quality of the processes (Minitab) - Development and maintenance of statistical models for the validation of processes - Implementation and monitoring of management indicators (SPSS, R) • Elaboration of process improvement projects using quality tools, Six Sigma, and 5s methodology. • Internal auditor based on the ISO 9001: 2008 standard and BPM manual • Implementation and maintenance of the Integrated Management System: scheduling of internal audits, external audits, updating of procedures, instructions and records corresponding to all areas.

Renato Galvez Castillo

About

Detail

Timeline

Résumé