Akshara Ch Email & Phone Number

Toronto, Ontario, Canada

• Developed ETL pipelines using Azure Data Factory to extract, transform, and load data from various sources into Azure Data Lake.• Built and managed a data lake using Azure Data Lake Storage Gen2 and set up data ingestion pipelines to load data from on-premises and cloud-based sources.Designed customized data collection models for specific visualization tasks. • Created and maintained data pipelines using SSIS for on-premises data sources and integrated them with Azure Data Factory to ensure seamless data transfer.• Designed and implemented Azure SQL databases for storing and querying data for Power BI reports and dashboards.• Optimized queries and data models in Azure SQL to improve report performance and reduce query times.• Developed data models in Power BI using Azure SQL data sources and ensured data accuracy, consistency, and completeness.• Designed and developed Power BI reports and dashboards using data from Azure Data Factory, Azure Data Lake, and Azure SQL.• Collaborated with business stakeholders to understand their reporting needs and provide insights using Power BI visualizations.• Developed intelligence-sharing dashboards, providing company-wide access to collected data. • Collected data from wide-ranging sources.• Code merges into GitLab repositories.

Toronto, Ontario, Canada

• Design SSIS packages to extract and transfer/load the data into SQL server databases from the different environment for SSAScubes.• Hands on packages deployment into servers to run with SQLagent.• Involvement in setup and maintain documentation/standards.• Exposure to development activities such as analyzing and designing the application, performing unit/regression test cases and Power BI reports using visualization.• Exposure to TFS to check-in/checkout the codes.• Exposure to data warehouse and tabular model.• Analysis and performance tuning for complex queries.• Creation of test cases and perform regression testing in HP ALM tool.• Exposure to publish Power BI reports and dashboards in Power BI server and Schedule the dataset to refresh for upcoming data in power BI server.• Coordination with the QA team and helped them come up with test scenarios. Worked on knowledge transfer and documentation of various jobs developed and deployed into production. • Use of SSAS for debugging purposes, having basic knowledge of it. • Have good experience on GITHUB code repository.

Kolkata, West Bengal, India

• Developed T-SQL (DDL and DML) statements in creating Tables, User Defined Functions, Views, Complex Stored Procedures, Relational Data Base Models, and Triggers to facilitate efficient data manipulation and consistent data storage.• Analysis on the Data quality, Data validating, Data Mapping to migrate data to LMB_DW. • Analysis business requirements and implemented data mart solutions for data mining and reporting. • Interaction with customers, gathered requirements and provided value addition to the client during support phases. • Development of SSIS packages which involves variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse. • Created SSIS packages for File Transfer from one location to the other using File system task. • Developed, Code Reviewed, fixed bugs, tested, deployed, monitored SSISpackages.• Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in the data warehouse. • Involvement in unit testing.• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project. • Monitored jobs and resolved all failures on time. • Exposure to Schedule Jobs in SQL Server.• Active interaction with DBAs to re-execute production jobs after fixing and any redeployment if needed. • Automated all status emails which we send users on daily basis.