Mayank Balani Email & Phone Number

Toronto, On, Ca

Ajmer, Rajasthan, India

-Created SQL queries to extract data from multiple sources for reporting purposes.-Led data gathering efforts from diverse upstream sources, including databases, effectively integrating the data into downstream systems to ensure smooth data flow and operational efficiency.-Integrated and processed data from multiple sources, such as SAP ERP, Excel, CSVs, and MySQL databases, transforming and consolidating large datasets into actionable insights using Python (Pandas, NumPy ) for sales reports and inventory management in supply chain projects.-Executed comprehensive data mapping, modeling, and transformation, utilizing Python, SQL, and Power BI for large-scale datasets, ensuring accuracy in sales reporting and optimizing inventory management processes.-Conducted User Acceptance Testing (UAT), validating system functionality and ensuring that all data integration and reporting solutions met project requirements and stakeholder expectations.-Applied Agile methodologies throughout the SDLC, streamlining development processes for faster iterations and improved collaboration between teams. Utilized ETL techniques to automate data workflows, reducing manual intervention and improving data accuracy.-Designed automated reporting processes utilizing SQL queries, stored procedures and Excel pivot tables for streamlined data analysis.

New Delhi, Delhi, India

## Awarded “Best Team Player” in September 2019-Connected Power BI to various data sources, including dataflows, gateways, SQL databases. Applied best practices throughout the development lifecycle to ensure high-quality deliverables-Participated in the full software development life cycle (SDLC) from requirements gathering through system implementation.-Extracted, transformed, and connected data from multiple source including MySQL, SSMS, and SQL databases, integrating them into Power BI for real-time reporting and visualization.-Developed and implemented Row-Level Security (RLS) within Power BI Services to ensure personalized and secure data access for different user roles, ensuring compliance with data governance policies.-Designed and deployed comprehensive sales performance reports, tracking key performance indicators (KPIs) and delivering insights that improved team productivity and efficiency by 20%.-Built and maintained strong relationships with internal and external stakeholders, ensuring smooth communication and seamless project execution from data extraction to report distribution.-Successfully composed, organized, and managed the entire process for various clients/stakeholders, resulting in clear, concise PowerPoint presentations

Postgraduate Degree, Buisness Intelligence And Data Analyst, 3.8/4

Postgraduate Degree, Information Technology Project Management, 3.4/4

Bachelor Of Technology - B.Tech, Information Technology, A

Activities and Societies: Fest Team Co-ordinator ( 2 Years), Toastmaster Member, NGO Volunteer - City Star Club , Ajmer.