Suman Suman Email & Phone Number

• With a total of 3+ years of experience, specializing in extracting valuable insights from complex datasets to drive informed decision-making and enhance business performance• Managed SQL databases, including SQL Server, optimizing database performance, and achieving a reduction in query execution time while ensuring seamless data retrieval and manipulation• Leveraged Pandas in Python to streamline data handling processes through Data frames and Series, executing comprehensive data cleaning, transformation, and exploratory data analysis tasks essential for data-centric roles• Adept in Python programming, with a solid grasp of its versatile syntax and extensive libraries, enabling the creation of efficient and legible code for diverse applications, including data analysis, and machine learning• Utilized Power BI, and Tableau to create interactive and visually compelling reports and dashboards, facilitating data-driven decision-making• Contributed to an increase in data comprehension by developing engaging Power BI dashboards, simplifying the understanding of complex datasets• Proficient in using DAX to perform advanced calculations and data modeling in Power BI. Accomplished in utilizing DAX to create advanced calculations and measures, significantly improving data analysis accuracy and enabling data-driven decision-making• Demonstrated proficiency in Microsoft Excel (Advanced) and Google Sheets for in-depth data analysis and reporting, presenting key insights to stakeholders• Utilized SQL Server Reporting Services (SSRS) to design and generate reports from SQL Server data sources, enhancing data-driven reporting capabilities• Proficient in querying and extracting data from diverse databases, including Microsoft SQL Server, and MySQL, ensuring data availability and accessibility• Skilled in crafting and employing Pivot Tables to streamline data summarization and enhance analytical processes for increased efficiency• Experienced in VBA (Visual Basic for Applications) for automating tasks and custom functions within Microsoft Excel• Worked in an agile environment and had good insight into agile methodologies and Lean working techniques. Participated in Agile ceremonies and Scrum Meetings. Possesses excellent communication skills, capable of translating data insights into actionable business recommendations

• 

  Data Analyst

  Rk Rocket Tech Inc

  Jun 2020 - Present - Canada

  • Utilized advanced analytical tools such as Power BI, Excel, and SQL daily to perform deep data analysis, enhancing the decision-making process across various departments• Designed and implemented bespoke analytics solutions tailored to specific business challenges, using DAX for complex calculations and metrics, which have resulted in measurable improvements in operational efficiency• Created dynamic and interactive reports using SSRS, and Power BI, making complex data accessible and understandable for stakeholders, thus supporting strategic planning and real-time decision-making• Ensured the highest standards of data quality and integrity by applying rigorous cleaning and transformation processes with Python, Pandas, and NumPy, significantly reducing data discrepancies and errors• Conducted performance tuning of data processes and queries to enhance speed and efficiency, ensuring Rk Rocket Tech’s analytics infrastructure supports fast-paced business requirements• Managed data warehousing solutions and utilizing business intelligence tools for comprehensive reporting and analytics, ensuring data is accurately represented and easily accessible for decision-making• Created intuitive and interactive visualizations for KPIs using Power BI, enabling stakeholders to quickly grasp performance trends and make informed decisions• Automated the generation and distribution of KPI reports, ensuring timely and accurate delivery of critical performance data to relevant stakeholders• Leveraged advanced data analysis tools such as Tableau, and Excel to extract valuable insights from web traffic and user behavior data· Created interactive and dynamic reports using DAX Data Analysis Expressions and SSRS SQL Server Reporting Services to facilitate data-driven decision-making· Applied Python with Pandas and NumPy libraries to manipulate and clean data, ensuring high-quality· Managed and optimized MySQL databases to ensure efficient extraction, transformation