Arts and Craft
Susmita Dutta
Research Associate
Kolkata,WB
Summary
Meticulous and analytical Data Analyst with 1 year 8 months of educational and hands-on experience in MIS reporting, serving major FMCG clients, with proven ability to drive process efficiency and data integrity. Adaptive team player with in-depth knowledge of serving major clients, providing business insights using Advanced Excel, Power-BI, VBA, PowerPoint and Nielsen Answers Desktop, adhering to quality. Enthusiast and numerate, looking for upskill of knowledge. Proficient in Advanced Excel, Power BI, Tableau, Python, VBA, SQL.
Overview
3
3
years of professional experience
8
8
years of post-secondary education
8
8
Certifications
3
3
Languages
Work History
Research Associate
NielsenIQ
Kolkata, West Bengal
02.2020 - Current
- Streamlined research processes to meet tight deadlines for multiple projects.
- Extract and wrangle data from Nielsen market databases of FMCG clients using in-house BI tools, Nielsen Answers Desktop, Power BI, Advanced Excel,Microsoft Powerpoint, Dipe to generate optimized automated reports and dashboards. Perform automation tasks using Excel VBA macros.
- Provide coherent and visually immersive Business Insights using Power BI.
- Provide interactive visual analytics in the form of dashboards using Tableau.
- Extracting data from external databases using queries.
- Generate optimized graphical presentations using Microsoft PowerPoint.
- Provide various analysis such as Competitive Analysis, Distribution Analysis, Time Series Analysis through compelling visualization to enhance business decision making using Microsoft Excel, PowerPoint and in house BI tools like Ad hoc Web and Connect Express.
- Gathered, arranged and corrected research data to create representative graphs and charts highlighting results for presentations.
- Validated incoming data to check information accuracy and integrity while independently locating and correcting concerns.
- Developed macros, special formulas and other actions to produce reliable and consistent statistical reviews.
- Collaborated with team members to initiate best practices to achieve organizational goals.
- Deep understanding of client’s business requirements and provide them with suitable products to match their needs.
- Co-ordinate and communicate with Client team and Report Liaison on multiple projects through Salesforce.
- Manage Report Development and Change Management activities for assigned Countries/Clients.
- Efficient and thoroughly well versed in communications across global client service teams and report liasoning. Currently operating for UK, Sweden, Belgium, Netherlands, Norway, Ireland and Spain.
- Currently managing over 20 deliveries for various FMCG clients each month.
- Responsible for maintaining and updating Content Folders.
- Ensures customer requirements are understood, achievable and leading to sustainable BAU operations.
- Create well organized documentation/instruction manuals for hassle-free deliveries in each cycle.
- Facilitate seamless deliveries while maintaining strict deadlines, adhering to quality.
- Active member of Employee Resource Groups- "Diversity and Inclusion" and Women in Nielsen".
Educational Content Manager
Utkarshini Edutech
Remote, Work From Home
11.2018 - 01.2020
- Managing and optimizing educational content.
- Conducted Online classes for python programming.
- Live interaction with learners.
- Collaborated with marketing and design teams to develop and plan site content, layout and style.
- Managed content distribution to online channels and social media platforms.
- Approved, reviewed and edited all content flowing to website, approving over 20 pieces of content per week.
Technical Content Writer Intern
Codebrink
Remote, Work From Home
03.2019 - 05.2019
- Used coordination and planning skills to achieve results according to schedule.
- Utilized exceptional writing, editing and proofreading skills to produce engaging and error-free content.
- Completed thorough research into assigned topics.
- Evaluated project requirements and content standards for each project to produce copy in line with creative structure.
- Wrote and edited high-quality content and visually impactful programs under deadline pressure with exciting, captivating and authentic approach.
Teaching Assistant
Utkarshini Edutech
Remote, Work From Home
08.2018 - 11.2018
- Imparted lessons on Python Programming Language.
- Assisted teachers with classroom management and document coordination to maintain positive learning environment.
- Set up visual aids, equipment and classroom displays to support teacher's lesson delivery.
- Optimized learning plans and quantified student progress through test administration.
- Collated classroom materials to help teachers prepare for daily instruction and activities.
Education
Data Science And Artificial Intelligence - Data Science, Data Visualization, Machine Learning
IVY Professional School
Kolkata 07.2019 - Current
Bachelor of Science - Physics, Mathematics, Electronics
University of Calcutta
Kolkata 08.2013 - 08.2019
Skills
Advanced Excel
MIS Reporting
Microsoft Powerpoint
Microsoft Power BI
Python Programming
VBA
SQL
Research and analysis
Quality assurance controls
Technical Writing
Reporting Requirements
Tableau
Data quality assurance processes
Accomplishments
- Project Coordinator for Monster Key Performance Reporting Project.
- Involved in an ongoing pilot project for the International Market, involving smooth transition of BAU process for a total of 180 reports(simple and complex) of major FMCG clients.
- Involved in ongoing projects of FMCG clients, involving Multicountry Top Categories Monthly Trended View and Key Performance reports using Power BI and Microsoft Excel.
- Made automated Quality Checker files for critical reports of Unicharm using Custom Excel and VBA Macros.
- Collaborated with team of 5 in the development of Feasibility for changes in 16 Unicharm Feminine Care reports involving East Asian Countries.
- LinkedIn Skill Assessment Badge in Advanced Excel and SQL.
Certification
Alteryx Workshop, IVY Professional School
Interests
Photography
Travelling
Gardening
Timeline
Alteryx Workshop, IVY Professional School
05-2021
Power Pivot Workshop, IVY Professional School
05-2021
Power Query Workshop, IVY Professional School
05-2021
Research Associate
NielsenIQ
02.2020 - Current
SQL, Digital Vidhya
12-2019
Data Science And Artificial Intelligence - Data Science, Data Visualization, Machine Learning
IVY Professional School
07.2019 - Current
Advanced Java(Servlet and JSP), NIIT
05-2019
Certified Technical Content Writer, Codebrink
05-2019
Programming In Python, NIELIT
04-2019
Programmimg With Python, Internshala
04-2019
Technical Content Writer Intern
Codebrink
03.2019 - 05.2019
Educational Content Manager
Utkarshini Edutech
11.2018 - 01.2020
Teaching Assistant
Utkarshini Edutech
08.2018 - 11.2018
Bachelor of Science - Physics, Mathematics, Electronics
University of Calcutta
08.2013 - 08.2019