Contact
Experience
Contract Software Developer
City of Los Angeles, Telecommute
Oct 2004 - Present (7 years 5 months)
- Create, design, deploy, document, create training videos for cross-database .NET group by roll-up report with drilldown, export to PDF, export to Excel, saving report snapshots, sending reports to others in interactive mode, re-running reports using the criteria from the existing report output, utilize standards such as XML for storing report snapshots, and roll-up data.
- Connecting disconnected systems through use of strategies such as page scraping, browserless http gets/posts, ftp, export files, scheduled tasks, and transformation logic.
- Migration of modified Fusebox 2 applications to Fusebox 4 in ColdFusion.
- Leveraging Apache Struts 2, Hibernate, and GWT applications in Java for tracking and reporting materials and labor costs.
- Implementing, planning, and training of source control software using Subversion. Previous to my initiative, no source control software was used on site.
- Development of .NET business components exposed with a COM interface using COM interop for use in ColdFusion processing.
- Determining deployment strategies for COM components, and upgrade considerations
- Planning, architecting, and implementing new functionality in ASP .NET, while maintaining seamless user experience with existing ColdFusion application.
- Upgrading inline SQL statements to use centralized stored procedures in Oracle 9i.
- Continuing support, and new feature development as new requirements arrive from users for Labor Cost Accounting application.
- Optimization of database activity to improve performance for reports against tables with 300k-3M+ records
- Generic database development to allow database interchangeability.
Contract SSIS Developer
InsideTrack, Telecommute
Apr 2010 - Present (1 years 11 months)
- Extract, Transform, and Load data from business partners as per specified requirements.
- Planning, proposal, code/logic review, and successfully implementation new ETL strategy to reduce run time of one job from over 3 hours to under 2 minutes.
- Identify and implement solutions to allow wide variety of source file formats: csv, xls, xlsx, and web services.
- Write CLR extensions to SQL Server 2005 to allow leverage of .NET framework in transformations.
- Add secure communications to business partners who require SSH using open source tools.
- Suggest money/time saving strategies as appropriate.
- Identify risk factors in specifications and provide NTE quotations.
Board of Directors, Chairman
Lake Royale Property Owners Association, Louisburg, NC
Jul 2008 - Jul 2010 (2 years 1 months)
- Acting as project manager for new gate house project, I helped co-ordinate efforts from volunteers, solicit bids from contractors, and made the proposal which was developed.
- Working with staff, and volunteers, together, we saved 50% of expected expenditures on new server equipment, and installed a new document management solution (Laserfiche).
- Together with my wife and other key volunteers, coordinated the most successful clean-up day in the history of Lake Royale.
- Association received two of recent four consecutive Large Scale Property Owner's Association of the Year awards from Carolina Association Institute during my time on the board as Chairman, and one during my time as vice chairman the prior year.
- Together with others, coordinated what was related to me as the most organized and successful annual meeting so far.
- Participated in exploratory field trip to another association in Virginia to help reduce wasted expenditures on upcoming solutions.
Senior Software Developer
Technology Innovations, Inc, Simi Valley, CA
May 2004 - Aug 2004 (5 months)
- Developing RMA process to reduce paperwork, and to ease communications between Cerwin-Vega! & KRK Systems with TII. Web based solution utilizing ASP .NET in C# and SQL Server 2000 with stored procedures.
- Problem solving numerous critical business operational breakdowns and applying emergency fixes for projects involving ASP .NET in C#, SQL Server 2000, Access 2000, EDI, Visual FoxPro 8.x, unrecoverable passwords, to name a few.
- Maintenance for eBay related software written in ASP .NET in C#, SQL Server 2000, console C# applications, and NT System service C# applications.
- Proactive problem solving for employees with updates to internal software assisting in time consuming, and tedious internal operations wasting valuable company resources. Example: updated existing software to include a way to bring in all items by receiving number where previously scanning each item was necessary, and additionally provided access to bulk “sign off” on finished items where individual data-entry was not appropriate.
Technology Specialist
McGill Barnes, Inc, Lancaster, CA
Feb 2004 - May 2004 (4 months)
- Recommended Microsoft Licensing programs to balance the need for proper licensing of used products and cost.
- Researched, proposed, and implemented anti-virus security measures to protect valuable company assets from damage or mal-configuration
- Provided emergency Microsoft Office (Excel, Access, Word, PowerPoint, and Outlook) lessons to students while the company sought a permanent replacement. Several students expressed strong interest in re-taking material under my direction.
Lead Software Developer (3+ yrs)
Cyberspace Headquarters, LLC, Canoga Park, CA
Oct 1998 - Jul 2003 (4 years 11 months)
- Led in-house development team for 3 versions of AddWeb, the top selling Website Promotion software (3 years in a row 2001, 2002, 2003 NPD Intellect Reports), which sold via the Internet, and popular retail stores: Best Buy, CompUSA, Staples, Fry’s Electronics, and others. Creation of AddWeb utilized Delphi 3-7, in-house developed attractive visual components, report generation system allowing for report templates, complex HTTP queue processing engines, script enabled page parsing, embedded Internet Explorer development, DHTML, DOM, javascript, custom developed embedded updating system to upgrade customer software & data files, convenient & effective anti-piracy measures utilizing SQL Server and Cold Fusion, and client side tools to allow customer extension of marketing resources.
- Led in-house development team for award winning Customer Relationship Management (CRM) solution, which won the coveted Best in eBusiness category award at COMDEX 2001. Using our own product cut support costs ~50%, reduced turn around time, and increased customer satisfaction. ServiceTraq technologies included Cold Fusion 4.x & 5.x, SQL Server 7.x & 2000 (stored procedures, full text indexing, indexes, dynamic queries), ActiveX forms through Delphi 7, ASP 3.x, javascript, cascading style sheets, SoundEX, and TCP/IP based XML-like chat implemented as an NT system service. Utilizing these we output top shelf CRM software integrating knowledge base, customer communication (through email, phone, or online chat), surveys, case surveys, exit surveys, extensive survey reporting, abundant customization features, data backup, system privileges, service rep proficiency case routing, and numerous other features.
- Observed custom version of CRM application implemented for online gaming company which reaped massive benefits during beta release when 2300+ online users simultaneously sought technical support.
- Applied leadership and technical skills creating new web site statistics application which received over 1 million hits/day. Special care was taken to maintain high uptime, optimal responsiveness, and still yield important live reporting to users of statistics application.
- Planned and executed web site statistics server resources migration from east coast to west coast with less than 60 seconds downtime, including provisions for cached DNS problems.
- Managed two outsourced programming teams for several key projects
- Managed prompt creation of new updates to AddWeb, including testing, and releasing.
- Implemented new and necessary source control practices, which were previously unused. Used Visual Sourcesafe 6.x.
- Designed and executed plan to migrate server resources from the east coast to the west coast with virtually no downtime on a server receiving approximately one million transactions per day at the time.
- Capitalized on my expert knowledge of Windows based operating systems, 9x/ME, NT4/2000/XP to reduce development time, and maintain superior integration with system functionality.
Software Developer (1+ yrs)
Cyberspace Headquarters, LLC, Canoga Park, CA
Oct 1998 - Jul 2003 (4 years 11 months)
- Co-authored AddWeb 3, including innovative technologies:
- In-program automatic updating mechanisms
- Low-overhead proprietary database format
- Customizable report generation system
- Utilization of script mechanism for areas that needed flexible, yet powerful abilities
- Developed Meta Tag editing software, which sold online and via retail stores
Technology
Delphi 3-7, C# .NET, VB .NET, ASP 3.0, PHP 4.0, Javascript, HTML, DHTML, Cold Fusion 3.0-5.0, Microsoft SQL Server Transact SQL 7.0-2005, subversion, Redmine, Java 6, Apache Struts, Google Web Toolkit, Regular Expressions, VMware Workstation, Microsoft Office Suite (Word/Access/Excel/Outlook/Powerpoint/VBA Macros). Personal projects also leveraged: .NET Webservices, cross domain scripting, IE9 browser helper objects, Chrome browser extensions, ASP .NET MVC 3.x, Entity Framework, LINQ, Linux, VMware ESXi 4.1.
Certifications
MCAD (C# for .NET), and MCP
Community Service
Board of Directors Chairman for Lake Royale Property Owners Association 2008-2010
Interests
Books, local triathlons, foreign languages, and Korean cooking