SUMMARY:

Diverse background in data and business analysis, including data mining, reporting, documentation, and system implementation; Serving as a bridge between business and technical users, with knowledge of multiple tools, including SQL, SAS, Excel, and Access.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, Virginia

Data Analyst

Responsibilities:

• Created and executed SQL and SAS scripts for reconciliation and to support ad hoc requests from actuaries and management.
• Reported results using Excel (pivots, lookups).
• Performed data stewardship role in accordance with the Data Governance Office to ensure accurate and organized metadata for long - term care insurance policies and to support federal and state regulations, including owning and maintaining a data dictionary for over 40 tables containing actuarial modeling data.

Tools Used: SQL (Greenplum, SQL Server), Excel (including PowerPivot), SAS, Visio

Confidential, Richmond, Virginia

Data Analyst

Responsibilities:

• Partnered with management and analysts to provide detailed performance metrics and monthly reporting for Trust/Brokerage divisions and financial advisors
• Improved existing processes to better automate reporting.
• Performed ad hoc data mining to fulfill management requests and to modify existing reports.
• Built and maintained Access database to track advisor scorecard and leaderboard metrics.
• Documented current procedures and trained offshore and onshore consultants to run the processes.

Tools Used: Access, Excel, SAS, Toad, SQL Server Management Studio, Qlikview

Confidential, Richmond, Virginia

Business Systems Analyst

Responsibilities:

• Analyzed existing credit policies for card partnerships in order to assist with monthly customer mailings.
• Created and executed simulations in SAS to test changes to credit policy.
• Created and executed ad hoc and monthly credit policy compliance reporting, using mainframe, SAS, and Excel.
• Monitored daily customer volumes through the creation and maintenance of control charts in Excel.

Tools Used: Excel, SAS (version 9.3, as well as mainframe SAS), Citrix, IBM Mainframe

Business Systems Analyst

Confidential

Responsibilities:

• As part of an Agile team for the Retail Banking portfolio, served as the subject matter expert for the Quantitative Risk Management (QRM) system and its ETL tool - the Transaction Data Mart (TDM)
• Analyzed QRM system structure to determine impacts of upcoming changes; developed and documented test plans; Setup test environment, loaded test files, and developed and executed SQL queries to perform QC.

Tools Used: SQL Server 2008, Excel, ETL tool (with Visual Basic), Agile environment (using Version One)

Data Analyst

Confidential

Responsibilities:

• Provided data support for audits of companywide controls and procedures by developing new SQL scripts as well as researching and verifying accuracy of current scripts
• Performed business analysis and testing of controls.
• Supported ad hoc data requests of management and Business Analysts, through analysis of the data architecture to provide meaningful reporting and documentation, as well as remapping of new data sources.

Tools Used: Teradata SQL, Excel, Knowledgelink

Data Analyst

Confidential

Responsibilities:

• Developed advanced Excel spreadsheets to automate and analyze the affiliate bidding processes and the “display marketing” campaigns.
• Used SQL to mine Teradata databases to analyze customer data and to measure success of internet marketing campaigns, as well as to perform ad-hoc analyses for business users.

Tools Used: Teradata SQL, Excel (including Vlookups, pivot tables, and embedded SQL)

Confidential, Richmond, Virginia

Data Mining and Reporting Analyst

Responsibilities:

• Analyzed senior management requests to develop enhancements for Microsoft Access reporting tool, providing call center performance metrics to multiple levels of management, leading to better health choices for customers.
• Modified and developed stored procedures in SQL Server; created ad-hoc SQL queries to assist business users.

Tools Used: SQL Server Management Studio, MS Access (forms, reports, queries), Excel, Adobe Pro

Confidential, Richmond, Virginia

Data Analyst

Responsibilities:

• Mined and analyzed Teradata databases to create metrics and reports to enable call centers to make efficient business decisions (such as proper staffing levels or amount of outsourcing to third-party agencies).
• Wrote SQL scripts for weekly reporting; managed continuous ad-hoc requests from multiple internal customers.

Tools Used: Teradata SQL, Business Objects (Crystal Reports, Web Intelligence), Excel

Confidential, Richmond, Virginia

Systems Analyst

Responsibilities:

• Worked with business customers to develop and maintain management-level reports for manufacturing plants.
• Mined Oracle databases using SQL to create views and procedures, and created ad hoc and intranet-based reports using ASP and Excel (including charts, graphs, pivot tables, macros, embedded SQL queries, and VB).

Tools Used: Oracle SQL, MS Access, Excel, PowerPoint, Visual Basic, ASP

Confidential, Richmond, Virginia

Operations Data and Reporting Analyst

Responsibilities:

• Developed, managed, and maintained reporting and security for 200+ users of Oracle-based ERP system through Crystal Reports and Crystal Enterprise.
• Automated weekly reports for business units, including implementation of labor-cost tracking system and creation of Oracle Views as needed to increase speed of reports.

Tools Used: Crystal Reports, Crystal Enterprise (intranet reporting tool), Oracle SQL