Puja Shete

To seek a growth-oriented position where my technical knowledge, skills and aptitude can be properly utilized and developed continuously leading to the growth of the organization.

13+ Years of experience in Data Analysis, Data Modelling, Reporting & Visualization and ETL Solutions. 5+ years of experience in Microsoft Business Intelligence and developing, Reporting and Scalable Enterprise applications to the client needs including DWH, Data Migration/Data Management projects Experienced in managing the complete SDLC, including analysing client requirements, estimation of work, design, requirements development, test planning, delivery, support and documentation. Experience with Azure Data Factory (ADF), Azure Data Lake Store (ADLS), Azure SQL Data Warehouse, Azure SQLDB Experience with Sql-Server Analysis Services Tabular Model Developed and implemented ETL processes by using SSIS to move data from different sources to targets using various types of transformations. Expertise in writing Stored Procedures, Stored Functions, Database Triggers, Packages using SQL Server. Actively involved in various project phases: Requirements Analysis, Database Design, Coding, Testing and Documentation Ability to quickly adapt to new environments and learn new technologies. Good Exposure on SQL Server Performance Tuning for enhancing the load performance in various schemas across databases. Experienced in Team Management, Service Management and Delivery Management Good Knowledge of Incident Management, Problem Management and Change Management. Team handling and management, task distribution and allocation among database team. Involvements in Project kick off meetings, JAD Sessions, Use case Walkthroughs, inter team discussions and client’s interactions. Expertise in analysis the system requirements from SRS, Use Case and existing applications. Responsible for maintaining Project Plan, Training plan, Risk register, Resource Plan, Other documents. A good team player with understanding of all aspects of the project activities Passionate about learning new things and implementing them in real-time scenarios.

• Tech Mahindra Ltd, Data Governance - Migration, AZURE SQL DB, SQL Server 2008, 2005, 2000, ADF – Pipelines, Power BI, Data Analyst / Power BI Developer, Create ADF Pipelines and Triggers to ingest Data in Azure SQL DB, Working on design and development of Finance reports using Microsoft PowerBI, Paginated reports from Azure Data Lake, Azure SQL DB as the source., Implement Row Level Security to restrict users level access of the data from other location’s based on the user Authentication in Azure directory., Used Many Features of the PowerBI design and developed advance PowerBI reports with respect to visualization like KPI, Bookmarks., Define and create multiple workspaces in PBI Services and their access for the users and super users., Scheduling and maintaining refresh schedule of the PowerBI Reports which moves to production., Carry out the Unit test for the Reports developed., Responsible for the Postproduction Support, Enhancement, change Request and Visualization and data issues., Responsible for Quality initiatives and Standards during the project tenure., Onsite-offshore coordination and communication with SMES.
• Tech Mahindra Ltd, Data Governance - Reporting, ADF – Pipelines, Power BI, Data Analyst / Power BI Developer, Analysis of the on prem reports and understand the business logic., Created MS-PowerBI Reports and Dashboard and from Azure SQL databases., Worked on SQL and DAX queries to generate complex calculation., Carry out the Unit test for the mappings developed., Responsible for Quality initiatives and Standards during the project tenure., Onsite-offshore coordination and communication with SME.
• AMDOCS DEVELOPMENT CENTER INDIA, Technical & Business Operations Analyst, Currently working as Technical & Business Operations Analyst in Production Support Environment for US based Telecom Client., Major responsibility is Error management (2G / Turbo charging)., Handling MRC & DRC Audits., Developing SQL Queries and Unix Scripts for Extracting Usage Data and Performing Validation of different client related Reports., Granting access to various Users to Internal Tools., Resolving DB related issues from Dev Teams which are internally or externally raised by Customer or Client through BMC Remedy Tool., Developing & Executing SQL queries to retrieve data for some specific checks which are required to minimize the manual efforts., Working on various tools including Citrix, BMC Remedy - UTS, Toad and Putty etc., Responsible to check data between Amdocs Ensemble Tables and Enabler Tables., Performs detailed invoice validation consisting of rating, display and overall formatting for each bill cycle., Validation of Due date, RC, OC, Airtime, Taxes, Roaming, SOC & Price Plan., Performing Special Checks on Price Plans., Responsible for Quality & Revenue Assurance of Invoice., Complaint Management., Billing Audit on Usage, Non-Usage and Revenue Reports., Analysis on Charges for Last 6 month’s bill generated., Performing billing audits, which includes financial trending and analysing and investigating exceptions., Reviewing the Trending from management within given turn- around time., Follow up at the time to bill generation to update the files on server if found any error escalating to Management & resolving by arranging Breach with client., SMS Blast to management for passing information like Bill Cycle Approval, reports Delivery and Prediction for Cycle., Preparing Balance Sheet for Bill Cycle by using reports like Usage, Non-usage, Revenue and Subscriber., Working on Systems like BIMS (Billing Information Management System & SQL (Structured Query language).

• Power BI Data Analyst Certified (PL300)
• Azure fundamentals Certified (AZ900)
• Azure Data fundamentals Certified (DP900)
• ITIL V3 certified
• Prince2 Foundation Certified
• Pat on Back 2024
• Pat on Back 2022
• ACER 2021
• Pat on Back 2020
• GAia Ninja 2019
• Bravo 2018
• Got multiple Client appreciations for dedication, hard work and success in completing critical work on time throughout my tenure.