Solutions Architect

• Oct 2022 - Present

Senior Technical Instructor

• Sep 2015 - Oct 2022

Senior Data Engineer

• Sep 2011 - Oct 2022

Line Manager

• Aug 2016 - Oct 2020

Tech Lead | Solution Architect - through Adastra Bulgaria

• Feb 2022 - Present

✔ Environment: Azure Data Factory, Azure Databricks Workspace, Azure Synapse Analytics, Azure Data Factory, Storage Account, Azure DevOps, CI/CD, SQL Server ✔ Responsibilities: ● Creating data model diagrams ● Designing solution architecture ● Writing technical design document ● Writing production implementation plan ● Leading the back-end and front-end development teams ● Participating in project planning, resource planning and scope definition ● Responsible for deployments ● Collaborating with various teams to perform a seamless integration Show less

Data Modeler - through Adastra Bulgaria

• Oct 2021 - Feb 2022

✔ Environment: Microsoft Visio, Azure Synapse Analytics (workspace), Azure Data Factory, Storage Account, Azure DevOps ✔ Responsibilities: ● Gathered requirements and converting business information into models ● Created entity relationship diagrams (ERDs) ● Created logical data model – dimensional star schema ● Iteratively refined the conceptual, logical, and physical data models ● Built a source to target mapping document ● Participated in the data integration process ✔ Environment: Microsoft Visio, Azure Synapse Analytics (workspace), Azure Data Factory, Storage Account, Azure DevOps ✔ Responsibilities: ● Gathered requirements and converting business information into models ● Created entity relationship diagrams (ERDs) ● Created logical data model – dimensional star schema ● Iteratively refined the conceptual, logical, and physical data models ● Built a source to target mapping document ● Participated in the data integration process

Senior Azure Data Engineer - through Adastra Bulgaria

• Jun 2021 - Sep 2021

✔ Environment: Azure Synapse Analytics (workspace), Azure Data Factory, Storage Account, Azure DevOps, SQL Server ✔ Responsibilities: ● Got familiar with and complied with the established standards of a large and complex project ● Gathered business requirements and documented them ● Suggested and implemented improvements to the existing processes ● Designed architecture for a few new side requirements ● Wrote technical design documentation and production implementation plans ● Wrote and optimized T-SQL stored procedures and views ● Built parametrized pipelines, datasets, and linked services ● Participated in the QA process by building test plans and test cases and executing them ● Was responsible for the UAT deployment ● Collaborated with various teams to perform a seamless integration Show less

Senior Azure Data Engineer - through Adastra Bulgaria

• Aug 2020 - May 2021

✔Environment: Azure Data Factory v2, Azure Synapse Analytics, Azure SQL Database, SSMS, SOAP ✔Responsibilities: ● Building parametrized pipelines, datasets and linked services in Azure Data Factory v2 ● Writing and optimizing T-SQL stored procedures in Azure Synapse Analytics ● Consuming data from a SOAP-based Web service and other sources ● Implementing error handling logic ● Identifying dependencies and implementing process orchestration ● Scheduling ADF triggers ● Manipulating JSON scripts when necessary ● Performing end-to-end unit-testing Show less

Senior Azure Data Engineer - through Adastra Bulgaria

• Nov 2020 - Dec 2020

✔Environment: Azure Synapse Analytics (workspaces preview), PolyBase, Azure Synapse built-in data integration via pipelines, Azure Data Lake Storage, SSMS, Power BI ✔Responsibilities: ● Participating in the dimensional modeling ● Configuring PolyBase to access external data from Azure Synapse Analytics (workspaces) ● Consuming files from Azure Blob Storage into Synapse SQL Pool using external tables ● Building parametrized pipelines, datasets and linked services ● Writing and optimizing complex T-SQL stored procedures in Azure Synapse Analytics ● Implementing error handling logic ● Designing and building Power BI report ● Performing end-to-end unit-testing Show less

Senior Data Integration Consultant - through Adastra Bulgaria

• Sep 2019 - Aug 2020

✔Environment: Microsoft SQL Server 2019 Data Tools, Microsoft SQL Server 2012, SSMS, SSIS, Git Lab, Python ✔Responsibilities: ● Analyzing and documenting existing Python code ● Building and deploying ETL packages with MS SQL Server Integration Services ● Writing and optimizing complex T-SQL stored procedures, functions and triggers ● Adding error handling logic ● Designing SQL Server data models ● Manipulating XML data dynamically ● Creating and maintaining business and mapping specifications ● Performing end-to-end unit-testing ● Maintaining database objects utilizing SQL Server Database Project Show less

Azure Cloud Engineer - through Adastra Bulgaria

• Jun 2019 - Aug 2019

✔Environment: Azure Data Factory v2, Azure Data Warehouse, Data Lake Gen 2, Azure DevOps GIT, SSDT, SSMS, Storage Explorer ✔Responsibilities: ● Created and migrated resources and resource groups to CSP subscription ● Provisioned, restored and rescaled Azure Data Warehouses ● Installed and configured Azure Data Lakes (Storage Accounts) ● Developed cloud-based solutions using Azure Data Factory v2 ● Scheduled and monitored ADF processes ● Maintained infrastructure and firewall policies ● Performed end-to-end unit-testing Show less

Release Lead - through Adastra Bulgaria

• Sep 2018 - May 2019

✔Environment: Microsoft SQL Server 2014, Microsoft Visual Studio, TFS, SSMS✔Responsibilities:● Branching, merging and labeling TFS versions of official and partial releases● Performing baseline and incremental data model comparisons to ensure consistency with code ● Gathering and maintaining production deployment documentation● Coordinating activities between DEV, QA, Infrastructure, Solution Architecture and Data Modeling teams and Business users● Monitoring and coordinating executions in multiple UA and PROD environments● Ensuring successful product delivery Show less

Senior Data Integration Consultant, Team Lead - through Adastra Bulgaria

• Mar 2018 - Aug 2018

✔Environment: Microsoft SQL Server 2014, MS SQL Server Integration Services, Microsoft SSDT, SSMS, TFS✔Responsibilities:● Analyzed business and mapping specifications● Wrote and optimized T-SQL queries● Designed, created, ran, monitored, debugged and troubleshooted ETL packages with MS SQL Server Integration Services, ● Complied with the main DWH/ETL principles based on provided technical specifications and naming conventions● Consulted in MS SQL Server performance tuning● Coordinated team and cross-team activities ● Ensured successful product delivery Show less

Senior Business Intelligence Consultant - throught Adastra Bulgaria

• Jan 2018 - Feb 2018

✔Environment: Microsoft SQL Server 2014, Power BI Report Server, Report Builder, TFS✔Responsibilities:● Analyzed report business and design specifications● Designed, created and deployed Power BI paginated reports using Report Builder ● Created in-built expressions and functions to provide detailed customization of the reports● Wrote and optimized T-SQL queries● Suggested indexes to increase performance● Created and maintained technical documentation● Participated in QA and UAT processes Show less

Master Data Management Consultant - through Adastra Bulgaria

• Mar 2017 - Dec 2017

✔Environment: Microsoft SQL Server 2014, Ataccama MDC 11.0.0✔Responsibilities:● Created and executed MDC plans and components● Developed cleansing and validation components● Analyzed and implemented matching business rules● Adhered to the data modeling and SQL Server performance optimization processes

Senior Data Integration Consultant - through Adastra Bulgaria

• Nov 2016 - Dec 2016

✔Environment: Microsoft SQL Server 2014 Data Tools, Microsoft SQL Server 2014, SSIS, EAV, Partitioning ✔Responsibilities: ● Participated in database design and solution architecture processes ● Built ETL packages with MS SQL Server Integration Services ● Wrote and optimized T-SQL queries using EAV data model database as a source ● Automated a sliding window technique on partitioned tables in the ETL to increase performance ● Attended sprint planning, daily scrums, retrospectives, and stakeholder meetings ● Created and maintained technical documentation Show less

Business Intelligence Consultant, Data Integration Consultant - through Adastra Bulgaria

• Feb 2014 - Oct 2016

✔Environment: Microsoft SQL Server 2012 Data Tools, Microsoft SQL Server 2012, SSRS, SSIS, DAX ✔Responsibilities: ● Analyzed report business and design specifications ● Designed, created and deployed reports using MS SQL Server Reporting Services ● Created in-built expressions and functions to provide detailed customization of the reports ● Built ETL packages with MS SQL Server Integration Services ● Wrote and optimized T-SQL stored procedures ● Created and maintained production implementation plans and technical documentation ● Participated in QA and UAT processes Show less

Data Integration Consultant - through Adastra Bulgaria

• May 2012 - Oct 2013

✔Environment: IBM InfoSphere DataStage 8.5, DB2, Teradata 13, UNIX ✔Responsibilities: ● Developed ETL applications with IBM InfoSphere DataStage 8.5 ● Created, executed, and troubleshot parallel and sequence jobs ● Optimized jobs performance (sorting and partitioning) ● Implemented SCD type 2 logic ● Performed Multistage data loading and processing ● Developed scripts for Control–M jobs ● Wrote Shell scripts for automating the ETL processes ● Performed Unit testing ● Supported QA in the defect resolution process ● Maintained documentation Show less

Senior Software Developer

• May 2009 - Aug 2011

✔Environment: ASP.NET 2.0/4.0, C#, ADO.NET, Web Services, MS SQL Server 2005, Crystal Reports, HTML, CSS, JavaScript, Ajax; ✔Responsibilities: ● Developed and maintained web-based ERP systems and e-commerce web sites ● Integrated a variety of payment processors ● Designed and developed SQL Databases and SQL stored procedures ● Wrote C# class libraries ● Designed and implemented the graphical interface ● Created reporting tools ● Supported the production server ● Participated in testing the products. ● Analyzed test execution results and identified source data issues and defects. ● Participated in the defects resolution process. Show less

Software Developer and Team Lead - through Vizibility

• Jun 2008 - Sep 2008

✔Environment: WPF/XAML/.NET 3.5/CAL (basics), ASP.NET 2.0, C#, MS SQL Server 2008, Microsoft LINQ to SQL (ORM), MS Change Tracking, MS Sync Services for ADO.NET. ✔Responsibilities: ● Leaded the developers’ team ● Wrote detailed reports and technical documentation ● Took part in designing and developing the database ● Developed SQL queries ● Wrote C# class libraries ● Implemented the required graphical interface ● Analyzed test execution results and identified source data issues and defects. ● Participated in the defects resolution process. Show less

Software Developer

• Aug 2007 - Jun 2008

✔Environment: ASP.NET 1.1, 2.0, C#, WCF, ADO.NET, MS SQL Server 2005, Crystal Reports, HTML, CSS, JavaScript ✔Responsibilities: ● Developed e-commerce projects using different content management systems ● Developed and maintained new modules for the CMS systems ● Made changes and improvements in existing projects ● Integrated a variety of payment processors ● Implemented the graphical user interface ● Developed SQL queries ● Wrote C# class libraries ● Analyzed test execution results and identified source data issues and defects. ● Participated in the defects resolution process. Show less

Software Developer

• Jul 2006 - Jun 2007

✔Environment: C#, .NET Framework 2.0, MS Access ✔Responsibilities: ● Developed and maintained software for automated photo cabins and other vending machines. ● Developed software for implementation of hardware devices like coin & bill acceptors, camera, printer, etc. ● Participated in developing image processing libraries in C# ● Designed and implemented the graphical user interface ● Designed and developed small databases ● Developed SQL scripts ● Participated in testing the products. ● Analyzed test execution results and identified source data issues and defects. ● Participated in the defects resolution process. Show less

Software Developer

• Oct 2005 - Apr 2006

✔Environment: ASP.NET 1.1, C#, Mono Framework, AJAX.NET, JavaScript, HTML, CSS ✔Responsibilities: ● Developed and maintained a Web-based network management system ● Implemented the graphical user interface ● Wrote C# class libraries ● Participated in testing the products. ● Analyzed test execution results and identified source data issues and defects. ● Participated in the defects resolution process. ✔Environment: ASP.NET 1.1, C#, Mono Framework, AJAX.NET, JavaScript, HTML, CSS ✔Responsibilities: ● Developed and maintained a Web-based network management system ● Implemented the graphical user interface ● Wrote C# class libraries ● Participated in testing the products. ● Analyzed test execution results and identified source data issues and defects. ● Participated in the defects resolution process.