About Me
12 years of Reporting & Analytics experience in Business Intelligence pertaining to Banking and Financial Services sector with roles ranging from developer to Project lead, working extensively in Data Analysis, Reporting…
12 years of Reporting & Analytics experience in Business Intelligence pertaining to Banking and Financial Services sector with roles ranging from developer to Project lead, working extensively in Data Analysis, Reporting, Visualization, Extraction, Transformation, Loading and Cleansing. 5 years of Experience on mortgage domain in Non-IT. Evaluate mortgage loan requests in order to approve or deny applications. Determine property values based on appraised market prices and the borrower's credit worthiness.
Experience
Sr data analyst - Team Lead
• Proficient in developing interactive dashboards, product experiences and reports using Power BI, Tableau and ChatGpt.
• Expertized in data visualization and storytelling techniques to effectively communicate insights and analysis.
• Skilled in data extraction, transformation, and loading (ETL) process to prepare data for analysis in Tableau.
• Strong understanding of data modelling and data warehousing concepts.
• Proficient in SQL for querying and manipulating data.
• Involved in daily/weekly status call with a client for requirement gathering and status updates.
• Knowledgeable in advanced Tableau features such as calculated fields, parameters, sets, and table calculations
• Experienced in creating complex visualizations, including heat maps, Tree Maps, scatter plots, and geographic maps.
• Proficient in collaborating with cross-functional teams, including data analysts, business stakeholders, and IT professionals.
• Excellent problem-solving and analytical skills to identify patterns and trends in data.
Proficient in creating interactive and visually appealing reports and dashboards.
Skilled in transforming raw data into captivating visualizations, graphs, charts and maps with support of Power BI & Tableau.
Strong understanding of data modeling concepts in Power BI, including designing efficient data models using relationships and DAX calculations.
Created and optimized data models using Power BI's Power Query and DAX language to ensure efficient and accurate data representation
Expertise in integrating data from multiple sources into Power BI, including databases, spreadsheets, APIs, and cloud-based platforms.
Implemented row-level security and data-level security measures to restrict data access based on user roles and permissions
Proficient in writing complex DAX formulas for calculated columns, measures, and dynamic calculations.
Extensive experience using Power Query to clean, transform, and shape data before loading it into Power BI
Employed M-language to handle data cleansing and transformation tasks efficiently.
Proficient in developing interactive dashboards, product experiences and reports using Power BI, Tableau and ChatGpt.
Expertized in data visualization and storytelling techniques to effectively communicate insights and analysis.
Skilled in data extraction, transformation, and loading (ETL) process to prepare data for analysis in Tableau.
Strong understanding of data modelling and data warehousing concepts.
Proficient in SQL for querying and manipulating data.
Involved in daily/weekly status call with a client for requirement gathering and status updates.
Knowledgeable in advanced Tableau features such as calculated fields, parameters, sets, and table calculations
Experienced in creating complex visualizations, including heat maps, Tree Maps, scatter plots, and geographic maps.
Proficient in collaborating with cross-functional teams, including data analysts, business stakeholders, and IT professionals.
Excellent problem-solving and analytical skills to identify patterns and trends in data.
Strong attention to detail and ability to create visually appealing and intuitive dashboards.
Effective communication and presentation skills to convey complex information to both technical and non-technical audiences.
Produced reports to comply with industry standards for Bank Operations, MIS Reporting, reports as data feeds to drive various programs within the bank.
Experience in reporting environment Migration from Legacy system to Data Visualization environment
Worked on banking operations, training programs, and customer inquiries.
Actively participated in training and mentoring junior staff members, facilitating their professional growth and ensuring team cohesion
Proficient in assessing financial profiles, designing and development using Excel.
Ensured data security and confidentiality of borrower information in accordance with company policies and regulations.
Identified opportunities for process improvement within the origination process, streamlining workflows and enhancing efficiency.