VANNURSWAMY KURUBA
Summary
Experienced and enthusiastic Data Analyst with 11 years in IT, specializing over the last 5 + years in SQL Server and Power BI for advanced data analysis and reporting. Proven ability to build impactful dashboards, optimize SQL queries, and manage data workflows with SSIS and SSAS. Brings a blend of technical skills and interpersonal strengths to meet business needs and drive data-driven decision-making. Seeking to leverage analytical expertise within a forward-thinking organization.
Overview
11
11
years of professional experience
Work History
Consultant
HCL Technologies
04.2024 - Current
- Developed and optimized complex SQL queries for data extraction and reporting
- Built Power BI dashboards and reports with features like bookmarks, drill-down, and drill-through for data insights
- Configured row-level security in Power BI, implementing role-based access control for secure data access
- Managed Power BI Service, administering workspaces and user roles to meet organizational security standards
- Designed Power BI dashboards for real-time KPI monitoring, supporting data-driven business decisions
- Created and deployed dynamic dashboards in Power BI to monitor KPIs for real-time decision support
- Conducted data analysis and created drill-down reports in Power BI to support business and operational insights
- Troubleshoot and optimized SQL Server performance issues, including indexing and query tuning
- Developed custom visuals in Power BI to provide enhanced data visualization tailored to client requirements
- Collaborated with stakeholders to gather requirements and deliver Power BI solutions aligned with business objectives
Data Analyst
StarHub Ltd
10.2016 - 03.2024
- Client: StarHub, Singapore
- Designed and optimized Power BI data models, including relationships, calculated columns, and measures, enhancing dashboard responsiveness and reducing refresh times by 25%
- Built advanced SQL queries and DAX expressions for data transformation, aggregation, and calculated metrics
- Created interactive Power BI dashboards with drill-through and drill-down capabilities, providing users with deeper insights and improved data exploration options
- Configured row-level security (RLS) in Power BI to safeguard data and meet compliance standards
- Utilized SQL Server to create, optimize for views and SP's for integration with Power BI reports and dashboards
- Developed and published Power BI apps, for various departments and improving user adoption rates
- Collaborated closely with business stakeholders to gather requirements, ensuring Power BI solutions aligned with specific analytical and reporting needs
- Conducted performance tuning on SQL queries, DAX measures, and Power BI datasets, improving report loading times and user experience
- Working with vendors on reviewing CR documentation like Technology plan & budgeting to provide sign off together with respective business dept lead
Caterpillar India Pvt Ltd
03.2016 - 09.2016
- Created packages to import data from different sources for automation
- Implementing logging, checkpoint configuration in SSIS
- Created views and procedures by using joins, Sdf's for delivering required reports
- Created reports using Power BI
- Involved in Analyzing requirements and built reports using Power BI Desktop
- Implemented key features like Drill Down, Drill Through, Slicers etc
- Implemented RLS as per the requirement
- Created various reports and dashboards as per the need and maintained in Workspaces
- Scheduled the reports in required frequency
- Created dataflow as per the need at Power BI Service Level
Associate Engineer
L&T Infotech
10.2013 - 03.2016
- Responsible for the monitoring jobs in SQL Agent
- Involved in writing SQL queries for views and stored procedures
- Preparing and sending reports on SQL jobs status
- Created reports using SSRS for various requirements
Education
MCA -
Nova College of Engineering & Technology
Hyderabad, India07-2011
B.Sc. - Electronics
S.S.G.S Degree College
Guntakal, India10-2007
Skills
- Power BI
- SQL Server
- SSIS
- SSRS
- SSAS
- ADF
- Dev Ops
- DAX
- SQL Agent
- Data flows
- Deployments
- Monitoring
- Migration
Technologies tools
- Power BI
- SQL Server
- SSIS
- SSRS
- SSAS
- ADF
- Dev Ops
Hobbies
Playing Chess: Developed and led chess workshops for my kids, enhancing teaching skills
Badminton: Regularly compete in local street badminton tournaments, showcasing physical fitness, agility, and team spirit
Timeline
Consultant
HCL Technologies
04.2024 - Current
Data Analyst
StarHub Ltd
10.2016 - 03.2024
Caterpillar India Pvt Ltd
03.2016 - 09.2016
Associate Engineer
L&T Infotech
10.2013 - 03.2016
MCA -
Nova College of Engineering & Technology
B.Sc. - Electronics
S.S.G.S Degree College
Similar Profiles
Srinivasan NandagopalSrinivasan Nandagopal
ETL Lead /Onshore Technical Business Analyst at HCL Technologies India & HCL Technologies NZ LtdETL Lead /Onshore Technical Business Analyst at HCL Technologies India & HCL Technologies NZ Ltd
Dan WyszynskiDan Wyszynski
Senior Mortgage Loan Closer at HCL Technologies/HCL Lending ServicesSenior Mortgage Loan Closer at HCL Technologies/HCL Lending Services
Sudhanshu ShekharSudhanshu Shekhar
Director at HCL Technologies/HCL America Inc.Director at HCL Technologies/HCL America Inc.
Dhruv PillaiDhruv Pillai
Associate Executive at HCL TechnologiesAssociate Executive at HCL Technologies
Sanket BhagwatSanket Bhagwat
Consultant at NICE SOFTWARE SOLUTIONSConsultant at NICE SOFTWARE SOLUTIONS