SUMMARY

Versatile, senior application development professional with full SDLC experience in multi - platform analysis, coding and testing, integration, management, and support.

TECHNICAL SKILLS

Platforms: Unix (AIX), Windows, IBM Mainframe

Languages/Tools: SQL, PL/SQL, SQL*Loader, VB.NET, Korn Shell, COBOL, PL/I, MVS JCL, CICS, MVS Utilities (File-Aid, Syncsort), Transmission Protocols (FTP, NDM, SSH/SCP),Global Plus Vision (proprietary language)

Database: Oracle, SQL Server, Sybase, MS Access

Productivity Tools: MS Project, MS Office, Visio

PROFESSIONAL EXPERIENCE

Confidential, Merrimack, NH

Senior Software Engineer/Developer

Responsibilities:

• Provided SME level systems and business analysis, development and production support services for multi-platform (Unix, Windows, IBM Mainframe) applications supporting Institutional Custody Solutions
• Served as primary vendor liaison for support issues and product enhancement requests for FIS’ Global Plus portfolio accounting system.
• Developed nightly interfaces between DST TA/2000 platform and Global Plus. Designed, coded, tested, and implemented all components on mainframe (COBOL/JCL) and Unix (shell scripts). Maintained test plans and MS Project plans for ICS portion of this major firm-wide project.
• Supported PL/SQL scripts, stored procedures and other Oracle objects used in daily ETL activities between Global Plus and in-house maintained data warehouse.
• Led several efforts between 2008 and 2017 to upgrade Global Plus software releases. Activities included regression and parallel testing, error tracking and resolution, and coordination with internal Oracle and AIX enterprise infrastructure teams for Oracle/AIX upgrades required to support vendor product.
• Managed all production support activities for 4 person support team from 2012 to 2017.
• Led project to convert legacy terminal emulation journal entry application to ASP.NET/C#/web services (SOAP). Participated heavily in design, testing, and implementation phases.
• Coordinated project to modify report generation processes to convert from Perl-based local server disk file write/retrieval to C#/Oracle app to upload BLOB files via web services to Fidelity enterprise document archive solution.
• Modified several Crystal Reports modules to update logos, disclosure footers, and fonts to reflect new business unit branding and compliance policies for external client reports.
• Participated in design, testing, and implementation phases of intranet reporting and reconciliation site from Perl/CGI architecture to C#/.NET.
• Improved production documentation that had last been updated in 2004.

Confidential, Milton, MA

Business Systems Analyst/Developer

Responsibilities:

• Analyzed mainframe-based extract processes to determine how data can be sourced from new Oracle-based data repository.
• Developed PL/SQL stored procedures and functions for client extract processes for Security Master data.
• Reviewed Investors Bank and Trust (IBT) Exchange-Traded Fund application to determine how to replace IBT accounting data with data sourced from State Street’s primary accounting platform.
• Led testing for migration of Putnam mainframe custody applications to State Street servers, including investigation and resolution of batch scheduling issues.

Confidential, Boston, MA

Project Manager (Contract)

Responsibilities:

• Managed enhancement and upgrade projects for small company that provides document composition and design services to insurance and retirement plan organizations.
• Maintained project documents including statements of work, project schedules, and action/issues lists.
• Coordinated production support activities for ASP clients with approximately 400,000 participants and/or policyholders and resolved production issues in hands-on manner with clients and external print vendors.
• Facilitated and improved technical discussions between internal infrastructure and developer teams and documented existing processes and structures, including MySQL database and Perl and PHP scripts.
• Accepted a voluntary buyout from State Street and took time off to investigate other careers but remained technically active through Oracle and Windows development.
• Developed VB.NET console apps, PL/SQL procedures and SQL*Loader scripts to format and load climate, census, and retail location data into Oracle database.
• Created personal web site to host demographic analyses and other self-authored work.

Confidential, Quincy, MA

Technical Project Manager

Responsibilities:

• Coordinated IT effort of 13-member matrixed team (3 direct report, 10+ indirect) on implementation of multi-platform interfaces and customized reporting applications for three concurrent Wealth Manager Services (WMS) projects to provide operational and systems support to UK-based private client management firms. Assessed clients’ current architecture and participated in design of changes. Created project schedules, managed resource issues, conducted technical and status meetings with US and UK team members, and provided application and analysis assistance to US-based technical staff.
• Collaborated as senior analyst in design and testing of proprietary message-based trading protocol to support interfaces between US-based investment managers, separately managed account sponsors (Merrill Lynch, Prudential), and DST Systems’ Managed Asset Platform .

Charitable Services

Application Manager

Responsibilities:

• Managed IT relationship with State Street Global Advisors (SSgA) charitable services business unit. Greatly improved cooperation and relations between business unit and IT.
• Implemented new scheduled and ad hoc Unix, Windows, and MVS processes to fulfill management and operational needs.
• Stabilized a VB 6/Sybase 11/Crystal Reports COM-based client statement system inherited from another IT group by reviewing and reworking Sybase procedures and VB code which resulted in fewer errors and significant run time shortening.
• Improved browser-based statement retrieval process response time by 50% by converting ColdFusion scripts to streamlined ASP interface and replacing Sybase database with SQL Server.
• Managed interface development between FIS’s Global Plus trust accounting system with internal and external applications on Unix, Windows, and MVS platforms.
• Served as lead analyst and co-developer for interfaces to provide account and position data to performance measurement and fixed income vendor products.
• Managed and co-developed processes to extract corporate action data from State Street centralized functions for transformation and upload to Global Plus..
• Composed environment standards including directory structure and naming conventions for shell scripts, AutoSys jobs, and developer-focused help documentation
• Led 2-member development team for desktop-based VB/SQL Server portfolio modeling and rebalancing application for investment managers. Participated actively in all phases including coding and support.
• Coded and implemented enhancements to mainframe batch cash sweep process to reflect 1996 industry change to same day funds availability.
• Served on 1999 IT knowledge management task force. Committee recommendations formed basis for first release of IT web portal