Anubhuti Singh
Toronto,Canada
Summary
Experienced data engineer with a proven track record in designing and implementing data-driven solutions and analytics frameworks. Demonstrated proficiency in constructing and overseeing data lakes on Microsoft Azure, utilizing Azure Data Factory, Azure Synapse, and Databricks. Highly skilled in advanced SQL and Power BI, enabling the generation of actionable insights and enhancing business intelligence. Proficient in data modeling, ETL processes, and creating scalable big data platforms to optimize data management and analytics capabilities.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Procurement Systems and Data Analyst
Salvation Army Territorial Headquarters
04.2020 - 07.2024
- Directed the migration of ETL processes to Azure cloud infrastructure, significantly enhancing the performance and accessibility of data lakes.
- Engineered and managed data pipelines using Azure Data Factory, seamlessly integrating structured and unstructured datasets to support robust reporting and analytics.
- Designed and implemented automated Power BI dashboards, creating interactive visualizations that empowered stakeholders to make informed, data-driven decisions.
- Leveraged advanced SQL to construct complex queries and stored procedures for data extraction, ensuring high-quality data analysis and reporting.
- Conducted comprehensive data modeling to establish cohesive data structures, improving the accuracy and reliability of reporting solutions.
- Automated data processing tasks through Python scripting, minimizing manual intervention and enhancing operational efficiency.
- Collaborated with the testing team to optimize database development, define project scopes, and resolve data-related challenges.
- Successfully migrated legacy systems to Azure, achieving a 20% reduction in processing time.
- Developed advanced Power BI reports that improved visibility into key metrics, resulting in a 30% decrease in manual reporting efforts.
- Enhanced operational efficiency through advanced data modeling and the application of analytics principles.
- Thrived in fast-paced environments, demonstrating self-motivation and a strong sense of accountability.
- Excelled in independent and collaborative team settings, providing support and guidance as needed.
- Demonstrated a proven ability to learn quickly and adapt to new situations.
- Exhibited excellent verbal and written communication skills.
Project Analyst
Rannlab Technologies
06.2016 - 06.2017
- Facilitated requirements gathering sessions, developing effective data strategies to enhance accuracy and reliability.
- Engineered intricate SQL queries and managed OLAP protocols to optimize ETL processes and data analysis.
- Developed monthly dashboards in Power BI and Excel, delivering actionable insights into company performance.
- Administered source control using Git and GitHub, ensuring code quality and consistency throughout all development stages.
- Increased sales consultant productivity by 26% through actionable insights generated from sales dashboards.
- Minimized project delays by streamlining internal processes and enhancing client communications.
- Continuously expanded personal knowledge base through participation in industry conferences, workshops, and training courses.
- Created in-depth reports regarding important project data that was distributed to clients every week.
- Cultivated a positive working environment for team members, resolving conflicts promptly, and promoting collaboration at all levels.
- Determined root causes of problems and issues to implement courses of action required to implement solutions.
Education
Master of Business Analytics -
La Trobe University
Melbourne, Australia01.2019
MTech in Computer Science & Engineering -
Jaypee Institute of Information Technology
Noida, India01.2016
BTech in Computer Science & Engineering -
Sharda University
Noida, India01.2014
Skills
- Cloud Platform: Microsoft Azure, Azure Data Factory (ADF), Azure Synapse, Azure SQL Database, Azure Blob Storage, Azure Logic Apps, Databricks
- Data Engineering & ETL: Building data lakes, data warehousing, data integration, and automation of ETL processes
- Source and Version Control: Git, GitHub
- Databases: Azure SQL DB, Oracle, MySQL Server
- Reporting Tools: Power BI, DAX queries, Tableau, Advanced Microsoft Excel (Macros/ VBA)
- Languages: Python, Machine Learning, SQL, Pandas, NLP
- Software development life cycle (SDLC): Agile/Scrum Methodology, Waterfall, JIRA, Azure confluence
- Applications/Software: SQL Server Management Studio, Coupa, Technology One, ServiceNow, Freshdesk, R Studio, Anaconda, Jupyter, PyCharm
- Other Tools: Microsoft PowerApps, Microsoft Visio, SpiraTest, Excel Functions
Certification
- The Salvation Army — Awarded for the Finance Recognition Program (Nov 2021) for demonstrating values of Integrity & Collaboration.
- Azure Fundamentals (AZ900)
- Coupa Product Certified — Expenses Certification
- Research paper: "Cosine Similarity with Centroid Implications for Text Clustering of Document Files" published in the Indian Journal of Science and Technology.
Timeline
Procurement Systems and Data Analyst
Salvation Army Territorial Headquarters
04.2020 - 07.2024
Project Analyst
Rannlab Technologies
06.2016 - 06.2017
Master of Business Analytics -
La Trobe University
MTech in Computer Science & Engineering -
Jaypee Institute of Information Technology
BTech in Computer Science & Engineering -
Sharda University
- The Salvation Army — Awarded for the Finance Recognition Program (Nov 2021) for demonstrating values of Integrity & Collaboration.
- Azure Fundamentals (AZ900)
- Coupa Product Certified — Expenses Certification
- Research paper: "Cosine Similarity with Centroid Implications for Text Clustering of Document Files" published in the Indian Journal of Science and Technology.
Similar Profiles
Melissa MollMelissa Moll
Administrative Assistant; at The Salvation Army, Territorial HeadquartersAdministrative Assistant; at The Salvation Army, Territorial Headquarters
KAREN M. HANTONKAREN M. HANTON
Emergency Disaster Services Manager at The Salvation ArmyEmergency Disaster Services Manager at The Salvation Army
Christina EriksonChristina Erikson
Philanthropy Administrator and Prospect Research at The Salvation Army Central Territory HeadquartersPhilanthropy Administrator and Prospect Research at The Salvation Army Central Territory Headquarters