Back to Search Results

ASHIS KUMAR M.

Technical Specialist - Data Engineer

Commitment
0/ 5
Competency
0/ 5
Reliability
0/ 5
  • Overall Experience: 23 Years  
  • Agile Software Development:
  • Amazon Relational Database Service:
  • Android:
  • Application Lifecycle Management:
  • Business Process Modeling:
+ More

ASHIS KUMAR M. 

Technical Specialist - Data Engineer

Commitment
0/5
Competency
0/5
Reliability
0/5

Time zones ready to work

  • New Delhi [UTC +5]
  • Dubai [UTC +4]
  • China (West) [UTC +6]
  • Singapore [UTC +7]
  • Hong Kong (East China) [UTC +8]

Willing to travel to client location: Yes  

About Me 

Highly efficient Technical Specialist & Data Engineer with over 18 years of hands-on expert technical experience in Data Migration, Data Integration, Data Analysis(Data P
Highly efficient Technical Specialist & Data Engineer with over 18 years of hands-on expert technical experience in Data Migration, Data Integration, Data Analysis(Data Profiling, Data Quality, Data Standardization, Data Governance), Data Architecture, Data Warehousing and Business Intelligence. Able to deliver management vision, goals, priorities, design principles, business drivers and operating policies in support of business goals of the organization. Extensive experience in full life cycle development including gathering business requirements, data profiling and analysis of source systems, design Data Strategies, design/develop Data Models, design/develop ETL solutions/specifications/mappings and so on.
Show More

Interview Videos

Signup to see videos

Risk-Free Trial, Pay Only If Satisfied.

Portfolios

Northern Trust SOM TA Program

Website Link:

Role:

  • Technically led the offshore ODC Data Mapping activities for Sprint 1-14
  • Developed ETL logical(Marklogic JSON Schema Event Payload) to physical(Oracle Staging Schema) data mapping for conformed dimensions, base facts and fact-less facts for Fund Utility and Investor Utility for S
  • Technically led the offshore ODC Data Mapping activities for Sprint 1-14
  • Developed ETL logical(Marklogic JSON Schema Event Payload) to physical(Oracle Staging Schema) data mapping for conformed dimensions, base facts and fact-less facts for Fund Utility and Investor Utility for SOM TA Data Mart
  • Guided and provided insights to the Modelling team for preparing LDM and Glossary Model
  • Provided recommendations to Test Lead in creation of User Acceptance Testing Strategy and Execution workflow
Show More

Skills: Python

Tools: ETL

HR unite Data Migration Program - ING Bank, NL

Website Link:

Role:

  • Technically led the client workshop sessions from offshore ODC for Wave 1B Phase P1 where the participating country was Australia
  • Actively participated in Requirement capture for the Data Migration program along with the onsite Business Analyst and Project teams
  • Perform
  • Technically led the client workshop sessions from offshore ODC for Wave 1B Phase P1 where the participating country was Australia
  • Actively participated in Requirement capture for the Data Migration program along with the onsite Business Analyst and Project teams
  • Performed Data profiling and Analysis of identified source data systems
  • Developed Conceptual and Physical Data Models
  • Defined Data Strategy (Security, Extraction/Staging, Retention, Archival, Data Quality, Cleansing/Removal) for Operational and Reference Data
  • Delivered DDL scripts for Physical DB creation
  • Provided Technical guidance in creation of ETL Mapping specifications for Converter and CVT tools for the Data Migration Program
  • Guided and provided insights to ODC ETL Development team for preparing Test Data, Unit Test Case for Wave 1B Phase P1
  • Provided recommendations to Test Lead in creation of User Acceptance Testing Strategy and Execution workflow
  • Recommended and enforced in reusing IBM ECA Automation Technology Asset "ETL Code Review" of this migration project
Show More

Skills:

Tools: Ibm datastage

Global Delivery Program-DQ, TD Bank, CA

Website Link:

Role:

  • Captured Data Quality business requirements through various brainstorming sessions and workshops with different LOBs and OCDO COE team
  • Analyzed sample masked production data from multiple LOBs (e.g. TD Securities, CAPP etc.) of TD Bank
  • Developed Data Quality Strategy, p
  • Captured Data Quality business requirements through various brainstorming sessions and workshops with different LOBs and OCDO COE team
  • Analyzed sample masked production data from multiple LOBs (e.g. TD Securities, CAPP etc.) of TD Bank
  • Developed Data Quality Strategy, principles and guidelines for the Global Delivery Program
  • On-boarded OCDO COE DQ Rule Offshore Development team along with Team Lead and offshore Delivery Manager
  • Technically led and mentored the DQ Development team towards Design, Development, Testing and Implementation of 6000+ DQ business rules for the whole program
  • Designed and developed complex DQ rules using IBM Information Analyzer 11.5
  • Prepared Data Quality reports and demonstrated them in front of OCDO (Office of Chief Data Officer) COE team
Show More

Skills: Data analytics

Tools: Information Analyzer

SCA-C Implementation (QS stream), Ford Motor Company, USA

Website Link:

Role:

  • Requirement capture and Scoping for SCA-C implementations (Rel 1.0) for NA region for Ford Motor Company, USA
  • Profiled and Analyzed source systems data and Developed Conceptual Data Model
  • Created DDL scripts for Physical tables creation for Landing and Staging areas for
  • Requirement capture and Scoping for SCA-C implementations (Rel 1.0) for NA region for Ford Motor Company, USA
  • Profiled and Analyzed source systems data and Developed Conceptual Data Model
  • Created DDL scripts for Physical tables creation for Landing and Staging areas for the Development team
  • Mentored and technically led Data Quality development using IBM InfoSphere QualityStage
  • Reviewed QualityStage codes and guided the Development Team lead in preparing efficient QS build strategies
  • Demonstrated QS tool capabilities to Ford Motor client team at Chennai for another potential QS implementation project for countries in Asia (CHINA, JAPAN, HONGKONG, THAILAND) and Helped the IBM team in successfully earning that project
Show More

Skills:

Tools: Quality Stage

Universal Customer Master Index (UCMI) System, Parkway Hospitals Pte Ltd, Singapore

Website Link:

Role:

  • Profiled and Analyzed 10 source systems (CMS, CAS, SAP, OHM, PCC, ENT, Cerner, Salesforce, DOBS, Volt1) and prepared Data Quality findings
  • Organized Design Workshops with participating Source Systems SME, Data Stewards, Parkway UCMI Management, Project and IT teams
  • Gath
  • Profiled and Analyzed 10 source systems (CMS, CAS, SAP, OHM, PCC, ENT, Cerner, Salesforce, DOBS, Volt1) and prepared Data Quality findings
  • Organized Design Workshops with participating Source Systems SME, Data Stewards, Parkway UCMI Management, Project and IT teams
  • Gathered business requirements for the proposed MDM solution for Parkway UCMI
  • Prepared Vision, Principles, Data Strategy and ETL solution for the program
  • Technical led and mentored ETL development team for Design, Development, Testing and Implementation for the Parkway UCMI solution
  • Responsible for managing scope, planning, tracking, change control aspects of the program along with the IBM Project Management team
Show More

Skills: Data Profiling

Tools: Information AnalyzerDatastage

+ More

Employment

Technical Specialist, Data Engineer

2005/03 -

Skills: IBM Data stageData QualityData analyticsETL(Extract, Transform, Load)

Your Role and Responsibilities:

  • ETL Lead Data Mapper
  • ETL Tech Lead
  • DQ Expert & IA SME
  • DQ Lead/QualityStage SME
  • ETL Designer/Tech Lead
  • ETL Lead Developer
  • ETL(Data Governance) Specialist
  • ETL Sen
  • ETL Lead Data Mapper
  • ETL Tech Lead
  • DQ Expert & IA SME
  • DQ Lead/QualityStage SME
  • ETL Designer/Tech Lead
  • ETL Lead Developer
  • ETL(Data Governance) Specialist
  • ETL Senior Consultant (IA & QS SME)
  • Senior System Analyst
Show More

ETL Tech Lead

2018/11 -

Skills: PythonDatastage

Your Role and Responsibilities:

Technically led the offshore ODC Data Mapping activities for Sprint 1, 2, 3 & 4Developed ETL logical(Marklogic Schema Event Payload) to physical(Oracle StagingSchema) data mapping for conformed dimensions, base facts and fact-less facts for FundUtility and Investor Utility for SOM TA Data MartWritt
Technically led the offshore ODC Data Mapping activities for Sprint 1, 2, 3 & 4Developed ETL logical(Marklogic Schema Event Payload) to physical(Oracle StagingSchema) data mapping for conformed dimensions, base facts and fact-less facts for FundUtility and Investor Utility for SOM TA Data MartWritten Python script for Logical to Physical entity-attribute mapping using Glossary filePeer reviewed data mapping documentsDelivered Logical to Physical mapping document for the Python(Metadata) andDataStage(ETL) teamDelivered DDL scripts for Physical DB creationProvided Technical guidance in creation of near real-time ETL jobs from the Mappingspecifications for the ProgramGuided and provided insights to the Modelling team for preparing LDM and Glossary ModelProvided recommendations to Test Lead in creation of User Acceptance Testing Strategy andExecution workflow
Show More

ETL Tech Lead

2018/03 - 2018/10

Skills: Data MigrationData ProfilingData analyticsData Quality

Your Role and Responsibilities:

Technically led the client workshop sessions from offshore ODC for Wave 1B Phase P1 wherethe participating country was AustraliaActively participated in Requirement capture for the Data Migration program along with theonsite Business Analyst and Project teamsPerformed Data profiling and Analysis of
Technically led the client workshop sessions from offshore ODC for Wave 1B Phase P1 wherethe participating country was AustraliaActively participated in Requirement capture for the Data Migration program along with theonsite Business Analyst and Project teamsPerformed Data profiling and Analysis of identified source data systemsDeveloped Conceptual and Physical Data ModelsDefined Data Strategy (Security, Extraction/Staging, Retention, Archival, Data Quality,Cleansing/Removal) for Operational and Reference DataDelivered DDL scripts for Physical DB creationProvided Technical guidance in creation of ETL Mapping specifications for Converter and CVTtools for the Data Migration ProgramGuided and provided insights to ODC ETL Development team for preparing Test Data, UnitTest Case for Wave 1B Phase P1Provided recommendations to Test Lead in creation of User Acceptance Testing Strategy andExecution workflowRecommended and enforced in reusing IBM ECA Automation Technology Asset ETL CodeReview of this migration project
Show More

DQ Expert & IA SME

2017/01 - 2018/02

Skills: Data Quality

Your Role and Responsibilities:

Captured Data Quality business requirements through various brainstorming sessions andworkshops with different LOBs and OCDO COE teamAnalyzed sample masked production data from multiple LOBs (e.g. TD Securities, CAPP etc.)of TD BankDeveloped Data Quality Strategy, principles and guidelines for the G
Captured Data Quality business requirements through various brainstorming sessions andworkshops with different LOBs and OCDO COE teamAnalyzed sample masked production data from multiple LOBs (e.g. TD Securities, CAPP etc.)of TD BankDeveloped Data Quality Strategy, principles and guidelines for the Global Delivery ProgramOn-boarded OCDO COE DQ Rule Offshore Development team along with Team Lead andoffshore Delivery ManagerTechnically led and mentored the DQ Development team towards Design, Development,Testing and Implementation of 6000+ DQ business rules for the whole programDesigned and developed complex DQ rules using IBM Information Analyzer 11.5Prepared Data Quality reports and demonstrated them in front of OCDO (Office of Chief DataOfficer) COE team
Show More

DQ Lead/QualityStage SME

2016/08 - 2016/12

Skills: Data Quality

Your Role and Responsibilities:

Requirement capture and Scoping for SCA-C implementations (Rel 1.0) for NA region for FordMotor Company, USAProfiled and Analyzed source systems data and Developed Conceptual Data ModelCreated DDL scripts for Physical tables creation for Landing and Staging areas for theDevelopment teamMentored and
Requirement capture and Scoping for SCA-C implementations (Rel 1.0) for NA region for FordMotor Company, USAProfiled and Analyzed source systems data and Developed Conceptual Data ModelCreated DDL scripts for Physical tables creation for Landing and Staging areas for theDevelopment teamMentored and technically led Data Quality development using IBM InfoSphere QualityStageReviewed QualityStage codes and guided the Development Team lead in preparing efficientQS build strategiesDemonstrated QS tool capabilities to Ford Motor client team at Chennai for another potentialQS implementation project for countries in Asia (CHINA, JAPAN, HONGKONG, THAILAND) andHelped the IBM team in successfully earning that project
Show More
+ More

Education

1990 - 1995

1995

1997

Skills

Agile Software Development Amazon Relational Database Service Android Application Lifecycle Management Big Data
+ More

Tools

Datastage Toad Anaconda Openshift

Certification

  • IBM Certified Solution Developer for IBM DataStage 7.5
  • IBM Certified Solution Developer for IBM QualityStage 8.5
  • IBM Certified Solution Developer for IBM Information Analyzer 8.5
  • Cognitive Class certification for Python for Data Science
  • Cognitive Class certification for Data Analysis with Python
  • Cognitive Class certification for Machine Learning with Python

Preferred Languages

English - Fluent Bengali - Fluent Hindi - Fluent