Andy Agus Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

Leads the data function for Amazon Worldwide Real Estate comprised of data science, business intelligence and data engineering.Build end to end data solutions for the organization supporting OLTP and OLAP use cases - data infrastructure, reporting including dashboarding, science models including LLM and AI, analytics, data provider for data setsWorks cross functionally with product, tech and program to develop tech and data products.Lead data engineering strategy, science strategy and metrics/reporting strategyTechnologies used: AWS - Sagemaker, S3, Redshift, Glue, Athena, Lambda, Spectrum, Lakehouse, SNS, SQS, QuicksightTableauArcGIS - Geospatial Data

Seattle, Wa, Us

Executive reporting, science, analytics and data engineering for the AWS Sales & Marketing organization• Manage and hired 14+ business intelligence engineers, data engineers and managers forming 3 teams (Automation/Data Engineering, Analytics/Data Science and Reporting).• Own reporting, data engineering, science and analytics for weekly and monthly business reviews for the entire AWS Sales and Marketing organization (66.5k people) for an executive audience (sales directors and vice presidents), the head of sales of AWS (Matt Garman) and AWS CEO (Adam Selipsky). • Developed analytics and data science models addressing executive requests used to make business decisions across the entire AWS Sales organization• Lead and influence the AWS Sales organization’s data strategy. Develop and set reporting standards and defining metrics for the entire AWS Sales organization. Team serves as the source of truth and authoritative source for metrics and reporting across AWS Sales.• Create and maintain core data sets leveraging AWS solutions (Redshift, Glue, Lake Formation) to be leveraged in reporting, analytics and data science for the entire AWS Sales organization• Centralized and migrated the manual production of a 120+ page business review deck from 15+ business teams to my team. Developed a fully automated reporting and engineering solution leveraging Excel, Python, Airflow and Quicksight in 6 months which resulted in the automation of~3 full time HC per year (operational excellence) and the team received the AWS Q2 CFO Award for the solution.• Scaled automated Excel and Quicksight reporting (30+ page business review deck) for 25+ teams across AWS Sales and Marketing in 1 month with optimal reporting and engineering design.Amazon Bar Raiser

Seattle, Wa, Us

Executive reporting, science, analytics and data engineering for the AWS Sales & Marketing organization• Manage and hired 14+ business intelligence engineers and managers forming 3 teams (Automation/Data Engineering, Analytics/Data Science and Reporting).• Own reporting, data engineering, science and analytics for weekly and monthly business reviews for the entire AWS Sales and Marketing organization (66.5k people) for an executive audience (sales directors and vice presidents), the head of sales of AWS (Matt Garman) and AWS CEO (Adam Selipsky). • Developed analytics and data science models addressing executive requests used to make business decisions across the entire AWS Sales organization• Lead and influence the AWS Sales organization’s data strategy. Develop and set reporting standards and defining metrics for the entire AWS Sales organization. Team serves as the source of truth and authoritative source for metrics and reporting across AWS Sales.• Create and maintain core data sets leveraging AWS solutions (Redshift, Glue, Lake Formation) to be leveraged in reporting, analytics and data science for the entire AWS Sales organization• Centralized and migrated the manual production of a 120+ page business review deck from 15+ business teams to my team. Developed a fully automated reporting and engineering solution leveraging Excel, Python, Airflow and Quicksight in 6 months which resulted in the automation of~3 full time HC per year (operational excellence) and the team received the AWS Q2 CFO Award for the solution.• Scaled automated Excel and Quicksight reporting (30+ page business review deck) for 25+ teams across AWS Sales and Marketing in 1 month with optimal reporting and engineering design.Amazon Bar Raiser

Seattle, Wa, Us

Product Econ and BI Division of Alexa Shopping addressing Customer Activity/Engagement and AdvertisingMission: Build an end to end (data infrastructure/architecture, modeling, reporting) automated scalable self-service customer insights analytics product.Role responsibilities:- Built and managed a team of 9, composed of Business Analysts, Business Intelligence Engineers and Data Engineers.- Recruit, interview and hire Business Intelligence Engineers, Data Engineers, Business Analysts and other data job families (data scientists, research scientists, etc). Know how to assess data job family bar.- Consult, develop and implement data architecture/infrastructure solutions to enable modeling and analytics.- Create novel metrics and reporting using ambiguous unstructured AI data. - Work with Software developers and Product Managers to develop software signals that enable decision making.- Consult, develop, launch and maintain data pipelines, data feeds and data tables via Redshift and other internal Amazon tools.- Consult, develop reporting and dashboards around customer engagement with Alexa Shopping using SQL, Excel and BI tooling.- Perform business analytics and develop key business insights using Alexa, Finance and Amazon data.Technologies used: S3, Glue, Athena, EMR Clusters, Redshift, Looker, SQL Workbench, Amazon in-house ETL Tools, Excel, QuicksightLanguages used: SQL (PL/SQL, PostgreSQL), XML, Python, Scala

Seattle, Wa, Us

Customer Engagement/Activity Division of Alexa ShoppingRole responsibilities:- Manage a team of 3 Business Intelligence Engineers while doing individual BIE work.- Develop and implement data architecture/infrastructure solutions to enable modeling and analytics.- Develop, launch and maintain data pipelines, data feeds and data tables via Redshift and other internal Amazon tools.- Develop reporting and dashboards around customer engagement with Alexa Shopping using SQL, Excel and Looker.- Perform business analytics and develop key business insights using Alexa and amazon.com data.- Manage a team of 3 composed of Business Intelligence Engineers and Business AnalystsTechnologies used: S3, Glue, Athena, EMR Clusters, Redshift, Looker, SQL Workbench, Amazon in-house ETL Tools, ExcelLanguages used: SQL (PL/SQL, PostgreSQL), XML, Python, Scala

Seattle, Wa, Us

Customer Engagement/Activity Division of Alexa ShoppingRole responsibilities:- Develop and implement data architecture/infrastructure solutions to enable modeling and analytics.- Develop, launch and maintain data pipelines, data feeds and data tables via Redshift and other internal Amazon tools.- Develop reporting and dashboards around customer engagement with Alexa Shopping using SQL, Excel and Looker.- Perform business analytics and develop key business insights using Alexa and amazon.com data.Technologies used: S3, Glue, Athena, EMR Clusters, Redshift, Looker, SQL Workbench, Amazon in-house ETL Tools, ExcelLanguages used: SQL (PL/SQL, PostgreSQL), XML, Python, Scala

Seattle, Wa, Us

Under the Central Operations Organization. Program Ownership - Store Performance Role responsibilities:- Created, implemented and managed the Store Performance Program under Physical Bookstore that is responsible for maintaining a healthy data infrastructure, creating metrics to track new processes, consulting and solving analytical/reporting problems as well as developing/automating dashboards and reporting used by store associates and corporate.- Act as a consultant and project manager to assist business groups in acquiring new data, automating reporting and developing business insights/new metrics.- Use SQL + Redshift to gather and analyze finance, marketing, labor, inventory/supply chain and operations data to develop business insights into the Bookstore business to drive sales, traffic and operational efficiencies.- Develop and automate dashboards in Amazon Quicksight (BI tool) or Excel leveraging data sets built through SQL + Redshift to provide business insights (sales, traffic, etc.) and actionable intelligence to associates and corporate. - Create and implement actionable business metrics/reporting to measure the success of newly implemented operational processes and provide actionable intelligence.- Translate business requirements to technical requirements from key business stakeholders to data engineering and research science teams. This includes working with third party teams and data engineering to come up with best data pipeline solutions and automating data feeds for model consumption.Technologies used: Redshift, Oracle, SQL Workbench, Amazon in-house ETL Tools, Excel, QuicksightLanguages used: SQL (PL/SQL, PostgreSQL)

Seattle, Wa, Us

Amazon Fashion - Shoes, Handbags, Luggage and Accessories- Led and drove a two person team of business analysts in the shoes, handbags, luggage and accessories business group at Amazon Fashion.- Solved complex data analysis questions in regards to vendor management, inventory management, finance, SEO, sales and demand forecasting using e-commerce data from Amazon.com.- Developed automated reporting solutions and metrics leveraging SQL (Oracle + Redshift), Amazon in-house ETL tools and Excel for business groups to use to manage the health of their vendor sales, assist in vendor negotiations, optimize their buying/online marketing strategy (including SEO) and manage third party sales.- Lead, developed and implemented an Oracle to Redshift migration for all of Amazon Fashion which included gathering technical requirements, helping create a centralized BI team, writing and presenting a migration document, managing/executing the migration and communicating the status of the migration.- Held trainings and classes to teach SQL and analytical techniques to employees to improve SQL skill set, increase the speed and efficiency of queries and improve their analytical capabilities. Technologies used: Redshift, Oracle, SQL Workbench, Amazon in-house ETL Tools, ExcelLanguages used: SQL (PL/SQL, PostgreSQL)

Tutor students from elementary through college in Math, Statistics, Physics, Chemistry, English, and Biology.Gained clients through recommendations and personal advertisement. Tutored algebra, geometry, trigonometry, AP calculus, AP Statistics, AP Physics, AP Chemistry, AP English, AP Biology, Calculus 1-3 (College Level), Chemistry (College Level), Physics (College Level), SAT Math

Arlington, Va, Us

Working in Boeing Commercial Airplane (BCA) materials services demand analytics, business intelligence, and strategy division. Job responsibilities:- Synthesize intelligence from aftermarket participants and internal Boeing sources into defined database architecture. - Produce quick useable results, with a plan for ongoing iteration to refine data and improve materials forecasts. - Performed a SQL Server database migration to Teradata involving millions of records of data, which included converting and re-coding stored procedures and functions from SQL server to Teradata. - Develop and maintain front end applications for Access in VBA for the business to be able to leverage and easily access material data.- Use parts requirements planning to provide practical, relevant insight to the material services business to improve internal understanding of part level market demand and competitive shifts to optimize spare part pricing and inventory levels. Visualization was done primarily in Tableau (stories/dashboards).- Leverage relationships with external customers, competitors and suppliers to improve quality of external data sources. - Perform business analytics and serve as a center of excellence for trusted data integrity and analysis needs. - Provide a business prospective to ETL Developers, Data Architects and support teams to enhance business intelligence datamarts and tools. Knowledge applied in position: relational databases, data mart concepts, SQL query language, business problem identification, data collection and preparation, and using Business Intelligence software and analytical tools.Software used: SQL Server, Excel, Alteryx, Access, Teradata and TableauLanguages used: SQL, T-SQL, VBA

Arlington, Va, Us

Compliance – Gather, construct, and quality check compliance of security deliverables (most updated database/sever patches, server blockpoints, user access validation, access control policies, CIA Ratings etc.) for over 100 computer applications, servers, and databases across IT business partners to reduce potential cyber security threats and information leaks. Generate a metrics report on compliance of these items using Excel and PowerPoint which is then presented to the Vice President and 5 directors of business partners.Security – Run application security vulnerability scans (static and dynamic) using AppScan and Veracode on computer applications to check for potential security flaws across IT business partners to ensure that applications will be able to defend against cyber attacks. Explain and suggest ways of fixing code to prevent security threats such as SQL injection, cross site scripting, buffer overflow, stack overflow, etc. to an application. Application Development Lifecycles – Understanding the application development process (waterfall and agile) and conducting random audits on applications to check for compliance with these processes.Productivity Metrics - Maintained and collected computer productivity metrics for Commercial Aviation Systems that allowed visibility of current status on stories, bugs, and fixes to leadership teams to allow them to make business decisions.

Seattle, Wa, Us

Assist an Information Systems Professor in grading, holding sections to answer student questions, and teaching two lab classes for an introductory Information Systems course for University of Washington undergrads.Taught Excel, Microsoft Project, Microsoft Visio, Access Database, and HTML to two 40 student information systems lab sections.

Reston, Va, Us

Worked on projects for electric utilities across the country, gaining valuable insight related to consultant-to-client interaction, relationship building, and project management.Worked on a variety of consulting projects for electric utility clients and assisted in procurement of new business. Conducted analysis for cost of service and rate design studies, equity and asset management plans, depreciation studies, engineering and billing spreadsheets, and misc. research for client projects. Helped prepare client presentations.

Bellevue, Wa, Us

Master'S Degree, Information Systems

Bachelor'S Degree, Mathematics

Master’S Degree, Computer Science