Archana Babu

Risk Adjustment Consolidated Submission Application (RACS) - A central hub for collecting, storing, and forwarding data currently handled by multiple systems.

➛ Developed Test Cases for Deployment Verification, ETL Data Validation and Report testing.
➛ Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
➛ Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
➛ Experience in querying and testing RDBMS such as Oracle, MS SQL Server using SQL for data integrity.
➛ Developed python script using Pandas and NumPy data frame for data validation in source, delta, master, stagging and target databases.
➛ Data loading of historical data onto the data warehouse , as well as reference data and metadata.

The Enterprise Physical Access Control System Integration project (ePACS) will deploy a new Physical Access Control System (PACS) to the facilities where American Airlines manages physical access. This security management suite will also become the system for badge/card creation

➛ Designed and developed REST APIs service validation scenarios using Spec-Flow (BDD framework) for business and functional requirements.
➛ Developed Hybrid framework for web application using BDD and Page Object Model to validation business scenarios for Enterprise Physical Access Control System.
➛ Integrated & executed test framework in CI/CD pipeline in test and stage by collaborating with teams such as DevOps(Azure) and support teams in CI/CD areas.

Crew Watch platform is an employee facing solution that allows operations teams to more effectively model and manage crew misconnects, illegalities, cancellations and recover affected crew on cancelled flights unlike the existing. Crew Watch incorporates FAR 117 & FAR 121 regulations and Joint Collective Bargaining Agreements (JCBAs) to allow the user to evaluate future legality issues utilizing configurable parameters such as ground objectives, gate connections and custom connections as well as lay the foundation for integrating additional crew disruption feature.

➛ Developed simulation framework for the LookAhead applications in the test environment.
➛ Developed automation strategy for complex integration of web and SABRE HTE components.
➛ Worked with the Crew SMEs to understand the challenges of creating illegalities in the test environment.

Implementation of SuccessFactors integration to CERS, Flight CAPS and Siebel Case Manager to process critical data points from a new interface set up in Employee Central

➛ Siebel server managment, local database extracts, upgrades, applying patches, monitoring siebel components, maintance of static data like LOV, responsibilities, EIM.
➛ Code Migration like Repository Migration, SRF Deployment and other special deployment activities required for AA.
➛ Database related tasks including Backup of DB, monitoring DB performance and server space/performance, etc.