Over 20 years experience in software development with a concentration in database design, development, administration, and performance tuning. Oracle
Certified Professional with strong technical skills including schema design, hardware design, physical layout, performance tuning, and database
Over 10 years experience as an Oracle Developer with experience in Oracle 8, 9i, and 10g
Experienced in Oracle performance tuning using STATSPACK/ADDM, TKPROF, and explain plan analysis
Strong understanding of logical and physical data modeling
Experience with large (>2TB) high volume OLTP databases using partitioning
Experience with Oracle 9i RAC including DBA activities in both the development and production environments
Experience configuring Data Guard and materialized views
Extensive PL/SQL experience creating and maintaining packages, procedures, functions, triggers, and materialized views.
Professional experience with SQL Loader
Experience as both a developer and a manager working with the full development lifecycle
Strong debugging and analytical skills
Comfortable working as a team player in complex environments
Experience with both financial and telecommunications databases
Oracle Database 10g Administration Certified Professional (2009)
OCP: All tests passed - pending completion of one Oracle class
Designed and managed the port of CDR processing from SQL Server to Oracle while maintaining compatibility with the existing SQL Server business
Provided HW estimates for all new customers and worked closely with specific customers to guide their selection of hardware.
Completed a comprehensive performance review of hardware and software purchased by Verizon in support of their Telarix installations. For this task
I installed software to gather performance metrics while controlling the impact on the running Windows servers. Based on my knowledge of their HW
and the performance data collected I prepared a recommendation for a single $3M platform capable of hosting their three Telarix installations.
Managed the development of a complex suite of telecommunication applications to support rating, routing, trading, billing, and auditing the
exchange of international voice traffic
Revised tables and code based on investigations performed on running production systems.
Worked with developers to investigate complex production issues. Reviewed design documents and met with the architects weekly.
Managed Production Engineering (PE): This included performance tuning and issue resolution for TIER 1 operators around the globe. To perform this
service I logged into customer servers to identify and resolve issues under a rigorous SLA. PE also evaluated new HW and SW platforms prior to
installation and completed many complex tasks.
Managed Customer Services (CS): I completely revamped the CS department creating a new organizational structure and optimized staffing. The new
structure held constant the number of open tickets during a period in which our active customer base doubled.
Rewrote and fine tuned many internal processes. As part of this effort I rewrote several customer facing documents to bring them current and
improve the professional appearance of the documents and the company.
Worked with senior executive staff to develop two new SAAS business models.
Managed all IT operations. Hired and worked with a new team to replace the corporate network, build out new production services, and migrate from
old servers to new virtual machines to save money. Implemented a new tape backup system.
I joined InphoMatch when there were less than 20 employees and was a significant factor in their growth to a business that sold for $425M.
Ported the SQL Server traffic database to Oracle
Installed Solaris and Oracle 9i on new UNIX hardware
Wrote the PHP interface to allow customers to access data in the traffic database
Wrote the C++ code used to log and route traffic
Designed the solution used to support Wireless Number Portability (WNP) using a feed that originated from Neustar
Designed and developed the WNP database schema to process the Neustar feed and merge it with LERG data to provide a comprehensive global routing
solution for SMS and MMS messaging.
Designed and implemented the servers and server configuration to support the production launch of the WNP routing solution. This solution included
a master server with partitioned materialized views located on two routing servers. A hot standby database was also created to enhance the
availability of the routing system.
Optimized production HW to support traffic growth that started at 500 msgs/hour and grew to 15M msgs/hour
Customized Oracle STATSPACK to include server performance metrics. Wrote custom KSH scripts to capture and log server performance data into the
Evaluated in-memory database tools to optimize database performance. The vendor selected, TimesTen, was subsequently purchased by Oracle
Installed Oracle on a new Solaris cluster to replace an existing cluster. Using a hot standby database successfully failed operation over to the
new cluster with a total down time of 15 minutes.
Redesigned the MM4 layer of the MMS stack to support a clearing house model for the exchange of MMS messages
Designed and coded the Oracle schema to log and report of MMS traffic.
Worked with the production DBA to build out and install the new MMS databases
Rebuilt a crashed database for a company we had just merged with. The database was not running in archive log mode and I had never logged into the
database before. Using information I had directed my team to gather I was able to personally reconstruct the database with very limited data loss.
Managed the development of a database warehouse used for reporting and billing
Managed the development of a SS7 system to send and receive SMS messages over SS7 networks
Managed the design of numerous application databases to support Application to Peer messaging services
Managed developers in the US, London, Paris, Singapore, and Beijing.
Designed the schema for a billing and receivables system to manage domain name registrations for Network Solutions. The schema consisted of about
120 tables and included support for standard invoicing, payment by account, and wholesale invoicing. The schema was later enhanced to support
flexible pricing including bundling and coupons.
Wrote the stored procedures and designed the security model for the NSI billing system.
Trained myself as a DBA to be able to perform testing on full scale copies of the NSI production database.
Performance tuned the OCI calls and database stored procedures to extend the life of the hardware platform
Wrote a Windows thick client application used by 400+ individuals at NSI to access the billing database.
Wrote a UNIX C++ server to process EDI 810 and 820 documents. This server ran uninterrupted for 12 months during which time it processed over 150M
documents without a single error.
Wrote lock-box software to process check payment files provided by the lock-box vendor.
Performance tuned a supply chain database written in Oracle. Rewrote parts of C++ business logic to make use of bulk operations improving
performance by a factor of 100.
Developed front end code for an association billing product that was to be the first product owned by Genesis. This product was used by the AMA
before Genesis closed its doors for business.
Built out the corporate network and maintained the servers
Completed many other tasks including interfacing with customers to create statements of work
VP, Software Development, VP, Operations
Telarix, Vienna, Virginia
VP, Software Engineering
Sybase365(Mobile265/Inphomatch), Chantilly, Virginia
Genesis Software Corporation, Herndon, Virginia
Thompson Technology Consulting Group, Herndon, Virginia
Fairchild Industries, Germantown, Maryland
Altek Corporation, White Oak, Maryland
USPTO Application Number ... 10/706,975 Filed on 14 November, 2003
SYSTEM AND METHOD FOR PROVIDING CONFIGURABLE, DYNAMIC MULTIMEDIA MESSAGE SERVICE PRE-TRANSCODING
USPTO Application Number ... 10/921,223 Filed on 19 August, 2004
ARCHITECTURE AND METHODS FOR INTER-CARRIER MULTI-MEDIA MESSAGING