Sneha S

• Managed distribution operations for the entire AERO Mobile Applications portfolio, ensuring timely and efficient BETA and Production releases of iOS, Android, and Windows applications. • Making recommendations on best practices to improve the efficiency of BETA and Production releases.
• Reviewed stakeholder approvals, worked with the legal team on EULA changes, interacted with UX designers, and tested each application for quality assurance as release manager, ensuring all required metadata and marketing materials were up-to-date before submittal.
• Manually decompiled, re-signed, and recompiled applications for distribution using command-line tools and XCode, when needed. Developed automation scripts and educated international teams to minimize AppStore rejection.
• Also Worked as DBA maintaining our databases which are hosted in our own VDC maintenance like Database Backup and Recovery, Data Extraction, Master-slave Replication, Cluster configuration, AIRAC recurring process updates, Performance Monitoring of Databases, and Datacenter Migrations. I have been supporting flight services and cabin services. Resolved around 250+ cases and also supported database activities.

• Worked for around 2 years as a DBA and application developer(Supporting applications like mygdc, WIS, Weather, SMS, Bridge, and FSM).
• Database Maintenance like Database Backup and Recovery, Data Extraction, Master-slave Replication, Cluster configuration, SITA and ARINC recurring billing process, and Monthly Aircraft BOW Updates. AIRAC recurring process updates. Performance Monitoring of Databases. Datacenter Migrations.
• I have been supporting flight services and cabin services.
• Resolved around 80+ cases and also supported database activities. Also worked as a developer handling around 5+ legacy applications and resolved around 100+ cases

Worked for around 1+ year on the OneNav+ tool. It is a desktop application that provides an environment to view, Compare and Archive the navigational data, Data-Driven Charts (DDC), Aerodrome Mapping Databases (AMDB) and Enhanced Ground Proximity Warning System (EGPWS) in user understandable format. This tool is primarily used by the airline users/partners/engineering teams and the production teams. OneNav+ application decodes the Navigation Database (NavDB)/DDC/AMDB/EGPWS database in a human-readable format which is derived from ARINC 424 format. This decoded file then can be exported to a text file for further use. This tool has the capability to show the information graphically and textually to view the binary data. It also creates loadable media for Navigation Databases which can be loaded into the FMS. With the increasing demand for the use of this tool, along with the regular builds many new modules/database formats are identified that fit into the existing framework to integrate them with OneNav+. This tool is also capable to Archive, Compare, Export, and Plot the databases

• Worked for around 1+ year. Had experience in System Development Life Cycle (SDLC) including Analysis, Application Programming, and Testing.
• Designing, building, testing, implementing & maintaining reliable C, and C++ code applications for the Windows platform.
• Constructive skills in developing complex algorithms. Expertise in technologies like Oracle, SQL PL/SQL, C. Had Constructive skills in developing stored procedures, user-defined functions, packages, and application of cursors.
• Had worked on complex SQL queries with Joins, Functions, Sub-queries, Views and Set operators. Expertise in SQL Queries for manipulation of data. Expertise in trapping run time errors by providing suitable Exception Handlers.
• Have used SQL Developer & TOAD extensively to develop PL/SQL code. Expertise in Query optimization & analyzing clients' business processes to deliver accurate solutions to incorporate the same business logic in software products. Ability to be an effective team player and work under time constraints.
• Good interpersonal communication skills and technical Documentation skills.
• Responsibilities: Requirement Analysis, requirement preparation, UTC preparation, implementation, UTC execution and integration