Sr. Business Systems Analyst Resume
Boston, MA
PROFESSIONAL SUMMARY:
- Business Systems Analyst with 8 years of experience in Banking Domain with services such as retail, mobile and online banking and knowledge of various banking terminologies
- Knowledge of various compliances like Bank Secrecy Act, Sarbanes Oxley Act, BASEL III, United States Patriot Act and regulations set by Financial Crimes Enforcement Network, Office of Foreign Assets & Control and GDPR.
- Worked with various technologies like Apache Hadoop, Flume, Hive, Storm, Spark ML, Kafka, Pig, SOLr, Sqoop and HBase, Salesforce Marketing Cloud, Automation Studio, Email Studio and Exact Target and SAP NetWeaver, SAP Hana.
- Good knowledge of programming and querying languages such as Python, JavaScript, HTML, CSS, WSDL, T - SQL, SQL, HQL, visualization & collaboration tools like Tableau, PowerBI, MS SharePoint, Confluence, GitHub and ETL tools like Informatica
- Experienced in with working System Development Life Cycle Methodologies like Waterfall, Waterfall - Scrum Hybrid and agile methodologies like Scrum and have knowledge of methodologies like Scrumban, Kanban, SAFe
- Involved in defining the Business Area/Scope, eliciting the requirements, analyzing requirements, communicating the requirements , identifying the solutions and verifying if solution satisfies the needs of clients and end users
- Experience in analyzing the AS-IS and TO-BE Systems using techniques like GAP Analysis, SWOT, Impact Analysis, Root-Cause Analysis, Cost-Benefit Analysis, Feasibility study and Risk Analysis to understand the system in depth.
- Experienced in eliciting requirements using Joint Application Development (JAD) sessions, Interviews, Brainstorming, Document Analysis, Observation, Prototyping, Interface Analysis, Surveys and questionnaires.
- Creating and Reviewing Business Requirements Document (BRD) , Functional Specification Document (FSD), Software Requirement Specifications (SRS) and Requirements Traceability Matrix (RTM) based on requirements analysis.
- Expertise in Graphic User Interface Design (GUI), Wireframes and UI mock-ups using Balsamiq tool, MS-Visio
- Experienced in performing Change Management Request , effectively implemented change by performing Business Impact Analysis and Technical Impact Analysis on the scope of the project and its effect on the triple constraints.
- Extensive experience in writing use cases, creating user scenarios and developing Unified Modeling Language (UML) diagrams like Use Case, Sequence, Activity, Class using tools like Lucidchart, draw.io, Microsoft Visio.
- Adept in breaking down Epics into User Stories satisfying (INVEST) , breaking down User Stories into Tasks (SMART)
- Participated in scrum ceremonies, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective and Backlog Grooming meetings, Release Planning and adept at prioritization & estimation techniques like MoSCoW, Kano and MoSCoW - Kano Hybrid Models and Planning Poker, T-Shirt Sizing, Bucket System and Relative Mass Valuation
- Extensively used SQL queries using joins, unions, outer joins, group by, order by and aggregate functions to extract data from different data sources and to perform DDL (Data Defining Language), DML (Data Manipulation Language) and DCL (Data Control Language) operations to Create, Read, Update and Delete (CRUD) the data in the database.
- Experience in Data Warehouse and ETL process using Informatica and used it to extract the data from source systems, transform it according to Business rules and load it into the Data Warehouse
- Good at identifying data sources, performing data profiling and data cleansing .
- Created Data Mapping Document, Data Model using modeling techniques like Entity Relationship (ER) modeling & dimensional modeling and data validation in data warehousing projects.
- Well versed in concepts like OLTP, OLAP, Data Marts, OLAP Cube, and ETL concepts
- Involved in scripting business logic in the web methods of the web services and documenting the Web Service Level Agreement (WSLA) document using Extensible Markup Language (XML) to serve as a contract between the front-end and the back-end team for efficient building of application, resolve ambiguities & speedup design
- Expertise in designing Test Cases, Test Plans, Test Scripts and Test Scenarios to perform Functional Testing, Regression Testing and Defects Logging using JIRA. Defined Acceptance Criteria for User Stories for UAT using Cucumber.
- Developed Test plans, Test case and Test procedures in manual test environment for different testing procedures like black box testing, white box testing, stress testing, regression testing, load testing and sanity check
- Experienced in API testing and documentation using Postman and Swagger to check if the API's are returning the data in JSON, XML format as defined in the API documentation and required by workflow and experienced in documenting Web-services/API’s manually in MS Application and using markdown language/editors
- Experience in creating custom interactive dashboards for analysis and reporting needs on Tableau and PowerBI.
- Highly motivated team player and a leader with excellent interpersonal and communicational skills , ability to bring the best out of team members and myself and proven skills to negotiate the best solution for clients and stakeholders alike
- Hard worker, committed & loyal in doing whatever it takes to get the job done and positive & upbeat about the challenges that come my way and strive to provide the best possible outcome for both the clients/customers and the company.
TECHNICAL SKILLS:
- AML, ACH, Payments, Loans, Credit Cards, Retail, Mobile and Online Banking
- BSA, BASEL - III, Sarbanes Oxley Act, US Patriot Act, GDPR Compliance, FinCEN Regulations, OFAC Regulations
- JIRA, LeanKit, Microsoft Project Professional
- Scrum, Kanban, Waterfall - Scrum Hybrid, Waterfall, Scrumban, SAFe, XP
- Hadoop, Querying Languages and Development Languages
- Apache SQOOP, FLUME, STORM, SPARK ML, PIG, KAFKA, HDFS, Hive, HBase
- T-SQL, HQL, SQL Server, HTML/HTML5, CSS3, JavaScript, JSON, XML, Python, WSDL
- Salesforce Marketing Cloud, Automation studio, Email studio, Exact Target, SEO, Balsamiq, Microsoft Visio, Draw.io, Lucidchart, MS Office Suite
- Postman, Swagger, HP ALM & QC, Cucumber
- Reporting, Visualization and Collaboration Tools
- Tableau, PowerBI, Confluence, Microsoft SharePoint, GitHub, Adobe Photoshop
WORK EXPERIENCE:
Confidential, Boston, MA
Sr. Business Systems Analyst
Responsibilities:
- Conducted Document Analysis to analyze the current system and conducted one on one Interview Sessions using open ended, closed ended and out of the box types of questions to elicit requirements from various stakeholders
- Acted as a Primary Point-of-Contact between the client and development team, gathered requirements from various end users and analyzed, evaluated, and implemented these requirements into appropriate Business and Technical solutions
- Assisted the product owner in creating product backlogs and sprint backlogs and overviewed burndown charts with the development team to keep track of project progress and ensure maximum throughput in the development effort
- Refined user stories and reprioritized and re-estimated user stories in product backlog in grooming meeting during sprints with the product owner using various prioritization techniques like MoSCoW-Kano Hybrid model and estimation techniques like Planning poker and t-shirt sizing depending on the situation
- Reviewed and transformed business and user story requirements documentation and created mockups and wireframes on Balsamiq for stakeholder approval to proceed with further development
- Created conceptual and logical data models to define the flow of data and identifying all the participating entities and defined their dependencies and relationships by creating Entity Relationship Diagrams using ERwin Modeler
- Developed UML diagrams to identify the flow of data between the existing and new system using Data Flow diagrams and Activity diagrams and identified the interactions and possible scenarios between various entities using use case diagrams
- Prepared documentation for filing formats for Suspicious Activity Reports (SARs) and Currency Transaction Reports (CTRs) to ensure conformity to compliances like BSA, USPA, BASEL III, SOX and regulations by OFAC, FinCEN and GDPR
- Work with Architecture and Development teams to understand usage patterns and work-load requirements of new projects to ensure the Hadoop platform can effectively meet performance requirements and service levels of application
- Developed Python scripts to stream data from various data sources and API’s to Apache Flume for further real time processing and stream it forward to Apache KAFKA for seamless transmission of real time data
- Developed scripts to import data into HDFS from various data sources using Apache SQOOP
- Developed Hive queries for HDFS & used special queries like built in operations and functions, views and indexes and partitioning to cater reporting needs and developed SQL queries like Joins, Unions and Stored Procedures to facilitate data analysis, pattern recognition and gap analysis to understand the data sets for production support
- Created interactive dashboards on tableau by analyzing the transactional data sets to identify trends and patterns which helped us identify our target data points and build on them to create refined metrics for AML screening
- Worked in collaboration with the QA team to perform end to end regression testing and wrote production validation tests along with Testers for functional, integration, regression and deployment testing on HP ALM & QC
- Developed and executed several test cases and scripts with the testing team to test the API based feature extension on API testing tool Postman and performed black box and white box testing to test the system for bugs for further improvements
Environment: SDLC: Agile - Scrum, HP ALM & QC (v 12.0), Apache SQOOP (v 1.4.7), FLUME (v 1.8.0), HQL, SQL, Postman, ERwin (v 9 .7), Python, JMS, MS SharePoint, MS Project Professional
Confidential, Santa Clara, CA
Sr. Business Systems Analyst
Responsibilities:
- Performed document analysis to understand the existing Confidential system and Client onboarding process and identified opportunities to improve the onboarding process by performing AS-IS and TO-BE Analysis
- Interacted with SME's, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both Technical users and Business users and acted as a liaison
- Conducted working session with Product owner, business users and end clients to document requirements and high-level product backlogs and assisted the development team in creating User Stories from the elicited requirements
- Proficiently helped development teams to break down large EPICS, Features to User Stories and tracked them on JIRA, assisted the development team with spikes and helped define the acceptance criteria for user stories
- Actively assisted the product owner in Prioritizing the product backlog for maximum business value and proactively worked on Grooming user stories in planning activities using INVEST criteria and kept track of the backlog
- Identified all participating users and their interactions within the existing and new system by creating UML diagrams on Draw.io such as Use Case Diagram, Sequence Diagram, Activity Diagram, Class diagrams to analyze the system completely
- Analyzed the customer base and its transactional activity to segment them & enable threshold-setting of scenarios
- Collaborated with partners in Compliance, other Confidential functional teams and the business to ensure stake-holder's understanding of Confidential requirements, system enhancements and regulatory changes
- Analyzed and documented domain specific API's while conducting the Interface analysis, to interpret the data formats in their WSDL/WADL for a thorough understanding of business requirements and supported integration of compliance REST API's and credit risk bureau REST API's with Business Rules Engine to ensure conformity to regulations
- Collected and reviewed due diligence documents to ensure CIP requirements and Confidential regulatory requirements are satisfied in accordance with the bank’s enhanced due diligence policies
- Develop and ensure adherence to testing standards and best practices. Reviewed and analyzed the existing Confidential standards to develop and document business requirements for the line of business Confidential application
- Extensively researched and collected the customer financial documentations and completed research for suspicious activity reports on Confidential, AML, and BSA analysis reports for flagged accounts
- Constructed an analysis of transactional activities within MS Excel that compares and contrasts the values and volume of individual transaction amounts and percentages to the anticipated values for each user/client profile
- Crafted a standalone reader friendly narrative that told the story of the customer, that recorded patterns, trends and activities of the customer and their counterparties using customer journey mapping
- Assisted in developing Soap API based feature extension which helped in the approval of end clients and customers over various products and services and helped with client on boarding based on Business Rules Engine
- Worked closely with the QA and Testing team and assisted them with creating various test scenarios and test cases for User Acceptance Testing to ensure that the system provides business value and caters end user needs and tested API using POST, PUT, GET, DELETE on API testing tool Postman and documented the same
Environment: SDLC: Agile - Scrum, Postman, SOAP API, Draw.io, JIRA (v 7.1), Confluence, JSON, XML, WSDL, Jenkins (v 2.25), MS Office Suite, JavaScript, SQL
Confidential, NYC, NY
Sr. Business Analyst/Jr. Project Manager
Responsibilities:
- Worked as a liaison between stakeholders and development team and elicited requirements using JAD Sessions, Document Analysis, Interviews and Brainstorming
- Helped the project manager/product owner in creating the Project Plan Document, Project Charter, identifying the scope of the system and helped with the cost benefit analysis, ROI analysis and feasibility study
- Actively participated in daily stand-ups, sprint planning meetings, sprint review and retrospective meetings and developed User Stories throughout the Agile Lifecycle as well as created UML diagrams such as Use Case, Activity, Sequence diagrams, ER diagrams, Chart diagrams, storyboards using Microsoft Visio
- Performed breaking down of Epics to user stories (INVEST Format) and then helped in prioritizing user stories using MoSCoW and Kano models and created mockups on Balsamiq
- Tracked all the user stories, issues and bugs during the sprints using JIRA and helped track Burndown Charts to estimate the team’s performance to calculate team’s cadence and better help with estimation efforts
- Helped developing strategy and roadmaps for email marketing programs to drive acquisition, customer retention, customer growth, and demand generation to achieve quantifiable revenue goals
- Experienced with Salesforce customizations using Apex Class (Custom, Extension), Visualforce pages, components, processing large data using Apex Batch classes and apex triggers to ensure correct data entry to the system
- Managed the data for Forecasting, Campaign Management, Contacts, Leads, Opportunities, Quotes and Dashboards and Responsible for setting up Salesforce Marketing cloud and administration to define user access criteria
- Generated discover reports and presented campaign engagement statistics to business owners to direct future strategies and initiatives and developed and maintained deadline-driven email campaigns and configured them
- Design and developed several emails a month using Exact Target and Salesforce Marketing Cloud to meet our various client and company requirements to promote the most suitable offers personalized to the end user
- Created journeys and implemented targeted marketing campaigns using tools like Journey Builder, Email Studio
- Used Journey builder in running more than 50 different campaigns along with Automation Studio and Contact Builder
- Developed HTML, CSS, AMP Scripts to build customized solutions that support dynamic Email Personalization and performed list pull by multiple SQL JOINS, Filters, Groups, Audience Builder
- Debugged Apex scripts using Debug Logs and System Log Console to catch Exceptions and execute limits
- Tested apps by appending multiple components to a Lightning Application thereby deployed Applications from Sandbox to Production and developed several test cases and scenarios to test the APIs using Swagger API testing tool
Environment: SDLC: Waterfall - Scrum Hybrid, JIRA (v 7.1.0), Swagger, SQL, HTML/HTML5, CSS3, REST API, Salesforce.com, Email studio, Automation studio, Exact Target, SEO, Adobe Photoshop, GitHub, Balsamiq, MS Visio
Confidential
Business Analyst
Responsibilities:
- Elicited requirements by arranging workshops & meetings with all the involved stakeholders to understand how their portfolio, program or project would be affected by the migration and what are the core characteristics of each of them using conceptual and logical data models and defined the relationships using E-R Diagrams using MS Visio
- Collaborated with the development team and stakeholders using Confluence pages and kept track of all contributions
- Coordinated with the stakeholders to gather functional and non-functional requirements during JAD sessions, interviews
- Recorded requirements in the Requirement Traceability Matrix (RTM) defining each technical requirement in detail from areas like: main hardware, application software, networks, servers, internet and desktop configuration
- Studied the existing business process, portfolios, programs and projects and created AS-IS workflow to illustrate the existing system and developed a TO-BE workflow to identify how the new system will be adapted
- Worked with architects to assist in the development of current and target state enterprise-level data architectures
- Created Source to target data mapping documents using Informatica identifying key data elements and prepared Data Flow Diagrams and performed extensive data cleaning on the source data to prepare it for migration
- Developed scripts to populate data directly to the target system based on the data mapping from consolidated excel sheets
- Performed extensive load, performance, stress, deployment and production validation tests on the target system to ensure that the system is capable and holds data integrity once the migration is completed
Environment: SDLC: Waterfall, Microsoft Visio, Excel, Informatica (v 9.1), JIRA (v 6.2.0)
Confidential
Junior Business Analyst - Sales
Responsibilities:
- Interacted with stakeholders, managed stakeholder responsibilities through continual communication
- Facilitated meetings with stakeholders and used various elicitation techniques like brainstorming, and interface analysis to identify business needs and rules
- Created Unified Modeling Language (UML) diagrams like activity, sequence and use case for process modeling and developing use case scenarios and activity diagrams to define the flow
- Performed in depth analysis of the sales data accumulated over past several years across various regions that the company caters to create detailed dashboards on PowerBI and Excel
- Performed basic ETL on the given data sets with SAP NetWeaver 7.0, SAP HANA and analyzed data sets for behavior and contribution to business performance, critical business metrics to track underlying business trends
- Developed a summarized report on the sales performance with visual representations, statistics and provided analysis backed suggestions on PowerBI Analytics
- Presented the analysis using dashboards on PowerBI to respective stakeholders to make them aware of the shortcomings and possible business opportunities amongst the various sales regions
- Created test cases and test scenarios to test the extracted data and respective analysis to verify data integrity
Environment: SDLC: Waterfall, Microsoft Excel, Microsoft PowerBI, IBM DB2, SAP HANA & NetWeaver 7.0, Lucidchart
Confidential
SQL Developer
Responsibilities:
- Created database objects like Functions, Triggers, Procedures, Indexes and Views using T-SQL in development and production-based environment for SQL Server 2000
- Participated in requirement gathering sessions and system specification sessions actively
- Developed complex SQL Queries to fetch data from remote databases stored in different tables, using joins, database links and formatted the same into detailed reports and maintained logs
- Worked on complex T-SQL statements, and implemented various codes and functions and used SQL Server 2005 Reporting Services to install, author, and manage reports
- Wrote Transact SQL queries to generate table insert and update statements and developed and optimized database structures, stored procedures, DDL triggers and user-defined functions
- Implemented new T-SQL features added in SQL Server 2005 that were, Error handling through TRY-CATCH statement and Common Table Expressions (CTE)
- Analyzed and developed Complex Stored Procedures, Functions, Cursor, Table, Constraints, Joins, Subquery in SQL to facilitate efficient data manipulation and maintain data consistency
Environment: SDLC: Waterfall, SQL server 2008/2005, T-SQL, Microsoft Framework 2.0, Erwin, MS Visio