Billing Customer classification (R, SQL, Tableau, git) * The goal of the project was to find billing event patterns and identify the adverse ones that would provide the senior management with the areas to improve the efficiency of the billing process * Time series analysis of billing and meter read events * Time series clustering and billing classification * Dimension reduction * Presentations in form of Tableau visualisation to various audiences: data scientists, business users, managers. Debt Collection efficiency (R, SQL, Tableau, git) * Identification of debt flows and inefficiencies * Test the hypothesis that some geographical areas have higher risk of debt * Provide data for bad debt provisioning * Presentations in form of Tableau visualisation to various audiences: data scientists, business users, managers.
Chief Underwriter OfficeSeptember 2016 - June 2018
Expense MI dashboard * Expense data insights dashboard created in QlikSense for the use of Budget Owners and Exco * The project was run in RAD/Agile manner, with iterative approach and weekly presentations of progress and design workshops with senior stakeholders and end users * Closely cooperated with FP&A team with regards to data provision and data quality (SQL Server, SSAS, SQL Server Management studio, transact-SQL) * Data analysis for Phase 2: Headcount * My personal success was to gain the credibility and establish good working relationship with the senior and demanding stakeholders * The overall success of the project put the team on the map as it was delivered quickly and outside of IT Designed the Index of Client Goodness for Client Engagement team (Multinational clients) * The goal was to find customers that have potential for growth using client segmentation output and historical data * Exploratory data analysis required querying large data sets (SQL, Netezza) and identifying factors that are relevant in Good Client definition (GWP, GLI, Sales amount etc) * Data quality validation and liaising with IT to implement changes * POC implemented in R * Data insights presented in non technical manner to the client engagement team (visualisations in R) * Technologies used: R, Excel, SQL Improvement of efficiency by automation of Claim Root Cause analysis * Developed a program in Python (NLP, nltk) to automate qualitative claim root causes analysis that had been done manually in Excel which decreased processing time * This allowed to expand the analysis to cover larger lines of business Data analyst on Multinational reporting project * Analysing data sources and quality for Multinational policy data (SQL) * In depth policy data analysis per region or country - different rules apply to different regions * Developed a prototype for Multinational local policy mapping with AIG financial systems * Designed ETL solution to on board Multinational policy data into Commercial Data Hub * Test cases and automated testing of the ETL * The challenge on this project was to find and get information - my ability to communicate efficiently and build good working relationships contributed to success Data analyst on Pricing project * Data provision for Pricing Actuaries * Data sources identification, data validation and reconciliation using SAS, SQL and Excel * Development of data processing framework (Netezza) * Close cooperation with the Pricing team in New York * Gained high level of understanding of Pricing models
Various projects for Data Management, Regulatory Reporting, Fixed Income, Corporate Data Warehouse
Data Analyst/Business Analyst on Corporate Datawarehouse project * My understanding of Financial Products and in-house systems allowed me to progress to data analyst role from senior developer * Worked on data provision for Front Office reporting * Analysed data quality and designed ETL process for historical positions for Fixed Income reporting * Worked closely with Integration team to ensure timely delivery by providing requirements and validating data * Technologies used: SQL, Excel Analyst/Designer/Lead Developer on EU Transparency and Significant Shareholders Disclosures regulatory project * Remapped and redesigned the Significant Shareholders process - it decreased the run time, allowed contingency time for report delivery (processing time improvement from 4 hours to 15 minutes) and improved efficiency * My personal achievement was to get the `buy in' and the approval of the process redesign of the Head of Significant Shareholders Disclosures and the Project Manager (risks versus gains) * Lead a team of 2 developers to deliver the project * Worked closely with the Head of Significant Shareholders Disclosures and the Lead Business Analyst to ensure data provision and data quality to meet the regulatory requirements * Technologies used: SQL, Excel, Oracle reports Analyst/designer/developer on Solvency II Pillar 3 project * Data provision to Prudential Group Analyst/designer and developer on the FFX Rates project - automation of FFX Rates feed from Markit. * The project provided a significant process improvement for the Data Management Team where manual tasks have been automated * The project required 3rd party vendor management * Technologies used: SQL, XML Each project gave me the opportunity to work closely with the business, establish credibility and maintain excellent working relationship Working closely with the business provided me with an excellent opportunity to gain financial knowledge and understand financial data
* Worked on several projects: Futures, Loans, Ulster integration, ABN Amro integration. * Firstly joined Futures project to meet timelines of PnL reporting which involved steep learning curve and working to tight timelines. * Development of reports for Finance and Accountants * Development of multiple financial reconciliations, mainly for Product Controllers, close co-operation with the business users, gained understanding of financial products * Performance tuning * Technologies: Oracle 10g/9i, SQL, PL/SQL, XML, XSLT, Oracle Warehouse Builder 10.2, data modelling, performance tuning, Oracle Reports, Oracle Warehouse Builder 10.2, Oracle Financial, Sybase, t-SQL, Autosys, JIL, Discoverer, Java
* Development and support of WallStreet Systems ORD v.3.4 database - MIS system for FX/MM (Oracle 10g, XML, Java). * Analysis, design and development of enhancements to SAMM (Settlement Accounting system; Oracle, Unix shell scripts, Autosys, dbms jobs) - new archiving solution, performance tuning, several enhancements for accounting messages processing * Release manager of production changes on WallStreet ORD database and XML interfaces to downstream systems * Simple DBA tasks for test and development database environments * Mentoring and supervising junior developers * Overnight and weekend system support (on-call - 3rd line)
* Analysing of customisations and enhancements to Swift: evaluate design, provide estimates and recommend and implement solutions as needed (Oracle 9i/10g, PL/SQL, Forms 6i/10g, Reports 6i/10g, JavaBeans, Designer 6i/10g, Solaris, Oracle XDK, XML, XSD) * Development of OLTP systems * Lead developer in integration project with Capita for education -EMS (Oracle 9i, PL/SQL, Oracle XDK, XML, Forms 6i, Designer 6i, XMLSpy, exposure to XSD, web services and WSDL, Fiorano) * Developer in integration project with Atos Origin for Scottish Executive - eCare phase I (Oracle 9i, PL/SQL, Oracle XDK, XML, Forms 6i, Designer 6i, XMLSpy, exposure to XSD, web services and WSDL, Fiorano, MS SQL) * Research and pilot of a solution to improve performance of Integrated Children Solution (Java, JDBC, Oracle XDK for JAVA, SAX, object types; exposure to EJB 3.0, JBOSS, Ebase Eforms) * Installation and configuration of Multi Agency Store (MS SQL server, IIS) * Migration of Core APIs from Oracle 9i to 10g (Oracle XDK, PL/SQL)
Full Development life cycle experience in terms of clients’ needs assessments, Database design, Application development, Performance Tuning and Enhancements. Work with data warehouses Work with star schemas, facts and dimension tables, knowledge of data partitioning and de-normalising tables for specialised data marts Design and development of Operational Data Store and data warehouse (Sysdate 11,12, Oracle 9i, Unix scripts, t-SQL, performance tuning)
* Development and support of Finance aspects of IFS system, exposure to Distribution and Production aspects (Oracle 7, Oracle 8, PL/SQL, Centura, Gupta, Crystal Reports, Forms 3.0, Reports 3.0, Pro*C)
SAX, Oracle Forms, JDBC
Analysis methods and tools
Oracle Pro-C, SQL Server Analysis Services, Enterprise Java Beans, Rapid Application Development RAD, Business Analyst, Lead developer, Data Analyst, Designer, Developer, English, Oracle Discoverer 2000, Database Designer, Senior Oracle Developer, the Lead Business Analyst, business Data analyst, Analyst/Visualisation in Data Science team, Forms 9i, RAD methodology, Oracle XDK, JIL, Investment Management, FX/MM Operations, Microsoft Transact-SQL, Oracle Designer 2000, BI DEVELOPER, Data Modelling, Systems developer, Data Engineer, Software Consultant, Oracle Report, Management Information System, tableau, Systems Analyst, Automatic Testing, SQLBase for Windows, Application development, Altova > Altova XMLSpy, Data management, Data Warehousing, Polish, Front Office, Microsoft Internet Information Server
Talent sourcing specialist de la plateforme Pentalog, SkillValue s’appuie sur un pool de +400 000 Experts Tech & Marketing, dont +15 000 freelancers. Évaluations de compétences, missions, offres d’emploi : les consultants SkillValue vous aident à accélérer votre carrière.
Restez informé de l'actualité tech avec la newsletter Pentalog
À propos de Pentalog
Pentalog est une plateforme de services IT qui accompagne les entreprises dans leur production digitale et leur transformation en fournissant des ingénieurs et développeurs de classe mondiale. Ses 16 Delivery Centers et Agences dans le monde comptent plus de 1600 ingénieurs, développeurs, product designers et spécialistes marketing.