Post Job Free

Resume

Sign in

Data Engineer Sql Developer

Location:
Charlotte, NC
Posted:
September 22, 2023

Contact this candidate

Resume:

Maria Travasso

Data Engineer/ Senior SQl Developer

*** *********** **, ****** ******, North Carolina, 27526 Ph. 919-***-****

adzvyj@r.postjobfree.com / https://www.linkedin.com/in/marit87/

Experienced Data Engineer leveraging data-driven solutions that propel business growth. Successfully delivered migration projects utilizing SQL Server, ETL, Snowflake cloud, and data transformation. Expertise includes SQL development, ETL pipelines, DBT, Python, macros, and Jinja for sophisticated data transformations and data modeling. Proven ability to streamline processes, working collaboratively to optimize data integration and transformation.

Technical Skills

SQL, T-SQL, PostgreSQL, Snowflake, Python, Jinja-macros, SSIS, Tableau, Power BI, Agile.

Soft skills

Analytical, Communication, Listening, Logical thinking, Integrity, Critical Observation.

Work Experience

Data Engineer Jan/2022 to Sept 2023

ACARA SOLUTIONS, Buffalo, New York

Orchestrated the design and development of Snowflake schemas, tables, and views, and streamlined data processing, resulting in a 70% reduction in data transformation time.

Configured ETL pipeline for data ingestion into Snowflake AWS cloud and improved productivity by 80%.

Automated intricate data transformations with DBT, ensuring unparalleled accuracy and consistency.

Employed advanced SQL logic, Windows functions, recursive SQL script, store procedures, and Python Jinja macros to execute intricate transformations.

Led the data science intern to train on business production data, sap S4 Hanna, and SQL queries to ensure exceptional consistency.

Data Engineer April/2021 to Oct/2021

Tiaa Bank- Charlotte, North Carolina

Computed using Snowflake cloud to write complex SQL logic, window functions, and store procedures to design and transform data with focus granularity which enhanced stakeholders’ satisfaction by 90%.

Integrated ETL pipelines utilizing Snow Pipe for real-time processing, auto ingestion, and advanced analytics into real-time data by 60%.

Modeled Tableau visualizations to unearth trends, driving strategic business expansion.

Applied Python scripts within DBT for customized data processing and elevated data quality speeding up the modeling process to 75%

Senior SQL Developer 03 /2019 to 10/2020.

HCL America - Cary, North Carolina

Developed and designed SQL in SAS using PostgreSQL to create data sets with a focus on granularity and metrics which reflected 77% high in data integrity.

Regulated cadences with internal stakeholders to understand their business needs for the data sets and provided options to choose from that led to 98% of business benefit and stakeholder satisfaction.

Implemented ETL frameworks to seamlessly data from different sources to SAS and enhanced flexibility which led to the successful data migration by 99%.

Create interactive Tableau and Power BI dashboards to provide consolidated and real-time insights that cut the development time by 40%.

Utilized data modeling strategies to optimize query performance and refine architecture.

Worked closely with cross-functional teams to align data strategies with business goals.

SQL Developer 06/2014 to 02/2019

Multimata LLC – Georgia

Elicited internal stakeholders' requests to understand technical needs and provide options and prototypes that better address business needs, which has led to mitigating risk and client interaction by 55%.

Constructed data sets using complex SQL logic, Windows functions, store procedures, and recursive SQL script to provide robust data sets with transformation and enhanced data flow, increasing development time by 60%.

Created efficient data warehouse and re-design schemas, and indexes for faster query processing and optimization, increasing client satisfaction by 75%.

Provided useful data with granularity to business metrics to determine trends and patterns through Power Bi and Tableau that enabled to mitigate risk by 75%.

Education and Certifications

BS -major in Computer Science -Middle Georgia State University.

Software Product Management and Processes.

CompTIA Security+ certification

DBT certification



Contact this candidate