Brett Shepard Email & Phone Number

Atlanta, In, Us

Indianapolis, Indiana, United States

Automation of Quarterly Reporting to Business Solution's customers saving 2-3 days work per reportDevelop comprehensive clinic satisfaction and loyalty survey reporting packageProcess biometric screening results providing summary reports on participant eligibility and feeding result sets to 3rd party providersAssessment of external vendors for Clinical Data Analytics and HRA assessment and reportingAutomate data transfers to and from 3rd party providersBuild Microsoft SQL Server 2017 database structure back end

Shepard International provides an environment for individuals seeking a career in personal entrepreneurship by leveraging the influence of social networking.We partner with business-minded people seeking to obtain economic independence by capitalizing on the current economic trends. Most individuals see the trends in E-Commerce and Social Commerce but are mere observers to this wave of business. We provide the partnerships, mentoring, and the tools necessary to participate in and profit from these business trends.

Indianapolis, Indiana Area

- Migrated Microsoft Access database to a Microsoft SQL 2008R2 Database Server back-end to facilitate growth from 15 to over 50 users.- Added significant data validation processes to database front-end.- Eliminated numerous longstanding bugs from the database front-end.- Tied together disparate processes within the database to simplify workflow for end-users.Improved and streamlined reporting, migrating from Excel based queries to stored procedures and functions.- Extended database functionality to enable peer- and manager-review of work to facilitate training of new employees.- Transitioned database processes from Access queries to stored procedures and functions in preparation for migrating from a Microsoft Access-based to web-based front-end.

Responsible for design and development of study specification documents leading up to the development of a clinical studyWork with Study Development Team, including doctors, statisticians and regulatory compliance representatives to determine data collection needsDevelop Electronic Case Report Forms and program edit checks for multiple studies simultaneouslyAssemble and approve design documentation for third-party development team.Liaison between GSK and external vendors to manage development of InForm web-based data collection systems.

Continuing work for Eli Lilly as part of a new outsourcing agreement.Responsible for designing, developing, implementing and validating systems solutions in support of nearly a dozen clinical trialsAutomated significant portions of the trial specification build process, saving 4-6 days per study.Assemble and approve design documentation for third-party development team.Liaison between i3 and external vendors to manage development of InForm and Clintrial web-based data collection systems.

Responsible for designing, developing, implementing and validating systems solutions in support of nearly a dozen clinical trialsTook on responsibility of maintaining and trouble shooting CRF logging system for legacy paper-based trials. Work with Study Development Team, including doctors, statisticians and regulatory compliance representatives to determine data collection needsAssemble and approve design documentation for third-party development team.Liaison between Lilly and external vendors to manage development of InForm and Clintrial web-based data collection systems.

Assigned to Eli Lilly and Company as a Data Management AnalystResponsible for designing, developing, implementing and validating systems solutions in support of nearly a dozen clinical trialsWork with Study Development Team, including doctors, statisticians and regulatory compliance representatives to determine data collection needsAssemble and approve design documentation for third-party development team.Liaison between Lilly and external vendors to manage development of InForm and Clintrial web-based data collection systems.

Developed password management & reset application.Helped to streamline & update billing systems from SQL-Windows/Sybase to Delphi/Oracle based systems.Project design with IBM Rational Rose.

Sole responsibility for development, maintenance and trouble-shooting of daily production of most correspondence from Office of Admissions.Migration of end-user reporting for Office of Admissions, Office of Student Financial Aid, and Vice-Chancellor of Student Services from in-house developed legacy mainframe system to PeopleSoft.Automation of Student Orientation Management system from labor intense manual tracking of new students to automated database updates, reporting and invitations.Automation of Student ID tracking system from manual data entry to automated lookup including integration with QuickWorks/IDWorks from DataCard.All tasks require extensive communication with non-technical end-users to design & implement solutions accessing data residing in Oracle & Microsoft Access data bases using a combination of ODBC & ADO.

Replacement of old job scheduling system saved 1000 man-hours per year in maintenance and trouble shooting.Allowed automation of projects on Windows NT/2000, Unix & AS/400 as well as integration with mainframe scheduling packages.Extensive programming PL/SQL and COBOL, scripting in Korn shell for Unix and WinBatch for Windows, as well as support of Windows 95, 98, NT and 2000 and some Unix support.Took over three projects from consultants and saw them through to completion.Responsible for analysis, design, coding, testing, implementation and documentation of new data mart project, oversaw staff of three in development of this project.Lead technical integration of acquired administration system into corporate environment.Lead upgrade of environment through two versions, including conversion from Novell to Unix platform.

Developed bank statement system capable of accepting text input from multiple, mainframe-based host processing systems for printing with check images on Windows NT-based network. Extensive work in Delphi and Visual Basic, with some COBOL and proprietary languagesRedesigned internal support systems to include contact management, project management, software auditing and billing.Remote and on-site installation of bank document handling hardware and software.

Developed project tracking system for mainframe and client/server based systems.Recommended and implemented end-user reporting system.Developed auditing system for electronic premium payment system.Training in and use of Magic.

Developed voice response system integrating third-party hardware and software running under OS/2 with client/server system running under DOS.Lead the integration of a third-party hypertext help system and conversion of existing printed documentation to on-line format.Evaluated development tools and draft purchasing recommendations.Supported conversion to from Realia to MicroFocus COBOL.Improved and maintain in-house data dictionary.Extensive COBOL programming experience, as well as Novell 3.x experience.