KERRY C. KNIGHT

ad25o3@r.postjobfree.com

760-***-**** (HP)

SUMMARY:

I have more than 20 years of technical and analytical experience along with about 18 years managing technical staff. My core duties include application development, project management, data warehousing, data management, logical and physical data modeling, database design (including performance analysis and tuning), analytics and managing the use of 3rd party tools. Since many of our applications involve research and financial related processes, I also represented the Jacobs School of Engineering and the Altman Clinical Center on a number of corresponding committees. I also collaborated with the EVC’s office to build applications used across Academic Affairs as well as building API’s which allows some of our applications to communicate and update other applications as needed, thus minimizing our user base from having to utilize multiple apps to accomplish the same tasks.

EXPERIENCE:

UC Health Sciences, Altman Clinical and Translational Research Institute (ACTRI)

10/2021 – 05/2023 Manager, Biomedical Informatics Services

Manage staff in order to work with tools such as REDCap, Velos, Epic, AWS and other tools in order to support our customer base.

Building reports using Python which extracts data from Oracle and SQL Server databases.

Develop calendars, data collection forms, budgets and other tools tied to clinical trials

UC San Diego, Jacobs School of Engineering

04/10 – 10/21 Manager, Business Application Development & Web Services

•Manage application development, database support and analytics for the Jacobs School of Engineering and various divisions across campus. This includes gathering requirements, designing, building, testing and deploying Java, PHP, ColdFusion and Perl based solutions on Linux platforms using the Kanban project management methodology. All applications support functional areas including fiscal / research, student affairs, human resources and academic personnel.

•Explore and implement new technologies, methodologies and standards which allows for the rapid development of complex applications, easier infrastructure maintenance along with increased application quality and performance.

•Responsible for the maintenance of our local database which supports all application development. This entails creating data models, tables, triggers, stored procedures, and ETLs.

•Manage content management systems along with static and dynamic websites which supports over 90 departments and ORU’s across campus and within Jacobs School.

•Work with the system administrator team to configure servers which supports application and web site development.

•Collaborate with various divisions and the EVC’s office to develop applications and provide services that are utilized across campus.

•Coordinate activities by scheduling work assignments, setting priorities, and directing staff.

•Create standards and policies regarding data security, documenting procedures and processes, creating test scenarios, and providing customer training.

•Write performance reviews, hire and mentor staff.

•Conduct presentations to various groups.

HSBC, San Diego, CA

04/08 – 4/10 Director, Management Information Systems and Data Warehousing

•Responsible for leading and managing a team of 12 developers (including offshore personnel) that developed and supported web based applications, BI reports and an Oracle data warehouse.

•Hands-on application development, which included creating and installing ETL processes and web based solutions using technologies such as Cognos, Actuate, DataStage, SAS, PHP, Perl Visual Basic and ASP.Net on various platforms such as Unix, Windows and Mainframe.

•Built both logical and physical models that supported Oracle and SQL Server databases.

•Designed and developed parallel processing ETL applications which increased performance and efficiency.

•Served on executive committees for strategic planning purposes.

•Provided departmental project management duties and reported the status of projects to upper management and clients.

•Responsible for managing a $2M budget.

•Defined and implemented best practices and procedures for application development.

•Ensured that the department was prepared for annual audits and developed business continuity plans.

•Set security standards for system and database access.

•Used the OSI Model to determine and resolve system configuration issues.

•Communicated with peers to identify common business intelligence needs and leveraged solutions across the organization.

•Successfully managed the technical aspects of a $5B merger deal with one of our competitors.

•Managed the purchasing, implementation and maintenance of ERP related applications which involved documenting specifications, evaluating various tools, providing proof of concept, and finally implementing, testing and managing selected products.

•Wrote performance reviews and goals, set priorities and objectives, hired and coached staff, and worked with the business areas to set priorities when assigning projects and determining workload.

12/03 - 4/08 Manager, Management Information Systems

•Managed the design and development of web based applications and reports on Unix, Windows and Mainframe platforms using the project life cycle to support the marketing, product management and sales departments. This included working with customers to determine requirements, designing and implementing applications, setting up milestone / schedules, assigning projects to staff, monitoring progress, working with staff to develop test plans, training end users, managing UAT, etc.

•Saved the company $1.5M by designing, developing and maintaining a Customer Relationship Management portal. This process pulled data from disparate sources into one system, providing users up-to-date profiles for each customer.

•Built a web based queuing system which allowed credit officers to focus their attention on customers whose loan requests had a higher probability of getting funded.

•Worked with the business areas at all levels to devise the best solutions for their technical and analytical needs.

•Installed and maintained MySQL and Apache servers that supported all web applications which received over 10K hits per day in total.

•Identified 3rd party vendor data that was relevant to the business, and devised technical solutions to warehouse the data for analytical and BI purposes.

•Created standards for coding and documentation, which included requirements, design, quality assurance and production support documents.

•Worked in conjunction with other IT groups within the company to share resources and knowledge.

•Provided statistical analysis on various research requests.

•Trained staff on writing efficient code and interpreting data.

•Provided network and basic hardware support.

•Wrote performance reviews, coach staff, determine budget and work with the business areas to set priorities when assigning projects and determining workload.

Federal Home Loan Mortgage Corporation (Freddie Mac), McLean, VA

4/02 – 12/03 Sr. Technical Analyst / Team Manager

•Managed a data warehouse and application development team which developed Java applications as well as Perl, PHP, SAS, C and DataStage ETL and reporting processes on Unix and Mainframe platforms.

•Worked with DBAs through the logical and physical modeling stages to ensure the accuracy of the data marts.

•Created and enforced standards for coding and documentation, which included gathering requirements, design, and quality assurance and production support documents.

•Trained the business community on how to use data warehousing tools and reports.

•Managed all projects through the project life cycle development process.

•Wrote performance reviews, coached staff, managed budget and worked with the business areas to set priorities when assigning projects and determining workload.

America OnLine, Dulles, VA

6/96 – 3/02 Sr. Software Engineer / Project Lead

•Project lead for the development of C, Perl, PHP and SAS ETL and reporting based systems on Unix platforms which tracked member and purchase activity across all AOL products.

•Created a data warehouse and data marts involving 20-30 gigs of data loaded per day from various sources.

•Managed all projects through the project life cycle development process.

•Met with business units to develop clear and concise requirement documents.

•Provided proof of concept on various software products. Coached and trained staff.

SKILLS: Languages: Java, Perl, C, PHP, ColdFusion, HTML5, PHP, SAS, SQL, VB and Shell Programming

Operating Systems: Linux, Unix, Windows and IBM MVS Mainframe

BI Tools: Cognos, Tableau and Actuate

Frameworks: Spring MVC

DB Servers: DB2, MySQL, Oracle, SQL Server and Sybase

Other: Ajax/JSON, AWS, CSS, DataStage, Drupal 7/8, Eclipse IDE, Git, Google Apps and Cloud Services and jQuery

EDUCATION: Masters in Business Administration - Florida Institute of Technology

G.P.A. - 4.0

B.S. Degree in Finance - Virginia Polytechnic Institute & State University

Contact this candidate