Pavas Krishnan Shanmugasundaram Email and Phone Number
Here’s a concise summary of your LinkedIn bio based on your resume:I am an Information Technology Master's student at Clark University, with a strong focus on data analytics, cloud technologies, and IT strategy. With over two years of experience at Ernst & Young (EY), I have honed my skills in SQL optimization, data preparation using Alteryx, and creating insightful Tableau dashboards to drive business decisions. My expertise includes working with data warehouses like Snowflake, utilizing cloud technologies such as Azure, and applying advanced data analysis techniques.Additionally, I have worked on projects involving end-to-end data integration, business intelligence reporting with Power BI, and building relational databases. I am passionate about leveraging technology and data to solve business challenges and improve operational efficiency.I am open to new opportunities and collaborations where I can contribute my skills and grow further in the fields of data engineering, analytics, and cloud technologies. Let's connect!
-
Data AnalystDaimler Truck North AmericaCharlotte, Nc, Us -
Summer InternSitek Inc Jun 2024 - Aug 2024Lexington, 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. -
Associate ConsultantEy Mar 2023 - Aug 2023Chennai, 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, consistency, and completeness.•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 organizational standards. -
Senior Data AnalystEy Feb 2022 - Feb 2023Chennai, 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.•Enabled marketing and sales teams to better engage customers through segmentation (RFM Analysis: Recency, Frequency, Monetary) for targeted communications and improved customer relationships.•Visualized key insights using Power BI, resulting in a 50% reduction in project costs and a 35% increase in the global adoption of analytics tools. -
Data AnalystEy Aug 2021 - Jan 2022Chennai, 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 implementation by 80% -
Internship TraineeThe Ramco Cements Limited Nov 2018 - Dec 2018Alathiyur• Collaborated with professionals from different departments to ensure efficient factory operation.• Assisted experts with installation and upgrade of various electrical equipment.
Pavas Krishnan Shanmugasundaram Education Details
-
Information Technology -
First Class
Frequently Asked Questions about Pavas Krishnan Shanmugasundaram
What company does Pavas Krishnan Shanmugasundaram work for?
Pavas Krishnan Shanmugasundaram works for Daimler Truck North America
What is Pavas Krishnan Shanmugasundaram's role at the current company?
Pavas Krishnan Shanmugasundaram's current role is Data Analyst.
What schools did Pavas Krishnan Shanmugasundaram attend?
Pavas Krishnan Shanmugasundaram attended Clark University, Ssn College Of Engineering.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial