Himanshi Katariya
Bengaluru
Summary
SQL Server Developer with 7 years of experience in the IT industry, specializing in MSSQL database development and optimization. Proven track record in ensuring data integrity and security while delivering high-quality solutions. Skilled in developing Python APIs using the FASTAPI framework and SQLAlchemy. Strong collaborator with cross-functional teams, adept at troubleshooting performance issues and implementing best practices.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Software Engineer
AIRBUS GROUP INDIA PVT Ltd
Bengaluru
09.2022 - Current
- Developed complex stored procedures and functions to meet business requirements.
- Optimized large-scale queries for performance, reducing query times by 50% and improving overall reporting efficiency.
- Designed and implemented ETL processes using SSIS for data integration from multiple external systems.
- Troubleshot and resolved data-related performance issues in production environments.
- Conducted code reviews, ensuring adherence to high standards in database development.
- Developed Python RESTful APIs utilizing FASTAPI framework for enhanced application performance.
- Designed data models and implemented robust data storage solutions with PostgreSQL database.
- Created unit tests for existing and new Python code using PyTest, improving code reliability.
- Integrated third-party APIs into applications to extend functionality and user experience.
- Participated in Agile development teams, contributing to timely project delivery through scrums and sprints.
Senior Analyst
HCL-Technologies
06.2018 - 09.2022
- Developed complex stored procedures for automation reporting.
- Created performance enhancement queries to optimize database functions.
- Designed and implemented database objects, including tables, views, and triggers.
- Managed scheduling of runbooks to streamline database operations.
- Executed synchronization of Active Directory users with the database.
- Tested APIs using POSTMAN to ensure functionality and reliability.
- Supported deployment processes across development, testing, pre-production, and production environments.
- Collaborated with clients to resolve requirements, ensuring successful project completion.
- Write dynamic queries to manage the runtime data and provide the output result set for the given input set
- Create unit test plans and perform unit testing.
Education
MTech - CE
YMCA University of Science & Technology
01.2018
B.Tech - Computer Science
The Technological Institute of Textile And Sciences
08-2015
12th -
CBSE
01.2011
10th -
CBSE
01.2009
Skills
- SQL programming
- SSIS ETL tool
- T-SQL development
- FastAPI framework
- RESTful APIs
- Pytest framework
- Performance tuning
- Aerospace industry
- Team management
- Problem solving
Accomplishments
- Received spot award twice at HCL Technology
- Received a commendation from the head of PLM at Airbus
Languages
- English
- Hindi
Personal Information
- Date of Birth: 09/28/94
- Gender: Female
- Marital Status: Married
Certification
AWS Cloud Practioner Certificate
Timeline
Senior Software Engineer
AIRBUS GROUP INDIA PVT Ltd
09.2022 - Current
Senior Analyst
HCL-Technologies
06.2018 - 09.2022
MTech - CE
YMCA University of Science & Technology
B.Tech - Computer Science
The Technological Institute of Textile And Sciences
12th -
CBSE
10th -
CBSE
Similar Profiles
Sanjeev ReddySanjeev Reddy
Senior Consultant at Capgemini India Pvt ltd (Client Airbus Group India pvt ltd)Senior Consultant at Capgemini India Pvt ltd (Client Airbus Group India pvt ltd)
Meghana Ashwin KumarMeghana Ashwin Kumar
Conformance Manager, Lead - Finance & Work Package Management, Procurement Operations Cabin Conformance Management Cross Programmes (POCC3) at Airbus Operations GmbHConformance Manager, Lead - Finance & Work Package Management, Procurement Operations Cabin Conformance Management Cross Programmes (POCC3) at Airbus Operations GmbH
Vivek Reddy KumbumVivek Reddy Kumbum
DevOps Engineer at Airbus Defence and SpaceDevOps Engineer at Airbus Defence and Space
Mohammed Zaid BangiMohammed Zaid Bangi
Middleware Administrator at AccentureMiddleware Administrator at Accenture
Keshav PushadappuKeshav Pushadappu
Community Specialist at G2.com Private LimitedCommunity Specialist at G2.com Private Limited