Uploaded File
add photo
Allan
allanjmaclean@yahoo.com
979-481-9966
Bryan, TX 77808
Business Intelligence Analyst (Lead)
7 years experience W2
0
Recommendations
Average rating
4
Profile views
Summary

  • A Top performing Business intelligence Analyst professional with proven ability to drive business expansion through aggressive initiatives that deliver revenue growth, market share, fill rates, customer satisfaction level and market penetration
  • A Strategic thinker and a competitive individual with a winning attitude who focuses on the customer and organizational needs in order to increase profits
  • Strong analytical, problem-solving, influencing, prioritization, decision
  • making and conflict resolution skills.
  • 6+ years of supply chain experience
  • PostgreSQL, MS SQL Server, SSMS, SQL, SSRS, SSIS, Power BI, Tableau, SharePoint, MS Office Suite (Word, Excel (advanced), PowerPoint, Outlook, Visio and Lync), HTML, SAP, SAS, OLTP, OLAP, XML CSV, flat files, Jira, ServiceNow, Agile (Kanban/Scrum), SDLC, ITSM, ITIL, SOAPUI, Oracle PL/SQL, Crystal Reports, JDA, JD Edwards, Logility

Experience
Business Intelligence Analyst (Lead)
Mar 2019 - Mar 2019
  • Analyze, and interpret trends in various data sets
  • Communicate findings and processes across organizations
  • Collect and maintain a wide array of data-related business processes and reporting using SQL, Power Bi and Tableau
  • Apply technical expertise to ensure data quality and accuracy
  • Implement business intelligence tools to support and drive self-service reporting tool.
  • Provide continues process improvements via Lean methodology and automation.
  • Complete all tasks in connection with the organization's activity but not detailed in current job description, charged by the direct manager, or executive team
Business Intelligence MS Power BI Process Improvement SQL Tableau
Remove Skill
Inventory Data Analyst
May 2014 - Mar 2016
  • Gathered, extracted, manipulated, analyzed and modeled data using analytical and statistical tools including SSAS, SSIS and Tableau
  • Calculated weekly demand forecasts for over 5000 Stock Keeping Units (SKU) distributed to 104 AT&T Device Support Centers (DSC) using various forecasting formulas for spreadsheets on Excel and data mining from SSMS
  • Identified new sources of data and methods to improve data collection, analysis and reporting.
  • Designed and developed business intelligence and data analytical reports to deliver insights to business through data using Tableau.
  • Analyzed demand data on JDA, Tableu and Excel spreadsheet reports and assessed the accuracy of each program for forecasting and reduced forecasting procedure time by 50% through Macros recorded on Excel
  • Analyzed and published the featured device list bi-monthly to determine which SKU's required removal or addition to the list and other complex reports to upper management using Tableu
  • Created SKU's on Oracle Product Hub, ordered requisitions using Oracle and managed on hand inventory at the warehouse
  • Collaborated with Genco and Flextronics on a daily basis to resolve issues regarding inventory at DSC's across USA / Puerto Rico
  • Prepared and compiled reports used for decision making to achieve operational efficiency through data mining
  • Worked alongside Apple to achieve AT&T's Same Unit Repair Project goals and brainstormed with Apple to eliminate bottlenecks downstream the supply chain
Business Intelligence Data Analysis Data Mining Microsoft Excel Oracle SSIS Tableau
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Supply and Value Chain Management Honors
Neeley School of Business 2014
Texas Christian University
Certifications
Oracle Autonomous Database Cloud Certified Specialist
Microsoft Certified Professional MTA
ITIL Foundation Certified
Skills
Business Intelligence
2019
2
Data Analysis
2016
2
Data Mining
2016
2
Microsoft Excel
2016
2
Oracle
2016
2
SSIS
2016
2
Tableau
2019
2
Crystal Reports
0
1
MS Power BI
2019
1
Process Improvement
2019
1
SAS
0
1
SQL
2019
1
SQL Server
0
1
SSRS
0
1