09/06/2022 updated


100 % available
Database Developer, Demand Analyst, MIS Reporter
Lagos, Portugal
Portugal
Microsoft AccessASP.NETMicrosoft ExcelMicrosoft WindowsData AnalysisAtlassian ConfluenceAtlassian JiraCustomer Relationship ManagementMicrosoft OutlookComputer ProgrammingData ProcessingDatabasesData CollectionData EntryExtract Transform Load (ETL)
Microsoft Excel, Microsoft Access, SQL, MS SQL Server, SSIS, SSRS, PostgreSQL, VSQL, MS Access, XML, Linux, Remote Desktop, Visual Basic 6, MS Visual Basic, VBA, JIRA, Confluence, Slack, FogBugz, MS Excel, MS Windows, MS Office, Outlook, IE, CRM, database, Visual Source Safe code management and version control, ASP.NET 2.0, code behind, data driven websites, VB.NET, debugging, SQL Server, data processing, analytics, query optimization, ICCube systems, ETL, Oracle Discoverer, Excel, Access, APO, SQL Server 2005, T-SQL, MS SQL Server databases, VB6, Database migration, VB6 and SQL, Data Analysis, SPSS, Raiser's Edge database, data capture, Data Protection, o/s, data entry, programming, relational database, Filemaker, CCD
Experience
Professional experience10+ years
Project history
* Building, debugging, optimizing SQL Server data processing functionality of a proprietary market
leading, internet marketing and attribution, data analytics platform. This included a fair amount
of query optimization and occasionally working with Linux, PostgreSQL, VSQL and ICCube systems.
* Scoping and developing complex ETL pipelines to import datasets for small, medium and large
national and international clients. These could be online and offline sales data or various
customer touchpoints, in order to further enrich marketing and attribution analyses and
reporting.
* Building new business critical SQL based processes . Eg. A novel automation process which
increased reporting capacity dramatically - a necessity prior to the sun-setting of our data
platform which ensured all clients were satisfied at this difficult time. They all received the
necessary historic reports prior to termination of service, despite this requiring a reporting
capacity and capability previously unavailable.
leading, internet marketing and attribution, data analytics platform. This included a fair amount
of query optimization and occasionally working with Linux, PostgreSQL, VSQL and ICCube systems.
* Scoping and developing complex ETL pipelines to import datasets for small, medium and large
national and international clients. These could be online and offline sales data or various
customer touchpoints, in order to further enrich marketing and attribution analyses and
reporting.
* Building new business critical SQL based processes . Eg. A novel automation process which
increased reporting capacity dramatically - a necessity prior to the sun-setting of our data
platform which ensured all clients were satisfied at this difficult time. They all received the
necessary historic reports prior to termination of service, despite this requiring a reporting
capacity and capability previously unavailable.
* Fully optimized regular KPI reporting using Oracle Discoverer, Excel, Access and the SO99+ APO.
* Initiating and developing promotion uplift analysis systems enabling supply chain optimization
in order to attain acceptable 98% Service Levels.
* Rationalizing and structuring large and diverse data and information systems enabling effective
use and analysis.
* Development of analysis and reporting solutions working across MS Access, MS Excel (including
effective use of VBA in both) and SQL Server 2005.
* Initiating and developing promotion uplift analysis systems enabling supply chain optimization
in order to attain acceptable 98% Service Levels.
* Rationalizing and structuring large and diverse data and information systems enabling effective
use and analysis.
* Development of analysis and reporting solutions working across MS Access, MS Excel (including
effective use of VBA in both) and SQL Server 2005.
* Live maintenance and development of new functionality for Estate Agency Database and Accounting
Applications (in VB6 and SQL).
* Database migration from numerous database formats to CFP data formats, liaising with clients
when necessary.
* Creating bespoke 'debug' applications to identify and fix database inconsistencies (in VB6 and
SQL).
Applications (in VB6 and SQL).
* Database migration from numerous database formats to CFP data formats, liaising with clients
when necessary.
* Creating bespoke 'debug' applications to identify and fix database inconsistencies (in VB6 and
SQL).