Aditya Arya Email & Phone Number

Columbia, Maryland, United States

Mclean, Virginia, United States

Reston, Virginia, United States

• FLS-MAM Shore Units Data TransitionData Transition/ETL7/2020 – 9/2020FLS-MAM – Silverlight RewriteDev Agile 10/2019 - 7/2020MISLE Mobility IPAPDev Waterfall10/2019 - 3/2020NPFC COFRDev Agile 10/2019 – 12/2019
• Led a 6-member development team to develop automated solution using SSIS that would transition inventory data for 367 different Shore Units from their Current respective databases to FLS-MAM Central database. Working.
• Led a 9-member cross-functional team to rewrite UI of full application FLS-MAM. The new solution would reuse the existing backend services and SQL Server database. (#2)
• Led a development team to do limited porting of Windows app to iOS, and subsequently to Platform agnostic implementation so it could be ported to various operating systems. (#3)

Washington D.C. Metro Area

FREDDIE MAC PROJECTSProject: Single Security Releases Duration: March 2018 to June 2019Role: IT Project ManagerProject: IT Resiliency WorkforceDuration: January 2018 to March 2018Role: IT Project ManagerProject: Quantum Modernization Phase IIIDuration: November 2017 to January 2018Role: IT Project Manager/DB ArchitectProject: Pricing.

• Led a 12-member Scrum team that studied 6 legacy Windows Database applications with total 240 screens & 90+ reports and documented business rules & logic in preparation for move to Appian BPM (#8).
• Led Freddie Mac’s flagship “CSP – Single Security” project that created Common Mortgage Backed Security and made Freddie competitive with Fannie and opened up 3.9 trillion UMBS market to Freddie. (#1)
• Led a project to optimize performance of Sybase application. Oversaw rewrite of database procedures, triggers, indexes related to 20 most critical functional areas of an application. This improved performance from 30%.
• Redesigned the architecture of data archival and reporting process to optimize daily archival and reports generation. This reduced daily archival time from full night to just over an hour without impacting reporting.
• For a very high-profile Selling Systems, managed over 20 Dev, SIT/UAT, End-to-End, Training, Performance environments for over 19-month period. This included coordinating with all upstream & downstream impacted.
• Coordinated encryption of organization-wide prod & non-prod, structured and non-structured databases containing PPI data using Vormetric Agent. (#7)

Birmingham, Alabama Area

• Healthcare domain SME with focus on patient health records.
• Instrumental in developing full gamut of business rules aware controls, class & function libraries. This reduced front end development time by 40%
• Drove structured, cost-effective instance level development that could easily maintained.
• Accomplished data modeler who Introduced widespread use of database features like stored procedures, triggers, built-in packages and object-oriented features of Oracle to improve application response time by more 50%.
• Led seamless integration of 3rd party healthcare APIs like Micromedex, Purkinje, Multum, FDB thus bringing wealth of new features into our applications.
• Imported and integrated External reference data from various sources including LOINC, UNII, J-Codes, ICD 9 & 10 mappings, RxNorm and Multum & FDB mappings. This brought thus far missing features to our applications.