Bill Bishop Email & Phone Number

Morrisville, North Carolina, United States

* Resource allocation management and software development oversight working with other Development managers, Project Management Office and Product Owners.* Provide career guidance and mentoring of direct reports.* Foster, shepherd and lead efforts to design and implement software by coordinating review of software design.* Design/architect and/or review/approve database schema for customer facing analysis and data management projects.* Create and/or foster the use and adoption of databases in Q2 operations using best practices to achieve timely design and implementation and use to provide value to the Q2 Genomics business.* Creation and management of a common database source code repository (SQL, PL/SQL, scripts, etc.) which provides for reuse of PL/SQL functions, procedure, packages and scripts across all projects leveraging database use.* Cross team/project mentor/resource for all efforts to use databases to persist/store data/information.* Establishing standards for database schema design and deployment (tools, scripting, utilities, etc.)* Responsible for configuration and maintenance of 15 AWS Oracle RDS Database Instances for (Production, Software Verification Test, Automated Testing, UAT and Development) instances host from 1 to 10 schemas which support various internal and client facing software projects (assays and operational systems). * Oracle database technical Subject Matter Expert (SME) on database use. * Filled role of Technical Coordinator for Analysis Delivery Management System (ADMS) project briefly. Responsible for guidance of (technical) software development for project, technical point of contact for development and fostering/encouraging informed team decision making in a timely fashion.* Apply formal software engineering methodologies to develop solutions in a timely manner.* Troubleshoot problems, provide workarounds and develop patches to sofware and systems.

Technical Subject Matter Expert (SME) for (Oracle) database operations at Q2 EA working to establish/develop standards/guidelines for the design, programming/development of schema(s) and instances within Oracle databases. • Establishing standards for database schema design and deployment (tools, scripting, utilities, etc.)• Briefly served as Technical (Lead) Coordinator for development of the Analysis Management and Delivery Management System (ADMS) which is the workflow engine and monitor for sample genome sequencing analysis and results delivery to clients.• Creation and management of a common database source code repository (SQL, PL/SQL, scripts, etc.) which provides for reuse of PL/SQL functions, procedure, packages and scripts across all projects leveraging database use.• Cross team/project mentor/resource for all efforts to use databases to persist/store data/information.• Presenting series of “Tech Talks” on databases (“what, where, how, why”, data modeling, implementation/uses at Q2, deployment and coding standards, scripting, etc.)

Mclean, Virginia, Us

Senior Consultant delivering database administration, management and development specific Information Technology services to Attain's scientific, research, environmental and health based clients in the public sector. Currently providing services on the NETS III contract for the National Institute of Environmental Health Sciences (NIEHS) as Database Admin and on the Environmental Inventory System (EIS) contract for the EPA as Application Database Admin.

Hanover, Md, Us

Provided database design and implementation expertise to the refactoring/redesign and implementation of the EPA's Emissions Inventory System (EIS) database. Skills and tools: Database analysis, SQL performance tuning, Oracle 11g, Oracle PL/SQL, Oracle SQL Developer, Oracle SQL Developer Data Modeler, TOAD, Git, Eclipse, JIRA, Confluence, BitBucket, SourceTree and Agile - Scrum.

King Of Prussia, Pa, Us

Managed and directed the technical development of several Quantum Sales Tax releases, the Central Software Digital Signature Initiatives, and QA regression testing tools and configuration management software for the Quantum software product suite. I also have served as guest lecturer and training leader in several capacities.

Maintained and upgraded the Shoppes of Bedford retail area website.

Bloomfield, Ct, Us

Spearheaded the development of electronic data interchanges interfaces for a disability management integrated claims management system. Analyzed customer requirements for interfaces, then worked with customers, account managers, database architects, support personnel, and management to implement standard interfaces and as required architected custom interfaces per customer specifications. Guided the design and implementation of new ICMS Employee Demographic Interfaces for employee payroll information from and to the PeopleSoft human resources system.

Burlington, Nj, Us

Supported the sales transaction database. Developed reports and systems supporting the overall operations of the sales audit, loss prevention, marketing, and accounting departments. Designed and implemented a coupon redemption tracking application.

Hamilton, New Jersey, Us

Maintained database tables and data. Resolved problems regarding client/server and web-based applications. Guided necessary upgrades.

Designed and implemented websites for clients, guiding projects from start to finish.

Duluth, Ga, Us

Designed, constructed and maintained a back office management system for the company’s proprietary MediaHawk video on-demand hardware/software solution. Designed, developed and support tools and utilities managing user database access for the video on-demand back office application. Created and maintained applications managing television and movie programming data. Configured data storage and manipulation processes. Maintained video on-demand replication applications. Regularly updated key web-based and client/server reporting applications.

Reston, Va, Us

Led a project team of eight developers and domain experts who developed vital modules of web-based knowledge discovery database business intelligence applications using the Rational Unified process for analysis and object-oriented development methodologies. Closely worked with developers to resolve issues and provide technical assistance to them. Planned projects, formulated functional and technical specifications, executed coding, testing, and hands-on supervision. Created enhancements to modules of BANNER finance software as functional and technical team leader. Coordinated unit testing efforts and delivered data reports. Supervised and trained four developers, evaluated performances, and provided career development assistance.

Warwick, New York, Us

Provided superior technical support to Passport language clients, primarily developers, via telephone and email. Performed production software distribution and administration. Engaged in pre-sales activities at tradeshows that represented the company, performing demonstrations.

Burlington, Nj, Us

Supervised a team of programmers and analysts, overseeing the construction of new order entry applications using Oracle Developer 2000 tool set, along with PL/SQL, Oracle Case, Sequent, and others. Led another team of programmers and analysts in the successful design and implementation of client-server inventory location-tracking application for multiple sites. Trained and mentored team members.

Delft, Zuid-Holland, Nl

Developed and maintained warehouse inventory systems and sales forecasting systems using Oracle RDBMS, Oracle Forms, Oracle Reports, Pro Pascal, and DCL.

Boston, Ma, Us

Maintained communications system software for the U.S. Navy’s Trident submarine using CMS-2Q assembly language.

Blue Bell, Pennsylvania, Us

Maintained the sono-bouy tracking and command/control software systems for the U.S. Navy’s PC3-Orion aircraft using CMS2-Y assembly language.