Vignesh Subramanian Email & Phone Number

Prague, Cz

Prague, Czechia

As a BI Team Lead, I am responsible for designing and implementing data warehouse flows and schemas to support analytics. I take ownership of the data warehouse and ensure the integrity of all information loaded into it. Additionally, I am accountable for end-to-end project delivery, from development to deployment and ongoing support.To ensure high-quality output from the BI team, I oversee code quality by reviewing team members work, identifying errors, and providing feedback. I also coach and mentor BI developers and BI analyst developers to help them improve their skills and achieve their goals.As part of my role, I maintain awareness of the overall BI strategy and ensure it is implemented across the team. I also ensure operational support for the business and effective resolution of technical issues for BI processes.To support our DevOps approach, I define and specify development, testing, release, update, and support processes. I also identify and deploy cybersecurity measures through continuous vulnerability assessment and risk management to protect our data and systems.Overall, my experience highlights my technical expertise in BI development, project management skills, and leadership qualities. I am dedicated to delivering high-quality solutions that support business goals and improve the user experience.

Chennai, Tamil Nadu, India

As a BI Developer, I was responsible for delivering end-to-end BI solutions by working closely with business stakeholders to understand their requirements and translate them into technical requirements. I designed and developed data warehouses and data marts using SQL Server and SSIS, resulting in data marts that were used for reporting, data mining, and data analysis.I also developed data models using SSAS Tabular and Power BI, which were accessible to power users for data analysis and reporting. I designed and maintained reports and dashboards using Power BI, SSRS, Excel, and advanced SQL in Microsoft Azure to support the decision-making processes for the business.To ensure efficient deployment and version control of BI solutions, I managed version control using TFS/Azure DevOps, creating branches and merging changes with other developers. I also managed the UAT and production deployment of the BI, resulting in a 30% reduction in deployment time by executing SQL Compare and Azure DevOps CI/CD pipelines on a weekly basis.In addition, I provided support to ensure the availability and performance of developed reports and dashboards by monitoring and resolving data quality issues, automating manual processes, and maintaining data integrity. I proactively monitored existing SQL jobs, workloads, subscriptions, Power BI Data Gateway, and Power BI to ensure that the system was functioning properly and completed the necessary actions to fix any reported issues.I also designed and delivered Power BI user training and training materials to help users effectively use the BI solutions. Overall, my experience highlights my technical expertise in BI development, project management skills, and dedication to delivering high-quality solutions that meet business needs.

Chennai Area, India

As a BI Developer, I was responsible for delivering end-to-end BI solutions by working closely with business stakeholders to understand their requirements and translate them into technical requirements. I designed and developed data warehouses and data marts using SQL Server and SSIS, resulting in data marts that were used for reporting, data mining, and data analysis.I also developed data models using SSAS Tabular and Power BI, which were accessible to power users for data analysis and reporting. I designed and maintained reports and dashboards using Power BI, SSRS, Excel, and advanced SQL in Microsoft Azure to support the decision-making processes for the business.To ensure efficient deployment and version control of BI solutions, I managed version control using TFS/Azure DevOps, creating branches and merging changes with other developers. I also managed the UAT and production deployment of the BI, resulting in a 30% reduction in deployment time by executing SQL Compare and Azure DevOps CI/CD pipelines on a weekly basis.In addition, I provided support to ensure the availability and performance of developed reports and dashboards by monitoring and resolving data quality issues, automating manual processes, and maintaining data integrity. I proactively monitored existing SQL jobs, workloads, subscriptions, Power BI Data Gateway, and Power BI to ensure that the system was functioning properly and completed the necessary actions to fix any reported issues.I also designed and delivered Power BI user training and training materials to help users effectively use the BI solutions. Overall, my experience highlights my technical expertise in BI development, project management skills, and dedication to delivering high-quality solutions that meet business needs.

Chennai Area, India

As a Solutions Specialist, I leveraged my expertise in BI to deliver tailored solutions that were specifically designed to align with each client's unique business requirements and data environments, resulting in increased customer satisfaction and improved business performance. I successfully conducted proof-of-concept projects using Power BI to showcase the platform's capabilities and to demonstrate how it could be customized to meet the specific needs of potential customers.In addition, I effectively applied my strong technical skills in SQL Server and SSIS to manage data conversion, import, and export processes across various internal and external software systems. By streamlining data management processes and enhancing data quality, I helped to optimize overall system performance.Finally, I delivered impactful Power BI reports and dashboards that provided valuable insights into various aspects of the company's performance. Working collaboratively with decision makers across departments and business units, I helped to inform and empower data-driven decision-making.

Chennai Area, India

As an Energy Analyst, I conducted comprehensive analyses of energy consumption in buildings using advanced Excel functions such as pivot tables, VLOOKUP, and SUMIF formulas. These analyses enabled me to identify cost and usage patterns for each building type over the past year.Furthermore, I collected and analyzed key business metrics for a prominent US energy retailer, including customer volume, revenue, and power usage. By doing so, I identified opportunities for revenue growth, improved customer experience, and enhanced business outcomes.To better monitor and invoice the energy supply, I designed and developed custom reports and dashboards that tracked Key Performance Indicators (KPIs). These KPIs encompassed critical factors such as energy consumption, generation, and weather data, providing valuable insights for decision-makers.Finally, to ensure that projected savings were achieved and quantifiable results were delivered, I validated savings post-project implementation by conducting monthly electricity usage comparisons for facilities pre- and post-project. This meticulous approach allowed me to deliver exceptional value to my clients.

Chennai Area, India

Thesis work on “Materials Integrated in Molded Plastics”

Chennai Area, India

Internship training on “Design of shell and tube heat exchanger for desalination”

Post Graduate Diploma In Data Analytics, Data Analytics

Bachelor Of Engineering (B.E.), Mechanical Engineering

Activities and Societies: CrankX, SAE, Instincts, NSS

Hsc

Activities and Societies: NSS