Project Manager Customer Service

Jim Hall

SharePoint/Database/Web Developer

**** ********** **, **** ***** VA 23059 Phone:804-***-****

Skills

Databases/Connectivity: SQL Server, SAP, Oracle, Teradata,SharePoint

portals, MOSS 2007, AS400 systems, SAP, DTS, DAO, mySQL, Access. Creating

reports using Crystal Reports, Access, SQL Server, SSIS, SSRS, SSAS. Excel,

Web development/design skills. Skilled in all MS Office Suite applications

and Windows 2000, XP, Windows 7. Expert training abilities.

Work Experience

Data Analyst/Developer - WellPoint (Contractor - Tek Systems) - 10/2009 -

4/2010, Richmond, VA

Performing analysis and creating ad hoc and scheduled reports using SQL

Server, SSIS, SSRS, SSAS, Access, Excel for Operations Support Management

department.

SharePoint, SQL Development using Visual Studio, SQL Server 2005, T-SQL,

SSIS, SSRS.

Project 1: Development of Ticket Request inflow system to provide workqueue

for analysts. Involved custom workflows, customized forms and webparts for

company portal. Project 2: Development of Shift Bid system enabling

associates to submit bids for alternate workshifts. Application awarded

shifts based on rankings in seniority, productivity, and attendance.

Involved custom workflows, customized forms and webparts for company

portal. Project 3: Development of PTO Request system enabling managers to

approve Paid Time Off. Involved custom workflows, customized forms and

webparts for company portal. Interfaced with business counterparts and

gathered requirements, scoped work effort, and designed prototype through

final launch site in all projects. Used SharePoint Designer 2007 and Visual

Studio. MOSS 2007 environment.

Application Data Analyst/Developer - Altria (Contractor - Modis) 4/2009 -

Present, Richmond, VA.

Created a system that pulled data from several sources and created

notification emails incorporating automation of MS Outlook to send

management Daily Procurement Card Threshold Alerts based on preset spending

limits for cardmembers. Working closely with the Purchasing department in

gathering and creating business requirements for project, cost-tracking,

and spending threshold alert databases in support of an AMEX Procurement

Card monitoring implementation for audit readiness. Interfacing with AMEX

data systems to pull data and generate appropriate data feeds. Designing

and developing databases, graphical frontends, and reporting to be used by

Senior Purchasing agents and management. Tools included SQL Server, SAP,

SSIS, Visual Studio, MS Access, Excel, DAO, HTML, and VB programming.

Data Tracking Coordinator/Web Developer - Qimonda, (Consultant -

PeopleSolutions) 12/2007 - 1/2009, Sandston, VA Construction and Cost

Accounting Dept. Configuration and administration of Access front-end

databases and SQL Server 7/2000 back-end databases. Consuming XML, CSV and

other data feeds from various sources (Lotus, SAP, SAS, Excel) using MS SQL

Server 2005 SSIS. Creating reports and views. Performing data mapping and

associated transformation rules. Creating reports/views using Access and

SQL Server for users in cost accounting department. Developing data

model/database and user interfaces (Access/Web) for new applications.

Documenting user requirements, system specifications, and data model of new

and existing systems. Performing testing and QA. Practicing software

configuration management practices. Maintaining and providing enhancements

to existing Access/Web applications. Working with application users to

gather requirements, and create use cases. Improving performance and

usability of existing applications. Maintaining Facilities departmental Web

site. Developing and maintaining Access databases with Visual Basic for

Applications (VBA), DAO, and ADO.

Web Developer - WellPoint (Consultant -TekSystems) 8/2007 - 12/2007,

Richmond, VA Developed and maintained the WellPoint company Sharepoint

portal. Managed requirements using Rational RequisitePro .Performed backups

and ensured user accessibility to the site. Monitored site traffic and

helped scale site capacity to meet traffic demands and performance.

Improved the company's efficiency and designed the look and feel for the

site. Used Pegasystems PEGA BPM, HTML, JSP, JavaScript, and SQL.

Self Employed 3/2006 - 8/2007, Alpharetta, GA End-to-end design and

development of internet sites using PHP, CakePHP and other frameworks.

Systems Application Developer (Contractor) 7/2005 - 3/2006 ACS, Roswell, GA

Built dynamic sites using JSP, Struts, Javascript, CSS DHTML, IntelliJ,

Maven, Photoshop and other tools.

PHP Developer (Contractor) 5/2005 - 9/2005 Safeguard Insurance, Atlanta, GA

Modified/enhanced SugarCRM open-source Customer Relationship Management

portal. Created SQL queries, modified PHP/HTML/JavaScript code to prior to

releasing portal for Safeguard's dealer network. Technology consisted of

the LAMP stack of open-source software (Linux operating system, Apache Web

server, MySQL database and PHP).

Web Content Developer (Contractor )10/2004 - 4/2005 Cox Communications,

Atlanta, GA Managed and developed content, created taxonomies, metadata,

HTML and Flash MX 2004 interactive content for SupportSoft Customer Service

Knowledge base. Technical Writing, graphics editing/creation. Areas of

expertise included browser features,customer billing, and other information

designed for call center personnel and customer end users.

Web Developer (Contractor )1/2004 - 8/2004 Cellnet, Alpharetta, GA Created

Flash MX 2004 pages/presentations/applications. Designed MySQL databases,

queries, built PHP/ASP/HTML pages, created graphics, branding, logos, etc.

Gathered/produced/managed all content for various business-to-consumer

websites. Organized information via information mapping techniques.

Web Developer/Project Manager (Contractor )3/2003 - 1/2004 Atlanta Western

Group, Roswell, GA Architected, designed and developed user-centered

business websites for e-commerce ventures. Designed MySQL databases,

queries, built PHP/HTML pages, created graphics, branding, logos, wrote

copy.

Instructor 5/2002 - 3/2003 Chubb Institute, Alpharetta, GA Instructed

classes of approximately 15 students in user-centered web design and

modular development practices - incorporated (X)HTML, CSS, XML, XSLT,

JavaScript, SQL, ACCESS, Oracle 8i, MySQL, PHP, PhotoShop, Illustrator,

Dreamweaver, MS Windows 2000 applications.

Project/Content Manager(Contractor )9/2000 - 5/2001 Logic Technology,

Atlanta, GA Directed consumer-oriented portal restructure of web site.

Oversaw Information Architects, developers, content producers, and worked

with cross-functional teams. Created test cases, conducted usability

studies. Instituted wireframe prototyping, led extensive user testing for

GEPower.com. Realized savings of 200K for 2001 due to process streamlining.

Managed and coordinated activities of content providers from 30 distinct

business units to create cohesive customer-focused website. Created,

implemented, and enforced standards for international site content resulted

in greater usability with significantly less rework.

Web Content Manager 1/2000 - 9/2000 AGL Resources, Atlanta, GA Supervised

daily operation of all product creation by coordinating production between

IT, Web Content team, and external partners. Performed usability analysis,

restructured/redesigned existing corporate sites. Developed online style

guide for corporation. Directed content producers and application

development for aglc.com and aglr.com sites. Managed development of online

employee press release auto-publishing, uniform ordering, and applications

for intranet. Directed content integration from corporate acquisitions into

AGL sites.

Web Project Manager (Contractor )1/1999 - 1/2000 Weather.com (the Weather

Channel), Marietta, GA Developed and managed coordination of customer-

interactive tools such as online surveys, contests, etc. in support of

"Storm of the Century" and other high-profile promotions. Directed

development of high-traffic photo gallery application, resulting in 300K

advertising sales in first year. Managed on-air promotion of photo gallery

with Weather Channel producers. Supervised integration of 3rd-party

applications, such as chat and message boards. Conducted strategic research

and planning for site enhancements. Created test cases, conducted usability

studies.

Consultant 10/1998 - 1/1999 BellSouth International Wireless, Tampa FL

Developed extranet for use by BellSouth Implementation, Operations and

customer groups in support of installations for international roaming and

prepaid wireless division of BellSouth.

Corporate Website Manager 8/1997 - 6/1998 Intermedia Communications, Tampa,

FL Directed and supervised company's website overhaul project. Produced

high-level and detail requirements documents for new site. Created test

cases, conducted usability studies. Performed competitive market analyses

of web sites. Chaired Internet Steering Committee. Created Internet

Security and Content Creation policies, process maps, and associated

documentation. Oversaw editorial aspects of web site submittals. Wrote

content for internet and intranet use. Uploaded to and maintained content

of web servers (UNIX and NT). Directed designers, HTML/Java developers, and

Information Providers. Performed web server traffic analysis. Created an

online catalog company store for employees. Instituted dynamic publishing

of databases and application prototyping/development using Active Server

Pages.

Technical Writer/Web Content Producer 3/1993 - 8/1997 GTE, Tampa, FL

Managed corporate Web site. Used HTML authoring and graphics tools to

produce home pages, CGI scripts, graphics, animated GIFs, image maps, multi-

media effects. Created security classification procedure tools and content

guidelines for GTE's Customer Service Operation Intranet. Produced test

cases, conducted usability studies. Performed SQL queries on ODBC data

sources to generate Web pages from databases. Maintained cross-platform and

cross-browser compatibility. Converted legacy documentation for intranet.

Trained users in HTML content authoring tools and methods. Authored

articles for industry publications - Wireless Communications.

Education

Central Connecticut State University, New Britain, CT Bachelor's Degree Cum

Laude (3.68 GPA) Chubb Institute, Alpharetta, GA Honors Graduate

LANGUAGES: Java, Swing, Java Servlets, JavaBeans, JavaScript, JSP, HTML,

DHTML, XML/XSL, CSS, Visual InterDev, ASP, PL/SQL, and Visual Basic

APPLICATIONS: Visual Basic for applications, SQL*PLUS, JDK1.3, BDK2.0,

Tomcat Web Server, Visual Age, WebSphere, Dreamweaver, Fireworks,

PhotoShop, MS Excel, MS Project, MS Word, and MS PowerPoint

DATABASES: Oracle 8i, MS Access, and JDBC

ENVIRONMENTS: Windows 2000/NT, XP, and DOS

CONCEPTS: Object-Oriented Programming, web site design, debugging and

testing procedures, relational database design.

Contact this candidate