Experience

NCPL Inc

• Canada
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Engineer

  • Jun 2021 - Present

  ● Created pipelines in ADF using linked services to extract, transform and load data from data sources like Azure SQL, Blob storage ● Extracted transform and Load data from source systems to Azure data storage services using Azure Data Factory ● Performed Data Ingestion to one or more Azure services – Azure Data Lake and processed the data in Azure Data bricks● Increased response rate by 10% and reduced 5% operational expense by leveraging experimental analytics● Accurately maintained, transferred, and processed home data in different databases by developing VBA and SQL scripts ● Wrote python codes to set up the new dataset for client onboarding ● Created a report for home data analysis from experimental design to dashboard● Performed migration of data from SQL server to Azure cloud using Azure database Migration Service(AMS)● Automated new product data acquisition, pricing, and classification process using Python● Developed client retention and potential measures improving the ability to maintain peak performance and improved underperformance reports● Automated the manual data reconciliation process between the different sources, increasing the data accuracy and efficiency by 90%● Developed visualization and dashboard leveraging SQL and Tableau to provide home insights into analytics ● Skilled in identifying problems through data, defining ambiguous and complex problems, and solving problems● Created processes and methods to monitor and analyze inventory data to minimize the errors in data, supply chain, and prod line to increase the efficiency of data ● Developed numerous categorical sales analyses along with visualizations for Customer data analytics showing insights to better focus on and improve future revenues (SQL, Python, PowerBI)● Extracted, combined, and conditioned various data formats from multiple sources



Mithra Technologies

• Staffing and Recruiting
• 1 - 100 Employee

• Data Analyst

  • May 2019 - Nov 2019

  ● Debugged and implemented new features in Python plugins using PyCharm and Git ● Presented data to draw business insights for managerial action and strategy ● Used statistical techniques for hypothesis testing to validate data and interpretations ● Processed Data and proposed solutions to improve system efficiencies and reduce total expenses ● Designed predictive statistical models for recommendation and optimization analysis ● Managed the design of reports and the planning of business metrics ● Conducted new performance reports and delegated tasks to team members ● Analyzed the dataset by data cleaning, data indexing, and ER diagrams ● Created a report for home data analysis from experimental design to dashboard● Performed ad-hoc reporting and automated report generation to reduce generation time by 20% using reusable code in MS-SQL packages● Interpreted data, analyzed results, and provided ongoing reports● Created daily, weekly, and monthly reconciliation reports accurately with adherence to stakeholder deadlines