Gurjit Kaur Oberoi

• Responsible for providing appropriate solutions, processing data or information, conducting analysis and preparing reports of findings
• Leveraging problem solving skills and framework to develop solution and documenting developed solution and preparing presentation
• Created data models to support decision-making processes.
• Coordinating with the client and senior consultant to implement recommended solutions and serving clients for their requirements of reports, solutions and any other services within the decided project scope
• Supporting clients in implementing the recommended solution, and developing and enhancing client applications based on the issue
• Liaise with client for requirement gathering, understand their issues, analyze those and documentation
• Recognized the root cause of a production problem; taking care and closely monitoring daily production cycles
• Estimated total efforts required for the implementation of requested changes; generated a user understanding document and analysed requirements that were received in the form of projects
• Planned and executed the requested changes; unit testing the requested changes
• Executed the test cases and documented test results and assisted during Integration testing; used appropriate quality tools to log defects, recording testing results and defects.

Project #1

Project Name: MPXM

Customer: Kaiser Duration: Feb 2024 - Sep 2024 Role: Business Analyst / Techno-Functional Lead Tools & Technology: Agile, Jira, Tableau, SQL, Python

Roles & Responsibilities:

• Led the Data Science and Data Visualization team to develop actionable insights for Kaiser Member Retention initiatives.
• Conducted root-cause analysis and optimized workflows to reduce data processing and model training time.
• Designed dashboards using Tableau to visualize retention metrics, helping stakeholders make data-driven decisions.
• Collaborated closely with the technical team to translate business requirements into technical specifications, ensuring timely and quality deliverables.

Project #2

Project Name: Claims Clustering Customer: Walmart Duration: 2023 - 2024 Role: Business Analyst / Team Member Tools & Technology: Agile, Python, SQL, Jira

Roles & Responsibilities:

• Worked closely with stakeholders to analyze business processes for claims clustering and identify if a claim can result into a dispute.
• Designed and implemented clustering models for claims processing using Python to improve claims categorization and resolution times.
• Prepared project ballpark effort estimations for Proof-of-Concept (POC) requests and provided data-driven recommendations to stakeholders.
• Monitored project progress and collaborated with technical teams to resolve roadblocks in Agile sprints.

Project #3

Project Name: Crop Anomaly Detection Customer: Jio Duration: 2022 - 2023 Role: Techno-Functional Analyst Tools & Technology: Python, TensorFlow, Tableau, SQL, VGG Annotator, Agile

Roles & Responsibilities:

• Collaborated with business stakeholders to understand and document requirements for crop anomaly detection.
• Designed and delivered machine learning models like SSD MobileNet and EfficientDet to detect crop issues, enabling early intervention.
• Conducted data analysis and pre-processing to optimize input datasets, improving model performance to 70%+ accuracy.
• Created interactive Tableau dashboards to visualize anomaly detection results and present insights to leadership teams.
• Provided value analysis by demonstrating cost savings potential to offer low-cost solutions to the farmers, give the farmers remote access, and reduce agriculture wastage.

• The scope of this design is ATM transaction processing which includes processing of incoming Transactions to HUB Application for deposits, transfers, PIN (POS), PIN (SIG), Credit cash advances, cash withdrawals to converted and unconverted checking and saving accounts from RAS, throughout the One HSBC core banking migration period.
• Defect Tracking and logging defects using the defect tracking tool.
• Accountable for mentoring peer team members with regular code reviews and feedback
• Interacted with internal customers to understand business needs and translate into requirements and project scope.
• Analyzed data to identify root causes of problems and recommend corrective actions.

• Description: Federal Employee Program (FEP) – provides health insurance to federal employees in Vermont who have selected BCBSVT as their insurer. It processes all of the claims generated by the federal employees, including all adjustments, suspense resolution and all Other Party Liability functions.
• Documented and demonstrated solutions by developing documentation, flowchart's, layouts, diagrams, charts, code comments and clear code.
• Identified ideas to improve system performance and impact availability, resolved complex technical design issues.
• Gathered requirements from the team lead, estimated total efforts required for implementation of requested changes.