Uploaded File
add photo
Theresa
tpace1@gmail.com
281-250-8799
Tampa, FL 33619
Financial Specialist
11 years experience W2
0
Recommendations
Average rating
23
Profile views
Summary

Computer ExperIENCE

  • RDMS: SQL Server 2012, Oracle, MS Access 2016, FileMaker Pro, Advanced Revelations, Bentley LCS, Teradata
  • Reporting: SharePoint Power View, BW, Insight 2014, Power BI, Spotfire, SSRS, SQL
  • Software: MS Office 2016, Visual Studio 2010, Visual SourceSafe, TFS, WinForms, SharePoint 2010, InfoPath 2010, JDE, SAP, Toad, Power Apps, ServiceNow, UltiPro, DB Visualizer, SSMS, SSIS, Documentum, Excel Power Pivot, Excel Analysis

Experience
Financial Specialist
Banking/Financial
Sep 2017 - Jun 2020
Temple Terrace, FL
  • Employed in the Finance Accounting Systems support group designing, upgrading, testing, and maintaining, databases that perform a variety of accounting functions and tasks, including reporting and visualizations
  • Created processes in VBA, SAP scripting interface to improve user performance and reliability, in addition to batch file scripting, all to assist with process automation
  • Created Power BI presentations and SSRS reporting for sales, finance, accounting, tax and payroll data
  • Importing source files through SSIS and BCP transfers, and HANA interface through SQL Server for large datasets
  • Created new SQL databases with procedures, triggers and functions
  • A few projects that provided cost savings were configuration of third party systems, data validation for state tax reporting, creating W2s text file imports and exports, and projects requiring outside consulting were done internally, in addition to SAP scripting
No skills were added
Remove Skill
Developer
Information Technology
Jul 2016 - Sep 2017
Tampa, FL
  • Develop MS Office tools for various projects and upgraded and testing existing tools that captured field personnel time, including upgrades for operating systems and office platforms
  • Part of team for major systems design modifications and worked with the data migration and validation of personnel data to SuccessFactors, from many sources, including Ultipro
  • Project and task tracking done in ServiceNow
SAP SuccessFactors ServiceNow Servicenow Developer
Remove Skill
Business Analyst
Information Technology
May 2016 - Jul 2016
Tampa, FL

(Contract for Chase)

  • Contract project at Chase to review and audit PL/SQL queries using Toad for data migration in Oracle
Business Analysis SQL TOAD
Remove Skill
Data Analyst
Apr 2015 - Jan 2016
Houston, TX
  • Designed and created a Benefit Accounting database to handle several monthly reporting tasks
  • In development, many issues were identified and diagnosed and as a result, additional reporting was developed and improved data accuracy covering financial accounting of employee benefits
  • Created VBA modules to run functions for importing, exporting, processing and maintaining data in Excel and MS Access, in addition to complicated calculations and queries due to many manual processes and sources
  • Developed additional tools in Excel for LOA tracking and budget analysis and used VBA to improve user functionality, including Word notification letters
  • Projects that provided cost savings included reducing reporting from 40+ to 4 reports to obtain same output which reduced labor hours
Data Analysis Microsoft Excel
Remove Skill
Data Analyst/Developer
Information Technology
Mar 2014 - Apr 2015
Houston, TX
(Contract for Baker Hughes International)
  • Responsible for designing/developing, and testing a database and tools for HSE data reporting
  • Created and setup SQL Server 2012 tables, procedures, data types, indexes, and triggers
  • Created scripts for nightly script and macro functions, including backup of databases
  • Created VBA modules to run functions for importing, exporting, processing and maintaining data tools interfaced with SQL Server using ADO objects, in addition to SAP scripts to export data from SAP
Data Analysis Database Backups SAP SQL SQL Server Triggers
Remove Skill
Developer
Information Technology
Sep 2013 - Mar 2014
Houston, TX
  • Modified and upgraded Excel charting and analytical tools used in benchmarking of oil and gas products
  • Part of the team charged with transitioning the current benchmarking application to VB.Net platform
  • Processed and modified Oracle queries related to benchmarking calculations
Oracle
Remove Skill
Software Engineer
Information Technology
Jun 2012 - Jul 2013
Houston, TX
  • Performed data technology tasks in the IHS equipment parts division which migrated and cleansed parts data for clients
  • Loaded, modified and exported client data in SQL Server and Oracle via several methods, such as text files, MS Access, and linked servers
  • Designed and created SQL Server procedures and scripts for improvement of data migration and reporting
  • Created functions to find hierarchy and user information through LDAP queries, in addition to views and scripts for BCP exports
  • Prepared data for deliverables to client in various formats, including Maximo and SAP compatible layout using VBA and T-SQL
  • Analyzed data to ensure data integrity
  • Tested new version software, tools and applications
Data Migration LDAP Oracle Software Engineer SQL SQL Server T-SQL
Remove Skill
Data Analyst/Developer
Information Technology
Nov 2010 - Jun 2012
Houston, TX

(Contract for Baker Hughes International)

  • Designed and developed a Program Management resources/cost MS Access database to interface with several sources
  • Created and setup SQL Server 2005 tables, procedures, data types, indexes, and triggers
  • Created scripts for nightly backup of tables
  • Designed and created VBA modules to run functions for importing, exporting, processing and maintaining data. Interfaces with the Program Management database were MS Project, Excel, Word (export), in addition to SQL Server using ADO objects
  • Designed and created tool for pulling Calendar data from Outlook
  • Created tools and reports for metrics reporting in Excel and Power View
  • Setup of External Content Types in SharePoint Designer for SQL Server data displayed in SharePoint List formats
  • Created InfoPath Forms using VSTA C#
  • Designed and implemented complicated project review forms with three tier sub-forms
  • Calculations and other considerations required since database used in international and US platforms
C# Data Analysis Database Backups Microsoft Excel MS SharePoint SQL SQL Server Triggers
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Computer and Information Science
FLORIDA STATE UNIVERSITY, Tallahassee, FL 2005
Minor: 2005, GPA: 3.5/4.0
Associate's in Arts, General Studies
TALLAHASSEE COMMUNITY COLLEGE, Tallahassee, FL 2001
Minor: 2001, GPA: 3.5/4.0
Skills
Data Analysis
2016
3
SQL
2016
3
SQL Server
2015
3
Database Backups
2015
2
Microsoft Excel
2016
2
Triggers
2015
2
C#
2012
1
Data Migration
2013
1
LDAP
2013
1
MS SharePoint
2012
1
Oracle
2014
1
SAP
2015
1
SAP SuccessFactors
2017
1
ServiceNow
2017
1
Servicenow Developer
2017
1
Software Engineer
2013
1
T-SQL
2013
1
Business Analysis
2016
1
TOAD
2016
1