Charul Gupta Email & Phone Number

India

• Developed end-to-end ETL pipelines using various azure components like Azure Data Factory, Azure Data bricks, Data Lake, ingesting data from diverse sources, and transforming it into a centralized data warehouse.• Developed ETL processes using PySpark and SQL to process and transform terabytes of data, enhancing data accessibility and cost efficiency.• Managed Azure Data Lake Storage for efficient storage and retrieval of structured and unstructured data for analytics and reporting.• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse.

Architected the design and deployment of highly efficient and scalable data pipelines leveraging the Azure cloud platform, including HDInsight, Data Lake, Data bricks, Blob Storage, Data Factory, Synapse, SQL, SQL DB, DWH, and Data Storage Explorer.

Munich, De

• Conducted data extraction, transformation, and loading (ETL) processes using SQL, ensuring data accuracy and consistency. • Experienced in BI Development and Deployment using SSIS packages• Functioned as Onsite Project Lead, liaison between the client and offshore team.• Coordinated with the development and testing team and other stakeholders of the project to meet desired business objectives. • Prepared and reviewed the RFP (Request for Proposal) for new client change requests.• Prepared use cases, analysis document which reviewed with client. • Designed dash boards for actionable, non-actionable complaints from Multidimensional database. • Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison. • Migration of objects from On Prem to Azure Cloud services( ADF, Data Lake, Azure Synapse, PowerBI). • Designed and implemented ETL processes to load data into fact and dimension tables through bronze, silver, and gold layers. • Generate daily, weekly, and monthly reports on top of stored data in Power BI.

Munich, De

• Collaborated with business units to define project requirements, data sources, and deliverables.• Generated and distributed weekly, monthly, and quarterly reports to track KPIs and provide insights for decision-makers.• Assisted in the development of data dashboards using Tableau and Power BI to visualize data and track key metrics.• Utilized DAX formulas to create calculated columns and measures that performed advanced calculations and data analysis within Tableau and Power BI.• Participated in data migration projects, ensuring data accuracy and completeness during the transition.• Assisted in creating data-driven strategies for marketing and product development.• Conducted statistical analyses, including hypothesis testing and regression modeling, to provide actionable insights for the marketing and sales teams.• Conducted market research and competitive analysis to support strategic planning.• Assisted in the creation of data visualization dashboards to monitor marketing campaign performance using Tableau and Power Bi.

Munich, De

• Your Power BI reports and dashboards could have focused on CPG-specific metrics, like sales performance by product category or region.• Design solution for various system components using Microsoft Azure services, ensuring scalability and efficiency. • Implemented pipelines with scheduled triggers to automate data extraction and storage using U-SQL code in Azure Data Lake Analytics and Blobs.Provide Sprint Demo to client and stake holders to highlight project progress. • Actively participated in Agile ceremonies including Sprint planning meetings, Daily Scrums, Sprint review meetings, and Sprint retrospective meetings. • Create Web API methods for adapters to pull data from systems. • Leveraged Logic Apps, Azure Data Factory and On-Prem SQL Server for scheduled data pumping using SQL Server Job agent• 3 Layer architecture in Azure Synapse Analytics to create modern data warehousing.• Working with IS (Information Systems) in the CPG domain involves managing data related to products, inventory, sales, and supply chain.• As part of this role, you likely dealt with data specific to CPG, such as product SKUs, pricing, promotions, and distribution channels.• Retailers in the CPG benefit from data-driven insights. The solutions may have addressed inventory turnover, shelf space allocation, and pricing strategies.• Understanding consumer behavior is crucial. Your BI solutions might have explored customer segmentation, loyalty programs, and purchasing patterns.

London, England, Gb

Developer and Admin of SharePoint.

Worked as Software Trainee.

Master Of Computer Applications - Mca, Computer Science

Mca, Computer Science

Education record