Windows Development/ Oracle Development/ Solution Architect Resume
New York, NY
PROFESSIONAL SUMMARY:
- Development 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 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 Confidential 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
Windows Development/ Oracle Development/ Solution Architect
Responsibilities:
- Remote Resource - Creating and designing administrative tools for the university hospital security team. 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.
- Custom search engine development using Oracle PL/SQL, Oracle Text and fuzzy matching names between security systems and applying real-time PeopleSoft integration.
Confidential - Baltimore, MD
Lead Software Architect/Developer
Responsibilities:
- Document management WCF web services using Xerox DocuShare repository. Service to manage all DocuShare concerns using C#, and to deliver documents and advanced Metadata to an enterprise CRM. Define as design service methods, test scripting using cURL, JSON.
- Compliance Workflow using DocuShare API and C#. Defining content rules and routing slips that adhere to requirements for documents to flow through compliance. Support notifications and browsing outside of DocuShare portal using ASP.NET.
- Adobe PDF conversion and PNG thumbnail creation of MS Office documents and slides.
- Captive editing Microsoft Office Add-ins for Word, Excel, PowerPoint & Outlook which prevent manipulating documents that are finalized in DocuShare (firm wide).
Confidential - New York, NY
Software Architect/Lead 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. Integrated SDN data and updated Sanctions Lists from OFAC, creating software for searching and detecting, using “Point in Time” analysis with OFAC Historical data and Business Group Exclusion Lists.
- Visual Studio 2012/2013 C# Win-forms, Controls & Assemblies
- Object oriented architecture
- Development principles & patterns. - Open/Close & Dependency Inversion
- Waterfall & Agile SDLC
- Team Foundation Server (2012)
- SQL Server 2014, 2012, 2008
- Advanced T-SQL Development, Stored Procedures, SQL Jobs
- Develop and enhance T-SQL Framework using SSDT & SSMS
- Development of Search Engine Calibration Rules from Business Group
- SQL Server Full Text Searching
- Custom Search Engine Algorithms (TSQL)(Brute force, Hard matching & Fuzzy)
- Develop C# - Jaro Winkler, Levenshtein Fuzzy Searching
Confidential - Newark, NJ
Lead Web 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.
- Specification and design of user and server control library for re-use across development efforts, including Ajax Control Toolkit 4.0.
- Support for client side javascript AJAX (XMLHttp(Request & Response) (Raw Ajax)
- Managed 5 developers and trained/mentored employee programmers in the use and implementation of the application framework
- Coded enhancements designed to improve functionality.
- Migrated and converted C# third party provided open source into VB.NET.
- 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.
- Responsible for Browser compatibility using JavaScript, HTML and CSS2/3 for client effects and UI design.
- Conversion of Classic ASP legacy intranet pages to .NET using custom framework.
Environment: .NET, Visual Studio 2010+, VB.NET 4.0, ASP.NET, C#, Oracle (TOAD) 10g/11g, HTML4/5, CSS2, CSS3, JavaScript, WCF, SOAP, REST & SQL Management Studio, Classic ASP
Confidential
Lead Software Developer
Responsibilities:
- Created reusable and extendable solutions for business units and credit card division of the bank in .NET Webforms.
- 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
Environment: VB.NET 3.5 ASP.NET, C#, ASP.NET, Oracle (Toad) 10g - Stored Procedures, Triggers, Sequences, Packages, XML, Microsoft Office (Word & Excel), Web Services & Web Controls, Object Oriented Architecture
Confidential
Lead Software 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
Software Developer
Responsibilities:
- 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.
- Project #2:Upgraded classic ASP Intranet portal to use 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
- Project #3: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, VB.NET, ADO.NET, Classic ASP, JavaScript, MSOFFICE-XML, Oracle, VSS, SQL Server, HTML, JavaScript & CSS
Confidential, Knoxville, TN
Senior .NET 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: ASP, ASP.NET, VB.NET, ADO.NET, JavaScript, HTML, CSS, SQL Server 2000, Oracle 9, Crystal Repots.
Confidential, Marlboro, NJ
Lead Software 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, ADO.NET, Java Script, HTML, CSS, DirectX, SQL Server 2000, MS Access, Crystal Reports, IIS
Confidential, New York, NY
Lead Developer
Responsibilities:
- Responsible for lead development for Capital Markets Technology, using Visual Basic 6.0, Crystal Reports, Oracle, SQL Server and Sybase. VB Custom User Controls, DLLs and ODBC API and ADO.
Confidential, New York, NY
Technical Architect Y2K Application Integration
Responsibilities:
- Managed 30+ Novell Network Administrators in the effort to integrate and distribute all internal and third party applications/components into a Y2K compliant Windows NT model, bank-wide.
Confidential, New York, NY
Software Developer
Responsibilities:
- Developed the standardized LEX (Listing Exchange) system version 1, still used today, which integrates various MLS legacy systems into a single common listing for Manhattan Condos, Apartments and Town homes between realtors.
Confidential, Washington DC
Application Developer
Responsibilities:
- Migrated hundreds of legacy systems and modules into a windows based environment, model 204 military super computers, mainframe, Oracle, and SQL Server.
- Programming in C, C++, Visual Basic 3 & 4, ODBC API functions, Graphics Server components and third party VBX/OCX controls.
Confidential, New York, NY
Application Developer
Responsibilities:
- Programmed in Visual Basic 3 to develop an Automated Workflow system to acquire electronic signatures for quarterly dividend payments to investors.
- Used SQL Server/Sybase database, and ODBC API.
Confidential, New York, NY
Responsibilities:
- Developed code in Visual Basic 2 & 3 for a mailing list system for bank clients to offer Master Card systems.
- Utilized the first version of SQL Server, Sybase.
Confidential, Piscataway, NJ
Responsibilities:
- Worked with the legacy transaction server and Confidential to acquire real time long distance data to feed to Oracle database.
- Created windows applications in Visual Basic 1 & 2 to utilize the ODBC level 1 conformance standard. Visual C++ for supporting DLL functions used in custom ODBC.DLL.