Swetha Sri Ravichandar
Calgary,AB
Summary
Results-driven BI Developer with 5+ years of experience in diverse industries. Dynamic, resourceful with a deep passion for creating and delivering dashboards, reports and BI Solutions that empower a team, company, and customer to meet and exceed their expectations.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
3
3
Languages
Work History
Senior Software Engineer
Servion Global Solutions - Banking Domain
2021.10 - 2023.01
- Worked as Senior Team member as SQL and Power BI developer
- Followed Agile-Safe Methodology and Participate in sprint planning, design and estimation for the upcoming program planning. Contributed during DSU meetings, Iteration review meeting and sprint statuses about jira stories and bugs on daily
- Revised the company's data governance strategy, increasing data integrity and consistency.
- Overhauled legacy SQL databases, optimized query performance by 50%, resulting in faster decision-making.
- Interacted with business users for understanding the business requirements and the existing system
- Performed Power BI Desktop data modelling, which cleans, transforms, mash up data from multiple sources.
- Designed and created interactive reports and different data visualizations and Implemented Row-Level Security, restricted Sharing and Publishing, restricted export.
- Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles
- Strong experience with query editor features like merge & append query, split column, conditional column, extract, pivot & un-pivot, add column, transpose, write M FORMULA using advanced query editor, delete column, remove null, errors, etc
- Experience in Performance Tuning and Query Optimization
- Created Dataflows in Power BI Services
- Deployed Power BI Desktop reports , configured the datasource and scheduled the refresh.
- Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently
Senior Associate
Wipro Pvt. Ltd. - Manufacturing Domain
2018.06 - 2021.08
- Worked as Team member as SQL and Power BI Developer in Manufacturing domain.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Increased data retrieval efficiency by designing optimized views tailored to specific reporting needs of various departments within the organization.
- Participated in regular status meetings with project stakeholders to provide updates on progress and address any concerns or feedback promptly.
- Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
- Developed Power BI visualizations and dashboards using Power BI Desktop
- Worked closely with the ETL team to automate the data load process, create required aggregate tables, indexing and table partitioning for performance optimization of reports
- Trained end users on utilizing new Business Intelligence tools effectively.
Education
B. Tech Information Technology -
Dhanalakshmi College of Engineering
Chennai, India 2013.06 - 2017.05
Skills
Power BI
Accomplishments
- Received Best Employee Award from client for work quality.
- Received Appreciation mail from client for handling deployment and production issues.
- Received appreciation mail form client for very good maintained several RPA bots in daily basis.
Timeline
Senior Software Engineer
Servion Global Solutions - Banking Domain
2021.10 - 2023.01
Senior Associate
Wipro Pvt. Ltd. - Manufacturing Domain
2018.06 - 2021.08
B. Tech Information Technology -
Dhanalakshmi College of Engineering
2013.06 - 2017.05
Similar Profiles
Robin ThomasRobin Thomas
Assistant Manager / Renewal Manager (MSS) at Servion Global SolutionsAssistant Manager / Renewal Manager (MSS) at Servion Global Solutions
Yuvaraj MYuvaraj M
Freelancer/ Director Contractor at myTVS / Servion Global Solutions Pvt LTDFreelancer/ Director Contractor at myTVS / Servion Global Solutions Pvt LTD
Parinita SehgalParinita Sehgal
Project Manager at Servion Global SolutionsProject Manager at Servion Global Solutions