SUMMARY:

• Expert IT developer with over 18 years of hands - on applications development and technical project leadership experience in client-server and web data processing. SOA Enterprise Application Integration methodologies such as OOP, distributed, cross-platform n-tiered program communication using VB.Net, C# interrelated object-sharing DNA ASP.Net, WCF EF applications, enterprise-wide content and data distribution using common databases and data standards implemented with XML, middleware, message queuing,, database design and development, business intelligence tools.
• Experienced in full life cycle development of three/n- tiered software architectures, high performance database solutions with .Net WS (WCF) and components based on object-oriented analysis and design.
• In service of 20 different clients carried out overall programming development for 32 big projects.
• Designed/ maintained 25 databases and technical environments along with technical specifications, effort estimation and status reports and end-user manuals.
• Experienced in gathering, formalization and architectural implementation of business requirements, software maintenance, support, release management, production roll out, and user training. Creative, initiative, able to provide leadership and direction to project teams, has strong client management and communications skills.
• Details, quality and goals-oriented, able to manage multiple tasks simultaneously, delegate tasks, set up priorities and milestones and meet deadlines. Self-motivated, has strong work ethic and professionalism.

TECHNICAL EXPERTISE:

Programming Languages: VB.NET, C#, MVC 2,3,4,5 ASP.NET, LINQ to objects and LINQ to SQL, XML DOM/ Schema, XSLT, XPath, AJAX, ODS, Winforms GUI,, Java Script, JQuery, JSON, Access Basic, T-SQL, PL/SQL, DDL, Power Builder (entry level), C/C++, ActiveX Components, VB 6.0, VBA, HTML5, DHTML,CSS3, ASP 2.0, OOA, OOD, MyGeneration, EF 4, TFS 00,2012, NUnit, Node.js, Angular JS

Programming Environments: .Net Framework 1.1, 2, 3.5, 4.5 MS Visual Studio.NET 2012, 10,8,5, MS Front Page, IIS 5.0, 6.0, COM, COM+, DNA, DCOM, MTS, MSMQ, ODBC, RDO, DAO, ADO 1.5-2.7, ADO.NET, ADO.NET Entity Framework 2,4,6, API, DTS, SSIS, SSRS, Confidential, SVN

Operating Systems: Windows 2012 server, W7, 8, 10, XP, 00, 98, 95, 3.11, NT 4.0, DOS, UNIX (shell scripts, Solaris), NetWare 4.01, Windows Server 08, 2012, 2016 beta, MS AZURE

Databases: MS SQL Server R2, 00, 05,08,2012, MS Access 7.0, 00,08,12 Oracle 8, 9.1.,10,11

Software: SQL Navigator, TOAD, PC Install, Rational Rose 4.0, ProComm, PerformPro, TFS, VSS, PVCS, SQA, PS7, Seagate Crystal Reports 4.5 - 8.0, 11, VB Assist, Erwin ERX 3.5, Erwin Platinum 3.5.2, MS Office 97, 2000, MS SQL Enterprise Manager, MS ISQL/w, Visio 5.0, Visio.Net, MS Visual Modeler, MS SNA, MS Visual Analyzer, Attachmate Extra 6.2 Personal Client, WCL, QFG, SizerOne 7.0, ISIS Base/Draw MDL, WIM, MS Project, Rational Clear Quest, WS FTP PRO, HotMetal Pro, Plumtree 4.5,5.0 Lotus Notes, Netop remote control, Eclipse java IDE, MagicDisk, Beyond Compare 3, MS ALM Agile tools, CuteEditor control, PlanBox, Adobe Lifecycle Designer, Oracle SQL Developer 3.1, MS Dynamics CRM, Infragystics and Telerik controls, PowerShell, SharePoint 2013, Office 365, Excel PowerPivot, PowerBI, PowerPoint in MS Office 13, 16, GIT Repo, SourceTree

PROFESSIONAL EXPERIENCE:

Confidential

Lead .Net developer, consultant

Responsibilities:

• Restored, maintained and developed a set of C# ASP.Net web sites with GIT BitBucket/VS 2015 integrated code base to enable lending operations, accounting, loan warehousing, loan pooling, origination, financing and other processes in mortgage financing.
• Created new web sites all combined under unified UI with SSO security model, SSO admin account maintenance screens.
• Coded JavaScript, complex Ajax pages, SQL Server stored procedures, web services, Ajax calling web methods.
• Maintained fifteen databases, created cross-database ETL with SSIS packages and jobs, C# Excel data exports from SSIS.
• Created several SSRS reports, managed SSRS report server. Supported QA, UAT, production deployment process and production support for new and existing web sites and ETL. Disassembled ASP.Net C# and prepared a clean maintainable code base for a set of sites.
• Used Jira HOMIT system, with internal user posting requirements for new pages and for site process re-designs.
• Upgraded EF 5 to EF 6 for ten sites, maintained DB-first object model with tt scripts, Repository pattern, coded css, bootstraps, JQuery.
• Coordinated team development effort with SourceTree and VS 2015 GIT Repo integration.

Confidential

Software developer, consultant

Responsibilities:

• Developed Winforms C# SQL Server Mortgage Calculator and title services system creating special business workflow for the state of Confidential where Confidential as a vendor provides title services to attorneys and national lenders, performing Title searches, creating a Title Report, processing the recordings and issuing the title policies.
• A Confidential attorney conducts the signing and escrow services.
• Created “Loan Estimate Calculator” within the Title System, to be used by authorized user.
• Using WebBrowser control on a Winforms popup form as an IFrame launch to 3rd party Confidential loan fees calculator with user entering mortgage parameters, processing HttpRequest and response from external web site, importing (parsing) response XML into the system in a second thread while awaiting response to refresh grid on a form.
• Estimated Data Mapping of Lodestar XML to fee’s tab within Confidential, created SQL Server tables for data import, modified existing workflow to use the incoming data, coded stored procedures and ETL processes for data import.
• Created forms resource files with images for tab control buttons.
• Created SSRS reports for preliminary and final Title bill and C# logic enabling them to run from Winforms modal popup. Remote team project with scrum daily meetings.
• Citrix connection to Win 2012 bridge server and W7 VM, TFS check-ins and deployments.

Confidential

Software architect, development lead

Responsibilities:

• Created AZURE C# Razor MVC SQL Server cloud web portalwith web and worker roles “Code-First” with EF 6.0, VS 2015 to be a hub for company projects.Coded Angular JS SPA model within ASP.Net MVC.
• Set up SQL Server 2016 database locally and in a cloud, a cloud service, a storage account, created company domain in a cloud.
• Created Custom Security schema for the site: resource authorization and user authentication with local storage of users combined with external cookie authentication using OWIN, customized Identity framework. Tested two-factor authentication with social accounts.
• Code storage - online TFS.
• Conducted internal company presentations on new features of SQL Server 2016 and SSRS integration with PowerBI, Excel PowerPivot, SharePoint 2013, creating SSRS KPI, Mobile reports, and Visual Studio 2015 environment and server setup with AZURE cloud account, new SSRS graphs: Sunburst and Tree Map Charts. Set up subprojects as MVC Areas using Razor MVC C# AZURE “Database-First” - modelled the database and created Models, Views, Controllers for data entry and reporting Views on Risk management EF 6.0 entities:
• Risk Controls and Assertions for different Fidato clients, Unifying into standard Risk Management application.

Confidential, Plymouth Meeting, PA

Sr. database developer, consultant

Responsibilities:

• SQL Server 2012, SSRS, SSIS ETL. Designed, created and converted multiple SSRS reports from one back end system to another.
• Coded SSIS ETL data transmission and transformation packages to fill data warehouse from many external sources.
• Created DB Rules Engine with reporting, a set of SSIS-run stored procedures, to check and report data inconsistencies between warehouse and several transactional databases.
• Successfully implemented multiple back-end projects optimizing SQL queries, performance tuning, maintaining table structure, creating new databases, managing SSRS subscriptions, analyzing data, working with internal end users through ticketing system and meetings. Team work with SQL developers, QA and DBAs.
• Created and modified SSIS packages to transmit data to 4th NF DataMart warehouse to enable BAs to analyze data there besides report presentations.
• Designed DataMart warehouse ETL SSIS packages, provided data inventory.
• Provided post-deployment production support through HATs ticketing system and TFS User stories, interacting with end users and QA: big fixing, user training, preparing manuals, implementing change requests.
• Developed multiple screens, modules and MVC-triggered SSRS reports for school district payroll system. C#, MVC 4,5 entity framework with C# service modules, functions calling/updating db through data repository classes or ADO. SQL Server 2012 stored procedures, SSRS Report viewer control with views, controller, and models.
• JavaScript and JQuery for controls handling and validation, JSON client to server calls, Angular JS, JQuery, AJAX for file import and download.
• EXT Grid. Remote team project, TFS, SCRUM agile, working with QA and BSA, strict based on Use cases and set timing for each module/report. VS 2012, LINQ, big mature OM. Run options for view rendering/model submit to reports. HTML5, LINQ control binding, db-driven menus.
• Remote team coordination with Scrum meetings and Use cases.
• Full SDLC development with production deployment and support based on QA and internal user feedback.
• Implemented AngularJS controllers that interacts with the Web Server using $http service.
• Created AngularJS templates that implement directives that are linked to Web Server data.
• Used JavaScript in AngularJS expressions, implemented scopes and modules, scope as a data model, directives in AngularJS views to extend form elements, bind them to the scope, and dynamically interact with them and to bind model to page elements.

Confidential, Princeton, NJ

Sr. Web developer, consultant

Responsibilities:

• Designed and implemented security model for VB.Net ASP.Net SQL Server reports Dashboard web site using windows integrated authentication, user role-based authorization, LDAP searches (.Net UserPrincipal).
• Created multiple graphical SSRS reports with parameters against Oracle database, with shared datasets showing linear graphs, pie charts and histograms Used Oracle SQL Developer 3.1.
• Created SQL Server jobs to run SSIS packages, Aspx pages with SSRS MS Report Viewer control to display SSRS reports on “user- given- and received collateral” data with summaries. JQuery UI interface.
• Full SDLC development with production deployment and support based on QA and internal user feedback.

Confidential, Berwyn, PA

Sr. Software developer, consultant

Responsibilities:

• Delevoped and maintained a conglomerate of corporate web-based and windows forms applications and systems (JavaScript, HTML, C#, ASP.Net 4.0, MVC, SQL Server 2008 R2).
• Managed production code and data deployment using SVN, Automated reports creation and email data distribution using Business objects Enterprise, Crystal Reports 11, outputting Ecxel reports. Created NUnit test projects to test blocks of code in MVC.
• Developed multiple ASP.Net intranet reports, Coded SQL Server procedures, triggers, DML DDL changes, for xml, xsl transforms, debugged and SQL profiler- traced complex SQL Server chains of procedures, C# code, created multiple C# admin and user web interfaces.
• Coded DTS and SSIS packages, creating new job processes, DTS/SSIS conversions. Process design, system maintenance, tables redesign.
• Maintained C# ASP.Net portfolio strategy proposals document generation system (“Progen”) based on MyGeneration OM, IBatis Object Mapping template and regular OO (AIM, BC).
• Developed VB.Net Winforms -SQL Server application (”FRS system”) to trace everyday account transactions and data imports from external feeds. XML, XSLT.
• Responsible for everyday functioning of 35 data ETL jobs and background processes.
• Developed Dynamic PDF automatically generated Signup Kit application using Adobe Lifecycle Designer with mapped form fields.
• Created C# plugins for MS Dynamics CRM. In close interaction with the main development team and QA implemented different stages of SDLC and supported functioning of client service group, focusing on production post-deployment support.

Confidential

Sr. Software developer, consultant

Responsibilities:

• Developed C#, ASP.Net 4.0, SQL Server 2008 extranet web site redesigning B2C use Confidential content management system with database-stored user-manageable context and page/email templates.
• Edited page templates replacing static page context (text areas) with FWTextContainer context area placeholders pointing to Confidential - managed content items in Confidential admin context repository.
• Made use of ASP 4.0 routing tables, user controls, coded JavaScript handling order placement and notary tracker user role-based controls visibility.
• Tested WCF Web service invocation by the consuming application.
• Provided production bug fixing documented in PlanBox adjusting user authentication and login/logout mechanisms, setting permissions in Confidential Admin and on the application site.

Confidential

Sr. Software developer, consultant

Responsibilities:

• Developed JavaScript, HTML, C#, ASP.Net 4.0, SQL Server 2008 intranet web site for Confidential Inc. containing features to build and manage a catalog of housing construction models with defining elevations and options.
• The system was managing processes of model option pricing, approvals of model-elevation-option associations for regional communities, model branding, project exceptions, model life cycle in community building, model catalog submission, approval, and status/ pricing changes.
• The work was a team effort in tight integration of two developers, three QA, two BA members, software architect and project manager, working on client site with Toll Brother's managers.
• Created new web pages, built multi-tiered .Net based XML-properties-defining serializable object model using entity editor application.
• Customized navigation templates in ASP.Net Wizard control managing WizardSteps which contained user controls and MDI Popups.
• Coded LINQ to objects and LINQ to SQL, user controls, AJAX panels, custom page validators, AJAX extenders.
• Used CuteEditor control to produce and store RTF notes, EventHandlers, invoking JavaScript, DataBinding SideBarList, GridViews with bound fields and ItemTemplates using ODS.
• Coded JavaScript, CSS, BreadCrumbs, XML parsing in web code and in SQL stored procedures, XSLT, (d)HTML, ETL processes. SCRUM Agile work was CR-based with strict timelines. Fixed many TFS-scheduled bugs, performed TFS server code deployment, code merges and check-ins.
• Each big CR would have its own TFS branch. Database project was part of the solution, with all DML and DDL compiled and build, with data and change deployment scripts.
• Performed DB schema comparisons and DB synchronizations. Full SDLC development with production deployment and support based on QA and internal user feedback.

Confidential, Moorestown, NJ

Sr. Software developer

Responsibilities:

• Developed JavaScript, HTML, VB.Net, C#, ASP.Net 3.5 Payroll processing system with modules for tax, deductions, salary, benefits, time-off accruals calculations with yearly and quarterly reports, pay checks processing.
• Maintained big 6-tier OO model with client and server communicating over .Net remoting, worked on replacing this mechanism with WCF calls.
• Parallel processing was done in multithreading.
• Worked on multiple change requests making parallel changes to web and client-server interfaces.
• Using .Net 4.0 ADO.Net Entity Framework 2.0 Coded LINQ updates, deletes, selects, grouping, joins, re-factored existing object model to use LINQ -generated code entity classes mirroring the database structure based on object relational mapping using VS 2010 O/R designer, LINQ to objects, LINQ to Sql (“Database First” modelling).
• Built VS dbml diagrams to add DB entities with relations, coded custom T4 scripts to create LINQ GeneratedEntities.vb from it.
• Coded SQL Server 2008 stored procedures including chained ETL processes, DML scripts, ADO datasets and LINQ queries, config data processing, WinForm GUI elements, infragystics controls binding, db grid, Form cotrollers, MS Enterprise library and MVC patterns, XML/XSLT scripts.
• Worked with TFS object model to create application for automatic check-in of database changes.
• In a team of Sw architects, BAs, QAs created and implemented new process designs using existing object model, following up TFS check-in, merging, branching, code building procedures.
• As a member of tech support for customer support group under tight time constraints worked on fixing bugs of different kinds and priorities, in Winforms client, database (data and scripts), middle tiers, Asp.Net, JavaScript, JQuery web front end, utility apps, reports, process and environment setups.
• Using MS Visual studio designed C# SharePoint forms. DevOps team operation using TFS continuous integration CIT, SIT, unit testing