PHILLIP C. RAWLS
Atlanta Metro Area,Georgia
Summary
Adept Power BI Developer with a proven track record at Northwestern Mutual, enhancing decision-making and reporting capabilities through advanced analytics and dashboard development. Skilled in leveraging Oracle Database and Microsoft SQL Server, coupled with exceptional cross-functional teamwork, I've driven significant improvements in TLS encryption compliance and operational efficiency.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Power BI Developer
Northwestern Mutual
10.2023 - 12.2024
- Developed interactive dashboards and reports for senior and executive leadership to track the overall compliance status of TLS encryption within the environment
- Built scalable semantic models based on star schema design principles to enhance reporting capabilities and optimize refresh performance
- Setup hourly and on-demand refresh schedules for Power BI reports as needed
- Led requirements gathering sessions to ensure all parties were aligned on the expected reporting deliverables
- Documented and socialized progress made towards improving the TLS encryption security posture
- Continuously improved development efforts by collecting and responding to feedback from key stakeholders
- Troubleshot production related issues within reporting environment
Sr. Business Analyst
Fiserv
Alpharetta, GA
11.2018 - 10.2023
- Delivered comprehensive reporting packages to executive and senior leadership, including 15+ KPI metrics and dashboards
- Enhanced decision-making processes by presenting actionable performance analytics within settlement operations department
- Optimized legacy ETL development efforts, which consisted of 22 VBA automations, into a single consolidated solution
- Created and maintained Power BI assets such as dashboards, reports, semantic models, dataflows, and apps
- Trained team members and end-users on Power BI functionality in an effort to facilitate adoption
- Performed administration tasks within reporting environment including user administration, report job scheduling, and report maintenance
- Utilized advanced SQL for the extraction and analysis of large datasets
- Collaborated with stakeholders to thoroughly understand and document business requirements
Data Analyst/CRM Administrator
Capital One
Richmond, VA
09.2014 - 11.2018
- Defined solutions (requirements, designs, services, recommendations) to business/systems problems and owned the integrity of the solution through customer acceptance and final disposition of solution
- Extracted, tracked, compiled, and analyzed data to generate reports on a weekly, monthly, and quarterly cadence
- Leveraged analytical tools to develop efficient system operations
- Performed data mining activities from within Teradata database that provided insights to leadership
- Imported customer data into Salesforce.com using proprietary tools
- Granted role-based privileges to relationship team members on Salesforce objects such as accounts, contacts, opportunities, and cases
Asset Management Systems Analyst II
Virginia Premier Health Plan, Inc.
Richmond, VA
10.2013 - 09.2014
- Tracked and managed all corporate assets, ranging from hardware to application licensure
- Generated monthly/weekly spending reports on corporate assets
- Performed physical and automated workstation inventory audits on a weekly cadence
- Analyzed differences between software license purchases and software installs to identify compliance issues and opportunities for cost savings
- Delivered extensive support to various departments by gathering business requirements, assessing needs, and designing new IT solutions to improve business efficiency and productivity
- Created data model and designed prototype of inventory management database application
Data/Information Analyst III
Capital One
Richmond, VA
08.2011 - 02.2013
- Key member of the software asset management team that realized over $1 million in cost savings in its first year of operation
- Performed audits on software inventory to identify and mitigate compliance risks
- Managed, updated, and manipulated report orientation and structures utilizing advanced Excel functions including pivot tables, V-lookups, and macros
- Normalized data from disparate systems to maintain the integrity of software license and install counts within asset-tracking system
- Identified data discrepancies between asset discovery system and asset tracking system and recommended solutions to improve consistency
- Created ETL solutions within Connect-IT utility to facilitate the process of importing data into asset tracking system as well as enhance the quality of the data
IT Asset Management Administrator
Bell Tech Logix
Richmond, VA
08.2006 - 08.2011
- Maintained the data integrity of the automated asset-tracking database through discrepancy analysis and reconciliation efforts
- Engaged with stakeholders to gather specific business requirements associated with data extraction, manipulation, processing, and analysis
- Performed analysis on complex datasets using pivot tables, aggregate functions, and SQL joins
- Conducted periodic audits within SMS database to verify workstation ownership/usage and identify potential security compliance violations
- Collaborated with developers on projects such as database migrations to test and validate successful transfer of data
- Loaded procurement data into Oracle staging database and utilized Connect-IT tool to import data into asset tracking system
Education
Bachelor of Science - Business Administration
Virginia Commonwealth University
05.2002
Skills
- Oracle Database
- Microsoft SQL Server
- Hadoop
- Teradata
- MS Access
- Power BI
- Tableau
- Oracle Business Intelligence
- MS Excel (Advanced)
- Power Query
- Salesforce Data Loader
- HP Connect-IT
- Power Automate
- Oracle SQL Developer
- SSMS
- Apache Impala
- Apache Hive
- Salesforcecom
- FlexNet Manager Suite
- HP Asset Manager
- SCCM
- BMC Remedy
- ServiceNow
- SharePoint
- Microsoft Visio
- Lucidchart
- Jira
- SQL
- DAX
- M
- End user support
- Design and development
- Adaptability and flexibility
- Cross-functional teamwork
- Time management
- UI/UX
Certification
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Salesforce Certified Administrator (ADM 201)
- Microsoft Technology Associate: Database Administration Fundamentals
Timeline
Power BI Developer
Northwestern Mutual
10.2023 - 12.2024
Sr. Business Analyst
Fiserv
11.2018 - 10.2023
Data Analyst/CRM Administrator
Capital One
09.2014 - 11.2018
Asset Management Systems Analyst II
Virginia Premier Health Plan, Inc.
10.2013 - 09.2014
Data/Information Analyst III
Capital One
08.2011 - 02.2013
IT Asset Management Administrator
Bell Tech Logix
08.2006 - 08.2011
Bachelor of Science - Business Administration
Virginia Commonwealth University
Similar Profiles
David ZuborDavid Zubor
Financial Representative at Northwestern MutualFinancial Representative at Northwestern Mutual
Rajender GuduruRajender Guduru
Financial Advisor at Northwestern MutualFinancial Advisor at Northwestern Mutual
Ryan AlbersonRyan Alberson
Financial Advisor at Northwestern MutualFinancial Advisor at Northwestern Mutual
Donald McleodDonald Mcleod
Financial Representative at Northwestern MutualFinancial Representative at Northwestern Mutual
Collin BarkleyCollin Barkley
Small Group Leader at Alpha Omega Campus MinistrySmall Group Leader at Alpha Omega Campus Ministry