Back to Search Results

Tanul S.

Data Analyst & Email-sms marketing Executive

Commitment
0/ 5
Competency
0/ 5
Reliability
0/ 5
  • Overall Experience: 8 Years  
  • Agile Software Development:
  • Amazon Relational Database Service:
  • API Development:
  • Application Lifecycle Management:
  • Cross functional Collaboration:
+ More

Tanul S. 

Data Analyst & Email-sms marketing Executive

Commitment
0/5
Competency
0/5
Reliability
0/5

Time zones ready to work

  • New Delhi [UTC +5]
  • Mountain Daylight [UTC -6]
  • Central Daylight [UTC -5]
  • Eastern Daylight [UTC -4]
  • Further EET [UTC +3]
  • Greenwich Mean [UTC ±0]
  • Eastern EST [UTC +3]
  • Eastern European [UTC +2]
  • Australian CDT [UTC +10:30]
  • Australian EDT [UTC +11]
  • Dubai [UTC +4]

Willing to travel to client location: Yes  

About Me 

A seasoned professional having done Graduation in BscIT and Post Graduation in PGDBA E-Business with 8+ years of progressive experience all inclusive of several categorie
A seasoned professional having done Graduation in BscIT and Post Graduation in PGDBA E-Business with 8+ years of progressive experience all inclusive of several categories primarily in MIS, Data analysis with proficiency in current relevant tools like Power BI desktop, Advanced Excel, SQL, MS Access, Powerpoint, Salesforce, ticketing tools, to collate, consolidate, process and transform data from multiple sources and analyze, interpret information from multiple viewpoints designing dashboards and visualizations, forecasting, MIS reporting, Problem Solving, Interpersonal skills and Strong work ethics. Digital asset management in organizing, filing, storing digitcal documents folderwise or in online repositories. Online Marketing in executing campaigns through Email and SMS marketing. Web content research in extracting required data from websites and further processing it to excel report , Incident/fault alarm monitoring, creating & executing FaultTickets/Service Orders/caseIDs. Collaborating with cross-functional teams / system owners to accomplish required tasks. Team player, proficient in Interacting with Clients, stakeholders
Show More

Interview Videos

Signup to see videos

Risk-Free Trial, Pay Only If Satisfied.

Portfolios

Data Analyst & Email-sms marketing Executive (WFH)

Website Link:

Role:

  • Preparing comprehensive MIS reports of revenue, leads, sales calls summary by customizing, extracting and exporting data from SalesForceCRM, formatting in Excel and updating to appropriate googlesheets dashboards depicting teamwise, productwise business metrics and analytical insights at r
  • Preparing comprehensive MIS reports of revenue, leads, sales calls summary by customizing, extracting and exporting data from SalesForceCRM, formatting in Excel and updating to appropriate googlesheets dashboards depicting teamwise, productwise business metrics and analytical insights at regular intervals while maintaining process efficiency
  • Creating MIS reports of new leads at regular intervals for Updation in salesforceCRM database by SalesForce team
  • Created SOP documentation of workflow and MIS reports preparing process and maintaining it with latest updates
  • Designing and executing multi-conditional SQL queries to extract criteria-wise customer centric data from multiple tables
  • Executing Online campaigns of product and service through Email and Sms marketing using tools(Sendpulse & Karix)
  • Creating and maintaining the digital content(templates, documents, images) for Online campaigns by consistent down-load, edit and upload to the Online Portal and preparing campaign-wise performance MIS report and dashboards
  • Remained up-to-date on office systems and procedures and functioned collaboratively with various partners
Show More

Skills: SalesforceGoogle SpreadsheetIntegrationsData Profiling

Tools:

MIS & Process Associate

Website Link:

Role:

  • Created Excel based Timesheet and consolidated Projectswise MIS to gauge and depict workforce productivity and performance on regular basis while Consistently communicated in a lucid and effective manner
  • Implemented tasks workflow by creating MS Access repository where records ar
  • Created Excel based Timesheet and consolidated Projectswise MIS to gauge and depict workforce productivity and performance on regular basis while Consistently communicated in a lucid and effective manner
  • Implemented tasks workflow by creating MS Access repository where records are loaded and fetched from and to Excel
  • Created ProjectWise analytical MIS reports with graphical charts displaying count and accuracy of documents processed.
Show More

Skills: MS OfficeData Visualization

Tools:

MIS Coordinator & Powerpoint designer

Website Link:

Role:

  • Created comprehensive Excel MIS with dashboards, pivoTables and graphical charts representing pan-india Client's Mobile-Wallet banking transactions with AccountWise, CircleWise, SegmentWise dashboards depicting the business KPI metrics
  • Converting data into useful information
  • Created comprehensive Excel MIS with dashboards, pivoTables and graphical charts representing pan-india Client's Mobile-Wallet banking transactions with AccountWise, CircleWise, SegmentWise dashboards depicting the business KPI metrics
  • Converting data into useful information by performing various ETL actions such as gathering, cleaning, formatting andsegregation of data and mapping with appropriate attributes; communicating with management, Clients, stakeholders to understand and define MIS reporting and dashboard requirements and maintaining consistency of MIS
  • Creating master Excel dataset by integrating data from files like large csv data files, text files in MS Access by creating and connecting relevant tables by designing or modifying backend SQL queries and querying out the required data by export-ing the file to excel. Compiling and publishing the excel MIS with dashboards to internal, external Clients and stakeholders
  • Collaborating with cross-functional teams/system owners to accomplish required tasks and participating in business meetings and discussions and preparing elegant powerpoint presentations with visuals, charts, shapes, themes
  • Creating, updating, daily, monthly, quarterly and annual MIS reports and dashboards and its relevant powerpoint slides and further highlighting descriptions, insights, KPIs and worked well both independently and in teams
  • Reconcilation of MIS data in co-ordination with pan-India teams and updating data whenever required
  • Creating and maintaining Month-on-Month(MoM) and Year-Over-Year (YOY) MIS and its relevant powerpoint slides
  • Performed analysis by calculating variance analysis, YTD, MTD, LMTD and actual vs target percentages
  • Creating and publishing criteria based ad-hoc and client specific dashboards MIS reports as per the business requirement
  • Coordinating with IT team for updating or modifying the mpesa portal data structure and information as per requirement
  • Organizing and storing digital documents of Onboarded clients by appropriate filing and storing of softcopies
  • Created SOP documentation/powerpoint of workflow and MIS preparing process and maintaining it with latest updates
Show More

Skills: Data MappingData analyticsData Cleansing

Tools:

Freelance Web Research Analyst (WFH)

Website Link:

Role:

  • Conducting Online content research to capture Corporate contacts/ Business information data from specific websites
  • Capturing information like Name, Designation, Geographical location, Contact info and maintaining data in excel table
  • Extracting information from websites
  • Conducting Online content research to capture Corporate contacts/ Business information data from specific websites
  • Capturing information like Name, Designation, Geographical location, Contact info and maintaining data in excel table
  • Extracting information from websites like LinkedIn, Bloomberg, reuters, zoominfo and creating an excel MIS report
  • Organized and prioritized work to complete assignments in a timely, efficient manner.
Show More

Skills: MS Office

Tools:

Dell Technical Support Consultant

Website Link:

Role:

  • Providing technical support for hardware & software faults through calls and emails to customers as per the SOP
  • Creating and maintaining caseIds or tickets and work records in Excel and documenting the fault and resolution details in Excel and Delta CRM tool.
  • Reeceived
  • Providing technical support for hardware & software faults through calls and emails to customers as per the SOP
  • Creating and maintaining caseIds or tickets and work records in Excel and documenting the fault and resolution details in Excel and Delta CRM tool.
  • Reeceived constructive criticism well and turned it into an opportunity to grow and improve
Show More

Skills: CRM

Tools:

+ More

Employment

DataAnalystEmailSmsMarketingExecutiveWFH

2020/10 - 2021/04

Skills: SalesforceGoogle Spreadsheet

Your Role and Responsibilities:

  • Preparing comprehensive MIS reports of revenue, leads, sales calls summary by customizing, extracting and exporting data from SalesForceCRM, formatting in Excel and updating to appropriate googlesheets dashboards depicting teamwise, productwise business metrics and analytical insights at r
  • Preparing comprehensive MIS reports of revenue, leads, sales calls summary by customizing, extracting and exporting data from SalesForceCRM, formatting in Excel and updating to appropriate googlesheets dashboards depicting teamwise, productwise business metrics and analytical insights at regular intervals while maintaining process efficiency
  • • Creating MIS reports of new leads at regular intervals for Updation in salesforceCRM database by SalesForce team • Created SOP documentation of workflow and MIS reports preparing process and maintaining it with latest updates
  • • Designing and executing multi-conditional SQL queries to extract criteria-wise customer centric data from multiple tables • Executing Online campaigns of product and service through Email and Sms marketing using tools(Sendpulse & Karix)
  • • Creating and maintaining the digital content(templates, documents, images) for Online campaigns by consistent down-load, edit and upload to the Online Portal and preparing campaign-wise performance MIS report and dashboards
  • • Remained up-to-date on office systems and procedures and functioned collaboratively with various partners MIS
Show More

MIS & Process Associate

2019/01 - 2019/07

Skills: MS Office

Your Role and Responsibilities:

  • Created Excel based Timesheet and consolidated Projectswise MIS to gauge and depict workforce productivity and performance on regular basis while Consistently communicated in a lucid and effective manner • Implemented tasks workflow by creating MS Access repository where records are load
  • Created Excel based Timesheet and consolidated Projectswise MIS to gauge and depict workforce productivity and performance on regular basis while Consistently communicated in a lucid and effective manner • Implemented tasks workflow by creating MS Access repository where records are loaded and fetched from and to Excel
  • Created ProjectWise analytical MIS reports with graphical charts displaying count and accuracy of documents processed.
Show More

MIS Coordinator& Powerpoint designer

2015/06 - 2017/10

Skills: Microsoft Access ProgrammingData VisualizationIntegrationsData MappingData Cleansing

Your Role and Responsibilities:

  • Created comprehensive Excel MIS with dashboards, pivoTables and graphical charts representing pan-india Client's Mobile-Wallet banking transactions with AccountWise, CircleWise, SegmentWise dashboards depicting the business KPI metrics
  • Converting data into useful information
  • Created comprehensive Excel MIS with dashboards, pivoTables and graphical charts representing pan-india Client's Mobile-Wallet banking transactions with AccountWise, CircleWise, SegmentWise dashboards depicting the business KPI metrics
  • Converting data into useful information by performing various ETL actions such as gathering, cleaning, formatting and segregation of data and mapping with appropriate attributes; communicating with management, Clients, stakeholders to understand and define MIS reporting and dashboard requirements and maintaining consistency of MIS
  •  Creating master Excel dataset by integrating data from files like large csv data files, text files in MS Access by creating and connecting relevant tables by designing or modifying backend SQL queries and querying out the required data by export-ing the file to excel. Compiling and publishing the excel MIS with dashboards to internal, external Clients and stakeholders
  • Collaborating with cross-functional teams/system owners to accomplish required tasks and participating in business meetings and discussions and preparing elegant powerpoint presentations with visuals, charts, shapes, themes
  •  Creating, updating, daily, monthly, quarterly and annual MIS reports and dashboards and its relevant powerpoint slides and further highlighting descriptions, insights, KPIs and worked well both independently and in teams.
  •  Reconcilation of MIS data in co-ordination with pan-India teams and updating data whenever required
  •  Creating and maintaining Month-on-Month(MoM) and Year-Over-Year (YOY) MIS and its relevant powerpoint slides
  • Performed analysis by calculating variance analysis, YTD, MTD, LMTD and actual vs target percentages • Creating and publishing criteria based ad-hoc and client specific dashboards MIS reports as per the business requirement
  • Coordinating with IT team for updating or modifying the mpesa portal data structure and information as per requirement
  • Organizing and storing digital documents of Onboarded clients by appropriate filing and storing of softcopies • Created SOP documentation/powerpoint of workflow and MIS preparing process and maintaining it with latest updates
Show More

Dell Technical Support Consultant

2013/04 - 2013/08

Skills: CRM

Your Role and Responsibilities:

  • Providing technical support for hardware & software faults through calls and emails to customers as per the SOP • Creating and maintaining caseIds or tickets and work records in Excel and documenting the fault and resolution details in Excel and Delta CRM tool. Reeceived constructive cri
  • Providing technical support for hardware & software faults through calls and emails to customers as per the SOP • Creating and maintaining caseIds or tickets and work records in Excel and documenting the fault and resolution details in Excel and Delta CRM tool. Reeceived constructive criticism well and turned it into an opportunity to grow and improve
Show More

Monitoring/Fault Reporting Executive

2008/02 - 2011/08

Skills: Business Activity MonitoringosTicket

Your Role and Responsibilities:

  • Overseeing the daily performance of network systems for any fault alarm on rotational shift basis through RealTime Incident/Fault/Alarm Monitoring application and implementing the Excel MIS by gathering reporting requirements
  • • Creating & executing fault/Incident tickets in Cla
  • Overseeing the daily performance of network systems for any fault alarm on rotational shift basis through RealTime Incident/Fault/Alarm Monitoring application and implementing the Excel MIS by gathering reporting requirements
  • • Creating & executing fault/Incident tickets in Clarity tool and updating entries in Excel depicting area-wise incidents
  • • Creating Excel MIS with KPI graphical charts of captured Network Incident logs and publishing the report on daily basis
  • • Accomplished target based UAT tasks of end user product deliveries by processing and executing service orders in order to examine equipment order sheets in Clarity tool. Worked well independently and with a team to solve problems.
  • • Collaborating with cross-functional teams/system owners to accomplish required tasks at regular intervals • Creating and maintaining specific MIS report with entries depicting area-wise maintainance updates of equipments
  • • Documented SOP alongwith powerpoint slides defining MIS reporting process, technical workflow and maintaining it with latest updates.
  • Remained intently responsive and committed to optimal productivity.
Show More
+ More

Education

2003 - 2006

2009 - 2011

Skills

Agile Software Development Amazon Relational Database Service API Development Application Lifecycle Management Business Activity Monitoring
+ More

Hobbies

Internet Research, Watching Movies & Web Series, Listening Songs, Interacting on Social Media, Stock analysis and trading

Certification

Institutional Training in designing SQL database queries, HTML-CSS web design
CMC(TATA Enterprise)

Preferred Languages

English - Fluent Hindi - Conversational