Summary

Business Data Analyst with a solid *+ years of experience, excelling in unearthing insights through data exploration and visualization to guide strategic business decisions. Known for a forward-looking approach in leveraging SQL and Agile methodologies to enhance operational efficiencies and drive continuous improvement. Adept at synthesizing complex data sets to provide actionable intelligence, aiming to leverage these skills to contribute to future-oriented business solutions.

Recent Project Undertaken

https://scholarworks.lib.csusb.edu/etd/1783/ LIVE AUGUST 2023 Conducted an extensive research project aimed at predicting water quality levels under varying climatic conditions pre and post monsoon in Telangana State, India, spanning from 2018 to 2020. This culminating experience involved rigorous data analysis and exploration, supervised by Dr. Cornard Shyao, Committee Chair.

Employed advanced statistical techniques, including linear regression with Water Quality Index, to analyze water quality trends in the Telangana region.

Further enhanced the study by implementing cutting-edge machine learning algorithms such as Light Gradient Boosting Machine, Random Forest, and Artificial Neural Network, thereby expanding the predictive capabilities and accuracy of water quality analysis.

Work Experience

Sizzle Impex Private Limited Business Analyst Punjab, India Aug 2017 - Feb 2021

Collaborated effectively with colleagues and stakeholders to thoroughly comprehend and prioritize critical business requirements, ensuring alignment with organizational goals and objectives. Involved in all stages of the SDLC (Software Development Life Cycle) for a Web Development Deployment. Assisted the Product Owner (PO) in defining Key Performance Indicators (KPIs) and performed Scope Analysis, Impact Assessment, Root Cause Analysis, Effort Estimation, Cost-Benefit Analysis, SWOT Analysis, and Feasibility Study specific to web services applications. Identified and categorized all relevant Website Services stakeholders, including administrators, and users, using the RACI Matrix. Conducted one-on-one interviews, JAD sessions to gather specific requirements, and documented them in terms of Epics/user stories.

Collaborated with the Project Manager to create a Project Charter and Work Breakdown Structure (WBS) tailored projects. Ensured project scope aligns with regulatory standards and guidelines. Collaborated closely with administrators for scheduling data jobs into the system using Oozie in Hadoop, considering patient data privacy and security.

Maintained Referential Integrity of data verified that clinical data captured in the front-end applications are correctly stored in the back-end database, ensuring patient data accuracy. Collaborated with data engineers and architects to design and implement Apache Spark and MLLib libraries for data analytics and predictive modeling.

Divy Jot

Business Data Analyst

1439, NorthStar Street, San Bernardino, United States, 92407 909-***-****

ad4tax@r.postjobfree.com

Work Experience

Tech Mahindra India

Jan 2018 - Jun 2018

Identified gaps in existing policy administrating systems and Guidewire Policy Center and designed the AS-IS and TO-BE process, the scope and out of scope documents. Create use case diagrams for claim filing journey and developed UML diagrams like Use Case diagrams, Sequence diagrams and flow diagrams using Rational Rose. Responsible for the Source system exploration and analysis, Data transformation logics by creating Data Mapping Document, performing the data mapping and validating the Data Marts using the Informatica PowerCenter.

Performed data integration and data mapping and extraction management along with data cleansing while migrating data from legacy system to Guidewire Claim Center and Guidewire Data Hub. Helped the Product owner in finalizing the Minimum viable product (MVP) and maintaining the Product Backlog and the Sprint Backlog by assisting the Product owner in prioritization and estimation of Product Backlog Items.

Assisted the Scrum Master to maintain the Sprint/ Release Burn-up and Burn-Down charts, Velocity Chart in JIRA.

Managed sprints artifacts i.e. burndown charts, project velocity, sprint backlogs and product backlogs using JIRA, managed and shared these artifacts using Confluence tool. Performed data integration and data mapping management along with data cleansing while migrating data from legacy system to Guidewire Policy Center.

Worked with QA team to design and develop Test Plan, Test Scenarios and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing and maintained the report for the test results.

Bright Roots Soft solutions Pvt Ltd BUSINESS ANALYST (Internship) Punjab, India May 2016 - Dec 2016

Worked in Facets with different modules like Subscriber, Claims Processing, Billing and Providers Applications.

Recommended changes for system design, methods, policies and workflows affecting Medicaid claims processing.

Performed data source exploration, data profiling, data cleansing and created data mapping document followed by creating various mappings using transformations to migrate data into the data marts and ODS using Informatica.

Wrote complex SQL queries to manage and retrieve data for further analyzing using Data Visualization tools. Created high fidelity and low fidelity UI Mock-up and Wireframes prototypes for the stakeholders using Balsamiq.

Used Swagger UI and Swagger Editor to document the request and response of the front-end RESTful API’s. Responsible for the core activities of test team including creating and executing test cases, documenting results and drawing a Requirement traceability matrix (RTM) to match the requirements with final test scenarios using HP ALM.

Involved in bug tracking and defect prevention activity using JIRA to improve issue/bug fixes and maintain the issue log.

Assisted in preparation of UAT test plan, Test Cases and performed UAT to validate the solution based on the tests.

Education

Master of Science in Information Systems California State University San Bernardino San Bernardino, CA

Aug 2021 - Jul 2023

Graduated with a Master's degree in Information Technology, specializing in Business Intelligence. Acquired expertise in a range of critical areas including Big Data management, data analytics, business management principles, and proficiency in programming languages such as Python, SQL, and RStudio. Developed a strong foundation in machine learning techniques, positioning myself to effectively leverage data-driven insights for informed decision-making in diverse business contexts. Master of Business Administration Panjab University Punjab, India In my MBA program, I acquired expertise in formulating and executing business strategies. Through rigorous coursework and practical application, I gained a deep understanding of various strategic frameworks, including SWOT analysis, Porter's Five Forces, and strategic planning methodologies. Additionally, I developed the skills to assess market dynamics, identify competitive advantages, and craft sustainable strategies that drive organizational growth and success.

Bachelor's in Computer Application Punjab University, Chanadigarh May 2009 - May 2013

Environment

Waterfall-Scrum Hybrid, JIRA, Balsamiq, HP LoadRunner, HP QC, MS SQL Server, MS Visio, MS Office (word, power point, excel)

Contact this candidate