Dr.Stalin Mishra

(CSM/ Agile Coach)

(MCA, PhD h.c. in computer Science)

Email :adbecr@r.postjobfree.com,

Phone :, +65 93444903

Resume Summary

Last Position : Scrum Master/ Sr. Project Manager

Current Specialisation: IT/Computer - Software

Highest Education: Master's Degree in Computer Application

Years of Experiences : 12+ Years

Availability : Immediate

Technical Skill / Experience Summary

I have total 12+ years of experience in Agile Coach/Scrum Master, Project Management, Delivery, implementing and supporting IT/Software projects for various clients in cross functional working areas like Project Management, Delivery, PMO, Technology Integration, ETL, Data Migration and Data Warehousing in various domains such as Banking & Finance. Broad casting (Media), Insurance, Retail and Manufacturing industries. Directs project team and manages team conflicts. Efficiently identifies and solves project issues. Design and maintain technical and project documentation.

·Working with PM tools like TFS, SNOW, Change Point, SAP Fieldglass etc.

·Coaching, Mentoring, and Guiding dev team (different Agile topics)

·Training on Agile Concepts, helping dev team in writing specifications, user stories

·Helping management understand the need and importance of Agile Leadership

·a Training on Agile Concepts, helping dev team in writing specifications, user stories

·Lead Scrum Team as Agile coach/Scrum Master, Manage agreed scope against schedule and cost, change management, dependency and risks, Stakeholder management, Conflict resolution among team. Budget Management, Resource and Capability Management.

·Worked with Senior Management, Business & Release Management to understand the vision of the product, priorities and develop software release planning.

·Communicated the progress to senior management thru 'Burn-down Charts'. Monitored the Quality thru metrics and mentored team thru the project management processes.

·A time and cost keeper within set baseline to ensure project milestone is achieved.

·Reporting the status to management stakeholders on a regular basis.

·Reviewer for User Requirement (UR) and System Requirement Specification (SRS)

·Resource Management for assigned projects.

·Meeting Customer expectation in term of delivery and agreed schedule.

·Achieve Management objectives by ensuring assigned projects/CRs completed within budget and planned schedule.

·Prepare and plan for UAT executing test plan.

·Manage post implementation Support

·Conduct Appraisal/Performance Review

·Pre sales activities

Technology Experience

Software Tools

SAP BI/BW/ BO/BODI/BODS, Informatica Power center 8.6 (Designer, Workflow Manager, Monitor, Repository Manager), Toad, SQL Developer, WINSCP(FTP),. Unix, HPQC, Service Now, TFS

Domain Experience

Manufacturing. Retail, Banking & Finance. Broad casting (Media)

Database

Oracle, Vertica, SQL Server, Teradata

Project Management tools

MS Project, MS Word, Excel & Power Point.

Certification

Certified Scrum Master (CSM)

Education Summary

Degree

Institute

Major and Specialization

Year of Passing

Percentage

MCA (Master Degree)

Regional College of Management, BPUT, INDIA

Computer Application

2008

76.6

BCA (Graduation)

Utkal University, India

Computer Application

2004

60.0

Experience Profile – Key Projects

MAJOR ASSIGNMENTS (Current Organization):

Oct 2019 – till date

Organization

SGX Singapore

Project

Multiple projects

EP provider

Hyper Cube Consultancy

Environment

SAP BI Tools, SAP BODS, SQL SERVER

Role

SME SAP BODS

Sep 2018 – May 2019

Organization

Varite India

Project

Multiple projects

Client

Dell, Bangalore

Environment

SAP BI Tools, Non Sap BI tools

Role

Sr. Project Manager (Scrum/Kanban)

This assignement is all about managing the platform team of DELL. I was taking care of all end to end activities of BI tools team ( BOBJ, BODS, Power BI, SAS MA, MSAS, Tableau, Alteryx). We followed both Scrum and Kanban methodology.

As a Sr. Project Manager i was involved in -

Conducting daily scrum call, Change management and Recourse management, Project management activities.

Working for

Closely working with product owner to understand & gather priorities backlog items, Backlog grooming and sprint planning activities.

Coaching, Mentoring, and Guiding dev team (different Agile topics)

Training on Agile Concepts, helping dev team in writing specifications, user stories

Helping management understand the need and importance of Agile Leadership

Training on Agile Concepts, helping dev team in writing specifications, user stories

Reporting the various project level tracking status to management stakeholders on a regular basis.

Reviewer for User Requirement (UR) and System Requirement Specification (SRS)

Resource Management for assigned projects.

Working with PM tools like TFS, SNOW, Change Point, SAP Fieldglass etc.

MAJOR ASSIGNMENTS (Previous Organization):

Nov 2016- June 2017

Organization

Siftu Technology

Project

Track Road

Client

Trackroad.com

Environment

Android/ ios

Role

Sr. Project Manager

This is a Route optimizer and route planner mobile app project basically used in supply chain system. This product used for Planning smart routes to save fuel, time and money! Build optimized routes with thousands of stops and multiple vehicles.

Import stops from Excel/XML or add stops.

Build optimized route and automatically distribute loads evenly if more than one vehicle.

Export to Excel, XML or print route manifest.

Download route onto your mobile app.

Click Go for turn-by-turn navigation.

Track your fleet in real-time.

Walkie-talkie with people in your group.

June 2017 – Sep 2018

Organization

Siftu Technology

Project

PDB Data mart integration

Client

Petronas Dagangan Berhad, Malaysia

Environment

SAP BODS, SQL Server, SAP BW, SAP SD

Role

Project Manager (SCRUM )

This Project is all about Integration of 5 Applications to feed data into centralized Database for PETRONAS Dagangan Berhad using use cases methodology. It includes the daily extraction and historical data loading into the different data mart. The data retention for detail data to be 13 months.

Responsible for:

●Facilitating Daily scrum meetings, Backlog grooming, sprint planning, sprint review, and sprint retrospective.

●Working with Product owner On Artifacts Such as Product Backlog, Spring Backlog, Sprint Burn down, and Release Burn down.

●Radiate information and ensure that team's progress and successes are highly visible to all stakeholders, including the team itself.

●Encourage cross-team coordination, Remove impediments

●Maintain relevant metrics that help the team see how they are doing – Sprint Burn-down, Sprint Burn-up, Release Burn-down

●Coach and mentor other scrum masters in our product team. Ensure that our ways of working are consistent across the teams.

●Specialties:

- Coaching Agile Teams

- Training and starting up Scrum teams

- Culture change involvement

- Team Velocity improvements

- Adherence to Scrum best practices

- Distributed Scrum teams and Remote Scrum Teams

- Scrumming the Scrum

- Cross functional Scrum teams (Hardware and Software)

●Project management, project planning and estimation, handling project cost/budget, resource loading, sizing, project schedules and risk management.

AUG 2015 - OCT 2016

Organization:

iGate Global Solutions

Project:

SYBASE 2 ORACLE MIGRATION

Client:

Royal Bank of Canada Investor Services

Environment:

SAP BODS, Oracle 11g, Sybase IQ

Role:

PROJECT MANAGER and SCRUM MASTER

This Project is to work on the existing client application related to Risk and Finance and perform migration and enhancement with ETL and Reports.

Responsible for:

·Project management, project planning and estimation, handling project cost/budget, resource loading, sizing, project schedules and risk management.

·Developed and followed agile project management plan (Agile Ceremonies). Facilitated build requirements log (product backlog) with cost estimates and priority.

·Conducted Scrum Daily standup, Product backlog, Sprint Planning, Sprint Review & Sprint Retrospective meetings.

·Determined the team capacity (velocity) from historical data. Created Work Break down structure (user stories) and corresponding activities (tasks).

·Monitored the project progress and radiated the information to stake holders. Identified and mitigated team risks and impediments (Blocking Issues, Critical Defects) on daily basis.

·Requirements elicitation and gathering, Requirements Traceability and project metrics. Regular interaction with stakeholders to understand & improve the existing IT/SAP(ERP) infrastructure to define & implement the project governance frame work, establish & maintain project monitoring, measurement & delivery.

·Interaction with (IP) & ITIP top management on various project related issues and its resolutions & way forward.

·Preparation of IT budget & alignment with units.

·Managing expenditure like Capital & Operating expenses, prepare expenditure calendar.

·SPOC for SAP support vendor for issue assignment & resolution.

·Preparing design documents, code review, team management, resource planing etc.

·Expertise and experience in migration and reporting based project implementation(s) with technical exposure in BODS, Data Extraction, Data Transformations and Data Loading and ETL concepts.

·Knowledge and understanding of reporting on Business Objects (BO), Dashboards, Business Warehouse and Business Intelligence (BW/BI) and modeling concepts.

·Good knowledge on SQL and fundamental knowledge on HANA Database, DBMS, DB Queries, Joins and Sorting. Performed POC's on HANA

·Good understanding of User Interfaces, UML, Use Cases, Analyst role experience in framing Functional Specifications. Prior experience of Mainframes and End-to-End Testing.

·Worked directly with client & business end users being primary point of contact in onshore/offshore project models. Capable in handling new projects and have exposure to multiple platforms.

·Assisting fellow team members in troubleshooting issues and peer review

·Interacting with the onshore team and offshore team for getting the task completed and timely basis.

Project: CareFusion Malaysia (EPS)

Duration from May 2014 to July 2015

Carefusion, Malaysia

Project Description:

This project is for data migration from SAP and non-SAP sourced data to SQL server.

Role: Scrum Master/Agilest

Responsibilities:

·Conducted Scrum Daily standup, Product backlog, Sprint Planning, Sprint Review & Sprint Retrospective meetings.

·Determined the team capacity (velocity) from historical data. Created Work Break down structure (user stories) and corresponding activities (tasks).

·Monitored the project progress and radiated the information to stake holders. Identified and mitigated team risks and impediments (Blocking Issues, Critical Defects) on daily basis.

·Worked with Senior Management, Business & Release Management to understand the vision of the product, prioritize and develop software release planning.

·Project management, project planning and estimation, handling project cost/budget, resource loading, sizing, project schedules and risk management.

·Production support activities.

·Monitoring Data migration activities.

·Issue log maintenance and provide resolution

·Manage and Monitor post migration validation and troubleshoot.

·Worked on various report generation requirement

·Extensively worked with Carefusion USA team in various Bods related assignment.

·Overseen and manage BODS team and BW team in KL and India.

·Prepared knowledge transfer plan from US/INDIA/MALAYSIA BODS team

·Hiring and manage resources in MALAYSIA and India

·Manage, coordinate BODS support team in India to provide operation support and issues solving.

·Monitor and control resource workload. Develop resources allocation and project assignment plan.

·Assists in the definition of short- and long-term strategic plans

·Provides input into the talent planning process and remains actively involved in the identification and selection of talent both internally and externally

·Effectively communicates the vision and business need for change to others and maintains a positive perspective

Project: WISE SAP Implementation

Duration from Sep-2013 to Nov 2013

Wasco Energy Group of Companies, Kuala Lumpur, Malaysia

Project Description:

This project is for SAP ERP implementation (FICO, SD, PP, PS, QM, and MM) and Data migration purpose for the Oil and Gas sector of Wasco Energy Group. Migrate date from the existing system to the new enhanced system.

Role: Integration Manager (Delivery/ Project Management)

Responsibilities:

·Project Management and delivery.

·Cut-Over planning and activities.

·Monitoring Data migration activities.

·Issue log maintenance and provide resolution

·Manage Change Request (CRs)

·Manage and Monitor post migration validation and troubleshoot.

·Worked on various report generation requirement

·Extensively worked with both client’s PMO team and our functional/technical team to suggest the best solution as per the client’s requirement.

Project: FRS Integration (Insurance)

Duration from April-2013 to Sep-2013

Dana Jamin Nasional Berhad), Kuala Lumpur, Malaysia

Project Description:

This project is for integrating the financial analysis report to their SAP system. The scope of this project is to create, edit and approve the insurance policy. Integration of financial report to the current transactional SAP system for getting the financial data to perform maturity calculation, premium calculation, coupon calculation and reporting.

Role: Integration Manager (Delivery/ Project Management)

Responsibilities:

·Project Management and delivery.

·Modules involved –

Policy issuance

Premium calculation

Maturity and Coupon calculation

Customer Account Details

Premium discount etc

·Requirement gathering, Project planning, Project budgeting, and project costing.

·Resource planning and time line management.

·Manage Change Request (CRs)

·Prepare and plan for UAT executing test plan.

·Plan and coordinate with Team Lead on Implementation/Fallback Plan.

·Manage post implementation Support

·FRS integration to the sap system.

·Worked on various report generation requirement

·Extensively worked with both client’s finance team and our technical team to suggest the best solution as per the client’s requirement.

Project: GDC-Singapore (British American Tobacco)

Duration from Jan-2013 to April-2013

British American Tobacco (BAT), Kuala Lumpur Malaysia

Project Description:

This project is a global data center migration project. BAT has a date center in Singapore supported by a vender HP. This project is to migrate the date center along with all applications and data base from HP managed data center to T-System managed data center.

It’s a very complex and challenging data center migration project as we have number of SAP and non- SAP applications which has huge dependency with each other and have high business impact.

Roles: Technology Integration Manager (Project Management- SAP Systems)

Responsibilities:

·Project Management and delivery.

·Project planning, Project budgeting, project costing.

·Resource planning and time line management.

·Application migration requirement gathering, Application support management. DR planning and implementation.

·Worked and managed the data migration team.

·Extensively worked with solution centre and project management team to ensure the GDC migration happened properly.

·Vender Management.

·Migration planning documentation etc.

Project: EDW-ASTRO-HP

Duration from March-2012 to Jan 2013

ASTRO Malaysia

Project Description:

This project is for ASTRO Malaysia (Broadcasting and Media company), Scope of this Project is to develop a EDW for their end to end operation. They have a transactional system AMDOC with Oracle database. Our EDW is in Vertica Database. We extract data from the AMDOC system where the database is Oracle then we load all tables to a staging layer in Vertica database by using SAP BODS ETL tool, then after necessary data massaging and cleansing we loaded the date to the next layer Lookup, Dimension, Fact and Summary.

It’s a very critical enterprise data warehousing project with huge numbers of tables in each layers and having very complex business logic for data validation. Every day we need to extract date from source by using our BODS jobs and load the data to target tables in diff. diff. Layers of our EDW.

The Client Management use our EDW for report generation for various business requirement and analysis.

Roles: Project Lead (Development/Support/ Delivery/ Project Management)

Responsibilities:

·Manage ETL team

·Worked on ETL development and troubleshooting in SAP BODS.

·Worked on Production support and operation whereas my daily work is to extract data from AMDOC- Oracle source and load the data to Vertica database by using BODS jobs.

·Resolve ETL issues on priority based on tickets.

·ETL job enhancement and performance analysis of the jobs.

·Worked with flat file source.

·Worked on multiple transformations like Query, Case, Hierarchy_Flattening, Merge, Pivot (Columns to Rows), Reverse Pivot ( Rows to Columns), SQL etc.

·Use of Row_Generation, Date_Generation, Map_Operation, Map_CDC_Operation, Effective_Date, Validation Transform, Table_Comparison, History_Preserving, Key_Generation, XML_Pipeline, Address_Enhancement, Match_Merge

·Creating Interface design, Interface specific table in ORCLE and VERTICA database.

·Preparing ETL specific design document, Preparing Test case document and Operational Guide document etc.

Project: LOBLAW R2

Duration from July-2011 to Jan 2012

LobLaw Canada (Retail)

Project Description:

This project is for Loblaw Canada Retail management system, Scope of this Project is to Extract source date from SAPBW and after validating the date according to business logic load the data to Teradata landing table (Staging area) and then finally from Teradata Landing to Teradata core table by using ETL tool SAP BODI/BODS

Roles: Team Lead

Responsibilities:

·Worked on extraction data from oracle Database, SAP BW source date, flat source.

·Worked with flat file.

·Worked on multiple transformations like Query, Case, Hierarchy_Flattening, Merge, Pivot (Columns to Rows), Reverse Pivot ( Rows to Columns), SQL etc.

·Use of Row_Generation, Date_Generation, Map_Operation, Map_CDC_Operation, Effective_Date, Validation Transform, Table_Comparison, History_Preserving, Key_Generation, XML_Pipeline, Address_Enhancement, Match_Merge, Name_Parsing

·Creating Interface design, Interface specific error table

·Preparing IDD (Interface specific design document), Preparing unit test case document.

Project: Kenna Food Supplying

Duration from Aug-2010 to June 2011

Kenna Products Company

Project Description:

Project Description: This is Bangalore based food supplier receives transactional information from the Shopping marts located at several parts of India. All this information is moved in to 3 data marts through Informatica Power Center 8.6 into an Oracle database.

Roles : Team Member

Responsibilities:

·Worked on extraction data from oracle Database.

·Worked with flat file.

·Worked on multiple transformations like Source qualifier, Expression, Lookup, Stored procedure, Update strategy, Filter transformations etc.

·Stored procedure transformations are used as source preload and target post load.

·Lookup transformations to compare the source and target values and Update strategy transformations are used for Update or Delete the records.

Project: Legacy Powercenter -ISBAN

Duration from Aug-2009 to Aug-2010

ISBAN, UK

Project Description: Isban is part of the Technology and Operations division of the Santander Group. Isban develops software and provides system integration services, which are shared by the different companies in the Group. The project scope is to give administration support services to the client in informatica powercenter.

Roles : Team Member

Responsibilities:

·Use the Repository Manager to create, organize, and maintain the repository. Repository administration tasks include repository creation, folder creation and organization, and configuring permissions and privileges for users and groups.

·Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.

·Performed data cleansing and transformation using Informatica.

·Worked extensively with Designer tools like Source Analyzer, warehouse Designer, Transformation Developer, Mapping and Mapplet Designers.

·Created data mappings to extract data from different source files, transform the data using Filter, Update Strategy, Aggregator, Expression, Joiner Transformations and then loaded into data warehouse.

·Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.

·Used Update Strategy Transformation to update the Target Dimension tables, type2 updates where we insert the new record and update the old record in the target so we can track the changes in the future.

·Developed various mapplets that were then included into the mappings.

·Used Workflow Manager to read data from sources, and write data to target databases and manage sessions.

·Review of the mappings.

Project: Euro DWH

Duration from Feb-2009 to Aug-2009

Customer name: Target

This project is for sales management system, Scope of this Project is to capture the Sales and Marketing processes in data warehouse. This organization needs a data warehouse for lucrative decision making and analysis and to get information about overall sales and its growth, profit and loss analysis, branch wise analysis. Data from Operational Source System was extracted, transformed and loaded into data warehouse Using Informatica.

Role: Team Lead

Responsibilities :

·Worked on Informatica Designer Tool’s components – Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.

·Involved in the development of Informatica mappings and also tuned for better performance. In the Mappings most of the Transformations were used like the Source Qualifier, Expression, Filter, Aggregator, Look Up, Update, and joiner, Sequence Generator, Sorter, Rank and Router.

·Used Unconnected Look Ups with the combination of Update Strategy to implement Type 2 Warehouse.

·Lookup tables were implemented at the staging level for the faster response time of Lookups.

·Extensively used Informatica’s Workflow Manager & Workflow Monitor tools to Load data from MS SQL Server, Oracle OLTP sources into the Target Oracle 9i Data Ware House.

Project: Belron – Oracle implémentation & Support

Duration from Jul-2008 To Feb-2009

BELRON

Project Description: BELRON is the world's largest, dedicated, vehicle glass repair and replacement (VGRR) company operating in 28 countries world-wide. The Scope of the project is to Implement Finance, Distribution & Manufacturing, Asset Management system in Oracle.

Roles : Team Member

Responsibilities:

·Receipt (PO) conversion from legacy system to Oracle.

·Item & Item Category Conversion from legacy to Oracle.

·Supplier Data migration to Oracle.

·Development of various SQL Loader control files to load data.

·Development of various PL/SQL procedures to validate the Data coming from legacy systems.

·Development of various PL/SQL procedures to populate Base Tables using various Interface tables for populating and fetching relevant data.

Employment Summary

Organization

Role

Duration

Varite India

(Contract with Dell)

Sr. Project Manager

Sep 2018- May 2019

Shiftu Technology

Sr. Project Manager

Oct 2016 - Sep2018

Igate (Now Cap Gemini)

Technical Specialist

Aug 2015- Oct 2016

EPS Venture SDN BHD

Consultant

May 2014- July 2015

Stone-Apple (M) SDN BHD

Consultant/ Manager

March 2012 to Nov 2013

Accenture, India

Sr. Software Engineer

July 2011 to Jan 2012

Applied e Logic, India

Sr. Software Engineer

Jul-2008 to July 2011

Orissatour.com (Travel Portal)

Founder and Creative Director

June-2005 to July 2008

Geo Infotech, India

IT Analyst

June-2004 to June-2005

Personal Details

Date of Birth

23 April 1982

Nationality

Indian

Languages

·Fluent in English (Spoken and Written)

·Fluent in Hindi (Spoken/Written)

·Fluent in Panjabi and other Indian languages(Spoken)

·Beginner in Bhasha Malay

Passport Details

Name

Relationship

Passport Number

Place of Issue

Stalin Mishra

Self

K0866278

Kuala Lumpur, Malaysia

Contact this candidate