James Alexander

About James Alexander

Highly analytical Business Analyst leveraging expertise across technology, healthcare, oil & gas, wealth management, and consumer finance sectors. Proficient in advanced data manipulation and analysis, the development of automated KPI reporting solutions, and effective collaboration with business stakeholders to deliver data-driven market insights. Demonstrated success in optimizing operational efficiency, including the automation of reporting processes that previously required two full-time employees, the creation of impactful dashboards utilized by over users within sales and operations, and a 94% reduction in the cycle time for critical quarterly update procedures.

Experience

1. Principal Business Analyst, Global Analytics

   Oracle

   Sep 2021 — Present · Houston, TX, US

   Streamlined data workflows by implementing and refining data cleansing and transformation pipelines with embedded data quality rules. This automation reduced manual effort (previously requiring two FTEs) and enabled twice-daily refreshes of critical sales dashboards for over 500 users.• Led the successful migration of Excel-based reporting to Oracle Analytics Cloud, leveraging subject areas and data flows to deliver secure, real-time insights to over 500 users and enhance decision-making for a ~$1B sales pipeline.• Ensured the reliability and accuracy of real-time dashboards (utilized by over operations and sales users) by proactively monitoring, diagnosing, and resolving ETL job failures using advanced analytics and data quality tools.• Collaborated with stakeholders through 24 annual in-depth interviews and workshops to elicit business requirements and feedback. Translated these insights into standardized reporting frameworks and enhancements to existing reports, leveraging SQL for efficient data manipulation and automation to support effective pipeline generation.• Developed and curated a comprehensive suite of training materials covering data analysis, reporting, and visualization best practices. Delivered interactive upskilling sessions and hands-on workshops for over 20 users on BI tools and data modeling techniques, fostering continuous learning and development across teams.

Education

• Louisiana State University

  Master of Science (MS), Finance, General

  2011 — 2012

• The University of Southern Mississippi

  Bachelor of Science (BS), Finance, General

  2007 — 2009

• Copiah-Lincoln Community College

  Associate's degree

  2007

Skills

• Hyperion
• Hyperion Hfm
• Problem Solving
• Sap Bpc
• Variance Analysis
• Budgets
• Smartview
• Finance
• Sharepoint
• Corporate Finance
• Forecasting
• Hyperion Enterprise
• Financial Analysis
• Sap
• Budget Process
• Financial Forecasting
• Department Budgeting
• Analysis
• Accounting
• Microsoft Excel
• Powerpoint