Summary
Overview
Work History
Education
Skills
Profilelinks
Projects
Timeline
Generic

SUJATA SHARMA

Vadodara

Summary

Results-oriented professional with 14 years of experience in operations, transitioning into data analytics, business analysis, MIS, and ESG analysis. Expert in leveraging analytical tools like SQL, Power BI, and Excel to deliver actionable insights and optimize business processes. Passionate about sustainability and ESG, with a strong foundation in financial and operational reporting. Dedicated and adaptable professional with a proactive attitude and the ability to learn quickly. Strong work ethic and effective communication skills. Eager to contribute to a dynamic team and support organizational goals.

Overview

17
17
years of professional experience

Work History

Career Break

08.2024 - Current
  • Focused on Professional Development in Data Analytics: Took a dedicated career break to deepen my expertise in data analytics, enhancing my skills in SQL, Python, data visualization, Project Management, and advanced analytical techniques
  • Engaged in continuous learning through online courses, projects, and practical applications to strengthen my understanding of data-driven decision-making
  • Explored new tools and methodologies to stay current with industry trends and best practices in data analytics

Officer - International Sales

Matrix Comsec Pvt Ltd.
06.2023 - 07.2024
  • In charge of new business development and expanding channel partnerships in domains like Telecommunication and Physical Security (Access Control, Time Attendance, and IP Video Surveillance Solutions)
  • Responsibilities include data mining, connecting, and lead follow-up for prospecting
  • Facilitate partner onboarding and support, coordinate with cross-functional teams, and ensure qualified partners are added to the CRM
  • Build strong rapport with prospects, research competition, and deliver concise sales presentations
  • Proficient in channel sales, technical advisory, customer relationship management, solution selling, and project management

Operations Executive

Beverage Trade Network
07.2022 - 05.2023
  • Responsible for editing, and posting content on the company websites
  • Having good marketable blogging skills like content marketing, photography, and editing
  • Maximize website traffic by utilizing Search Engine Optimization keywords
  • Having strong knowledge of SEO and SEM tools, Canva
  • Monitoring 20+ website updates regularly
  • Knowing blog maintenance and internal links
  • Having sound proofreading and copyediting skills
  • Assisting in the payment collection for the London Spirit and London Beer competition
  • Timely communication with participants through Email and WhatsApp apps and resolving customer queries and payment collection
  • Updating competition data in Excel daily and submitting a report to the lead

Analyst - TV Content

Tam Media Research Pvt. Ltd.
04.2018 - 06.2022
  • Monitoring the content being telecasted on various television channels and analyzing the content based on various parameters concerning the project
  • Generating TV clips for the monitored content
  • Encoding in English by listening and understanding the news
  • Analyzing the news content thoroughly before coding it
  • Delivering the data within the stipulated time period
  • Analyzing and coding the monitored content in excel spreadsheet as per the client's requirements
  • Responsible for the analysis and coding of regular projects content in various software platforms
  • Actively participating and contributing to all training sessions organized by the management

Office Administrator

L.K. Agency
10.2014 - 11.2017
  • Attending orders from customers for premixes and vending machines via phone, email, or face-to-face and also creating invoices in the company system
  • Checking the payments received from the customers and balancing them against the dues in the system
  • If payment was not received on time then follow up with the customers
  • Filing the sales tax correctly every month after checking entries in company software - Tally
  • Ensuring the smooth running of the office by making the payments on time which are related to office expenses
  • Handling the query of new customers related to vending machines & premixes of Lipton & Waghbakri Brand and also following up on the deliveries on behalf of the customers
  • Responsible for handling all defects-related queries in vending machines and also making sure that the problem is sought out as soon as possible
  • Responsible for placing the orders for Lipton and Waghbakri premixes and vending machines on time with the company

Operations Executive (MTS Division)

Reliance Money Express Limited
10.2010 - 08.2011
  • Maintaining the records of expenses and the audit files for the branch office
  • To tally & check daily cash stock with money transaction
  • Daily maintenance of ET records of agents and mailing them along with money transactions to the agents
  • Providing help as required by the agents to lock the money transaction through their computer system
  • Checking daily records of gold coins stock in the company and recording the transaction with stock
  • Maintaining stock of gold coins based on the budgets
  • Providing gold coins to post offices on their requirements & maintaining that record in the company database

As an Operation Executive

Sunrise Airsea Logistic Company
11.2009 - 05.2010
  • To handle the export department in Mumbai & Delhi
  • If it is by sea, to be coordinated with the Mumbai Office
  • If it is through air, to be coordinated with the Delhi Office
  • To check documents before mailing them to the particular office
  • To coordinate with shipping lines for the rates
  • To verify cargo details
  • To confirm - the cargo was handed over to the shipping lines
  • To provide information regarding their cargo to the clients through mail or telephone
  • To maintain the daily status of the shipment and to report it to the director

GTM Software Client Integration Point, inc.

Sanskar Management Professionals
08.2008 - 01.2009
  • Searching the custom tariff of a particular country or island assigned to us and then providing the details to the client
  • Checking and verifying the custom tariff provided on the company website through the government customs website of the particular country
  • Noting down all the discrepancies in the excel spreadsheet and then advising the Head Office of the company accordingly based on the facts in the spreadsheet

Client Sales Partner

Yes Bank
01.2008 - 07.2008
  • Generating new Business for the bank by meeting new people
  • Meeting with the new clients and providing them with the knowledge about the Bank's product
  • Providing various financial solutions to the clients according to their financial needs by understanding their concerns

Education

Advance Certification course - Data Analytics for Business

IITM Pravartak

IBM Introduction to Project Management -

Coursera

Esg and Climate Change -

University of Pennsylvania

Master of Arts - Education

IGNOU

PGD - Banking and Business Finance

M. S. University
Vadodara

Post Graduate Diploma - Computer Application

DOEACC Society - 'A' Level
Vadodara

Bachelor of Commerce -

M. S. University
Vadodara

Skills

  • SQL
  • Database Management
  • Data Querying
  • Data Manipulation
  • MIS(VLOOKUP,HLOOKUP, Pivot Table)
  • Formulas
  • MS Access
  • Excel VBA - Macro
  • Advanced Excel
  • Power BI
  • Data Visualization
  • Python(Pandas,Numpy,Matplotlib)
  • Analytical Reporting
  • PowerPoint
  • Data Cleaning
  • Data Transformation
  • Financial Analysis
  • Data Analysis
  • Business Process Optimization
  • Reporting Automation
  • Financial Reporting
  • Operational Reporting
  • MIS Reporting
  • Dashboard Creation
  • ESG Analysis
  • Media
  • Dependable and Responsible
  • People Management
  • Innovation
  • Customer Service
  • Analytical mindset
  • Market Research
  • Microsoft Office
  • Problem-Solving
  • Communication
  • Team Collaboration

Profilelinks

https://github.com/sujata0921, https://www.linkedin.com/in/sujata-sharma-6b9a6017/

Projects

BCG Climate & Sustainability Job Simulation on Forage (08/2024)

Completed a carbon emissions analysis simulation for the Sustainability Team, using Excel to calculate baselines and compare data from the CDP database for accuracy., Analyzed and recommended carbon reduction initiatives for Fast Cars to achieve net Zero, considering effective Scope 3 strategies., Crafted clear emails and a presentation to communicate findings and recommendations to the client., Adapted messaging strategies to address investor concerns, aligning with Fast Cars' sustainability goals. 

Tata Consultancy Services ESG Job Simulation on Forage (08/2024)

Completed a simulation involving sustainability consulting for Tata Consultancy Services., Assessed a client's sustainability needs., Completed a comparative analysis of potential TCS solutions., Developed a fitment matrix to present proposed solutions to address the client's needs. 

Cloud Counselage Pvt. Ltd.,- Data Analyst (Internship- Remote)

Data Analyst, Communication, Decision-Making, Data Cleaning, Exploratory Data Analysis, Data Visualization, SQL, Data-Driven Insights, Data Analytics, Self-confidence, Data Validation, Attention to Detail, Databases, Analytical Skills, Data Analysis, Solution-oriented Bank Loan Reports: Excel, Created Excel dashboard on Bank Loan Reports, showcasing key performance indicators (KPIs) of the loan application process and insights into loan data analysis., Features various visualizations including Map Charts, Bar Charts, Line Charts, and Donut Charts. 

Osais InfoByte, Data Analyst, (05/20/2024 - 06/20/2024) 

Customer Segmentation Analysis (Retail/E-commerce): Leveraged Python to segment customers based on purchasing behavior and demographics., Wine Quality Prediction Analysis (Food & Beverage): Developed predictive models to assess wine quality., Fraud Detection Analysis (Finance/Banking): Implemented a fraud detection system using supervised learning algorithms. 

Psyliq, Data Analytics, (05/10/2024 - 06/10/2024) 

Diabetes Prediction Analysis (SQL): Utilized SQL for data cleaning, transformation, and analysis., Employee Data Analysis (Excel): Conducted in-depth analysis of employee demographics, performance metrics, and compensation., HR Data Analysis (Excel and Power BI): Analyzed employee attrition, attendance patterns, and job satisfaction.

Cognifyz Technologies, PowerBi, (05/11/2024 - 06/11/2024) Explored differences in investment choices between genders using Power BI., Developed interactive dashboards and reports.

Mentorness, SQL and Power BI Analysis, (04/21/2024 - 05/21/2024) Conducted in-depth analysis using SQL and Power BI., Presented a comprehensive SQL project on Coronavirus Analysis.

Timeline

Career Break

08.2024 - Current

Officer - International Sales

Matrix Comsec Pvt Ltd.
06.2023 - 07.2024

Operations Executive

Beverage Trade Network
07.2022 - 05.2023

Analyst - TV Content

Tam Media Research Pvt. Ltd.
04.2018 - 06.2022

Office Administrator

L.K. Agency
10.2014 - 11.2017

Operations Executive (MTS Division)

Reliance Money Express Limited
10.2010 - 08.2011

As an Operation Executive

Sunrise Airsea Logistic Company
11.2009 - 05.2010

GTM Software Client Integration Point, inc.

Sanskar Management Professionals
08.2008 - 01.2009

Client Sales Partner

Yes Bank
01.2008 - 07.2008

Advance Certification course - Data Analytics for Business

IITM Pravartak

IBM Introduction to Project Management -

Coursera

Esg and Climate Change -

University of Pennsylvania

Master of Arts - Education

IGNOU

PGD - Banking and Business Finance

M. S. University

Post Graduate Diploma - Computer Application

DOEACC Society - 'A' Level

Bachelor of Commerce -

M. S. University
SUJATA SHARMA