PROFILE:

Senior - level business/data analyst and operations expert with extensive experience with end-to-end implementation of business process re-engineering initiatives. Expertise lies in query-based data analysis, report design and process effectiveness measurement. Use technical and analytical skills to create data-driven reporting models which fuel efficient business process change. Team player that possesses the ability to liaise with individuals at all levels of an organization. Proven track record developing reporting, operational infrastructure and business processes in corporate and “start-up” organizations. SQL and MS Excel Expert.

CORE SKILLS:

SQL and Query-Based Data Analysis

Report Design and Construction

Cost Control and Reduction

Operations and Process Analysis

Business Requirements Gathering

Database Testing and Design

Process Design & Implementation

System Analysis and Design

Executive Communication

Data Warehouse Testing and Analysis

Project Management

Business/Technical Liaison

TECHNICAL/FINANCIAL SKILLS:

Reporting Tools: My Eureka, Business Warehouse, Microsoft Access (ODBC), QlikView, Crystal Reports

Languages: TSQL, MYSQL, PL/SQL, SQL for Oracle Databases, VBA, Visual Basic Learning Python, R, Hive

Enterprise Application Platforms: SAP R/3 6.20, Banner, ISTA

RDBMS: Oracle 11/12, SQL Server, ACT DB Software, MS Access

Operating Systems: Windows 8/XP/NT/2000, OSX

Application Software: Excel Expert, Access, PowerPoint, Word, Project, Visio

WORK EXPERIENCE:

Sr. Business Analyst / Data Analyst

Confidential

Responsibilities:

• Analyze large data sets with SQL and other tools to determine anomalies within the data warehouse
• Determine business reporting requirements and translate those needs into technical specifications for the database architect
• Create data mapping and requirements documentation for the ETL team to populate the data warehouse based on the architects specifications
• Test loaded data sets (fact tables and dimension tables) for accuracy and logical issues regarding data normalization
• Conduct root cause analysis for “data outliers” to determine exclusions or inclusions of specific data points within a subject area
• Create audit scripts used by data warehouse support to automatically analyze ongoing data loads for anomalies

Sr. Business Analyst of Data Analytics and Process Improvement

Confidential

Responsibilities:

• Data mined and created ad-hoc reports that solve immediate business needs within hours of request
• Created data extraction queries (SQL, PL/SQL, MYSQL, TSQL) with TOAD for MySQL and PL/SQL Developer
• Generated daily data quality audits and reports used to improve the Confidential Business Warehouse
• Data Analysis Tools Support: Provided support to stakeholders wanting become familiar with SQL and QlikView
• Documented reporting requirements from business owners and/or business analysts
• Instructed the business on proper use of data to understand issues associated with manual, broken, or convoluted processes. Redesigned old processes and re-measured new processes with data analysis to ensure improvement
• Data integrity analysis: wrote queries to help detect data anomalies within large data sets

Sr. Financial Analyst - Revenue Analysis Lead

Confidential

Responsibilities:

• Led a team to develop, build and manage daily/weekly reports which include, but are not limited to:
• Top 25 Customer - Outstanding A/R by Profile Class
• Collector Target Reporting - Algorithm development for individual, team, and division targets for 150+ individual collectors
• Aging Index Reporting - weighted average reporting on receivables which dictates dollars at risk
• Database creation, extensive data mining, and query analysis using Microsoft Access and SQL
• Analyzed statistical data and prepared analysis to support change initiatives
• Developed standard and ad-hoc reports to identify data integrity failures
• Produced reports for management that draw data from various sources to aid in tracking business unit efficiency
• Led a team to develop, build and manage daily/weekly reports which include critical Operations Reporting, Credit and Collections Bad Debt and Accounts Receivable analysis
• Provided functional guidance, advice and/or training to less-experienced data analysis professionals
• Created powerful Excel Data models and reports using Oracle database extracts
• Completed time-sensitive ad hoc projects which created efficient use of FTEs by eliminating need for rework
• Developed and submitted change control recommendations to support operational and business requirements which include functional design, test plan, and implementation.

Business Operations Analyst

Confidential

Responsibilities:

• Analyzed data and operations using SAP, Access/SQL and Excel
• Completed time-sensitive ad hoc reports related to disconnections and reconnect desk activity
• Documented and communicated technical data requirements for development of customer information system queries to support ongoing root cause analysis and identification of unique lists of accounts requiring resolution
• Prepared spreadsheets, graphics, and word documents as required for reporting, analysis, documentation, and presentations
• Developed and documented training requirements, training materials, and provide training as required for call center representatives, supervisors and management