$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Strong Data Analyst and Visualization expert
Sabi Sivam
,
london, United Kingdom
Experience
Other titles
Skills
I'm offering
An experienced Data Analyst,SQL Server Consultant/DBA, with 9+ years commercial experience primarily in Data Analysis, Database Support (performance, integrity and security of business data), Report designing, data extraction and integration using SSIS, SSRS, MS Excel, MS SQL Server, Informatica, Power BI and Business Objects
• Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Successfully implemented Healthcare, Insurance/Financial services, Retail Data projects and have obtained a good working knowledge of the business processes and models.
• Expertise in data analysis, SQL database management, modelling, reporting, complex query tuning, forecasting and trend analysis.
• Quality customer communication and stake holder management for managing business requirements, design and development support of the SQL Server and backend database related activities.
• Experience of delivering insightful information of various views from data and ability to present analysis, information and MIS reporting.
• Worked on complete life cycle of projects such as Requirement analysis, design, development, implementation, and operation maintenance.
• Successfully designed, developed and implemented ETL solutions using SSIS Packages and SSRS on various business critical large scale applications.
• Provide level 2 and 3 support for issues/defects and timely resolution in demanding environments
• Independently analyse, test and fix issues in real time, providing problem resolution end-to-end.
• Knowledge sharing: Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
CERTIFICATIONS:
Accreditation:
• Certified ISTQB professional
• Certified PowerBI consultant
• Certified Informatica PowerCenter Data Integration 9.x Developer Specialist
• PowerCenter Data Integration 9.x:Developer Specialist
• Certified MS SQL Server Database Administrator 764: Administering a Microsoft SQL Database Infrastructure
• Oracle Certified Associate OCA
• Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Successfully implemented Healthcare, Insurance/Financial services, Retail Data projects and have obtained a good working knowledge of the business processes and models.
• Expertise in data analysis, SQL database management, modelling, reporting, complex query tuning, forecasting and trend analysis.
• Quality customer communication and stake holder management for managing business requirements, design and development support of the SQL Server and backend database related activities.
• Experience of delivering insightful information of various views from data and ability to present analysis, information and MIS reporting.
• Worked on complete life cycle of projects such as Requirement analysis, design, development, implementation, and operation maintenance.
• Successfully designed, developed and implemented ETL solutions using SSIS Packages and SSRS on various business critical large scale applications.
• Provide level 2 and 3 support for issues/defects and timely resolution in demanding environments
• Independently analyse, test and fix issues in real time, providing problem resolution end-to-end.
• Knowledge sharing: Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
CERTIFICATIONS:
Accreditation:
• Certified ISTQB professional
• Certified PowerBI consultant
• Certified Informatica PowerCenter Data Integration 9.x Developer Specialist
• PowerCenter Data Integration 9.x:Developer Specialist
• Certified MS SQL Server Database Administrator 764: Administering a Microsoft SQL Database Infrastructure
• Oracle Certified Associate OCA
Markets
United Kingdom
Industries
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Available
My experience
2019 - ?
freelance
Data Analyst /SQL Server Consultant
UCL.
• Analyse requirements, develop design specifications, source target mapping matrix, maintained naming conventions of the enterprise.
• Apply data cleansing to extracted data from various source environments.
• Designed data mappings for extraction, cleanse, transform and load data.
• Experience in delivering insightful information of various views from data and ability to present analysis, information and MIS reporting.
• Designed, developed reports, and supported on MS-Excel and SSRS environments
• Report development consultation for design, development and support on SSRS and Power BI environments
• Develop test cases, testing, data validation and document test plan and results.
• Involved in process initiatives and compliance, Knowledge Management (identify and update/prepare artefacts).
• Apply data cleansing to extracted data from various source environments.
• Designed data mappings for extraction, cleanse, transform and load data.
• Experience in delivering insightful information of various views from data and ability to present analysis, information and MIS reporting.
• Designed, developed reports, and supported on MS-Excel and SSRS environments
• Report development consultation for design, development and support on SSRS and Power BI environments
• Develop test cases, testing, data validation and document test plan and results.
• Involved in process initiatives and compliance, Knowledge Management (identify and update/prepare artefacts).
Support, Naming, Enterprise, Power, Server, BEE, Development, Testing, Analyst, Test cases, Design, SSRS, Compliance, Test, Management, Power BI, SQL Server, Excel, Sql
2016 - ?
freelance
Data Analyst/SQL Server Consultant
unknown.
Sql, SQL Server, Analyst, Server
2018 - 2019
job
Data Analyst/DBA
GSTT (Guys & St. Thomas Hospital, NHS).
Projects worked: LMS Migration, SCR Migration, DataNet/EMIS Load
Responsibilities:
• Managed Support services for GSTT (NHS) Healthcare customer on their SQL Server environments.
• SQL database management: Performing daily checks, configure and maintain critical database servers and processes, regular monitoring of system health and performance, to ensure high levels of performance, availability, and security. SQL Server monitoring to ensure service availability and continuity.
• Successfully developed and implemented data extraction projects, ETL solutions using SSIS and SSRS on various business critical large scale applications such as EMIS DataNet, SCR, LMS data. Designed SSIS packages and development for data extract and load
• Perform SQL Server installation, SSDT tools, Redgate Backup and restore, upgrade, SQL Server security patch update, support upgrade and migration of database and production servers
• Provide development support for SQL Server components for query analysis and fine tuning
• Support Server decommissioning and migrations
• SQL Server maintenance activities such as data archival, backup, purge and retrieval
• Providing development support for SQL Server components for query analysis and fine tuning
• Designed, developed reports, and supported on MS-Excel and SSRS environments
• Report development consultation for design, development and support on SSRS and Power BI environments
• Refine and automate regular processes, track issues, and document changes
• Perform scheduled maintenance and support release deployment activities after hours.
Responsibilities:
• Managed Support services for GSTT (NHS) Healthcare customer on their SQL Server environments.
• SQL database management: Performing daily checks, configure and maintain critical database servers and processes, regular monitoring of system health and performance, to ensure high levels of performance, availability, and security. SQL Server monitoring to ensure service availability and continuity.
• Successfully developed and implemented data extraction projects, ETL solutions using SSIS and SSRS on various business critical large scale applications such as EMIS DataNet, SCR, LMS data. Designed SSIS packages and development for data extract and load
• Perform SQL Server installation, SSDT tools, Redgate Backup and restore, upgrade, SQL Server security patch update, support upgrade and migration of database and production servers
• Provide development support for SQL Server components for query analysis and fine tuning
• Support Server decommissioning and migrations
• SQL Server maintenance activities such as data archival, backup, purge and retrieval
• Providing development support for SQL Server components for query analysis and fine tuning
• Designed, developed reports, and supported on MS-Excel and SSRS environments
• Report development consultation for design, development and support on SSRS and Power BI environments
• Refine and automate regular processes, track issues, and document changes
• Perform scheduled maintenance and support release deployment activities after hours.
Support, SSDT, Processes, Tuning, Performing, Production, Power, Server, BEE, Development, Backup, Health, Monitoring, Analyst, Design, SSRS, Ssis, Security, Service, Management, Database, ETL, Deployment, Power BI, SQL Server, Excel, Sql
2017 - 2018
job
Data Analyst/DBA
GOSH.
Responsibilities:
• SQL database management: Performing daily checks, configure and maintain critical database servers and processes, regular monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Migration of SQL data, objects (tables, views, functions, procedures, jobs) to target environments and setup and maintain SQL logins
• Perform SQL Server installation, upgrade, SQL Server security patch update, support upgrade and migration of database and production servers
• Provide level 2 and 3 support for data issues/defect resolution
• SQL Server maintenance activities such as data archival, backup, purge and retrieval.
• Providing development support for SQL Server components for query analysis and fine tuning
• Designed reports and supported SSIS packages and SSRS environments.
• Experience in delivering insightful information of various views from data and ability to present analysis, information and MIS reporting.
• SQL database management: Performing daily checks, configure and maintain critical database servers and processes, regular monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Migration of SQL data, objects (tables, views, functions, procedures, jobs) to target environments and setup and maintain SQL logins
• Perform SQL Server installation, upgrade, SQL Server security patch update, support upgrade and migration of database and production servers
• Provide level 2 and 3 support for data issues/defect resolution
• SQL Server maintenance activities such as data archival, backup, purge and retrieval.
• Providing development support for SQL Server components for query analysis and fine tuning
• Designed reports and supported SSIS packages and SSRS environments.
• Experience in delivering insightful information of various views from data and ability to present analysis, information and MIS reporting.
Monitoring, Processes, Tuning, Performing, Production, Server, Development, Backup, Health, Sql, Analyst, Support, SSRS, Ssis, Security, Management, Database, SQL Server
2016 - 2017
freelance
Microsoft SQL Server Consultant
unknown.
Sql, SQL Server, Microsoft SQL, Microsoft SQL Server, Server
2016 - 2017
freelance
Data Analyst/SQL Server Consultant
Anya Consultancy Services.
Responsibilities:
• Managed Support services for Healthcare and Retail customers for their SQL Server environments.
• Performing daily checks for over 25 customers
• Providing level 2 and 3 support for defect resolution
• Providing development support for SQL Server components
• Worked to perform System, Integration and Regression testing
• Perform SQL Server installation, SSDT tools, Redgate Backup and restore, upgrade, SQL Server security patch update, support upgrade and migration of database and production servers
• SQL Server monitoring to ensure service availability
• SQL Server maintenance activities such as data archival, backup, purge and retrieval
• SSIS package design and development for data extract and load
• Report development consultation for design, development and support on SSRS and Power BI environments
• Managed Support services for Healthcare and Retail customers for their SQL Server environments.
• Performing daily checks for over 25 customers
• Providing level 2 and 3 support for defect resolution
• Providing development support for SQL Server components
• Worked to perform System, Integration and Regression testing
• Perform SQL Server installation, SSDT tools, Redgate Backup and restore, upgrade, SQL Server security patch update, support upgrade and migration of database and production servers
• SQL Server monitoring to ensure service availability
• SQL Server maintenance activities such as data archival, backup, purge and retrieval
• SSIS package design and development for data extract and load
• Report development consultation for design, development and support on SSRS and Power BI environments
Support, SSDT, Performing, Production, Power, Server, BEE, Development, Backup, Testing, Monitoring, Analyst, Design, SSRS, Ssis, Security, Service, Integration, Regression testing, Database, Power BI, SQL Server, Retail, Sql
2011 - 2012
freelance
IT Consultant
unknown.
IT Consultant, It
2011 - 2012
freelance
IT Consultant/Test Analyst
John Lewis.
Responsibilities:
• Worked on preparation of Test Plan, test data preparation.
• Defining testing estimations, approaches, plans.
• Requirements mapping of the test scripts against requirements.
• Worked to perform System, Integration and Regression testing.
• Defects logging, tracking, and reporting
• Preparation and sending the Test Status Reports
• Worked on preparation of Test Plan, test data preparation.
• Defining testing estimations, approaches, plans.
• Requirements mapping of the test scripts against requirements.
• Worked to perform System, Integration and Regression testing.
• Defects logging, tracking, and reporting
• Preparation and sending the Test Status Reports
Regression testing, Integration, Test, IT Consultant, It, Analyst, Testing
2008 - 2010
freelance
IT Consultant
BBC Worldwide.
BBC Worldwide IT Consultant
July 2008 - Dec 2010
BBC Worldwide is the main commercial arm and a wholly owned subsidiary of the British Broadcasting Corporation (BBC).
Responsibilities:
• Design specifications encompassing all aspects of technical solution design.
• Extensively worked on data extraction, Transformation and loading data from various sources like SQL Server, Oracle and Flat files.
• SQL Server security patch update, support upgrade and migration of database and production servers
• Refactoring of data mart schema to accommodate new features and performance improvement
• Development/enhancements to cater to new/changing business requirements and business rules.
• Created Test cases for the mappings, integration Testing Document.
• Work closely with the Reporting team, to find mismatches in the reports, and the source database.
• Performed user support, Frequent Failure Analysis, SLA Management and Status Reporting.
July 2008 - Dec 2010
BBC Worldwide is the main commercial arm and a wholly owned subsidiary of the British Broadcasting Corporation (BBC).
Responsibilities:
• Design specifications encompassing all aspects of technical solution design.
• Extensively worked on data extraction, Transformation and loading data from various sources like SQL Server, Oracle and Flat files.
• SQL Server security patch update, support upgrade and migration of database and production servers
• Refactoring of data mart schema to accommodate new features and performance improvement
• Development/enhancements to cater to new/changing business requirements and business rules.
• Created Test cases for the mappings, integration Testing Document.
• Work closely with the Reporting team, to find mismatches in the reports, and the source database.
• Performed user support, Frequent Failure Analysis, SLA Management and Status Reporting.
IT Consultant, Production, Server, Development, Testing, Test cases, Support, Transformation, It, Design, Security, Test, Integration, Management, Database, SQL Server, Oracle, Sql
2007 - 2008
job
Data Warehouse Developer
Johnson Diversey.
Data Warehouse, Developer
2007 - 2008
job
Data Warehouse Tester/ Designer
GM (General Motors).
GMAC Insurance/Financial Services, largest property and casualty insurance company, provides broad range of insurance and insurance-related products and services.
Responsibilities:
• Analysed requirements, developed design specifications, source target mapping matrix, maintained naming conventions of the enterprise and customized it.
• Apply data cleansing to extracted data from various source environments.
• Designed data mappings and created various Type 2 (Slowly Changed Dimension) mappings for dimension load, implementing date based logic.
• Improved the productivity by developing reusable components.
• Proactively identified the performance issues and resolved the overall loading process time by 40% (reduced form 48 hrs to 30 hrs). Performed unit testing and integrated testing for the mappings developed and used Debugger to check the errors.
• Process initiatives and compliance, Knowledge Management (identify and prepare artefacts).
• Developed test cases, involved in testing and data validation and documented unit test plan and results.
Responsibilities:
• Analysed requirements, developed design specifications, source target mapping matrix, maintained naming conventions of the enterprise and customized it.
• Apply data cleansing to extracted data from various source environments.
• Designed data mappings and created various Type 2 (Slowly Changed Dimension) mappings for dimension load, implementing date based logic.
• Improved the productivity by developing reusable components.
• Proactively identified the performance issues and resolved the overall loading process time by 40% (reduced form 48 hrs to 30 hrs). Performed unit testing and integrated testing for the mappings developed and used Debugger to check the errors.
• Process initiatives and compliance, Knowledge Management (identify and prepare artefacts).
• Developed test cases, involved in testing and data validation and documented unit test plan and results.
Design, Data Warehouse, Management, Unit test, Test, Compliance, It, Test cases, Insurance, Testing, Logic, Enterprise, Naming
My education
UCL University of London
N/a, N/a
N/a, N/a
Sabi's reviews
Sabi has not received any reviews on Worksome.
Contact Sabi Sivam
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Sabi 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