Malaya Ranjan Aich

1. MSU - Orchestrating End-to-End Workflow Solutions(Ongoing)

Tools- Power BI, Excel, My SQL, Python,GA4,

• Delivered actionable insights via comprehensive reports and dashboards, facilitating strategic initiatives.
• Oversaw large-scale databases to ensure prompt access to vital information for key stakeholders.
• Developed tailored tracking systems to monitor Key Performance Indicators (KPIs), ensuring alignment with organizational objectives.
• Streamlined analytic capabilities by integrating disparate data sources into cohesive datasets through effective Extract, Transform, Load (ETL) processes.
• Conducted thorough competitor analyses, pinpointing market share gaps and uncovering growth opportunities.
• Trained junior analysts on best practices, improving overall team performance and productivity.
• Evaluated the effectiveness of marketing campaigns using A/B testing methodologies, optimizing strategies for higher ROI.

2. Untold Studios (Ongoing)

Tool- Tableau

• Improved decision-making processes with accurate data analysis and visualization techniques.
• Optimized company resources allocation with detailed forecasting models based on historical data analysis.
• Presented findings to executive leadership teams through concise presentations, influencing future strategy development.

3. Suventure Internal - AI Tools Solutions for News Publishers (Ongoing)

4. Wellness Vibe ( Apr-23 to Oct 23)

Tools- Power BI, GA, Excel

• Utilized data visualization tools to effectively communicate business insights.
• Collaborated with business-unit leaders to identify and prioritize problems.
• Analyzed transactions to build logical business intelligence model for real-time reporting needs.

5. The Quint ( Feb-22 to May-22)

Tools- Power BI, Google Analytics

• Customized media consumption trend reports highlighting audience preferences and behavior.
• Real-time dashboards showcasing social media engagement metrics for ongoing campaign optimization.
• Target audience segmentation analysis for tailored content creation and advertising campaigns.

6. Forkast News (Sep-22 to Nov-22)

• Content performance analytics for informed content creation decisions.
• Campaign effectiveness assessments to maximize ROI.

7. The Karighars (Apr -22 to Mar-23)

Tools- Google Analytics, Power BI

• Data Visualization and Reporting : Presenting findings, recommendations, and design proposals through clear and visually appealing reports, presentations, and interactive dashboards.
• Budget analysis and forecasting for project cost management.

• NGEN Phase4 Instance split
• With expansion in current business in US, client opened stores in Canada
• To evaluate current performance and future forecast in the recently opened store, it was needed to provide monthly reports for the sales performance of products in each region and forecast the sales in the future to improve business
• Data collection from different sources, data cleaning, data understanding, building model with the data and validate that model and finally deploy the model were the activities in the scope of the project
• Tools- My Sql, Python, Power BI, Ms Excel

• TC4W Integration (Trunk Club for women): Enables the shipment of Trunk Club (TC) stylist orders from Cedar Rapids (CR) to the customer
• Was involved in Analysis of the business level changes that are required to support the integration, Design and technical documents designing, Designing UTC and unit testing, Supporting SIT and UAT
• Tools-Python, Power BI, Ms Excel

• Custom data extraction: We work for Most of the pharmaceutical client in Canada
• We provide them the reports based on their demand
• We take their data and perform analyze that apply confidentiality whenever competitors data is involved and send the report as per demand
• We provide trending and overlapping report to help them understanding the performance of product and medical representative
• Tools: Power BI, Ms Excel