John E Marchan Jr Email and Phone Number
Strong SQL Server / VBA developer with proven problem-solving ability, solid analytic skills, and over 15 years of experience developing applications.
-
Adjunct ProfessorMercy University Sep 2019 - PresentDobbs Ferry, New York, United StatesAs 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. -
Software EngineerZebra Technologies Oct 2018 - Dec 2018Holtsville, NyAs 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. -
Computer Programmer ConsultantSociété Générale Jan 2018 - Apr 2018Jersey City, NjAs 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. -
Computer Programmer ConsultantDouglas Elliman Real Estate Nov 2017 - Dec 2017Dix Hills, NyAs 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 -
Computer Programmer ConsultantBroadridge Financial Solutions Limited Feb 2017 - Jun 2017Brentwood, 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. -
Computer Programmer ConsultantNyu Langone Medical Center Oct 2016 - Dec 2016New 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. -
Technical ProgrammerMarks Paneth Llp May 2008 - Jun 2016New 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. -
Computer Programmer ConsultantMerck Oct 2006 - Mar 2008Rahway, 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. -
Computer Programmer ConsultantConed Solutions Mar 2006 - Jun 2006Valhalla, 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.
-
Applications DeveloperRisk Management Planning Group, Inc. Nov 2004 - Mar 2006Mineola, 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.
-
It ConsultantJemconsulting May 2002 - Nov 2004Woodside, NyAs 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.
-
Supervising Senior, Applications Developer/Manager, Programmer/Analyst, Programmer/AnalystKpmg Us Sep 1990 - May 2002New York, Ny; Montvale, Nj; New York, Ny; New York, NyTax 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
-
Computer Science -
Computer Science
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial