William Avery work email
- Valid
- Valid
William Avery personal email
- Valid
William Avery phone numbers
BI Solutions Developer/Analyst specializing in Business Intelligence / Data Analysis / Data Science- Senior Data Analyst (2013 - 2023)- Pricing Analytics (2018 - 2019)- Digital Sales and Service (2013 - 2022)- Power BI (2016 - 2023)- SAP BusinessObjects Webi / Crystal / Excelsius Report development (2007 - 2013)- SQL using BigQuery, SQL Server, Teradata, Netezza, Vertica, OBIEE, Tableau- Tableau Dashboard Development (2013 - 2023)- SAP BusinessObjects (Business Objects) 4.x and 3.x, including: Web Intelligence (Webi) Report Development, Universe Design, Crystal Reports- SAP Data Services/Data Integrator ETL- Microsoft BI including Power BI, SQL Server, SSIS, SSAS, SSRS- Oracle Business Intelligence Enterprise Edition (OBIEE)- Digital Adoption Strategy (2013 - 2016)- Salesforce (2007 and 2016)Very knowledgeable in:- SQL- SQL Server- Data Analysis- SAP BusinessObjects / Business Objects- Web Intelligence- Google BigQuery- ETL- SAP Data Services- Tableau- SSRS- SAS- Adobe Analytics- Data Management- Data Quality- Data Modeling- Data Warehousing- BODS. BODI- Crystal Reports- All Microsoft (Power BI, Excel, Access, Reporting Services)- Telecom- Healthcare- Insurance- Banking- Retail
Aff, Llc
-
Financial Manager - Data AnalyticsAff, Llc Jul 2023 - PresentManage finances for Real Estate business. Property management, marketing and developmentUtilize Python and other scripting, advanced MS Excel, Pivot tables, Word, SQL Server and GCP
-
Senior Developer Data AnalyticsCentene Corporation May 2023 - Jul 2023Saint Louis, Mo, UsData Analyst using SQL, Teradata, MicroStrategy, Microsoft Power BI -
Senior Data AnalystAt&T Dec 2021 - Feb 2023Dallas, Tx, UsSenior Consultant, Data Analyst Ecommerce -
Senior Data Analyst - ConsultantRgp Oct 2020 - Dec 2021Irvine, Ca, UsSenior Business Intelligence Analyst, Data Analyst for Linkedin and Kaiser Permanente. Power BI Dashboards, Tableau, Built data dictionary, advanced Microsoft Excel, SQL, Microsoft SQL Server -
Senior Data Analyst/DeveloperAt&T Apr 2019 - Sep 2019Dallas, Tx, UsDevelop SQL Server stored procedures related to Quota Tool and Compensation system. Implement new SAP Callidus compensation system.
-
Senior Pricing AnalystThe Home Depot Jul 2018 - Mar 2019Atlanta, Georgia, UsSenior Data Analyst - Pricing. Build Tableau dashboards, SSRS reports. Google BigQuery SQL -
Senior Data Analyst Digital Sales, Ecommerce, Wireless, TvAt&T Aug 2016 - Jul 2018Dallas, Tx, Us● Develop Tableau dashboards for Digital Sales from multiple data sources using SQL, SAS, Teradata, Vertica● Develop SAP BusinessObjects Web Intelligence reports for Digital Sales, e-commerce, and related projects● Created Tableau dashboards for tracking digital traffic, mobile and desktop orders, device sales, accessory sales, upper, middle and lower funnels● Write and run SQL queries from e-commerce data mart (Netezza and Vertica) and Enterprise (Teradata) data warehouses● In-depth analysis of online and Click-to-Store order cancellations● Developed and distributed Digitally Influenced dashboard showing percentage of non-online channels shopped online first● Developed multiple funnel, traffic, and fallout reports/dashboards in Adobe Analytics● Other ad-hoc projects as required (Adobe Analytics, Tableau SQL, SAP Business Objects, Excel Pivot tables and formulas)● Worked in OBIEE to pull financial system data (numbers such as final sales by channels, churn, no-installs)
-
Senior Data AnalystPgi Apr 2016 - Jul 2016Alpharetta, Ga, UsSenior Data Analyst - Microsoft SQL Server 2012, 2014, SSIS, Salesforce.com.Salesforce data cleanup using SQL Server duplicate checks, fuzzy matches, other cleanup mechanisms.● Run SQL Queries, APIs on Salesforce.com data to find invalid, duplicate data● Wrote Fuzzy Match SSIS package to help isolate duplicate data in Salesforce database● Using APIs to merge or delete invalid Salesforce records● Documenting current interfaces with Salesforce in an overall Data Governance effort● Implementing new procedures, through triggers, or other methods, to alert users not to create duplicate records● Utilize Dun & Bradstreet (including Data.com) for data clean up -
Data Analyst, Digital Adoption, E-CommerceAt&T Apr 2013 - Mar 2016Dallas, Tx, Us● Develop SAP BusinessObjects Web Intelligence reports for Digital Adoption, e-commerce, and related projects● Discovered and resolved paperless billing system issue through data analysis of e-bill customer online habits, saving AT&T over $100K per month● Intense online customer digital adoption data analysis● Write and run SQL queries from e-commerce data mart (Netezza) and Enterprise (Teradata) data warehouses● Produce weekly KPI reports related to Digital Adoption for Wireless, U-verse and Wireline● Became go-to source for all paperless and AutoPay adoption knowledge/data● Responsible for all Paperless and AutoPay adoption percent penetration forecasts● Helping develop Coldfusion/Javascript tool for tracking call shed projects utilizing SQL Server database● Other ad-hoc projects as required (Microsoft PowerPoint, Excel Pivot tables, Tableau, some Adobe Analytics)● Administer Digital Adoption Microsoft SharePoint sit
-
Senior Bi Developer/AnalystIce Mar 2011 - Feb 2013Atlanta, Ga, UsBusiness Intelligence, Data Warehousing, DevelopmentSQL, BusinessObjects Web Intelligence, Crystal Reports, BODI, BODS, Netezza -
Senior ConsultantThe Glenture Group, Llc Oct 2010 - Mar 2011Deerfield, Il, UsBusiness Intelligence, Data Warehousing -
Senior Data Analyst, Business IntelligenceAccess General Jun 2009 - Oct 2010Atlanta, Ga, UsSenior role in developing solutions for Access General Insurance relating to their Sales and Claims departments -
Business Intelligence ConsultantDecision First Technologies Feb 2007 - Apr 2009Atlanta, Ga, UsSAP BusinessObjects, Data Integrator (BODI), Data Services (BODS), Universe Design, Web Intelligence, Crystal Reports, SQL, SQL Server, Oracle, Business Intelligence, Data Warehouse, Data Modeling, -
Data Acquisition SpecialistPrg-Schultz International, Inc. Jan 2003 - Jan 2007Atlanta, Georgia, UsSQL Server, ETL, Report Development, VB, Data Analysis, AS/400, see other PRGX experience -
It Data Services ManagerPrg-Schultz International, Inc. Jul 2000 - Jan 2003Atlanta, Georgia, UsData Services Manager over all ETL, Reporting, and other services related to our Southern and Western regions.
-
Data AnalystPrg-Schultz International, Inc. Dec 1996 - Jun 2000Atlanta, Georgia, UsData analysis, data delivery, and reporting for auditors and clients, primarily southern and western regions. Acquired, analyzed, converted (ETL) and delivered client Accounts Payable, Purchase Order, and other related data to our Auditors who recovered profits from their clients' vendors.
William Avery Skills
William Avery Education Details
-
Georgia State University - J. Mack Robinson College Of BusinessInternational Business -
The University Of GeorgiaSpanish
-
The Westminster Schools
-
Georgia State University - J. Mack Robinson College Of BusinessInternational Business
Frequently Asked Questions about William Avery
What company does William Avery work for?
William Avery works for Aff, Llc
What is William Avery's role at the current company?
William Avery's current role is Senior Business Intelligence & Data Analytics Professional.
What is William Avery's email address?
William Avery's email address is bi****@****rgp.com
What is William Avery's direct phone number?
William Avery's direct phone number is +167866*****
What schools did William Avery attend?
William Avery attended Georgia State University - J. Mack Robinson College Of Business, The University Of Georgia, The Westminster Schools, Georgia State University - J. Mack Robinson College Of Business.
What skills is William Avery known for?
William Avery has skills like Business Intelligence, Data Warehousing, Business Objects, Web Intelligence, Universe Design, Sql, Data Analysis, Obiee, Sql Server, Etl, Sap, Data Integration.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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