Jonathan Im Email & Phone Number

Clients: Defense Health Agency (DHA)• Maintaining and supporting Carepoint/DSS tools and applications running SQL Server/Visual Studio• Interfacing with other MDS/MIDES/HIS team members to determine design approaches and resolve issues• Tuning Carepoint/DSS tools to continuously achieve optimum levels of performance• Analyzing and evaluating existing systems, to define problems, data availability, report requirements, system design, and program specifications.• Processed ad hoc data requests and data-analysis services for Air Force Surgeon General Directorate and Action Officers utilizing data obtained from a variety of sources including the M2 repository, MDR feeds, CHCS ad hocs, ODS, AFCHIPS, CareMart, HSDW, Teradata and Amazon Redshift.• Leading and supporting DoD/VA tool that provides program analysis insight into information/analytical support for DoD/VA healthcare planning and potential medical resource sharing activities. • Developing complex analytic reports using advanced Excel tools, including pivot tables• Writing scripts for automating Access database applications in support of client needs• Specific experience developing applications using MS Visual Studio (SSIS, SSRS, and Etc.), Business Objects XI Suite (Web Intelligence, Crystal Reports, Xcelsius), Excel PowerPivot, Tableau, JavaScript, HTML, ASP, and CGI

Falls Church, Virginia, United States

Clients: TRICARE Operations Centers (TOC) for TRICARE Management Activity (TMA), Office of Assistant Secretary of Defense/Health Affairs (OASD/HA)• Lead and guide team members with migrating/configuring all existing systems to MS SQL Server 2008, BusinessObjects XI R3, and CrystalReports 2008 environment.• Maintain and Support large-scale systems within TRICARE Operations Center. • Developed various tools/applications using BO XI R2, Visual Basic, MS Access, SAS, and MS SQL Server 2000/2005/2008.• Interface with other team leads to determine design approaches and resolve issues.• Lead and guide team members with migrating existing systems from MS Access and SAS to MS SQL Server 2000/2005/2008, BusinessObjects XI R2 environment.• Possess the ability to collect relevant information to thoroughly understand and document the scope of work required as well as assess, organize, plan, and schedule the efforts required to successfully complete projects/tasks.• Provide clients with prototypes and proofs-of-concept solutions to meet their needs. • Interface with other team members to determine design approaches and resolve issues. • Guide team members with systems designs and specifications.• Monitor and tune the systems in TOC to achieve an optimum level of performance.• Perform software installations and upgrades to operating systems and layered software packages and maintain them in accordance with established policies and procedures.• Lead team members to obtain MHS IA DITSCAP/DIACAP Accreditation.

Tysons Corner, Virginia, United States

• Develop various client applications using Visual Basic, MS Access, and MS SQL Server 7/2000. • Administer workstations, and servers for user support and Troubleshoot LAN and WAN problems.• Work with a wide range of Internet technologies and applications including MS IIS, Apache, HTML, Flash, JSP, ASP, VB Script, XML, and more. • Provide MS SQL Servers 7/2000 Administration.• Provides systems analysis and administration for web-based applications. • Installations and upgrade to Windows NT, Windows 2000 Servers, and workstations.• Perform software installations and upgrades to operating systems and layered software packages and maintain them in accordance with established policies and procedures.• Provide pre-sales/post-sales technical support for the Convera suite of Products (RetrievalWare, ScreeningRoom, Internet Spider, FileRoom, CD Express and etc). • Work closely with direct sales to educate prospective customers about the superiority of Convera's solution. • Handle the installation of our product and provide training to our customers.• Work closely with R&D and Product Management to be closely involved with future product direction and strategy providing valuable input from the field.• Demonstrate Convera’s software capabilities, install evaluation software at client sites, and represent Convera at tradeshows. • Develop and deliver responses to clients’ technical inquiries, including RFPs and RFIs.• Provide clients with prototypes and proofs-of-concept solutions to meet their needs. • Guide clients with infrastructure design pertaining to Convera products.• Manage large-scale Convera products implementation, integration, deployment, and upgrade projects as Professional Service Consultant and Systems Engineer.• Possess the ability to collect relevant information to thoroughly understand and document the scope of work required as well as assess, organize, plan, and schedule the efforts required to successfully complete projects/tasks.

Tysons Corner, Virginia, United States

Clients: Directorate for Personnel and Security (P&S) at Army Material Command Building (AMC)• Provide Oracle, Omnis, and MS Access database administration.• Monitor and tune the systems to achieve an optimum level of performance.• Guide team members with database designs and specifications.• Develop and maintain procedures in establishing an Oracle database configuration management and backup and recovery plans. • Develop and maintain procedures for migrating and/or enhancing any current platforms to the HP platforms.• Develop a process for implementing content and structure changes for the Oracle database. • Utilize ERwin CASE Tool to perform database administration functions including user access, identifying changes in entity and relationship, modifying tables and attributes, and generating a data dictionary and database.• Interface with other team leads to determine design approaches and resolve issues. Office of Secretary of Defense (OSD)• Develop a new database schema for the modernized Adjudications Facility Tracking System 2 • (AFTS 2). • Develop modernized AFTS 2 using Visual Basic and Oracle database. • Maintain, administer, and support AFTS 2.National Guard Bureau (NGB)• Lead and guide team members with database design and developed Site and Cost Business Model database for National Guard Bureau. • Database Quality and Assurance testing.• Enhancement suggestions to enhance functionality for future releases.

Master'S Degree, Information Systems

Bachelor Of Applied Science - Basc, Management Information Systems, General