Tanul S.

Data Analyst & Email-sms marketing Executive

Mumbai , India

Experience: 8 Years

Tanul

Mumbai , India

Data Analyst & Email-sms marketing Executive

8775.96 USD / Year

Immediate: Available

8 Years

Now you can Instantly Chat with Tanul!

Chat Now

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 categories primarily in MIS, Data analysis with proficiency in current relevant tools lik...

Skills

Positions

Data Analysts

Data Scientist

Quality Analysts

Business Analysts

Technical Specialists

Portfolio Projects

Description

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 Show Less

Description

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 Show Less

Description

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 Show Less

Description

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 Show Less

Description

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 Show Less

Description

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 Show Less