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.