We provide IT Staff Augmentation Services!

Software Engineer Resume

Summary

Principal Software Engineer with comprehensive data warehousing, data marts, and ETL experience. Extensive experience in Java / C++ / Perl / RDBMS environments. Key strengths include building extensible tool sets, functional inter-interoperability in heterogeneous systems, communications and protocols development and business rules encapsulation. Recognized for high level of operational excellence. Possesses a passion for quality and continuous improvement.

Technical Skills Summary

Language Proficiency: Java, C++, Perl, Pascal, BASIC, FORTRAN, PLSQL, T-SQL.
Language Familiarity: HTML, LISP, ASSEMBLER
Special Packages: Oracle 10g, SQL Server 2005, Sybase 15, Informatica 8, DB2, Business Objects, SAS, SPSS, Lotus Notes
Hardware and Operating Systems: IBM/AIX, Sun /Solaris, IBM 3090(MVS/TSO), IBM-PC(MS-DOS & UCSD-p)

Experience

Confidential, Boston, MA 2/2011 - 4/2011
Contractor

  • Text Book ETL implementation of new Oracle 10g Data Warehouse sourced from SQLServer 2005 and XML.
  • Data Modeling of MathXL (textbook data) to new warehouse.
  • Prototyping of XML and non-XML data via multiple mechanisms.

Confidential, Boston, MA 5/2010 - 9/2010
Contractor for Global Investment Technology Division

  • Fixed Income Trading System / Front-End Compliance Stored Procedure rules-based development via Sybase 15/RAP (In-Memory DB).
  • Design and implementation of trading system pre-trade rules (SQL) for DIVA (Data Integrity Validation Analyzer).
  • Full Review rules-based Analysis (1959 Front-End Compliance rules, 1209 Active, 259 Stored Procedures).

Confidential, 1997 – 2009
Principal Software Engineer (Fidelity Technology Group/Enterprise Group) / Bonded (Aug 2008 – Feb 2009)

  • Converted enterprise-wide Global Trade Preclearance System (GEMS) to Global System in Sybase, with next emphasis on Oracle PLSQL conversion.
  • Converted Global Post-Trade analysis, using Sybase triggers, stored procedures, and Actimize.
  • Developed Employee Category Loader using Informatica ETL, Sybase, stored procedures, and Autosys.
  • Re-Design of Annual/Quarterly Trade Verification (QTV) to include FMR-India workflow separation.

Principal Software Engineer Confidential / Bonded (Nov 2005 – Aug 2008)

  • Maintained Global Trade and Research Commissions (GTRAC), an ASP intranet application in Oracle 9i, encompassing Informatica ETL, PLSQL packages and Business Objects – a soft-dollars application sourcing Fund Trades from IDW (Investment Data Warehouse).
  • Implemented intranet ASP to .NET conversion using Oracle PLSQL.
  • Converted Informatica ETL business-rule processing to Oracle PLSQL package bucketing, for potential future use.
  • Architected Informatica ETL SQL Server loaders for new feeds processing, on separate project.
  • Managed department groups' Informatica 7 to Informatica 8 upgrade conversion, 14 applications/groups.

Consultant Software Engineer/Database Developer Confidential / Bonded, IMT (Apr 2000 – Nov 2005)

  • Converted Equity Trading Information Warehouse (ETIW) in Oracle, PLSQL to Investment Data Warehouse (IDW) Sybase; 8M fund trades, 12GB data. Re-Design of existing Autosys, Bourne profiles, Perl, shell scripts, and RDBMS stored procedures.
  • Created IDW Oracle, PLSQL instance of Sybase; 22M fund trades, 36.5GB of data. Warehouse consisted of new ODS/Archive segmentation architecture. Phase 1 conversion via Informatica/ETL as data transfer mechanism.
  • Implemented export data marts, ETL, target-aligned staging, group-level security via views, access and group/ end-user mappings, reference data dimension tables for performance.
  • Performed Autosys job scheduling with atomic processing and pre-processed single-source installs.
  • Bundled installation/backups via Make utility and individual Makefiles.
  • Created DDL preprocessing tool with CPP functionality and auditing/logging; originally required for Dev/QA on same RDBMS server. Preprocessing allowed single-source for multiple target environments.

Contractor Confidential / Bonded (1999)

  • Maintained Y2K development and testing for Perl applications within Treasurer’s Office.


Contractor Confidential / Bonded (Sept 1997 – Aug 1999)

  • Implemented Sybase stored procedures and triggers supporting Fidelity’s Research Reports, an equity research notes repository.
  • Developed Analyst Performance, a rating tool using web-based user interface, Perl, Sybase and market research data.
  • Designed Technical Notes loading system using Perl, Sybase, and Autosys on a Unix platform.
  • Developed and supported market research data loaders/ETL in a Unix, Perl and Autosys environment.
  • Other projects: Server migration, Perl4 to Perl5 conversions, Y2k issues, FAME upgrades, database design.

Confidential, Quincy, MA 1996 - 1997
Contractor for Information Technology Division

  • Performed data transfer for synchronization of global fund data for World Trust, a global financial data services project.
  • Built innovative, dynamic query application using stored procedures for selection criteria and data definition.
  • Application built in C, Sybase, stored procedures and shell scripts on Unix(Solaris/SunOS) platform.
  • Maintained existing application transfer protocols.

Confidential, Boston, MA 1994 - 1996
Contractor for FACS Systems Group (FACS/Systems) / Bonded

  • Developed and maintained a 400+ user, Fund Reporting Automation System (FRAS), a PC-based, three-tier client/server application in a heterogeneous environment utilizing JYACC Jam, MS-C, Sybase (UNIX), Interleaf (Ultrix) and SQR. Migrated UNIX-based FRAS to Client/Server PC desktop.
  • Re-engineered FRAS application - including database connectivity, cell rule evaluation, memory management, logging, stored procedures, triggers and indexing.
  • Projects included: FRAS Unlimited Shares project; cell rule (business rules) evaluator re-write.


Confidential, Cambridge, MA 1993 - 1994
Contractor for ISS Group

  • Implemented Direct Marketing campaigns using Sybase SQL Server, Transact-SQL and SQR in a Vax/VMS based environment.
  • Maintained database, database design using DEFT, Sybase stored procedures and triggers.
  • Corporate data loading using C, SQL-Server dblib calls and bulk-copy utilities.
  • Created company name-matching using corporate data from ABI and Dunn & Bradstreet vendors, via SSA-NAM3.

Confidential, Bedford, MA 1992 - 1993
Principal Software Engineer

  • Responsible for database applications development for the Airport Noise and Operations Monitoring System (ANOMS), an integrated Sun Sparcstation based(UNIX), airport noise abatement system.
  • Designed and developed a stand-alone Data Archiver for archival/restoration of large volumes of data within the ANOMS system in C and Interbase DSQL.
  • Implemented database relation access routines using both static SQL and GMDL (Interbase's proprietary DML).
  • Developed a C/GDML code generator for Select, Insert, Update, Delete and subsequent test operations for rapid prototyping; overcoming certain GDML deficiencies available in SQL.
  • Re-designed ANONS sub-component transaction models and scoping.

Confidential, Westwood, MA 1991 - 1992
Confidential, Burlington, MA 1989 - 1991
Confidential, Cambridge, MA 1985 - 1989
Confidential, Wellesley, MA 1984 - 1985

Education

Computer Science
Business Administration

Hire Now