SAM FAKHOURY
Yonkers, N.Y. *****
acrk3k@r.postjobfree.com
EXPERIENCE
*/** – Present Credit Suisse Bank
Lead Dev/Architect – Predictive Analytics
Created LDM (Logical Database Model), PDM (Physical Database Model) and Data Dictionary using Sybase Power Designer.
Working on Digital Analytic project to Analyze Web Traffic to CS web site and pass normalized data to Tableau for reporting purpose.
ORACLE stored procedure, PLSQL, Sybase Power Designer
7/05 - 6/15 Interactive Data Corp
Hands on Development Lead – Fixed Income Pricing & Reference Data
Proven track record and achievement to design and develop small & large ORACLE Database projects including data modeling (Logical Data Model & Physical Data Model), schema design and business logic implementation.
Designed & developed Reference data DB repositories, Real-Time vendor data feeds (Options, S&P ratings, Moody’s, MSRB trades, etc) and clients portfolio applications.
Extensive knowledge in ORACLE SQL performance tuning & PLSQL development.
Migrated ORACLE 9 (rule base) to ORACLE 10g (cost base optimizer). Invested an extensive effort to optimize stored procedures performance under cost base optimizer.
Worked closely with DBA to tune performance of Historical DB using DB partitions, RAC Clusters and reducing cluster wait time.
Worked with DBA to build and test Database replication - using ORACLE DataGuard - to Disaster recovery site in CA.
Oversaw the migration of several individual legacy systems (Municipal bonds, Corporate bonds - pricing & reference data - and Corporate actions) to run on single ORACLE Integrated Database
Created ORACLE Stored procedures & package using Oracle PL/SQL for any transformations required to the data in the Data warehouse
Used ETL to upload Database from various sources
Oversaw UI Development and Database Development team constructs
Complete Software Development Life Cycle (SDLC) starting with requirements through implementation and deployment...
Mentoring and managing developers and development teams, provide vision and negotiation at the departmental and business level.
Adhered to best practices and Change Management. System
Worked with end users and business side to gather requirements and turn it into technical design specifications. Worked with operations, System Admin & DBA to provide production support.
Extensive knowledge in developing Fixed Income Pricing & Reference Data applications especially for Municipal bonds. Proven achievement in requirements gathering, designing & developing batch & Real-Time bonds evaluation systems based on various pricing methodologies. Worked with Quants to implement various algorithms.
Hands on Java Core development (Data Structures, Collections, etc) of a publish/subscribe messaging system where all of the data sits on a Bus architecture (No Database).
Completed designing and building application to create an in-house Real Time AAA curve similar to MMD curve
Worked closely with Bond evaluators, end users, Quants to gather business requirements and translate it into technical & design specification used by developers.
Developed application to bring in Real-Time market colors such as MSRB trades and TMC Quotes.
Oracle & RAC Cluster, PLSQL, SQLPlus, Oracle SQL Developer, SQR (Hibernate Reports product),
Pro*C, Linux, C, Core Java, CVS, SVN, Linux shell scripts, TWS
7/99 – 7/05 Financial Times (Pearson subsidiary)
Team leader
Designed and built a Corporate Action System that integrated data from three legacy systems into a new system and created new products off the new platform
Lead a team of developers to build Portfolio processing system & Fixed Income pricing systems for Municipal bonds & Corporate Money Market using various benchmarks and methodologies.
.
Oracle, PLSQL, SQLPlus,
Pro*C, Linux, C, SQR,
CVS, Linux shell scripts, Eclipse, Java profiler, TWS
2/97 – 7/99 Muller Data Corp
Developer
Developing a system to process bonds reference data from vendors such as Moody’s, Fitch and S&P rating.
Developing Analytical tools for bond evaluators. Involved in Data Modeling and Database schema design and all stages of the Software Development Life Cycle (SDLC)
Oracle, PLSQL, SQLPlus,
Pro*C, Linux, C,
CVS, Linux shell scripts
2/96 - 2/97 Advanced Network Systems (America Online Company)
Software Engineer
Analyzing, designing & programming of SNMP agents and clients, such as
applications to monitor the UPS and reports any problems occurs such as
high transformer temperature, low running time.
Developed other applications to monitor other pieces in the backbone,
such as the Cabletron Hub.
SNMP, UNIX, C
11/93 - 2/96 MCI
Software Engineer
Analyzing, designing & programming of Client/Server applications as part of MCI
Global Messaging Services, which involves transferring, messages between
MCI & its clients using various communication protocols.
Those applications used as interfaces to SAFE (Store And Forward Exchange)
system.
IPC (Inter Processes Communication) has been used such as Shared Memory,
Message Queues, Pipes & Semaphores.
Also, performing UNIX system administration tasks and writing Shell Scripts.
C, UNIX, TCP/IP, DECnet (Using TSSnet package which runs on
Solaris x86 & provides an API to the Transport Layer Interface )
EDUCATION
MS, Computer Science from Lehman College (CUNY)
BS, Computer Science