Post Job Free


Sign in

Project Manager Data Analyst

Thornhill, ON, Canada
January 31, 2024

Contact this candidate


** ********** ****, *******

Ontario, L*T *T*

Cell: +647-***-****


Soumita Deb


Soumita has 19+ years of extensive experience as Data Architect/Senior Business Solution Analyst/Senior Data Analyst/Technical Project Manager in Information technology, Data Analytics and business intelligence.

She is certified scrum master (2020, 2021), SAF e agile certified in 2022. PSM1 Certified in 2023. Under going PSPO certification for 2023 December.

She has completed certification on bigdata/Hadoop in 2018.

Strong knowledge in implementing end to end solution in banking domain, health care domain.

She has an outstanding knowledge and experience in ETL Data Warehouse (DWH) and data migration projects involving data extraction, data transformation and data load using Industry standard ETL tools like Infosphere Data Stage, Informatica, PySpark etc. Exposure on integrating ETL with different source systems like Kafka using Nifi.

She has very strong expertise in IBM Infosphere DataStage tool.

She has good understanding and technical knowledge on Informatica PowerCenter tool.

She has good experience in Bigdata and PySpark tools and gained extensive knowledge in Sas end to end migration projects.

Currently she has been working as a Technical Solution Designer in one of the leading banks in Toronto.

Engaged as Technical Solution Lead role for more than 12 years in various engagements. She has managed end to end deliveries in Data Warehouse and Data Migration Projects successfully.

She has demonstrated her expertise in designing DWH architecture, modeling and design methodology for different ETL end to end in multiple solutions.

She has become an SME in IBM Infosphere DataStage tool and now is part of Service Line Core technology group. She has got certifications in IBM DataStage.

She has good knowledge in Informatica Power Center. She has implemented EDW projects in Informatica ETL tool.

As a Technical Project lead, she has designed Enterprise Data Warehouse ETL architecture for different projects using IBM UDMH model, Banking Data Model and IBM Infosphere DataStage tool.

Has created ETL Accelerators and Prototypes using IBM Infosphere DataStage which are implemented across various Analytics projects in IBM.

She had developed a Dynamic Excel based Data Profiling Report using IBM Infosphere DataStage tool for Source Data Extraction, Data Analysis and Complex calculation on Legacy Data Distribution. The report was critically acclaimed at client places. This had given significant savings in cost for client.

As a Technical solution lead, she had been involved in resolution of different production incidents, analysis, design and deployment of various Change Requests, Configuration Management, Project estimation and Project management activities.

She had knowledge in Big Data, Analytics and developed application on IBM Bluemix platform.

She had worked as Onsite Development lead and ETL Architect in Denmark on behalf of ITC Infotech India Ltd.

Excellent applied technical and analytical skill, interpersonal skills, presentation skills, self-motivated, quick learner, team player. She is now mentor for other IBMers for the next Career Framework Level Readiness.

Soumita worked as an ETL Solution architect for St Mike Hospital, a leading Healthcare Service provider in Toronto. I have been involved directly in requirement gathering, solutioning, ETL designing and Implementation.

She has completed Bigdata certification from Simplilearn institute.

Skill Set


IBM InfoSphere DataStage(14+Years)

IBM InfoSphere Data Architect(2_years)

IBM InfoSphere Information Analyzer

Informatica PowerCenter 9.0.2(2+years)


Unified data model for Health care

Bigdata-Hadoop, Spark, Hive, Python (1+years)



Jira, Confluence


IBM Pure Data System for Analytics (2+Years)

IBM DB2 database(5+years)

Oracle 9i(5+years)

Oracle 8(5+years)

Oracle 10g(2+years)

SQL Server 2005(2+years)



Windows 2000 Server

Windows 98

Windows 7

Wndows XP





UNIX Shell Script




MS Office


Bachelor of Science in Physics, University of Calcutta

Masters in computer application, West Bengal University of Technology.


Oracle Apps




Ascential Datastage(7.5.2) Certification in 2006.

Banking Certification (Basics of banking) from IIBF in 2010.

IBM Infosphere DataStage (8.5) Certification in 2013.

Healthcare Domain Certification (IBM) in 2018.

Certified in Bigdata Hadoop and Spark from Simplilearn in 2018

Earned Silver Badge in Healthcare domain (2018).

Earned IBM badges in Bigdata Hadoop and Spark (2019).

Certified scrum master from Scrum Alliance (2020).

Certified in PSKI (2021).

Certified SAFe Agilist (2022).

Certified PSM1 (2023).

Professional Experience

Aug 2021 – Till date Delivery Lead/Senior Technical Solution Analyst TCS Canada

Aug 2021– Till date Technical Solution Designer Lead BMO- Toronto (Client)


Soumita currently managing two portfolios under BMO Credit risk applications, One is CECL (Current expected Credit Loss) as Business Analyst and delivery lead and CCBM(CC Basel Migration) project as Project manager.

Soumita has been working as BA -Technical Solution designer and Delivery lead in BMO- Credit Risk Management team implementing expected credit loss results repository ETL project. She is also performing Data architect role in the project.

She is involved in analyzing new requirements, converting into technical solution, designing solution, creating mapping documents for the development and QA teams.

She has been key points of contact from team to interact with the Business users.

She has been involved in multiple projects as Solution Designer as well as handling project management activities to ensure smooth delivery.

She is helping as a consultant for Bank of West acquisition of BMO to ingest the data into results repository.

She has been working as onsite delivery lead and as Project manager in the project and manage a mid-sized team of 20 resources

She has managed another project under Credit risk application- CCBM as a Technical project manager and helped the team successfully complete Release 4 and shaping the team for next R5 release.

She has received accolades from client. She has bee identified one of the core resources in Credit Risk platform.

Environment: SSIS,Netezza,unix

Team Size : 20

Oct 2020 – July 2021 Delivery Lead/ETL Architect TechMahindra

Oct 2020– Till date Onsite Dev Lead / ETL Architect Scotia Bank-Toronto(Client)


Soumita worked as solution architect and Datastage SME in Scotiabank.

She was involved in multiple projects as Senior ETL Consultant.

She worked as onsite development lead in the project to implement the “business banking” solution in ETL layer.

She has been involved in requirement gathering, designing the solution, writing mapping documents, performance tuning and overall management of solution design.

She has made considerable performance gain in ETL framework that benefits clients in terms of batch execution.

She was instrumental for successful Go Live of BBSL(Business banking service layer) project.

She received accolades from client for guiding the project till successful implementation.

Environment: Datastage(11.5), Oracle, Unix,nifi,bitbucket, PLSQL

Team Size : 15

March 2017 – Oct 2020 Data Management Specialist IBM Canada

July 2020– Oct-2020 Senior ETL Consultant /Data Architect Credit Union-Toronto(client)


Soumita worked as Lead Technical specialist in Credit union digital business application layer implementation project.

Credit union has taken an initiative to implement an application layer to integrate disparate source systems in one single layer that would deliver a centralized credit system application to other down stream application.

She worked as a development lead in the project to implement the solution in ETL layer.

She has been involved in designing the solution, writing mapping documents and over all management of code development of team.

She has designed and developed multiple common reusable components for lean design and better code management.

She has received accolades from client.

She helps team to perform work in agile method.

Environment: Datastage(11.7), Db2, Unix, Informatica Power center 9.0

Team Size : 12

February 2020– July 2020 Business Analyst/Team Lead TD Bank -SAS Migration Project-Toronto(client)


Soumita worked as Lead/ Analyst at TD bank-Sas migration project.

TD bank migration project is a very complex project migrating an existing SAS/Netezza application to TD bank Akora environment (PySpark/Hive). It has many challenges in converting SAS code to PySpark due to technical difference between two applications.

She worked as a business analyst, analyzing Sas code and converting it to ETL mapping document for the developers. She coordinated meeting with Business for requirement gathering.

She was involved in designing the solution, writing mapping documents and development of PySpark code.

She had performed team lead role in delivering end to end solution managing a team of 6 resources.

She received accolades from client for delivery with almost 0 defects.

Environment: PySpark,Hive (TD Akora environment)

Team Size : 15

Jan 2019– January 2020 Onsite Informatica SME/Onsite Lead CIBC Bank -DCP2 project-Toronto(client)


Soumita worked as onsite Informatica SME at CIBC DCP2 project.

CIBC DCP2 project is a complex project migrating an existing SAS application to Informatica. It had many challenges in converting SAS code to Informatica due to technical difference between two applications.

She successfully delivered high quality code converting complex Sas application to Informatica with minimum inputs from Business. She worked end to end creating mapping document, design documents.

She resolved many showstopper defects within minimum time frame.

She received client appreciation for making the solution successful.

Environment: Informatica Power center 9.0, Unix, Oracle 10g

Team Size : 30

Oct 2018 – Jan 2019, Onsite Lead Datastage SME Scotia Bank project-Toronto(client)


Soumita worked as onsite lead DataStage SME at Scotia Bank project.

She independently handled an extremely complex application to migrate data from SAS to Datastage.

IBM Software lab has confirmed the limitation of converting variable length binary Cobol file in Datatstage and she proposed an out of the box solution to convert the binary files using python script to make it usable in Datastage.

She received client appreciation for driving the end to end delivery successful.

Environment: DataStage 11, Unix, Hadoop

Team Size : 6

Achievements: Received appreciation email from client architect.

Appreciation email from GEO Solution architect.

March 2017 – Oct 2018, Onsite Tech Project Lead SMH DWH project-Toronto(client)


Soumita worked as Onsite Technical Solution Lead/Architect at SMH EDW project.

She worked from Toronto Location since March,2017 as Technical Lead. Prior to that she worked as offshore project lead managing a team of 8 resources.

She demonstrated her in depth understanding of IBM Unified Data Model for Healthcare, an industry data model developed by IBM to accelerate DWH/BI implementations; used the same to implement SMH clinical DWH.

She was responsible for analyze and understand business mapping and translate to ETL architecture design using IBM Inpfosphere Information Server suite and IBM Pure Data System for Analytics. More importantly she handles complex business rule transformation in ETL process flow.

Raised mapping /data issue during development and provide resolution to data modelling.

She provided solutioning in designing and building DWH accelerators using IBM proprietary tools like Ibm Infosphere datastge and IBM Pure Data System for Analytics.

She created generic accelerator development that can be used across other healthcare projects and that will reduce build effort.

She launched Healthcare Data service which is a one stop solution in healthcare ETL projects using IBM UDMH model, IBM Infosphere DataStage and Netezza.

Guided offshore team in ETL design, development and test planning and design.

She was responsible for Estimation, Development Plan Preparation, Work Stream Forecasting, Timely status reporting, and tracking of technical dependencies, risk and issues

Ensuring schedule and effort are tracked and monitored. In maintenance projects ensuring SLA objectives are met. In Dev projects milestone targets are met

She supported PM in Quality Audit, Product audit, assessments, PMR activities

Ensuring delivery metrics are met and submitted on time with zero delinquency as per DE process requirements

Set up a culture of knowledge sharing and teamwork within and outside the project team

Promoted new ideas / innovations and present it to the account leadership team / client to help win more work.

Compliance to all customer and IBM audit and assessment requirements"


Environment: DataStage 11, Unix, Netezza,SQL

Team Size : 12


Appreciation email from GEO Solution architect.

Has been nominated as an achiever in Canada Sector (2018)

Jan 2011 – March 2017, Data Management Specialist IBM India Pvt. Ltd. India

May 2016 – March 2017, Offshore Tech Project Lead SMH DWH project-Toronto


Soumita worked as Offshore Technical Solution Lead at SMH EDW project.

She worked as Technical Lead managing a team of 12 resources from offshore location.

She demonstrated her in depth understanding of IBM Unified Data Model for Healthcare, an industry data model developed by IBM to accelerate EDW/BI implementations; used the same to implement SMH clinical EDW.

She was responsible for analyze and understand business mapping and translate to ETL architecture design using IBM Infosphere Information Server suite and IBM Pure Data System for Analytics. More importantly she handles complex business rule transformation in ETL process flow.

She managed the application delivery so well that was recommended by client to work from onsite Toronto.

Environment: DataStage 11, Unix, Netezza

Team Size : 12

Achievements: Managers Choice Award in 2016.

Jan 2014 – May 2016, Data Quality Project Lead British American Tobacco


Worked as Data quality project lead and was responsible for providing data quality implementation solutioning using IBM Infosphere Datastage, Unix and IBM DB2.

Analyzed business requirement and provided effective ETL solution to Geo/client.

Responsible for end to end on time quality delivery for 2 different applications DQ and DSP applications, DSP tool was developed by IBM Germany and was supported by India GD team.The tool was made for source data template analysis. Managed the team so effectively that DSP work entirely transferred to India offshore team from GEO team.

Had created excel based Profiling Report using IBM Infosphere Datastage and IBM DB2 database that represented source data analysis as per client requirement and the report was accepted well and presented to IBM software team to implement the functionalities using IBM Infosphere Information Analyzer.

Had created accelerator using IBM DataStage that extract data from SAP systems and load into database using dynamic queries leveraging Datastage SAP packs functionality.

Had worked closely with SAP client team to establish a process to connect RTL landscape with SAP legacy system using IBM Infosphere DataStage SAP packs and this process is widely used for different Roll outs in SAP migration projects.

Had led team to develop an automated SQL script that compares table metadata mismatch across different schemas and databases.

Established automated email system to notify respective stake holders when Unix file system usage tends to reach it threshold limit.

Visited client place (London) for business meetings and requirement understanding.

Managed DQ team so effectively that client rolled off Romania DQ team and India GD team lead by her took over the applications.

Effectively managed a team size of 21 practitioners.

Proactively raised risk and issues to avoid future escalations.

Supported PM in audit, assessments, PMR activities.

Worked closely with PM for project budgeting and Lean activities.

Managed the offshore DQ and DSP team without any Onsite Geo lead and directly managed it with Client.

Developed an application in IBM Bluemix platform that integrated with Twitter applications.

Environment: DataStage 9,Unix,Oracle

Team Size : 21

Achievements: GD Excellence Award-2014

GBS Service Excellence Award-2015

Jan 11 – Dec 13 Technical Team Lead and Finance Track Lead IBM India Pvt. Ltd. India


Worked as a Technical Team Lead and Finance Track Lead in Blue Harmony Project.

Responsible to design and deliver conversion objects using IBM Infosphere DataStage,Unix and IBM DB2 database.

Provided efficient ETL design solution for complex Business requirements using IBM tool.

Single handedly managed 13 different most complex conversion objects in Finance domain in parallel.

Responsible for on time delivery of high-quality deliverables by adherence to the quality goals for the team by conducting and ensuring technical reviews of all deliverables.

Managed 12 resources very efficiently and reached Delivery Milestone as per the project plan for each and every conversion Items.

Assigned Development tasks to team member and ensure the completion of assigned tasks within time.

Performed complexity determination and estimation for development objects.

Participated in client workshops held at IBM Hyderabad.

Conducted root cause analysis when needed.

Conducted weekly status meeting with team.

Environment: IBM Infosphere Datastage V8.5.1, Unix, IBM DB2

Team Size-12

Achievements: GBS GD Excellence Award-2012

Mar 08 – Jan 11 Lead Consultant ITC Infotech Pvt Ltd

Danske Bank is the largest bank in Denmark and a leading player in the Scandinavian financial markets.

Their EDW is an end-to-end implementation.


Working as a module lead and ETL process Designer/Architect in BDWINTER project in Danske Bank.

Involved in understanding of requirements, Project planning and Estimation.

Design develop ETL solution for Enterprise EDW for Danske bank using IBM DataStage, oracle and Unix.

Deputed in Denmark for 9 months as onsite development lead and module lead as well,

Communication with Clients on requirement specification.

Delegation of work within the team.

Approver of all technical changes in the project.

Involved in high level designing.

Technical co-ordination.

Environment: IBM Infosphere DataStage 8.1,UNIX,SQL server2008, Informatica- PowerCenter 8.0,MS Reporting Service

Team Size-8

Achievements: Received Client appreciation emails from Danske Bank and ITC Service Delivery lead.

Received highest client points in annual resource review plan in 2009 and 2010.

Nov 06 – Feb 08 Application Programmer IBM India Private LTD


She worked as a module lead (Senior ETL developer) in PMI and managed the entire PMI Leaf Datawarehouse application.

She handled all the 3 technologies used in PMI like Accentual DataStage, MS Olap and Panorama Novaview.

She managed a team of size 3.

She was involved in Requirement analysis Designing, Developing, testing and post development support for PMI DWH.

She interacted with client to gather requirement, made Estimation and involved in project Planning.

She got client appreciation for her dedication and innovative work.

She was involved in recruitment drive, conducted training on DataStage for Graduate Hire.

Environment: DataStage 7.5.1,MS Olap, Informatica- Powercenter 8.0,Panorama Novaview

Team Size:3

Achievements: She received the “Sustain Star Awards” for her consistent performance in PMI

Jun 04 – Oct 06 Senior Software Engineer Accenture

I worked as a Senior Software Engineer and module lead for Metavante, a leading Application Service Provider in retail banking sector in USA.


Techno-functional analysis and detailed understanding of data warehousing solution and business flow of the same.

Worked with all the primary modules for ZIONS BankCorporation(comprising of BIC Customization) covering Loans, Deposits, G/L consumer banking packages and also Data Marts covering BillPay, Trusts.

Designed and Developed medium to very complex ETL jobs using IBM DataStage tool (server edition).

Designed and Developed medium to complex SQL statements for reporting purposes.

Developed Complex UNIX shell scripts for Bulk data load and Jobs scheduling, custom data stage routine for Time Dimension.

Involved in Testing & Post Development support for critical modules.

Undergone walk through sessions with client.

Independently handled M&I Trust Module for over 1 year. Involved in analysis, design, deployment and post development support for the same. Also contribute to the changed work requests analysis for the project.

And contribution to unit testing for all those work requests.

Involved in consultations and table changes for problems, questions and request issues related to application usage.

Conducted training for other projects on DataStage, SQL, PL/SQL.

Had been part of the team, which achieved the IDC Milestone for enabling Metavante to use Business Intelligence Centre for Zions Bank Corporation.

Environment:Ascential DataStage 7.0, Informatica- Powercenter 7.1, Oracle 9i and UNIX


Awarded “Super achiever” award in 2005.

Awarded “Super Trooper award” in 2006.

Awarded “Peer award” for valuable contribution in the project in 2005.


Contact this candidate