Anil Dhage¶
Montreal, QC J4Z 1G7 • +1 514 235 8388 • i.am.dhage@gmail.com • LinkedIn
Summary¶
Developer, Data & Business Analytics enthusiast with 8+ years of experience in developing solutions for clients and applications. Expertise in data transformations, automating data operations, working with big data to perform ETL & ELT operations, and creating and maintaining data pipelines end-to-end on-premise and cloud.
Work History¶
Data Developer¶
Soho Square Solutions, Montreal, Quebec
Client: Societe Generale
June 2025 – Present
- Built data pipelines to deliver data seamlessly from on-premise data sources to Azure SQL and Azure Data Lake.
- Orchestrated and implemented SQL migrations from on-premise SQL Server to Azure SQL.
- Automated data transformations in Python to reduce manual interventions during data ingestion into the data warehouse.
- Developed data solutions using GitHub Copilot for rapid development with automatic documentation.
- Maintained code in GitHub repositories with complete CI/CD implementation.
- Built data transformations in Python to clean unstructured sources like .csv, .txt, and .psv files before ingestion into the data warehouse.
Business Data Analyst¶
Soho Square Solutions, Toronto, Ontario
Client: Societe Generale
April 2023 – June 2025
- Developed and deployed data projects to production systems on-cloud and on-premise.
- Built data pipelines in ETL tools to generate daily, quarterly, monthly, and ad-hoc reports and datasets for regulatory reporting.
- Wrote, planned, and defined SQL queries to retrieve and generate records, and performed DDL and DML operations on production systems.
- Automated solutions in Python to improve OLAP database performance and optimize data archival and backup strategies.
- Created custom FastAPI applications for internal teams to automate change and release activities.
- Participated in the complete software development lifecycle, including testing in dev, UAT, and production deployment.
- Handled production issues swiftly with production support teams.
- Scheduled and maintained accurate Autosys jobs to ensure data sources and transformations were completed without issues.
Data Specialist¶
Cognizant Technologies Ltd, Hyderabad, Telangana
Client: Google India
March 2020 – December 2022
- Transformed and analyzed relational data to develop and report data solutions using on-premise MS SQL.
- Automated data visualizations to present insights and tell compelling stories using Power BI.
- Developed SQL queries to extract data from various sources and presented it in an easily understandable format based on business requirements.
Junior Business Analyst¶
Leopard Systems, Melbourne, Victoria
February 2019 – March 2020
- Conducted requirements gathering sessions and meetings with product owners and stakeholders.
- Assisted product owners in creating project reports, user stories, and use cases for requirements analysis.
- Collaborated with programmers, engineers, and management to identify process improvement opportunities and propose system modifications.
Analyst¶
GlobalLogic Technologies Limited, Hyderabad, Telangana, India
Client: Google Maps India
December 2012 – August 2016
- Analyzed data sets, created and modified data using Excel formulas, and performed statistical operations to generate insights.
- Worked with developers and product owners to create clean data for client applications to improve user experience.
Skills & Knowledge Stack¶
- Operating Systems: Linux, Windows, Ubuntu, CentOS, Mac, and Cloud Instances.
- Languages: Python, SQL, Bash, Shell Scripting, Git, and Java Basics.
- Docs & Office Tools: Microsoft Office 360 Suite, Excel, PowerPoint, Google Docs, GitHub.
- BI Tools: Power BI, Power Query, Tableau, AWS QuickSight.
- Automation Tools: Autosys, Airflow.
- Data Analysis: Pandas, PySpark, DataFrames, Matplotlib.
- Machine Learning: Supervised and Unsupervised Learning, Data Modeling, Machine Learning Projects.
- Big Data Tools: AWS, Azure Databricks, Data Factory, Synapse, Google Cloud.
- Data Stores: NoSQL, MySQL, SQL Server, PostgreSQL, Snowflake.
- Web Frameworks: Flask, Django, FastAPI.
Education¶
Masters of Information Technology¶
Charles Sturt University, Melbourne, Victoria, Australia
Study Period: August 2016 – December 2018
- Specialized in Databases & Data Management.
Bachelors of Commerce¶
Railway Degree College, Hyderabad, Telangana, India
Study Period: May 2009 – April 2012
Certifications and Trainings¶
- DP-900 Certified Microsoft Azure Data Fundamentals
- Python Developer Bootcamp
- SQL Developer Bootcamp
- Pandas Developer for Data Analysis
- Business Analysis Fundamentals
Current Projects¶
- Migrating On-Premise Database to Azure Database.
- Migrating from Autosys to Airflow for scheduling ETL jobs.
- Building ELT and ETL pipelines and projects.