Dennis Spera Email & Phone Number

New York City Metropolitan Area

Support Of the MongoDB platform for high security applications

Garden City, N.Y.

Systems Engineer utilizing software engineering tools to support a premier global credit card processing platform. Kubernetes, Docker and Python data science modules and libraries. Jenkins, Jira, Git, Visual Code, Pycharm, Visa and MasterCard propriety software mastery.• MasterCard® and Visa® TC57/IPM/CTF file structure analysis and troubleshooting• Designed and Implemented Perl System Architecture • Developed modern Perl OO infrastructure to interface with Fidelity’s FIS Software• Multi-currency POS, ATM, e-commerce and VISA® emerging market compliance• Escalating system issues to NOC and relevant hardware/software support• Intimate knowledge of Fidelity’s FIS Clearing Integrated product Suite• Partnering and sharing with PP colleagues globally in Beijing, Bermuda, Dubai, Dublin, Hong Kong, London, Mexico, Shangai, Singapore and Toronto as well as domestically.

Hauppauge N.Y.

• Created and Maintained Schema objects like table spaces, tables, indexes, constraints, ...views, materialized views, synonyms, DB links, sequences and triggers. • Experience with replication and migration using oracle data migration utilities ..including SQL*Loader, Export/Import, DATAPUMP. • Expertise with Database Administrative tools like Oracle Enterprise manager (OEM), ..SQL*PLUS, TOAD, SQL Developer. • Experience in all phases of Software Development Life Cycle (SDLC) • Experience in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks.

Bethpage, N.Y.

• Development of backend packages, procedures, functions, triggers and other underlying objects used within the KOMS backend operational data store which ultimately populate the fact tables. • Understanding business Metrics populated within KOMS ® front end (MicroStrategy) application. Knowledge of the flow of metrics from detailed report, summary reports up to the executive dashboard, Allowing Cablevision Executives to have a thorough understanding of the business they are managing.• Intimate knowledge of Application source tables, Dimension tables and fact tables and their inter-relationship to each other.

60 Wall St., N.Y.,N.Y. 10001

* As a application DBA some of my duties (although not exhaustive) included schema design, objectpartitioning and object fine tuning.* Analysis of indexing requirements and examining index Clustering Factors and B-tree level height to ensurethe CBO is using them properly.* Other responsibilities include, PL/SQL development supporting the iCRES ®, risk management software forderivative transactions. Inclusive of but not limited to Futures, Options and Loans.* I additionally contributed to the Perl development effort for the New York portion of the iCRES kernellocated in Frankfurt Germany. In addition to these skills I am was also responsible for supporting 3000feeds coming in from all parts of the globe which make up the iCRES ® system (Perl, PL/SQL).

New York, Ny

* Data Warehouse Project: * Built the warehouse prototype in a distributed environment residing on Sun Microsystems ES6000(s) + ES4000(s), This project allowed us to be in a ‘go’ state when we received Chase Manhattan Bank’s first of many ES10000 multi-domain servers.* Upon receipt of the server, developed the strategy for exploiting the ES10000 including domains/sizes/function; how to best exploit the gigaplane architecture in loading the warehouse* extracting from the warehouse and loading the CVMG Datamart.* Working with EMC engineers, developed the physical/logical strategy that provided the most parallelization based on the footprint of the resources, coupled with the knowledge this would be a highly de-normalized schema.* Implemented Platinum’s DB vision database monitoring suite and Teleran's Adaptive Query Management tools.* Led team using Perl to develop the warehouse update process, including CNT downloads, split and load processing and index builds using a process that was dynamic to the environment, so as to not need updating as changes to the schema were made. This was accomplished by dynamically generating batch scripts from the schema dictionary tables. Comprehensive end-user support; endusers * Chase Auto Finance Datamart (CAF) Project: * DBA/Developer/SA responsible for the design and implementation of the CAF Datamart I ordered the hardware, built all the logical volumes and designed the database. I was required to serve as both a Sun Solaris System Administrator and Oracle DBA/Developer of an existing ES6000 server and evaluating it for use as a CAF Datamart database server. * Chase Auto Finance CRM Project:* Chase Auto Finance Servicing Website Project:

235 Pinelawn Rd, Melville, Ny 11747

* Administered the replicated environments and deployed to new replication sites.* Involved in the Year 200 projects to assure the applications are Y2K compliant.* Participated in the database upgrade from Oracle 7 to Oracle 8, and provided support for Oracle upgrade, application installation and operation, and database implementation at the Post.* Installed Oracle software and implemented database and applications on the server. Responsible for monitoring and troubleshooting the database environment.* Analyze the database performance and performed database performance tuning.* Document database procedures and responsible for organizing and instructing training

United States

Served Aboard USS John F. Kennedy making 2 deployments to Europe and Asia Injured in the Line of Duty

B. Sci., Computer Science

Education record

Oracle Performance tuning Oracle Backup and recovery Oracle Real Application Clusters Oracle Data management and storage internals Oracle.