Brenda Ackerson

About Brenda Ackerson

I am a Automation ETL Developer specializing in SQL with many years of experience in healthcare insurance and reseach data, and accounting software products such as Viewpoint Construction Software, Sage 300 (formerly Timberline Office Accounting, Project Management & Property Management applications); Protrax, Ajera, QuickBooks, Semaphore, MAS90, Solomon, Great Plains Dynamics and OSAS.I absolutely love working with SQL and ETL tools such as Informatica, SSIS, PowerShell for data extractions or loading data into databases. I have many years of experience with T-SQL developing and maintaining stored procedures and processes for data migration/conversion and extractions. On a regular basis, I have imported and extracted data, written ad-hoc queries and performed data related tasks for client and research projects. And, I was a Report Developer (SSRS, Crystal, Tableau) and have provided technical support work for software companies!Skills: T-SQL, SQL Server Management Studio (SSMS), Informatica, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), DTS, Import/Export Utilities, MS Visual Studio, TFS, SVN, SourceGear Vault, PVCS Tracker, SAS & PROC SQL, Oracle SQL Developer, and Teradata SQL, PowerShell, Python, XML.Reporting Tools: SQL Server Reporting Services (SSRS), Tableau, Power BI, Crystal Reports, MS Access, SAS, Sage Timberline Report Designer, Quickbooks and willing to learn more!Training: Advanced T-SQL, Integration Services (SSIS), MS Reporting Services (SSRS), attended SQL Saturday, SQL PASS SUMMIT, Portland SQL User Group Meetings.Bachelor\'s Degree in Accounting.

Experience

1. Data Platform Developer Iii

   PacificSource Health Plans

   Aug 2023 — Present · OR, US

Education

• University of Akron, School of Business

  Bachelor's degree, Accounting

  1985 — 1990

Skills

• Visual Studio
• Sql
• Visio
• Protrax
• Sql Server Management Studio
• Technical Support
• Microsoft Excel
• Data Conversion
• Ajera
• Ssis
• Ssrs
• Software Implementation
• Integration
• Sas Programming
• Semaphore
• Software Quality Assurance
• Data Analysis
• Data Migration
• Analysis
• T-Sql
• Windows
• Troubleshooting
• Xml
• Database Design
• Viewpoint Construction Software
• Crystal Reports
• Stored Procedures
• Etl
• Accounting
• Crm
• Report Writing
• Microsoft Office
• Microsoft Sql Server
• Quality Assurance
• Project Management
• Access
• Quickbooks
• Software Development
• Sage 300 / Timberline Office / Extended / Ts Gold
• Data Warehousing