We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

New York New, YorK

PROFESSIONAL SUMMARY:

  • Business systems analyst with 8+ years of work experience in IT business analysis, worked with self - organized, cross functional teams in finance, banking and retail domain with proficiency in gathering requirements, writing user stories, performing exploratory analysis, ad-hoc analysis & reporting.
  • Proficient in Business Process Engineering and Software Development Life Cycle (SDLC) methodologies and Agile methodologies such as Waterfall, XP, Scrumban, Scrum, Waterfall-Scrum Hybrid and SAFe
  • Strong knowledge of Software Development Life Cycle (SDLC) and its phases - Scope Initiation, Planning Requirements elicitation, Analysis/Design, Development, Testing, Operations and maintenance.
  • Collaborated with SMEs and Stakeholders to get a better understanding of organization's business processes and gather business requirements; conducted Gap analysis, Cost/benefit analysis, Risk analysis and SWOT analysis.
  • Experienced in documenting Business Requirements Document (BRD), Functional Requirements Document (FRD) and Non-Functional Requirements Document (NFRD).
  • Proficient in networking with individuals at various levels while organizing, conducting and facilitating elicitation sessions such as survey/questionnaires, Interviews, Brainstorming, Focus group, Requirement workshops, Shadowing, Document analysis and JAD sessions.
  • Experienced in estimation techniques such as planning poker, t-shirt size, relative mass valuation, bucket method to help product owner in picking Product Backlog Items (PBIs) to commit to in the iterations (Sprints)
  • Created Unified Modeling Language (UML) diagrams like Use Case diagrams, Activity diagrams, Sequence Diagrams using tools such as MS Visio, Rational rose and Lucid harts.
  • Created Wireframes and Mock-ups (with Mockup screens and Balsamiq mockups) whenever necessary to help the developers to understand the requirements/user stories.
  • Assisted product owner in writing efficient user stories by following INVEST (independent, negotiable, valuable, estimable, small, testable) principal and uploaded in JIRA
  • Familiarity with Scaled Agile Framework for the Enterprise, including release planning and portfolio backlogs
  • Experience working in big data systems like Hadoop (Cloudera), RDMS (SQL server, oracle etc.)
  • Collected data from various sources, manipulated them, performed ad-hoc analysis & reporting using SQL, Tableau; also performed exploratory analysis using SQL, Excel and R
  • Worked in all phases of Data Warehousing project like Data Cleansing, Data modeling for ETL, Data profiling, Data validation, and Data analytics & reporting to business users.
  • Skillful at designing and implementing SQL queries using joins unions, sub queries and analytical functions (sum () over, row number, rank, dense rank, lead, lag, ntile) to extract data from different data sources
  • Good understanding of Hadoop concepts and tools such as HDFS, Map Reduce, Hive, Hue, Spark SQL, Oozie etc.
  • Strong knowledge of implementing Databases, Data Table Structures, Data Marts, Data Analysis, Data Integration, Schemas and OLAP operations viz. Slice, Dice, Pivot, Roll-up and Drill-down.
  • Good understanding in architecture design of Extract, Transform, Load environment using Mapping Designer, Source Analyzer, Target Designer, Transformation Developer, Workflow Manager, Repository Manager and Workflow Monitor in Informatica Power Center.
  • Comprehensive understanding of Web-Services like REST and SOAP using XML, WSDL and UDDI using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
  • Skilled in writing test plans, test cases and analysis of test conditions using HP ALM and collaborated with the development team on test failures and corrections to ensure functional specifications meet business needs throughout the development cycle.
  • Prepared and maintained Requirement Traceability Matrix (RTM) and ensured there is 100% test coverage
  • Proficient in Blackbox Testing, Integration Testing, Regression Testing and facilitated the User Acceptance Test (UAT) sessions with the defined Acceptance Criteria and with references for users by writing and maintaining user documentation and other training needs.
  • Proficient in creating dash boards using Tableau and Qlikview and performing ad-hoc reporting by executing SQL queries, creating and loading views into Tableau and designing visualizations
  • Documented solutions and shared with the team using SharePoint and presented results in a simple comprehensive way to non-technical audience.

SKILL:

Domain & methodology: Finance, Banking, Retail, Agile-Scrum, Waterfall-Scrum, Waterfall, Extreme Programming, Kanban, RUP

Project Management: JIRA, rally, MS Office (Excel, Word, Publisher, Outlook, PowerPoint, One Note), MS project, MS Visio

Content Management: MS-SharePoint, Confluence, InfoPath

Testing/tracking tools: JIRA, HP ALM, Rally, Bugzilla, Postman, SoapUI, Cucumber

Databases: MS SQL Server, Hadoop (Hive), AWS (Red shift, S3), Oracle, My SQL, Big query

Data Warehousing: Data Marts, Data Modeling, OLAP, OLTP, Data Mining, ETL, Slicing/Dicing, Drill Down/ Roll up, Pivot, Star and Snowflake Schema

Business Skills: Change Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, JAD Sessions, requirements elicitation, SWOT analysis, Gap analysis and Root cause analysis

Business Intelligence & Visualization: Tableau, Qlikview, PowerBI, Erwin

Programming: SAS, SQL, R

Webservice: SOAP, REST, JSON, XML

Other skills: Predictive analytics, statistics, A/B testing, Data warehousing, ETL, Informatica, Talend

WORK HISTORY:

Business systems analyst

Confidential, New York, New York

Responsibilities:

  • The project followed a hybrid methodology where the initial phases of the project followed waterfall approach and the later phases followed Agile approach that is customized to the needs of the project.
  • Worked in close interaction with key areas at Global, Regional and local levels, such as the Financial Investigations Unit (FIU), AML Technology, Risk Management (MRM) and AML Compliance teams; gathered requirements using elicitation techniques like interviews; documented them in BRD's and FRD.
  • Collaborated with all the internal stakeholders and clarified any doubts regarding the compliances being followed such as Bank Secrecy act (BSA), Due diligence programs, filing suspicious activity reports (SAR), other BSA reports.
  • Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows, to help product owner to plan how to bridge the gap and increase the efficiency.
  • Collaborated with Trade surveillance team and interviewed the relevant stakeholders and documented the Top-down approach (Rules-based) and the Bottom-up approach (predictive) and shared the research with the team.
  • Collaborated with stakeholders to understand requirements for any upcoming releases or change requests / system enhancements; documented the same and shared it with the team.
  • Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
  • Provided on-going assessment of Monitoring Ecosystem, working with the Business, MRM, FIU, and Compliance to ensure that the relevant stakeholders are kept updated throughout the process.
  • Used modeling tools like MS VISIO in creating UML diagrams like use case diagrams, sequence diagrams, data flow diagrams and Activity diagrams by collaborating with architects and other technical stakeholders.
  • Creating complex data analysis using SQL to troubleshoot issues related to Risk Management, AML, and compliance issues
  • Performed data analysis across the modules such as high-risk transfers, moment of funds, offset trades, journal transfers, change in historical behavior and change in anticipated behavior.
  • Interacted with architects and subject matter experts to create Data mapping specification and data dictionary.
  • Performed data pulls from source systems and conducted exploratory analysis using tools like SQL and Excel.
  • Assisted technical team in designing and implementing various Data Quality methods in Oracle database. Executed quality checks against database and report all data issues. Reviewed the detected data anomalies and identified the source of data problems. Documented data quality solutions.
  • Performed Intermediate analytical research and investigative analysis that include customer research and transactional analysis using SQL and excel; also used third party data for analysis.
  • Familiar with RESTFUL and SOAP web services, Web API and involved in API technical writing and documented XML and JSON requests and responses using SWAGGER and Word.
  • Assisted QA team in creation of Test cases, Test plans, Test scenarios to perform Functional Testing, Regression, System and maintained requirement traceability changes throughout the project life cycle.
  • Wrote user stores in BDD format using Gherkin language (GIVEN, WHEN, THEN format) to produce Feature Files and used Cucumber tool to generate Step Def files which enable automation of Blackbox testing.
  • Documented solutions and shared with the team using SharePoint and presented results in a simple comprehensive way to non-technical audience.
  • Prepared reports using Tableau and presented to the AML Monitoring Committee, including analysis support towards effectiveness opportunity, support in building a good pipeline for future, etc.

Environment: SQL, R, Hadoop, Hive, JIRA, Tableau, Spark, SAS, MS-Office (Word, Excel, PowerPoint, Project, Visio), SharePoint, predictive analytics, fraud detection

Business data analyst

Confidential, Leawood, KS

Responsibilities:

  • Assisted the Product Owner to define project scope and objectives; Documenting vision and scope, including monitoring changes through change management plan throughout project lifecycle.
  • Helped product owner in writing stories, Decomposed requirements document (BRD) into user stories and linked necessary requirements documents to JIRA via confluence link.
  • Participated in Scrum Backlog Refinement meeting along with the Product owner in prioritizing at higher level to ensure that the product backlog meets the DEEP criteria and moving the user stories to Sprint backlog which ensured Definition of Ready.
  • Collaborated with Business Intelligence team, Performed Launch analysis that includes spend analysis, user analysis and cross over analysis and presented the findings to the senior management.
  • Ensured that the data which is being collected and the analysis which is being performed is according to the General data protection regulation (GDPR) compliance.
  • Collaborated with various stakeholders and involved in creation of High-level specification document that contains Scope, time and cost details; also created design specification document that contains system architecture and structural code and shared with team using google sheets.
  • Involved in creating UML diagrams like activity diagrams, use case diagrams and code flow diagrams using Gliffy tool, which is integrated in JIRA, by collaborating with technical stakeholders.
  • Performed data pulls from Central information repository (CIR) system using T-SQL; constructed views; loaded into Tableau and created charts; presented the findings to the team.
  • Interacted with architects and subject matter experts to create Data mapping specification document (Data mapping between sources and targets, transformations logic, connection info etc.) and data dictionary.
  • Assisted the Business Intelligence team in performing exploratory analysis, conducting research on various statistical techniques used to build various models for leads generation and credit scoring.
  • Involved in RESTFUL API testing using Postman tool, validated the API request and response for a third-party data source like clear bit and ZoomInfo; involved in API documentation using custom template.
  • Assisted end users to perform User Acceptance Testing. Assisted QA team in designing Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Regression, System and Load Testing.
  • Logged and tracked the defects using JIRA and created an error repository to support QA team in testing, tracking defects and systematically manage defects and bugs.
  • Collaborated with business and determined the frequency of metric tracking to assist analysts perform A/b testing on operational data sets; sales team call data and tracking data; assisted product owner and other business stakeholders define metrics such as hard touch and soft touch metrics for sales team call data.
  • Supported sales and product teams that are placed across various geographical locations and performed ad-hoc reporting & analysis using tools like Tableau and Excel (pivot, charts, VLOOKUP)

Environment: JIRA, Gliffy, Google sheets, SQL server (CIR), R, AWS (S3, Red Shift), Tableau, MS-Office (Word, Excel, PowerPoint), CRM (Sales Force)

Business systems analyst

Confidential, St. Petersburg, FL

Responsibilities:

  • Collaborated with senior management, clients, portfolio managers and traders, financial advisors and gathered business requirements using elicitation techniques like interviews etc.
  • Assisted product owner in writing stories, Decomposed requirements document (BRD) into user stories and linked necessary requirements documents to JIRA via confluence link.
  • Participated in Scrum Backlog Refinement meeting along with the Product owner in prioritizing at higher level to ensure that the product backlog meets the DEEP criteria and moving the user stories to Sprint backlog which ensured Definition of Ready.
  • Assisted product owner in prioritizing the Scrum Product Backlog (PBI's) using MOSCOW technique and assisting the technical team in breaking down the EPICS into user stories to meet the INVEST criteria.
  • Performed data queries, mapping, gap analysis and data reconciliations between strategic data sources and target systems and updated any defects in the process.
  • Used modeling tools like MS VISIO in creating UML diagrams like use case diagrams, sequence diagrams, data flow diagrams and Activity diagrams by collaborating with architects and other technical stakeholders.
  • Created Mockups and wireframes for the user stories whenever it's necessary to help the developers understand functionality using tools like Balsamiq.
  • Designed and implemented queries in HiveQL using joins, unions and sub-queries for Data Validation.
  • Interacted with architects and subject matter experts to create Data mapping specification document (Data mapping between sources and targets, transformations logic) and data dictionary.
  • Performed data profiling, data analysis on Customer Account data, Transaction Data, Wire Data, Trade Data, Customer Relationship Management (CRM) data to obtain a single view of customer segments across multiple product offerings so that marketing customization can be achieved.
  • Familiar with RESTFUL and SOAP web services, Web API and involved in API technical writing and documented XML and JSON requests and responses using SWAGGER and Word.
  • Logged and tracked the defects using HP Quality Center and created an error repository to support QA team in testing, tracking defects and systematically manage defects and bugs.
  • Provided multiple levels of dashboards using tableau ranging from the Descriptive (Business Intelligence) to the Predictive and constantly harnessed to drive higher insight and visibility into a range of areas - client tastes, product fit and business strategy.

Environment: Scrum, Hadoop, Tableau, Hive, MS Visio, HP ALM, Balsamiq, JIRA, SharePoint.

Business analyst/reporting analyst

Confidential, Hanover, NJ

Responsibilities:

  • Gained knowledge about the reconciliation needs of the regulators and elicited the requirements from the stakeholders; documented them in Functional specification document (FSD).
  • Coordinated cross-functionally with Subject Matter Experts, Global Reporting leaders, internal/external auditors, and compliance analysts to ensure compliance.
  • Collaborated with technology team to assess the solution strategy which included quality and control framework, performed gap analysis and identified new attributes required for reporting which are not present in semantic or the core layer of the data warehouse.
  • Created several Data Flow diagrams, Use Case diagrams, Sequence diagrams using Rational Rose UML software suite and wrote business use cases for several scenarios for business users.
  • Elicited the list of critical data elements required for the report, understood the key requirements of data quality and governance needs; documented them and shred with the team.
  • Mapped critical data elements to various data sources; performed data profiling; created detailed requirements specification document for mappings; built data process flow of various sources used for reporting submission and shared them with the team using SharePoint.
  • Collaborated with QA team for testing; Created test scripts, test plans and executed test cases in HPALM; Extensively used SQL for data validation between source tables and target tables.
  • Assisted analysts in creating reports and dashboards using SSRS, Tableau and presented the finding s to team

Environment: Waterfall methodology, SQL server stack (SSIS, SSRS), Teradata excel, HP ALM, MS-Office (Word, Excel, PowerPoint, Project, Visio), Tableau.

Business analyst

Confidential

Responsibilities:

  • Conducted interviews and meetings with different stakeholders and business users to gather requirements.
  • And documented those requirements for technical and non-technical audience via BRD and FRD.
  • Conducted Gap analysis between the current loan application system & the target automated system.
  • Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting with users, management, SME (Subject Matter Expert), stakeholders, lenders, underwriters using JAD sessions and interviews.
  • Designed Use Case diagrams involving Mortgage Business Rules used very heavily for determining Loan Application approval decisions like Accept, Soft Approval, Hard Approval, Refer, Hard Stops and Hard Rejects based on LTV, CLTV, PTI Calculations.
  • Created several Data Flow diagrams, Use Case diagrams, Sequence diagrams using Rational Rose UML software suite and wrote business use cases for several scenarios for business users.
  • Validated the data by writing SQL queries such as joins, unions, aggregated functions etc.
  • Helped testing team in developing QA Test plans for Functional, Integration and System Testing.
  • Performed Black Box Testing. Also assisted in GUI testing, smoke testing, regression testing.
  • Used HP ALM to review test cases written by testers and ensure test cases were written for every requirement.

Environment: Water fall scrum hybrid, HP Quality Center, Rational ClearCase, XML, Rational rose UML, HP ALM, Bugzilla, Oracle PL/SQL, Mockup screens.

Business data analyst/ Quality analyst

Confidential

Responsibilities:

  • Compare & validate the source data with the data loaded on Hadoop system to ensure they match.
  • Participating in requirements and specification reviews and design and code walk-thru as needed.
  • Extracted and Analyzed very large retail data sets using HQL to perform data validation between the source and target data; performed data analysis like data profiling based on campaign objective (like propensity score, rewards and recommendation etc., identified defects, and presented the findings to the team.
  • Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
  • Understand the scope/schedule of work and construct test cases/execute test cases/report bugs for code fixes.
  • Improved module efficiency 30% by automating 3 functionalities related to quality checks using shell scripts in an environment of constantly shifting priorities.
  • Analyzed, created, and interpreted metrics in customer transactions data using Tableau and presented the findings to the team and improved the efficiency of the project by 20%.
  • Augmented team performance by mentoring 3 analysts, training them in HQL, and assisting in understanding seasonality and other modules by conducting multiple brown bag sessions Environment: Hadoop, Hive, HQL, Hue, HP Quality Center/ ALM, Tableau, MS-Office (Word, Excel, PowerPoint, Project, Visio), Pig, Oozie, Scrum methodology

Quality Analyst

Confidential

Responsibilities:

  • Analyzing Business requirement specifications and identifying the source data and transformations that needs to be applied in the process of moving data to target database.
  • Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
  • Developed and executed test scripts, test conditions, input test data, and expected results for many test plans.
  • Created test data for all mapping rules to test the functionality of the ETL process based on mapping document.
  • Executed SQL queries to validate various scenarios like count test, primary key test, duplicate test, attribute test, default check, technical data quality, business data quality.
  • Perform analysis on data to detect and address issues and establish criteria for data quality standards.
  • Logged defects using HP ALM, linked defects with requirements and generated Defect Reports in ALM.
  • Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed so that 100% test coverage is achieved

Environment: Oracle, Teradata, SQL, Informatica, HP Quality Center/ ALM, MS-Office (Word, Excel, PowerPoint, Project, Visio), Lync, ETL testing, Agile.

Hire Now