SMS marketing platform (web-based portal) to be developed using perl/MySQL to send a customised sms message to a list of delivery mobile numbers along with a mailmerge field if necessary. Key features are as follows:
- Deliverables: Perl code, HTML pages, MySQL database/table schemas
- Perl CGI, using HTML::Template to load HTML pages, DBI for MySQL communication
- Ability to create campaign with a name, description, creator, promo code reference
- Ability to upload/enter delivery list of up to 10000 mobile numbers
- Ability to set delivery from field
- Ability to enter specific message (java character counter needed)
- Ability to 'mailmerge' an additional data field into the message using an appropriate variable name
- Ability to preview SMS's before sending
- Low-level send_sms function will be provided (e.g. send_sms($msg, $to, $from));
- All outbound messages to be checked against STOP/unsubscribed list before sending, details + schema for this MySQL will be provided
- Delivery list to be deduped to prevent multiple messages going to the same recipient during the session
- All messages are sent also to a default test list which is maintained separately
- Full logs of all messages sent and timings to be maintained
- Sending a batch is undertaken by a cron job
- Campaign summary stats page + deeper breakdown stats
Hello.
The project looks like a really interesting one, I would like to participate in it. To assure you that I am the right person to handle it let me say that I have overall 12 years of Linux C/C++ experience, 8 years of Perl / Python Linux shell scripting Mysql and Berkeley Databases. I will be looking forward to hear from you, thank you
Having extensive work experience of over 5 years in PERL, UNIX, Oracle and MySQL with in-depth knowledge in Web Development. Presently serving for a reputed MNC in India and Working as Team Leader for an US based Client in the development and enhancement of a Webportal. Initiating career as a Freelancer and having goals to move with this as a Primary Venture.
In Telecoms, and A Team Leader for Development with 3+ years intensive Perl experience. Perl in CentOS, Windows environments sitting on MySQL, MSSQL, and Sybase databases.
Currently running in production environment similar applications for subscribers in our network.