$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Architect-SQL Server
Sandesh Kadam
,
NorthWood London, United Kingdom
Experience
Other titles
Skills
I'm offering
Sandesh is a SQL Server Expert and possesses over 18 years of SQL database experience, combined with Microsoft Certified Professional and Microsoft Certified Solutions Designer certifications and also a Masters in Information Technology.
I worked for a variety of government sector clients over the years including HMRC, Department of Health and the Ministry of Defence, as well as having a knowledge of the energy sector from the time he spent with Smartest Energy Limited (SEL) and Bord Gais (A Centrica Group Business).
I am seeking an opportunity in a great organisation. Somewhere he can put roots down and develop not only a career but build great relationships in an established team, working collaboratively towards common goals.
I worked for a variety of government sector clients over the years including HMRC, Department of Health and the Ministry of Defence, as well as having a knowledge of the energy sector from the time he spent with Smartest Energy Limited (SEL) and Bord Gais (A Centrica Group Business).
I am seeking an opportunity in a great organisation. Somewhere he can put roots down and develop not only a career but build great relationships in an established team, working collaboratively towards common goals.
Markets
United States
(Remote
only)
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2019 - 2019
job
Senior DW & Azure Data Engineer
Costain (Secured Client).
Job Type: Contract, This being a secure project. I am not permitted to detail the activities & my duties on the public domain.
• It was Strategic development forming a Dreadnaught alliance with several consulting companies & stakeholders.
• I developed POC of shift & load of the on Premises data to Azure SQL Databases. Further development of ADF pipelines to demonstrate the transformation activities.
• I also developed & demonstrated the usage of Azure integration service loading their on promises SSIS packages with minimal changes and triggering them in the data factory.
• I also demonstrated the benefits of Azure data warehouse vs on premise data warehouse.
• Prepared documentation such as Data Warehouse programe strategy; ETL Strategy; User guide and ownership.
• It was Strategic development forming a Dreadnaught alliance with several consulting companies & stakeholders.
• I developed POC of shift & load of the on Premises data to Azure SQL Databases. Further development of ADF pipelines to demonstrate the transformation activities.
• I also developed & demonstrated the usage of Azure integration service loading their on promises SSIS packages with minimal changes and triggering them in the data factory.
• I also demonstrated the benefits of Azure data warehouse vs on premise data warehouse.
• Prepared documentation such as Data Warehouse programe strategy; ETL Strategy; User guide and ownership.
Sql, Azure, Data Warehouse, ETL, Consulting, Integration, Service, Ssis, It, Transformation, Azure SQL, Development, Detail, Guide
2019 - 2019
job
Expert
Data Visualisation & Azure Data Arc.
Job Type: Contract Tools: SSIS, BI, Data Factory, PowerShell, ARM
• Hansard is the Investment fund managers, and I was on a client site helping them to gear up with the migration of Oracle and On-Premise SQL Server to MS Azure.
• I helped them formulate ETL strategies. Data factory, and pipeline execution strategies and also helped with the nominal issue with the Azure Data Analysis service queries.
• It was an impeccable experience, as handling and dealing the clients request alone & single-handedly to satisfy the clients to demand further next step support from the Expert thinking and myself involved for the solution design.
• Hansard is the Investment fund managers, and I was on a client site helping them to gear up with the migration of Oracle and On-Premise SQL Server to MS Azure.
• I helped them formulate ETL strategies. Data factory, and pipeline execution strategies and also helped with the nominal issue with the Azure Data Analysis service queries.
• It was an impeccable experience, as handling and dealing the clients request alone & single-handedly to satisfy the clients to demand further next step support from the Expert thinking and myself involved for the solution design.
Design, Sql, Data Analysis, SQL Server, Azure, Oracle, ETL, PowerShell, Service, Ssis, It, Support, BEE, Server, UP
2019 - 2019
job
Senior SQL Developer (SSIS, BI & PowerBI)
Smartest Energy Limited.
Job Type: Contract Tools: MS Azure SQL Server 2017, Azure PowerShell.
I was returning to Smartest Energy for the second time.
• Achieved facilitation of the data migration & exchange within different Azure Regions using Azure PowerShell.
• Developed further leadership and management qualities by providing mentorship on data modelling best practices to the permanent team.
I was returning to Smartest Energy for the second time.
• Achieved facilitation of the data migration & exchange within different Azure Regions using Azure PowerShell.
• Developed further leadership and management qualities by providing mentorship on data modelling best practices to the permanent team.
Sql, SQL Server, Azure, Exchange, Leadership, Management, PowerShell, Ssis, Developer, Azure SQL, BEE, Server, Mentorship, Energy, Energy
2018 - 2019
job
SQL Data Architect
IBM.
Job Type: Contract Tools: Postgres 10, PgAdmin, AWS. Navicat DM, (Confidential apps BPC)
• I completed the aligning IT and business systems for migration.
◦ I achieved above by understanding the model & intersections (digest) & variants.
◦ I created a merged model subsuming a collection of the business process.
• I worked on the data mapping and integrated it into different unrelated data sources.
• Streamlined the domain model & I worked closely with the stakeholders and users, the systems designers and the developers.
◦ This helped to abstract general principles from specifics and get recognition to the value of DA Design Patterns (POLE)
• Hands-on data modelling; translating a logical design into a few physical Databases.
• I also re-developed and enhanced the old SQL coded functions on PostGress SQL implementing Service API calls.
• I completed the aligning IT and business systems for migration.
◦ I achieved above by understanding the model & intersections (digest) & variants.
◦ I created a merged model subsuming a collection of the business process.
• I worked on the data mapping and integrated it into different unrelated data sources.
• Streamlined the domain model & I worked closely with the stakeholders and users, the systems designers and the developers.
◦ This helped to abstract general principles from specifics and get recognition to the value of DA Design Patterns (POLE)
• Hands-on data modelling; translating a logical design into a few physical Databases.
• I also re-developed and enhanced the old SQL coded functions on PostGress SQL implementing Service API calls.
Design, Sql, API, AWS, Design Patterns, Service, It, Apps, Postgres, Patterns
2018 - 2018
job
Senior SQL Developer SME
SSIS, BI & Power BI.
Job Type: Contract Tools: MS Azure SQL Server 2017, DBSchema, SSIS, SSRS, Power BI.
Worked as a Senior SQL Developer on asset optimization programme for the Smartest Energy limited.
• Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
• Utilised a pipe and filter model to find bottlenecks and enable measurement of system resource usage and process behaviour at boundary limits of all operations.
• Coordinated with systems partners to finalise designs and confirm requirements.
• Deployed the BI solution of CI & CD with SSDT projects within Azure DevOps.
• Performed Data discovery & Entity-Relationship modelling to map to the developed HLD.
• Developed pipelines for SSIS & SQL Stored Procedures code projects.
• Developed ETL using SSIS to ingest the meter readings & Invoices from customers and suppliers.
• Developed payment pricing & rating engine for Gas & Electricity (STOR) for Customer & Supplier.
• Successfully deployed SSIS & few stored procedures as a job using Azure Data Factory (ADF)
• Developed POC of the Power BI dashboard to provide rating over a (STOR) contract.
• Developed Azure SQL Server Stored procedures.
• Achieved database tuning to improve ETL and query performance.
• Introduced peer reviews function to improvise the developers coding standards.
• It helped me ease the knowledge transfers between the developers in the team.
• Defined and executed test cases as part of developer QA.
• As a certified scrum master, I was given the responsibility of daily stand-ups & daily progress updates.
• Provide clear complexity estimates during agile scrum sprint planning meetings.
Worked as a Senior SQL Developer on asset optimization programme for the Smartest Energy limited.
• Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
• Utilised a pipe and filter model to find bottlenecks and enable measurement of system resource usage and process behaviour at boundary limits of all operations.
• Coordinated with systems partners to finalise designs and confirm requirements.
• Deployed the BI solution of CI & CD with SSDT projects within Azure DevOps.
• Performed Data discovery & Entity-Relationship modelling to map to the developed HLD.
• Developed pipelines for SSIS & SQL Stored Procedures code projects.
• Developed ETL using SSIS to ingest the meter readings & Invoices from customers and suppliers.
• Developed payment pricing & rating engine for Gas & Electricity (STOR) for Customer & Supplier.
• Successfully deployed SSIS & few stored procedures as a job using Azure Data Factory (ADF)
• Developed POC of the Power BI dashboard to provide rating over a (STOR) contract.
• Developed Azure SQL Server Stored procedures.
• Achieved database tuning to improve ETL and query performance.
• Introduced peer reviews function to improvise the developers coding standards.
• It helped me ease the knowledge transfers between the developers in the team.
• Defined and executed test cases as part of developer QA.
• As a certified scrum master, I was given the responsibility of daily stand-ups & daily progress updates.
• Provide clear complexity estimates during agile scrum sprint planning meetings.
Ssis, ME, SSDT, Energy, Energy, Tuning, Power, Server, BEE, Azure SQL, Developer, It, SSRS, Stored procedures, Sql, QA, Test, ETL, Database, Agile, Power BI, Operations, DevOps, Scrum master, Azure, SQL Server, Scrum
2018 - 2018
job
Architect / SQL SME (SSIS, BI)
Data Modeler.
Job Type: Contract Tools: SQL Server 2016, MDS, SSIS, PAAS, MS Azure, Source Tree GIT & Trello
A Centrica group business & is one of Ireland's leading energy providers.
• I completed the SSIS framework design and ETL development for Data Warehouse Project.
• Worked with stakeholders and users to develop and complete the requirements.
• Designed conceptual, Logical & physical model of a database.
• Implemented a Master Record Management system for a client using SQL MDS server.
• Teamed in designing a BI solution of CI CD with GIT projects within Azure DevOps (migrating from Trello)
• Hands-on ETL implementation of Bloomberg data pipeline.
• Develop a robust core framework for the reporting and analytics platform
• Defining pipelines & projects for developing & optimizing stored procedures for continuous deployment.
• Worked closely with the system architect, Director of the data management unit, a product manager
A Centrica group business & is one of Ireland's leading energy providers.
• I completed the SSIS framework design and ETL development for Data Warehouse Project.
• Worked with stakeholders and users to develop and complete the requirements.
• Designed conceptual, Logical & physical model of a database.
• Implemented a Master Record Management system for a client using SQL MDS server.
• Teamed in designing a BI solution of CI CD with GIT projects within Azure DevOps (migrating from Trello)
• Hands-on ETL implementation of Bloomberg data pipeline.
• Develop a robust core framework for the reporting and analytics platform
• Defining pipelines & projects for developing & optimizing stored procedures for continuous deployment.
• Worked closely with the system architect, Director of the data management unit, a product manager
Analytics, Manager, Framework, Energy, Sql server 2016, Energy, Server, BEE, Development, Trello, Implementation, Stored procedures, Ssis, Design, Management, Product Manager, Deployment, ETL, Data management, Data Warehouse, Database, DevOps, Azure, SQL Server, Git, Sql
2017 - 2017
job
SQL Knowledge Database Expert
Ministry of Defense.
Job Type: Contract Tools: SQL Server 2016, O365 Forms, Power BI, SharePoint portal
Developed an organization-wide knowledge management strategy as a part of enterprise decision support systems by capturing, organizing and developing information. Designed & Developed HLD & PDM for LFE database to manage the learnings from the experiences as the first steps towards artificial intelligence. So then apply the machine algorithms to interrogate the other interconnected datasets and systems & compare the AI with projects expectations, Developed Power BI to collate existing trends in the data with the public-sector MOD Organizations. Deriving insight and using knowledge from data collected and analyzed in decision making, planning, cross-organizational and external activities. Solutions focused on a can-do attitude also Flexible and able to respond to the change-making Centre of excellence team with MOD PPD.
Developed an organization-wide knowledge management strategy as a part of enterprise decision support systems by capturing, organizing and developing information. Designed & Developed HLD & PDM for LFE database to manage the learnings from the experiences as the first steps towards artificial intelligence. So then apply the machine algorithms to interrogate the other interconnected datasets and systems & compare the AI with projects expectations, Developed Power BI to collate existing trends in the data with the public-sector MOD Organizations. Deriving insight and using knowledge from data collected and analyzed in decision making, planning, cross-organizational and external activities. Solutions focused on a can-do attitude also Flexible and able to respond to the change-making Centre of excellence team with MOD PPD.
Sql, SQL Server, Power BI, SharePoint, Artificial Intelligence, Database, Management, Algorithms, Support, Ai, BEE, Server, Power, Enterprise, Sql server 2016, Portal
2017 - 2017
freelance
Senior BI Consultant
Willis Tower Watson.
Job Type: Contract Tools: SQL Server 2016, SSIS, SSDT, And Firebird Database. SSRS, BING MAPS.
I worked for the Data Program of Willis Tower Watson, Executed an active role in Data Migration and GIS reporting delivery. Whilst also completed the migration of Firebird 2.1 database to the Azure SQL Database also migrated existing reports to SSRS platform. Analyze, design and develop MS Business Intelligence solutions working closely with the business to understand their requirements. Write ETL and SQL to load data from various system sources. I automated the SharePoint publishing of SSRS output of excel/pdf. Write complex ad-hoc T-SQL queries to meet urgent changes and quick needs. A further program was rescoped and moved to Ipswich
I worked for the Data Program of Willis Tower Watson, Executed an active role in Data Migration and GIS reporting delivery. Whilst also completed the migration of Firebird 2.1 database to the Azure SQL Database also migrated existing reports to SSRS platform. Analyze, design and develop MS Business Intelligence solutions working closely with the business to understand their requirements. Write ETL and SQL to load data from various system sources. I automated the SharePoint publishing of SSRS output of excel/pdf. Write complex ad-hoc T-SQL queries to meet urgent changes and quick needs. A further program was rescoped and moved to Ipswich
Ssis, Watson, SSDT, Firebird, Sql server 2016, Server, BEE, PDF, Azure SQL, SSRS, Gis, Design, T-SQL, ETL, Database, SharePoint, Azure, SQL Server, Business Intelligence, Excel, Sql
2017 - 2017
job
Snr. BI Developer
Talbot underwriting ltd.
Job Type: Contract Tools: SQL Server 2016, SSIS, SSDT, Job Scheduling tool. TFS--DevOps.
Being a strategic thinker among Actuarial team performing (satisfying the complex & dynamic need of solvency ratio formula) the upgrade to their legacy data & processes from access to MS SQL. While performing a responsibility of SQL SME & decision maker for the application/solutions readiness and present before CAB
my responsibilities included coordinating with an off-shore team for End User Computing (EUC) projects. I used SQL Server 2014(SSIS, SSAS, SSRS, and Power BI) implementing the Actuarial risk assessment. I also learned how to evaluate the Precision of actuarial risk and margins of error, effectively calculate the TCOR (Total cost of risk) and quantify the actual risk. Having performed Data Modelling roles in past my work scope was extended towards architectural & Quality Assurance of the data solutions provided by the group IT for BAU & other ongoing projects. This brought me to work closer to the business and coordinate the changes and continuously seek for the improvements of the data processor and better deliverables for the various teams.
Being a strategic thinker among Actuarial team performing (satisfying the complex & dynamic need of solvency ratio formula) the upgrade to their legacy data & processes from access to MS SQL. While performing a responsibility of SQL SME & decision maker for the application/solutions readiness and present before CAB
my responsibilities included coordinating with an off-shore team for End User Computing (EUC) projects. I used SQL Server 2014(SSIS, SSAS, SSRS, and Power BI) implementing the Actuarial risk assessment. I also learned how to evaluate the Precision of actuarial risk and margins of error, effectively calculate the TCOR (Total cost of risk) and quantify the actual risk. Having performed Data Modelling roles in past my work scope was extended towards architectural & Quality Assurance of the data solutions provided by the group IT for BAU & other ongoing projects. This brought me to work closer to the business and coordinate the changes and continuously seek for the improvements of the data processor and better deliverables for the various teams.
BEE, ME, SSDT, Processes, Sql server 2014, Performing, Sql server 2016, Off-shore, Power, Assessment, Server, Sql, SSAS, Quality Assurance, TFS, Developer, It, SSRS, Ssis, Power BI, DevOps, SQL Server
2016 - 2016
job
Lead BI & Data Design Eng
Merkle Inc.
Job Type: Contract
Merkle; a Data-driven performance marketing & strategic consultant. I worked as a Lead data & design development consultant (hands-on) for a client VTEC. This challenged me and tuned my people skills as a solution designer while performing Analysis and Data Structure Designs for the different processes. Due to the diverse data sources I used SQOOP to load the data in HDFS (Hadoop file system) and HIVE on top to used HIVEQL to deliver the normalized data to SQL SSIS engine which further triggered IBM Campaign Designer to execute the actual campaigns determining the individual journey legs also used Insource Data Academy & Pitney's Spectrum enterprise designer to fulfil my everyday activities.
Merkle; a Data-driven performance marketing & strategic consultant. I worked as a Lead data & design development consultant (hands-on) for a client VTEC. This challenged me and tuned my people skills as a solution designer while performing Analysis and Data Structure Designs for the different processes. Due to the diverse data sources I used SQOOP to load the data in HDFS (Hadoop file system) and HIVE on top to used HIVEQL to deliver the normalized data to SQL SSIS engine which further triggered IBM Campaign Designer to execute the actual campaigns determining the individual journey legs also used Insource Data Academy & Pitney's Spectrum enterprise designer to fulfil my everyday activities.
Marketing, Design, Sql, Hadoop, Ssis, People skills, Hive, Development, BEE, Campaign, Enterprise, Performing, Processes, ME
2016 - 2016
job
BI Data Architect
Schlumberger Oilfield Technology UK.
Job Type: Contract
As a hand's On BI Architect with responsibility for designing and developing complex ETL for global data transformation and migration project. The Project implements agile methodology using TFS with intention of SLM certification. I completed SLM KPI reports development using (ETL, SSAS cube, SSRS Reports & Power view). Often, I played the role of the scrum master during the standups and it has been improving my communication skills to excellence and work effectively with other developers, analysts, and SME's across the boundaries.
As a hand's On BI Architect with responsibility for designing and developing complex ETL for global data transformation and migration project. The Project implements agile methodology using TFS with intention of SLM certification. I completed SLM KPI reports development using (ETL, SSAS cube, SSRS Reports & Power view). Often, I played the role of the scrum master during the standups and it has been improving my communication skills to excellence and work effectively with other developers, analysts, and SME's across the boundaries.
Scrum, Scrum master, Agile, ETL, SSRS, It, TFS, Transformation, KPI, Development, SSAS, BEE, Power
2015 - 2016
job
Agile SQL Server Expert
HMRC.
Job Type: Contract 3 Extensions
This project followed agile dev standards with the stories and its changes controlled using Kanban board and dev code stored within TFS; having a sprint length of maximum 2 weeks iterative. Part of BPR team delivering this project in two deliverables MI Reporting & data integration. I performed to benefit the team goals that recognized our team for an Award. Data integration (with PEGA app) and cleansing Module. We delivered the service based on SQL Server on Windows & UNIX scripts to run TSQL to reconcile the central database using the KORN Shells. I developed SSIS & maintain those UNIX scripts.
This project followed agile dev standards with the stories and its changes controlled using Kanban board and dev code stored within TFS; having a sprint length of maximum 2 weeks iterative. Part of BPR team delivering this project in two deliverables MI Reporting & data integration. I performed to benefit the team goals that recognized our team for an Award. Data integration (with PEGA app) and cleansing Module. We delivered the service based on SQL Server on Windows & UNIX scripts to run TSQL to reconcile the central database using the KORN Shells. I developed SSIS & maintain those UNIX scripts.
Sql, SQL Server, Agile, Database, Unix, Integration, Kanban, Windows, Service, Ssis, TFS, App, Server
2015 - 2015
job
SQL Server Data Architect
Landmarc Support Services (MOD).
Job Type: Contract Previous client called back
On return to the same project phase two I have the following responsibilities and I am successfully handling them. Development accomplished using SQL Server 2012, T-SQL, SSIS, SSAS tabular cubes, Power view deployed on SharePoint Server with TFS as versioning and storage mechanism,
• Solely developed and designed Phase two data flows alongside all types of models (data, transformation, dimensional).
• Develop maintaining the high standards and less IO within the TSQL stored procedures due to the Of-Site and On-Site deployments of the solutions.
On return to the same project phase two I have the following responsibilities and I am successfully handling them. Development accomplished using SQL Server 2012, T-SQL, SSIS, SSAS tabular cubes, Power view deployed on SharePoint Server with TFS as versioning and storage mechanism,
• Solely developed and designed Phase two data flows alongside all types of models (data, transformation, dimensional).
• Develop maintaining the high standards and less IO within the TSQL stored procedures due to the Of-Site and On-Site deployments of the solutions.
Sql, SQL Server, SharePoint, Less, T-SQL, Ssis, Stored procedures, TFS, Transformation, Development, SSAS, Storage, Server, Power, Sql server 2012
2015 - 2015
job
SQL BI & DI Expert
Capita Justice and Secure Services.
Job Type: Contract SC cleared role
Tools: SQL 2012 and SSDT 2012 (SSIS, SSRS, SSAS / Power Pivots)
I joined a team in capacity of SQL & Bi Subject matter expert.
• Worked with the Enterprise/Solutions Architect and business analysts to plan, document and deliver a data warehouse implemented with the CDC from the ODS of the application.
• Developed SSIS frameworks to manage SSIS packages & separate framework for the CDC enabled tables.
Tools: SQL 2012 and SSDT 2012 (SSIS, SSRS, SSAS / Power Pivots)
I joined a team in capacity of SQL & Bi Subject matter expert.
• Worked with the Enterprise/Solutions Architect and business analysts to plan, document and deliver a data warehouse implemented with the CDC from the ODS of the application.
• Developed SSIS frameworks to manage SSIS packages & separate framework for the CDC enabled tables.
Sql, Data Warehouse, Ssis, SSRS, SSAS, BEE, Power, Enterprise, Framework, SSDT
2014 - 2014
job
BI & Data Analyst
BAE Systems.
Job Type: Contract Short time Project
Tools: SQL 2014 and SSDT 2013 (SSIS, SSAS), TFS
I joined a team on the HRFS project to be implementing throughout their businesses, handling all the lunar schedules for biweekly and the monthly payrolls. This is achieved using the SAP Success Factors application and fixing few ETL Issues. I achieved success by engagement workshops for their required features in their reporting dashboards.
Tools: SQL 2014 and SSDT 2013 (SSIS, SSAS), TFS
I joined a team on the HRFS project to be implementing throughout their businesses, handling all the lunar schedules for biweekly and the monthly payrolls. This is achieved using the SAP Success Factors application and fixing few ETL Issues. I achieved success by engagement workshops for their required features in their reporting dashboards.
Sql, SAP, ETL, Ssis, Workshops, TFS, Analyst, SSAS, BEE, SSDT
2012 - 2013
job
BI Analyst
JD Wetherspoon.
Job Type: Contract 1 extensions
Tools: BIDS-2008 & 2010, SSIS, SSRS & SSAS, N-Software SFTP SSIS controls
Along with requirements I also improved query performance on the existing cube. Completed Data migration project of legacy applications based in Paradox and access to the SQL server 2008 R2. SSIS. Developed SFTP data transfer to Public Sector clients as such (NEST).
Tools: BIDS-2008 & 2010, SSIS, SSRS & SSAS, N-Software SFTP SSIS controls
Along with requirements I also improved query performance on the existing cube. Completed Data migration project of legacy applications based in Paradox and access to the SQL server 2008 R2. SSIS. Developed SFTP data transfer to Public Sector clients as such (NEST).
Sql, SQL Server, Ssis, SSRS, Analyst, SSAS, Software, BEE, Public sector, Server, Sql server 2008, Sftp
2012 - 2012
job
Senior BI Analyst
Carnival UK Group.
Job Type: Contract 2 extensions
Tools: BIDS-2008 & 2010, SSIS, SSRS & SSAS, Pragmatics Bi Xpress.
I was only hired for 6 weeks' for niche SSIS activity. With further extensions I worked on an agile project of CDW. Developed ETL using SSIS; Develop the SSAS Cubes to the design using SSAS.I regularly contributed and communicated in daily stand-ups in scrum discussing our progress on the stories handled, challenges and success during the day.
Tools: BIDS-2008 & 2010, SSIS, SSRS & SSAS, Pragmatics Bi Xpress.
I was only hired for 6 weeks' for niche SSIS activity. With further extensions I worked on an agile project of CDW. Developed ETL using SSIS; Develop the SSAS Cubes to the design using SSAS.I regularly contributed and communicated in daily stand-ups in scrum discussing our progress on the stories handled, challenges and success during the day.
Design, Scrum, Agile, ETL, Ssis, SSRS, Analyst, SSAS, BEE
2012 - 2012
job
Senior BI & Data Architect
KPMG.
Job Type: Contract
Tools: Erwin DM (Data Modeler) and Data profiler, SQL Server 2008, BIDS-2008 (MS-BI Stack), BIDs-Helper. Worked within an Agile team; contributing daily standups & scrum ceremonies. I re-designed the ETL architecture of a PPI project from the earlier POC developed. I developed the data checks & governance routines. I successfully implemented the process-driven (hashing/data masking) for sensitive data.
Tools: Erwin DM (Data Modeler) and Data profiler, SQL Server 2008, BIDS-2008 (MS-BI Stack), BIDs-Helper. Worked within an Agile team; contributing daily standups & scrum ceremonies. I re-designed the ETL architecture of a PPI project from the earlier POC developed. I developed the data checks & governance routines. I successfully implemented the process-driven (hashing/data masking) for sensitive data.
Sql, Scrum, SQL Server, Agile, ETL, Architecture, BEE, Server, Sql server 2008, MS-BI
2011 - 2011
freelance
SQL Consultant (MS BI Expert)
Japan Tobacco Inc.
Job Type: Contract 2 extensions
Tools: SQL Server 2005 & 2008, BIDS-2008, BIDs-Helper, SSIS, SSRS (Report Designer 3.0) & SSAS (MDX, XMLA & DMX). I worked on the Siebel replacement project & an Integration of legacy EPOS for JTI Gallaher. I have been instrumental in addressing issues within EPOS data. I developed SSIS packages to migrate the periodic sales transactions from EPOS to Seibel
Tools: SQL Server 2005 & 2008, BIDS-2008, BIDs-Helper, SSIS, SSRS (Report Designer 3.0) & SSAS (MDX, XMLA & DMX). I worked on the Siebel replacement project & an Integration of legacy EPOS for JTI Gallaher. I have been instrumental in addressing issues within EPOS data. I developed SSIS packages to migrate the periodic sales transactions from EPOS to Seibel
Sql, SQL Server, Integration, Sales, Ssis, SSRS, SSAS, BEE, Server, MDX, SQL Server 2005
2011 - 2011
job
Specialist Developer
Virgin Media.
Designed & developing a weekly download SSIS Package to capture the information from the media's HFC (Hardware) network and load it to the data warehouse for further analysis by business using SSAS Cube. Performed the basket analysis Using decision tree & Time series to predict & forecasts the sales
Data Warehouse, Sales, Network, Ssis, It, Developer, Hardware, SSAS
2008 - 2010
job
Analyst Developer & BI Developer
Royal Bank Of Scotland.
Job Type: Contract Several Extensions
Tools: SharePoint Site Designer, SSRS, SSIS & SSAS & Dundas Suite.
I worked as a part of a back-office IT team: A complete agile environment, with daily stand-ups and task assignments. Day end Scrums to assessing the achievements on the stories handled during the day.
Tools: SharePoint Site Designer, SSRS, SSIS & SSAS & Dundas Suite.
I worked as a part of a back-office IT team: A complete agile environment, with daily stand-ups and task assignments. Day end Scrums to assessing the achievements on the stories handled during the day.
SharePoint, Agile, Ssis, SSRS, It, Developer, Analyst, SSAS, Office, BEE
2007 - 2007
job
SQL Specialist Developer
Department of Health & NHS PASA.
Job Type: Contract 1 Extension
* Tools: Visual studio 2005 (Integration, Reporting & Analysis Service Package), SSMS of SQL Server 2005.
* RAD Applications & Third-Party Components: Red Gate tool belt. Component one's C1 Web Grid.
* Tools: Visual studio 2005 (Integration, Reporting & Analysis Service Package), SSMS of SQL Server 2005.
* RAD Applications & Third-Party Components: Red Gate tool belt. Component one's C1 Web Grid.
Sql, SQL Server, Visual Studio, Integration, Service, Developer, Server, Web, SQL Server 2005
2006 - 2007
job
SQL & VB.net (Asp) Developer
Balfour Beatty Rail.
Job Type: Contract 1 Extension
Tools: MS Bids (Integration Service project), ASP.net (with 1.1 & 2.0 framework) using VB .net, Ado.net in the data connection layer, SQL Server 2005 DB. We followed agile development methodology.
Tools: MS Bids (Integration Service project), ASP.net (with 1.1 & 2.0 framework) using VB .net, Ado.net in the data connection layer, SQL Server 2005 DB. We followed agile development methodology.
ASP, SQL Server 2005, Framework, Vb, Server, Development, Developer, Net, Service, Sql, Integration, Vb.net, Agile, Agile development, ASP.NET, SQL Server, .Net
2006 - 2006
job
VB.Net -SQL Specialist
Ingeus Group.
Job Type: Contract 2 Extensions
SQL Server 2005 (UDF's, database triggers, stored procedures & SQL Agent jobs); VB.Net - Remoting.
SQL Server 2005 (UDF's, database triggers, stored procedures & SQL Agent jobs); VB.Net - Remoting.
Sql, .Net, SQL Server, Database, Vb.net, Net, Stored procedures, Server, Vb, Agent, SQL Server 2005
2005 - 2006
job
Web App & SQL Specialist
Bank of Ireland First Currency Services.
Job Type: Contract 2 Extensions
Sql, App, Web
2005 - 2005
job
Technical Analyst / Designer
Gordon & Gotch Publishing Ltd.
Worked as a contractor using VB.net and SQL Server 2000, Crystal reports for reports.
Sql, .Net, SQL Server, Vb.net, Net, Analyst, Server, Vb
2002 - 2004
freelance
Application Support Consultant
Xyvision Enterprise Solutions Europe Ltd.
Job Type: Contract to Permanent
Support
2001 - 2001
job
Senior Software Engineer
Datamatics Ltd.
Tools: Visual basic 6 & SQL Server 2000, MS Source Safe, XML, XPATH.
Sql, SQL Server, XML, Safe, Software, Server, Basic, XPath
2000 - 2001
job
Team Leader & Senior Software Engineer
Access Information Systems.
Using VB6, SQL Server 7.0, MTS, MSMQ, Sheridan Controls, Crystal reports 7.0, Visual Source Safe.
Sql, SQL Server, Safe, Software, Server
1998 - 2000
job
Analyst Programmer
Safari Motors.
Using Visual Basic 4 and VB 5, SQL Server 6.5 & 7, Access & VBA.
Sql, SQL Server, VBA, Analyst, Server, Vb, Basic
1997 - 1998
job
R&D Programmer
unknown.
Using Visual Basic 5 & SQL Server 6.5 worked on BOT, STAR 2000, Implemented a proprietary protocol rs232 using Winsock 2.
Sql, SQL Server, R, Server, Basic
My education
1994
-
1997
Mumbai University
BSc, Physics
BSc, Physics
Sandesh's reviews
Sandesh has not received any reviews on Worksome.
Contact Sandesh Kadam
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Sandesh directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark