Andrew T Balcom Email and Phone Number
Andrew T Balcom's Location
Portland, Oregon Metropolitan Area, United States, United States
Andrew T Balcom's Contact Details
Andrew T Balcom work email
- Valid
- Valid
- Valid
Andrew T Balcom personal email
n/a
Andrew T Balcom phone numbers
About Andrew T Balcom
As a Sr Business Intelligence Developer at AuditBoard, Andrew leverages his 15 years of experience in software development and data analytics to deliver actionable insights to customers and stakeholders. He holds certifications in online marketing, agile project leadership, and agile foundations, which enable him to apply best practices and innovative solutions to BI challenges.Andrew leads BI integrations throughout AuditBoard's suite of applications and is passionate about making data more digestible and empowering data-driven decision making.
Andrew T Balcom's Current Company Details
Andrew T Balcom Work Experience Details
-
Sr Business Intelligence DeveloperAuditboard Aug 2021 - PresentCerritos, California, Us• Leading BI integrations throughout AuditBoard's suite of applications allowing customers to glean more actionable business insights.• Documenting processes and systems for internal knowledge base for engineering and support teams.• Managing BI project backlog using JIRA to increase productivity of BI team and quickly release quality features.• Setting up a git repository to manage SQL queries and legacy ETL systems.• Training support teams on Power BI so they can better assist customers and peers with data-driven insights.• Developing and debugging embedded BI reports for customer's ad-hoc reporting needs.
-
Sr. Analyst, Business IntelligenceWarn Automotive Jan 2020 - Aug 2021Milwaukie, Oregon, Us• Implemented and enforced procedures for requesting new reports and managing queue priority.• Managed interns and power users at Warn's parent company (VSG) as they began implementing BI tools and services in their environment.• Developed a set of basic starter reports for VSG for them to make data-driven decisions with Power BI.• Managed requests for BI reports from leaders across the business and ensured delivery of these reports within agreed deadlines.• Identified and drew attention to data requiring cleanup in source systems to improve data integrity.• Consulted with senior management to ensure they had the tools to make key decisions. -
Business Intelligence ConsultantWarn Automotive Sep 2017 - Dec 2019Milwaukie, Oregon, Us• Gathered requirements for new BI reporting platform and trialed potential solutions with team leaders.• Migrated reporting from an old version of QlikView to Microsoft Power BI while maintaining and enhancing the overall quality of reports.• Prepared JDE data for a new BI solution through ETL processes to improve the legibility of data and its relevancy to the business.• Ensured key data from manufacturing line was being captured accurately and consistently.• Wrote and published Power BI reports to meet user and customer requirements and expectations.• Documented report sources and automated nightly processes including recovery instructions and manual execution required to maintain system integrity.
-
RelocationCareer Break Jul 2017 - Aug 2017• Relocated to the pacific northwest after over 30 years in southern New England• Followed the Oregon Trail from Independence, MO to Oregon City, OR.
-
It Business AnalystBerkshire Bank Jun 2016 - Jun 2017Boston , Ma , Us• Worked with senior management in the Finance department to ensure smooth project rollouts and address application issues.• Managed off-shore third-party PeopleSoft support vendor.• Improved documentation for PeopleSoft Financials installation, tracking customizations to delivered code and outlining standard business operations.• Created user acceptance testing scripts for PeopleSoft updates.• Retrieved Oracle cloud data in a nightly sync as part of a proof of concept for a new data warehouse initiative.• Assisted other IT Corporate Systems teams in support of other enterprise applications including SharePoint and Power BI. -
Systems Integrator IiiBerkshire Bank Oct 2014 - Jun 2016Boston , Ma , Us• Monitored PeopleSoft Financials installation, resolving any issues and outages.• Created simple solutions to refresh development servers for proper testing of application updates and new features by working with technicians and engineers.• Devised ETL methods to transfer data from new acquisitions into Berkshire systems while ensuring data integrity.• Worked with users to create SSRS reports for business users requesting access to archived data from retired systems.• Collaborated with the Infrastructure team to keep application servers up to date and running optimally.
-
TravelCareer Break Jun 2014 - Jul 2014• Seven-week solo road trip over 10,000+ miles across 18 states.• Tent camping at 18 state and national parks (plus 4 hotels in inclement weather)
-
Principal Software EngineerMmsi (A Division Of Rain The Growth Agency) Jun 2007 - Feb 2014Warwick, Ri, Us• Lead requirements gathering for a new in-house application to track core data, ensuring its success through team training.• Designed an upgraded database to track media, clients, ads, and leads providing a foundation for future innovation.• Tested ETL processes to ensure data integrity and optimize system performance.• Developed a WPF and C# .NET application with off-site developers and end-users.• Advised media buyers on the expanding digital media opportunities as cable subscriber rates began to slow in the early 2010s.• Demonstrated new reports analyzing performance using Google Charts APIs and business intelligence dashboards.• Deployed VBA applications to scrub bad leads before loading into MMSI core systems resulting in improved lead quality and conversion rates for clients.• Designed, wrote copy, and developed landing pages to collect leads for clients and improve conversion rates. -
Web Development InternConnecticut Center For Advanced Technology May 2006 - May 2007East Hartford, Ct, Us• Maintained site for the National Aerospace Leadership Initiative (NALI).• Replaced Flash elements on NALI site with SEO- and bandwidth-friendly HTML and CSS effects.• Collaborated with staff and third-party developers to update of company site. -
Technology DirectorWnek-Fm Aug 2005 - May 2007• Created budgets and roadmaps for the new year including future expansion to live stream broadcasts.• Initiated the digitization of the station’s CD library.
-
Alternative Music DirectorWnek-Fm Aug 2005 - May 2006• Trained new DJs on station equipment and procedures.• Maintained the station’s relationships with record promoters.
-
Web DeveloperSolutions For Staffing Sep 2006 - Dec 2006• Updated the client's website design, structure, and content to conform to the client's branding and accommodate the client's services.
Andrew T Balcom Skills
Database Design
Css
Sql
Social Media
Html
Advertising
Microsoft Sql Server
Javascript
Business Analysis
Data Analysis
Process Improvement
Project Management
Lead Generation
Business Intelligence
Technical Analysis
Marketing
Data Integration
Business Process Improvement
Web Development
Vba
Databases
Transact Sql
Requirements Analysis
Sdlc
Process Automation
Direct Marketing
Spreadsheets
Digital Marketing
Analysis
Root Cause Analysis
Software Development
Documentation
Customer Relationship Management
Integration
Technical Support
Requirements Gathering
Troubleshooting
Data Warehousing
Etl
Sql Server Integration Services
T Sql
Database
Microsoft Excel
Enterprise Software
Microsoft Power Bi
Customer Service
Application Support
Uat Coordination
Data Analytics
Andrew T Balcom Education Details
-
Western New England UniversityComputer Science -
Duke University Continuing StudiesNon-Credit Courses
Frequently Asked Questions about Andrew T Balcom
What company does Andrew T Balcom work for?
Andrew T Balcom works for Auditboard
What is Andrew T Balcom's role at the current company?
Andrew T Balcom's current role is Sr BI Developer @ AuditBoard | Driving BI Integrations.
What is Andrew T Balcom's email address?
Andrew T Balcom's email address is ab****@****ank.com
What is Andrew T Balcom's direct phone number?
Andrew T Balcom's direct phone number is +141323*****
What schools did Andrew T Balcom attend?
Andrew T Balcom attended Western New England University, Duke University Continuing Studies.
What are some of Andrew T Balcom's interests?
Andrew T Balcom has interest in Design, Snowboarding, Photography, Board Games, Travel.
What skills is Andrew T Balcom known for?
Andrew T Balcom has skills like Database Design, Css, Sql, Social Media, Html, Advertising, Microsoft Sql Server, Javascript, Business Analysis, Data Analysis, Process Improvement, Project Management.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial