Subham Roy

Business Analyst

Kolkata, West Bengal, India6 yrs 11 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

4+ years in digital and media analytics.
Proficient in SQL, Python, and Power BI.
Experience in managing large-scale marketing data.

Stackforce AI infers this person is a Data Analytics Professional with expertise in SaaS and Digital Marketing.

Contact

subham.roy@thesmartcube.com LinkedIn

Skills

Core Skills

Data AnalyticsDigital AnalyticsWeb Application DevelopmentMachine LearningRecruitmentTalent Acquisition

Other Skills

Applicant Tracking SystemsAzure Data FactoryAzure Data Lake ServicesContract RecruitmentDatabricksJavaJobDivaLinkedIn RecruiterMarketingMarketing AnalyticsMicrosoft OfficeMicrosoft OutlookMicrosoft PowerPointMicrosoft WordPower BI

About

Experienced Analytics Professional with 4+ years in digital and media analytics, focusing on data processing, transformation, and visualization for large-scale marketing data. Proficient in SQL, Excel, Python, PySpark, and Power BI, with hands-on experience using Azure Data Lake, Data Factory, and Databricks to manage and analyze data from multiple digital platforms. Completed my Post-Graduation in Data Science from Praxis Business School and Graduation in Electronics and Communication Engineering from West Bengal University of Technology. Before my Post-Graduation I had nearly 2.5 years of experience in hiring Technology, Data Analytics and Program Management professionals for Microsoft, Accenture, and other top clients of USA.

Experience

6 yrs 11 mos

Total Experience

2 yrs 3 mos

Average Tenure

3 yrs 5 mos

Current Experience

Wns analytics

Senior Data Analyst

Jan 2023 – Present · 3 yrs 5 mos · Noida, Uttar Pradesh, India · Remote

The Smart Cube has been acquired by WNS and is now known as WNS Analytics.
Experienced in Digital Analytics with a focus on media data for one of the world’s leading CPG (Consumer Packaged Goods) clients. Proficient in leveraging Azure Data Lake Services and Azure Data Factory to ingest and manage large volumes of media data from a wide range of media connectors, including social media platforms, YouTube, Google Campaign Manager (GCM), Google Analytics 4 (GA4), Amazon, and Walmart. Skilled in processing and transforming this data using Azure Databricks to derive meaningful insights. The processed data is visualized through interactive and insightful dashboards built in Power BI to support data-driven decision-making and performance tracking across marketing channels.

Azure Data Lake ServicesAzure Data FactoryPower BISQLPythonDatabricks+2

The smart cube

Data Analyst

Nov 2021 – Jan 2023 · 1 yr 2 mos · Noida, Uttar Pradesh, India · Remote

Created an end-to-end interactive web-based application (Maintenance Prediction System) providing daily predictions of machine failure based on historical data using multiple ML Classification Models using Python and Streamlit

PythonMachine LearningStreamlitWeb Application Development

Artech l.l.c.

Associate Recruiter

Oct 2018 – Feb 2021 · 2 yrs 4 mos · Noida, Uttar Pradesh, India

Best Achievement: Awarded as the Top Recruiter for the year 2020
Responsibilities:
A LinkedIn Certified Recruiter, recruiting for Microsoft as well as other direct clients of Washington and California.
Clients handled as a Primary Recruiter: Accenture LLP (December 2018 – May 2019) and Microsoft Corporation (May 2019 - Feb 2021).
Clients handled as a Supporting Recruiter: Comcast, Target Corporation, Expedia, Symetra Financial, 343 Industries, Getty Images, Neudesic and Pinterest.
Working on client's IT staffing requirement; complete resourcing life-cycle.
Used JobDiva, Dice, LinkedIn Recruiter, Indeed and Monster for head-hunting of resources for various technologies and skill-sets that includes but not limited to Microsoft Technologies, .Net, Python, C++, C#, SQL, Java/J2EE (Mostly back-end and Full Stack development technologies), and Game Development(Video Games for PC/X-Box/PSP).
Worked on multiple requirements starting from Customer Service Representative, Administrative Assistant, Technical Support Associate to Data Architect, Data Scientist, Java Developer, SDE, Game Developer/Designer, UI/UX Designer and Program Manager/Project Manager.
Worked with multiple Account Managers (both onshore and offshore) to maintain the existing relationships and building new relationships and accounts.

RecruitingApplicant Tracking SystemsJobDivaLinkedIn RecruiterRecruitmentTalent Acquisition

Railtel corporation of india ltd

Summer Intern

Jun 2017 – Jul 2017 · 1 mo · Kolkata, West Bengal, India

Worked as an Network Intern for Railtel Kolkata NOC in Operations and Maintenance Department of Eastern Region

Helping hand katjunagar

Co-Founder

Aug 2014 – Present · 11 yrs 10 mos · Kolkata, West Bengal, India

Started the Non-Profitable Organization and got it registered under West Bengal Govt. (West Bengal Societies Registration Act 1961) and certified by NCC (IIT KGP Division).
Served as a Secretary from 2014 – 2018 and currently working as a Member of the Managing Committee.
Worked on different projects on Children's Development and Welfare both independently and by collaborating with other organizations where we tried to support underprivileged and differently abled children.
Managed and coordinated with a team of 75 members and volunteers.
Current ongoing projects:-
o Skill Development Project for Communicative English in Jharkhali, Sunderban, West Bengal.
o Supporting 3 tribal villages in Shantinketan, Birbhum, West Bengal and a differently abled children school(Bansai Prochesta) in Konnagar, Hoogly, WB with a constant supply of sanitary napkins for the girls and sponsoring sports kits for the Paraolympian players.
(Bansai Prochesta is a small school who is producing talented students who has won medal for India in Paraolympics so we try to support them in all ways so that they can make India prouder.)
o Conduct Cancer Awareness Workshops/Seminars in NCC Camps all over West Bengal in collaboration with Cancer Fight Foundation.