SUMMARY:

• 10 years of experience with Data Analysis
• 10 years of experience with Reporting
• 8 years of experience with Financial and Accounting Services
• 5 years of experience with Project Coordination
• 5 years of experience with SharePoint
• Self - starter with the ability to liaison with a broad group of stakeholders
• Excellent with Microsoft Excel, Access queries and reporting
• Excellent Written and Verbal Skills

PROFESSIONAL EXPERIENCE:

Confidential, Greenville, SC

IT Specialist

Responsibilities:

• Use Excel and SQL to research anomalies between medical benefit deductions and elections.
• Use and develop SQL stored procedure, queries and reports.
• Trouble shoot and resolve issues with IT hardware and software.
• Collaborate with account managers, IT personnel and executive management.
• Participate in development meetings and other duties as assigned.
• SQL 2008 r2, SSIS, MS Office with developer settings.

Confidential, Charlotte, NC

Business Data Analyst

Responsibilities:

• Developed a thorough understanding of the Governance and Oversight Framework.
• Developed an understanding of the Center of Excellence Use Cases.
• Created artifacts/documents as assigned, including Business Element Inventory and Metadata Data Lineage.
• Established professional working relationships.
• Other duties as assigned.

Confidential, Charlotte, NC

Data Analyst Contractor

Responsibilities:

• Gather business requirements from other departments and use to create management reports.
• Pull data from a variety of sources and export the data to Excel files.
• Analyze data across reports assuring consistency and accuracy.
• Validate metrics with other data sources, groups and/or departments.
• Coordinate gathering report data with teammates in India and create processes for gathering data.
• Create Pivot charts, Pie Charts, Bar Charts and Tables.
• Integrate data from multiple Excel workbooks into PowerPoint Presentation.
• PolicyWorks, Avant-Garde, MS Office 2013 (Word, Excel, PowerPoint), MS SharePoint 2010.

Confidential, Newberry, SC

Orders Support Team, Data Analys

Responsibilities:

• Prepare daily, weekly and monthly metric reports for management on data stored in TOPS.
• Prepare design documentation and data dictionary for Access database “TOPS”.
• Run reports in SAP for daily download into TOPS. Backup TOPS database.
• Identify weaknesses in database design and propose changes.
• Modify Access 2010 database as approved by DB Team. Design new queries, forms and/or reports.

Confidential, Greenville, SC

Contractor Data Analyst

Responsibilities:

• Automate weekly reports based excel spreadsheets.
• Includes researching requirements, design, coding, testing and QA, documentation (user and developer), performing modifications requested by the business and collaboration with Cincinnati, OH office.
• Development design concept, requirements gathering, code research, documenting (user manual, programmer guide, quick reference sheet),
• Process Improvement, Excel, VBA, Word, internet and user group code research.
• VBA, MS Office 2013 (Excel, Access, Word, PowerPoint), Outlook, Cisco WebEx Connect, GE Forms

Confidential, Greenville, SC

Coordinator Data Warehouse Support

Responsibilities:

• Automate weekly reports based on MicroStrategy produced excel spreadsheets. Includes researching requirements, design, coding, testing and QA, documentation (user and developer) and performing modifications requested by the business.
• Run both standard and adhoc periodic (daily, weekly, etc.) reports in MicroStrategy.
• Teach department staff how to automate reports.
• Development design concept, requirements gathering, code research, documenting (user manual, programmer guide, quick reference sheet), Process Improvement, MicroStrategy (includes iCubes), Excel, VBA, Word, SQL review (underlying MicroStrategy reporting), internet and user group code research, Google and gmail, auto generation of emails through gmail.

Confidential

Senior Data Analyst

Responsibilities:

• Run SQL and Tableau files to pull loss reserves information.
• Design SQL queries to pull data from multiple servers/databases/tables in the data warehouse.
• Created data dictionary and business glossary.
• Build and/or rebuild tables to improve data accuracy.
• Project Coordinator for Recovery project.
• Built use case for auto recovery by gathering business requirements, assessing data sources and creating product to meet the needs for maximizing recovery values on defaulted loans.
• Table and data validation, adhoc reports (report writing), data variance/trending (Tableau), requirements gathering (multiple divisions, same data source), design and/or redesign of tables, process improvement, QA, SQL Server 2008 r2, SQL, T-SQL, Tableau, Excel, Word, Access, PowerPoint, internet and user group code research, Outlook, remote server login, SharePoint, data governance, data management.

Confidential, Greenville, NC

SQL Report Developer

Responsibilities:

• Prepare standard and adhoc reports (report writing) and scripts using SQL Server 2008 r2.
• Analyze database structure. Prepare and maintain data dictionary.
• Requirements gathering, process improvement, SQL Server 2008 r2, SQL, T-SQL, Access, Excel, Word,
• PowerPoint, SharePoint internet and user group code research, remote server login, Remedy, adherence to government standards/policies/procedures, data governance, data management.

Confidential

Knowledge Management

Responsibilities:

• Support establishment & facilitate growth of Communities, to improve performance, innovate, develop & manage Intellectual Capital.
• Work closely with the KM Process Owner to align strategies, share experiences & identify new opportunities for own site/function & others.
• Promote & champion Good Practice process so it is built up, understood & systematically applied.
• Assist KM Process Owner with training service teams on KM best practices & standards.
• Confidential , SharePoint (including creation of SharePoint sites, folders, etc.), member of international cross-development team, Excel, Word, Outlook, PowerPoint, Remedy, FTP, SFTP, VPN, adherence to government standards/policies/procedures, data management.

Confidential, Morrisville, NC

Project Coordinator/Auditor/Business Analyst

Responsibilities:

• Review and analyze construction project drivers, associated costs, purchase approvals and purchase orders, and vendor information to identify quantity and price variances of drivers.
• Cross-train team members, process improvement, quality review of team member work, quality review of packets.
• Swift Track, Oracle, Project Workbench, SharePoint, Excel, Outlook, Office Communicator, SharePoint, data management.

Confidential

Systems Administrator, Data Warehouse Operations

Responsibilities:

• Interact with global management, customers, and competitors.
• Change management control (Project Coordination): Verify release components are present, tested, and ready for release to production.
• Create and modify workflows (In Process Manager (IPM) application), including the analysis of scripts to verify presence of necessary files, tws schedules, and UNIX accounts.
• Monitor server space allocations, request additional storage for new and existing Unix Teradata accounts, maintain capacity storage database (MS Access).
• Create Access databases and applications. Prepare technical documentation on processes and procedures for DWT Operations. Process improvement. Solaris 8, Solaris 10, SAN storage, UNIX, Access, StarTeam, Excel, Word, Outlook, PowerPoint, Chat program (global), Remedy, VBA, FTP, SFTP, VPN, adherence to government standards/policies/procedures, change management.

Confidential, NC

Technical Support Specialist

Responsibilities:

• Tier 3 technical support for clients and consultants with additional interface with sales, development and executive management.
• Research, model, and test new and existing issues, test with virtual machines different database back ends and analyze, debug, and resolve application code, scripts and AutoCAD (connectivity, function and program module).
• Configure and customize CAFM Application.
• Process improvement with customer technical support and with technical research to resolve customer issues.
• Technologies include FoxPro, SQL Server, Oracle, VB, AutoCAD (including version 2007), data governance, data management, Crystal Reports, FM Reports, Outlook, SQL, T-SQL, SalesForce, Excel, Word, DB2, AutoCAD, remote server login.

Confidential

Applications Programmer

Responsibilities:

• Design queries and reports. Project coordination for roll-out and training.
• Test and debug application code. Includes sensitive payroll data.
• Prepare training manuals and documentation. Train field personnel and management on application.
• Customer service liaison with clients, system administrators, and other IT professionals.
• Use of sales/marketing/support software (Sales Force) for tracking client issues and contact information.
• Technologies include SQL, Oracle, VB, Access, Crystal Reports, T-SQL, Excel, Word, PowerPoint, Outlook, code research, data governance and data management.

Confidential

Operations Specialist, Accounting

Responsibilities:

• Confidential, complex insurance remittances. Review and reconcile time sheets and payroll data.
• General Ledger (GL), General Journal (GJ), Accounts Receivable (AR) (on-line medical billing to EDS for Medicaid claims, manual and automated billing for other types of charges).
• Month, quarter and year-end closing procedures and reports.
• Database maintenance, queries, and reports. Coordinate physical changes to computer databases. Use packaged programs MAS90 (ERP) and IRIS.
• Resolve software and hardware problems (PC, laptop, network cards, peripherals, cables, and diagnostics). Occasional server and router/hub support.
• MAS90, IRIS, adhoc reports (PC Works), design of standard reports (PC Works), Excel, Medicaid EDS, Word, PowerPoint, Outlook, router support, hub support, PC/laptop support, remote server login, adherence to government standards/policies/procedures, data management.

Confidential

Data Base Administrative Assistant/Office Administrator

Responsibilities:

• Project management of documentation publications using MS Project.
• Data cleaning (data correction and removal of data duplication).
• Research and resolve pricing variations between web site and internal sales documents.
• Maintain database web administration and time sheet/absence system records.
• UNIX, Word, Excel, PowerPoint, Access, Outlook, UNIX script, FrontPage, html, Intranet department site creation.

Confidential

Project Control Coordinator

Responsibilities:

• Coordinate planning, scheduling and cost control with internal/external cost account managers; develop management reports; input and execute project management software; prepare work schedules, cost estimates, work packages/dictionaries and Work Plan; project performance and cost; and analyze variances in project performance.
• Primavera Project Planner (P3).
• Prepare and revise figures/drawings using AutoCAD and Intergraph Microstation software.
• Prepare site characterization plans and reports for both potential sites of project (documentation).
• Evaluate company processes and recommend improvements for efficiency and economy (Process Improvement Team - PIT).
• Provide secretarial and administrative support to the Site Characterization manger, Site Characterization team, License Application manager, and License Application team.
• Primavera Project Planner (P3), AutoCAD, Microstation Intergraph, Outlook, Word, Excel, PowerPoint, chain-of-custody logging of core samples, government/environmental licensing, adherence to government standards/policies/procedures, plotting, documentation.