Summary of Qualifications: Requirements and data analysis, business rule definition and verification, process and data modeling, software development and deployment, application and customer support, configuration management, user and group training, and computer hardware savvy.

Technical Skills:

Operating Systems: MS-DOS and compatible 2.0 through 6.22, Novell Netware 2.15 through Novell Netware 4.1, Microsoft Windows 2.0 through Win95/WinNT Server 4.0, Windows 2000, WinXP, (Server, Advanced Server, and Workstation), some exposure to UNIX, Linux, and Solaris.

Software Development: MS-Office (97, 2000, OfficeXP, and Office2003, Office 2007), Visual Basic 3-6, VBA, SQL, Foxbase+ / FoxPro, Clipper, Dbase III Plus/IV/V, miscellaneous Access Addins and ActiveX controls for MS-Access and Visual Basic, miscellaneous Graphics software and production support tools, CA Erwin Data Modeling, Various graphics and presentation software and utility software as needed to complete tasking

Employment History:

Programmer / Analyst Confidential 6/2011 - Current
Perform Data Analysis, Programming, Custom Ad Hoc Reporting, and Vendor Management for Confidential

• Perform Process Analysis to verify and improve existing processes.
• Create specifications and map existing applications to new platform for forensic analysis
• Design custom database and spreadsheet applications as needed to accommodate stake holders' business requirements
• Perform data analysis in an attempt to identify system inadequacies and system data rule issues

Financial Analyst Confidential 6/2010 - 6/2011
Perform Data Analysis, Programming, Financial Modeling, and Custom Support for GS and SES staff at Confidential

• Perform process analysis to determine data structures, processes, and develop pseudo code for new Assertion application model
• Create initial data model for new Assertion application (MS-Access, Excel, VBA)
• Develop new tool in Access / Excel VBA to manage DoD customer assertion information and generate Custom Excel Charts
• Analyze data to create and support metrics for OSD
• Develop automation code to programmatically populate database models to generate metrics output
• Create presentation materials for meetings with various DoD customers

Programmer / Analyst Confidential 10/2009 - 6/2010
Perform Data Analysis, SQL and Excel VBA Programming for PBGC (Pension Benefit Guarantee Corporation)

• Rewrite existing tools and new enhancements for existing tools in the ACT (Actuarial Control Toolkit) Suite
• Develop new tools in the ACT Suite for various data maintenance, repair, and ongoing quality control issues.
• Diagnose, troubleshoot, and repair production problems as necessary across any part of the Suite.

Data Analyst Confidential 11/2008 - 02/28/2009
Perform Data Modeling tasks for Confidential

• Create Entity and Attribute names according to established data naming standards
• Report on Entity and Attribute names to various representatives for verification
• Establish new data standard names as necessary when existing data naming standards do not accommodate model

Programmer / Analyst Confidential 5/2007 - 10/2008
Perform Data Analyst, SQL, and Excel / Access VBA programming for Confidential

• Perform Analysis on tables and fields and modify when required
• Create Excel / Access VBA for automated load of Excel data into data repository
• Create database / spreadsheet models to facilitate improvement in business process definition for data cycles required from DFAS / OSD.
• Modify existing models to extend functionality and to eliminate as much user intervention as possible.
• Assist junior peers in complicated SQL / VBA programming when necessary to solve complex business problems.

Programmer / Analyst Confidential (Client: Fannie Mae / Herndon) 12/06 - 2/07
Redesigned an Access Database for User Acceptance Testing for SIR mortgage processing system for Fannie Mae.

• Performed analysis on VBA modules that calculate rates and verify with business owners
• Modify code to properly test known conditions for UAT and track proper usage of conditions in the UAT process.
• Write new modules to extend the functionality of the existing system for proper performance
• Develop forms as needed to facilitate data entry used to generate expected results for UAT

LAN Manager / Programmer Analyst Confidential, Tyson's Corner, VA 4/04 - 12/06
Designed and developed an automated marketing engine in MS-Access.

• Developed code to normalize data from known patterns and analyze new data for establishing new patterns
• Developed code to create new structures and adjust legacy structures to accommodate external repository
• Designed an automated process for importing different structures into a common repository for lead generation
• Designed an automated process for mass email for targeted marketing blasts based on content of repository data
• Designed and developed an automated statistical analysis engine for an offsite partner repository
• Designed an automated process to map dissimilar data structures to a common repository and adjust repository automatically to accommodate new system components and new data structures
• Reengineered code to run more efficiently and make recursive calls
• Manage Microsoft Windows 2000 Network and associated Servers
• Create new tape rotation scheme and design and implement automated backup routine for LAN drives
• Establish client policy and procedures for various LAN based activities for a small group of salesmen

Programmer / Analyst (Consultant), Confidential, Ashburn, VA. 7/03 - 1/04
Participated in the definition, development, and maintenance of an HR database designed to support deployment activities for a large contracting agency.

• Re-Designed an Access database to take advantage of the features native in a relational database engine
• Assist process managers and business owners with implementation of proprietary corporate business models in an MS-Office 2000 & XP environment (Access, Word, Excel, and Outlook)

Programmer / Analyst (Consultant), Confidential, Bethesda, MD. 8/01 - 8/02
Developed an underwriting tool Utilizing SQL and VBA for an insurance provider to establish pricing for dental insurance products.

• Designed “Black Box” modules of code that perform the actual quotation rating which I then integrated into the existing database objects (forms, reports, modules, etc.)
• Created functionality for dental procedure and fee schedule adjustments to be applied at different geographic areas and groupings allowing additional flexibility in the rate
• Created functionality for quotations to be based on any combination of population, age, weight, gender, income, occupation, geographic location, and many other demographic factors
• Contributed on the writing of the procedures manual and operating procedures for the system delivery

Programmer / Analyst (Consultant), Confidential, Ashburn, VA. 11/99 - 4/01
Provided analysis, SQL and VBA programming, implementation for the Commercial Billing Systems (CBS) at MCI, WorldCom

• Re-Engineered the Access97 Commercial Billing System for new data warehouse provider with more detailed data feeds
• Implemented and deployed the Y2K multi-product audit and High Speed Frame Relay (HSFR) audit
• Maintained existing audits as necessary to accommodate changing data sources Provided Access97 and Visual Basic programming to support a registration system developed in Access97.
• Created and maintained database forms and reports as modifications were defined
• Contributed to the VBA development of the Documentation Automation Tool as required to complete tasks

Programmer / Analyst (Consultant), Confidential, (Client: Confidential - HQ) Potomac, MD. 4/99 - 10/99
Developed a prototype property investment project-tracking tool in Access 97 VBA and ArcView 3.1 (GIS).

• Conducted interviews and reviewed existing materials to define requirements and create logical and physical data model
• Created Tables, Indexes, Relationships, Queries, Forms, Reports, and Modules in Access97
• Implemented integration of Access97 and ArcView GIS systems and trained staff on usage of system

LAN Admin. / Programmer (Consultant), Confidential, Vienna, VA. 10/98 - 4/99
Provided software development and local area network (LAN) management and monitoring services in support of a telecommunication company in VA.

• Developed an in-house production tool for recording problem tickets in Access97
• Developed an in-house production tool for recording various business metrics for management review in Access97
• Monitored and reacted to servers in the server farm to ensure billing agents have a reliable platform for billing products
• Developed file system utilities to automate telecommunications switch data collection and reporting

Programmer / Analyst / LAN / RF, Confidential, Newington, VA. 11/95 - 9/98
Redeveloped a Contracts Management System in Access '97 to run on a Novell Netware LAN.

• Added multi-user capabilities to existing single-user system
• Modified forms, reports, and code to implement software enhancements
• Assisted in installation, configuration, deployment, and support of a Lotus Domino Server / database system
• Participated in the design, development, deployment, and support of a geographically distributed Inventory Management/Stock Control System developed in Visual Basic, MS Access, and C. Assisted with management of 3 Novell networks, an IBM RS9000 mainframe, 25 portable data terminals (PDT), and 3 stand-alone sites with asynchronous communications to Novell Network Server.
• Established configuration management baseline for client machines of Arabic Windows and Arabic Office
• Co-Designed, developed, deployed, and trained users on Arabic Access2 (initial version)
• Created and deployed versions and managed release notes and bug tracking
• Performed data modeling as necessary to be able to implement new product features confidently
• Resolved radio frequency (RF) and local area network (LAN) configuration issues
• Supervised the code for the handheld units and the language conversion implementation for the RF units
• Assisted with Mainframe LAN integration to existing RS9000 and performed initial data load
• Developed a Radio Frequency (RF) communications server in Visual Basic using an Intermecs serial port radio frequency (RF) controller to implement tracking and processing of parts moving through a metal plating facility. Assisted with management of a local area network (LAN), portable data terminals (PDT), and PCs.
• Developed, tested, and debugged radio frequency (RF) controller in Visual Basic 3.0
• Resolved radio frequency, LAN, and hardware issues during deployment or staging of new clients
• Trained groups of users on software usage and hardware features and shortcuts
• Established baseline parameters for clients and servers on a Novell Netware LAN and an (RF) network
• Established Wide Area Network fail procedures and testing interfaces to ensure the maximum data availability
• Performed ongoing support of software and hardware

Access Programmer, Confidential, Rockville, MD. 1/95 - 11/95
Assisted in the development of an MS Access 2 record keeping system driven from a customization module where the farmer chooses the commodities, assets, and liabilities that apply to their specific farming operation.

• Assisted with requirements analysis to create logical and physical data model
• Created technical documentation portraying the new system and create first version in Access 2
• Created and modified forms, reports, and code as required by software change requests
• Tracked technical changes to database to facilitate formal submission of new software builds

PC LAN Technician / Programmer, Confidential, 1993 - 1995
I supported four different LANs in the Washington Metro Area as well as providing programming services for contracts

• Developed an Activity Monitoring System (AMS) for the Agency of International Development in Jerusalem, Israel in Paradox 4.0 intended to improve the quality of life for under developed regions of the country.
• Developed an electronic survey under Clipper 4.2 / 5.1 to emulate a five page survey that goes to all the chemical addiction treatment centers around the world.
• Designed and maintained a database in Paradox 3.5 for the Barbara Bush Foundation for literacy
• Maintained servers, workstations, user accounts, and security for WAN as necessary to minimize downtime

LAN Administrator / Programmer, Confidential, 1991 - 1993
Assisted in the support of a LAN and a phone system as well as providing programming for internal IT efforts.

• Developed a Contact Management Tool in Clipper 4.2 for tracking congressional contact information and legislation
• Co-Developed a budget forecasting tool providing predictive forecasting based on simple trend analysis of historical data
• Maintained servers, workstations, user accounts, and security for the LAN and the digital key telephone system
• Develop and document Directory Structure for the LAN and create appropriate technical and user documentation

LAN Administrator / Software Engineer, Confidential, 1989 - 1991
Managed the internal LAN and provided programming for various clients in the Washington Metro area.

• Co-Developed Fixed Assets Control Tracking System (FACTS) for Fairfax County in FoxPro LAN and assisted in directing the physical inventory of all equipment deemed valuable
• Maintained a generic version of Fixed Asset Control Tracking System (FACTS) in Clipper 4.2 and assist in customer specific implementation during installation
• Rewrote generic versions of stand-alone Clipper systems to allow multi-user access on a LAN
• Installed, configured, and maintained the internal LAN and it's associated user accounts and directory structure

Database Technician, Confidential, 1987 - 1989
I provided technical librarian skills for an Informix database and co-developed a deficiency tracking system.

• Performed ad-hoc searching and reporting for the database administrator for an SDIO contract
• Co-wrote a deficiency tracking system in Rbase System V to report status on activities, meetings, outstanding issues, and milestones
• Wrote a utility to send output from the deficiency tracking system to intended recipients
• Performed hardware maintenance and configuration management as necessary

Word Processor / Administrative Assistant, Confidential, Manpower, 1986 - 1987
Provide administrative support to contracts

• Performed word processing, data entry, data manipulation, graphics manipulation, desktop publishing, spreadsheet manipulation and document cataloging in various environments

Radioman, Confidential, 1982 - 1986
Configured various Naval communications systems in support of fleet activities.

• Assigned to USS Bradley FF-1041 home ported in Long Beach, CA from 1984 to 1986
• Assigned to Naval Communications Area Master Station (NavCAMS), Westpac, Guam from 1982 to 1984

Training
Some coursework for MCSE 2003/2000
Microsoft Certified Professional (MCP)
Intermec RF Site Survey Certificate (design adequate coverage for RF communications)
Erwin/BPWin (Entity Relationship / Business Process Modeling for Windows)
Applications Development from Computer Training Center (CTC - USC)
Telecommunications awarded in USN (Training for Radioman Tour)
Certified Novell Network Administrator (CNA)