Saswati Swain

Experience

• 

  SunLife

  Sept 2016 - Aug 2019

  Business Data Analyst

  • Worked with management to prioritize business and information needed.• Perform analysis of large data sets in MS Excel and Tableau.• Developed and managed visual system to track progress of work during sprints and projects.• Engaged in end to end data collection processes using qualitative and quantitative methods for 2 projects.• Applied ETL techniques during the migration of financial customer data to data warehouse tables.• Optimized poorly performing Sql queries. Through index reconstructing and referential integrity analysis. This made customer on boarding process faster.• Encouraged and facilitated cross-team coordination and collaboration.• Involved in ETL/BI requirement gathering and conversion into useful functional requirements. • Source to target data mapping document preparation. • Developed report wireframes along with SQL schema data element definitions. • Worked with Data Warehouse architecture and wrote SQL queries. • Applied dimension modeling to identify dimension & fact tables and associated data elements. • Familiar with wealth and asset management concepts as well as trading life cycles. • Conducted in-depth data analysis on the reports/dashboards to identify gaps. • Knowledge in BFSI domain and financial markets. Well versed with agile process, scrum and sprint concepts. Show less

• 

  Prudential Bank

  Sept 2019 - Apr 2021

  Business Data Analyst

  • Managed large datasets with huge observations using regular expressions and selecting key variables to build models for statistical logic.• Achieved huge reduction in customer complaints from minors, by performing data remediation activities such as Data validation on an API used by “Bank Authentication App”.• Created Data tables utilizing PyQt to display User information and add, delete, update User records. • Involved in development of Web Services using SOAP for sending and getting data from the external interface in the XML format. • Designed many workflows using Alteryx with connecting to oracle Database and developed Reconciliation Report at Month end.• Wrote and executed various MYSQL database queries from Python using Python-MySQL connector and MySQL db package.• Engaged with stakeholders to analyze and isolate root cause of data issues and drive data cleansing efforts.• Developed and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.• Strong experience in Unit, Regression, Validation testing and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.• Worked on Data mapping documentation for data consumption and extraction for reporting requirements.• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.• Guided the development teams on becoming self-organized, cross-functional thereby becoming a highly efficient team. • Experienced at root cause analysis, development, testing (unit, system, functional, integration and regression), code promotion and change management in SDLC.• Provided onshore/offshore team co-ordination.• Trained new members on the agile release train on agile mindset, scrum framework and SAFe.• Represented the team at the Scrum of Scrums meeting to report impediments for escalation. Show less

• 

  Cognizant

  May 2021 - Oct 2023

  Senior Business Data Analyst

  • Conducted market research and competitor analysis to identify new business opportunities.• Analyze and Interpret large datasets to identify trends and insights that drive business and financial decisions.• Performed various scrum roles by collaboratively working with the developers during sprints, guiding the product owner by prioritizing product backlogs, user stories, sprint backlogs, following up with the team and coordinating the scrum principles, values, guidelines and facilitate by removing impediments for fast and incremental product releases. • Performing all scrum roles as well as Refinement to ensure all deliverables will be on time.• Meet with application owners, application developers and analysts, coding staff and the like to determine business needs and functionalities desired for new or revised application.• Facilitate the discussions as of complex, high value IT delivery projects that require the coordination of development work or technology work on multiple platforms to achieve desired functionality.• Proactively facilitate scrum ceremonies for the team (Sprint, Planning, Grooming & Review/Demo, and Retrospective). Show less

• 

  Fugetron Corp

  Feb 2024 - now

  Senior Business Data Analyst

  @ Gathering business requirement and creating data pipeline to data warehouse using Collibra