SKILLS SUMMARY:

• Oracle PL/SQL 6+ 2014
• Sybase 9+ 2014
• MS SQLServer 15 2006
• DB2 1 2008
• Postgresql 5 2016
• MySQl 1 2013
• Unix Script 8+ Current
• DOS/Windows/Basic Script 10+ 2008
• Cobol 3 1990
• C,C++,C# 2 2002
• VB/VBA 5 2003
• ASP.Net 1 2003
• Java 3 2016
• JavaScript 1 2004
• AbInitio(ETL) 3 2008
• Sunopsis(ETL) 4 2014
• Sybase Replication (ETL) 5 2014
• Informatica(ETL) 1 2007
• Talend 1 2016
• Windows NT/2000/XP Network Admin 4 2002
• Business Objects 1 2007
• Cognos 1 2008
• MVS/TSO 6 2008
• CVS 5 2016
• SVN 2 2106
• MS VCS 2 2003
• LogRhythm 3+ current

WORK HISTORY:

Security Tools Administrator

Confidential, Albany, NY

Responsibilities:

• Worked along side Operations and Security Teams to stabilize their current LogRhythm SIEM platform.
• SQLServer was utilized as the database supporting the SIEM.
• I upgraded platform( Windows 2000 to 2016 and SQLServer2012 to SQLServer2016) and enhanced the security monitoring to meet the Confidential needs.
• Having DBA experience was necessary to support maintenance and researching issues and we had many occasion to utilize my knowledge of transaction logging to resolve system and performance issues.
• And I did utilize my skills to support maintenance and researching issues.
• I did have many occasions to utilize my knowledge of transaction logging when issues occurred.

Database Developer

Confidential, Saratoga, NY

Responsibilities:

• Installed and tuned Postgres database.
• Migrated DB2 procedures to Postgres.
• Worked with Development team to remove some processing in Java to procedures to bring nightly processing from over 24 hrs to 2 hrs.
• Developed model VMs for customer installations and began migrating customers to Postgres platform.

DataAnalyst

Confidential, St, Albany, NY

Responsibilities:

• Extracted Data From Oracle database(s) for graphical input to web pages for clients.

Database Developer

Confidential, Queensbury, NY

Responsibilities:

• Position required developing and maintaining many procedures ( T - SQL and PL/SQL) for Sybase and Oracle in addition to many triggers and functions.
• Responsible for replication/transformation from Sybase to Oracle/AWS and Postgres environments using Sybase replication and custom procedures.
• Developed and maintained several java applications in conjunction with HTML to support some of our monitoring tools.
• Used UNIX shell and perl scripts in combination with PL/SQL, crontab for some database maintenance( update statistics, DBCC checks,ANALYZE and DBMS STATS) and preventative alerts.
• Performance monitoring and tuning of Sybase and Postgres environment.
• Provided rotational oncall support for all database activities.
• Reviewed and recommended design standards for all database design.
• Often tuned queries for myself, application developers,and team members using query plans, cached plans, etc for increased efficiencies.

Lead Applications Developer

Confidential, Albany, NY

Responsibilities:

• I migrated Unix scripts from SunSolaris to Linux RedHat as well as coding several new Sybase procedures and refactoring existing PL/SQL procedures.
• Several new applications in Java were required, all to support the merge.
• We upgraded Oracle from 8 to 9i and converted their SQLserver apps into Oracle.
• Many new applications in Java were necessary and a new Oracle schema were architected to support a Data repository for regulatory reporting.
• There were several customized MS Access data feeds we supported from the Oracle data warehouse .
• I then joined their Risk and Compliance department developing Anti-Money Laundering systems for Fraud Detection that utilizes an Oracle 9i/linux application with Java and Informatica interfaces. AbInitio is used to extract data required for money-laundering analysis from the legacy mainframe data repositories.
• I converted from Business Objects to Cognos all reporting.
• After the merge, we reviewed and redesigned our MSSQL databases that supported our web faces to assure it accommodated all our new business.

Contracted Programmer

Confidential, Albany, NY

Responsibilities:

• Unix and Oracle Database developer for Confidential .
• Developed Testing Utilities using Unix script, PL/SQL,HTML,Java and implemented upgraded Claims processing system.

Programmer

Confidential, Albany, NY

Responsibilities:

• Developed Fraud datacapture system with Domino Forms frontend and converted Access
• DataBase to Oracle Database. Reviewed and designed PL/SQL procedures to audit data transformation maintained for their International Leasing System.