Jeffrey — database analyst

Some of my achievements in this role consisted of: I successfully facilitated migration of a comprehensive in-house ClientTrack application system to the SQL Azure and cloud-based ClientTrack 2015. I conceptualized and created SSRS implementation for the CMS Psychosocial Assessment Report consisting of a 12-page report with 628 checkbox fields and 130 text fields

In this role, I planned and delivered onsite Microsoft SQL Server DBA and SQL Developer support services to reinforce a small non-profit organization responsible for coordinating healthcare and social services for HIV and AIDS patients. Some of my achievements in this role consisted of: ● I successfully facilitated migration of a comprehensive in-house ClientTrack application system to the SQL Azure and cloud-based ClientTrack 2015. ● I conceptualized and created SSRS implementation for the CMS Psychosocial Assessment Report consisting of a 12-page report with 628 checkbox fields and 130 text fields.

As a Sybase DBA Consultant and IBM Contractor, I delivered valued remote Sybase production DBA support and assistance as well as product support for the following: Sybase ASE, IQ, Replication Server, and SQL Anywhere products. Some of my achievements in this role consisted of: ● I skillfully utilized my outstanding script design skills to create and write 3 Perl programs to perform an index audit of 24876 index DDLs; and Korn Shell and cmd.exe scripts to integrate IBM Blue Care monitoring software into the customer's Replication Server, Sybase IQ and Adaptive Server Anywhere production server estates. ● I improved performance by auditing 40 user databases on a Sybase production instance in addition to managing Sybase RDBMS migration feasibility for selected applications. ● I closely tracked track performance and configuration changes of a clustered and mirrored production SQL Anywhere 12.x application system by organizing and constructing an SQL Anywhere database repository.

As a member of the Global Markets DBA team, I delivered Sybase production DBA support services and primary DBA support services to the Markets Derivatives group in Latin America, Asia, Australia, Canada and the United States. Some of my achievements in this role consisted of: ● I drove marked improvement in productivity by creating and implementing a reporting mechanism to effectively extract, parse, and convert database instance vulnerability assessment data embedded in PDF files into XML files. ● I conducted in-depth data analysis to generate reports on database and filesystem growth.