Cathy Von Elphberg

Experience

• 

  Maxxis Tech Center

  Feb 2002 - Mar 2004

  Assistant Claims Supervisor/Office Manager

  --Initially selected to serve as assistant to the technical director based on demonstrated work performance and dedication.--Arrange reservations for hotels and other traveling needs.--Quickly advanced to active involvement of company's warranty claims department.--Maintain contact with customers, dealers, and distributors regarding warranty related issues.--Ensure the efficient day-to-day running of all business operations and assistance in processing and initial approval for all defective product adjustments.--Assist with HR functions, such as troubleshooting payroll and employee benefits issues.--Handle location's financial matters, including purchase orders, compensation reports, A/P and A/R. --Orders all necessary office supplies and other technical equipment needed for company use.--Implemented and updates all employee training programs, including purchase orders both internal and external customer bases.--Develops department budgetary forecasts to ensure corporate guidelines were met.--Help design and implement company's warranty database using MS Access 2003 with Visual Basic.--Wrote and issued a standard operating procedure manual for use with the new warranty database.--Achievements:---Selected as department's Social Committee Chairperson for third consecutive year. Show less

• 

  Home Capital, Inc.

  Aug 2004 - Apr 2006

  Database Administrator

  --Design reports for each department using MS Access based on both extracted and SQL-based data.--Automate and QA each report to ensure that all reports are accurate and efficient 6 times a day.--Denote every bogus loan file in The Loan Handler, front end system used by the loan officers.--Ensure all data fields have met data integrity standards for use report extraction purposes.--Responsible for organizing 120+ loan officers lead distribution and allocation.--Effectively restores, cancels, and creates all loan files for our system.--Generates bi-monthly revenue reports and commission sheets for the payroll department.--Successfully migrated the company's reporting system to a SQL based environment.--Answers and resolves one-third of all IT Helpdesk tickets.--Assists in all lead allocation procedures for the Vice President of Marketing.--Generates data for the pull-through bonus program for every loan consultant. Show less

• 

  AT&T

  Apr 2006 - Aug 2009

  --Develop and run weekly, monthly, and ad-hoc reports in MS Excel based on multiple SQL/DB systems.--SQL Server database administrator.--Manages RDBMS and Flat File Databases used for reporting.--Mirrors/Replicates old formats of data to new PL SQL server using DTS packages.--Massages data for reporting and analysis.--Uses SQL Query Analyzer to develop queries for reporting in T-SQL.--Prepares members of the group with new software updates or versions. --Links via ODBC from SQL Server, Teradata, Oracle 9i, MS Access to Excel or Access to generate reports using large datasets.--Generate aesthetically pleasing charts and graphs for upper management and officer conferences.--Uses Business Objects 6.5 to develop reports on U-Verse and DSL Direct data--Assists Six Sigma group on many projects regarding reducing invalid helper referrals.--Generates weekly and monthly scorecard summary reports for the field.--Runs backup process for storing and retrieving data.--Find new and inventive methods of data mining by recognizing patterns in behavior.--Design macros in VBA to help automate repetitive report creation manipulation to reduce manual tasks and for error checking.--Achievements:---Received the “Spirit of Service Award” for helping in the creation, development and delivery of the Gold Mining Report.---Helped reduce the Invalid U-Verse Installation Referrals to I&R Project for Six Sigma Show less --Develop and run weekly, monthly, and ad-hoc reports in MS Excel based on multiple SQL/DB systems.--SQL Server database administrator.--Manages RDBMS and Flat File Databases used for reporting.--Mirrors/Replicates old formats of data to new PL SQL server using DTS packages.--Massages data for reporting and analysis.--Uses SQL Query Analyzer to develop queries for reporting in T-SQL.--Prepares members of the group with new software updates or versions.--Links via ODBC from SQL Server, Teradata, MS Access to Excel or Access to generate reports using large datasets.--Generate aesthetically pleasing charts and graphs for upper management and officer conferences.--Assists Six Sigma group on many projects regarding reducing invalid helper referrals.--Runs backup process for storing and retrieving data.--Find new and inventive methods of data mining by recognizing patterns in behavior.--Design macros in VBA to help automate repetitive report creation manipulation to reduce manual tasks and for error checking. Show less

  • Application/SW Development/Support

    Jan 2007 - Aug 2009

  • Technical Consultant, Level 3

    Apr 2006 - Jan 2007
• 

  Kemira

  May 2009 - Oct 2010

  Application Developer

   Gathered requirements from advanced users for design development Created a Project Tracking Reporting System using MS Excel and MS Access for over 70 employees Wrote union queries to combine end user files for reporting and analysis Set links and coded macros between applications to automatically refresh with new data Generated pivot table reports in MS Excel that are connected to an Access backend data repository Upgrading company to a Front End User system in MS Access with user level security Designing end user forms for entering new data and filtering current active projects Creating reports in MS Access for data analysis and time reporting Writing Standard Operating Procedure Manuals for new Project Tracking System Show less

• 

  Stibo

  Aug 2009 - Apr 2010

  VBA Developer

   Works closely with the client, Home Depot, developing a MS Excel based user entry form Corrects errors in code made by previous VBA development teams Set field formatting types based on intranet web upload needs Experience developing code in Microsoft Excel Objects, Forms, and Modules Designs error and validation check macros for consistent and correct data Develops user forms in VBA for multiple selections by the end user (i.e. multiple states, countries, etc.) Uses VBA code to speed up efficiency and processes of the macros and formulas programmed Show less

• 

  Citizens Financial Group

  Nov 2009 - Dec 2009

  Excel/SQL Developer

  Automating Excel reportsLinking SQL Server dynamically to ExcelWriting technical papers on setup of new reporting

• 

  Cbeyond

  Jan 2010 - Jun 2010

  Excel/VBA Developer

   Developing a MS Excel based Service Order Contract form Set field formatting types and data validation Experience developing code in Microsoft Excel Objects, Forms, and Modules Designs error and validation check macros for consistent and correct data Uses VBA code to speed up efficiency and processes of the macros and formulas programmed

• 

  AT&T Mobility

  Feb 2010 - Apr 2010

  Excel Specialist

  - Automated existing reports for 7.2 project upgrading cell sites in the field using MS Access, SQL Server, and MS Excel- Created ODBC linked pivot tables to gather data from sources and publish to charts and graphs

• 

  Schweitzer-Mauduit International

  Apr 2010 - Sept 2010

  Project Administrator

   Designed and built an Issues Tracking database for logging issues associated with the company’s upgrade to Oracle R12. Created user level security for individual user access to the MS Access database in order to track specific entries made by individuals. Codes modules that perform automated routines; such as sending emails to end users when they entered a new issue into the system and to the person that was assigned to the issue. Provided weekly summary reports of progress made to the issues to the R12 Project Team in PowerPoint. Generated monthly forecasts to the CIO to track project spending, costs, and projected spending for the implementation of the R12 Project in MS Excel.  Approved and accrued monthly invoices and statements for other contractors on the project. Acted as the main point of contact for Oracle America for the company for handling and approving invoices for the company. Show less

• 

  AT&T

  Sept 2010 - Oct 2010

  Project/Program Mgmt

  Developed reports in ColdFusion to display SQL Server 2005 data.

• 

  Technisource

  Nov 2010 - Jan 2011

  Senior Project Consultant

   Developed Business Objects Edge Universes, reports, and browsers to fill business intelligence needs for an onsite client Coded macros in VBA for MS Excel to speed up current processes for reporting Visited a client’s site in San Antonio to review requirements for a new project and to present SQL Server 2008 R2 migration options Wrote process flows for the conversion of MS Access 97 databases to a new SQL Server 2008 R2 environment Received training on VB.net for the upgrade of existing applications from USDC written in VB 6.0 Show less

• 

  CIBA Vision

  Feb 2011 - May 2011

  Application Developer

   Developed site visit MS Excel spreadsheets to automate protocol information for research studies using pivot tables and VBA macros. Created and manipulated existed forms for clinical trials using Teleform. Migrated MS Access 97 VBA to be compliant with new MS Access 2007 VBA.

• 

  Care USA

  May 2011 - Jul 2011

  Access DBA
• 

  Project Center

  May 2011 - May 2011

  MS Access DBA / Application Developer
• 

  NCR Corporation

  Jun 2011 - Nov 2012

  CX Senior Analyst

  - Manages the Customer Temperature program which identifies accounts that are between satisfied to those injeopardy by collecting information and data through Sales Force on a monthly basis from 700+ account ownersacross the globe- Updates MS Outlook email distribution lists and group codes for access to Windows Authentication groupsVarious adhoc reporting using data from Sales Force, SQL Server, MS Access 2010, Walker BI in MS Excel- Maintains and manages the SharePoint 2010 server for the teams collaboration and data storage sites- Acted as the Project Manager while overseeing saw the development of an EDBI/SQL Server based datarepository with daily feeds to and from Sales Force- Wrote the business requirements necessary for email work flow automation used in the validation processconfirming Red Alerts with various functional areas (SW, HW, Services, etc.) Show less

• 

  MDI Group

  Nov 2012 - Mar 2013

  Technical Consultant
• 

  TRX

  Mar 2013 - Jan 2014

  Functional Consultant - Managed Reporting

   Utilizes Salesforce.com case management capabilities to assign and handle various BAU client reporting requests Various script changes to queries using an internal query building tool that requires the use of T-SQL and JAVA and MS SQL Enterprise Manager  Coding changes to MS Excel 2003, 2007 and 2010 reports using VBA  Communications with numerous clients to update them on their open requests for change and manages potential scope creep on new requirements Managed new report and various change requests for well over 50 clients Show less

• 

  CompliancePoint

  Feb 2014 - Aug 2014

  Business Analyst

  - Gathered functional requirements from business stake holders - Met with technical resources to identify constraints and options for meeting business requirements - Clarified requirements and answer functional questions for development through meeting various stake holders- Created and submitted user stories for prioritization and inclusion in future development sprints - Served as the owner of new features as they move from analysis to delivery - Provided expertise on usability and organization of user interface elements for web-based / SaaS applications - Created clear, concise and accurate business requirements documentation - Tested all developmental changes in both the Quality Assurance (QA) and Staging server environments to ensure it meets the original specifications Show less

• 

  Connolly, LLC

  Mar 2015 - Apr 2018

  Engineer

  - Leveraged acute technical expertise to collaborate with the current engineer for executing builds and deploying data to production. Streamlined operational processes and executed all six Pittsburgh audits.- Skilfully revised the Macys AP build scripts to match the BASC current standards. Created an Audit Start Up Check List which includes 19 items required for any audit refresh or start up.- Efficiently ran periodic strats for Wakefern as well as built template for Wakefern. Resolved issues regarding the regression of the views behind the follow ups by working with the audit team.- Methodically completed the optimization of refresh builds for five clients. Introduced process improvements and revised audit start up documentation to include new process requirements.- Acquired total of 32000 potentially new contacts for our audit team to review by contacting BASC audit resources. Added additional Decipher screens to the existing Solicitation Tool to facilitate auditors. Show less

• 

  C3 Experiential

  Sept 2018 - now

  C3 Success Manager