Pavas Krishnan Shanmugasundaram Email & Phone Number

Charlotte, NC, US

Lexington, Kentucky, United States

• Assisted in gathering and documenting business requirements from stakeholders, translating them into technical specifications for development teams.
• Created Power BI reports and dashboards to present key business metrics and track project progress, providing stakeholders with actionable insights into application performance.
• Assisted in developing web applications using ASP.NET MVC, contributing to the design and implementation of features based on client requirements.
• Collaborated with team members to optimize existing SQL queries, improving application performance.
• Developed and integrated RESTful APIs to facilitate seamless communication between front-end and back-end systems.

Chennai, Tamil Nadu, India

• Audited data quality and created remediation plans to resolve data quality concerns. Assured data integrity throughout system migrations and upgrades by playing key role in data mapping, transformation, and validation
• Utilized advanced Excel functions such as VLOOKUP to streamline data analysis processes. Monitored and executed end-to-end Master Data Management activities in SAP MM, assuring material master data accuracy.
• Create, update, and maintain Material Master records, including materials, vendors, and purchasing info records, Source list, Material Listing in SAP ECC & SAP MDG in ensuring consistency, and compliance with.

Chennai, Tamil Nadu, India

• Designed and developed an ETL process using Alteryx to automate data extraction from internal SharePoint sources, reducing manual data preparation time by 40% and streamlining workflows.
• Transformed large datasets, improving data accuracy and efficiency in reporting by 70%, providing actionable insights for decision-making.
• Built interactive Tableau dashboards to visualize media analytics, enabling stakeholders to track KPIs in real-time and make data-driven decisions.
• Reduced reporting cycle time by 50%, automated report generation, and ensured consistency, accelerating decision-making for media campaigns and strategy adjustments.
• Designed and implemented a fully automated BI solution for 10+ countries by integrating data from various internal and external sources in Azure Synapse, ensuring seamless data flow across the organization.
• Developed a centralized data warehouse and performed advanced SQL queries to extract and manipulate data for insights into marketing and sales performance.

Chennai, Tamil Nadu, India

• Designed and developed complex SQL queries in MS SQL Server, automating the evaluation of individual customer profiles against the Risk Control Matrix (RCM), reducing manual audit time by 50%.
• Assisted the Internal Audit (IA) team in analyzing the risks within the credit process, identifying and ranking risks, and recommending control measures, which led to a 30% improvement in risk mitigation effectiveness.
• Conducted analytical tests on the credit process and internal controls, minimizing the potential negative impacts of risk and preventing revenue leakage by 20%.
• Created Power BI visualizations and dashboards, delivering actionable insights on risk metrics, trends, and control effectiveness, which enabled the client to make more informed decisions and improved control.

Alathiyur

• Collaborated with professionals from different departments to ensure efficient factory operation.
• Assisted experts with installation and upgrade of various electrical equipment.

Master Of Science - Ms, Information Technology

Coursework • Data Management for Information Technology • Cloud Computing (Microsoft Azure) • Business Intelligence • Fundamental of Data.

Bachelor Of Engineering - Be, Electrical And Electronics Engineering, First Class