We provide IT Staff Augmentation Services!

Lead Business Analyst Resume

2.00/5 (Submit Your Rating)

SUMMARY

  • Business Systems Analyst with 10 years of experience in Business Development Process and System and Data analysis with extensive work experience in the domain of Finance, Banking and Trading and a registered CFA Level lll and FRM Part ll candidate and Certified Scrum Master.
  • Experience on Waterfall, Agile Scrum and Hybrid of Waterfall and Agile methodologies with the ability to work with self - managing, self-organizing, and cross-functional teams along with coaching of agile framework across the verticals of the organization.
  • Sound knowledge of Extreme programming, Rational Unified Process (RUP), Spiral Model, SAFE and Kanban.
  • Designed and documented Business process modeling using Swim Lane based Business process flows accompanied by conducting and facilitating elicitation sessions such as survey/questionnaires, Interviews sessions, Brainstorming sessions, Focus group sessions, Requirement workshops, Observation, Prototyping, Interface analysis, Root Cause analysis, Document analysis, and Joint Application Development (JAD) sessions with internal as well as external stakeholders.
  • Experience in conducting GAP analysis, Impact analysis, SWOT analysis, Cost benefit analysis, Root cause analysis, Feasibility study, Impact analysis, Risk Analysis, and As-Is and To-Be business analysis and drafting reports.
  • Facilitated Change Request Management, testing and created and validated Business Requirements documents (BRD), Use-Case Specifications, and System Requirements Specifications (SRS), and verified Requirement Traceability Matrix (RTM) along with Request for Information, Request for Offer (RFO) and Statement of Work (SOW) documents.
  • Experience in building Unified Modeling Language (UML) diagrams including Use Cases, Activity diagrams, Sequence Diagrams, Class diagrams, Data Flow Diagrams, and transforming the requirements gathered into functional specifications focusing on workflow analysis and design, user interface design, data flow, process flow and (Entity Relationship) Diagram.
  • Good understanding in building and maintaining Responsible, Accountable, Consulted, and Informed (RACI) Matrix.
  • Experienced in writing User stories using INVEST technique and handling the Requirement Churn. Efficient in facilitating Product Owner to prioritize using techniques such as MoSCoW Technique, KANO Model Based and Business Value Based.
  • Hands on experience in facilitating Sprint Ceremonies (Product Backlog grooming, Sprint Planning meeting, Daily Scrum/Stand-up meeting, Sprint Review meeting and Sprint Retrospective meeting) for Agile Scrum as Scrum Master.
  • Hands on experience in using estimation techniques such as Planning Poker, T-shirt sizing, Relative Mass Evaluation.
  • Experience in converting Business functionalities into Service Oriented Architecture (SOA) models across IT environment. Created Data Mapping Documents using Hypertext Markup Language HTML, and Extreme Markup Language XML.
  • Experience working in Three-Tier architecture, Ajax, Simple API for XML, Web Services (SOAP, WSDL).
  • Experience in Testing Life Cycle and supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
  • Experience in Data Integration using Data center with Hub and Spoke. Extensive implementation knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
  • Experience working in Mainframe environment and deep understanding of database concepts like Data Warehousing, Data Structures, Schemas, Data Marts, Data-Entity Relationships and User Administration. Worked extensively with Data warehouses by migrating data from various OLTP’s to OLAP cube using ETL tools
  • Extensive knowledge of Data Cleaning to understand current applications relevant to International Rating Based Risk Weighted Assets calculations (IRB RWA), Pre-Provision Net Revenue forecast, and CCAR
  • Sound understanding of Value at Risk (VaR), Mortgage Valuation, and portfolio management and Basel Parameters (PD, LGD, and EAD), Credit Risk, Market risk and Liquidity risk.
  • Excellent Interpersonal skills to interact with end-users, Subject Matter Experts SME’s and Project Stakeholders.
  • Experience in commercial lending, mortgages, LOS, data work stream, data flow diagrams, data integration, building data dictionary, data inventory.
  • Strong understanding of leasing life cycle and Loan Syndication as well as Loan IQ and their alignment with regulatory norms coupled with Capital markets and Financial Planning
  • Experience with Wealth Management, Equities, Mutual Funds, Options, Futures
  • Acted as a strategic partner between the business community and IT development teams to resolve functional and technical issues related to business applications with strong understanding of client on board process.
  • Strong experience with workflow-based systems as well as comfortable with analyzing large volumes of data.

TECHNICAL SKILLS

Finance and Banking Domain knowledge: CCAR/DFAST, MiFID II, BASEL lll, SOX, National Automated Clearing House Association (NACHA), Asset allocation, Portfolio management, Fixed Income (Bonds, Convertibles, T-Notes, T-Bonds), Derivatives Money Market Instruments and Mutual Funds.

Project Management Tools/Methodology: MS-Project, MS Share Point, Rally, JIRA, and Agile-Scrum, Waterfall-Scrum, Waterfall, Extreme Programming, and Kanban.

Modeling Tools: PowerDesigner, ER/Studio, ORACLE SQL developer Data Modeler

Requirement Management: MS Office, JIRA, Confluence, HP ALM 11.5.

Reporting Tools: IBM Cognos, Tableau, MS office Suite, Spotfire

Database: MS SQL server 2012, MS Access, Oracle 9i, DB2

Transaction Processing (OS): IBM CICS TG V9.0

Mainframes (Hardware): IBM z13 2964 series, IBM z10

Testing Tools: HP QC, Load runner, Bugzillla and SOAP UI

ETL Tools: Informatica, SQL Server Data Tools-Business Intelligence (SSDT-BI)

Languages: HTML, XML, MS SQL, Base SAS 9, SOAP and Java

PROFESSIONAL EXPERIENCE

Data Analyst / Lead Business Analyst

Confidential

Responsibilities:

  • Conduct data analysis and generate ad hoc management reports based on the requests from business units.
  • Identify the opportunities for data report automation and work in order to materialize such opportunities.
  • Assist in identifying data quality issues and recommend options for how they will be handled.
  • Act as a liaison between end users and business partners (such as IT, Change Execution, etc.) and/or 3rd party vendor to design feasible analytical solutions for medium to large projects.
  • Develop appropriate process flow and work on data models to meet compliance/regulatory requirements.
  • Work on developing data models to ensure the successful solution delivery.
  • Design and perform user acceptance test to ensure a system or application functions as expected.
  • Maintain regular updates to the management team, business units and business partners (as applicable) regarding related project(s)
  • Provide training as and when required.
  • Compile and maintain the documentation (such as procedures, guides, instructions, etc.) for critical applications, reports and daily business analytics processes.
  • Perform related operational and administrative functions as directed by management.

Environment: Scrum - waterfall Hybrid, MS Visio, HP ALM, MS SQL Server, Visual studio 2013, JIRA 5.2, MS Office Suite (MS word, MS Excel, PowerPoint) 2013, IAS 2012.

Confidential, Livingston, New Jersey

Data Analyst / Lead Business Analyst

Responsibilities:

  • Identify and engage key stakeholders and contributor to both business and technical that must participate in the project and ensure that contributors are motivated to complete assigned tasks with in parameters of the project plan. This is across many different geographic locations.
  • Elicited requirements using JAD sessions, Survey/Questionnaire, Interview sessions, Focus Groups with the UI/UX team and analyzed the feasibility of the requirements and formulated and conducted GAP Analysis to derive requirements per infrastructure for Regulatory Compliance.
  • Plan, organize and control activities associated with roll out or enhancement of a global technical solution for KYC-AML activities not limited to an individual country. This may involve understanding, navigating and following local country project, compliance, regulatory risk, legal and any other required Confidential processes and guidelines per credit, liquidity, market risk. Provided solution in lieu with compliance and regulatory authority for ITSRP, OLA, etc.
  • Drafted requirement maintaining consistency in the credit risk model and having a tradeoff between Market risk and liquidity risk. Facilitate a coherent risk aggregation by providing feedback to stake holders on risk reporting.
  • Working diligently with various stakeholders collaboratively to solve problems any impediments and drafted functional requirements and provided walkthroughs of the same through Use cases. Participate and lead requirements Sign Off.
  • Facilitating necessary project meetings and follow ups with team members as required to focus on driving business, operational and /or technical tasks, risks and issues to completion. Documenting, assigning and monitoring all project activities to completion. Making sure of hedging risks by maintaining credit risk, liquidity risk, risk aggregation through risk reporting.
  • Prepared Business Requirement Document (BRD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
  • Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
  • Coordinated working with the business, business analysts, technical resources and other supporting teams to drive the project and ensure a delivery of requirements. Teams will span many geographic locations.
  • Assisted with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box testing, Integration testing, DR exercise maintaining consistency in migration data from legacy by testing both systems parallelly.

Environment: Scrum - waterfall Hybrid, MS Visio, MS Project, Basel III, MS SQL Server, Visual studio 2013, JIRA 5.2, MS Office Suite (MS word, MS Excel, PowerPoint) 2013, IAS 2012.

Confidential, Buffalo, New York

Project Manager / Business Analyst

Responsibilities:

  • Elicited requirements using JAD sessions, Survey/Questionnaire, Interview sessions, Focus Groups with the UI/UX team and analyzed the feasibility of the requirements and formulated and conducted GAP Analysis to derive requirements for ACH processing as well as assisting PM in creating work breakdown structure and project charter using MS Project
  • Conducted a detailed Feasibility check, Impact analysis, Cost analysis, System Functional analysis for system infrastructure.
  • Plan, organize and control activities associated with roll out or enhancement of a global technical solution for KYC-AML activities not limited to an individual country. This may involve understanding, navigating and following local country project, compliance, regulatory risk, legal and any other required Confidential processes and guidelines per credit, liquidity, market risk. Provided solution in lieu with compliance and regulatory authority for ITSRP, OLA, etc.
  • Drafted requirement maintaining consistency in the credit risk model and having a tradeoff between Market risk and liquidity risk. Facilitate a coherent risk aggregation by providing feedback to stake holders on risk reporting.
  • Working diligently with various stakeholders collaboratively to solve problems any impediments and drafted functional requirements and provided walkthroughs of the same through Use cases. Participate and lead requirements Sign Off.
  • Facilitating necessary project meetings and follow ups with team members as required to focus on driving business, operational and /or technical tasks, risks and issues to completion. Documenting, assigning and monitoring all project activities to completion. Making sure of hedging risks by maintaining credit risk, liquidity risk, risk aggregation through risk reporting.
  • Prepared Business Requirement Document (BRD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
  • Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
  • Coordinated working with the business, business analysts, technical resources and other supporting teams to drive the project and ensure a delivery of requirements with in Confidential standards. Teams will span many geographic locations.
  • Create and managing project plans using tools that facilitate task listing, assignment, tracking and approvals to ensure business requirements are completely satisfied and on time.
  • Engage and participate with various stakeholders in various testing phases i.e. UAT, DR and heading sign offs. Creating or contributing to project status on assigned projects and keep management apprised of project status, issues, risks, scope changes, and milestone achievements or misses.
  • Used JIRA for issue tracking, user story management and requirement traceability.
  • Troubleshoot data or transaction issues, and reviewed opportunities to leverage new functionality.
  • Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature are DONE and satisfied using the Acceptance Criteria.
  • Assisted with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box testing, Integration testing, DR exercise maintaining consistency in migration data from legacy by testing both systems parallelly.

Environment: Scrum - waterfall Hybrid, MS Visio, MS Project, Basel III, MS SQL Server, Visual studio 2013, JIRA 5.2, MS Office Suite (MS word, MS Excel, PowerPoint) 2013, IAS 2012.

Confidential, Cincinnati, Ohio

Sr. Business System Analyst /Scrum Master

Responsibilities:

  • Gathered requirements as per regulatory article 31 CFR Part 210 and owned the requirements process and oversaw it from the beginning of development as well as performed requirements related progress tracking, and managing Liquidity and Market risk.
  • Drafting Functional requirements by setting trade offs for Liquidity and credit risk.
  • Elicited requirements using JAD sessions, Survey/Questionnaire, Interview sessions, Focus Groups with the UI/UX team and analyzed the feasibility of the requirements and formulated and conducted GAP Analysis to derive requirements for ACH processing as well as assisting PM in creating work breakdown structure and project charter using MS Project
  • Conducted a detailed Feasibility check, Impact analysis, Cost analysis, System Functional analysis for system infrastructure.
  • Making sure of hedging risks by maintaining credit risk, liquidity risk, risk aggregation through risk reporting.
  • Coached the team and Implemented software methodologies including Agile (Scrum) Scrum - waterfall Hybrid.
  • Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
  • Created Mock-Up Screens and Wireframes using User Interface GUI components for client verification.
  • Adopted Entity-relationship modeling technique and developed Conceptual and Logical data model for DFI tables.
  • Logged Data Mapping documents of various HTML field to XML tags and further onto tables stored in database.
  • Conducted User Story Writing sessions and determine Acceptance Criteria for Potentially Shippable Product Increment.
  • As a SCRUM Master, facilitated and time-boxed the SCRUM ceremonies Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospective Meeting and Grooming Sessions.
  • Helped the Product Owner to Prioritize the Product Backlog items for developing Sprint tasks by taking suggestions from the cross-functional development team.
  • Highly proficient in writing and prioritizing user stories in Product Back Log with Product Owner.
  • Analyzed the Iteration Burn Down charts and reviewed defects.
  • As experienced Scrum Master anticipated and removed obstacles from project team’s path and pushed them to deliver quality results based on schedule.
  • Used JIRA for issue tracking, user story management and requirement traceability.
  • Troubleshoot data or transaction issues, and reviewed opportunities to leverage new functionality.
  • Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature are DONE and satisfied using the Acceptance Criteria.
  • Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the SQL Server database systems. Drafted reports based on the analysis using SSRS (Power Pivot and Power View).
  • Assisted with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box testing, Integration testing, Load testing using LoadRunner and Regression testing using UFT.
  • Extensively involved in the User Acceptance Testing phase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated.
  • Conducted Risk analysis as required by NACHA and maintained a Risk Register.
  • Communicated effectively across company contacts and clients regarding requirements, schedules and launches.

Environment: Scrum - waterfall Hybrid, MS Visio, MS Project, MS SQL Server, Basel II, Visual studio 2013, JIRA 5.2, IBM CICS, Tableau 8.3, MS Office Suite (MS word, MS Excel, PowerPoint) 2013, IAS 2012, SAS, LoadRunner 12.02, UFT 12.02, HTML5, CSS3, Bootstrap.

Confidential, Charlotte, North Carolina

Sr. Business System Analyst/Scrum Master

Responsibilities:

  • Assisted PM in creating work breakdown structure to incorporate inputs from UI/UX team and project charter using MS Project.
  • Elicited requirements as per SEC and FINRA regulatory norms and conducted extensive GAP analysis by identifying AS-IS and TO-BE process models as well as process flows and help product owner to plan how to bridge the gap.
  • Created Mock-Up Screens and Wireframes for designing GUI.
  • Facilitated Fair Value calculation as well as consolidating PnL and Balance Sheet statements for internal reports.
  • Elicited requirements involving vast set of interactions with various stakeholders using JAD Sessions, Structured Interviews, Process Analysis and Business Rules Analysis.
  • Analyzed feasibility of business requirements and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead.
  • Created a Macro Document incorporating components of Business Requirement Document and System Requirement Specification incorporating business, functional, non-functional, data and GUI requirements which would in turn serve as the centerpiece of the project.
  • Created Use Case Diagrams and Use Case Narratives and incorporated them in Macro Document.
  • Created User Stories and led the Planning Poker game to estimate them in Sprint Planning and Backlog Grooming meetings. Also, helped PO to prioritize user stories based on business value.
  • Helped product owner in prioritization of Product Backlog Items (PBIs) including the process of breaking down EPICS into user stories using INVEST criteria.
  • Facilitated and time-boxed Scrum ceremonies. Helped negotiating commitments and assured parallel understanding of requirements and deliverables amongst all stakeholders in Sprint Planning Meetings.
  • Timely assured development team has necessary resources to perform up to potential, tracked and removed impediments.
  • Performed extensive prototyping using Mock-Up Screens.
  • Handled requirement churn during the project by performing Impact Analysis.
  • Checking the feasibility of Change in Requirement and maintaining the triple constraint.
  • At the end of each sprint conducted Sprint Retrospective meetings creating the environment for each stakeholder to freely express their opinions and suggest improvement measures.
  • Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
  • Troubleshoot data or transaction issues, and reviewed opportunities to leverage new functionality.
  • Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed them in JIRA 5.2.
  • Created Spotfire Visualization and dashboards using Spotfire Professional.
  • Analyzed using Spotfire Professional and provided recommendations to the product owner over the use of Business Intelligence (BI) tools.
  • Created Structured Query Language (SQL) Queries for Portfolio Drill Downs to pull-out necessary data from the data sources.
  • Created environment for self-organization and organized team engagement activities.
  • Worked on service oriented architecture (SOA), REST, SOAP, XML, API.
  • Created training curriculum and wrote training scripts.

ENVIRONMENT: Waterfall-Scrum Hybrid, MS Visio, Mock-Up Screens, MS Office Suite, Actimize, JIRA 5.2, Moody’s, MS SQL Server, MS Project, HP Identity Management, Spotfire Professional, JAVASCRIPT CSS, AJAX, HTML, IAS 2012, BASEL lll.

Confidential

Business System Analyst/Data Analyst

Responsibilities:

  • Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
  • Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
  • Understood problem definition through one to one meetings with Data architect, Enterprise architect and Solution advisors.
  • The methodology used for the project was Waterfall and had a deep understanding about the requirement gathering. Provided clear and consistent information about project status both internally, IT team and stakeholders.
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO- BE system concepts and also prepared the System Process Maps.
  • Prepared Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
  • Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
  • Worked with QA team to design and develop Test Plan and Test Cases.
  • Performed User Acceptance Testing (UAT), Functional Testing and Regression Testing.
  • Identified Source systems for financial data profiling of the legacy system.
  • Integrated various OLTP to the OLAP by using SSIS/SSAS as an ETL tool and used SSRS (Power Pivot and Power View) as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
  • Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
  • Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
  • As a Scrum Master, I facilitated all the scrum ceremonies, namely: Sprint Planning meeting, Daily Scrum Meeting, Product backlog refinement meeting, Sprint Review meeting and Sprint Review meeting.
  • Was also responsible for resolving impediments during the entire project life. Was also responsible to update the burn down charts. Played a key role in the planning, testing, and implementation of system enhancements and conversions.
  • Used ETL to map data and assemble data repository and created data marts.
  • Used Data Center for Integrating Legacy systems and supporting in decision making.
  • Assisted in creating Data Marts with Bus Architecture.
  • Assisted in the implementation of Integrated Data Warehouse with individual data marts to address areas of business interest.
  • Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules. Understand the Software Development Life Cycle and experience in system architecture mapping. Designed and developed all Use Cases and UML models using MS Visio.
  • Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
  • Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes.
  • Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, PL/SQL, SSIS, SSRS, SSAS, HP ALM, JIRA 5.2.

We'd love your feedback!