Robert Alim Demircioglu

Houston, Texas, United States

adwc3l@r.postjobfree.com 346-***-****

www.linkedin.com/in/robert-d-822896267/

Senior Data Engineer with over 7 years of experience in database design, data collection, SQL Server Development, ETL processing, data cleansing, report delivery, and data analysis. A highly motivated, well-organized, and productive team member with an excellent analytical mind who can quickly adapt to the given role and deliver results. Extensive work experience in a variety of enterprise domains, including finance, banking, healthcare. Healthcare claim transactions such as 837,834,270/271,276/277.

Strong collaboration Microsoft Commerce Insights (MSBI), ETL Information Stockroom, OLTP & amp.

OLAP utilizing SQL Server Integration Administrations (SSIS) and Sky-blue Information.

Production plant V2 (ADF2), Announcing (SSRS/Power BI), Investigation Administrations (SSAS).

And MS SQL Server (2012 - 2019).

Worked with Managing Directors and Executives in departmental meeting for gathering requirements.

Also, presentations were presented.

Comprehensive knowledge and involvement with social database administration frameworks.

Include Normalization, Clustering, T-SQL, storing Techniques, Limits, Inquiry, Joins.

Keys, Records, Information Import/Export, Triggers and Cursors and different SQL server objects like patterns, tables, Client Characterized Information Sorts, Lists, Ordered Sees, Capacities, CTE (common table expression), Table Factors and Put away Methods.

Hands-on experience with Azure Data Factory V2, Data Flows, Azure Data Lake, Azure

Synapse, Azure Analysis Services, Snowflake, and other cloud tools.

Developed physical information models, DDL (Information Definition Dialect) scripts, and DML (Data Modeling Language).

(Information Control dialect) scripts to control the SQL Database.

Solid knowledge of migration of on-premises SQL Server schemas to the cloud on Azure SQL

Server DB and Azure VM and development and maintenance of databases across both on-

Installations on-premises and in the cloud.

Mastery in Extricating, Change and Stacking (ETL) utilizing different apparatuses like export/import information and SQL Server Integration administrations. Made, Created, Tried and Sent Bundles into generation servers by making bundle configurations.

Master in consolidating Information from different complex Information sources, Populating Measurement and Truth tables in Information stockrooms, Cleaning and Standardizing the

Information stacked into OLTP and OLAP databases utilizing SSIS.

Normalization/De-normalization and database plan technique. Encounter in making ETL handle,

Information warehousing, Operations Information Store concepts, information marts and OLAP advances, Counting Star and Snowflake schema.

Capable in creating PBIX records in both Control BI Desktop and Control BI Administrations stages and in uploading them into Report Server and Cloud Administrations with appropriate push level security settings.

Seasoned in building Tabular models within Power BI Desktop and writing complex DAX queries to create measures and calculated columns.

Skilled in Analyses Service, particularly in building Tabular models on top of DW/DM/DB and writing complex DAX and MDX queries against the models.

Knowing how to use SSRS to create report models for Ad-hoc reports, Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table (List), Matrix (Crosstab), Charts, Sub-Reports, Indicators, Bar Graphs & Line Graphs, Dashboards, and Ad-hoc reports. Expert in Performance Tuning of Complex T-SQL codes, SSIS packages, Power BI/SSRS reports.

Pushing and extracting data from an Azure blob. Backend service development and deployment experience on Azure clouds.

Excellent grasp of SSIS maintenance and administration through the creation of SQL Agent Jobs, Alerts, and Reports.

Mail Notifications, and schedule DTS/SSIS Packages by SQL Agent, Windows Scheduler and

Experience in developing Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for Analyzing & transforming the data to uncover insight into the customer usage patterns.

Good understanding of Spark Architecture with Databricks, Structured Streaming. Setting Up AWS and Microsoft Azure with Databricks, Databricks Workspace for Business Analytics, Manage Clusters in Databricks, Managing the Machine Learning Lifecyle.

Responsible for estimating the cluster size, monitoring, and troubleshooting of the Spark Databricks cluster.

Experience

Data Engineer

Turquoise Horizon Houston, TX

Oct 2021 - Present (Remote)

With business users and team leaders to improve knowledge of business specifications.

Needs, selecting data sources and Developing methodologies.

Assisted the team in addressing SQL Reporting Services and T-SQL difficulties and demonstrated proficiency in developing reports.

Many forms of reports.

Leading the Project team to oversee the development and ongoing delivery of the data analysis.

Capability of reporting.

Formalizing and institutionalizing a data governance framework: creating common set of data definition,

And concentrate on data quality.

A broad view of the BI market space including technologies from other vendors such as IBM/ Cognos, QlikView, and Microsoft.

Excellent knowledge in Azure SQL stack architecture (SQL Server, Synapse and Azure Data factory).

Configured Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes. Build workflows to with ADF, automate data flow.

Actively participated in migration of on-premises SQL Server schemas to cloud on Azure SQL Server DB

And Azure VM and developed and maintained databases across both on-premises and cloud deployments.

Worked on various DAX expressions in Power Pivot based on the business requirement.

Used Power BI to implement a semantic model to simplify the analysis of business data and relationships.

By loading relevant data from Azure Synapse data warehouse.

Migrated on-premises SQL server schemas to the cloud on Azure SQL Server and maintained databases.

Both on-premises and cloud installations are supported.

Developed filters, reports, dashboards and created chart types, visualizations and complex.

Power BI computations are used to alter data.

Built efficient ETL packages, using both SSIS and ADF2 pipelines for processing Fact and Dimension

Tables with sophisticated transformations and SCD type 1/ type 2 modifications. Create processes to help automate data flow.

Using Python and ADF2.

Use the Azure Data Factory pipeline to pull data from various semi-structured data sources, both on-

Premises and in the cloud. Data captured from a file-based location, including CSV or JSON files.

Developed many Power BI reports using Power BI Desktop and Power BI Service such as Performance.

Reports, Profit Reports, Sales Per City / State Report, Score Card Summary, Annual Expenses Report,

Cost Comparison Reports and etc.

Created various types of reports such as sub reports, Tablix and Matrix using SQL Server Reporting

Services and created Parameterized Reports which consist of report Criteria in various reports to make

Minimize the report execution time and to limit the no of records required.

Created reports on both cascading and standard parameters.

Designed reports on account information, research reports using ad-hoc reporting to be used by clients

And advisors.

Used Power Query to acquire data, developed calculated columns and measures using DAX in Power BI

Desktop for designing rich visuals using visualizations such as Bar chart, Clustered Column Chart,

Waterfall Chart, Gauge, Pie Chart, Tree map.

Shared with user groups, scheduled and maintained the Power BI and SSRS reports published to the

Report Server and Power BI Service.

Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL

Code and SQL joins for SSIS packages and SSRS reports.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services

(SSRS).

Created linked, drill through, drill down, cashed, snapshot and sub reports using Report Server Project & amp.

Report Model Template in SSRS and was responsible for deploying them.

Analyzing business requirements and data sources to design and develop ETL solutions using DataStage.

Creating and maintaining DataStage jobs, job sequences, and job schedules to support data integration needs.

Troubleshooting and resolving technical issues related to DataStage jobs and data integration processes.

Sr. SQL/ BI Developer

The Cigna Group

Jan 2019 - Sep 2021

Professional experience in SQL Server and T-SQL in implementing, developing, and maintaining Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, creating and updating tables, and checking database consistency with DBCC commands.

SQL performance monitoring and tweaking of reporting data was completed by optimizing indexes and stored procedures. Designed and implemented T-SQL triggers to ensure consistent data entry into the database.

Built reports for different domains such as Finance, Accounting, Management, and other client teams.

Created Power BI reports on account information, research reports using ad-hoc reporting to be used by clients and advisors. Created reports on both cascading and standard parameters. Worked on Power BI in creating dashboards and reports and visualizing data.

Prepared accounting Reports included Year-To-Date, Month-To-Date, Period Close reports, Transaction and Snapshot reports for General Ledger, Budget reports, etc.

Developed filters, reports, dashboards and created chart types, visualizations and complex DAX calculations to manipulate the data in Power BI.

Created reports using Power BI Desktop and deployed to Power BI Service to share with end users via Workspaces and Apps which implemented Row Level Security and User Group management.

Used various formatting techniques and features like interactive sorting, grouping, slicer, bookmarks, RLS, PLS and many others to create user friendly reports.

Helped clients to convert Excel reports for Accounting Department into Power BI reports by automating the whole lifecycle of report generation. Generated OLTP database objects. designed Data Warehouse. Created ETL processes to automated data flow.

Built efficient SSIS packages/ADF2 pipelines for processing Fact and Dimension tables with complex transformations by maintaining SCD Type 2/SCD Type 1 historical data.

Imported data into Synapse using various technologies such as SSIS, Polybase, and Azure Data Factory and stored the imported data in a columnar format to provide distributed querying capabilities to increase OLAP workload performance.

Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and developed and maintained databases across both on-premise and cloud deployments.

Provided support and guidance to other members of the BI team on separate projects

SQL/ETL Developer

Prosperity Bank

Apr 2016 - Dec 2018

In various projects, I provided help and direction to other members of the BI team.

Helped the team resolve SQL Reporting Services and T-SQL challenges and shown skill in developing various sorts of reports.

Filtered bad data from old system using complicated T-SQL statements and applied different constraints and triggers to database objects to guarantee referential integrity for data consistency and database integrity.

Assisted the team in resolving SQL Reporting Services and T-SQL-related issues, as well as proficiency in creating various types of reports.

Worked with Technical Analysts to understand and translate business requirements into technical specifications.

Implemented Copy activity, Custom Azure Data Factory Pipeline Activities

Created notifications and alerts, subscriptions to reports in the Power BI service.

Worked with cloud migration from On-prem to Azure cloud.

Coordinated with Technical Analysts in understanding the business requirements and translated them into technical specifications.

Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.

Generated SSIS packages/projects to pull out, modify and load data from various sources such as Oracle/SAP and SQL Server Database, Flat Files, Excel source files to specific destinations by using Visual Studio 2012 into Data Warehouse.

Scheduled SSIS packages using SQL Server Agent Job for ETL processes.

Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.

Participated in business analysis activities to gather required reporting, ETL and dashboard requirements.

Worked with Key Performance Indicators that drive company measurement, reporting and analytics across key data sources and functions.

Translated business requirements into specifications that will be used to implement the required reports, ETL and dashboards, created from potentially multiple data sources.

Supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.

Participated in formal and informal training programs to improve technical skills and knowledge of all programmers (e.g., lunch and learns, articles, white papers).

Data Analyst

Enerflex

Feb 2015 - March 2016

Engaged in formal and informal training programs to increase all programmers' technical skills and knowledge (e.g., lunch and learns, articles, white papers).

Row-level security was worked on to improve performance and security from a hierarchy standpoint.

Participated in design discussions with Database architects and Application architects.

Worked on implementation of SQL Server Master Data Services 2012 to achieve reliable, centralized data for accounting that can be analyzed, resulting in better business decisions.

High Experienced in generating SSIS Packages/projects from various sources to specific destination by using Visual Studio 2012, building and scheduling jobs for ETL process.

Developed SSIS packages to pull out, modify and load data from Oracle/SAP and SQL Server databases into Data Warehouse.

Good knowledge on the dimension, fact tables and designing the Data-Mart using Star schema.

Wrote Stored Procedures, Functions and expressions for better performance and flexibility.

Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.

Worked on creating SQL Server jobs and scheduled them to load data over nightly using SQL server Agent.

Based on the execution plan and the creation of appropriate logic using T-SQL, we achieved successful performance results.

Created Joins and sub-queries for complex queries involving multiple tables from different databases Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

Created SQL server MDS 2008 Web App that integrates with Add-in Excel and right Sql Server database.

Presented and supported Sales team on implementation of SQL Server MDS 2008 for MDM of Sales team.

Strong Applications Development experience with back-end databases such as SQL Server, SQL MDS 2008, Oracle and MS Access using ADO/ADO.NET OLEDB and SQL client.

Strong skills in transformation data from DB2 to SQL Server.

Data migration from text files, DB2, excels files to SQL server.

Largely used T-SQL in supporting Finance Team and constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

Created and Designed Data Source and Data Source Views and also configured OLAP Cubes (Star and Snowflake Schema) using SSAS.

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.

Involved in Dimensional Data Modeling and Cube partitioning in SSAS.

Had experience on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures, and views).

Configured Dimensional modeling for End-User from Hierarchy perspectives.

Technical Skills

OS

Windows XP/7/10, Windows Server 2016/12/08, UNIX/LINUX

Databases

SQL Server 2016/14/12/08R2, Oracle 11g/8.0i, MS Access 2000/8.0, Teradata 14.0, DB2

Languages

T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET Framework, C#, C, C++, JavaScript

Web Tools

C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL & Reporting

SSDT 2016/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS) 2016/ 2014/2012/2008R2), SQL Server Reporting Services (SSRS) 2016/2014/2012 /2008R2), PowerBI, SQL Server Analysis Services (SSAS)

Others

MS Office, Crystal Reports XI, Visio, Service Oriented Architecture (SOA), SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, DataStage, Informatica, Hadoop, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, Synergy, HP Quality Center & Jira, Master Data management, Data Quality Services

Education

Hacettepe University Bachelor's Degree

Data Engineer

Contact this candidate