Camellia Pramanick
Detroit,MI
Summary
Results-driven data professional with a keen eye for detail and a passion for uncovering actionable insights from data. Demonstrated success in utilizing data analysis and visualization tools to drive business decisions and optimize processes. Team-oriented individual with a strong focus on collaboration and adaptability, consistently delivering reliable results in dynamic environments. Seeking to apply my analytical expertise to contribute to the success of a forward-thinking organization.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Junior Business Analyst
Universal Stream Solution, Inc.
04.2021 - 08.2023
- Assisted senior analysts in gathering and documenting business requirements, conducting data analysis, and creating reports
- Conducted user acceptance testing (UAT) to validate software functionality and ensure alignment with business needs
- Collaborated with stakeholders to identify process improvements and recommend solutions to enhance operational efficiency
- Contributed to the development of training materials and provided training to end-users on new software and processes
- Assisted in maintaining documentation of business processes, data dictionaries, and system configurations
Business Development Executive
Universal Stream Solution, Inc.
04.2019 - 03.2021
- Developed and executed a comprehensive sales strategy, resulting in a 40% increase in new client acquisition within the first quarter of 2020
- Collaborated with cross-functional teams to identify key pain points for potential clients, resulting in a 30% increase in successful sales pitches
- Created and managed a database of potential clients, resulting in a 15% increase in sales conversion rate
- Developed and implemented a lead generation strategy that increased qualified leads by 10%
- Developed and maintained strong relationships with key stakeholders, resulting in a 20% increase in customer loyalty
- Established and maintained relationships with potential investors, leading to an average investment size increase of 20%
- Identified and pursued new business opportunities that resulted in a 40% increase in revenue for the company
Education
Master’s in Applied Data Analytics -
University of Detroit Mercy
Detroit, MI12-2025
Bachelor’s in Commerce -
Deen Dayal Upadhyaya Gorakhpur University
04.2018
Skills
- Microsoft Excel
- SQL
- Python
- Power BI
- Tableau
- PowerPoint
- Statistics
- Agile Methodology
- Analytical Skills
- Requirement Analysis
- Management Skills
- Excellent Communication Skills
- Project Management
- Client Relationship
- Project Presentation
- User acceptance testing
Accomplishments
- Managed and coordinated National Level Technology Fair of Prime Minister’s DIGIDHAN MELA, Gorakhpur (01/17 - 03/12)
- Practicing and Conducting SAHAJAYOGA MEDITATION (09/12 - Present)
- Conducted several self-realization programs and stress management sessions in corporate sector as well as in masses in many places throughout India.
- Worked towards social services via NGO Prayatna Foundation.
- Women Empowerment through the distribution of Sanitary pads in rural areas via NGO Prayatna Foundation.
- Awarded First Prize for Singing Competition in 'Swar Sangram 2016' in the state level.
- Awarded as The Best Student Overall in the college for my utmost performance in the study as well as the cultural programs and fests.
- Also been Miss Farewell 2018 for my overall performance.
Projects
1. Financial Data Analysis of the Western Countries:- (Performed analysis on Financial Countries dataset using Excel, SQL, Power BI & Tableau).
- Data Cleaning & Statistical & Graphical Analysis using Statistical Tools.
- Designing parameters & creating a database using SQL for the construction of the database table along with its verification.
- Importing the data in Power BI from SQL Database.
- Performed Data Cleaning along with other operations using query editor, creating measures in order to make an interactive visualization.
- Creating a detailed & interactive dashboard by using Power BI to find answers for Yearly Sales, Country wise sales, Top & Bottom performing countries, etc.
Technologies Used: SQL, Python, Power BI.
2. Power BI Product Sales Analysis using Power BI:- (Performed analysis on Product Sales and Customers dataset using Power BI).
- Importing data in Power BI from JSON Database.
- Performed Data Cleaning along with other operations using query editor, creating measures to make an interactive visualization.
- Taking insights from the graph plotted and doing data analysis by creating a detailed dashboard for the data visualization.
- Creating a detailed & interactive dashboard by using Power BI to find answers for Yearly Sales, Country wise sales, Top & Bottom customers, etc.
Technologies used: Power BI
Hobbies and Interests
- Practicing SahajaYoga Meditation.
- Exploring new places and adventures.
- Creating social media contents.
- Exploring new digital contents and binge-watching digital shows.
- Singing and playing piano.
Certification
- Business Analyst Career Program Certification From Skill Academy By Testbook Feb 2023
Languages
English
Native or Bilingual
Hindi
Native or Bilingual
Bengali
Native or Bilingual
Urdu
Professional Working
Timeline
Junior Business Analyst
Universal Stream Solution, Inc.
04.2021 - 08.2023
Business Development Executive
Universal Stream Solution, Inc.
04.2019 - 03.2021
Master’s in Applied Data Analytics -
University of Detroit Mercy
Bachelor’s in Commerce -
Deen Dayal Upadhyaya Gorakhpur University
Similar Profiles
Mariam MetryMariam Metry
Human Resources Consultant at Universal StreamHuman Resources Consultant at Universal Stream
Jitendra RathoreJitendra Rathore
Team Leader at WM Universal Solution PVT LTDTeam Leader at WM Universal Solution PVT LTD
SELVARAJ VIJAYABALANSELVARAJ VIJAYABALAN
ASSISTANT PROJECT ENGINEER at UNIVERSAL SOLUTION PTE LTDASSISTANT PROJECT ENGINEER at UNIVERSAL SOLUTION PTE LTD