CAREER PROFILE:

• Over 10 years experience in Financial Analysis, Data Analysis and Reporting .
• Over 5 years experience in designing and developing Business Intelligence tools.
• Reporting and analysis helped Confidential reduce the negative impact of Credit Card chargebacks on the P&L by $1.9 Mil.
• Cost benefit analysis resulted $1.1 Mil in annual savings for Confidential by influencing Executive Management to convert offshore resources to internal FTEs due to increased efficiencies.
• Reporting and analysis helped Confidential reduce preventable application outages by 36%.
• Analysis and insight helped Confidential reduce customer related SLA penalties by $1.5 Mil annually .
• Created pricing models that helped Confidential drive the acquisition of new business worth $3.5 Mil in annual revenue.
• Developed financial models used to measure Confidential operational costs related to maintaining Servers, Storage & Networking devices which lead to a projected $2 Mil in cost savings for 2016.
• Automation of financial reporting using Apptio lead to a reduction of 20 hours of effort monthly at Confidential .
• Extensive experience in extracting and manipulating data using Excel, Access, SAP, Cognos, PeopleSoft, Business Objects, Remedy, Apptio, Spotfire, Tableau, Qlikview, VMware ITBM, Essbase, Oracle Financials, HP PPM and legacy systems.
• Experience in providing variance, trend, and cost benefit analysis for senior and executive level management.
• Experience in developing pricing, forecasting and financial models to aid managerial decision making.
• Record of improving efficiency, productivity, and profitability through automation and process improvement.

Audit:  Apptio Budgeting  Business Objects

Cognos:  Essbase/Hyperion

Financial Analysis:  Forecasting

Informatica MDM:  Microsoft Access, Microsoft Excel, Microsoft Visio

P&L Statement:  Oracle Financials/PA

Pareto Analysis:  PeopleSoft

Process Improvement:  Process Mapping

Qlikview:  QlikSense

Remedy:  Regression

Reporting:  ROI

SAP:  Scatter Plot, Seasonality, Six Sigma, SLA

SQL:  Tableau, ITIL v3, ITBM, ITSM, Tibco Spotfire, T - SQL, VMware ITBM/ITSM Suite

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Senior Data Analyst

Responsibilities:

• Automation of financial reporting using Spotfire, Tableau & QlikSense lead to a reduction of 60 hours of effort monthly.
• Lead weekly business reviews with Senior Leadership and developed the related Analytics.
• Developed dashboards and KPIs used to measure the success of Equifax’s customer onboarding process and analyze the related revenue stream.
• Developed dashboards and KPIs used to measure the acquisition of new business and customer attrition.
• Managed the automation of manual reporting using Tableau and Spotfire.
• Managed data mapping and data conversion from source systems.
• Modeled data using SQL and managed the ETL process.
• Provided continuous improvement to reports, queries, and databases.
• Developed, analyzed, and prepared summary/detail for various Business Units and Sales Organizations.

Confidential, Atlanta, GA

Lead Technology Business Management Analyst

• Developed financial models in Excel and Apptio used to measure operational costs related to maintaining Servers, Storage & Networking devices.
• Partnered with Executive Leadership in order to develop KPIs that effectively measured the necessity of IT Infrastructure operating costs and capital expenditures.
• Automation of financial reporting using Apptio & Tableau lead to a reduction of 20 hours of effort monthly.
• Acted as team lead and SME for the implementation of Confidential ’ IT Business Management Tool using Agile methodology.
• Acted as Master Data Management SME to identify data gaps, inconsistencies and remediation strategies.
• Worked with external consultants and third party vendors to gather business requirements and specifications.
• Managed the automation of manual reporting using Tableau and Apptio.
• Managed data mapping and data conversion from source systems.
• Modeled data using SQL and managed the ETL process.
• Developed financial reports using Oracle Financials/PA and Hyperion.
• Provided continuous improvement to reports, queries, and databases.
• Developed, analyzed, and prepared summary/detail for various Business Units.

Confidential, Norcross, GA

Business/Data Analyst

• Automation and retirement of Excel based reports lead to a reduction of 40 hours of effort monthly.
• Managed the automation of manual reporting using Qlikview and the corresponding stakeholder relationships.
• Collected and documented report requirements for Qlikview development for Private Wealth Management and Retail Banking business units.
• Provided the Private Wealth Management Team with monthly reporting for loan, deposit and investment production.
• Provided the Consumer Default Team with monthly reporting for aging and monitoring of collections.
• Developed executive and managerial dashboards using Qlikview.
• Provided variance, trend, and cost benefit analysis for senior and executive level management.
• Developed, analyzed, and prepared summary/detail for various Business Units.

Confidential, Norcross, GA

Senior Data/Financial Analyst

• Reporting and analysis helped reduce preventable application outages by 36% during Fiscal 2012.
• Analysis helped drive a $1.5 Million reduction in customer related SLA penalties during Fiscal 2013.
• Developed executive and managerial reporting using VMware IT Business Management cloud based development tool.
• Developed SLA based KPIs in Excel and automated Excel based reporting using Vmware ITSM Suite.
• Managed data mapping and data conversion from source systems.
• Modeled data using SQL and managed the ETL process.
• Utilized data mining techniques to identify trends and factors related to recurring application outages.
• Collected and documented report requirements for IT Operations used to track ITIL based processes.
• Created trend analysis used to develop SLA agreements for application based services.
• Created a more efficient and accurate process for tracking application related outages.
• Extracted and manipulated data using VMWare ITSM, Remedy, Business Objects, Access and Excel.
• Lead Weekly Ops Meetings with Executive and Senior Leadership focused on Continuous Process Improvement and SLA compliance.
• Acted as back up administrator for SAP Business Object.
• Provided direction and training for a team of 4 Senior Analysts.

Confidential, Atlanta, GA

Senior Finance Analyst

• Created pricing models that helped drive the acquisition of new business worth $3.5 Million in annual revenue using Excel and Access.
• Directed and provided data analysis, process mapping and ongoing support for Six Sigma Greenbelt projects.
• Developed, analyzed, and prepared summary/detail for various sales districts.
• Created account level P&L’s to analyze the profitability of new and existing clients.
• Responsible for monthly accruals related to logistics expenses.
• Provided trend analysis used in the annual budgeting initiative.
• Provided variance, trend, and cost benefit analysis for Senior and Executive level management.
• Serviced the sales team with ad hoc queries, reporting and projects.
• Extracted and manipulated data using Cognos, PeopleSoft, Access, Excel, and legacy systems.
• Successfully implemented and conducted an Excel training class for fellow employees.
• Conducted routine SOX testing.

Confidential, Atlanta, GA

Senior Financial Analyst

• Reporting and analysis helped reduce the negative impact of chargebacks on the P&L by $1.9 Million in Fiscal 2007.
• Developed cost benefit analysis in Excel that resulted $1.1 Million in annual savings by influencing Executive management to convert offshore resources to internal FTEs due to increased efficiencies.
• Analysis helped increase successful chargeback disputes by 35% annually by identifying areas of focus.
• Acted as a liaison between Confidential and American Express, Discover, First Data, Visa, MasterCard and Citibank.
• Developed, analyzed, and prepared summary/detail for various business units, credit card processors and distribution centers.
• Assisted Credit Accounting and various business units with ad hoc queries, reporting and projects.
• Created financial models to aid managerial decision making.
• Developed and optimized $4 Billion annual budget for transportation related DC expenses.
• Developed forecasting models for DC freight and related fuel exposure.
• Constructed and updated process maps detailing departmental processes.
• Responsible for monthly accruals and reconciliations related to freight expenses.
• Extracted and manipulated data using SAP, IBM Base Tables, Access and Excel.