Shalu Gupta

An analytical and logic-based information technology professional who has 4+ years of Power BI experience as well as a broad background in database programming. Flexible with changing project guidelines, my knowledge and agility with using the PowerBI results in solutions where absolute accuracy in reports takes place.

Skills: Power BI Desktop, Power Bi service, SQL Server, MYSQL, Dataflows, Power Automate, Google Big query , ADF

Languages: SQL, MYSQL ,PLSQL

Database: MYSQL, Dataflows, MS-Access, MS Excel, Google Big query

Operating systems: Windows 7,8,10/NT/2000/XP/2003

Other Tools: DAX Studio, Power Bi Helper, Workbench, DBeaver

Project 1:

Project Title : Developing Report and Dashboard, Club Apparel, Danbro,

                        Nukebox,

Duration        : 10/01/2019 - Ongoing, 

Roles and Responsibilities:

• Responsible for developing and build the Reports/Dashboards and deploy into Power BI.
• Com service,
• Responsible Import, reshape and model the data.,
• Responsible Create App Workspaces and content packs to share your insights.,
• Responsible for import data from MYSQL and build the dashboards as per the requirement.
• Responsible for schedule the dashboards according to frequency (daily, weekly) and incremental refresh.
• Responsible for creating Workspaces and share insights to specific business customers/partners and stockholders.
• Managed relationship with programmers and bridged communication between end users and development team, Responsible for identifies the projects stakeholders and figures out what they need.
• Responsible for providing the securities for reports/dashboards by assigning roles.
• Responsible for coordinate with offshore development team, assign them tasks and help with any technical queries.
• Supported in QA testing.
• Implemented Incremental script to take last day data from prod to reporting DB.

Project 2 :

Project Name : Event Gifting Module Development

Client                 : Tech tree It Private Ltd, 

Duration           : 01/01/2021 - 03/30/2021, 

Roles and Responsibilities: 

• Worked on creating database design for the event gifting module.
• Created table, index, constraint, function and stored procedure to insert data from api to database.
• Created trigger to maintain the audit table., Worked on Housekeeping of DB to remove unwanted data from DB.
• Created trigger as per requirement.

Project 3 :

Project Name : Gift Card Module Development

Client                 : Tech tree It Private Ltd, Bangalore

Duration           :  10/01/2019 - 02/28/2020, Worked on creating database Roles and Responsibilities: 

• design database as per the requirement.
• Created table, index, constraint, function, trigger and stored procedure to insert data from api to database.

Project 4 :

Project Name : Tata Star Buck

Client                 : Tata Star Buck

Duration            : 06/01/2022 - 02/28/2023

Roles and Responsibilities: 

• Worked on creating database design as per the requirement.
• Created table, index, constraint, function, trigger and stored procedure to insert data from api to database.
• Created ADF (Azure data Factory) Pipeline to move data from Client Db to Our DB.

Father's Name: Naresh Gupta

Date of Birth: 05/10/95

Nationality: Indian

Marital Status: Married

Religion: Hindu

Language: English, Hindi

I hereby declare that the information above is true to the best of my knowledge and belief.