Richa Singh
Business Analyst
Clyde North
Summary
Data driven Business Analyst with 8+ years of experience, specializes in Business Intelligence (BI), Data Warehousing, and Analytics solutions. Skilled at translating business requirements into technical solutions. Proven track record of improving operational efficiency by 30%. Skilled at developing an automated data quality framework, resulting in a 40% error reduction. Strong background in the fintech, superannuation and healthcare industries, with experience working on large-scale transformation projects implemented on cloud.
Overview
9
9
years of professional experience
Work History
Consultant
Energy Australia
05.2024 - Current
- Developed intelligence-sharing dashboards, providing company-wide access to sales data
- Monitored key performance indicators (KPIs) through Power BI dashboards
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools
- Facilitated knowledge-sharing sessions that improved team cohesion and communication, leading to a more efficient sales process and better customer engagement
- Collaborated with cross-functional teams like Marketing, Product, Risk, and Onboarding to optimize customer experiences and achieve set organizational goals
Solutions Consultant
Australian Retirement Trust
09.2023 - 12.2023
- Assessed and analyzed the current customer onboarding process to identify inefficiencies and areas for improvement
- Acted as a bridge between internal teams to provide customers with a unified, seamless experience
- Maintained in-depth understanding of relevant superannuation legislation, regulations, policies and procedures, ensuring that all customer inquiries were handled efficiently
- Trained internal teams on updated processes and best practices to ensure consistency
Senior Data Business Analyst
Ameriprise Financial Services, LLC
08.2021 - 02.2023
- Conducted workshops to gather end to end requirement for data onboarding, data manipulation and data consumption
- Managed existing data models and created new data models for curated data
- Worked on source to target data mapping documents for 20+ objects in the Glue Catalog
- Collaborated with cross-function teams to define feature group requirements and produced functional designs for 200+ metrics, resulting in a 30% reduction in turnaround time
- Leveraged SQL to perform detailed analysis of large datasets for data curation, data acquisition, and data migration
- Implemented a metadata-driven approach to dynamically create data quality rules at runtime using Deequ that reduced defects by 40% and reported findings using QuickSight dashboards
- Conducted workshops to educate numerous stakeholders, including data scientists and engineers on best practices for utilizing Data Lake
Business Analyst
Conduent Business Services India Pty Ltd
03.2018 - 08.2021
- Worked on data migration from Advantage to RKS system for 10+ clients
- Developed mapping documents that precisely define how data flows from the source to the target, maintaining consistency and reliability throughout the process
- Conducted 20+ workshops with business stakeholders and SME(s) to gain high-level knowledge of the business process and draft relevant documentation
- Experienced in reverse engineering, building requirements from analyzing PL/SQL procedures in addition to new requirements
- Checked source data to verify completeness and accuracy, addressing incomplete or missing data fields to streamline the application of analytic scripts
- Design customized Power BI dashboards to meet specific organizational needs
- Implement row-level security and data governance measures within Power BI reports
Business Analyst
Alight Solutions
03.2016 - 01.2018
- Maintained project documentation such as requirements traceability matrix, test plans and user guides
- Developed comprehensive test plans for the testing team, ensuring thorough coverage of software functionality and conducted rigorous UAT to validate software against user requirements
- Developed SQL queries to extract relevant data for client reporting, ensuring accuracy and timeliness
- Defined and tracked quality assurance metrics such as defects, defect counts, test results, and test status
- Created and reviewed functional test cases and audited the quality of deliverables at intervals
Education
Bachelor of Technology in Information Technology -
Guru Gobind Singh Indraprastha University
04.2001 -
Skills
Technical: Power BI, AWS, SQL, Snowflake, Agile methodologies, JIRA, Data Modelling, Data Warehouse, Requirement Gathering, Process improvement, Quality Assurance
Interpersonal: Communication, Conflict resolution, Problem solving, Attention to details, Stakeholder management
Key Competencies
- Designed and implemented ETL processes within the cloud environment, producing functional designs and detailed data mapping documents and integrated it into the data warehouse.
- Expert in Power BI: Dashboards, data visualization, and user enablement training for self-service BI solutions.
- Strong understanding of data modeling and relational database concepts.
- Advanced SQL skills for detailed data analysis, validation, and testing.
- Proficient in performing root cause analysis to identify and resolve data anomalies and discrepancies using SQL.
- Skilled in facilitating requirement workshops, conducting user interviews, conducting surveys and leading brainstorming sessions to generate business solutions.
- Proven capability in designing integration solutions, enabling seamless data flow across enterprise systems.
- Experienced with creating current and future-state process maps, entity relation diagrams, and data flow diagrams for existing systems and enhancements
- Capable of preparing business requirement specifications, functional requirement specifications, Design documents, technical documentation and traceability matrices.
- Skilled in Agile frameworks such as Scrum, Kanban, Lean and Waterfall for efficient project delivery.
- Actively participated in Agile sprint ceremonies (e.g., daily standups, backlog grooming, planning, and retrospectives) to deliver cloud-based big data solutions effectively.
- Skilled in utilizing project management and documentation tools such as Jira, TFS, Maestro, OneNote, and Confluence, among others.
Timeline
Consultant
Energy Australia
05.2024 - Current
Solutions Consultant
Australian Retirement Trust
09.2023 - 12.2023
Senior Data Business Analyst
Ameriprise Financial Services, LLC
08.2021 - 02.2023
Business Analyst
Conduent Business Services India Pty Ltd
03.2018 - 08.2021
Business Analyst
Alight Solutions
03.2016 - 01.2018
Bachelor of Technology in Information Technology -
Guru Gobind Singh Indraprastha University
04.2001 -
Similar Profiles
Phoebe LionhartPhoebe Lionhart
Energy Sales Representative at Energy AustraliaEnergy Sales Representative at Energy Australia
Sunil NuluSunil Nulu
Energy Assist Specialist at Energy AustraliaEnergy Assist Specialist at Energy Australia
PALLAVI BISHTPALLAVI BISHT
Senior Sales Consultant at Energy AustraliaSenior Sales Consultant at Energy Australia
Ben MontgomeryBen Montgomery
Food Service Worker at Kentucky Fried ChickenFood Service Worker at Kentucky Fried Chicken
Arman KaurArman Kaur
PCA at Workforce ExPCA at Workforce Ex