Lisa Baum

**** ****** *****, ******, ******** ***34

Cell: 404-***-**** E-mail: ac0t43@r.postjobfree.com

LinkedIn Profile: www.linkedin.com/in/LisaBaumDataAnalyst

DATA ANALYST SUMMARY:

Data Analyst, Senior Reporting Analyst, Business Analyst, Report Developer, Metrics Reporting Analyst, Data Analytics and Support, Business Systems Consultant, Business Systems Analyst, MS Access Database Developer, Metrics Reporting Analyst, Database Analyst, Database Specialist, Database Administrator, Database Programmer. Retrieves, collects, cleanses, manipulates, summarizes, and analyzes large data sets. Identifies, analyzes, and interpret trends in large data sets, statistics and complex reporting needs solved. Data scrubbing/cleaning, root cause analysis, graphs, charts, forecasting, data research, special data projects, report mock ups, SQL, SQL Server TSQL, PL/SQL, ANSI SQL, Oracle, Data Warehouse, RDMBS, DB2, SSRS, VBA, SharePoint Team Sites Collection Administrator, Fusion, PeopleSoft, Salesforce, AS-400, Fieldglass, IQ Navigator, EZ-Suite. SSRS, HR and Payroll data and analytics, Web based reporting tools, SAP Business Objects Business Intelligence (BI), Tableau, Microsoft PowerBI, Power Pivot,Lotus Notes, AS/400, Crystal Reports XI, Cognos Impromptu, Oracle 10g ISQL*Plus Workspace, Pinnacle Studio Plus, Goldmine, JD Edwards, ACT! 2000, Support Central, Flash, Snag-it, Smart Draw, UserBase V2.2.Expert Access, Excel, Tableau, PowerPoint, Word, Visio. Spreadsheets, graphs, charts, pivot tables, pivot charts, V-LOOKUP, Macros, VBA, advanced Excel and Access functions and formulas. Gathers business requirements, conducts business analysis, ETL processes, QA testing, streamlines existing processes to improve efficiency, develops use cases, defines and documents user procedures, business writing, data mapping, data lineage, metadata, data governance documentation, technical writing. All around data support person available for long and short term projects. I provide simple solutions to complex data needs. Experience working with HR and Payroll data, manufacturing, Insurance, Banking, Mortgage, Financial, Production and healthcare data.

MS Access Developer:

Developed MS Access databases and reports for some of the largest companies in the USA. Siemens, UPS, Wells Fargo, Bank of America, SunTrust, Comcast, Synchronoss, and others. I am available for remote/virtual project work or local work in Conway, Arkansas.

EDUCATION:

Business Management, California Lutheran University, Thousand Oaks, CA.

PROFESSIONAL EXPERIENCE:

DATA ANALYTICS AND SUPPORT

Siemens, Alpharetta, GA (Contract assignment – Randstad Sourceright – Remote Position) 5/13 – 6/17

Assisted with Fusion HCM implementation of HR and Payroll modules (Peoplesoft to Fusion), training of temp workers to assist with manual data entry, edits, terminations.

SQL Server, Oracle Fusion, Fieldglass, PeopleSoft, Ez-Suite, Tableau.

Used MS Access, Excel, V-LOOKUP, charts, graphs, Excel advanced formulas and functions, macros.

PowerPoint, MS Word, data analysis, reporting, data warehouse, Fieldglass, EZ-Suite, Modias, SQL Server 2012.

Developed reporting metrics, analysis and analytics of HR and Payroll data.

Oracle SQL Developer, T-SQL, PL/SQL to query databases and create reports.

Performed data analysis to validate data warehouse changes in HR and Payroll production data.

Built MS Access databases and created ad hoc queries and reporting for management.

Responsible for writing business requirements, user documentation and QA testing.

Developed and managed processes for file prep and data uploads to travel database tool.

Automated travel profile data prep process, created MS Access database and used VBA to import files and run queries and ETL to production system.

Responsible for creating weekly, monthly and ad hoc reports, worked with NPPI Data.

Cleansed and prepared large files in preparation for upload to database.

Largest files contain close to 1 million rows, smallest files about 150,000 rows.

Removed duplicates, removed leading and trailing spaces using various formulas and functions.

Validated the upload files against existing data in database to ensure duplicates were not uploaded by using

Formulas: V-Lookups, MID, LEN, COUNTIF, CONCATENATE, DATE SERIAL, GET PIVOT DATA, MACROS, VBA, IF THEN.

Created weekly, monthly and ad hoc reports by pulling data from databases and used Excel to create charts, graphs, pivot tables, various metrics and summaries, dashboards and analysis.

Gathered business requirements.

Created field mapping documentation.

Created travel database process to cleanse and transform data for upload to production.

Used SQL Server, Fieldglass, Fusion, Oracle, PeopleSoft, EZ-Suite, Modias, MS Access, Excel, Powerpoint for a variety of analysis, metrics and analytics.

Created data mapping documentation, BRD and FSD as well as a variety of technical writing of user procedures to support end users.

REPORT DEVELOPER/BUSINESS ANALYST

Sun Trust Bank, Richmond, VA (contract assignment – PSG Principle Solutions Group – Remote Position) 7/15 –04/16

Updated MS Access queries to reflect organizational changes.

Automated and streamlined manually created reports with VBA, Macros and MS Access and other automated processes.

Ad hoc reporting, created queries in MS Access, SQL Server, DB2, Compass used SQL, TSQL, data lineage, metadata, and mapping, worked with NPPI Data.

Cleaned up report inventory, worked with SME’s to determine if report was still needed, updated SharePoint library.

Used MS Access, VBA, Excel, Salesforce, SQL Server, Cognos, Clickview for data analysis, reporting.

Gathered business requirements to assist with IT solutions.

Provided simple solutions to complex user issues through analysis and report development.

Facilitated meetings with IT support and users to solve complex software integration issues with mainframes.

Provided solutions to open tickets in support of users, resolved issues and closed tickets.

Automated reports by integrating Access, Excel and VBA, reports updated weekly with the click of a button.

Created source to target mapping documentation with table names column names, criteria and transformation.

Updated report procedure documents as well as SharePoint reports and objects.

Tested new reports to ensure compliance with requirements.

Created Functional Specification Documents (FSD) by outlining the functionality and features that will be supported by the system.

Updated report procedure documents as well as SharePoint reports and objects.

UAT Tested new reports to ensure compliance with Business Requirement Document (BRD).

METRICS REPORTING ANALYST

Wells Fargo, NC (Contract assignment – Matrix – Remote Position) 7/13 - 10/13

Streamlined and automated monthly reporting metrics for team.

Created easy to use Excel templates with complex formulas and functions.

Created MS Access database with advanced query functions, VBA coding to import data with the click of a button, Integrated MS Access Database with Excel using MS Query, advanced functions and formulas, charts, graphs, pivot tables.

Compiled data from multiple sources into easy-to-consume and understand online views of the data published to SharePoint.

Wrote T-SQL queries using Microsoft SQL Server 2012 and created reports using SSRS.

Significantly simplified existing reporting processes, worked with NPPI Data.

Streamlined and automated monthly reporting metrics for management team by creating an MS Access database with advanced query functions and VBA coding that imported millions of rows of data into the database with the click of a button. Integrated this MS Access Database with Excel using MS Query, advanced functions and formulas, charts, graphs, pivot tables. To create report and update this report monthly with the click of a button.

Gathered business requirements

Conducted Business Analysis

Analyzed and manipulated large data sets

Responsible for QA testing.

Created Field Mapping documentation.

BUSINESS ANALYST/DATA ANALYST

Synchronoss Technologies at AT&T, Atlanta, GA (Remote Position) 2/13 – 5/13

Responsible for writing business requirements, user documents and report mock ups.

Using Business Objects, Cognos, Excel, MS Access, PowerPoint, Word, Oxygen XML Editor, SVN file manager.

Validated enhancements using Oracle SQL Developer, SQL, PL/SQL queries.

Built MS Access database with ODBC connection to the data warehouse.

Performed data analysis, ad hoc reports, queries, metrics, charts and graphs in Excel, created PowerPoint content, data lineage, metadata, and mapping.

Worked closely with project managers and team to convey requirements to developers for large scale

data analytics project.

Validated UAT test cases and submitted change requests to team of developers.

Responsible for weekly reports and ad hoc reports for both internal and external customers.

Used advanced functions and functions derive summaries and dashboards

Created charts, graphs, pivot tables and charts.

Used various functions and formulas to create reports.

Gathered business requirements

Conducted Business Analysis

Analyzed and manipulated large data sets, worked with NPPI Data.

Responsible for QA testing.

Created field mapping documentation.

BUSINESS ANALYST/DATA ANALYST 10/12 – 2/13

Bank of America, Tucker, GA (Contract assignment – Solomon Edwards)

• Gathered requirements from end users, designed and built reporting solutions to capture and manage

production data for 103 file reviewers, worked with NPPI Data.

• Used Freddie Mac and Fannie Mae mortgage data to create various metrics, reporting and statistics.

• Improved efficiency of data collection and reporting. Before joining this project, a team member was receiving

53 emails every day to consolidate, summarize and report to management.

• Integrated MS Outlook with MS Access to collect data through email, data captured was automatically imported into

MS Access database from Outlook inbox.

• Developed, built and maintained 2 MS Access databases to collect and manage data and reporting.

• Developed ad hoc reports and queries in MS Access. Created MS Access queries to report on weekly production,

production numbers available with a click of a button.

• Wrote a business case in PowerPoint to explain the need for SharePoint to centralize reporting, SharePoint Team

site was approved.

• Built and maintained SharePoint 2007 Team site. Integrated MS Access with SharePoint, linked MS Access tables

to SharePoint lists for more efficient data collection.

• Created VBA Macros in Excel.

• Used T-SQL to write and edit queries in Microsoft SQL Server 2012 and SSRS.

• Used SQL to write and edit queries in MS Access.

• Used MS Project to create Gantt Charts for mortgage look back project.

• Trained end users how to enter their production data on SharePoint lists and created a user guide.

• Gathered business requirements.

• Conducted business analysis.

• Analyzed and manipulated large data sets.

• Responsible for QA Testing.

DATABASE ANALYST 6/12 – 9/12

Comcast, Atlanta, GA (Contract Assignment - Randstad)

• Retrieved large data sets from User Base, developed MS Access databases, ad hoc reports and queries. .

• Used MS Access, MS Excel, V-Look Ups, Pivot tables and charts, MS PowerPoint, MS Outlook, MS Communicator and User Base to perform responsibilities.

• Coordinated with billing system Managers and support staff to clean up duplicate billing system user IDs in billing systems and User Base, worked with NPPI Data.

• Provided status updates on projects to Sr. Director of Information Technology and Sr. Director of Customer Service Operations.

• Participated in frequent conference calls with regions regarding User Base clean up phases.

• Cleaned and imported data into UserBase to correct duplicate data from regions.

Gathered business requirements

Conducted business analysis

Analyzed and manipulated large data sets

Responsible for QA testing, data lineage, metadata, and mapping.

Created field mapping documentation.

REVENUE ASSURANCE ANALYST 7/11 – 6/12

Allconnect, Atlanta, GA

Supported the business with data analysis and report development using Sales and Marketing Data in SAP Business Objects Business Intelligence (BI), Crystal Reports, Oracle Toad, PL/SQL, MS Access, MS Excel, MS PowerPoint, MS Outlook, Pivot Tables, V-Look Ups, charts, graphs.

Developed and automated reporting. Self-taught SAP Business Objects Business Intelligence (BI), improved efficiency and accuracy of daily reporting of Breakage metrics and monthly Revenue Reporting for over 40 partners.

Worked with IT Dept. to implement requirements for BI Universes to support the business.

Created charts, graphs and PowerPoint presentations for financial reviews and meetings.

Participated in cross functional projects and problems as needed.

Reviewed contracts to ensure compliance with billing rates and partners obligations.

Supported billing team with payment reconciliation and invoice auditing, worked with NPPI Data.

Created financial model templates for monthly billing using formulas and functions.

Gathered business requirements

Conducted Business Analysis

Analyzed and manipulated large data sets

Responsible for QA testing.

CORP. REPORTING ANALYST 11/10 – 7/11

UPS, Atlanta, GA

Supported Global, Enterprise and Strategic Management with web based decision tools and data reporting.

Used Business Objects, MS Access, MS Excel, MS PowerPoint, MS Outlook, Pivot Tables, V-Look Ups, SharePoint, Web Based proprietary databases, data warehouse to perform data analysis and advanced reporting functions.

Generated sales reports and created various ad hoc reports as needed using Sales, Marketing and NPPI data.

Prepared PowerPoint presentations and managed sales databases.

Solved business problems related to decision tools and reporting.

Developed MS Access Database for Sales Operations Department.

INSURANCE AGENT 8/09 – 8/10

Bankers Life and Casualty Company, Greenville, SC

Top Producer South East Region, worked with NPPI Data.

Won “NAS” award, wrote 51.5 applications in 1st 90 days.

Won 1st and 2nd place in “Winners Edge” Sales Contest.

Became part of Management team, trained and managed a team of 8 agents.

Earned CLTC designation certification.

Won 2 sales awards for beating my own best record in 2 quarterly sales cycles.

Became expert telephone prospector and trained new agents how to use the telephone to conduct business and cold call, used web based lead system to generate reports, mailings and advertising using Sales and Marketing Data.

Licensed Insurance Agent in 4 states SC, GA, NY, CA.

DATA REPORTING ANALYST 10/07 – 8/09

GE Energy, Greenville, SC (Contract Assignment – Adecco)

Responsible for data analysis and reporting to Management. Used Business Objects, MS Access, MS Excel, MS PowerPoint, MS Outlook, MS Visio, SharePoint, Pivot Tables, V-Look Ups, data warehouse, MapPoint, Support Central and advanced reporting functions to develop and manage data reporting.

Created correlation and regression statistical analyses in MS Excel on the relationship that crude oil prices have on other oil commodities.

Created Excel spreadsheet analyses to track spend by business units.

Created and maintained SharePoint website for centralized team information sharing.

Developed MS Access databases for team reporting enabling users to retrieve data metrics at the click of a button.

Arranged technical on-site training for 150 GE Engineers.

Responsible for all aspects of planning, managing and coordinating the Mechanical Design Fundamentals Technical Training Program for GE Engineers, worked with NPPI Data.

Managed and maintained student databases, website content, lecture materials, schedules and workflow forms.

Created advanced charts and graphs to analyze data and measure correlation between crude oil prices have on other oil commodities.

Gathered business requirements

Conducted Business Analysis

Analyzed and manipulated large data sets

Responsible for QA testing.

DATA ANALYST 8/05 – 8/07

Electrolux, Anderson, SC

Responsible for data analysis and reporting of product line performance to engineering teams and Management.

Extracted large data sets from Microsoft SQL Server, AS/400 and used MS Access, MS Excel, MS PowerPoint, Louts Notes, MS Word, MS Visio, to extract, analyze, manipulate and present data findings.

Created root cause analyses, histograms to determine cause of quality and performance issues.

Presented data findings in graphs, charts, pivot tables, pivot charts and PowerPoint presentations.

Created data analysis presentations for weekly meetings, created org charts and diagrams in MS Visio.

Created a faster more efficient method for tracking trial runs using MS Access Select Queries.

Successfully coordinated QES Training for 20 employees.

Became Quality Evaluation System (QES) database expert, self-taught proprietary database systems and reporting capabilities, worked with NPPI Data.

Won 2nd place in global PowerPoint competition – created a PowerPoint presentation for the manufacturing/Quality Team to Present to annual summit in Italy.

Extracted data from various databases to create ad hoc, weekly and monthly reports.

Imported monthly data from AS400 to SQL server using MS Access as a front end interface.

ADMINISTRATIVE ASSISTANT 7/03 – 7/05

Whittaker Controls, North Hollywood, CA

Senior Administrative Assistant to Plant Manager Senior Management Team.

Responsible for all aspects of managing day-to-day operations of executive office.

Performed data analysis and created reporting using MS Access, MS Excel, MS PowerPoint, Data Warehouse, JD Edwards to create and manage data reporting projects.

Created correspondence, technical manuals, Excel spreadsheets, graphs and charts, PowerPoint presentations, MS Visio org charts and diagrams.

Improved speed and efficiency of financial reporting, reducing 2 days of data manipulation to 2 minutes.

Coordinated executive travel, managed executive calendar, handled logistics of meetings, high profile customer visits and other special in-plant events.

Simplified the budgeting process, reduced several weeks’ worth of manual data extraction and manipulation to minutes.

Worked with IT Dept. to create more efficient processes for accurate data collection and reporting.

Conducted internet research for government contract opportunities and won the NASA Deep Space Cable contract for the Jupiter Icy Moon Orbiter (JIMO) Program.

ADMINISTRATIVE ASSISTANT 7/02 - 7/03

Hersch & Company, Los Angeles, CA

Responsible for all aspects of managing day-to-day operations of executive offices.

Provided high-level executive assistance and administrative support to 3 General Partners.

Used MS Excel, MS Word, MS PowerPoint, MS Outlook and web based programs.

Managed executive calendars and handled logistics of meetings and conference calls, coordinated travel and conducted internet research for special projects.

ADMINISTRATIVE ASSISTANT

BFC Mortgage Corp., Los Angeles, CA 6/01 – 6/02

Responsible for managing office operations, provided administrative support to the President and Vice President.

Assisted with the mortgage loan process

Used MS Excel, MS Word, MS PowerPoint, MS Outlook and web based programs to create mass mailings to solicit business using Sales and Marketing Data

Prepared correspondence, spreadsheets, established workflow for daily operations and created central filing system.

EXECUTIVE ASSISTANT 1/99 – 5/01

Salomon Smith Barney, Los Angeles, CA

Provided executive assistance and administrative support to 8 Financial Consultants.

Provided client services, used proprietary software to manage client accounts

Generated various reports for clients

Created correspondence, MS Excel spreadsheets, MS Word, MS PowerPoint, MS Outlook, client mailings and day-to-day administrative tasks.

Contact this candidate