Eren Radichel

Brigham Young University - Idaho

GPA: 3.898

SQL Database Developer

• ETL Process Automation and Optimization: Spearheaded the automation of the company’s ETL processes using SQL Server, PowerShell, and batch scripting. Streamlined workflows to reduce manual intervention, ensuring efficient, error-free operations with minimal monitoring.
• Dynamic SQL Implementation for Reusability: Designed and implemented reusable, dynamic SQL code to support Medicare marketing campaigns across multiple clients. Improved query performance and execution times, significantly enhancing campaign delivery speed and accuracy.
• Error Management and Data Quality Assurance: Standardized error-handling frameworks by incorporating TRY-CATCH blocks, rollbacks, and commit statements. Developed automated QC checks to detect data anomalies, ensuring data quality aligns with business requirements.
• Mentorship and Collaboration: Mentor and support two junior SQL developers, offering technical guidance and fostering a collaborative environment to enhance team capabilities and project outcomes.
• Server Monitoring and Database Performance: Monitor database servers to mitigate process blocking and downtime risks caused by resource contention. Collaborate with data scientists and technical teams to optimize resource usage and maintain server stability.
• Database Replication and Integrity: Oversee the replication of critical databases, ensuring data synchronization and consistency across systems to meet business continuity requirements.
• Continuous Learning in Database Administration: Proactively expanding expertise in database administration concepts to better manage server performance, storage, and replication challenges.

Junior SQL Database Developer

• Responsible for developing and supporting SQL Server database solutions within both the production and development environments.
• Lead the Extract, Transform, and Load (ETL) process, overseeing the ingestion of data from various sources into the organization's databases.
• Streamline data import procedures, employing automation tools and scripting languages to expedite the ETL process and minimize manual intervention.
• Monitor and troubleshoot data discrepancies, employing data profiling and validation techniques to identify and resolve anomalies.
• Design and implement SQL procedures to support the execution of marketing campaigns, ensuring efficient data retrieval and manipulation for targeted customer communications.
• Collaborate with marketing teams to understand campaign requirements, translating them into SQL code and optimizing query performance.
• Conduct thorough testing and debugging of SQL procedures, promptly identifying and resolving errors to maintain campaign accuracy and effectiveness.
• Actively engaged in training for a Junior Database Administrator (DBA) position, acquiring comprehensive knowledge of database management principles, backup and recovery procedures, and performance monitoring.

Database Developer Intern

• Responsible for creating, administering, and troubleshooting computer databases that can process large amounts of information and keep it secure.
• Designed database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access to the generic database structure.
• Planned and installed upgrades of database management system software to enhance database performance and implementation stages to address business or industry requirements.
• Developed database architectural strategies at the modeling, design, and implementation stages to address business or industry requirements.
• Created and enforced database development standards.
• Tested changes to database applications or systems.
• Initiated, reviewed, or approved modifications to project plans.
• Created a database to track relevant targets during the production process.
• Collaborated with department heads to build a data model with current information.
• Presented projects to executives and sponsors.