Sql And Web Developer Resume
PROFESSIONAL SUMMARY:
Harriet is a Microsoft Certified Solutions Developer (MCSD) in VB 6.0 and has over 25 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, d Confidential base 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
SQL and Web Developer
Responsibilities:
- Convert sustainment application from Access to ASP.NET/SQL Server 2012 website.
- Analyze requirements from existing Access d Confidential base, reports and forms.
- Create IIS websites and SQL Server d Confidential bases.
Technical Environment: Visual Studio 2013, C3, VB.NET, SQL Server 2012, SSRS, HTML 5, Windows 7
Confidential
Web Developer
- Convert St. John Providence Health System Intranet websites to SharePoint 2010 websites.
- Analyze content of classic ASP and HTML websites to convert to SharePoint 2010 websites.
- Create SharePoint 2010 webpages, master pages, navigation, lists, views, document libraries.
Technical Environment: SharePoint 2010, SharePoint Designer 2010, HTML 5, Windows 7
Confidential
Application Developer
- Created custom web parts for SharePoint Extranet using ASP.NET, VB.NET.
- Set up SharePoint and SQL Server Reporting Servers for development environment.
- Updated Production Scheduling application using WinForms, VB.NET.
- Perpetual Inventory real - time reports using SQL Server Reporting Services (SSRS) and OpenQuery to AS400.
Technical Environment: SharePoint 2003, SQL Server, Visual Studio 2003 and 2012, Windows 7
Confidential
Application Developer
- Created financial webpages for d Confidential entry and monthly reporting using ASP.NET C#.
- Updated Customer Information D Confidential application using WinForms, VB.NET.
- Created reports using SQL Server Reporting Services (SSRS).
- SQL Server d Confidential bases stored procedures for applications and reports
Technical Environment: SQL Server 2008 R2, Visual Studio 2008, Windows 7
Confidential
Business Intelligence Developer
- Interview and interpret user requirements, code and maintain reports using SSRS solutions.
- Sharepoint 2007 collaboration, report deployment and subscriptions.
- D Confidential Warehouse Extract, Transform, Load (ETL) SSIS packages on SQL Server d Confidential bases
Technical Environment: SQL Server, Visual Studio, SharePoint 2007, Windows 7
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 Confidential t labels from mainframe screens, web services, and SQL Server.
- Crystal Reports for PeopleSoft Financial Reports.
- Unix Sun Solaris C programs Operation Room billing d Confidential 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 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 d Confidential on Web Part report.
- Debugged and corrected VB.NET file utility
Technical Environment: Visual Studio, SharePoint, Dot Net Nuke, ASP.NET, C#, VB.NET, JavaScript, HTML, ASP, SQL Server, SQL Services Reporting Services
Confidential
Senior Programmer
- Automated Microsoft Office application to import Excel worksheets into Access d Confidential base.
- Wrote VBA code for d Confidential 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 D Confidential Entry and Online Reporting using ASP.NET, C#, VB.NET, AJAX, JavaScript.
- SQL Server and d Confidential base 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
Technical Environment: ASP.NET, C#, VB.NET, Javascript, ASP, SQL Server, DotNetNuke CMS
Confidential, Auburn Hills, MI
Application Developer
- Requirements Analysis using VB skills and d Confidential base 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, Detroit, MI
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
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 d Confidential base design and d Confidential 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
Confidential
Application Developer
- 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 d Confidential to the system users
- Updated SQL Server d Confidential base tables and stored procedures
- Produced ASP.NET/ASP pages for the user to select criteria for running custom reports
- D Confidential Transformation (DTS) programs to download d Confidential from Harris Financial Systems
Technical Environment: ASP, VB.Net, JavaScript, SQL Server 2000, ASP.NET/ASP
Confidential
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
Confidential
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 d Confidential bases, migrating d Confidential and creating stored procedures
- Migrated d Confidential from an AS/400 system to a SQL Server d Confidential base
- Created thin client interface to log-in, add, edit and view d Confidential base information using VB.NET, ASP.NET, ADO.NET, Crystal Reports, SQL Server 2000, and Access 2000
- Designed and Developed SQL Server d Confidential base for Evosyst Accounting and Inventory system
- Created D Confidential Transformation (DTS) programs to migrate d Confidential from ISAM d Confidential base files
- Created Crystal Reports 11.0 for Evosyst Accounting and Inventory Delphi 8.0 system
- Trouble shot and updated Vice Capital Access d Confidential base system
- KTool upload SQL Server 2000 with D Confidential Transformation (DTS) programs
- Microsoft Office development using Excel, Access, and .NET framework
Technical Environment: SQL Server 2000, Evosyst Accounting and Inventory system, D Confidential 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
Confidential
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 d Confidential base 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 d Confidential 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 d Confidential transformation tool
- UNIX scripts for d Confidential exchange from IBM Mainframe to Unix/Sybase d Confidential base
- Documentation for user guide, functional design, system guides for Unix and Windows
- Visio 2000 d Confidential model for Sybase d Confidential base 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 d Confidential Access 2000 d Confidential base to SQL Server 2000. Redesigned d Confidential base 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
Confidential
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 Confidential ’s Central D Confidential 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 for BDO Seidmans Accounting Department. Migrated the d Confidential from Pro FX Tax Software Suite/dBaseV d Confidential base
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 D Confidential bases 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
Confidential
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
Confidential
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 d Confidential bases.
- 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
Software Release/QA Engineer
- 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 d Confidential to Delphi 2.0/Oracle 7.0 system
- Developed Visual Basic 3.0 - 4.0/Crystal Reports/Oracle 5.0 - 7.0 d Confidential base system to generate software build integration and release reports and update external testing and concern d Confidential bases
- 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
Customer Service Engineer
Responsibilities:
- Maintenance/Service of large and small A Series mainframes, I/0 devices, and communication end-devices
- Developed d Confidential base inventory system for tracking on-site parts at Unisys World D Confidential Center
Technical Environment: A Series mainframes, I/O devices
Confidential
Network Consultant
- Consulting Transition Team member at Host Computer site during cutover to a private secure BBN packing switching network
- Identified requirements, updated requirements DBaseV d Confidential base, troubleshot hardware and software configuration problems
- Established WAN/LAN help desk procedures
Technical Environment: BBN, DBaseV, WAN/LAN