Business Analyst Data Analysis

Aastha Chachra

Lead BSA

PROFESSIONAL SUMMARY

11+ years of experience as Business Analyst within Banking – Digital banking, Retail banking, Mortgages & credit card applications

Experience in Retail Banking, Loans, Digital Banking and other areas of BFSI.

Strong experience in requirement gathering, analysis, working as bridge between IT and Business, converting functional requirements to technical requirements and testing teams.

Proven ability to work efficiently within multiple requirements, design, and development methodologies, particularly within Agile frameworks.

Strong project management skills, demonstrated through successful leadership of cross-functional teams and an in-depth understanding of project management methodologies.

Extensive experience with BI tools such as Tableau, Power BI, MicroStrategy, and QlikView, leveraging them for comprehensive data analysis and visualization.

Strong data analysis skills to understand data models and structures, detect anomalies, and validate data accuracy.

Experienced in end-to-end software testing lifecycle, defect reporting, root cause analysis & test management.

Proficient in SQL and adept at handling data manipulation and validation in relational databases, with strong data analysis skills and an understanding of data models.

Experienced in using testing tools and frameworks, with a strong emphasis on creating detailed process flow charts, recording test cases, and meticulously documenting results.

Experience in regression & UAT (User Acceptance Testing) testing to ensure the stability of the BI system with updates and changes.

Proven analytical and problem-solving abilities, with a strong proficiency in MS Excel, MS PowerPoint & Tableau.

Extensive experience as a Business Systems Analyst, specializing in requirements gathering, business process optimization.

Exceptional communication skills, enabling effective technical communication with both technical and non- technical stakeholders, facilitating seamless collaboration, and understanding.

TECH STACK

Programming and visualization Tools: Tableau, MicroStrategy, Microsoft Excel, SQL, Microsoft PowerPoint

Tools/Software: JIRA, Lucid, Visio, HP ALM Databases: My-SQL, MS-SQL Server 2010, Oracle9i

Databases: My-SQL, MS-SQL Server 2010, Oracle9i

Functional skills: Data Analysis, Business Analysis, Project management, Requirement Gathering, Project Management, SME Banking domain

Operational Competencies: Agile/Scrum framework, Confluence, KPI (key performance indicators) Formulation, Process Optimization, SDLC, QA methodologies

WORK EXPERIENCE

Business Analyst

06/2024 to Present

Credit One Bank, Las Vegas, NV (Digital Banking)

Collaborated with stakeholders and cross-functional teams and facilitated requirement gathering for digital banking application transitioning from legacy system to EDP

Created High level flow diagrams, business process charts depicting the project flow in Lucid

Created Requirement Traceability Matrix and tracked project all stages of SDLC

Facilitate sessions for requirements gathering and user story creation, ensuring alignment with stakeholder expectations.

Managed project in JIRA and created documents in Confluence

Collaborate with Product Owners to document and refine user stories, providing clarity during the design and development phases.

Support cross-functional teams throughout the Software Development Life Cycle (SDLC) to ensure compliance with business requirements.

Develop comprehensive project documents covering functional and non-functional requirements, enhancing communication across teams.

Business Analyst

11/2023 to 04/2024

LivCor, Sacremento, CA

Elicited requirements through interviews, data modeling, and business process modeling to inform technology solutions.

Acted as a Subject Matter Expert (SME) during testing and post-production validation phases, ensuring high-quality deliverables.

Analyzed strategic problems, delivering insights that informed decision-making processes across multiple departments.

Business Analyst

03/2022 to 08/2023

Bank Of the West, San Ramon, CA (Retail Banking and Loans)

Conducted a comprehensive impact analysis to understand how the LIBOR to SOFR transition will affect various business areas, including contracts, financial products, and risk management.

Collaborated with stakeholders to gather detailed requirements related to the transition, including system changes, process adjustments, and regulatory compliance.

Worked with the IT team to align existing systems and processes with the new SOFR-based calculations and reporting requirements, ensuring a seamless transition without disruption to operations.

Developed a data migration plan to convert existing LIBOR-based data to SOFR, ensuring data integrity and accuracy during the transition.

Ensured that all activities related to the transition comply with regulatory guidelines and requirements, providing documentation and reports as needed to demonstrate adherence.

Identified potential risks associated with the transition and implemented risk mitigation strategies to minimize the impact on business operations and financial products.

Utilized SQL to perform data integration, aggregation, and calculations, enabling the generation of comprehensive reports and dashboards.

Communicated effectively with internal and external stakeholders, including clients, regulators, and industry partners, to provide updates on the transition progress and address any concerns or queries.

Developed training materials and conducted training sessions for internal teams to educate them about the implications of the transition and how it will impact their daily operations and decision-making.

Conducted thorough testing of systems, processes, and data conversions to validate the accuracy and functionality of the new SOFR-based infrastructure, ensuring that it meets the required standards and delivers expected outcomes.

Maintained detailed documentation of the transition process, including changes made, challenges faced, and solutions implemented in Confluence.

Generated reports to provide insights into the progress of the transition and its impact on the organization.

Continuously monitored the effectiveness of the transition in JIRA, gathered feedback from stakeholders, and identified areas for improvement to optimize processes and ensure long-term sustainability in the post-transition phase.

Handled all documented all project artifacts Planning, RTM, BRD, Summary reports.

Business Systems Analyst

06/2021 to 01/2022

NBCU - InfoCepts Technology Solutions

Collaborated with IT stakeholders to clarify and document business requirements, enabling the development teams.

Worked closely with development teams to ensure software features aligned with business requirements and provided expected benefits.

Translated business requirements into test scripts, validating software functionality and quality.

Acted as the first line of defense during testing, ensuring overall software quality and eliminating significant bugs before release.

Assisted in transitioning software solutions into production by providing informed training content.

Continued to support business partners post-implementation by remaining responsive to maintenance and improvement opportunities.

Analyzed data to identify trends, patterns, and insights that can inform business decisions.

Collaborated with business stakeholders to gather and document their data and reporting requirements.

Business Analyst

01/2021 to 05/2021

SPOK - Global Logic India, MH

Responsible for understanding user requirements and creation of BRD & FRS documents.

Translated business needs to development team.

Worked closely with clients and developer to get QA fixes in every release.

Responsible for UAT and JIRA management.

Ensured data accuracy, consistency, and reliability to support accurate reporting and analysis.

Responsible for supporting business taking better decisions through storytelling and recommendation of KPIs via Tableau.

Managed a team of 7 people, providing estimation, planning, and delivery for a complex client.

Collaborated across teams, including development, business, product, sales, and management.

Monitored projects in JIRA, managed user stories, and led SCRUM meetings.

Senior Business Analyst

03/2016 to 01/2020

Vertex Pharmaceuticals - InfoCepts Technology Sol Pvt Ltd India, MH

Responsible for understanding user requirements and working with business analysts at the client's end.

Performed end-end lead business analyst operations starting with requirement gathering, stakeholder management, collaboration with cross-functional teams, creating artifacts post requirement elicitation like process flow, data modeling, BRD and getting client sign off.

Analyzed tableau reports, dashboards on web and iPhone/iPad to display correct data as well as functional driving.

Work closely with data scientists and data engineers to ensure seamless integration of diverse data sources, including laboratory data, clinical trial data, and regulatory information. Ensure data accuracy, security, and compliance with industry standards.

Streamlined document templates through QMS implementation.

Served as an SME in the pharmacy domain, reporting and recommending KPIs in healthcare.

Mitigated risk by identifying a critical KPI validation error, saving millions of dollars.

Business Analyst

01/2011 to 01/2016

Keybank - Cognizant Technology Solutions India, MH

Analyzed banking data, stayed up to date with Federal Bank updates and legal teams to ensure regulatory and compliance measures are well adhered.

Collaborated with cross-functional teams including DEV, product manager, project manager and design teams.

Performed various testing (smoke, stress, integration) in all environments (SIT, DEV, PROD and UAT).

Managed QA lifecycle in HP ALM.

Monitored quality across multiple environments and conducted various testing types. Automated manual processes to optimize data delivery.

Monitored quality across multiple environments and conducted various testing types.

Worked with business partners to translate their business problems into data requirements.

Supported the Data Product Team and the business partners to conduct due diligence of current state of data and analytics needs.

Accomplishments

Streamlined documentation processes, resulting in a 20% reduction in project delivery time.

Enhanced stakeholder engagement through effective communication and relationship-building practices.

Successfully implemented a new feature for account opening in a digital banking platform, improving customer onboarding time by 30%.

Played a pivotal role in the transition to Agile methodologies within the team, leading to improved project delivery timelines.

Excellent project leadership skills, proactive, create plans, processes to facilitate effective issue resolution.

Expertise in reporting and presenting essential project management KPIs.

Skilled in identifying and prioritizing deliverables & delegating assignments.

Extensive conflict and negotiation skills

Committed to delivering high-quality results within tight deadlines in fast-paced environments with strong attention to detail.

Strong analytical and problem-solving skills.

Ability to define and measure key quality metrics.

Experience in creating test reports and presenting findings to stakeholders.

Received appreciation from client for weekend and extended weekdays support.

Received numerous appreciations on effective communication & presentation skills

Received Digital banking client appreciation for identifying blockers in every sprint.

Received accolades in reporting major data bugs.

Received SPOT award at InfoCepts for outstanding delivery in projects.

Received SYNERGY team award for overall team performance @InfoCepts.

Star of the Month Award/- June 2013 and March 2014.

Received Client Appreciation on Quality work on Test Strategy & Test Design in ECP project.

Education

Northeastern University

Master of Professional Studies in Analytics, Boston, MA

Shri Ramdeobaba Kamla Nehru College of Engineering and Management

Bachelor’s Industrial Engineering India, MI

Certifications

ISTQB-Foundation Level

PMP and Agile Planned

References

Available upon request

Contact this candidate