$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Khammer Mohamed
,
, United Kingdom
Experience
Other titles
Skills
I'm offering
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
My experience
2019 - ?
job
Business Data Analyst/ Data Visualisation Developer
Siemens.
Description:
• Siemens proprietary automated system PCS7(Process Control System) is being used in the Production line of Food manufacturing companies such as Pladis, McVities Godiva & Ulker.
• The PCS7 works based on the process workflows and would capture the production line data, logs and other important details in MS SQL Server database.
Responsibilities:
• As a Data Visualisation Developer, the primary responsibility is to understand the business data and develop the reports based on the User Requirement Specification (URS) using SSRS.
• The different types of reports developed were simple, drill down, linked, paginated, charts and graphs.
• Working closely with the MES (Manufacturing Execution System) experts & Automation team on day to day basis to baseline the reports.
• As a Data analyst, one of the primary responsibilities was to deep dive and understand the production data that was hosted on Microsoft Azure (captured in UAMI, UAPI and HistorianDB) based on the scenarios of Recipes, Batches produced, Good Intake, Silos information, Siros details, Genealogy & Traceability, Right First Time information etc.
• Understanding the analytical aspects of Recipe based on Mean, Median, Mode, Std Dev, Distribution Curves & SPC values.
• Link them back to the Visualisation reports for interpretation and readability.
• Setting up and maintaining the Reporting services in the Dev environment. Deployment of the reports to the Dev env for CICD (Continuous Integration and Continuous Deployment)
• Housekeeping and archiving the Production data in Dev env to maintain Integrity and efficiency.
• Siemens proprietary automated system PCS7(Process Control System) is being used in the Production line of Food manufacturing companies such as Pladis, McVities Godiva & Ulker.
• The PCS7 works based on the process workflows and would capture the production line data, logs and other important details in MS SQL Server database.
Responsibilities:
• As a Data Visualisation Developer, the primary responsibility is to understand the business data and develop the reports based on the User Requirement Specification (URS) using SSRS.
• The different types of reports developed were simple, drill down, linked, paginated, charts and graphs.
• Working closely with the MES (Manufacturing Execution System) experts & Automation team on day to day basis to baseline the reports.
• As a Data analyst, one of the primary responsibilities was to deep dive and understand the production data that was hosted on Microsoft Azure (captured in UAMI, UAPI and HistorianDB) based on the scenarios of Recipes, Batches produced, Good Intake, Silos information, Siros details, Genealogy & Traceability, Right First Time information etc.
• Understanding the analytical aspects of Recipe based on Mean, Median, Mode, Std Dev, Distribution Curves & SPC values.
• Link them back to the Visualisation reports for interpretation and readability.
• Setting up and maintaining the Reporting services in the Dev environment. Deployment of the reports to the Dev env for CICD (Continuous Integration and Continuous Deployment)
• Housekeeping and archiving the Production data in Dev env to maintain Integrity and efficiency.
SSRS, UP, Production, Server, Continuous deployment, Mode, Analyst, Continuous integration, Developer, Sql, Integration, Database, Automation, Deployment, Microsoft azure, Azure, SQL Server
2016 - 2018
job
Business Data Analyst/ Modeller & Environment Owner
E.ON IT UK.
Responsibilities:
• Test data was one of the major challenges in any company so with my expertise I had thoroughly analysed the historical data and business models and had solely developed a bespoke TestData Tool (M.I.N.T- C#, Oracle) to fetch the test data across different environments and databases based on Users' selection.
• M.I.N.T was much appreciated and recognised in E.ON UK group and was made as a Standard TestData Tool for different programmes and I am continuously improving and maintaining it for the different programmes.
• The Test environment was very unstable and volatile since all the processes or jobs are placed on hold so as an Environment Owner I had to streamline the processes, schedule the jobs and mature the data to look like LIVE(BAU) standards
• As a Test environment owner, I'm responsible for running the Registration, Invoicing, Billing, Payment, Reconciliation jobs at regular intervals.
• Have developed and simulated general business models to aid business decisions such as payments, billing, PDF bills etc.
• Having a cross-functional skillset and expertise, I have got an opportunity to work in different Programmes such as Digital (Website and Mob Apps), Home Moves, RPA(Robotics Process Automation), CCP(Customer Contact Platform), GDPR and few internal projects such as Pricing, CABI(Consultant and Broker Interface), Fixed Bills and Free days for SmartMeter Customers, EON HEAT- 3rd party system(Junifer) integrated into EON modules.
• Analysing large volumes of multi-dimensional data sets and modelling new data models based on business requirements and updating the existing data model. Created new metadata and updating existing metadata.
• Working closely with the business users on providing tactical solutions and designing logical data models accordingly. Worked with clients to generate use case scenarios based on user requirements.
• Performed the gap analysis and impact analysis and assisted DBAs on support needs and provided guidance on architectural issues.
• Test data was one of the major challenges in any company so with my expertise I had thoroughly analysed the historical data and business models and had solely developed a bespoke TestData Tool (M.I.N.T- C#, Oracle) to fetch the test data across different environments and databases based on Users' selection.
• M.I.N.T was much appreciated and recognised in E.ON UK group and was made as a Standard TestData Tool for different programmes and I am continuously improving and maintaining it for the different programmes.
• The Test environment was very unstable and volatile since all the processes or jobs are placed on hold so as an Environment Owner I had to streamline the processes, schedule the jobs and mature the data to look like LIVE(BAU) standards
• As a Test environment owner, I'm responsible for running the Registration, Invoicing, Billing, Payment, Reconciliation jobs at regular intervals.
• Have developed and simulated general business models to aid business decisions such as payments, billing, PDF bills etc.
• Having a cross-functional skillset and expertise, I have got an opportunity to work in different Programmes such as Digital (Website and Mob Apps), Home Moves, RPA(Robotics Process Automation), CCP(Customer Contact Platform), GDPR and few internal projects such as Pricing, CABI(Consultant and Broker Interface), Fixed Bills and Free days for SmartMeter Customers, EON HEAT- 3rd party system(Junifer) integrated into EON modules.
• Analysing large volumes of multi-dimensional data sets and modelling new data models based on business requirements and updating the existing data model. Created new metadata and updating existing metadata.
• Working closely with the business users on providing tactical solutions and designing logical data models accordingly. Worked with clients to generate use case scenarios based on user requirements.
• Performed the gap analysis and impact analysis and assisted DBAs on support needs and provided guidance on architectural issues.
Oracle, Automation, C, GDpr, Test, Robotics, Website, RPA, PDF, It, Support, Apps, Analyst, Processes
2015 - 2016
job
Senior Data Analyst/ Modeller
Northern PowerGrid.
Responsibilities:
● NPG has undertaken the eAM(Enterprise Asset Management) spatial programme, the largest IT-enabled business transformation programme in decades. Since the merger, the Northeast and Yorkshire power grid has been operating on two separate systems. So the team was taken up to replace the core asset information systems which have been in place since the mid-1990s and to provide a suite of applications which will significantly alter the way of updating the records for maintenance and inspection works. The ultimate agenda is to modernize the systems that are currently being used and to provide access to the assets and network records both in office and out in field i.e. touchpads and tough books.
● The primary responsibility is to coordinate between multiple stakeholders such as NPG business users, Field engineers, Regulation team, development & testing teams.
● The major responsibility is to cross-reference the data models and make sure that the data captured in eAM from two different sources (North East and Yorkshire Powergrid) are as per the Business standards and should adhere the compliance metrics of OFGEM regulatory standards.
● The raw data is available in many formats such as Vectors, maps, semi-schematic, LV skeletons, connectivity models etc. Based on the requirements, the creation and validation of Field lists, collection plans and LOV(List of Values) data for a particular ad-hoc are done to load in eAM.
● The BAU data tasks were captured in ERP (Microsoft Dynamics AX 2012 R2) such as new connections setup, asset replacement, repairs, remedies, enforcement, new/closed work orders, collection plans, inspection data etc. need to be validated and loaded to the new system.
● Responsible for a thorough analysis of the investments' data in the new, maintained and reinforced assets in the field. Monitoring and guiding the multiple procurements and delivery teams. Building up strategies and drawing conclusions on the investment closure and reconcile methods.
● The validated data is supplied to the new systems iSmart and GeoField which enables the field engineers to quickly respond to the customers enquires on assets. Understand the process and correcting the standard, measurement and random errors using Data Reconciliation techniques.
● Responsible for all in-house data-related tasks such as Data Extraction, Cleansing, Enriching, Parsing, Mining, Transformation, Profiling, Dictionary, Reconciliation, Loading, Migration and Maintenance.
● Validating the existing data models, DML & T-SQL Stored Procedures, Functions, Triggers & Error handling scripts that were developed in Dev and test environments and reporting back to the concerned teams.
● NPG has undertaken the eAM(Enterprise Asset Management) spatial programme, the largest IT-enabled business transformation programme in decades. Since the merger, the Northeast and Yorkshire power grid has been operating on two separate systems. So the team was taken up to replace the core asset information systems which have been in place since the mid-1990s and to provide a suite of applications which will significantly alter the way of updating the records for maintenance and inspection works. The ultimate agenda is to modernize the systems that are currently being used and to provide access to the assets and network records both in office and out in field i.e. touchpads and tough books.
● The primary responsibility is to coordinate between multiple stakeholders such as NPG business users, Field engineers, Regulation team, development & testing teams.
● The major responsibility is to cross-reference the data models and make sure that the data captured in eAM from two different sources (North East and Yorkshire Powergrid) are as per the Business standards and should adhere the compliance metrics of OFGEM regulatory standards.
● The raw data is available in many formats such as Vectors, maps, semi-schematic, LV skeletons, connectivity models etc. Based on the requirements, the creation and validation of Field lists, collection plans and LOV(List of Values) data for a particular ad-hoc are done to load in eAM.
● The BAU data tasks were captured in ERP (Microsoft Dynamics AX 2012 R2) such as new connections setup, asset replacement, repairs, remedies, enforcement, new/closed work orders, collection plans, inspection data etc. need to be validated and loaded to the new system.
● Responsible for a thorough analysis of the investments' data in the new, maintained and reinforced assets in the field. Monitoring and guiding the multiple procurements and delivery teams. Building up strategies and drawing conclusions on the investment closure and reconcile methods.
● The validated data is supplied to the new systems iSmart and GeoField which enables the field engineers to quickly respond to the customers enquires on assets. Understand the process and correcting the standard, measurement and random errors using Data Reconciliation techniques.
● Responsible for all in-house data-related tasks such as Data Extraction, Cleansing, Enriching, Parsing, Mining, Transformation, Profiling, Dictionary, Reconciliation, Loading, Migration and Maintenance.
● Validating the existing data models, DML & T-SQL Stored Procedures, Functions, Triggers & Error handling scripts that were developed in Dev and test environments and reporting back to the concerned teams.
Transformation, UP, AX 2012, Enterprise, Power, Office, Development, Regulatory, Testing, Monitoring, Analyst, Dynamics AX, Sql, It, Network, Compliance, Test, T-SQL, Stored procedures, Asset Management, Management, Business transformation, ERP
2014 - 2015
job
Senior Data Analyst & SQL Developer
National Grid.
Responsibilities:
● The primary responsibility was to work closely with the different stakeholders like National Grid Business users, Shippers, Distribution Networks, Independent Gas Transporters(iGT) and OFGEM to analyse the business initiatives, gather, develop and document process maps.
● Conducting and attending the Business meetings to provide technical and functional support to the critical modules of National Grid's Gas network systems namely Gemini and UK Link systems.
● Responsible for running and troubleshooting the Production jobs of New Site Creation/Registration, Nomination, Invoicing, Billing, Reconciliation, Site Closure jobs etc.
● Owner of all the in-house data-related tasks such as Extraction, Cleansing, Enriching, Parsing, Mining, Transformation, Profiling, Dictionary, Loading, Reconciliation, Migration and Maintenance using MSBI (SSIS)
● Writing T-SQL (Stored Procedures, Functions, Triggers, Error handling, optimisation, hints etc.) and automating the scripts for better performance & efficiency. Responsible for Query Performance optimization as well.
● To analyse the process and measurement metrics of the system and to perform Reconciliation techniques for better outcomes. Reporting the status and summary using the Reporting server (SSAS & SSRS).
● Worked closely with the Business users & Testers to perform User Acceptance Testing (UAT), System Testing, Regression and Integration Testing to validate the newly developed interfaces, enhancements, and functionalities in the Gas domain.
● The primary responsibility was to work closely with the different stakeholders like National Grid Business users, Shippers, Distribution Networks, Independent Gas Transporters(iGT) and OFGEM to analyse the business initiatives, gather, develop and document process maps.
● Conducting and attending the Business meetings to provide technical and functional support to the critical modules of National Grid's Gas network systems namely Gemini and UK Link systems.
● Responsible for running and troubleshooting the Production jobs of New Site Creation/Registration, Nomination, Invoicing, Billing, Reconciliation, Site Closure jobs etc.
● Owner of all the in-house data-related tasks such as Extraction, Cleansing, Enriching, Parsing, Mining, Transformation, Profiling, Dictionary, Loading, Reconciliation, Migration and Maintenance using MSBI (SSIS)
● Writing T-SQL (Stored Procedures, Functions, Triggers, Error handling, optimisation, hints etc.) and automating the scripts for better performance & efficiency. Responsible for Query Performance optimization as well.
● To analyse the process and measurement metrics of the system and to perform Reconciliation techniques for better outcomes. Reporting the status and summary using the Reporting server (SSAS & SSRS).
● Worked closely with the Business users & Testers to perform User Acceptance Testing (UAT), System Testing, Regression and Integration Testing to validate the newly developed interfaces, enhancements, and functionalities in the Gas domain.
Developer, Production, Server, Performance optimization, Testing, SSAS, Analyst, Support, Transformation, Sql, SSRS, Network, Ssis, Integration, T-SQL, Stored procedures, Optimization, Writing
2013 - 2014
job
Senior Data Analyst/Modeller & SQL Developer
Wells Fargo Bank.
Responsibilities:
● The primary responsibility was to understand and interpret the complex Data Models.
● Using MS data tools (BI) and ETL concepts, the unstructured data from different sources were loaded to the target destinations.
● Worked with business users to develop data quality, business rules and to improve the quality of data.
● Owner of all the in-house data-related tasks such as Modelling, Mapping, Extraction, Cleansing, Enriching, Parsing, Mining, Transformation, Profiling, Dictionary, Loading, Migration and Maintenance.
● The extracted SSIS data was analysed using SSAS and prototype reports were using SSRS.
● Finding the data and process anomalies which improve the existing process.
● Responsible to create the data models to transform the unstructured dataset to structured dataset in MS SQL Server 2008 and MS Access.
● The data results are obtained from SSIS and then thoroughly analysed in pictorial formats of graphs, charts, Pivot tables etc. for better readability.
● Document and present the Data quality processes to business users and different stakeholders.
● The primary responsibility was to understand and interpret the complex Data Models.
● Using MS data tools (BI) and ETL concepts, the unstructured data from different sources were loaded to the target destinations.
● Worked with business users to develop data quality, business rules and to improve the quality of data.
● Owner of all the in-house data-related tasks such as Modelling, Mapping, Extraction, Cleansing, Enriching, Parsing, Mining, Transformation, Profiling, Dictionary, Loading, Migration and Maintenance.
● The extracted SSIS data was analysed using SSAS and prototype reports were using SSRS.
● Finding the data and process anomalies which improve the existing process.
● Responsible to create the data models to transform the unstructured dataset to structured dataset in MS SQL Server 2008 and MS Access.
● The data results are obtained from SSIS and then thoroughly analysed in pictorial formats of graphs, charts, Pivot tables etc. for better readability.
● Document and present the Data quality processes to business users and different stakeholders.
Sql, SQL Server, ETL, Data quality, Ssis, Access, SSRS, Developer, Transformation, Analyst, SSAS, Server, BEE, Processes, Sql server 2008
2009 - 2013
job
Data Analyst/Modeller & SQL Developer
DXC (Hewlett Packard).
Responsibilities:
● This is one of most prestigious and complicated GreenField and POC (Proof of Concept) project where HP firm had acquired the 3PAR firm in which I need to ensure that a smooth adaption between these two firms should be accomplished.
● The primary role was to analyse and understand the initiatives, gather requirements, set goals, process mapping, Data modelling, risk assessments, plan risk mitigation, share the outcome/ results and achieve the target within tight deadlines.
● To closely work with both the stakeholders of two firms (3PAR and HP) like Hardware manufacturers, Suppliers, Integrators, developers and Business users.
● All the analysis, dataset, anomalies, efforts and performances are captured in spreadsheets and presented to both the stakeholders for smoother transitions.
● Ensured that the quality standards of acquiring firm are met by the end of the assignment by fixing the data and process anomalies and with improved efficiency.
● Have reviewed all the technical documents and maintained all the documents in SharePoint.
● Owner of all the in-house data-related tasks such as Extraction, Cleansing, Enriching, Parsing, Mining, Transformation, Profiling, Dictionary, Reconciliation, Loading, Migration and Maintenance.
● To design the data models with Data Modelers, transformed the raw data to the target systems using MS Data tools (MS BI) and ETL concepts.
● Writing T-SQL (Stored Procedures, Functions, Triggers, Error handling, optimisation, hints etc.) and automating the scripts for better performance & efficiency. Responsible for Query Performance optimisation as well.
● Analysing the system build and process to check on the random errors using Data reconciliation and Reporting the status and summary using the statistical tools R and Reporting server(SSAS & SSRS).
● The MS Access data results are obtained from SSIS and then thoroughly analysed in pictorial formats of graphs, charts, Pivot tables etc. for better readability and understanding.
● The Decision support systems were used to draw conclusions to the existing process and invented new design techniques to improve the efficiency of the project using LEAN.
● This is one of most prestigious and complicated GreenField and POC (Proof of Concept) project where HP firm had acquired the 3PAR firm in which I need to ensure that a smooth adaption between these two firms should be accomplished.
● The primary role was to analyse and understand the initiatives, gather requirements, set goals, process mapping, Data modelling, risk assessments, plan risk mitigation, share the outcome/ results and achieve the target within tight deadlines.
● To closely work with both the stakeholders of two firms (3PAR and HP) like Hardware manufacturers, Suppliers, Integrators, developers and Business users.
● All the analysis, dataset, anomalies, efforts and performances are captured in spreadsheets and presented to both the stakeholders for smoother transitions.
● Ensured that the quality standards of acquiring firm are met by the end of the assignment by fixing the data and process anomalies and with improved efficiency.
● Have reviewed all the technical documents and maintained all the documents in SharePoint.
● Owner of all the in-house data-related tasks such as Extraction, Cleansing, Enriching, Parsing, Mining, Transformation, Profiling, Dictionary, Reconciliation, Loading, Migration and Maintenance.
● To design the data models with Data Modelers, transformed the raw data to the target systems using MS Data tools (MS BI) and ETL concepts.
● Writing T-SQL (Stored Procedures, Functions, Triggers, Error handling, optimisation, hints etc.) and automating the scripts for better performance & efficiency. Responsible for Query Performance optimisation as well.
● Analysing the system build and process to check on the random errors using Data reconciliation and Reporting the status and summary using the statistical tools R and Reporting server(SSAS & SSRS).
● The MS Access data results are obtained from SSIS and then thoroughly analysed in pictorial formats of graphs, charts, Pivot tables etc. for better readability and understanding.
● The Decision support systems were used to draw conclusions to the existing process and invented new design techniques to improve the efficiency of the project using LEAN.
Access, BEE, Server, Hardware, SSAS, Analyst, Support, Transformation, Developer, Process Mapping, SSRS, Design, Ssis, T-SQL, Stored procedures, Optimization, Lean, ETL, R, SharePoint, Writing, Sql
2008 - 2009
job
Technical Analyst
Norton Software.
Responsibilities:
● Remote Installation and configuration of Norton Software (Norton Antivirus, Internet Security, Online Backup and 360).
● Troubleshooting the issues caused by Virus, Malware and Rootkits and quarantining the bad files.
● Troubleshooting DSL and Line faults (Audio issues, No Dial tone, one-way audio etc.) for Belkin, Motorola, Linksys, Netgear, D-Link routers
● Responsible for handling all Network related issues from client-side and server-side.
● The configuration of Network devices like Routers, Adapters and Switches with Wire/Wireless features and enabling the Security types on the Network.
● Well versed with different types of ISPs like Cable, DSL and PPPOE connections.
GRADUATION:
● Remote Installation and configuration of Norton Software (Norton Antivirus, Internet Security, Online Backup and 360).
● Troubleshooting the issues caused by Virus, Malware and Rootkits and quarantining the bad files.
● Troubleshooting DSL and Line faults (Audio issues, No Dial tone, one-way audio etc.) for Belkin, Motorola, Linksys, Netgear, D-Link routers
● Responsible for handling all Network related issues from client-side and server-side.
● The configuration of Network devices like Routers, Adapters and Switches with Wire/Wireless features and enabling the Security types on the Network.
● Well versed with different types of ISPs like Cable, DSL and PPPOE connections.
GRADUATION:
Security, Wireless, Audio, Network, Analyst, Backup, Internet, Software, Server, Online
My education
2004
-
2008
Jawaharlal Nehru Technological University
Bachelors, Information Technology
Bachelors, Information Technology
Khammer's reviews
Khammer has not received any reviews on Worksome.
Contact Khammer Mohamed
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Khammer directly in Worksome.
are ready to help you
and get specific bids from skilled talent in Denmark