Summary
Overview
Work History
Education
Skills
Timeline
Generic

Madhura Santhapadavu

Summary

Detail-focused Data focused developer with over 8 years of experience in SQL development, data modelling and business analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Data Modelling and Big data


Overview

8
8
years of professional experience

Work History

Data & Analytics Consultant

Nupanch
10.2021 - 09.2022
  • Performed exploratory data analysis, data modelling and built data warehouse tables for - Orders, Customers, Products.
  • Normalized legacy source tables.
  • Created Data guardrails for analytics and insights.
  • Worked as a data partner for a clothing brand in the USA, producing data-driven insights for informed decision-making using Looker.
  • Developed KPI reporting for marketing and finance teams, aiding executive decision-making.
  • Built and managed data sets from sources like Shopify, Heap, Goggle Web Analytics using Fivetran, Dbt for Bigquery, RedShift.
  • Built reports using Looker to track performance, costs, inventory, traffic, marketing initiatives.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Utilized data visualization tools to effectively communicate business insights.
  • Participated in requirements meetings to understand business needs.
  • Used statistical methods to analyze data and generate useful business reports.
  • Upheld security and confidentiality of documents and data within area of responsibility.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Analyzed transactions to build logical business intelligence model for real-time reporting needs.

Insights Analyst

Bank Of New Zealand
08.2020 - 05.2021
  • Worked with the bank's conduct team on Product Review and Conduct Metrics.
  • Liaised with senior stakeholders in the Products domain to understand the product suite of about 50+ products and services offered to its customers and proposed solutions to review the product setup.
  • Reverse-engineered complex data flows from multiple systems to build ETL pipelines.
  • Developed comprehensive metrics and dashboards for ongoing monitoring of Conduct Metrics.
  • Worked on ad-hoc requests from product team to build data insights to help with customer experience, product personalization and fraud transactions.
  • Helped build and maintain the Tableau reporting layer.
  • Resolved data discrepancies between multiple source systems using Hadoop and Tableau reports.
  • Identified appropriate marketing channels and target customers for campaigns.
  • Created customized marketing materials to increase product awareness.
  • Helped plan data extraction and processing tasks, aiding in eventual deployments.
  • Wrote software that scaled to petabytes of data and supported millions of transactions per second.
  • Acted as expert technical resource to programming staff in program development, testing and implementation process.
  • Worked in hybrid environment where legacy and data warehouse applications and new big-data applications co-existed.
  • Engaged with business representatives, business analysts and developers and delivered comprehensive business-facing analytics solutions.
  • Analyzed large datasets to identify trends and patterns in customer behaviors.

Business Intelligence Consultant

Altis Consulting
04.2019 - 08.2020
  • Worked with clients in Energy and Banking sectors.
  • At the energy company, tasked with simplifying a complex SAP hierarchy and making it customizable for use in reporting.
  • Developed a debtor's dashboard to visualize over $10M owed to the company by debtors.
  • At the bank, built tables summarizing the core elements of testing (i.e fees, accounts, customers, transactions, products), based on the Quality Assurance (QA) test library, which were updated on a month-by-month rolling basis.
  • Created over 20 self-service Tableau dashboards for a QA analysts based on the tables to enable testing of different products.
  • Peer reviewed one another's work to guarantee the data source and logic of the scripts, data relevance and query accuracy.
  • Collected data from wide-ranging sources.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Created data analysis tools to allow teams to query acquired information for unique details.
  • Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
  • Collaborated with stakeholders to identify business needs and data sources.

Customer Insights Analyst

2degrees Mobile Limited
10.2018 - 03.2019
  • Provided marketing insights and supported sales strategy through Tableau reports.
  • Worked collaboratively with the Data Warehouse team to propose and develop data solutions to help migrate reports to Tableau.
  • Involved in migrating reports built using SAP Business Objects and PostgreSQL to Tableau.
  • Developed and presented data insights and reports to the Chief Marketing Officer on an ongoing basic
  • Identified and resolved problems through root cause analysis and research.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Recommended process improvements to continually identify, analyze and fix constraints and challenges.
  • Queried databases for information needed for report processing.
  • Monitored compliance and filing requirements in conjunction with staff and management.
  • Optimized core processes to improve business performance and operational agility.
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Documented analysis results and provided performance improvement feedback.

Application Development Analyst (ETL/SQL)

Accenture
08.2014 - 01.2017
  • Worked with clients in the Banking and Financial Services industries.
  • Developed new ETL jobs and transformations using Pentaho and maintained existing jobs to process over 1 million rows daily.
  • Wrote SQL procedures, views, and triggers to implement complex business logic.
  • Created and tested SQL deployment scripts for release into higher environments.
  • Created process flow chart for execution of ETL and reporting use cases.
  • Worked on technical documents for metadata, naming convention, and coding standards.
  • Designed best practice documentation for development.
  • Resolved system test and validation problems to provide normal program functioning.
  • Participated in design and planning exercises for future software rollouts.
  • Developed and implemented personalized client solutions using programming language expertise.
  • Collaborated with multidisciplinary teams to design and implement new technology features.
  • Updated technical documentation, product specifications and technical training materials.
  • Designed and developed application scripts for test scenarios.
  • Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality.
  • Designed and developed analytical data structures.
  • Analyzed enterprise data holdings to reduce redundancy of data within existing systems or improve conflation of datasets from one system to another.
  • Organized integration of data and migration activities to enhance operations.

Education

Master of Science - Information Technology

Technology University of Auckland
Auckland, NZ
04.2018

Bachelor of Engineering - Computer And Information Sciences

Technology Visvesvaraya Technological University
Bengaluru, India
06.2014

Skills

  • SQL and PLSQL Expertise
  • DB Schema Data modeler
  • Data Modeling and DB Design
  • Hadoop and Big Data Analytics
  • Business Intelligence and Analytics
  • Data Visualization and Dashboard creation in Tableau
  • Power BI
  • Looker
  • ETL Development
  • Pentaho Data Integration
  • Shell scripting
  • MS Visio, Excel and Word

Timeline

Data & Analytics Consultant

Nupanch
10.2021 - 09.2022

Insights Analyst

Bank Of New Zealand
08.2020 - 05.2021

Business Intelligence Consultant

Altis Consulting
04.2019 - 08.2020

Customer Insights Analyst

2degrees Mobile Limited
10.2018 - 03.2019

Application Development Analyst (ETL/SQL)

Accenture
08.2014 - 01.2017

Master of Science - Information Technology

Technology University of Auckland

Bachelor of Engineering - Computer And Information Sciences

Technology Visvesvaraya Technological University

Similar Profiles

CREATE PROFILE
Madhura Santhapadavu