Led intense, two to four-day data labs with customers ranging from startup to enterprise workloads, spanning analytics, AI, and Machine Learning Services.AWS Data Labs are accelerated, joint engineering engagements between customers and AWS technical resources to create a functional prototype in a week or less. Candidate workloads include databases, analytics, artificial intelligence/machine learning (AI/ML), application & infrastructure modernization, and DataOps initiatives.* Architected terabyte-scale Redshift cluster to replace a sharded Maria DB cluster to reduce latency from 24 hours to 15 minutes via Database Migration Service and Redshift Materialized Views* Refactored legacy ETL to leverage AWS Glue and Glue Studio* Mastered DynamoDB Single-table design for petabyte scale point of sale workload to meet millisecond ACID transaction latency * Improved Global Replication and Recovery Time Objective by hours via Amazon Aurora Global tables* Specialized in NLP services like Amazon Textract and Amazon Comprehend for Intelligent Document Processing (IDP)* Architected multi-model endpoint in SageMaker to scale to thousands of model versions used in serial inferences* Prototyped, Architected IDP pipelines to reduce document processing from days to minutes at a scale of 10 million documents/day, using NLP and Human-in-the-Loop to accurately extract data into DynamoDB.* Led thought on IDP space and the data lab engagement model - advised on how to run successful labs for these use cases.* Connected with AWS service teams to surface important features, evaluate new releases, and curate customer feedback* Acted as Subject Matter Expert on the following services:* * Amazon Textract and Amazon Comprehend for IDP workloads* * Amazon DynamoDB for terabyte-scale, millisecond latency analytics

* Lead, manage, and deliver data engineering engagements beginning to end* Guide customers through greenfield Data lake architectures, skills ramp, and key organizational decisions for adoption* Assist customers in executing on the Lake house architecture using S3, Redshift Spectrum, Athena/Presto* Assist customers in building ETL in PySpark on AWS Glue* Help migrate existing ML models to Sagemaker for running at scale* Execute on the serverless application architecture using things like Amplify, DynamoDB, API Gateway, and S3 to run single page applications* Embed TekSystems analytics into Slack using API Gateway and slash commands for quick access to business insights* Orchestrate customer data pipelines using Step Functions* Build infrastructure-as-code using CloudFormation, SAM, and CDK* Architect/deliver on event-driven architectures using Event Bridge, S3 Events* Migrate existing batch processing data pipelines to AWS using AWS Glue and Step Functions.* Assist in implementing Data Quality using PyDeequ* Build Ingestion of data in real-time or batch via Database Migration Service for change data capture (CDC).* Deliver classroom instruction on and delivered work using Kinesis for log shipping and CDC data.* Optimize Redshift tables and clusters to perform faster, as well as orchestrating cluster down times to minimize costs.* Set up AWS Organizations for greenfield telecom customer to enable safe innovation within Organizational Units* Architect/build shared enterprise VPC network using Transit Gateway, VPN, and Shared VPCs.

I assist clients in understanding how their existing systems will translate into an AWS architectures and guide them through the process of migrating. My areas of expertise are in architecting solutions to support data workloads such as data lakes, data warehouses, ETL/ELT workflows, Streaming workflows, analytics, and machine learning operations.

Managed a consulting software development team of 5 throughout various projects.*Oversaw delivery of up to 5 different data warehouse projects at a given time with strict deadlines*Planned resources and budget to grow team with the pace of new work*Collaborated across Beyondsoft business units to estimate new development work, supporting technical sales through high-level architecture and technology stack evaluations for prospective clients*Worked closely with Sr. Leadership to ensure monthly P&L goals were being met*Turned sales opportunities into billable software contracts, estimates, and high-level architecture*Step into hands-on development to ensure quality of work and speed expectations were being met*Monitored code quality through strict change management policy and peer accountability via code reviews*Grew talent by offering challenging work, holding high code and documentation standards*Provided coaching, mentorship and performance management to team members.*Built talent through weekly 1-on-1s, pushing team to grow new skills, annual performance tracking and review process

Duties involve BI and data engineering or solutions architecture for various consulting engagements. Heavy use of Power BI and SQL Server, and AWSData Engineering:*Acted as lead developer for new data warehouse accounting for 1500 employees’ data.*Troubleshooted data issues in advanced ETL and Azure Data Factory (ADF) pipelines and quickly modified logic to meet requirements.*Created ETL in AWS Glue with scheduled jobs using PySpark, S3, EMR.*Validate Data Science model results for accuracy to meet client expectations.*Dealt highly ambiguous business problems and delivered tangible ETL logic.*Created data pipelines in C#/SSIS for various data sources: csv files, APIs, Azure Blob storage, and Cosmos.*Optimized SQL stored procedures to run faster and more efficiently under strong client pressure.*Provided immediate first level triage of ETL processing failures under strict Service Level Agreements.*Traced data lineage through inherited 3rd party BI infrastructure with little to no documentation.*Administered production databases by maintaining backup data and expanding drive space when needed. Solutions Architecture:*Created CloudFormation templates to automate AWS Budget alerts in Slack, and enforce tagging through AWS Config.*Conducted AWS Well-Architected Reviews and subsequent areas of remediation.

Responsibilities included global report development for Senior Executives, data quality assurance, web prototyping, and data modeling. Performed business analysis, systems analysis, and data analysis to drive new feature development.Report Development* Develop and maintain a suite of reports to support the Global Air Product Development group and Senior Executives.* Implement reporting standards used for submission to the Security and Exchange Commission.* Train report developers on correct data usage and interpretation. Vet peer reports for accuracy and integrity.* Consult branches worldwide in report development and best practices.* Reverse engineer heavy SQL queries for optimal speed (DB2) in our reporting environment.* Dimensional modeling of complex logistics entities to be suitable for reporting.Product Development* Drive new systems features to improve data collection in our proprietary Export system.* Build web application prototypes to rapidly discover business requirements.* Consult other product groups on reporting best practices.* Collaborate with data science team to drive predictive analytics* Leverage 3rd party SOAP/REST APIs, such as Google Maps Engine, to rapidly geocode customer locations.* Map company territories into geospatial data using Quantum GIS, for use in geospatial analysis and app development.Data Quality* Worked with ETL team to fix deep-rooted data problems* Drove source system features that ensure data cleanliness.ETL Development: * Used ETL tools to transform disparate data sources into meaningfully housed data from flat files, web services, web scraping, and databases.

• Gathered business requirements and tested each user scenario• Heavily documented bugs and steps to recreate them in central reporting database• Challenged assumptions about the user experience to drive quality system development• Streamlined data collection processes using Microsoft Access, Microsoft Visual Basic UI’s, and Microsoft Excel• Monthly monitoring of system metrics through Excel reporting and iNetsoft, built on SQL query results from a production database• Automated enterprise reporting processes through the use of using DB2 SQL queries and VB scripts on a DB2 database platform• Translated business requirements into QA test cases through daily Scrum and test plan review sessions• Documented deliverables and progress within an enterprise level SDLC framework, and delivered QA work products on time and as requested• Ensured quality global applications within Agile and Waterfall development methodologies.• Coordinated testing efforts across departments and disciplines

I managed a book of aviation insurance clients who purchase insurance for their aircraft on an annual basis, both private and commercial. Acted as sales support and trainee for lead producers and senior account managers.

I managed a book of commercial insurance agencies, who’s clients need financing for their insurance policies.