ALEX PANDRE
email: [web at pandre dot org]
OBJECTIVE
Providing "State Of The Art" Web Development, Network and System Security Engineering.
Level: hands-on Web Architect/Lead Web Developer/Development Manager
Operating Systems
Linux, Android, UNIX, Windows, MacOS, DOS
Languages
PHP, JavaScript, C/C++, HTML5/DHTML/XHTML/XML, CSS, Perl, JSP, Python, Java, ASP/VBScript, VB, C#, .NET, AppleScript.
IDE & Tools
kate (KDE Advanced Text Editor), Quanta Plus, KDevelop, gcc, Eclipse, Visual Studio, Bluefish, efte, Notepad++, EditPlus 2
VCS
Git, Bazaar, Subversion (SVN), CVS, SourceSafe.
WEB Server Side
PHP5-FPM, FastCGI, Apache, nginx, Microsoft IIS, Flash/ActionScript, ColdFusion.
API/Frameworks
It is too long list to put it here, so see project's descriptions in Professional Experience section.
Database
MySQL, SQLite, PostgreSQL, Microsoft SQL Server, Access, FileMaker Pro Dev, FoxPro.
GRAPHICS
Raster/Vector/CAD/3D; GIMP, Google Drawing, Inkscape, LibreOffice Draw, Krita, Karbon14, LibreOffice CAD, FreeCAD, 3D modeling, Adobe Photoshop/Illustrator, Font tools.
OFFICE
LibreOffice/OpenOffice, Microsoft Office/VBA, Adobe InDesign/PageMaker/FrameMaker.
REPORT TOOLS
Google Chart Tools, ActiveReport, Crystal Reports, many different PHP and JAVA based reporting and project management systems and frameworks (Zoho Projects, JIRA, ...)
2001 - Present, Consulting (directly as Independent Contractor/Developer, dba WebAPPL or via different consulting agencies)
2011/11 - 2012/01, direct client: Mobiquity, Inc.
Technology In Use:
  • Amazon EC2/RDS cloud environment with LAMP/LXMP stack in its base, where LXMP is stands for Linux/nginx/MySQL/PHP.
  • PHP Frameworks: Drupal 7.x/6.x, CodeIgniter, Zend Framework, Symfony.
  • Debugging tools: FirePHP, Firebug.
  • Client side: JavaScript, DOM, AJAX, JSON, jQuery, jQueryUI, CSS, XHTML/DHTML/HTML5/XML.
Description: Over this time I have work for numbers of the projects.
  • Implement custom Drupal Views for custom Drupal content type with WebForm in order to deliver posted content as JSON array to mobile app (Android, iOS).
  • Integration of server side development environment with Github services in order to use Git not only for source code version control, but also as a deployment and server migration agent.
  • Investigate, research, install and configure nginx web server with php5-fpm (PHP5 FastCGI Process Manager) and with Drupal as a web hosting solution for Drupal based web applications.
  • Works on integration of custom relational objects model on top of Drupal data structure.
  • Works on implementation of custom JSON API web service between Drupal and Node.js.
  • Drupal theming based on jQuery Mobile.
  • Troubleshoot, debug and resolve problems related to implementation of http raw data posting processing in order to sending JSON data from iOS native app to CodeIgniter based web application.
2011/05 - 2011/11, consulting agency: WinterWyman, client: DYMO Mimio (Newell Rubbermaid)
  • Migrating old code to new development environment managed by version control systems (Git, SVN).
  • Developing Interactive Teaching Community based on modern frameworks.
  • Drupal 6.x custom module and theme development.
  • Troubleshooting and fixing problems.
2010/11 - 2011/03, consulting agency: KMDM Group, client: NPR/Public Interactive
Project Summary: Custom module development for Drupal 7 to implement stories search via NPR API.
Technology In Use: LAMP, PHP Framework Drupal 7, FirePHP, JavaScript, DOM, AJAX, JSON, jQuery, jQueryUI, CSS, XHTML/DHTML, XML.
Supported browsers: Firefox, Chrome, IE8.
Description: I have created a custom module for Drupal 7 to search for news and stories via NPR API and implement submission selected from search result stories into News River of Core Publisher web application.
  • During this development I have use following Drupal 7 API: Forms API, AJAX Forms API, AJAX Framework, JavaScript API, Common API, Menu API.
  • Develop custom functionality for:
    • Parsing NPR API Input XML and convert it into simplified PHP object.
    • Dynamically generation of form elements code based on result of NPR API Input XML parsing.
    • Organize form fields into groups by using jQueryUI.tabs instead of usual fieldset tags. jQueryUI.tabs now included into Drupal 7 but use of it not yet documented. So, I have come up with custom functionality to apply Drupal 7 build-in jQueryUI.tabs to group of the form fields.
    • Injection of dynamically generated JavaScript with JSON object generated by PHP on server side level.
2010/05 - 2010/11, consulting agency: EliassenGroup, client: InfoMedics
Project Summary: Internal Intranet Web Application development for new InfoMedics Call Center running on Linux/Apache/PHP environment with dedicated Oracle database server.
Technology In Use: LAMP, Oracle, PHP Framework CodeIgniter, FirePHP, JavaScript, DOM, AJAX, JSON, jQuery, jQueryUI, CSS, XHTML/DHTML, XML. Supported browsers: Firefox, IE8.
Description: For this project I have created a lot of server side business logic as well as UI modules by using listed technologies. All development was done with Object-Oriented Programming techniques under CodeIgniter MVC Framework with extensive use of jQuery, jQueryUI and CSS on client side.
  • Architect and develop main controller that allow incorporate into all other controllers of this web application all common functionalities including but not limited to
    • user management system over correct handling of sessions, cookies and login/logout functionalities;
    • debugging system by using FirePHP, Firebug, Firebug Lite and some custom code;
    • browsers identification;
    • managing main controllers and views.
  • Architect and develop many major controllers, views and libraries including but not limited to
    • home controller and related views that implement main "one window" interface that allow use of many controllers and views from within main interface based on user actions;
    • form builder library and CodeIgniter form helper extension that allow developers to generate form elements code with all attributes and attached JavaScript actions or AJAX behaviors;
    • set of controllers and views to implement multi-layer/multi-page forms with extensive use of jQuery and jQueryUI on client side, specifically jQueryUI.tabs and jQueryUI.accordion and style it with custom CSS;
    • custom functionality to handle transfer of data from server side to client side and otherwise by using JSON encoding/decoding on server side and AJAX on client side;
    • dynamically generated JavaScript validation functionality for form elements based on type of data for those form fields and database rules for those fields.
2010/03 - 2010/05, consulting agency: WinterWyman, client: Charity Partners
  • Help client to migrate old system to new framework and apply OOP style of programming.
  • Help to find some new solutions and fix some problems.
2009/09 - 2010/03, direct client: Adelja Learning Inc.
  • Develop workflow for migration techniques of client web application and database from one hosting server to another, including but not limited to working out problems such as
    • server side based spellcheck support over PHP;
    • problems inherited from old MySQL server;
    • problems introduced by different file names handling procedures on Windows and Linux in order to make sure that web application could run on following platforms: LAMP, WAMP or WIMP;
    • and some another problems.
  • Discovering and fixing problems in client web application related but not limited to user interface and implementation techniques of some front-end features implemented with PHP, HTML, DOM, JavaScript, CSS.
  • Research, develop and implement procedures for conversion of old Microsoft Agent Text-To-Speech (TTS) technology into the new Flash animation character based TTS technology from Media Semantics. This was done by embedding appropriate Flash objects into the code and use of Flash client API and custom coded JavaScript functionality which is bind it together with web application eventuality and user interface behavior.
2009, client: IBM
  • As a PHP/Drupal web developer I was involved in second phase development of InfoBOOM! web site (http://theinfoboom.com). Bugs fixing and new functionality introduction and development.
2009, direct client: WordStream, Inc.
  • Research, development and consulting for specific techniques in web applications development based on Drupal framework in order to implement certain clients requirements.
  • Implementation of migration techniques for client web application and database from one hosting server to another.
  • Creating and managing corporate development environment capable to manage any web project over SVN version control system with ability to deploy web sites directly from version control system repository. Web mastering Apache2 configurations and administrating database server in development environment.
  • Researching and fixing problems in client web application. Including upgrading Drupal core and contributed modules to the latest versions by converting clients Drupal installation to the Drupal deployed directly from Drupal CVS repository. That will make all future updates for Drupal and contributed modules as easy as click of the button in CVS client or run a simple shell command, even in the case of locally modified code in the Drupal core or contributed modules. It is also allow developers to find these locally modified code lines and manage them better.
  • Develop complex Drupal theme to implement different design for different section of the site.
  • Working with many Drupal modules.
  • Translate non-technical wishes to technical requirements and tasks, and implement them as a custom Drupal modules and/or PHP snippets, or implement it from scratch.
  • Implement content browsing by date feature - "DATE BASED ARCHIVE" block and all related functionality. Client use it to provide visitors possibility to browse blog content by year, month, day.
2008, client: Relational Semantics, Inc.
  • Research, development and consulting for specific techniques in web applications development based on Mozilla Lab Prism prototype application, Adobe Air, Adobe Flex in order to implement certain clients requirements.
  • Research of different ways to install Prism application.
  • Design and development of NSIS installer for client web application installation as a Prism desktop application.
  • Research and consulting on PHP based report system integration with client web application.
2008, client: Black Hammer Productions, Inc.
  • Research, development and consulting for specific techniques in web applications development based on Drupal framework in order to implement certain clients requirements.
  • Researching and fixing problems in client web application.
2008, client: Massachusetts Institute of Technology (MIT)
Design and implementation of Software Downloads and Licensing distribution System (SDLS) as a Drupal CMS based web application (Linux, Apache2, MySQL5, PHP5, DHTML, XHTML, XML, DOM, CSS, JavaScript, AJAX).
  • Architect and implement Subversion (SVN) driven development environment for Drupal CMS development on Linux/Apache2/MySQL5/PHP5 (LAMP) environment.
  • Design and implementation of Drupal based web development workflows and complex procedures (included but not limited to use of modules, custom code, Drupal special administrative configuration techniques) for:
    • initial deployment directly from Drupal CVS repository;
    • keeping development code up to date even with customized code of Drupal core or contributed modules;
    • migration from one server to another;
    • Drupal content access control, content visibility and navigation visibility permission properties of the same content.
  • Custom Drupal modules development. Design and implement Shibboleth AAA (Authentication, Accounting, Authorization) Drupal module for integration with WebSSO (Web Single SignOn) system based on Stanford's WebAuth with federated identity-based authentication and authorization infrastructure. WebAuth based on SAML over Shibboleth Service Provider (SP) to Shibboleth Identity Provider (IdP) relationship implementation. Where WebSSO server support authentication mechanisms like web certificates, Kerberos tickets (via the HTTP/SPNEGO protocol), usernames and passwords over SSL/TLS.
2007, client: Waste Management via CommonPlaces e-Solutons, Inc.
  • Social Network development (http://greenopolis.com) based on Drupal CMS. LAMP: Linux, Apache2, MySQL5, PHP5; DHTML, XHTML, XML, DOM, CSS, JavaScript, AJAX.
  • Custom Drupal module development.
  • Architect and implement Subversion (SVN) driven development environment for Drupal CMS development on Debian Linux/Apache2/MySQL5/PHP5 (LAMP).
  • Development Manager role: Drupal based web development workflow process design and implementation.
  • System virtualization by using VirtualBox.
  • Implementation of MySQL databases and file system incremental backup system (Bash scripting).
DNSstuff.com, aka DNSreport.com, aka Declude.com
  • Web development. OO PHP, DHTML, XML, CSS, JavaScript, DOM, AJAX, Apache, MySQL (LAMP).
  • DNSBL/RBL alert service developement. I've create for DNSstuff.com a DNSBL/RBL report alert service (http://www.dnsstuff.com/products/alerts/rblalert) in order to alert service members when IP addresses for they email servers become blacklisted and why. So, they will be able to take appropriate actions.
  • System virtualization by using VirtualBox, ParallelPC, VMWare.
Starent Networks Corporation
  • Complete redesign of Test Management System for QA department and implementation of it as a Web Application with Object-Oriented PHP5, DHTML, CSS, JavaScript, AJAX under Debian Linux, Apache2, MySQL5 (LAMP environment).
  • Procedure implementation for MS Access (data) migration into MySQL.
Consulting company
(OOP on PHP 5, Flash, DHTML, XHTML, XML, DOM, JavaScript, AJAX, CSS, MySQL).
  • Design and implementation of abstract layer and Frameworks for:
    • web based SQL query constructor, editor and SQL result handler.
    • web based Questionnaire/Form constructor, editor and result handler on many levels.
  • Custom ColdFusion Web Application development.
  • Web application service provider, content management system (CMS) and user management, eCommerce and online catalog, web publishing and PDF Forms generation, information accumulation and intelligent form handling, web database integration and data representation conversion.
  • Designed and developed Web Application User Interface SDK and Web API for applications by using Object-Oriented web development techniques as a combination of DHTML, JavaScript, Web Events, CSS, Flash MX, ActionScript technology, server side scripting in PHP and ASP/VBScript with COM.
  • Design and development of client/server solution for security policy and software application deployment and enforcement over any connection (Visual Basic, ASP, DHTML, VBScript, JavaScript, DCOM, ActiveX).
London Economics International
  • Creating client side Visual Basic Application for interaction with MySQL database for data representation and manipulation in different ways.
  • Providing project development analysis and most efficient strategy to combine together many different modules written in C, C++, C#, Visual Basic, Turbo Pascal programming languages into one manageable development project with ability to use one debugger for all modules.
Vista Higher Learning Company
  • Development of web based learning courses with Object-Oriented PHP on Apache/MySQL/PHP5/SVN environment with extensive use of DHTML, XHTML, DOM, JavaScript, AJAX, CSS.
04/2004 - 09/2005, Wingate Computer Services, Inc.
Design, Development, Deployment.
  • Automation workflow development for as many procedures as possible (Scripting).
  • Routers, Firewalls, VPN and IP tunnel connection configuration and management (including Cisco).
  • DNS, DHCP, WINS, IIS servers, Active Directory DC, Workstation settings, Registry management over manual administration and programmatically over scripting (Shell, VB, WSH, WMI) locally and remotely. Server Load Balancing (Round Robin) configuration.
  • Authentication, authorization, and accounting (AAA) implementation and configuration over RADIUS and Active Directory in order to establish secure user connection and identity management on enterprise network level and over VPN connection.
  • VirtualHost for Apache Web Server or multihoming web server configuration for Microsoft Internet Information Server (IIS).
  • Implementation and management of enterprise wide antivirus protection over McAfee ePolicy Orchestrator (ePO) with VirusScan 8.0i Enterprise or Symantec AntiVirus Corporate Edition.
  • Vulnerability Assessment, Intrusion Detection, Intrusion Prevention, Network and System Audit and monitoring. Behavioral application control and workstation based firewall rules design and enforcement. Familiar with different Intrusion Prevention Systems: HIPS (McAfee Entercept, eEye Blink, WHIPS, eTrust Intrusion Detection) and NIPS (Snort).
  • Remote deployment design and implementation for any software, updates and policy enforcement.
  • Microsoft Office Visual Basic Application (VBA) and Macro programming. HelpDesk system customization programming and administration.
  • Remore Screen Control (VNC, pcAnywhere, RAdmin, Timbuktu, Remote Desktop/Terminal Client, NetMeeting). Remote Shell (ssh, telnet, rconsole, rsh, psexec, rexec).
Federal Aviation Administration (FAA)
Developed the client/server system for processing Geo database, for calculation of the optimal location and the type of communication equipment (as COM DLL with Visual C++/ATL/STL and Compaq Visual Fortran, interface with Citrix MetaFrame).
  • The Server side of the system includes searching and retrieving functionality for all necessary data from DTED database (Digital Terrain Elevation Data); another function library calculates the destination coordinates and elevation from starting point with appropriate possible directions and vice versa; server-side subsystem organizes all results and user input into facility database.
  • The Client side of the system includes GUI for facility database plus dynamic textual and graphical reporting tools; it was implemented as a Visual BASIC application that was linked through Citrix MetaFrame to server side COM DLL and using COM API of ActiveReport and ATS Mozaik for textual and graphical (vectors, 3D modeling & CAD) reporting.
The Donath Group, Inc.
Apache, PHP, CPanel, WebHost Manager, Visual Basic, ASP, PHP, JSP, MySQL, VBScript, JavaScript, DHTML, CSS, XML, CGI, Perl, COM, ActiveX, Acrobat PDF/FDF, Flash MX, ActionScript, Adobe SDK, Jabber, SSL.
  • Web design, development and deployment.
  • Workflow automation development.
  • Network security (VPN, Firewall and Router setup, configuration and monitoring).
  • Web mastering.
2000 - 2001, Senior Software Engineer, VistaPrint.com
(IIS, ASP, VBScript, DHTML, JavaScript, Visual Basic, ActiveX, LEADTOOLS, Adobe Applications API and SDK)
  • Web Application development for graphic image and document processing and conversion automation.
  • Web Application User Interface Framework development.
  • Designed and implemented cookie encryption/decryption cipher to secure user connection to web server and protect, customized and managed users' settings and user's identity on web server side.
1998 - 2000, Software Engineer, Marketing By Design, Inc. (Workflow By Design, Inc.)
(WebStar, JRun, AppleScript, CGI, DHTML, CSS, JavaScript, Canto Cumulus, FileMaker Pro, Acrobat)
  • Web site and server architecture, web application development.
  • Development of web-based content management system (CMS) with document version control.
  • Development of publishing technologies workflow automation and digital asset management and workflow for fonts and documents.
  • Problem tracking system development and management.
  • Automation of system and network administration. Backup system automation workflow development.
For previous experience see my word version resume.
BACKGROUND
My professional work experience started long time ago. During this time I was involved into many different technologies and development techniques such as:
  • System deployment over any reliable connection, remote boot process control and network management automation, system and network security policy management, system and network remote control and vulnerabilities discovery, cryptography.
  • Design and development for publishing technologies, electronic document management, workflow automation and project management.
  • Training personal and educational software development.
  • Vector and raster graphics design and modeling, PostScript and TrueType font development.
  • Page Layout and Graphics Design.
EDUCATION
MS in Computer Science.
Major Field of Study: Software Engineering and Applied Mathematics.
MIEM, http://www.miem.edu.ru