Data Engineer / Data Architect

.

.

Gaithersburg, MD ***** 610-***-**** ****************@*****.***

www.linkedin.com/in/jerry-armstrong-jr-2886b268

JERRY ARMSTRONG JR

PROFESSIONAL

SUMMARY

Microsoft Azure Data Engineer and information technology professional with 30 years of experience in data engineering, database technologies, administrative leadership, and consulting roles. Brings hands-on expertise designing, migrating, and supporting cloud data solutions using Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure SQL, ADLS Gen2, Delta Lake, and Power BI. A self-directed learner and technology enthusiast who continually expands technical expertise, mentors team members on emerging technologies, and contributes effectively in dynamic, fast-paced environments. Holds multiple Microsoft certifications and is pursuing additional Microsoft Azure, Microsoft Fabric, and Snowflake credentials.

EDUCATION Villanova University, Villanova, PA

Master of Science, Computer Engineering

Hampton University, Hampton, VA

Bachelor of Science, Electrical Engineering

General Electrical Company

Thomas Edison Engineering, Graduate of Computer Science Leadership Program PROFESSIONAL

SUMMARY

• Certified in Azure Fundamentals (AZ-900), Azure Data Fundamentals (DP-900), Azure

(Security, Compliance, and Identity) Fundamentals (SC-900), Microsoft® Database Development (MCTS), SAP Application Associate, Microsoft SQL Server Professional, Enry-Level Python Programmer (PCEP) Specialization, Snowflake Data Engineering Professional

• Strong experience in Data Engineering, System Integrations, Solution Architectures, and Database Technologies in development & administration

• In depth experience in database profiling & performance tuning using SQL Query Analyzer & SQL Server Performance Monitor, execution plans, indexes

• Widespread experience with Installing, upgrading, and administering SQL Server Database Engines, SSIS, SSRS, & SSAS

• Data migrations from legacy databases to the cloud (AWS, Azure SQL & Databricks)

• Design, build, and support enterprise data warehouse pipelines and data models across bronze, silver, and gold layers in Databricks

• Own data domains as production systems, help simplify legacy transformation layers, and support the transition from batch processing to event-driven, low-latency ingestion

• Established strong engineering practices, document complex systems, review code, and mentor other Data Engineers

• Optimized pipeline performance, processing latency, reliability, and Databricks & Snowflake compute costs

• Ability to independently build, review, troubleshoot, and optimize complex data transformations.

.

.

• Superior analytical and troubleshooting skills

• Effectively communicate with all levels of management, customers, development team members, and vendors

• Strong analytical and problem-solving skills

• Excellent verbal and written communication skills TECHNICAL SKILLS • Financial Systems: SAP, Oracle, JD Edwards, PeopleSoft

• Databases: Microsoft SQL Server (2000–2025, Express), Azure SQL DB, Azure SQL Data Warehouse, Azure Synapse Analytics, Microsoft Access, Oracle, Sybase IQ, IBM D2

• ETL and Analytics: MS SSIS, Azure Data Factory/Databricks/Fabric, Informatica, Microsoft Power BI, SAP BODS

• Programming Languages and Frameworks: .NET, ASP.NET, ADO.NET, Visual Studio

.NET, C#, .NET Framework, Web Services, Classic ASP, Java, Scala, Python, JSON, Visual Basic, VBScript, JavaScript, C++, COM+/DCOM, T-SQL, PL/SQL, JSP, JDBC, and SAP ABAP

• Methodologies and Version Control: Agile, CI/CD, and GitHub, Azure DevOps

• Operating Systems: Windows, DOS, UNIX, and Linux

• BPM, BI, and ERP: SAP BPC (7, 7.5, 10.0, 10.1, 11.0), SAP NetWeaver, SAP BW, SAP HANA, SAP ERP, SAP BusinessObjects (3.1–4.1), SAP BODS (4.0–4.2), and IBM Cognos TM1 (9.5, 10.1)

• Data Modeling Tools: Power Architect, Erwin, and Microsoft Visio

• Cloud Computing: IaaS, PaaS, and SaaS across AWS and Microsoft Azure

• Azure Data Engineering: Medallion Architecture (Bronze-Silver-Gold), Azure Data Factory (orchestration, Apache Spark Declarative Pipelines (PySpark, Spark SQL), SDP Expectations, Lakeflow Jobs, data ingestion from (on-premises SQL databases, Azure Blob Storage, and Azure Data Lake Storage Gen2), Azure Databricks notebooks, Azure Synapse Analytics

• Snowflake: SnowSQL, Snowsight, Snowflake CLI, and the Visual Studio Code extension

.

.

PROFESSIONAL

EXPERIENCE

SENIOR DATA ENGINEER 07/2023 – Present

Pratt & Whitney, East Hartford, CT

SAP ABAP Reports Conversion to complex MS SQL Views Project Analyzed complex SAP ABAP reports and SQL traces, translating procedural logic into optimized CTE-based SQL views for Microsoft Azure Synapse Analytics. Replaced slow, cumbersome SAP reporting processes with more efficient Power BI reports and dashboards that improved usability and presentation.

Designed and developed SAP BODS data pipelines to extract data from SAP and load it into Microsoft Azure Synapse Analytics.

Microsoft Fabric Data Factory/Databricks Migration Project Migrated SQL views, stored procedures, and SAP BODS data pipelines from Microsoft SQL Server OnPrem to Azure SQL Server and Data Factory/Databricks. Designed and developed over 30+ end-to-end Supply Chain Management Analytics data pipelines using Microsoft Fabric, Azure Data Factory (ADF), Azure Databricks (PySpark & Spark SQL), Azure Data Lake Storage ADLS Gen2/OneLake, Delta Tables, Azure Functions, Azure SQL Database, Azure Synapse Analytics, and Snowflake. One of the largest data pipelines being Material Requirements Planning (MRP).

• Implemented Medallion Architecture (Bronze–Silver–Gold) in ADLS Gen2 to process and transform supply chain management data from raw ingestion to business-ready analytics.

• Developed PySpark transformation notebooks in Azure Databricks for data cleansing, deduplication, null handling, schema validation, standardization, and derived column creation in the Silver Layer.

• Implemented Delta Lake and Unity Catalog external locations to enable secure, governed, and scalable data storage and access across Bronze, Silver, and Gold Layers.

• Integrated curated datasets with Azure Synapse Analytics to support SQL-based querying, reporting, and downstream analytical consumption for banking insights.

• Optimized data processing using explicit schemas, Delta format, metadata-driven ingestion, and batch orchestration, improving data quality and pipeline reliability. Assessment & Discovery

Cataloged source systems, assessed SQL and ETL code complexity, and mapped data structures to define migration scope and risks.

Data Migration (ETL)

Migrated structured data from on-premises Hadoop and SQL Server environments and cloud storage, including AWS S3 and Azure Blob Storage, to Delta Lake. Code Conversion

Converted SAP BODS ETL workflows into Databricks-compatible PySpark and SQL Spark Notebooks and Snowflake data pipelines; also administered the Snowflake environment. Validation & Testing

Validated data integrity and benchmarked performance against the legacy environment to ensure accurate migration to Databricks.

User/Client Support

Supported Microsoft Power BI users by resolving report and dashboard data issues and reconciling discrepancies.

SENIOR DATA ARCHITECT / DATA ENGINEER 07/2022–07/2023 Bank

.

.

Banking Analytics Microsoft Azure Data Factory/Databricks Project

• Designed and developed end-to-end Banking Analytics Data Engineering pipelines using Azure Data Factory (ADF), Azure Databricks (PySpark), Storage Accounts, ADLS Gen2, Delta Tables, and Azure Synapse Analytics for processing banking datasets.

• Implemented Medallion Architecture (Bronze–Silver–Gold) in ADLS Gen2 to process and transform banking data from raw ingestion to business-ready analytics.

• Built scalable ingestion pipelines to process 10 banking datasets, including customers, accounts, transactions, loans, credit cards, fraud transactions, and customer support tickets.

• Developed PySpark transformation notebooks in Azure Databricks for data cleansing, deduplication, null handling, schema validation, standardization, and derived column creation in the Silver Layer.

• Implemented Delta Lake and Unity Catalog external locations to enable secure, governed, and scalable data storage and access across Medallion layers.

• Created Gold layer business aggregations such as Customer 360 View, Loan Portfolio Analysis, Branch Performance Metrics, Fraud Analytics, and Transaction Insights for reporting and analytics.

• Integrated curated datasets with Azure Synapse Analytics to support SQL-based querying, reporting, and downstream analytical consumption for banking insights.

• Optimized data processing using explicit schemas, Delta format, metadata-driven ingestion, and batch orchestration, improving data quality and pipeline reliability. SENIOR DATA ARCHITECT / DATA ENGINEER 01/2008–07/2022 Breakaway Technologies, Inc., Philadelphia, PA

Selected consulting projects from the final 10 years of a 15-year tenure with Breakaway Technologies, a Microsoft, SAP, TM1, and cloud consulting firm that delivered high- performance, highly available ERP and analytics solutions on the Microsoft platform and technology stack.

BPMConnect

Co-designed/developed an in-house ETL Tool named BPMConnect. Built on the Microsoft stack SSIS, VB.net, and C#.net. Used on all SAP BPC Projects to extract, transform, and load data from SAP ECC/BW to Microsoft SQL Server. Approved by SAP as a rapid development tool.

https://www.breakaway-inc.com/2014/05/bpm-connect-for-sap-bpc/ Lead Data Engineer / Data Architect, California

• Migrated Microsoft SQL Server databases to Azure SQL Managed Instance.

• Used Microsoft Data Migration Assistant to assess database compatibility, plan migrations, and execute data transfers.

• Provisioned, backed up, and restored Azure SQL databases.

• Automated routine database administration tasks with PowerShell.

• Administered databases throughout the SDLC, managing availability, security, performance monitoring, and optimization.

• Improved Azure SQL Database performance by implementing Automatic Tuning index recommendations.

• Configured Azure Data Factory data sources and developed ETL pipelines for the development environment.

.

.

• Configured Power BI Desktop data sources, models, and cleansing processes for report development.

Lead Data Engineer / Data Architect, New Hampshire

• Administered databases throughout the project SDLC, including maintenance, security, and SQL performance tuning with SQL Query Analyzer and SQL Server Performance Tuner.

• Installed and configured SQL Server in a clustered environment.

• Designed, implemented, and deployed an SAP BPC 10.1 product-costing application on the Microsoft technology stack, enabling power users to adjust product-level metrics sourced from SAP ECC, including direct materials, overhead, cost of goods sold, and labor. The solution generated approximately $1 million in product-cost savings during its first year, with savings increasing annually.

• Led the design and development of balance sheet and income statement ETL pipelines that extracted SAP ECC FICO data, transformed it, and loaded it into SAP BPC Global Financial and Intercompany Matching models. Implemented global currency translations to support financial accounting and reporting.

• Designed and developed detailed drill-through functionality for income statement and balance sheet reports.

Lead Data Engineer / Data Architect, Philadelphia, PA

• Administered databases throughout the project SDLC, including maintenance, security, and SQL performance tuning with SQL Query Analyzer and SQL Server Performance Tuner.

• Installed and configured SAP BusinessObjects 4.0, including Crystal Reports Server, Dashboards, Explorer, Mobile, and Web Intelligence. Enabled near-real-time access to casino-floor data through mobile applications supported by scheduled ETL pipelines that loaded source data into the ERP system.

• Led the migration of SAP BusinessObjects 3.5 to a new SAP BusinessObjects 4.0 environment.

• Installed and configured SAP BPC 10 in a clustered server environment.

• Designed and developed Microsoft SSIS ETL pipelines to integrate casino player transaction data from multiple source systems into SAP BPC, supporting table-game and slot-machine revenue, income statements, balance sheets, and detailed drill- through reporting.

IT Manager / Solutions Architect, 06/2007–11/2008

Iverson Gaming Systems, Philadelphia, PA

• Led a Microsoft application development team responsible for SLOTMaster, a real- time casino player-tracking system for slot machines and table games. The patented solution transmitted data over existing power lines between gaming devices and the SLOTMaster application.

• Supported SLOTMaster deployments at casinos operated by Carnival Cruise Line, MSC Cruises, and Palms Casino in Managua, Nicaragua.

• Traveled internationally aboard cruise ships to install and deploy SLOTMaster.

• Identified product enhancements through on-site observations and feedback from clients and internal teams, supporting continuous improvement of SLOTMaster.

• Technologies: Microsoft technology stack, SSIS, SSRS, .NET, and C#

.

.

INDUSTRY

EXPERIENCE

• Engineering: Parsons Brinkerhoff

• CPG: Stonyfield Farms/Lactalis

• Casino (Gaming): Iverson Gaming, Palms Casino (Managua), PARX, MSC (Mediterranean Shipping Company)

• Government: General Electric, Lockheed Martin, Martin Marietta

• Education: Columbia College Chicago

• Life Sciences: Abiomed, Alvogen, Dyax, Integra Life Sciences, Vertex Pharmaceuticals

• Pharmaceutical: AstraZeneca, Boehringer Ingelheim, DuPont Pharma, Merck, Purdue Pharma, Vertex, Wyeth, Zeneca

• Manufacturing: Mine Safety (MSA), Siemens

• Services: ARC Document Solutions, Dun & Bradstreet

• Retail: Broder Bros/Alpha Broder, Edison, Edmunds, Myron, Urban Outfitters

• Technology: IPC Trading Services, SunGard

CERTIFICATIONS

(IN PROGRESS)

• Microsoft Certified Azure Fabric Data Engineer Associate (DP-700)

• Snowflake SnowPro Core Certification (COF-CO3)

• Databricks Data Engineer Associate

CERTIFICATIONS

(OBTAINED)

• Microsoft Certified Azure Fundamentals (AZ-900)

• Microsoft Certified Azure Data Fundamentals (DP-900)

• Microsoft Certified Azure Security Fundamentals (SC-900)

• Microsoft Certified Professional (MCP)

• Microsoft® Certified Technology Specialist (MCTS) - Microsoft SQL Server 2008 Database Development: C425-2229

• SAP Certified Application Associate (10.1 & 11.0 BW/4HANA): C_EPMBPC_11

• Microsoft SQL Server Professional

• Enry-Level Python Programmer (PCEP) Specialization

• Snowflake Data Engineering Professional

Contact this candidate