Selvaganapathy S
Data Analyst
Chennai
Summary
Brings over 8 years of IT Experience along with knowledge on huge volumetric dataset and worked in vivid reporting tools as per client requirement. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
8
8
years of professional experience
13
13
years of post-secondary education
Work History
Data Analyst
Star health insurance
Chennai
02.2023 - Current
- To maintain complete call center data that includes WFM, performance, attrition, Roster report, Agent Login logout report, Attendance Report, Allowance report, Productivity report
- Produced monthly reports using advanced Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Analyzed transactions to build logical business intelligence model for real-time reporting needs.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
- Designed custom tracking systems to monitor KPIs, ensuring alignment with organizational goals and objectives
Process Associate – SQL Developer
Smart Connect Technologies
Bangalore
05.2022 - 02.2023
- Developing Various Dashboards using Power BI, Tableau Developing Various Dashboards using Power BI, Tableau
- Pulling data from backend database using queries and SQL for Realtime Dashboard
- Develop Power BI, Tableau desktop reports and dashboards.
- Consult with business and technology partners on data visualization options and best practices.
- Identified and resolved process issues to drive optimal workflow and business growth
- Collaborated with team to define business requirements for organizational processes, achieve productivity standards, and adhere to accuracy standards
- Partnered with cross-functional teams to conduct thorough discovery and due diligence on existing processes
Process Associate – Data Analyst
Tata Consultancy Services
Chennai
06.2020 - 02.2022
- Market Risk project is one of main wings of ‘Run the Bank’ stream of Deutsche Bank.
- Overseeing the global market performance this process involves in the Value at Risk calculation & analysis and in projecting the Economic Capital requirement for the bank.
- Increased productivity by developing automated tools for routine data processing tasks
- Planning and dividing work based on daily volume to meet SLA and resolving queries of team member
- Helping new joined employee on mandatory course completion, system allocation and scheduling process training
- Conducting session of advanced excel for team weekly
- Preparation of daily reports for team
- Helping in Internal audit
- Playing key role in creating resource utilization report for profit margin report.
- Extensive usage of MS Excel (Aggregate Functions, Formulas, VLOOKUP Index, Match, Data Validation, Conditional Formatting, Pivot table.)
- Improved decision-making processes by presenting comprehensive data visualizations and reports to key stakeholders
- Facilitated knowledge sharing among team members through regular training sessions on best practices in data analytics techniques and tools
Process Associate
British Telecom (BT)
Chennai
10.2015 - 05.2020
- Develop Power BI, Tableau desktop reports and dashboards.
- Consult with business and technology partners on data visualization options and best practices.
- Follow up with clients to ensure their IT systems are fully functional after troubleshooting.
- Overseeing inbound and outbound to confirm Telephone Directories
- To place orders to track them and follow up.
- Been flexible with shift when there was need to extend my support.
- Identified and resolved process issues to drive optimal workflow and business growth
- Monitored and reported on process performance to verify compliance with established standards
- Collaborated with team to define business requirements for organizational processes, achieve productivity standards, and adhere to accuracy standards
Education
Bachelor of Arts - Commerce & Accounting
Sindhi College of Arts And Science
Chennai 03.2011 - 03.2024
Skills
Providing Client solution by implementing SQL queryPreparing Business Related report using TableauAs an extended role and responsibilities, automating the MIS report using excel advanced formula and Tableau for data visualizationInserting updating and altering the table and fetching the accurate value as per client requestPreparing reports in Power BIExperience in creating different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tablesProficient in writing all formulas like logical (IF, AND, OR), Arithmetic (Sumifs, Countifs), Text (Replace, Substitute, Find, Left, Search), Date (Date Formats, Datedif)Solving complex queries using SQL
Support to the team leader in managing different sales data
Data profiling
Workflow Analysis
Operations analysis
Data Mapping
Timeline
Data Analyst
Star health insurance
02.2023 - Current
Process Associate – SQL Developer
Smart Connect Technologies
05.2022 - 02.2023
Process Associate – Data Analyst
Tata Consultancy Services
06.2020 - 02.2022
Process Associate
British Telecom (BT)
10.2015 - 05.2020
Bachelor of Arts - Commerce & Accounting
Sindhi College of Arts And Science
03.2011 - 03.2024