Senior Business Intelligence Developer
Current• Developed QlikView load scripts in 3 Tier Architecture – Source Layer (Database), Transformation Layer(QVD), Presentation Layer according to the requirements of the End User.• Ensured the data model is efficient and solved synthetic keys and circular loops formed while building the data model.• Established the connection string and extracted the data from several source systems like Oracle, Linked servers in the SQL and Excel sheets.• Implemented the Incremental Load strategy to improve the loading performance.• Built the front end Qlikview Dashboard by using various in built and widely accepted components which fulfills the requirements of the users.• Emphasized on data integrity to good chart aesthetics.• Implemented Section Access and hidden scripting for the Application Security.• Designed intuitive visuals utilizing; containers, charts, pivot tables, straight tables etc.• Extensive use of SET Analysis expressions in the charts for achieving complex logics.