Fabian Pustelnik

Fabian Pustelnik Argentinean Phone/Whatsapp - email:-– Telegram: @fpustelnik Professional Summary Analysis and implement solutions to improve the performance, usability and information of data-driven, web-based, multi-requirement information systems Professional Experience Business Oriented System Architecture and Web Applications Development Critical Information Flow Analysis in order to define and implement resources and capabilities using cutting edge technology to create and improve functionality through data availability and sharing and/or process optimization. Functional and Technical research. Critical path and resource analysis. Business, functional and technical specs writing. System architecture, design and implementation Train personnel in the use of new technologies. Internal Management Information System and Quality Assurance Improve key procedures and information gathering to present better decision tools to the management, setting controls in place for quality control and assurance. Research key procedures and flow of data. Identify points of quality control and assurance. Produce reports for the management to allow better decision-making procedures. Database Development, Management, Analysis and Mining Design, optimize and manage databases to improve the quality of the information, allow for fast data retrieval, better analysis, mining capabilities and transactional procedures. Database architecture. Performance tuning. Transaction (OLTP) and Cube (OLAP) systems. Queries, Stored Procedures, Batch development and optimization. User Interface Design and Programming Design and program the usability procedures for the different layers and functions, considering information needs, procedures and security. Usability assessment. Security assessment. Management consultation to improve the use of information. Thin client-server interface programming. User Interface programming using Cold Fusion MX, Phyton, DotNet, JavaScript, PHP and other languages. Facebook and Google API programming and integration. Project and Clients Note: Due to the confidential and/or private nature of many of my projects only front ends are showing their web addresses. I can set up a videoconference tour if interested in seeing back ends that requires login. Fort Systems (800wine.com) Optimize and re-architect a CF9 system and MS SQL 2008 DB that holds 23+ point reward sites (RCI, VacationRewards, Wine.com, etc) and implement e-communication and automation with clients, providers, warehouses, end-users, shipping companies, logistics, payment processors and accounting systems. Design, code and test webservices both consuming and delivering. Write functional and technical specs to migrate the system to a new hardware infrastructure, implement CF10 and OOP, a new APP and CFC session and client based model, different security and faster performance. Implement gAnalitycs, social marketing and demographics measurement. Discuss with management, implement requirements, suggest models. Lead a team of programmers delivering milestones over a 12 months project. QA and troubleshooting system implementation. Set a new model for continue developing and training in the new backend administratration. Implement clean-up routines and install all components on the new hardware. Loppex (live.loppex.com) Prepare a financial bidding and share sales system for production. Lead an existing team of developers in optimize, re-architect and fix bugs of a financial application to make it ready for production. CF 9, mySQL and msSQL on Windows 2008 and Linux platform. DB optimization, securing web services, CF security and code optimization, installation, document the system and the installation steps. Load testing and user tracking implementation. Maple Street (www.maplestreetinc.com) Create and implement a banking risk rating system, including file manager for contracts, processing and digitalization. Security system for files, Cold Fusion programming, data base design, stored procedures coding and business logic implementation. Intranet. 1st Security USA (www.1stsecurityusa.com) Design and implement a Customer Management Record System to manage sales, from leads to customers, including phone calls, security system design, parts and pricing, Transunion credit check integration via API, Credit Card Processing and Docusign dynamic document generation and signature. Datebid (www.datebid.com) Architecture and planning. Database optimization. Stored Procedures and maintenance plans. Cold Fusion coding and various Facebook API implementation (oAuth 2.0, Graph, Canvas). Amazon AWS storage and retrieval implementation. iPhone API and System Routines. -SIlkRoad (www.silkroad.com) Coding on various versions of the site, implementing dynamic translation tags, SQL Stored Procedures, Coldfusion tags under Fusebox 5. Asset Oversight (www.assetoversight.com) WhitecapAdvisors (www.whitecapadvisors.com) Login Required for most parts. Specs, database design and SQL / Cold Fusion coding. Design & implementation. Report system that exposes financial information. Data warehousing, filters, chart, sorting capabilities, dynamic formulas & data types, aggregation and segmentation. Rabbi Fohrman (www.rabbifohrman.com) API integration with Google Maps & Google Calendar. Cold Fusion sections in front end. Complete backend & database. The Salty Dog (www.thesaltydog.com) Back end system to update listing. Consume and process xml feed via webservice to automatically update listings from different providers. 21st Century Fox – Fox Home Entertainment Contractor. Telecommuting Architect and develop an E-CRM system to allow data collection, mass communication, OLAP analysis and campaign planning and deployment across the Fox Home Division websites. Requirements, planning and architecture for an E-CRM system. Develop a database that currently holds 300,000,000 records without degrading performance. Consult with the management and program the user interface for deploying campaigns. Design and program the reporting interface including OLAP capabilities to run campaign analysis. Design and program a system to deliver secure video streaming over the Internet using latest encryption technology. Used MS SQL 2000, MS SQL 2000 Analysis services, ASP, Cold Fusion, Windows Media Services, IIS 5 and COM objects. Sony Contractor. Telecommuting Re-architect, design and develop their public site and private intranet to match the requirements of a multi-country operation. Set up requirements and goals with the client. Design and program the public site: http://www.sdds.com Adjust the documentation they use to match the requirements across branches. Develop and set up a system where different offices can upload data and synchronize information. Program the back end, user interface and reporting system to support data sharing and fast-decision taking between multiple countries. Integrate with MS Word, Acrobat PDF and MS Excel to import and export data. DCOM objects to dynamically read/update data across Microsoft Desktop Programs Altus Learning Systems http://www.altuscorp.com Contractor. Telecommuting vProject 2.0 Functional specifications, database design, back and front end and implementation of their Project Management System. Interact with project managers and develop the functional specs. Implement and train people in use a video/audio conference technology to maintain weekly meetings with the technology team. Design the system, security model and choose the technology. Implement the database, triggers, stored procedures and DTS packages on MS SQL 2000. Design and code the back and front end in Cold Fusion 5 QA, bug tracking and adjustment Final Deployment vProject 3.0 Adding functionality for the new version. Develop a reporting module, capable of reporting automatically from any database view, schedule and email reports. Adding security to provide reports by clients. Added a survey system to track client satisfaction. Added a ‘Templates’ sub system to have projects pre-built and apply to current projects, lowering times to design a project schedule. Added security, new users types, email notifications and automatic status changes to projects and tasks. QA, bug tracking and adjustment Final Deployment vProject 4.0 and 5.0 Adding functionality for new versions. Based on client and user input, develop new specifications, interact with marketing people, generate agreements and arrive to final specs. Update the system to new CF versions, adding new functionality, upgrade to new MS SQL versions, coding, installing, training, QA’ing and write online help files. vPortal 2.0 Research, design and implementation of a Video Hosting Solution oriented toward giving the client a Portal to show Real and Windows videos and a back end to track video usage. CFMX and MS SQL. Gather requirement from directors, marketing, managers and technical people. Prepare the functional specification. Research available products. Implement the complete system, including Database: design, implementation, DTS and Stored Procedures Log parsing: automated routines to parse Real and Windows servers logs UI: front-end, security and administration Reporting: tabular and graphical. OLAP Reporting: create cubes, displays, graphic displays and web based pivot tables. vPortal VS Developed a stand alone application based on the vPortal 2.0 model CFX_ValidateURL Tag to download the first 200 bytes of a given URL and check if URL exist or what type of error the server returns. C++ CF_WMData Tag to return the duration and bit rate of a given media file, using the Windows Media Player COM+ methods. Doha Bank Private Intranet Contractor. Telecommuting. Business logic and technical consultant. Functional and technical specifications to comply with government laws to allow flagging and searching suspicious wire transfers both in real time and over a past period. Database design, coding, installation, maintenance and updates. Assistmed http://www.assistmed.com http://www.dictaide.com Contractor. Telecommuting. Senior Consultant Develop their web strategy and programming their database, website, business logic, gateway, HL7 connection and integration with other clients and vendors. Dictaide is a transcription system that interacts with PDA’s and Cell Phones through MMS and CF7 Gateways, and allows for dictation on mobile devices as well as on and off line, remote transcription, e-signature and approval. Write requirements, system design, and functional and technical specifications. Database Design, stored procedures and complex queries. Lead a group of programmers Install HL7 software Develop HL7 software to communicate to clients and vendors Co-Developed a dot.net in C# application for dictation, audio tagging, demographic searches and edition of documents. Create and configure gateways for MMS and Sockets communication. Design XML and Web Services for a complete flexible interaction with Client-Defined demographic fields. Programming the administration, user interface and front end Programming the client site, transcriptions site and administrative site. Writing specs for standard integration through web services with providers and vendors. Lead a group of 4 programmers. Coding. Integrating. Quality assurance. UCLA – Philosophy Website Contractor. Telecommuting Develop the informational intranet for the department of philosophy at UCLA. Write requirements and system design. Develop the database to support personnel updates; faculty and alumni mail system and communication between departments. Program the administrative and front-end (http://www.humnet.ucla.edu/humnet/phil/) interface using PHP and mySQL UCLA – ISECS Website and Backend Contractor. Telecommuting Conference Site Allow scheduling of conference meetings and conflict checker by time or room. Front End: Design and display Back End: Routines to enter time/room/speakers and to check and resolve conflicts Front End can be seen at: http://www.isecs.ucla.edu/ UCLA – SASS Website and Backend Contractor. Telecommuting Generalize the conference site to be used for other departments. Creating a master holding database and transforming the system in an ASP model. UCLA – ISSECS Website and Backend Contractor. Telecommuting Website and Backend Citic Bank Private Intranet Contractor. Telecommuting Adapting Doha Bank System. Training. Coding changes. Database design, coding, installation, maintenance and updates. Online Corporation – Hosting Provider Contractor. Telecommuting Develop various projects for their clients Database design and Cold Fusion programming for TVA Club (http://www.tvaclub.biz) Database design and Cold Fusion programming for Mystical Vacations (http://www.mysticalvacations.biz) Database design and Cold Fusion programming for 500Promotions Database design, web services, XML, components and Cold Fusion Programming for Surftix (http://www.surftix.com) Dynaprice Contractor. Telecommuting. CF_Prettify Develop a tag to parse mainframe text and data into human readable form Senior Consultant. Develop various aspects of their system integration including Paypal gateway, Authorize.net gateway, ordering, credit card processing. Business logic, technical specifications, database design and programming, Cold Fusion coding. Worxs http://www.worxsystems.com Consulting. Telecommuting Develop a Retailer Point-of-Sale System for this company in a team with 3 other programmers. CFMX, Dot.Net and MSSQL. Database Design Technical specifications Consulting with client and retailers Coding in MX and dot.net. Creating the scripts for automatic deployment and configuration in client’s servers. Testing and QA Deployment Developing a tag to communicate with Experian to pull reports and report back to their legacy system in CFMX and XML Systrackinc (http://www.systrackinc.com) Consulting. Telecommuting Concept, architect and lead a team of developers to build a complete interactive system to perform database analysis on OLAP and OLTP servers. Consultant for this company since 1998. Optimize client-server technology across the system. Develop re-usable code to improve developing speed. Optimize and tune database. Develop an interactive help system. Leading and mentor their team Write installation and configuration procedures. Integrate with external technologies (Sybase, Java Chart, Flash Maps) MX Chart Server Developing the specs, Cold Fusion MX Components and .Net Web Services section of a Flash MX Chart Server Hunter Group (http://www.huntergrp.org) Consulting. Telecommuting Senior Consultant for this holding of 9 companies. Developed their whole web strategy as well as their sites, back ends, administrations, and information flow system. Hunter Group (http://www.huntergrp.org) Flash Front End Administration including Accounting System Hitech Security (http://www.hitechsecurity.us) Developed the concept for an Artifical Inteligence security system Implemented image-processing routines Scripted actions on triggers Developed wireless connection methodology for self standing units AsoSports (http://www.asosports.us) Coordinating and developing a nine region site devoted to sports Front End and Back End Dynamic generation and creation of pages Database design Resources & Technology (http://www.resntech.com) E-commerce site Vendors integration including Ingram Micro, Tech Data, Aczerty and others Order Placement Credit Card Processing Accounting, Administration & Order Processing Developing of a state-of-the-art artificial intelligence surveillance system using Visual Basic. Managing a group of 3 programmers. Designing specs, both hardware and software, interfacing with high resolution cameras, developed algorithms to detect intrusion and transmitting images over the web. Other Clients and Sites Coordinize, Inc Concept, Functional specs, design and develop. Trillium (an Intel Company) Develop a mining model; integrate five different db systems, servers’ optimization, support and training. EduAdvantage, LLC Complete e-commerce site. Front and Back End Jewelry Brazil Jewelry e-commerce site and administration. Iposcan Complete Site and Agent. Pets.com DBA work. Performance optimization and stored procedures. SheepskinExperts.com Design and developed full e-commerce site AlmackLiners.com Design and developed full e-commerce site City Scuba.com Design and develop Fonts4Teachers.com Design and developed this full e-commerce site. Cleargreen Design, developed and maintain front and back end. WorldSite Networks – ISP 7 projects for various clients Slevin Industries – ISP 9 projects for various clients AdvancedSteel.com Complete front and back end. Auction system. Client security. SEI Consultant 3 projects for various clients California Credit Union League Re-engineering their back end. Dr. Soda SiteStars.com American Pacific College Imagencard Bahurang Skills Expert: Coding Cold Fusion, Ralio, Phyton, AJAX, Javascript, JSQuery, HTML5, Ruby on Rails, SQL, NoSQL, Facebook, Google, Amazon AWS, Cloud Implementation. Frameworks. RAD. SourceControl. OOP. Segregation. Inheritance. Security and Advanced Security. Server Installation and configuration Server tuning and optimization. Databases: MS SQL, MySQL and NOSQL: Database Design and Architecture. Complex queries. Stored Procedures. Functions GeoLocation XML Queries Database Tuning. Performance analysis and reporting. OLAP Server installation, configuration, maintenance and performance optimization. Distributed Queries, linked servers and DTS packages. Automation Web, e-Commerce, Backend, Automation: Client Interaction, Functional and Technical specification writing. Back End and Front End design. UI centrix designs. Scripting, Database. API integration. Rest. SOAP. Web Services as consumer and as provider. Documentation. Security. Encriyption. oAuth. Others. Credit Card Processors and Gateways implementations Shopping Carts EDI interaction with Legacy systems. Cross browser compatibility POP, SMTP and exchange server integration Data Scrapping. Data mining and Ad Serving technologies. Audio and Video Technologies: Codecs Compression. Format conversions. Post Production. Platform delivery. Streaming. Distributed Streaming and delivery. Encoding for multiple platforms and/or bandwidths. Education 1983 - 1987 University of Technology Buenos Aires, Argentina BA Computer Science 1977 - 1983 ORT (technical high school) Buenos Aires, Argentina Specialized in Computer Systems Other Entrepreneurial. Fast thinker. Self-learning. Team player. Spanish and English fluent. Good communication. Creative. Love challenges. Work without supervision References Available upon request.