- Fannie Mae
- Gathered and consolidated requirements from the key stakeholders and product owner for the analysis of potential future exposures (PFE) models
- Identified the upstream input sources for reporting of models like derivatives, interest rates, volatility and macro-analysis economics factors for PFE calculations
- Participated in upcoming sprint planning, quarterly planning and routine Scrum activities, followed Agile
- Worked with teammates to clarify requirements and scope and test developed solutions to achieve more
- Helped prioritize and groom user stories in JIRA with advanced team members and documented
- Assisted in designing the technical structure for reporting outputs for models which would use
- Redshift
- Python packages, AWS Glue
- Performed
- Drove communication with other interface teams including modeling architects, support team and documented important decisions and UAT requests in Confluence
- Participated in production deployment of models for daily reporting of Swaps, Swaptions and other PFE
- Oracle PL/SQL Developer - State of Georgia, DPH
- Analyzed the requirements from epidemiologist for Congenital Infection Registry (CIR) to source data from existing tables in Oracle database for creating extracts in csv format to report to CDC
- Worked with the ETL team by using
- SQL Loader to load data relating to manual reporting and archived
- Developed
- Enhanced the processing time for each extract from 1 hour 22 mins to 12 mins after
- Created simplified algorithm in external source schema to merge csv files using
- Pandas, NumPy, SciPy
- UNIX shell scripts to automate the execution of selected CIR IDs for reporting while producing
- Completed the reporting module for entire CIR system successfully with automated extract delivery