László Á. Koller
Lead Developer / Database Architect
Key Technologies: C#, Visual Basic.NET, SQL Server, MVC,
ASP.NET, CSS, HTML, jQuery, JavaScript, Entity Framework,
Web Services, Mobile Web, IIS, XML, Bootstrap, NuGet
Experience
SAGE ANALYTIC TECHNOLOGIES, LLC Budd Lake, NJ 8/00 – Present Senior Consultant
Developed business solutions for various Fortune 1000 clients
Served as a developer on all of the following projects (in order of recency):
Revalee Web Automation Software http://revalee.sageanalytic.com An open source project was launched to greatly simplify the administration of web applications. The design aims to free developers from having a multitude of miscellaneous processes to run scheduled tasks. The existing web application can request callbacks at specified times in the future. Revalee reduces a system’s technology footprint as well as increases its scalability.
Technologies: C#, ASP.NET, ESENT, NuGet
Bausch + Lomb Sample Vault Website
A branded storefront was required for ordering pharmaceutical samples online. Industry regulations such as PDMA and Title 21 CFR Part 11 mandated formal compliance testing and an advanced security layer with electronic signatures. The responsive web design is fully functional on desktops, tablets, and mobile devices. A complex rules system implements the client’s sales force coverage and sample allocation strategies.
Technologies: C#, ASP.NET MVC, SQL Server, Entity Framework, jQuery, Bootstrap, HTML, CSS
Who’s In? Event Scheduling System http://whosinwith.us A free Internet service created for scheduling community events featuring a web design tuned for mobile web browsers such as iPhone, Android, and Blackberry. It implements an innovative authentication approach that does not require user registration. Other
highlights include: precision scheduling routines, personal calendar integration, asynchronous events, and an automatic state recovery system.
Technologies: Visual Basic.NET, ASP.NET MVC, SQL Server, Linq2Sql, ESENT, jQuery, HTML, CSS, JavaScript, iCal, SMTP
Merkle Media Placement Application Architecture
A system was designed to optimize advertising opportunities by matching demographic cohorts to media properties. A normalized database model was developed and accessed
Contact Information László Á. Koller (973) 219-4189
through an ORM layer. The web interface made heavy use of jQuery UI controls and AJAX.
Technologies: C#, ASP.NET MVC, SQL Server, Linq2Sql, jQuery UI, HTML, CSS, JavaScript
GEICO Insurance Premium Pricing System
An intranet system was developed to centralize statistical pricing models for nationwide use. Large datasets mandated sophisticated database routines including high-performance import and export procedures. An XML-based template engine was employed to create and automate multi-step analysis jobs.
Technologies: C#, ASP.NET MVC, SQL Server, Linq2Sql, jQuery, jQueryUI, JSON, HTML, CSS, JavaScript, Excel
Microsoft Data Warehouse Metadata Repository
An extranet application was developed to store and manage the multitude of external files that are aggregated to create the client’s data warehouse. An advanced versioning system was created to manage changes and a fully transactional database layer maximized concurrency.
Technologies: Visual Basic.NET, ASP.NET MVC, SQL Server, Linq2Sql, jQuery, HTML, CSS, JavaScript, Excel
Procter & Gamble Online Offer Data Capture http://offerprocessingcenter.com A complete platform for hosting special offers for consumer promotions was created for P&G and other consumer products companies. It features high-performance web page and web service hosting with a first-rate privacy and security infrastructure. Other
functionality includes: a robust programming language and toolkit, e-commerce processing, seamless multilingual support, abuse detection & prevention, real-time reporting, advanced caching techniques, asynchronous I/O processing, multithreaded memory access, and an integrated content management system. This ultra-scalable architecture has processed over 22 million registrations of live data.
Technologies: ASP.NET WebForms, Web Services, Visual Basic.NET, SQL Server, HTML, CSS, JavaScript, REST, SOAP, JSON, WSDL, SMTP
Experian Analytical Report Generation System
A line-of-business application was developed to produce analytical reports for the client’s customers. This complete workflow application imported raw data, analyzed results, and produced rich PDF reports with charts and dynamic text. A flexible, XML-based document architecture allowed new products to be added over time.
Technologies: PDF, Visual Basic.NET, XML, Dundas Controls, ASP.NET, SQL Server
Marketing Management Analytics Marketing Analysis System
A database marketing application was enhanced to include Excel & PowerPoint export features, mathematical analysis functions, and security subsystem.
Technologies: Visual Basic.NET, .NET WinForms, Component One Controls, SQL Server, Excel, PowerPoint
Ipsos Sales Builder Platform
A client services framework was designed to allow document sharing between marketing analysts and back-end reporting systems.
Technologies: SharePoint, XML, SQL Server, Excel
Dun & Bradstreet Customer Data Matching Engine Dashboard
A telemetry application was developed to monitor the client’s high-volume matching systems. The browser-based console provided numerous filtering and charting features. Technologies: WebSphere, Tomcat, Oracle, SVG
Experian ListLink Lead Generation System
A new visual interface was designed for a popular online application for database marketing and lead generation. An interactive demonstration website was developed to solicit feedback and track comments.
Technologies: HTML, JavaScript
magicVORTEX File Transfer Service http://magicvortex.com A comprehensive software-as-a-service solution was created to send large files securely on the Internet. Focused on reliability and ease-of-use, this online service is used across multiple industries including healthcare, transcription, and military customers. Some of the more interesting programming challenges included a completely automated billing system with credit card processing, a standards-based API, Windows services, self-tuning file & network I/O, HTTP compression, and HTTPS encryption. Currently, magicVORTEX boasts over 11,000 users and over 12 TB of data transferred.
Technologies: .NET, Visual Basic, ASP, XML, SQL Server, HTTP, ActiveX, SMTP
Schering-Plough Pharmacist Online Community Website
A community membership website was developed to foster communications with the client’s pharmacist customer base. The features included product alerts, events calendar, certification planner, and a reference library. A back-office fulfillment system was also developed to complement the online application to manage shipment of welcome kits and other printed materials.
Technologies: ASP, .NET WinForms, Visual Basic.NET, HTML, CSS, JavaScript, VBScript, SQL Server
ATLANTIC IMAGING GROUP, LLC Whippany, NJ 6/11 – 4/13 Lead Developer
Designed and developed unique health care solutions for internal and external clients
Assigned tasks for other developers on the team
Health Care Claim Export System
A system was designed and developed to export health care claims from an internal, proprietary database to the industry standard ASC X12N/005010X222 (837P) EDI format. As a line-of-business solution, seamless integration with existing systems was required. Technologies: C#, SQL Server, Entity Framework 5
Industry-specific: ASC X12N/005010X222, OMB-0938-0999 Form CMS-1500 (08-05)
EPHI Policies and Procedures Document
A policy and procedure document was generated for handling Electronic Protected Health Information (EPHI), including administrative, physical, & technical safeguards. Its purpose is to show compliance with current electronic protected health information (EPHI)
regulations based on the Health Insurance Portability and Accountability Act of 1996 (HIPAA) and the Health Information Technology for Economic and Clinical Health Act (HITECH).
Industry-specific: HIPAA, HITECH
Managed Claims System
A platform for managing health care claims was designed to replace the existing Atlantic Imaging Group Network application. The front-end MVC application included tight integration with Telerik’s Kendo UI Web package.
Technologies: C#, ASP.NET MVC, Kendo UI Web Controls, SQL Server, Entity Framework 5, jQuery, HTML5, JSON
Atlantic Imaging Group Network Application
A system for managing and processing health care claims was maintained and enhanced. Reporting systems were updated to reflect changes in business needs.
Technologies: ASP, HTML, CSS, JavaScript, VBScript, SQL Server, SQL Server Reporting Services
iHCFA
An existing health care claim processing system was maintained and enhanced, both front-end website and back-front-end processing engine, to ensure reliability and improve overall uptime. Reporting systems were generated to provide users access to untapped business information.
Technologies: C#, ASP.NET WebForms, HTML, CSS, JavaScript, .NET WinForms, SQL Server, NHibernate, SMTP
NABISCO, INC. East Hanover, NJ
1/99 - 8/00 Systems Developer
Developed a RF (radio frequency) barcode scanning application used to track warehouse inventory real-time. Deployed the application to 7 manufacturing sites. Technologies: Visual Basic; RF equipment; barcode scanners; AS/400 DB2
Maintained and upgraded an application used by financial analysts to track enterprise-wide costs, including inventory, manufacturing, & finished goods, from over a dozen manufacturing facilities.
Technologies: PowerBuilder; AS/400 DB2
Designed and developed a prototype metrics reporting application. This reporting tool armed maintenance planners with the necessary information to properly forecast future maintenance requirements at single manufacturing facility, regional, and enterprise-wide levels
Technologies: Microsoft SQL Server; AS/400 DB2; Visual Basic
DOMINION DATA PROCESSING, INC. Parsippany, NJ 6/95 - 8/98 Programmer/Analyst
6/91 - 5/95 IT Technician
Education
RUTGERS UNIVERSITY - COLLEGE OF ENGINEERING New Brunswick, NJ 9/91 - 5/95 Bachelors of Science in Ceramic Engineering, graduated in 1995 with honors
Publications
The Code Project - Scheduling tasks with Revalee and MVC [2014]
