ROBERT FILTZKOWSKI
Napa,USA
Summary
A seasoned AWS Data Engineer with a proven track record at Booz Allen Hamilton, I excel in data pipeline development and performance optimization. Leveraging skills in SQL, Python, and AWS, I've successfully migrated and scaled data warehouses, enhancing data availability by over 30%. My leadership in mentoring teams underscores my commitment to excellence and continuous improvement.
Overview
24
24
years of professional experience
1
1
Certification
Work History
AWS DATA ENGINEER
Booz Allen Hamilton
04.2023 - Current
- Responsible for monitoring and troubleshooting issues to ensure optimal availability and scalability of AWS Redshift Cluster
- Design and implemented Dimensional logical & physical model utilizing Kimball methodology
- Designed ETL/ELT specifications documenting data flow and transformations performed at each stage
- Designed and developed Data Pipelines using Data Build Tool (DBT) to populate Data Warehouse
- Implementation of Data Migration Services (DMS) to replicate Postgres to Redshift; recently migrated to utilize Zero ETL functionality
- Wrote numerous validation scripts (Python) to validate DW against source system
- Maintained documentation such as the bus matrix, lineage diagrams, data catalog and dictionary providing business with visibility into design of the Data Warehouse
- Developed numerous QuickSight assets including Datasets, Analysis and Dashboards
- Utilizing AWS CDK (TypeScript), developed scripts to generate CloudFormation stacks
- Mentor staff on various aspects of DW design & implementation
ORACLE DATA ENGINEER
Independent Consultant
02.2022 - Current
- Technical lead migrating on-premise Oracle Analytic Server (OAS) instance to Oracle Analytics Cloud (OAC)
- Configured ATP database to support various activities such as APEX, metadata management and usage tracking
- Developed and implemented strategy to maintain various metadata components utilizing OBIEE Writeback functionality
- Developed Bash scripts to perform Presentation catalog maintenance, such as user folder clean-up, archiving and removing orphaned analyses
- Performed various RPD and Analysis modifications to support business requirements
- Contributed to the migration of Oracle Essbase from Windows to Linux including the installation and configuration of Essbase on Linux, migrated Windows Batch scripts to Python for automated tasks
- Optimized data integration between Essbase and PeopleSoft utilizing Python, MAXL, SQL
- Loader and PL/SQL Packages
- Processing time was reduced from 3 hrs to 15 mins
AWS DATA ENGINEER
Tyler Technologies
04.2022 - 05.2023
- Responsible for designing, developing & implementing Redshift dimensional model
- Developed Data Pipelines using Data Build Tool (DBT) to populate Redshift Data Warehouse
- Developed numerous Python scripts to query DynamoDB utilizing Boto3
- Developed Python scripts to call REST APIs, parse the payload and store in Data Lake (S3)
- Developed numerous QuickSight assets including Datasets, Analysis and Dashboards
- Utilizing AWS CDK (TypeScript), developed scripts to generate Cloud Formation stacks
DATA ENGINEER
HERE Technologies
Chicago, USA
03.2016 - 02.2022
- Company Overview: Chicago, IL
- Built AWS infrastructure supporting the Oracle DW (RDS) and APEX (EC2) environments including automated backups, network configuration and other AWS components
- Led DW migration of entire stack from on-prem to AWS
- Designed & Implemented Dimensional data models utilizing Kimball methodology
- Designed ETL/ELT specifications documenting data flow and transformations performed at each stage
- Contributed to the design and development of efficient and scalable backend systems including data warehouse, data integration processes and RESTful APIs
- Led data integration projects sourcing Oracle PBCS, iCertis, SalesForce and Marketo REST APIs, transforming the data and loading into Data Warehouse
- Developed numerous PL/SQL based applications including a custom build MDM solution to manage vendors across Salesforce and PeopleSoft
- Responsible for administering 7-node Qlik Sense environment on AWS, developing curated datasets for Finance team
- Developed numerous database applications using stored procedures and Oracle APEX
- Chicago, IL
ORACLE BI ARCHITECT
Brookdale Senior Living
Milwaukee, USA
03.2015 - 03.2016
- Company Overview: Milwaukee, WI
- Led team in migrating and upgrading OBIA DAC & Informatica PowerCenter to Linux
- Assisted Informatica developers in design and troubleshooting efforts
- Assisted OBIEE developers in troubleshooting various issues including data quality, performance, and usability
- Identified and developed solutions to resolve performance bottlenecks within the entire data flow, including ETL (Informatica), OBIEE RPD changes and OBIEE Analysis
- Milwaukee, WI
SENIOR BUSINESS INTELLIGENCE CONSULTANT
HERE Technologies
Chicago, USA
01.2011 - 03.2015
- Company Overview: Chicago, IL
- Accountable for all OBIEE environments, executed upgrade from 11g to 12c
- Responsible for developing RPD and dashboards, implementing FGAC and advanced features
- Vertically and horizontally integrated Essbase and DW in OBIEE to enhance Finance (OpEX and Revenue) reporting
- Developed Informatica mappings to populate star schemas, type 1 and type 2 dimensions
- Responsible for troubleshooting and resolving performance bottlenecks in Oracle DW, consisting of modifying the index strategy, generating materialized views, or optimizing the data pipeline
- Chicago, IL
SENIOR BUSINESS INTELLIGENCE CONSULTANT
Catamaran
Milwaukee, USA
04.2010 - 12.2010
- Company Overview: Milwaukee, WI
- Designed ETL data mappings, developed in OWB to populate dimensional model
- Developed OBIEE RPD and Dashboards to support business requirements
- Identified and resolved data quality and performance issues across the data pipeline
- Milwaukee, WI
SENIOR ORACLE CONSULTANT
Oshkosh Corporation
Oshkosh, USA
04.2009 - 04.2010
- Company Overview: Oshkosh, WI
- Developed all PL/SQL components and Oracle Workflow modules to support custom Change Request application
- Converted numerous interfaces originally developed in BPEL into PL/SQL, providing the required scalability
- Provided support across entire Oracle stack during implementation of iSupplier Portal
- Oshkosh, WI
SENIOR BUSINESS INTELLIGENCE CONSULTANT
Phillips-Medisize
Eau Claire, USA
04.2008 - 04.2009
- Company Overview: Eau Claire, WI
- Designed and developed fully functional, robust model to support client's Sales Reporting initiative
- This included multiple staging areas to support 3 source systems along with a completely integrated Data Warehouse and Data Mart
- Implemented Oracle Streams to populate staging area in real-time, providing the foundation to support incremental loads into the Data Warehouse
- Eau Claire, WI
SENIOR ETL CONSULTANT
ACT
Iowa City, USA
01.2007 - 03.2008
- Company Overview: Iowa City, IA
- Conducted interviews and meetings, performed extensive research leading to modelling of new Data Mart
- Developed numerous OWB Mappings to support new data model in Strategic subject area
- Identified and implemented strategies to optimize database performance to meet required SLAs
- Iowa City, IA
SENIOR BUSINESS INTELLIGENCE CONSULTANT
Boyd Gaming
Las Vegas, USA
01.2007 - 03.2007
- Company Overview: Las Vegas, NV
- Conducted interviews and meetings, performed extensive research leading to modelling of new Purchasing DW
- Responsible for gathering business requirements by conducting user interview and reviewing source systems
- Designed and implemented Dimension Model for Purchasing department consisting of dimensions and fact tables
- Developed ETL processes in Cognos Decision Stream 7.x populating DW in SQL Server
- Assembled numerous validation and reconciliation reports to determine accuracy of dimensional model
- Las Vegas, NV
ORACLE DATABASE CONSULTANT
AIG
Woodland Hills, USA
10.2000 - 01.2007
- Company Overview: Woodland Hills, CA
- DBA responsible for maintaining data warehouse environments (Oracle 9i on Sun Solaris 5.8)
- Duties included developing backup and recovery strategies, performance tuning, query optimization, writing stored procedures and triggers using PL/SQL
- Designed and implemented bi-directional interfaces with various systems
- Responsible for pre-production performance tuning, capacity planning, disaster recovery and security administration within Data Warehouse environment
- Lead Oracle Developer responsible for architecting ODS and Data Warehouse loading methods
- Wrote numerous PL/SQL packages populating the Data Warehouse and ODS
- Wrote numerous shell (ksh) scripts to perform various tasks
- Performed benchmark tests between various data transfer methods from SQL Server to Oracle including BCP to flat-file, DTS with native and 3rd party drivers and DTS to a flat-file
- Woodland Hills, CA
Education
Bachelor's Degree - INFORMATION SCIENCE
UW-Milwaukee
Milwaukee, WI12.2026
Associate Degree - COMPUTER SCIENCE
Chippewa Valley Technical College
Eau Claire, WISkills
- SQL
- PL/SQL
- ETL
- Informatica
- DBT & Jinja
- OBIEE
- APEX
- PowerShell
- BI Publisher
- Python
- CI/CD
- Git
- TypeScript
- Qlik Sense
- Oracle Database
- RedShift
- Relational and star schema modelsodels
- Data analysis
- AWS
- OCI
- Oracle
- SQL Server
- Postgres
- Essbase
- DynamoDB
- BI and Analytics
- Data pipeline development
- Infrastructure as Code
- Data migration strategies
- AWS glue ETL management
- Data modeling techniques
- SQL querying
- Data security practices
- Performance optimization
- Data lake management
- Real-time data streaming
Certification
- AWS Certified Solution Architect Associate, 2023
- AWS Certified Cloud Practitioner, 2023
- Oracle Cloud Infrastructure, Autonomous Database Specialist (2022), Architect Associate (2022), Database Migration and Integration Specialist (2022), Enterprise Analytics Specialist (2022)
- Oracle DBA, 2004
- Oracle Developer, 2001
Timeline
AWS DATA ENGINEER
Booz Allen Hamilton
04.2023 - Current
AWS DATA ENGINEER
Tyler Technologies
04.2022 - 05.2023
ORACLE DATA ENGINEER
Independent Consultant
02.2022 - Current
DATA ENGINEER
HERE Technologies
03.2016 - 02.2022
ORACLE BI ARCHITECT
Brookdale Senior Living
03.2015 - 03.2016
SENIOR BUSINESS INTELLIGENCE CONSULTANT
HERE Technologies
01.2011 - 03.2015
SENIOR BUSINESS INTELLIGENCE CONSULTANT
Catamaran
04.2010 - 12.2010
SENIOR ORACLE CONSULTANT
Oshkosh Corporation
04.2009 - 04.2010
SENIOR BUSINESS INTELLIGENCE CONSULTANT
Phillips-Medisize
04.2008 - 04.2009
SENIOR ETL CONSULTANT
ACT
01.2007 - 03.2008
SENIOR BUSINESS INTELLIGENCE CONSULTANT
Boyd Gaming
01.2007 - 03.2007
ORACLE DATABASE CONSULTANT
AIG
10.2000 - 01.2007
Bachelor's Degree - INFORMATION SCIENCE
UW-Milwaukee
Associate Degree - COMPUTER SCIENCE
Chippewa Valley Technical College
Similar Profiles
Randy BrownRandy Brown
Physical and Personnel Specialist at Booz Allen HamiltonPhysical and Personnel Specialist at Booz Allen Hamilton
Kimberly GrayKimberly Gray
Senior Executive Administrative Assistant at Booz Allen HamiltonSenior Executive Administrative Assistant at Booz Allen Hamilton
Amanda RutiglianoAmanda Rutigliano
Lead Associate/Portfolio and Strategy Task Lead at Booz Allen HamiltonLead Associate/Portfolio and Strategy Task Lead at Booz Allen Hamilton
Charles ProctorCharles Proctor
Logistics Analyst / Project Manager at Booz Allen HamiltonLogistics Analyst / Project Manager at Booz Allen Hamilton
Melissa AtwoodMelissa Atwood
Director of Operations at Grant Engineering & Manufacturing Inc.Director of Operations at Grant Engineering & Manufacturing Inc.