Ganesan Subramanian

Title:LRD – Line holder and Reserve Designation - Crew Planning, 

American Airlines, 08/2019 - Present, 14, ASP.NET, MVC, JavaScript, C#, MSSQL, Power BI, The purpose of the LRD tool is to provide the FA with the capability to select their preferred designation for the next contract month during the FA bidding window. Active FA’s can bid for 'Reserve Bid on (ON)' or 'Reserve Bid off (OFF)'. This utility also provides the ability for crew planners to define the required FA count for a given base for following 3 categories (which are termed as buckets)., Worked on all Phases of data warehouse development lifecycle from gathering requirements, Implementation, Testing and Support., Designed and Developed ETL SSIS packages for Incremental Load Process., Developed Multiple Dashboards, analytical reports, KPI’s and Interactive reports based on Business Needs using Report viewer in Dot Net and Power BI., Migrated Existing Self-service reports and adhoc reports to Power BI., Developed Custom Calculated measures using DAX in Power BI to satisfy Business needs., Involved in Analysis, Design, and Development of the application., Preparation of estimation based on the understanding of requirement and impact analysis., Designed and created Web pages in ASP.NET. Worked MVC framework and provided client validation using JavaScript., Responsible for deployment of the Application in production and resolving any post-deployment issues., Support Build and release activities., Provide guidance to all team members to complete their tasks on time., Designed and Created database objects such as Tables, Stored Procedures, Functions, and Indexes using PL/SQL., Created package with different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)., Created VB script for transforming data from various sources like Sabre, Teradata, Oracle. Cargo Intranet Applications, American Airlines, 08/2015 - 2019, 4, Delivery Project Lead, Java, Spring, Hibernate, ASP.NET, MVC, JavaScript, C#, AA uses the below 4 main portals to support the entire cargo operations on day-to-day basis: Operations.aa.com, Cargo.aa.com, Customs.aa.com, Dashboard.aa.com., Created web pages using Classic Asp, .Net, Spring MVC, developed layout pages, classes for reuse., Involved in Analysis, Design, and Development of the application., Preparation of estimation based on the understanding of requirement and impact analysis., Designed and created Web pages in ASP.NET. Worked MVC framework and provided client validation using JavaScript., Responsible for deployment of the Application in production and resolving any post-deployment issues., Support Build and release activities., Provide guidance to all team members to complete their tasks on time., Designed and Created database objects such as Tables, Stored Procedures, Functions, and Indexes using PL/SQL., Created package with different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)., Created VB script for transforming data from various sources like Sabre, Teradata, Oracle. CRM for AHA Korea General Insurance, AHA Korea, 01/2010 - 08/2015, 6, Delivery Module Lead, ASP.NET, JavaScript, Ajax, C#, XML, This application is used as a CRM tool for AIG Korea to perform well defined customer service. It is widely used by all lines of business in the insurance domain and major throughout the call centers. Used by the front counter staffs to answer walking customers regarding their policies. NPS (Net Promoter Score) – Development and Support, AIG - APAC Countries, 24 months, 4, C#.Net, SQL Server 2008, Chartis in APAC Region has a few pockets of business operations reaching out to customers to obtain an indication of customers’ satisfaction (mainly through complaints management) but the current approach is tactical and sporadic across countries and areas of business operations. UHC – Foreign Claims, United Health Care, US, 04/2006 - 07/2006, 3, Team Leader, Asp.Net, Sql Server 2000, This is a Web application which is used to fulfill the needs of the UHC. UHC is a health care company. Their need is to have a system which is fully automated and manually configurable to track the claims which are collected from Regional mail located in various places in US. RMO – Regional Mail Office, UHC, US, 04/2005 - 12/2005, 6, Team Member, C#, ASP.Net, SQL Server, JavaScript, This is a Web based application developed for the Poultry industry. The outcome of this application is used to monitor the daily transactions done in the poultry industry.

• Date of Birth: 03/15/82
• Marital Status: Married

• Tamil
• English
• Tamil