Prasanna Vengadesh Nagarajan

Data Analyst

Epowerx Learning Technologies Private Limited (Skill-Lync)•  August 2022 - Present

Create Automated Dashboards using Power Bi/Excel/Google Sheets for sales, customer service, career support, escalations, quality & training. Using the SQL Queries to fetch the data from the database to use that as a raw for all kind of dashboards. Create & maintaining the Daily, weekly, monthly, and yearly performance dashboard of all the employees in the system. Create & maintaining the management level dashboard for better decision making. Developed and implemented Extract, Transform, Load (ETL) processes to extract data from diverse sources, transform it into usable formats, and load it into target databases. Utilized SQL and ETL tools to automate data integration processes, ensuring data consistency and accuracy. Worked closely with stakeholders to understand their business requirements and translated them into effective Power BI solutions. Utilized Power BI to create interactive dashboards, reports, and visualizations to communicate insights from complex datasets. Applied DAX formulas and functions to perform calculations, aggregations, and custom calculations for business metrics and KPIs. Conducted user training sessions and provided ongoing support to enable self-service analytics for business users. Create & maintain the leader board of the organization which shows employees current stage with respective quality, performance, attendance, target achievements. Perform RCA for student raised tickets/Rating provided for the company.

Senoir System Coordinator

Saud Bahwan Automotive LLC•  October 2019 - April 2022

Using SQL query and stored procedures to develop the data for the Management needs. Handling large data and compile the data for the team/management requirements accordingly. Collaborating with the business team members and BI to ensure the solutions to the business needs. Understanding business problems and providing the data relevant to the problem. Leveraged SQL queries to extract, manipulate, and analyze large datasets from various databases and data sources. Utilized Power BI to create interactive dashboards, reports, and visualizations to communicate insights from complex datasets. Applied DAX formulas and functions to perform calculations, aggregations, and custom calculations for business metrics and KPIs. Analyzed large volumes of data to identify trends, patterns, and anomalies, providing actionable recommendations to stakeholders. Developed and implemented data models in Power BI, ensuring accurate and efficient data representation for analysis. Developed complex SQL queries to generate reports, perform ad-hoc analysis, and identify key insights and trends. Designed and implemented data models, schemas, and database structures to ensure efficient storage and retrieval of data. Collaborated with cross-functional teams to define data integration requirements and resolve data integration issues. Dashboard Maintenance of Sales Performance in different schedules. Created custom visualizations, charts, and graphs to represent complex data and trends. Applied data visualization best practices to create visually appealing and user-friendly reports and dashboards. Designed intuitive and interactive user interfaces using Power BI features such as slicers, drill-through, and bookmarks.

MIS Executive

BankBazaar.com•  April 2018 - October 2019

Creating Excel templates for tracking the daily workflow activities. Checking the daily reports and get the data from the users. Monitoring all branches of the companies and maintains their data. Creating the monthly expenses sheets and share to HOD. Create Team’s monthly performance report and share to HOD. Create, Share & Maintain the detailed MIS reports month wise.

Senior Process Executive

Infosys BPM Limited•  July 2015 - April 2018

Download daily, weekly dashboard from client’s refreshable tool. Interaction with production floor and get the work done by given TAT. Create daily, weekly reports and charts and send to Team leads, Managers and Clients. Generate the team’s monthly report (Production, Efficiency and Quality). Create the slides with the data from monthly reports and present in monthly meetings. Assigning workflow on daily basics and get it done within the TAT given by clients. Interactive with Client for any process related issues and fix it ASAP. Quality checks within the team members and ensure the quality percentage. Generates the detailed report and send it to clients on daily basics.

MIS Support Executive

Sun Business Solutions Privated Limited•  July 2012 - February 2014

Initially, answering inbound calls in a timely and friendly manner. Evaluate problems and complaints of the callers and provide proper solutions to them. Later Moved to MIS team and worked with all call center reports like aux details, Calls Answered & Abended reports, Productivity, Team’s performance, Team wise score card and Quality reports

Bharathidasan University

Computer Science, MS•  April 2013 - April 2015

MCA

Bharathidasan University

Computer Information Systems, BS•  April 2009 - April 2012

BCA