Prem R
Chennai
Summary
Experienced and detail-oriented professional with over a year of practical expertise in Power BI and MySQL. Possessing a strong background in analytical tasks and support functions, Successfully contributed to data management and project coordination in previous roles. Eager to bring skills and knowledge to impactful projects, while continuously seeking opportunities for growth and learning in the field of data analysis and business intelligence.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Associate Analyst
Maveric Systems Ltd.
07.2024 - Current
- Implemented and automated ETL processes for diverse raw datasets, streamlining data processing and ensuring efficient data flow to facilitate timely reporting and analytical insights for stakeholders.
- Enhanced a client analytics report by resolving bugs and implementing UI/UX improvements, increasing usability and value. Additionally, developed a sales pipeline report with complex computations, integrating CRM data to provide sales leaders with accurate revenue forecasts and performance tracking.
- Designed and implemented data marts and tables within the database tailored to specific application requirements. Enhanced data management by creating stored procedures and source queries, facilitating seamless data integration and accessibility across platforms.
- Spearheaded the data migration for the PSA system upgrade, ensuring the seamless transfer of clean records from the legacy system. Coordinated with vendors on data preparation, implemented rigorous ETL processes, and utilized scripted checks to minimize errors and ensure data accuracy.
- Oversaw data validation during the system migration to maintain data integrity across all systems. Implemented highly automated ETL processes to convert raw data into a readable format for comprehensive validation against multiple sources, ensuring data cleanliness and consistency post-migration.
- Assumed responsibility for the maintenance of a SharePoint database, ensuring consistent and clean data flow using Power Automate. Managed change requests and addressed bugs to optimize data flow, guaranteeing data completeness and accuracy within SharePoint.
- Managed Business-As-Usual (BAU) activities within Power BI, addressing Change Requests (CRs), implementing enhancements, and developing new reports and insights. Implemented streaming datasets to capture data from APIs, ensuring data integrity and real-time data availability.
Data Analyst Intern
Maveric Systems Ltd.
08.2023 - 06.2024
- Collaborated with stakeholders to elicit business requirements and translate them into actionable insights, developing interactive Power BI reports to facilitate data-driven decision-making and enhance user comprehension.
- Developed a comprehensive HRMIS report detailing active employee count, attrition rates, workforce demographics, skill gaps, recruitment insights, and performance metrics, thereby enabling the HROPS team to strategically manage workforce dynamics and ensure regulatory compliance.
- Compiled a detailed Travel Report analyzing expenses, visa accommodations, and travel patterns to inform budget management, identify cost reduction opportunities, optimize travel policies, and forecast future travel demands.
- Conducted in-depth analyses of workforce metrics, including hiring patterns and recruitment expenses, to provide actionable insights to recruitment leadership, facilitating refined talent acquisition strategies and optimized vendor selection processes.
- Produced a comprehensive report tracking work items within the ticketing system, enhancing task management and improving team productivity by identifying workflow bottlenecks and optimizing operational processes.
- Routinely updated existing reports to align with evolving business requirements, managing enhancements and maintenance to ensure the continued relevance, user-friendliness, and effectiveness of reporting tools.
Education
BBA - Information Technology
Mittal School of Business
Jalandhar, Punjab05.2024
Higher Secondary Education -
Union Christian Mtc. Hr. Sec. School
Chennai, Tamilnadu05.2021
Skills
- DAX
- SQL
- Advanced Excel
- Requirements gathering
- Data Visualization
- Data Cleanup
- Data Transformation
- M Language
Certification
- Microsoft Power BI - Udemy
- Advanced Excel - Udemy
- Structured Query Language - Udemy
- Python Programming for Analytics - Udemy
Websites, Portfolios and Profiles
https://www.linkedin.com/in/prem-r-183b75235/
Timeline
Associate Analyst
Maveric Systems Ltd.
07.2024 - Current
Data Analyst Intern
Maveric Systems Ltd.
08.2023 - 06.2024
BBA - Information Technology
Mittal School of Business
Higher Secondary Education -
Union Christian Mtc. Hr. Sec. School
Similar Profiles
Syed Rameez HaiderSyed Rameez Haider
Assistant Manager-TAG-Corporate at Maveric Systems LimitedAssistant Manager-TAG-Corporate at Maveric Systems Limited
Merlin ElizabethMerlin Elizabeth
Senior Test Engineer at Maveric Systems LimitedSenior Test Engineer at Maveric Systems Limited
Pratibha SanghiPratibha Sanghi
Company Secretary at Maveric Systems LimitedCompany Secretary at Maveric Systems Limited