Vidhya K
Analyst
CHENGALPATTU,TAMILNADU
Summary
- An experienced IT analyst in Business Intelligence with 12+ years of experience in Reporting & Analytics with good technical communication and interpersonal skills.
- Expertise in working with Data Warehousing and business intelligence tools for developing various reports using QlikView, Power BI, Tableau and can able to decode of Webfocus coding.
- Experience in full life cycle project development, including design, coding, testing and implementation with ongoing product support. Strong analytical database design and Data Modeling (Star Schema, Snowflake Schema, Circular loop) skills in Qlikview and Power BI.
- Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and Workflow Development, data cleansing, data quality validation and unit testing.
- Interacted with Customers for requirement gathering and effective analysis.
- Supported all phases of a project life cycle including analysis, design, development, testing, deployment of solutions, and postproduction support/maintenance functions.
- Developed Macros, set analysis to provide custom functionality in QlikView Applications Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar creation by using Master Calendar concept.
- Experience in designing QlikView & PowerBI Document/User Setting, Layouts to make consistent and professional optimized look to clients. Expert in Data warehousing concepts - Star Schema, Snowflake Schema, Multi-Dimensional modeling & Entity-Relationship modeling. Strong knowledge on creating Master Calendar and Qlik N printing.
- Hands-on experience with Microsoft Fabric tools like Data Flow, Data Pipeline, Data Warehouse and Azure Analytics Tool.
Overview
13
13
years of professional experience
1
1
Certification
1
1
Language
Work History
Analyst
TATA Consultancy Services
06.2012 - 09.2025
- Clients:
Microsoft Mobile Oy – Retail Domain,
The Home Depot – Retail Domain,
Citi Bank – Banking Domain,
Visteon – Manufacturing Domain.
Roles and responsibilities:
- Understanding the requirements and implementing them according to the business needs in QlikView.
- Gathered and loaded data into QlikView from various data sources (SQL Server, Oracle 10g, .CSV, and Excel files).
- Created dashboards with different styles using QlikView components, like list boxes, sliders, buttons, charts, and bookmarks.
- Developed linked tables, concatenation, and solved the loop issues.
- Implemented incremental load to improve load time.
- Tested applications, ensuring the application met the requirements, and data quality for quality assurance before delivering to the end users.
- Applies security to the document (section access) and QMC server level (reduction, distribution, and loop).
- Responsible for maintenance and enhancement of a Forecasting database (MS Access Project front end and SQL Server backend).
- Generate an output file from the QlikView table object, and distribute it to users by their respective regions using Qlik NPrinting.
- Writes QlikView and SQL scripts to load relevant data, and uses VB macro and set analysis to create customized reports.
- Leverage query folding techniques to push the data transformations back to the data source, ensuring faster data refreshes, and more efficient resource utilization.
- Reviewed QlikView and Power BI error logs, and provided production support.
- Responsible for training and giving guidance to the team for the development and maintenance of the above systems and reports.
- Responsible for analyzing data reports to find system bugs, data integrity issues, and process issues.
- Migrated and served as the technical lead for Qlik dashboards from QlikView to Power BI.
- Tools and technologies:
- QlikView 11.2, Tableau 9.2, QlikView 12.4, Power BI, WebFOCUS, QMC, Qlik NPrinting, Azure Analytics Tool, ETL – Data Pipeline, Microsoft Analytics Tool, Python (Data Analysis, Automation).
Education
BE - EEE
Govt.College of Technology
05-2012
XII - Maths- Biology
Govt. Girls. Hr.Sec School
Uthangarai03-2008
X -
Govt. Girls. Hr.Sec School
Uthangarai03-2006
Skills
- BI Platforms: Power BI, QlikView, Qlik Sense,Tableau,PowerBI
- Data Tools & Languages: SQL, DAX, JavaScript (for Qlik extensions), Python
- ETL & Data Management: data modeling, data integration
- Cloud Platforms: Experience with Azure cloud services
- Other Tools: Excel, Tableau, SSRS, Version Control (Git)Qlikview,Qliksense,Tableau,PowerBI,
Awards and Achievements
- Technical Excellence Award from Visteon Client.
- Awards for handling Qlikview report refresh failure and QVD file Corruption,Performance Improvement and ensuring high availability and minimizing business disruptions.
- Technical excellence award(06/2025) for successfully migrating from qlikview dashboard to Power BI.
- Received many on the spot award from account level in TCS.
Certification
Qlikview E2
Timeline
Qlikview E2
04-2023
Analyst
TATA Consultancy Services
06.2012 - 09.2025
BE - EEE
Govt.College of Technology
XII - Maths- Biology
Govt. Girls. Hr.Sec School
X -
Govt. Girls. Hr.Sec School