Subhomoy Saha
Hyderabad
Summary
Experienced Business Analyst with 11+ years of experience in boosting warehouse profitability for Wells Fargo, the world's fifth largest bank Skilled in Solution Definition and Design, Requirements Gathering and Analysis, Source System Analysis, Data Profiling, Data Analysis, Data Curation, and Data Migration activities Worked in various industries including Telecom (Verizon), Healthcare (GSK), Consumer Electronics (Apple Inc.), and Fintech (JP Morgan & Chase). Proficient in gathering requirements, conducting requirement analysis, and attending JAD meetings with business stakeholders Extensive experience with Informatica 10.1 HF2, Teradata 14.0, Hive, Tableau, and GCP Big Query Strong expertise in Requirement Gathering, Analysis, Design, Development, and Implementation of ETL processes using Teradata utilities like TPT, BTEQ, FLOAD, and MLOAD Received 8 Recognition Awards from Verizon's AI&D org. Vice President, and Director, for outstanding contributions and achievements Keen Analyst with exceptional background in utilizing data from diverse information systems and performing analysis of large data sets to remarkably improve organizational decision-making capabilities Capability to deliver insights & make recommendations for significant improvement in business process, SLA, quality, customer service, cost Experience in mapping business requirements, designing customized solutions with strong analytical skills; strong exposure in analyzing business practices and defining optimal procedures Expertise in business process analysis (As-Is, To-Be), preparing functional specifications, business blueprint document, analyzing the gaps and preparing functional test cases
Overview
11
11
years of professional experience
Work History
Senior Lead Analytics Consultant (Band:P5)
Wells Fargo
Hyderabad
05.2024 - Current
- Managing a team of 15 Business Analysts and Product Owners to deliver analytics solution of tangible value for the bank and improving the overall customer experience
- Designing and developing multiple curated data products with Conflict of Interest, Loudspeaker and Allegation data
- Supporting the Development Team during System Integration Testing (SIT) and assisting the business team during User Acceptance Testing (UAT)
- Implemented a SAS automation which mitigates access dependency to the restricted databases
- Created Unix shell scripts incorporating SAS ETL for seamless data ingestion using SCD Type 1 and Type 2 logic
- Developed Physical Data Models (PDM), Logical Data Models (LDM), and Conceptual Data Models (CDM) regarding the allegations data
- Developed Digital Twin of HR employees
Sr. Business Analyst
Verizon
Hyderabad
12.2019 - 05.2024
- Managing end-to-end POD ownership of critical projects such as 5G, 4G LTE, Entertainment Hub, Audience Interface Management, and more; ownership includes creating end-to-end designs, conducting impact analysis, and mapping documents using Teradata and GCP BigQuery
- Supporting the Development Team during System Integration Testing (SIT) and assisting the business team during User Acceptance Testing (UAT)
- Providing 2 months of warranty support after the code goes into production
- Designing and developing multiple curated data products, including Customer Journey, Promo Trade-In, E2E Promo Activity, and Customer Digital Twin(s)
- Evaluating the consistency and importance of various business intelligence data to determine optimal courses of action
- Developing Tableau dashboards focusing on metrics such as Gross Adds vs
- Net Adds for Verizon Business Group, Profit vs
- Sales for Verizon Consumer 5G products, and other relevant analytics
- Offering subject matter expertise (SME) consultation on the 2PB warehouse data to data scientists and the business
- Facilitating recruitment of new team members for the Business Analysis Team to support division growth and foster a strong and productive department
- Defined subject areas and taxonomy for 3000+ data warehouse tables
- Provided curated datasets to B2B partners such as MasterCard and McKinsey & Company, which were utilized in their AI models to evaluate the effectiveness of marketing campaigns and customer behavioral analysis; these initiatives contributed approximately $20 million in revenue in 2021, with a projected amount of around $75 million by the end of 2023
Business Analyst
Cognizant
Hyderabad
06.2018 - 12.2019
- Collaborated with JP Morgan & Chase as a Business Analyst, contributing to Cognizant's revenue growth
- Played a pivotal role in the end-to-end ownership of ingesting mortgage loan origination system files from Black Knight, which was outsourced by Chase
- Utilized Informatica, Unix, and Teradata for file ingestion from the Black Knight file system
- Conducted meetings with the Chase business team to gather requirements and understand business use cases for reporting purposes
- Designed curated data sets, focusing on loans and mortgage data
- Developed Physical Data Models (PDM), Logical Data Models (LDM), and Conceptual Data Models (CDM) by establishing the Loan: Borrower relationship
- Created Unix shell scripts incorporating BTEQ for seamless data ingestion
- Proactively engaged with stakeholders to foster strong business relationships and support mutually beneficial interests
Business Analyst
Exilant Technologies
Bhubaneswar
07.2017 - 06.2018
- Worked as a Junior Business Analyst and Developer for Apple Inc
- Collaborated with the Tax Team to calculate taxes for iTunes services in Middle Eastern Countries used by customers
- Played a key role in understanding the business logic by analyzing Informatica mappings
- Executed Informatica workflow to successfully load data into the target system
- Conducted unit testing for Informatica objects, ensuring technical and functional requirements were met
- Analyzed, designed, developed, and implemented ETL processes using Teradata utilities such as TPT, BTEQ, FLOAD, and MLOAD
- Acquired in-depth knowledge of Teradata Architecture, SQL, BTEQ, TPT, Fastload, and Multiload
- Conducted Teradata SQL performance tuning to optimize query performance
- Developed Unix shell scripts to automate and streamline data processing tasks
- Provided daily and weekly status reports to keep stakeholders informed
Developer
Tech Mahindra
Bhubaneswar
01.2014 - 06.2017
- Collaborated with Business Analysts to understand and analyze business requirements, ensuring accuracy and completeness
- Prepared Informatica mappings and workflow, exploring business logic within the mappings
- Executed Informatica workflow to load data into the target system and performed unit testing to validate technical and functional requirements
- Developed Unix shell scripts to streamline data processing tasks
- Analyzed source and target systems, mapping data as per functional requirements
- Provided accurate estimates for test conditions, planning, and execution efforts based on business requirements
- Advised and guided client staff on test strategy, planning, data strategy, execution, and defect management
- Coordinated deliverables from team members, review of test cases, SQL queries, test results, and defects
- Ensured data accuracy by writing complex queries to validate the data during the source-to-target loading process
- Managed test data from various source systems and implemented data reconciliation to verify accurate data loading
- Utilized HP-ALM for creating and documenting test plans, test cases, and expected results
- Compiled test metrics for management and provided status reports on a daily/ weekly basis
- Conducted defect triage meetings with Development, Business, and Project Management Teams to prioritize and resolve defects in a timely manner
- Maintained a traceability matrix to track requirements and ensure complete test coverage
- Coordinated offshore and onsite activities to facilitate smooth project execution
Education
Bachelor of Technology - Information Technology
West Bengal University of Technology
Kolkata01.2013
Skills
- Business Operational Excellence
- ETL
- Data Visualization
- Data Modeling
- Requirement Gathering
- Statistical Analysis
- Business Analysis
- Business Intelligence
- Data Profiling
- Data Analysis
- Data Curation
- Data Migration
- Solution Definition and Design
- Requirements Gathering & Analysis
- Source System Analysis
- Teradata 140
- Hive
- GCP Big Query
- Teradata Architecture
- SQL
- SAS (Beginner)
- ETL Processes using Teradata Utilities (TPT, BTEQ, FLOAD, MLOAD)
- Informatica 101 HF2
- Informatica Mappings and Workflow
- Tableau
- Unix Shell Scripting
- HP-ALM (Application Lifecycle Management)
Languages
- English
- Hindi
- Bengali
Personal Information
Date of Birth: 05/21/90
Timeline
Senior Lead Analytics Consultant (Band:P5)
Wells Fargo
05.2024 - Current
Sr. Business Analyst
Verizon
12.2019 - 05.2024
Business Analyst
Cognizant
06.2018 - 12.2019
Business Analyst
Exilant Technologies
07.2017 - 06.2018
Developer
Tech Mahindra
01.2014 - 06.2017
Bachelor of Technology - Information Technology
West Bengal University of Technology
Similar Profiles
PATRICIA M. SCHERERPATRICIA M. SCHERER
Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors
Andrew S. HollenbachAndrew S. Hollenbach
Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Prakash GadhamsettyPrakash Gadhamsetty
Assistant Consultant at Tata consultancy services limitedAssistant Consultant at Tata consultancy services limited