TECHNICAL SKILLS

Programming Languages:

• SQL Scripting, PL/SQL, MySQL, Transact-SQL, PHP
• C .Net, Visual C , ProC, Vax/Dec C
• Visual Basic.Net, Visual Basic 6.0, VB Script
• Dcl, Cobol, Fortran, Macro32 / 64,
• Assembler IBM and Dec
• WMI, ActiveX, PERL
• Java, J2EE, JSP/Servlets, EJBs

Operating Systems:

• Windows Server 2000 through 2012 R2, Windows NT Server and Workstation
• Windows 7
• Windows XP Professional and Home
• Windows Professional 2000
• Windows Vista
• Windows 98/95, DOS
• VMS Versions 2.1 through 7.1, RSX11-M, RSTS, RT-11
• Unix Sun Solaris 3.4, Unix AXP
• Linux
• AIX v5

Databases:

• SQL Server 2000 through 2012
• MS Access Access 97 through 2012
• Oracle 12, Oracle 11i, Oracle 8, Oracle for Workgroups v7, Oracle v6, Oracle Developer 2000, OracleERPSuite,
• SQL Plus
• RDB6.0, DBMS, Ingres v6.4/06, ASK ManMan
• Sybase11

Layered Products:

• Visual Studio 2003 through 2012, Visual Source Safe BI Business Intelligence Development Studio
• .Net Framework 2.0 through 4.0
• ASP.Net
• MVC
• Web Forms
• Web Services
• XML, MS Silverlight
• Rational Clear Case
• Core Dossier, Guard 4.1
• FTP, TCP/IPv6, TCP/IP, TCP Ware, Pathworks, PBX, TSClient
• NetOP, Reflection, MSMeeting
• IIS 6.0, ActiveBatch
• PC Anywhere, Xybion
• EFS, ETM
• FrontPage200, HTML, SFTP, NDM
• Crystal Reports, Wordscan, Imagecenter
• MS Exchange
• MS Office through 2012 Word, Excel, Outlook, Power Point
• MicroSoft SharePoint, Microsoft Office SharePoint Server 2007, Microsoft Office SharePoint Designer 2007,
• Extensions for Windows SharePoint Services 3.0, WSS 3.0 Windows SharePoint Services , Team Foundation
• Server 2010
• SMS Server 2.0,
• SSIS, SSRS, SSAS
• WinSCP, VSTS, SLC, ASP,.ADO, XML. DHTML, SOAP, AJAX, WCF, 2007 Moss
• IBM WebSphere
• Agile development methodologies

Hardware:

• IBM Blade Centers, LPAR, Think Pad
• Dell Series,
• Compaq Servers DL380/DL580, Compaq Deskpro, Compaq Proliant, Compaq 6500,
• IBM compatible x86 based PCs, IBM compatible multiprocessor servers,
• SUNSparc Systems,
• Ethernet network, PBX Devices,
• DEC Cluster Configuration, VAX 6620, 6410, 8350, 4000, DEC Alpha 500 7 Node VAX/Alpha cluster system,
• MicroVAX II, 42 Node VAX models running from 3100 to 7630, PDP11 series,
• IBM 3090, IBM p570

James Scott Ritsick

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Hired to complete several critical projects
• Validation, FDA compliance, which included making their proprietary software, bug free. This was critical, if not finished
• by the deadline they would lose several of their larger clientele. I completed the work several weeks early, which allowed
• extra time to prepare for presentation to the FDA. There were over 65 problems that were fixed. Each problem was
• presented by a ticket system called OneSite . The programming was done in VB6 VB .net using embedded SQL
• accessing several SQL Server 2008 R 2 databases, both local and remote. Much of the enhancements were in the forms
• and subsequent modules and class modules.
• Completed and enhanced a system written in SQL that would import data using FTP. This data which was in
• tab-delimited flat files was then processed through SSIS dtsx packages, into the SQL Server 2008 R2
• databases.
• Desired future enhancements include rewriting the VB6 system in C .net and ASP.net

Confidential

Role: Third contract Red Compass Associate/Regulatory Portfolio Management - .Net Programmer/In House Software Tool development/Database Developer

Responsibilites:

• Hired to develop a department critical tool called Detailed Regulatory Assessment DRA . This was an Excel workbook and the coding was done in Visual Basic. The basic system was inherited. I created a forms menu to navigate through the system and create desired work sheets based on selection criteria. An Access database was used for data storage and retrieval.
• This system would create the desired spreadsheet, DRA Summary, Dossier, or Renewals.
• Coded changes and enhancements in code-behind Excel Visual Basic
• Changes were made so the tool would be acceptable and more useful for the user community
• Documented all aspects of the system
• Extensive customization and testing were intensive including forms
• There was extensive debugging involved
• Made changes and enhancements for product stability and reliability

Confidential

Role: Contract Sr. ASP.NET/C Developer/Visual Basic .Net Developer/Project Lead

Analyst Supply Chain Procurement

Responsibilites:

• Hired to participate in the major transition that the company was going through. Including
• Documentation of critical systems.
• Automation of critical systems C ,Vbscript, Java
• Operations of critical systems
• Participation in Company consolidation
• Inherited the duties of previous employees
• Running the Daily, Weekly, and Monthly procedures that provides the data for the functionality of business
• operations.
• Strong customer and business focus
• Strong documentation and communications skills
• Experience managing database operations
• Services / Transaction log management
• Backup and restoration
• System database rebuilding
• Import/Export of data
• Copy/move data between servers
• SharePoint development Changes were made according to company specifications.
• InfoPath forms were created and implemented.

Confidential

Role: Contract DataBase Adminstrator/Developer/SharePoint Developer

Responsibilities: Hired to convert very large databases to Access 2010. This involved writing detailed scripts using joins and unions to verify the data was consistent during and after the conversion. All tables, queries, macros, forms, and modules were tested and verified.

• Installation, configuration and management of enterprise SQL Server databases in a clustered environment
• Installation considerations
• Installation validation
• Installation configuration
• Database mirroring
• Log shipping
• Upgrade to SQL Server 2005/2008
• Patch management
• Knowledge of page and extents
• Files and filegroups
• Transaction logs
• Knowledge of database, table, index, partitions and view storage structure
• Experience migrating database objects from development through test and into production
• Experience monitoring events, log files and resource usage.
• Experience working in a formal software system delivery methodology

Confidential

Role: Contract Sharepoint Developer/Administrator

Responsibilites:

• Hired to create customized Sharepoint sites. This included development of the Sharepoint Portal. The client did not want to use any of the available templates.
• They wanted customized graphics that would reflect each season of the year.
• Performed full system life cycle duties from interviewing the client personnel to determine what their goals
• and expectations were.
• Translation of expectations, requirements, and customer goals to technical specifications Hardware and
• Software .
• Development, Testing, and full Implementation of entire system. This required code behind customization.
• InfoPath forms were created and implemented.
• All permissions and accesses were set up so designated personnel could make changes as desired.
• Complete installation and implementation of Sharepoint environment.
• Full Cycle SDLC C / ASP.NET Application Development
• SharePoint 2010 Architecture/Design/Development/Configuration /Customization/Troubleshooting
• SharePoint 2007 / 2010 Created Customized Web Parts/Features/Solution Packages
• SharePoint Server 2010 Configuration of out-of-the-box Shared Services
• SharePoint WorkFlow / WWF
• Microsoft Office PerformancePoint Server Administration / Development / Dashboards
• Scorecard / KPI Key Performance Indicator
• SQL Server 2005 / 2008 T-SQL / Stored Procedures / Triggers / Functions, etc.
• TFS Team Foundation Server 2008 / 2010
• Client Side Web Development Web Services / ASP.NET 2.0
• AJAX Extensions / Java Script / CSS / XML / XSL

Confidential

Role: Contract Database Administrator/Developer/Data Analyst

Responsibilities:

• Hired to do a Database redesign. There were many problems with the current Database such an Invalid Data
• types.
• Wrote SQL Scripts to extract Invalid records from the client. These records were written to an error table. The
• criteria for an Invalid record were any required fields that contained a null were invalid. The Invalid records
• were returned to the different clients to be fixed.
• Performed Daily, Weekly, and Monthly Transaction processing.
• Performed Daily activities also so my supervisor could attend meetings and work on other tasks.
• Created Import and Export DTSX packages for data transfer using SSIS. Using Visual Studio 2008 Business
• Intelligence Projects - Integration Services Project. For Each Enumerator
• Rewrote Documentation to fix the discrepancies between the actual data types and what was in the
• documentation. This was all in accordance with the client FTAs which stands for File Transfer Agreements
• Ability to manage multiple concurrent objectives, projects, or activities
• Experience tuning individual SQL queries, database applications, and optimizing databases for performance
• Experience supporting SQL Server databases 2000, 2005 and 2008 R2
• Experience in the Windows 2003 and 2008 Server Operating System
• Experience with logical data modeling, including developing and maintaining data model diagrams ERD ,
• facilitating structured data modeling meetings

Confidential

Role: Contract Share Point Developer/ Administrator/ Programmer/Developer

Responsibilities:

• Hired to assist in the crossover from Wachovia to Wells Fargo.
• Setting up and modifying SharePoint Sites. This included development of the Sharepoint Portal.
• The projects required proficiency in SharePoint Administration, Excel Services, BDC - Business Data Catalog,
• Creating Web parts, Workflow, IIS 6, Visual Studio 2008, SharePoint 2007, Share Point Designer, U2U CAML
• Query Builder, xml, C and ASP.Net, MVC
• Wrote and modified C and ASP.Net programs to pull fields and data from the SQL Server.
• Database and placed into the Share Point Database.
• This also involved coding in CAML Query
• Built Sites and pages that contained Announcements, Contacts, On call Calendars etc, for several different
• departments. Also applied tight security settings for all documents.
• Deployed and administered MS Office SharePoint Server 2007
• Assessed and optimized SharePoint performance
• Deployed and administered workflows. Set up security including enabling user access
• Created web applications and site collections.

Confidential

Role: Repeat business - Contract On going on as needed basis Computer Systems Manager Senior Software/Systems Engineer see previous experience below for this company also

Responsibilities:

• Client requested systems enhancements and training for staff. See previous experience for details. Contract
• on going on as needed basis.
• Business expansion
• Creation of Blue Moon Kitchens branch of the business
• New business was made possible by the introduction of the 20/20 design system
• Databases were created for the different components such as cabinets, basins, pantries, etc
• These databases could be updated as new models became available
• Kitchen designs could be viewed from 3 different perspectives 3D, Elevated, and Floor Plans
• Expanded system to allow inclusion of the custom counter tops that they manufactured
• Set up system so the field sales personnel could access the in house system which would enable them to do designs and
• pricing quotes at the customer site
• Created and implanted a concise and aggressive back up of all activity and transactions
• Installation of SharePoint 2007 Server and Designer
• Web Parts, Work Flow, Document Libraries
• Documents included Change Control, Community Documents, FAQ, Form Templates, Images, Private Documents,
• Shared Pictures, Site Collection Documents, Site Collection Images, Style Library which contained the Cascading Style
• Sheets .css files
• Lists Announcements, Content and Structure Reports, Reusable Content, Tip of the Week, Tips, Workflow Tasks
• Discussions Community Discussion
• Available on Server Calendar, Community Administration Forms, Dashboard, Metrics, Pages, and Wiki

Confidential

Role: Contract Programmer/Analyst/Infrastructure Transition Engineer, Senior Analyst

Responsibilities:

• Temporary position to ensure work transition of projects that were created by an intern college student, who
• left the company.
• Several projects needed to be completed that were not finished.
• This included several systems that were created in the Dot Net framework. Installing, administering,
• documenting, and supporting these programs was the main objective.
• Other functions included software code management, QA testing, migrating data.
• Primary tools used were SSIS, SSRS, SSAS, and data warehousing. Also involved heavy use of Winforms.

Confidential

Role: Configuration Engineer, Commercial Software Engineer IV, Project coordinator and Manager

Responsibilities:

• Wrote programs scripts in Visual Basic VBScript and PERL
• Development using C , VB.net
• Performed S/W installation and integration COTS, GOTS installations, upgrades, and troubleshooting
• Monitoring and delegation of the ARS Trouble Ticket system Remedy
• Support of the Storage Area Network SAN
• Troubleshoot and solved problems in this production support environment.
• Support requests were administered through a Trouble Ticket system and prioritized.
• Installation and implementation of Microsoft SharePoint
• The goal of this project was to simplify the way departments would share information.
• Created the company master pages
• Organize group activities with shared calendars
• Share Documents All types of formats
• Collaborate via a secure website anytime, anywhere
• Discuss and Manage projects with sub sites
• Exchange Data with Other Office Applications
• Transfer documents using your web browser
• Collect Customer Data with Live Forms
• Interactive surveys and data analyses
• Organized SharePoint Farms
• Assessed and optimized SharePoint performance
• Deployed and administered workflows
• Created web applications and site collections.
• Set up security including enabling user access
• Wrote Inventory system to capture all data for systems on the LDAP of each location.
• This utilized WMI and the Wn32 internal DBs. Once system was completed and tested, the
• system was presented to the user community.
• Training was also provided for the users on how to run the system.
• This was a temporary system that sufficed until SMS Server 2.0 was implemented.
• Complete out-of-the-box Server builds. Windows 2003 and latest service pack. SP2 .
• This also included installing and setting up Raid Level 5.
• Applied all available Hot fixes KB , Updates and Service Packs.
• The goal of this project was to create a deliverable product for the USAF.
• The new version to be created was version 4.5, upgraded from version 4.4.
• This would then meet Lockheed Martin's contractual obligation for this project.
• What warranted the new 4.5 version were 10 different utilities that were written in C under .Net framework.
• The I/O data was stored and retrieved from an SQL Server database.
• This was also upgraded from SQL Server version 2000 to SQL Server version 2005.
• The other tools also used were .ASP, .ADO, XML. DHTML, Transact-SQL, and VB.Net.
• Installation of Windows Component IIS 6.0 for Web Page development
• Responsible for project life cycles.
• Responsible for many different assignments including Trade Studies.
• Several projects in brief were...
• New product version creation - Deliverable to the USAF. - Entire Life Cycle
• Projector project - Entire life cycle
• Inventory project - Entire life cycle
• Several of these projects required coding in VBscript and C .Net
• Also responsible for finding and analyzing the latest technologies to see if they could be applied to our
• environment.
• Created Virtual machines using Vmware.
• Windows Forms/WPF development using C , demonstrating object-oriented, multi-tier architecture and design