ANDREW CICCARELLI, MCSD, PMP
Andrew.D.Ciccarelli@gmail.com
216 6th St., #9
Huntington Beach, CA 92648
(310) 614-1100
_________________________________________________________________________________________________________
EXPERIENCE
Ceradyne - Costa Mesa, CA January 2007 - present
Senior Consultant - Revere Group, Los Angeles, CA 90025
Created n-tier C# ASP.NET WebForms on IIS 6.0 for online requisition processing.
Implemented a web service in .NET to send form input to Documentum AppXtender.
Implemented client-side and server-side required field, regular expression and
comparison validation for WebForms. Implemented Windows authentication. Wrote
application stored procedures in T/SQL on SQL Server 2005. Created linked
servers, stored procedures and database jobs to import data from source systems.
Configured Database Mail on SQL Server to send application e-mails. Created WBS
(work breakdown structure) to decompose requirements into work packages. Created
a structured risk management template. Created use cases to define system
behavior. Created a class diagram to model component inheritance and
aggregation.
Countrywide - Agoura Hills, CA April 2006 - December 2006
Senior Software Consultant - Teklead, Los Angeles, CA 90024
Enhanced and maintained a 3-tier enterprise-wide asynchronous web service
written in C# to accept and return dynamically generated XML documents. Wrote C#
classes to dynamically generate XML document for web service response. Use an
XmlValidatingReader to validate the dynamically generated XML against the
client's XSD. Used a ValidationHandler to handle exceptions thrown by the
XmlValidatingReader. Developed data access logic using ADO.NET with Oracle and
SQL Server 2000. Implemented .NET caching to improve performance. Developed
custom configuration sections to provide modular configuration for web service
components. Refactored code using OO concepts to reduce complexity and improve
maintainability. Created WBS (work breakdown structure) to decompose
requirements into work packages.
Lockheed Martin - Grand Prairie, TX September 2004 - April 2006
Senior Software Consultant - Concero Partners, Plano, TX 75024
Helped deliver a new ASP.NET C# application with six developers by using
Microsoft Solutions Framework 3.0. Created a file upload control to return Excel
spreadsheets as strongly-typed DataSets by using XML/XSD. Used this
functionality to establish an architecture for Electronic Data Interchange (EDI)
with vendors. Created an extensible RegularExpressionValidator by mapping
validation types to an XML file and retrieving the validation expressions with
XPath. Extended the .NET validators to provide client-side and server-side
required field validation. Extended the .NET DataGrid to include a custom
header, footer, pager and hover style. Created composite input controls that can
also display as labels. Implemented Forms Authentication. Created security
input pages and PL/SQL stored procedures. Converted paper forms to
self-validating online forms. Leveraged Use Cases to elicit requirements,
establish design constraints and build consensus among a cross-functional group
of managers.
Deloitte & Touche - Dallas, TX April 2001 - September 2004
Senior Software Developer
Served as project lead to develop a .NET C# application to send e-mails to over
20,000 clients on Linux Sendmail. Created application data model and PL/SQL
stored procedures on Oracle 9i. Created pages for office administrators to
administer e-mail messages and view e-mail log details. Created Cascading Style
Sheets (CSS) to ensure a consistent style for the application. Wrote JavaScript
functions to extend application navigation and validation. Helped define business
requirements with Sr. Managers and Partners. Administered projects using Visual
SourceSafe and used PVCS Tracker for issue tracking and resolution. Developed
.NET C# portal with single sign-on functionality to support over 50,000 users.
Created user administration module to store user details including MD5-encrypted
passwords. Designed portal with UML Class Diagrams, Sequence Diagrams and Use
Cases. Developed previous portal and user administration modules using Java,
J2EE, JAAS, STRUTS, JSP, Servlets, JBoss, and Ant with a Model-View-Controller
design pattern. Wrote LoadRunner scripts to load-test applications and identify
regression errors. Awarded the 2002 Deloitte & Touche Above and Beyond award for
leadership and commitment.
Concentra Managed Health Care - Addison, TX October 2000 - April 2001
Software Consultant - Matrix Resources Dallas, TX 75242
Led four developers to identify and resolve issues with billing system software
written in PowerBuilder 7.0, Sybase SQL Server and C on Unix. Generated a pie
chart for management presenting the most common issues, explanations and
resolutions. Performed database performance and tuning to improve application
performance. Wrote T/SQL stored procedures and triggers. Created UML class
diagrams to propose system enhancements.
Crossroads Investment Group - Dallas, TX May 2000 - October 2000
Software Consultant - Ajacom Corporation Dallas, TX 75080
Designed and developed workflow software for investments firm including the
development of an automated email process using OLE/ActiveX and COM objects to
download investment updates from the web and send the investment updates to
investors via automated e-mail. Developed accounting and reporting modules using
PowerBuilder 6.5 on Microsoft SQL Server.
UnitedHealthcare - Birmingham, AL March 1999 - May 2000
Software Engineer
Developed and coordinated the implementation of a reporting application for the
Southeast region using PowerBuilder 6.5 with PFC and IBM DB2 4.0. Used Microsoft
Project to scheduled project resources, milestones and dependencies over
iterative and incremental release cycles. Used InstallShield IDE to create
installation packages. Created regional intranet site using ASP and JavaScript.
Worked on a team to convert an insurance claim entry system from COBOL to
PowerBuilder.
Office of Technology Resources, University of Southern Mississippi August 1998
ý March 1999
Web Developer
Created several web sites using HTML, JavaScript, Adobe PhotoShop and Macromedia
Flash. Presented site layout and design to clients. Created a web development
business plan for OTR including product packages and pricing.
EDUCATION
Bachelor of Science in Business Administration
Emphasis: Management Information Systems
University of Southern Mississippi, December 1998
Hattiesburg, MS 39406
Awarded Who's Who in U.S. Colleges and Universities
Omicron Delta Kappa Leadership Honor Society
Outstanding Freshman Male (All-University)
CERTIFICATIONS
Microsoft
70-300: Analyzing Requirements and Defining Microsoft .NET Solution
Architectures
70-301: Managing, Organizing and Delivering IT Projects by Using Microsoft
Solutions Framework 3.1
70-340: Implementing Security for Applications with Microsoft Visual C# .NET
70-320: Developing XML Web Services and Server Components with Microsoft Visual
C# .NET and the Microsoft .NET Framework
70-315: Developing and Implementing Web Applications with Microsoft Visual C#
.NET and Microsoft Visual Studio.NET
70-316: Developing and Implementing Windows-based Applications with Visual C#
.NET and Visual Studio.NET
70-229: Designing and Implementing Databases with Microsoft SQL Server 2000
Enterprise Edition
IBM
000-665: Architectural Design of SOA Solutions
000-486: Object-Oriented Analysis and Design with UML
000-639: Rational Unified Process
Project Management Institute
PMI-001: Project Management Professional
|
