## BIO
**Frank J. Visco
** Sr. Software Developer - Specializing in .Net development
I am a dedicated professional with over 15 years IT experience. I am fully knowledgeable in the entire software development lifecycle as well as relational database design & development.
**PROFESSIONAL EXPERIENCE
=======================================
**
AIG SunAmerica – Woodland Hills, CA Aug 2003 – Present
**Sr. Web Developer** – VB.Net, C#, ASP.Net, Oracle, SQL Server, Win 2000
AIG SunAmerica is a retirement investment and insurance firm. Presently assigned to a business critical project in the investment management & trading division.
o Converted older VB / ASP code to .Net framework insuring zero down-time and maintaining proper version control.
o Re-engineered certain older architectures to improve performance and insure stability.
o Designed and developed an Intranet application to maintain compliance with the US Patriot Act by screening all investors against a known terrorst list publishedd by OFAC (Office of Foreign Assets Control).
o Participated in team driven development projects and followed strict production release schedules.
* * *
Countrywide Home Loans – Calabasas, CA June 2002 – July 2003
**Sr. Software Engineer** – VB.Net, C#, ASP.Net, SQL Server 2000, Win NT/2000/XP
Working in the Secondary Marketing division to assist and lead in major development projects. Also involved in business-critical system re-engineering efforts.
o Lead developer on high visibility loan pooling intranet application being done in .Net
o Developed Intranet application to provide interface capabilities to AS400 systems using ASP.Net & VB.Net.
o Full life cycle development using C#, [login to view URL], ASP.Net, VB.Net, XML Web Services, SQL Server 2000
o Optimized numerous complex stored procedures and SQL scripts to streamline process flows.
o Developed DTS packages to streamline conversion processes.
o Produced logical and physical data models for re-engineering projects.
o Improved SQL database performance by building proper indexes.
o Scheduled routine SQL Server maintenance schedules, and set up security models.
o Converted older VB 6.0 programs into VB.net and ASP.Net applications.
* * *
UCLA, Corporate Finance – Los Angeles, CA Sept 2000 – May 2002
**Sr. Software Developer** – Visual Basic 6.0, SQL Server 7.0/2000, Sybase, Visual InterDev 6.0, ASP, WinNT/2000
Responsible for final development, testing, and production implementation of a campus-wide equipment management and procurement system.
o Analyzed existing system architecture and offered solutions to expedite delivery.
o Developed middle-tier ActiveX components running under MTS.
o Completed several Full Life-Cycle Development software projects.
o Developed web interface for corporate intranet applications.
o Wrote complex stored procedures/triggers for SQL Server and Sybase databases.
o Developed DTS packages to load large volumes of data into a data warehouse on a daily basis.
o Set up constraints and configured indexes for optimal performance and data integrity.
o Performed routine SQL Server database administration
o Produced technical documentation; design specs, data models, process flows, help files, user manuals.
o Carried out initial .Net implementation analysis.
* * *
Affinity Corporation – West Hills, CA March 2001 – June 2001
**Sr. Software Developer** – Visual Basic 6.0, SQL Server 7.0/2000, Win95/98/NT/2000
A company that provides mortgage loan fraud protection services to financial institutions. Duties included support and optimization of high volume transactional Electronic Loan Review (ELR) system.
o Developed COM components for Electronic Loan Review (ELR) system.
o Incorporated use of subclassing, message hooks, and callback functions.
o Developed ActiveX controls (both in-process and out-of-process).
* * *
California Power Exchange – Pasadena, CA July 1998 – Sept 2000
DPRC – Woodland Hills, CA (Contracting Agency)
**Project Lead** – Visual Basic 5.0/6.0, SQL Server 6.5/7.0, Sybase, Access, WinNT
The Power Exchange (PX) was formed as a result of the electrical industry’s deregulation in California. The company provided an energy-trading platform for participants to buy/sell electricity at market prices. Assigned to lead a high-visibility team in the implementation of an n-tier, client/server systems to be used as a pre-processor for the billing and settlements system.
o Participated in initial project planning, requirements definition, system architecture, and database design.
o Installed, configured, and utilized MS Message Queue (MSMQ) for middleware messaging capabilities.
o Installed and configured several development and production SQL Servers.
o Configured security and maintenance schedules for SQL Servers.
o Wrote stored procedures using parameters, cursors, loops, error checking, conditional branching, etc.
o Wrote insert/update triggers, set up constraints and indexes.
o Developed middle-tier COM components encapsulating business rules and logic.
o Implemented Change Management Control procedures.
o Maintained version control of all development elements using Visual SourceSafe.
o Wrote functional/detailed design specifications.
o Conducted system design and code reviews.
* * *
Home Savings of America – Irwindale, CA Feb 1997 – June 1998
RCG/IT – Yorba Linda, CA (Contracting Agency)
**Sr. Programmer/Analyst** – Visual Basic 4.0, Access 2.0/95, SQL Server 6.0, Win 3.x/95/NT
Assigned to the Information Systems Division (ISD). Primary responsibilities were to provide RDMS support for a $60m Deposit Replacement Project. Subsequent duties included development of a distributed project reporting database application, and support for various other software development projects.
o Designed data models to support decision-making efforts requiring large amounts of comparative data.
o Developed Access database applications based on data models.
o Migrated Access databases to SQL Server.
o Developed Visual Basic client/server applications.
o Created views, stored procedures, and triggers.
**(ask for additional work history)**
## Area of Expertise
| > .Net Framework | > VB.Net |
| > ASP.Net | > [login to view URL] |
| > C#.Net | > SQL Server |
| > Database Design | > Stored Procedures |
| > Access | > Web Development |
| > D/HTML | > Documentation |
| > XML/XSLT | > Web Services |
| > VBScript | > JavaScript |
| > OOD/OOP | > ASP / ADO |
| > Win32 API | > Visual Basic 6.0 |
| > Client/Server | > Dreamweaver |
| > COM/DCOM | > ActiveX |
| > Visio | > IIS |
