Ritu Singh
Delhi
Summary
Versatile Data Engineer with 6+ Years of experience in Data Engineering & Leadership, adept at navigating diverse roles from Support , Developer, Data Analyst to Data Engineer. Demonstrated expertise in mentorship, seamlessly transitioning across domains . Encouraging manager and analytical problem-solver with talents of team building, customer relations, and independent decision making. Dedicated to streamlining operations,enchansing employee engagement and promoting organisational efficiency.
Overview
7
7
years of professional experience
1
1
Certification
Work History
System Analyst
Hexaware Technologies
Noida
03.2024 - Current
- Investigation and resolution of failed / slow ADF and synapse pipelines
- Perform maintenance tasks such as Data backup performance monitoring to ensure the stability and reliability and delivery of reports
- Used Amazon S3 to store and manage data, keeping gold layer data in Amazon RedShift, Analyzed and understanding of Data modelling and normalization techniques
- Worked on AWS pipeline for orchestrating data workflows for processing and movement of data
- Providing training to clients resources when required
- Automated daily backups of critical data using AWS S3, reducing the risk of data loss in case of system failures.
- Developed custom ETL processes for efficient data ingestion and transformation.
Consultant
Celebal Technologies
Jaipur
04.2021 - 03.2024
- Analyzed data warehousing framework proposals, advising clients on feasibility, scale and other metrics
- Worked on ETL( Extract Transform Load) and ELT(Extract Load Transform) tasks, maintaining data integrity and verifying pipeline stability through Azure Data Factory
- Migrated on premise SQL server/Dynamic 365 to Azure synapse, built ADF pipelines for all types of load
- Worked with Azure Data Lake Storage
- Involved in end to end migration of Power BI Reports
- Maintained complex T-Sql queries, views and stored procedures in multi database environment
- Migrated changes from staging to production environment and provided technology support to meet business requirements
- Analyzed existing SQL queries to identify opportunities for improvements
- Developed, implemented and optimized stored procedures and functions using T-SQL
- Designed and implemented end to end IoT data processing solution leveraging Azure services
- IoT devices transmitted messages to an IoT Hub, which were seamlessly transferred to Azure Data Lake Storage(ADLS)
- Utilized Azure Synapse Notebook to process incoming messages in real-time through streaming, and triggered automated responses using Azure Functions when specific conditions were met
SQL Developer & Support
ACS Infotech Pvt Ltd
Noida
04.2018 - 03.2021
- Involved in testing of new features with the help of manual testing
- Analyzed existing SQL queries to identify opportunities for improvements
- With the knowledge of Tableau and Power BI have prepared various visualization which resulted in prompt communication and understandability with users
- Applied knowledge in area of analysis to develop custom database objects, stored procedures and application support
- Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback
- Performed regular database updations
- Documented and analyzed business reports for prompt communication, follow-up and ongoing support
- Created optimal technical solutions to user needs through research and in-depth system and market analysis
- Supported multiple concurrent projects enabling delivery efficiencies and technical resolution
- Drove data analysis, resolving complex business issues and proposing long-term system solutions and improved applications performances
- Involved in cross team training's and implementations
- Carry domain knowledge of Automobile and Insurance industry
Education
Master of Computer Applications -
Amity University
01.2021
GNIIT(Diploma : Computer Application) -
NIIT
01.2016
Skills
Databases Microsoft SQL Server
Cloud Azure Data Factory , Azure Synapse Analytics , Azure Databricks ,Azure SQL ,AWS
Programming Skills SQL ,Pyspark
Visualization Tool Power BI
- Project Management and Team Management
- Stakeholder Management
- Effective Communication and Documentation
Certification
- Databricks Certified Data Analyst Associate
- Databricks Certified Data Engineer Professional
- Microsoft Azure Data Fundamentals
- Generative AI Fundamentals
- Databricks Lakehouse Fundamentals
Languages
- English, Proficient
- Hindi, C2
Timeline
System Analyst
Hexaware Technologies
03.2024 - Current
Consultant
Celebal Technologies
04.2021 - 03.2024
SQL Developer & Support
ACS Infotech Pvt Ltd
04.2018 - 03.2021
Master of Computer Applications -
Amity University
GNIIT(Diploma : Computer Application) -
NIIT
Similar Profiles
Monika KumariMonika Kumari
Senior Software Engineer Team Lead at Hexaware TechnologiesSenior Software Engineer Team Lead at Hexaware Technologies
Deveshkumar SinghDeveshkumar Singh
SENIOR PROJECT MANAGER at Hexaware TechnologiesSENIOR PROJECT MANAGER at Hexaware Technologies
Tamilselvan RadhakrishnanTamilselvan Radhakrishnan
Dotnet Core Fullstack Developer at Hexaware TechnologiesDotnet Core Fullstack Developer at Hexaware Technologies