SUMMARY

• A highly experienced software developer, database administrator and analyst with expertise in financial services and the public sector. Managed numerous projects to create systems in support of retirement annuity, mutual fund and individual portfolio products. Managed system conversion from ADABAS to relational databases (SQL and ORACLE). Responsible for production support of mission critical applications, including net asset value calculations.

TECHNICAL SKILLS

• CICS, COBOL, NATURAL, JCL, TSO/SPF, MVS, Z OS, VM/CMS, Panvalet, Predict
• Microsoft SQL Server, Oracle, ADABAS, ADASQL, ADAMINT, ADABAS Utilities, EntireX, VSAM, DB2, PL/SQL, SQL Plus, TSQL, SSIS, DTS, Access, DAO, ODBC, OLEDB, ADO, Informatica, Enterprise Manager, DBArtisan, SQL Navigator, Toad and Red Gate Suite
• Visual Studio, C/C++, VB, ASP, IDL, VBScript, JavaScript, OLE, HTTP, FTP, XML, HTML, Crystal Reports, SQL Reporting Services, Power BI, Visual SourceSafe, StarTeam, and ANT.
• Microsoft Teams, Eagle PACE/STAR, Gentran, Autosys, CA Scheduler, 24x7 Scheduler, Internet Information Services (IIS), Remote Desktop Services, IBM Mainframe, Mobius Reporting, VMWare, Virtual Server/PC, Microsoft Office Suite (Outlook, Word, Excel, Visio, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential

Mainframe Developer

Responsibilities:

• Team successfully transitioned from office - based to remote work during COVID-19 crisis by incorporating new tools and improving communication and productivity in the process
• Analyzed legacy CLIPS system; designed and developed Natural/ADABAS programs to extract data from ADABAS files. Incorporated CLIPS reports with PASSPort system based on SQL Server
• Created SQL server infrastructure (DBs, tables) to load data from an Oracle based Financial Management System (FMS)
• Set up weekly SQL Server jobs to load FMS Contracts data from production ORACLE to Test SQL Server environments using SSIS projects and SQL Stored Procedures
• Developed enterprise reports and documentation based on defined requirements for projects in Procurement System; used ad hoc SQL queries to resolve performance issues
• Enhanced over 40 reports for better performance
• Created multiple by request EXCEL spreadsheets by loading data from PASSPort or FMS system.
• Developed and built business rules for the ETL processes that translates to Doing Business Accountability Project (DBAP) for NYC.
• Documented workflow and integration database modeling and data mapping of Procurement and Sourcing Portal
• Prepared BRD and FRD documents to be reviewed by business users and requested by Senior PMO Management
• Reviewed work of other team members, provided suggestions for improvement and performed knowledge management functions

Confidential, NJ

Software Architect and System Administrator

Responsibilities:

• Cloud based database and web server administrator
• MS SQL Server database design, development and implementation
• XML file processing, job scheduling

Confidential

Lead Developer

Responsibilities:

• Mapped ADABAS data to ACCELA, request new descriptors and superdescriptors to speed up downloads.
• Developed & tested various batch programs to download data from ADABAS files to ACCELA.
• Using Natural/EntireX broker developed and tested real time processes to upload Mainframe data to ACCELA and update ADABAS files using ACCELA data.
• Developed new on-line functions (COBOL, CICS, and SQL) to map ACCELA to new department’s initiative.

Confidential

IT Specialist

Responsibilities:

• Computer and Network support,
• Infrastructure setup (wireless network, switches and other peripherals)

Confidential, Rye Brook, NY

SQL Server Developer

Responsibilities:

• Developed, tested and implemented Local Route To Number VOIP system (LRN-VOIP).
• Enhanced the LERG (Local Exchange Route Group) International Billing system. Created new stored procedures, tables, views and triggers. Coded batch script files for ABAT scheduler.
• Converted Excel Reports from ODBC to ADO in order to put reports into the network environment.
• Deployed the LERG system to a new platform. Ran parallel tests on new and old environments. Fixed problems as they occurred and provided comparison reports.
• Created functional specifications and implementation documentation.

Confidential

Software Developer and Network Manager

Responsibilities:

• Supported the entire computing environment of a 20 person small business, including servers, desktops and the physical network.
• SQL server DBA- Supported and enhanced the “Everest” application to provide the company with automated business management capabilities.
• It is based on SQL Server 2005. Created new functions to support inventory management, sales and accounting using SQL Server stored procedures and triggers on the server and C#/.NET on the client.
• Used Crystal reports to support the new functions.

Lead Developer

Confidential

Responsibilities:

• Retirement Annuity Funds - Leading member of a consulting team which created CAIMS (CREF Accounting and Investment Management System). Designed and developed the following modules:
• Pricing, Corporate action, Holdings, Trades, History and Archiving, Statutory Reporting System.
• Provided incremental improvements, production support and maintenance after project completion over 15 years.
• Treasury - Project leader for the Treasury Commitment Mortgage and Real Estate application (cash flow projections).
• Led a team of 3 developers for 6 months until project completion.
• Provided incremental improvements, production support and maintenance for 10 years.
• Mutual Funds - Adapted all CAIMS systems to MPAS (CREF Mutual fund system) and added new functions.
• Supported mission-critical Net Asset Value (NAV) Calculation application for 5 years.
• Provided incremental improvements, production support and maintenance for 10 years.
• Euro and Y2k Conversion - Annuity and mutual fund systems.
• Migration of data from ADABAS to ORACLE database (Data HUB) - Leading member of the team which convert investment accounting data from ADABAS to ORACLE.