• Created Interactive BI reports and dashboards: Executive Summary, Site Activity, Upcoming Expirations, Community posts tracking and more• Promptly fixed bugs with emphasis on client delivery and an ongoing open communication with Customer Success Management and Software Development teams• Sped up many BI reports by optimizing queries and tuning client databases• Designed a black and white theme for accessibility• Tested colleagues' code and updated documentation

• ETL: cleaned data and applied business rules using Python and Apache Spark, setup and maintained process schedules and resource allocations, fixed late or failed batch jobs, programmed automatic data validations• Extracted financial data via API using Ruby and brought it into the data warehouse, developed a data model, shared code on GitHub• BI Reporting: Developed and maintained reports using SQL, Excel and BI Visualization tools such as Mode, Tableau, Python Pandas and Matplotlib• Collaborated and communicated results with Finance and Data teams

• Developed sophisticated business analytics, data mining and modelling solutions with large data sets from multiple sources• Streamlined and automated ETL processes using creative problem solving, Python, R and SQL• Responded to complex information requests and provided data analysis support to Senior Leadership and Wholesale Electricity Traders• Represented the Risk Group in new Business Intelligence Technologies Initiatives and working groups as a subject-matter expert

• Developed business analytics using MS SQL Server Analysis Services• Delivered creative Business Intelligence reports using Cognos and VBA• Automated Reports using Microsoft Power Pivot, VBA macros and Matlab• Optimized and automated business processes using innovative and creative approaches• Identified and fixed data-quality issues• Lead and successfully designed an interactive Financial Profit/Loss explanation tool• Coordinated weekly Financial and Risk reports for Senior Management• Provided Data Analysis support to Senior Leadership and Electricity Traders• Supported and trained Cognos users

• Designed and validated risk models using Matlab: VaR, options, non-standard exotic contracts and financial instruments• Developed a scenario model in VBA to evaluate a new acquisition project• Automated and established a template for the daily calculation of margin requirements for energy trading on the ICE and NYMEX exchanges

FTSE Private Banking Index was a company that produced an index and a tracker for the private banking industry. Solutions for Wealth Capital Management was it's partner. It was a hedge fund that invested in the tracker for the private banking index.• Developed a sub index in Matlab with significantly improved performance• Supervised daily valuation of index fund performance• Developed and tested financial models using Matlab and Thomson Reuters

• Lead weekly tutorials • Supervised and graded exams• Maintained student information database

• Conducted and Analyzed laboratory experiments • Wrote legal reports• Organized records in Excel• Mediated between production teams• Provided guidance to clients