Summary
Overview
Work History
Education
Skills
Volunteer Experience
Hobbies and Interests
Languages
Certification
Timeline
Generic

Srinath Ananthula

Montreal,Canada

Summary

Experienced Data Specialist and Business Intelligence professional with a diverse skill set across multiple industries. Started my journey at FEG Company, spending 1 year and 8 months specializing in data pipelines, reporting, and analytics. Pursued a 9-month internship as a BI Analyst at McGill University, to design interactive dashboards and reporting solutions using Power BI and Tableau. Transitioned to a full-time role as a BI Developer at the university, excelling for 8 months by modernizing data infrastructure and implementing scalable cloud-based data pipelines. Demonstrated prowess as a Data Pipeline Architect at EVLO Energy Storage, seamlessly integrating data and optimizing costs through strategic resource management. Introduced dynamic Power BI visualizations for insightful reporting and championed Azure Synapse by launching workspaces to enhance data filtering and reporting. Consistently delivered comprehensive KPI reports and created custom solutions for real-time monitoring and backfill processes. Proactive problem-solver dedicated to leveraging the latest data and BI technologies to drive impactful insights and business value.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Specalist

EvLo Energy Storage Inc
04.2023 - Current

• Built robust Azure Data Factory pipelines, seamlessly integrating data from InfluxDB to Azure Data Lake.
• Optimized resource usage and cut costs through strategic management and cleanup.
• Introduced dynamic visualizations for battery KPIs, leveraging DAX for insightful reporting.
• Launched Synapse workspaces to streamline client data filtering and daily refreshed views, connected to Power BI.
• Automated alarm data extraction from InfluxDB using custom scripts and Python automation.
• Developed Dagster pipelines for complex KPI calculations and data backfilling, integrating with Azure CosmosDB.
• Created Azure Functions for real-time data monitoring and backfill processes.
• Deployed InfluxDB clones on Docker to expedite data backfilling.
• Leveraged Terraform for scalable Azure instance creation.
• Conducted in-depth analysis and forecasting to ensure optimal battery performance.
• Established guidelines for efficient data extraction and usage.
• Implemented TimescaleDB on the cloud for enhanced data management.
• Delivered comprehensive KPI reports, keeping clients informed with incremental and monthly updates.
• Defined essential networking protocols for seamless Azure operations.

BI Developer

McGill University
09.2022 - 04.2023
  • Participated in design, development, implementation and delivery of optimized BI and Data warehouse solutions using Microsoft Azure, SQL Server, and Oracle Databases
  • Interacting with Business users to assess requests, set priorities and meeting expectations
  • Maintenance of existing BI applications in collaboration with the DBA, Architects and Analysts
  • Building the prototype for the upcoming projects by using Azure Data factory, Azure DevOps, BIML Flex, Visual Studio
  • Collaborated with cross-functional teams to identify business requirements and translate them into technical specifications.
  • Developed strategic reports for executive decision-making using advanced data visualization techniques.
  • Prepared targeted documentation, specifications, and resources to analyze business data.

BI Analyst - Internship

McGill University
01.2022 - 09.2022
  • Developing innovations & insight across the business, analyzing the business model, and looking at the development tasks
  • Developed testing scripts scenarios in SQL Server management studio, Toad to ensure programming / configuration has been done in accordance with functional specifications and business requirements
  • Responsible to document Bl needs in Confluence and evaluate project opportunities, liaise between the end users, the business SMEs, and the BI project team
  • Responsible for gathering Bl-related business requirements, develop and plan, including functional, nonfunctional, dashboards/reports, operational, service level and performance requirements from business stakeholders via various mediums such as user workshops, product / prototype demos, interviews, surveys, and others

Data Engineer

Ideaspark Solutions
05.2019 - 11.2020
  • Company Overview: Data Engineer
  • Migrated packages from SSIS to Azure Data Factory
  • Developed Integration approaches using Azure Data Factory for business reports
  • Automated Full/Incremental Daily Loads using Azure Data Factory, followed by alerts and client communications using SendGrid and various manual tasks
  • Implemented Azure Logic Apps for various business requirements
  • Developed SQL scripts with HTML & CSS for various client daily delivery reports, reconciliation mails using Azure Web activities and Web hooks
  • Implemented Python scripts for fetching data from different API's
  • Developed Error Handling and implemented logs using azure activities
  • Monitored production pipelines on Azure Data Factory and initiated corrective actions based on performance and automations
  • Load incremental data into big query stage, and load data from stage to target database
  • Schedule hourly load jobs in UNIX and implemented logging
  • Data Engineer
  • Core Competencies: Data Warehousing & Development, Cloud Integration & Automation, Stakeholder Management, Troubleshooting & Management, Subject Expertise & Performance Optimization, Load Monitoring, Scheduling ETL Jobs, Error Handling

Education

Master of Engineering - COOP - Electrical and Computer Engineering

Concordia University
Montreal, QC
08.2022

Bachelor of Technology - Electronics and Communication Engineering

GITAM University
04.2019

Skills

  • Data Migration, Process Enhancement, Process Automation, Troubleshooting, Data Integration, Agile Methodology, ETL , Stakeholder Management, Troubleshooting & Management, Subject Expertise & Performance Optimization
  • Data Warehousing & Development, Cloud Integration & Automation, Cloud Management
  • Microsoft Azure - Data Factory, ADLS, Storage explorer, Databricks, Synapse Analytics, Azure functions, VNET's, VM's, Logic Apps, DevOps,
  • Power BI
  • Confluence, JIRA, SSMS, SSIS, WINSCP, Putty, DBeaver, pgAdmin, VSCode,
  • MY SQL, Python, Influx, PostgreSQL, HTML, CSS
  • Google Big Query
  • Snowflake

Volunteer Experience

  • Student Volunteer, National Service Scheme, 09/18, 09/18, Conducted various social events in a government school for 5 days at Bheemili in Visakhapatnam.
  • Organizer, IEEE Student Chapter, 09/18, 09/18, Organized workshop on Android App Development which was conducted by IIT Delhi.

Hobbies and Interests

Watching Football and Cricket, Playing Badminton, Travelling, Organizing Social Events.

Languages

English
Full Professional
French
Limited Working
Telugu
Native or Bilingual
Hindi
Limited Working

Certification

• Azure Data Engineer Associate DP-203

• Azure Fundamentals– Cloud Computing

• Python for Beginners - University of Michigan.



Timeline

Data Specalist

EvLo Energy Storage Inc
04.2023 - Current

BI Developer

McGill University
09.2022 - 04.2023

BI Analyst - Internship

McGill University
01.2022 - 09.2022

Data Engineer

Ideaspark Solutions
05.2019 - 11.2020

Bachelor of Technology - Electronics and Communication Engineering

GITAM University

Master of Engineering - COOP - Electrical and Computer Engineering

Concordia University
Srinath Ananthula