John Cassens Email & Phone Number

Riverview, Florida, United States

Tampa/St. Petersburg, Florida Area

Support the technology behind the greatest Game on Earth.

Brandon, Fl

Clearwater, Florida

Business Analysis and ETL of existing Systems data into new Data Factory for Loading into new ERP System. SQL, SSRS, SSIS, and Power BI for reporting and dashboarding.

Clearwater, Fl

QA Data in Order Entry and Container Logistics Systems. Wrote Excel VBA code to integrate Sharepoint Data with SQL order database for Ticket tracking system.

Newark, Nj

• TrakSmart Administration – Work with Operations and RES project teams to implement new Energy Efficiency projects into the TrakSmart system. Support Design to capture project data, energy savings and cost data as mandated by the Board of Public Utilities and Internal Company Compliance. Monitor the system for Bugs and prepare reports for Vendor to resolve the issues. Add/Remove users and update program security. Request new features and test new code builds before promoting to… Show more • TrakSmart Administration – Work with Operations and RES project teams to implement new Energy Efficiency projects into the TrakSmart system. Support Design to capture project data, energy savings and cost data as mandated by the Board of Public Utilities and Internal Company Compliance. Monitor the system for Bugs and prepare reports for Vendor to resolve the issues. Add/Remove users and update program security. Request new features and test new code builds before promoting to Production.• Data Processing – Work with Operations and RES team to collect and scrub project data from old programs that pre-dated the TrakSmart system. Prepare TrakSmart Bulk Load Templates and re-format data into TrakSmart readable formats for import into the system. Maintain measure tables and fields for energy savings engineering calculations. Report Data Issues and work with team to make corrections. Work with BPU MIS to create code conversion tables to prepare for BPU electronic reporting via TrakSmart. • Energy Efficiency projects included Direct Install for Small Business and Government, Data Center, Warehouse, Hospital Efficiency, Technology Demonstration, Thermostat, and Whole House programs. Environment – Excel / Access VBA 2010, Oracle 11g/SQL Developer, Nexant TrakSmart, Jasper, XML. Show less

South Brunswick, Nj

Market Data Migration Project: Was a key developer in the conversion from Reuters to Six Telekurs and ICAP PLC data sources. Wrote new Excel VBA code and modified spreadsheets to accept new data source files that produce tables and charts for the Wall Street Journal and Barron’s. The articles were for both print and on-line web sites. Created test files and was responsible for QA of the data feeds, the VBA code, and the XML output that produces the article. Created data import… Show more Market Data Migration Project: Was a key developer in the conversion from Reuters to Six Telekurs and ICAP PLC data sources. Wrote new Excel VBA code and modified spreadsheets to accept new data source files that produce tables and charts for the Wall Street Journal and Barron’s. The articles were for both print and on-line web sites. Created test files and was responsible for QA of the data feeds, the VBA code, and the XML output that produces the article. Created data import classes/modules, updated user forms to include new data source options, modified toolbars, updated code to produce well formed XML output. Implemented Business Units requests for changes to article data and formats. Examined XML output in Methode (article layout/pagination software) verified article output formats properly with requested changes. Updated XML and CSS when needed to correct article formatting. Was a team player and assisted other team members with Financial data and VBA issues, and was responsible for the overall success of the project. Worked well with Business users and provided production support during cutover. Fully Documented spreadsheets and VBA code by writing word documents fully describing spreadsheet/article processes and transitioned to production support staff.Articles included:Barron's Market Laboratory section - Federal Reserve Dollar Index versus Euro and Yen Chart.Wall Street Journal Saturday Business & Finance section - World Value of the Dollar.Barron's Market Laboratory - Other Market Indexes.Barron's "The Trader" DJIA, SP500, Nasdaq, and Barrons's 400 Index Graph's Show less

370 7Th Avenue

• Provided Windows Server and desktop support to the office.• Wrote VBA scripts to retrieve file attachments (resumes) and e-mail contact addresses from Outlook mailboxes of recruiters who left the company.• Sourced teams including developers and project management consultants to leading Financial companies. Found technically qualified candidates that meet the project billing rate budget, technically screen them for functional and team fit, communicate the candidate’s value to the… Show more • Provided Windows Server and desktop support to the office.• Wrote VBA scripts to retrieve file attachments (resumes) and e-mail contact addresses from Outlook mailboxes of recruiters who left the company.• Sourced teams including developers and project management consultants to leading Financial companies. Found technically qualified candidates that meet the project billing rate budget, technically screen them for functional and team fit, communicate the candidate’s value to the project, and to negotiate and close the contract Show less

• Wrote Visual Basic Excel/Access system to automate the Specialist Break Report audits run after each trading day. System replaced a manual 2 hour process into an 5 minute task. System FTPed then parsed files from the NYSE, Comstock/Hyperfeed Pricing, and 3rd Party Clearing System, joined data from all systems and compared number of shares, price, and P/L figures for variance reporting.• Wrote VBA for Excel programs to merge specialist post assignments files to specialist trading PL… Show more • Wrote Visual Basic Excel/Access system to automate the Specialist Break Report audits run after each trading day. System replaced a manual 2 hour process into an 5 minute task. System FTPed then parsed files from the NYSE, Comstock/Hyperfeed Pricing, and 3rd Party Clearing System, joined data from all systems and compared number of shares, price, and P/L figures for variance reporting.• Wrote VBA for Excel programs to merge specialist post assignments files to specialist trading PL spreadsheets and build Access Database for daily and monthly Cents per Share performance reports.• Worked in a fast paced environment, monitored and resolved system wide issues on a daily basis to ensure reliability of market data servers and financial applications over the LAN and WAN• Interacted with field engineers, communication technicians and end users as a Technical Support Analyst supporting customers on a 24x7 basis• Set up a new office for the Clearing department which also served as the disaster recovery site for 40 Wall (trading/specialist operations)o Installed servers and applications including DTCC, Bank of New York Cash Register Plus, Options Clearing Corporation, SunGard Loanet, NASDAQ (NWII, NASDAQ Workstation), Hyperfeed/Comstock, Patrina Archiving, ISE options, Realtick, Bloomberg Professional, and Fastrack. NYSE applications SPF, CHOP, and FOCUS. o Primary Contact for all issues at the new facility, coordinated external vendor support and external programming consultants to resolve issues with data transmission, circuit outages, hardware and software issues. o Maintained system, facility records and maintenance contracts. Supervised repair, maintenance, and installations of the electrical, data, telecom, generator, and HVAC systems. Generated reports for compliance on Sarbanes-Oxley audits, as well as historical research and special requests for NYSE, SEC, and internal audits. Show less

Implemented a high priority global logistics distribution system. Liaison between US, Japan, and China MIS personnel. Specified server hardware and software and worked with internal/external developers to install and test code. Traveled to Japan and China to install the system at the Narita, Nagoya, and Shanghai locations. Diagnosed and assisted in the resolution of problems with the VPN/Firewall and ICH file transfer. Wrote C program to reformat input files that did not load… Show more Implemented a high priority global logistics distribution system. Liaison between US, Japan, and China MIS personnel. Specified server hardware and software and worked with internal/external developers to install and test code. Traveled to Japan and China to install the system at the Narita, Nagoya, and Shanghai locations. Diagnosed and assisted in the resolution of problems with the VPN/Firewall and ICH file transfer. Wrote C program to reformat input files that did not load properly.Novell - Created Zenworks app installation packages for Oracle & Sybase Clients, McAfee VirusScan, Attachmate Term emulator, MS SNA client, and PowerBuilder/3rd party apps. Maintained user lists/security settings. Monitored disk usage, adjusted quotas, purged files, and added disk capacity as required.Restored file deletions using Salvage, Legato, and Veritas tape restores. Application and Web servers Windows 2000 - Installed Sybase server, MS-SQL server, or Oracle client as required by applications. Configured FTP, Shares, and file rights to allow developer access to the servers. Added/deleted accounts to groups to maintain security on the servers. Worked with developers/vendors to install applications (Focus Report Server, Dunn and Bradstreet DIG, Apex A/P software, Bridgeway e-Counsel, Omtool Fax Sr., McAfee ePolicy Orchestrator, Access 360 Exchange Agent (for ESM/RAS). Worked with Network group to get proper firewall access for externally hosted databases.Server Room - Order, build, & rack HP Servers to meet requirements.Query Cisco Switches for open ports and VLAN information to obtain necessary network connections for servers and management cards. Maintain inventory database with all cabinet, contact, IP/Domain, and serial # information. Y2K and Server consolidation project - Migrated over 40 servers from Novell 3.12 to Netware 4.11 NDS for a 2200 user, 4 building campus. Migrated login scripts, data, apps, and print queues into the directory. Show less

• Streamlined multiple manual and automated processes that produced Financial Research reports into single job stream using Focus• Created restatement tables to correct markdown errors in point of sale system• Prepared manual backup to automated financial reports. Helped Audit the Distribution Center Inventory• Wrote programs in Data Analyzer for Financial Research

Bachelors, Finance - Minor Computer Information Theory And Marketing

Activities and Societies: Swim Team, Rugby Club, Hot Dog Day Fundraiser and St. Patricks Day Parade events.

High School Diploma