Simplicity is the ultimate sophistication.
~ Leonardo da Vinci *
I am a highly skilled senior database programmer & data architect with a specialty in database design & development, systems integration, ETL, analytics, security and reporting. I have been coding using various technologies for over 20 years and have experience with nearly every aspect of running a business.
I started with COBOL mainframe programming (yes, including Y2K!) and after a couple of years switched rolls to IT Management. This helped provide a well-rounded skill set that transitioned well into consulting. As a consultant, I spent several years developing database solutions with a focus on custom reporting. After consulting, my focus was shifted to database applications development for larger companies like Univision, Inc. & Charles Schwab, Inc. At Univision and Univision Radio, I worked closely with executives and auditors, so report development remained a core responsibility.
For backend programming I am well versed in object oriented coding and design patterns. Expert with most common web programming languages such as PHP, Perl, Javascript, JSP, C# and others. I'm also a pretty good systems administrator. I am looking for a company where my diverse skillset and background will be utilized and provides a comfortable, fun working environment.
Make it as simple as possible, but not simpler.
~ Albert Einstein *
Simple Software was truly ahead of its time, and in many ways still is. We created a SaaS application that allows companies to build their own applications using simple web tools. You can setup your own secure workspace, load your csv data and have forms generated in less than 15 minutes. You can manage user access, use simple tools to create and update tables, generate and regenerate web forms, automate business processes, create your own reports, and so much more.
I really enjoyed working on this project and even though we ran out of funding, there are still companies using it to this day! I learned a lot, especially from our lead architect Mr. Robison, and it was interesting to see the various ways the application was used, including a charter bus company & a helpdesk solution for an IT department.
This short video gives a quick overview of the project. Or watch them all at youtube.com/user/SimpSF
I was contracted to build a new B2B website that gave wholesale customers the ability to order directly from Sanrio. The requirements were not only to build a shopping cart, but to encompass all of the business rules associated with an order and have it tie directly to their ERP. This included specific ordering rules for customers & salespersons, credit checks, special product offers, including prebook products. The data not only had to interface with Lawson, it also came from spreadsheets via email. This was a complicated project just from a data perspective.
Unfortunately, the project got off to a rough start after my business parter, a.k.a the lead web developer, decided to move to Ireland, 3 months into development. After a month of trying to perform my role as data architect, and take over as web developer, I made the decision to move from PHP/Apache to MVC/.NET. From the client's perspective we were starting over, but in reality we moved from an unpaved side street, to a modern highway and were quickly meeting our deadlines.
To be honest, the decision to change environments after 4 months of development was one of the biggest I've had to make in my career. While I could slowly reverse engineer the work already done in PHP, I had minimal to no experience with .NET development at that time. Luckily, I was managing the funding and client's expectations properly, so I hired a full-stack .NET engineer and spent the next 2 months on the biggest learning curve of my life. When the time came for the developer to take a permanent position elsewhere, I had no problem taking over as lead web developer. While I'm learning new techniques everyday and always expanding my knowledge, those 8 months were some of the most stressful and rewarding of my life.
When I was 18 years old, I decided on a general template for my life. My 20's would be for education and playing; my 30's would be for traveling and advancing a career; my 40's would be for family. Every decade went according to plan and a few months after I turned 40, Eve was born.
Sep, 2018
~ Present
Management of information flow, operation and programming activities, including network and systems design, procedures, and operations. Provides management direction and leadership in computer applications development and computer operations of the corporation as well as advice and counsel to management concerning new applications and technology.
Essential Functions:Jan, 2016
~ Oct, 2018
Responsible for designing and managing a flexible new B2B website for
Sanrio Inc. (Hello Kitty). I put together a small team of front & back end
engineers to deliver a modern, responsive website completely interfaced with their
ERP. The architecture helped significantly increase their wholesale business by quickly
adding special offer products through custom data uploads.
Since initial deployment, I have remained the primary developer for all new requests.
Some of the technologies used are:
Jan, 2015
~ Jan, 2016
Migrate all SQL Servers to SQL 2014. This included migrating all DTS packages to SSIS, and all Business Objects to SSRS. Prepared their B2B databases for the development of a new application, including new AS400 interface methods.
Nov, 2012
~ Jan, 2015
Developed reporting infrastructure to support their Business Intelligence requirements.
This included:
Other projects:
Jan, 2009
~ Oct, 2012
Self-funded startup specializing in Software as a Service. My role included designing data infrastructure for easily replicated online workspaces. I also worked with customers to gather requirements and develop solutions that met their needs. We created web tools so clients could develop their own workspace. Tools included:
There are still several companies using our hosted services. I'm especially proud of helping our family business grow 400% in less than five years. This was accomplished by working together to develop a SaaS solution that automated many business processes including:
Jan, 2009
~ Nov, 2011
Created application to feed data from their new warehouse management solution to their ERP and external vendors. Updated their SQL Server DTS packages, as well as modified their existing BO reports. I continue to support their reporting needs as they arise.
Oct, 2008
~ Dec, 2008
I was contracted to develop a sales program merging raw external vendor data with a proprietary sales system. This was developed in Oracle PL/SQL in a Linux environment. I was responsible for requirements gathering from internal and external sources; database design; code development; and testing. Extensive technical documentation and rigorous QA was required.
April, 2004
~ Oct, 2008
Worked closely and provided solutions for corporate executives by
developing and maintaining custom applications and financial reporting.
ETL
All custom requests that were not handled by software agreements were passed on to me for development. Maintaining data integrity and user confidence were a core objective.
Oct, 2002
~ April, 2004
Custom application development, database administration, network
administration, application and desktop support, & new site builds
were my primary responsibilities. I also managed our data warehouse and
OLAP cubes containing AP/AR and GL information derived from Great
Plains and Marketron systems.
My other responsibilities included creating and managing in-house
applications. Most applications were created with an ASP front end,
Active Directory security, and reinforced with a data security layer.
Oct, 2001
~ Oct, 2002
E-talk is a provider of call center software solutions. I was contracted by E-talk to develop custom Crystal reports for their customers including full lifecycle project management from quote to deployment. Database administration, Crystal Reports, VB and all IT implementations were my primary responsibilities. Reporting involved, but was not limited to, data warehousing, systems integration, and web development.
April, 2001
~ Sept, 2001
My primary responsibility was as a solution provider for many industries through consulting services. Some of the solutions I provided include Web development, application development, database design, and reporting solutions in various environments. Reporting solutions were our main focus and DSG was Seagate's Partner of the Year for two consecutive years. I have implemented many enterprise reporting solutions including Seagate Info, and Crystal Enterprise and have integrated them with multiple databases including DB2, Oracle and SQL Server.
Nov, 2000
~ Mar, 2001
Functioned as multi-leveled software specialist. Located inside CBOT, my duties included development of trading software. Written in VB, it handled data requests for clients inquiring on stocks and futures. I also implemented a fully automated Help Desk solution; upgraded server/network & hardware/software; network administration including managing proxy and all web services.
July, 1999
~ Oct, 2000
My responsibilities included Network Administratior, support &
enhancing LAN/WAN hardware, supervision of the PC technicians,
AS/400 computer operators, and consultants. I was also
purchasing manager for all hardware and software as well as
the project lead for all development and enhancement needs.
Network
Novell 4.11 server, Windows NT servers, two AS/400's,
and over 100 Windows 95 and 98 PC's and laptops. I was involved
in many projects that helped them to perform more efficiently.
Some of the projects include moving from a DSL to a metered T1,
upgrading their network backbone from hubs to switches, and
working with the AS/400 systems programmer to integrate with
multiple systems. I upgraded their design department from old 9600's
to G4 workstations and upgraded all of the printers.
Services
I implemented a SQL server with crystal reports. Supported
the mail server, Internet Proxy. and all Network services and protocols.
EDI
Acquired EDI certification, implemented and managed new EDI solution.
Integrate the EDI orders directly into our Lawson order entry system.
I set up our VAN, handled interconnects with our Trading Partners, and
created all message mappings for each document required. The documents
were created in X12 4010 standards. We acquired Extol as our translator.
Aug, 1997
~ June, 1999
Enhancement of the financial modules including Project Management Accounting
and Budget forecasting, Accounts Payable, Purchase Order Entry, Processing
and Distribution, and Inventory Management. In house development and providing
technical support were the core responsibilities. The work involved analyzing,
coding and testing new and existing features for better efficiency and
optimization, as well as supporting the various releases. The programs
were written in COBOL, Visual Basic and other Walker proprietary languages
in an RDShare file control environment for DB2 / CICS / VSAM environments
with MVS / VM as the operating systems.
Reporting Solutions
Involved in multiple projects to enhance the ability of data extraction for
reporting purposes. Focus Reports that accessed DB2 tables using SQL.
Developed Visual Basic forms that linked to COBOL using screen scrapes.
Installation of the Direct Web product, which allowed the Walker CICS
transactions to be accessed directly from the Web. This involved coding
in COBOL, VBScript, and HTML commands.
Data Migration
Developed standard routines for the migration of customer data from
one release of Walker financial to another. Analyzing Walker systems
for performance and data corrections & testing the migration routines
after generating test data were the core responsibilities.
Quality Assurance
Lead a team of professionals for system testing of the new releases
and provided technical guidance and expertise as needed.
Monitor the testing progress and job scheduling were my secondary
responsibilities. This involved mainframe and client testing of
financial applications and efficiency measurements.
Y2K
Reengineered the Procurement system for YEAR 2000 compliance. This
involved identifying the affected entities, mainframe field expansion,
recode and testing client/server applications.
Computer Learning Center, SF, CA
1997
Computer Programming
