Resume of Systems Architect

Title
Systems Architect

Primary Skills
Systems and Services Architect and Integrator with strong Business, Basis, DBA, System Admin and Programming skills

Location
US-NJ-Warren

Posted
Sep-11-07

Overview: Systems and Services Architect and Integrator with strong Business, Basis, DBA, System Admin and Programming skills.
Industries: Financial, Pharmaceutical, Manufacturing, Publishing, Health-Care, Consulting and Sales & Marketing. Notable Clients and Employers include: IBM, UPS, Panasonic, Simon & Schuster, Chemical Bank, Schering-Plough

Key Accomplishments:

* Architected EAI for Panasonic with an XML-SAP interface infrastructure utilizing WebMethods (SAP Business Connector) software. Designed, built and implemented multiple internal & external realtime & batch XML interfaces (both proprietary and RosettaNet) between Panasonic and multiple Warehouses, Factories, Customers, Trading Partners and Web Applications, improving savings by making it possible to more speedily switch to more cost-efficient partners.

* Provided Basis Implementation and Production Support for multiple High-Availability SAP systems for an international publishing conglomerate. Streamlined, semi-automated and documented install process for quicker server implementation. Devised automated system performance, availability and printer monitoring scripts to generate. Devised and Developed interfaces and scripts for SAP to integrate job schedules, transfer files and perform printing with multiple heterogeneous system. Installed and configured OSS Saprouter gateway, Fax Server and external scheduler. Automated SAP internal client-copy and system copy procedure to allow unattended execution. Performed routine OSS Note research and updates.

* Architected and Developed leading-edge comprehensive Electronic Medical Record system under Oracle and Linux using APEX, PL/SQL and Java, with real-time XML, HL7 and X12 interfaces to Insurers, Pharmacies, Billers and Labs. System reduces costs, staffing, claims rejection and workload to medical providers, while increasing revenue through PQRI compliance.

* Introduced and implemented comprehensive Web-based based transmission tracking, logging and audit system, allowed for access and confirmation of all transmissions and their statuses via the internet. This minimized partner phone inquiries, and improved response time in identifying and resolving transmission issues. This resulted in reduced help-desk, support costs and down-time penalties, which had been burdensome using previous technologies.

* Designed and helped build a data-driven Rapid Screen development infrastructure using WebMethods, SAP and Java front-end. Using pre-built screen-frame templates, Web applications could rapidly be built, updated and customized by simple changes in SAP data table content. This reduced new Web application screen development from 3-6 weeks to 2-3 days.

Technical Skills:

Enterprise Software: Oracle, SAP, WebMethods, EAI
Project Skills: Systems Architecture, Executive Presentations, Intranet Infrastructure, High-Availability, Project Leadership, Disaster Recovery, Project Management, System Documentation, Problem Determination and Resolution.
Database: Oracle, Access
Operating Systems: Linux, AIX, Windows
Data Formats: XML, X12, HL7, PDF, CSV, FlatFile
System Software: HACMP/6000, PSSP, DNS, NIS, NTP, Apache WebServer
Programming Languages: APEX (HTML DB), PL/SQL, Java, HTML, WSDL, ABAP, Visual Basic, Awk, Shell, Pearl, PHP, C
Communication and Networking: TCP/IP, HTTP, SSL, MQ Series, TCP Socket, FTP, SSH, SQL*NET (TNS), Microsoft Networking, RAS, ETL
Earlier Technologies: VM/XA, MVS, OS/2, DOS, AFS, PL/I, Fortran, Cobol, Pascal, JCL, CLIST, Novell Netware, Basic, Token-Ring, SNA, Dbase, Clipper, RS/232, Rexec

Additional Chronological Accomplishments and Experience:

RAL Consulting September 2005 to Date, Bedminster, NJ

* Architected and Developed full function Web ASP Electronic Medical Record system using APEX, Java and PL/SQL on a Highly-Availability Oracle 10G Server running on Linux. Program features includes: Patient Demographics, Insurance, Labs, Follow-up, Scheduling, Referrals, Authorization, Vitals, History, Templates, Imaging, Secure messaging, Reporting and more. Other features:
* Free-form PDF annotation program with data population and auto-match keys
* Text-based PDF editor and form generation
* Inbound Lab, Fax and Rx workbench for multi-step processing of inbounds.
* User Configurable screens controlled by application-level settings

* Architected, Developed and Implemented multiple real-time & batch interfaces between Medi-EMR and their various technology and business partners and medical devices using Vendor-provided, Internally developed or Hybrid specifications such as HL7, XML, X12, CSV, FlatFile, PDF, DICOM and TIFF, using various secure or point-to-point transmission protocols:
* Electronic Prescriptions with SureScripts and wholesale pharmacies
* Lab Integration (Quest Labs, Shiels and Enzo Labs)
* Drug Safety and Interaction Checking
* Medical Billing Integration
* Efax Electronic Fax Integration
* Online Insurance Eligibility Checking
* Clinic & Practices Data Loads/Migrations
* Insurance Card Scanning and OCR integration and patient auto-match
* ETL using Application Screens, PL/SQL and Unix scripts
* Led, performed or assisted with Project Management, Negotiation, Design, Specification-writing, Documentation, Training & Skills-transfer, Testing, Certification and Go-live on various projects.

Panasonic July 1999 to September 2005, Secaucus, NJ

* Architected SAP EAI for Panasonic Industrial Company with an XML-SAP interface infrastructure utilizing WebMethods (SAP Business Connector) software. Designed, built and implemented multiple internal & external realtime & batch XML interfaces (both proprietary and RosettaNet) between SAP and various Partner and Business entities including Warehouses, Factories, Customers, Shippers, Trading Partners, 3rd Party Integrators, EDI partners and Browser based Web applications. Protocols supported included HTTP, HTTPS, MQ, FTP, SFTP, Rexec and others.
* Led, performed or assisted with the following Business and Technical aspects of those implementations, including Negotiation, Design recommendations, Specification-writing, Documentation, Training & Skills-transfer, Testing, Project Management and Go-live Coordination
* Introduced and implemented comprehensive Web based transmission tracking, logging and audit system. This system, available both internally and to partners, allowed for access and confirmation of all transmissions and their statuses via the Web.
* Designed and helped build a data-driven Rapid Screen development infrastructure using WebMethods, SAP and Java front-end. Using pre-built screen-frame templates, Web applications could rapidly be built, updated and customized by simple changes in SAP data table contents. Screen layouts supported searches, list results, pop-ups, and display/update data, which could handle most inquiry/entry applications.
* Implemented Web-based systems-monitoring solution that tracked disk utilization, process status, MQ health, database availability, application status and event logs. Configured to send alert messages to support staff depending on severity and time of day.
* Provided Basis Support Developed ABAP and BDC programs to perform interface actions. Assisted other programmers with ABAP program debugging and tuning. Setup and monitored SAP Job and Job Logs. Reviewed and remedied job failures. Performed SAP Basis trouble-shooting, problem determination and tuning assistance.
* Implementation of a High Availability AIX system to support Oracle-based Warehouse Management System running Catalyst WMS, interfaced with SAP via MQ, FTP, Web Methods and Mercator.
* Performance Analysis and Tuning on assorted Unix, Sap, Oracle and Windows systems, and well as application and server upgrades.
Simon & Schuster December 1996 to June 1999 Old Tappan, NJ
Provided a variety of Basis, AIX, High-Availability and Oracle support functions for multiple production, development and test SAP systems running on SP/2 Frames and standalone systems.

* Installed and configured 2 & 3 tier SAP systems for Y2K, Training and System Sandbox testing. Also installed and configured multiple SAP App servers per node. Streamlined and documented install process. Upgraded Sqlnet from V1 to V2 across multiple running SAP systems.
* High Availability - Performed HACMP implementation and support of Production SAP Central Instance and Database Server. Implemented Unix Mirroring or Raid as appropriate on key systems.
* Data Transmission - Devised and Developed SAP logical commands to allow ABAP programs to efficiently move files between nodes. Developed ABAP stub code for programmers' inclusion as a sample program. Developed complementary Unix scripts to perform file copies, moves and concatenations from SAP calls with comprehensive error and completion checking. Also developed Unix scripts to perform FTPs from Global Job Scheduler to AS400's, MVS and Unix systems, updating global sequence numbers and perform completion checking.
* Printer support - Developed Unix and BDC programs to automate entering printer definitions in both SAP & Unix from external data sources. Modified SAP printing to support customized cover sheets, MICR printers, Fax Servers and specialized printers and forms. Developed SAP/Unix printing interfaces to allow seamless printing to AS/400's, MVS spool archive products, and FTP print servers.
* System Support - Researched and Applied OSS notes. Performed SAP Kernel upgrades and emergency CTS transports Performed routine SAP/Unix/Oracle administration tasks as well as Critical Problem Identification & Resolution duties. Devised automated system and printer monitoring scripts to generate e-mails or beeper alerts to appropriate support persons.
* Global Automated Job Scheduling - Assisted with install & configuration of Autosys global job scheduler that coordinated jobs across Unix, NT, MVS, AS400 and SAP. Wrote ABAP/BDC programs to populate SAP Job definitions from various external sources, including legacy extracts, spreadsheets and test SAP systems.
* SAP Fax Server - Installed NT based Omtools SAP Fax server gateway (first functional site worldwide). Worked closely with Omtools developers to identify and remedy problems. Configured Sapcomm to interface between SAP and Omtools, setup mechanism to generate SAP inbox message indicating Fax completion status to user. Altered Fax output in SAP to include customized cover sheets formats and messaging based on company code,
* Performance & Sizing - Assisted with monitoring and sizing of Unix, Oracle tables & tablespaces. Also did Performance Analysis and Tuning at Unix, SAP and Oracle levels. Performed R/3 implementation planning specific to SP and RS/6000 platform including hardware sizing and configuration.
* Connectivity - Installed and configured OSS Saprouter gateway.
* Product Evaluation - Drove Third-party report forms generator products to enhance SAP functionality. Assisting in evaluation of Third-party report archival products for SAP that would utilize Archive-Link and provide superior Fax, Web and E-mail capabilities
* Automation Efficiencies - Automated SAP internal client-copy procedure to allow unattended execution with problem alerting to regular operations staff. Automated SAP system external copy/SID switch to perform weekly refresh of training class systems from continuously updated training master.
* Abap Programming - Developed ABAP and BDC programs to perform interface actions. Assisted other programmers with ABAP program debugging and tuning.
* Job Scheduling - Setup and monitored SAP Job and Job Logs. Reviewed and remedied job failures.



UPS July 1996 to December 1996 Mahwah, NJ
Provided Oracle DBA and Unix support, problem tracing and tuning for multiple production, development and testing instances systems running on Unix and NT systems, reduced operational cost and complexity:

* Installed, configured, implemented, standardized and revamped Oracle Network Manager, Oracle Nameservers, Oracle Enterprise Manager, Oracle SNMP agent processes and start/stop scripts across multiple systems. This generated more accurate and consistent TNS configuration files for SQL*NET and Enterprise Manager allowing for better monitoring and control of various Oracle components.
* Wrote SQL and Unix scripts for integration with BMC Patrol to detect and generate operator alerts for application and database problems, identify problem processes, and to automatically resolve where possible



Schering-Plough Corporation July 1995 to July 1996 Kenilworth, NJ
Provided Unix and Oracle architecture, implementation, project plans and daily support for multiple HP, AIX, Sun and DEC systems, primarily running Oracle-based Client/Server applications for pharmaceutical research and regulatory groups, maintaining SLA levels for high-profile application.

* Developed an integrated Unix and Oracle backup script and automated tape library for HP-UX and AIX systems Performed Oracle, Unix and Client/Server application performance problem tracing and tuning. Coordinated and performed Unix and Oracle restorations for Disaster Recovery tests at offsite facilities.
* Implemented System Management tools and techniques to monitor, manage and perform Software Distribution, image scanner and Printer availability across multiple Unix systems, and generate E-mail reports and notifications.


Chemical Bank Corporation May 1994 to July 1995 New York, NY
Re-architected and provided support for multiple AIX systems used by traders, researchers and developers of Client/Server financial derivative systems worldwide (New York, London, Tokyo).
* Design, coding and implementation of socket-based C programs to handle inter-system requests in a manner meeting security and business requirements
* Architecting, testing and implementation of AFS and Kerberos to provide high-performance secure network file access.
* Design, testing and implementation of a high-availability, X-window based, 24x7 Commodities and Foreign Exchange Trading system that utilizes HACMP/6000, RAID and disk mirroring.
* Implementation of System Management tools and techniques to monitor and manage multiple Unix systems worldwide. Design, testing and implementation of backup and disaster-recovery solutions.


Panasonic 1993 to 1994 Secaucus, NJ
Responsible for the rollout and support of multiple highly-available RS/6000's running mission-critical order entry and sales query applications for 500+ user Oracle databases. Also assisted with other Client/Server projects.

* Implementation, testing and documentation of backup/restore and disaster recovery procedures using UNIX system backups and Hot and Cold Oracle database backups
* Design, implementation, testing and documentation of a Highly Available RS/6000 cluster.
* Recommendation, installation and programming of Visual Basic and Crystal Reports as a front-end report query application to access system databases.
* Oracle Database administration activities including database creation, data loading, database migration, SQL & AIX scripts programming, and automated database shutdown and startup.
* Installation and configuration of SQL*NET under HP-UX and Microsoft Windows, and integration with Powerbuilder for client access.
* Configuration, implementation and support of multiple SNA communication products to MVS via LU0, LU1, LU2 and LU6.2. Packages included ANET, HALKEY, HCON, XCOM & Message Express. Setup of seamless printing from Unix to SNA printers.


IBM Corporation 1984-1993 Multiple Locations

Consulting and Installation Services 1991-1993 West Orange, NJ
* Lead IBM team in architecting and enabling a high-availability AIX system running Oracle. Responsibilities included analyzing RFP and other technical specifications and determining solution best meeting those requirements, researching and confirming pre-requisites and co-requisites of solutions, creating project plans, and installing or directing the installation of systems.
* Designed, reviewed, and implemented departmental Client/Server and Right-Sizing solutions utilizing AIX, PC's and Host-based databases over TCP/IP and SNA networks. Conducted sizing, performance & tuning analysis and remediation. Provided on-site and on-call problem determination and resolution for critical AIX situations. Responsible for directing and training other team members.
* Installed and implemented AIX systems and LANs. Ported COBOL and FORTRAN programs to AIX from other platforms. Networked RS/6000's to VMS, SUN, Ultrix, Novell, Banyan, OS/2, DOS, MVS, VM and X-stations through various protocols including TCP/IP, IPX, SNA and others. Conducted AIX performance analysis and tuning, and also customized and modified AIX user interfaces.

IBM Marketing and Services 1987-1990 West Orange, NJ
* Made technical and business presentations to customer executives. Assisted and participated in joint customer/vendor Design & Strategy workshops. Provided technical marketing assistance and support to sales representatives and customers.
* Worked on a broad range of IBM platforms and operating systems, particularly midrange and workstations. Core responsibilities were analyzing and resolving communication and migration issues and introducing new technologies to customers. Accomplishments included installing and enabling VM/XA on 3090's, OS/2 on PS/2's, AIX on RS/6000's and migrating systems from S/36's to AS/400's.

IBM General Technology Division 1984-1987 Fishkill, NY
* Designed, coded and integrated software to build and distribute tool controller programs for a laser and mechanical based manufacturing system being developed. Extraction software running under TSO retrieved and re-processed data from a Host-based EDS database, which then fed the distribution component that utilized Series/1 and PC's to download the data to the manufacturing line.


Education
Cornell University, 1983 Bachelors Degree, Chemistry

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NJ-Warren »
View all resumes in US-NJ »

View other Systems Architect resumes, System / Network Administrator resumes