Business Intelligence Power Bi
Resume:
Business Intelligence Lead
ALBERT C. WILLIAMS
*************@*****.***
Over 12 years of experience in Business Intelligence (BI) development and management, 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
● Management and Leadership: Mentoring, performance assessment, training
● Data Policies, Security, Privacy, and Governance
● 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
● Strategic Vision, impactful leadership and mentoring
● Communication of high-performance expectations and mentoring
● Performance assessment and training
● Business requirements gathering and creation of technical and functional documents
● Project, Stakeholder and Change Management
● Post-production support and continuous improvement
● Collection, analyses, and interpretation of data
● Development and maintenance of data models to support forecasting and predictive analytics
● Development and reporting of Key Performance Indicators (KPI)
● Quality Analyses and Testing
● Upgrades and updates
● Datawarehouse management
● Standard Development Life Cycles including Waterfall and Agile
● Reporting and Dashboards (Webi, Tableau, Lumira, Power BI, Crystal Reports, Bex query designer)
● Business Objects Administration
● ASAP Methodology
● Online analytical processing (OLAP) and online transaction processing (OLTP)
● Collection, analyzation, and interpretation of data
● SAP S4HANA, SAP BW4HANA, SAP BW, IDT/UDT (Universe Design)
● SAP ERP Modules, ETL Tools and Data Staging
Professional Experience
Deloitte
Capacity: Business Intelligence Lead - (Jan 2025 – Present)
● Organized requirements gathering meetings with Business and put together functional and technical documents.
● Created weekly status reports, managed projects with Jira and set high performance expectations.
● Accessed and tested configurations, documented findings and made recommendations.
● Implemented advanced DAX queries in Power BI desktop, providing detailed insights.
● Led team to developed Web Intelligence reports using freehand SQL.
● Created and validated views using Teradata Version 16 using SQL and created testing documents that captured the testing procedures.
● Configured folder level security, created BW Olap connections and cleaned up redundant users in CMC.
Environment: Jira, Dbeaver, BOBJ 4.2, IDT Version 4.2 SP 7, Webi & CMC. Business Intelligence Lead
ALBERT C. WILLIAMS
*************@*****.***
Sarasota County Public Schools, FL
Data Migration Engineer/ Lead (Contractor) - (Nov 2024 – December 2024)
● Led my team to migrate 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.
● Provided training on Power BI tools to three key users and many end users.
● 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. Environment: MS SQL Server, Visual Studio, SSIS, SSRS, Power BI & Dax. PSCU (Velera), St. Petersburg, FL
BI Lead (June 2019 – August 2024)
● Led team to upgrade BOE to 4.3 and produced over 109 reports to increase productivity and revenue.
● Led team to automate many manual processes and saved the company over a million dollars.
● Performed performance assessments and mentored team to maximize their individual potentials.
● Led team to developed dashboards using WEBI, Power BI and Tableau with important KPIs to help Business make important decisions, drive improvement and increase productivity.
● Provided training on Business Objects tools to five key users and over 200 end users.
● Conducted requirements gathering and created technical and functional documents for developments.
● Validated data on reports against data in Teradata, SAS and Marketo. Environment: BOBJ 4.2 SP 7, Power BI, Python, R, SQL, Azure, SAS, SQL, SSRS, SSAS, CMC & CMS. 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 Webi 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. Business Intelligence Lead
ALBERT C. WILLIAMS
*************@*****.***
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 Webi 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