Data Architect Engineer

Philadelphia, PA ***** 610-***-**** ****************@*****.***

.

JERRY ARMSTRONG JR

PROFESSIONAL SUMMARY

Twenty-five-year Information Technology Professional who has worked in administrative and consulting roles. Self-learner, with a passion for technology where I constantly study, learn, and teach myself and mentor team members of new technology. Thrive in a dynamic, fast-paced environment where my skills and experience can make an impact. Welcome the opportunity to work on a variety of exciting and challenging projects, collaborating with a talented and passionate team. Certified in Microsoft Technologies while pursuing additional certifications in Microsoft and Amazon to continue increasing my knowledge.

EDUCATION

Villanova University, Villanova, PA

Master of Science, Computer Engineering, 06/1995

Hampton University, Hampton, VA

Bachelor of Science, Electrical Engineering, 05/1992

General Electrical Company

Thomas Edison Engineering, Graduate of Computer Science Leadership Program, 06/1995

PROFESSIONAL SUMMARY

Certified in Azure Fundamentals, Azure Data Fundamentals, Azure (Security, Compliance, and Identity) Fundamentals, Microsoft® Database Development (MCTS), SAP Application Associate

Strong experience in Data Engineering, Data Architecture, System Integrations, and Database Technologies in development & administration

In depth experience in database profiling & performance tuning using SQL Query Analyzer & SQL Server Performance Monitor

Comprehensive understanding of database development methodology from multiple perspectives: user, developer, and administrator

Widespread experience with Installing, upgrading, and administering SQL Server Database Engines, Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)

Data migrations from legacy databases to the cloud (AWS, Azure)

In-depth experience in relational and enterprise data warehouse (EDW) data modeling and familiarity with data lakes

Design and build OnPrem & Cloud ETL data pipelines

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

Able to digest complexity while maintaining an understanding of the “big picture” of business needs

TECHNICAL SKILLS

Financial Systems: SAP, Oracle, JDE, PeopleSoft

Database: SQL Server (2019, 2017, 2016, 2014, 2012, 2008, 2008 R2, 2005, 2000, Express, Access), Oracle (7, 8, 9i, 10g, 11g), Sybase IQ, IBM DB2, Microsoft Stack (SQL, SSIS, SSAS, SSRS, Power BI, NoSQL, Open-Source RDBMS

ETL: Microsoft SSIS, Azure Data Factory, Informatica, Power BI Desktop (Cloud)

Programming Languages: .Net (ASP.Net, ADO.Net, VS.Net, C#.Net, .Net Framework, Web Services), Classic ASP, Java, Scala, Python, JSON, VB, VB Script, JavaScript, C++, COM+/DCOM, T-SQL, PL/SQL, Java (JSP, JDBC, EJB), SAP ABAP

Methodologies & Version Control: GitHub, Agile, CI/CD

Operating Systems: Windows, DOS, UNIX, LINUX

BPM/BI/ERP: SAP (BPC 7, 7.5, 10.0, 10.1, 11.0, NetWeaver, BW, HANA, ERP), BOBJ (3.1 - 4.1), BODS (4.0 - 4.2), TM1 (9.5, 10.1), TM1

Modeling Tools: Power Architect, ERWin, VISIO

Cloud Computing: IaaS, PaaS, SaaS – AWS, Microsoft Azure

Microsoft Azure: Azure SQL Database, Storage, KeyVault, Data Factory

Amazon Web Services (AWS): EC2, S3, RDS, Redshift

Snowflake: SnowSQL, Snowpipes

WORK HISTORY

SENIOR DATA ARCHITECT / DATA ENGINEER 01/2008 to Present

Breakaway Technologies Inc, Philadelphia, PA

Selected projects over the last 10 years with Breakaway Technologies. A Microsoft, SAP, TM1, and Cloud consulting firm delivering high performance and available ERP & Analytical Systems on the Microsoft Platform & Stack.

Cloud Data Engineer/Data Architect, New Hampshire

Created AWS S3 buckets in Amazon to store data files from Oracle Financials

Integrated Snowflake to AWS Storage - S3 Buckets

Set up AWS User in Amazon for Snowflake access - created AWS User, policies with JSON file, attached IAM roles.

Implemented integrated storage in Snowflake to stage the AWS S3 data files.

Implemented Snowpipes to automatically ingest data from integrated storage.

Created a Snowflake warehouse.

Implemented CDC data pipelines to extract, transform, and load data from integrated stage to the warehouse.

Performed data tie-out by comparing the source data in Oracle via PL/SQL to that loaded in Snowflake via Transact SQL and SnowSQL.

Cloud Data Engineer/Data Architect, New Jersey

Performed assessments & migrations using the Data Migration Assistant. Used the assessment to plan the migration and then the Data Migration Assistant to migrate the data.

Migrated on-prem Microsoft SQL Server Databases to Amazon RDS for SQL Server using the AWS Data Migration Service (AWS DMS) and native Microsoft SQL Server tools.

Configured RDS instances and restored database back up files to them.

Created & configured source Azure BLOB Storage to store source CSV files.

Created & configured destination Azure SQL DB to store the data tables.

Created Data Factory with source BLOB and SQL destination linked services,

Developed Data Pipelines using the linked services in the Copy Activities with data transformations.

PowerBI used for data tie out reporting

Lead Data Engineer/Data Architect, Alvogen, New Jersey

Performed daily database administrator duties for the SDLC of the project. Database maintenance, security, SQL performance tuning using SQL Query Analyzer & SQL Server Performance Tuner.

Installed and configured SQL Server in a clustered server environment.

Designed, implemented, and deployed an SAP BPC 10.1 ERP on a Microsoft Stack for a Product Costing Business Application. This app allows the power business users to adjust costing metrics sourced from ECC for the company’s products on a per-product basis. These costing metrics include the cost of Direct Material, Overhead, COGS, and Labor Costs. The company saved one million in product costs for the first year while increasing each year.

Led the design & development of Balance Sheet & Income Statement ETL data pipelines. These data pipelines extract data from SAP ECC, transform, and load data to the BPC Global Financial & Intercompany Matching (ICM) Models. ETL Transformations calculate many Global currency translations for financial accounting and reporting. Sourced data from SAP ECC FICO.

Designed & developed detailed drill functionality for the Income Statements and Balance Sheets Reports.

Lead Data Engineer/Data Architect, PARX Casino, Philadelphia, PA

Performed daily database administrator duties for the SDLC of the project. Database maintenance, security, SQL performance tuning using SQL Query Analyzer & SQL Server Performance Tuner.

Installed and configured SAP BOBJ 4.0 (Crystal Server/Reports, Dashboards, Explorer, Mobility, Web Intelligence). The mobility allowed the usability of this data on the live casino floor. See the data changing near real-time in the mobile apps because the data pipelines are periodically extracting, transforming, and loading data from the source system into ERP System.

Led team to migrate BOBJ 3.5 System to a new BOBJ 4.0 Environment.

Installed and configured SAP BPC10 in a clustered server environment.

Designed and developed data pipelines, using MS SSIS ETL, to extract/transform/load casino player transactional data from various source systems to BPC. Types of data pipelines: Load revenue for table games & slot machines, Income Statements, Balance Sheets, and detailed Drill Throughs.

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

Iverson Gaming Systems, Philadelphia, PA

Lead a small Microsoft application development team for SLOTMaster. SLOTMaster tracks real-time player activity from the slot machines and table games. Patented technology to send and receive data through the power lines between slot machines/table games and SLOTMaster Software Application.

It’s currently installed in Casinos of Carnival Cruise Lines, Mediterranean Shipping Company Passenger (MSC) Cruise Lines, Palms Casino in Managua Nicaragua

Constantly traveled to various countries on cruise ships to install and deploy SLOTMaster.

Gathered ideas for improvements from each installation through personal observations, feedback from clients, and internal team members to continually grow SLOTMaster.

Technology used: Microsoft Stack, SSIS, SSRS, .net, C#

PRACTICE LEADER / SOLUTIONS ARCHITECT 06/1998 to 06/2007

DoubleStar, Exton, PA

Held roles as Application Developer to Application Development Practice Lead. Designed, developed, and deployed custom business applications and company intranets.

All projects were customized based on the client’s business needs. Technologies used for these projects varied based on their requirements.

As an Application Developer, designed, developed, deployed, and maintained many custom-built applications for various clients.

Grew into a leadership role and became Application Development Practice Lead, which entailed more setting application development standards, code reviews, technical sales support, etc. but still hands-on coding to keep up technical skills.

Microsoft Stack, Java, Oracle, Informatica, C/C++, ASP, .Net, Hyperion, ERWin, VISIO, various data profiling tools

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 Data Engineer Associate (DP-203)

Amazon AWS Certified Database - Specialty

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

Contact this candidate