Simranjit Kaur
AVP, Analyst & Reporting @Marsh Risk
Signup · Get unlimited contacts
WORK HISTORY
AVP, Analyst & Reporting @Marsh Risk
EDUCATION
Mohawk College
Post-secondary diploma in Business Analyst
Khallikote Unitary University, Brahmapur
Bachelor Of Economics
Mohawk College
International Business Management
ABOUT SIMRANJIT KAUR
Over 3+ years of experience in a data-driven environment, with a robust understanding of data issues and effective data management strategies, particularly in the context of reporting.• Proficient in writing complex SQL queries utilizing various features such as joins, aggregate functions, subqueries, and set operations to retrieve and manipulate data• Highly knowledge in Python programming, exploratory Data Analysis, and Power BI Visualization• Skilled in the design and development of various dashboards, and reports utilizing Tableau and Power BI Visualizations like bar graphs, scatter plots, pie-charts• Expertise in Excel including pivot tables, VLOOKUPs, working and matching substantial amounts of data, and able to tackle complex analyses leveraging data from various sources and delivering information• Savvy in using analytics tools such as Tableau and Business Objects to support the marketing team and sales teams• Performed advanced data analysis using Power Query\'s functions and capabilities, including Grouping data and calculating aggregates to extract valuable insights, creating custom columns using Power Query\'s formula language (M) for calculations and deriving new information.• Experienced in designing processes to support data transformation, data structures, metadata, dependency, and workload management• Expertise in performing efficiency improvements for reporting processes with MS Excel Power Pivot, MS Power Query, and MS Access• Hands-on experience in data extraction, data cleaning, setup workspace, updating and performing calibrations, and generating outputs• Skilled in Automating data processing and reporting tasks using VBA scripting and Macros, streamlining workflows, and improving data accuracy and consistency• Proficient in Advanced Excel functions, including VLOOKUP, HLOOKUP, INDEX-MATCH, and complex nested IF statements, resulting in a 25% reduction in manual data processing time. Effectively managed and analyzed substantial datasets, ensuring data accuracy, and enhancing efficiency • Worked in an Agile environment and have good insight into Agile methodologies and Lean working techniques. Participated in Agile ceremonies and Scrum Meetings • Clear and concise written and verbal communication and Strong analytical, conflict management, team management, and critical thinking skills
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.