Anita Kankand Resume MSBI 2.0 C

ANITA KANKAND
Woorbridge, ON L4L6K5 | 647-979-8914| anitakankad01@gmail.com
Professional Summary
 Experienced ETL developer with 4+ years of experience developing and maintaining ETL solutions
for enterprise-level organizations.
 Skilled in designing and developing ETL processes using tools to integrate data from various
sources into data warehouses or data marts.
 Good Working Experience in creating packages for implementing ETL Methodology by using
various Control Flow Tasks, Containers, and Data Flow transformations while migrating the data
from source to destination. Hands-on Experience implementing Checkpoints and Configurations.
 Expert in implementation of Event Handling, Maintaining the Log and Audit information in the SQL
tables.
 Extensively involved in T-SQL Stored Procedures, Functions, Views, Indexes, Triggers, Sub-queries
implement best practices.
 Gathered report requirements and determined the best solution to provide the results in either a
Reporting Services report or Power BI.
 Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data
massaging.
 Designing and developing ETL (Extract, Transform, Load) processes using SQL Server Integration
Services (SSIS) to extract data from various data sources, transform it into the desired format, and
load it into data warehouses.
 Sound Knowledge of Power Bi Reports.
 Experience developing Custom Reports and different types of Tabular Reports, Matrix Reports,
and drill-down reports in multiple formats using SQL Server Reporting Services (SSRS) in the
Business intelligence development studio (BIDS).
 Experience importing/Exporting Data from various heterogeneous data sources to SQL servers
using transformation of OLTP data to the Data Warehouse using SSIS.
 Working with SQL Server Job scheduling to execute Integration Services packages and send
reports to the client.
 Ability to work in groups as well as independently with minimal supervision.
 Good team player, strong interpersonal and communication skills combined with self-motivation,
initiative and the ability to think outside the box.
Skills
 Database Technologies: SQL Server  Version Control / Code Management: GitHub,

2012/2016/2019 Bitbucket
 DWH Technologies: SSIS, SSRS, Power BI  Operating System: Windows, Linux, and Unix
 Programming Languages: Java, C# (.Net)  Development Tool: Visual Studios, GitHub.
 IDE: SSMS 2019, Visual Studio 2017
Work History
ETL/MSBI Developer 03/2022 to Current

MintexTech USA
 Collaborated with cross-functional teams to gather and analyze business requirements,

translating them into robust database solutions. Demonstrated proficiency in all aspects of the
development lifecycle, including architecture, analysis, design, testing, development,
deployment, documentation, and implementation.
 Developed, identified, designed, built, tested, optimized, and maintained a Data Warehouse
using the entire Microsoft BI Stack
 Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
 Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
 Translate requirements and generate and develop a roadmap utilizing the best technologies for
the project with comprehensive and obtainable milestones.
 · Extensively used SSIS transformations such as Lookup, Derived column, Data conversion,
Aggregate, Conditional split, SQL task, Script task, and Send Mail task etc.
 Developed drill-down and drill-through reports, facilitating the exploration of data details and
child reports within Power BI based on hierarchical structures.
 Created databases and schema objects, including tables, indexes and applied constraints;
connected various applications to the database and written functions, stored procs and
triggers.
 Develop and deploy dashboards, visualizations, and autonomous and dynamic reporting
interfaces to be distributed to stakeholders via the BI reporting platform, web portal, mobile,
tablet devices, widgets, and email.
 Work with the Data Management team to provide input on logical and physical database
design, data modelling and/or mapping.
 Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
 Solve technical and data-related problems to meet the needs of the business.
 Prepare & maintain documentation for reports, metrics, and processes.
 Transforming data to meet business requirements, including cleaning, filtering, aggregating, and
formatting data.
 Ensuring data quality and accuracy by implementing data quality checks and validation rules.
 Tuning ETL processes for optimal performance, including optimizing database queries,
partitioning tables, and optimizing ETL workflows.
 Creating and maintaining documentation for ETL solutions, including data dictionaries, flow
diagrams, and other technical documents.
 Test and prepare ETL processes for deployment to production and non-production
environments.
Database -BI Developer 01/2017 to 11/2020

Data Lynx Pvt. Ltd
 Designing and developing databases that are optimized for performance, scalability, and
security.
 Writing and optimizing SQL code to retrieve, manipulate, and analyze data from databases.
 Developing and maintaining database objects such as tables, stored procedures, views, and
triggers.
 Administering databases, including monitoring database performance, ensuring data integrity,
and managing security.
 Integrating data from various sources into SQL Server databases using ETL (Extract, Transform,
and Load) processes.
 Analyzing database performance issues and optimizing SQL code to improve database
performance.
 Creating reports using SQL Server Reporting Services (SSRS) or other reporting tools. (Power BI)
 Collaborating with other developers, business analysts, and stakeholders to ensure database
solutions meet business requirements.
 Creating and maintaining documentation for database solutions, including data dictionaries,
data flow diagrams, and other technical documents.
 Staying up to date with the latest database technologies and best practices and continuously
improving skills through training and professional development.
Internship - Data Analytics 07/2016 to 12/2016

Kyrosdigital
 Gained hands-on experience with data analytics tools and techniques.

 Worked on data extraction, transformation, and visualization projects, including cleaning and
preprocessing data for analysis.
 Assisted in creating reports and dashboards to support business decision-making.
 Conducted exploratory data analysis (EDA) to identify trends and patterns in datasets.
 Collaborated with senior analysts to contribute to ongoing data projects, such as market
research and customer segmentation.
 Assisted in the development of data-driven recommendations to improve business processes
and efficiency.
Education
Advanced Diploma in Database Business Intelligence 11/2021

TrainingHub.io
Bachelor of Engineering : Electronic And Communication Engineering 06/2016

Gujarat Technological University

Anita Kankand Resume MSBI 2.0 C

Uploaded by

Copyright:

Available Formats

Anita Kankand Resume MSBI 2.0 C

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Anita Kankand Resume MSBI 2.0 C

Uploaded by

Copyright:

Available Formats

ANITA KANKAND

Woorbridge, ON L4L6K5 | 647-979-8914| anitakankad01@gmail.com

 Database Technologies: SQL Server  Version Control / Code Management: GitHub,

ETL/MSBI Developer 03/2022 to Current

 Collaborated with cross-functional teams to gather and analyze business requirements,

Database -BI Developer 01/2017 to 11/2020

Internship - Data Analytics 07/2016 to 12/2016

 Gained hands-on experience with data analytics tools and techniques.

Advanced Diploma in Database Business Intelligence 11/2021

Bachelor of Engineering : Electronic And Communication Engineering 06/2016

You might also like