Stephen Hanson Hackman
Edmonds,WA
Summary
Qualified Business Intelligence Engineer with over 10 years of IT experience in cloud computing, solving business problems using SQL, Python and other programming languages and writing business analytical documents for business action. Organized and dependable candidate successful at managing multiple priorities with a positive attitude; and leading and developing team members. Willingness to take on added responsibilities to meet team goals.
Overview
15
15
years of professional experience
1
1
Certification
Work History
BI Engineer II
Amazon Web Services
09.2021 - Current
- Principal BI engineer for the AWS Outposts and Servers product, providing business reporting and analytics for 10 product managers and the Outposts org
- Developed an internal tool that automatically splits revenue for AWS outposts racks into the component service revenue
- This tool eliminated about 3 hours of manual calculations carried out by Outposts Finance managers to correctly report on the service component’s revenue presented to Edge computing VP
- The tool employed AWS lambda, AWS glue, AWS S3 and Redshift in its design using python and SQL
- Architected and optimized Outposts data model using RedShift, AWS Glue, and CI/CD tool; reduced ETL runtime by 83% (100 minutes) daily
- Equipped product managers with SQL skills through interactive training sessions, enabling them to independently access and analyze data for ad-hoc needs; reduced dependency on BI engineers leading to about 3 hours daily time savings for BI engineers to focus on high impacting projects
- Architected Redshift RA3 data share for backfilling of five (5) years’ worth (3PB) of revenue and usage data
- Writing analytical papers on the Outposts business to unravel usage patterns that predict retention or attrition
- Design of Operational dashboards for the Amazon EC2 BI organization using Quicksight that enabled the leadership to quickly answer operational questions
- Dashboards provides metrics such a Redshift cluster runtime, ETL efficiency, long running queries etc
- Overall dashboards provide about 50 minutes of time saving for leadership weekly business reviews
- Cloud automations using AWS Lambda, S3 and Cloud Formation stacks
- Hosting Kanban sprint prioritization meetings for work tracking
- Projects: OMAT SKU Revenue Disaggregation, Stale Data Identification Tool, Outposts Ordering System Data Model design, Outposts Inventory Data Model design, Edge Computing impact on AWS regions analytical paper.
SQL/ETL Developer
DaVita Inc.
09.2016 - 09.2021
- Create complex TSQL stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart
- Created and modify indexes to optimize the performance of stored procedures which support report executions leading to 2 hours reduction in the overall time ETL and reports run
- Monitor SQL server performance with SQL profiler, database engine tuning advisor, and command line utilities
- Design and implementation T-SQL logic with joins, sub-queries, CTEs, and ranking/analytical functions to fetch data from a multitude of data sources to load the data mart
- Encapsulation frequently executed SQL statements into stored procedures to reduce the query execution times
- Improve the performance of SQL scripts within stored procedures by evaluating execution plans, creating indexes/table partitions, and utilizing tools such as SQL profiler and database tuning advisor
- Implement data profiling, cleansing and conversion tasks to consolidate data formats
- Configure packages with parameters to acquire values at runtime; deployed packages to the production server
- Design Microsoft Access forms with complex business logic using VBA scripting
- Create analytical dashboards depicting critical KPIs using Tableau
- Develop ServiceNow reports and performance Analytics
- Publish Tableau dashboards to Tableau Server
- Use of IT infrastructure library for scrum releases
- Project: Helix Data warehouse migration, Connect Chat Data model and reporting, ETL task dependency detection automation.
Intelligent Network Engineer, Supervisor
Millicom (Ghana) Ltd
06.2009 - 06.2014
- Managed a team of six(6) network engineers for the design and deployment of the TiGo Cash money transfer platform
- Managed end-to-end design and deployment of network operational dashboards using Tableau for senior management
- Installation of oracle 11g database on RedHat and Centos Linux server
- Creating tables, views, joins, users, triggers, stored procedures, indexes on oracle 11g database
- Provided Oracle 11g administration services including performing full and incremental backups using RMAN, optimizing memory pools, granting and revoke user access to Oracle 11g services
- Created Oracle 11g server reports
- Creation of Linux bash scripts to search files and generate specific outputs using awk, grep and sed, together with Linux regular expressions
- Creation of Linux bash scripts for monitoring and analyzing the number of product subscriptions per hour for each customer sector
- Managing Linux server storage using the Linux Volume Manager (LVM)
- Configuring iptables and SSH connections on Linux servers
- Designed, coded, tested, and debugged SQL queries in SSMS and SSRS
- Projects: TiGo Cash Mobile Money Transfer project.
Education
Master of Science Data Science and Business Analytics -
University of North Carolina At Charlotte
Charlotte, NC12.2020
Master of Science in Information Telecommunication Systems -
Ohio University
Athens, OH02.2016
Bachelor of Science Electrical and Electronic Engineering -
Kwame Nkrumah University of Science and Technology
05.2008
Skills
- Amazon RedShift
- Postgre SQL
- MS SQL
- MySQL
- Python
- Linux shell Scripting
- AWS QuickSight
- AWS Glue
- AWS CloudFormation
- Tableau
- Power BI
- MS Excel
- DataGrip
- VS Code
- SSMS
- BIDS
- SSDT
- Git
- Team Foundation Server (TFS)
Certification
- AWS C02 Solutions Architect
- Oracle 11g Administrator Certification
Timeline
BI Engineer II
Amazon Web Services
09.2021 - Current
SQL/ETL Developer
DaVita Inc.
09.2016 - 09.2021
Intelligent Network Engineer, Supervisor
Millicom (Ghana) Ltd
06.2009 - 06.2014
Master of Science Data Science and Business Analytics -
University of North Carolina At Charlotte
Master of Science in Information Telecommunication Systems -
Ohio University
Bachelor of Science Electrical and Electronic Engineering -
Kwame Nkrumah University of Science and Technology
Similar Profiles
Francisco Javier Chavero, Jr.Francisco Javier Chavero, Jr.
Environmental Program Manager (EPM) at Amazon Web Services (AWS), Amazon Data Services, Inc.Environmental Program Manager (EPM) at Amazon Web Services (AWS), Amazon Data Services, Inc.
Manish KulshreshthaManish Kulshreshtha
Head - Enterprise Support (Mid and Large Enterprise Business) at Amazon Web Services (Amazon Internet Services Pvt. Ltd.)Head - Enterprise Support (Mid and Large Enterprise Business) at Amazon Web Services (Amazon Internet Services Pvt. Ltd.)
Joe BehrensJoe Behrens
Senior DevOps Consultant at Amazon Web Services (AWS) Professional ServicesSenior DevOps Consultant at Amazon Web Services (AWS) Professional Services
DEEPA KARUNAKARANDEEPA KARUNAKARAN
Customer Solutions Manager (Customer facing Program Manager) at Amazon Inc. (Strategic Accounts, Amazon Web Services)Customer Solutions Manager (Customer facing Program Manager) at Amazon Inc. (Strategic Accounts, Amazon Web Services)
Caitlyn (Justine) VoylesCaitlyn (Justine) Voyles
Certified Ophthalmic Assistant at Swedberg Eye CareCertified Ophthalmic Assistant at Swedberg Eye Care