$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Experienced BI Analyst/Developer
Jenny Melvin
,
Norwich, United Kingdom
Experience
Other titles
Skills
I'm offering
I am an experienced analyst/developer who enjoys problem-solving. I specialise in data analysis in creating dashboards and reporting tools through Excel, Word, Access, Power BI etc.
My natural ability to see the whole picture and not only the area I am working on, enables me to create maintainable, future-proof solutions. I take pride in my work and enjoy a challenge!
My natural ability to see the whole picture and not only the area I am working on, enables me to create maintainable, future-proof solutions. I take pride in my work and enjoy a challenge!
Markets
United Kingdom
Language
German
Good
English
Fluently
French
Good
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2016 - ?
freelance
Freelance BI Analyst/Developer
Freelance BI Analyster/Developer.
I work with firms to analyse their requirements and create automated bespoke reports and dashboards, allowing them to easily see up-to-date information from their data sources.
Technology used: T-SQL, Access SQL, Excel VBA, Word VBA, MS Access, Power BI, Target Dashboard, Smartsheet
Technology used: T-SQL, Access SQL, Excel VBA, Word VBA, MS Access, Power BI, Target Dashboard, Smartsheet
T-SQL, UP, Power, Server, BEE, Office, Analyst, Developer, It, Access, Sql, Word, VBA, Database, Power BI, CRM, SQL Server, Data Analysis, Excel
2018 - 2019
freelance
Data Migration Consultant
Contract role.
Creation of process to migrate of data from one Financial Services CRM to another through complex coding in T-SQL creating views, cte's, cursors, functions etc.
Office 365, Data quality, Testing, Office, Online, Data Analysis, Sql
2015 - 2016
job
Software Developer
Redrose Software.
(MS Access, VBA, SQL, Visual Studio, TFS)
* In a small team working in a fast-paced environment, I provided development support for the Microsoft
Access ERP software.
* I designed and implemented improvements to the system and to business processes, which increased
efficiency for clients and the development team.
* I built relationships with clients and was known to be capable and reliable, trusted by colleagues and clients alike.
* In a small team working in a fast-paced environment, I provided development support for the Microsoft
Access ERP software.
* I designed and implemented improvements to the system and to business processes, which increased
efficiency for clients and the development team.
* I built relationships with clients and was known to be capable and reliable, trusted by colleagues and clients alike.
Sql, ERP, VBA, Visual Studio, Access, Developer, TFS, Support, Development, Software, Processes
2012 - 2015
job
Software Engineer
Sunquest Information Systems.
(Pascal, VB.net, T-SQL, Agile, PowerShell, TFS, Visual Studio)
* My main role was to maintain and develop two legacy applications used by the NHS. There was little
knowledge of either system in the development team and my task was to gain that knowledge and develop the systems.
* I held the responsibility of designing and implementing a major upgrade to comply with new regulations. I
performed design, development and testing work and coordinated with other team members to ensure
that the project was completed on time and with no defects.
* I implemented source control for both systems within TFS, produced documentation and ensured that all
software changes follow the strict company processes for design, development, testing, release and use of sensitive data.
* I held meetings with internal and external stakeholders to ascertain requirements for future
redevelopment of the systems and investigated suitable technologies.
* I was a part of the development support team for the core Sunquest VB.net software, which involved
finding defects in the code and providing a solution.
* I held the role of Agile Scrum Master and effectively steered the team to meeting scrum targets, through
improving communication and clearing impediments.
* My main role was to maintain and develop two legacy applications used by the NHS. There was little
knowledge of either system in the development team and my task was to gain that knowledge and develop the systems.
* I held the responsibility of designing and implementing a major upgrade to comply with new regulations. I
performed design, development and testing work and coordinated with other team members to ensure
that the project was completed on time and with no defects.
* I implemented source control for both systems within TFS, produced documentation and ensured that all
software changes follow the strict company processes for design, development, testing, release and use of sensitive data.
* I held meetings with internal and external stakeholders to ascertain requirements for future
redevelopment of the systems and investigated suitable technologies.
* I was a part of the development support team for the core Sunquest VB.net software, which involved
finding defects in the code and providing a solution.
* I held the role of Agile Scrum Master and effectively steered the team to meeting scrum targets, through
improving communication and clearing impediments.
T-SQL, Processes, Vb, Software, Development, Testing, Support, TFS, Net, Design, PowerShell, Visual Studio, Vb.net, Agile, Scrum master, Scrum, .Net, Sql
2011 - 2012
job
BI Developer/Analyst
Alan Boswell Insurance Group Ltd.
(T-SQL, SSRS, MS Access, SQL Profiler, Adviser Office, C#.net, Sharepoint, Open-GI)
* My role was to analyse the SQL Server database of the Iress Adviser Office CRM software used by the Financial Services department and create reports that would enable them to streamline their
administration and increase profitability.
* There was no knowledge within the development team of the database so I worked independently,
creating from scratch an extensive suite of reports and data extracts in SSRS and Sharepoint, enabling the business to make many efficiencies.
* I designed and developed an administrative system in Access 2010, importing data from existing Excel
spreadsheets into SQL Server tables linked to an Access front-end. The system enabled users to automatically upload data received from clients and maintain client/product information to produce
reports.
* I spent several months training a new member of staff in T-SQL, SSRS and Access. I was responsible for
allocating and supervising his work.
* My role was to analyse the SQL Server database of the Iress Adviser Office CRM software used by the Financial Services department and create reports that would enable them to streamline their
administration and increase profitability.
* There was no knowledge within the development team of the database so I worked independently,
creating from scratch an extensive suite of reports and data extracts in SSRS and Sharepoint, enabling the business to make many efficiencies.
* I designed and developed an administrative system in Access 2010, importing data from existing Excel
spreadsheets into SQL Server tables linked to an Access front-end. The system enabled users to automatically upload data received from clients and maintain client/product information to produce
reports.
* I spent several months training a new member of staff in T-SQL, SSRS and Access. I was responsible for
allocating and supervising his work.
Net, Server, BEE, Software, Office, Development, Analyst, Developer, SSRS, Access, Sql, T-SQL, C, Database, SharePoint, Training, CRM, SQL Server, Administration, Excel
My education
1988
-
1990
Kingston College of Further Education
A levels, Pure Maths, Maths with stats, Computer Science, Economics
A levels, Pure Maths, Maths with stats, Computer Science, Economics
1984
-
1988
Cheam High School
Secondary, English, Maths, Chemistry, Physics, Geography, German, French, Art
Secondary, English, Maths, Chemistry, Physics, Geography, German, French, Art
Jenny's reviews
Jenny has not received any reviews on Worksome.
Contact Jenny Melvin
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Jenny directly in Worksome.
37900+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark