Virjesh Solraja TSK

Senior BI Engineer

• Job Details:Collaborate closely with functional teams to gather requirements and transform them into actionable reports and dashboards, driving valuable business insights. Designed and managed SharePoint Online sites, lists, and libraries to centralize business-critical data, improving accessibility and collaboration across teams. Automated data extraction from databases using SQL, reducing manual reporting efforts by 40% and ensuring real-time data updates in Power BI and QlikSense dashboards. Led a team of 3 data analysts in collecting, cleaning, and analyzing data from multiple sources, resulting in a 15% increase in productivity through streamlined processes. Leverage tools and technologies such as Power BI, QlikSense, SQL, and Python to develop robust analytics solutions. Manage end-to-end analytics projects, including scoping, planning, execution, and delivery. Hands-on experience in managing the project completion lifecycle using the Agile Scrum methodology.

Senior Business Analyst

• Job Details:Managed a team of 5 members to successfully design and implement a high-priority migration project, resulting in a 25% reduction in project completion time and a 15% decrease in implementation costs. Assisted users with Power BI and Tableau dashboard development/data preparation on Postgres SQL. Defined and gathered requirements to build goal frameworks to track business metrics. Collated and translated business requirements to data prep team. Built SQL scripts, data sets and data lineage. Built complex visualizations on Tableau Desktop and drew inferences for stakeholders and assigned appropriate permissions and licenses to users based on their roles and responsibilities. Improved Tableau dashboard performance by optimizing queries and visualization design, resulting in a 30% increase in user efficiency and a 20% reduction in server load. Successfully led a team of data analysts and visualization specialists to deliver dashboard & reports to stakeholders with zero SLA miss.

Data Analyst

• Job Details:Completed 30 projects and multiple ad-hoc project requests. Using Agile methodology - analyzed, defined, and documented project objectives to fulfill business requirements on JIRA. Queried, extracted, and validated data from server using Postgres SQL. Implemented automated data cleaning and preprocessing procedures, reducing data preparation time by 40% and improving data accuracy by 25%. Worked on creating interactive Tableau dashboards and applied actions (filter, highlight and URL). Identified key areas in profit and loss reports where organization should improve, leading to 5% increase in revenue for the program. Utilized statistical techniques such as regression analysis to identify factors influencing key business metrics, such as sales, customer retention, tele-sales performance for various regions. Forecasted sales for near future and validated forecasts with backward forecasting. Created different Tableau visualizations using bars, pies, bubbles, tree maps, highlight tables, heat maps, custom charts (donut chart, waterfall chart, bump chart).