Ken Keller

Rochester, VT ***** 412-***-**** ad4nl5@r.postjobfree.com

Innovative, solutions-focused, and analytical professional with extensive experience in database development, data warehousing, project management, web development, technical documentation, and report development. PROFILE

● Knowledgeable in implementation of diverse processes, including SIIS, backup and disaster recovery, and scripting languages.

● Broad exposure to developing, migrating, and integrating databases using comprehensive knowledge of SQL scripts, stored procedures, and triggers.

● Experienced with Data Analysis, Data Modeling and Database Design

● Skilled in communicating with end-users to understand their business needs and challenges, translate requirements into user-friendly applications, and provide personalized solutions for technical issues resolution.

● Proven track record of success in leading multi-disciplinary teams to manage and deliver complex web development and data transition projects within strict deadlines.

● Proficient in utilizing multiple programming languages and object-oriented concepts to design and develop network-centric applications including C#.Net, ASP.Net, Javascript, JQuery, JSON, XML, CSS with HTML

● Experienced with WCF framework in API implementations

● Quality-focused and compliance-driven individual, capable of developing robust QA testing requirements in line with company and industry standards.

● Skilled in handling technical documentation, including user guides, programming guidelines, and client specifications

● Experienced with Agile development process and with leadership and mentorship role on projects

● Knowledge of AWS implementations for databases including SQL Server and Oracle PROFESSIONAL BACKGROUND

ASK Real Estate Technology, LLC. 1/2018 to 9/2023

SSIS Developer Dayton, OH

Developed and implemented large-scale ETL process using SSIS and SQL Server for weekly data imports. Oversaw database administration activities, such as maintaining log shipping processes and regularly scheduling database and log backups for 200+ databases on multiple clustered server environments. Enhanced system stability and performance by troubleshooting deadlocking and timeout issues.

● QA and Unit-testing of ETL processes

● Minimized data loss and downtime by designing and testing robust disaster recovery processes.

● Boosted database and query performance by identifying inconsistencies and implementing optimal solutions.

● Increased data throughput by setting up Service Broker and synchronizing database processes.

● Recommended best industry practices to maximize data integrity and security.

● Reviewed Javascript, JQuery, and CSS used within ASP.Net application

● Implemented JSON with AJAX for UI updates

● Implemented SQL Messaging Service to improve performance of API processes Oxford IT 8/2015 to 12/2017

SSIS Developer Data Analyst Pittsburgh, PA

Developed large-scale SSIS implementation to transfer legacy systems to SQL Server 2014 and Data Warehouse environment. Collaborated with local and remote developers to drive projects using Agile Scrum methodology. Facilitated executive management in identifying and managing deadlines through regular progress reports.

● Tested SSIS processes on both Oracle 11i and SQL Server 2012 databases within an Agile environment.

● Managed development efforts by utilizing SharePoint BI, Microsoft Teams, and One Note 2016.

● Utilized technical expertise in C#, LINQ, Javascript and XML to develop REST web services.

● Played a key role in designing and implementing QA requirements and data-checking processes to ensure adherence to company standards.

● Assisted junior developers by conducting comprehensive business analysis while ensuring their work complied with coding standards.

Ken Keller Page 2

● Clients: EQT and Western Reserve Group.

Randstad Technologies 7/2014 to 8/2015

Senior SQL Server Data Analyst SSRS Development Pittsburgh, PA Generated financial reports for accounting by utilizing Elite SQL database. Tracked changes across several systems by developing REST web services in ASP.NET.

● Collaborated with cross-functional teams to develop and document data warehouse environment utilized in generating OLAP databases.

● Conducted detailed data analysis to enhance understanding of data, track data anomalies, and ensure data validation for maximum report accuracy.

● Leveraged strong communication skills to communicate with end users with a focus on analyzing business needs and understanding report requirements.

● Combined data from multiple WinSQL databases into a single SQL Server database by working in close collaboration with a large, multi-disciplinary team.

● Clients: K&L Gates and EDMC.

Yoyodyne Data Services 5/2012 to 4/2014

SSIS Developer SQL Server DBA Pittsburgh, PA

Designed and maintained data warehouse, developed SSIS packages, and installed QA server for monthly and yearly reporting, daily data archival, and website testing. Synchronized data to maintain consistency between separate servers by utilizing SQL replication.

● Utilized expertise in ASP.NET and MVC to deliver client analysis reports and develop web services in C# while deploying and maintaining SQL Server Database server with SQL Server 2012.

● Defined and implemented unit-testing requirements for each process

● Leveraged technical skills in SSIS to develop ETL process for new DataMarts.

● Enhanced performance of database queries used by .NET applications and SSRS reports for troubleshooting SSRS reporting by upgrading from SQL server 2008 to 2012.

● Clients: CMMI Institute and KIT Solutions.

Experis 10/2011 to 5/2012

Senior SQL Server DBA .NET Development Pittsburgh, PA Executed Unit Testing plans for data warehouse and defined QA testing requirements by conducting detailed analysis and utilizing strong understanding of web analytics data. Updated and managed DB2 data warehouse.

● Identified discrepancies and implemented optimal updates by performing in-depth analysis of the website developed with ASP.NET, Javascript, JQuery to understand data flow while developing ETIL processes for data integration using SSIS packages.

● Implemented updates to CSS pages on HTML

● Client: Progressive Insurance.

Beacon Hill Technologies 3/2009 to 6/2011

Senior SQL Server DBA Pittsburgh, PA

Facilitated ASP.NET development team by recommending industry-leading practices for database development and enhancement. Designed and recorded development process of disaster recovery plans for databases.

● Prepared 2008 SQL servers in a clustered environment and maintained existing 2005 SQL servers with TDE for all databases.

● Utilized strong technical skills in ASP.NET to develop back-end components for ASP.NET applications.

● Streamlined data by performing standard management duties on SQL server database, such as monitoring daily backups, creating user accounts, and performing performance analysis of database for further improvements.

● Resolved complex issues in processes that interacted with SQL Server database by collaborating with Siebel development team members.

● Used Informatica to develop ETL processes for Oracle database

● Clients: ServiceLink and DelMonte.

EARLY CAREER

Data Analyst Report Developer Armada

Ken Keller Page 3

.NET Developer SQL Server DBA Report Developer Oxford Global Resources EDUCATION AND TRAINING

B.A. Legal Studies Keiser University Ft Lauderdale, FL Udemy AWS Solutions Architect

Public Speaking and Presentation Skills, Dale Carnegie Training Course Wilmington, Delaware Spring LearningC – 64 hour course on SAP BI/BW systems with introduction to Netweaver TECHNICAL SKILLS

SQL Server version 6.0 to 2019, SSRS, SSIS, SSAS, T-SQL, Informatica, TDE, PowerShell, C#.NET, ASP.NET, CSS, VB.Net, Java, JavaScript, JQuery, Oracle PL/SQL, PHP, DB2, MySQL, Jira, XML, AWS, GitHub, JSON, AJAX

Contact this candidate