TECHNICAL SKILLS:

Oper. /Syst: Windows System 7 - 10, D3-Pick, AIX/OS Rel.4.2.1.0, AIX/OS Rel.4.3.3.0, SAP R/3, Informix Universe (Ver 8.3), UniData, OS/400 (Ver.2), Pick-D3 for Windows, PRIMOS, AMOS, OS/VS-CMS, TSO-SPF under VTAM, Pr1me INFORMATION (Identical to the PICK O/S).

Hardware: Dell, (3) IBM Model 37015's, (6) IBM Model SP2-9076, IBM RS/, HP/9000, AS400/Model E50, McDonnell Douglas, Sequel 9340, PRIME MODII'S, ALPHA-MICRO (similar to DEC PDP 11/70), IBM 370 using 308x.

Network: VPN (virtual private network) extensive usage of ODBC

Databases: SQL, Universe, Unidata, PICK-D3, MySQL, MS Access, ORACLE 8, Informix, FOCUS Six for Windows.

Application Packages: CRM GoldMine 8.0 Professional & 6.0 Premium Editions, MS Great Plains, SQL 2000/2005 DTS SAP R/3(AIX) vers upgrades 3.1H, 3.1I, 4.0B (NT). FOCUS Six for Windows Workbench (Information Builders), IBM/400, PC-Support/400, Performance Tools/400. Screen Design Aid (SDA), Data File Utility (DFU), SSIS, SSRS and FTP.

Software Languages: All flavors of Pick Data-Basic, DesignBais, MS Access VBA, SQL/TSQL, XML, HTML, .NET Framework 3.0, ABAP/4, FOCUS SIX for Windows, Unix-shell scripts, MSDOS batch-files, Access/Excel Macros, RPG/400, Perl, COBOL, BASIC, FORTRAN, "C"(Lattice-compiler), WD-16 Assembler.

PC Packages: MS Outlook, Word, Gismo, Quote works, Excel, Crystal Reports, Skype/Lync for Business, Visio and PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, Trevose, PA

Technical Lead /Consultant

Responsibilities:

• Responsible of producing ADDs (Application Design Documents) from BRD’s (Business Requirements Documents) of various projects from project managers.
• The stakeholders include senior management, quality assurance and software developers running their companies on multivalued Universe database.
• All software enhancements are designed and coded in Pick Basic Universe.
• Responsible of recommending to add, change or delete portions of software code to enhance existing logic, file structures (Dictionary & INSERT/EQUATE) within existing application systems to meet business requirements.
• Performed content flat file data integrity mappings supporting external data document service vendors.
• Responsible of identifying the scope within the business work flows of needed requirements to fulfill the requested desired enhancements.
• Assisted quality assurance of testing desired enhancements during and after completion of software test development.
• Participant sign off of enhancement products after final testing.
• Knowledge of Software Development Lifecycle (SDLC)

Confidential, Needham, Mass

Software EDI-Sr. Programmer-System. Analyst/Consultant

Responsibilities:

• Design/developed and coded Confidential ’s-EDI data integrity/validation using Universe Basic, Procs and Voc Paragraphs within the EDI 850 transaction sets.
• Performed reconciliation PROC reporting of incoming raw EDI-850 sales-order data to Euro Pro’s ERP production database.
• Generated error and/or warning reports to help end-user(s) to amend incoming transmittedsales-orders by end users.
• Performed production support of legacy multivalued JD Edwards ERP system while transitioning to SAP ERP system. Worked with using EDI of 810, 856, 940, 943, 944 and 945 warehouse transaction codes.

Confidential, Brooklyn, NY

Software Business Analyst (Temporary)

Responsibilities:

• Completed conversion from Universe PICK Legacy COMPTRON medical servicessystem to an in-house medical billing/services Microsoft Access 2010 database system.
• Migrated Microsoft Access forms/reports/databases from old XP .
• Designed/coded PICK Basic coded applications for driver pickup/deliveries, house call maintenance/reporting sales project entry/reporting and supplies inventory maintenance/reporting systems.

Confidential, Brooklyn, NY

Software Consultant

Responsibilities:

• Transformed D3-Pick report legacy flat-file data onto Sql-Server. SQL-2005’s.
• Created SSRS, SSIS snd dtswizard scheduled batched packages to automatically export/import and refresh reports
• Created SQL work tables supporting ad hoc customer master reconciliation reporting.
• Established connecting clients to open MS Access (VBA) forms while linking tables using (ODBC) or client/server on SQL-Server database.
• Created stored procedures to simultaneously select launching of producing desired ad hoc reports (text, excel).
• Created FTP site to store incoming pickup schedules by customer

Confidential, Newark, NJ

Sr. Systems Developer/ CRM Administrator

Responsibilities:

• Designed SQL views/stored procedures to query the database to produce all company wide sales client/server distribution and sales reporting.
• Created methods using data integration, data mining and warehousing from several different relational databases Unidata (NONSQL and truly relational).
• Became System administrator of our customer relations management (CRM) package and its add-on software integration tools using MsOutlook while automating purchasing quotes for raw materials and proforma customer invoices.
• Created canned sales production dashboards.
• Performed migration of MS Access 2000 database to SQL Server 2005 using MS Access projects.

Confidential, Freeport, NY

Senior Programmer/Analyst

Responsibilities:

• Integrated all multivalued sales, expense and traffic information residing on PICK-D3 multivalued database platform producing output tables that were stored, prepared and transferred as input to be fed into SAP FI/GL, SD accounting modules.
• Designed and coded Unix-scripts for transport and ABAP programs interfacing to populate sales, expense and traffic info into SAP's FI and SD production tables and Ztables. 4.0b workbench (gui) installed.
• Designed, developed and responsible for several SAP DataMart’s containing inception-to-date billing with traffic information by sales order by product by customer.
• Coded PICK data basic programs to download several of SAP production tables and DataMart Ztables into flat-text files for exporting to MS Access.
• Created DOS-batch files to invoke MS Access macros using make/update query’s to import/export SAP data, supplying information to their Traffic/Controlling operations
• Developed, revised and written project plans for all financial sales distribution integration applications.

Confidential, New York, NY

Senior Programmer/Analyst Consultant

Responsibilities:

• Responsible for maintenance, development and enhancement of claims processing application system software for major start up health maintenance organization. Coding percentage used 100% Universe pick basic.

Confidential, New York, NY

Senior Programmer/Analyst - Consultant

Responsibilities:

• Responsible for maintenance of CSI wholesale distribution software package relating to local and remote warehousing, replenishment of goods for resale for a major NY-Manhattan apparel designer/retailer. Coding percentage used 100% UniData pick basic.

Confidential, Lyndhurst, NJ

Senior Programmer - Consultant

Responsibilities:

• Responsible for enhancing and tailoring MDS (Systems House) wholesale distribution software package to conform with current business A/R credit/collection and control policies. Coding percentage used 100% Universe pick basic.

Confidential, New York, NY

EDI programmer/support analyst

Responsibilities:

• Designed, coded, maintained software to receive/send electronic customer sales-orders, point-of-sales (inventory & forecast), acknowledgement, advance ship notices (ASN) and invoice information emulating our manual data-entry sales-order/billing database.
• Revised receiving and sending software supporting customer request of using the latest detail industry's VICS (ANSI ASC X12) segment version formats.
• Scheduled and coordinated with our customer's edi staff to test and implement new version formats. initialialized electronic contracts by logging onto 3rd party remote host computers (IBM, GE) to affirm sending/receiving transactions.

Confidential

Senior Programmer/systems-coordinator

Responsibilities:

• Installed, configured, maintained and revised all local/remote devices O/S, releases and communications equipment.
• Supervised and trained sales-billing staff (3) for billing, sales report distribution and system operations.
• Taught end-users the functionality and purpose of new hardware and software.
• Initialized end-user’s application environments within local/remote networked AS/400 host computers.
• Trouble-shooted and enhanced existing hardware/software applications to increase end-user job (tasks) response-time.
• Configured PC's (locally) to download sales-projection information into Lotus worksheets using AS400/PC-Support from respective end-user folders.
• Maintenance McDonnell Douglas Pick basic coding within sales-order-entry, accounting, manufacturing and shipping application systems.

Confidential

Project-Leader/-programmer, systems coordinator

Responsibilities:

• Designed/, developed and coded Pr1me data basic software to poll and collect national theater ticket, concession daily sales information.
• Designed and developed specifications for programmers to code sales-data interface software for immediate update to daily sales-ledgers.
• Performed daily system maintenance in preparation for next day polling.
• Interfaced extensively with end-users for amending applications, operations and technical support.

Confidential

Systems-analyst/programmer

Responsibilities:

• Responsibilities included designing and developing through implementation distributive processing of local and remote area networks. Using PR1ME (mainframe) and IBM, Tele video XT/AT's.
• Amended, tested and installed general-ledger software packages.
• Completed AR data conversions from Honeywell to PR1ME,
• Developed, designed and documented software for the company's Budget Dept. supporting (labor distributions, budget variances, etc.) forecasts for desired fiscal years.
• Developed PC data interface with mainframe supporting field servicing and personnel departments by installing and utilizing communication packages with LOTUS 123, SYMPHONY spreadsheets.
• Coded LATTICE "C" programs to create ASCII files for up/down loading from P.C. to mainframe.
• Designed, configured and documented respective Prime and P.C. data file grid layouts. Documented daily input/output flow of end-of-day operations.

Confidential

Systems Analyst-Programmer

Responsibilities:

• Performed needs assessments for three on-line application systems (Corporate-activity, Accounts Pay/Rec),
• Evaluated, enhanced, redesigned and documented respective data-bases for efficient and quick support of file/record creation, retrieving and updating information by end-users.
• Tested and maintained needed PR1ME hardware/software revisions,
• Performed routine hardware/software maintenance, continuously upgraded and re-configured system command files to conform with new peripherals.
• Performed maintenance software coding and development of the A/P, A/R systems
• Directed and schooled consulting personnel to conform with current client file designs and needs
• Scheduled data-entry personnel in support of end-of-day processing