Madhu S

Driven by a robust background in data analysis and team leadership, I excel in transforming complex data sets into actionable insights with tools like SQL and Power BI. At Cognizant Technologies, I spearheaded process optimizations, enhancing efficiency by 35%. My collaborative approach and strong analytical thinking have consistently driven project success and innovation.

• Proficiency in Power BI, including data modelling, DAX (Data Analysis Expressions), and report/dashboard development.
• Performing Data Profiling, modeling, scrubbing, and transform needed for BI solutions.
• Design, develop and deployment of Data Integration Solutions, Data Warehousing Solutions and Data Pipeline Management.
• Design, develop and optimize database queries to perform data mining on various data sources and ensure data integrity.
• Develop and maintain interactive and automated BI Dashboards as directed.
• Improve reporting workflow by automating processes for pulling and loading of data.
• Performing data cleansing using SQL views.
• Strong command of SQL concepts, including tables, keys, DDL (Data Definition Language), DML (Data Manipulation Language), and TCL (Transaction Control Language).
• Troubleshooting and resolving database issues related to data extraction, transformation, and loading.
• Integrate data from multiple sources, including databases, spreadsheets, and cloud services.
• Involved in data integration techniques (ETL processes).
• Writing SQL queries or use ETL (Extract, Transform, Load) processes to ensure seamless data extraction and analysis.
• Create, edit, and delete data factories and child resources, including datasets, linked services, pipelines, triggers, and integration runtimes.
• Familiar with data modelling and data warehousing concepts.
• Experience with cloud platforms (e.g., Snowflake, Azure).
• Implementing SCD1 and SCD2 types.
• Strong analytical thinking and problem-solving abilities.
• Effective communication skills to convey insights to non-technical stakeholders.
• Collaboration and teamwork for successful project execution.

Project 1:

Title: Buywow Sales Dashboard

BI Tools: Power BI Desktop, Power BI Service

Database: SQL Server, Excel Files

ETL Tool: Informatica Cloud

Project Description: Buywow is a startup cosmetics company, the company have the huge sales data. We developed data-driven sales teams to track and analyze key performance indicators (KPIs) and share this information across an organization.

Roles and responsibilities:

· Collecting inputs from the stakeholders,

· Documenting the given inputs,

· Identifying the Data Key points,

· Loading Excel files into SQL Server

· Writing SQL Views to optimize complex SQL Query,

· Connecting multiple data sources and building data model,

· Writing DAX measures based in the requirement,

· Building visuals and sharing with the stakeholders.

Project 2:

Title: Healthcare (Diagnosis Tracker)

BI Tools: Power BI Desktop, Power BI Service

Database: Snowflake, Excel Files

Project Description: Prism Vision is the US Healthcare company. We developed data-driven Healthcare dashboard which includes new patient, Diagnosis Information, Provider dashboard, regional healthcare information. We share this information across an organization.

Roles and responsibilities:

· Collecting inputs from the stakeholders,

· Documenting the given inputs,

· Identifying the Data Key points,

· Creating Tables in Snowflake using SnowSQL,

· Performed ETL activities to develop OLAP model,

· Implementing Indexes on tables for better results,

· Writing SQL Views to optimize complex SQL Query,

· Connecting multiple data sources and building data model,

· Writing DAX measures based in the requirement,

· Building visuals and sharing with the stakeholders.

Project 3:

Title: Governance Portal

BI Tools: Power BI Desktop, Power BI Service

Database: SQL Server, Excel Files

Project Description: PostNord is a Parcel service company. We developed Insights for Stakeholders on Accounts Payable, Record to Report, Order to Cash dashboards with Key Performance Indicators. We share this information across an organization.

Roles and responsibilities:

· Collecting inputs from the stakeholders,

· Documenting the given inputs,

· Identifying the Data Key points,

· Creating Tables in SQL Server using SQL,

· Performed ETL activities to develop OLAP model,

· Implementing Indexes on tables for better results,

· Writing SQL Views to optimize complex SQL Query,

· Connecting multiple data sources and building data model,

· Writing DAX measures based in the requirement,

· Building visuals and sharing with the stakeholders.

Project 4:

Title: SLA / KPI Dashboard

BI Tools: Tableau Desktop, Tableau Online

Database: Snowflake, Excel Files

Project Description: Safelite is an Auto glass manufacturing company. We developed Insights for Stakeholders on Accounts Payable, Record to Report, Order to Cash dashboards with Key Performance Indicators. We share this information across an organization.

Roles and responsibilities:

· Collecting inputs from the stakeholders,

· Documenting the given inputs,

· Identifying the Data Key points,

· writing SQL queries or use ETL (Extract, Transform, Load) processes to ensure seamless data extraction and analysis.

· Creating Tables in SQL Server using SQL,

· Performed ETL activities to develop OLAP model,

· Integrate data from multiple sources, including databases, spreadsheets, and cloud services.

· Implementing Indexes on tables for better results,

· Writing SQL Views to optimize complex SQL Query,

· Connecting multiple data sources and building data model,

· Writing measures or calculated fields based in the requirement,

· Building visuals and sharing with the stakeholders.

I hereby declare that all the information furnished above is true to the best of my belief.