PROFESSIONAL SUMMARY

Harriet is a Microsoft Certified Solutions Developer MCSD in VB 6.0 and has over 20 years of experience in the information systems field. Although her primary expertise and interest is in application development she is also skilled and experienced in requirement gathering, systems and application design, database administration and design and technical walkthroughs. She works in various capacities based upon project needs and has worked in web and client server environments. Her development experience includes ASP.NET, C , VB.Net, JavaScript, VBScript, HTML, Visual Basic, XML, Active Server Pages, and SQL Server.

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

• Interview and interpret user requirements, code and maintain reports using SSRS solutions.
• Sharepoint 2007 collaboration, report deployment and subscriptions.
• Datawarehouse Extract, Transform, Load ETL SSIS packages on SQL Server databases

Technical Environment: SQL Server 2005 - 2012, Visual Studio 2008 - 2010, Sharepoint 2007

Confidential

Programmer Analyst

• Interview and interpret client requirements, code and maintain multi-environment system solutions.
• System Integration Testing SIT and User Acceptance Testing UAT .
• Level 2 user support, off-hours on-call support, system maintenance performed off-hours and/or on weekends.
• ASP.NET/SQL Server application to support Network Security Operations remote access for IT Vendor Registry.
• HTML5, CSS, Jquery website for employee remote access to enterprise applications.
• Windows Services for HL7 message transfers with DrFirst Rcopia/E-Prescriptions.
• Windows 7 applications to print patient labels from mainframe screens, web services, and SQL Server.
• Crystal Reports for PeopleSoft Financial Reports.
• Unix Sun Solaris C programs Operation Room billing data transfers to IBM Mainframe.
• Sharepoint user for Department Applications and Programs System Support Documentation.

Technical Environment: Windows Server 2008, IIS 7.5, Visual Studio 2010, ASP.NET, C , VB.NET, JavaScript, JQuery, HTML, CSS, ASP, SQL Server 2005-2008 R2, Crystal Reports, Sharepoint 2007

Confidential

Web Developer

• Development of complex SharePoint and Dot Net Nuke web portals.
• Support client and management to resolve issues and validate programming requirements.
• Documentation of Design, Code, Testing and Maintenance SDLC processes.
• Created complex SQL procedures to integrate systems data on Web Part report.
• Debugged and corrected VB.NET file utility

Technical Environment: Visual Studio 2003- 2008, SharePoint 2003 - 2007, Dot Net Nuke, ASP.NET, C , VB.NET, JavaScript, HTML, ASP, SQL Server 2000-2008, SQL Services Reporting Services

Confidential

Senior Programmer

• Automated Microsoft Office application to import Excel worksheets into Access database.
• Wrote VBA code for data transformations and to record times of uploads of supervisor's schedules/metrics.

Confidential

Senior Programmer

• DotNetNuke Administration of Content Management System and Web Portal Security
• Web Application Data Entry and Online Reporting using ASP.NET, C , VB.NET, AJAX, JavaScript.
• SQL Server and database modeling and design, stored procedures, functions for web application business logic, functionality and online Reporting.
• Create adhoc and monthly reports with SQL reporting services.
• Modify software for LifeSettleWare, create test cases, test 3rd party applications and software, and document Agile software development.
• System builds and Version Control using Visual Source Safe and Tortoise SVN

Confidential

Application Developer

• Requirements Analysis using VB skills and database modeling and design.
• Estimate updating client/server Sales Call application from VB 5.0 to VB.NET.
• Modify software for Retail Distribution Channel Technology Services, create test cases, test new applications and software, and document proper procedures for users

Technical Environment: VB 5.0, VB.NET, Crystal Reports, DB2, Oracle10g

Confidential

Configuration Specialist

• Lead configuration Specialist for VB and SQL Server for application/reports.
• Administration of IIS on Windows 2003 platform
• Install and configure global web applications to run Crystal Reports for GM plants internationally
• Report development and customization using ASP, Crystal Reports and SQL Server 2000
• Technical Environment: ASP, Crystal Reports and SQL Server 2000
• CES Computer Engineering Services/Arrow Strategies LLC April 2006 May 2006

Confidential

Application Developer

• Worked with development team to break down benefit packaged by categories in order to detail the Benefits Configurator system on a person by person basis to allow for better cost savings and personal attention
• BCBS of Michigan Benefit Configurator system using Microsoft Visual Studio and Oracle 9i
• Updated Oracle 9i database design and data model for new Benefit Configurator system
• Produced detail design for user security/login modules Benefit Configurator system
• Produced detail design to implement Oracle Audit Trail
• Gained an understanding of HIPAA, Healthcare, Benefit Policies and Claims, etc. due to an intense work environment
• Technical Environment: VB.Net, Visio, Microsoft Visual Studio, Oracle 9i, Oracle Audit Trail, HIPPA
• Wolverine Technical Staffing February 2006 March 2006

Confidential

• Lead developer on completing an unfinished Budgeting Project for Livingston County using ASP, JavaScript, SQL Server 2000, and Microsoft Visual Studio 2003
• Replaced manual excel calculations through the migration to the new Budgeting System Project
• Configured the Budgeting System to produce over 280 reports on financial data to the system users
• Updated SQL Server database tables and stored procedures
• Produced ASP.NET/ASP pages for the user to select criteria for running custom reports
• Data Transformation DTS programs to download data from Harris Financial Systems

Technical Environment: ASP, VB.Net, JavaScript, SQL Server 2000, ASP.NET/ASP

• CES Computer Engineering Services/Arrow Strategies LLC February 2005 December 2005 Assigned to ThyssenKrupp Application Developer
• Developed web portal applications accessed via Plumtree portal using Microsoft VB, ASP.NET, ADO.NET, C , SQL Server 2000 and SQL Reporting Services.
• Utilized rapid application development RAD methodology to meet stakeholder needs
• Gathered user requirements and created applications to be taken back for user acceptance testing
• BEA/Plumtree Web Portal administrate users, schedule jobs, and crawlers to update web pages and documents
• Used PCAnywhere to troubleshot and support user help tickets
• Maintained internet, intranet, and extranet websites for ThyssenKrupp North America and ThyssenKruppBudd
• Updated programs for adding/editing new users and assets from Active Directory to BEA/Plumtree Web Portal
• Updated Electronic Change Notification System using VB 6.0, Oracle 8i and Crystal Reports.

Technical Environment: BEA/Plumtree, XML, VB.Net, Web Portal, ASP.NET, ADO.NET, C , SQL Server 2000, SQL Reporting, VB 6.0, Oracle 8i, Crystal Reports, PCAnywhere

• Consulting for various small business November 2003 April 2006 Application Developer
• Lead programmer on KTool Inventory and Sales Order tablet application using VB 6.0
• Worked as the functional DBA administering the server, working on configuration, upgrades, designing new databases, migrating data and creating stored procedures
• Migrated data from an AS/400 system to a SQL Server database
• Created thin client interface to log-in, add, edit and view database information using VB.NET, ASP.NET, ADO.NET, Crystal Reports, SQL Server 2000, and Access 2000
• Designed and Developed SQL Server database for Evosyst Accounting and Inventory system
• Created Data Transformation DTS programs to migrate data from ISAM database files
• Created Crystal Reports 11.0 for Evosyst Accounting and Inventory Delphi 8.0 system
• Trouble shot and updated Vice Capital Access database system
• KTool upload SQL Server 2000 with Data Transformation DTS programs
• Microsoft Office development using Excel, Access, and .NET framework

Technical Environment: SQL Server 2000, Evosyst Accounting and Inventory system, Data Transformation DTS , ISAM, Crystal Reports 11.0, Delphi 8.0, Access 2002/2000, VB 6.0, Microsoft Office, .NET Framework, VB.NET, ASP.NET, ADO.NET

• Analyst International June 2002 October 2003 Application Developer
• Developed Heat Treat Scheduling system for MNP Enterprises Shop Floor Automation which scheduled various metals to be heat treated on various critical timelines
• Lead developer using Visual Basic 6.0, VB.NET, ADO.NET, Active Reports and SQL Server 2000 to create a user interface to external database systems
• Enhanced ASP/Access 2000 Distribution documentation system and updated to ASP.NET using VB.NET
• Developed Documentation system for MIS, Frame and Stamping Division, Budd Company
• Development using Windows 2000/Oracle 8i from requirements using Visual Basic 6.0 RDO/ODBC, Crystal Reports 7.0 and PL/SQL
• Estimated work effort to begin conversion of systems using VB.NET, ASP.NET, ADO.NET

Technical Environment: VB 6.0, VB.NET, ADO.NET, Visio, Active Reports, SQL Server 2000, ASP/Access 2000, RDO/ODBC, Crystal Reports 7.0, PL/SQL

Confidential

System Developer

• Systems Assessment for transition to outsourcing support of Visual Basic 6.0 programs for Sales and Marketing Planning, DaimlerChrysler
• Updated Visual Basic 5.0 to 6.0 for Volumes Planning EVP system Windows 2000 rollout
• Utilized Visual Basic program to transfer Sybase data to Lotus Notes 5.0 forms and views
• Analyzed work effort for integrating multiple applications and ongoing support
• Process improvement solutions for Product Strategy and Sales and Marketing Planning
• Designed and wrote Visual Basic 6.0/Access 97 data transformation tool
• UNIX scripts for data exchange from IBM Mainframe to Unix/Sybase database
• Documentation for user guide, functional design, system guides for Unix and Windows
• Visio 2000 data model for Sybase database design and administration
• Converted Visual C program from Windows 95 to Windows 2000 system security
• Assessment team member of the Blue Cross Northeast Pennsylvania ECustomer project
• Gap Analysis of Web Site Functionality. Transition of Visual Basic 6.0/HTML/ASP/IIS to use the .NET framework with VB.NET and ASP.NET. Analyzed and migrated data Access 2000 database to SQL Server 2000. Redesigned database design for new web interface. Development team WinNT4/IIS4/Openshare Intranet site for Saint Josephs Medical Center
• Developed Web Interface using HTML/ASP/VB Script/ADO.
• Used PCAnywhere to support user applicatios
• Project Manager for Superior Consultant's Windows 2000 rollout
• Identify Windows 2000 Professional configuration for laptop and desktop users
• Published project documentation on IIS4 Server using MS Office 2000 Front Page and Word

Technical Environment: Visual Basic 5.0/6.0, Windows 2000, Access 97, Sybase, Lotus Notes 5.0, UNIX scripts, IBM Mainframe, UNIX/Sybase, Visio 2000, Visual C , Windows 95, Visual Basic 6.0/HTML/ASP/IIS, .NET, VB.NET, ASP.NET, Access 2000, SQL Server 2000, Windows NT/IIS4/Openshare, SQL Server 7.0, HTML/ASP/VB Script/ADO, Windows 2000 Professional, IIS4 Server, Microsoft FrontPage 2000, Microsoft Word 2000, PCAnywhere

• BDO Seidman, LLP May 1999 December 1999 Senior Consultant
• Developed Visual Basic 6.0/ADO/Access 97/Crystal Reports Driver Information Survey Application for Visteon. This application allowed the user to input questions to create a survey, conduct the survey, and consolidate the survey answers for analysis reporting
• Developed Access 95 system for Software Development Audit Team for tracking Configuration Maturity Model CMM
• Provided Quality Assurance and Functional Testing as part of a twenty-five member team subcontracted to Organic, Inc. Sub-Team Leader responsible for quality assurance of five members web content and functional testing on two E-Commerce web sites, Blockbuster.com and PlantRx.com
• Established acceptance-testing procedures for NetDynamics Web Development team at BDO Seidman's Central Data Center. Wrote test scripts and completed acceptance testing of Elite Software Timekeeper upgrades
• Designed and implemented Access 97 applications for supporting Tax Form Tracking and Continuous Profession Education for BDO Seidmans Accounting Department. Migrated the data from Pro FX Tax Software Suite/dBaseV database

Technical Environment: Visual Basic 6.0/ADO/Access 97/Crystal Reports, Access 95, NetDynamics Web Development, Pro FX Tax Software Suite/dBase V

Confidential

Systems Analyst

• Oracle 2000 Developer customized form and reports for backend Oracle Financial Purchase Orders 10.7
• Administration of Oracle 7.3.4 Databases on a Sun ES 4000 System
• Technical Environment: Oracle 2000 Developer, Oracle Financial Purchase Orders 10.7, Oracle 7.3.4, Sun ES 4000 System
• CDI Information Services October 1998 December 1998

Programmer Analyst

• Administration and Development of Access 97/Sybase application for reporting 1st and 2nd Tier Supplier minority business for Strategic Systems Development, Procurement Supply, DaimlerChrysler
• Technical Environment: Access 97/Sybase
• Penske Auto Centers, Inc. April 1997 October 1998

Information Systems Developer

• Visual Basic 5.0/SQL Server 6.5/Crystal Reports system for processing tire inventories at nationwide stores to determine weekly Tire Purchase Orders
• Administration for all Oracle/Unix, SQL Server/NT and MS Access databases.
• Ad hoc SQL, PL/SQL and custom Developer 2000 Forms and Reports for interfacing Oracle Financial General Ledger and Accounts Payable tables
• IBM Mainframe JCL/Focus/DB2 batch jobs to retrieve Kmart sales for financial reports, calculating sales bonus and auto-center timecard reports in MS Access 97 applications.
• Programmed the St. Paul Software EDI Translator and Application Mapping for receiving Invoices
• Established and implemented business agreements for new trading partners
• PL/SQL for loading the invoices into the Oracle Accounts Payables tables
• Visual Basic 5.0 application to report daily EDI loads invoice counts and dollar amounts

Technical Environment: Visual Basic 5.0/SQL Server 6.5/Crystal Reports, Oracle/UNIX, SQL Server/NT, Microsoft Access, SQL, PL/SQL, Developer 2000 Forms Reports, Oracle Financial General Ledger Accounts Payable, IBM Mainframe, JCL/Focus/DB2, Microsoft Access 97, St. Paul EDI Translator Application Mapping

Confidential

• Established procedures for building the system software for the Service Bay Diagnostic System SBDS
• PVCS/Version Control Monitor for 100 C programmers
• Created scripts to automate source code retrieval for building C libraries, DLLs, executables and Btrieve
• SBDS Calibrations Reengineering Team, design, develop, migrate data to Delphi 2.0/Oracle 7.0 system
• Developed Visual Basic 3.0 4.0/Crystal Reports/Oracle 5.0 7.0 database system to generate software build integration and release reports and update external testing and concern databases
• Administered, designed and developed Lotus Notes 3.0/4.0 application to automate check-out/in process

Technical Environment: C, DLLs, Btrieve, Delphi 2.0/Oracle 7.0, Visual Basic 3.0-4.0/Crystal Reports/Oracle 5.0-7.0, Lotus Notes 4.0

Confidential

Responsibilities Included:

• Maintenance/Service of large and small A Series mainframes, I/0 devices, and communication end-devices
• Developed database inventory system for tracking on-site parts at Unisys World Data Center

Technical Environment: A Series mainframes, I/O devices

Subcontract to Computer Sciences Corporation

Confidential

• Consulting Transition Team member at Host Computer site during cutover to a private secure BBN packing switching network
• Identified requirements, updated requirements DBaseV database, troubleshot hardware and software configuration problems
• Established WAN/LAN help desk procedures