Alexander Faust Email & Phone Number

Conshohocken, Pennsylvania, United States

Conshohocken, Pennsylvania, United States

• Proficient in extracting data from multiple source systems (SQL Server, Azure SQL DW, SAP Hana, Oracle, Analysis Services, SharePoint, Excel, etc.) transforming data and building data models in Power BI• Develops workflows/plans with business stakeholders to effectively manage project timelines and estimate project magnitude• Expert knowledge of features available in Power BI Service: app configuration, scheduling data-refresh, alerts, subscriptions, personal bookmarks, row-level security and incremental refresh• Collaborate with developers to assure processes are in line with strategic guidelines• Partner with business stakeholders to develop business analytics requirements to ensure functional and non-functional requirements are met

Chesterbrook, Pa

• Provide data analytics support for various audits performed throughout the year, including requirements brainstorming, data acquisition, data management, iterative analysis design and analytics, and data visualization• Develop automated analytical scripts, tests, and analytical reports using SQL, ACL, and SAP• Acquire large datasets and take them through the ETL process using multiple tools to meet audit objectives.• Summarize results to present anomalies, error rates and dollar impact from anomalies / exceptions to meet and present to the audit team and other internal business partners.• Managed time working on multiple projects simultaneously

Chesterbrook, Pa

Paoli, Pennsylvania

- Responsible for the development and implementation of Sales Territory Mapping Platform which lead to an increase in productivity and performance within the Pacer Financial Sales Team- Establish collaborative relationships with cross-functional teams to develop continuous improvements for business processes and systems relative to financial data and reporting- Explore and assess technology solutions in order to provide recommendations for improved system processes

Port Of Newark, Nj

- Drafted standard operating procedure manual for Food Grade Oil Division- Responsible for developing scope for researching solar panel project – leading to purchase and installation of multi-million dollar storage and distribution facility- Recreated “lost database” of equipment inventory and tested software- Delivered/Presented monthly progress reports to Senior Management and Chemists

Phoenixville, Pa

- Developed Inventory control system- Created schedule delivery logs and procedures- Developed project implementation plan to enhance production and storage capabilities- Developed warehouse workforce infrastructure grid- Worked with retail customers to develop customer experience skills

Master Of Science In Business Intelligence & Analytics, Information Technology

Activities and Societies: Member of Beta Gamma Sigma International Business Honor Society

Bachelor'S Degree, Information Technology

Activities and Societies: La Salle Baseball Team

Education record

Activities and Societies: Baseball Team Golf Team Basketball Team