John E Marchan Jr

John E Marchan Jr Email and Phone Number

Adjunct Professor at Mercy University @ Mercy University
John E Marchan Jr's Location
New York City Metropolitan Area, United States
About John E Marchan Jr

Strong SQL Server / VBA developer with proven problem-solving ability, solid analytic skills, and over 15 years of experience developing applications.

John E Marchan Jr's Current Company Details
Mercy University

Mercy University

View
Adjunct Professor at Mercy University
John E Marchan Jr Work Experience Details
  • Mercy University
    Adjunct Professor
    Mercy University Sep 2019 - Present
    Dobbs Ferry, New York, United States
    As an Adjunct Professor, I have been assigned to teach an Introduction to Computers (CISC/MATH 120) course on the various campuses of the institution: Bronx, Dobbs Ferry, Yorktown, Manhattan.
  • Zebra Technologies
    Software Engineer
    Zebra Technologies Oct 2018 - Dec 2018
    Holtsville, Ny
    As a contractor for Infobahn Softworld Inc., I was assigned to the Holtsville, NY location where I work in the Zebra Retail Solutions department with a Team of Software Engineers maintaining web applications designed to keep inventory of client’s merchandise using hand-held scanners that transmit the data directly to the database servers. From the data collected, a great variety of reports are generated, and the clients can access their information on the web.
  • Société Générale
    Computer Programmer Consultant
    Société Générale Jan 2018 - Apr 2018
    Jersey City, Nj
    As a contractor for M-Logic Inc., I was assigned to the Jersey City, NJ location where I developed a database designed to keep track of the interactions between Controllers and Remediators of the KYC (Know Your Client) program, which keeps track of the bank’s investing customers to validate their activities.
  • Douglas Elliman Real Estate
    Computer Programmer Consultant
    Douglas Elliman Real Estate Nov 2017 - Dec 2017
    Dix Hills, Ny
    As a contractor for Robert Half Technology, I was assigned to the Commercial Real Estate division in Dix Hills, NY where I developed an MS Access application designed to keep track of the agents’ activities by matching buyers and sellers with their listings
  • Broadridge Financial Solutions Limited
    Computer Programmer Consultant
    Broadridge Financial Solutions Limited Feb 2017 - Jun 2017
    Brentwood, Ny
    • As a contractor for Robert Half Technology, I was assigned to the Acquisition Integration & Financial Systems Strategy group in Brentwood, NY where I supported existing MS Access applications used to keep track of the financial dealings with their clients: Credit Memos, Refunds, Prepayments, etc.• Changed approach used to produce monthly Aging reporting with MS Excel. I implemented the use of MS Access to process the raw data, and wrote Excel VBA code to format and produce the final reports which were distributed to Collectors to keep track of their dealings. The implementation helped minimized the changes made to the source data provided by the Oracle team.• Wrote MS Access VBA application that used source data provided by the Oracle team to generate monthly reports for the Sales Group. Raw data from Oracle would be processed in MS Access where final reports converted to Excel would be e-mailed to their respective recipients.• Modified various existing Excel macros used to create monthly reports using relative addressing rather than hard-coded address locations.
  • Nyu Langone Medical Center
    Computer Programmer Consultant
    Nyu Langone Medical Center Oct 2016 - Dec 2016
    New York, Ny
    • As a contractor for Vertex Group Inc, I was assigned to the Immunohistochemistry Core Laboratory of the Office of Collaborative Science in New York, NY where I enhanced an MS Access application used to keep track of both antibody specific and methodological characteristics per industry wide best practices.• The application was intended to share the results of research performed among the various labs within the hospital, and kept an inventory of the materials used to perform the experiments.
  • Marks Paneth Llp
    Technical Programmer
    Marks Paneth Llp May 2008 - Jun 2016
    New York, Ny
    • Maintained and enhanced an MS Access/SQL Server application used to provide financial and productivity information on a monthly basis to approximately 500 partners/employees. By using SQL Server as a back end, the application saved the Firm $10K in annual fees to compress the data.• Developed SSIS package, modeled after applying SQL Profiler tool, to keep track of Client Fees. Package ETL’d Excel source data into a SQL Server table where various stored procedures validated the data, and submitted it for billing.• Use SQL Profiler to debug stored procedures that were used by the Time Management Program System.• Wrote various SSIS packages that backed up and maintained various databases on schedule.• Wrote various SSIS packages that ETL raw data (text and Excel) into the corresponding databases.• Wrote various stored procedure for Human Resources (HR) designed to keep track of employees Floating Holidays, Holidays, Personal Time Off.• Developed an MS Access/SQL Server application to keep track of how the professional staff is allocated among the various departments of the Firm.• Maintained and enhanced an MS Access/SQL Server application designed to alert tax managers when various tax filings were due.• Worked with Developer Architect on a Dashboard project to write and test the SQL 2012 portion by building a normalized database to house the data. The web application tracked A/R, WIP, Collections, Reserves, Employee Productivity, and Operational Costs.• Worked with the Salesforce team in the integration process of the existing client base. Built test database modeled after the Production database to store test outcomes.
  • Merck
    Computer Programmer Consultant
    Merck Oct 2006 - Mar 2008
    Rahway, Nj
    • As a contractor for Paragon Computer Professionals, I was assigned to the Clinical & Regulatory Information Services, Clinical Research Systems, and Experimental Medicine of Merck & Co., Inc. in Rahway, NJ.• Developed an MS Access application used as a Capacity Planner tool. Merck Business Unit showed interest in adapting the application company wide.• Developed an MS Access database that consumed the output of a Web Service. This project was part of the Learning Management System to track the qualifications of individuals selected to participate in the various clinical studies, and to ultimately comply with the Federal Drug Administration. Used SQL Navigator to verify data accuracy originated from Oracle database.• Developed an MS Excel application that automatically extracted relevant budget information from another Excel master application developed in-house.
  • Coned Solutions
    Computer Programmer Consultant
    Coned Solutions Mar 2006 - Jun 2006
    Valhalla, Ny
    • As a contractor for Information Technical Solutions, I was assigned to ConEd Solutions in Valhalla, NY, a subsidiary of ConEdison energy provider.• Provided technical support to Customer Service by processing energy consumption data to produce monthly billing by creating, using or modifying existing SQL stored procedures.• Wrote ASP .NET application to update database from errors generated when running the billing process.• Converted existing reporting package from MS Access to MS Reporting Services.
  • Risk Management Planning Group, Inc.
    Applications Developer
    Risk Management Planning Group, Inc. Nov 2004 - Mar 2006
    Mineola, Ny
    • Developed new and maintained existing .NET applications that generated monthly reports in Excel for various clients among which were Metropolitan Transit Authority, FOJP Hospitals, and New York City Housing Authority.• Wrote scripts to extract source data to generate monthly reports from a Business Objects application.
  • Jemconsulting
    It Consultant
    Jemconsulting May 2002 - Nov 2004
    Woodside, Ny
    As an IT consultant, the clients I serviced included:• KPMG Japanese Practiceo Designed MS Access database applications to track accomplishments for partners of the Audit Practice, and to prepare monthly financial statements for the entire practice.• Deepdale Gardens Community Councilo Redesigned by enforcing data integrity, improved by tightening code and enhanced MS Access membership database interface which resulted in substantial savings on consulting fees.• Finaly General Contractorso Revamped an MS Access client database with features that included project estimation.• The Sophie Davis School of Biomedical Educationo Designed and developed a multi-user MS Access 2000 database application geared to maintain demographical and medical information on patients of the Morris Heights Birthing Center.
  • Kpmg Us
    Supervising Senior, Applications Developer/Manager, Programmer/Analyst, Programmer/Analyst
    Kpmg Us Sep 1990 - May 2002
    New York, Ny; Montvale, Nj; New York, Ny; New York, Ny
    Tax Management Solutions Practice - Supervising Senior Tax Specialist – New York, NY Feb 2001 – May 2002As part of team, developed standards for the use of tools and code optimization, wrote data dictionaries, designed and developed various applications and prototypes including:Tax Technology Practice – Applications Developer/Manager – Montvale, NJ Jul 1995 – Feb 2001• Designed and wrote the interfaces for numerous databases and web-based applications for external and internal clients including Citibank, Chevron, 3COM, KPMG International Practice, and KPMG Executive Committee.• Designed a web-based Chargeability Forecast Application consisting of an MS Access 2000 back-end database and ASP pages with VB Script.• Ported MS Access 2000 marketing database application to MS SQL 7 for KPMG Consulting.• Designed report package for an in-house application, KPMG Link, using Crystal Reports. It was a tool designed to assist expatriates to maintain tax information for submission and preparation of tax returns.• Japanese Practice Tracking System. Ported and enhanced an application interface from Visual Basic 5 to Visual Basic 6 that included a reporting package designed in Crystal Reports.• Ported and enhanced the application interface for AppUse Tracking System from Visual Basic 5 to Visual Basic 6, and the back-end database from MS Access 97 to MS Access 2000.• Wrote all the SQL statements and designed the entire commission reporting package for 3COM to develop a package that generated monthly commission statements from an MS SQL7 back-end database.• Played a key role in the firm-wide Y2K-compliant conversion of existing financial and client-based systems.State and Local Tax Practice (SALT) - Programmer/Analyst – New York, NY Jan 1993 – Jul 1995Management Consulting Practice - Programmer/Analyst – New York, NY Sep 1990 – Jan 1993

John E Marchan Jr Education Details

Frequently Asked Questions about John E Marchan Jr

What company does John E Marchan Jr work for?

John E Marchan Jr works for Mercy University

What is John E Marchan Jr's role at the current company?

John E Marchan Jr's current role is Adjunct Professor at Mercy University.

What schools did John E Marchan Jr attend?

John E Marchan Jr attended The City College Of New York, The City College Of New York.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.