My job title was renamed in order to better reflect my role at Athora.

Senior Data Engineer using AWS Cloud stack(Organisation changed from Aegon to Athora in July 2018)Major themes: Financial environment. AWS Cloud Architect with Python, Azure Function Apps, Database Design, PowerBI Report Development, Agile Scrum. Responsibilities: Build and maintain AWS Cloud Infrastructure with Python/Pyspark, build and maintain databases, build and maintain Azure Function Apps, maintain legacy systems, assist with release cycle, automate recurring tasks. Design and create data flows and processing systems using AWS Cloud.Consult on technical issues. Identify and tackle technical debt. Suggest design changes, contribute to their implementation. Peer review other team members' work.Technologies: AWS CloudFormation stacks, Lambda with Python and Glue with Pyspark. Decouple workflows with State Machines and SQS. Redshift for big data. RDS instances for archiving.Pycharm, VSCode, SQL (AWS Athena, T-SQL, Informix), Bitbucket (source repositories, pull requests), Confluence (wiki), Jira (work tracking), Sharepoint (doc storage and wiki).In the past I have used Eclipse (Java), JBoss (Java servers), SoapUI, Ecrion (Document templates), Subversion (Source control), Fisheye and Crucible (Code review), Bamboo (Building code), Nexus (Build repository), Ant and Maven (Releasing code), Spring, Hibernate, JAXB, JUnit, Mockito.My day to day work involves, working within an Agile methodology:- Work with business teams to devise task specs - Grooming of user stories for sprint planning: Definition, sizing, and breakdown of tasks- Design the architecture of the solution collaboratively- Implementation: deliver new functionality iteratively. Apply best coding practice to new code, overhaul technical debt- Wiki articles for users and support personnel, demo to QA and business stakeholders- Release code to test environments; prepare release to live for handover to release team- Assist test effort by guiding design of tests (system and UAT)

Major themes: Financial environment. Database Design, ETL (Extract Transform Load), Report Development. Responsibilities: DB architecture, creation of ETLs gathering data from a variety of sources (local and remote machines, Excel, large amounts of XML), dealing with fuzzy matching, sync between staging and warehousing levels, automation of monthly refreshes, control and business reporting. Actively optimise efficiency of DBs and reduce load times. Consult on technical issues. Bring new design ideas up at design meetings, contribute to their implementation. Code review other team members' work.Technologies: SQL (T-SQL, Informix), SQL Server Management Studio/Server Studio, SQL Server Reporting Services (SSRS)/Report Builder, SQL Server Integration Services (SSIS/ETL), Eclipse (Java), Visual Studio (C#), SoapUI, Sharepoint and Confluence (wiki and doc storage), Subversion (Source control), Fisheye and Crucible (Code review), Jira (work tracking), Ant and Maven (Releasing code)Working within an Agile methodology:- Work with business teams to devise reporting specs - Grooming of user stories for sprint planning: Definition, sizing, and breakdown of tasks- Implementation: new functionality must be delivered within tight deadlines. Apply best coding practice to new code, overhaul legacy code- Documentation, wiki, demo to QA and business stakeholders- Release code to test environments; occasionally assist with release to live- Assist test effort by guiding design of tests (system and UAT)

Poker gaming website. BI Report development through full lifecycle: scoping, often with mockup in Excel; definition of structures and integration into the universe; development and testing using Business Objects and/or SSRS; deployment and scheduling of job; further extensions as required. - Evangelised SSRS and created showcase demos. - Used SSIS Integration Services packages to automate data transfers and to integrate data from Excel data sources, with scripting in C#. - Maintenance of objects in the Business Objects Universe and the reporting portal.- Exposed to payments processing industry and methods for detecting fraudulent activity.- Assisted in setting up data and jobs for QA (test) server rack. Tools used: SQL Server 2008; Visual Studio 2008; Business Objects IX (Crystal Reports); Business Objects Universe; SQL Server Reporting Services (SSRS); Excel; Accurev Source Control.

(Client: Microsoft; Employer: Accenture)Prepared reporting solutions for managerial clients across the department. Evaluated client needs, sourced data, devised KPIs and built out the reporting solution. Responsibility for refresh of daily customer-focussed reports, which were automated as much as possible using SQL Server Integration Services (SSIS). Solutions were proactively upgraded as new technologies become available. Technologies used : - T-SQL and MDX- SQL Server Management Studio- OLAP data sources- SQL Server Reporting Services/Analysis Services/Integration Services- Excel 2003/2007/2010 pivots- MS Access- VB Macros- Source control: Visual Source Safe and Team Foundation Server

Software test for internal apps and web portals. Completion of test case scenarios. Bug logging, adhoc testing, regression testing.

Short term contract to rebuild scripted software installations of varying difficulty, many of which had to be reconstructed from scratch. Liased directly with QA. There was a mixture of conventional setups and MSI (Winstall) setups.Skills gained: Further experience of software installs, experience with the Mac OS X user interface, burning hybrid CDs, and managing my own project schedule.

Encryption products for the ISDN and satellite phone market. A multi-role position, but largely software engineering. In charge of preparing product releases for market - install program and master CD. Covered 5 or more installs at the same time. Migrated legacy setups to the new MSI (Winstall) technology. Responsibilities:- Build engineer working on product install programs- Software engineer working on VC++ applications- Network and email adminTools used: Installshield, VC++, Visual Source Safe

Internet Videos and social media.Responsible for all PC and web development matters:- Graphical manipulation, using Macromedia Fireworks and Adobe Photoshop, - Flash animations, using Macromedia Flash and my own design knowledge, - Web development, using Macromedia Dreamweaver, - Web scripting in Perl, - General Admin: Re-installing and configuring operating systems, programs, and hardware, - Tech support, both for staff (locally and remotely), and customers, - Customer etiquette, when dealing with complaints and/or inappropriate requests, - Documentation, such as franchise or internal manuals explaining technical processes to non-computer literate staff. Through suggestions and input, I continuously attempted to expand this range of skills.