Alan Lipton

adjmi4@r.postjobfree.com

610-***-**** (c) - 610-***-**** (h)

Extremely creative, thorough, experienced designer /IS business analyst /project leader with outstanding experience working in various industries but primarily Healthcare systems using SDLC database design on a Oracle/PL-SQL/ Cloud (AWS-S3)/ SQL Server/ Postgres/ UNIX / API / ETL/ Teradata/ Powerbuilder/ Datastage/ Data Warehouse / Docker/ AEM environment. Excellent interpersonal and analytical skills. Adept at working with management stakeholders, analyzing data that travels from a source system database to APIs and company websites.

Education and Credentials

•BBA Degree in Computer Science – Temple University

•Elected to Who’s Who Worldwide - Professional Services

Applications and Systems Knowledge

Software: ORACLE 10.2/11.2, POSTGRES, AWS (S3), SYBASE SQL SERVER, ORACLE PL/SQL, ORACLE SQL DEVELOPER, DBEAVER, POSTMAN, COLDFUSION, PYTHON, SQL LOADER, AEM, JIRA, GIT, WINSCP/FILEZILLA, VISUAL STUDIO CODE/BRACKETS, PUTTY, SLACK/SKYPE/TEAMS/ZOOM, VPN, LASTPASS, DOCKER, LINUX/UNIX/SHELL SCRIPTS, DATA WAREHOUSING, SQL PLUS, POWERBUILDER 19/12.5, WINMERGE, CA CYBERMATION, TERADATA SQL ASSISTANT, INFOSPHERE DATASTAGE, DB2, PVCS, WEBSPHERE

Hardware/OS: WINDOWS 10/7, UNIX, DEC VAX/VMS

Project Profiles and Employment History

Insight Global – Jefferson Hospital – Philadelphia, PA

Solution Architect/Lead Developer/Consultant – Senior Analyst June 2016 – Present

Tech/Business Lead analyst for the conversion of the Center City Jeffnow Call Processing and Provider Maintenance systems to Kyruus. This also involved the migration of the Echo Credentialing system to Cactus. This has been a multi-year project that is still being implemented as we integrate additional Jefferson Divisions (JNJ, Abington and Northeast) into Enterprise Cactus and Kyruus. This project originally involved integrating our internal Oracle JNIS and SQL Server Echo data marts into the VSOR and Kyruus's databases. It also involves the uploading of Provider photos to Kyruus and AWS S3, where they are stored. The Provider data in Kyruus is fed back to our newly created Postgres database, which feeds our newly designed Provider Directory API. From the API, the Provider Data is sent to our Content Management System for Center City (AEM) and JNJ (Drupl), which feeds the respective Find-A-Doc websites. Eventually, Jefferson Northeast and Abington will be integrated as well. The project team, which includes management from the Marketing/Seamless Access departments across the Jefferson Enterprise, meets every week to discuss issues and next steps. I am a lead contributor in these meetings.

Provider analysis and support for various internal applications in Center City Jefferson. I led the effort to modify the download of Provider data download to our JNIS database, which was re-configured to accept ECactus Provider data instead of data from our previous Credentialing system, Echo. The internal applications include On Call Scheduling, Telephone Directory, Clinical Communications and P2P.

Environment: ORACLE 11.2, ORACLE SQL DEVELOPER, POSTGRES, SQL LOADER, POSTMAN, AEM, DB BEAVER, POWERBUILDER 19.2, DOCKER/CONTAINERS, AWS (S3), RABBIT MQ, SQL, VISUAL STUDIO CODE, SQL SERVER, API, AEM, WINSCP, FILEZILLA, EXCEL, BRACKETS, SLACK/TEAMS/SKYPE,

E-Primary - IMS Data - Collegeville, PA August 2015 – April 2016

Consultant – Lead Developer

•Specialty Pharmacy Products (SPP) – Supervised development of SPP project which accepts Specialty Drug data from multiple suppliers and uses CA Cybermation and SQL Loader to load the data into an Oracle database. The data is then validated thru a series of Linux shell scripts, SQL metadata and Oracle packages. CA Cybermation and Linux SQL scripts are used to produce Feedback files and Quality Control reports for the pharmaceutical client.

•Overlap Analysis – Utilized Excel, CSV files, SQL Loader, Oracle tables to compare 2 sets of SPP data to report data overlap between 2 IMS proprietary databases on a quarterly basis.

Environment: ORACLE 10.2/11.2, ORACLE PL/SQL, ORACLE SQL DEVELOPER, TOAD, CA CYBERMATION, SQL LOADER, WINSCP, PUTTY, LINUX/UNIX/SHELL SCRIPTS, PVCS

LiquidHub, Inc. - Independence Blue Cross - Philadelphia, PA March 2011 – June 2015

Senior Associate – Solution Architect/Project Leader/Lead Developer

•IMC Sourcing Transition – Supervised challenging design/development effort to revise the source of incoming IMC Enrollment and Transaction data from IBC’s Pre-Enrollment Medicare system (Oracle) to Highmark’s Pre-Enrollment Medicare system (Teradata). This was done in 2 stages: 1) downloaded daily data files from Highmark’s system to Teradata views 2) utilized Datastage to download data from Teradata views to new IMC Oracle tables. Worked extensively with Business, Testing, Teradata, Datastage and Data Modeling teams to implement in March 2015.

•Individual Medicare Commission (IMC) – Supervised challenging development effort to create a new Oracle/Java Commission system to generate commissions/retractions for external Brokers selling IBC’s new Individual Medicare product. IMC had an accelerated timetable to replace an antiquated Access system which was incapable of supporting this in-demand product. Worked extensively with IBC management, design/development/testing teams and data modeler/Oracle DBAs to create a robust, supportable, user-friendly system with a light Java Front-End and a heavy Oracle back-end that was integrated thru Websphere.

•Incentive Administration – Support IBC’s Incentive system that issues Incentive Bonuses to internal IBC brokers. The Incentive system is comprised of UNIX Shell scripts, SQL Loader scripts, Oracle procedures and Datastage jobs that load Incentive data into an Oracle data mart on a monthly basis for management reporting.

•Win 7 Transition - Supervised effort to migrate several PB applications from PB 8 to PB 12.5 to satisfy Windows XP to Windows 7 transition. Worked with Desktop team to create Radia/SCCM packages to deploy migrated applications to several hundred desktops.

•Oracle Back-end Development on MBRS (Modified Book Rate System) – produce more diverse network options for new renewal coverage packages in small NJ business segment.

•Worked extensively with both IS and Business Management groups during the design.

•Created back-end objects (stored procedures, packages, functions, triggers), utilizing PL/SQL SQL Developer, SQL Plus and PVCS.

•Analysis and Powerbuilder development for Family Planning - Kentucky Denied Encounter Reporting

•Worked extensively with both IS and Business Management groups during the design.

•Developed solution to send Denied Encounters to the state of Kentucky using their guidelines and requirements. Also developed solution for filtering down what Denied Encounters are reported to Pennsylvania. (DB2)

•Worked on several projects on the Infocare Medicare Pre-Enrollment system, including the capture of Broker information, critical to distributing MA Broker compensation. (Oracle/Powerbuilder)

Environment: ORACLE 10.2/11.2, ORACLE PL/SQL, ORACLE SQL DEVELOPER, POWERBUILDER 12.5/8.0, UNIX/SHELL, TERADATA SQL ASSISTANT, SQL PLUS, IBM RATIONAL APPLICATION DEVELOPER, WINSCP, PUTTY, SQL LOADER, RADIA, DATA WAREHOUSING, INFOSPHERE DATASTAGE, DB2, PVCS, JAVA DEVELOPMENT KIT (JDK)– VERSION 6/7, WEBSPHERE

Independence Blue Cross February 2005 – March 2011

Solution Architect/Lead Developer

•Developed and maintained 4 Powerbuilder applications; Infocare (Oracle), RAPS – Risk Adjustment Processing (DB2), Family Planning (DB2) and IDDPS - Part D Prescription (DB2).

•Worked extensively with both IS and Business Management groups during the design, testing and implementation phases for each application release.

•Installed versioning software (PVCS) and developed automated deployment procedures for all 4 applications.

•Implemented a security subsystem for Infocare and RAPS where user’s permissions were database-controlled.

•Maintained interface with CMS Marx website thru a Powerbuilder/Proxy/Java Webservice located on Websphere server.

•Developed a release as part of the design team for the MBRS application (Member Retention) utilizing Oracle PL/SQL and Powerbuilder.

•Served as the focal point for IS and business user’s software and application installs.

Environment: Oracle, Powerbuilder 8.0.3, DB2, PVCS, SQL Developer, SQL Plus, PL/SQL, Websphere

Member Retention Management Data Warehouse (MRM)

Helped design and implement an Oracle data warehouse, which uncovered trends that were used to retain Blue Cross membership. The data warehouse was a star-schema containing 8 million rows. Several extract files from several databases residing on various platforms are imported into the data warehouse. Powerbuilder was used to perform the initial load of 3 years of data. Datastage was be used for the monthly imports. Cognos Power Cubes were created to give the user a MRM multi-dimensional reporting tool. Cognos Impromptu was used for drill-down reporting from the Power Cubes.

Environment: Ascential Datastage, Data Warehousing, Oracle 8i, Powerbuilder 8.0/6.5, Cognos Impromptu/Powerplay, MS Access.

CDI Corp June 2002 – January 2005

Consultant – Solution Architect/Lead Developer

Independence Blue Cross - Valley Forge, PA

Risk Adjustment Processing System (RAPS)

Designed and implemented a Powerbuilder/DB2 application, which allows the client to correct claim/diagnosis errors that are input into a corporate database and passed through an internal edit process. The claim/diagnosis attributes, errors and history reside in a DB2 database, which is accessed with Powerbuilder through a MDI gateway. The error processing is complex, allowing the client to perform many functions, depending on the attributes of the claim/diagnosis. The application contains online reports that aid in the correction process. It also allows the client to request a report via the batch system. This is done by creating an e-mail within the application that contains the batch report parameters. The e-mail is sent via Powerbuilder to the mainframe scheduler to be executed.

Environment: Powerbuilder 8.0.3, DB2, Direct Connect MDI Gateway

Robert Half, Inc. April 1998 – June 2002

Consultant –Solution Architect/Lead Developer

Independence Blue Cross (June 2001 – June 2002)

Coded and implemented Family Planning System (FAP). This system allowed the user to drill down, browse and correct Family Planning claims. The claim information, which included demographic and payment information, was stored in a DB2 database. The system used treeviews, listviews and tabs to perform the browse and modifications. FAP also included reporting and maintenance table processing. FAP was documented in MS Word and integrated into the FAP Help processing via intranet.

Environment: Powerbuilder 6.5, DB2, MS Word Designed.

Morgan Stanley Dean Witter (formerly Miller, Anderson & Sherrard) (April 1998 – June 2001) - Conshohocken, PA

Billing Application

Designed, coded and implemented Billing system for system for Morgan Stanley Dean Witter. The Global Revenue Management Information System (GRMIS) is used by Finance/Controllers to automate the billing of Morgan Stanley’s separately managed clients. GRMIS calculates and creates invoices based on the Portfolio Account, Billing Contact and Fee Schedule data in AGCIS. (Asset Gathering Information System) GRMIS also includes a reporting system, search capabilities and AR/Performance feeds which are pipelined to an Informix database. GRMIS currently serves 3 billing locations; NY, W. Conshohocken & London. It will be expanded to include Tokyo & Singapore. GRMIS handles multiple invoice, letterhead and date formats based on billing/cycle/basis types and location. This includes several standard and aggregate invoice formats. The next phase will include multi-currency fee schedules and functionality. This system replaced several local billing systems and will set a billing standard for all of Morgan Stanley’s separately managed clients.

Environment: Powerbuilder 7.0.2/PowerBuilder 5, Sybase SQL Server 11/10, CAST SQL Builder, SQL Advantage, Q & E, Snagit, Windows NT, Unix, Informix

IBAH, Inc. (formerly Biopharm) - Blue Bell, PA November 1996 – April 1998

Project Leader / Analyst

Invoice Application - (Project Leader)

Designed, coded and implemented Billing system for IBAH, Inc. and its worldwide subsidiaries. This replaced a manual system maintained with Excel spreadsheets. The system allows the user to create invoice drafts and actual invoices using numerous pre-defined formats. The user can also create a customized format for each project. The system also contains credit memos, master contracts, grant billing items and numerous reports. The billing input is 1) pipelined from a Sybase Revenue system, 2) imported from a SUN GL system and 3) imported from Excel spreadsheets. The system maintains multiple currencies and conversion rates. I designed and created a billing database in Sybase SQL Server and SQL Anywhere (and stored procedures).

Using Powerbuilder 5.0, designed, coded and implemented worldwide application which imports SUN GL data by task into a Sybase revenue database. The application calculates administration fee markups, updates the revenue database (using conversion rates) and then creates an export file to send the markups back to the SUN system.

Using Powerbuilder 5.0, designed, coded and implemented application which creates an IRS 1099 electronic file.

Environment: Powerbuilder 5.0, Sybase SQL Server 10.0.04, Sybase SQL Anywhere, SQL Central, Windows 95, MS Access, Excel, SUN GL, VAX Alpha Severs, Pentium 133.

EDP Contract Services January 1996 – November 1996

Consultant - Developer

Merck, Sharp and Dohme (June 1996 – November 1996) - Lansdale, PA

Marketing/Budget Application

Using Smartstream Budget, enhanced a budgeting application built with Smartstream; a Powerscript 4.0 code-generator. Created and modified data-entry screens and reports that utilized dynamic stored procedures.

Environment: Powerbuilder 4.0, Smartstream Budget (with dynamic stored procedures), Sybase SQL Server, Windows 3.1, Pentium 133.

IBAH, Inc. (formerly Biopharm) (January 1996 – June 1996) - Blue Bell, PA

CRO Project Management/Revenue Recognition Application - Using Powerbuilder 4.0, enhanced application primarily used for entering and reporting revenue and expenses by project. The DBMS was Sybase SQL Server for corporate use and Watcom 4.0 for salespeople in the field. VAX DCL command procedures were used to download data from the corporate database to the PC laptops, which utilized Watcom 4.0.

Environment: Powerbuilder 4.0, Watcom 4.0, Sybase SQL Server, Windows 3.1, MS Access 2.0, Excel, SUN GL, DEC Pathworks, Pentium 120, VAX DCL.

RSI, Inc. September 1994 – January 1996

Consultant - Developer

Corestates Bank - Philadelphia, PA

Banking Application

Using Powerbuilder 4.0/3.0A, designed the update of reporting database (DSS) that resides on both an IBM Mainframe (DB2) and a network LAN server (ORACLE). The update required input screens that captured the non-performing data in ORACLE and transferred it to DB2 via EHLLAPI upon user request. The Oracle SQLNet gateway provided access to the DB2 reporting data. Infopump was used to replicate the smaller DB2 tables to Oracle for faster access for lookup list boxes. Created numerous reports that detailed the NPA activity which were distributed to management. Our group also prototyped delivery tools for adhoc queries and multi-dimensional analysis (COGNOS).

Environment: Powerbuilder 3.0A/4.0, ORACLE 7.0, DB2, WATCOM 3.0, Windows 3.1, ORACLE SQLNet Gateway, 486/66 PC Workstation & Server, IBM Maniframe (server), Platinum, MS Access, EHLLAPI, Excel, Trinzic Infopump.

Devon Consulting January 1994 – September 1994

Consultant - Developer

Air Products (July 1994 – September 1994) - Trexlertown, PA

Environment: Engineering Application, Powerbuilder 3.0A, Sybase SQL Server, DDE (Excel/Formula One), NVOs, Windows for Workgroups 3.0. VBX controls (Visual Tools - Formula One spreadsheet), Novell LAN, Powerbuilder reports and labels

Air Products (January 1994 – July 1994)

Using Powerbuilder 3.0A and DB2, helped develop the next release of a Human Resource MDI appliction called SUMMIT 3.01A, B. The SUMMIT application used Powerbuilder 3.0A to maintain classified employee information for AIR Products worldwide. The latest release utilized inheritance, multiple window instances,dynamic datawindows, dynamic SQL and remote stored procedures called from COBOL on the IBM Mainframe. The client workstations utilized DEC Pathworks and a MDI Gateway to gain access to CICS/DB2/IDMS on the IBM mainframe.

Environment: Powerbuilder3.0/3.0A, DB2, SAF (Microsoft SQL Server Query Facility), Watocm 3.0, Platinum (IBM/DB2 SQL Query Facility), COBOL, Windows 3.1, 486/50 Workstations, DEC Pathworks 4.1, MDI Gateway 2.00.02, Select Client for Windows, IBM Mainframe (server).

EDP Contract Services April 1993 – January 1994

Consultant - Developer

Charming Shoppes, Inc. - Bensalem, PA

Using Powerbuilder 2.0A/3.0 and MS SQL Server, helped develop a prototype Assortment Planning System (APS). APS was responsible for the distribution of merchandise to the more than 1500 Fashion Bug retail clothing stores nationwide. APS categorized this distribution by season, item style, item color, item groups, staple/non-staple items, geographical location, trend, etc. APS will utilize 18 months before the actual distribution of merchandise. APS resides on a Novell LAN consisting of 486 clients and server. Merchants and planners provide some APS input while the rest is downloaded weekly via bulk copy from an IBM Mainframe.

Environment: Powerbuilder 2.0A/3.0, Microsoft SQL Server 4.2, SAF, Windows SDK, Windows 3.1, DOS 5.0, 486/33 Workstation & Server, Novell LAN, Watcom 3.0, MS Word, IBM Mainframe.

Actium (formerly Information Technologists - ITI) September 1992 – March 1993

Consultant - Conshokocken, PA

Attended Powerbuilder 2.0 training class at ITI. Helped to develop in-house Client/Consulting Information System application using Powerbuilder/SQL Server. Continued to develop at home with Powerbuilder software installed on 386SX PC. Used Lotus Notes to e-mail messages from my home to ITI.

Environment: Powerbuilder 2.0, Sybase SQL Server, Gupta SQL Base, Windows 3.1, Novell LAN, Lotus Notes.

CGI Inc. – (formerly Matrix) April 1992 – September 1992

Consultant

Scott Paper - Philadelphia, PA

Environment: Procurement Application, VAX/VMS, VAX 6XXX, VAX 9XXX, IBM PC, COBOL, DEC FORMS, DATATRIEVE, CMS, MMS, CDO, DCL.

Devon Consulting January 1992 – April 1992

Consultant

Personnel Data Systems - Plymouth Meeting, PA

Environment: Payroll/Budget Planning Application, VAX/VMS, VX 8250, VAX 11/750, HP3000, IBM PC, AS400, COBOL, FMS, DCL.

Information Technologists January 1991 – December 1991

Consultant

Centocor, Inc. - Malvern, PA

Environment: Marketing/Sales Application, SUPRA, MANTIS (4GL), COBOL, PC Express, RFFlow (PC Flowcharting), VT420, VAX Cluster, DCL, IBM PC, VAX Wordperfect 5.0.

Computer Assistance - Cooper’s & Lybrand June 1989 – January 1991

Consultant

Stanley G. Flagg, Inc. - Pottstown, PA

Manufacturing, Order Management and Accounts Receivable Application

Converted and downloaded IBM VSAM/ISAM files onto DEC VX 8350 / DEC ASK/MANMAN DBMS databases; OMAR (order mgmt/acct rcvble & Manufacturing. Created and enhanced several MANMAN screens (order entry, shipping, invoicing) using COBOL and FORTRAN. On-hand experience with RAxx and TUxx drives.

Environment: ASK/MANMAN, VAX/VMS, COBOL, FORTRAN, VAX DBMS, DATATRIEVE, DML, FMS, CDD/CDO/DMU, DCL, VX6410.

Computer Assistance - Cooper’s & Lybrand January 1989 – June 1989

Consultant

Health Care Systems - Philadelphia, PA

Applications included prescription/refill entry, drug interactions and sales analysis. Created sales analysis tapes (EBCDIC/ASCII RMS files) for various IBM/DEC customers. Documented existing pharmacy system. Hands-on experience with disk and tape drives.

Environment: Pharmaceutical/Sales Application - VAX/VMS, VAX Cluster, COBOL, DATATRIEVE, DCL, TDMS, CDD/DMU.

Day Data Systems April 1988 – December 1988

Consultant

Wawa, Inc. - Media, PA

Used VMS system and run-time library services to automate the maintenance of in-house and remote user authorization files (also using COBOL and spawned DCL subprocesses). Created a reporting front end in DCL to execute reports and print them on a store terminal LA50 slave printer.

Environment: Payroll/Cash/Pricing/Inventory Applications, VAX/VMS, System/RTL Services, COBOL, FMS, DATATRIEVE, DCL, CMS, VAX 11/780, VAX Cluster.

Computer Assistance December 1987 – March 1988

Consultant

Merion Software/Praxa Systems - Wayne, PA

Designed and coded reports. Installed software on-site at Praxa on Microvax using TK50 tape drive.

Environment: Manufacturing/Payroll/Accounts Payable Application, VAX/VMS, COBOL, Microvax, PRAXA Software, DCL, DATATRIEVE.

Shared Medical Systems - Malvern, PA July 1983 – October 1987

Project Leader / Programmer Analyst

•Progressed from Associate Programmer to Programmer (Feb 1984) to Project Leader (Dec 1985).

•Redesigned and recoded VAX Startup package (DCL) that initialized operating and application systems on client hardware. Received Merit Award.

•Spent two months in Japan converting AIRS from PDP to VAX using MUMPS/COBOL.

•Designed an Incident Reporting System (AIRS) that processed data and statistics concerning client’s problems and support requests.

Environment: VAX/VMS, PDP/DSM-11, MUMPS, COBOL, DCL, VAX Cluster, DEC NET, VX 11/780, VX8XXX, MicroVAX

Paycomp Services January 1982 – October 1983

President/Owner

Established and ran own payroll service to maintain all payroll data and issue checks for clients. Individually researched payroll needs and developed complete payroll system in BASIC. Complete one person operation.

Environment: TRS-80, TRSDOS, BASIC

Contact this candidate