SUMMARY:

Senior Developer / Architect accomplished in designing and implementing systems including internet/intranet, client/server applications and relational databases. Offer comprehensive understanding of website project concepts and best practices.

EXPERT IN:

• New product development
• Application architectures
• Database object design
• Agile development
• Production support
• Application development lifestyle
• Troubleshooting
• Performance optimization
• Web development principles & standards

TECHNICAL SKILLS:

Languages: .Net Core 1.1/2.0, Visual Studio.NET 2012/ 2010/2005/2003 , C#, Visual Basic 2010/2005/2003 , SQL, PL/SQL, WScript, C using Microsoft Visual C++.

Databases: MS SQL Server 2016/2015/2012/2008/2005 , SSIS, Analysis Services (MS OLAP 2000/7.0), DB2 z/OS 10/9, Oracle 9i/8/7.3, Sybase SQL Server 11, MS Access.

Internet technologies: AJAX, NLog, MSTest, MVC, JQuery, CSS, JavaScript, ASP.NET, IIS 7.5, XML/XSLT, REST WebAPI, SOAP, WCF, Web Services, HTML, ADO.NET/ADO, Silverlight.

Tools: SSRS 2016, GIT, TFS, Rally, AutoSys, CodeMirror, Kendo UI, ID Works, MS Office 2010/2016, Erwin Case Tool, Crystal Reports/Crystal Analysis Pro/Crystal Enterprise, Oracle Express, MS Silverlight 5.1.

Operating systems: Windows NT, Windows 2012/2008//Win7, MS DOS, UNIX.

EXPERIENCE:

Senior Software Developer/Architect consultant

Confidential, Exton, PA

Responsibilities:

• As the architect I was responsible for design of the Performance Monitoring solution for Flight Plan Management System across multiple environments for 30 airlines.
• This multitenant solution provides the following features:
• Collection of data from the servers/databases particular to airline’s environments:
• Performance Monitoring
• SQL Extended Events
• SQL Alerts
• SQL Queries
• Transfer collected data to Confidential Center
• Confidential Center provides:
• Configuration management for Airline/Environment/Server specifics
• Operational functionality for collection of airlines data
• Reporting analysis
• This solution will make Flight Plan Management System more stable, and prevent flight scheduling delays, and increase the quality of airline service operations.
• Designed and developed three - tier solution:
• Center database including Configuration, Operation, Security schemas
• Center Rest Web Api to collect data from the airlines
• Center Dashboard Web Api database interaction for Center Dashboard web application
• Center Dashboard web application provides the following features:
• Administering:
• User/role/authorization
• Airline/environment/server/metrics configuration
• Reporting configuration
• Integration reporting system (SSRS)

Tools: utilized: REST Web API, Windows PerfMon/PLA, Visio, C# .Net Core 2.0, MVC, Entity Framework, Spark UI framework, AJAX, SQL Server 2016, SSRS 2016, GIT, Rally, NLog

Senior Software Developer

Confidential, Wilmington, DE

Responsibilities:

• web and log analytics, ad hoc reporting, DB tables compare tool, Web SQL Scripts management studio, production support set of utilities for accounts and loans corrections, and template studio for XSLT validation, editing, saving into DB and producing HTML and PDF output.
• Application uses active directory and windows authentication security and provides administration of user/roles and database connectivity.
• Internet application to increase customers by 50% within 3 years.
• Designed custom web analytics system. Participated in design and implementation of internet based applications
• Application provides customer registration, customer loan application process, application online pre-approval, customer account management system, payment processing and custom web analytics.
• Supported and enhanced Silverlight application for customer support and loan processing administration, improving customer service by 370 customer service representatives.

Tools: utilized: MS Silverlight 5.1, WCF, Windows 2012/Win7, IIS 7.5, Visio, C# 2015/2012, MVC 4, Entity Framework, CodeMirror, Kendo UI, AJAX, ASP.NET, SQL Server 2012, Excel, ADO.NET, XML, XSLT, CSS.

Senior Consultant

Confidential, Hopewell, NJ

Responsibilities:

• Trained development teams to improve the quality of production support and issue resolution, sharing centralized, categorized SQL scripts which facilitate the gathering of statistical and analytical data and the monitoring of information across team members.
• Application:
• Provides the functionality of connecting to any environment of databases such as SQL Server, DB2 and Oracle.
• Has intellisense SQL editor and allows the creation and storage of categorized SQL scripts with versions, executing them against target environment.
• Allows getting results with Save and Export options.
• Provides data transferring functionality between different environments/ databases, over 1-M rows simultaneously within 3-7 minutes.
• Uses windows authentication security and provides administration of user/roles and db connectivity.
• Is enhanced with functionalities such as
• Report PDF lock/unlock with tracking history of the changes
• Microsoft Rule Engine XML interpreter/comparer rules/rule sets utility
• Specific data refreshing utility.
• Quarterly Performance Reports - Windows service multi-threading notification system for scheduling quarterly performance reports for 2.5 MM clients.
• Redesigned existing process to optimize notification system including database, improving performance by 85%.
• Designed and implemented the conversion of XSL-FO reports to PDF format with secure lock, packaging of the reports (20K/per zip ~ 4.5 GB) and the delivery process to print/mailing facility.
• Designed and built web-based monitoring system to provide fast and accurate analysis for business-interested statistics and to expedite the resolution of production issues.
• Application:
• Each client can have 7-24 different complexity reports.
• System provides XSL-FO to PDF conversion of processed reports and packaging/delivering to the print/mailing facility or by e-delivery.
• Composite Performance Reporting System: Windows service multi-threading notification system for scheduling composite performance of quarterly reports for strategies and scorecards for over 300 financial advisers to improve their overall performance by 60%.
• Designed core system.
• Designed and implemented database driven rule engine.
• Analyzed and processed tune-up and optimization of built applications.
• Designed and built web-based monitoring system to improve the resolution of production issues.
• Redesigned strategy performance calculation and automated the strategy inception date determination.
• Designed and implemented database-driven security module including administration front and backend functionality.
• Designed and implemented the new rewards adjustment process.
• Optimized the process of loading data from different vendors and catalogs.
• Added maintenance processes for providing flexibility in order to satisfy different business requests.
• Standardizes and centralizes data access (Oracle, SQL Server), security and exception management in a multi-project environment; simplifies development and increases productivity of web-based applications.
• Designed the banking core framework and made common components flexible and configurable.
• Maintains compliance with the Office of Foreign Assets Control (OFAC) provisions of the USA Patriot Act, specifically those related to Web Cash Manager Application ( Confidential ) transactions.
• Designed and implemented batch and real-time applications of the OFAC Screening Utility including retrieving/calling data processing from mainframe by using Shadow Direct ODBC connection.
• Automated data transfer to mainframe.
• Application helps transfer all available information relevant to these transactions from

Senior Consultant

Confidential, Voorhees, NJ

Responsibilities:

• Software solutions for service contractors and field service companies that optimize operations by enabling remote data exchange and comprehensive back office automation by combining wireless technology with 'best of breed' business management software application enabling improvement to overall productivity.
• Designed and implemented a DHTML web-based dispatch board for a multi-user environment with complex, visually-rich functionality.
• Built interactive web-based inventory control system which incorporates a majority of features used by Windows Explorer by using Web Services and built Web Server Controls.
• Application: Multiple WEB components for inventory and sales analysis for MS digital dashboard based on a multidimensional database.
• Participated in design and implementation of Microsoft joint venture, which utilized multiple Digital Dashboard Components (ASP Factory) against OLAP Server.
• Developed data archive and restore processes for information module using pivot table control, MDX queries along with WEB components.
• Developed automatic process of installation and configuration of website, SQL Server databases and OLAP database.
• Application: A complex process of migrating existing MUMPS system to Windows based internet/intranet-enabled front end using Oracle database as back end.
• Developed and implemented multi-tier client/server and WEB enabled applications to process personal, educational and financial information for over 270 law schools throughout North America.
• Designed and implemented application specific search engines and processes of shipping LSAC publications to improve and extend functionality of processing information through internet on-line with LSAC representatives.
• Developed and scheduled automatic processes of reading scanned data from flat files and provided data load into Oracle database with e-mail capability through a notification system.