Ramesh Salagala
RAMABHADRAPURAM,Andhra Pradesh
Summary
- I pursue a competitive environment that improvises My responsibilities and goals, helpful to learn and to deliver solutions to problems
- Dedicated and proficient Azure Data factory developer with overall 3 years of IT experience.
- Demonstrates a comprehensive grasp of Azure Data Services, Azure SQL Database, Azure Data Factory.
- Experience in Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, and Azure SQL Data warehouse and controlling and granting database access and migrating on-premises databases to Azure Data Lake store using Azure Data Factory.
- Designed and Developed ETL Processes in Azure data factory to migrate data from external sources like S3.
- Collaborative team player, adept at coordinating with team members to meet project deadlines and proficient updating Jira tickets to ensure project tracking and management.
- Versatile in the software development life cycle (SDLC), employing both waterfall and agile (Scrum) methodologies to drive project success.
- Writing SQL queries to retrieve, update, insert, and delete data from databases, ensuring accuracy, efficiency, and adherence to business logic.
- Analyzing and optimizing SQL queries for performance by using techniques such as indexing, query tuning, and query plan analysis.
- Analyzing data to derive insights, trends, and patterns using SQL queries, and generating reports or visualizations to present findings to stakeholders.
- Excellent knowledge of Oracle 11g/12c environment.
- Create the objects like tables, synonyms, sequences and views.
- Create Tables, Views, Constraints, Index.
- Excellent knowledge on Git hub desktop and Git hub server and workflow management.
- Cloud and Collaboration Tools: Experience with Google Cloud Platform, including Google Cloud Big Query. Proficient in collaboration tools such as Jira, Confluence, GitHub, Tableau desktop.
- Business Stakeholder Collaboration: Proven experience in engaging with business stakeholders to elicit and comprehend business specifications, effectively translating them into compelling data visualizations for informed decision-making.
- Design and Deployment: Demonstrates end- to- end experience in the design and deployment of data visualizations using Tableau, showcasing a comprehensive understanding of creating various Views and Stories.
- Data Analysis and Validation: Proficient in performing Data Analysis and Validation using SQL queries and MS Excel, ensuring data accuracy and reliability.
- Cloud and Collaboration Tools: Experience with Google Cloud Platform, including Google Cloud Big Query. Proficient in collaboration tools such as Jira, Confluence, GitHub
- SQL Expertise: Skilled in writing SQL queries and creating views in databases, employing clauses such as Select, From, Where, Group by, Having, Over(), and Partition().
- Deployment and Migration Experience: Extensive experience in deployment verification across different environments, including DEV, UAT, FT, PROD. Proficient in migrating workbooks, replacing data sources, and transferring from one server to another.
- Workflow Management: Demonstrates expertise in workflow creation, ensuring efficient processes and project management.
Overview
3
3
years of professional experience
Work History
Application Developer Engineer
Synechron Technologies Pvt Limited
10.2021 - Current
- Company Overview: The Finance on The Cloud (FOTC) program is a multi-year data and reporting transformation initiative
- Leveraging cloud technology as a key enabler, it aims to reshape the Global Finance operating model by migrating the Finance architecture to the cloud, facilitating core finance processes and key data flows
- Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse
- Ingesting data from different sources like Oracle BICC, Amazon S3 to lakegen2
- Ensured data quality and integrity by performing data validation, cleansing, and transformation operations using Azure Data Factory
- Worked with various Azure services including Azure Data Lake Analytics, Azure Data Lake Storage, Azure SQL databases, and Azure SQL Data Warehouse for analytics solutions
- Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory
- Used Azure Data Factory to perform Incremental Loads from Azure SQL DB to Azure Synapse
- Built & deployed complex distributed systems, handled large amounts of data, created data pipelines & conducted analytics
- Skilled in version control tools like GIT and ticket tracking platforms like JIRA
- Creation of tableau navigator pages for visualization to stakeholders and end users
- Development of various reports and dashboards using Tableau
- Active involvement in code review processes
- The Finance on The Cloud (FOTC) program is a multi-year data and reporting transformation initiative
- Leveraging cloud technology as a key enabler, it aims to reshape the Global Finance operating model by migrating the Finance architecture to the cloud, facilitating core finance processes and key data flows
Education
B.E -
SATYA INSTITUTE OF TECHNOLOGY & MANAGEMENT
Vizianagaram01.2016
Intermediate -
Narayana Junior College
Vishakapatnam01.2011
SSC -
Deepthi High School
Vizianagaram01.2009
Skills
- Azure data factory, SQL server, Oracle 11g,Oracle 12c,
- Azure SQL Database, SQL Developer, Tableau Desktop, Tableau Server Tool
- GCP big query, Jenkins, GitHub, Jira ,Visual Studio ,
- Windows , MS Excel
- Agile/Scrum
Languages
English
Telugu
Personal Information
Date of Birth: 03/18/94
Disclaimer
I hereby declare that all the information furnished above is true to the best of my knowledge.
Socialactivities
One of the member of Helping Hands.
Timeline
Application Developer Engineer
Synechron Technologies Pvt Limited
10.2021 - Current
B.E -
SATYA INSTITUTE OF TECHNOLOGY & MANAGEMENT
Intermediate -
Narayana Junior College
SSC -
Deepthi High School
Similar Profiles
Yogesh DholeYogesh Dhole
Sr. Manager Technology at Synechron Technologies Pvt. Ltd.Sr. Manager Technology at Synechron Technologies Pvt. Ltd.
Mehul TalathiMehul Talathi
Lead Business Analyst at Synechron Technologies Pvt LtdLead Business Analyst at Synechron Technologies Pvt Ltd
Vishal PatilVishal Patil
Senior Principal at Synechron Technologies Pvt. Ltd.Senior Principal at Synechron Technologies Pvt. Ltd.