John E Marchan Jr Email & Phone Number

New York, NY, US

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.

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.

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.

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

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.
• 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.
• 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.
• Modified various existing Excel macros used to create monthly reports using relative addressing rather than hard-coded address locations.

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.
• 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.

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.
• 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.
• 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.

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.
• Developed an MS Excel application that automatically extracted relevant budget information from another Excel master application developed in-house.

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.

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.

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.

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.
• 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.

Master Of Science (Ms), Computer Science

Bachelor Of Science (Bs), Computer Science