Luciana T.
Data Engineer

Skills

Laravel

Qlikview

Asp.net

Sql

Pl/sql

Sas

Oracle Database

Java

Javascript

Php

Python

Luciana is available for hire

Hire Luciana T.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

Specializing in the development of Business Intelligence structures, a Senior BI Analyst brings expertise in data extraction, transformation, and loading using platforms such as Azure Synapse and SAP Data Warehouse Cloud. Proficient in dashboard creation with Power BI, the role includes significant experience in financial data warehousing, particularly in the implementation of Financial Data Warehouses, and leading application development projects for healthcare institutions. Additional capabilities extend to utilizing TOTVS and QlikView for business intelligence solutions.

Experience in Oracle database administration, including serving as a Database Administrator and Systems Analyst for VB and .Net environments, involves monitoring log growth routines, listeners, and the overall database management. Previous project leadership includes managing the database development for an e-learning system, demonstrating skills in database management and team leadership.

Proficient in data analysis and big data analytics, expertise encompasses ETL processes, Azure Databricks, Azure Data Factory, Microsoft Azure platform management, SAP Datasphere, Synapse Azure, SQL Azure, Azure DevOps, Azure Data Lake, Pentaho business intelligence tools, and Microsoft SQL Server administration. Visualization skills are demonstrated through advanced use of Microsoft Power BI and Data Lake technologies.

Systems Analyst
1/2/2011 - 4/2/2012

Developed proficiency in VB, VB.NET, and PHP, with extensive experience in PL/SQL for PostgreSQL and SQL Server 2005. Created complex database objects such as procedures, triggers, functions, and views. Demonstrated strong abilities in user interviewing, requirements gathering, software testing, support, and user training.
Senior Analyst
1/2/2020 - Present

Developed proficiency in SAS, Cognos, and PowerBI, leveraging these tools to design and implement sophisticated business intelligence solutions. Mastered ETL processes and data modeling using IBM Data Stage, efficiently transforming and integrating large datasets. Demonstrated advanced skills in SQL Server Database, Oracle, and Netezza, utilizing these systems for robust data storage and retrieval. Excelled in PL/SQL, creating complex queries and procedures to support data analysis and reporting. Delivered intuitive and actionable dashboards, enabling data-driven decision-making across various business functions.
Senior Analyst
5/2/2018 - 1/2/2020

Developed the Hospital Application and internal systems using Laravel with integration into Oracle and MySQL databases. Conducted report preparation, TAF and TSS updates, version updates, and provided user training. Constructed Business Intelligence dashboards with QlikView for the management area.
Senior Analyst
3/2/2016 - 4/2/2018

Developed proficiency in C#, MVC, and SQL Server. Worked extensively with Totvs as both an Educational and Financial Analyst. Oversaw the Access project, Digital Secretariat, and SMS from initial conception through development, implementation, and ongoing monitoring. Created dashboards using Power BI, utilizing Totvs data to support the Education sector.
Senior Analyst
8/2/2015 - 1/2/2016

Led a migration project focused on transitioning application architecture to Zend Framework, demonstrating advanced proficiency in PHP. Utilized Angular and jQuery for front-end development, combined with backend integration through Doctrine. Conducted comprehensive database remodeling, including the creation of triggers and procedures to optimize database operations. Employed Agile Development methodology, specifically SCRUM, to manage and deliver the project efficiently.
Systems Analyst
5/2/2012 - 7/2/2015

From November 2013 to the present, served as a Senior Systems Analyst, developing technical expertise in Java and JQuery. Utilized extensive experience with Oracle databases, and employed tools and frameworks such as Knockout, Angular, PrimeFaces, Maven, JSON, and Hibernate. Conducted SQL tuning, developed procedures and triggers, and managed visual reporting using iReport. Demonstrated proficiency in collaborative code maintenance with Subversion and NetBeans.

From May 2012 to November 2013, worked as a Systems Analyst, focusing on Lua programming and Oracle 11g PL/SQL development. Engaged in the creation of procedures, triggers, and robust SQL tuning, alongside comprehensive data modeling. Contributed significantly to a system controlling the extraction of oil from wells, adhering to Agile Development methodologies, specifically SCRUM.
Senior Analyst
4/2/2011 - 4/2/2012

Sefaz - State Department of Finance System Analyst with expertise in VB, VB.NET, and PHP. Proficient in PL/SQL for PostgreSQL and SQL Server 2005, involving the creation and maintenance of procedures, triggers, functions, and views. Conducted user interviews and requirements gathering to ensure accurate alignment of technical solutions with business needs. Executed comprehensive software testing to guarantee quality and reliability. Provided dedicated user support and conducted training sessions to empower end-users in effectively utilizing software applications.
Jr DBA and Systems Analyst
8/2/2009 - 5/2/2010

Developed proficiency in performance analysis and optimization for Oracle 10g, including query enhancement. Conducted comprehensive requirements gathering and prepared detailed documentation for new systems with a focus on analysis and development. Modeled and implemented databases using Oracle 9i, Oracle 10g, and SQL Server 2000. Oversaw the development and monitoring of schedules for Japanese corporate systems, specifically FA Terminal systems.
Systems Analyst
4/2/2008 - 2/2/2010

Developed technical expertise in MySQL and SQLServer, with a strong focus on PHP for various systems, leveraging Apache and Linux platforms. Created functions, procedures, triggers, and enhanced queries to improve database performance and functionality. Engaged in comprehensive web application development, particularly for a distance education system, involving database modeling and development. Collaborated closely with users to identify, describe, and validate activities, ensuring effective database modeling processes and addressing application issues or potential improvements. Executed detailed analysis and optimization of MySQL database performance, and regularly created and monitored scripts for routine database backup and recovery. Coordinated the team responsible for the maintenance and creation of the AVA system – Virtual Learning Environment, ensuring reliable and effective system performance.