Ranjith Y

Accomplished IT professional with over 9 years and 8 months of experience in the Information Technology and Service industry. Specialized in Power BI with 3.5 years of expertise, complemented by foundational knowledge in Power Apps &

Power Automation. Currently serving as LEAD ANALYST BUSINESS ANALYSIS at Fidelity Information Services (FIS).

Proficient in data analysis, modeling, transformation, visualization, and report creation. Possess foundational knowledge of SQL. Seeking to advance my career in Business Intelligence, leveraging expertise in decision-making, time management, supervision, and administration to drive company success.

• Understanding requirements from the business and analyze them in Power BI context.
• Designing data models to convert raw data to meaningful insights using Visualizations in Power BI.
• Creating useful and interactive Dashboards, KPI scorecards, reports and analyzing the data by using Power BI desktop.
• Performing data manipulation using DAX.
• Involved in cleaning the data using SQL.
• Creating Filters, performing table calculations, calculate measures and parameters in Power BI.
• Creating and managing Gateways to keep reports update & refresh.
• Set Power BI reports on subscription so that reports reach users every day on email without manual intervention.

Extensive experience in Power BI Desktop and Power BI Service and having good knowledge on writing SQL queries.

• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Optimizing data queries to improve the performance.
• Collaborating closely with database team to identify data sources and streamline data collection that results reduction in report development time.
• Improved dashboard usability by implementing interactive visualizations resulting in a 20% increase in user engagement.
• Responsible for tracking, compiling, and completing the reports that are distributed among the team.
• Headed a team that converts all operational excel reports into Power BI Report.
• Conduct weekly one to one call with my team to understand and assist their challenges/doubts with tasks. Documenting the data models, reports and processes for knowledge sharing.
• Provide trainings to end users.
• Participate in daily development team stand-ups and answer questions brought up by the team.
• Worked closely as a team, to perform GAP analysis between the legacy system and the proposed system.
• Collaborated with the Product Owner and other team members to understand the product vision and features.
• Serve as the liaison between business stakeholders, development team, and the QA testers.
• Perform acceptance testing with business units to make sure solutions meet the requirements and business needs.
• Participated in sprint planning meetings to define the tasks and duration of the Sprints.
• Collaborate with team in prioritizing the requirements.
• Lead calls with onshore team during managers absence and is a backup support for his team tasks.

Bachelor of Commerce - 2013

Sivananda Sarma Memorial RV College (SSMRV)