Adrian Anders
IT Application Development Engineer III at Amazon
IT Application Development Engineer III at Amazon
Business Intelligence Developer specializing in data visualization, dashboard development, and reporting with a wide variety of popular platforms. 

Certifications:
Bellevue College Certified Business Intelligence Developer
Microstrategy Certified Associate Analyst
Trained in:
SQL Server, Microstrategy, Tableau, R, Crystal Reports, and Business Objects
Amazon
https://www.linkedin.com/company/amazon
- Team senior in the AWS HR Tech Organization.
- Worked with other senior staff to refine existing web application built by myself.
- Migrated web applications to a to a React-based UI with Redux state.
- Leads management of security and infrastructure deployment.
Seattle, Washington, United States
https://media-exp1.licdn.com/dms/image/C560BAQHTvZwCx4p2Qg/company-logo_100_100/0/1612205615891?e=1655942400&v=beta&t=AVKhS-aqZ8h_yaf-McQWAc1jIlHiawZrjoadhfnNFOM
IT Application Development Engineer III
Amazon
https://www.linkedin.com/company/amazon
- Developed Spring MVC web application for AWS HR.
- Full-stack development of backend + frontend components. 
   - AWS MySQL Aurora Database
   - AWS Lambda
   - AWS Kinesis Firehose
   - Bootstrap UI
   - D3 Visualizations
Greater Seattle Area
https://media-exp1.licdn.com/dms/image/C560BAQHTvZwCx4p2Qg/company-logo_100_100/0/1612205615891?e=1655942400&v=beta&t=AVKhS-aqZ8h_yaf-McQWAc1jIlHiawZrjoadhfnNFOM
IT Application Development Engineer II
Amazon
https://www.linkedin.com/company/amazon
- Developed a comprehensive productivity scorecard product for over 500 individuals in AWS Talent Acquisition.
- Created multiple dashboards related to individual and organizational productivity.
- Administered a distributed MicroStrategy business intelligence environment on AWS with several hundred users.
- Administered and developed pages for AWS HRBI website.
- Developed customized SQL reporting logic.
- Developed scripting tools in Python to automate common MicroStrategy tasks such as post-deployment code validation.
- Authored internal papers on measurement logic to argue for specific business logic.
Greater Seattle Area
https://media-exp1.licdn.com/dms/image/C560BAQHTvZwCx4p2Qg/company-logo_100_100/0/1612205615891?e=1655942400&v=beta&t=AVKhS-aqZ8h_yaf-McQWAc1jIlHiawZrjoadhfnNFOM
IT Application Analyst
Napster
https://www.linkedin.com/company/napster-deprecated
- Administered on-premise MicroStrategy application for over 200 regular daily users.
- Developed new MicroStrategy reports and schema objects.
- Scheduled report bursting in MicroStrategy NarrowCast Server with Pre/Post SQL triggering based on ETL status conditions.
- Enhanced and optimized existing reports to increase performance and reduce resource usage.
Developed new Teradata ETL processes, views, materialized views, and MicroStrategy Logical views to enhance existing dimensional reporting capabilities.
- Created new Teradata Parallel Transporter scripts for data extract reports and shell scripts for external file transfers.
- Provided input into dimensional modeling of playlist data from the perspective of MicroStrategy reporting.
- Optimized and created new FreeForm Impala queries used in MicroStrategy reporting.
- Provided assistance in migrating MicroStrategy from 9 to 10.4.
Greater Seattle Area
https://media-exp1.licdn.com/dms/image/C560BAQFTY7DQD6k8dg/company-logo_100_100/0/1519856217987?e=1655942400&v=beta&t=wGc0IuAEGZyBs8QAFB4gmg8eQZ25-E2H_F8RKPfXb9U
BI Developer
QuintilesIMS
https://www.linkedin.com/company/iqvia
- Developed customized BI reporting solutions on AWS EC2 servers.
- Implemented Dashboards connected to large datasets of billions of rows.
- Customized Environment with company branding using Microstrategy SDK.
- Developed customized visualizations and widgets to enhance dashboard capabilities.
- Generated large partitioned cubes with over 32GB of data each.
- Administered Windows and Linux servers using AWS EC2, RDS, and Data Pipelines 
- Developed scripts to generate, manage, backup, and monitor environments.
- Generated custom SQL to generate custom tables and views for star-schema Redshift clusters.
Greater Seattle Area
https://media-exp1.licdn.com/dms/image/C4D0BAQEiOifAvjV9vw/company-logo_100_100/0/1619640262440?e=1655942400&v=beta&t=VIHv8yCyTj-64utWmdCm4fZrXCbbFhUGrr0HNAI4uic
Software Engineer - Microstrategy Developer
UnitedHealth Group
https://www.linkedin.com/company/unitedhealth-group
•	The only dedicated local reporting and analytical resource for the first year and six months of United Healthcare Medicaid Community Plan in Washington state.
•	Refined existing static reports using Excel macro automation to customize them according to external provider specifications. This drove improvements in HEDIS outcomes in 2013.
•	Wrote a SQL-based parser and eligibility analyzer for EDI 834 benefit enrollment and maintenance files.
•	Developed in conjunction with health plan CMO a suite of affordability reports to identify and engage high-risk members.
•	Coordinated the development of several contractually required reports. Performed extensive audits and analysis to validate data quality and specification parameters.
•	Built dashboard representations of key clinical metrics for management presentations.
•	Managed the development, quality review, and visual representation of clinical performance reporting for the contractually required annual state audits.
•	Collaborated with regional and national Business Intelligence to develop additional reporting capabilities, as well as adjust existing reports to the specific requirements of the Washington Community Plan.
•	Developed ad-hoc SQL and Microstrategy queries out of a data warehouse with turnarounds as short as same day depending on complexity and priority level.
•	Performed flexible technical related tasks and support to staff due to severe initial budget and manpower constraints.
•	Analyzed and combined data from separate data sources and formats for time sensitive initiatives.
•	Developed, documented, tested, and implemented processes for certain reporting requirements that could not be fully automated.
•	Became proficient in the data structure of several industry standard claims and clinical data systems including CSP Facets (claims platform), CareOne (case management platform), Optum InSite (HEDIS measurement platform), and Impact Pro (risk management platform).
Seattle, WA
https://media-exp1.licdn.com/dms/image/C4D0BAQHFsVkm-0t4fA/company-logo_100_100/0/1643414338931?e=1655942400&v=beta&t=WnLGqZbq1ibMjVLxW_bLVSWXPZCJ3bHB-X3BNh4zFxk
Senior Clinical Analyst
Windsor Health Group
•	Co-ordinated workflow and trained individuals on data entry for yearly network filing with Center for Medicare & Medicaid Services (CMS).
•	Developed mass update and insert queries for temporary filing staging tables using source data from excel spreadsheets, .csv files, Salesforce.com-based credentialing data warehouse, claim data systems, and Oracle-based legacy credentialing database data.
•	Generated detailed provider reports for project management.
•	Used geocoding data to narrowly identify providers to fill contracting coverage gaps.
•	Ran existing analytics reports for Quality Assurance.
•	Developed new reporting from the Verisk Analytics HEDIS system tables using SQL SELECT queries.
•	Combined data queried from various claim systems with the data generated from Verisk to audit its data quality. In addition, produced reporting information that overcame the limitations of the Verisk system in regards to look-back timeframe and provider data.
Bellingham, Washington Area
Project Team Analyst
Sterling Health Plans
https://www.linkedin.com/company/sterling-insurance-a-windsor-health-group-company
•	Identified existing issues in provider files and generated operations workflow from self-generated reporting.
•	Created a split-database MS-Access workflow time-tracker for analysts to accurately report the time spent on workflow issues, generating highly detailed reporting for leadership. Extensive and advanced VBA scripting was used to achieve desired functionality.
•	Built several advanced select data queries written in Microsoft SQL utilizing unions, sub-queries, and other functionality not present in the company’s legacy Crystal Reports 7. 
•	Took lead in the claims department's testing of the new SAP BusinessObjects based data warehouse project. Identified issues with missing and incorrect claim fields as well as selection criteria. 
•	Designed and executed the provider data extraction and conversion methodology from the previous claims system into a new system-compatible format. Microsoft SQL was used to extract the raw data based on specific criteria. Data was processed in Microsoft Access for export.
Bellingham, Washington Area
https://media-exp1.licdn.com/dms/image/C510BAQFvOXRb8TUq1Q/company-logo_100_100/0/1519929444568?e=1655942400&v=beta&t=8zHeHzK0Kpzf_Obk_dtZLm_0D-2Wqxu8eDvGJhUaYb4
Senior Claims Analyst
KUGS 89.3 FM
On-Air DJ
Bachelor of Arts
Dean's List
Political Science/Philosophy/Economics
https://media-exp1.licdn.com/dms/image/C560BAQEnzkInnHps4A/company-logo_100_100/0/1610759616551?e=1655942400&v=beta&t=BbX3_lamwPIkkE2Rf4-NtGc7GzXXBsuB4jWXuxQb0Zs
Western Washington University
https://www.linkedin.com/school/western-washington-university/
Certificate of Achievement
Business Intelligence Developer
https://media-exp1.licdn.com/dms/image/C4E0BAQGb_pYLRdOHtw/company-logo_100_100/0/1519856034380?e=1655942400&v=beta&t=0aM4Gr4ls-arDWgaxNvWu1gpxzW9wl-0j-T2kLe8O4A
Bellevue College
https://www.linkedin.com/school/bellevue-college/
MicroStrategy
Microstrategy 10 Certified Associate Analyst
Bellevue College
B561
Certificate of Achievement: Business Intelligence Developer With High Distinction
https://www.linkedin.com/in/bingrouzhou
Seattle, WA
Alice Z.
Sr. Machine Learning Scientist at Amazon Web Services (AWS)
https://www.linkedin.com/in/swthompson01
Seattle, WA
Scott Thompson
Principal Workforce Strategist at Amazon Web Services
https://www.linkedin.com/in/john-sampson-ab434240
Greater Seattle Area
John Sampson
Senior Director of People Analytics at DoorDash
https://www.linkedin.com/in/dirkantonczyk
Seattle, WA
Dirk Antonczyk
Senior Manager, Economist, Amazon Ads
https://www.linkedin.com/in/christopher-johnson-9706323
Seattle, WA
Christopher Johnson
Semi Retired at Self Employed
https://www.linkedin.com/in/michael-broughton-ii-bb2275196
Greater Philadelphia
Michael Broughton II
1L at Drexel University Thomas R. Kline School of Law
https://www.linkedin.com/in/roy-sutton-289b7527
Ohio, United States
Roy Sutton
Sr. Quality Assurance Engineer at Thirty-One Gifts
https://www.linkedin.com/in/sunitajayagaran
Greater Seattle Area
Sunita Jayagaran
Senior QA Engineer/SDET
https://www.linkedin.com/in/ruby-johnson-msc-9676b4166
Atlanta Metropolitan Area
Ruby Johnson, MSC
Data Warehouse & Analytics Consultant at DXC Technology/Kansas Department of Health and Environment
https://www.linkedin.com/in/thomas-shore-qa
Greater Seattle Area
Thomas Shore
Quality Assurance Analyst 3 at Costco Wholesale
https://www.linkedin.com/in/albertyakhnin
Brooklyn, NY
Albert Yakhnin
Sr. ETL Automation Engineer at Mindtree
https://www.linkedin.com/in/sujan-s-418534b3
Glendale Heights, IL
Sujan S.
Quality Assurance Advisor at CVS Health
https://www.linkedin.com/in/vsharma0728
United States
Vishal Sharma
Experienced Software Development Engineer in Test (SDET)
https://www.linkedin.com/in/bmclarenstanley
Seattle, WA
B. McLaren Stanley
Principal Engineer at Amazon
https://www.linkedin.com/in/soujanyakola
Greater Boston
Soujanya K.
IT App Analyst at Amazon Robotics
https://www.linkedin.com/in/marbsmananghaya
New York, NY
Marvin Mananghaya
Software Engineer - Data & Machine Learning Infrastructure
https://www.linkedin.com/in/ravi-srivastava
Seattle, WA
Ravi Kumar Srivastava
7 Years of Data Analytics - Chat Bot / NLU / Fleet Management / Logistics/ Retail / Financial Services
https://www.linkedin.com/in/chent
Greater Seattle Area
Chen Tong
SDE at Amazon
https://www.linkedin.com/in/noufal85
Greater Seattle Area
Noufal E.
Senior Data Engineer at Oracle
Andrew Haakenson
      
          



            
              
        
              
  

    
        Adrian initially impressed me with his powerful analytical ability and thoroughness as a Provider Relations Analyst.  When a Senior Analyst position opened up on my team, he'd demonstrated his fitness for the position with his exceptional attention to detail.  In the 4 years he's worked for me, Adrian has consistently shown professionally progressive growth in his technical and analytical ability.  He researched, developed and implemented technical solutions that delivered substantial value to my team.  I can highly recommend Adrian for any position that gives him the leeway to deploy his problem-solving abilities to their fullest.
Shared by Adrian Anders
https://www.linkedin.com/signup/cold-join
Exciting opportunity in Workforce Planning!  https://lnkd.in/e8J3DwT
Liked by Adrian Anders
https://www.linkedin.com/signup/cold-join
Exciting opportunity in Workforce Planning!  https://lnkd.in/e8J3DwT
https://se.linkedin.com/in/adrianc-a
Stockholm
Adrian Chmielewski-Anders
ML Ops Engineer at King
https://uk.linkedin.com/in/adrian-anders-38811048
London
adrian anders
profesor at chestershire
https://pa.linkedin.com/in/adrian-anders-78699a19
Panama
Adrian Anders
Owner, Cerveceria Boca Chica, S.A.
https://pl.linkedin.com/in/adrian-anders-041264100
Koszalin
Adrian Anders
Kontroler jakości w Globmetal
Excel Developers
https://media-exp1.licdn.com/dms/image/C5607AQHqYftlHQxX4w/group-logo_image-shrink_200x200/0/1631418838222?e=1647694800&v=beta&t=f0w8mCyQW-oE-wrI-QAS7H0K6UsBUipsFWFKpygmD3k
https://www.linkedin.com/groups/58704
The R Project for Statistical Computing
https://media-exp1.licdn.com/dms/image/C5607AQHUcEWCbwI8RA/group-logo_image-shrink_92x92/0/1630997017542?e=1647694800&v=beta&t=A5EM4TQTkD7IBjX8bjwD-bMFHQm7mQE1qpdum2mnIIE
https://www.linkedin.com/groups/77616
Microsoft Excel Users
https://media-exp1.licdn.com/dms/image/C5607AQHx55vmtEYv7A/group-logo_image-shrink_200x200/0/1631434518179?e=1647694800&v=beta&t=MNTmZU-41ZMXF32pI-VEiSIH83TCz0l8_j7t4O_Sz9M
https://www.linkedin.com/groups/44008
Microsoft Access Gurus
https://media-exp1.licdn.com/dms/image/C4E07AQG3e8OWdKl3eg/group-logo_image-shrink_200x200/0/1631362125126?e=1647694800&v=beta&t=V-6FyFxx6g-z3Zag4ZU3VVcBGJkvhrxYit4Q8GUt-Vc
https://www.linkedin.com/groups/1770866
Microsoft Developers
https://media-exp1.licdn.com/dms/image/C4D07AQE2KYf-lqMkuw/group-logo_image-shrink_200x200/0/1631371325982?e=1647694800&v=beta&t=Hf29VYeyImTOP7PIvCjSyQ2b7WIImeDyB1z61tCL1tQ
https://www.linkedin.com/groups/136510
R Programming
https://media-exp1.licdn.com/dms/image/C4D07AQEDB1lQQzpotw/group-logo_image-shrink_200x200/0/1631365768099?e=1647694800&v=beta&t=kXNJk8j3afpISYqc4BQ2xGHDm6ah4cdXaSe0rsRf2yk
https://www.linkedin.com/groups/2229532
Western Washington University Alumni
https://media-exp1.licdn.com/dms/image/C5607AQHC6ddKtCe61w/group-logo_image-shrink_92x92/0/1640020923457?e=1647694800&v=beta&t=-qZKDWfCB8G9x3cwZ5rVVdBkiHvVXc1WWcypjnHV-zA
https://www.linkedin.com/groups/3423
Western Washington University College of Business & Economics Alumni
https://media-exp1.licdn.com/dms/image/C4E07AQH7O1V95ZKCTw/group-logo_image-shrink_200x200/0/1631381061616?e=1647694800&v=beta&t=o0qka0-XYD1EDV5U5V5QZYdjp31ErrVZora3iAucSRM
https://www.linkedin.com/groups/90014