PAN HU

15 West Glebe Road, Apt #C4

Alexandria, VA 22305

Email: pan.hu@bearingpoint.com

 

 

 

OBJECTIVE:

 

To provide my services to any company that hires me as a developer, and to sharpen my coding and overall IT skills in the process.

 

 

EDUCATION

 

College

Bachelor of Arts, New York University (May 2003)

Major: Computer Science with Honors

GPA (overall): 3.77

GPA (major): 3.70

 

 

SKILLS / KNOWLEDGE

 

PROGRAMMING

·        Microsoft .NET environment (including ASP.NET)

-        Strong understanding of Microsoft .NET environment fundamentals

-        Proficiency and coding experience in C#.NET and VB.NET

-        Familiarity with Visual Studio.NET 2003 development environment

-        Strong understanding of ASP.NET web programming fundamentals

-        Experience with various ASP.NET controls, both user and server-side

-        Familiarity with ASP.NET authentication, i.e. Windows-based and forms-based

-        Strong foundation in the object-oriented features of C#.NET and VB.NET

-        Familiarity with multithreading features of .NET programming

-        Familiarity with .NET component features, e.g. COM+

-        Familiarity and experience with fundamental features of ADO.NET

·        Other Web programming

-        High proficiency in HTML

-        Familiarity and experience with Javascript

-        Familiarity and experience with classic ASP

-        Familiarity and experience with CGI scripting (Perl)

·        Java

-        Strong understanding of Java language with extensive coding experience

-        Familiarity with all essential object-oriented features of Java

-        Experience with JSP and familiarity with its fundamental features, i.e. servlets and the MVC paradigm

-        Good general understanding of Java component technologies, i.e. JavaBeans

·        C/C++

-        Considerable coding experience in C/C++

-        Familiarity with essential object-oriented features of C++

·        Scripting experience

-        Javascript

-        Perl

-        VBScript, JScript

·        XML/Web services

-        Familiarity with XML fundamentals, e.g. schema validation

-        Familiarity with ASP.NET’s XML capabilities

-        Experience with XML parsing, i.e. XSLT transformation coding and (ASP.NET’s) Xpath navigation functionality

-        Familiarity with XML’s role in ADO.NET and Web services

-        Familiarity with the creation and invocation of Web services using ASP.NET

·        VBA

-        High proficiency in VBA for MS Office applications, particularly Excel and Access

 

DATABASES

·        SQL

-        Proficiency in writing essential SQL statements for retrieving, updating and joining data

·        Database design

-        Familiarity with database normalization issues and fundamental relational concepts, e.g. Third Normal Form

-        Familiarity with translating entities and their relationships into data models

·        Microsoft SQL Server

-        Knowledge of fundamentals of SQL Server database management, including configuration and security

-        Experience in coding stored procedures and calling such procedures from ASP.NET Web applications

-        Familiarity with table relation management and other essential tools

-        Familiarity with triggers

·        Microsoft Access

-        High proficiency in constructing queries and macros to run queries and/or VBA code

-        Extensive experience with report building and constructing user forms

-        Experience in integrating Access with Excel spreadsheets, both importing and exporting data through VBA automation for analysis and reporting

-        Experience in retrieving and updating data from both classic ASP and ASP.NET Web applications

 

SOFTWARE DESIGN/ENGINEERING

-        Experience in gathering user requirements for software solutions

-        Experience in building use cases based on user requirements

-        Familiarity with various UML diagrams: use case, statechart, activity, etc.

-        Familiarity with iterative software development fundamentals (RUP certified)

-        Experience in implementing various software design patterns: singleton, observer, flyweight, factory, etc.

-        Experience in creating complex software programs in Java, consisting of multiple packages and class hierarchies which coordinate with each other

-        Experience in creating class libraries in VB.NET and C#.NET for middle-tier and data-tier modules in Web applications, with attention given to modularity and interfaces

-        Familiarity with common distributed application paradigms, e.g. n-tier architecture

 

OPERATING SYSTEMS/NETWORKING

-        High proficiency in Windows 2000 Server and Professional (MCSE certified)

-        Familiarity with Windows 2000 Active Directory

-        Familiarity with various Windows 2000 network services: DNS, DHCP, remote access, IIS, etc.

-        Familiarity with Solaris 8.0 and other Unix environments

 

 

CERTIFICATIONS

 

Microsoft Certified Systems Engineer (MCSE): February 2003

Rational Unified Process (RUP) Consultant: April 2004

 

 

WORK EXPERIENCE

 

September 2003-present

BearingPoint, Inc. (IT consulting/systems integration company)

1725 Duke Street, 3^rd Floor   Alexandria, VA 22314   Tel: 703-519-2373

Managers: Christina Yan (T: 703-602-3578), Aimee Scanlon (T: 202-302-7985)

·        Project: Contract with Department of Navy’s (DON) Program Executive Office for Information Technology (PEO-IT) to assist DON’s IT functional area managers (FAMs) in rationalizing their application portfolio, conduct business case analyses (BCAs) to compare groups of similar applications and determine which applications are preferred, and migrate legacy applications to preferred applications

• Designed and implemented pilot BCA questionnaires to be used by FAMs, consisting of spreadsheets in Microsoft Excel, with implementation of sheet validation and rules in Excel VBA
• Designed and implemented pilot BCA database in Microsoft Access, including Access VBA code to conveniently browse for and import BCA questionnaires (Excel spreadsheets) to data tables for analysis, scoring, and reporting
• Implemented VBA macros to format tabular data copied from DON Application Database Management System (DADMS) for convenient import into above database
• Developed concept/specification documentation for web-based BCA tool to be used by FAMs
• Updated guidance and checklist documents for FAMs to use in conducting their BCAs, incorporating links to various workbooks and tools such as the interim BCA tool in Excel (see above)
• Analyzed and documented possible methods to collect and administer BCA-related data from widely distributed groups of stakeholders
• Assisted PEO-IT’s effort to collect data extracts of application information from DADMS, DON’s authoritative repository, and integrate the extracts with the pilot BCA database (above)
• Wrote use cases for a possible online tool to be used for collecting BCA pilot questionnaires from FAMs and stakeholders
• Conducted internal pilots of BCA questionnaires, incorporating feedback from other teams supporting the FAM process into questionnaires and BCA database
• Incorporated suggestions and recommendations from internal FAMs (BearingPoint contractors) to improve guidance for and enhance user-friendliness of BCA questionnaires
• Worked with a team supporting Deputy Assistant Secretary of the Navy for Acquisition (DASN Acquisition) to devise a tool for collecting cost information on applications based on DOD appropriations categories, adding this tool to the BCA questionnaires’ financial analysis section
• Participated in BCA pilot with an external FAM on a pre-ranked group of applications
• Assisted in piloting a “functionality matrix” to gather information on relative ability of applications to satisfy business requirements of a BCA group; created tool in Excel to manipulate collected data to make it readily importable to Access database, from which pivot-table reports were generated to compare applications
• Created migration planning tool in Excel to capture fundamental migration planning considerations for a migration group, with dynamically generated full-time equivalent (FTE) analysis sheets and work breakdown structures (WBS)
• Analyzed methods to collect key BCA process metrics through available and feasible tools
• Created Excel tool for FAMs to log BCA progress through its main steps; sheets importable to Access database for periodic progress reports
• Designed and implemented various scoring and metrics reports in BCA (Access) database
• Wrote Excel VBA code to automate calculation of the project’s internal financial metrics
• Wrote Excel VBA code to generate a highly customized pivot table-like report of BCA applications and their information – the code processes a table dump from the Access BCA database

·        Project: Contract with Deputy Assistant Secretary of the Navy for Acquisition (DASN Acquisition) to streamline future procurement practices

• Implemented Excel tool (VBA) to be used by DASN Acquisition and distributed to DON system commands for collecting quarterly and annual procurement metrics pertaining to customer service, human resources, business process, finance

·        Project: Navy-Air Force Interface (NAFI) ticket tracking database

·        Implemented an Access database to import data dumps of helpdesk ticket status information for the NAFI web application, and to produce reports on various helpdesk ticket metrics

 

 

September 1999-July 2003 (website: thru present)

Five Star Touring, Inc. (tour operation company)

60 East 42^nd Street, Suite 612   New York, NY 10165   Tel: 212-818-9140

President: Marjorie Brandon

·        Worked on establishing, maintaining and updating the company’s web site, which displays information on the company’s tour products (http://www.fivestartouring.com)

·        Currently (since mid-2004), site is ASP.NET-based, with ASPX pages and controls (both user and server), and C# the code-behind language

·        Site features include an XSLT-based navigation menu, a site keyword search function and an SMTP-based mail form

·        Original site was built with plain HTML, CSS, Javascript and CGI (Perl scripts)

·        Site will soon be upgraded with more advanced ASP.NET features

·        Provided technical consulting and desktop support to company president

·        Received calls from clients, performed basic tasks such as filing, composing of letters and faxes, etc.

·        Helped organize itineraries for clients and calculate the cost of the services offered

 

September 2002-January 2003

Compu21 (IT training/certification center)

133-50 41^st Ave, 2^nd floor   Flushing, NY  Tel: 718-762-1900

Contact: Winnie Zhou

·        Prepared lab equipment, including Windows and Unix systems, for classes

·        Maintained and troubleshot local-area network for classrooms

 

March-June 2002

Millennium Information Group (MIG) (IT consulting)

50 Broadway, Suite 1100   New York, NY   Tel: 212-430-6375

President: Glen Liu

·        Tech-support internship

·        Worked with help desk staff in maintaining and troubleshooting company equipment – i.e. desktop assembly and repair, local network maintenance

·        Supported end-user company clients over the phone and on site, from individuals to a large non-profit organization with dozens of employees

·        Client support included desktop and local network troubleshooting

 

 

STATEMENT

 

I seek to join a company where my skills and potential can be effectively utilized to support the organization’s goals and objectives. I understand that my actual professional experience as a programmer is limited. However, I do have solid foundations in a range of development areas that I can quickly build on. My learning curve is steep and my enthusiasm for development work is strong. In addition to being a proficient coder, I have strong analytical skills that I can leverage to devise and design solutions as well as implement them. My work experience to date has given me a sharp mind for mapping business requirements to technical solutions. I am confident that I can become a valuable asset to any organization that hires me. I have a strong work ethic and am willing to take on challenges.