Ramesh Salagala
Data Analyst
Hire this person
Send a job offer directly to this candidate
About
Results-driven and technically skilled as Data analyst with 4.6 years of hands-on IT experience, specializing in cloud data engineering and analytics. Adept at designing and implementing scalable ETL pipelines using Azure Data Factory, Azure SQL Database, and Azure Data Lake technologies to support business intelligence and data modernization initiatives. Proven experience migrating on-premises SQL databases to Azure cloud platforms including Data Lake Analytics, Azure SQL DB, and Data Warehouse.
Designed and developed complex ETL workflows in Azure Data Factory to ingest and transform data from external sources like AWS S3. Strong command over SQL, with expertise in performance optimization, query analysis, and business-driven data insights.
Skilled in Tableau BI: building interactive dashboards and visual stories based on business stakeholder requirements.
Power BI Expertise: Capable of designing interactive Power BI dashboards tailored for client views, empowering stakeholders to take informed, action-oriented decisions. Proficient with version control and workflow management using GitHub Desktop, GitHub Server, and Jira. Experienced in Agile and Waterfall SDLC models with cross-functional collaboration to meet sprint goals and client deadlines.
Hands-on with environments across DEV, UAT, FT, and PROD, including deployment verification and migration of assets. Exceptional communicator and a proactive team player with an ability to simplify complex data challenges and deliver tailored solutions.
Experience
Application Developer - Accenture Solutions Private Limited
(2024-11)
UK Health manages data for health-authorized organizations, product licensing, and regulatory operations. The project focuses on migrating data from SQL Server databases to centralized target systems to support comprehensive data visualization and reporting. The initiative plays a key role in transforming how regulated health data is managed and presented to stakeholders.
- Developed Azure Data Factory (ADF) pipelines to load data from SQL Server to Dataverse, utilizing activities such as Copy Data, If Condition, Script, Lookup, and Stored Procedures
- Migrated data across SQL Server schemas using Stored Procedures, Views, and User-Defined Functions
- Ensured high data quality by executing data validation, cleansing, and transformation in both SQL Server and Azure Data Factory
- Designed Power BI dashboards for reconciliation and client-facing visualizations, enabling actionable business insights
- Built interactive dashboards and reports in Power BI with drill-through and dynamic filtering
- Connected Power BI to multiple data sources including SQL Server, Excel, and Azure services
- Designed data models with relationships across multiple tables to support business reporting
- Set up scheduled refreshes to ensure dashboards remained up to date
- Automated dataset refreshes using Power BI Service and Azure Data Factory triggers
- Improved report performance by using measures instead of calculated columns
- Performed ADF deployments at the conclusion of each sprint to maintain timely delivery
- Hands-on experience with Azure Data Studio, particularly for code check-in and deployment management
- Built pipelines to manage full load, incremental load, and delta load operations tailored to the project's data model
- Applied comprehensive SQL expertise, including usage of INSERT, UPDATE, DELETE, TRUNCATE, and DROP statements
- Actively participated in defect resolution across SIT (System Integration Testing) and UAT (User Acceptance Testing) environments
Application Developer - Synechron Technologies Pvt Limited
(2021-10 - 2024-11)
The Finance on The Cloud (FOTC) program is a multi-year data and reporting transformation initiative. By leveraging cloud technology as a key enabler, the program aims to reshape HSBC's Global Finance operating model through cloud-based migration of finance architecture, facilitating core financial processes and key data flows.
- Hands-on experience in migrating ETL's to Google Cloud Platform (GCP) using cloud native tools such as Big Query, Cloud Storage, IAM, and VM's
- Creation of tableau navigator pages for visualization to stakeholders and end users
- Code deployment which data is stored in GitHub to cloud storage by using Jenkins pipeline
- Dim queues preparation for batch run to data validation
- Development of various reports and dashboards using Tableau
- Active involvement in code review processes
- Creation of Big Query authorized views and tooling views to implement row- level security for other teams
- Creation of schema's using Big Query tables. Played a key role in training team members on GCP
- Proficient in version control using Git and ticket tracking through Jira
- Created Tableau Navigator Pages for stakeholder and end-user data visualizations
- Designed and developed interactive reports and dashboards using Tableau
- Actively participated in code review processes to ensure best practices and coding standards
Education
B.E - SITAM COLLEGE (2016)
Intermediate - Narayana Junior College (2011)
SSC - Deepthi High school (2009)