Debashis Mandal

 Name: Debashis Mandal Address: 1 kartic nagar Sarsuna main road, Kolkata -700061, India Telephone: - Email:-Telegram: debashis09 Skype: debashis09 Date of Birth: 15/09/1978 15 years of experience in web development and project management with ZCE certification. Working as a WordPress and PHP programmer for last 10 years. Experience with custom WordPress theme & plugin and custom PHP application development along with knowledge of Payment gateway integration such as PayPal and HSBC Secure Payment etc. Also have knowledge in Linux platform. Total Years of Experience: 15 years Current employer: MailMantra Pvt. Ltd. (Nov 2018 – Present) Previous employer: InnovationStrat Consulting – USA (March 2017 – March 2018) Past employer: Working as freelance web developer (March 2011 – March 2017) https://www.upwork.com/o/profiles/users/~0147d237398a64ea4f/ Past employers: Eslarr Infoservices (January 2007 – December 2008 as project manager), BEAS Consultancy & Services Pvt. Ltd.(May 2006 – January 2007 as senior programmer and December 2008 – February 2010 as project manager), 123india.com Ltd. (April 2004 – May 2006 as programmer) Education B.Sc from Calcutta University in 1999. PG Diploma (Computers) from DOEACC in 2003. Other Qualifications DOEACC O level. DOEACC A level. Projects Project Name: Backend system for members and site admin for MLM businesses. Project duration: Ongoing Team Size: 6 members Project Description: I am working as one of the 4 developers in the team. I have developed multiple websites for MLM companies. I have developed modules (includes set of PHP scripts, MySQL triggers and procedures) for commission calculation distribution, member registration, wallet management by user and admin etc. As system performance and data consistency are the paramount, as developer I always need to keep in mind. For example I use PDO to increase SQL query performance. I use SQL trigger and stored procedure whenever needed to make sure data consistence and DB performance. Project Name: Talking Hens website (https://talkinghens.com.au/) Project duration: 2 weeks Team Size: 2 members Project Description: I worked as the developer for this project. This is made on Woocommerce. I have converted the HTML (provided bu designer) to a custom theme. I also made a plugin here to calculate weight based shipping discount based on product category. Project Name: PatientMD website (https://patientmd.com) Project duration: 1 year Team Size: 5 members Project Description: I am have developed the website for PatientMD in WordPress(PHP). Through this website user will be able to register and login as patient and can search for doctor. Patient will also be able to book appointment with doctor here. Doctor can also check his appointment calendar here and manage the appointments. Clinics will also be able to register here and add doctors. There will be a section called PHR (Patient Health Record) through which user can store and share his/her health records with doctors. The website is developed using Wordpress custom plugin, MDBootstrap framework, It’s using REST API call to connect to backend. Project Name: Rainbow play system website (https://www.rainbowplay.com/) Project duration: 1 Month Team Size: 3 members Project Description: I was amongst the developer for this website. This was bult on WordPress with custom theme, ACF and custom post types. Project Name: The Novak Agency (http://thenovakagency.com) Project duration: 3 month Team Size: 1 members Project Description: I developed and maintain this website for an real estate agent of Dee Why, Australia. The estate agent lists property for sale and rent through site's back end. User can search for property and send enquery. The website is developed using PHP-MySQL, Wordpress custom plugin, Bootstrap framework Project Name: Design Holidays (http://www.designholidays.co.uk) Project duration: 2 months Team Size: 1 members Project Description: I developed this website for a luxury holiday resort company in UK. The website admin can add resort details from back end and manage bookings. User can search for holiday resort and villas and book them. The website is developed using PHP-MySQL, Wordpress custom plugin Project Name: Brighton and Hove Holiday Rental Association(http://www.brightonholidayrentals.org/) Project duration: 3 week Team Size: 1 member Project Description: I developed the website in WordPress.User who lives near to holiday let property and having noise disturbance can search on the site to get number to call to report the issue. A custom made wordpress plugin is used that do the search and allows admin to enter holiday property and contact details. Project Name: My Big Night Out (http://www.mybignightout.co.uk) Project duration: 1 month Team Size: 1 members Project Description: I developed this website for a company that provide accommodation and fun, well organized activities for hen and stag party groups coming to Brighton. User can book hen or stag party activities through the website. And site admin can manage activities and booking through back end. The website is developed using PHP-MySQL, Wordpress custom plugin, Bootstrap framework Some of my recently developed WordPress plugin detail I developed plugin for http://www.millistream.com. User of this plugin can show data retrieved from millistream server using API in widget. This plugin also has setup page there so site admin can set API user name/password and data to fetch etc. For a client of mine I developed a plugin that allows admin to add RSS link to system for processing by custom made RSS parser. It reads the RSS feed and post the info into the wp site. I also developed a WordPress plugin for a client to lock post and pages using user condition such as if user logged in, user age, user country (using IP) etc. This plugin is also compatible with buddyPress. Project Name: The Bomb (https://www.thebomb.co.uk) Project duration: 4 weeks Team Size: 1 members Project Description: I developed the website in opencart for one my clients in UK. The purpose of the website is to list and sale nail polish and other beauty products. Project Name: Deco Art Tile (http://www.decoarttile.com) Project duration: 4 weeks Team Size: 1 members Project Description: I developed the website in opencart for one my clients. The purpose of thesite is to list and sale decorative ceramic tiles. Project Name: Healthy Nails (http://www.healthynails.co.uk/) Project duration: 4 weeks Team Size: 1 members Project Description: Another ecommerce website developed in opencart. The purpose of the site is to list and sale decorative ceramic tiles. Project Name: My Property for Sale (http://www.mypropertyforsale.co.uk/) Project duration: 4 years Team Size: 1 members Project Description: I developed and maintained the website for a real estate agent in Portsmouth, UK. Admin can manage property from back end along with feed management to RightMove, Zoopla, PrimeLocation etc. User can list their property for a fee to be listed on the site. Property from the site is also feeded into other property portals like RightMove, Zoopla, PrimeLocation etc. The website is developed using custom PHP-MySQL Project Name: EstateAgent.me (https://estateagent.me) Project duration: 1 years Team Size: 1 members Project Description: I have developed and maintained the website for a real estate agent of UK. Using this website an estate agent can create & manage properties, chains, sales, rentals vender and viewer details etc. Agent can also manage offer and chain details. Vendor can also login into the system and manage their details, viewings and give reviews to agents. Project Name: Website for School House Books (schoolhousebooks.co.uk) Project duration: 2 months Team Size: 3 members (2 developers and 1 designer) Project Description: This site is for a book selling organization of UK. Admin can upload books information form CSV files provided by a publisher house. Shipping cost can be edited from admin panel. Site admin can view user profile and delete/suspend user. Static page editing can be performed from admin panel. Order management module is there for admin so he can view, process or cancel any order. User can search books by title, author, ISBN or publisher. Books can be added to cart and user can checkout to place an order. All payments are processed by PayPal. There are two type of user on this site i) Trade member and ii) Non-trade member. Trade member can purchase books on credit where as non-trade members need do the payment first before there orders are processed. Role: I am working as the team leader and a developer. Skills used: PHP, MySql, Linux Project Name: Website for Travel-u (travel-u.com) Project duration: 1 month Team Size: 2 members (1 developer and 1 designer) Project Description: This site is developed in CodeIgniter framework. Hotel and travel packages are displayed on the site under national international category. Registered user can book hotel or travel packages in this site. All payments are made through PayPal. Admin can add, edit & delete travel and hotel packages. Hotel and travel packages can be marked as ‘featured’ to be shown on home page. A module to manage all static pages is there in admin panel. Admin can also compose and save/send newsletter. Registered user can write blogs, edit personal information and view booking history from his My Account area. Role: I am working as the developer. Skills used: PHP, CodeIgniter, MySQL, Linux Project Name: Global European Travel web site (globaleuropeantravel.com.au) Project duration: 2 months Team Size: 2 members (1 developer and 1 designer) Project Description:This site is for an Australia based travel operator organization. The purpose of this site is to give information about different travel destinations in Europe. Traveler’s testimonials, blogs and insurance stories (added by admin) are also published on this site. Users needs to register and logged in to post blog or testimonials. Other users can comment on blogs or rate blogs. Admin add destinations and pages under a destination. Admin can also block any blog on the site. There is also a newsletter management section on the admin panel. All static pages of this site can be modified by admin. Role: I am working as the developer. Skills used: PHP, MySql, Linux Project Name: Brain Bashing (brainbashing.com) Project duration: 3 months Team Size: 3 members (2 developers and 1 designer) Project Description:This site is based on wiki.answers.com. In this site anyone can ask, answer to questions to build a knowledge base covering all topics. Admin can add, edit and delete categories and sub categories he can also ask or answer to questions. Categories and subcategories are viewed in tree view in admin section for easy management. Any user can be suspended or deleted by admin. There are modules to manage newsletter and polls. A module for editing static pages on the site is also there in the admin section. Any user can ask question or answer to questions. User can recommend contributor which will increase their trust point. Visitor can also report a question or answer to admin if it is found inappropriate for the site. Admin may delete the question/answer or ignore the request. While asking question or giving answer user can attaché images or videos to explain his question/answer further. Users can discusses a question among them or send it to a friend. There is a tag cloud on this site to show the popularity of categories in users. There is also an AJAX driven widget section in the site from where other site owners can get customized widget o there site to show brainbashing’s question/answers. Role I am working as the team leader and a developer. Skills used: PHP, AJAX, MySql, Linux Project Name: CMS for entopyid Project duration: 1 month Team Size: 3 members (2 developers and 1 designer) Project Description:This is a customized CMS to manage many website with same layouts but belong to different categories. New sites can be included in this CMS and pages for this site can also be created. Admin can customize the color scheme for each site. CMS is at spark.link-metric.co.uk/admin Sites that are controlled by this CMS are given below. Categories     Sites Casino     spark3.link-metric.co.uk Bingo       spark.link-metric.co.uk, spark2.link-metric.co.uk Test         spark4.link-metric.co.uk Role I am working as the team leader and a developer. Skills used: PHP, MySql, Linux, .htaccess Project Name: Great Holiday Rentals (greatholidayrentals.co.uk) Project duration: 2 month Team Size: 3 members (2 developers and 1 designer) Project Description:This sit was for one of our clients who offer a selection of privately owned villas with pools, townhouses, penthouses and apartments for holiday rentals mainly in the Murcia region of Spain. Properties are uploaded by site admin under location and sub-location. From the admin panel of this site admin can control the content of other six sites namely www.holidayrentalscamposolgolf.co.uk, www.holidayrentalslatorregolf.co.uk, www.holidayrentalselvallegolf.co.uk, www.holidayrentalsinturkey.co.uk, www.dolphinresidenceinturkey.com and www.holidayrentalsmurcia.co.uk. Admin is also able to show/hide a property on one or more sites selectively. There is also a module to manage all the static pages of all the sites form the admin panel. Role I worked as the team leader and a developer. Skills used: PHP, MySql, Linux, Project Name: Fine Naturals (finenaturalsltd.com) Project duration: 1 month Team Size: 2 members (1 developer and 1 designer) Project Description:This site was developed using CodeIgniter framework. The client is a Red Bush Mulch seller in UK. The purpose of the site is to show information about the product and sell the same. User can buy the product in desired quantity online. All kinds of major cards are accepted. HSBC Secure payment system is used for CC processing. Site admin can modify product details and shipping cost for different shipping mode. There is also a module for static page management in the admin panel. Role I worked as the developer. Skills used: PHP, CodeIgniter, MySql, Linux Project Name: All Inclusive Kerala (allinclusivekerala.com) Project duration: 1 month Team Size: 2 members (1 developer and 1 designer) Project Description:This site is developed in CodeIgniter framework. Hotel and travel packages of Kerala are displayed on the site. Registered user can book hotel or travel packages in this site. All payments are made through PayPal. Admin can add, edit & delete travel and hotel packages. Hotel and travel packages can be marked as ‘featured’ to be shown on home page. There is a separate section for Hotel with Ayurbedha services. A module to manage all static pages is there in admin panel. Admin can also compose and save/send newsletter. Registered user can write blogs, edit personal information and view booking history from his My Account area. Role I worked as the developer. Skills used: PHP, CodeIgniter, MySql, Linux Project Name: Video selling website ClipDesire (ClipDesire.com) Project duration: 2 month Team Size: 3 members (2 developers and 1 designer) Project Description:This is a site for selling videos. Seller needs to register and login to upload videos in different categories (mpeg, avi etc) along with price and other information to sell. User can search videos by categories or by keywords. Buyer needs to register and login to buy clips. Payments are made by PayPal. On successful payment buyer will have a download link in his ‘My Account’ are to download the purchased clip. Admin will send money of his sold clip to seller’s bank account on the basis on withdrawal request from seller after deducting admin’s commission. Role I worked as the team leader and a developer. Skills used: PHP, MySql, Linux Project Name: Website for Jaital (jaital.com) Project duration: 3 month Team Size: 3 members (2 developers and 1 designer) Project Description:This site is for a tour and transfer operator in Jamaica. Admin will add, edit and delete or suspend tour and transfer detail. User can view tour and transfer details but needs to register and login to book a tour and/or transfer. PayPal is user to receive payment from user. Travel agents can book tour or transfer for others in discounted rate. Admin can get detailed booking report for chosen range of date or monthly. Registered users are provided with My Account area where they can see the booking history or current status of booking, change personal details etc. There is also a newsletter composing & sending and static page editing option for admin Role I worked as the team leader and a developer. Skills used: PHP, MySql, Linux Project Name: Website for professional photographer (Icapturephotography.co.uk) Project duration: 1 month Team Size: 2 members (1 developer and 1 designer) Project Description:This is a site of a professional photographer. From the admin panel site owner can edit the pages with FCKeditor and change the images used in the flash slide show. Role I worked as a developer. Skills used: PHP, MySql, Linux Project Name: Website for Top of The Tubes (topofthetubes.com) Project duration: 1 month Team Size: 3 members (2 developers and 1 designer) Project Description:This site shows top 20 most viewed videos from 13 popular video sharing sites including YouTube, yahoo video, Google video etc. There are scripts which run periodically to parse those sites and fetch the videos. This site has a section to show Top 20 most viewed videos on top of the tubes it self with RSS feed. There are AJAX driven widgets which can be added to one’s site to show top of tubes videos. Role I worked as the team leader and a developer. Skills used: PHP, HTML/RSS page parsing, MySql, Linux Project Name: Website for a school (etbcs.com) Project duration: 2 month Team Size: 2 members (1 developers and 1 designer) Project Description:This site was for a school. Admin can add, edit or delete teacher and school administrative member profile. Admin can also manage the event calendar of the school from the admin panel. Teacher can add or edit announcement to their profile page. Images and events can be added, edited or deleted to teacher’s image gallery and event/assignment calendar. Role I worked as the developer. Skills used: PHP, MySql, Linux Project Name: Website for Attractive solutions (attractivesolutions.se) Project duration: 1 month Team Size: 2 members (1 developers and 1 designer) Project Description:This was a site for one of our Swedish clients who gives advice to the tourists on where to go and where to stay and how to get around and what excursions to make in New Zealand. There is an image gallery on the site which can be accessed from an image map, where the images are displayed under different region of New Zealand. Admin uploads images with description under different regions New Zealand from admin panel. Role I worked as the developer. Skills used: PHP, MySql, Linux Project Name: Redesigned Citizenship Test (redesignedcitizenshiptest.com) Project duration: 1 month Team Size: 2 members (1 developers and 1 designer) Project Description:This site is for an online test. The purpose of this test is to evaluate your general knowledge about the United States. Any one can participate in the test. The result will be sent to the user over his mail. Questions are chosen in random from the database. Admin can add, edit or delete questions/answers from the admin panel. And can also download the users’ mail ids in a CSV file. Role I worked as the developer. Skills used: PHP, MySql, Linux Billigaflygbiljetter billigaflygbiljetter.nu Real-estate agent engine realestateagentengine.com Chester house shares chesterhouseshares.com IT Projects (PERL) Project Name: Maintenance of training networks sites Project duration: May 2006 to Feb 2007 Team Size: 4 members (2 developers and 2 designers) Project Description: The Training Network sells training VCD and DVD on safety and Hr training from their sites www.safetytrainingnetwork.com and www.hr-training-network.com. User can brows products, place order and pay using CC on the sites. Main objective of this project is to merge the above mentioned domains and cart of these two categories for easy maintenance and better user experience. This task involves lots of code/system study and code modification. Role: I am working as the team leader and a developer. Skills used: perl, MySql, Linux Project Name: Website of Eslarr Enterprise (eslarrenterprise.com) Project duration: February 2006 to March 2006 Team Size: 2 member (1 developer and one 1 designer) Project Description: The main objective of the site is to present various products (garments) of Eslarr Enterprise on internet. In this site visitors are able to view products’ image, description and unite prise. User (those are registered) can also submit order through the site. Role: I worked as the developer and tester. Skills used: Active perl, MySql, IIS 6 Project Name: Optimisations of ARTS (Ad Rotation and Targeting System) Project duration: From December 2005 – February 2006 Team Size: 1 Project Description: Target of the project was to optimise the ARTS so that it can serve ads even in very high traffic on the site. I installed and configured apache with mod_perl and made necessary changes in the programmes so that they can be run under mod_perl. The entire system has been optimised to handle high traffic efficiently. Logging system of ARTS has also been changed to log faster. Many new features have been added to the system for comprehensive report generation. Now the system is 12 to 13 times faster than the previous one (conventional CGI). Role: I did the development, profiling and testing (QC) Skills used: mod_perl, apache configuration for mod_perl Project Name: Cricket system Project duration: From July 2005 - January 2006 Team Size: 5 Project Description: Working as developer and tester of a four-member team to develop a cricket system. With this system the users will be able to check the real-time cricket scorecard of one or more on-going cricket match, up-to-date player info, country info, venue info etc. This system has an admin section, which will be used by operator to feed player information, country information, venue information, match referee information etc. to a MySql database. This system has two special admin for real time score entry by operators, sub admin for real-time score entry and main admin for any correction in the already-entered data from sub admin for any on-going match. There is a system for updating the data of player, country, venue etc in their profile tables after one match is over. This programme is to be run from cron every day. The generation section of this system will be responsible for generation of the live scorecard. The generation programme will be on all the servers and will be running as daemon. The programme will access the live score data from MySql database located on another server and generate the scorecard (html page). The programme will generate pages with 30 sec of interval. There will be a programme running from cron to check if the daemon is running or not, if daemon not running the programme will trigger the daemon again. MySql is used to store all the information for this system Role: Developer and testing units Skills used: perl 5, MySql 4.1.11, Linux RH9, BSD 4 Project Name: Some tools for internal jobs Project duration: From April 2005 - May 2005 Team Size: 1 Project Description: Developed some tools to check the e-cards (html pages), which are generated on our local server for E-card service. If any error found this tool is capable of fixing the error in html pages (if possible). This tool can be used to upload the patched cards to remote servers. Another tool was developed to do secure FTP to remote server by using SSH secure tunnel. Role: developer and tester Skills used: perl 5, Linux RH9, BSD 4 Project Name: Special E-card service Project duration: February 2005 - March 2005 Team Size: 1 member Project Description: Worked as the developer of a one-member team. Using this service user can send special ecard for special occasion (e.g. friendship day, Rakhi etc.) to one person with personal messages. Sender and receiver mail ids, ips and date &time are logged. Role: I was working as a developer and tester. Skills used: perl 5, Linux RH9: BSD 4 Project Name: V-day Contest Project duration: From December 2004 - January 2005 Team Size: 2 members Project Description: Worked as a developer and tester of a two-member team in the development of this system. There was a special online quiz contest on greetins.123india.com on the occasion of valentine day. Every day the participants were asked 5 question and they had to answer it within 10 minutes. Any user of our E-card service could participate in that quiz with the card number. There was a scorecard, which was updated in every 1 min to show the points obtained by each user. Flat files were used to store the points and other info Role: I worked as a programmer and tester Skills used: Perl 5, MySql 4.1.11, Linux RH9, BSD 4 Project Name: E-card service Project duration: July 2004 - November 2004 Team Size: 2 members Project Description: Worked as a perl programmer in development of this system for 123india.com. In this service user can view and choose a card from a wide range of ecards for wide range of categories to send it to one or more person by email with personal messages. It works in the following manner. First the cards are fetched from 123greetings' associate page using LWP and parse the pages using HTML parser to get the card images, flash objects, and background images. New html pages are generated with new layout at our servers with those elements. After sending cards by a user the card is saved in our server and a card-id is given to the sender. A mail is send to the recipient's mail id with an URL to view the card. After recipient views the card the sender is informed (optional). All senders', receiver's mail id and ips are logged. Flat files are used to store all the data. Role: I was in working as developer and tester. Skills used: perl 5, Linux RH9: BSD 4 Project Name: News fetch system Project duration: May 2004 - June 2004 Team Size: 1 member Project Description: Worked as the developer, tester of a one-member team in the development of this system. It fetches the asianage.com's news (movie, national, international, sports etc.), parses the html and traverse the links for full stories, fetches the news and generate news pages (in html). The fetch and generation programme run from cron daemon daily to update the news. Have a look at 123india.com's news section Role: I was the developer. Skills used: perl 5, Linux RH9: BSD 4 Project Name: ‘New openings’ section for 123india.com Project duration: April 2004 - May 2004 Team Size: 1 member Project Description: Worked as the developer, tester of a one-member team in the development of this. News about new openings at 123india.com is published in this section (hrd.123india.com). New vacancies can be put there; existing entries can be modified and removed from an admin panel. Flat files are used to store information. Role: I worked as the programmer and tester Skills used: perl 5, Linux RH9, BSD 4