Consultant Resume
New York, NY
SUMMARY:
- A talented programmer experienced in the financial industry as a Data Engineer, Application Developer and DevOps Engineer, with a demonstrated record of delivering value by adapting to new technologies and languages. Experienced with a broad array of technologies utilized to implement new applications and enhance the efficiency of existing applications and supporting processes. Recognized for strong business acumen and communication skills. Self - motivated, dedicated to excellence and a selfless team player.
- Worked with Sybase almost entire career. Designed data models, developed stored procedures and triggers, and tuned legacy code for performance. Designed and built processes to maintain data across platforms (UNIX to mainframe) in real time. Used dis as a basis for converting Oracle SQL to HiveQL.
- Vast experience with PERL. Utilized DBI package to read and write data, and CGI package to write Web applications. Wrote Sybase XML package to return Sybase query results in XML.
- Experienced as a C++ developer, C# developer and Java developer. Converted two applications from JBOSS 5 to JBOSS 6, which necessitated a conversion from Java 6 to Java 8.
- Experienced as a DevOps engineer. Automated many deployment processes. Trained in Puppet.
TECHNICAL SKILLS:
Computer Languages: PERL 5, SQL, HiveQL, Korn Shell, C, C++, Java, JavaScript, Expect, C#, Python
Databases: Hadoop, Oracle, Sybase 15 (including DB-LIBRARY in C and PERL)
Operating Systems: LINUX, UNIX, DOS, Windows, Macintosh OS
Software Development Tools: Eclipse, Informatica, Pentaho, Visual Studio, most debuggers and Web page builders
Other Software: Puppet, Jenkins, CARA/Nolio, MATLAB, most word processors, spreadsheets and graphics packages
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Consultant
Responsibilities:
- Supported the Anti-Financial Crime Group
- Designed and developed methodologies to build Pentaho Data Integration workflows using only metadata stored in Oracle. These would be used to generate reports and datasets from a Hadoop Data Lake.
- Converted SQL generating reports sourced from an Oracle dataset copy of a Hadoop dataset to directly source the original Hadoop dataset through Hive.
Confidential, New York, NY
Senior Software Engineer
Responsibilities:
- Supported the Structured Finance Group database and applications.
- Performed performance and functionality enhancements to various aspects of database and applications.
- Designed and developed new data feeds (including designing and building new tables and indexes to hold new data and stored procedures to maintain and access data).
- Designed automated upload systems to allow users to maintain their own data.
- Designed and developed infrastructure to maintain the execution history of Control-M jobs and utilized that information in recording the last date for which a job ran successfully, in order not to miss any processing dates.
- Enhanced object extraction shell script to report column-level permissions.
- Designed and developed several enhancements to SDLC process.
- Performed DevOps development for Analytic Harmonization and Sharing system in an Agile Scrum environment.
- Worked on incorporating Puppet into configuration maintenance.
- Designed automation of manual processes; utilized the Jenkins CLI.
Confidential, Jersey City, NJ
Consultant
Responsibilities:
- Supported the Bridge database which is the underlying database for confidential.
- Incorporated international instruments into the database which included new functionality on the front end, requiring new tables and stored procedures.
Confidential, New York, NY
Vice President - Application Programmer
Responsibilities:
- Supported the Trades Completion infrastructure, which enhanced FIX protocol trade messages with indicative information from Firmwide databases.
- Supported the in corporation of the Syndicate business into the infrastructure.
- Implemented various jobs utilizing PERL to access Sybase stored procedures and formatting the data into user-readable reports.
- Performed production support activities.
- Supported the Global Capital Markets business unit with various technological needs.
- Merged separate US and European vendor systems into one, allowing users to view data from both simultaneously. Built system front-to-back, including data loaders from each system into main Sybase database, and Web-based JavaScript front-end viewer.
- Additionally, integrated after market data, industries, and prices from Firm-wide databases into the system. The availability of dis data enhanced the information available to the user.
- Enhanced trade booking infrastructure to process different types of instruments and integrate with the new suite of vendor products. dis infrastructure was built in - house, and primarily consisted of server-processes written in C++, PERL, and Java. All servers queried and wrote to Sybase databases via stored procedures and were designed to work with the trade booking functionality of the vendor applications.
- Developed Trade Booking Debugger in .NET with C#. dis allowed users to identify issues with trades that were submitted but not processed yet.
- Served as main developer and database engineer for all vendor and in-house products supported by the group.
Data Engineer
Responsibilities:
- Designed and implemented databases using a variety of database tools to hold a wide variety of data, covering all areas of fixed income trading. Served as sole support for over twenty databases and related procedures and applications, as well as main contact with over fifteen different data vendors.
- Designed and implemented loaders, access methods, data maintenance GUI applications, report generators and error notification mechanisms for the above-mentioned databases.