JOSEPH J. GELLER

S69W14090 Tess Corners Dr

Muskego, WI 53150-3160

Phone: (414) 422-9547

Cell: (414) 467-3805

email: joejvg@stonycreekconsulting.com

CAREER OBJECTIVE

Information Technology Professional

WORK EXPERIENCE

Stony Creek Consulting, Inc. - Muskego, WI - 3/2006 to Present

Web Designer/Developer and Managed Service Provider - 3/2006 to Present

Analyzing, designing, developing, administering, and supporting web sites, running on the Linux Operating System and Apache Web Server, using Adobe Web Premium CS4 and NetBeans, are primary responsibilities as a freelancer for this company that I own and operate. Joomla and Drupal Content Management Systems are leveraged whenever possible. Familiarity with most popular Joomla components, modules and plugins, plus developing them using the MVC Framework, and using the OOP paradigm with PHP, and JavaScript, complement MySQL DBMS experience, and extensive development using HTML, CSS, and XML. Development of Drupal Modules, plus designing and styling Joomla Templates and Drupal Themes, using HTML and CSS, complete the profile of a web developer well-versed in analysis, design, development, maintenance, and support of web sites. Marketing and sales are done through freelance web site posts, resulting in over forty five projects so far.

Some of the projects have produced clients who request work regularly, and require daily, ongoing support for the LAMP web sites my company designs and develops for them. For these clients, my company facilitates Managed Service Provider support, on my company's bare metal cloud servers, on which I do all the builds and administration of the Linux operating system, Apache, PHP, and MySQL, plus all other components necessary for firewall, email, and other operating system functions. Installing and configuring control panel software, and setting up clients using it is another responsibility. My company installs, configures and administers networking and the DNS for these cloud servers, while providing automated monitoring on them, facilitated by email alerts to quickly attend to any service interruptions. Contingency recovery services for client's web sites is also provided, by ensuring automated daily backups of my client's web sites and database complete successfully. Ensuring offsite backup retentions are downloaded regularly to local servers in my business office, facilitates recovery of the site from offsite backups, if necessary. My company also provide these same services on servers other than our cloud servers, for other web sites where LAMP design and development work is done, if my client prefers hosting them on another service provider's server. My company also provides the same services on these servers, and where permissible, dose all the installation, configuration, and administration, using control panels such as Plesk, WHM, and cPanel, plus the Linux shell if use of VNC or SSH is permitted. Data centers where these servers are located also undergo a rigorous check by me, to ensure they have adequate provision for contingencies and disaster recovery procedures in place, such as the one my cloud server's data center provides.

U.S. Bank, Milwaukee, WI - 10/1997 to 3/2006

Software Consultant - 6/2000 to 3/2006

The Collateralized Debt Obligation business unit and its 110 users, required extensive knowledge of structured finance and general accounting, to effectively communicate with stakeholders. Applications administered structured deals, simulated trading scenarios, facilitated compliance testing, and generated reports. Interviewing stakeholders and their employees to gather requirements, then translating them to a visual and written format for use by management, business unit, software development, and testing teams, comprised services performed.

As Lead Systems Architect, business analysis processes were followed by design and development of a prototype running on Windows Server, MS SQL, and using MS SQL Reporting Services. This was ported to a fault tolerant, redundant intranet, that used virtual server technology. Rigorous project budget, review and approval processes followed. Software engineering using IBM Rational Unified Process (RUP), Perot Systems Change Management, Microsoft Office, and Microsoft Project, facilitated, and was used during project management, development, testing, and deployment. Final project deliverables comprised CDO Suite, a custom ETL application that used MS SQL Replication and Stored Procedures, Wall Street Office, WebFocus Business Intelligence Suite, Wall Street Office Reporting Intranet Web Site, and data feeds to MS SQL, automated using SFTP, Visual Basic and MS SQL Agent Services. Other development maintenance projects throughout the business unit's systems, were also completed.

During this period, US Bank had a company wide endeavor to ensure contingency and disaster recovery was clearly defined in each business unit's Service Level Agreement. My role was to analyze automated systems hardware and software, determine time required to resolve the outage, and define necessary escalation procedures to advance the outage to the next tier. Each tier had a prescribed period for resolution accompanied by an appraisal of acceptable loss of revenue defined by and acceptable to the business unit manager. Resolution needed to include clearly defined paths to acquire any necessary hardware from vendors, with estimated timelines for procuring, receiving delivery of, and installing it, plus documenting any third party contacts required to install it, plus listing internal staff with the skill sets to do so. My responsibility was also to ensure any necessary software had been cataloged, was accessible, and had the necessary vendor contacts documented and internal staff documented to install and configure it, including accessibility to any documentation required to do so. Escalation was another responsibility to ensure higher levels of management were determined and contact information was documented to involve them in the decision making process to deal with the outage. Each tier was facilitated by replacement of automated processes and procedures with manual ones, to ensure catastrophic financial loss was not incurred. Ultimately, the final tier required definition of processes and procedures that were completely manual to replace automated systems entirely to deal with an extended outage.

Another role I played was to ensure the Service Level Agreement had disaster recovery processes and procedures defined, documented, and approved by the business unit. This entailed ensuring an offsite facility was in place that could facilitate minimum staffing levels and all computer systems, office equipment, and communication devices necessary to keep the business unit in operation and producing the same revenue streams present before the disaster occurred. The degree beyond the scope defined as a recoverable contingency also had to be defined in the Service Level Agreement, to which computer systems, office equipment, or communication devices had been destroyed, before declaring it as a disaster. This also had to be prescribed by and agreed to by the business unit. Determining the amount of time recovery could be accomplished at the previous facility was also a factor in the analysis for inclusion in the Service Level Agreement.

Prior to this, US Bancorp LLC, Fund Administration and Compliance funded a data warehouse project that required mapping CPORT Fund Accounting and Portfolio Management report data to formats MS SQL DTS Packages could import from the application, written in COBOL, running on an Alpha Server. Global financial data was used for any missing information from CPORT Fund Accounting and Portfolio Management report data necessary for creating and maintaining the financial securities master. A prototype was created for Proof-of-Concept running on Windows Server, MS SQL, and using MS SQL Data Transformation Services. Installation, configuration and ongoing support of servers and the application, including maintenance of DTS packages used for ETL, were primary responsibilities. Interviews with business unit personnel, requirements gathering, analysis, design, and data mapping with development teams, plus project management of the final version followed. Charles River application was interfaced next to monitor and maintain the data warehouse financial securities master, and automate compliance tests and reports for fund administrators. This required business analysis, prototyping, installing, configuring, and providing ongoing support for the application. Professional data warehouse training, business analysis, and development of a prototype to mine data in the data warehouse ensued. ProClarity with MS SSAS was used for OLAP Dimensional Data Analysis. Other roles were lead business analyst and designer on a team developing a Java application to produce print-ready fund annual and semiannual report files.

I also was assigned to provide software consulting services to the Fund Accounting business unit and developed Price Feeds for the CPORT Fund Accounting and Portfolio Management application, written in COBOL, running on an Alpha Server. Other duties included developing and supporting interfaces to and from other institutions such as Chase and Bank of New York. Projects also involved installing and configuring the software and hardware necessary to supply NASDAQ with the daily NAV (Net Asset Value) for each of the over 100 funds the business unit was responsible for doing fund accounting for. Development of a centralized pricing server to feed prices from the vendor supplying daily prices for various securities and other financial instruments held by the funds and required for the calculation of their NAV was another role. Another role was installing and configuring the business unit's CPORT Fund Accounting and Portfolio Management application software plus other systems required to do their daily business, including all desktop hardware, Windows operating system, and numerous applications used daily by the Fund Accountants to service the funds assigned to them that they did the accounting for, to calculate the fund's Net Asset Value on a daily basis. The CPORT Fund Accounting and Portfolio Management - FundStation API, was also developed by me during the assignment to this business unit.

Another responsibility was the annual disaster recovery project planning for the business unit. Responsibilities similar to those described for the Collateralized Debt Obligations business unit applied here. However, it was much more extensive for disaster recovery as the business unit was required to contract with SunGard and utilized their complete offsite disaster recovery services, including all hardware and software, minimum amount of personnel required to run the business unit, and an offsite facility to house all of this, while providing the necessary office and communication equipment. The complexity of this business unit required an annual project to assess all these factors and arrive at metrics required for Sungard to ensure the needs of the business could be accommodated. Another responsibility was documenting all of this in diagrams and text to accompany a contract which underwent annual review by myself, the head of the business unit and SunGard. Part of the contract was the annual simulation of a disaster, with actual offsite recovery at the remote Sungard facility of the business unit's primary hardware and software, and a simulated office personnel move to the facility was included. My responsibility was to plan and mange the project to do this, including execution of the annual disaster recovery simulation.

Network Project Manager & Engineer - 10/1997 to 6/2000

Firstar Bank merged with StarBank, and then U.S. Bank. Firstar Networking Services Division hired me. Project duties were to research, purchase, install, maintain and support topology, servers, operating systems, and software applications running on a Novell LAN, used by US Bancorp LLC, Fund Services business units. These resided in a building on a MAN connecting two downtown Milwaukee buildings, and on a Novell WAN spanning several Midwestern states. A variety of projects were completed requiring extensive, hands-on, operating system and software application knowledge and experience, plus advanced network engineering and administration skills with servers and desktops used by approximately 400 users.

Another responsibility was project manager for contingency processes and procedures for the Data Center in the downtown Milwaukee Lewis Center. Similar responsibilities described for the Collateralized Debt Obligations business unit applied here. Tiers were not a factor though, and only contingency, not disaster recovery was applicable. The complexity was far greater since this was a data center and other factors such as a commercial UPS requiring testing and coordination with WE Energy, and complex telecommunications, such as a PBX, T1 and fractional T1's were involved. Requirements for routers, switches, hubs, and over forty servers from three different vendors and other networking hardware had to be accommodated for in the project plan. Annual testing of the plan was also managed by me including scheduling and supervision of all networking engineers and assignment of specific duties to them. An element of disaster recovery was present in the form of running the data center from an onsite mobile generator to supply power, plus the coordination of offsite backups stored in the bank's tower located across the street from the data center. Responsibility for offsite data storage included the purchase of appropriate offsite storage facilities were done. A later project I managed was procuring courier transport of the previous day's backups offsite to a facility far removed from the data center location. The offsite storage cabinets were also relocated there as part of the projects. Daily backups were retained in the building across from the data center as the time to recover them from the remote facility was prohibitive to effective contingency recovery and the one day lag was deemed acceptable. tower facility retrieval of the backups and included in the project plan had to be accommodated.

An inordinate amount of development work I did for these projects, lead to a transfer to Trust Development as a Software Consultant assigned to US Bancorp LLC, Fund Services.

MBC Foods, A Hagemeyer Company - Milwaukee, WI - 10/1988 to 10/1997

Systems Integrator - 1/1992 to 10/1997

Researching, purchasing, installing, maintaining and supporting all components of a Novell NetWare LAN for the company and its mobile sales staff, were my primary duties. The same applied, using SNA and APPC, over a distributed, networked environment comprised of one local and two remote IBM AS/400 systems. Other responsibilities included training and supporting all local and remote personnel on a variety of operating systems and applications, running on diverse hardware platforms.

While Developing and automating remote data communications systems, that connected desktop, laptop and handheld computers to the minicomputer, other systems were implemented throughout the company, including Internet Service Provider and email access for mobile sales staff and local desktop users. Designing, documenting, testing and supporting a radio frequency based warehouse control system, residing on the IBM AS/400 and used to automate receiving, put-away, replenishment, selection, staging and loading operations, were other job duties. Development of an interactive, corporate web site was one of my accomplishments. EDI, including trading partner setup, developing ANSI X.12 transaction sets, establishing accounts with Value Added Networks and implementing necessary data communication over these networks, was another. Development of distribution software on a System/36 and AS/400 in System/36 mode, and playing a major role in migrating the System/36 to the AS/400, were other achievements.

Data Processing Manager & Programmer/Analyst - 10/1988 to 1/1992

Position required managing operations and software development. Developer duties included designing, coding in RPG II on a IBM System/36, testing, installing and supporting general financial applications and wholesale food distribution software. I hired and managed a programmer/analyst to assist. Management duties included responsibility for department's budget, and weekly meetings with management to define and fulfill departmental requests followed by operating system and hardware upgrades, and application software development. Other duties included budgeting, maintaining computer supplies and forms inventory, plus ordering, installing, maintaining and supporting System/36 and desktop hardware, operating systems and upgrades, along with application software and peripherals. Direct reports were three shifts of keypunchers and operators, and a person whose duties were to assist me, order forms and supplies, and support users.

HarrisData Service - Brookfield, WI - 3/1983 to 10/1988

Programmer/Analyst - 3/1984 to 10/1988

As Research and Development team leader, managed development of general financial accounting software on IBM System/34 and System/36, sold and supported by a distributor network. Project management duties included chairing steering committee meetings, prioritizing distributor requests for enhancements and fixes, setting up schedules, and organizing teams of programmers and technical writers. Review of project plan with research and development manager, was followed by design and project approval. RPG II coding and testing with the team were other duties. Responsibility for quality assurance of the shrink-wrapped product was mine. Designing, coding and supporting a custom wholesale food distribution order entry, purchase order, warehouse and inventory management, and sales reporting application was done by a team whose members were a senior analyst, myself, and two, direct report, junior programmers. I also trained and supported customers.

Prior to this, planning, installing, and supporting networked, local and remote IBM System/36 and System/38 minicomputers, used for sales reporting and company wide interoffice memos over a dedicated, leased line connected to a remote System/36, were some of my duties. Others were training operations staff how to use this system and ones like it, providing ongoing support, plus training and assisting field engineers, configuring, installing and troubleshooting various IBM System/3X minicomputer and IBM PS/2 hardware, operating systems and telecommunications equipment. Connectivity solutions for desktop and IBM minicomputer systems using PC Support, plus training and supporting office personnel on PC application software, were other tasks.

Software Support Specialist - 3/1983 to 3/1984

Provided support for a software development and distribution network that was a separate division of Harris Data Service - Int'l Software Network. Designed new releases for general financial applications. Wrote user documentation.

Moore Business Forms and Systems - Brookfield, WI - 6/1981 to 3/1983

Branch Account Analyst Manager

Managed software support specialists who provided support, installation and training for Dental, Medical, Oral Surgeon, Motor Freight (Management and Owner/Operator), and Peach Tree Accounting software applications in the office and also out in the field. Assisted sales personnel with client presentations, wrote and conducted client training classes, assisted support staff with client sites. Supervised field engineer.

Chicago Board of Trade - Chicago, IL - 1/1971 to 10/1977

Member, Registered Commodity Representative & Accountant/Bookkeper – 1/1974 to 1/1977

Member of Chicago Board of Trade, working for Illinois Cooperative Futures Company (sister company of Illinois Grain Corporation) that specialized in hedging holdings of wheat, corn, oats, soybeans, soybean meal, soybean oil and broiler producer cooperatives. Entered trades and provided consultation for these producers on Chicago Board of Trade trading floor. After trading hours, did all corporate accounting and bookkeeping for company's cooperative hedging operations on futures exchange including annual audits by the Commodity Exchange Authority, company's certified accounting firm, and the Internal Revenue Service, plus did all tax accounting and reporting, including tracking and investing company's excess margins in commercial paper approved for that purpose by the Chicago Board of Trade. Maintained open orders and confirmed same with producers on a daily basis.

Trade Runner, Back Office Clerk, Bookeeper - 1/1971 to 1/1974

Worked on floor of Chicago Board of Trade relaying orders placed by Chicago Board of Trade members employed by Lincolnwood, Inc., from and to trading desk and pits. Did back office work for company after trading hours performing miscellaneous tasks such as reporting trade positions to Commodity Exchange Authority, and clerical work in the office such as filing, delivering mail, etc. Later, worked for commercial grain hedging corporation, Illinois Grain Company, and maintained books for their hedging operations on futures exchange.

EDUCATION - AWARDS - ACCREDITATIONS

University of Wisconsin, Milwaukee - Milwaukee, WI - Completed three years - BBA, MIS with CS minor - 3.70 G.P.A.

Member of the National Honor Society, UWM Chapter

RPGII Training – HarrisData Service

Service Above and Beyond Call of Duty - MBC Foods

Service Plaque – MBC Foods

Star Awards - US Bank

Firefighter Award - US Bank

Service Pin – US Bank

WebSphere Training - US Bank

IBM Rational Unified Process Training - US Bank

Microsoft C#.NET Programming - Accredited Course

Information Builders WebFOCUS - Accredited Course