Fernando Fonseca Espinoza Email & Phone Number

Peru

Lima, Perú

Lima, Peru

> Development of distributed queries in PySpark to perform exploratory analysis of large volumes of data, optimizing the extraction of key insights in big data environments.> Time series analysis with PySpark, processing large-scale historical data to identify behaviors and predict future trends.> Application of web scraping techniques in Python using libraries such as BeautifulSoup and Scrapy to extract relevant data from websites, transforming it into structured formats for further analysis.> Creation of interactive dashboards and dynamic panels in Looker Studio that enable advanced visualization of metrics and KPIs.> Development of ETL pipelines in AWS Glue for automated extraction, transformation and loading of large volumes of data from various sources.> Implementation of AWS S3 to store and share files between teams, ensuring the security and accessibility required for periodic analysis and reporting.

Lima, Peru

> Processing large data volumes in clusters using DataFrames and RDDs to perform efficient transformations.> Data exploration with PySpark to identify patterns and trends in large data sets using aggregation and filtering functions.> Implementing extract, transform and load (ETL) processes using SQL Server Integration Services (SSIS).> Designing and optimizing Microsoft SQL Server stored procedures to automate data extraction and transformation processes, improving operational efficiency.> Creation of interactive visualizations in Looker Studio, using filters and parameters to facilitate data exploration and trend identification.> Detailed analysis of user behavior, using segments and conversion funnels using Google Analytics.

Lima, Peru

> Automation of data cleansing and transformation processes with Python.> Development of Python scripts for data extraction from APIs and SQL databases, facilitating the access to relevant information for analysis.> Optimization of SQL queries through the use of indexes and performance analysis, improving the efficiency of data extraction.> Development of VBA scripts to automate repetitive tasks in Microsoft Excel.> Construction of dashboards in Looker Studio that integrate data from various sources, facilitating the analysis of important metrics in real time.

Lima, Peru

> Development of web applications using Spring Framework, facilitating the creation of RESTful services and improving data integration in existing systems.> Creation of ER diagrams and logical models to represent data relationships and attributes.> Optimization of SQL queries, significantly improving efficiency and response times in high-volume databases.> Implementation of advanced visualizations with amCharts for graphical representation of data, improving the understanding and analysis of critical information in real time.> Implementation of stored procedures for reconciliation of transactions and commissions from electronic channels, ensuring accuracy and consistency of financial data.

Bachelor'S Degree, Ingeniería De Sistemas

Nivel Avanzado, Inglés