Skilled business solutions technology professional offering in-depth understanding of securing and leveraging data resources. Accomplished in building brand new systems that meet complex business requirements. Expertise includes: Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications. Knowledge of Data Governance, Data Quality, Metadata Management, and Data Architecture, including industry standards, Proficient in, sql, pl sql, BI, , Mysql, sql server, oracle database, advanced Microsoft excel, Erwin, non-sql, sql developer, and data warehousing. Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
Hi, I’m
Lucimara Brant
Winter Garden,FL
Summary
Overview
20
years of professional experience
Work History
Duarte International Corporation
Data Modeler
04.2021 - Current
Job overview
- Identified and described relationships between data fields in enterprise databases.
- Analyzed enterprise data holdings to reduce redundancy of data within existing systems or improve conflation of datasets from one system to another.
- Progressed and maintained official description of enterprise datasets.
- Organized integration of data and migration activities to enhance operations.
- Designed data models for complex analysis needs.
- Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
L&P solutions
Data Modeler /Business Analysts
01.2015 - 02.2021
Job overview
- Progressed and maintained official description of enterprise datasets. Designed, and created and maintained large, complex logical and physical data models, and metadata repositories using ERWIN
- Assisted service developers in finding relevant content in existing reference models,
- Organized integration of data and migration activities to enhance operations.
- Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
Ipiranga / Accenture
Data Analyst/ Sql Developer, Data Modeler
01.2012 - 01.2015
Job overview
- Interpreted data, analyzed results using statistical techniques and provide ongoing reports -Created views with business logics to reduce database complexities for easily ad hoc reporting
- Created stage and snap tables and ETL process to store daily/monthly data for reporting purposes
- Monitored query using query analyzer and tuned queries and procedures to boost database performance
- Established integration between legacy systems and ERP, developed and maintained data dictionary, establish standards, rules and policies
- Developed, implemented and optimized stored procedures and functions using T-SQL.
Bank Bradesco
Data Modeler
01.2008 - 01.2012
Job overview
- Created, managed, and modified logical and physical data models using a variety of data modeling philosophies and techniques including Inmon or Kimball
- Collaborated with cross-functional team in support of business case development and identifying modeling method(s) to provide business solutions -
- Recognized the need for specific relational design – OLTP, OLAP, Data Warehouse – from set of requirements and/or from Logical Data Model
- Translated Business Requirements to Conceptual and Logical Data Models
- Progressed and maintained official description of enterprise datasets.
Unisys
System Analyst
01.2002 - 01.2007
Job overview
- Developed highly optimized stored procedures, functions, and database views to implement business logic and also created clustered and non-clustered indexes
- Involved in performance monitoring, tuning and capacity planning
- Advised optimization of slow performance queries by looking at Executed Plan for better tuning of database
- Organized system infrastructure documentation and operating procedures, strengthening controls and enhancing overall performance.
- Resolved malfunctions with systems and programs through troubleshooting.
Education
Uerj
Bachelor of Science from Economics
University Overview
Puc
Master of Science from Communications Systems Technology
2010
University Overview
FGV
Master of Science from Systems Engineering
2012
University Overview
UCFOrlando, FL
from Data Modeling/ Data Analytics
2020
University Overview
Skills
- Business Intelligence Data Modeling
- Modeling Expertise
- Reverse Engineering
- Data Repositories
- Extraction Transformation and Loading (ETL)
- Staging Tables
Languages
English
Full Professional
Portuguese
Full Professional
Espanish
Limited Working
Accomplishments
Accomplishments
- Collaborated with team of Ipiranga Gas and Oleo to defeat many challenges in integrating of the 5 data systems.. The integration Increased sales of gas and oleo in 20% exceeding all goals
Timeline
Data Modeler
Duarte International Corporation
04.2021 - Current
Data Modeler /Business Analysts
L&P solutions
01.2015 - 02.2021
Data Analyst/ Sql Developer, Data Modeler
Ipiranga / Accenture
01.2012 - 01.2015
Data Modeler
Bank Bradesco
01.2008 - 01.2012
System Analyst
Unisys
01.2002 - 01.2007
Uerj
Bachelor of Science from Economics
Puc
Master of Science from Communications Systems Technology
FGV
Master of Science from Systems Engineering
UCF
from Data Modeling/ Data Analytics
Similar Profiles
NUBIA N DUARTENUBIA N DUARTE
Export/Import Assistant at Duarte International CorporationExport/Import Assistant at Duarte International Corporation
Guilherme DuarteGuilherme Duarte
Sócio Gerente at Guilherme Duarte e Lucas DuarteSócio Gerente at Guilherme Duarte e Lucas Duarte
Erin TwedellErin Twedell
Credit Compliance at Options For Youth - DuarteCredit Compliance at Options For Youth - Duarte
MICHAEL VITARELLIMICHAEL VITARELLI
Photographer at Disney's Hollywood StudiosPhotographer at Disney's Hollywood Studios
Keysha FraserKeysha Fraser
Licensed Childcare Provider at Self EmployedLicensed Childcare Provider at Self Employed