Sutapa Ghosh Email & Phone Number

Nagoya, Aichi, JP

Nagoya, Aichi, JP

Dallas, TX, US

• Manage a team of 8+ data analysts and BI Engineers for Mr. Cooper Mortgage Origination line of business.
• Partner with different product managers and operational leads in business to fulfill all their data needs through adhoc as well as recurring reporting in Power BI.
• Act as a liaison between technology and business, establish robust data -pipelines for analytics and reporting use cases.
• Led planning, designing and user acceptance testing for ~40 tables as part of establishing the data infrastructure for product teams.
• Worked on POC to establish the framework for adhoc analytics using Microsoft Synapse infrastructure for unstructured data (Like Parquets/json files).
• Led the team to establish the real time streaming reporting using PowerBI by creating the data pipelines from unstructured application data collection in Mongo. This live dashboard was used as the primary tool for.

We moved to Bengaluru,KN and I took an extended time off to be with my daughter and for my son who was born during that period.

Mclean, VA, US

- Define and gather requirements for building BI dashboard for Auto Navigator analytics team.Conduct stakeholder interviews and conduct review with senior leadership.- Build and maintain product analytics dashboard for Autonavigator (www.Capitalone.com/cars) using web data.POC done in D3.js and python is used to automate the underling data extraction.

Mclean, VA, US

• 2015 (Sales & Operations support)
• Lead cross functional teams across geographies providing data and analytical support to businessfor adhoc/recurring requests.
• Create large data sets and store data in tables in user space for purposes of analysis as well as reportkey metrics to senior leadership on a regular basis.
• Build an integrated reporting suite consisting of daily/weekly/monthly view of Sales Operations keymatrices which is used to monitor Sales performance and productivity.
• Work with business to gather requirements for ~120 metrics, consolidating 40 different manual aswell as Business Objects reports into one reporting suite in Tableau.
• Built data architecture for the intermediate solution in user space and work with offshore to buildreport in Tableau with efficient visualization.

Mclean, VA, US

• Leading a Team of 4 data analysts supporting marketing campaign management to help Home Equity business drive forward with new marketing initiatives as well as close CRA gaps
• Manage and create segmentation data files for execution of marketing campaigns through various channels like EMAIL,DIRECT MAIL,TELEMARKETING,DIGITAL MARKETING etc
• Establish efficient campaign management infrastructure to support Multiple Population Segmentation,Data fulfillment and Response tracking to help drive new customer acquisition strategy
• Work closely with business customers to implement accurate intent for new marketing and response tracking strategy for insightful monitoring of the results of various test campaigns.
• Analyze existing opportunities to create new segmentation for marketing through deep understanding of existing data sources and help business acquire more customers or improve existing response rate of a marketing.
• Enhanced existing Segmentation & QA framework to build a user friendly,effiecient,faster,easy to learn tool which reduced execution time by 1/3

US

• Requirements/Data lead for Auto and Property LOB to work as a liaison between Business users and technical teams in order to capture accurate project requirements by facilitating requirements gathering, requirements.
• Support all new and production enhancement projects end to end in a huge Teradata Data Warehouse environment following SDLC process in a Waterfall as well as Agile environment
• Work closely with PM to report project statuses, update issue/risk logs, identify roles and provide estimates.
• Convert project functional, non-functional requirements to data design/model using ERWIN modeling tool.
• Generate Target to source mapping for design documents.
• Develop strong understanding of Teradata SQL Skills,ETL flows, Informatics tool, Reporting levels, staging databases, source system data, various downstream application impacts as a job responsibility to be able gather.

US

• Learned Teradata SQL and using Teradata SQL assistant tool to query huge set of Insurance related data
• Teradata BTEQ
• Hyperion Administration
• Working with Informatica to create mappings, generate workflows and subsequent troubleshooting.

Executive Education Certificate, Business Analytics :From Data To Insights

Ms, Masters Of Communication Technology And Policy

Ms, Applied Math And Computer Science

Bachelor Of Science, Physics