Summary

Overview

Work History

Education

Skills

Accomplishments

Certification

Additional Information

Affiliations

Software

Author of "World of Business with Data and Analytics" - 'Investor Behavior Towards Mutual Fund'

Timeline

Devamrita Biswas

Senior Business Analyst

Kolkata

Summary

Perceptive Senior Business Analyst,Techno-functional consultant with 7 years driving successful business processes & leading the implementation of customized IT solutions for complex business problems; working closely with executive management and teams at all levels. Dedicated to maximizing impact of key performance metrics to enhance and expand business operations. Known for leveraging both macro and micro-scale analyses to generate holistic images of ongoing business operations for immediate actionability. Expertise in Retail banking, Core banking, AML & Regulatory reporting projects, Credit Risk an Market Risk. Experience in managing end to end projects from initiation to closure, handling multiple stakeholders expectations while maintaining high quality delivery under tight deadlines. Hands on experience on the agile methodology and SDLC methodology.

Overview

years of professional experience

years of post-secondary education

Certifications

Work History

Senior Business Analyst

Tata Consultancy Services

04.2020 - 03.2023

TERADATA, SQL Business, The goal of the project was to build a Data-warehouse to identify if an investor is active
Also, it was required to track the total investments, cash flows, and update/insert data into specified marketing tables
We had to obtain the data from various databases as well as Flat files
The data from different sources were integrated and loaded into Data Warehouse
Responsibilities:
Designed Data stage ETL Jobs for extracting data from heterogeneous systems, transform and finally load into Data-mart
Also, involved in developing logic for different KPIs tracking financial position of an investor
Led Business Requirement Analysis using Business Process Modelling, Dataflow Diagrams
Involved in managing data modelling project from Logical design and implementation of Sybase Database
Identified Source Systems, their connectivity, related tables, fields, ensure data suitability for mapping
Designed the Business Requirement collection approach based on Project Scope and SDLC methodology
Used MS VISIO for Process Modelling, Process Mapping and Business Process flow diagrams
Worked closely with Enterprise Data Warehouse team & Business Intelligence Architecture team, to understand repository objects that supports the Business Requirement and process
Lead Business Intelligence (BI) reports, development efforts by working closely with Micro strategy, Teradata, ETL teams
Played a leading role in the effort to rollout new Retek Modules such as RDF to the organization and to upgrade existing modules as new versions released
Reported, analyzed all application defects, user issues, resolution status to the Higher Mgmt
Using Mercury test detector
Prepared Test plans which includes introduction, test strategies, test schedules, QA team’s role, test deliverables etc
Responsible for writing test cases to cover quality assurance using Test detector
Designed, Developed Use cases, Activity diagrams and sequence diagrams using UML
Established Requirement Traceability Matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages,
Created Business Process Model using VISIO for better understanding of the system, Presented to PMs, team members for validation.
Managed team performance by implementing measurable metrics to track delivery of supporting requirement artifacts.
Supported leadership team with reporting, analysis, and business presentations to inform divisional strategies.
Directed business analysts in executing and delivering various tactical and strategic plans.
Guided teams and refined Agile techniques throughout journey and evolution of delivery cycles, establishing documentation framework to support Agile methodology implementation with Waterfall-centric delivery team.
Effectively supervised team performance by implementing measurable metrics to assess delivery of requirements.
Recruited new members for business analysis team to support division growth and create strong and productive department, replacing underperforming staff.
Developed diverse reporting packages to meet individual needs of sales, marketing, product management and senior leadership.
Created new analytical systems to boost vital business metrics visibility.
Analyzed sales, profitability and market conditions and presented findings in cohesive format.
Improved business direction by prioritizing customers and implementing changes based on collected feedback.
Reduced corporate expenses by streamlining incentive and demand processes across regions.
Grew business analysis team to support division growth and create robust team by replacing underperforming staff and recommending staff members for permanent roles.
Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
Analyzed open orders, backlog, and sales data to provide sales team with insights.
Conducted interviews with key business users to collect information on business processes and user requirements.

Analyst

TATA Consultancy Services

10.2016 - 10.2019

Tools: Teradata, Cognos, ORACLE Studio, Assist in UAT testing for report built in AXIOM
Oversee Entity Consolidation in accordance with US GAAP
Ensuring all UK regulatory reporting is completed and reported accurately in a timely manner
Support the Hiring Manager when they need help with prime brokerage audit in securities lending space and regulatory reporting audit
Support building up the Regulatory Reporting captive capability in India
Prepare regulatory filings with multiple government agencies
Determine the fund scoping of each quarterly regulatory filings
Research new regulatory developments and reporting requirements
Design test scripts
Report on Net Capital
Using Adobe Analytics to create customized reports and perform specialized analyses in Microsoft Excel
Also used Report Builder i.e
An Excel plug-in helped in importing real-time digital analytics so you can combine data from multiple sources and easily create customized visualizations for specific business or user needs
Generating Weekly Status Report using “Data Mapping” as well as Batch-Report to Clients as well as Senior Management
Develop, manage and implement reporting processes to improve efficiency, collaboration and innovation
Provide input in the development and maintenance of RDAAaR reporting and data management for regulatory and internal risk reporting
Develop, manage and implement reporting processes to improve efficiency
Work with leaders in the development of a one source data management tool
Engaged with clients to discuss Future value of money in a particular scheme as they wanted to find and compare Internal Rate of Return (IRR) and Average Cost of Capital
Deployment of Batch jobs to find out present value of annuity payment modules
Calculating Net Present Value, Average Rate of Return and to check whether ROI> WACC by analyzing the modules
Interpreting data by analyzing reports of several modules and finding trends, comparing several schemes across industry
Hands on experience directly with clients, won “Spot-light Award” among all domains in CITI Bank and achieved client appreciation too in FY17 resulted cost savings of 200$ in FY18
Received “On the Spot Award”; “Learning Achievement Award”,” TCS Gems” & “Performance Band “A”.
Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
Validated results and performed quality assurance to assess accuracy of data.
Identified clear connections between policies and business results to eliminate or reduce confusion and help employees achieve goals.
Queried databases for information needed for report processing.
Conducted system analysis and implementation to maintain and improve computer systems.
Conducted workplace compliance training to reduce liability risks and operate effectively.
Assessed data modeling and statistics to integrate high-level business processes with data rules.
Performed budget analysis to control expenditures and predict future budget needs.
Enhanced interfaces to promote better functionality for users.
Optimized core processes to improve business performance and operational agility.
Installed system updates to address vulnerabilities and reduce security issues.
Monitored compliance and filing requirements in conjunction with staff and management.
Recommended process improvements to continually identify, analyze and fix constraints and challenges.
Identified and resolved problems through root cause analysis and research.
Guided acquisition process to capture projected cost and revenue synergies and move combined organization forward.
Supported creation of detailed, technical financial models to value potential acquisition targets.
Researched and adopted new technologies to add value to existing offerings.
Performed audits of subsidiaries to protect shareholders and potential investors from fraudulent or unrepresentative financial claims.
Evaluated staff performance and provided coaching to address inefficiencies.
Cultivated positive relationships with vendors to deliver timely and cost-effective supply of services and materials.
Educated staff on organizational mission and goals to help employees achieve success.
Maintained database systems to track and analyze operational data.
Developed and updated tracking spreadsheets for process monitoring and reporting.
Created and managed project plans, timelines and budgets.
Frequently inspected production area to verify proper equipment operation.
Devised and implemented processes and procedures to streamline operations.
Conducted regular reviews of operations and identified areas for improvement.
Evaluated customer needs and feedback to drive product and service improvements.
Maintained overall safe work environment with employee training programs and enforcement of safety procedures.
Generated reports detailing findings and recommendations.
Collected, arranged, and input information into database system.
Developed effective improvement plans in alignment with goals and specifications.
Observed packing operations to verify conformance to specifications.
Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
Helped meet changing demands by recommending improvements to business systems or procedures.
Gathered, organized and input information into digital database.

Developer

Tata Consultancy Services

09.2015 - 10.2016

Vision Plus, Cobol, JCL, DB2, SQL Server, Involved in requirement gathering meeting to understand the client requirement and prepare documentation for the team
Worked as a Developer in “Bank Payroll Card Processing” where I had to reprocess several Batch Jobs run to trigger payments
Feed is being sent to Data Warehouse to generate reports to check how much payment is successful in a monthly basis
Extracted data, manual insertion and updating of entry of regular Transaction using SQL Query
Loading Salary Payments to Employee’s ‘Smart Cards’ as well as checking “Availability Float” by running queries
Acts as liaison between Near shore team and Business as well as Developed and Executed Test plans and fixing defects
Designed, developed, and implemented software applications for website based on analyzed requirements and understanding of industry technical standards.
Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
Tested programs and databases to identify issues and make necessary modifications.
Revised, modularized and updated old code bases to modern development standards, reducing operating costs, and improving functionality.
Designed reusable and reliable code for use within distributed cloud environments.
Developed software for desktop and mobile operating systems.
Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
Updated old code bases to modern development standards, improving functionality.
Architected data engineering pipelines to support machine learning performance.
Coordinated with project management on database development timelines.
Participated in software field testing to verify performance of developed projects.
Integrated constructive programs into cohesive product.
Designed intuitive graphical user interfaces to improve user experience.

Education

MBA - Finance

IFMR Graduate School of Business

01.2018 - 04.2020

B.Tech -

West Bengal University of Technology (MAKAUT)

07.2011 - 07.2015

12th -

West Bengal Council of Higher Secondary Education (WBCHSE)

B.T Road Government Sponsored H.S School

04.2009 - 04.2011

10th -

West Bengal Board of Secondary Education (WBBSE)

Baranagore Ramakrishna Mission Ashrama High School

04.2008 - 04.2009

Management Consultant -

Growth School

02.2023 - 04.2023

Skills

Lean Six Sigma Green Beltundefined

Accomplishments

Using Adobe Reporting Analytics And Excel, performed data analysis, created Batch-Reports and with help of Dashboard finding average payments cycle in last 6 months with finding trends along with gap analysis
As a Lean Six Sigma Green Belt, presented and analyzed “As IS Data” and implemented Automated Batch-Processing to manual errors, avoiding Availability Float, redundancy in data which helped to reduce number of reports to be generated and improving Soft Cost Savings by 30%
Analysed Key-functioning, mechanism, opportunities of ERP and suggested improvement areas where it can be applied to various industries using Predictive Analytics
Conducted Strategic Analysis of Tata-Motors and JLR, identified share price of Tata Motors fell by 63% since January,09 & recommended to disinvest stake in JLR & decrease reliability on Diesel Centric Cars
Carried out Market Research for Britannia Nutri-choice Biscuits as they still lag in sales compared to other segments & recommended for investment in promotion, repositioning & segmentation to increase market share by 10% in FY20
Extra-curricular Activities/ Other Achievements
Runner-up of Tech Fest ‘Kshitij’ of IIT Kharagpur, in Robotics Event- ‘Delta Surge’ in 2014 among 1000 participants
As Social Worker with Don Bosco Ashalayam in National Child Labour Project & Asha Sishu Siksha Project in 2014
Process Improvement - Achieved revenue objective by implementing cost-cutting measures.
Management - Directed marketing team of 12 direct reports.Supervised creation of marketing strategies/plans and ensured operations were within budget constraints.
Awarded the TCS's STAR Award.

Certification

Professional Scrum Master Certification from Scrum.org in 2021 and Certified Business Analyst in U.S. Banking from IIBA and TCS, Design Thinking (E2) Certification from TCS

Additional Information

Prepare the requirement document to define report layouts and identify data sources. Capital Market – Credit Cards, Loans, Mortgages Converting Functional requirement to technical requirement within established timeline and involve BA for validation. Helping in creation of User Stories by analyzing the business requirements and defining, fulfilling acceptance criteria. Performed Source System Data Analysis to manage ‘Source-Target’ data mapping. Preparing the Regulatory Reporting Analyst reports to the Regulatory Reporting Manager and is responsible for the timely and accurate preparation and filing of various financial regulatory reports (including FFIEC 009, FFIEC 031, FRY9-C) in compliance with all regulatory requirements, Company policies and procedures, and generally accepted accounting principles.

Affiliations

TATA CONSULTANCY SERVICES

IIBA

Software

PYTHON

DB2

JIRA

POWER BI

TABLEAU

TERADATA

DATA WAREHOUSE

ETL

Advanced Excel

MS VISIO

POWERPOINT

Author of "World of Business with Data and Analytics" - 'Investor Behavior Towards Mutual Fund'

https://doi.org/10.1007/978-981-19-5689-8_7

Timeline

Management Consultant -

Growth School

02.2023 - 04.2023

Senior Business Analyst

Tata Consultancy Services

04.2020 - 03.2023

MBA - Finance

IFMR Graduate School of Business

01.2018 - 04.2020

Analyst

TATA Consultancy Services

10.2016 - 10.2019

Developer

Tata Consultancy Services

09.2015 - 10.2016

B.Tech -

West Bengal University of Technology (MAKAUT)

07.2011 - 07.2015

12th -

West Bengal Council of Higher Secondary Education (WBCHSE)

04.2009 - 04.2011

10th -

West Bengal Board of Secondary Education (WBBSE)

04.2008 - 04.2009