JS

Japjeet Sodhi

Business Data Analyst · California Department of Justice


In My Own Words

• Business Data Analyst with hands-on experience in Agile Scrum software development for enterprise products working side-by-side with multiple teams in multiple time zones
• Expertise in data visualization and dashboard design (Tableau). Strong data storytelling, strong communication skills with proven expertise leading visualization design and/or business dashboard working sessions.
• A go-getter with exceptional problem-solving skills.
• Designed, developed, tested, maintained Tableau functional reports based on user requirements.
• Team player with good communication and interpersonal skills and responsible for interacting with business partners to identify information needs and business requirements for reports.

Work Experience

Business Data Analyst

California Department of Justice

2020 – 2021

| Remote, CA • Spearhead requirements for CSAR (California Sex Arson Registry) Optimization Project by collaborating along with Project Stakeholders, Business VCIC/ ORAU and IT development team. • Use Analytical thought process to create Tableau data visualization dashboards using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographical maps, Pie Charts, Bar Charts, Density Chart, Gantt charts. • Validate reconciliation checks by performing data hygiene checks on the source and target databases for all columns using Oracle SQL. • Work upon Advance analysis Actions, Calculations, Parameters, Background images, Trend Lines, table calculations, calculated fields, Bins, and hierarchies using Tableau Desktop. • Creating SQL queries and optimizing SQL queries for data analysis. • Utilized Tableau Server to publish and share the reports with internal business teams. • Building interactive Tableau dashboards with multi-layer drill down for operation optimization. • Define Use Cases, Problem Statements and Test Cases for CSAR Optimization project and utilized RTM to trace requirements throughout the development process and verifying adherence. • Enhanced Petitioning and Optimization functionality within the CSAR application, utilized by Law Enforcement Agencies (LEAs) across California. • Developed business intelligence tools such as interactive Tableau, Excel, dashboards to support sales reps and managers for customer analytics and supports. • Operate in an agile team environment and ensure success of the project by taking ownership of deliverables and performing agile project management, testing, support, and training. • Support cross-functional stakeholders, performing client Demo sessions, and capturing feedback. • Monitor and measure progress, defect Tracking using JIRA and performs UAT to help ensure that all the functional requirements were met.

Business Analyst (Contract)

Apple Inc

2020 – 2020

• Liaison between the Business stakeholders and IT team for Accelerate Pay Product under Finance and Admin Systems Team.

• Work collaboratively with senior team members and cross-functional stakeholders to evaluate and drive Change request and requirements.

• Support Agile SCRUM SDLC Model and conducts Gap analysis for business process improvement using Excel.

• Work closely with the Product Manager to translate roadmaps into user stories that are part of a well-groomed backlog • Define thorough Invoicing Automation business requirements (PRD document) using MS Visio, created test cases.

• Highly collaborative and proficient at leading cross-functional teams across engineering, development, business, and sales departments. • Tuning SQL query to optimize Tableau, Access, and Excel dashboard performance. • Trace requirements throughout the development process using Requirements Traceability Matrix, RTM

• Created pivot tables, charts using worksheet data, utilized MS Excel formulas including Conditional formatting, VLOOKUP, HLOOKUP etc.

• Executed the project using Rally for requirement management and performed UAT with stakeholders.

Business Data Analyst

Cisco Systems

2019 – 2019

• Managed Cisco Clarity PPM (Project and Portfolio Management) project by working along with cross-functional stakeholders for IOPS OBIEE Team. • Build Tableau data visualization dashboards using Bar graph, dual-axis bar chart, stack bars, and created different KPI using calculated key figures and parameters. • Optimizing Access performance with improved tables and SQL queries. • Good understanding of technical trends and utilized Tableau Desktop on generating various Tableau functional dashboards and reports (Fixed Asset Audit report and Out of Compliance report) from Excel data source and share the reports with the Cisco Asset Owners and Laboratory Management Team. • Utilized Rally tool to track release cadence and utilized the tool for defect logging and tracking. • Executed Business Acceptance Testing by working collaboratively with development and testing team to help ensure that all the functional requirements are met. • Bridge between the Business stakeholders and IT team for NextGen CPDM Project (B2B Platform domain) in Enterprise Engineering Business Operations Team • Gather requirements for Cisco Compliance Technical Product standards such as Leap Second, Smart Licensing, Coding Standards, Programmability, Serviceability and IPv6. • Elaborate user stories for implementation, working with the Product Manager to ensure alignment toward the business vision and strategy. • Coordinate across multiple operations teams to add reporting insight and support reporting needs. • Develop and deliver data-driven insights and recommendations for our stakeholders. • Performed Gap analysis, document BRD's, worked on creating smartsheets, created HTML mockups of user stories, and test cases for each NextGen technical Product standard using Oxygen XML Editor and utilized Content Management System, AEM tool for publishing the content. • Utilized Agile SCRUM Model, participated in SCRUM ceremonies and worked collaboratively with on-shore and off-shore stakeholders from gathering, analyzing business requirements, ensures requirements with traceability and driving sessions as well setting up the future sessions articulating what happens next and remove roadblocks and executed BAT by working collaboratively with team.

Business Data Analyst

Lululemon Athletica

2017 – 2018

• Worked on enhancing/adding functionalities at Lululemon E-commerce website to attract millennial visiting website and providing better user experience and utilized Agile SCRUM SDLC Model • Executed the project using Rally to capture project requirements assign tasks to specific users. • Provided timely status reports and metrics using Tableau Desktop and Tableau Server. • Designed and developed Tableau visualization solutions for Sales Success team. • Implemented data blending to blend related data from different data sources. • Creating visual reports designed to assist field sales teams and internal management in product placement. • Wrote Custom SQL in Tableau to support business requirements. • Worked on creating and modifying worksheets and various interactive dashboards using various data source. • Designed rich Graphic visualizations with Drill Down and Show Me functionality and different KPI using calculated fields and parameters in Tableau. • Communicated analysis effectively to internal team and clients and perform UAT with the team.

Education

Master of Science

Amity University

Master of Science

Bachelor of Science

Delhi University

2017

Bachelor of Science