ASHIS KUMAR M.

Technical Specialist - Data Engineer

Kolkata , India

Experience: 18 Years

ASHIS KUMAR

Kolkata , India

Technical Specialist - Data Engineer

53136 USD / Year

Notice Period: Days

18 Years

Now you can Instantly Chat with ASHIS KUMAR!

Chat Now

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 Profiling, Data Quality, Data Standardization, Data Governance), Data Architectur...

Skills

Positions

Data Analysts

Data Scientist

Data Engineer

Portfolio Projects

Description

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 Show Less

Description

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 Show Less

Description

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 Show Less

Description

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 Show Less

Description

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 Show Less

Description

Gather requirement and prepared Solution Proposal document for GWBI(Global Wealth Business Intelligence) solution for integrating Insurance information and providing wealth data for Business analysis as part of HSBC Bordereaux program
Created Conceptual, Logical and Physical data models for Commission Data Mart for the GWBI solution from existing and new interfaces of the client
Co-authored Solution Architecture Design Document for ICM solution implementation for HSBC Bordereaux program along with Business Analyst
Designed Data Architecture, Data Integration Architecture, Analytics Layer Architecture including scope, design considerations, principles, proposed Infrastructure
Developed Solution Design Document for two major sub-systems (ETL and ICM Cognos)

Show More Show Less

Description

Designed “Cleansing and House Holding” process in the Integration Layer of the solution
Responsible for independently handling ETL design (macro and micro) and code using InfoSphere QualityStage
On-boarded and Mentored cross-location ETL (QualityStage) offshore development team
Developed and Delivered Householding process for TCCC CDS solution using InfoSphere QualityStage in response as per business requirements
Participated and guided the offshore team in SIT testing, preparation of AMS support documents and manuals and PMR reviews

Show More Show Less

Description

Responsible for independently performing Data Governance (DG) assessment for current-state Etihad Airways BI solution
Performed Gap Analysis for Etihad BI current maturity and expected maturity levels as per IBM Maturity model for Airline industry
Prepared and Delivered Data Governance Framework for Etihad airways BI solution
Designed and Delivered Etihad Airways Architecture Blueprint and High Level Design documents as per business requirements

Show More Show Less

Description

Responsible for technically leading client’s offshore development Data Governance team and providing SME support on InfoSphere QualityStage
Performed source system Profiling, Analysis and Data Quality Assessment for in-scope source systems for EIM Caterpillar
Designed and co-authored “Enterprise Customer management (ECM) - Gen1 and Gen2” solution for the client
Developed, tested and implemented “Enterprise Customer management (ECM) - Gen1 and Gen2” solution using complex QualityStage Standardization Rules for Australia, Canada, Germany, Spain, France, Great Britain, Italy, United States, Japan, China, Hong Kong
Participated in SIT testing for enhancing and customizations to the core solution

Show More Show Less

Description

Analysis, design, develop, testing and implementation of GCSS for MaerskLine
Responsible for independently handling development, enhancement, maintenance and support activities as part of GCSS technical team for the client in travel & transport industry.
Technically led GCSS Linux Migration team
Designed, Developed and Delivered high level and low level Design Documents as per stakeholder business requirements
Utilized in-depth knowledge of functional and Technical experience in Unix, C, C++ to deliver solutions to customer

Show More Show Less

Description

Analysis, design, develop, testing and implementation of PXEngine component of IBM InfoSphere
Analysis, design, develop, testing and implementation of DataStage component of IBM InfoSphere
Responsible for analysis, design, develop, testing and implementation of new development activities as well as support, enhancement and bug fixing activities with high quality and on-time
Design, develop and deliver high level and low level design documents
Utilized in-depth knowledge of functional and Technical experience in UNIX, C, C++ to deliver solutions

Show More Show Less