Looking for IT role in Angola (DBA)
14 years ago
John Wright
Address: 86 Cline Road,
Guildford, Surrey.
GU1 3NH
Email: [email protected]
DOB: 23/01/1980
Key IT skills:
SQL Server 2005 ASP.NET C#.NET VB.NET
SQL Server 2000 Crystal Reports SSIS/DTS IIS
MS Access Visual Basic 6 XML HTML
MS Excel .NET Framework 3.5 JavaScript ASP
Career Summary:
I am a reliable professional with over seven years industry experience, more than 4 years in .NET development mainly working as a developer using web technologies and SQL Server 2000 and 2005. I have strong IT qualifications, including a BSc in Computing and I.T. from the University of Surrey. I am strong in SQL Server 2005, SSIS, T-SQL, C#.NET, VB.NET, ASP, ASP.NET, JavaScript, XML, Visual Basic 6, and HTML. I am also fluent in Spanish, and can speak French to a high standard. I am now looking to further my management experience in a senior role in software development.
Career History:
Please note that any gaps in my career history are due to having to return to studying.
July 2008-(Current)
PNI Digital Media (http://www.photochannel.com/), Guildford
Database Developer/Administrator
? Maintained and administered back end database infrastructure, including the deployment of promotions for large clients such as Tesco for their photo processing business (http://www.tescophoto.com/wpp/tesco/).
? Designed database structures including tables, indexes, stored procedures, triggers, functions and views for web facing as well as back end databases.
? Created and improved upon existing data importing processes into reporting database and back-end data processing database.
? Developed reports using Crystal Reports v10, SQL Server 2000 and 2005 for internal and external clients for clients such as Tesco, Boots, Asda, Jessops.
? Administered web based reporting engine using Crystal Enterprise Server.
? Designed and created data outputs into Microsoft Excel spreadsheets for reporting or analysis uses.
? Monitored database size and performance, as well as memory usage on database servers and resolved any issues arising.
? Administered large databases of over 40GB on both SQL 2000 and 2005 server.
? Developed tools in C#.NET to automate or facilitate monitoring or reporting tasks.
? Liaised and communicated closely with head office in Vancouver, Canada.
? Designed and developed DTS and SSIS package for a range of purposes from importing new product data to updating store information.
November 2006 – (July 2008)
Cegedim RX Ltd. (http://www.cegedim-rx.co.uk/), Chertsey
Lead Developer
? Developed features and supported existing functionality of the Group Management system (http://www.enigmagm.co.uk/ ), which is a web based system, written in ASP.NET (C#.NET and VB.NET), JavaScript, SQL Server, and using Crystal Reports. The system is used by pharmacy groups to manage and apply drug restrictions to the pharmacies, enabling groups to increase profits and efficiency.
? Worked as lead developer and team leader on an XML based messaging solution integrated into Nexphase to allow pharmacies to communicate with patients via automated telephone calls and text messages. Designed data structures and data importing process to read in the XML responses from the patients and store them in the database. Produced the functional and technical design documents for the project. Created a C#.NET message handling website to communicate between the pharmacy and the 3rd party telephone messaging company.
? Designed and developed features for the Nexphase pharmacy management system (written mainly in Visual Basic 6, JavaScript and SQL Server), which is utilised by several large pharmacy groups such as Asda, Alliance, and Boots have also recently announced a rollout, as well as many independent pharmacies.
? Developed and designed new data structures including tables, indexes, stored procedures, functions and views in SQL Server for an incremental patching system, written in Visual Basic 6. Using MD5 checksums for file identification, it was possible to incrementally patch new versions of software files or data files, register any dll or exe files as necessary and run any SQL scripts required by the update. Also the system would not only cleanly rollback if any errors were encountered, but also when there was a loss of power to the machine or a reboot.
? Developed and designed a tool in Visual Basic 6 to be used internally to automate the lengthy manual process of generating the monthly tariff.
? Optimised and improved existing code and SQL stored procedures (using SQL profiler as much as possible), whilst fixing existing bugs within the time constraints.
? Worked closely with account managers, and wherever possible end users to try to establish and understand client requirements.
? Worked closely with QA and UAT teams to ensure good communication and quality for the solution.
? Worked under pressure with Database Administrators to resolve LIVE issues whenever necessary.
? Aided colleagues such as QA or helpdesk staff in investigations of LIVE issues, and worked hard to resolve issues as soon as possible, whilst maintaining the quality of the solutions.
? Constructively challenged or questioned the design of existing software whenever I could see potential improvements could be made to either optimise, or standardise the code.
? Designed databases, stored procedures and tables with a forward thinking approach, so that changing requirements can be accommodated with as little extra changes as possible, and that the solutions could be expanded or enhanced.
? Designed an XML based logging system, which then imports the data into SQL Server into well structured database tables, so that the data could be reported on based on changing requirements, ensuring that the design was flexible, yet optimal.
January 2005 – November 2006
Alphameric Hospitality Ltd. (www.alphameric.com), Godalming
Web Developer
? Developed new and fixed existing software for the Caterwide Stock System (www.caterwide.com) for large hospitality clients such as Spirit (over 2000 sites), Costa, Benjy’s Delivered, Benjy’s Retail, Tattershall Castle Group, The Restaurant Group, West Cornish Pasty Company, Laurel and Travel Inn.
? Analysed client requirements and created functional requirements documents.
? Implemented the new functionality, based on the requirements to the deadline, and fixed any bugs that came back from QA or UAT.
? Created and worked with SQL server stored procedures in multi-database (and server) replicated environments.
? Amended and created new xml, ASP.NET, and compiled programs, using C#.NET, VB.NET, JavaScript and Visual Basic.
September 2003 – January 2005
Alphameric Hospitality Ltd., Godalming
QA Analyst
? Verified that the Stock system (part of Caterwide) was working correctly, through QA testing.
? Wrote detailed test scripts and back-end SQL data verification scripts.
? Ran numerous updates to the Caterwide QA or UAT systems, both front end and back end, as well as applying replication. Restored some of the relevant live databases for QA purposes. Created business requirements documents.
? Created patch documents and organized the application and testing of patches to the live systems.
July 2003 – August 2003
Alphameric Hospitality Ltd., Godalming
Support Consultant
? Supported many large clients including; Costa Coffee, Yates Bros., Noble House, Deep Pan Pizza, O’Neil’s.
? Solved problems of business critical issues and supported the Alphameric touch screen till and PC software; InnTouch and InnMaster in various ways including remote support.
? Supported users of the web based ordering and stock control system; Caterwide.
July 2001 – August 2002
(Professional Placement – Associateship of University of Surrey - Distinction)
Versatile Mobile Systems Europe Ltd. (VMS), Woking
Support Consultant
? Supported clients using VMS software in handheld, wireless applications, such as Cadbury Ireland and Elizabeth Arden.
? Assisted in support management through the production of regular reports.
? Developed a web-based knowledge base to allow on-line support, using Visual Basic programming, HTML and Microsoft Access.
? Actively involved in the ongoing development and deployment of the support database, created new tables and forms to improve efficiency and remove redundancies.
? Managed and executed the training of my successors, which included the production of a training manual and training schedule.
? Recognised for good organisational and communication skills and the ability to use initiative.
Dear Sir/Madam,
As you can see from my CV, I have 7 years experience in software development and am currently working as a database administrator for a digital image processing company with such clients in the UK as Tesco, Asda and in North America Walmart, Costco and Sam's Club. I also have experience in the pharmaceutical and hospitality software industries. I am a 29yrs old British Male.
I am searching for an expatriate role in IT, management or any role so that we can work in Africa.
I would be available to come over to Africa again for interviews if needed. I am looking for a family contract. My wife is a Nigerian/British citizen and we have 2 Kids(Boys).
I would be most interested to hear what opportunities there are available for me at your company or if you could point me in the right direction that would be great.
I look forward to hearing from you soon,
Best Regards,
John
00447984072157
Angola
Living in Angola Guide
Angola Forum
Contribute
Best Places to Live in Angola
29 Expats Talk about Healthcare & Health Insurance in Angola
Pros & Cons of Living in Angola
