Fre Markos

About Fre Markos

Skilled SQL/ETL/BI developer, Microsoft power bi and Microsoft Certified SQL Server, Database administrator and Data engineer with 7+ years of experience as a valued contributor to MS SQL Server with extensive experience on Architecture, Development, Administration (Installation and Configuration, Backup/Restore, Security, Performance Tuning, Upgrading, Migrations, SQL performance tuning and troubleshooting etc.) of SQL Server 2012 and the latest versions and I have also worked on high availability and disaster recovery solutions and have a solid background in SSIS and SSRS. skills in writing complex SQL queries, User Defined Functions, Store Procedures, Views, Window Functions and Derived tables and joins. Having experience in working with industry-specific data such as Retail, Sales, Banking and Healthcare. Good organizational, time management, and listening skills.

Experience

1. Sr Msbi Etl Developer and Database Administrator

   Cardinal Health

   Jul 2018 — Present · Dublin, OH, US

   Azure Cloud Migrations from On Premises i.e. IAAS and PAAS migrations to Cloud. Performing Database Migrations from lower to higher versions of SQL. And Performing Physical to Virtual (P2V) SQL Migrations. Performing Dedicated SQL server Migrations. And Performing SAN Migrations of physical/cluster SQL Servers. Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Dataflow. Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS. Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.• Generated monthly reports and budget analysis to drive forecast production plan with SQL Server Reporting Services (SSRS).• Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture.(Table, chart and matrix report). Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer. Worked on Data Warehouse Modeling with SQL Server Analysis Services (SSAS). Involved in automating SSIS Packages using SQL Server Agent Jobs. Generated Parameterized reports, Sub reports, Drill down and Drill through reports using SQL Server Reporting Services (SSRS) working along with MDX queries. Involved in Analyzing, Designing and testing of OLAP cubes with SQL Server Analysis Services (SSAS) 2014. Debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance. Developed dashboards with Power BI which display key KPIs for business analysis and decision making.

Education

• Unity University

  Bachelor's degree

• Techno Brain Horizon

  Bachelor's degree

  2008 — 2012