Senior Programmer/Analyst - Project Leader

Piero Giorgi

TECHNICAL SUMMARY

• More than twenty years of experience in business analisys, project definition, architectural software design, development and implementation in Software Products, Client/Server and Internet/Intranet applications throughout the whole software development cycle.

• Project leading throughout the whole life cycle from analisys to design to market rollout.

• Business, feasibility and functional requirement analysis and assessment.

• Excellent analytical and problem-solving skills, project leading, small and medium size.

• Excellent experience with advanced MS based client-server (Thick Client) applications.

• Excellent experience in database access technologies. ADO.Net, ADO, and DAO.

• Good experience in writing stored procedures, database triggers and writing crystal reports and data reports in VB.

• Excellent expertise in design and use of databases like SQL Server, Oracle, MYSQL, MS-Access.

• Excellent Data Warehousing, OLTP, OLAP, DataMart, Star schema design experience

• Substantial level of skill in various other products.

• HIPAA Certification on Compliance, Fraud, Waste and Abuse.

• Bilingual English-Italian, also fluent in Spanish

• Bachelors degree in Computer Science

TECHINCAL SKILLS

Operating Systems Windows 95/98/2000/XP Professional/Vista/NT, UNIX, LINUX, MS-DOS

Languages C#, VB.NET 2/3/3.5, VB6, PL/SQL, T-SQL, ASP 2.0/3.0, ASP.NET, HTML, DHTML, PHP, COM/DCOM

Databases SQL Server (With LINQ), Oracle, MS Access, MYSQL

IDE Tools Visual Studio 2005/2008, Dreamweaver, MS FrontPag, Visual Interdev, Web Development Tools, UML Tools

Reporting Tools Crystal Reports 8/9/10

Standards EDI, SOA, ESB, WSDL, XML

Packages MS-Office, Macromedia studio, Cinema4D, Oracle Toad, MDPro, Zen-Cart, Joomla

PROJECTS

American Healthcare, Rocklin, CA

Environment: Visual Basic .NET, SQL Server 2005

10/2007- 5/2008 Contract – Project delivered

Description: Medical Eligibility System review and improvement

Responsibilities:

• Senior Software Engineer/Business Analyst

• Visual Studio 2005/2008 environment.

• LINQ Implementation in the Eligibility package

• Complete architectural analysis and improvement of the front-end and database.

• Optimisation of the existing database for performance and search capabilities using OLTP and OLAP techniques.

• Written an interpreter for the translation of EDI X12 834 (Eligibility interchange) files

• Design and code of Visual Basic interface in order to import and use the EDIFACT standard for file interchange.

ABSO, Roseville, CA

Environment: C#, SQL Server 2005

4/2007 - 10/2007 Contract – Project delivered

Description: National Criminal Database and Criminal Background Check web service development

Responsibilities:

• Senior Software Engineer/Business Analyst

• Complete architectural analysis and design of the front-end and back-end for the new Criminal Background Check system.

• Design and code of C# interface for the web service, with extensive use of T-SQL queries based on the MS SGL Server 2005 Full Text index engine.

• Design end development, all the BackOffice and database maintenance tools.

• Design and creation of the Star schema for a SQL Server 2005 Database with use of partitioning to keep the database easy to manage.

• Extensive use of OLTP technology to maximise the efficiency of the database during the constant data pumping

• Designed the new OLAP access system to maximise the search capabilities of the system.

Styrotrim, Sacramento, CA

1/2007 - 12/2007 Contract - Project delivered

Environment: ASP, VB, SQL 2000, COM, HTML.

Description: E-Commerce Website. (http://www.styrotrim.com) Improve the stability and performances of the site, adding custom administrative capabilities.

Responsibilities:

• Project leader – Team with 5 programmers.

• Wrote the whole project plan, with requirements, resource allocation and timeline analysis.

• Architectural Analysis and redesign of the front-end and back-end of an existing website (www.styrotrim.com) to streamline and simplify the flow of information on Customers and Online Sales.

• Design and code of ASP and COM+ objects

• Design and creation of a SQLServer 2000 Database schema with use of triggers and stored procedures.

• Design of OLAP datamart procedures to identify the best sale areas in the USA.

• Installation, configuration, maintenance and optimization of SQLServer 2000.

TIM – Padova, Italy

4/2006 - 12/2006 Contract – Project delivered

Project: Billing data flow improvement.

Environment: Visual Studio, Oracle 10g.

Project leader/Business analyst – Team with 12 programmers

Requirement analysis, project plan definition and team management.

Database star schema design and best practices mentoring for the team.

Architectural analysis and improvement of the workflow of data during the billing/invoicing cycle of the company, a primary Cellular phone network.

Analysis performed using a wide array of VB6 and .NET self-designed tools acting on PL/SQL Procedures through standard and self designed COM and COM+ objects. The software monitor the flow of data coming from the cellular exchange stations (Averaging 50 million records per day) and marks all the records about dropped and non–billable calls, corrects the records and resubmits them to the billing system.

Architectural analysis and design of an OLAP system, system, based on an ORACLE datamart extracted from the main database, used to identify the best possible “Special offer” plan based on the calling patterns of every single customer of the company. The implementation of the system brought an increase of sales of approximately $6 millions for year 2006.

GlaxoSmithKline – Verona, Italy

1/2006 - 4/2006 Contract – Project delivered

Project: web interface for Pharmacokinesis analytical tool.

Environment: ASP.NeT, PhP, MySql 5.0, SQL Server 2000, Oracle 9i, Apache 2, Linux RedHat.

Feasibility study, analysis, design and implementation of a web interface for a suite of tools used for Pharmaceutical analysis.

Work performed using PhP and ASP .NET on custom designed MySql 5.0 and SQL Server 2000 Databases using standard UML Star schemas.

The software gathers all the raw results of the clinical exams from as an XML file and, after an initial regrouping, outputs the organized data in a custom designed SQLServer 2000 database.

There the data is processed using data mining techniques to optimise and regroup the results.

The web interface provides an easy access to all the tools (BlackBoxes) used to perform the actual work of data mining and analysis, submitting the data as XML Streams.

FPT – Venice, Italy

6/2001 - 12/2005 Permanent - Company downsized

Environment: MS Visual Studio, Visual Basic 6, MS SQL Server 6.5, VBScript, COM, IIS Visual Source Safe 6.0 (For Version Control).

Project Leader – Team size 5 programmers..

Responsible for requirement analysis, project planning, execution and production rollout.

Project definition, analysis and planning.

Management of the various project timelines, allocation of internal and contract resources, direct interface with the company management.

Architectural design, analysis and development of a package for production and production cost control, based on a SQL Server datamart used to optimise cost controls with the purchasing forecast calculated from the bill of materials using OLAP techniques.

Installation, configuration, maintenance and optimization of SQLServer Database servers.

Database analysis and design of several SQLServer 2000 Databases, DTS services, triggers and SQL Stored procedures.

Extensive usage of VB6 and ADO on a SQLServer 2000 DB that is constantly updated nightly via DTS from an existing AS400 DataBase.

Lawrence Berkeley Laboratories – Berkeley

10/2000 - 5/2001 Contract – Project canceled

Project: Janus – Budget control system for a government research facility

Environment: Visual Studio, Visual Basic 6, SQLServer, Oracle 8, Visual Source Safe 6.0 (For Version Control).

Planning and development of a procedure used to manage all the budget activities within a Government research center.

Program written in VB6 with Oracle 8 DataBase using OOP technology.

Bank Of America - San Francisco

5/2000 - 10/2000 Contract – Project delivered

Project: Credit scoring analysis application for business loans

Environment: Windows NT, SQLServer 7.0, Oracle 8, SQL, Visual Source Safe 6.0 (For Version Control)

Development of several reports using data mining techniques from the central servers of B of A.

The VB program is interfaced with the central Oracle servers using a three-tier database system controlled by custom DB-Objects (OOP) acting on a local SQLServer DataBase via ODBC and DTS. The program outputs Rich Text Format (RTF) Files that are passed directly to MSWord.

All the modifications have been executed with Visual Basic 6 with extensive Object Oriented Programming, OLTP and OLAP techniques over the B of A data warehouse.

Clorox – Oakland

3/1999 - 5/2000 Contract – Project delivered

Project: Y2K remediation

Environment: Windows NT, SQLServer 7.0, Visual Source Safe 6.0 (For Version Control), MS-DOS, QuickBasic 4.5, GWBasic

Project Leader.

Responsible for requirement analysis, project planning, execution and production rollout.

Y2K remediation on a set of programs written in GWBasic, QuickBasic 4.5, Visual Basic 2 and 3.

Development of an extension for the International Order Management System for Hazardous Materials, Using VB 6.0 in conjunction with SQL Server 7.0 using custom written Stored procedures

Watkins-Johnson – Palo Alto

10/1997 - 3/1999 Contract – Project delivered

Project: Cellular repeaters control software

Environment: Windows NT, Windows 95, Access.

Team Leader.

Responsible for the whole life cycle of the project, timeline planning and resource allocation.

Responsible for the Testing phase and market introduction of the package.

The package consist in a shrink-wrap suite of programs used for the check-up and configuration of the network of repeaters in the cellular GSM, TDMA and CDMA system. Project written in Visual Basic 4 and 5 using an Access Database on Windows 95 and NT4 platform.

The program remotely monitors all the repeaters and checks all the operating parameters, triggering an alarm if any of the repeaters has a problem or doesn't respond properly.

InsWeb – San Mateo

1/1997 – 10/1997 Contract – Project delivered

Environment: Windows NT, Windows 95, SqlServer, Access.

Senior programmer/Analyst.

Developed the whole backend structure for the company, an insurance ISP that hosts many of the biggest insurance companies in the USA. The tools used ranged from Visual Basic (4 and 5) to SQL Server (6 and 6.5), Access 7 and many other third-party OCX products.

Intel Corp. – Santa Clara

10/1995 - 12/1997 Contract – Project delivered

Project: Landscape – Autonomous chip circuitry redesign software

Environment: Windows NT, Windows 95, SqlServer, Access.

Senior Programmer/Analyst

Developed a series of software tools to be used in the optimization of the new Pentium families. The product was designed to optimize the internal path of the signals, reducing the size of the chip.

The software was developed using Visual Basic 4.0 under Windows NT 3.51 with MS SQL Server 6.0 databases on a Banyan-Vines network. Tables used ranged to 500k to 40MM+ rows.

Extensive use of Object programming (OOP) and OLAP techniques.

Computer Consultants – Tiburon

7/1995 - 10/1995 Contract – Project delivered

Project: The Marina Program – Berth rental on marina harbors

Environment: Windows 3.1, Visual Basic 3, Btrieve.

Project leader.

Developed the MSWindows Visual Basic version of The Marina Program, a harbor and berth rental product. Implemented a point-and-click graphic/map interface into the berth rental program for commercial and tourist harbors.

Work performed with Visual Basic 3.0 and the BTrieve Database system

Santinello Costruzioni – Padova, Italy

4/1988 – 5/1995 Permanent – Company downsized

Project: IT Department manager

Environment: HP260, HP3000, Hp9000, HP/UX, Eloquence, MS-DOS, Windows, GWBasic, QuickBasic, Visual Basic, Access

IT Manager.

Direct interfacing with the company upper management to develop and maintain the whole IT structure of the company

Responsible for the operations of an HP-9000 and a network of 60 Personal Computers and also all the system analysis and programming.

Constant market scanning looking for new technologies.

Used an HP-3000 with IMAGE database to develop a package solution for production planning and control, cost analysis, delivery (truck load plan), billing and accounting for pre-fabricated concrete buildings with all the vendor relations and daily tracking of the production.

Provided accurate real cost information of parts using a 'last price paid' system.

Developed many tools for database maintenance and repair.

Designed and developed a VB program for the analysis of earthquake stress in a prefabricated concrete beam. The program included graphic animated output.

Also used Visual Basic to write an estimation package for industrial buildings; starting from an AutoCad drawing and the database of raw materials it managed to obtain a list of parts to be built, with the bill of materials along with the costs.

The procedure used a custom developed OLAP system, based on HP IMAGE Database with a custom developed datamart engine and proved efficient to the point of printing the purchase orders directly.

In this company I also established a CAD department, hired the drafters and taught them how to use AutoCad.

Contact this candidate