Kanchan Wadhwani

Video Marketing | Client: AT&T Inc. | Domain: Business Intelligence and Data warehousing

• Worked on hierarchy expansion by modifying existing hierarchies to incorporate new levels.
• Worked on schema objects, updating tables in warehouse catalogs, creating and modifying attributes and relationships.
• Created various public objects such as metrics, filters, prompts etc as per requirement.
• Modified and worked on various dashboards to show expanded hierarchies through different sections.
• Extensively worked on validation of data in reports.
• Experienced in admin functionalities of MSTR such as setting up New Projects, security filters, movement of objects using Object Manager.

(CTH Position- Client Amdocs India Development Center)

EBIS Smart-M | Client: AT&T Inc. | Domain: Business Intelligence and Data warehousing | (April 2020 - April 2021)

• Worked of creating schema objects, public objects and mapping of objects to different tables.
• Worked on Transaction Services reports and dashboards.
• Worked on hyperlinked reports.
• Monitored End-to-End report runs and successful delivery.
• Worked on data validation and UI validation of reports.
• Worked on ticket handling and resolving of issues.
• Worked on query fixes, script fixes and monitored logs.
• Daily confirmation that all planned report and service schedules ran without error and taking appropriate action to recover any lost or failed processes.

AERS Migration | Client: AT&T Inc. | Domain: Business Intelligence and Data warehousing | December 2020-May 2021)

• Migration of Reports from MicroStrategy to Power BI.
• Migrating reports from MicroStrategy to Power BI with all the features.
• Using different database connections as data source during migration.
• Creation of Power BI dashboards, report and mappings.
• Worked on Data Modeling to create logical tables and transforming data • Feature compatibility or work around for several functionalities.
• Testing and data verification post migration of reports.
• Publishing reports to Power BI service

System-XR | Client: AT&T Inc. | Domain: Business Intelligence and Data warehousing | (September 2019 – March 2020)

• Worked on monitoring reports delivery.
• Monitored narrowcast distribution and services.
• Creation and modification of subscriptions and schedules.
• Ticket handling and resolving in given timelines.
• Adding and removing of users in distribution list of subscriptions.

India LLR BO-MSTR Migration | Domain: Business Intelligence and Data warehousing | Client: Citi Bank(January 2018 – March 2019)

Citibank Business helps you reduce the risks and uncertainties associated with commercial transactions. Minimize the buyer’s cost, maximize the seller’s offer, and manage the commercial, political and currency risks on both sides with our trade finance products.

• Developed and recreated the BO reports in MSTR as per client’s requirement.
• Created datasets and Worked on metrics, derived metrics, attribute, filter, prompt creation.
• Creation of MSTR dashboards, report and VI dashboards.
• Implemented thresholds, advanced sorting, totals and prompts.
• Performed unit testing of data for the report.

CTO-BCBS-DFP Reporting & Dashboard | Domain: Business Intelligence and Data warehousing | Client: Citi Bank (January 2017-December 2017)

• Worked on metric creation, attributes, report creation.
• Formatting of MSTR dashboards and reports under Citi guidelines.
• Created Reports as per the client requirement according to the templates given.
• Testing of developed reports.
• Data validation and UX validation of data in reports.