Mary Ortikova

About Mary Ortikova

As a Senior Business Intelligence (BI) Developer with over 7 years of experience, I have demonstrated expertise in working with BI applications including SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) across Development, Test, and Production environments. I have also gained proficiency in utilizing visualization tools such as Power BI. My professional experience spans various industries including service, leasing, and retail sectors.• Possessed advanced proficiency in Microsoft Business Intelligence (BI) technologies, including T-SQL, SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS), along with an in-depth understanding of Azure services such as Azure SQL Database, Azure Data Factory (ADF), Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS), Software-as-a-Service (SaaS), Azure Blob Storage, Azure SQL Data Warehouse (SQL DW), Azure Data Lake Storage Gen2 (ADLS2), Azure Key Vault (AKV), Azure Synapse Analytics, and Azure Databricks. Additionally, demonstrated expertise in Amazon Web Services (AWS) services like Elastic Compute Cloud (EC2), Amazon RDS for SQL Server, Amazon Redshift, and Amazon S3.• Possessed exceptional skills in database administration, proficiently creating and managing databases, as well as various database objects such as tables, views, indexed views, complex parametrized stored procedures, DDL/DML triggers, user-defined data types, user-defined functions, and indexes (clustered, non-clustered, filtered, covering, with included columns, columnar storage) using T-SQL.• Developed SSIS packages, leveraging a wide range of data sources such as flat/raw files, Excel, CSV, Access, OLEDB, XML, Change Data Capture (CDC), ADO.NET, and employing transformations like aggregation, conditional split, derived column, merge, merge join, union all, multicast, row count, lookup, sort, audit, fuzzy lookup, and more.• Created reports following design specifications, documented database maintenance processes, and administered SQL Server using client/server tools such as SQL Server Management Studio, SQL Server Profiler, and SQL Server Query Analyzer. Created ad-hoc reports using Report Builder and managed the Report Manager for SQL Server Reporting Services (SSRS).

Experience

1. Senior Data Engineer

   Service Experts

   Jul 2023 — Present · Dallas, TX, US

   Developed data pipelines to efficiently extract, transform, and load data from various sources, including APIs and data lakes, into an azure SQL database, ensuring data accuracy and consistency.• Created and optimized stored procedures for data transformations, automating the movement of data from a Raw database to a Refined database, improving data processing efficiency.• Implemented logic and business rules to enhance data views, such as segregating credit sums by month and implementing data archiving when clients made payments, resulting in cleaner and more insightful data for reporting purposes.• Collaborated with a team of Power Bi developers and business stakeholders, participating in daily stand-up meetings and additional meetings to align data engineering efforts with business needs.• Utilized Azure DevOps as a source control system to manage code changes, taking ownership of promoting code changes from the development environment to production while ensuring data integrity.• Worked with Continuous Integration/Continuous Deployment (ci/cd) pipelines to streamline the deployment process, reducing deployment errors and increasing the reliability of data updates.• Proactively addressed and resolved daily data issues reported by the report team, such as missing data, data discrepancies, and incorrect logic, demonstrating a strong commitment to data quality and business success.• Demonstrated critical thinking and logic skills to solve complex data-related challenges.• Attended daily scrum meetings, discussed new requested features/user-stories/tasks with Business Analysts and updated the status of tasks assigned on CA Agile Platform.• Designed, developed, and maintained BI Infrastructure comprised of large data (couple of Billions) using Relational Databases, Tabular Modeling and Reporting.• Worked closely with Architecture team to transition old database models into new Data Warehouse, Data Mart and reporting structures.

Education

• Brooklyn College

  Biology, General