| Experience |
| 6/2006 - Present |
Wells Fargo |
Chandler, AZ |
Application Engineer |
| Worked on a team that developed, supports and maintains the Rational Suite of products at Wells Fargo. |
| I improved the performance and reliability of the “CORE” application, this application uses a custom threading library, custom TCP/IP messaging and ClearQuest objects to automate the movement of defects and code packages through the ClearQuest workflow. The CORE system generated approximately 300 error messages a day, after a month of debugging and coding the error messages was reduced to one to two a week. |
| Created a custom ADO.NET provider and SQL client application for querying the ClearQuest data store using SQL syntax. This involved the parsing of incoming SQL requests (INSERT, UPDATE, DELETE, SELECT) and convert it to the corresponding ClearQuest API calls. |
| Created a web service the queries the ClearQuest data store using either web services protocols or JavaScript objects. |
| For many of these applications, I generated unit test and executed them with NUnit and added additional logging with log4net. |
| Another project that I created was a custom task scheduler, similar to that of the Windows Scheduler, with a few exceptions. This application allowed the user to create a task using any .NET language. Once created the plug-in or task would be placed in the plug-ins folder and on the next restart of the scheduler the plug-in would be loaded and executed based on its schedule. |
| Created custom CodeSmith templates, a CodeSmith SqlLite schema provider, and a CodeSmith template to generate NUnit tests for an existing .NET assembly. |
| Technologies Used: C#, NHibernate, Log4Net, Custom Threading Library, Custom TCP/IP messaging, CodeSmith, NUnit, SQLite, Oracle, Custom CodeSmith Schema Provider. Rational ClearQuest and Rational ClearCase |
| 1/2006 - 6/2006 |
Intel |
Chandler, AZ |
Lead Software Developer |
| As part of the Flex Services Technical Operations team (TechOps), I was tasked to improve the performance and reliability of one of Flex Services internal billing sites. This web site supported 600 users all across the globe. Application performance was dramatically improved (search speeds when from 3 minutes for 600 records to 3-17 seconds for 1200 records), page load times when from 45-60 to about 5 seconds. The user interface was also improved dramatically be using Ajax technology to dynamically load pages (or sections of) when needed. The security, menu and database interfaces were improved. I was also tasked with reviewing third party developed code to ensure it was following general programming requirements and design. |
| I also created a dynamic reporting application which used reflection to see a list of available reports. In conjunction with this reporting application a Microsoft Excel add in was created to merge cells in a spreadsheet programmatically. |
| Technologies Used: ASP.NET, C#, IIS6, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server Reporting Services, Microsoft Excel, Ajax Professional.NET, Infragistics NetVantage, ComponentArt WebUI. |
| 7/2005 - 1/2006 |
Express Scripts, Inc. |
Tempe, AZ |
Senior Programmer Analyst |
| As part of the Tempe Application Development group for Express Scripts, Inc. I was tasked to help clean up the development processes and help support their existing applications. |
Some of the accomplishments that I achieved during this time frame include:
- Put in place a process for application development
- Created the source code control repository
- Outlined procedures for gathering requirements
- Outlined procedures for documenting functional specifications
- Outlined procedures for developing applications
- Outlined procedures for testing applications
- Outlines procedures for implementing and supporting the applications.
- “Cleaned Up” several of the applications to make use of stored procedures and features of the operating systems and/or frameworks.
- Had one major release (approx. 150 users) of their letter generating application.
- Implemented a fax notification application, to let the users know when their faxes were sent successfully.
- Started a data warehouse project to store approximately 100 gigabytes of their Pharmacy data.
- Implemented several data extracts using Crystal Reports, SQL Server Reporting Services and Microsoft Excel.
|
| Technologies used: Visual Basic 6.0, Visual Basic.NET, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Oracle 9.0i, Microsoft Excel, Microsoft Access, Microsoft SQL Server Reporting Services, Microsoft Visual SourceSafe, Crystal Reports. |
| 12/1998 - 7/2005 |
Guardian Life Insurance Co. |
New York, NY |
Development Manager / Manager of Imaging Practice |
| I managed a team of four people which includes; one project manager, one business analyst, one support person / system administration and one developer. Management task include handling day to day personnel issues, assigning work to people, ensuring that work is complete and performing semi annual reviews. Daily tasks include creating status reports, attending status meetings, supporting existing systems, designing new systems, gathering requirements. |
| I also look for ways to optimize the current applications by re-architecting them as newer technologies come out. Examples include: Redesigning Kofax Batch Classes, using new components/technologies that become available. |
| Some of the day to day programming tasks include, designing Kofax Batch Classes, modifying OCR for AnyDoc templates, modifying the Web site and components that have been created, creating Kofax release scripts and recognition scripts. |
Some of the accomplishments I achieved while being the manager of the imaging practice include:
- Created a conversion application to take documents out of Optika and place them in a FileNet repository.
- Create a secure remote scanning facility which allowed Guardians agencies to scan documents and transmit them securely to the central capture area.
- Part of a team of individuals that was responsible for creating a workflow RFI and gathering business requirements.
- Optimized existing Optika workflow application.
- Created disaster recovery solution for all of the imaging systems at the Guardian.
- Created a Forms Design Guidelines for Visual Basic development in user at the Guardian
- Served as a member of the Enterprise Architecture team to create a framework for the company using .NET technologies.
|
| 12/1998 - 7/2005 |
Guardian Life Insurance Co. |
New York, NY |
Project Manager |
| I managed a project for Guardian’s Individual Market profit center. This application was designed to enable for faster underwriting of the insurance applications. This was accomplished by having the agencies scan or fax in their application to our capture system which in term indexed them for storage in the FileNet repository. I was responsible for getting the project approved, designing, developing, implementation and supporting the project. The project team consisted of 4 developers, 1 DBA, 1 system administrator and me. I managed this project from end to end. The following technologies were used; Microsoft Visual Basic, Microsoft ASP, Microsoft VBA, FileNet SDK, Desaware NT Service Toolkit, OCR for AnyDoc, DCOM, Accusoft ImageGear, XML. Project Life Cycle: Full Cycle. |
| I started on the team as the lead developer, but I am now the project manager, to build the Billing Information Storage and Retrieval System that is currently in production. While working on the team my responsibilities entailed, installing and configuring a FileNet Image Services server, implementing a Datacap capture system, creating a Visual Basic front end and an Intranet based front end to query the FileNet repository. I also built several scripts for retrieving a data file from the corporate main frame and uploading to the Oracle validation database. I was also responsible for training all of the users on administration and use of the BISAR system. Other responsibilities included evaluating other capture and imaging products for use in production. In building the Intranet application to query the FileNet repository, I designed and developed a connection pooler to FileNet. The connection pooler ran as an NT service and handled multiple requests coming in FileNet connections. This saved the company over $400k in licensing fees. The connection pooler was able to use 15 connections to support over 300 users. I created an imaging framework that sat on top of the FileNet API, to provide easier more object oriented access to the FileNet repository. With this Intranet application, I build a suite of FileNet Visual Basic COM wrappers that accept parameters and return results as XML documents. Technologies used: Visual Basic 5.0 – 6.0, Microsoft InterDev, FileNet IDMIS, Datacap 2000, Microsoft Ado, Oracle 8.0.5, Windows Scripting Host, IIS 4.0, Active Server Pages, HTML, Dynamic HTML, ASP, Accusoft ImageGear, Digital Certificates, COM, DCOM, XML, and NT services. Project Life Cycle: Full 1st & 2nd phase release. |
| 12/1998 - 7/2005 |
Guardian Life Insurance Co. |
New York, NY |
Technical Consultant |
| I served as an imaging consultant for the Guardian Life Insurance Company & Berkshire Life Insurance Company merger. I helped Berkshire Life Insurance with recommendations for their design of the imaging and workflow application. Project Life Cycle: Full Life Cycle. |
| I headed the development team for an imaging workflow project for Park Avenue Securities. With this system I designed the backend workflow database and form data storage. I was also responsible for designing and developing over 10 components for interacting with FileNet, CereSoft and SQL server. These components performed data validation, data verification and workflow routing. I also had to build a custom SGML parser to read export files. Project Life Cycle: Full Cycle. |
| I also worked on the Online Electronic Forms Repository project. For this project, I created a prototype Internet site where people can search through a database of forms that the Guardian had to offer. I was also involved in many vendor meetings to determine which vendor application met the needs of this project. For the production system, I design the backend database for the forms repository. I also created the conversion program for the department’s old Microsoft Access database to the new DB2 database. Technologies used: Microsoft InterDev, ASP, Microsoft Ado, UDB, IIS 4.0, Active Server Pages, and HTML. Project Life Cycle: Full Life Cycle. |
| 4/1998 -10/1998 |
DeBari Associates |
New York, NY |
Director of Technology |
| I managed the technical staff that consisted of six programmers, 2 network administrators, and 3 interns. Part of my responsibilities included managing all in house development, approximately 5-6 projects a month. These projects were custom designed document imaging projects. Documents are scanned, then "coded" using the scanned image. We then created a custom export application for the clients to use with their document system. Other duties included the interviewing of prospective candidates, and terminating employees. I was also responsible for the computer network that consisted of over 300 computers both in New York and the country of St. Vincent. I also maintained client contact to ensure the data that we were providing them was accurate. Technologies used: Visual Basic 3-6, Microsoft Access, Microsoft Word, Microsoft FrontPage, Microsoft ADO, Microsoft RDO, Microsoft DAO, ODBC, Microsoft SQL Server, Kofax Imaging, Caere OCR, Seagate Crystal Reports. Microsoft Project and Microsoft Team Manager. |
| 12/1997 - 3/1998 |
Bear Stearns |
New York, NY |
Vice President |
| I managed the development several projects that the group created; part of my responsibilities included the managing of the developers on these projects, attending several weekly project status meetings and new development/project meetings and holding monthly code reviews. I created several graphical custom controls for this organization and a project documenting utility add-in. Technologies used: Visual Basic 5.0, ADO, AS/400. |
| 6/1996 - 12/1997 |
Lehrer McGovern Bovis |
New York, NY |
Project Leader |
| American Museum of Natural History, New York, NY. Project Leader, 7/97 to 12/97. I served as the primary developer and contact to build a totally customizable project tracking system for the museum. The application included familiar Windows interfaces, such as the Explorer and "hot tracking". Technologies used: Visual Basic 5.0, ADO, Erwin, Microsoft Project, and Crystal Reports. Project Life Cycle: Through development. |
| U.S. General Services Administration (GSA), Washington DC. Senior Programmer, 6/96 to 12/97. I served as the primary developer for a nationwide project management system. In constant contact with the GSA through meeting and telephone calls, I managed the development and the evolution of this product. Duties included creating new database tables, assigning team resources, and keeping the client update to date with the most recent copy of the application. In addition to assigning an reviewing the work of other developers on the project and interacting with the rest of the team, I also developed and implemented the financial, contract, cost, security and administration modules in the Project Manager’s Toolbox. These modules track how money is spend on projects by the Public Building Services of GSA. The financial module issues requisitions and tracks commitments, obligations, and payments on awarded contract. This module also allows the project manager to create a spending plan, allocate funds and track actual and future estimated costs thought out its lifetime. Technologies used: Visual Basic 5.0, ADO, VBSQL, SQL Server, Wise Installation, Microsoft Project, Microsoft Word, Microsoft Excel, Crystal Reports. Project Life Cycle: Full Life cycle, and deployment to 12 regional offices. |
| Princeton University, Princeton, NJ. Project Manager, 9/96 to 12/97. I visited with the Princeton University staff and determined what there needs were for a project management system. Though several meeting with the team I determined what they needed as far of the software goes. And headed the project development team to build this. Technologies used: Visual Basic 4.0, DAO, Microsoft Access, and Crystal Reports. Project Life Cycle: Full Life Cycle. |
| 6/1995 - 6/1996 |
Norwood Computer Services |
Hicksville, NY |
Programmer |
| I developed and implemented their payroll and invoicing system. This system included interaction with Microsoft Word, Microsoft Excel, MAS 90, Advance Software to create many different reports. The system included transactions with accounts payable, accounts receivable and general ledger. Technologies used: Visual Basic 3.0, Crystal Reports, Microsoft Access, Sybase, FoxPro, and MAS90. Project Life Cycle: Full Life Cycle |
| I was responsible for a 40 computer wide area networks in over four cities throughout the U.S. I was also responsible for configuring and maintaining a Windows NT and Novell Server. Responsible for configuring workstations for the seven workgroups and configuring the software on the workstations. Technologies used: Windows NT 3.51, Novell NetWare 2.1, Ascend Communications, and ISDN. |
| 2/1991 - 2/1993 |
Patriot Computer Services |
Queens, NY |
Programmer |
| I was responsible for creating a real estate database system that tracked available apartments, and rented apartments. It maintained a list of upcoming apartments and the managers of these apartments. Technologies used: QuickBasic, Project Life Cycle: Full Life Cycle. |
| 12/1987 - 6/1995 |
RGIS Inventory Specialist |
Westbury, NY |
Area Manager |
| I developed a timesheet and invoicing system. This system was used to bill over 100,000 customers a year. Technologies used: Visual Basic 3.0, Microsoft Access. Project Life Cycle: Beta. |
|
| Additional Information |
| I have 10 years of professional programming experience. I have programmed with Microsoft Visual Basic versions 3.0 - 6.0, .NET, C# and Active Server Pages. I have worked on the following imaging systems; FileNET Images Services. I have used the following tools to aid in my development of software packages; Microsoft InterDev, Microsoft Visual SourceSafe, Microsoft Access, Microsoft Project, Microsoft Excel, Microsoft Word, Microsoft FrontPage 98, Microsoft Team Manager, and Windows Scripting Host (VBScript and Jscript). These are some of the controls that I have used to aid in my development Crystal Reports, FarPoint Spread, FarPoint ListPro, Kofax Image Controls, Caere OCR toolkit, Accusoft ImageGear Pro, and Desaware NT Service Toolkit. I have worked with many databases; here are a few Microsoft SQL Server, Sybase SQL Anywhere, Oracle, and UDB. I used the following to connect to these previously mentioned databases, Microsoft ADO, and Microsoft ODBC. I have working knowledge of the following technologies: XML, COM, DCOM, MTS, MSMQ, OOP, .NET. |
| I have had two articles published in a magazine, one in Windows Developers Journal, and the other in Microsoft Developers Network library. I have received the Microsoft Most Valuable Professional award in 1996, which is awarded to developers who aid other developers in programming problems. I belonged to the beta test teams for the following products. Dundas TCP/IP Software, Symantec Anti-Virus, Microsoft Windows 95,98, Millennium Edition, Microsoft Visual Basic v5.0, Microsoft Windows 2000, and Microsoft Outlook 2.x and 98. I have worked with the following operating systems, Microsoft Windows, Versions 3.0 - 98, Microsoft Windows NT, Versions 3.51 – 2000, XP, MS-DOS, Versions 3.3 - 6.22, and Windows NT Server, Version 3.51 –2003. I also created a web page geared towards Visual Basic development, "Beyond The Basics of Visual Basic", at http://www.geocities.com/~jguadagno, this web site is still up but not up to date. This web site has won an award for intuitive and new design for the menu. |
|