Lead Business Systems Analyst Resume
Richmond, VA
PROFESSIONAL SUMMARY:
- A results - oriented Business Analyst over 9 years of experience in leading global teams delivering complex, mission critical initiatives in Banking, Finance and Healthcare involving product implementation, Data warehousing, Data Modeling, Evaluating Data Sources, and Data Profiling.
- Good understanding in data warehousing concepts, data architecture, data modeling, data mapping and Analysis.
- Skilled in stakeholder analysis, management and communication by working with senior business sponsors and technical specialists. Acted as a liaison between the business and development teams.
- Partnered with operations and PMO to create efficient cross-functional processes by eliminating non-value added activities. Worked with executives and staff to develop culture of continuous improvement (business process improvement).
- Knowledge and exposure working with various regulations and compliance such as FINCEN, PATRIOTIC ACT, BSA, OFAC, CCAR FRY-14 A/M/Q. Designed and implemented solutions pertaining to regulations.
- Working knowledge in Anti-Money Laundering (AML), Suspicious Activity Reporting (SAR), Customer Risk Scoring (CRS), Customer Due Diligence (CDD) and Know Your Customer (KYC), PEP and sanctions screening.
- Managed Anti-Money Laundering/Know Your Customer (KYC) data remediation initiative in Actimize.
- Extensive experience in Release Management, Incident Management, Configuration Management, Business Process Modeling, Requirement Analysis, writing technical specifications, VISIO Diagramming, Service Management and well versed with ITIL.
- In depth knowledge on different phases of Software Development Life Cycle (SDLC), Project Life Cycle (PLC) and Software Testing Life Cycle (STLC).
- Skilled as Scrum Master in facilitating scrum ceremonies such as daily scrum meeting, sprint planning meeting and review meeting. Extensively contributed for the backlog grooming and refining by efficiently analyzing the stories and writing use cases and test cases
- Expertise in writing user stories in JIRA using 'Agile' and 'Waterfall' methodology, root cause analysis, creating workflows and process mapping.
- Efficiently analyzed and managed the change requests and Requirements Churn.
- Efficient in performing, prioritizing tasks effectively leveraging and analyzing techniques like Planning poker and T-shirt sizing.
- Complete understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
- Facilitated and participated in Joint Application Development (JAD) sessions to gather the requirements and to resolve the revolving issues and to facilitate the coordination between the teams.
- Well versed in authoring Business Requirements Document (BRD), Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case, Business case and Data mapping document.
- Proficient in User Acceptance Testing (UAT), Functionality Testing, Unit testing, Integration Testing and have assisted writing test cases and creating test plans.
- Good understanding of the data warehousing concepts, data architecture, data modeling and data mapping and Data Analysis.
- Experience working in BI Tools (Qlik View, Tableau etc.) and BPM Tools (Pega, Actimize)
- Have facilitated and driven the defect triage call daily with the internal team members.
- Highly collaborative team player with extensive customer relationship skills, also possess excellent facilitation and mentoring skills and ability to prioritize tasks according to business needs.
- Creative thinker and analytical problem-solver with demonstrated ability to multitask and deliver innovative projects from planning through execution under the pressure of fast-paced, time-sensitive environments and can Lead the team independently in both Onsite and Offshore driven projects.
TECHNICAL SKILLS:
Project Management Tools/Methodology: MS-Project, MS SharePoint, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, Change Management, IT Governance and Compliance
Requirement and Test Management Tools: MS Office, Versionone, Jira, SOAP UI.
Reporting and BI Tools: Qlik Sense, Qlik View, SAS EG, Tableau
Databases: Microsoft SQL Server, Oracle, DB2, Mongo DB, Sybase
Office Tools: MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Project, MS Visio
Analytics Tools: MS Excel, MS Access, Pivot Tables, V-Look Ups
Languages: HTML, XML, SQL, Unix, COBOL, JCL, CICS, PL/SQL
Data Analytics: SAS, Ab Initio BRE, Informatic Business Rules Engine
BPM: Pega PRPC 7.2, Actimize ( CDD, RCM)
PROFESSIONAL EXPERIENCE:
Confidential, Richmond, VA
Lead Business Systems Analyst
Responsibilities:
- Facilitate JAD sessions and conducted User Interviews with SMEs’, Business Change managers to understand the business process; gather Business Requirements and identified changes for the applications and loaded into Enterprise JIRA.
- Designed and reviewed various documents including the Functional Specification Document, Software Requirement Specifications, Use Case Specifications, Data mapping document and verifying Requirement Traceability Matrix.
- Working closely with the Data Architect, planned several phased implementations of data migration and removal.
- Proposed UI changes and Created Mapping documents for the service calls.
- Experience with extensive client interactions and converting business functionalities to Service Oriented Architecture models across IT environment.
- Work with a Product Owner to make decisions on refining and grooming the product backlog. Facilitated the scrum events and managed Agile Lifecycle in JIRA from planning to sprint deployment.
- Work with various teams in the place of Product owner to coordinate the integration activities.
- Coordinate with QA and development team in reviewing the test cases scenarios and lead a defect triage call daily to provide clarifications regarding the defects identified.
- Generate/maintain a Project Level schedule which projects task necessary to accomplish in the next 30-45 days to achieve business/technical objectives.
- Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in Versionone and collaborated with system users to conduct UAT.
- Maintain tracking/trending of the Veracode score for the Application: Audit Level, Dynamic score, Static score, summary of Very high, high or CWE findings, date of audit, release number.
- Monitor Automation and UAT environment daily when running batches for analysis. Obtain metrics on throughput and raise concerns in daily meeting for any environment where performance has deteriorated.
Environment: Agile Scrum Methodology, Java, MS SQL, Jira, SOAP UI, SharePoint 2016, MS Office.
Confidential, Mclean, VA
Lead Business Analyst
Responsibilities:
- Interact with customer personnel on significant technical matters frequently requiring coordination across organizational lines.
- Interacted with stakeholders; gather technical requirements; document them as user stories, business rules and Business requirements.
- Performed End to End mapping between Non-Relational databases (Mongo DB) and Relational databases (Sybase).
- Interacted with the upstream and the downstream application teams to communicate the technical dependency to and from of the application.
- Assisted in Data modelling, Data Mapping, and Data Integration process. Helped in performing ETL from current OLTP to the target data warehouse.
- Extensively performed data analysis with use of SQL in multiple databases, form the source systems to the target application to understand the attributes, schema and data structure for the transactional data.
- Identify and develop solutions to enhance operations through technology, solution design and implementation across multiple technology platforms.
- Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in Versionone and collaborated with system users to conduct UAT.
- Identify business unit requirements, create project and process specifications, facilitate testing, coordinate with project teams and ensure that projects are delivered on-time and within budget.
- Provide resolution to an extensive range of complicated technology problems.
Environment: Agile Scrum Methodology, Java, Mongo DB, Sybase, Mongo Compass, VersionOne, SOAP UI, SharePoint 2013, MS Office.
Confidential, Atlanta
AML Business Analyst Lead/Project Manager
Responsibilities:
- Work with the business and product owners to translate business objectives into software requirements by developing business requirements, functional specifications and user stories.
- Solve business problems by working with users, compliance and delivery teams using Waterfall, Iterative and Agile methodologies.
- Conducted and facilitated JAD, brainstorming sessions and user interviews with SMEs’, Business Change managers (BCM) managers to understand the business process, gather requirements and document the same in the various of slots of Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case Specifications, Data mapping document and verifying Requirement Traceability Matrix (RTM).
- Developed and maintained Requirement Traceability Matrix.
- Interacted with stakeholders and gathered requirements as per the business needs.
- Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with BCM’s and Directors.
- Served as liaison between the technical team, architect and non-technical stakeholders, earning their confidence with reliable follow-through.
- Obtained requirements from business stakeholders of the functionalities we needed for KYC Program.
- Ensures that information obtained is consistent with KYC Policy and Procedures and satisfies regulatory requirements.
- Gathered CIP (Customer Identification Program) questionnaires from multiple departments and integrated into one.
- Served as liaison between the technical team and stakeholders to automate AML reports in Cognos.
- Adept experiences in DART, J report capabilities in RCM, have provided interim solution for FIU (Financial Investigations Unit) during unavailability of RCM.
- Studied the existing KYP/CIP system and prepared the test data for the CDD and EDD(Enhanced Due Diligence) based on the inputs.
- Created data mapping document for the application after finalizing the attributes and tables with business users communicated dependencies and potential risks for Money Laundering. Participated intensive data analysis over in scope databases and created various documents to support the project initiation Phase.
- Extensively performed data analysis with use of SQL with different databases, which were going to be the source systems to the application to understand the attributes, schema and data structure for the transactional data.
- Have written the user stories and the acceptance criteria for the requirements.
- Conducted and facilitated the scrum ceremonies and have efficiently handled the internal team activities.
- Worked with a Product Owner to make decisions on refining and grooming the product backlog
- Have worked with various teams in the place of Product owner to coordinate the integration activities.
- Worked with vendors and partner systems to ensure their processes are aligned.
- Coordinated with QA and development team in reviewing the test cases scenarios and lead a defect triage call daily to provide clarifications regarding the defects identified.
- Identified the key facts and dimensions necessary to support the business requirements and used Star Schema and Snowflake schema to develop the logical dimensional models.
- Maintained and updated the Meta data repository containing data elements, semantics and business rules as and when the requirements changed.
- Removed internal and external impediments that hinder team’s productivity.
- Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
- Preparing End of schedule report and carrying out minutes of meeting with the team.
Environment: Hybrid Waterfall-Agile Methodology, Actimize(CDD/KYC, RCM), SAS, Qlikview, Cognos , SOAP UI, JIRA, MS-Visio, SharePoint 2010, HP ALM, MS Office.
Confidential, Virginia Beach, VA
Sr. Business Systems Analyst
Responsibilities:
- Conducting user interviews, gathering requirements, analyzing the requirements and loaded into Enterprise JIRA.
- Facilitated JAD sessions with SMEs’, Business Change managers (BCM) managers to understand the business process; gather Business Requirements and identified changes for the applications.
- Interacted with stakeholders and gathered requirements as per the business needs.
- Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with BCM’s and Directors.
- Served as liaison between the technical team, architect and non-technical stakeholders, earning their confidence with reliable follow-through.
- Involved in creating UI/UX wireframes for implementing in Pega.
- Reviewed the impact of the existing system for the changes in the wireframes.
- Analyze and Reviewed the service calls sequence for the proposed UI changes .
- Created Mapping documents for the service calls.
- Design and review of various documents including the Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case Specifications, Data mapping document and verifying Requirement Traceability Matrix (RTM).
- Experienced with extensive client interactions and converting business functionalities to Service Oriented Architecture (SOA) models across IT environment. Also worked in Three-tier architecture API’s/Web Services (SOAP, WSDL), Client-side and Server-side validations.
- Worked with a Product Owner to make decisions on refining and grooming the product backlog
- Have worked with various teams in the place of Product owner to coordinate the integration activities.
- Coordinated with QA and development team in reviewing the test cases scenarios and lead a defect triage call on a daily basis to provide clarifications regarding the defects identified.
- Facilitated the scrum events and managed Agile Lifecycle in JIRA from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress. Assisted in managing the Product Backlog, Sprint Backlog, Sprint Burn down and Release burn down charts.
- Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting.
- Removed internal and external impediments that hinder team’s productivity. Worked with the team in the grooming and prioritization of product backlog using technique such as planning poker.
- Developed test scenarios/scripts, test plans, prepared user acceptance test cases (UAT), UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.
- Preparing End of schedule report and carrying out minutes of meeting with the team.
- Handled the portfolios across the enterprise to coordinate the integration activities
Environment: Agile Methodology, Pega PRPC 7.2, JAVA, Hibernate, Spring UI/UX Designing, SOAP UI, EDI, JIRA 6.3.3, MS-Visio, SharePoint 2010, MS Office, HP ALM, SQL Server Management Studio.
Confidential
Business Systems Analyst
Responsibilities:
- Interacted with stakeholders, Systems Architect, UI/Content Management Team, Developers, SME and diverse group of personnel and involved in JAD sessions to understand the business process, gather Business Requirements and identify changes for the application s and implemented the systems.
- Worked in cross functional teams on building business use cases, understanding the process flow and gathering Signoffs from Businesses.
- Served as liaison between the technical team, architect and non-technical stakeholders, earning their confidence with reliable follow-through.
- Conducted GAP Analysis to understand limitations of the existing system and designed future system, modelled the AS-IS and TO-BE business process workflow.
- Design and review of various documents including the Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case Specifications, Data mapping document and verifying Requirement Traceability Matrix (RTM).
- Successfully collaborated with developers, DBA's and technical team to perform root cause analysis of issues.
- Established customer expectations of project scope, deliverables, procedures for project communications and delegation of tasks for team members.
- Was in regular contact with Business partners on the Prioritization of issues, pain points, action plans and timeframe for resolution throughout the development cycle maintaining customer satisfaction.
- Identify and register Critical Data Elements (CDE), Business rules, Data Quality rules, Controls and End to End Data Lineage for Enterprise/Retail data warehouses/Marts in a Meta data central repository.
- Manage and interact with Metadata Management team and Data Quality team to deliver expected results.
- Worked on mainframe environment wrote SQL to query various reporting databases for data analysis/ Query Optimization / Performance / Tuning and supported continuous integration and continuous delivery development practices.
- Preparing End of schedule report and carrying out minutes of meeting with the team (Both offshore and onsite).
Environment: Waterfall, Agile/Scrum Methodology, COBOL, CICS, JCL, IBM Mainframe DB2, API’s/Web Services, SOA, JIRA, Visio, MS Project, SOAP, XML, CA-7.
Confidential
Business Analyst
Responsibilities:
- Conducted GAP Analysis to understand limitations of the existing system and contributed to design of future system; assisted in modeling the AS-IS and TO-BE business workflow.
- Worked with business and technical SME’s to develop thorough understanding of Applications, Systems, relational database, Business Methods and Strategies.
- Generated key statistics e.g. Defect reporting by application, performance usage, tasks estimating as well as time and task reporting.
- Managed SQL Server environments, by configuring a facet in one instance of SQL Server, copy the state of the facet to a file, and then import that file into another instance of SQL Server as a policy.
- Conducted spike testing under secured environment, accurately documented all processes and report to senior management during the initial release of the Kindle software.
- Performed functional testing, Regression testing, Performance testing, Stress testing, User Acceptance testing, and new feature testing and ensuring overall quality of kindle device and its software.
- Encouraged and implemented process improvements techniques and ensure that there was room for change. Introduced a checklist during story time to ask the right questions while reviewing each story.
- Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams.
- Constructed Requirements Traceability Matrix to ensure all requirements are met and locate affected system components when there is a requirement change. Maintained the traceability matrix until business requirements were signed off.
- Preparing End of schedule report and carrying out minutes of meeting with the team.
Environment: Agile-Scrum, JIRA, JAVA, Hibernate, Spring, HTML, Mockups, MS Visio, SOAP, XML, HP Quality Center, MS Office, SQL Server.