Pragna Prasad Hiremutt

Experience

• 

  Accenture

  Aug 2014 - Jan 2018

  Data Engineer

  3.6 years of professional experience in analysis, design, development, testing and implementation of business systems for Business Intelligence applications in Health & Public Service.- Building the code with the use of tools like Teradata, Informatica and UNIX.- Creating a source query (SQL), modifying the query, fine tuning the query, performing various logical functions on data sitting in tables and databases using Teradata SQL Assistant.- Working on SQL’s in Teradata Bteq as well.-Using Teradata as the real time source to build source views on multiple source tables and working on transformations through informatica mappings/sessions. Having an extensive hands-on experience in building various informatica mappings like normalizer, router, lookup etc.-Experienced in building shell scripts and using these scripts to transmit (SFTP) output files to various vendors' clouds.-Experienced in building parameters, SQL files, shell scripts, source views using CA tool - Harvest Workbench which is used in integration to informatica.-Experienced in debugging errors encountered in session failures in informatica. - Creating detailed design document/functional document based on the business requirements.- Creating unit test cases and execution of the same. Show less

• 

  SetuServ

  Oct 2015 - Oct 2015

  Freelance Content Writer

  Submitted content for the company's blog entailing various solutions offered by SetuServ. About SetuServ :'We are a team of data scientists, engineers and consultants committed to harnessing the vast powers of machine learning to solve distinct problems. Founded in 2012 and backed by leading investors and industry practitioners, we are experts at combining human intelligence with artificial intelligence to build custom solutions for each of our clients.'

• 

  Biker Soul & Lyphe app

  Oct 2016 - Dec 2017

  Freelance Content Creator

  - Worked with an instagram page about bikes of almost 100K followers- Created written content and helped the instagram page to boost their visibility- My best instagram post garnered 7,122 organic likes- Primarily worked on content that had a unique combination of inspiration and bikes- Simultaneously, worked with another instagram and facebook page which was based on healthcare related solutions (Lyphe app)- Created videos and written content to boost their instagram and facebook page as well Show less

• 

  SD Global Technologies Sdn Bhd

  Jul 2018 - Sept 2020

  - Actively working on B2B lead generation- Responsible for creating & sending bulk cold emails, marketing email campaigns - End to end copywriting of brochures & other marketing collaterals for the company’s healthcare solutions- Directly working with sales and senior management teams (including prominent leaders from Malaysia & India) to chart the continuous progress of sales- Creative strategy with focus on targeting prospects, markets and building sales pipeline - Market research, competitive analysis with rich, useful information to further help perform data-driven marketing - Using previous experience as data analyst to use market research information & create strategies as a backbone for sales team - Tools used : Mailchimp, Hubspot, Trello Show less • Assisting Sales team with crafting tender and proposal documents to initiate a sales pitch to potential clients and customers• Given multiple presentations on SD Global’s products and SMART healthcare solutions to potential clients through our very own ‘experience center’• Have worked with internal team to zero in on a nation-wide SMART healthcare idea to provide as a proposal to Minister of Health• Have contributed immensely towards sales and marketing during APHM 2018 (Association Of Private Hospitals, Malaysia) exhibition held at Kuala Lumpur. A yearly affair, the exhibition helps healthcare companies to gain exposure and traction Show less

  • Email Marketing, Lead Generation, Copywriting & Creative Strategy

    Jan 2020 - Sept 2020

  • Operations Team Lead

    Feb 2018 - Jul 2020

  • Presales Consultant

    Feb 2019 - Dec 2019

  • Business Intelligence Analyst

    Jul 2018 - Feb 2019
• 

  Freelance, self-employed

  Jan 2020 - May 2020

  Data Analyst

  - Completed projects : JAN 2020 - 2 projects FEB 2020 - 1 project MAR 2020 - 1 project APR 2020 - 1 project- Working on mini-projects to perform data extraction, data analytics, data visualization, email newsletter, email infographics, sales pages- Using tools such as Qlik Sense and Tableau to generate interactive dashboards & visualization that narrates a compelling story- Performing exhaustive data research and analytics by applying logic, intelligence, and calculation to data in order to transform the same into readable information that helps businesses with decisions - Helping in plotting trends, and patterns as well as drawing insights - Providing consultation to walk through the requirements & problems at hand to help find relevant solutions- Also helping in creating infographics that represent relevant information in a concise & thorough manner with a good look and feel Show less

• 

  Effortless

  Jun 2020 - Feb 2021

  Marketing Specialist

  Generated a direct revenue from FB ads at ROI of 47% Generated direct conversions from email newsletters Customer segmentation, web analytics, product copywriting, social media strategy, basic data analytics

• 

  Sales Ninja Official

  Feb 2021 - Mar 2022

  Marketing Ninja

  Generated FB leads at ROI of 69% from Aug ‘21 to Dec ‘21Generated a direct sale of RM10,000 from a newsletter (Rs. 1,80,000)CXO Linkedin content, Drip campaigns, FB ad strategy, Zapier, UTM link management

• 

  Albot Technologies

  Apr 2021 - Apr 2022

  Marketing Team
• 

  UrbanPiper

  Mar 2022 - Nov 2022

  Marketing Manager

  - Creation of Data Pipelines from various marketing channels via integration tools - Transformation and wrangling of raw data into structured datasets with Google Sheets query - Building Data Visualization Dashboards in Google Data Studio for various requirements- Maintaining marketing data sanity and troubleshooting on the marketing automation tool HubSpot- Conceptualizing, designing, and launching email marketing campaigns, chatbots, and website workflows using the Hubspot marketing automation tool.- Consulting teams and helping them automate lead data management for various partners by building automated workflows in HubSpot and SalesforceSkills: Google Sheets Query · Google Data Studio · Google Analytics · HubSpot · Salesforce Show less

• 

  Growth Gurus

  Mar 2023 - Jul 2024

  Lifecycle Marketing Manager

  Lifecycle MarketingConversion & RetentionConversion Rate Optimisation Technology expertise (Klaviyo, Justuno, Yotpo, etc.)Data analysis & strategy Client ConsultationCross-functional CollaborationIn Season Jewelry, Epicurean Trader, Enclave Audio, Penn State Industries, Mito Red Light

• 

  DIJGTAL

  Sept 2024 - now

  CRM & Automation Specialist