Rafat Jahan Qayum

8 years of experience in Social Media & Digital Media In-depth knowledge of Campaign Management, Web Analytics, E-mail Marketing, Optimization, Keyword Research and analysis, Business and Competitor Analysis, Content Optimization. Excellent interpersonal, communication and organizational skills with proven abilities in team management, strategy and planning.

Experienced with conducting comprehensive market research to identify trends and consumer behavior. Utilizes strong analytical skills to interpret data and generate valuable insights. Knowledge of advanced research methodologies and proficient in using statistical software for data analysis.

NASSCOM

• Campaign Management- Creating email campaigns in backoffice 1. Each campaign is unique depending on the target audience 2. Campaign naming convention For Each Campaign the appropriate package is selected and added The Assets are added to the package during the package creation process based on the requirements Activation hours and date is added as per the campaign running time and duration start date and end date. All Business Mechanics details are added and list of SKUs from individual buyer tab is added Inform platform team to input setup details Take screenshot of CRM Form Responses for all campaigns for the following week
• HR Trainer (Lotus Interworks)- Worked in recruiting various freelance candidates for a virtual business. Training the candidates on various tasks, via Skype calls Worked productively with the client and team to accomplish milestone. Creating weekly reports and analyzing the candidates performance each week in Excel Reporting Daily, Weekly & Monthly for performance. Handling various Admin tasks, sending emails, generating reports, drafting invoices in PayPal, sending session reminders each day.
• Email Marketing - Create different events and send out emails in MailChimp and Hubspot Using different tools like LeadGrabber and LeadFuze to generate leads and target audience to send emails Linkedin Lead generation for email marketing Compiling list of leads by internet research and sending out marketing emails. Podcast invites for hosting and guest appearance, reaching out to different businesses via emails Using Facebook to compile emails of various businesses to send emails Generate weekly and monthly reporting for all responses and emails sent LinkedIN Lead generation using LeadGrabber and Dripify
• Social Media Specialist – Handling Podcast website in WordPress, Wix, Editorx, Pickmonkey Creating Email Campaigns in MailChimp Creating and editing social media graphics in PickMonkey Managing the podcast guests scheduled in Calendly Responding to messages on LinkedIN and handling LinkedIN page https://www.linkedin.com/company/four-oaks-capital/ https://www.linkedin.com/company/streamline-capital-group/ Web research and creating a list of potential podcast guests and sending invitations Handling YouTube Channel editing videos and clips https://www.youtube.com/@diaryofanapartmentinvestor Instagram Page adding captions and images https://www.instagram.com/diary_of_an_apartment_investor/ Managing google forms with guest responses and scheduling appointments Using Otter.ai platform and transcribing the podcast Using the platform Kapwing to edit videos for social media Handling weekly KPI’s

Banking Analytics  

• Used SQL, Tableau, Power BI, Excel tools to Extract, Transform, and Load (ETL) data, which sample data were collected from the source systems to data warehouse designed to analyze data.
• In this project, we understood the overall distribution of key variables such as loan amounts, interest rates, customer demographics, and loan terms. Statistics, visualizations, and data insights provides an initial understanding of the datasets.
• Customer demographics and loan characteristics can be utilized to segment the customer base into distinct groups.
• Identifying common characteristics and behaviors within these segments help to tailor loan products and marketing strategies. The project's analysis of loan performance over time reveals patterns in loan delinquency and repayment behavior.
• Maintain and update dashboard datasets in Excel, Tableau and Power BI.

Healthcare Analytics  

• Successfully implemented analysis of healthcare( providers and facilities)analysis project focuses on providing a comprehensive understanding of the distribution, types, and characteristics of hospitals in a specified geographic area. The analysis encompasses various dimensions to support informed decision-making and strategic planning within the healthcare sector.
• clean the data in excel, merge it and use for visualization.
• Use page navigation for Excel dashboard, it contains 3 main pages which shows the insights of patients summaries.
• Built interactive Dashboard using Excel, Power bi and tableau.
• This dataset contain providers and facilities information help to identify the various patients summaries, chain of organization ,avg mortality rate ,top 10 dialysis station by state and many other kpi.

E-COMMERCE OLIST STORE ANALYSIS 

• • We leveraged a variety of Excels 3 analytical features, such as pivot tables, charting, and statistical functions, to explore the data and derive initial insights that informed subsequent data analysis and modeling activitiesUsing Python Libraries such as Pandas, Numpy, Matplotlib, Seborn.
• • We utilized advanced MySQL querying techniques to extract and analyze the data.
• • Team leveraged the advanced visualization capabilities of Power BI and Tableau to present critical data insights in a visually compelling and easily understandable format.