Data Engineer Analyst
Vezeeta
Total years of experience :6 years, 2 Months
• Developed prediction models using Machine Learning and custom mathematical algorithms to evaluate demand for doctors leading to actionable insights for cost optimization and enhanced patient experience
• Implemented layout and architecture of data mart for Business Intelligence (BI) process delivering custom and clean data across departments
• Designed and developed over 40 Extract, Transform, Load (ETLs) involving both internal and external data sources
• Designing Job Failure mechanism for ETL failures making system more efficient and saving around 7-10 hours per week for the whole team.
• Identified a multitude of databases compatible with OLTP architecture and transformed them to maintain their record in our data warehouse
• Designed and Developed Data Warehouse using ETL's and Schedulers with CI/CD and data quality tests in order to provide data to various stakeholders.
• Leading Business Intelligence team for architecting and managing Data Pipelines and Executive Dashboards to track activities in one place while automating tasks, optimizing existing scripts and ETLs to reduce workload
• Developed a Live COVID Dashboard using web scraping and various APIs to generate more leads resulting in the improvement of marketing efforts
• Responsible for the management and development of executive dashboards which form around 40% of total dashboards on platform.
• Speeding up the dashboard performance by upto 30% by using the Tableau Rest API's.
Data Analysis & Machine Learning
• Deployed efficient Machine Learning models to predict sales and working hours ensuring optimized workforce management
• Developed a real-time dashboard through the integration of numerous technologies including Google Sheets and Google Data Studio linked to Python using the Google API
• Implemented Data Management system compliant with the nature of the business to reduce data inconsistencies by up to 40%
Automation
• Automated data generated by scheduling software into Timesheet Reports using Python which reduced the workload of the employees by up to 60%
• Wrote software patches to automate leads acceptation by around 300% and designed an Intelligent Program to identify and auto-correct the typing errors in data entry
Credit System and Auditing Assurance
• Analyzed issues and weaknesses in the credit system and developed a solution to assess credits improving the recovery process by around 20%
• Developed a Fraud Detection system tailored to each department alleviating fraud rate from around 10% to almost 5% of the total revenue
▪ Analyzed software requirements to meet potential customer needs.
▪ Formulation and Evaluation of project summaries which include goals, timelines, milestones, budgetary targets.
Employed the use of Python Data Analysis suite especially Pandas for cleaning and manipulating data into a specific format and utilized packages such as Matplotlib and Seaborn for providing valuable visual insights and data analysis reports.
▪ Took part in software and architectural development activities
▪ Developed, implemented and maintained application software
▪ Conducted software analysis, programming, testing and debugging
▪ Developed application code for java programs
Administered the upgradation of the Open Source Lab (LAB001) at Department of CSE, North Campus, University of Kashmir.