GUNBEEN SODHI
Levittown,NY
Summary
Data & Business analysis expert with scrum master experience (CSM Certified) for 7+ years. Experience in implementing projects of varying scale, scope, and technology in Healthcare, Banking, IT, Operations and Financial services. Strong knowledge in SQL, Excel operations, JIRA, User story writing, Tableau, Power BI and creating BA specific documentation like BRDs, FRDs & Flow chart designs
Overview
14
14
years of professional experience
1
1
Certification
Work History
Business & Data Analyst
ConcordUSA
08.2022 - Current
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Generated standard and custom reports to provide insights into business performance.
- Collaborated with stakeholders to define project objectives and criteria.
- Gathered and documented business requirements along with communicating them effectively to team members
- Handled story writing and maintained requirements for team using different platforms like DevOps ADO board and JIRA board
- Developed actionable business insights through comprehensive data analysis for informed decision making.
- Optimized JIRA projects for different project teams by streamlining and customizing workflow
- Drafted SOWs and provided guidance for Pre-sales documentation
- Performed complex analysis of datasets and conducted data validation across multiple data sources
- Designed Source to Target Mapping documents for customer database systems
- Performed Data profiling and data quality checks using SQL queries
- Enhanced customer’s tableau and Power BI reports for better performance and usability
- Executed analysis of risks and identified risk mitigation strategies.
- Trained team members on best practices in data management, increasing overall departmental proficiency in handling large datasets efficiently.
- Reviewed & suggested performance enhancement measures for various Client reports
- Developed complex dashboard and reporting tools to track business performance metrics.
- Experience with Google analytics, Google tag management and digital analytics development
- Organized trainings ensuring customer readiness for upgraded Power BI and Tableau reports
- Designed wireframes for new Tableau reports targeting specific Use case for each Stakeholders
- Analyzed Current architecture and designed future architecture flow for Snowflake azure implementation
- Documented data dictionary for different data domains like Membership, Benefits, Enrollment, Claims etc
- Partnered with IT teams to design efficient ETL workflows, ensuring smooth integration between various databases.
- Created Knowledge repository documents for team reference
- Designed various flow diagrams using Microsoft Visio and Lucid Chart.
Senior Business Analyst
CitiusTech Inc
08.2021 - 08.2022
- Conducted gap analyses to identify discrepancies between current and desired states, leading to actionable recommendations.
- Identified patterns and trends in large data sets and provided actionable insights.
- Analyzed and converted raw data into standardized format using data analysis tools
- Performed data quality checks and data profiling on raw datasets of Claims, patient, Quality care and enrollment data etc
- Analyzed processes and data for process optimization which improvised TAT for Client’s downstream applications
- Created source to target mapping document and Technical specification document highlighting highlighting end to end data flow
- Facilitated stakeholder interviews and brainstorming sessions, resulting in clear project objectives and deliverables.
- Performed risk assessments on potential projects to determine feasibility and viability before moving forward with implementation plans.
- Conceptualized and drafted Use case with data workflow for different Stakeholders
- Reviewed test cases and validate results and work with QA team for understanding
- Worked closely with all stakeholders including business customers, vendors, and internal resources in order to facilitate team communication
- Managed JIRA board for multiple projects and drafted user stories for team members
- Implemented Agile methodologies within project teams, increasing overall adaptability and responsiveness.
- Mentored Junior BA’s in executing specific functionalities and BA tasks as per project and Customer requirements.
- Collaborated with cross-functional teams, ensuring cohesive approach to business analysis.
Business Analyst
CitiusTech
05.2016 - 08.2018
- Gathered business requirements and addressed customer issues through competitive solutions
- Conducted interviews with key business users to collect information on business processes and user requirements.
- Designed Use Case Diagram, Activity Diagrams, Flow Charts and Data Flow Diagrams using Excel and Visio
- Created Business Requirement Document(BRD) and System Requirement Specification document(SRS) for customer and stakeholders
- Designed efficient and distinctive Tableau dashboards for Providers & Payers
- Performed thorough gap and competitive analysis for our clients
- Designed wireframes for Tableau, Cognos and Power BI applications through Balsamiq and Microsoft Powerpoint
- Generated ad-hoc reports to achieve specific business requirements.
- Conducted walkthroughs and demos of new or upcoming features of our product to prospective clients
- Recommended competitive solutions to business leaders leading to increase in client base
- Coordinated & collaborated with internal and external stakeholders for artifacts like Use Cases, User Stories, Screen Mock-ups and Product Demo presentations
- Designed data flow diagrams with help of Microsoft Visio
- Handled data requirements, data processing, validation and modeling using MS SQL, Excel & ETL frameworks
- Performed data integration and data profiling through SSIS packages to database
- Implemented and enhanced SQL Queries, Procedures and Views specific to customer centric reports
- Performed Scrum Master responsibilities like planning & executing sprints, prioritizing user stories, removing impediments and reporting team metrics
- Ensured effective Burndown and grooming sessions across teams
- Ensured all Scrum events are productive and time boxed for effective deliverables.
Business Analyst
Capgemini
08.2013 - 06.2014
- Analyzed Business and Data Requirements for Shipment Details and Price Drop Dates of products
- Defined user stories, tasks and acceptance criteria for team
- Build executive presentations and demos for new product features
- Project On Board Training for new team recruits and created knowledge repository documents
- Developed and enhanced client application to settle financial claims for its distributors
- Handled 10% more claims than usual through query optimization
- Improved application with functionality to validate and generate manual claims on price drop out of products
- Implemented new design for recorded data using .NET framework following Agile Methodology
- Performed feasibility analysis of current and target system for application upgrade.
Senior Systems Engineer
Infosys
06.2010 - 08.2013
- Managed Finacle e-Banking configurable and flexible components for retail, corporate and I-banks
- Improved application scalability by Database procedural calls optimization for enhanced user experience
- Analysed for Technology & System feasibility and implemented solution with time-to-market advantage
- Detected and fixed data integrity issues in application due to architectural and interface inefficiencies
- Devised integrated testing and re-factoring of application code which decreased space complexity.
Education
MBA - Masters of Management
Indian Institute of Technology
Mumbai, India04.2016
Bachelors of Engineering - Engineering
Panjab University
Chandigarh, India04.2010
Skills
- Business Analysis and Data Analysis
- SQL and Databases
- Excel & Microsoft Office expertise
- Technical Design Documentation
- Data Mining and Mapping
- Google Analytics and Google Tag Management knowledge
- Agile Scrum experience
- Tableau & Power BI
- User Story Writing
Websites
Certification
- (CSM) Certified Scrum Master
- IBM-Databases & SQL for Data Science with Python
- Google Analytics(GA4)
- Microsoft Certified Technology Specialist(MSTS)
Timeline
Business & Data Analyst
ConcordUSA
08.2022 - Current
Senior Business Analyst
CitiusTech Inc
08.2021 - 08.2022
Business Analyst
CitiusTech
05.2016 - 08.2018
Business Analyst
Capgemini
08.2013 - 06.2014
Senior Systems Engineer
Infosys
06.2010 - 08.2013
MBA - Masters of Management
Indian Institute of Technology
Bachelors of Engineering - Engineering
Panjab University
Similar Profiles
FAIZA UMERFAIZA UMER
Systems Analyst at Altera for NorthwellSystems Analyst at Altera for Northwell
Christian Smith-MaslauskasChristian Smith-Maslauskas
Tree Pruner at Incorporated Village of Garden CityTree Pruner at Incorporated Village of Garden City
Francine VitaleFrancine Vitale
Teachers Assistant at First Presbyterian PreschoolTeachers Assistant at First Presbyterian Preschool
Diptti SharmaDiptti Sharma
Med/Surg Rehabilitation Registered Nurse at Glen Cove HospitalMed/Surg Rehabilitation Registered Nurse at Glen Cove Hospital
CHRISTINE SUAREZCHRISTINE SUAREZ
Business & Data Analyst at LG CNSBusiness & Data Analyst at LG CNS