نبذة عني
Business Analyst with experience in energy markets, data analysis, ETL design, business and technical documentation, QA testing, and project coordination. Experienced with Python, R, SQL, Tableau, Alteryx, AWS, Airflow, …
Business Analyst with experience in energy markets, data analysis, ETL design, business and technical documentation, QA testing, and project coordination. Experienced with Python, R, SQL, Tableau, Alteryx, AWS, Airflow, Spark, and database technologies including MySQL, MS SQL, PostgreSQL, and Apache Cassandra.
الخبرة
Business Analyst
When I worked as a business analyst some of my
responsibilities were:
• Researching on various energy markets
• Accessing various data sources and designing the ETL
processes
• Acting as an intermediary between traders and
developers in designing and guiding business application
development
• Gather requirements and then create business design
documents for different projects
• Lead project planning among other scrum tasks such as
sprint planning
• Do Quality Assurance tests on projects in their different
stages of development
Business Analyst
Researching on various energy markets
Accessing various data sources and designing the ETL processes
Acting as an intermediary between traders and developers in designing and guiding business application development
Gather requirements and then create business design documents for different projects
Lead project planning among other scrum tasks such as sprint planning
Do Quality Assurance tests on projects in their different stages of development
Complete real time integration of the UK primary power data provider called Elexon
Documented how to apply the data to trading tools
Managed developers to implement the integration
Did analysis of the Irish power market
Used python scripting
Used excel for front end chart displays
Used postgres sql database for storage of data
Used tableau and Alteryx for in depth granular understanding of the market
Integration of ENTOSE for domestic UK short term trading and cross border trading
Accomplished a detailed study of the data available
Investigated the api through which the data was to be absorbed
Mapped out how the data would be transformed into fitting the existing systems
Mapped out how the data was to be saved in the database
Managed the project to completion
Integration of capacity market, JAO and nomination sites such as RNP and Britned
Investigated the data sources
Mapped out the process of integration, transformation and storage
Fed the data to the greater trading software
Integration of trading market platforms such as Nordpool and EEX
Developed a complete new application that would send alerts if traded volumes did not match capacity or nominations
Led designing, documenting, and managing the project to build the system
Automatically sent varying levels of alerts depending on the thresholds of differences
Trading Analyst
Part of the trading team that traded UK, Ireland and European power including markets such as Day Ahead, Intraday and Cross Border
Researched different ETRMS such as LCP Enact and Enappsys
Concluded that inhouse tools were better suited for trading strategies
Freelance Software Developer
Developed a web system using ASP.NET technology for the car bond company named Haks
Gathered requirements
Designed the system
Programmed the application
Deployed it to a web server
Reduced the cost previously being incurred by the client from using a paid service
IT Consultant
Acted as a freelance developer for the university
Worked in the development of a third-party web application
Delivered a stable web product built with ASP.NET and Ms Sql