SDM | Senior Technical Consultant| Nov 2023 – Present
Technologies: Power BI, Python, SQL, Azure Data Factory
Roles & Responsibilities:
- Utilized Azure Data Factory to design and implement data transformation pipelines, ensuring efficient and accurate data preparation for reporting and analytics.
- Conducted comprehensive data analysis using SQL, and Python, identifying trends and insights that drove business decisions.
- Developed and maintained interactive dashboards in Power BI, improving data accessibility for key stakeholders.
- Developed and applied RLS in Power BI to ensure data security and compliance with organizational policies.
- Collaborated with marketing and product teams to define and track KPIs, providing actionable insights through detailed reports.
Customer Engagement | Senior Technical Consultant| Oct 2021 – Oct 2023
Technologies: Power BI, Azure SQL, Power Apps, Power Automate
Roles & Responsibilities:
- Managing and guiding highly efficient team in solution design anddevelopment.
- Direct interaction with clients to understand business requirements and convert them to actionable insights.
- Converted more than 40 Traditional manual excel reporting into an intuitive & interactive automatic reports using Power BI and scheduled data refresh for the reports.
- Created Power Apps application and Automated data collection using Power Automate, processing work flows, reducing manual data entry time by 30%.
Customer Engagement | Technical Consultant |Jan 2020 – Dec 2021
Technologies: SQL Server, API Integration, Power BI, Machine Learning , Python
Roles & Responsibilities:
- Work with Business users to gather, define business requirements and analyze the possible technical solutions.
- Individually handling main project and doing development on Power BI and ETL (SQL Stored procedures).
- Load data from Appian cloud database to SQL server, Web API and Python language.
- Built Reports in Power BI desktop and Utilized statistical techniques and predictive modeling to forecast sales and optimize inventory levels.
ADR | Associate Technical Consultant | May 2019 – Oct 2019
Technologies: Azure Synapse, API Integration, Power BI
Roles & Responsibilities:
- Develop and maintain data pipelines in cloud to ingest different formats of data from Appian cloudDB.
- Replicate the data into Azure Data Lake using Server less SQL pool for processing data.
- Built incremental model to reduce the load on the source system.
- Created detailed reports and visualizations using Power BI, facilitating data-driven decision-making. Responsible for agile methodologies and project documentary.