Solution Architect Resume
New York, NY
SUMMARY:
- Windows Application Specialist - with more than 25 years of experience in software architecture and database development/design using C# \ VB.NET, VB6 / (ASP.NET & ADO.NET) for Oracle 9/10/11/12 and SQL Server Implemented for financial, government, healthcare and manufacturing, software development projects.
- Vast experience in the IT industry in Project/Team management, Research, Analysis, design and development of web and PC based Applications using C#.NET using all versions to 4.6.1. Broad experience in classic VB(1 thru 6), VB.NET & Win-forms, Assemblies, API, Custom Controls. Strong ASP.NET, AJAX, JavaScript, XML, and classic ASP. Experience using WCF & .NET. RESTful web services.
- Advanced workflow and document management systems using SharePoint and Xerox DocuShare programming API (Xerox HTTPXML API) for DocuShare. CPX Content Rules, Workflows and front end client integration. LENEL Security & Badging Systems, expertise using OnGuard, Data Exchange and Data Conduit (WMI) with SQL Server and Oracle backend.
- Development experience with SSDT (Sql Server Data Tools in Visual Studio 2013) MS Build & Deploy via DACPAC / BACPAC SqlPackage.exe.
- Web portal functional design using JavaScript, HTML(4 &5) and CSS(2 & 3) & ASP.NET.
- Highly proficient in database design, development and programming using Oracle (TOAD) & PL/SQL (cursors, packages, sequences, triggers, functions and procedures), view creation and advanced SQL queries & parsing, DML, DDL and Oracle Text indexing and operators for CONTAINS (SoundX, Fuzzy, Synonym). Custom thesaurus & dictionary.
- Highly proficient in database design, development and programming using SQL SERVER Management Studio, SSMS - 2016, 2014, 2012, 2008, 2005, 2000, TSQL cursors, packages, sequences, triggers, functions and procedures (TSQL), view creation and advanced SQL queries & parsing, DML, DDL and Full Text indexing and searching & search calibration
- Deep knowledge of web programming techniques, web site development practices, web services and web architecture.
- Deep knowledge of software & UI programming, win-forms & control development and assembly architecture. Experience building custom frameworks and API’s.
- High standards in code design and user interface design delivering intuitive access to complex, business driven data models
- Strong understanding and implementation of architectural and object oriented design patterns and principles.
- NET framework and development of Object Oriented Applications using .NET Technologies. IIS 6 & 7, web server security concepts, and IIS configuration techniques.
- Third party terminal emulation and/or migration/support for mainframe functionality. Screen scraping & Macro programming and scripting using Windows API
- .NET solutions for KEPWARE & WONDERWARE PLC real-time control of robotic devices.
- Strong ETL (Extract, Transform, Load) techniques,
TECHNICAL SKILLS:
Operating Systems: NT 4.0, Windows 2003 &, XP, Vista, Windows 7
Languages: ASP.NET, Classic ASP, VBScript - DOS Batch - HTTPXML -
Technology: .NET (All versions), Windows Applications, Console Applications, Windows Services, Web Services (WCF) & Web Applications,C#, VB/VB.NET, T-SQL & PL/SQL /Java-script, HTML/ CSS, Database modeling & Scripting (Stored Procedures, Triggers and SQL Server Jobs)HTML, XML, ODBC, Client Server / HTTP Web - Active Directory LDAP, Intranet development.
. NET Technology:Visual Studio /.NET (1.1, 2.0, 3.5, 4.0, 4.5), Team Explorer, Source Safe & SVN, C#\VB .NET, ASP.NET, C#, User & Web Server, Controls & Windows console, Windows Services, (ASMX & WCF), ADO.NET
Database: Oracle TOAD 11/10g, SQL Server 2014 SSMS, MS Access, Sybase,Informix, DB2, Stored Procedures, Triggers, Sequences, Functions.,Oracle Text, SQL Server Full Text, SSDT (Sql Server Data Tools in Visual Studio) MSBuild & Deploy via DACPAC / BACPAC SqlPackage.exe
Other Tools: Tortoise SVN - Beyond Compare - Agent Ransack - SQL Tool Belt - Crystal Report Writer 6.0/7.0/8.5, Sandcastle,Team Foundation Server TFS version control
IDE s: Visual Studio, CURL test harnesses, PUTTY, GIT source control.
Visual Studio (all versions) - Oracle (TOAD), SQL SERVER (SSMS), Legacy Visual Interdev (All Versions), Homesite 5.0, Legacy Visual Basic 1 thru 6
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Solution Architect
Responsibilities:
- Remote Resource - Created and designed administrative tools for the university hospital security team using Visual Studio 2016 C#, WPF Winforms and WebForms. Utilized OOP techniques for reusable components.
- Created administrator application
- Created security access reports from Honeywell bio-metric scanning devices and card readers using C#,as an EXCEL add-in.
- Performed Data cleansing and integration with Oracle Identity Management & PeopleSoft HR Systems. Active Directory and badging using Diamond, Honeywell and Lenel enterprise badging systems, including manipulation and transformation of employee photos. Analysis & integration of HR Policies as applied to badging and security.
- Involved in custom search engine development using Oracle PL/SQL, Oracle Text and fuzzy matching names between security systems and applying real-time PeopleSoft integration.
- Used Agile environment, Jira, Git, Jenkins. TDD & continuous integration.
Confidential, Baltimore, MD
Lead Software Architect/Windows Application Developer
Responsibilities:
- Created RESTful web service in C#, WCF (HTTP - GET, POST with C.R.U.D directly to DocuShare)
- Performed document management using Xerox DocuShare repository service to manage all DocuShare concerns using C# and Xerox HttpXML API, to list, display and deliver documents and advanced Metadata to an enterprise CRM.
- Defined as design service methods, test scripting using cURL, JSON.
- Created Document Compliance Workflow using DocuShare API and C# Webforms ASP.NET.
- Defined content rules and routing slips dat adhere to requirements for documents to flow through compliance.
- Supported notifications and browsing outside of DocuShare portal using ASP.NET.
- Adobe PDF conversion and PNG thumbnail creation of MS Office documents and PP slides.
- Performed Captive editing using Microsoft Office Add-ins for Word, Excel, PowerPoint & Outlook which prevent manipulating documents dat are finalized in DocuShare (firm wide).
Confidential - New York, NY
Software Architect/Lead Windows Application Developer
Responsibilities:
- OFAC Sanctions & Anti-Money Laundering Software Architect - As a consultant for PFG, worked onsite at Federal Reserve Bank of NY, to search SWIFT messages by Year, to detect Suspicious Activity Reports to be investigated.
- Created Windows Service in C# for downloading and parsing new OFAC XML Sanctions XML files into SQL Server 14 database with ADO.NET.
- Integrated SDN data and updated Sanctions Lists from OFAC.
- Created .NET C# code for software searches dat detects bank activity in SWIFT messages, used “Point in Time” analysis with OFAC Historical data and Business Group Exclusion Lists.
- Using Visual Studio 2012 & 2013, for creating C# Win-forms, WPF Controls & Assemblies
- Involved in Object oriented architecture
- Used Development principles & patterns. - Open/Close & Dependency Inversion
- Used Waterfall & Agile SDLC methodologies.
- Used Team Foundation Server (2012)
- Used SQL Server 2014, 2012, 2008
- Used Advanced T-SQL Development, Stored Procedures, SQL Jobs
- Developed and enhanced T-SQL Framework using SSDT & SSMS
- Performed Development of Search Engine Calibration Rules from Business Group
- Used SQL Server Full Text Searching
- Used Custom Search Engine Algorithms (TSQL) (Brute force, Hard matching & Fuzzy)
- Developed C# - Jaro Winkler, Levenshtein Fuzzy Searching
- Used Subversion & TFS Source Control
Confidential, Newark, NJ
Lead Web/ Windows Application Developer
Responsibilities:
- Project was to lead the architecture and development of the corporate intranet application.
- The intranet emulated an HR system, complete with photographs (LENEL SECURITY BADGE SYSTEM), position and employment data, organizational data, contact information from external sources, supporting finance, corporate and executive initiatives.
- Responsible for design and implementation of Intranet Application “@Transit“.
- Designed and created Intranet and Application Programming Framework scalable to web-forms, win-forms and web service implementation using C# and VB.NET.
- Specification and design of user and server control library for re-use across development efforts, including Ajax Control Toolkit 4.0, using C#.NET.
- Supported for client-side Java script AJAX, XML, HTTP (Request & Response) (Raw Ajax)
- Managed 5 developers and trained/mentored/hired employee programmers in the use and implementation of the custom application framework dat me wrote.
- Coded enhancements designed to improve functionality.
- Migrated and converted (refactored) C# third party provided open source code to VB.NET for engineering team.
- Provided Web Service transports for new and existing libraries in Service Oriented Architecture via .NET web services for human resource metadata.
- Designed Hosted Web Services with multiple applications in SOA/Service Bus.
- Specified Service Contracts for efforts prototyping WCF Web Services both XML and Binary (TCPIP) end point bindings.
- Created wrapper classes for SOAP via .NET.
- Designed and created a programmers application framework focused on building and developed a myriad of intranet forms in C#, ASP.NET to replace paper-based systems.
- Collaborated with business groups and former CMS users to gather specific requirements to support all functionality and enhancements needed.
- Designed and built usable application framework for developers to enforce coding standards, simplified data access with Oracle, and provided abstract classes for managing database results for reusable user/server controls on forms.
- Developed extranet components to provide capability for users to browse the intranet from home using multiple device types.
- Maintain or enhance Classic ASP Applications & SSRS Reporting, as needed and on demand while gathering requirements for refactoring for ASP.NET upgrade.
- Conversion of Classic ASP legacy intranet pages to .NET using custom framework.
- Responsible for Browser compatibility using JavaScript, HTML 4/5 and CSS2/3 for client effects and UI design.
Environment: .NET, Visual Studio 2010+, C#, VB.NET, Visual Basic 6, VBScript, VBA, ASP.NET, C#, Oracle (TOAD) 10g/11g, HTML4/5, CSS2, CSS3, JavaScript, WCF, SOAP, REST & SQL Management Studio, Classic ASP, Bootstrap CSS/JS
Confidential, Wilmington, DE
Lead Software Developer/ Windows Applications
Responsibilities:
- Created reusable and extendable solutions for business units and credit card division of the bank in .NET Webforms C#.NET.
- Support Programs written in VBScript, Classic ASP.
- Used MVC3 framework for offshore application development in C# ASP.NET.
- Managed daily scrum meeting and performed code reviews on individual sprints.
- Performed segmented tests and implementations.
- Tested domain and function / method specific urls for release to QA.
- Enhanced and created new intranet functions and forms using ASP.NET (VB), HTML4, CSS2.
- Created web services and DLLs for Object Oriented and portable n-tier architecture.
- Mentored and trained full time development team.
- Collaborated with Business Analysts, Senior VPs and Business Unit Admins for gathering requirements and defining workflow to emulate intelligent web solutions.
- Sprints with Agile Scrum methodology
- Help Desk application support for ASP.NET and Classic ASP Legacy applications
Environment: VB.NET 3.5 ASP.NET, C#, ASP.NET, Classic ASP, Oracle (Toad) 10g - Stored Procedures, Triggers, Sequences, Packages, XML, Microsoft Office (Word & Excel), Web Services & Web Controls, Object Oriented Architecture, Bootstrap
Confidential, Georgetown, SC
Lead Windows Application Developer
Responsibilities:
- Responsible for integration of inventory system to support new steel product line for large steel mill.
- Performed industrial machine programming and console software development
- Performed front and back end development using VB.NET 2.0 and Oracle (Toad) 10g.
- Developed stored procedures, triggers, sequences, and packages.
- Employed Office XML and Crystal Reports for documentation of all development activity.
- Developed applications for sales, accounting, production of material, inventory database design, documentation, and technical writing.
- Used full project life cycle for all phases including business and system analysis.
- Performed Oracle and SQL Server database development and SAP integration.
Environment: VB.NET 2.0, Oracle 10g, Crystal Reports, Visual Basic 6 .NET 2.0, XNA and Visual Studio.
Confidential, North Wilkesboro, NC
Windows Application/ Web Developer
Responsibilities:
- Developed web based public application allowing premier customers of the Crown Heritage Stair Parts realm of ECMD to load and view 4000+ categorized stair parts, in order to set profit margin mark-ups from editable base prices, to produce, print and publish real-time price books for wholesale customers.
- Developed website in ASP.NET, VB.NET and JavaScript, utilizing MS-Word-XML and Excel-XML to produce printable reports and end user price books.
- Performed Business analysis from the company and user perspectives.
- Responsible for portable database delivery and design using MS Access database for front-end and Oracle database for back end.
- Created web services for distribution of serialized MS Word and MS Excel XML documents for consumption in intranet forms.
- Performed GUI interface and form design using frames, ASP, and JavaScript.
- Responsible for creating custom classes representing updateable business objects for all tiers.
- Simplified and tuned stored procedures
- Conducted Integrated Testing, Functional Testing and User Acceptance
- Hosted weekly presentation meetings to users, owners, buyers and technical personnel.
- Upgraded classic ASP Intranet portal to use C# ASP.NET 2.0, HTML, JavaScript & CSS with dynamic menus to existing sites, with the ability to expand application links for distribution on the private corporate intranet, nationwide.
- Analyzed Intranet based applications available on the intranet.
- Reorganized application security and privileges.
- Reinvented graphical user interface of intranet portal.
- Created dynamic representation of application links for reduction or expansion.
- Segmented rollout of intranet features without disruption of production business flow.
- Responsible for connectivity to SQL Server, Oracle databases and legacy systems.
- Integrated and data parsed from JD Edwards (AS400) accounting/inventory backend.
- Maintenance and modification of ASP pages during development to .NET
- Creation of Days of Supply Reporting Tool.
- Created multiple Excel spreadsheet reports fed from Oracle and SQL Server databases.
- Used Excel XML generation from data access.
- Utilized existing Crystal Reports for non-spreadsheet views of data in an intranet based web environment.
- Modified and created stored procedures for extensibility outside compiled resources.
Environment: ASP.NET, C#, VB.NET, ADO.NET, Classic ASP, JavaScript, MSOFFICE-XML, Oracle, VSS, SQL Server, HTML, JavaScript & CSS
Confidential . Knoxville, TN
Senior .NET/ Windows Application Developer
Responsibilities:
- Developed multiple intranet applications to communicate with external resources and public websites, inform and enable key personnel to utilize a single role based page for work-related and position specific tasks.
- Used Crystal Reports for usage statistics, time sheets, and printed credit applications and credit reports
- Created SQL Server database design for business object data read from or entered into web forms.
- Created Link to Reynolds & Reynolds accounting software via Oracle for inventory and final sales data and statistics.
- Managed meetings and analysis to acquire realistic usage of daily tasks and usability from many departments.
Environment: Classic ASP, ASP.NET, C#.NET, ADO.NET, Classic ASP, JavaScript, HTML, CSS, SQL Server 2000, Oracle 9, Crystal Repots.
Confidential, Marlboro, NJ
Lead Windows Application/ Web Developer
Responsibilities:
- Responsible for development of E-commerce web application commercial website.
- Designed, architected and developed a large suite of e-commerce and commercial websites for retail clients in central New Jersey.
- Integrated common components written in JavaScript, HTML, CSS and ASP.NET to support e-commerce solutions, product listing, inventory previews and other specific multi-media capabilities, such as audio/video streaming with Direct-X v9.
- Developed modules for new connectivity, new site, shopping cart, data driven forms and portals for “My Account, video commercial streaming, web statistic reports, and multiple user login.
Environment: Classic ASP - ASP.NET, VB.NET, C#.NET, ADO.NET, Java Script, HTML, CSS, DirectX, SQL Server 2000, MS Access, Crystal Reports, IIS
