SUMMARY:

• Database: Large - scale database design and administration, real-time data warehouse design and implementation, data storage and query optimization, ETL, data governance, stored procedures and triggers, data mining
• Application Integration: Electronic Data Interchange (EDI), data transfer and replication
• Programming: Android application development, 4GL/SQL/PL development
• UNIX- and Linux-based O/S: Installation/configuration/administration, performance tuning, filesystem repair and data recovery, software integration, terminal/printer drivers
• Hardware: Computer system configuration and installation, peripheral device interfacing and integration
• Personal Projects: Home network wiring and device set-up, custom PC assembly, distributed home DVR set-up, sound and video recording and editing, document typesetting and printing
• Intangible: Ability to integrate new functionality into existing production systems, methodical and detailed-oriented approach to problem-solving, ability to understand business system architecture and process flow (with or without documentation), desire to find "teh elegant solution"

TECHNICAL SKILLS:

Operating Systems/Environments: UNIX, Linux, Ubuntu, Windows, Gnome, Unity, Novell, Facetterm, Multiview, DesqView

Hardware: IBM, Sun, HP, DG, Sequent, Altos, PCs, Macs, ASCII terminals, printers, modems, terminal and printer servers, DSU/CSUs, statistical multiplexers, barcode readers, data collection equipment (scales, coin counters, chemical analyzers), PBX/phone systems

Database/ETL: Informix, SQLite, MySQL, SQL Server, Access, Pentaho

Programming Languages and Environments: Informix 4GL, SQL, Stored Procedure Language (SPL), Shell scripting, Android, Java, Perl, Eclipse, Business BASIC, Fourgen CASE Tools

Web Programming: HTML, CSS, XML, PHP, LAMP, ColdFusion, ASP

Accounting: PayChoice, Garpac, Fourgen, Open Systems, MAS-90, RealWorld, MACS

Productivity/Office Automation: Microsoft Office, OpenOffice and derivatives, WordPerfect Office, Uniplex, SCO Professional, Lotus 1-2-3, Multiplan, On-Contact, ACT, WinFax, Replix, VSI*FAX, ReFORM, Eudora, UNIX mail

Communications: UUCP/cu, MMDF, TERM, TinyTerm, Kermit, Cleo 3780, PCworks, Macline, Microphone, Procomm

Network: TCP/IP, FTP, 802.11g/n wireless, routers and switches, phone/network cabling

PROFESSIONAL EXPERIENCE:

Application / Mobile / Database Developer

Confidential, Torrance CA

Responsibilities:

• Designed, developed and published Android mobile application “Word Links”
• Released enhancements to Word Links and promoted to increase user engagement
• Attended developer conferences, researched mobile web / cross-platform technologies
• Initiated study of iOS programming, Drupal / PHP / LAMP development

Confidential

Responsibilities:

• Designed and implemented data integration solution to support new nationwide client
• Consulted on extranet and report file creation/delivery solutions

Confidential

Responsibilities:

• Developed data interfaces between in-house and acquired Nielsen systems
• Served as subject matter expert on Nielsen databases and data warehouses
• Maintained legacy Nielsen systems during transition to in-house platform

Confidential

Responsibilities:

• Designed and implemented configurable "detail-level" box office collection enhancement
• Developed data warehouse enhancements for web-based reporting application
• Enhanced intra-day box office data file handling and implemented preview data capture
• Provided subject matter expertise and datasets to other Nielsen divisions
• Engaged in project planning with senior-level management

Environment: s: Android, Java, Eclipse, SQLite, Pentaho, Perl, Informix, 4GL, SQL, SPL, Linux, Windows

Database / Data Warehouse Architect, Senior Application Developer

Confidential

Responsibilities:

• Assistance with integration of outsourcing staff into Nielsen environment
• Development of documentation and classes for new off-shore support staff
• Participation in design meetings for next-generation box office applications
• Continued development and support for Nielsen legacy systems
• Created data interface standards connecting legacy and next-generation systems
• Developed and implemented data replication routines
• Designed and developed major enhancements to data warehouse
• Integrated new inbound and outbound data feeds

Environment: s: Informix, 4GL, SQL, SPL, IBM/Sequent, Sun, UNIX, Dynix, Solaris, Linux, Windows

Senior Application Developer

Confidential

Responsibilities:

• Development and enhancement of custom box office tracking application
• Development and enhancement of primary database assets
• Development of real-time data warehouse for web and next-generation applications
• Development of standardized electronic data formats and generating applications
• Leadership role in product design and development meetings with management
• Creation and implementation of global programming and data standards
• Developed ETL process for high-volume electronically reported box office data
• Developed real-time data warehouse with high-performance custom ETL process
• Developed PL-based suite of data warehouse query routines for web applications
• Designed and implemented "matinee" data collection and reporting system
• Designed and implemented intra-day (“hourly”) data collection and reporting system
• Designed and implemented Y2K and Euro currency enhancements
• Designed and implemented currency conversion and decimal enhancements
• Designed and implemented show time tracking system to feed client website
• Developed customized data feeds according to client specifications
• Managed transition of clients to new standardized outbound data formats
• Provided database subject matter expertise to outside departments and clients
• Created ad hoc queries to provide BI datasets to management
• Participated in interview and hiring process for prospective IT candidates

Environment: s: Informix, 4GL, SQL, SPL, IBM/Sequent, Sun, UNIX, Dynix, Solaris, Linux, Windows, ColdFusion, SQL Server

Database and System Administrator, Lead Application Developer

Confidential, Manhattan Beach CA

Responsibilities:

• Maintenance and enhancement of Garpac accounting and order processing application
• Administration of primary database assets
• Administration of primary UNIX servers and PC network
• Serving as liaison between IT director and programming staff
• Providing and technical assistance to IT staff
• Prototyping repetitive installation and setup procedures
• Implemented EDI interface between retailers and in-house accounting system
• Optimized OLTP database and established a mirrored environment
• Developed data warehouse to support Crystal Reports queries
• Implemented corporate email and electronic FAX services
• Designed and installed remote site data link
• Standardized programs and reports
• Restored database operation without backup recovery following hardware failure

Environment: s: Informix, 4GL, SQL, Garpac, Fourgen, Sun, PCs, Solaris, SunOS, Windows

System Administrator, Technical Account Manager

Confidential, Torrance CA

Responsibilities:

• Development and modification of Fourgen accounting applications for external clients
• Providing technical support to customers on-site and via telephone and modem
• Installation and configuration of software applications
• Installation and monitoring of in-house servers, network, and phone/voice mail systems
• Created UNIX-to-Windows networks for external clients and internal use
• Performed large-scale legacy data conversions
• Developed EDI interfaces between clients and their suppliers
• Developed modem-based data communications support system
• Developed automated data transfer routines
• Performed custom software/hardware integration (FAX, barcode, credit card processing)

Environment: s: Informix, 4GL, SQL, Fourgen, HP, DG, Sun, PCs, UNIX, Windows

Technical Support Manager, Systems Engineer

Confidential, Torrance CA

Responsibilities:

• Developing and modifying Open Systems and MAS-90 accounting applications
• Developing and maintaining Informix applications
• Providing technical support to customers on-site and via telephone and modem
• Providing technical assistance to other programming staff
• Installing computer systems and application software
• Developed peripheral device interfacing manual
• Implemented modem-based data communications support network
• Tested and implemented new hardware and software products
• Carried out multi-week “road show” providing support and to East Coast clients
• Developed in-house repair parts inventory tracking system
• Developed and taught system administration course
• Redesigned in-house data network
• Served as office automation suite and desktop publishing expert
• Salvaged corrupted client file system without available reliable backup

Environment: s: Informix, SQL, Open Systems, MAS-90, Altos, UNIX, Xenix, Windows