Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Timeline
Generic

Sindhuja Poddar

Land O' Lakes,USA

Summary

Experienced Senior Business Data Analyst with 6+ years of experience in the HealthCare industry. Data analyst with expertise in Microsoft SQL, Informatica, MS Office Suite, and Google Cloud Big Query. Skilled in data analysis and profiling. Experienced professional adept in documenting BRDs, FRDs, and Data flow Diagrams with a focus on clarity and conciseness. Skilled in version control and ensuring regular updates throughout the project lifecycle. Experienced in healthcare insurance processing including Medicaid and Medicare claims processing with a firm understanding of State regulations. Skilled in collaborating with stakeholders to understand business needs and align technology solutions accordingly.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Business System Analyst

Independence Blue Cross
Philadelphia, PA
12.2022 - Current
  • Served as a Business System Analyst for multiple projects like Accumulators, Extracts, Pennie JSON Files, External Fee on Funding customers, and Claims Re-write, PAR-NON PAR project, Web Audit File
  • Provided Functional Requirement Documentation, Data Mapping Documentation, Data profiling, Running SQL queries, and showcasing Data to better understand the requirements during handshaking sessions
  • Conducted in-depth data analysis using SQL to identify patterns, trends, and anomalies, ensuring accurate and reliable data for business stakeholders
  • Created and maintained detailed data mapping documentation, facilitating seamless communication between technical and non-technical team members
  • Developed and documented Functional Requirements Documents (FRD) to articulate business needs and system requirements for various projects
  • Collaborated with stakeholders to gather and analyze business requirements, translating them into actionable solutions for the development team
  • Implemented robust data profiling strategies, identifying data quality issues and recommending improvements to enhance overall data integrity
  • Conducted regular data validation and cleansing processes to maintain the highest standard of data accuracy
  • Collaborated with cross-functional teams to troubleshoot data-related issues and optimize data processes
  • Expertise in real-time DATA Flow concepts like- HashKey Functionality, UPDATE & INSERT Logic, Staging Tables, Delta tables, Soft Delete Logic
  • Proficient in writing complex SQL queries to extract, manipulate, and analyze large datasets from relational databases
  • Experienced in using SQL functions such as JOIN, GROUP BY, and HAVING to derive insights and generate reports
  • Utilized aggregate functions (e.g., SUM(), COUNT(), AVG()) to perform data analysis and identify trends and patterns
  • Developed and optimized SQL queries for performance, ensuring efficient data retrieval and analysis
  • Created Common Table Expressions (CTEs) to simplify complex queries and improve readability
  • Conducted data validation and cleaning using SQL to ensure data integrity before analysis
  • Provided technical support to the development team by troubleshooting and resolving system-related issues
  • Gathered, analyzed, and documented business requirements from stakeholders in order to create functional specifications for software development projects
  • Developed test plans and conducted unit testing of new software applications prior to release into production environment
  • Created process flow diagrams, data models, use cases, workflow diagrams, and other documents as needed for project deliverables
  • Conducted user acceptance testing with stakeholders to ensure that all requirements are met before final implementation

Sr. Business System Analyst

Highmark wholecare
Pittsburg, PA
10.2020 - 02.2023
  • Company Overview: Formerly called Gateway Health Plan, Acquired by Highmark wholecare
  • GateTech remediation: Going from DST platform to UST Platform, different claims processing platforms from different databases (Oracle to MS SQL)
  • Worked with multiple External vendors and documented data specifications for Authorizations, Enrollment, Claims, Provider feeds
  • Worked on analyzing and documenting Mapping documentations for Authorizations, Enrollment, Claims, Provider feeds
  • Playing a major role of liaison between tester and developer, being a point of contact for project-related activities
  • Consulting support to team members, hand off sessions with Developer and QA team explaining the Workflow
  • Constantly meeting Subject Matter Expert's (SMEs) for sourcing data and discussing possible scenarios
  • Experience in writing complex SQL queries using JOINS, AGGREGATE functions, DATE Functions, and applying filters to extract data by using multiple datasets
  • Providing business process and system support, data quality governance through data coordination to ensure consistent data flows to business and stakeholders
  • Understanding the organization's data, identifying, capturing, classifying, and monitoring data use cases as appropriate, and making recommendations around refining existing processes for data use identification, review, and management
  • Well versed with Basic SQL functions like COUNT, DISTINCT, LIKE, DATE AND TIME Conversions, ORDER BY, AND /OR Clauses
  • Conducting testing and system validation to troubleshoot issues related to data management and system
  • Experience with Delimiter files generation(Pipe, Tab, comma Delimiters) and validating them to mapping document
  • In order to Increase the efficiency and performance came up with the idea of developing Views, Flat tables and provided mapping documentation in order to build these
  • Provided mapping documentations for Enrollment, provider – supplier and Claims standard layout to share with external vendors
  • Closely Working with Product owner for breaking down Large features into Epics and Stories, essentially helping in sprint planning and retrospective sessions
  • Identifying and implementing process improvements in relation to data processes
  • Responsible for writing advanced SQL to dig into the database, and pull accurate data for customers
  • Expertise in writing SQL Union clauses, Nested Queries, Sub queries, Temporary tables
  • Well versed with ICD-9, ICD-10, Medicaid, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing alternative solutions
  • Receiving Business requirements and identify which DB to go to, and then create a mapping document for said customer
  • Created UAT Test plan documents and Post Deployment Test Plan Documents and performed end to end validation
  • Good understanding of Scrum Kanban Methodologies, Jira and confluence Dashboards
  • Work closely with the ETL Developers and Technical BAs to refine system requirements
  • Map data for ETL processes and determine and document system requirements
  • Experience in using Informatica Power Center 10.4 Repository, designer, workflow monitor and session logs
  • Ability to work with end users who may not be technically savvy, Strong interpersonal skills
  • Strong experience in the MS Office products, particularly Excel, Strong problem-solving and analytical skills
  • Formerly called Gateway Health Plan, Acquired by Highmark wholecare

Technical Analyst & Tester

BN InfoTech
04.2017 - 02.2018
  • Worked in different projects and provided Source to Target Mapping (STTM) documents for Enrollment data, Medical Claims, Pharmacy Claims, Provider data, Authorization and discharge feeds
  • Hands-on experience in handling and processing ETL application with extensive knowledge of testing and validating data warehouse
  • Designing and maintaining data systems and databases; this includes fixing coding errors and other data-related problems
  • Proficient in writing SQL queries using JOINS, AGGREGATE FUNCTIONS like GroupBy, Having Clauses, Row number /Rank over partition By, Cross apply Functions
  • Experience in writing complex SQL queries using complex joins, grouping, aggregation, nested subqueries
  • Strong in analyzing and understanding business specifications, testing requirements, and developing test plans, test cases, test scenarios, and traceability matrix
  • Involved in agile development and participated in everyday scrum meetings
  • Primarily responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables
  • Tested loaded data warehouse components like ODS (Stage), EDW and data marts tables after the jobs run
  • Experience in documenting requirements using UML and Flow diagrams
  • Proficient in creating use cases and swim lane diagrams using MS Visio
  • Strong in ETL data validation, developed using Informatica ETL environments
  • Test the flat file data transfers
  • Check modeling views based on the target tables
  • Created context and workflow models, information and business rule models, Use Case during the analysis using Rational Tools
  • Tested the ETL Informatica Jobs and other ETL Processes (Data Warehouse Testing)
  • Handled SCD Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse
  • Working Knowledge of Defect management process, Risk Framework and mitigation, and Enterprise Testing standards
  • Used Generic UNIX shell scripts to access and move files from production to development environment
  • Verify the tables in source system for count check, data type check, no spam data loaded
  • Develop and Design ETL test cases, scenarios, and scripts to ensure quality Data warehouse
  • Strong leadership skills, as demonstrated by the ability to facilitate process changes, foster innovative work environment and manage competing priorities
  • Demonstrate excellent communication (verbal and written) and time management skills with an ability to multitask, prioritize and meet deadlines

Business Analyst

Highmark
Camp Hill, PA
09.2015 - 12.2016
  • Involved in gathering Business Requirements from sales/marketing team and business analysts and performed detailed analysis of business and technical requirements
  • Assisted the senior business analyst in defining the scope, and defining business rules of the project
  • Analyzed client's business requirements and processes through document analysis, interviews, workshops, and workflow analysis
  • Collecting and interpreting data, analyzing results and Reporting the results back to the relevant members of the business, Identifying patterns and trends in data sets
  • Work alongside within the business or the management team to establish business needs and Defining new data collection and analysis processes
  • Expertise in complete end - to-end project implementation and consulting in ServiceNow and best ITIL practices
  • Experienced with the ITIL process in ServiceNow: Incident Management, Problem Management, Change management, Knowledge Management, Project Management
  • Experienced in ETL testing, manual and automated testing, and black/white box testing
  • Well-versed in ETL processes, performance-based systems, and ETL process flow and standards
  • Created to be process flows of systems including cross functional diagrams/swim lane diagrams
  • Provided Visio diagrams to the customer to socialize the customer on the development process
  • Analyzing the Automation Test Plan and creating a Design document for the HP QTP /HP UFT script to be created
  • Developed and Executed Automation and Manual test cases for Functional testing of various modules of the application
  • Perform Regression execution using HP QTP/HP UFT scripts to ensure existing functionalities work properly
  • In-depth knowledge of Enterprise Data warehousing ETL, Data warehousing requirements, and Enterprise level data warehousing
  • Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance and functionality

Education

Master's Degree - Computer Science

Rivier University
NH

Skills

  • Microsoft SQL
  • Google Cloud BigQuery
  • Source to Target Mapping Documentation
  • Functional Requirement Documentation
  • Data Profiling
  • Requirements Gathering
  • Communication skills
  • Process Flow/Data Flow Diagrams
  • MS Office (Word, Excel, Visio, PowerPoint)
  • Domain knowledge
  • Agile Methodology (JIRA, Azure DevOps)

Certification

Certified Scrum Master (CSM)

Personal Information

Title: Business System Analyst

Timeline

Business System Analyst

Independence Blue Cross
12.2022 - Current

Sr. Business System Analyst

Highmark wholecare
10.2020 - 02.2023

Technical Analyst & Tester

BN InfoTech
04.2017 - 02.2018

Business Analyst

Highmark
09.2015 - 12.2016

Master's Degree - Computer Science

Rivier University

Similar Profiles

CREATE PROFILE
Sindhuja Poddar