Amrit Kaur Randhawa
Data Analyst @Capgemini
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Capgemini
CA
Designed and implemented data solutions to enhance statistical efficiency and quality. Improved data processing speed and reduced errors• Created interactive Power BI Dashboards, KPIs, and Reports for Monthly Metric analysis reduced monthly reporting time, and improved data accuracy, increasing report reliability• Enabled the managed identity on Data Factory for Power BI to connect to datasets in Data Bricks and visualized data sets on Power BI, achieving a reduction in data integration time, leading to more efficient data visualization• Architected a robust database solution and leveraged advanced SQL techniques to efficiently store, analyze, and retrieve data for measuring the success of marketing projects, enabling in-depth performance tracking, trend analysis, and actionable insights that drove data-driven decision-making• Developed and designed interactive and visually appealing reports using SSRS to present key performance indicators KPIs, trends, and insights to stakeholders• Analyzed CRM data to identify and implement cost-saving strategies, achieving in an reduction in customer acquisition costs• Redesigned and optimized SSRS reports and SSIS packages by implementing query optimization techniques, efficient indexing, and incremental data loads, resulting in a 50% improvement in query execution times and significantly enhancing data load efficiency and overall report performance• Developed visualization and dashboard leveraging SQL and Tableau to provide home insights into analytics. Increased the accuracy of home insights, leading to more informed decisions• Implemented data quality checks and validation rules within SSIS packages to ensure data integrity and accuracy throughout the ETL process• Enhanced data quality, efficiency, and reliability by implementing best practices in data management and analytics, including rigorous data validation, cleaning, and transformation processes
EDUCATION
Guru Nanak Dev University, Amritsar
Master's degree, Physics
BBK DAV College for women, Amritsar
Bachelor's degree, Science (PCM)
Georgian College
Graduate Certificate, Big Data Analytics
ABOUT AMRIT KAUR RANDHAWA
Around 3 years of experience in data reporting, data analysis, cleansing, modeling, visualization and deep understanding and hands-on development experience within the Microsoft Power BI application, including data refresh methods, data modeling, data transformation• Highly skilled in designing and building Microsoft Azure functions to optimize data extractions and ensure data validation, cleansing, and merging form a critical part of data processing solutions• Strong experience working in teams to perform ETL (extract, transform, and load) of data from a variety of databases from SQL, NoSQL• Expertise in developing product analysis advanced metrics and visuals by collecting and integrating data from various sources, including web analytics tools and internal databases• Skilled in using statistical techniques SSRS and SAS to track and analyze the data and used statistical techniques for hypothesis testing to validate data and interpretations• Proficient in crafting advanced DAX formulas to build comprehensive data models, perform data transformation, and create sophisticated measures and calculated columns• Excelled in importing, exporting, and cleaning databases using SQL, NumPy, and Pandas in Python and superior skill in Advanced Excel to create pivot tables and pivot reporting and the VLOOKUP function• Adept at designing and maintaining KPI scorecards that provide a comprehensive overview of business health and skilled in integrating VBA with other Office applications to improve data interchange and reporting capabilities• Skilled in the design and development of various dashboards, and reports utilizing Tableau and Power BI Visualizations like bar graphs, scatter plots, pie charts• Experienced in developing, maintaining, and processing large databases with complex relationships between tables. Written several advanced SQL queries for extracting relevant data for predictive analytics• Strong ability to identify opportunities for optimizing CRM processes and workflow, and experienced in implementing data quality best practices, ensuring data integrity, and enhancing the overall efficiency of CRM systems• Demonstrated in enhancing Looker dashboards and reports for visual representation of performance metrics, trends, and analytical insights, thereby promoting a culture of openness and responsibility• Adept at automating workflows and optimizing batch/stream processing pipelines using Python, SQL, and data governance practices to support business-driven analytics and reporting
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.