PRATHEESH RAJU
Analytics Manager
Bangalore,Karnataka
Summary
Astute, insightful and highly successful Data Analytics Manager with proven skills in building analytics frameworks for comprehensive dashboards. Talented in leveraging existing and fresh capabilities to uncover substantial insights. Expert in work force planning operations and decisive in approaching business problems.
Overview
18
18
years of professional experience
6
6
Certification
Work History
Analytics Manager
Technicolor Creative Studios Pvt. Ltd.
Bengaluru, Karnataka
08.2023 - Current
- Developed and implemented analytics strategies to improve customer experience.
- Analyzed large data sets to identify trends, patterns, and opportunities for improvement.
- Collaborated with stakeholders to define business objectives and KPIs for analytics initiatives.
- Designed dashboards using PowerBI or other visualization tools to track key performance indicators.
- Identified areas of improvement in existing processes through data exploration and statistical modeling techniques.
- Developed automated reporting processes using SQL queries or other scripting languages to streamline data extraction tasks.
- Designed surveys, opinion polls and assessment tools to collect data.
- Created detailed reports on customer segmentation, customer journey mapping, and user behavior analysis.
- Provided strategic insights into customer segmentation, process, core business, and overall performance of the business.
- Assessed team member's skillsets and assigned tasks accordingly for optimal efficiency.
Project Lead
Accenture Business Solutions Pvt. Ltd
Bengaluru
06.2020 - 08.2023
- Leading the technical team to oversee the development and ongoing delivery of the data analysis and reporting capability
- Working on platform migration for the client from a server based database to cloud based database using ADF & Synapse
- To understand business requirements in the BI context and design data models to convert raw data to meaningful insights
- In-depth understanding and experience with Microsoft BI stacks
- Documenting, designing, and modeling solutions and explaining, representing, and discussing the same with the team
- Oversee day-to-day operation by monitoring the inflow of requests, have them tracked on Azure Devops, Service Now and emails
- Standardizing processes and data aligned with industry best practice, to provide a common, consistent foundation to support data analysis for organizational effectiveness
- Formalizing and institutionalizing a data governance framework: creating common set of data definitions and focus on data quality
- Gathering requirements from stakeholders identify and understand business needs and converting these into technical specification, Data Model and ETL design
- Quality audits on all the request, before the outcome had been deployed to the requester
- Discover training needs and provide coaching to the team
- Connecting with team members to intervene and resolve any issues or clarifications
- Encouraging team to be creativity and prompt them in accepting challenging projects
- Suggest and organize team building activities
- Conducting technical upskilling training for the team members
- Attending client leadership catch up calls to provide an update on the project status on a weekly basis (Sprint Planning - Priorties setting)
- Being the first point of contact and a bridge between the client and team
- Conducting skill-based interview and supporting leadership panel to identify potential resource to hire
- Having regular catch ups with the team member as a group and individually to understand the challenges and convey feedback.
Senior Associate Business Analyst
Avantor Sciences
Coimbatore
08.2018 - 06.2020
- Develop mass production of inventory metrics reports for the entire Europe and Asia regions (245 Reports)
- Develop business architecture using requirements such as scope, processes, alternatives, and risks
- Analyze client's business requirements and processes through document analysis and workflow analysis
- Manage SQL Database and conduct various levels of testing including functional, regression, user acceptance, integration and performance to verify the client's needs are met
- Communicate client's business requirements by constructing easy-to-understand data and process models
- Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications
- Mediate between business and technical personnel to ensure a mutual understanding of processes and applications
- Transition of new reports, report structuring, report automation with VBA and SQL platform.
Assistant Manager
Tradepro Ventures Private Limited
Coimbatore
06.2017 - 08.2018
- Coordinate daily customer service operations (e.g., post sales processes, orders shipments and payments)
- Track the progress of weekly, monthly, quarterly, and annual objectives
- Monitor and maintain store and stockroom inventory
- Communicate with clients and evaluate their needs
- Research emerging products and use information to update the store's merchandise
- Create reports, analyze, and interpret retail data, like revenues, expenses and competition
- Conduct regular audits to ensure the store is functional and presentable
- Make sure all employees adhere to company's policies and guidelines
- Supervising employees, providing additional training, and coaching as needed to ensure everyone is performing their job properly
- Handling customer complaints and resolving issues that employees are not authorized to oversee on their own
- Travelling to the client sites to check the progress of the work and communicating with the clients to capture the overall feel of our product and the services.
Senior Project Leader
Maxval - IP Services Private Ltd
Coimbatore
06.2016 - 06.2017
- Managed the database project; with a team strength of 44 members and 4 project leads reporting
- Handling team's monthly attendance roster, attendance adherence tracking and concerns if any by addressing them with a pattern methodology
- Built and led a cross-functional project team in support of symphony application, providing customer service and maintaining positive communications with fourteen client sites
- With each project, provided guidance on team decision-making and problem solving
- Provided feedback and daily project direction
- Interacting with the active clients on a regular basis to capture all the potential updates to keep the procedures to current
- Tactfully managed complex team dynamics, managing organizational change related issues, and fostered an on-going positive environment with a motivated staff and satisfied customer base
- Collaborated with functional managers and the HR team to obtain necessary resources to support the team's requirements.
Senior Analyst
Tesco Hindustan Service Centre Private Ltd
Bengaluru
08.2009 - 01.2016
- Leading and Monitoring team members' participation to ensure the training they are being provided is being put into use, and to see if any additional training is needed
- Assigning task to the team members daily based on the team bandwidth
- Creating Report Template design for dashboard and representing to the client
- Good understanding on the requirements of the task and deliver it within a specified time and identify gaps in requirements and coordinating with customer to get the work hand done
- Provided MS Access 2003, VBA, MS Access Reports, SQL support for an automated job and scheduling system
- Designed and created MS Access & SQL Teradata database using user requirements and process analysis
- Provided MS Access 2007, VBA, MS Access Reports, SQL support to various projects with emphasis on debugging and enhancing existing End User application
- Good working experience in software development on Microsoft technologies like SQL, MSBI, VBA, MS Access, Business Object
- Project manager for design, automation, and solution development of various applications, including integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens
- Collect user's requirements and incorporate them into the database
- Assist in configuration, installation, maintenance, and troubleshooting of applications
- Automating reports and creating various macros using MS Access, VBA, and SQL and also creating CRMs for operations team.
Senior Customer Service Associate
Aditya Birla Minacs, Capital One
Bengaluru
01.2009 - 06.2009
- Answering Customer queries and attending to the immediate needs in an endeavor to achieve the set standards of the performance
- Making eligible up selling products like balance transfer and adding an authorized user to the credit card to the customer account, ensuring the service satisfaction and meeting up the designed targets set the by the clients
- Ensuring 100% productivity and quality service to the customer
- Contribute and imbibe the best practices of the organization
- Being an effective collaborator and contribute to the success of the team and campaign.
Senior Customer Service Associate
Aegis BPO Services
Bengaluru
06.2007 - 12.2008
- Answering Customer queries and attending to the immediate needs in an endeavor to achieve the set standards of the performance
- Making of computer sales ensuring the customer's satisfaction and meeting up the designed targets set by the clients
- Ensuring 100% productivity and quality service to the customer
- Contribute and imbibe the best practices of the organization
- Being an effective collaborator and contribute to the success of the team and campaign
- Handling client query, escalations and clarifications via email communication or by call basis priority
- Working on Daily Dashboard Report, Management Report, and Weekly Dashboard Reports to be shared with the higher management.
Senior Process Associate
Dell International Services
Bengaluru
10.2005 - 11.2006
- Doing a Quality audit on the orders processed by the associate
- Allocating the orders to the associate according to the queue availability
- Crossing verifying with the customers with their system configurations and allocate the orders for manufacturing
- Preparing of weekly dashboard and review meeting reports for the managers meeting
- Automating the reports to make the work more efficient and error free
- Sending the order counts report for the team every two hours.
Education
Bachelor of Science - Computer Application
C.V. Raman University
High School Diploma - Computer Science
Laurel Matriculation Higher Secondary School
High School Diploma - CBSE Board - 10th Standard
SBOA Matriculation Higher Secondary School
Skills
- Data Warehousing
- Business Intelligence
- Dashboard creation
- Effective Communication
- Problem-Solving
- Time-series analysis
- Task Prioritization
- Analytical Skills
- Statistical Analysis
- Interpersonal Skills
- Team management
Hobbies and Interests
- Exploring new places
- Automobile modification
- Audio accoustics
- Cooking
Languages
Tamil
First Language
Malayalam
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Kannada
Intermediate (B1)
B1
Telugu
Intermediate (B1)
B1
Certification
- Cisco Certified Network Associate
- Cisco Certified Network Professional
- Microsoft Certified Systems Engineer
- Microsoft Certified Systems Administrator
- Contact Center Certified Professional
- Microsoft Power BI Certification: DA-100 | PL-300
Timeline
Analytics Manager
Technicolor Creative Studios Pvt. Ltd.
08.2023 - Current
Project Lead
Accenture Business Solutions Pvt. Ltd
06.2020 - 08.2023
Senior Associate Business Analyst
Avantor Sciences
08.2018 - 06.2020
Assistant Manager
Tradepro Ventures Private Limited
06.2017 - 08.2018
Senior Project Leader
Maxval - IP Services Private Ltd
06.2016 - 06.2017
Senior Analyst
Tesco Hindustan Service Centre Private Ltd
08.2009 - 01.2016
Senior Customer Service Associate
Aditya Birla Minacs, Capital One
01.2009 - 06.2009
Senior Customer Service Associate
Aegis BPO Services
06.2007 - 12.2008
Senior Process Associate
Dell International Services
10.2005 - 11.2006
Bachelor of Science - Computer Application
C.V. Raman University
High School Diploma - Computer Science
Laurel Matriculation Higher Secondary School
High School Diploma - CBSE Board - 10th Standard
SBOA Matriculation Higher Secondary School
- Cisco Certified Network Associate
- Cisco Certified Network Professional
- Microsoft Certified Systems Engineer
- Microsoft Certified Systems Administrator
- Contact Center Certified Professional
- Microsoft Power BI Certification: DA-100 | PL-300
Similar Profiles
Andrew HarveyAndrew Harvey
Business Development Producer at MPC - Technicolor Creative StudiosBusiness Development Producer at MPC - Technicolor Creative Studios
Akash Benny ThomasAkash Benny Thomas
3D Rigger Artist at at Technicolor Creative Studios3D Rigger Artist at at Technicolor Creative Studios
Samrat MukherjeeSamrat Mukherjee
Global Data Analyst-Workforce Planning at TECHNICOLOR CREATIVE STUDIOSGlobal Data Analyst-Workforce Planning at TECHNICOLOR CREATIVE STUDIOS