Theresa Phillips Cavanaugh
Senior System Analyst at InterFlex Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
InterFlex Group
-
United States
-
Packaging and Containers Manufacturing
-
100 - 200 Employee
-
Senior System Analyst
-
Nov 2015 - Present
Design, build and test programs, applications, reports and dashboards across all existing ERP and Financial systems. Utilize SQL Server Reporting tools (SSRS, SSIS, SSAS), Crystal Reports, Exact Macola(ERP) and Wisys Agility(WMS/Shipping) to develop companywide processes, applications and reports. Analyze SQL database, processing applications and programs to maximize performance and efficiency. Responsible for testing of new/updated applications. Provide production system support for ERP applications, WMS/Shipping applications , database issues and performance, and data quality issues Modify/create reports, stored procedures, tables and views in SQL Server. Show less
-
-
-
DataMasters
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior System Analyst
-
Nov 2014 - Nov 2015
INTERFLEX GROUP – SQL DEVELOPER MAY 2015- NOV 2015 Design, build and test reports and dashboards across all existing ERP and Financial systems. Utilize SQL Server Reporting tools (SSRS, SSIS, SSAS), Crystal Reports, Exact Macola (ERP) and Wisys Agility(WMS/Shipping) to develop companywide processes and reports. Provide system support for ERP applications, WMS/Shipping applications, database issues and performance, and data quality issues Modify/create reports, stored procedures, tables, and views. WELLS FARGO – SYSTEMS ENGINEER NOV 2014 – MAY 2015 Lead testing efforts for the ETL/data warehouse team. Specifically, testing Informatica ETL packages. Write and execute test scripts and plans for data warehouse processes. Utilize SQL scripts to validate data loaded from ETL packages. Work with developers and business analysts to identify system defects and resolve technical issues FLOW AUTOMOTIVE – SQL DEVELOPER APR 2012 - MAY 2016 Develop and execute SQL queries for the marketing department for use in direct mail and e-mail campaigns. Validate and cleanse data before uploading to marketing tools. Show less
-
-
-
LPL Financial
-
United States
-
Financial Services
-
700 & Above Employee
-
Senior Systems Analyst
-
2012 - 2014
Provide real-time analysis and monitoring of production processes. Includes troubleshooting stored procedures, ETL packages, SQL agent queries and large data sets. Ensure concise and timely completion of business processes to ensure business critical systems are available to enterprise wide users. Provide support and act as the focal point for production issues. This includes modifying procedures, programs or data to resolve defects quickly and efficiently. Escalate issues to the appropriate resources, when necessary, to ensure proper resolution and communication. Perform analysis of new and existing program/processes to ensure processing performance is optimized and efficient. Assist in the testing of new applications. Provide training and support to newer team members and data center operators. Show less
-
-
-
Wake Forest University
-
United States
-
Higher Education
-
700 & Above Employee
-
DATA/REPORTING ANALYST
-
2011 - 2012
Responsible for executing, developing, enhancing and maintaining reports for University Advancement. Used knowledge of reporting tools, relational data structure, desktop applications and business drivers to create actionable analysis of information. Developed SQL programs/queries to create a wide variety of complex, ad-hoc reporting segments; work closely with end-users to determine actual information needs and apply reporting tools. Designed and implemented a Dashboard Reporting system to meet the needs of University Advancement. Created functional reporting specifications and define technical reporting specifications. Document and test reports. Partnered with central IS resources on the development of data warehouse design and information framework design. Show less
-
-
-
Performance Group
-
Winston-Salem,NC
-
Equities Analyst/Trader
-
2006 - 2011
Managed an on-line equities trading account. Researched financial and economic data in order to identify long and short term trading opportunities. Created a daily trading plan and execute trades based on risk and profitability. Maintained a database of stocks and indices to trigger alerts when trading parameters are reached. Responsible for maintaining all financial records and documentation relating to the trading account. Managed an on-line equities trading account. Researched financial and economic data in order to identify long and short term trading opportunities. Created a daily trading plan and execute trades based on risk and profitability. Maintained a database of stocks and indices to trigger alerts when trading parameters are reached. Responsible for maintaining all financial records and documentation relating to the trading account.
-
-
-
-
Consultant
-
2004 - 2006
Responsible for the development and design of company wide reporting used for financial, sales and CRM analysis at an outside Client site. Developed Business Intelligence reporting for company wide users. This included gathering requirements from business users and writing software specifications. Responsible for the maintenance of existing reporting, including problem solving and user support at all levels, including the user and software security. Additional responsibilities included testing of company wide reports along with providing documentation and user training. Show less
-
-
-
-
Data Warehouse Administrator
-
2003 - 2004
Responsible for the development and maintenance of a data warehouse used for company-wide financial and sales reporting. Developed and maintained ETL scripts to populate the data warehouse with production system data. Gathered user requirements and developed detailed specifications for the data warehouse. Responsible for the implementation and development of a Business Intelligence reporting system. Designed, developed and tested all company wide BI reporting. This included user documentation and training. Show less
-
-
-
-
Director of Database Marketing
-
2002 - 2003
Responsible for directing all phases of design, development and implementation of a data warehouse to be used for marketing and sales analysis. Responsible for development and deployment of Cognos Business Intelligence tools to internal and external user community. Responsible for assessing and making recommendations to Senior Management on Business Intelligence reporting tools. Accountable for the planning and execution of direct mail marketing campaigns with an annual budget of $3 million Managed the relationship between Senior Management, the Information Technology staff and an outside consulting firm Show less
-
-
Education
-
University of North Carolina at Charlotte
Bachelor of Arts (B.A.), Mathematics