Business Intelligence Information Technology

Page * of *

ASHWINI MALATKAR

Business Intelligence and Data Analytics

*******.**********@*****.***, 248-***-****, Troy, Michigan https://www.linkedin.com/in/ashwini-malatkar/

Accomplished Data lead with 12+ years of experience in managing end-to-end BI solutions, driving data insights, and delivering high-impact projects. Proven track record in enhancing data quality, mentoring global teams, and accelerating business performance through innovative data-driven strategies. Technical Skills: SQL (Redshift, T-SQL, Oracle, AS 400), Amazon Quicksight, Microsoft Power BI, Tableau, QlikView, QlikSense, SQL Server Reporting Services (SSRS), Talend, SQL Server Integration Services (SSIS- ETL), Amazon Hammerstone ETL tool, Excel

(for reports), Microsoft SCOPE scripting, QlikView Management Console (QMC), SharePoint Certifications: PMP, AWS Cloud Practitioner, ITIL Foundation Level – Pink Elephant, BA Essential Master Class, Python Education Summary: MS in Software Engineering and Information Technology Oakland University (2016-2017); Bachelor of Engineering in Information Technology SRTM University (2006-2010) EXPERIENCE:

United Wholesale Mortgage (Senior Data Analyst) Detroit, USA Dec’24-Current o Led Power BI dashboard development to assess underwriter performance by volume, turnaround time, and borrower profiles. Designed and managed Talend ETL pipelines and optimized complex SQL queries to improve data quality and reporting speed.

o Led Agile sprint planning, backlog management, and delivery, while mentoring analysts on data modeling and visualization. Managed daily team operations, project milestones, and resource allocation to ensure timely delivery and adherence to quality standards.

Amazon Web Services (Data Analytics Lead) Detroit, USA Mar’22-July’23 o Led end-to-end BI projects using agile methodologies, collaborating with stakeholders to gather requirements, define KPIs, and develop data models that drive business decisions. o Led a team of analysts, mentoring them on building and maintaining dashboards using Quicksight and Tableau to meet organizational needs.

o Partnered closely with internal stakeholders to translate data challenges into clear, actionable insights that helped drive business outcomes; led presentations that used compelling storytelling to convey data insights effectively. o Designed and developed complex data models, data pipelines and dashboards using reporting tools and SQL to support strategic initiatives; Familiar with Python for data extraction from various sources. o Conducted root cause analysis for data quality issues, improving the user experience for 700 sellers by highlighting data hygiene problems and reducing data issues by 28% in one month. o Transformed customer experience by eliminating confusion from numerous unnecessary dashboards; collaborated with global teams to create a streamlined global dashboard that unified data access, significantly enhancing usability and effectively addressing the diverse needs of our customers while reducing clutter. o Worked with global data teams to validate metrics and reporting assets, audited code for consistency, and guided external teams to align with organizational best practices and governance protocols. Lear Corporation (Senior Business Intelligence Analyst) Southfield, USA Nov’16-Mar’22 o Led the hiring, on-boarding, and training of a high-performing offshore team to support key BI and analytics projects. o Managed a cross-functional team across different time zones, ensuring smooth communication and collaboration between onshore and offshore teams.

o Oversaw daily operations, project deliverables, and resource allocation for the offshore team, ensuring adherence to timelines and quality standards.

o Collaborated to gather project requirements and manage projects scope/deliverables, wrote and maintained requirements documents, technical specification documents, test cases, deployment document, and go-live/launch emails. o Designed and developed ad hoc reports for client using various tools such as Power BI, Qlikview, SSRS with various databases such as Oracle SQL, TSQL, AS400 and Snowflake for functional areas such as Finance, HR, Manufacturing, Audit and Purchasing. Developed complex DAX scripts to build Power BI dashboards. o Achieved $600K in annual savings by creating data-driven insights and automating reporting processes across 30 dashboards.

o Spearheaded platform migration from QlikView to Power BI, managing vendor relationships while overseeing requirements, development, and testing for seamless transition. Implemented data on boarding from various HR platforms into SAP Success Factors.

Page 2 of 2

Tata Consultancy Services: Microsoft (System Engineer) Pune, India Jul’13-Mar’15 o Built SQL packages to automate various jobs by extracting data streams via Cosmos (Big data for Microsoft) using SCOPE script, T-SQL and SSIS packages; managed the unique identifiers for Bing.com web pages. o Developed and optimized SQL-based data models to improve data quality and efficiency for Microsoft's Bing.com, ensuring accurate analysis of web page data.

o Fine-tuned performance of TSQL queries and stored procedures using SQL profiler to enhance query performance. o Created, deployed, and maintained SQL agent jobs. Led data governance activities to maintain standards and data quality. o Built ETL processes using SSIS and developed ad hoc reports using SSRS and Excel, providing meaningful insights to stakeholders.

o Maintained and structured documentation throughout the project’s lifecycle. Tech Mahindra (Software Engineer) Pune, India Apr’11-May’13 o Created and deployed SSRS reports for telecommunication clients, delivering insights on business performance and improving decision-making capabilities.

o Developed ETL processes using SSIS, ensuring seamless data integration for client reporting needs. o Collaborated in database design and development, ensuring the accuracy and performance of critical data solutions. o Produced SSAS Cubes for reporting, thereby enhancing report performance. o Actively led knowledge-sharing sessions for new team members, demonstrating using real-time projects. OTHER ACHIEVEMENTS:

o Developed multiple patent prototypes during my time at Lear Corporation. o ‘Key Contributor Recognition Program’ award at Lear Corporation for contributing significantly towards collecting KPIs data from 160 plants and creating data analytics solutions. o Innovation panelist among other leaders at Lear, encouraging peers to innovate and develop new ideas. o Selected to be a part of Detroit Economic Club Leader’s member through which I attended multiple seminars for professional development.

o Chosen to deliver on the selection panel for the Innovation team tasked with bringing new talent to the organization. o ‘Pat on the back’ award for going above and beyond in delivering ahead of schedule at Tech Mahindra.

Contact this candidate