TUGCE TINA BACALAN

Houston, TX

(***) *** - ****

advlmj@r.postjobfree.com

Highly motivated Data Engineer with over 5 years of experience in Database Design and Development, Reporting and Presentation using BI applications such as SSMS, SSAS, SSIS, SSRS. I work well independently as well as committed team player. A well organized, effective team member with excellent analytical mind and time management skills that meets client’s needs.

Expertise in T-SQL, SQL Server Integration Services (SSIS) with good knowledge on SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) & Power BI.

•Good skills in creating and managing Databases, and various database objects like Tables, Views, Indexed Views, Complex Parametrized Stored Procedures, DDL/DML Triggers, Cursors, User Defined Data Types, User Defined Functions and Indexes (clustered, non-clustered, filtered, covering, with included columns, column stored) using T-SQL.

•Experience in Performance Tuning and Optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, Query Execution Plans and Performance Analyzer.

•Hands on experience in High Level Design of ETL DTS/SSIS packages and ADF pipelines for integrating data using OLE DB connection from heterogeneous sources like (CRM, ERP, API, RDBMS, Excel, CSV, SAS, Oracle, Flat File, Text Format Data) by using multiple transformations such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge and Union All to bring data into a standard, final format that it needs to be in order to be compatible with the final destination database/data warehouse.

•Good knowledge in creating Databases, Tables, Stored Procedures using Window Functions, DDL/DML Triggers, Views, User defined data types, functions, and Indexes using T-SQL.

•Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints, and Logging for Complex SSIS Packages.

•Knowledge of Entity-Relationship concept, Facts and Dimension tables, slowly changing dimensions (SCD) and Dimensional Modeling (Star and Snow Flake Schemas).

•Skillful in report development using SSRS/Power BI and creating various types of reports and dashboards with drill down/through, parameterized, cascading, conditional, slice and dice, bookmark, ad-hoc and sub reports features.

•Experience in writing DAX in Power BI and Expert in fine tuning the reports;

•Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).

InfoCepts Technology Consultant (NBCUniversal AIH Project) Sep 2022- Present

Gather reporting requirements from business stakeholders and convert them into technical solutions that give the users access to the data in a format that highlight actionable insights

Evaluate business value, manage the prioritization and execution of enhancements and projects, including communication to key stakeholders and coordination of work effort within internal IT teams, and the business community

Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using cloud-native data engineering principles

Design, build, and scale data pipelines across a variety of source systems and streams (internal, third-party, as well as cloud-based), distributed/elastic environments, and downstream applications and/or self-service solutions

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Implement the appropriate design patterns while optimizing performance, cost, security, and scale and end user experience

Build visualizations that tell a story, making the best use of the canvas and leverage intuitive layouts

Work with key stakeholders to ensure quality and integrity for products delivered

Act as a subject matter expert in the design and recommendation of analytical methodologies and approaches

3+ years of progressive experience in solution development & building of data and analytics produ

3+ years of experience with Data Engineering, SQL, data discovery/analysis platforms in a capacity supporting Data & Analytics products

2+ years of experience with data visualization tools (Tableau, Power BI, MSTR, SSAS.

Direct experience with data modeling, ETL/ELT development principles, cloud development, and data warehousing concepts.

Direct experience with Cloud native technologies, data modeling, ETL/ELT development principles, and data warehousing concepts.

Experience in building data pipelines using Python/SQL or similar programming languages.

Fuji Engineers & Consultants Jun 2017– Feb 2020

Data Analyst, Istanbul, Turkey (Remote)

Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.

Experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands

Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.

Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.

Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment.

Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling.

Created reports on both cascading and standard parameters.

Worked on PowerBI in creating dashboards and reports and visualizing data.

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

Sourced data from SQL Azure database, SQL Azure Data warehouse, AWS RDS solutions such as MySQL Aurora and Redshift for my Power BI reports.

Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.

Mincron Software Systems (Now – Kerridge Commercial Systems) Mar 2015 – Jun 2016

SQL Developer, Houston, TX

Optimized SQL queries, stored procedures for maximum efficiency.

Developed SSIS packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow tasks.

Created database table partitions, functions, and schemes to enhance performance and troubleshooting

Participated in formal and informal training programs to improve technical skills and knowledge of all programmers.

Participated in design discussions with Database architects and Application architects.

Worked with building the Standard Reports using SSRS and worked with tuning the large complex reports on SQL Server Database.

Involved in creating, structuring, formatting using Report Designer and Report Builder.

Application Development end-to-end with LANSA i-Series AS/400 RPG Visual LANSA.NET

Provide the SmartDistributor software and assist on support service that deliver fully integrated business

management solutions to wholesale distributors, resellers and manufacturers’ stocking reps

Enhance, design, develop and code IBM i-Applications using Visual LANSA.

Installation, upgrading and management of LANSA 13.0 on system I, windows and on client servers.

Project Status reporting and project documentation preparation

Setting up and managing networks to meet client’s expectation

Deploying and managing software on mobile devices and desktops

Install aXes and build new application for web and mobile devices

Isnet Corporation – Isbank May 2011 – March 2013

System Specialist

Istanbul Turkey

Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2012/2014.

Experience in working with Web services to handle SQL connections.

Knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.

Experience in using T-SQL in SQL Server.

Experience in Performance Tuning and Query Optimization.

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

Experience in creating packages to transfer data between, DB2, ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.

Upgrading Microsoft SharePoint 2007 to SharePoint 2010. Migration of all company data from SharePoint 2007 to SharePoint 2010 by using Metalogix migration tool.

Experience SharePoint development administrating and configuring SharePoint accounts and permission levels, creating, and managing sites, libraries, workflows. Managing features, functions, security groups, user permissions, content types.

Experience installing, administering, configuring, troubleshooting, and improving Windows Server environments.

Knowledge of networking including IP addressing, subnetting, TCP/IP, VLANs, DNS.

Experience with provisioning and day to day management Active Directory, providing stable supporting authentication and authorization Infrastructure, and effectively and efficiently performing procedures to ensure services meet requirements.

Assist Active Directory and Active roles for user management and system Center configuration. Active Directory w/ group policy etc.

Develop document, maintain, and continuously improve Active Directory support services in accordance with defined policies perform management and support for Active Directory Access Protocol.

Monitor Directory Services components, provide alerts when issues are detected, and take corrective actions in a timely manner to resolve issues.

Integration and migration management: SharePoint, Active Directory.

Deploy desktop application software and patches, and troubleshoot, diagnose, and resolve incidents for desktop systems and applications.

Conducts training, create training aids, develops, and provides documentation to IT Staff for new or upgraded software applications.

ISO / IEC 27001 Information Security, all work processes associated with the ISO27001 Certification Program and participation in annual security audits.

Assess the functional needs for internal business units to determine specifications for new, upgraded or replacement software purchase.

Process IT-related procurements and associated paperwork to include requirements, justification, compliance, and security.

Provide support for inventories of IT resources.

Assists the user community with the installation, configuration, and ongoing usability of software within established standards and guidelines.

Provide support for employee processing activities (e.g., new hires, moves, terminations)

EDUCATION

Bachelor of Science – Computer Engineering from Near East University, Northern Cyprus / Turkey

Operating Systems: Windows 2003-10, Unix/Linux

Databases: SQL Server 2012-2019, Oracle 11g/12c/18c,

Microsoft Access 2003-2013, Teradata 14.0,

Languages: T-SQL, PL/SQL, MySQL, Scala, Pyton, Javascript

Cloud: Azure SQL Server, Databricks, Analysis, AWS, Snowflake

Version Control/DevOps: Microsoft TFS, Jira, Azure DevOps, Git, GitHub

Methodologies: Agile, Scrum, Waterfall

Others: MS Visio, DAX Studio, Azure Data Studio, Athena Notebook, Snowflake

Contact this candidate