Open To Work
Aman Saxena
Kanpur
Summary
Analytical SQL Developer known for high productivity and efficient task completion. Specialize in database design, Stored procedure, query optimization, and data analysis. Excel in problem-solving, communication, and teamwork to enhance project outcomes. Committed to delivering reliable solutions and improving data-driven decision-making processes.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Senior Software Engineer
FIS Global
Mohali
06.2023 - Current
- Led migration of SSIS packages to Azure, achieving high availability and scalability for cloud operations.
- Optimized database performance through execution plan analysis and strategic indexing, improving query response times.
- Managed large-scale datasets to enhance data retrieval using advanced query techniques like CTEs and window functions.
- Designed, implemented, and maintained complex SQL queries, stored procedures, and triggers for enterprise applications.
Technology Analyst
Infosys Limited
Mohali
08.2020 - 06.2023
- Created database objects, including tables, views, and indexes in MSSQL.
- Developed stored procedures, functions, and triggers to meet application requirements.
- Optimized database performance through indexing and query tuning techniques.
- Troubleshot database issues, minimizing downtime and disruptions.
- Tested databases thoroughly and fixed bugs, enhancing stability.
- Optimized queries using SQL tuning methods for improved performance.
- Designed complex reports with SQL Server Reporting Services.
- Utilized Power BI to design advanced reporting solutions.
Education
Bachelor of Technology - Computer Science
PSIT College Of Engineering
Kanpur07-2020
Skills
- MSSQL and PL/SQL
- Advanced SQL queries
- SQL optimization strategies
- Stored procedures development
- Complex query design
- ETL processes and SSIS
- Database troubleshooting
- Data modeling techniques
- Power BI and data visualization
- DAX and Power Query
- Python programming
- Git version control
- Agile methodologies
- Requirements analysis
- Technical documentation
Certification
Data Analyst, Newton School, 01/01/24, Present, https://my.newtonschool.co/course/4rpcpo4uanl7/certificate/61xk8yq2n4nk/verify
Projects
Print and Mail :-
- Designed and maintained complex T-SQL stored procedures and functions to automate high-volume financial document processing.
- Optimized data retrieval for real-time tracking systems by analyzing execution plans and implementing advanced indexing strategies.
- Refined database schemas and normalized tables to handle increasing volumes of transactional data without degrading performance.
Molina Healthcare:-
- Led the migration of legacy SSIS packages to Azure, ensuring seamless data integration and scalability for healthcare applications.
- Developed sophisticated SQL queries using CTEs, window functions, and advanced joins to extract critical patient and provider insights.
- Utilised Azure and SQL Server to support large-scale healthcare data transformations and migrations.
Languages
English
Proficient (C2)
C2
Hindi
Native
Native
Accomplishments
- Top Performer Award, Q4 2022 - To Scale up and provide a quality deliverables
Work Preference
Job Search Status
Open to workWork Type
Full TimeLocation Preference
RemoteHybridOn-SiteSalary Range
₹0/yr - ₹1000/yrTimeline
Senior Software Engineer
FIS Global
06.2023 - Current
Technology Analyst
Infosys Limited
08.2020 - 06.2023
Bachelor of Technology - Computer Science
PSIT College Of Engineering