Home

Sarbjot Dhindsa - Project Manager (CSM, CSPO)

[email protected]

Location: Fremont, California, USA

Relocation: Yes

Visa: TN

Sarbjot Dhindsa Project Manager (CSM, CSPO) 669-842-3737 [email protected] Fremont, CA Yes TN https://www.linkedin.com/in/sarbjotdhindsa/ SUMMARY Qualified professional with over 11+ years of extensive experience in the field of Business Analyst working with the technical staff to implement management and staff's business requirements in Banking industry, Retail and Insurance domain. Strong knowledge of Core Banking System, Retail and Commercial banking business, products, policies and procedures. Expert at ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets. Extensive experience in the Retail and e-commerce environments with knowledge of Microsoft commerce ATG suite and Websphere. Experience in understanding, analyzing, and documenting Business Requirements, Functional Specifications, Business Process Flow, Business Process Mapping, and Modeling. Proficient in documenting requirement specifications including BRD, FRD, use cases, user stories and supplementing them with UML diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, and Sequence Diagrams for Web Services documentation etc., Experience in Finance Industry, Investment banking, Retail banking, Commercial banking, Credit Cards, Mobile Banking and Mortgage Services. Experience in creating screen mock-ups, wire frames and User Interface Documents, including Screen for Mobile Application. Strong Knowledge of UML, RUP, Waterfall, Agile Technologies, JIRA, SAFe and Rational Requisite Pro. Proficient in developing Use case scenarios to enable design and development of applications using tools like Rational Requisite Pro, JIRA and VersionOne based on the SDLC methodology. Expertise in developing Test Plan, Test Conditions, and Test Cases ensuring adequate testing of software both before and after completion conducting and documenting UAT. PNC Bank, Pittsburgh, PA July 2020 - June 2023 Sr Business Analyst/Project Manager Responsibilities: Prepare for GAP Analysis; identify and document improving areas to meet capital markets requirement regulations. Work with technical team to Implement integration to Closing Corp Fees management and Appraisal Order platforms. Responsible for gathering user requirements and specifications for designing a mortgage-based loan system using and documenting the same. Conduct JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues. Work with client to determine user requirements and goals at requirement elicitation stage using Agile Methodology. Document requirements into Business requirement document (BRD), Functional Requirement Document (FRD) and Software Requirement Specification (SRS). Use iManage to upload/modify SOX compliance documents containing users rights and permissions to software applications/Datasets within the organization. These documents were then distributed to authorized users via email as an embedded report or Link to the documents in iManage Liaison with SME s/stakeholders and Tech Team to ensure that appropriate privileges are being provided to users/user groups in iManage. Generate iManage .csv reports containing user access information to the system to monitor user access to various sections/documents within iManage Manage iManage document retrievals that were mistakenly deleted by the users from the client applications Involve in project supporting enhancements for regulatory/compliance as we all as business initiative. Actively participate in review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting. Involve Functional Requirement Specifications (FRS) based on User Requirement Specification (URS). Understood and articulate business requirements from user interviews and convert these requirements into technical specifications. Review and analyze the Finance Regulatory Reporting business requirements document. Design and develop Use Cases, Activity Diagrams, Sequence Diagrams, and OOD. Conducting internal and external FRD walkthroughs to all the concerned stakeholders. Conduct a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc., and their mapping to the standard analysis mechanism to enable maximum reuse. Use JIRA bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release. Midfirst Bank, Oklahoma City, OK (Remote) Jan 2019 - Jun 2020 Business Analyst Responsibilities: Facilitated review sessions with stakeholders to access business needs and elicit requirements. Reviewed and analyzed the existing KYC standards in order to develop and document business requirements for the line of business KYC application. Collaborated with partners in Compliance, other KYC functional teams and the business to ensure stake-holder's understanding of KYC requirements, system enhancements and regulatory changes. Analyzed the process and identified the functionality improvement options to fulfill the business needs. Communicated benefits and risks of each option, and recommended business priorities. Worked in partnership with the KYC technical team to translate implementation options into detailed Functional Requirement Specifications and Technical Requirement Specifications. Created UML to ensure the business logic is clearly demonstrated to developers. Created use cases to understand the narratives. Partnered with the KYC Operational Readiness team to ensure the business is prepared for implementation by Documenting new policies & procedures and outlining and explaining updates to the KYC application. Effectively conducted AML /KYC formality reports on questionable accounts and transactions. Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives. Involved in Performing data analysis using SQL to generate portfolio summary reports the system used this information to generate reports analyzing returns on equity and fixed income portfolios. Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams. Meijer, Grand Rapids, MI (Onshore/Offshore) Jan 2015 Dec 2017 Business Analyst Responsibilities: Gathered requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational. Provided recommendation for use of ATG Commerce for B2B and B2C business. Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database. Developed E-Business Suite programs for databases supporting supply chain management (SCM), order management, inventory, warehouse management system, purchasing, and iProcurement. Implementation, enhancement and support solutions to meet client's needs using Demandware ecommerce platform. Gathered requirements and modeled the data warehouse and the underlying transactional database. Worked with ETL team during the upload process. Prepared and maintain Business Rules Spreadsheets (BRS) identifying Rules, Triggers and corresponding data fields from Legacy to target CRM application. Created different Experienced in User experience (UX) definition and User Interface (UI) design for project as well as mockups, prototypes and wire frames. Duties included maintenance of existing and development of new Unix Korn and C shell scripts for sales/marketing EDI data extraction and uploading to Excel spreadsheets and MS Project files. Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle). Followed by reverse engineering to document UI and Functionality. Created Test Scripts & Test Scenarios to check report content, layout, and parameters. Performed Gap Analysis of the processes to identify and validate requirements. E-Bay, Chicago, IL (Onshore/Offshore) June 2012 Dec 2014 Product Owner/Business Analyst Responsibilities: Conducted JAD sessions between the end users and the development team. Delivered requirements under the Agile Scrum SDLC methodology to meet a very fast release schedule. Worked with the software architects / developers to ensure that the applications confirm to customer requirements. Acceptance Testing (UAT), reviewed UAT results to identify defects and report to relevant teams for fixes. Ensured deliverables in a timely fashion for Digital, Wholesale and Retail Store Orders. Prepared and maintained the Requirement Traceability Matrix RTM to record the business, functional and non-functional requirement. Involved in creating logical and physical model of the database using MS SQL Server. Responsible for scheduling meetings with users, SME s and stakeholders to identify. Provided input to standards, guidelines and processes to consistently address recurring Enterprise Master Data issues resulting from data convergence, master data gaps, inconsistent use of data standards and utilization. Contributing to software process-reengineering efforts aimed at evolving current software development practices to adopt Agile and Scrum practices. Conducted Workshops with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation. Served as the requirements liaison between the business community and the IT teams Supported testing, validation, and documentation as necessary. Assisted with coordination & representation for Change Requests (CRs) Development of business process models, business requirements/user stories (functional and non-functional) and product backlogs Served as the requirements liaison between the business community and the IT teams EDUCATION: Bachelor in Computer Science from Laurentian University (Sudbury, Ontario, Canada) in 2007 Computer Programming diploma with honors from Georgian College, Barrie, Canada Keywords: cprogramm quality analyst user interface user experience information technology trade national microsoft California Illinois Michigan Pennsylvania Tennessee