C# Team Lead
Resume:
Perrault Jean-Paul
Charles River Trading System Expert (Consultant) - Project at The Vanguard Group
Jersey City, NJ 07305
**@************.***
Work Experience
Charles River Trading System Expert (Consultant)
Wells Fargo - New York, NY
July 2016 to Present
• Team Lead responsible for the implementation of Wells Fargo's complex entitlements scheme within CRD v9.8's new role based entitlements paradigm.
• Interfaced with the business and technology to gather and implement requirements for the various entitlements personas and account ownership roles within the CRD framework
• Developed complex Oracle packages to convert compliance rules from Wells compliance system
(Moxy and APL) to Charles River using a combination of lexical analysis, data mapping and data transformation.
• Oracle 11g, Oracle Packages, Java, Subversion
Charles River Trading System Expert (Consultant)
Project at The Vanguard Group - Malvern, PA
March 2014 to Present
Primarily responsible for the maintenance of the Charles River Trading System and Support of the business
• Developed and enhanced Charles River blotter buttons using C# to extend Charles River functionality
• Coded complex stored procedures and data export scripts to export trading data for FCA and EMIR compliance
• Created stored queries, workflow monitors and reports to streamline business processes and report on business performance
• Performed core data analysis and data extraction, transformation and load tasks in Charles River upgrade to v9
• Interfaced with traders and portfolio to gather requirements and fine tune design of application
• Developed Groovy and Python scripts for various End of Day and Start of Day jobs
• Java J2EE, Python, Groovy, C#, C++, Shell Scripting, EMIR, FCA, Subversion Charles River Trading System Expert (Consultant)
Project at TIAA Cref - New York, NY
January 2012 to March 2014
Managed key components of the upgrade form Charles River v8.2 to Charles River v9
• Developed core adapters in Python to allow Charles River to communicate with external system (i.e. FICC)
• Created custom Reports in Crystal Reports for Portfolio Managers
• Create blotter views and customized Manager's Worbench for Porfolio Managers and Traders
• Developed custom blotter icons and streamlined workflows for traders
• Created JAVA based Dashboard interface that provides summary CRD transaction information for management via the Web
• Charles River v9, Oracle 10i, Crystal Reports, Java, C#, Python, Informatica, Eagle Pace, Eagle Star Charles River Trading System Expert (Consultant)
Project at Metlife - Somerset, NJ
July 2010 to December 2011
Migrated pilot group from Charles River v8.2 to Charles River v9
• Configured CRD Blotter and developed custom blotter buttons in C# and Webservices for traders
• Developed custom CRD Exports to PAM via Trade Gateway and custom database driven applications
• Created Crystal Reports reports in CRD to present key logistical data to traders and portfolio managers
• Developed applications that used Charles River compliance data to provide enhanced compliance functionality
• Transformed data sets from CRD, PAM and advisors to Eagle Pace schema via Informatica
• Populated Eagle Pace datawarehouse via Eagle Uploaders
• Created OLAP reports in Eagle Pace that referenced company employee data
• Exported Eagle Pace Security master data to downstream systems via Eagle Exporters
• Charles River v9, SQL Server 2008, Crystal Reports, Java, C#, Informatica, PAM, PAM SDK, Eagle PACE v9, JBOSS
Charles River Trading System Expert (Consultant)
Project at Goldman Sachs - New York, NY
June 2009 to July 2010
Worked as an expert Charles River resource for the implementation of Charles River at Goldman Sachs
• Architected and developed delta reconciliation logic to support Goldman Sachs Fundamental Equities 24/7 multi-region trading environment
• Designed and developed a JAVA trade amendment wrapper around Charles River's out of the box Cancel/Replace trade update logic to perform "true" amends of trades
• Developed custom accounting system exports from CRD using PYTHON's SQLObject and Django web framework
• Developed complex Crystal Reports in Charles River to monitor trade life cycle, cash balances and compliance violations.
• Used C# to update Charles River's Winforms based UI to support additional functionality developed on the middle-tier
• Configured Manager's Workbench models for portfolio to performs REBALS
• Exported data from CRD to Eagle Pace datawarehouse via custom C# Eagle Pace OLAP/DCOM Adapter
• Charles River 8.2, SQL Server 2008, Java, JDBC, PYTHON, C#, Eagle Pace Charles River Trading System Expert (Consultant)
Project at Bank of America - Cranford, NJ
August 2007 to May 2009
Worked with business requirements to develop a trading system xml Gateway between Eagle Pace and Charles River using the Charles River XML import API
• Configured real-time blotter updates using market data from Bloomberg
• Developed imports and exports to manage parameters (i.e. pricing) on transactions and to perform transaction reconcilliation
• Performed groundwork on TBA implementation at Bank of America via Charles River
• Charles River 8.2, Oracle 10i, Java, C#, Eagle Pace v8, IBM MQSeries, Bloomberg Project at Legg Mason
Stamford, CT
December 2006 to August 2007
Technical Implementation Manager
• Architected and lead all phases of the implementation of the Charles River Trading System at Legg Mason, from Equities implementation to Fixed Income implementation.
• Worked in the capacity of both a Charles River Developer and Business Analyst to ensure on-time release of trading system
• Worked directly with traders and portfolio managers to devise a requirements document and develop a strategy for the phased implementation of CRD at Legg Mason. This required a detailed understanding of their business needs and the firm's trading work-flows.
• Performed all aspects of CRD configuration, from blotter/manager's workbench setup to the setup of feeds to/from external systems. This includes the use of the CRD Trade Gateway for export and import, as well as communications with XML and MQ Queues.
• Mapped data from Charles River and Portia (the accounting system), TPM and UK Salerio
(settlements). Also mapped data from Macgregor XIP (the former trading system) to Portia for security and account data.
• Integrated CRD with Bloomberg for real-time market data as well as intraday pricing. Also devised a FIX based engine to send trade data to Bloomberg EMS for execution.
• Developed custom stored queries and workflow monitors for traders and PMs to facilitate trading and trade data analysis
• Configured CRD to send data to Plexus on a daily basis for trade execution reporting
• SQL Server 2000, Java, JDBC, C++, Perl, Unix Shell Scripting (CSH) Trading System Resource (Consultant)
Project at Ameriprise Financial - New York, NY
February 2006 to December 2006
Served as the primary trading system and database resource for Deloitte and Touche in implemting the Charles River Trading System (CRD) at Ameriprise Financial (the investment end of American Express)
• Performed extensive data analysis and data mapping between AMEX's old trading system and the new CRD system
• Gathered business requirements from AMEX business units and used those requirements to design, and code components (monitoring, trade imports and reporting) for the trading system
• Coded SQL queries and stored procedures to develop complex Crystal Reports reports for various business units.
• Coordinated configuration sessions with various business groups to setup CRD trading system workflows, brokers, funds and market data tools within the enterprise framework
• Installed and configured Crystal Reports Developer and Crystal Enterprise to work with Charles River
• Trained and provided technical staff to AMEX staff on using and developing reports on the Charles River Trading system
• Oracle 9i, MS SQL Server 2000, Java, JDBC, C, C++, Perl, Unix Shell Scripting (BASH), JDeveloper Project Architect and Senior Developer (Consultant) Project at Wells Fargo - Milwaukee, WI
November 2005 to February 2006
Architected the migration of reports built in Cognos (Cognos cubes) to Crystal Reports in order to implement a uniform enterprise reporting framework built around the Charles River Trading System
• Gathered business requirements from various business groups to enhance existing reports and develop new ones in Crystal Reports
• Defined the reporting framework for the development of SQL queries, functions and stored procedures for report building.
• Developed a base of SQL code for accessing the trading system and performing trade calculations
• Provided support to operations on trading system issues and workflow monitoring
• Used the Spring/Hibernate Framework to provide an intranet front-end to view reports
• J2EE, JDBC, Sybase 12, MS SQL Server, C, C++, Perl, JDeveloper Project Architect and Senior Charles River Developer (Consultant) Project at Oppenheimer Funds - New York, NY
March 2005 to October 2005
Senior developer for the development and enhancement of the Charles River Trading System
• Developed trade reconciliation system for equities and fixed income trading platforms via stored procedures (SQL Server and Sybase) and Java daemons
• Utilized Perl and Cron to develop and manage critical end of day trading system jobs
• Provided third tier support for trades and help desk in resolving trading system issues
• J2EE, JDBC, Sybase 12, MS SQL Server, C, C++, Perl, SourceSafe, JDeveloper Technical Lead and Project Architect (Independent Consultant) Project at Strong Capital Management, Inc - Menomonee Falls, WI August 2002 to January 2003
Analyzed business requirements and designed CRD trading system gateway to process external orders from Strong's affiliate brokerage houses
• Utilized Java and Oracle (via JDBC) to architect and develop a robust database backend to load orders, run compliance on then and generate them to the trading system blotter.
• Generated new Strong compliance software to validate equities orders
• Developed compliance rules as per compliance and legal departments to run pre-trade and post- trade compliance on orders
• J2EE, JDBC, CQCS, CICS, Perl, Unix, Windows, Oracle 8i, BEA WebLogic, Rational Rose, SOAP Education
BA in Computer Science
Cornell University
September 1994 to May 1998
Computer Science
Stuyvesant High School
September 1991 to June 1994
Contact this candidate