William Bishop
(215) 453-7703 • (610) 256-0413 • bix@bixsite.com
Highly talented and accomplished IT professional with extensive skills in Applications Development and Project Management. Proven ability to design, implement, and support innovative technical applications. Expertise in applications development, database design and implementation, and project coordination. Adept at planning, personnel supervision, client relations, and software lifecycle development direction. Knowledgeable in wide variety of development languages and tools, award-winning background in project management. Able to bridge the gap between technical and non-technical persons. Excellent presentation and communication skills.
Operating
Systems: Windows 98/NT/2000/XP,
VAX VMS, Sun OS, UNIX
Development Tools: Oracle Discoverer, Oracle Developer
2000, Oracle Pro*C, Oracle Forms, Oracle PL/SQL, Oracle Designer, Oracle
Application Server, HTML, Photoshop, Pascal, Perl, Visual C++, C, JavaScript,
HomeSite, ODBC, Passport, Java, style sheets, Object Oriented Analysis and
Design, JSP, DCL, Fortran, Crystal Reports
Applications: MS Office, Project, SQL
Server, SQL Server Transact SQL, SQL Navigator, AutoPlan, Erwin, TOAD, SQL
Server Enterprise Manager
Hardware: PCs, Sequent, Silicon
Graphics, Sun Sparc, DEC VAX, NCD, VT2000
CIGNA, Philadelphia, PA 11/2004 – Present
Applications
Development Senior Specialist
·
Lead
developer in a team of four responsible for design and implementation of
Electronic Data Interchange (EDI) interfaces for the Disability Management
Integrated Claims Management System (DM ICMS). Providing analysis of customer requirements for interfaces,
working with customers, account managers, database architects, support
personnel, and management to implement CIGNA’s standard interfaces and as
required architect custom interfaces according to customer specifications.
·
Development
and support of EDI interfaces for the (DM ICMS) in Oracle v8.x & v10g
databases using SQL Navigator, PL/SQL, TOAD, SQL Plus, Unix Shell scripting,
Oracle PL/SQL, & Perl. Provide
primary knowledge of Oracle PL/SQL for port of EDI interfaces to Oracle PL/SQL
from RDB db on Open VMS w/DCL scripting.
Principally responsible for development of PL/SQL intake and extract
interface development and Unix/Perl script for job control and monitoring and
logging.
·
One
of two senior developers providing technical analysis of functional
requirements and implementation estimates for EDI interfaces to Account
Managers for enhancements to existing customer functionality as well as for new
customer implementations.
·
Project
technical lead for design and implementation of new ICMS employee demographic
intake and payroll extract interfaces that will receive employee information
from and provide payroll information to CIGNA’s implementation of the
Peoplesoft HR system.
Burlington Coat Factory, Burlington, NJ 2/2004 – 11/2004
Senior
Software Developer
·
Providing
support for sales transaction database while developing reports and systems
which support the operations of the Sales Audit, Loss Prevention, Marketing,
and Accounting departments using Oracle Discoverer, SQL Navigator, PL/SQL, SQL
Plus, Oracle DBMS v8 & v9, Unix Shell scripting, FTP, and GPG. Designed and implemented Coupon Redemption
Tracking application using Oracle Forms 6i, Oracle Reports 6i, SQL Navigator,
Oracle Designer, PL/SQL, SQL Plus, Oracle DBMS v8 & v9.
Buda Consulting, Princeton, NJ 9/2003 – 2/2004
·
Providing
maintenance for client database tables and data, problem solving and
client/server and web-based application support and upgrades using SQL, PL/SQL,
Oracle v8i, Oracle Developer 2000, VMS, TOAD, Fortran, and DCL.
Concurrent Computer
Corporation,
Chalfont, PA 9/2000
– 5/2003
·
Performed
large majority of design, construction, and maintenance for backoffice
management system of company’s Video on Demand
(VOD) system. Utilized Oracle
Developer 2000 IDE, Perl, SQL Server, TOAD, and Oracle 8i databases via ODBC.
·
Authored
and supported Perl tools and utilities to manage user database access and
backoffice system screens.
·
Developed
and maintained applications that managed television and movie programming data
and configured data storage and manipulation processes using C++, ODBC, and
SQL.
·
Carried
out maintenance of VOD data replication applications using C++, PL/SQL, SQL,
and Oracle 8i and SQL Server databases.
·
Maintained
key web-based and client/server reporting applications, using Crystal Reports,
JSP, and HTML.
Webmanor, Incorporated, Philadelphia, PA 5/2000
– 2/2004
·
Design
and implementation of websites using HTML, Adobe Photoshop, JavaScript, and
HomeSite.
Systems and Computer
Technology (SCT) Corporation, Malvern, PA
5/1997 – 9/2000
Team
Leader/Sr. Project Lead (1998 – 2000)
·
Co-managed
project team of eight developers and domain experts responsible for developing
vital module of web-based Knowledge Discovery Database (KDD) business
intelligence application, using Rational Unified process for analysis and
object-oriented development methodologies.
The team compiled requirements using Use Cases and traditional analysis
methods.
·
Coordinated
developers in creating web-based product demos using HTML, JavaScript, and
style sheets.
·
Led
project involving utilization of multiple database technologies to upload
information from databases using MS VB to MS Excel spreadsheets via ODBC.
·
Performed
project planning, formulated functional and technical specifications, carried
out coding, testing, and hands-on supervision.
Served as liaison to developers, resolving issues and providing technical
assistance.
·
Functional
/ Technical Lead for project to create enhancements to web modules of BANNER
finance software. Coordinated unit
testing efforts and delivered data reports.
·
Supervised
four developers in addition to project duties.
Conducted training, evaluated performance, and provided career
development assistance.
Sr. Project Lead (1997 – 1998)
·
One
of eight Project Leads / Project Managers responsible for directing 20-month,
60-developer/analyst, $8 million BANNER Finance software creation project.
·
Personally
led 12-person developer and business analyst team, managing functional and
technical efforts to produce major enhancements to Purchasing module and
prepare system for production release.
·
Recognized
for achieving fewest quality issue increases in entire BANNER Education Systems
suite.
·
Provided
technical and functional assistance to development organization and other
groups, facilitating project efforts.
Passport Corporation, Jenkintown, PA 10/1995 – 4/1997
·
Provided
technical support to Passport language clients (developers) via telephone and
email.
·
Carried
out production software distribution administration, participated in pre-sales
activities at trade shows, representing company and performing demonstrations.
·
Designed,
developed, and implemented software enhancements to meet client specifications.
Burlington Coat Factory, Burlington, NJ 3/1993 – 10/1995
Team Lead /
Project Leader (1994 – 1995)
·
Coordinated
team of eight programmer / analysts and oversaw construction of new order entry
application, using Oracle Developer 2000 tool set, as well as PL/SQL, Oracle
Case, Sequent, and more.
·
Carried
out staff training and mentoring.
Project Leader (1993 – 1994)
·
Supervised
six programmer / analysts in successful design and implementation of
client-server inventory location-tracking application for multiple sites.
·
Played
major role in creation of corporate GUI development standards.
·
Delivered
presentation on Integration of Oracle Forms and Oracle Graphics at Oracle
International User Week.
Sr. Programmer
/ Analyst (1993)
·
Actively
involved in design and development of Oracle interfaces to real-time
merchandise sorting systems. Performed
over 30% of project’s interface programming, using Pro*C.
·
Served
as Project Lead for upgrade of distribution center application front-end system
to Oracle Forms v3.0 and SQL*Menu.
Applications
Engineer,
IKEA N.A. Services, Inc., Plymouth Meeting, PA (9/1988 – 2/1993)
Software
Engineer,
General Electric Corporation, Camden, NJ (10/1987 – 9/1988)
Software
Engineer,
Defense Systems Div., Unisys Corp., Warminster, PA (7/1986 – 10/1987)
Certificate in
Web Development, Penn State University, Great Valley, PA (2000)
BBA in
Computer and Information Sciences, Temple University, Philadelphia, PA (1986)
Outstanding
Achievement Award as Team Leader, 2000
Outstanding
Achievement Award as Project Lead, 1998
Available
upon request.