Piero Giorgi

Senior Software Engineer, Information Technology and Services

Piero Giorgi is a Software Engineer, Webmaster, Web designer, IT Freak and all around tinkerer

Piero Giorgi's Bio:

Piero Giorgi's Experience:

• Senior software Analyst/Programmer at Styrotrim

  March 2007 - September 2012

  Rebuild the backend of the company sales website. ASP SQLServer HTML

• Senior Solution Provider at Delegata

  April 2009 - December 2009

  Development of a package for Enterprise Risk Analysis (Covered by NDA) Software developed in C# used in conjunction with SQL Server 2005, with large use of OOP, Stored procedures and triggers in a Client/Server environment. Advanced study of the human interface with the use of "PureComponents" that give the application the more modern look of Office 2007. Also part of the PSR project at CalPERS, where I integrated the databases for the error tracking team streamlining and reconciling the procedures, reducing the waiting times and making the process more stable.

• Senior Software Engineer at Parker Hannifin

  August 2008 - March 2009

  Building a "Bridge" software to allow interchange of data between the system of a newly aquired company (High Tech Rubber) to the main Parker-Hannifin mainframe system. Environment: VB6 + SQL Server

• Senior Software Engineer at American Health Care Association

  November 2007 - June 2008

  Responsible for development of the new interface of the Electronic Eligibility System. Work on a SQL Server 2005 Database with Visual Basic .NET HIPAA Certified.

• Senior Software Engineer/Analyst at ABSO

  April 2007 - November 2007

  Design and implementation of a system used to perform Nationwide and international criminal background checks. Work performed using C# over Sql Server 2005, with extensive use of partitioning and full text semantic searches.

• Independent Consultant at Self Employed

  February 2007 - April 2007

  GUI Design and optimization

• Software Engineer at TIM

  May 2006 - December 2006

  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 with more than 30 million registered users. 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. System based on Weblogic SOAP architecture. Architectural analysis and design of an n-Tier 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 Euros for year 2006.

• Software Engineer at GlaxoSmithKline

  January 2006 - April 2006

  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.

• Senior Software Engineer at FPT Industries

  June 2001 - October 2005

  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.

• Software Engineer at Lawrence Berkeley National Laboratories

  October 2000 - May 2001

  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 n-Tier OOP technology.

• Senior Software Engineer at Bank of America

  March 2000 - September 2000

  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.

• Team Lead/Senior Software Engineer at The Clorox Company

  February 1999 - March 2000

  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

• Team Lead/Software Engineer at Watkins-Johnson

  August 1997 - February 1999

  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.

• software engineer at InsWeb

  July 1996 - June 1997

  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.

• Software Engineer at Intel

  October 1995 - June 1996

  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.

• IT Manager at Santinello Costruzioni

  June 1988 - December 1994

  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. 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 prefabricated 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.

• Senior Software Engineer at IBM Global Business Process Services

  March 2010

  Maintenance and update of the CWS/CMS system, for the Child Welfare System of the State of California. Provide system support for a statewide software application, including trouble shooting and detail analysis of user's trouble reports, devising workarounds and other corrective actions as needed. Environment: VB6, VB.NET, C++ on an IBM DB2 database.

Piero Giorgi's Education:

• FF International Studies

  1994 – 1996
  Bachelor of Science

• Dante Alighieri

  1980 – 1981
  Certified Public Accountant
  Concentration: Accounting and Economics

Piero Giorgi's Interests & Activities: