Aaron Kempf, Mcitp Sql Server Email & Phone Number

Hood River, Or, Us

Ladrón De Guevara, Jalisco, Mx

• Developed innovative solutions for data rescue, wifi penetration testing, Android security, databases, and web design in a hybrid work environment.• Trained less technical individuals to understand technology, bridging the gap between technical and non-technical teams.

After building dozens of sites with ASP and HTML, I have really settled into using WordPress for many projects. I honestly believe that the WordPress Plugins Repository and Themes Repository are more exciting than the Google Play Store and the Apple Store.I know that not EVERY website needs to use WordPress, but I know about 500 other Php applications and regularly play with Drupal and Joomla. I love trying to learn new things. I use a few different hosted Virtual Private Servers to host websites for a couple of clients, and about a dozen of my own websites. I want to keep growing my infrastructure because I am always discovering new and exciting things at http://reddit.com/r/selfhosted. I really believe that companies, and people should own their own code, their own infrastructure so that they can customize it as they please. For example, right now, I use SQL Server Express to connect mySQL in a few different hosted environments and I produce pretty SQL Server Reporting Services reports against mySQL data. Nobody intended SQL Server Express to connect to external databases for Reporting Services, but it is possible. I've done it in production before also. To be honest, my SECOND favorite Website Builder is a bit obscure, it is called Odoo. Odoo used to be called OpenERP, and the only thing I don't like about it is that the premium version just seems a bit too expensive. I would rather use PostgreSQL than mySql any day of the week, I'm a database guy and writing Stored Procedures and using PostgreSQL is just a FANTASTIC database. And on the programming side, I prefer the Python development of Odoo to the Php development of WordPress. Maybe someday, Odoo will have 60,000 different themes to choose from.

Albuquerque, Nm, Us

• Developed custom browser automation tools using .NET Console Applications to streamline processes.• Implemented SSRS DLL to centralize business logic and improve data reporting efficiency.

Ladrón De Guevara, Jalisco, Mx

• Developed database designs for various small projects using SQL Server, mySQL, and Postgres.• Prototyped and tested Hadoop HortonWorks for data processing efficiency.• Conducted troubleshooting and testing for cPanel and VestaCP to ensure smooth operations.

• Developed ETL processes for storing reporting and performance metrics, enhancing data accuracy and efficiency.• Trained developers and end users on SSAS/Olap, improving data analysis capabilities.• Designed and implemented Datamart for dimensional modeling, optimizing data storage and retrieval.• Automated SSIS/Integration Services tasks, streamlining data integration processes.

• Developed SSIS packages for accounting, billing, and archiving using 3rd party components from 'Pragmatic Works' and 'CodePlex'.• Designed Datamarts and implemented Dimensional Modeling for efficient data storage and retrieval.• Trained 2 developers on SSRS Reporting Services for optimized reporting and troubleshooting.

Bellevue, Washington, Us

• Developed and optimized complex relational database algorithms using SQL Server 2012 and SQLCLR 2.0/4.0.• Led the development, testing, automation, and training of junior DBAs in SSIS/Integration Services at EagleView Technologies.• Implemented SSRS/Reporting Services solutions and SSAS/Analysis Services for prototype reporting applications.

Lacey, Washington, Us

• Developed ETL processes using SQL Server 2005/2008, XML, and Oracle queries for Alliance Enterprises.• Implemented Table Partitioning and Source Control Integration for efficient data management.• Automated ETL processes, resulting in increased efficiency and accuracy in data reporting.• Collaborated with cross-functional teams to design and implement proprietary ETL packages.

• Designed and implemented SSRS reporting services for financial and real estate data with Google Maps integration.• Managed and optimized SQL Server 2008 stored procedures, tables, and indexes for efficient data retrieval.• Administered 15 physical servers, including IIS and SQL Server, ensuring smooth operation and scheduling.

Seattle, Wa, Us

• Developed SQL Server stored procedures, databases, and applications for ABC Legal Services in the Greater Seattle Area.• Implemented address verification software testing and schema design for efficient data management.• Created .NET Console Applications for consuming and sending text messages, enhancing communication capabilities within the company.

Schema Design / Datamart Design / Dimensional Modeling SSAS / Analysis Services-development, queryingSSRS / Reporting Services-developmentSSIS / Integration Services-development, design, maintenanceDesign large solution(s) with minimal supervisionAutomate and improve hundreds of existing database objectsImplement indexing strategiesDevelopment of testing system for finding cross-database inaccuracies

Seattle, Wa, Us

Migrate cubes from SQL Server 2000 to 2006Develop Test Harness to Test Existing Adhoc Reports

Blue Bell, Pennsylvania, Us

SSRS / Reporting Services – development, migration Migrate 120k lines of business logic to SQL Server stored proceduresWrite hundreds of stored proceduresManage Development schedules, develop & implement metadata management solutionDesign complex systems with minimal supervision

Seattle, Washington, Us

Datamart Design / Dimensional Modeling SSAS / Analysis Services – Automation, Troubleshooting, Performance, ConsultingSSRS / Reporting Services 2005, Soft Artisans Office Writer Author TSQL statements against a large schema (800+ tables)

XSLT Development Schema DesignDevOps / Build Automation

Seattle, Wa, Us

Design and develop ETL for retiring legacy bTrieve system.Work with various business owners to understand complex rulesETL scripting solution for parsing of document titles, definitions

SQL Backup / Restore Troubleshoot SQL Locking problemsConfigure / Troubleshoot AS/400 & SQL Server Replication

Seattle, Wa, Us

Sybase Stored ProceduresDevelop reports using Crystal Reports, Access, VB6

Seattle, Wa, Us

SSAS / Analysis Services-Development, Optimization, Design, Troubleshooting, AutomationSSAS / Analysis Services-Manage performance and availability for 15 Servers SSAS / Analysis Services-metadata reporting, collection & analysisSSAS / Analysis Services-Develop PerfMon collection + reporting solution to track performance over timeDTS Automation solution for importing 10,000 Performance Monitor filesConfigure security roles / mappings, Assign Permissions, Manage DNS cNamesTroubleshoot connectivity problems-2005 x64, DB2, TeraData, OWCDevelop administration utilities using VBS, XMLA and VB 2005ETL / log reporting system

Seattle, Wa, Us

SSRS / Reporting Services-Development, Configuration and ImplementationClassic ASP / VbScript-development, debugging & implementation SSAS / Analysis Services-Development, Optimization, Design, Troubleshooting, AutomationDTS AutomationMDX Queries and Optimization

Redmond, Washington, Us

SSAS / Analysis Services-Development, Optimization, Design, Troubleshooting, AutomationClassic ASP / VbScript-development, debugging & implementation VB.net, VB6, ASP, DHTML development SQL Server Modeling, Automation, Relational Design

Redmond, Washington, Us

Parse log files, build database automation procedures, automate work flow, etcSSRS / Reporting Services testing, exploration and recommendationFind errors in scripts (batch, MSI Installers, Database DDL)Datamart Design / Dimensional Modeling Parse ASP.net error logs for production MSN systems in order to investigate problemsTest for accuracy and consistency of complex stored procedures

Access Development / VBA / Database Design

Redmond, Washington, Us

Intrusion Detection / Log Analysis. VLDB, Datamart, DTS Automatation, Implementation of Analysis Services databases (dozens).Classic ASP / VbScript-design, development, debugging & implementation SSAS / Analysis Services – Automation, Troubleshooting, PerformanceDTS Automation-Scripting, Troubleshooting, Screen-ScrapingDatamart Design / Dimensional Modeling SSAS / Analysis Services – Training developers SSAS / Analysis Services – Training End-UsersSQL Server Job Scheduling, troubleshooting and optimization

Bellevue, Wa, Us

Schema Design / Datamart Design / Dimensional Modeling SSAS / Analysis Services development-databases, queries, data marts and reportsDTS Automation-development, design, automation, shaping, job workflow/schedulingClassic ASP / VbScript – developmentOffice Web Components, Excel Pivot Tables, VB6, XML, MDX

Hoffman Estates, Il, Us

Migrate 100s of Access Queries to SQL Server Stored ProceduresRe-write 100 Access Reports as Crystal Reports, deploy into Crystal EnterpriseClassic ASP / VbScript-development, debugging & implementation

Us

Crystal Reports 8.5 – Report Development, Testing, MigrationsVB / SQL CRM DevelopmentClassic ASP / VbScript-development, debugging & implementationETL / screen-scraping applicationDatamart Design / Dimensional Modeling

Belmont, California, Us

Developed and optimized custom databases, reports & applications ETL Automation-Importing data from AS400 / DB2 VB6 Optimization, Troubleshooting and Implementation

Migration of large system from Access to SQL Server.Migration of business logic from Jet Queries to SQL Server Stored ProceudresMigration of forms from Accesss/Jet to Access Data Projects

Schema DesignDeveloped Reporting & Data Entry Solutions for ERP, CRM, General Ledger, Auditing and Sales Developed & maintained SQL Server and Microsoft Access Databases, Applications and ReportsDeveloped Enterprise Information System for reporting on a dozen data feedsSQL Server-Stored ProceduresAccess Development, MaintenanceAccess to SQL MigrationsSSAS / Analysis Services – Development / Prototypes for Mission-Critical EIS / DSS

Access Queries, Reports Oracle ReportingWebTrends IIS Log Analysis

Us

Collected and audited spoken data for the testing of Voice Recognition softwareDemonstrated Project Management principles in keeping project ahead of schedule

Us

Created Licensing Inventory Spreadsheets to analyze the licensing needs of clientsAuthored corporate naming conventions / standards for Goldmine CRM data entryAuthored Excel VBA that enabled the automation of repetitive tasks Data Consolidation

Us

Wrote 100s of Access Queries to improve the quality of bug reportsSearched for bugs and worked in a team environment in order to determine the accuracy of bug reports

Mis, Accounting, Econ, Polisci, Speechcomm

Mcitp, Database Administrator Sql 2005

Sql Server, Computer Programming

Management Information Systems, Generall Studies

Diploma, Advanced Calculus, College/University Preparatory And Advanced High School/Secondary Diploma Program

Oracle, Oracle Business Intelligence

Javascript Introduction

Php Intermediate

Audit, Computer Science - Java

Vocational, Introduction Java

Vocational, Intermediate Java