EXPERIENCE:

Confidential

Variety of client-oriented projects. Migration of applications EUCs, EUAs from MS Office 2003 to MS Office 2010 for multiple clients. Extensive reverse engineering to determine original mathematical calculations and program logic. Advanced MS Office Visual Basic for Applications VBA . Windows API function calls. Liaison with client's subject matter experts SME and IT department requirements gathering documentation reverse engineering user training user acceptance testing. MS Excel 2010 32-bit and 64-bit including compatibility with Excel 2007 and Excel 2003, and across MS operating systems MS Windows 7 32-bit and 64-bit , MS Windows Vista, MS Windows XP. Office 365 for Midsize Business includes SharePoint . MS SQL Server 2008 R2.

Confidential

LBG Commercial Banking. Specialist VBA developer. Use of MS Access 2003 / 2007 and MS Excel 2003 / 2007 for End User Computing EUC system. Project 1: To re-design, build and extend a scorecard reporting process originally developed outside of business unit. Extensive VBA for import of data metrics from multiple sources scoring and ranking of sales performance at various levels in business hierarchy and for tabular display of monthly sales reports. Performance data extracted from Teradata data warehouse and other internal business units. Project 2: To design and build a multi-user MS Access database to track and re-verify customer signature mandates. MS Access back-end database with MS Access front-end database / application for user account search and data entry.

Confidential

Specialist VBA developer, CMHL Spreadsheet Remediation Project. Urgent project to implement and deploy strong environmental controls over critical Finance Accounting Actuarial Excel spreadsheets. Remediation of existing inventory of Excel spreadsheets to embed standardised audit / compliance controls using a mix of advanced Excel and VBA skills / tools. Deliver VBA coding and spreadsheet changes for Excel spreadsheets being brought into the controlled environment ensuring that changes made are compliant with standards set and adhere to best practice. Reverse engineer and analyse complex spreadsheet models and financial forecasts. Liaise with business owners and subject matter experts SME to ensure successful user testing and sign-off of remediated workbooks.

Confidential

Software house. Specialist developer to re-engineer and repackage a client's in-house developed MIS legacy application which the client now intends to also sell commercially as a shrink-wrapped product. Analyse client requirements, produce technical specifications support user acceptance testing draft user guide user training. Extensive reverse engineering and documentation to determine original program logic and computations. Advanced MS Office Visual Basic for Applications VBA . Construction of test data sets. Balanced scorecards, dashboards, KPIs, charting, RAG and trend analysis, pivot tables. MS Excel 2003 front-end. Dynamic linking to MS Project, XML manipulation, migration to Excel 2007, Office 2007 custom ribbons and toolbars, etc.

Confidential

Eastleigh, Southampton. Specialist developer and technical analyst. Short-notice priority functional enhancements to two legacy applications to support new health product launch. a multi-user 2-tier desktop client application accessing remote Oracle database. b multi-user 3-tier application comprising client web browser a host IIS web server with a VB web class accessing a remote Oracle database. Multiple VB6 project files, multiple component DLLs. MS Visual Basic v6.0 VB6 , MS Internet Information Services v5, MS Transaction Server MTS , Oracle Client v8.06, Quest Toad v9.6 Toad for Oracle . Identify, ring-fence and assemble source code and ancillary files documentation, batch files, registry files, Word report templates, HTM and ASP pages, SQL script files .

Confidential

Software house. Specialist developer to deliver enhancements to an existing client application. Analysing client business requirements using MS Access front-end with MS SQL Server 2005 back-end database. Producing technical specifications developing a suite of management information reporting tools documentation training support to testing. MS SQL Server 2005 database. MS SQL Server Reporting Services 2005 SSRS . Complex SQL Server stored procedures, etc. SQL Server Management Studio SSMS , etc. Windows permissions, policies, etc. Additional data analysis using Visual Basic for Applications VBA with MS Access 2003. Includes some web reports ASP.Net WebForms .

Confidential

Central London and Horsham. Group Corporate Centre. Specialist developer and technical data analyst. Migration of monthly executive reporting to new platform. Project covered analysis and support of the then existing Group reporting processes based on receiving monthly inputs from regions using a large suite of VB6 and MS Excel 2003 front-end applications, email attachments, and several SQL Server databases defining the new data structures and business processes to be used in IBM Cognos 8 Controller specification writing migration of historical data into IBM Cognos 8 Controller data cleansing, extraction, transformation, loading and validation foreign exchange currency conversions currency restatements system testing user acceptance testing.

Confidential

Software house. Specialist developer to deliver enhancements to existing client applications. Similar role to entry listed above

Confidential

Lift-out of Investment Operations Services IOS outsourced by Threadneedle Asset Management TAM to JPMorgan JPM . Project covered transfer of all business processes from TAM to JPM involving transferring all IT applications and activities from TAM platform to different JPM platform. Included several dress rehearsals as actual full migration needed to occur within a single weekend. Expert MS Office VBA developer and technical integrator. Job title was business analyst but actual role included the VBA macro remediation / conversion of all TAM End User Computing EUC applications comprising 600 complex MS Excel 2003 workbooks, MS Word documents, MS Access databases and SQL Server ODBC DSNs to work with new directory / file naming structure.

Confidential

HR Technology. Pay and Bonus Review 2007 Project. This is the annual review of salary and awards for 60,000 employees. Technical specialist within dedicated project team managing the recommending and data collection process. Server side SQL Server 2000 database. Advanced client side Excel VBA. Analysing business requirements. Updating and upgrading existing program suite to incorporate new reward schemes and rule-based recommending guidelines. Identifying and resolving logical errors. System testing. Implementing technical standards. Ensuring program compatibility across multiple desktop / laptop Windows operating systems and installed Excel versions viz Windows NT, Windows 98 thro Windows XP Excel 97 thro Excel 2000 . High data security environment.

Confidential

Special project using VB6 / MS Office 97 / MS SQL Server 2000 / NT4 Server and other packages / tools. To understand, document and potentially support a large existing 24/7 application used in warehouse depots throughout the UK. Mainly Access 97 front-end with SQL Server and Access 97 back-end databases. Extensive Access VBA and VB6. Multiple sites, multiple servers, multiple clients. Data replicated and aggregated nationally to provide single point-of-view while allowing autonomous depot fallback. Application comprises multiple modules to plan, pick, schedule, route and deliver all orders to the group's retail stores.

Confidential

Specialist report developer / writer. Urgent project to fix and enhance an in-house management training information system. Central MS SQL Server database with multiple users running a MS Access 2003 front-end application. Multiple users at different geographical locations for entering / updating data and for printing / exporting reports. Large number of analysis reports. High value application used for course booking, calendar and venue scheduling, joining notifications, tutor registers and staff feedback analysis accounts billing, invoicing, payment reconciliation and system auditing personnel training requirements and qualifications tracking. Multiple MS Access user forms with extensive reporting.

Confidential

Pay and Bonus Review 2006 Project. Similar role to entry listed above .