Navin Kumar Email & Phone Number

Canada

Markham, Ontario, Canada

• Interacting with business to gather requirements and to propose the effective and efficient design. • Daily stand up call to track daily progress as per agile framework• Weekly meeting with business and senior manager to have status of all issues, resolution and proposed solution.• Project tracking and reporting the project status to senior management and stakeholders.• Provide direction and motivation to the project team to ensure that the project is delivered within agreed scope, time and budget• Defining a procedure and process to ensure solution delivery.• Doing POC and proving the best solution as per business requirements.• Design and implement for DB2 data migration to API using Informatica BDM, Curl Script and datapower.• Design and implement daily transactions from API to different downstream using Informatica BDM, Curl Script and datapower.

Toronto, Canada Area

Trivendrum, India

Initial Learning Programme:This was the initial training after joining TCS.

California, United States

• Taken over multiple applications from another vendor and completed the smooth transition to develop a team of total 16 (1 onshore and 15 offshore).• Interacting with business to gather requirements and to propose the effective and efficient design. • Weekly meeting with business and senior manager to have status of all issues, resolution and proposed enhancement.• Reviewing system design, code and testing outcome.• Review and Implement effective design and code.• Interviewing resources to acquire/recruit best suitable project team.• Project tracking and reporting the project status to senior management and stakeholders.• Built and manages project teams of 16 associates in 24 * 7 delivery model.• Defining and implementing the best practices and standards to achieve a stable environment/application.• Implemented automated scripts for better monitoring different applications.• Accountable for all deployment activities for DEV, SIT, UAT and PROD environments.• Provided direction and motivation to the project team to ensure that the project is delivered within agreed scope, time and budget

Toronto, Ontario, Canada

• Defining a procedure and process to ensure solution delivery.• Creating a solution prototype to overcome performance issue in Tableau report with meeting reporting needs. • Analyzing technical and business requirements to propose the effective and efficient design. • Project tracking and reporting the project status to senior management and stakeholders.• Defining and implementing the best practices and standards to achieve a stable environment/application.• Proposed changes to design code and made sure to implement effective design and code• Doing POC and proving the best solution as per business requirements.• Optimizing SQL Queries for the Tableau report.

Toronto, Canada Area

• Taken over Fraud Applications from another vendor and completed the smooth transition to develop a team of total 9 (4 onshore and 5 offshore).• Interacting with business to gather requirements and to propose the effective and efficient design. • Weekly meeting with business and senior manager to have status of all issues, resolution and proposed enhancement.• Reviewed system design, code and testing outcome• Review and Implement effective design and code• Held interview sessions to acquire/recruit best suitable project team• Project tracking and reporting the project status to senior management and Stakeholders• Built and manages project teams of 9 associates in 24 * 7 delivery model• Defining and implementing the best practices and standards to achieve a stable environment/application

Toronto, Canada Area

EDH (Enterprise Data Hub):• Led and manage Enterprise Data Hub-EDH initiative for development, modelling and enhancement of Enterprise Data Hub in ETL Operations Environment for a Banking and Financial organisations.• Interacting with business to gather requirements and to propose the effective and efficient design. • Held project kick-off meetings to have all project team members on same page• Creating the Enterprise data hub to integrate all the source system data in the hub using BDE version and ingesting these data in the HIVE tables. • Reviewed system design, code and testing outcome• Proposed changes to design code and made sure to implement effective design and code• Held interview sessions to acquire/recruit best suitable project team• Project tracking and reporting the project status to senior management and Stakeholders• Accountable for all deployment activities for DEV, SIT, UAT and PROD environments.• Built and manages project teams of over 20 associates in 24 * 7 delivery and development model• Informed and escalated the issues to higher management if required which resulted in timely resolution of issues• Provided direction and motivation to the project team to ensure that the project is delivered within agreed scope, time and budget• Created and successfully implemented new process by identifying redundant activities during release and by appointing single point of contact for each release activity, thus reducing the effort on release activities.• Defining and implementing the best practices and standards to achieve a stable environment/application• Implemented multi technology/multi-platform application projects using Agile and traditional methodology

Toronto, Canada Area

BASEL III:• Leading a team of more than 50 including onshore-offshore for Analysis, Design and Development of the application based on the requirements.• Interacting with business to gather requirements and to propose the effective and efficient design. • Creating reusable code, like error logging and complex transformation to use in all the informatica workflows/ mappings. • Defining and implementing the best practices and standards to achieve a stable ETL environment/application• Importing/Creating source/target definition, creating the shared transformation like lookup, mapplets etc. in informatica• Developing Informatica maps from functional specifications and complete Unit testing• Analysis and coding of new programs using Informatica • Enhancement of Informatica Mappings, Performance Testing and Tuning• Creating various documents e.g. Application Design Document for the requirement, Component Design Document for the development, Unit test cases etc.• Code implementation in SIT, UAT & PROD environments• Managing onshore & offshore team• Code version maintenance using VSS• Job scheduling using Autosys• Creating design for Oracle Database package, procedure, fuction etc.• Informatica, Autosys and Database code review

Toronto, Canada Area

CSESS-Base Essential Support Team• Supporting application in PROD and managing offshore team• Working on production incidents• Opening incidents in Service Center• Working on new intakes on existing or new applications• Analysis, Design and Development of the application based on the requirements.• Defining and implementing the best practices and standards to achieve a stable ETL environment/application• Code version maintenance using SVN• Developing Informatica maps from functional specifications• Analysis and coding of new programs using Informatica • Enhancement of Informatica Mappings• Preparation of Unit Test Cases , Unit testing and System testing • Performance Testing and Tuning• Code implementation in UAT & PROD environment• Opening change tickets in Service Now

Toronto, Canada Area

WB Client Data Cleanup:• Analysis, Design and Development of the application based on the requirements.• Defining and implementing the best practices and standards to achieve a stable ETL environment/application• Code version maintenance using SVN• CRM Application using Salesforce.• Importing/Creating source/target definition, creating the shared transformation like lookup• Developing Informatica maps from functional specifications• Analysis and coding of new programs using Informatica • Enhancement of Informatica Mappings• Unit testing and System testing • Performance Testing and Tuning• Preparation of Unit Test Cases

Bhubaneshwar Area, India

• Understanding source code along with the business requirement to propose the effective and efficient design. • Importing/Creating source/target definition, creating the shared transformation like lookup, mapplets.• Developing Informatica maps from functional specifications• Analysis and coding of new programs using Informatica • Enhancement of Informatica Mappings based on POC results• Using different performance tuning techniques like Pushdown optimization, Multiload, Fastload etc• Unit testing and System testing • Performance turning of Informatica maps• Preparation of Unit Test Cases• Developing Teradata procedure

Bhubaneshwar Area, India

AMEX Data warehouse:• Requirement Capturing from business users• Importing/Creating source/target definition, crating the shared transformation like lookup• Developing Informatica maps from functional specifications• Analysis and coding of new programs using Informatica• Enhancement of codes/Informatica Mappings• Unit testing and System testing• Performance turning of Informatica maps

Bachelor Of Technology (B.Tech.), Electronics & Instrumentation Engineering, S (86%)

Activities and Societies: B. Tech.• Student Merit Scholarship from SASTRA for 2nd year. • 3rd prize in hardware contest (Automated Car.

Intermadiate Of Science, Mathematics, Physics, Chemistry

Activities and Societies: I. Sc.Intermediate o Science