Madhumita Choudhury
Melbourne,VIC
Summary
A highly adaptable professional with 10+ years of experience in roles such as Data Analyst, Technical Business Analyst, Data Engineer, and Production Support Engineer. Demonstrate proficiency in requirement elicitation, data analysis, solution design, modelling, communication, and team leadership. Skilled in building data-intensive applications and addressing challenging architectural and scalability issues, while executing solutions to meet complex business requirements. Well-versed in conducting effective business meetings with stakeholders to understand and gather the requirements, elicitation information, implementing operational assessments, and conducting functional requirement analysis to define the scope and projection of work for businesses of all sizes. Proactive and personable team lead player in organizing information.
Overview
10
10
years of professional experience
Work History
Technical Business Analyst
Telstra
06.2021 - Current
- Worked as Technical Business Analyst in Customer Self-Serve Data mission under Data and AI subgroup for TE Digitization group and member of TE Business Data Domain chapter.
- Maintained documentation of system changes to facilitate knowledge transfer among team members while ensuring ongoing support capabilities were maintained throughout the life cycle of a given solution.
- Collaborated with stakeholders to identify business requirements, requirement specifications, Non-Functional Requirements (NFRs), and analyzing requirements, and recommend solutions, ensuring compliance with operational controls.
- Worked closely with Product Managers and Operations teams to align business requirements and design future-state business processes.
- Ensured adherence to Agile best practices by meeting the Definitions of Done (DoD) and Ready (DoR), collaborating with Product Owners and Subject Matter Experts (SMEs) to refine requirements in JIRA.
- Converted complex requirements into user stories with acceptance criteria and details for development team in Agile Sprints, developed test plans for customer user acceptance testing and supported the creation of UAT test cases.
- Led dynamic planning processes, aligning with Product Owners on priorities and defining key requirements.
- Designed data models and established governance standards, collaborating with data modelers and SMEs to ensure high-quality data for APIs, channels, and business reports.
- Designed comprehensive customer journeys, wire-frames, and prototypes to facilitate the transition of 120,000 existing customers from legacy services to a digital platform.
- Developed and tested self-serve portal using APIs for Enterprise customers which lists their network and internet services, view services on a map and list, monitor usage and performance and check for planned maintenance.
- Successfully developed an assurance portal to significantly enhance Customer Service Asset and Classification capabilities which unified tool consolidates inventory requirements, empowering assurance agents to efficiently query and access additional service information.
- Encouraged solution reuse and API enhancements, optimizing product capabilities to meet evolving customer needs.
- Customized an automated solution using Azure Databricks and Data Factory to provide NBN customers with speed remediation. communications and build Power BI dashboards and reports displaying the success of the company’s obligations.
- Conducted project feasibility studies to determine potential return on investment (ROI).
Data Analyst
Telstra
08.2017 - 05.2021
- Working as a Data Analyst for the client which focuses on migrating the existing Copper services data for Enterprise customers from BAU systems to the strategic applications.
- Collaborated with stakeholders to define data requirements for SIO reporting, translating business needs into analytical solutions for enterprise customers.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
- Mapped legacy product models, system integrations, and billing methods, working with SMEs to establish sourcing rules for accurate product and service identification.
- Analyzed and compared data with EDW, ensuring data quality, availability, and Master Data Mapping integrity, leading to the seamless transition of 120K customers from legacy to digital systems.
- Built multiple Synapse views for Power BI reporting, providing key product inventory insights for business and product owners.
- Developed a user-friendly Power BI dashboard for sales teams, improving customer query resolution during the assurance phase.
- Designed a solution using Azure SQL for customers to view their invoice summary.
- Documented product definitions in Confluence, SharePoint, and Microsoft Office, capturing system behavior, scenarios, business rules, specifications, and reference data for IT development.
- Explored and optimized Salesforce CRM, identifying improvement opportunities for customer self-service applications and enhancing customer satisfaction.
- Established and enforced data quality standards, ensuring referential integrity, eliminating data errors, and protecting PII and PCI information.
Data Engineer
Deutsche Bank
02.2015 - 07.2017
- Worked as Data Engineer which Extracted financial data from different systems and created reports for the head banks to analyze the financial statistics.
- Designed, built, and maintained ETL pipelines to efficiently move data from multiple sources to a data warehouse, transforming data based on business requirements and acceptance criteria.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks into optimized formats for various business consumers.
- Implemented robust data validation and monitoring techniques, ensuring data accuracy, security, and compliance with GDPR, HIPAA, and other regulations.
- Supported migration of legacy systems like Airflow Jobs from Cloudera to modern big-data technologies like Azure data Lake, Azure SQL Database, Data Bricks using Azure Data factory pipelines for cost savings, enhanced security, improved performance, advanced analytics and with minimal business disruption.
- Optimized data workflows for performance and scalability, enhancing long-running ETL pipelines and Spark jobs to meet Service Level Agreements (SLAs).
- Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.
- Provided root cause analysis (RCA) and incident resolution, addressing data issues and system incidents reported via ITAM.
- Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.
Education
Bachelor of Technology - Electronics and Communications Engineering
Siliguri Institute of Technology
India06.2014
Skills
- SQL
- Excel
- Power BI
- Data cleaning and preparation
- Microsoft Azure
- ETL
- Azure Data Bricks
- Azure Data Factory
- Azure Synapse Analytics
- Azure Cosmos DB
- Azure Data Lake
- Data warehousing
- Root-cause analysis
- Data Interpretation
- Statistical Analysis
- Critical Thinking
- Domain Knowledge
- Data Storytelling
- Report Writing
- Stakeholder Communication
- Attention to Details
- Curiosity
- Pro-activeness
- Team management and collaboration
- JIRA
- User acceptance testing
- Requirement documentation
- Confluence
- SharePoint
- Microsoft OneNote
- Microsoft Visio
- BPNM
- BDD framework
- Development Methodologies
- Agile
- Scrum
- DevOps
- Waterfall
- Software development life cycle
Visa
Temporary Skills Shortage (TSS), GK / 482,
Visa grant date: 07 June 2024
Visa expiry date: 07 June 2026
Timeline
Technical Business Analyst
Telstra
06.2021 - Current
Data Analyst
Telstra
08.2017 - 05.2021
Data Engineer
Deutsche Bank
02.2015 - 07.2017
Bachelor of Technology - Electronics and Communications Engineering
Siliguri Institute of Technology
Similar Profiles
Mark Vergel RamirezMark Vergel Ramirez
Data Engineer – CVM Mission (Data Insights & Analytics Analyst) at TelstraData Engineer – CVM Mission (Data Insights & Analytics Analyst) at Telstra
Kuntal PatelKuntal Patel
Customer Service Representative at TelstraCustomer Service Representative at Telstra
Bella McCorkellBella McCorkell
Customer Consultant at TelstraCustomer Consultant at Telstra