Jeffrey Slon BS, MBA

Specialties

• RDBMS (OLAP / OLTP)
• Data Warehousing
• Business Intelligence (BI)
• ETL / Data Conversion
• Quality Assurance (QA)
• Documentation
• Application Development and Support
• Front-End Web Development

Public Company; PTSC; Computer Software industry

December 2010 – Present (4 months)

• Responsible for implementing, deploying and maintaining data sharing exchanges.
• Work with in-house SMEs to understand data exchanges and create IEPDs using PDSG ExchangeBuilder.
• Develop SQL queries to extract appropriate data to map to XML schemas.
• Use PDSG CDX mapping tool to transform data into XSD formats to be NIEM IEPD compliant.
• Install and configure CDX software on customer networks.
• Write PDSG CDX Mapping tool documentation.

Information Technology and Services industry

February 2009 – 2010 (1 year)

• UC San Diego Extension Classes. (Java Fundamentals, Oracle, Excel 2007)
• Volunteer at SD Mama’s Kitchen, an organization that serves hot meals to critically ill San Diegans.
• Raised over $2000 for the San Diego AIDS Walk as a member of the Qualcomm team. (2009 / 2010)
• Volunteer for various projects at Whispering Winds Catholic Camp & Conference Center.

Information Technology and Services industry

August 2008 – February 2009 (7 months)

• Contract position: supported Space and Naval Warfare Systems Command (SPAWARS) PD2 application.
• Administrated Sybase ASE RDBMS servers in three locations. Responsibilities included memory management, backup, user maintenance and COOP.
• Created UNIX scripted utilities to access Sybase ASE RDBMS server information for reporting to management. (UNIX Korn shell script, sed / awk)
• Initiated Sybase ASE RDBMS server auditing proposal to monitor user activity.
• Researched Service Oriented Architecture (SOA) applicability for PD2.
• Interim Secret Security Clearance.

Public Company; QCOM; Telecommunications industry

September 2006 – February 2008 (1 year 6 months)

• Supported COGNOS Finance, an application for corporate-wide financial reporting using Oracle SQL for data feeds.
• Troubleshooted processing and data issues in a Business Intelligence (BI) OLAP environment.
• Maintained and added as needed Control-M ETL batch processing modules.
• Validated QA financial data in COGNOS submissions using Excel spreadsheet data reports
• Documented the current ETL and Oracle SQL for data feed processes.

Public Company; SY; Computer Software industry

March 2000 – August 2006 (6 years 6 months)

• Worked on a team to create external customer facing Sybase.com, a dynamic content web site and Content Management System (CMS) application.
• Wrote CMS content data input modules used by Sybase internal customers. (StoryServer, tcl, HTML, CSS, javascript, Sybase ASE RDBMS)
• Member of QA engineering team that tested (My)Sybase.com functionality, usability and scalability in accordance with business specifications.
• Demonstrated MySybase.com site usability at Sybase Techwave Users’ Conference.
• Assumed responsibility for Sybase.com customer facing Search Application.
• Redesigned and streamlined existing Search Application UI according to business specifications. (StoryServer, tcl, HTML, CSS, javascript, Sybase ASE RDBMS, Verity)
• Assisted in gathering and writing business requirements for the re-engineering of Sybase.com Search Application
• Evaluated POC search engines with respect to business requirements for Search Application re-design. (Verity, Google, Autonomy)
• Wrote architectural design document for Search Application.
• Designed, programmed and successfully launched the re-design of the Sybase.com customer facing Search Application, which allowed Sybase customers easy access to documentation and information previously not available without contacting technical support. (J2EE, Java, HTML, JavaScript, JSP, Struts, Eclipse, Perforce, Sybase ASE RDBMS, Sybase EAS application server and Autonomy search engine)
• QA tested Search Application to comply with functional specification and business requirements.
• Troubleshooted data integrity for Sybase.com eShop for products and financial information using SQL.

Information Technology and Services industry

October 1997 – March 2000 (2 years 6 months)

• Worked on a team to maintained GEAC SmartStream (SS), a corporate wide financial application.
• Improved data feeds and interfaces (ETL) from SS to other applications and data warehouses within the Sybase enterprise. (Sybase ASE RDBMS, UNIX C shell script, Informatica)
• Developed and implemented OLAP star schema data warehouse to merge disparate financial information for revenue recognition analysis.
• Wrote ad hoc Sybase SQL queries, complex stored procedures, views, triggers and database object creation scripts.
• Designed end-user Business Objects Universe.
• Wrote Business Object architectural and users’ documentation.

Public Company; BAC; Banking industry

October 1994 – October 1997 (3 years 1 month)

• Engineered data loading (ETL) of the Trading Products Database (TPD), a data source of risk exposure information for BofA derivative product trading. (UNIX Bourne shell script, Pearl, sed / awk)
• Designed TPD RDBMS star schema.
• Created Sybase SQL table-driven data validations and auditing routines for error reporting to process files from various BofA world locations.
• Scripted creation of database objects using Sybase SQL.
• Assisted operations in support of TPD by designing custom scripted UNIX utilities, ad hoc Sybase SQL queries, SQR reports and a user front-end dashboard. (UNIX Bourne shell script, Pearl, sed / awk)
• Re-engineered load to modularize routines for more comprehensive logging system to inform operations of Sybase ASE RDBMS and UNIX server failures during the load process.
• Wrote / optimized Sybase SQL queries, stored procedures, views and triggers.

Public Company; SY; Computer Software industry

June 1992 – October 1994 (2 years 5 months)

• Developed, maintained and supported corporate-wide applications using a large database system (order entry, purchasing, invoicing, sales and marketing, sub-ledger accounting, VAR/Channels data tracking and cases/calls tracking. ).
• QA tested application modules for performance, functionality and data integrity
• Required intimate knowledge of Sybase client/server and its integration with SUN OS, Macintosh (4D), APT front end. (Sybase v4.2 - 10.2, SQR, 4D, Macintosh, UNIX Solaris)

Claremont Graduate University - Peter F. Drucker and Masatoshi Ito Graduate School of Management

MBA, Management Information Systems

1989

Programmer / Analyst for CGU while earning my MBA.

Syracuse University - Martin J. Whitman School of Management

BS, Finance

1981

Activities and Societies: • Hendricks Chapel Choir • SU Musical Stage

Related Classes

Activities and Societies: • UNIX Solaris System Administration • Sybase ASE RDBMS server Admin • Sybase ASE RDBMS Performance and Tuning • Project Management Intl Workshop • Ralph Kimball: Data Warehousing (OLAP) • Business Objects Admin / Dev (2009) • UCSD-JAVA Fundamentals (2009) • UCSD-Java Core (2009) • UCSD-Oracle SQL (2010) • UCSD-Excel 2007 (2010)

• career opportunities
• consulting offers
• new ventures
• expertise requests
• reference requests
• getting back in touch