John Squires Email & Phone Number

Palisades, Ny

Palisades, Ny

Collecting, processing and mapping census and boundary data for the NASA Socioeconomic Data and Applications Center (SEDAC) project "Gridded Population of the World (GPW), v4". Writing Python scripts and creating maps for numerous data publications including Global Estimated Net Migration Grids By Decade and The Global Grid of Probabilities of Urban Expansion to 2030. Synthesized and scripted data to produce an analysis of supply chain risk due to selected natural hazards for a major corporate… Show more Collecting, processing and mapping census and boundary data for the NASA Socioeconomic Data and Applications Center (SEDAC) project "Gridded Population of the World (GPW), v4". Writing Python scripts and creating maps for numerous data publications including Global Estimated Net Migration Grids By Decade and The Global Grid of Probabilities of Urban Expansion to 2030. Synthesized and scripted data to produce an analysis of supply chain risk due to selected natural hazards for a major corporate manufacturer. Building a web application so citizen scientists can report on bioswales for a Coastal SEES initiative to improve green infrastructure in the Bronx River Sewershed. Validated prediction model by using Google Earth to verify building heights and structure composition at various locations across the globe for a NASA funded project developing global building exposure for disaster forecasting, mitigation, and response. Show less

Columbia University, New York City

Created scientific equivalencies, along with a team of Columbia seniors and the artist Mary Miss, for the project Broadway: 1000 Steps, a sustainability initiative to establish Broadway as a green corridor where current and planned sustainability initiatives, such as those outlined in the City’s PlaNYC, will be made tangible to its citizens. Built the framework and mapping platform for a Broadway Corridor Network of neighborhood partners and artists to help maintain the project.

Columbia University, New York City

Project manager for the Social Venture Challenge, a competition by venture capitalists to fund student created sustainable projects. Facilitated communication between Student Union, the Earth Institute and Columbia University to enlist students to apply. Participated in peer-to-peer academic advising and launched the student group as a founding member.

Greater New York City Area

Researched annual reports of oil and shipping companies, in particular how they are viewing climate change as opportunity. Analyzed survey results for director of center. Attended weekly lunch conferences with guest speakers from organizations such as the EPA and NRDC.

Greater New York City Area

Contributed to the design and testing of a new reporting system to quantify, track and budget for each Millennium Village, allowing the operations team to see the results of their work in an easy to understand and accessible format. Assisted in creating training materials, and gathered feedback from teams. Analyzed management costs throughout Millennium Villages, working with budgets and work plans. Updated Quickbooks database and Excel spreadsheets.

• Integrated over a thousand trading partners into a major e-commerce company’s supply-chain system• Ran trading partner’s EDI documents through an EDI translator to check for compliance with client's specifications• Retrieved output files and checked file was compliant with the supply-chain system's 850, 855, 810, 856, 846 and 997 EDI transaction specifications. • Set up and tested business-to-business data transport solutions using the following protocol options: AS2, FTP, and… Show more • Integrated over a thousand trading partners into a major e-commerce company’s supply-chain system• Ran trading partner’s EDI documents through an EDI translator to check for compliance with client's specifications• Retrieved output files and checked file was compliant with the supply-chain system's 850, 855, 810, 856, 846 and 997 EDI transaction specifications. • Set up and tested business-to-business data transport solutions using the following protocol options: AS2, FTP, and VAN.• Provided business rule context to trading partner’s clients.• Resolved post-production issues with finance, receiving, shipping, catalog and buying teams.• Wrote training manuals on how to set-up and test EDI documents and transmission methods.• Maintained workflow database for e-commerce site, chronicling hundreds of vendors and their status in the system. Show less

• Resolved technical tickets and performed on-call pager duty: investigated, troubleshot, and solved tickets issued from internal teams; monitored ordering pipeline and supply chain systems; worked with developers, engineers and database administrators to resolve any problems during work day and on-call shifts.• Edited and rewrote Perl and C/C++ code to resolve problems and add improved functionality to supply-chain systems, monitoring processes, and automation of systems during outages… Show more • Resolved technical tickets and performed on-call pager duty: investigated, troubleshot, and solved tickets issued from internal teams; monitored ordering pipeline and supply chain systems; worked with developers, engineers and database administrators to resolve any problems during work day and on-call shifts.• Edited and rewrote Perl and C/C++ code to resolve problems and add improved functionality to supply-chain systems, monitoring processes, and automation of systems during outages. • Wrote SQL scripts to query databases for problem solving.• FTP’d stalled order files for reprocessing.• Investigated why customer orders and purchase orders were not processing, i.e. determined if order was canceled, the SKU was suppressed, or if there were file format problems, etc.• Restarted servers and daemons after hardware crashes & database outages.• Researched & fixed discrepancies from external vendor data feeds.• Created documentation that detailed how to troubleshoot systems. Show less

• Engineered EI monitoring system to automatically create technical tickets and send email notifications to the appropriate resolver groups and customers by retrofitting Perl and shell scripts into the system.• Wrote Perl scripts to check if too many files (purchase orders, shipping files, and invoices) were stalled in the system.• Created a business proposal and technical spec so that internal users would no longer need to monitor “cascades” (EDI distributor ordering system). The… Show more • Engineered EI monitoring system to automatically create technical tickets and send email notifications to the appropriate resolver groups and customers by retrofitting Perl and shell scripts into the system.• Wrote Perl scripts to check if too many files (purchase orders, shipping files, and invoices) were stalled in the system.• Created a business proposal and technical spec so that internal users would no longer need to monitor “cascades” (EDI distributor ordering system). The improved system would re-FTP purchase orders and purchase order acknowledgment files; and email distributor contacts when necessary.• Wrote Perl scripts to automate EI processes and tasks such as emailing vendors and handling EDI rejected files.• Developed scripts to “insert” and “select” from the EI Database by using Amazon::Oracle::Session Perl module and SQL knowledge.• Resolved EDI Development team technical tickets by implementing Mercator (third-party EDI software) map and type-tree changes. Show less

• Managed EDI distributor ordering system• Coordinated operational trouble-shooting procedures for direct-to-customer drop-ship system.• Advised product teams how to improve margins by utilizing EI system.• Interviewed and integrated new distributors.• Managed distributor orders from demand to receive ensuring: accurate forecasting, best margins, fast turn-around times, and orders were being filled correctly and shipped in a timely fashion.• Suggested and implemented changes… Show more • Managed EDI distributor ordering system• Coordinated operational trouble-shooting procedures for direct-to-customer drop-ship system.• Advised product teams how to improve margins by utilizing EI system.• Interviewed and integrated new distributors.• Managed distributor orders from demand to receive ensuring: accurate forecasting, best margins, fast turn-around times, and orders were being filled correctly and shipped in a timely fashion.• Suggested and implemented changes to optimize electronic-ordering process (scale systems, fill-rate analysis, EDI turn-around times, etc.) • Worked with global EI counterparts to instill knowledge and ensure the EI systems were providing them with the functionality that they required.• Wrote trouble-shooting Standard Operating Procedures and documentation for EDI department documents.• Led root-cause analysis for vendor operational and technical issues as Operational Excellence leader.• Hired, trained, and developed new employees. Show less

• Ordered 75,000-150,000 items each shift via EDI.• Solved problems in EDI ordering system such as fixing ftp issues, corrupt order files, inaccurate purchase order acknowledgements and incorrectly formatted electronic EDI documents.• Analyzed confirmation turn around times, fill rates, and order integrity and made improvements by working with vendors, distribution centers and buying teams.• Updated electronic ordering configuration files (edited using vi & emacs) to reflect current… Show more • Ordered 75,000-150,000 items each shift via EDI.• Solved problems in EDI ordering system such as fixing ftp issues, corrupt order files, inaccurate purchase order acknowledgements and incorrectly formatted electronic EDI documents.• Analyzed confirmation turn around times, fill rates, and order integrity and made improvements by working with vendors, distribution centers and buying teams.• Updated electronic ordering configuration files (edited using vi & emacs) to reflect current policies and ordering strategies determined by the buying managers. Show less

• Researched and sourced authors and publishers.• Set up new accounts and placed book orders.• Maintained publisher database.• Trained new Special Orders Buyers.