MARK STEINBERG

Chicago Illinois

adzy9y@r.postjobfree.com

773-***-****

SUMMARY

27+ years of Core Data and coding Expertise

Data Engineering: Alignment of data with business needs, compliance, collaborate with clients to assure needs are met.

Data Architecture: Data modeling for physical and logical diagrams, redesigning databases and implementation.

Data Warehouses: Development and data processing into star and snowflake schemas and cloud and on-site platforms.

Coding: ETL and Interfacing with databases in multiple languages and platforms.

Data Analysis: Evaluation of systems, data mapping, business model vulnerability and documentation.

Business Analysis: Creation and review of businesses requirements, Overseeing implementation and evaluation of risks.

Reporting: Design and development of data flow to various layouts so users can easily use third party tools.

Areas of specialization:

Data Integration

Data Modeling and Architecture

Data Warehousing

ETL

Databricks

Data Integration

Problem Solving

TECHNICAL SKILLS

App / Web Programming

.NET, VB.NET, C#, VBA, JSON, VB.NET, Visual Studio, ASP.NET, IIS, XML, Visual Basic, PowerBuilder, Databricks

Business Analytics

MS SQL Server Reporting Services, PowerPivot, Business Intelligence Development Studio, Crystal Reports

Data Science

Python, PySpark

Database / OLAP / Hadoop

MS SQL Server, MS SQL Server Integration Services, MS SQL Server Analysis Services, Microsoft SQL Server Parallel Data Warehouse, PostgreSQL, MySQL, Spark, Hive, ER/Studio, Snowflake, Azure Data Factory, ERwin, T-SQL, Toad, Embarcadero, Azure SQL DB, Oracle, PL/SQL, MDX, DBArtisan, Sybase

Other Relevant

Salesforce, Azure, PeopleSoft, AWS, Docker, Kubernetes, TFS

Industry Experience

Information Technology, Healthcare, Retail, Telecommunications, Insurance, Banking, Finance and Transportation.

EXPERIENCE

Concentrix Catalyst, Chicago, Illinois October 2021 - Present

Senior Data Engineer:

Customer: Microsoft Redmond, WA May 2023 – July2023

Designed ETL new ETL process using Data Factory

Processed data from source systems to data warehouse

Process reports for PowerBI

Senior Data Engineer:

Customer: Microchip Technologies, Chandler, AZ Mar 2022 – Dec 2022

Assisted in the design of new system for Salesforce.

Assured requirements aligned with the existing data.

Created logical and physical data models for new Salesforce system which was used to validate requirements.

Worked with Salesforce architect to align data from old system to new Salesforce system.

Implemented strategic release of data so it will conform to data hierarchy in new system.

Data was transformed from secure MySQL and SQL Server into Salesforce.

Technologies Used: SQL Server, MySQL, SSIS, Salesforce, WinScp, ERStudio,

Customer: Best Buy Health, Richfield, MN Oct 2021 – Dec 2021

Designed system to pull data from Snowflake to SQL server.

Used SSIS to pull and format data into SQL Sever.

Assisted Project Manager on design and testing.

Technologies Used: SQL Server, Snowflake, SSIS

Training Initiatives:

Alteryx Bootcamp.

The Ultimate Hands-On Hadoop: Tame your Big Data!

Taming Big Data with Apache Spark and Python - Hands On!

Hadoop Developer in Real World.

AWS Certified Data Analytics Specialty 2022 - Hands On!

Spark and Python for Big Data with PySpark.

Hive to Advance Hive on Hadoop.

Databricks-certified-data-engineer-associate

Deloitte May 2021 – September 2021

Data Architect:

Designed physical data model.

Started design of a data warehouse.

Used T-SQL to speed up stored procedures.

Checked ETL codes in Azure Data Factory.

Improved PowerBI Reports.

Technologies Used: SQL Server, Azure Data Factory, GIT, ERwin, T-SQL, PowerBI

Medline Industries July 2020 - April 2021

Data Architect:

Worked with team to design best-practices for a full development cycle.

Assisted on re-design of data environment.

Used T-SQL stored procedures to move data from stage to production.

Designed physical and logical schemas for databases.

Improved the release process to use T-SQL SQL scripts in a more effective manner.

Created a methodology for building T-SQL templates.

Utilized T-SQL code for ETL process to move data from SAP to data warehouse.

Technologies Used: SQL Server, PeopleSoft, SAP, Toad, T-SQL

Baxter Health Care September 2019 – June 2020

Data Architect:

Designed and implemented a full working data warehouse for medical infusions using star schema.

Implemented data marts for reporting.

Used full ETL process to load data warehouse data marts.

Wrote a C# process that reads message sent to pump via RabbitMQ.

Parsed JSON objects into database.

Fully developed database schemas.

Worked with team to assure reporting data for pharmacists was accurate for alarms and limits.

Deployed code to Docker and Kubernetes.

Technologies Used: C#, PostgresSQL, Embarcadero, RabbitMQ, JSON, AWS, Docker, Kubernetes

Discovery Health Partners (Contract) May 2019 – August 2019

ETL Expert:

Utilized SSIS Packages to load data into staging and production database.

Used SSRS Complex Report with 4 sub reports that exported into Excel.

Used T-SQL stored procedures to fix accounts that were missing from ETL Process.

Technologies Used: Microsoft Azure SQL, SSIS, SSRS, T-SQL

Alliance of Chicago August 2016 – May 2019

Data Architect:

Improved performance on Big Data databases using Microsoft.

Contributed knowledgeable of Distributed and Replicated table structures throughout the project.

Designed Common data model for Healthcare.

Utilized ETL to move data from various Health Centers into Big Data BI warehouse.

Completed data modeling for warehouses and data marts.

Implemented release process to assure production data would process correctly.

Improved query performance on PDW Platform by altering distribution logic.

Migrated the APS platform database into Azure.

Technologies Used: Microsoft Appliance (Big Data), SQL 2012, SSIS, ER/Studio, Azure, PDW

Data Integration & Data Architecture – Across Multiple Clients January 2012 – August 2016

Customer: Aim Specialty Health - ETL Expert:

Rebuilt SSIS packages to conform with standards.

Completed extensive data logging and monitoring.

Redesigned data model to have proper data flow and history.

Reported on ETL results.

Documented all SSIS and Visio models of data flow.

Responsible for initial design of data warehouse for cost of CPT data.

Technologies Used: SQL 2012, SSIS, SSAS, SSRS, Visio

Customer: Infinity - Data Warehouse Managed Care POC:

Responsible for conceptual, physical, and logical data models.

Transformed data into ODS warehouse.

Built SSAS Cubes for managed care data.

Used SSIS Packages to load bank data to warehouse.

Built SSRS reports to show how data can help assist users in the daily jobs.

Technologies Used: SQL 2012, SSIS, SSAS, SSRS, PowerPivot, Master Data

Customer: World Bank - Data Architect:

Responsible for conceptual, physical, and logical data models.

Managed and mentored Onshore and Offshore teams.

Redesigned Enterprise Data Warehouse from over 900 tables to under 200.

Designed data marts.

Conducted extensive research and data analysis of ODS system.

Designed dimensional warehouse to have proper functionality.

Technologies Used: ERwin, Oracle, PL/SQL, SQL Server 2012

Customer: Ernst & Young - Data Architect:

Responsible for physical and logical data models.

Managed and mentored Onshore and Offshore teams.

Database was designed to have high order of history and record keeping.

Designed calculation to Wash Sales, Constructive Sales, Straddles and other tax laws.

Proven ability to have multiple sets of default mapping levels to set up clients easily.

Reviewed documents to assure design conformed to all use cases.

Technologies Used: ERWin, SQL Server 2012, T-SQL, SSIS

Customer: Reyes Holdings - SSIS Specialist:

Reviewed architecture design of SSIS data flow.

Completed analysis of data to assure proper filters were in place.

Validated data between JDE and warehouse.

Used SSIS work to load Dimension and Fact tables.

Documented all work including full details on design of SSIS packages.

Implemented better SSIS logging to use custom tables.

PowerPivot used for reporting.

Technologies Used: ERwin, SQL Server 2008 R2, T-SQL, C#, SSIS, JDE

Customer: Salix - Data Integration Specialist / Business Analysis:

Developed File Management System to download, upload, unzip, and rename files that are database driven.

Set-up documentation guidelines for client which included: Requirements, Design and Detail Design.

Modified existing SSIS packages to fix and enhance processes.

Assisted Manger to bring staff to proper development process.

Technologies Used: SQL Server 2008 R2, T-SQL, C#, SSIS

Customer: Harris Associates - Data Integration Specialist:

Wrote SSIS packages that moved financial data from source system to a reporting depository.

Used T-SQL to merge the data from source to destination using type 1 and type 2 dimension tables.

Developed methodology to enhance development time of ETL process.

Designed system to be able to automate the data mapping.

Redesigned original schematics to be more effective.

Documented all processes and mapping of data.

Created reports using SSRS and stored procedures.

Created functional VBA Excel spreadsheets to use data from warehouse for owners to calculate profits.

Technologies Used: SQL Server 2008 R2, T-SQL, C#, SSIS, SSRS, VBA, VB.NET 3

Customer: Apartments.com - Data Integration Specialist:

Wrote SSIS packages that integrated data to and from Salesforce.

Documented data map to show data flow from warehouse to Salesforce.

Mentored users on SSIS.

Developed SSIS template logic so users can delete data from an object in Salesforce.

Assisted in the development of Agile stories for project and time estimations.

Technologies Used: SQL Server 2008R2, T-SQL, SSIS, Salesforce (cloud)

Customer: NXT Capital - Data Integration Specialist:

Developed SSIS packages that move financial data from source system to a reporting depository.

Used T-SQL to merge the data from source to destination using type 1 and type 2 dimension tables.

Developed methodology to enhance development time of ETL process.

Designed system to be able to automate the data mapping.

Redesigned original schematics to be more effective.

Documented all processes and mapping of data.

Technologies Used: SQL Server 2008 R2, T-SQL, C#, SSIS, SSRS

Magenic August 2007 – January 2012

Senior Consultant:

Customer: Abbott Laboratories - Data Specialist:

Wrote SSIS packages to test data between databases instances to ensure proper replication.

Developed SQL reports that tracked data on production system that checked for system integrity.

Developed data change process to track all data changers requested by users this enabled developers to better determine where fixes may be needed in the system as well as a verified rollback of data if needed.

Wrote and tested protocols for releasing of software.

Wrote SQL updates in C# and SQL to the production system.

Technologies Used: SQL Server 2008, T-SQL, TFS, C#, SSIS

Customer: Huron Consulting - Reporting Architect:

Assisted business with creating a process and workflow for records management remediation.

Developed and Created Repots to house records management remediation data.

Assisted in ETL processes to import retention schedule, inventories, legal cases and attorney decisions.

Created functional spreadsheet for review process as lawyers review document to not allow certain processes.

Technologies Used: SQL Server 2008, T-SQL, SSRS, BIDS, VS DB Pro., TFS, Excel, VBA

Customer: Bally's - Data Warehouse Developer:

Assisted in the design of an enterprise warehouse.

Built SSIS package to load Type 2 dimension.

Built SSIS packages to load Fact tables.

Assisted in debugging MDX code.

Designed new format for reports to use Matrix over table, making report development simpler.

Used stored procedures and functions to be used with SSIS packages for easily management of enterprise system.

Technologies Used: SQL Server 2008, SSIS, SSRS, SSAS, MDX

Customer: TTX - SSIS/SSRS/SSAS Specialist:

Developed SSIS that exports data from production database to staging and to build fact and type 2 dimension tables.

Used SSAS to build cubes and add business intelligence measures.

Worked with team to design a data warehouse.

Wrote MDX reports adapting linked servers to SSAS giving flexibility within the reports.

Created extensive reports using matrix and table structures.

Created stored procedures to be used with reports.

Standardized SSRS templates to comply with company standards.

Provided detailed documentation mapping all report fields to warehouse and to original database.

Technologies Used: SQL Server 2005, SSIS, SSRS, SSAS

Customer: Sears Holdings - SSIS/SSRS Specialist:

Mined data to fit into PPS fact tables Assisted with Business Modeler to design a PerformancePoint 2007 Planning application for Forecasting involving workflow, assignments, Excel, dashboard, and reports.

Designed and implemented complex SSIS Data Integration between three source systems and PerformancePoint to load the key fact tables in the application.

Data was set up and tested in the PPS staging area so it can be converted into the PPS product cubes.

Technologies Used: Performance Point 2007 Planning and Monitoring, SQL Server 2005, SSIS

Customer: TTX - SSIS/SSRS Specialist:

Developed SSIS that exported data from old user systems to SQL 2005.

Set-up batch processes to update data nightly via the SSIS.

Configured the SSIS packages to be deployed via configuration files.

Built ad-hoc reports Using SSRS.

Created complex views and stored procedures.

Developed SSIS and C# routines to migrate data from SQL Server to Excel. Users can then save changes in the excel spreadsheet and update them back to the SQL server.

Created logical and physical data schematic for project.

Technologies Used: SQL Server 2005/8, SSIS, SSRS, C#

Customer: Neighborhood Health Plan - Data Specialist:

Developed .NET Solution that automated the execution of 80 queries for the creation of the Claims Lag report in Microsoft Excel.

Developed a series of Commission reports including Commission History and Commission Calculations. This also included creating an archive for reproduce Commission Reports.

Developed SSIS process to move claims data into Microsoft Excel to analyze timing of payments and receivables.

Developed reports to track Premium Lag.

Developed reports to track Cash requirements.

Met with users to gather requirement, documentation and produce functional specifications for reports.

Performance-tuned Data Warehouse to allow for faster execution of reports.

Technologies Used: SQL Server 2005, SSRS, SSIS, C#, Visual Studio 2005

Emes Consulting November 2004 – August 2007

Programmer:

Assisted team members in compliance.

Modeled database schemas (Logical and Physical).

Set-up security and standards for ETLs.

Designed and built cubes for reporting and billing of clients.

Documented detailed and functional specifications.

Worked on Data Warehouse Team for a Major consulting firm.

Converted data from Firebird to SQL Server.

Developed database driven web sites.

Built extensive OLAP Cubes for a major insurance company.

Developed a HIPAA compliance questionnaire web site.

Built custom modules for DotNetNuke.

Customized and developed Crystal Reports.

Technologies Used: SQL Server 2005, T-SQL, C#, ASP.Net, ASP, OLAP, Crystal Reports, DotNetNuke, Visual Studio 2005, Firebird, ERwin

University of Illinois Dental School December 2002 – October 2004

Database Software Specialist:

Reverse engineered third-party database to create a data warehousing system.

Provided performance and tuning services for the dental school database.

Developed custom software for the dental school.

Designed and architected a data warehouse reporting system.

Set-up standards for data deployment for the university’s dental school.

Set-up data marts for different university departments.

Set-up a stand-by database including partitioning.

Performance tuning of Oracle databases.

Database schema design.

Technologies Used: C#, .Net, Crystal Reports, Excel, Oracle, Embarcadero’s ER/Studio and DBArtisan

MethodEase May 2001 – November 2002

Data/Business Analyst:

Studied vast amounts of methodologies to select a more decisive method to build better databases, faster.

Developed an application that reads information from web pages and stores data in a database.

Planned and implemented a strategy for consolidating multiple databases into a single database.

Gathered information for HIPAA privacy requirements.

Technologies Used: SQL Server, C#, ASP.NET, Embarcadero’s ER/Studio, DBArtisan

Bronner Group October 2000 – April 2001

Database and Project Manager:

Provided database and project management.

Developed web sites and databases for clients.

Designed and built a web site to allow registration and payment for classes provided by a major metropolitan library.

Wrote proposals collaboratively for various governmental contracts.

Developed a standard company methodology for database design.

Technologies Used: SQL Server 2000, Embarcadero’s ER/Studio and DBArtisan, ASP, SQL Server, IIS, XML, Visual Basic, Site Server

Emes Consulting Data Modeler/Programmer January 1992 – October 2000

Worked on multiple projects from full life cycle to quick fixes for clients.

Installed and modified FILENET system components for a major insurance company.

Set-up data warehouse/marts to effectively run reports.

Reverse-engineered databases to schemas.

Designed logical and physical schemas.

Assisted company in the design of object-oriented systems using Rational Rose.

Worked on a major retailer’s website.

Developed school supplies’ site for a major retailer.

Automated a data conversion process between DB2 and Oracle.

Managed development of web-based time keeping system for a consulting firm.

Set up automated OLTP process to run reports via email.

Generated Rose models, use-cases, sequence diagrams and class objects.

Provided development services to various client sites.

Worked on team that developed a client server EIS system for a major electric supply firm.

Assisted DBA in the design of data schemas.

Built an application to assist the test kitchen for product satisfaction at a major fast-food company.

Provided design and development of a catalog system in the Windows environment using an Oracle database.

Debugged software of the pagination system for classified ads.

Technologies Used: VB, C, C++, Oracle, SQL Server, PowerBuilder, Oracle, ERwin, ASP, VB6, Sybase, Embarcaderos DBArtisan, Site server, Broadvision

EDUCATION

BS in Mathematics and Computer Science, University of Illinois at Chicago.

Contact this candidate