Susabhya Upadhyay
Senior Database Developer
Bengaluru
Summary
PROFESSIONAL SUMMARY:
- 9+ Years of overall progressive experience as an experienced SQL/PLSQL Developer with a proven track record in designing, developing, and maintaining robust database solutions.
- Skilled in writing complex SQL queries and optimizing query performance using techniques such as index optimization, query tuning, and execution plan analysis to ensure efficient data retrieval and processing.
- Seasoned professional with extensive experience in designing, developing, and implementing data integration solutions using Azure Data Factory (ADF), harnessing its capabilities to orchestrate complex data workflows efficiently.
- Experienced in designing and implementing ETL processes to extract, transform, and load data from diverse sources into target databases, leveraging SQL scripts or ETL tools for seamless data integration and synchronization.
- Proficient in utilizing Azure DevOps for streamlined development, continuous integration, and deployment processes.
- Outstanding analytical ability and grasping power that enables to learn new technologies and tools.
- Familiarity with Software Agile Methodology, enabling the adaptation of agile practices for efficient project management.
Overview
10
10
years of professional experience
4
4
Certifications
Work History
Technical Lead
Wipro Technologies
12.2018 - Current
- Worked on designing, developing, and implementing data integration solutions using Azure Data Factory to orchestrate and automate data workflows.
- Created efficient and scalable data pipelines in Azure Data Factory to ingest, transform, and load data from various sources such as Azure Blob Storage, Azure SQL Database, Azure Data Lake Storage, and on-premises systems.
- Build ETL processes in Azure Data Factory to cleanse, transform, and enrich raw data for analytics and reporting purposes, ensuring data quality and consistency.
- Worked on designing and implementing ETL processes using SQL scripts or ETL tools like SSIS (SQL Server Integration Services) to extract data from various sources, transform it according to business requirements, and load it into target databases/data warehouses.
- Worked on creating and maintaining stored procedures, user-defined functions, and triggers to encapsulate business logic, enforce data integrity constraints, and automate database operations.
- Worked on optimizing SQL queries to extract, manipulate, and analyze data from relational databases, ensuring efficiency, accuracy, and adherence to business requirements.
Technology Analyst
Infosys Ltd.
02.2014 - 12.2018
- Worked in multiple Data Migration Projects using Oracle PL-SQL, MS-SQL Server and Microsoft Azure.
- Developed and optimized complex SQL queries, stored procedures, and triggers to ensure efficient data retrieval and manipulation.
- Designed, updated, and created relational database models to ensure data integrity, efficient storage, and retrieval.
- Created Schemas, users, tables, constraints, indexes, triggers, privileges, roles, cursors, anonymous blocks, sequences, synonyms etc.
- Utilized extensive database knowledge to identify and resolve performance bottlenecks, enhancing system responsiveness and user experience.
- Applied strong troubleshooting skills to identify root causes of database issues and implemented effective solutions in collaboration with the team.
- Highly effective working in a team, as well as working independently.
- Create and modify the solution/batch jobs using PLSQL/C#/Unix.
- Utilized PL/SQL programming to implement business logic and enhance database functionality.
- Designed, updated, and created relational database models to ensure data integrity, efficient storage, and retrieval.
- Demonstrated proficiency in monitoring databases, proactively identifying potential issues, and proposing corrective actions.
Education
Bachelor of Technology -
Rajasthan Technical University
Kota 04.2001 -
Skills
Microsoft Azure
Azure Data Factory
Database Development
Agile Methodology
Microsoft SQL server
SSIS (SQL Server Integration Services))
Performance Tuning
Database Migration
Oracle PLSQL
OOPS Concepts
Unix Shell Scripting
Soft Skills
- Agile Methodologies
- Leadership/Teamwork
- Decision Making/Analysis
- Communication
- Multi-tasking
- Adaptability
- Problem Solving
- Work Ethics
Sectors Worked
- Banking/Finance
- Insurance
- Food Industry
- Healthcare
Certification
Microsoft Azure Fundamentals (AZ-900)
Timeline
Salesforce AI Associate
02-2024
Microsoft Azure Fundamentals (AZ-900)
07-2023
SQL Advanced Certification (Hacker Rank)
08-2022
Upper Intermediate English (British Council)
11-2021
Technical Lead
Wipro Technologies
12.2018 - Current
Technology Analyst
Infosys Ltd.
02.2014 - 12.2018
Bachelor of Technology -
Rajasthan Technical University
04.2001 -