Project Manager Customer Service
Resume:
RICHARD A. GUIDI
***** **** ******** **** *** F**5, Covington LA 70433
**********@*****.***
CONSULTANT/ SOFTWARE DEVELOPER / PROJECT MANAGER
Addressing Business Challenges with IT Solutions
Pragmatic Problem Solving:
o Proven history applying common sense with a disciplined, systematic approach
to identify core issues and craft innovative solutions that are reliable,
minimize maintenance costs and adapt to evolving business conditions.
Cost Savings & Process Improvement:
Track record of success automating and streamlining vital business processes to
o
enable organizational efficiencies while maximizing business output.
Impact to Operations
Consistently deliver high-profile projects within expedited time frames while meeting all business deliverables
resulting in millions of dollars of business benefit per project.
Core Competencies: ANALYZE - DESIGN - BUILD
Excel in all phases of systems development, including needs assessments, business process analysis,
requirements definition, architecture, design, development, testing and performance tuning in varied
environments.
Co-ordinate and direct all phases of project based efforts while managing and motivating a project team.
Technical Specialties:
Web: ASP.NET, .Net Reporting Services, Web Services, AJAX, XML, JavaScript, JSON, CSS, HTML, DHTML, Classic ASP
Desktop: VB.Net, C# .Net, Visual Basic, Microsoft Office Automation (VBA:Word/Excel/Outlook/Project), MS Access
Databases: Schema design, stored procedures, functions, performance tuning, database optimization
SQL Server (2000, 2005, 2008, 2010), Oracle (up to 10g), MySql
Other: Visual Studio (2003, 2005, 2008, 2010), XML, EDI,
API integration, ERP integration (SAP, Clarify, EDITrans)
SDLC Methodologies – Rapid application development, waterfall, pseudo-agile iterative and incremental
methods
SDLC documentation – Requirements analysis, Functional specs, Detailed Design specs, UML, Test Plans
Project Management – Work breakdown structures, Project Plans, PERT/GAANT reporting
PROFESSIONAL EXPERIENCE
THE NORLAND GROUP Jan 2013 - Present
On contract to GCR developing credentialing sw for the aviation industry.
C#, jquery, AJAX, SqlServer 2012, Entity Framework, VS2012, TFS 2010, Agile.
SPANTECH SOFTWARE INC July 1996 - Jan 2013
Recent client activities include:
Confidential Client:
- Maintaining a C# .Net application which supports state Medicaid billing.
Dunkin’ Donuts:
Developed a C# .Net application which creates custom Planograms for monthly POP material rollouts.
-
Project Manager, Co-designer and developer of Classic ASP web applications with Oracle db schemas to attract Franchisee
applicants and to internally manage the screening and approval process of becoming a Franchisee.
Converse Inc:
- Project Manager, team leader and a developer of integrated worldwide Purchase Order ASP.NET/SQL Server 2005 web
application. (2.5 year project with multiple releases)
Designed and developed the database schema: tables, stored procedures, functions, triggers, indexes.
Spent considerable effort tuning the database and stored procedures for optimal performance.
Co-designed and developed the ASP.NET (vb) pages.
This is a high profile, high volume application with demanding performance requirements.
Enables Converse to coordinate company wide Demand Planning and realize considerable cost savings.
-
Easily processes hundreds of thousands of factory purchase orders in monthly bursts due to highly optimized
-
SQL Server stored procedures, database structure and asp.net efficiencies.
- Used by internal and external purchasers and factory users who are scattered worldwide.
Richard Guidi
Page 2
- Project Manager, team leader and a developer of the International Royalty Licensing Reporting and Forecasting ASP.NET/SQL
Server 2005 web application. (1.5 year project with multiple releases)
Designed and developed the database schema: tables, stored procedures, functions, triggers, indexes.
Spent considerable effort tuning the database and stored procedures for optimal performance.
Co-designed and developed a ASP.NET (vb) solution that not only met all requirements, it exceeded all expectations while
allowing the application to instantaneously adapt to fast-changing business needs by providing extensive user
maintainable configuration features.
Transformed a complex manual global licensing model for 40+licensees and 28 currencies into an efficient,
understandable website portal that allows for locally provided forecasts, reporting of actual results (SSRS), invoice
creation and addresses all contract reporting requirements.
Other client activities include:
Dunkin’ Donuts, Nortel Networks, Compaq, Osram Sylvania, HP, KeyPort Insurance, Gillette and more
Dunkin’ Donuts:
Developed numerous applications in support of Marketing and Franchisee management operations. Examples include:
Documented and analyzed the business processes of the prototype Digital Menu Board program and identified critical
technical and process limitations.
Developed SQL Server 2008 stored procedures and ASP.NET (vb) pages in support of Baskin-Robbins Purchase Order system.
Developed an ASP.NET/Oracle (vb) application to manage the enrollment of Franchisees in the Digital Menu Board program.
Confidential Client:
Developed extensive SQL Server 2008 suite of stored procedures and ASP.NET (vb) pages in support of a high volume
application (thousands of transactions per hour) which tracks political campaign contributions for national level candidates for
the 2012 election.
Nortel:
Developed enhancements to web application supporting Nortel’s customer service entitlement. Developed EDI 850/855
transaction processes supporting logistic part requests. Technologies included JSP, Java, Java Beans, Clarify 12.0 business
objects, First Choice APIs, Oracle 9i and Perl scripts.
Compaq:
Developed a Classic ASP web application to track the Compaq’s implementation process for SAP R/3. The application allows
users to see how data is sourced from legacy applications and fed to SAP, what the data is intended to represent from a local
business perspective and where the data is used in SAP.
Built a VB based tool that calls SAP remote function calls (RFCs) using SAP OLE. The RFCs directly pass data from SAP to the
calling application. In addition to being a stand-alone application, this logic is implemented into several tools which
used/analyzed SAP data/processes.
Osram Sylvania:
In support of a SAP Data Warehouse implementation, developed over 100 Cognos Impromptu reports and re-designed Cognos
PowerPlay cube processes .
Co-developed a tool to automate a re-pricing process. The client has thousands of different products marketed through
several channels, a complicated pricing processes and produces camera ready copy for a series of complex price schedules
(lists). This tool provides an online analysis interface to help product managers understand current position, competitor
direction, and help determine a new price position. The application communicates with SAP R/3: receiving product and pricing
information and passing along the finalized pricing records to load into the SAP pricing module.
DIGITAL EQUIPMENT CORPORATION Sept 1987 to June 1996
Information Systems Analyst/Project Manager
- Team member/business analyst/project manager on numerous projects in support of corporate wide reference
product/pricing and BOM repositories. Consistently rated a top performer in annual reviews!
Projects included:
Analyzed/defined/tested processes to implement real-time and batch interfaces to/from SAP R/3 for 3 SAP implementations.
Interfaces include connecting to non-R/3 systems; manufacturing execution systems, reference databases, data warehouses,
bank lockboxes using client/server, messaging and file transfer technologies. Determined project cross-platform work
Richard Guidi
Page 3
breakdown and resource requirements. Coordinated development activities.
Modeled, designed, coded and implemented a portable MS Access application which builds files to load R/3 with data from
multiple non-R/3 databases. The tool converts the data into R/3 values and builds R/3 input files. Modeled, designed, coded
and implemented MS Access tools that allow users to compare R/3 data to current warehouse data structures and/or act as
integration test platforms for export/import processes.
Co-developed the idea and provided the analytic support for a distributed end-user Rdb DECforms application to integrate new
product data collection processes from Hardware Engineering, Software Engineering, Customer Services and Marketing into a
seamless flow populating corporate reference product/pricing and BOM repositories replacing a decades old paper flow
system. Developed an extensive automated (DTM, SQL) system test suite.
EDUCATION:
University of New Hampshire: BS Environmental Conservation
Boston University: courses towards an MBA
Contact this candidate