We provide IT Staff Augmentation Services!

Business Analyst Resume

Phoenix, AZ

PERFORMANCE SUMMARY:

Meticulous Data Analyst with proven abilities to bring quick resolution to complex assignments. Over a twenty - five-year track record of applying strong analytical skills to inform senior management of key trends, hidden patterns, previously unknown correlations, and customer preferences.

CORE COMPETENCIES INCLUDE:

  • Analytic decision support Trend Analysis Report Automation Variance Analysis Scorecards Dashboards
  • Custom Reporting Requirements Gathering Data Mining & Segmentation Budget Analysis
  • Interpreting Trends Report Process Improvement Customer Analysis Marketing Campaign Analysis
  • Key Metric Analysis Ad-hoc Analysis Data Manipulation Productivity Reports

TECHNICAL SKILLS:

  • SQL Proficient in Microsoft Office Suite: Advanced Excel Word PowerPoint Outlook Access
  • Essbase Teradata SQL Server Oracle MySQL PowerPivot TOAD Tableau SalesForce
  • V-lookups Pivot Tables FastLoad

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Business Analyst

Responsibilities:

  • Support business operations by creating and automating Tableau reports.
  • Analyze merchant compliance issues by querying the data warehouse with Teradata along with creating and running reports from SalesForce.
  • Worked with fellow analysts in streamlining Teradata queries pertinent to their job functionality.
  • Perform ad-hoc analysis utilizing Excel with data from SalesForce and SQL query results from Teradata.

Confidential, Phoenix, AZ

Database Analyst

Responsibilities:

  • Developed, maintained, and provided data used in regulatory reporting.
  • Provided analysis and insight of portfolio via reports or on a conference call with business partners.
  • Created and updated task documentation.
  • Performed ad-hoc analysis utilizing Microsoft Excel and SQL with both Teradata and Oracle.

Confidential, Scottsdale, AZ

Sales Operations Manager

Responsibilities:

  • Created a manual ETL process performed daily to prepare several disparate data sources for production reporting.
  • Managed the creation of all current sales reporting for agents, managers and sales leaders.
  • Provided sales management with the information to make key decisions and track progress of sales teams.
  • Provided reporting and analysis from SalesForce and proprietary Customer Relationship Management system.
  • Developed the Sales Quality Assurance program that monitored customer interaction to ensure a positive customer experience.
  • Provided data and analysis used in Confidential ’s published Quarterly Security reports
  • Report provides exclusive insight into the most common threats website owners face.
  • Coordinated with Finance to ensure the accuracy of commission payments for the sales agents.
  • Lead recurring and ad-hoc analysis to enable well-informed executive decision-making.
  • Implemented a post call survey to track Net Promoter Score.
  • Mentored a junior analyst.

Confidential, Phoenix, AZ

Database Analyst

Responsibilities:

  • Provide in-depth data analyses, research, and reporting needed to support the Checks program (e.g. billing audit, pricing changes audit, reconcilement, compliance, and remediation).
  • Recouped approximately $53,000 in overcharges by developing a system utilizing Teradata and Excel to audit an order file.
  • Reduced audit analysis cycle time by 40% by overhauling manual process with a systematic approach in Excel.
  • Produced and delivered timely banking regulatory reports to multiple audiences.
  • Shortened processing time by up to 90% on various production reports with process improvement utilizing both Teradata and Excel.
  • Automated several reports in Excel thus mitigating the chance of human error.
  • Evaluated customer transactional data identifying opportunities to increase acquisition, retention, and profitability.
  • Use data mining and modeling approaches in various areas such as account/customer segmentation, customer transactional behavior, portfolio studies, and product performance (penetration, shift, and retention).

Confidential, Scottsdale, AZ

Senior Marketing Database Analyst

Responsibilities:

  • Built the first report in corporate history to accurately report cruise bookings from all partners.
  • Commission payout process simplified by using combined booking report instead of various booking sources.
  • Reviewed effectiveness of online campaigns by tracking clicks, opens, and length of stay with Google Analytics.
  • Utilized data analysis to build customer profiles showing behavior and trends.
  • Employed customer profiles by querying Data Warehouse with SQL Server to increase effectiveness of targeted marketing campaigns.
  • Developed a scorecard in Excel with data from Data Warehouse to determine effectiveness of email campaigns.
  • Provided solutions to complex inquiries for all marketing managers on an ad-hoc basis.
  • Constructed variance analysis reports showing the business units adherence to the budget by comparing actuals from Essbase to budget.

Confidential, Phoenix, AZ

Pricing Analyst

Responsibilities:

  • Developed and maintained reports on new business pricing and existing customer pricing trends.
  • Monitored, analyzed and reported on key tracking metrics including average price, customer retention, customer behavior, and customer acquisition rates.
  • Built an automated scorecard in Excel with connections to summarized data tables in SQL Server.
  • Provided budget planning and developed management reports with variance and trend analysis.
  • Skilled at retrieving data from Essbase to perform variance analysis comparing actuals to budget.

Confidential, Phoenix, AZ

Analyst

Responsibilities:

  • Determined if particular HEDIS performance measures had statistical significant improvement or decline in performance from prior reporting period.
  • Applied complex statistical formulas in Excel to determine whether a change was statistically significant.
  • Compiled summaries that interpreted the findings of the analysis thus pointing out which measures or areas of services required improvement.
  • Conducted quality reviews of team members’ analysis results.
  • Converted SAS code to SQL.

Confidential, Scottsdale, AZ

Sr. Analyst

Responsibilities:

  • Developed new sales reports based upon specifications from sales department and delivered with BusinessObjects.
  • Processed existing production client reports requested by the sales force.
  • Decreased processing time by 98% by both automating and combining multiple quarterly reports into one report.
  • Reduced production time by up to 50% by creating a new methodology of running for the entire book of business rather than one client at a time.
  • Initiated a review of procedures for department that led to more efficient productivity and reduction in processing costs.
  • Responsible for converting existing processes from Oracle to Teradata as part of the corporate move towards Teradata.

Confidential, Phoenix, AZ

Sr. Information Analyst

Responsibilities:

  • Provided in-depth data analyses, research, and reporting needed to support end of lease transactions for autos
  • Increased profit by matching repossessed autos with auction sites that had higher return on sales for a particular model than other auction sites in the nation by analyzing data from Oracle.
  • Supported home finance brokers with data analysis and research needed to service their clients.
  • Added benefit to an incentive program by providing the brokers with real time competition status with an Oracle Reports Developer report.
  • Engaged in full spectrum of report building from requirements gathering to report delivery.
  • Led user acceptance testing for a system conversion.

Hire Now