Haneef Khan
Business Intelligence Developer @Allstate Canada
Signup · Get unlimited contacts
WORK HISTORY
Business Intelligence Developer @Allstate Canada
Allstate Insurance Company of Canada is a leading home and auto insurer focused on providing its customers prevention and protection products and services for every stage of life.• Worked of Python language for data analysis using Pandas and NumPy• Effectively completed a capstone project by collecting data from multiple sources, performing exploratory data analysis, data wrangling, statistical analysis, and mining of the data using Python libraries• Work extensively on creating charts and plots to visualize data, and building an interactive dashboard using IBMs Cognos Analytics and various Excel charts/graphs• Visualized the data using Python libraries including Matplotlib, Seaborn, Plotly, and Dash• Composed the queries to access data in cloud databases using SQL and Python from Jupyter notebooks• Explain cloud concepts, benefits of cloud computing, and core Azure architecture components• Developed Power BI model used for financial reporting and designed and documented the entire Architecture of Power BI POC• Involved in writing complex DAX functions in Power BI and Power Pivot• Automated Power Query refresh using power shell script and windows task scheduler• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc• Installed and configured Enterprise gateway and Personal gateway in Power bi service• Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily• Created stored procedures and SQL queries to pull data into power pivot model• Worked on Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
EDUCATION
Jawaharlal Nehru Technological University
Bachelor's degree
ABOUT HANEEF KHAN
5+years of experience in Data Analysis, Design, Developing, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining.• Experienced in SQL Server, SSRS, SSIS, writing Reports, Data Extraction, Queries, Stored Procedures using SQL, T-SQL.• Worked closely with Business users, Report developers and other members of Reporting teams to analyze and simplifying requirements.• Strong Experience with the Microsoft BI Tools (SSIS/SSRS/SSAS) and T-SQL using SQL Server.• Expertise in Power BI, Power BI Pro, Power BI Mobile and expert in creating and developing Power BI Dashboards.• Involved in IT Business Analytics, Data Analytics and Data Profiling tasks with business to make data more accurate and result oriented Experienced with marketing tools such as salesforce.com, LinkedIn campaign manager, Folloze, and 6sense a plus. • Experienced with Project management tools such as Dbeaver(Redshift), Asana, Trello. Used Dbeaver management tool to pull data by using SQL queries.• Good knowledge of data analysis, visualization using Power BI and SQL. Experience with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing, and Implementation. Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling, and reporting tools.• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts, and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation.• Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL, Physical, logical database design, and Performance tuning.• Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.• Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager Developed OLTP system (s) and involved in creating facts, dimensions, and Star Schema representation for the data mart and had expertise in OLAP and OLAP Cubes in SSAS.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.