Data Management Architect

Jerzy Uscilowicz

Mobile: 1-732-***-****

Email: ***********@*********.***

Summary

Over 25 years of experience assuming various roles in Technical Leadership, Data Architecture, Physical, Logical & Semantic Modeling (TD HCDM & FLDM), Data Base Administration, Performance Tuning and Service Management. As a Teradata senior consultant, Jerzy possesses a strong business background and the skills necessary to research business issues, identify solutions and implement technology to achieve the desired solution.

Jerzy Uscilowicz has over 25 years in Enterprise Data management/Data Engineering Architectures with a cross-industry multidisciplinary background.

As a thought leader and trusted advisor in Information Management, had implemented, architected, and delivered a wide variety of off the shelf and/or custom data management solutions. Helped a wide variety of customers across multitude of industries in achieving very cost effective and high performing data driven enterprise analytic goals.

Jerzy Uscilowicz is a positive, proactive, and highly client-focused avid learner with a proven track record of effectively translating conceptual ideas and business requirements into impactful data driven analytic solutions focusing on Enterprise Data Warehouse, Digital Analytics, Datamart consolidations, Integrations, Data Modelling, Cloud Migration, and related Data Governance processes.

He has led and coordinated teams across the globe, while being individually responsible for critical hands-on tasks to deliver successful implementations of petabyte scale Enterprise Data Warehouses impacting hundreds of applications and thousands of users allowing the realization of real and continuous ROI to his clients.

Relevant Engagements

TIAA, Data Architect Test Data/ Quality Engineer - September 2024 – Current

Test Data Management team member to review the existing and propose future TDM architecture regarding data identification, acquisition, population and maintenance. Created TDM platform for data contamination in lower environments by designing specialized queries to compare production vs. test data for PII information. Evaluated such tools as Securiti.AI, Collibra, DataGuise, Starburst/Galaxy for their capabilities

Comcast, Quality Engineer / Teradata SME- June 2024 – September 2024

Supported the high visibility DX (Digital Experience) project critical testing of Tableau reports related to Teradata Migration from on-premises to Teradata VantageCloud on AWS. 400+ reports selected for testing to be ran on Teradata both on premises and cloud for comparison. Researched and selected various test tools to meet the client requirements. Provided inputs to the overall test plan. Setup all 4 Postgres environments for metadata queries. Installed databases/tables/functions for these test tools on local Postgres server. Trained team members on Postgres Tableau meta data queries. Managed the request of Team Teradata accesses for client Teradata environments. Installed Tabjolt Server for automated Tableau report testing working with client reporting team to resolve barriers. Executed Tabjolt testing scenarios. Analyzed metadata model and created queries to extracted test run details from Tableau metadata for test reporting. Assisted with Python Test Automation coding & testing. Provided sessions on Tabjolt with other team members for KT.

Client provided positive feedback on results of team effort and decided to internalize our automation testing processes and tools as a part of their standard test processes. This was a very compressed timeline with many requirements

Boeing, Data Engineer/Data Architect - December 2023 – March 2024

Data architect for Boeing’s BDS POC for MVI(Material Vertical Integration) reporting. Created a comprehensive inventory of all field data mappings and transformation from both source IRE(Teradata) and IBI(Oracle) data. Developed a robust Data Model within the BEDW (Teradata) environment

Designed and implemented processes for capturing and curating data, ensuring it is properly prepared for populating the Excel Sheet

Developed and performed semantic layer testing, validation, and reconciliation with Boeing’s SMEs

Suffolk Northern, Freight Logistics Data Architect /Modeler- January 2023 – July 2023

Semantic data modeler for near-real time data warehouse solution, with DB2 data source, Datastage ETL, and Teradata (on-prem) target.

Assisted data warehouse solution, with DB2 data source, Datastage ETL, and Teradata (on-prem) target.

Created comprehensive data dictionary with source to target mapping, derived columns, data types for the consumption layer.

Verizon, Data Architect/Semantic Layer Virtualization, (January 2023 – May 2022)

Data architect or a large telecom company on Planning, Reporting & Data Strategy Program. The semantic model will be approved through user stories for source data requirements and driver definitions. Estimates assumes 3 data sources (SAP/eHANA, GCP, Teradata), 14-18 master data governance objects (i.e., dimensions, hierarchies, attributes, alternate hierarchies) and 35 intermediate transactional objects. Source systems include Anaplan for all BUs where revenue and OPEX need to be integrated for Oracle EPM. The enterprise and segment design framework will provide the requirements of the initial management reporting and planning master data objects, which is to be managed in centralized master data tool. Estimates assumes up to 100 attributes will be loaded from each data source Integration approach (e.g., direct connect vs file exchange) will be determined during the Blueprint phase. Virtual/Physical semantic layer architecture will be determined during blueprint phase. ETL tech stack to be determined based on target state architecture defined in blueprint phase using either GCP or Starburst.

Ally Bank, Data Architect, (May 2022 – December, 2022)

Data architect/modeler for a large online bank. Working with the SMEs, various user groups and offshore teams to support Snowflake Nucleus data warehouse/data lake for various HR data sources (user profile, employee groups, survey & feedback data, pay factors) and ServiceNow data feeds using NiFi, sftp and AWS S3 buckets. Involved in the data models creation at conceptual, logic and physical levels. Provided the mapping for ETL teams for various internal and 3rd party vendors of data sources in structured and semi-structured format following the company’s Data Vault 2.0 methodology (hub, satellite, and link entities). Creating Erwin data models for the data governance team reviews.

Supporting Snowflake running on AWS for databases/schemas creation, tables, views, performance problems, table flattening, dimensional modeling design for analytics.

JPMC, Data/Cloud Architect, (February 2022 – May 2022)

Data/Cloud architect on JPMC multi-year Data Center migration program and as part of the program is working towards identifying which data applications should remain on Teradata and which should be migrated to cloud e.g. AWS/Snowflake and cloud-native ETL tools. Two vendors are assisting JPMC in identification of applications to be migrated to cloud and the drafting an application disposition plan. Reviewing several different artifacts to create datasets for Pulse scripts of Teradata metadata. Creating multiple insights of Teradata current state. Examining the LOB/application clusters from multiple angles. Reviewing critical dependencies on strategic initiatives, such as Data Center Migration and Cloud Strategy.

Celgene/Bristol Myers Squibb, Summit, NJ (April 2019 – October 2021)

Data Architect on Celgene new drug launch. The role requires coordinating data sources from multiple vendors (aggregators, hubs, 3rd party etc.) feeding the data lake. Managing the offshore team of developers in India.

The DataKitchen schemas are maintained in AWS/S3/RedShift cluster that are used for all analytical purposes accessed by Tableau/Alteryx servers. Created and maintained ETL processes to move data from stage/core layer to semantic layer for Tableau analytical needs as well as data extracts to internal/external applications.

Responsible for RedShift schema design, data quality, defect resolution, performance and all other data-related issues recorded in JIRA.

Managing a few small teams of offshore consultants to migrate several 3rd party applications to BMS’s corporate data lake CSCAN (AWS/S3 Redshift environment. The responsibilities include code, processes, ETL processes and all 3rd party data feeds replication, data validation testing and all necessary modifications.

Anthem, Richmond, VA (July 2018 – February 2019

Data Architect/Semantic Layer Data Modeler on Served as Data Architect/Data Modeler on Anthem's HealthCloud project that is a multi-tenant analytical platform used to ingest and curate data from multiple customers/clients and provide access to industry leading analytical models and other applications as a service. Analyzed ADL layer in Hive for all fact and dimension views for all Tableau reporting needs using SAP Power Designer modeling tool. Involved in data modeling, data mapping cross functional sessions for all data sources. Supported Agile project delivery model by using JIRA/Confluence, Hue/IMPALA and BitBucket. Created data load scripts from CFF layer into ADL data layer within IBM Cloud/Hadoop Cloudera data lake repository.

PNC Bank, Cleveland, OH (March 2018 – June 2018)

Teradata Architect/Semantic Layer Data Modeler on PNC Bank. Analyzed semantic layer for all fact and dimension views and then proposed several improvements.

Tested the proposed improvements in POC DataLab environment. The following modifications to the existing databases have been applied and sample test report queries retested: statistics both new and missing, changing PI for major fact tables, compression, partitioning and creating JIs on several look-up tables. The overall performance boost was between 20-40% depending on the particular query logic. In addition, many spooled out queried have run successfully in POC.

Ameren, St. Louis, MO (July 2017 – February 2018)

Teradata Architect/Semantic Modeler on Ameren Energy Delivery Analytics application for several subject areas such as weather, revenue, usage, meter reading, reading interval, lighting etc. Maintained semantic layer for all fact and dimension views built on Teradata Utility LDM which was using temporal functionality of Teradata.

Tested semantic layer, existing reports (300 reports including 8 SAS queries) & made necessary changes for required compatibility (SQLServer to Teradata compatibility).

Created & maintained the XFEF document that was used by OBIEE team for join criteria, source-to-target mapping and CDW (production) vs. UAT (Teradata) view/column/derived column listing. Performed a thorough data validation for all semantic views that provided information about ETL defects, data mismatches and default issues. Co-wrote & maintained several stored procedures to materialized complex facts/dims including full replace or delta logic. Involved in analysis of over 300 OBIEE and SAS reports by providing the finding to users about discrepancies and solutions to data issues. Improved performance of majority of long running reports by partitioning tables, compression, collecting stats and JIs.

McCain Foods, Canada (December 2016 – February 2017)

Teradata Semantic Modeler on 3 projects: Plant Performance, Freight Performance and Freight Variance. Performed review and analysis of semantic models for all 3 applications. Suggested several improvements that were implemented in 3 iterations such as secondary indexes, statistics, column compression, partitioning, DDL rewrite

Created and tested several Join Indexes for Plant Performance applications.

Assisted in testing Microstrategy SQL scripts. Conducted DBQL analyses for worst performing queries. Recommended the use of QueryBanding for BI tool queries

Keiser Permanente (June 2016 – November 2016)

Teradata Architect on Keiser Permanente Cerner Millenium system. Performed data analysis, profiling, and review data demographics for 187 Cerner Lab source tables. Reviewed Business Objects reports and query access paths for existing Cerner Lab reporting needs as well as identified analytic use cases for integrating Cerner Lab data with other existing data sets.

Designed and implemented physical data model for 187 SCAL Cerner Lab tables tuned for analytics on Teradata. Designed and implemented semantic layer structures to facilitate end user access and data re-use through encapsulation of business logic, simplification of join paths and tuning for query performance. Review of existing reporting queries & access paths

Demonstrated integration of Cerner Lab & Clarity data.

Assisted KP with reconfiguration and tuning of reports for Teradata data model and semantic layer. Testing of semantic layer views for data accuracy

Previous Engagements (pre-2015)

Worked as an employee of IBM, Lucent Technologies or independent consultant for such companies as United Health Group, Keiser Permanente, Verizon, JP Morgan Chase, Johnson & Johnson, Well Fargo, State Street Bank & Trust, Merck, Merrill Lynch, AT&T etc.

Certifications:

AWS Cloud Practitioner, Snowflake, 2 Teradata Vantage, MS Azure

Education:

MS. In Computer Science & Management, Technical University of Wroclaw, Poland

Roles

Data Architect

DBA

Integration Specialist

Physical/Logical/Semantic Modeler

Cloud Migration

Technologies

Teradata

Redshift

Snowflake

Hadoop

Hive

Unix

Alteryx

Informatica

Tableau

ERWIN/SAP Power Designer

C/C++

UDF in C/C++

Java

Cognos

Aster

Hadoop (pig, hive, hcat, Cassandra, spark)

Python

AWS

Collibra

Industries

FIHL (Financial, Insurance, Healthcare Financial & Life Sciences)

Telecommunication

Utility (Gas/Electric)

Functional Expertise

Teradata Load Utilities

Physical Database Performance

SQL Development

Application Development

Unix/Linux scripting

Education

MS, Management & Computer Science, 1982, Technical University of Wroclaw, Poland

Certifications

2 TD14 certifications

Contact this candidate