New York, New York, United States
In addition to responsibilities as Technical Engineer: • Mentor junior engineers – 2x weekly trainings and code reviews
• Design and develop technical solutions across 26 client-specific implementations and 5 discrete product modules • Build custom ETL pipelines to integrate with third-party data providers • Automate business workflows, create custom dashboards and reports • Advise clients on core product architecture and industry best practices • Troubleshoot urgent client issues in production environments • Contribute to code diff tool, won 2nd place in company Hackathon
• Implemented cloud-based data management solutions for financial institutions, including data warehousing, research, portfolio and trade order management • Translated client requests into detailed technical requirements documents, outlining business use cases and entire SDLC • Utilized product and business knowledge to explain complex systems to external stakeholders, including Ops teams and non-technical end users
• Automated financial data management processes using Python (Pandas, OpenPyXL), reduced monthly bookkeeping time by 40%
• Developed generic data validation tool: Python scripts to classify data into a star schema and produce trended aggregate statistics, Microsoft Power BI interactive dashboard to highlight data inconsistencies • Deployed tool to hosted solutions teams, improved data quality and reduced validation time by 30%
• Examined trended bank data across multiple population segments to create custom thresholds to identify any outlier data trends across 400+ data validation tests • Developed multifaceted SQL query to pull all validation metrics into one comprehensive view, and then automatically flag all metrics that did not comply with assigned thresholds • Utilized VBA to design and automate generation of visually appealing data reports, which are leveraged by the data validation team to save time and effort during their daily processes • Presented project to upper management using strong visual aids and presentation skills to clearly communicate the project's functions, features, and overall importance to the company