Andrew Pal
Freelance Web Application Developer
Rocky River

Andrew Pal
2014-09-01 - 2015-05-01
Owner/Operator
Leveraging nearly 20 years of professional web development experience to design and build custom web and mobile applications. Current focus and passion is: back-end systems and API's built around NodeJS; front end HTML5/CSS3 systems built with single-page application frameworks such as AngularJS and BackboneJS; and NoSQL datastores such as MongoDB and Firebase.
  • https://serverlist.io - Real-time Minecraft server listing application built on NodeJS, AngularJS and Firebase.
  • Sign In System for activity tracking for students enrolled in Upward Bound program. Built with BackboneJS, NodeJS and MongoDB.
  • Consultation on modifications for systems built with AngularJS to provide proper search engine indexing of site content.
  • Various tasks for domain name registrar client including name availability analysis from WHOIS sources, executing registry tasks using NodeJS library to generate and transmit EPP XML and extension of web site and supporting systems to handle additional TLD's.
IQ 20/20
2010-01-01 - 2014-09-01
Senior Developer / Business Inteligence Implemenation Specialist
Develop and maintain new features and systems for leading Business Inteligence platform targeting Pharmaceutical Sales space. Interface with clients to create custom interactive dashboards and visualizations with their data on the IQ 20/20 platform. Implement ETL (extract, transform, load) systems for client data with accompanying operational processes.
  • Create new map data visualization feature using Google Maps API
  • Create operations workflow system based on Microsoft Workflow Foundation for managing data update process including steps for retrieval of new client data, processing of data, deployment to QC environment, QC sign off, end user sign off and production deployment. System includes notifications and UI for process monitoring and pass/fail for each step.
  • Modifications to integration of IQ 20/20 platform with Salesforce.com
  • Data analysis, visualization and report design and implementation management for various clients with data sourced from internal systems, Salesforce.com and other vendor services.
  • Manage sales, call plan, coupons, samples and promotion data processing for major pharmaceutical client. Manage operations for same, covering data updates on various weekly and monthly schedules and timely processing of large (100M+ rows) datasets. Efficiently load, join, transform and and aggregate data from disparate sources at varying aggregation levels.
SunGard Availability Services
2004-07-01 - 2010-01-01
Senior Software Engineer - Team Lead
Design, develop and test systems and features for leading Business Continuity and Disaster Recovery software tool. Lead team of developers in same and provide professional guidance and performance reviews.
  • Enhance legacy VB 6.0 system to provide support for Unicode text.
  • Participate in design and development of complete system rewrite in C# .NET
  • Design and implementation of scheduled task system for executing imports, exports and other long running processes out of band.
  • Design and implementation of database abstraction layer providing object model for writing SQL statements that can be executed against multiple RDBMS back-ends.
  • Participate in design of custom object-relational mapping layer supporting arbitrary extension of models by end users.
  • Design and implementation of a guided UI system allowing end user administrators to create custom flows through the software with completion tracking, notifications and scheduled resets.
  • Manage team of offshore developers. Organize and provide training on entire platform.
  • Participate in design and development of RESTful API for data import and export built on ASP.NET MVC.
QVC
1999-12-01 - 2004-07-01
Systems Engineer III - Technical Lead
Develop new eCommerce and customer support functionality for the web site of the leading cable shopping network. Design, implement and test content management systems for online shopping assets and information.
  • Evaluate technology options both for QVC.com projects and the QVC organization as a whole.
  • Provide technical recommendations and guidance.
  • Functional analysis, conceptual design, detailed physical design, implementation, testing and support of site enhancements and supporting intranet applications.
  • Application development using Microsoft technologies including: C#.NET, .NET Interop, Visual C++ 6.0, ASP and ASP.NET, VB 6.0, COM/COM+, MSXML and SQL Server 2000.
Pronet-Inc Kft
1998-10-01 - 1999-10-01
Project Coordinator
  • Worked with customers to create custom web sites and N-tier applications.
  • Responsibilites included requirements gathering and functional analysis, technical design, project management and implementation of SQL Server databases, MTS Components in VB 6.0, ASP pages, HTML, and VB executables providing user interfaces for database applications.
Vertex Software, Inc.
1998-01-01 - 1998-10-01
Web Developer
  • Created custom web sites and web applications using PERL, CGI, HTML and ASP pages interfacing with MS Access and Foxpro databases.
  • Created a telephony application in VB 5.0.
Rubbermaid, Inc.
1996-03-01 - 1998-01-01
Web Developer
  • Involved in the second iteration of Rubbermaid's web site including their first eCommerce functionality.
  • Created interactive web pages using HTML and CGI.
  • Modifications to MS Access application for maintaining online product catalog.
College of Wooster
Mathematics and Computer Science - Bachelor of Arts
1994-08-01 - 1998-05-01
Budapest Semesters in Math
Mathematics - Study Abroad Program
1997-01-01 - 1997-06-01
English
Native speaker
French
Intermediate
Web Development
Master
  • HTML5
  • HTML
  • CSS
  • Javascript
Javascript Platforms and Frameworks
Master
  • NodeJS
  • AngularJS
  • BackboneJS
Programming Languages
Master
  • C#
  • Javascript
Databases
Master
  • SQL Server
  • MySQL
  • SQLite
  • MongoDB
  • Firebase
Music
  • Playing Guitar
  • Rock
  • Blues
  • Folk
  • Electronic
Languages and Cultures
  • French
  • Hungarian
Activities
  • Swimming
  • Raising Two Kids