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).