Yonca G. Email & Phone Number

Engaged in diverse consulting projects, delivering customized business solutions through data analysis and technology integration to enhance client operations and foster growth.REPRESENTATIVE CLIENTS & EXPERIENCE:Anheuser-Busch InBev: Led the migration from a legacy database to a modern infrastructure with bi-directional data replication. Worked with cross-functional teams to ensure the migration aligned with business goals, compliance, and system optimization, enhancing operational efficiency and scalability.Cigna: Performed an in-depth analysis of a legacy system to inform its future modernization. This involved an extensive review of the system's architecture and functionality, providing insights that identified technological improvements and process optimization opportunities.Medtronic: Developed cloud-based data engineering solutions, creating sophisticated data models and visualizations while ensuring data performance and compliance. Contributed to the seamless integration of technologies including Snowflake, Power BI, and Tableau, streamlining data processes and enhancing system testing.***Technical Proficiencies: SQL Server · Oracle · Sap Hana · Sybase ASE · Snowflake · Azure · SSMS · DBeaver · TOAD · Embarcadero DBArtisan · Visual Studio · Alteryx · FiveTran · DBT · SymmetricDS · Power Query M · Erwin · JavaScript · DAX · GitHub · JIRA · Confluence · CAST Imaging · Visual Studio Code · Microsoft Power BI · Tableau

- Managed and upgraded database systems, including migrating SQL Server versions and ensuring data integrity and security. Responsibilities encompassed the development of database structures, performance tuning, data acquisition from various sources, and optimizing ETL processes. Played a pivotal role in designing data cubes, generating insightful reports, and performing complex data analyses. Ensured clear communication of findings via platforms like SSRS, Power BI, and Tableau, supporting data-driven decisions. Collaborated with management, adhered to compliance standards, and utilized Agile methodologies for efficient project execution.***Technical Proficiencies: MS SQL Server · TSQL · GCP· PowerShell · DAX · Power Query M · SQL Server Reporting Services (SSRS) · Microsoft Power BI · Tableau · Server Integration Service (SSIS) · Data Transformation Services (DTS) · SQL Server Data Tools (SSDT) · Microsoft Visual Studio · SharePoint · SSMS · SSAS · OLAP Cubes · MDX · MS Office · TOAD · Quest LiteSpeed · RedGate · Salesforce · Agile Methodology and Scrum Methodology · Team Foundation Server (TFS) · Power Apps · Power Automate · Jira · Confluence · Sharepoint · Excel · PowerShell

Greater Minneapolis-St. Paul Area

- Oversaw MySQL and SQL Server environments, focusing on performance optimization, troubleshooting, and maintenance. Key tasks included enhancing database performance, query optimization, managing log maintenance, and improving system integrity and efficiency. Responsible for user access security, replication server configuration, and robust disaster recovery processes. Additionally, managed SSRS, developed reports for management, and documented database procedures, playing a pivotal role in database migrations and upgrades.***Technical Proficiencies: MS SQL Server · MySQL · TSQL· MYSQL· SQL Server Reporting Services (SSRS) · Server Integration Service (SSIS) · Data Transformation Services (DTS) · SQL Server Data Tools (SSDT) · Microsoft Visual Studio · SSMS · SSIS · SSAS · MS Office · TOAD · RedGate · MySQL Workbench · MySQL Enterprise Monitor

- Led the migration of 150+ Perl Script Reports to SQL Server Reports using MS Visual Studio SSRS, aligning them with business needs. Handled multiple SQL Server Databases, optimizing performance, and implementing backup and recovery strategies. Involved in coding, optimizing SQL queries, and managing database migrations and report development. Additionally, played a key role in financial reporting and analysis, preparing financial statements, and managing accounts receivable, contributing to the organization's financial management.***Technical Proficiencies: MS SQL Server · MS Access · TSQL· Perl · SQL Server Reporting Services (SSRS) · Excel · Crystal Reports · Server Integration Service (SSIS) · Data Transformation Services (DTS) · SQL Server Data Tools (SSDT) · Microsoft Visual Studio · SSMS · SSIS · SSAS · MS Office · Quest LiteSpeed · Salesforce · Made2Manage

Bachelor Of Science (Bs), Computer Science

Associate Of Arts (Aa), Computer Programming