Karamveer kaur
fremont,ca
Summary
Business systems analyst with total of 4+ years into BFS IT, Software, Regulatory Reporting and ETL/Data Warehousing domains. Experience working in both scrum and waterfall methodologies of software development. Knowledge in organizing, leading, and setting the agendas for sprint ceremonies (sprint planning, daily scrum, sprint review, sprint retrospective and backlog refinement). Proficient in eliciting client requirements through interviews, workshops, and existing records. Extensive years of experience working with Agile environment in Technical Requirement Gathering and liaising between Business needs and Solutions. Highly efficient in writing skills preparing Business Requirement Document (BRD), Functional Specification Document (FSD), Systems Requirement Specification (SRS), Data mapping and ETL documentation, User Stories, Use Cases, and Test Cases. Experienced in performing Business Process Analysis to check the compatibility of the existing system infrastructure with the new business requirements and translating user expectation. Conducted JAD sessions involving Subject Matter Experts (SME’s) asking functionality aspects of business process and carefully updating the information as requirements in an easily understandable format. Expertise in creating Unified Modeling Language (UML) diagrams i.e., Use Case Diagrams, Activity Diagrams along with Data Flow Diagrams, Entity Relationship Diagrams, and Flowcharts. Performed GAP analysis, SWOT analysis, Impact analysis, and cost/benefit analysis to maximize the productivity and reduce the cost. Highly experienced in techno-functional roles, expertise comprising of AS-IS and TO-BE analysis, Gap Analysis, and Process Mapping, Data mapping, integrations, batch processing.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Business Systems Analyst
Goldman Sachs
San Francisco
04.2022 - Current
- Company Overview: The Goldman Sachs Group, Inc. is an American multinational bulge bracket investment banking and securities firm that engages in global investment banking, securities, investment management, and other financial services primarily with institutional clients.
- Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies.
- Conducted JAD sessions for effective communication of vision and goals between stakeholders and gathered business requirements.
- Designed Data Flow Diagrams (DFDs), Entity Relationship Diagrams (ERDs) and web-page mock ups using modeling tools.
- Prepared Business Process Models that presented modeling of all the activities carried on by the business from the conceptual to procedural level.
- Effectively utilized prototypes to demonstrate and verify the behavior of the system.
- For User Acceptance Testing (UAT) provided technical and procedural support.
- On a regular basis communicated and interacted with the users, project manager and development teams during various stages of the product life cycle to make sure everyone was on the same lines.
- Maintained documents for change request and implemented procedures for testing changes.
- Maintained Requirement Traceability Matrix (RTM).
- Interacted with technical team in letting them to make a better navigational plan for the project flow that makes a better user interactivity for the application.
- Signed off on progress and completion reports which were then submitted to project management on a weekly basis.
- Responsible for the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
- Primarily responsible for interacting with the users and business relationship managers and changes on the database in order to ensure UAT completion.
- The Goldman Sachs Group, Inc. is an American multinational bulge bracket investment banking and securities firm that engages in global investment banking, securities, investment management, and other financial services primarily with institutional clients.
- Environment: Rational Rose, MS Office Suite, Oracle9i, Windows NT/XP, Business Objects, ASP.Net, BizTalk 2006, SQL, Excel, Oracle, Windows, Rational Rose, Rational RequisitePro, RUP, UML.
Business Systems Analyst
Citi Bank
San Francisco
07.2019 - 06.2022
- Deliver in-depth analysis for significant projects and programs with a focus on producing datasets for complex data integration, analytics, and reporting.
- Working closely with solutions architects, data engineers, and business partners, you can make sure that data architecture, data models, and ETL methods support best-in-class solutions.
- Create mapping and transformation specifications to assist vendor integration and internal development teams.
- Perform in-depth data analysis and investigations to confirm findings and make recommendations for the development of data solutions.
- Communicate effectively with both business partners and technical teams, acting as the bridge between business needs and priorities and translating into details specifications for developers.
- Become a subject matter expert on domain data, reflecting both knowledge of business landscape and data in the application ecosystem.
- Worked on detailed requirements definition, enterprise architecture, project management, user stories, data mapping, data modeling, API development and data acquisition as per client requirement and captured in BRD/SRS for work stream using tools like JIRA and Confluence for source systems across different geographies.
- Written Business requirement documents (SRS), Test cases and provided overall functional/domain support.
- Facilitate requirements gathering sessions, define business solutions, POC/POTs, Demos and joint meetings with the diverse stakeholders.
- Supported the overall SDLCC, UAT, Deployment, Go-live and Post-Production support, managed defects/bugs using tracking tools like MS Team foundation server and Azure DevOps.
- Communicate with the users for build handover and published user guides.
Jr. Business Systems Analyst
E & Y
Gurugram, India
05.2018 - 06.2019
- Processing confidential data and information according to guidelines.
- Extracting data from multiple systems and joining tables using SQL JOINS e.g. joining Payments received data with data provided by Insurance companies for underpaid claims using unique Store codes and Prescription numbers.
- Lead the support of business initiatives through data analysis, identification of implementation barriers and user acceptance testing of various systems.
- Lead the identification and analysis of user requirements, procedures, and problems to improve existing processes.
- Resolve issues and identify opportunities for process redesign and improvement.
- Perform detailed analysis on multiple projects, recommend potential business solutions and ensure successful implementations, including improvements and revisions to business processes and requirements.
- Managing project features and user stories on Azure DevOps board.
Education
Bachelor of Technology (B.Tech) - Computer Science and Engineering
01.2019
Diploma - Computer Science and Engineering
01.2015
Skills
- Use Case Design
- Processing Flows (Mapping)
- Requirements Gathering
- Functional Matrix
- Business Rules Definition
- Analysis Flows
- Data Analysis
- Visualization & Modelling
- MS Excel
- T-SQL
- SSMS
- SSDT
- MS Word
- MS Power Point
- VLOOKUP
- PIVOT tables
- MS SQL Server
- MS Access
- Persuasive communication skills
- Professional communication skills
- Creative problem solving
- Cross national experience
- Cross-cultural experience
- Team player
- Leadership skills
- Ability to work independently
- Multi-tasking
- Timely project delivery
- Agile
- Scrum
- Data Warehouse
- Jira
Certification
Certified Scrum Master
Timeline
Business Systems Analyst
Goldman Sachs
04.2022 - Current
Business Systems Analyst
Citi Bank
07.2019 - 06.2022
Jr. Business Systems Analyst
E & Y
05.2018 - 06.2019