Senior Systems Analyst Resume Profile
SKILLS SUMMARY
Over ten years experience developing enterprise applications. Senior level expertise developing data - driven Web and Windows applications using C VB.NET Visual Basic ASP.NET MVC Angular EF ADO Internet Information Server IIS Active Server Pages ASP ActiveX Data Objects ADO ActiveReports Crystal Reports SQL Server Access VBScript JavaScript and DHTML. I have a thorough understanding of the challenges facing enterprise application development including architecture management scalability deployment maintenance and cross-platform compatibility - having full life-cycle experience from requirements gathering through prototyping testing deployment and implementation. TECHNICAL SUMMARY Technical and Architectural Leadership - Project Management Over six years technical and architectural leadership experience in providing architectural design task assignments managing multi-developer projects in separate locations interviewing new recruits source code/version control testing and application deployment. Experienced in providing design estimates work breakdown structures task sequencing scheduling tracking reporting progress interfacing with business owners executive management and technical support. PMI trained in Project Management and effectively used MS Project as a management tool. All responsible efforts were delivered on schedule with positive results while making significant contributions on coding tasks by developing the supporting foundations of several enterprise applications. Application architecture committee member responsible for developing the enterprise application architecture software engineering practices and application development standards for a fortune 500 corporation reporting directly to an IT Vice President. C - Visual Basic Over three years experience in C since .NET Beta1. Over eight years VB experience developing multi-tier data-driven applications COM objects and Controls since VB 3.0. Microsoft SQL Server - Access Expert skills in designing and implementing mission-critical database applications for both corporate enterprise and internet e-commerce solutions using SQL Server and Access. Experience includes relational data-modeling SQL knowledge including stored procedures triggers conversion referential integrity normalization and data-tier component development. ASP - ADO - IIS Over six years experience creating dynamic data-driven web applications with ASP.NET ASP and ADO.Net using C Visual Basic Visual Interdev FrontPage VBScript JavaScript Remote Data Services RDS Remote Scripting DHTML .NET Web Services TCP/HTTP Remoting Automated Internet Deployment and XML. Experience developing corporate Intranet applications and numerous secure Internet e-commerce solutions. See my side business for commercial examples. .NET Components - ActiveX/COM - MTS Experienced encapsulating business data and presentation logic in reusable server-side .NET/COM/DCOM objects. Recent experience in .NET Web Services and TCP/HTTP Remoting. Expert skill level designing and coding reusable stateless components for use in multi-tier applications based on Microsoft DNA architecture and design principles. Experience includes full life-cycle development of both thin-client web-based and windows client server applications implemented in MTS. Reporting Extensive skills in designing and developing component based web and windows reporting systems. Experience in the design and use of ActiveReports and ActiveReports.NET since version 1.0. Experience designing Crystal reports since version 3.0. Experience in MS Access reporting since version
WORK EXPERIENCE
Confidential
Senior Systems Analyst - Systems Consultant - Primary Developer and Lead Architect for several individual disability rating and proposal systems including the corporation s primary sales illustration software distributed to entire sales force nationwide and home office call center. Responsible for full life-cycle development of systems from initial design to final implementation - ranging from standalone desktop to n-tier distributed and web based .NET call center solutions. Projects implemented using C ASP.NET Visual Basic SQL Server MS Access ASP ADO XML ActiveReports and Crystal Reports using component-based design and technologies. Confidential
Contributed significantly on coding tasks by developing the supporting foundations of enterprise applications o Responsible for technical architecture modeling application flow/use case in Visio and presenting to team members o Ensured project technical communication with team business stakeholders and executive management o Ensured methodology was followed on responsible projects including technology reviews design reviews and testing o Ensured estimates and resource requirements were properly communicated to senior management o Provided status to executive management and participated as a part of the IT management team o Mentored team members on utilized technologies and ensured technical issue resolution during initiatives o Coordinated overall task plan with technical team members and made deliverable assignments o Evaluated technical resource contributions and communicated them with executive management Integrated Rating and Proposal - Web Based .NET Individual Disability Insurance Rating and Proposals C .NET - Webforms - User Controls - Winform Controls - SQL Server 2000 via ADO.NET Internet Explorer - CSS Style Sheets - JavaScript - VBScript - DHTML 250 Users in Call Center Environment Intranet - 1500 Users in Field Offices Nationwide via WAN Intranet ActiveReports.NET streamed PDF output to browser for Print/Preview/VisiFax/Email C Components for encapsulation of Data Rules Enumerations Utility Function classes VB.NET Components for Indemnity and Premium calculation engines Import/Export from Excel via ADO.Net and Native System.Data.SQLClient Mainframe integration via COMTI returning UDT to VB COM Component ADO Recordset Scalable - load-balanced and clustered environment with over 10 000 users Protector - Primary Corporate Individual Disability Insurance Rating and Proposals VB4 - VB6 100 forms - 20 classes - 26 modules - Client Server - Call Center Environment - 3000 records/day 250 Internal Users SQL Server 7.0 - 7500 External Distributed Sales Force Users File Server MS-Access 7 different versions of one source code managed with INI files Registry settings and different installation scripts SQL Server or File Server Access Backend Database via ADO Crystal Reports 125 rpt files via OCX - Automation Engine - Crystal API - Multithreaded Background Processing Print - Preview - VisiFax - Email - Print to Image Custom Search Engine for quick Quote Record Retrieval Database Utilities for Copy - New - Delete - Change - Repair - Compact Access Databases Import/Export from Excel via ADO Recordset and OLEDB VB6 COM Components for Data Rules Calculations Reporting Enumerations Raised Event Monitoring DCOM calls to shared component for listing PDF files included in Print Job via Adobe Automation PowerPoint Presentations launched via automation of PowerPoint Viewer Base 256 Binary Conversion of database tables to decrease rate table data file size and increase speed Relational database look-ups for drop-down and business rule validations Third party controls Sheridan Crescent OLE Tools for form input controls and buttons Screen and Control scaling for versatility on different screen resolutions Built Excel Spreadsheet comparison tool for regression testing of exported insurance premiums Replaced Visual C application with less than half of the original development time Deployed via SMS Installer InstallShield Package Deployment wizard Source Managed with Visual SourceSafe DICalcNet - .NET C Web Service for Exposing Disability Insurance Premium Rating Engine C Web Service - Wrapper for Protector system COM component rating engine C Winform Control Client - Embedded in HTML Object tag - Deployed via Internet Explorer Component wrapper accessed via Web service - TCP or HTTP Remoting ProtectorReports - Web Based Protector - ILTC - PolicyChange Quote Activity and Tracking Exposed Call Center SQL Server Quote Database from Protector System to Executives and Field Offices Nationwide ASP 86 pages - VBScript - JavaScript - DHTML - XML - XSLT Internet Explorer - CSS Style Sheets - Include file Headers and Footers SQL Server 7.0 Backend Database via ADO and Stored Procedures COM Components of Protector System reused on IIS web server implemented in MTS Crystal Reports 134 rpt files and ActiveReports 22 rpt files streamed to browser in viewers installed by .cab files Email Request for Proposal via CDONTS and HTML form post PowerPoint Presentations launched in Browser Policy Change Proposals - Individual Disability Insurance Policy Change Proposal Output VB6 Windows Client 13 forms - 7 classes - 6 modules - IBM WebSphere 5.3 MQSeries Mainframe Integration via API Mainframe DB2 Data to MQSeries Message converted to XML then to ADO Recordset for Output generation Call Center Distributed Environment 250 Users - ActiveReports 9 rpt files Print - Preview - VisiFax - Email Launched by Mainframe process on user s desktop via MQSeries message polled by IP Address COM Components for Data Rules Reporting Enumerations MQSeries API Wrapper Raised Event Monitoring DCOM calls to shared component for listing PDF files included in Print Job via Adobe Automation Contact Management Reporting - Web Based Reporting for Executive Tracking of Field Sales Activity ASP Client in Internet Explorer for Report Option Selections - CSS Style Sheets - Intranet 25 Users ACT DB converted to MS Access database with Reports bound to Queries VB6 COM Component to automate MS Access and execute Access reports Access Report framed in browser by Access Snapshot Viewer Control Web Based Task Management - Internal System for Tracking Programmer Task Deliverables ASP - SQL Server 7.0 - Internet Explorer - CSS Style Sheets - Include file Headers and Footers - Intranet 25 Users Task Entry - Assignment - Status - Estimates - Search - Role Based Permissions and Authentication ILTC Quote - Individual Long Term Care Insurance Rating and Proposals VB4 - VB6 - SQL Server - ActiveReports - Call Center Environment - 250 Users - 2000 records/day Converted from Flat File single user system to Client Server SQL Server/Access via ADO Print - Preview - VisiFax - Email - Print to Image - Import/Export from Excel via ADO and OLEDB Monogram - Individual Disability Insurance Rating and Proposals for MFinancial VB4 - VB6 - Distributed Desktop Access Database via DAO - 50 Users Crystal Reports via OCX - Print - Preview - Import/Export from Excel via DAO and Installable ISAM driver MaxxCode development my side business - Various Commercial Applications ASP Link Index - ASP Appointments and Reservations - ASP.NET Universal Table Editor Source Code E-commerce - shopping carts data driven applications - ASP/ADO/IIS - please see links for ASP content MS Access Book Store management system MS Access Training Enrollment application ASP/VB application for equipment monitoring using A/D converter data acquisition ConfidentialConfidential
Database Administrator - Programmer Administrator Programmer and I/C Engineer on the design and implementation of an Integrated Nuclear Plant Monitoring System costing 16 000 000. Responsible for database administration of engineering related fields conversion of existing plant databases and the development of several VB/Access applications. Converted re-populated and merged two existing plant computer system databases into an integrated version for use in the new system. Also responsible for the development of VB/Access applications used for tracking of drawings bill of material and plant cable tracking. Coordinated the services of subcontractors for additional software development and hardware procurement. Provided testing and troubleshooting related to data acquisition hardware and its integration with core software. Verified accurate scaling parameters in plant database and made necessary software changes based on process measurement requirements signal logic and instrument characteristics. Mapped plant database records with data acquisition hardware points and provided field support during installation. Acquired practical experience with Ethernet networks Fiber Optic communications A/D converter utilization and integration of plant instrumentation with a central database. Confidential
Confidential
Maintenance Application Access 2.0-95 - VBA application for controlled and validated data-entry from system engineers - 25 Users Exported data modified for core software revisions from VB to a DEC Alpha proprietary S.A.I.C. database Form based search engine to perform user defined searches and filters in an intuitive interface Used to compare two database versions to identify which records and fields were different Complex queries for global updates to populate fields based on logical criteria performed on other fields Creation of relationships inner and outer joins - referential integrity - normalization Screen and Control scaling for versatility on different screen resolutions User and Group level security and permissions - Mail Merge output utilizing OLE between MS Access and MS Word MS Access reports and subreports for output purposes for validation of plant parameters by engineers