Lio C.

Data Analyst

Data Engineer
4/1/2022 - Present

Developed expertise in requirements gathering, script development, data modeling, and ETLs, specifically for building and maintaining financial sector data products in both Azure and GCP environments. Proficient in using DBT, Python, and AirFlow tools. Successfully managed data migration projects from Azure to GCP, ensuring seamless transition and data integrity. Demonstrated strong analytical skills through development activities such as requirement analysis, data modeling, documentation, and validation of customer needs in software projects.

Skilled in creating and maintaining scripts including Procedures, Functions, Triggers, and Views to support management indicator reports using GCP, Azure DataBricks, and SAS technologies. Responsible for developing and maintaining insightful reports and dashboards using Power BI, enhancing data visualization and decision-making processes.

BI Analyst
8/1/2020 - 4/1/2022

Conducted comprehensive tasks related to surveying, analysis, data modeling, documentation, and validation of client needs within a software project, leveraging a range of technologies. Developed and maintained reports and dashboards utilizing Power BI, and executed ETL processes within Microsoft DBMS. Created and optimized scripts including Procedures, Functions, Triggers, and Views in T-SQL for management indicator reports, ensuring accurate and actionable insights for stakeholders.

Senior Systems Analyst
7/1/2019 - 5/1/2020

Handled maintenance, support, improvement implementation, and development of management reports in RM modules. Managed TAF maintenance effectively. Developed and maintained management reports using MS Reporting, and created and maintained reports and dashboards in Power BI. Executed backup routines, database restoration, creation, administration, maintenance, growth management, automation of routines, user management, and performance tuning in Microsoft SQL Server 2017 database. Exhibited advanced knowledge in T-SQL, including maintenance and development of queries, procedures, functions, and triggers.

Senior Systems Analyst
9/1/2017 - 7/1/2018

Specialized in the maintenance, support, and implementation of improvements in RM modules, as well as the development of managerial reports. Implemented and maintained TAF systems, ensuring seamless integration and functionality. Developed robust managerial reports utilizing Power BI and Microsoft Reporting Services, and maintained and created detailed reports and dashboards in Power BI. Administered maintenance routines, managed user accounts, and optimized performance within Microsoft SQL Server 2008/2012 environments. Demonstrated advanced knowledge in T-SQL for the maintenance and development of complex queries, procedures, functions, and triggers.

Senior Systems Analyst
11/1/2015 - 2/1/2017

Expertise in maintenance, support, implementation of improvements, and development of management reports in the modules, Labore Chronus, and Vitae. Skilled in maintaining and developing management reports using Microsoft Reporting, with advanced knowledge in T-SQL, including the maintenance and development of various queries, procedures, functions, and triggers.

Mid-Level Systems Analyst
8/1/2013 - 10/1/2015

Responsible for maintenance, support, implementation of improvements, and development of management reports in Nucleus, Fluxus, Saldus, Liber, and Bonum modules. Gained intermediate knowledge in T-SQL, specifically in the maintenance and development of queries. Implemented PDV Consult and provided support for sales integration in ERP/TOTVS-RM. Facilitated the integration of TECFOOD Production Planning and Control software with ERP/TOTVS-RM. Managed the integration of Electronic Access Control software to ERP/TOTVS-RM.

Junior Systems Analyst
1/1/2013 - 7/1/2013

Developed expertise in maintaining, supporting, and implementing improvements for various software modules including Nucleus, Fluxus, Saldus, Liber, Labore, Biblius, and Classis. Additionally, created and refined managerial reports within these modules. Acquired intermediate proficiency in T-SQL, focusing on the maintenance and development of complex queries.

Business Intelligence Analyst
5/1/2012 - 12/1/2012

Acquired expertise in the development of management reports with a specific focus on human resources utilizing Microsoft Reporting Services. Gained intermediate proficiency in T-SQL, actively maintaining and developing complex queries to support reporting needs.

Junior Systems Analyst
8/1/2010 - 3/1/2012

Managed and supported the implementation of improvements and development of management reports within the Nucleus, Fluxus, Saldus, and Liber modules. Developed intermediate knowledge in T-SQL, focusing on the maintenance and development of queries to enhance data handling and reporting capabilities.

Junior Systems Analyst
1/1/2007 - 7/1/2010

Maintained, supported, and developed management reports within the Nucleus and Fluxus modules, enhancing reporting capabilities and ensuring data integrity. Developed basic proficiency in T-SQL for maintenance and query development, allowing for efficient data retrieval and manipulation.

Technology in Computer Network Management at Pitágoras College
2008 - 2010