Business Intellegence and Data Analytics expert with 6 years of Industry experience

8/2016 – 8/2017

• Gathering requirements from end users, preparing the checklist documents and involved in modifying various technical & functional specifications.
• Developed MDM with Informatica and managed SSAS qubes and defined data wirehouse with SSIS
• Hands-on experience in the design, development of end user applications for the data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using QlikView 11 BI platform and Tableau.
• Extracted information from different data sources like JDE, SAP, Oracle, SQL Server, MS Access and flat files by using different scripts like add, concatenate, resident, qualify , unqualified etc.
• Wrote SQL queries and created ad hoc queries to perform data validation and analysis Designed reporting packages for report authors.
• Created data warehouse using SSIS and responsible for creating cubes for data analysis.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports
• Developed QlikView and SSRS Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island. Also, installed and deployed them accordingly.
• Created of the tasks, scheduling of the applications, reloading of data, distribution of applications and reducing the size of application at Qlikview Publisher.

Tableau, Microsoft Business Intelligence, Transact-Sql, Microsoft SQL Server Reporting Services (SSRS), Qlikview, Oracle Database

1/2016 – 7/2016

Working as database Developer and guiding the whole team for the front end requirement. Planning for future BI cubes and design in SSAS platform.
My responsibilities was :
 Requirement understanding from requirement document provided by client.
 Understand the use cases and deliver to the team.
 Finalization of the product requirement and creating phase wise plan
 Developing and upgrading features and design the whole database structure.
 Writing T-SQL to handle complex functionalities.
 Performance tuning with bulk data and load testing.
 Preparing the server box to set up the new application.
 Working with SIT team to fix defects and ensure quality delivery

Tableau, Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL-Server (MS SQL), PL/SQL