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: Spend Analytics

BI Tools: Power BI Desktop, Power BI Service

Database: SQL Server, Excel Files, Sharepoint excel files

Project Description: The Spend Analytics project is designed to collect, cleanse, classify, and analyze procurement and financial data to uncover actionable insights into organizational spending. The goal is to improve cost efficiency, enhance supplier management, and support strategic sourcing decisions by providing full visibility into spend patterns across departments, categories, and suppliers.

Roles and responsibilities:

· Collecting inputs from the stakeholders,

· Documenting the given inputs,

· Identifying the Data Key points,

· 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: Supplier Performance Score Card

BI Tools: Power BI Desktop, Power BI Service

Database: SAP Ariba, Sharepoint Excel Files

Project Description: The Supplier Performance Scorecard project is a strategic initiative aimed at developing a standardized framework to evaluate, monitor, and improve supplier performance. By leveraging key performance indicators (KPIs), the scorecard provides a transparent and data-driven approach to supplier relationship management, enabling organizations to optimize procurement decisions, mitigate risks, and foster continuous improvement.

Roles and responsibilities:

· Collecting inputs from the stakeholders,

· Documenting the given inputs,

· Identifying the Data Key points,

· Performed ETL activities to develop OLAP model,

· Implementing Indexes on tables for better results,

· Connecting multiple data sources and building data model,

· Writing DAX measures 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.