Power Bi Business Intelligence
Resume:
SAS Programmer
ALBERT C. WILLIAMS
*************@*****.***
Over 12 years of experience in Business Intelligence development, implementing multiple full life cycle projects. Skilled in managing both small and large teams, onsite and offshore, with expertise in management, implementation, analytics, and reporting.
Key Skills
● Development and maintenance of data models to support forecasting and predictive analytics
● Development and reporting of Key Performance Indicators (KPI)
● Data Analysis, Security, Privacy, and Governance
● Data migration using SSIS packages in Visual Studio
● Reporting and Dashboards (SAS, Webi, Tableau, Lumira, Power BI, SSIS and SSRS)
● Experience with BI architecture (tables, attributes, facts and hierarchies)
● Performance of in-depth data analysis and configuration using SAS
● Advanced knowledge in Excel, using pivot tables and VLOOKUPs for data visualization.
● Research, problem solving and root cause analyses
● Recommendation and implementation of solutions to optimize business processes
● Conduction of gap analysis to identify areas of improvement
● Business requirements gathering and creation of technical and functional documents
● Project, Stakeholder and Change Management
● Post-production support and continuous improvement
● Quality Analyses and Testing
● Datawarehouse management, Collection, analyses, and interpretation of data
● Quality Analyses, Testing, Upgrades/updates, performance tuning and query optimization
● Performance Assessment, training and mentoring
● Online analytical processing (OLAP) and online transaction processing (OLTP)
● Project administration using SharePoint and Jira
● SAP BI/BW/BO/HANA/Universe Design
● ETL experience using SSIS and SAP ECC
Professional Experience
Sarasota County Public Schools, FL
Data Migration Engineer (Contractor) - (Nov 2024 – December 2024)
● Migrated legacy on-premises data to MS Azure
● Implemented advanced DAX queries in Power BI desktop, providing detailed insights and resulting in 15 % improvement in performance
● Developed Power BI reports using Quick measures, Iterator functions, Hierarchies, etc.
● Developed data flows and packages in Visual Studio according to task
● Developed and optimized complex SQL queries resulting in a 25% increase in performance
● Implemented row-level security on confidential data consolidating information security
● Conducted requirements gathering and created technical and functional documents.
● Provided training on Power BI tools to three key users and many end users.
● Created Dataflow tasks for ETL in SSIS
Environment: SAS, MS SQL Server, Visual Studio, SSIS, SSRS, Power BI & Dax. SAS Programmer
ALBERT C. WILLIAMS
*************@*****.***
PSCU (Velera), St. Petersburg, FL
Senior Business Intelligence Developer (June 2019 – August 2024)
• Performed data analyses and resolved issues using Teradata and SAS.
• Validated data on reports against data in Teradata, SAS and Marketo
• Developed reports using SAS with important KPIs to help the Business to make important decisions and drive improvement
• Combined data from multiple data sources and complex data feeds to create dashboards
• Created and updated Power BI and Webi reports with different reporting features Environment: SAS, Teradata Version 16, SAS, Jira and SharePoint J. J. Keller & Associates, Inc., Neenah, WI
SAP BI/BO Analyst (March 2019 – May 2019)
● Updated BOE and Lumira versions.
● Configured single sign-on for BI launch pad and CMC.
● Created implementation documentation for Single Sign-On.
● Trained two key users and many users on Lumira functionalities. Environment: CMC, BOE 4.2 SP 4 & 7, Lumira versions 2.1 & 2.2. Dawn Foods, Jackson, MI
SAP BI/BO Analyst 3 (Sept 2013 – Sept 2018)
● Maintained BW backend configurations and BI tools.
● Created and updated Power BI and Analyses for Office (AFO) reports
● Performed Transportation or migration of objects between different systems
● Performed data validation for business departments.
● Managed BW process chains and performed BW to HANA migration.
● Solved business challenges that require integrating SAP solutions and leveraging delivered and customized SAP Business Content/Packages.
Environment: SAP BI 7.4, BWonHANA 7.5, BEx Query Designer. Maines Paper & Food, Conklin, NY
SAP BI/BO Consultant (April 2013 – June 2013)
● Created a three-layer Webi report showing customer data, Invoice Data and Invoice PDFs.
● Analyzed old Crystal Reports and converted them into Power BI reports
● Integrated corporate security policies by using Customer exits in Bex queries to limit
● Franchise Groups/Sold to parties to their data
● Created functional documents and technical documents for effective knowledge transfer. Environment: BOBJ 3.1 SP4, SAP BI 7.0, BEx Analyzer. Education
● PhD in Leadership, Liberty University (2019 - Present)
● Master of Arts, Liberty University (2012-2015)
● Bachelor of Arts, University of Science and Technology (1998-2002)
Contact this candidate