Summary
Overview
Work History
Education
Skills
Key Professional Achievements
Certification
Languages
Timeline
ProjectManager
SANDEEP SINGH

SANDEEP SINGH

Technical Business Data Analayst
Reading,ENG

Summary

Data specialist with over 18 years of experience in data-centric roles. Recent experience as a Technical Business Data Analyst, excelling in stakeholder engagement and the development of robust data solutions. Demonstrated success in delivering accurate data tables and reporting while maintaining data integrity, with expertise in SQL, data analysis, and user acceptance testing. Aims to enhance data quality and improve operational efficiencies.

Overview

18
18
years of professional experience
5
5

Professional Certifications

Work History

Business Data Analyst

DataMatics | Sugansa
08.2021 - Current
  • Led requirement elicitation and prioritization for various use cases within data transformation Programme.
  • Managed end-to-end data flow from legacy platforms to Azure Synapse efficiently.
  • Conducted data profiling to evaluate extraction types and ingestion frequency accurately.
  • Collaborated with Data Engineering Team to design data models consistent with enterprise architecture.
  • Coordinated submission of data requests to ingest relevant information for data pipelines.
  • Executed comprehensive data validations and reconciliations to ensure high-quality standards.
  • Supported Data Governance teams in defining robust data quality and security rules.
  • Facilitated user acceptance testing sessions with business users to confirm data movement compliance.

Lead – Data & Reporting

Tech Mahindra UK Ltd.
09.2017 - 08.2021
  • Directed the technical operations team to ensure end-to-end business operations for over 250 ETL processes and 1,000 reports.
  • Enhanced reporting capabilities through the implementation of SAS EG, Talend Data Integration, SQL, and MS Excel dashboards.
  • Managed onshore and offshore engineers to optimize data and reporting solution performance.
  • Conducting POCs with vendors and acted as a subject matter expert for transformations and migrations.

Data Engineer/Analyst (SAS)

Multiple Clients over the Years
06.2014 - 08.2017
  • Supported existing and designed new reporting solutions, leveraging SAS Enterprise Guide, SAS Management Console, and IBM Flow Manager.
  • Collaborated with stakeholders to define reporting and data requirements for Sales and Churn reporting.
  • Created data inputs to fulfil Ofcom regulatory requirements within established SLAs.
  • Performed data profiling and segmentation for customer models and predictive analysis using SQL and SAS programming.
  • Reviewed and created SOP documents for operational support and new reporting designs.
  • Led migration project from SAS 7.1 to SAS 9.3, ensuring minimal impact on existing data formats.

Data Migration Consultant/E2E Solution Designer

Tech Mahindra UK Ltd.
05.2010 - 05.2014
  • Designed and implemented technical ETL solutions for BSS and OSS data migration projects.
  • Configured UoM (Unit of Migration) concept to enhance migration strategies across systems.
  • Established business rules, data staging, and reconciliation processes within data entities.
  • Developed E2E migration workflows aligned with business requirements for source and target components.
  • Enhanced UDMF framework using custom PLSQL and Unix for effective data extraction and transformation.
  • Prepared functional and technical design documents detailing migration scope, risks, dependencies, and approaches.
  • Collaborated with SMEs to clarify field mappings from source to target systems for developers.
  • Created data load, rollback, and reconciliation methods through custom PLSQL and SQL across systems.

PLSQL Developer

CGI India
10.2008 - 05.2010
  • Supported applications built in Oracle Forms and Reports as a PL/SQL Developer to create and modify database programs, including procedures, triggers, and functions.
  • Developed and customized invoice printing using Red Titan and Steamserve.
  • Maintained database objects such as tables, indexes, constraints, views, and sequences.
  • Estimated, designed, and developed enhancements with coding and unit testing.
  • Provided support during integration and UAT testing phases of application development.

Support Analyst – Oracle Forms & Reports, PLSQL

ITC Infotech India Ltd.
06.2006 - 09.2008
  • Supported applications built in Oracle Forms and Reports as Support Analyst
  • Created and modified database programs, including procedures, triggers, and functions.
  • Maintained database objects such as tables, indexes, constraints, views, and sequences.
  • Reviewed tickets for customizations and resolved issues within existing modules.

Education

Certificate in Big Data Analytics for Business & Management -

FORE School of Management
New Delhi, USA
11.2018

Bachelor of Technology - Electrical Engineering

Motilal Nehru National Institute of Technology (MNNIT)
Allahabad, India
01.2006

Skills

  • Requirements gathering and analysis
  • Stakeholder engagement and management
  • Data discovery and profiling
  • Data migration and quality assurance
  • SQL programming and reporting
  • Data modeling and visualization
  • User acceptance testing
  • Basic Python programming
  • Business requirements documentation
  • Operations management and optimization
  • Agile methodologies and practices
  • Azure Data Factory expertise

Key Professional Achievements

  • Received multiple thank-you cards and a big thank-you card while working at the client location, Three, UK, for managing critical priorities
  • Received multiple Star Performer, PAT on the Back, and Cookies Awards for the individual contributor for various data migration projects while working for Tech Mahindra UK and Tech Mahindra, India
  • Received multiple appreciation notes and awards for delivering critical projects and meeting deadlines while working with CGI and ITC Infotech

Certification

  • Oracle Certified Associate (OCA) - Oracle 9i (2008): 1Z0-007 and 1Z0-147
  • Cloud Fundamentals Certified - AZ-900 & DP-900: Microsoft Azure & Data Fundamentals
  • Cloud ETL and DW implementation - AZ-203: Data Engineering on Microsoft Azure

Languages

Punjabi
First Language
English
Advanced (C1)
C1
Hindi
Advanced (C1)
C1

Timeline

Business Data Analyst

DataMatics | Sugansa
08.2021 - Current

Lead – Data & Reporting

Tech Mahindra UK Ltd.
09.2017 - 08.2021

Data Engineer/Analyst (SAS)

Multiple Clients over the Years
06.2014 - 08.2017

Data Migration Consultant/E2E Solution Designer

Tech Mahindra UK Ltd.
05.2010 - 05.2014

PLSQL Developer

CGI India
10.2008 - 05.2010

Support Analyst – Oracle Forms & Reports, PLSQL

ITC Infotech India Ltd.
06.2006 - 09.2008

Certificate in Big Data Analytics for Business & Management -

FORE School of Management

Bachelor of Technology - Electrical Engineering

Motilal Nehru National Institute of Technology (MNNIT)

Similar Profiles

CREATE PROFILE
SANDEEP SINGHTechnical Business Data Analayst