Prem Kumar

R.Prem Kumar E-mail id :-Objective: A strong data professional with 10+ years of experience in various kind of digital marketing operations and data management operations. Educational Qualification:  Bachelor of Computer Application (B.C.A) – J.H.A. Agarsen Mobile No: College, Madhavaram, Chennai, 60% -  Higher Secondary in S.M.D.P.V.C Hr Sec School, Doveton, Chennai, 70%.  High School in S.M.D.P.V.C Hr Sec School, Doveton Chennai, 67.8%. Passport No: H- Skills: Address: No1, Judge Paramasivam St, Perambur Chennai-600 011 Data Management: MS Office: MS Excel – Data Management(De-duplication, Normalization, Standardization), SQL & MySQL query generation for eCommerce Platform, Lookup, Pivot Table, Functions and Macros. MS SQL Server: Installation, Data Model, Data Management(Import, Export, Backup, Cleansing, De-duplication), T-SQL Queries, Database Administration. Father’s Name R.Rathinam D.C.E, A.M.I.E (Late) Catalog Management: eCommerce Product Catalog Management(Magento, Opencart, Shopify and Online Marketplaces) Digital Marketing: Web Design: Website architecture, Wordpress, Joomla, OsClass, eCommerce(Magento, Opencart, Shopify), Website Builders(Wix, Weebly), Website Management Date Of Birth: 03 Sep 1987 SEO: SEO Audit, Keyword Research, Competitor Analysis, On-Page Recommendations, Gaining Popularity using off-page white hat methods SEM: Keyword Research, Google Ads Management, Ad Copy Writing Languages Known Tamil and English Content Writing: Optimized web content writing, optimized youtube meta information writing, e-Commerce product copy Social Media Optimization & Marketing: Social Media Account Creation(Cover Page, Profile Picture, Custom URL), Account Management(Planning & Updates, Paid Ads) Skills: Nationality: Email Marketing: EDM Design, Landing Page Design, Email Blasting Indian Softwares(Constant Contact, Mail Chimp, Sendy, Mail Marketer and Send Blaster) Designing Software: Adobe Photoshop CS3(Logo Design, Pamphlet Marital Status: Design, EDM Design from Scratch), Basic Video Editing (Youtube Video Married Editor) Analytics Tools: Google Webmaster, Google Analytics, Bing Webmaster Other Skills: Typing Speed – 55wpm, Web Hosting Management(cPanel, Plesk) Strength:  Taking ownership at work  Good in data mining and data management using ms excel & sql server  Good in digital marketing planning and execution.  Practicing yoga Experience: Company: Prem Kumar Online, Chennai (Apr 2018 – Till Date) Designation: Digital Marketing Consultant Responsibilities:  Handling client projects  Lead Generation for Digital Marketing projects (Web design, SEO, Google Ads, SMO, SMM, B2B Database, Product Catalog Management)  Managing client delivery. Company: Yayin Business Services Pvt Ltd , Chennai (Aug 2013 – Apr 2018) Designation: Founder, DM2 Manager Responsibilities:  Handling client projects and a 5 member team.  Data Sourcing – B2B Data using Secondary Research, e-Mail validation, e-Commerce product crawling  Data Cleansing – Scraping, Cleansing & Enrichment(as per the client requirement)  Campaign Management – Digital Marketing, Email, SMS, Social Media Company: CMO Axis Outsourcing Services Pvt Ltd , Chennai (Nov 2012 – Aug 2013) Designation: Process Executive – Database and Research Responsibilities:  Data Management - Cleansing, Standardization etc.  Lead Research - Crawling, Profiling, Validation  Lead Generation - Web, Email Marketing, Mobile Marketing  Region - APAC, EMEA  Projects Handled - 10+ Company: Sakthi Software Solutions Pvt Ltd , Chennai (Jan 2012 – Nov 2012) Designation: DBA Trainer – SQL Server 2008 Responsibilities: Level1 Class:  SQL Server Installation  Disaster Recovery  Security Management  Automating Administrative Tasks Level2 Class:  Monitoring & Tuning the database performance  Troubleshooting & tuning the query performance  Troubleshooting concurrency problems Experience: Company: Redisolve Software Pvt Ltd , Chennai (Feb 2010 – Dec 2011) Designation: Data Engineering Associate Project: DQM ( Data Quality Management) Responsibilities:  Crawling data from various sources.  Cleansing and standardizing the crawled data using MS Excel.  Writing SQL data model and consolidate the cleansed data in SQL table.  Data de-duplication using SQL server  Maintaining master data in SQL table  Data enrichment  Data testing using t-sql queries Additional Tasks for Incentive:  Office administration  Vendor management  Regression testing for web application  SEO audit & competitor analysis Company: Naethra Technologies Pvt Ltd , Chennai (Dec 2007 – Jan 2010) Designation: Senior Process Associate Project: Mango DVM(Digital Vending Machine) Responsibilities:  Process music content into a web application  Quality check by listening the sample  Ripping music files from wma to mp3  Production report maintenance Project: PAN Card Processing Responsibilities:  Process PAN application into a foxpro application  Crop PAN applicant photo using photoshop  Quality check  PAN application & proof verification  Production report maintenance Experience: Project: Facebook marketplace ad posting Responsibilities:  Email account creation  Facebook account creation  Open source proxy server management(Vidalia Bundle)  Posting ads in facebook marketplace for various us cities  Ad posting report maintenance I hereby declare that the above given information is true to the best of my knowledge. Place : Chennai Date : (R.PREM KUMAR)