Santosh Kumar Email & Phone Number

Noida, Uttar Pradesh, India

Noida, Uttar Pradesh, India

Working for Client ZS Associates. Developing Conceptual, Logical and Physical data model for integrated data warehouse for Innova care to store Health care Data set.

Noida, Uttar Pradesh, India

Define and deliver data strategy and develop concept, data models, data architecture diagrams including current, Interim and Target State.Define best practices for data loading and extraction and ensure architectural alignment of design and developement.Driving innovations by keeping current and emerging technologies and data trends such as big data, nosql, data services and API.Collaborate with different stakeholders, address data related problems in regards to systems integration and compatibility.Developing conceptual, logical and Physical Data models within the context of the Enterprise and Line of Business Information Architecture.

Noida, Uttar Pradesh, India

Noida Area, India

• Developed data models within the context of Enterprise and Line of Business Information Architecture.• Fully defined and enforced standards for data modeling, SQL queries, T-SQL standards, new database creation, and capacity planning.• Led a team of architects and engineers to build data ingestion pipelines, data stores, and platform components.• Led proof-of-concept projects, driving innovation and validating technical approaches.• Defined and delivered data strategy, including the development of conceptual, logical, and physical data models, as well as architecture diagrams for current, interim, and target states.• Collaborated with stakeholders to address data-related challenges, focusing on systems integration and compatibility.• Conducted data model and SQL performance reviews to optimize and ensure adherence to best practices.• Provided architecture reviews for new and existing solutions, ensuring scalability and efficiency.

Gurugram, Haryana, India

• Led data modeling projects for major banks including CITI Bank, Barclays Bank, and RBS Bank.• Led data modeling initiatives for CitiDirect’s global e-business platform, integrating various banking services.• led database performance optimization projects, significantly improving query performance and reducing migration times.• Created and reviewed various database objects, including tables, views, synonyms, indexes, and sequences.• Conducted a feasibility study and migrated existing reports to SAP BusinessObjects.• Led the migration of customer data from legacy applications (BIB & BM2) to the Phoenix cash management platform, facilitating a seamless ‘like-for-like’ migration for corporate banking.• Created the migration plan and data mapping documents, ensuring smooth data flow between legacy systems and the new platform.• Designed and implemented ETL solutions to extract, transform, and load data accurately.• Conducted feasibility studies and defined the data flow for the migration process.• Ensured the integrity of data loads and addressed any load errors.

Gurugram, Haryana, India

Chennai, Tamil Nadu, India

Ncr

Key Clients: Capital One USA, Owens & Minors USA• Designed and developed physical databases and optimized database performance through efficient query writing, indexing, and data migration strategies.• Collaborated with cross-functional teams to gather and define new requirements, ensuring alignment with business needs.

Ncr

• Designed and developed physical databases, including the creation of complex procedures, views, and functions to support application functionality and performance.• Managed change requests by conducting thorough analysis, followed by the design and development of database objects to meet evolving requirements.

Postgraduate Certificate Program, Data Science And Machine Learning

Activities and Societies: Certificate specialization course in Data science and Machine Learning

Mca (B Level), Computer Software Engineering