I A

I A Email and Phone Number

Azure BI Analyst || Power BI, SSRS, SSAS, SSIS SQL, T-SQL, DAX, SSIS, Pentaho, Azure Data Factory,Microsoft Azure BI (ADF, ADLA, U-SQL), Azure Data Bricks, Azure Synapse, JIRA, SVN, GIT,SQL Server ,MS Windows @
I A's Location
Toronto, Ontario, Canada, Canada
About I A

• I am having overall 6 + years of experience in the software industry. • Having experience in requirement gathering, design, development, and deployment of BI Reports. • Hands on Experience in Dimensional modelling using Star Schema, Snowflake Schema. • Having experience in Designing and Developing the ETL Data flows to extract the data from different sources and loaded into various business entities. • Have excellent working experience in Performance Tuning and Query Optimization.• Have worked on both On-premises and Cloud versions of SQL Server.• Have worked on setting up the Azure Cloud environment as well as integrating various data sources on Azure.• Have worked on Azure Data Factory, Integration Runtime, Azure SQL, Web Automation Account, and other Azure features.• Having experience in the development of Database & BI Reporting using technologies such as MSBI (SSIS, SSAS, SSRS), Power BI (DAX), Azure BI, SQL Server.• I have worked on both OLTP & OLAP Systems.• Have data modelling experience as well.• Experience in all the phases of System Development Life Cycle (SDLC) such as analyzing, designing, coding, testing, debugging, deployment, and documentation.• Worked closely with clients and peers to understand business requirements for the development of new/ up gradation of existing applications including project management documentations.• Hands on experience in implementing out of the box functionalities, UI and UX design and customizing forms and business workflows using Power Apps and Power Automate.• Implemented Power BI gateway different sources to matching analysis criteria and further modeling for Power Pivot and Power View.• Prepared ETL processes according to business requirements and incorporate all business requirements into all design specifications.• Adept in learning and implementing new technologies in dynamic IT environment.• Debugging and problem-solving skills with good understanding of system development methodologies• Performed dimensional handling and data modeling, created graphs and charts for analytics.• Automated the daily data refresh activity starting from downloading data from vendor portals and utilizing T-SQL and power query to normalize the data and publish the latest data to Power Bi service.• Identifying issues and risks associated with the project.• Prepared all functional, technical specification documents and High-Level Document preparation.• Designed and generated reports as per the specifications.• Worked closely with cross-functional teams to identify and evaluate data requirements.

I A's Current Company Details
George Brown College, Toronto, ON.

George Brown College, Toronto, On.

Azure BI Analyst || Power BI, SSRS, SSAS, SSIS SQL, T-SQL, DAX, SSIS, Pentaho, Azure Data Factory,Microsoft Azure BI (ADF, ADLA, U-SQL), Azure Data Bricks, Azure Synapse, JIRA, SVN, GIT,SQL Server ,MS Windows
I A Work Experience Details
  • George Brown College, Toronto, On.
    Azure Bi Analyst
    George Brown College, Toronto, On. Mar 2021 - Present
    Technologies Visual Studio 2019, Power BI, SSIS, Azure BI, SSMS, SQL Sentry Explorer, Jira, Bitbucket, T-SQL, SSRS, SSAS, Azure Data Factory, Azure Synapse, Web JobsResponsibilities • Interacting with the client to understand requirements and making design decisions along with the architect.• Working on Microsoft Business Intelligence (MSBI) Technologies (SSAS (DAX, MDX), SSIS, SSRS) and Azure Data Factory, ADLA(U-SQL), Azure Data Bricks & Power BI.• Hands on experience in DWH/BI Profile using Microsoft (MSBI) Technologies.• Creating Azure Data Factory pipelines for data pull, scheduling the pipeline run.• Creating Azure Analysis services instance for analyzing the data in the required view.• Creating Azure Power BI Reports using custom visuals and writing DAX queries.• Hands on experience in Dimensional Modelling using Star & Snowflake Schema.• Designing and developing Complex Power BI Dashboard.• Generated custom and parameterized reports on Power BI Desktop.• Requirements and Analysis: Understanding the requirements of the stakeholders• Transforming the functional requirement into technical requirement• Discussing business rules and documenting it along with data dictionary• Impact analysis of the number of ETL components to be modified/developed• Creating the high- & low-level design documents and presenting it in review meetings• Making the code changes, spot checking, Test Case preparation for Unit testing• Working with various source systems like Flat files, DB tables, SAP, Salesforce, API• Unit test the newly developed, modified, and impacted components• Review of code components changed by peers• To write the SQL Queries to retrieve and verify the data loaded into the Database• Communicate the completion to Technical/Business Stakeholders
  • Slalom, Toronto, On.
    Business Intelligence Developer
    Slalom, Toronto, On. Dec 2019 - Feb 2021
    TechnologiesVisual Studio 2013, Tableau, SSIS, SSRS, SQL Server 2016, Git, SSAS,Responsibilities • Developing the application code to meet the customer requirements • Co-ordinate with Different business Stakeholders.• Designing and developing Complex Tableau Dashboard.• Design and implement ETL Solutions in SSIS, Data Manager. Write code in TSQL.• Design and implement OLAP cube solutions in SSAS. Write MDX scripts to fetch data from OLAP cubes.• Develop reporting framework in various reporting and visualization tools such as SSRS.• Creating customized SSRS report for displaying the KPIs as per their status indicators.• Extensively worked in data Extraction, Transformation and Loading data from source to target system using SSIS.• Worked on database design, functions, views, and Procedures at database end using SQL Server • Extensively worked on SSRS Reports. Actively worked on deployment, monitoring and support• Review and Analysis of Business, Functional, Technical requirements, and documentation of requirements• Involved in code review process.• Worked on DBA Activities as well.• Monitoring the project executions to ensure the first-time right deliveries on time.• Was responsible for developing the database structure and ETL packages.
  • Home Depot, Toronto,On
    Database Developer
    Home Depot, Toronto,On Sep 2017 - Nov 2019
    Technologies SQL Server 2012, SQL Sentry Explorer, Red Gate Tools, SSIS, SSRS, C#, PowerShellResponsibilities • Design and implement ETL Solutions in SSIS, Data Manager. Write code in TSQL.• Creating customized SSRS reports as per requirements.• Requirements and Analysis: Understanding the requirements of the stakeholders• Transforming the functional requirement into technical requirement• Discussing business rules and documenting it along with data dictionary• Impact analysis of the number of ETL components to be modified/developed• Writing optimized queries.• Writing procedures, functions, packages, and triggers.• sing all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, and Check, Unique etc.) and Generating Complex Transaction SQL (T-SQL) Queries and Sub queries.• Maintained all the maintenance jobs in all the servers.• Monitor SQL Server Error Log space.• Database Monitoring/ Performance tuning.• Also developed SSIS packages transferring significant amount of data from a relational transactional database to flat files/spread sheets/xml files. • Writing the Queries/Procedures, Functions and Triggers as per reporting needs and making sure that Business Logic is taken care of.• Experience in Maintenance Tasks Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC check Data Integrity and, Update Statistics• Handling all the Database Changes requested by the Application Team.

Frequently Asked Questions about I A

What company does I A work for?

I A works for George Brown College, Toronto, On.

What is I A's role at the current company?

I A's current role is Azure BI Analyst || Power BI, SSRS, SSAS, SSIS SQL, T-SQL, DAX, SSIS, Pentaho, Azure Data Factory,Microsoft Azure BI (ADF, ADLA, U-SQL), Azure Data Bricks, Azure Synapse, JIRA, SVN, GIT,SQL Server ,MS Windows.

Not the I A you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.