SUMMARY:

• Interacts with clients to develop solutions to business needs, leads team of developers and DBAs to create software product.
• Communicates with cross - functional business teams to gather requirements, design systems, develop code, install and upgrade databases, design tests, implement products and support systems in production.
• Identifies resources to meet the needs of specific projects.
• Worked with software products installed on multiple continents, involving hundreds of servers and terabytes of data.
• Creates technical training presentations, develops labs for application of material learned in presentations, mentor team members.
• Conversant with many developmental tools, programming languages and database products.

SOFTWARE:

Oracle, DB2, Sybase, SQL Server, MySQL, Supra, Hadoop, Neo4J, Redis, C, C++, C#, Java, Perl, COBOL, Assembler, Javascript, JSP, HTML, .NET, PHP, Korn, BASH, DataStage, Eclipse, Netbeans, Tomcat, Apache HTTPD, ALGS, Syncsort, EZTrieve, Microsoft Office suite, Wireshark, z/OS, Linux (many versions), Solaris, OOP design, many more

WORK EXPERIENCE:

Confidential, Temple Terrace, FL

Software Engineer/Team Lead/Database Administrator

Responsibilities:

• Performance Tuning Team Lead - monitor and analyze the expressTrak Billing System, the former MCI systems, and other adjunct and interfacing systems. Responsible for the efficiency of assembler, COBOL and DB2 systems, as well as the underlying architecture of the application and operating system software. Instruct new developers in proper coding and debugging techniques, design approach, testing, software tools, and DB2 efficiencies.
• Data Masking Team Lead/SME - mask sensitive data to meet regulatory requirements. Involves analysis of the systems accessing the data, maintaining data integrity across systems, building methods that disallow decryption yet remain human-readable, tune processes to reduce impact on applications and create automated processes running as background tasks. Effort involves multiple systems and environments: DB2, mainframe files, PC files, Oracle, Sybase and SQL Server databases, in systems from z/OS to Linux to Windows. Tools include SQL, DataStage, Perl, shell script, Java, C++, PHP, Javascript and COBOL. Developed and recorded data masking training course for Confidential ’s internal training series. Act in advisory role for multiple departments across the organization (100+), analyzing and approving their approaches to masking. Developed web-based data masking SQL generator using PHP and Javascript.
• Intranet tools - develop application for Performance Tuning to allow upper management to create ad hoc reports from mainframe system data. System statistics are loaded to SQL Server, Oracle and MySQL. The original website was created in Visual Studio using C#, as well as a DB2 interfacing web application. A secondary application recently created in PHP and Javascript.
• Designed and implemented a Legal Department Auditing website which front-ended an Oracle database; also designed database
• Federal Systems Support - DBA support for Oracle database for Federal Systems within Confidential, including building Oracle installations on new servers
• Database Administrator - support databases for multiple systems. Install and patch Oracle, maintain data elements, troubleshoot database issues, convert Shareplex replication to Golden Gate.
• Training - develop and present in-house training to enable employees’ to meet Confidential ’s 40 hour minimum yearly training goal. Topics include Linux installs, virtual machine software, SQL, Linux commands, Cloud overview, security, DB2 basics, Oracle basics, install/load balancing/failover of JBoss and Apache, and introduction to Android development.

Confidential, Port Washington, NY

Project Leader

Responsibilities:

• Oversee and train developers for system.
• Responsible for every phase of project life cycle: maintain rapport with clients to establish needs and efficient design, especially of Confidential ; design system interfaces; develop test conditions and monitor proper procedures; advise developers in code methodology and efficiencies; plan implementation and contingency procedures; obtain client approvals; install applications; verify post-implementation results with clients.
• Responsible for all facets of batch and online system maintenance and tuning, support all production issues and internal and external data transfer.
• Interface with users for development of new features and data retrieval to satisfy business needs.
• Oversee and assist team with development, testing, and installation of Year 2000 modifications.
• Development, testing and installation of new DB2 Customer Name and Address interface to system.
• Conversion, testing and installation of DB2 interface, replacing SPECTRA database.
• Oversee and assist with analysis and development of interface for fully-featured mainframe word-processing package; interface with all vendors supplying equipment for system and receiving data from system. The Customer Service System serves three purposes: it is a view to the Billing database, which is divided into two main tables of approximately 30 million rows each, with several related tables for each main table detailing customer account information. The second function is the updating of these tables with various transactions, averaging 13 million transactions yearly. The final function is the creation of customer correspondence. Every contact initiated by a customer that is affects their account is confirmed by generating letters based on billing data.
• Develop automated auditing procedures for Contest system.
• Develop new Contest Selection system
• Support Contest Selections and Prize Giveaways.
• Support all aspects of Magazine Fulfillment

Confidential, New York, NY

Programmer

Responsibilities:

• Developed Batch COBOL programs for the Confidential processing system.