Data Engineer Senior

Rozita Hedayati

SENIOR DATA ENGINEER

************@*****.*** 949-***-**** linkedin.com/in/rozita-hedayaty-8a3a964 Laguna Niguel, CA Qualification Summary

High performing professional with more than eighteen years of experience in application development, SQL programming, data modeling and building ETLs

Confident in the ability to thrive in a fast-paced setting and leverage data engineering skills to enable team’s success

Committed to lifelong learning and going the extra mile for continuous improvement Qualification Highlights

Design and implementation of several ETL processes, utilizing AWS Redshift

Design and development of batch processes, leveraging Redshift, Spark, Python, PySpark and data lake solutions in AWS S3

Expert level experience in SQL programming (MS SQL Server stored procedures and triggers), design of relational databases, indexing strategies, query tuning and performance optimization

Contribution to the design of NoSQL tables and indexing for AWS DynamoDB

Academic and professional experience in object-oriented programming, data modeling, software engineering practices and methodologies such as waterfall and agile

Excellent diagnostics skills and root cause analysis of data discrepancies

Database design and code reviews, database engineering technical lead in several projects

Mentoring junior level database developers and data analysts in adopting best practices Professional Experience

Jul 14 – Sep 24 Experian Consumer Services (ECS) Senior Data Engineer Jan 19 - Sep 24 (ECS, Product Management Department)

Improved fraud detection accuracy by 30% by contributing to fraud detection machine learning projects, building ETL pipelines, and implementing data cleansing processes for external data using Redshift and data lake in S3

Reduced monthly operational costs by eliminating hundreds of work hours and mitigating compliance risks (e.g., in Experian Boost benefit enrollment) through design and implementation of automated enrollment reconciliations and recurring data fixes, utilizing Redshift

Designed and implemented bureau enrollment reconciliation processes, leveraging AWS S3, EMR Spark and Python (PySpark) to optimize efficiency of processing external rosters

Conducted research on replacing Control M with Apache Airflow for workflow management

Designed and implemented 7+ ETLs for processing of billing related external data, optimizing the performance of analysis by 80% and enhancing data accuracy, utilizing data lake in AWS S3 and Redshift external tables

Jan 17- Jan 19 (ECS, Data Services Department)

Ensured near 100% data quality by developing SQL Server stored procedures to facilitate migration of customer data to the new cloud platform, including AWS DynamoDB and Aurora

Designed and implemented over five batch processes and data pipelines in AWS cloud platform, utilizing Redshift

Participated in rotation of database deployments in production Jul 14 - Jan 17 (ECS, Software Engineering Department)

Managed database development, production support, and maintenance of multiple applications, such as billing and customer benefit enrollments, in the legacy SQL Server databases

Led the deployment of configuration data for multiple partner sites, including Morgan Stanley, Discover, AMEX and Blue Cross Blue Sheild

Supported data modeling and design of NoSQL tables for DynamoDB Feb 06 – Jul 14 Experian Consumer Services, Data Services Dept. Database Engineer

Led SQL Server database programming and development of over fifteen projects, such as ProtectMyId dot com, Wells Fargo and American Express

Implemented and maintained over ten applications, including order processing, membership, billing, customer service tool, bureau enrollment, correspondence and alert processing

Mitigated compliance risks by identifying the root causes of critical production data issues, executing data fixes, and providing impact and root cause analysis reports to the business team and senior management

Eliminated compliance risks by performing comprehensive bureau enrollment reconciliation and executing data remediation

Led the design and development of ETL and batch processes for TransUnion, Equifax and Experian credit monitoring enrollment reconciliation, reducing compliance risk by 90%, utilizing SQL Server and SSIS

Enhanced the efficiency of multiple processes, including QA/stage/production configuration data synchronization, promotion code deployment and customer data batch updates, resulting in a 50% reduction in operational cost

Database technical lead, overseeing a team of 5+ database developers in the design, implementation, and deployment of projects, including Wells Fargo, identity alerts, and billing

Trained new hires to effectively contribute to projects with aggressive timelines Nov 04 – Feb 06 C-CAMS Inc Database Developer / SQL programmer / DBA

Led SQL Server database development and maintenance for telecommunication applications

Optimized the performance of SQL Server triggers and stored procedures, reducing database deadlock frequency by 90%

Improved database maintenance productivity by 60% by automating the synchronization of database objects and configuration data across multiple SQL Servers Jun 04 – Sep 04 Beckman Coulter Inc Software Engineer Intern Enhanced the efficiency of genetic analysis software (CEQ 8000) by adding functionality to allow users to switch database server connections via the UI, utilizing C++ and COM components Education

Master of Science in Computer Science, California State University, Fullerton (CSUF) Bachelor of Science in Applied Mathematics, Isfahan University of Technology (IUT)

Contact this candidate