Hardware Software

Technologies: OBIEE Oracle Business Intelligence, Cascade, CTMS, SpotFire, Iron Python, Oracle 11g, PL/SQL, SAS 9.1, R, C/C /C , MS Visual Basic, Java , MS Access, Crystal Reports, Perl, Unix Shell Scripting, SYBASE, Transact SQL, MS SQL Server, HTML , PHP, DB2, Informix

Professional Experience

Clinical Programmer Analyst

Confidential

Developing programs that convert raw SAS datasets to standard format, programs that produce analysis datasets from raw data or standard data, program data displays tables, listings, graphs for inclusion in documents including publications, stat reports, clinical study report and other regulatory documents. Perform peer review of SAS programming code and deliverables derived data, tables, listings graphs , Prepare documentation on above production programming and validation activities. Assists our tools team as needed to develop .NET applications using VB.net and C to maintain and automate many aspects of our work.

Sr. Business Analytics Specialist

Confidential

Responsible for producing executive, clinical and operational reports and dashboards from Cascade, Project View and CTMS data sources, which are used to assist with key business decisions, study project management and client contractual reporting. Tools and programming languages used include Tibco Spotfire Professional, MS Visual Studio 2010, MS Excel, Oracle Business Intelligence, Oracle PL/SQL and SQL.

Systems Developer

Confidential

As a member of the Lawson Corporate Software Development team, I was responsible for the production support and development efforts for our Lawson ERP system and DataBasics Time and Expense systems. Programming experience included writing SQLPLUS/PL/SQL code for Oracle 11g using Korn, Bourne and Perl shell scripting or Crystal Reports to produce results. Also responsible for writing the Payroll load process PIPULL from TimeSite to Lawson using Oracle PL/SQL scripts for Project Global. Reduce Oracle to Lawson process runtime from several hours to less than 15 minutes. Hardware and operating system includes HP 9000/800 running HP-UX B.11.11 and HP Proliant G4 running Red Hat Enterprise Linux ES R 2.1 Panama . TimeSite programming tasks to include creating and maintaining PHP4.1.2 web pages or Crystal reports that access our Oracle data and allows the user to review reports or make database changes through our intranet. Also wrote a VBS script to assist in automating the EDC PDR CD Archival process that made several .NET class library calls as well as TimeSite VBS scripts to check on the Jaguar Services and restart them if necessary

Technical Consultant

Confidential

Contracted to Bank of America through Sapphire Technologies. As a technical consultant, assisted in the design and implementation of the Payment DataMart for Bank of America. Tasks included extracting, processing and loading savings, checking and credit card data from various bank systems Teradata, SAS and DB2 into the Payment DataMart. Hardware included IBM RS/6000 PowerPCs, running IBM AIX Version 5.3. Languages included Korn Shell, Perl v5.8.2 script programming to automate the SQL extraction, processing and loading of data. Credit Card analysis and verification was performed using SAS 9.1. Other financial data was extracted using Teradata Version 5 and DB2 version 8.1 through SQL, MLOAD, BTEQ, QMF and Queryman.

Web Developer

Confidential

Provided primary support for the university BlackBoard POS system, which runs on a HP rp 2470 using HP UX 11.00. Responsibilities included maintaining Bourne/Korn Unix Shell scripts for reporting, data extracts and feeds. Also responsible for providing programming support to the UBusiness Web based application suite, using Cold Fusion version 7.0 accessing data in Oracle 9i and MS SQL Server 2000.

Owner/Developer

Confidential

Designed and developed KidzSay, a Personalized Learning Station for Children in MS Visual Basic 6.0, and ScubaRec, an electronic dive journal in MS Foxpro 6.0. KidzSay was designed to assist and encourage children to learn their ABCs, Numbers, Colors and Shapes. It is also designed to allow parents to customize the software using their children's picture and voice. A language module has also been added to help a child develop their foreign language skills in Chinese PinYin , French, Greek and Spanish. ScubaRec, allows a user to organize and store their dive related experiences and information. It provides a dive planner, picture log and dive trip journal. It also provides the diver with a dive trivia game that allows them to review some of their critical diving skills and other dive related information. Sub-contracted out to IPM computers to assist them in converting a Health and Nutrition application from C to MS Foxpro.

Senior Programmer

Confidential

Provided telephony support for the Benefits Now Interactive Voice Response System. Responsibilities included writing Telephony scripts, using PeriPro, which accesses customer specific data Oracle . Tasks also included supporting our socket server software, which is written in C, to access the Oracle data, for our CTI system Genesys and implementing our Intranet Reporting system, which allows Call Center Managers to access call specific statistics using their browsers. Also responsible for supporting the DOS based PC Dialogic system. Assisted in creating an automated Benefits Enrollment Setup support system using MS Visual Basic 6.0.

Senior Programmer Analyst

Confidential

Worked on the TelSell Voice Response Unit VRU using IBM DirectTalk, Version 2.2 on a RS6000 using AIX 4.3.1. Primary responsibilities include writing the communication interface, using Visual Age C 4.0, to our Sybase servers residing on 11 HP 9000 Unix 10 machines. Programming environment includes native Sybase Open Client and Connect ODBC. Provided C /PowerBuilder/Sybase support to the Selling Support team. Tasks included maintaining the customer routing and pallet building/truck loading solutions, which are feed daily to the portable hand held computers. Provided support for the image archive and retrieval system. Responsibilities include trouble shooting, maintaining the INFORMIX database tables, embedding SQL calls in KORN UNIX scripts to automate many of the daily tasks. Assisted in the conversion of our imaging system from INFORMIX/UNIX to a Client/Server solution utilizing Oracle 7.3/KOFAX-MS SQL Server technology, running in a Windows NT environment.

Systems Developer

Confidential

Computer Consultant

Wrote a multi-user safety and analysis program in MS ACCESS for a Polyester Intermediates Manufacturer. Wrote a multi-user employee T A system in MS ACCESS. Provided database management and communication support to a medical office serving 21 physicians. Provided computer hardware, software and training to a travel agency. Continued to provide support with DB2/2, OS2/2, C for the automated curing system described below.

Programmer Analyst

Confidential

Developed a system to assist in tracking and automating the curing process for a pork processing plant. This system utilized IBM's Data Collection and Control DCC terminals and software in an OS/2 environment using DB2/2. Wrote C utilities to interface with the DCC/2 configuration and access and manipulate information in DB2/2. This system also utilized Radio Frequency technology , bar-coding and control of a bar-code scanner. Assisted a refrigeration plant in the installation of a MAPICS application which tracks time and attendance and exchanges information from an IBM mainframe with the PC equipment located in the manufacturing plant for order tracking.

Senior Systems Engineer

Confidential Responsibilities included providing PC and mainframe support to various areas in the bank. Programming experience included developing window applications using Visual C /Basic, EXCEL, and FOXPRO. Maintained a Credit Review interactive system using SAS. As NBCARS Database Manager, responsibilities include serving as system liaison to the contract programmers and other areas within the bank. Tasks also include writing FOCUS, dBASE and FOXPRO programs to support the NBCARS products. As a senior programmer, responsible for designing End User Systems in FOXPRO to produce and maintain information for credit reports. Examples are: financial projections, planning, strategy, portfolio acquisitions and other credit related projects. Wrote several NOVELL utilities to automate network maintenance and aid LAN users. Responsible for coordinating and providing software support to the EDI pilot program. Programming experience included writing application programs in C, using SQL to generate customer financial transaction files and reports from an Oracle database, and providing support utilities to automate many aspects of our work. Also responsible for the PC hardware, network configuration and software services. Performed VAX system and network management functions, which included installing layered products, setting up user accounts and privileges as well as maintaining other system activities.

Programmer Analyst/Task Manager

Confidential

Provided software support to the TRIDENT program. Programming experience included building operating systems with VAXELN, porting scientific programs from a mainframe to a PC environment, writing C graphic packages and designing various applications in FORTRAN, THLL and C to support on going tasks. Task manager for the Debug Utility Group. Tasks included monitoring software and design document deliveries, coordinating employee's efforts and hours, and ensuring all contractual obligations were fulfilled.

Programmer Analyst

Confidential

Provided quality assurance support for the TOMAHAWK Cruise Missile Project. Tasks involved performing validation and verification on proposed software design enhancements, modifications and test procedures. Prepared code validation and other pertinent reports, explaining the findings of each assigned investigation. As a member of the software development team, assisted in the maintenance of all software-related databases on a VAX 11/785. Tasks included optimizing the performance of the database system, writing utility programs to support the database and provided user assistance, which included training and other various types of support.