Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$100 USD / hour
Flag of UNITED KINGDOM
not telling, united kingdom
$100 USD / hour
It's currently 6:53 AM here
Joined November 30, 2007
0 Recommendations

Ian P.

@rickyproductions

5.0 (11 reviews)
4.5
4.5
100%
100%
$100 USD / hour
Flag of UNITED KINGDOM
not telling, united kingdom
$100 USD / hour
100%
Jobs Completed
100%
On Budget
100%
On Time
29%
Repeat Hire Rate

Professional MsAccess Developer & Business Analyst

Firstly, thanks for taking the time to look at my resume. I\'m an IS/IT professional with 10+ years experience surrounding the analysis, design and build of IS projects for companies ranging from small one man bands to large blue-chip organizations. I have a rare blend of technical & \'soft\' skills, and i\'m a tenacious leader able to lead, motivate and develop teams while liaising with both technical and business users as well as third party vendors and stakeholders. I adopt a positive attitude to work, with superior written and verbal communications skills, developed over many years of client facing at all levels. CAREER HIGHLIGHTS o    Experienced across all stages of the project lifecycle, from requirements gathering & analysis through to coding, testing and sign-off; o    Extensive Financial Services sector exposure, including: electronic payments, MI reporting, data warehousing data analysis. o    Business focused but from a development background, therefore highly proficient in both business & technical areas & translating the requirements from both. o    Familiar with front middle & back office functions of UK corporate & commercial banking, with knowledge & experience of payments gateways, protocols & organisations such as SWIFT, VOCA etc.; o    Proficient in gathering and documenting both functional & non-functional requirements, creating test plans, performing GAP Analysis and supporting testing at all levels, liaising between IT & business to ensure all requirements are understood & delivered; o    Proven track record of ensuring project elements are delivered within time and budgetary constraints; o    Highly proficient in coding (VBA) Ms Office programs such as Ms Access, Word, Excel to expert level.Excellent understanding of the practical and theoretical aspects of database systems and their supporting architecture (such as ERD modeling and normalization). PROFESSIONAL EXPERIENCE IT consultant, business analyst and developer Various clients.    2004 - Present Adopted a consultative and collaborative approach as a professional I.T. Consultant in the areas of data, systems and process analysis, design and build. ACADEMIC BACKGROUND [login to view URL]. (Hons) Computing for Business, 2:1    University of Northumbria    2001 - Computer Science degree  (with a strong emphasis on database theory and practice) which also combined business analysis and project management skills. ## Area of Expertise Ms Access design & build (All versions from 97 - 2010) * Programming * Design * Queries * SQL * Complete applications * Reporting * Security * Relationship modeling * Normalization * VBA (Visual Basic for Applications) Ms Office automation & interoperability for: * Ms Access * Ms Excel * Ms Outlook * Ms Project * Ms Work * Visio Large (& small!) Mail Merges: * Word/Ms Access/Outlook Application integration Application development Application testing Ms Office programming including use of: * APIs * Web services * ADO * DAO * VBA * VBScript * COM/ActiveX, * ODBC * Visual Basic * Client-Server * DLLs Web scraping/ Data scraping (Automated collection of data from websites) Business Consulting Process improvement, Programming Requirements documentation Requirements gathering Application design Data modeling Data analysis, ER diagrams Data cleansing & de-duping

Contact Ian P. about your job

Log in to discuss any details over chat.

Reviews

Changes saved
Showing 1 - 5 out of 11 reviews
Filter reviews by:
5.0
$550.00 AUD
A very good conclusion to a prototype that has produced labour savings already.
SQL
MySQL
User Avatar
Flag of John M.
@timepoor
•
11 years ago
5.0
$426.00 AUD
This work was an addition to previous work on a database project. We're adding refinements and new reporting features and conducting regular testing. We varied timing and budget to suit the change of scope and things have worked well. This Bidder is particularly good at working up solutions from a 'fluid' specification.
Database Administration
Visual Basic for Apps
User Avatar
Flag of John M.
@timepoor
•
11 years ago
5.0
$750.00 AUD
This was a work in progress with an evolving specification. RickyProductions brought good experience and knowledge to the Project and we were able to simplify aspects of data collection and user interface to speed-up project output for the end client. We are currently packaging two versions of the project to begin client testing. I can recommend RickyProductions for strong project management and willingness to contribute beyond the immediate specification for a better outcome. A good experience all round.
Visual Basic
User Avatar
Flag of John M.
@timepoor
•
11 years ago
5.0
$353.00 USD
Ian is an accomplished programmer who delivered on the detail. Timescale became slightly extended but he kept us fully informed at every point and the final result was exactly what we were looking for. Would definitely use again.
Windows Desktop
D
Flag of Peter W.
@decibels
•
11 years ago
5.0
$85.00 USD
Rating: 5.0/5.0
Data Entry
Virtual Assistant
User Avatar
Flag of John M.
@timepoor
•
12 years ago

Contact Ian P. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

uk_english1.png UK English 1 90%
us_eng_1.png US English 1 88%
uk_english1.png UK English 1 85%
SQL_1.png SQL 1 83%
numeracy_1.png Basic Numeracy 1 83%
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.