Nehali Shah


Location

Jersey City, NJ
Mumbai, India
Education
    Syracuse University
    January 2018 - December 2019
    degree
    Master's
    major
    Computer Engineering
    Maharashtra Institute of Technology
Work Experience
    Peri Software Solutions
    Systems Analyst
    January 2020 - present
    company
    Peri Software Solutions
    title
    Systems Analyst
    overview
    - 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
Skills
Acceptance TestingAgile MethodologyAlgorithmsAmazon RedshiftAmazon S3Amazon Simple Queue Service (SQS)AnacondaAutomationAWS GlueCalculationsCloud ComputingCloudwatchCommunication SkillsComputer EngineeringConfluenceC++ (Programming Language)CronData LoggingData WarehousingEconomyEpidemiologyExtract Transform Load (ETL)Filing SkillsFinancial DerivativesInfectious DiseasesInformation TechnologyIntrusion Detection SystemsJavaScript (Programming Language)JIRAKnowledge of EngineeringLog FilesMatplotlibMicrosoft Visual StudioNumPyOracle DatabasesOracle SQL DeveloperPandasPL-SQLPrioritization of RequirementsProblem SolvingProgramming LanguagesPython (Programming Language)SciPyScrum MethodologyShell ScriptSoftware DebuggingSoftware SystemsSql LoaderSql NavigatorStakeholder ManagementSwap (finance)Systems AnalysisTesting SkillsUnit TestingUnix ShellUser Stories