$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Management
Vitaly Kaganov
,
Borehamwood, United Kingdom
Experience
Other titles
Skills
I'm offering
Expert Analyst / Technical Lead specialising in system implementation projects, responsible for requirement analysis, business process design and configuration, data architecture and data management, including data migration. Proven record of successful system implementations in Telecoms, Utilities and HE sectors. Numerous full project lifecycles ranging from small upgrade projects to multi-national business transformation programs. Strong hands-on and problem solving skills. Passionate Web developer. Enhanced CRB checked.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - ?
job
Data Manager
Met Film School.
• Submission of statutory reports
• Design and preparation of internal reports
• Implementation of Student Records System
• Creation of workflows for automated reporting
• Design and preparation of internal reports
• Implementation of Student Records System
• Creation of workflows for automated reporting
Design, Implementation, Manager
2014 - 2018
job
System Architect
University of Westminster.
• Acted as Technical Authority on all integration projects - reviewed solutions for IT change
• Custodian of interfaces and data feeds - performed data collection and analysis from the beginning SQL Server
• Introduced Data governance and GDPR compliance process
• Maintained an overall view of Corporate systems architecture
• Developed strategy on Identity Management, Data Management and System Architecture
• Supported analytics team in building data warehouse and introducing QlikView as a corporate reporting tool
Key achievements:
• Documented and graphically represented Corporate systems architecture - main reference document now in existence
• Discovered and documented interfaces and data flows of the main Corporate systems (SITS -Student Records System, SAP HR, Agresso - Finance)
• Initiated GDPR project and acted as Technical Lead, analysed personal data held in the University systems and assessed compliance, conveyed status and insights to relevant stakeholders
• Created Data Strategy document for the Senior Management
• Custodian of interfaces and data feeds - performed data collection and analysis from the beginning SQL Server
• Introduced Data governance and GDPR compliance process
• Maintained an overall view of Corporate systems architecture
• Developed strategy on Identity Management, Data Management and System Architecture
• Supported analytics team in building data warehouse and introducing QlikView as a corporate reporting tool
Key achievements:
• Documented and graphically represented Corporate systems architecture - main reference document now in existence
• Discovered and documented interfaces and data flows of the main Corporate systems (SITS -Student Records System, SAP HR, Agresso - Finance)
• Initiated GDPR project and acted as Technical Lead, analysed personal data held in the University systems and assessed compliance, conveyed status and insights to relevant stakeholders
• Created Data Strategy document for the Senior Management
Integration, Tech lead, Server, Data collection, It, Architecture, Compliance, Finance, Analytics, Sql, Management, GDPR Compliance, GDpr, Data management, Data Warehouse, SAP, SQL Server
2013 - 2013
job
Data Manager
Sky IQ.
• Collated data for channel mapping from multiple sources
• Maintained reference data for different Customer insight projects
• Provided data releases and reports to Corporate BI team for Customer 360 view
Key achievements:
• Identified and performed large-scale data cleansing (Sybase/T-SQL)
• Developed an algorithm for automated data merging with ~90% success rate
• Rationalised and documented the channel mapping process and trained remaining staff
• Maintained reference data for different Customer insight projects
• Provided data releases and reports to Corporate BI team for Customer 360 view
Key achievements:
• Identified and performed large-scale data cleansing (Sybase/T-SQL)
• Developed an algorithm for automated data merging with ~90% success rate
• Rationalised and documented the channel mapping process and trained remaining staff
Sql, T-SQL, BEE, Sybase, Manager
2013 - 2013
job
Solution Designer
Sainsbury's.
Customer Data Anonymisation project - compliance with Data Protection Act, PCI DSS and EU regulations. Project was suspended.
• Participated in vendor selection (Commercial tool vs. ETL scripts)
• Identified data masking rules to create realistic test data
Key achievements:
• Analysed how the available solutions satisfied the requirements
• Participated in vendor selection (Commercial tool vs. ETL scripts)
• Identified data masking rules to create realistic test data
Key achievements:
• Analysed how the available solutions satisfied the requirements
ETL, Test, Compliance
2012 - 2012
job
System Analyst
TSL Education.
• Managed a small invoice consolidation project using MSL Ordering system
• Responsible for requirements and configuration analysis, creation of test cases, managing software deliveries and supervision of UAT in a very tight timescale
Key achievements:
• Learned Ordering system functionality in detail within a very short period
• Covered different VAT rules and various discounts, rewards and surcharges in a very complex testing environment
• Validated new invoice extract against the requirements and liaised with vendor and finance team on all issues until resolution
• Responsible for requirements and configuration analysis, creation of test cases, managing software deliveries and supervision of UAT in a very tight timescale
Key achievements:
• Learned Ordering system functionality in detail within a very short period
• Covered different VAT rules and various discounts, rewards and surcharges in a very complex testing environment
• Validated new invoice extract against the requirements and liaised with vendor and finance team on all issues until resolution
Test, Finance, Analyst, Testing, Supervision, Software, Detail
2012 - 2012
job
Senior Data Analyst
Universal Music.
Work with an IT support team on a migration project (from multiple sources to Neolane/Adobe CRM) in B2C department
• Documented custom developed BI Applications and Dashboards
• Reconciled customer and marketing data between old and new system
• Validated workflow of marketing communications
Key achievements:
• Performed data extracts and loads, reconciliation of manual and automated ETL processes, analysed the differences, produced custom reports
• Created test cases and data mapping for manual customer loads
• Developed processes for comprehensive reconciliation of large files in Excel and SQL Server and handed them over to the team
• Documented custom developed BI Applications and Dashboards
• Reconciled customer and marketing data between old and new system
• Validated workflow of marketing communications
Key achievements:
• Performed data extracts and loads, reconciliation of manual and automated ETL processes, analysed the differences, produced custom reports
• Created test cases and data mapping for manual customer loads
• Developed processes for comprehensive reconciliation of large files in Excel and SQL Server and handed them over to the team
Test, Processes, Server, BEE, Adobe, Workflow, Analyst, Support, It, Marketing, ETL, B2C, CRM, It support, SQL Server, Excel, Sql
2011 - 2012
job
Data Migration Expert
Huawei.
Migration from EPlus legacy systems to Huawei CRM and Billing
• Led workshops with SMEs to understand the current functionality and to produce field mapping
• Led analysis of Migration and Decommissioning strategy
• Reviewed all vendor design documents before delivery to the client for sign-off
• Managed business requirements gathering and Gap analysis
Key achievements:
• Identified data in scope for migration and the required target tables in CRM and Billing Systems and SAP
• Developed field mapping and ETL strategy Oracle/SQL
• Developed Cutover/Decommissioning strategy for legacy systems
• Led workshops with SMEs to understand the current functionality and to produce field mapping
• Led analysis of Migration and Decommissioning strategy
• Reviewed all vendor design documents before delivery to the client for sign-off
• Managed business requirements gathering and Gap analysis
Key achievements:
• Identified data in scope for migration and the required target tables in CRM and Billing Systems and SAP
• Developed field mapping and ETL strategy Oracle/SQL
• Developed Cutover/Decommissioning strategy for legacy systems
Design, Sql, CRM, Oracle, SAP, ETL, Workshops, LED
2010 - 2011
job
Data Quality Manager
Cable and Wireless.
• Responsible for Quality Assurance and Gap analysis during migration of customer accounts from Oracle BRM to Arbor and SSBS
• Took part in the design and testing of in-house ETL tools and ETL rules
• Managed off-shore teams providing data extracts and data loads from Mainframe
Key achievements:
• Developed a product report (PL/SQL) that validated product mapping from source to target and quantified revenue loss after each transform
• Identified quality criteria, defined KPIs and created quality controls and sanity checks
• Took part in the design and testing of in-house ETL tools and ETL rules
• Managed off-shore teams providing data extracts and data loads from Mainframe
Key achievements:
• Developed a product report (PL/SQL) that validated product mapping from source to target and quantified revenue loss after each transform
• Identified quality criteria, defined KPIs and created quality controls and sanity checks
Design, Sql, Oracle, ETL, Pl/sql, Data quality, Mainframe, Quality Assurance, Testing, Off-shore, Manager
2009 - 2010
job
Data Migration Lead
KPN.
• Ensured migration of all customer accounts (ca.3M) from legacy systems to BSCS billing system, CRM and SAP GL (for Loyalty rewards)
• Monitored the ETL process for compliance with the SLA and SOW
• Responsible for Data Quality assurance
• Reviewed Data mapping and Data flows Oracle, DB2
• Acted as a main point of contact for finance, business and third-parties
• Translated business needs into technical solutions
Key achievements:
• Created a control framework for migration validation and reconciliation and provided approval for loading into the target systems after each transform
• Delivered High Level Test Scenarios and test scripts for Customer Journey
• Created and maintained the Business Rules document and monitored adherence
• Planned and performed Bill comparison with business and vendors using the existing SAP report and vendor delivered reports
• Monitored the ETL process for compliance with the SLA and SOW
• Responsible for Data Quality assurance
• Reviewed Data mapping and Data flows Oracle, DB2
• Acted as a main point of contact for finance, business and third-parties
• Translated business needs into technical solutions
Key achievements:
• Created a control framework for migration validation and reconciliation and provided approval for loading into the target systems after each transform
• Delivered High Level Test Scenarios and test scripts for Customer Journey
• Created and maintained the Business Rules document and monitored adherence
• Planned and performed Bill comparison with business and vendors using the existing SAP report and vendor delivered reports
CRM, Oracle, SAP, ETL, DB2, Test, Finance, Compliance, Data quality, Quality Assurance, Framework
2007 - 2009
freelance
Senior Consultant
Cartesian.
(Multiple projects - consulting)
• Virgin Media - migration of mediation system and consolidation of billing systems. Wrote functional and test specifications, created test scripts and performed tests on live CDRs. Performed data analysis and reconciliation
• O2 - Revenue Assurance project: reconciliation between different billing/provisioning systems (ABS, DISE, GPRS), design, coding, reporting and analysis of the differences. Data analysis to identify and quantify revenue loss. Managed development team
• T-Mobile - development, testing and documenting of Usage Monitor, optimisation of queries and post-production support. Resolved database locks from previous design. Modified BI reports and re-designed data feeds
Key achievements:
• Created multiple scripts (PL/SQL) to implement complex business requirements
• Produced documentation for Test Scenarios and Functional Design for multiple projects
• Virgin Media - migration of mediation system and consolidation of billing systems. Wrote functional and test specifications, created test scripts and performed tests on live CDRs. Performed data analysis and reconciliation
• O2 - Revenue Assurance project: reconciliation between different billing/provisioning systems (ABS, DISE, GPRS), design, coding, reporting and analysis of the differences. Data analysis to identify and quantify revenue loss. Managed development team
• T-Mobile - development, testing and documenting of Usage Monitor, optimisation of queries and post-production support. Resolved database locks from previous design. Modified BI reports and re-designed data feeds
Key achievements:
• Created multiple scripts (PL/SQL) to implement complex business requirements
• Produced documentation for Test Scenarios and Functional Design for multiple projects
Design, Sql, Data Analysis, Database, Consulting, Pl/sql, Test, Optimization, Support, Testing, Development, BEE, Production
2006 - 2007
job
UK technical lead in the International project
T-Mobile.
ee.co.uk 8/2006-5/2007
Technical Design Authority
• Data Change Authority - reviewed and signed off all high level and detailed designs for Product, Reference and Rating data changes Oracle/SQL
• Maintained SAP GL interface with rating and billing systems, develop consistent mapping rules
• UK technical lead in the International project of Amdocs Enterprise Product Catalogue 7 implementation across T-Mobile group
• Managed technical teams and vendors
Key achievements:
• Reviewed all vendor's design documents, analysed business processes (AS IS and TO BE) and data, created PID, Deployment plan and Roadmaps
• Validated feasibility and test requirements for all new products and product changes before implementation and compliance with eTOM and ISO 9001
Technical Design Authority
• Data Change Authority - reviewed and signed off all high level and detailed designs for Product, Reference and Rating data changes Oracle/SQL
• Maintained SAP GL interface with rating and billing systems, develop consistent mapping rules
• UK technical lead in the International project of Amdocs Enterprise Product Catalogue 7 implementation across T-Mobile group
• Managed technical teams and vendors
Key achievements:
• Reviewed all vendor's design documents, analysed business processes (AS IS and TO BE) and data, created PID, Deployment plan and Roadmaps
• Validated feasibility and test requirements for all new products and product changes before implementation and compliance with eTOM and ISO 9001
Design, Sql, Oracle, SAP, Deployment, Test, Compliance, Implementation, International, Enterprise, Tech lead, Processes
My education
Technical University
Masters, Information Technology
Masters, Information Technology
Vitaly's reviews
Vitaly has not received any reviews on Worksome.
Contact Vitaly Kaganov
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Vitaly directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark