Jonathan Ricks Email & Phone Number

Hampton Roads, Virginia Metropolitan Area

• Design, develop and maintain business intelligence solutions• Translate business needs to technical specifications• Design, build and deploy BI solutions (e.g. reporting tools)• Maintain and support data analytics platforms (e.g. MicroStrategy)• Create tools to store data (e.g. OLAP cubes)• Conduct unit testing and troubleshooting• Evaluate and improve existing BI systems• Collaborate with teams to integrate systems• Create visualizations and reports for requested projects• Proven experience as a BI Developer and/or Data Scientist • Design data warehouse (e.g. dimensional modeling) and data mining• Demonstrate in-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework• Demonstrate in-depth understanding of BI technologies (e.g. Microsoft Power BI, Oracle BI)• Demonstrate in-depth understanding of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

Newport News, Virginia, United States

• Oversee the deployment of data to the data warehouse.• Develop BI deliverables using Microsoft development environments (i.e. SSRS, SSIS, SSAS, PowerBI, C#, etc.).• Develop technical related documentation for the BI deliverables (i.e. design documents, instructional documents).• Coordinate and facilitate design reviews with our business users and analysts.• Ensure compliance with configuration management standards and guidelines (i.e. Version control, release management).• Report and track all BI testing processes and software related issues.• Provide functionality updates to key personnel on new BI releases and general enhancements.• Serve as liaison between the helpdesk, systems administrators, systems analysts, and business users.• Troubleshoot technical applications problems and coordinates resolution of problems with other support groups.• Obtain regular processing reports to check for errors, assess/analyze errors and distinguishes between databases, application and customized application problems.• Assist with developing strategy for the installation and testing of major releases.• Perform testing on all fixes provided for application and abide by the SDLC process for promoting code through the various environments.• Work with IT to perform software and hardware deployments/upgrades.• Ensure proper documentation for Data Warehouse systems.• Provide technical support for interfaces (troubleshoot and resolve any interface issues).• Develop and design end-user training and training materials.

Newport News, Virginia, United States

• Analyze, design, develop, implement, test, maintain and troubleshoot server, database, software programs, and applications.• Applies knowledge of applications, databases and operating systems to research and provide direction and/or resolution for applications, databases or technical problems as identified by clients. • Assist in implementing patch releases, deployment test cycles and creation/review of release notes.• Develops software solutions and increase knowledge by studying information needs, conferring with users, studying system flow, studying data usage and work processes, investigating problem areas, studying state-of-the-art development tools, following the software development, and learning numerous system specifications.• Manage the life cycle of problems from problem identification, through root cause analysis, to the completion of associated remediation tasks of problems resulting from incidents in the production.• Maintain an accurate record of activities using office tools, reports and incident management software.• Develop technical documentation and user manuals.• Work independently and make self-directed decisions but also work in a team environment and take direction.• Train new colleagues, clients, and perform other related duties as assigned.• Participate in 24/7 shift rotation as part of a Quick Incident Response Team.

Newport News, Virginia, United States

• Write, edit, debug, and review code. • Modify existing programs with enhancements. Implement fixes and enhancements.• Provide front-line software support to corporate associates.• Managed system security and user profiles.• Troubleshoot and develop technical solutions related to company software and setup errors.• Create workaround procedures when standard procedures have failed and ensure issues are resolved in a timely fashion.• Facilitate the Incident Management process in determining root cause of issues.• Communicate business functions to programmers and technology restraints to non-technical business managers.• Demonstrate superb understanding of system design methodology.• Comply with defined Information Technology Infrastructure Library (ITIL) processes.• Demonstrate a high level of creative thinking in troubleshooting techniques.• Demonstrate leadership skills by training junior level associates, mentoring new support associates, and interviewing perspective support candidates.• Demonstrate Subject Matter Expertise for Knowledge Base of the Company’s management system.