Data Engineer Business Intelligence
Resume:
Alex Rubinshteyn
Business Intelligence Developer / Senior Data Engineer
**** * ******** ***, *********, WI 53211
************@*****.***
www.linkedin.com/in/AlexRubinshteyn
PROFESSIONAL SUMMARY
Results-driven Business Intelligence Developer / Data Engineer with 18 years of experience designing, developing, and optimizing data-driven solutions.
Extensive (20 years) knowledge of SQL Server and Azure SQL Databases – creating and maintaining server objects such as databases, tables, views, stored procedures, functions, sequences, user defined types, CTEs, triggers, server jobs.
Extensive (18 years) knowledge in ETL processes and data normalization to transform raw data into meaningful business insights. Created hundreds of SSIS packages to transform data from text/SQL/no SQL sources into staging area and then to process data into data warehouses.
Skilled in designing and creating and processing data warehouses (star and snowflake).
Skilled in defining and calculating analytical metrics.
Expertise in database design - relationship integrity, indexes, foreign keys, primary keys, database design tools.
Extensive knowledge of Microsoft Azure Cloud Services (Azure SQL Databases).
Knowledge of programming languages such as C## and Python, including data processing, regex, multithreading, etc.
Knowledge of scripting (Microsoft Windows Batch files, Windows Powershell).
Extensive knowledge of XML including creating custom XML schemas.
Detail-oriented and independent.
Knowledge in data exchange, including encryption/decryption, managing SFTP servers. Experience in administrating AdTempus software for 10 years.
In every workplace I introduced version control software (TFS) and was administrating it.
Collaborated with stakeholders and developers in developing data visualization using SSAS, QlikView and PowerBI.
Extensive knowledge of Healthcare Data, including Health care coding (CPT, ICD10, DRG etc.) and compliance metrics such as common screening tests (Mammography, Cervical, Colorectal etc.) and hospital metrics (LOS, Readmission etc.).
Created multiple SSIS packages to process providers, medical, dental, clinic, rx and lab data.
Created a set of ETL processes to load EPIC data into data warehouse.
Created a set of ETL processes to load MSSP data into data warehouse.
Knowledge of EDI – created a tool to convert 837 format files into a set of SQL database tables.
Administrated 3m Grouping software for 8 years, including setup, creating data exchange layouts, automation through SSIS and Windows Scheduler.
Automated processing medical data through ACG software.
TECHNICAL SKILLS
Databases: SQL Server, SSAS, AWS, MS Azure
SQL: T-SQL, Stored procedures, Queries, CLR Functions, SQL Profiler, User Defined Types
Programming: C#, .Net, scripting, JSON, XML, Python, Visual Studio, SSIS
Data Modeling: ETL, Normalization, Denormalization, Data Warehouses, Star Schema, Snowflake Schema, Data Modelling tools (Toad, ErWin).
BI Tools: Power BI, QlikView, MS Cubes
Version Control: GitHub, TFS
Data Transfer: MS SFTP Server, AdTempus, PGP/GPG, Kleopatra, FileZilla, PuTTy.
AI: Prompt Engineering
Healthcare Data Expertise: Medical, Rx, and eligibility data feeds, CMS MSSP format, EDI 837 format, ACG, 3M Grouping, Compliance metrics.
Class Action Data Expertise: Consumer Protection, Securities.
PROFESSIONAL EXPERIENCE
Business Intelligence Developer
Benefit Services Group of Alliant Insurance Services, Pewaukee, WI
October 2014 - March 2025
Designed and developed data warehouses, front-end solutions in QlikView, MS Cubes and Power BI.
Created ETL pipelines to extract, transform, and load data from diverse sources into a centralized data warehouse.
Optimized SQL queries.
Optimized database structures, introduced Column-Stored Indexes.
Created SFTP accounts, ftp/sftp connections, encryption/decryption procedures.
As a lead developer, fully redesigned the master data warehouse using a snowflake schema and column stored indexes. Data processing speed improved by 90%.
Was accountable to create documentation covering critical processes and requirements to ensure customer alignment.
Led introduction of Source Control technologies (TFS) for the team and administered it, resolving issues with missing/damaged stored procedures and packages.
Created an audit process covering all ETL processes in the SQL server, resolving issues with order of processing, missing files, improperly processed data sets.
Was responsible for developing the methodology for Health Care compliance metrics, highly anticipated by the Analyst Team and the clients.
Environment: SQL Server, SSIS, SSAS, Power BI, QlikView, .NET (C#), TFS
Senior Database Developer
Class Experts Group, Milwaukee, WI (part-time)
January 2015 – May 2021
Created and maintained databases on Azure platform
Created tens of SSIS packages to ETL consumer class action data into Azure Databases
Creating multiple stored procedures to calculate financial loss for claimants.
Collaborated with other team members using Asana.
Environment: Microsoft Azure Cloud Services, SQL Server, SSIS, Asana, TFS.
Senior Data Engineer
AB Data, Milwaukee, WI
August 2007– October 2014
Developed databases to support class actions.
Automated data pipeline workflows.
Conducted deep-dive data analysis to identify trends and anomalies, driving actionable insights.
Developed Loss Calculations algorithms for Security Case using FIFO/LIFO methods (with the help of CLR functions on SQL Server).
Set up replication on SQL Servers.
Created multiple .Net application to support data processing.
Created data migration tool for legacy MS Access data.
Environment: SQL Server, SSIS, .NET (C#, VB), MS Access, VBA
Previous experience is available upon request.
EDUCATION
MA in Applied Computer Science, National University of Science and Technology, Moscow, Russia
Took multiple online classes in C#, Python, PowerBI.
CERTIFICATION
Microsoft Certified: SQL Queries
Contact this candidate