Business System Analyst Resume - Hire IT People (2024)

Objective

• To work in a professional environment where I can utilize my Business Analysis knowledge, skills and experience for the benefit of the organization where I work.

SUMMARY

• About 10 years of experience in IT industry in Business models, tools and techniques to gather Business requirements and system requirements, defining process flow, mapping and analysis.
• Experience in Capital markets, back office and middle office operations, Trader support with Trading life cycle, Derivatives, equities, Forex, Fixed income, Money market, Corporate Lending and Counterparty credit risk, Client Onboarding, Corporate Lending Hub and Finance IT etc.
• Experienced in conducting Joint Application Development (JAD), project meetings, reviews
• Walkthroughs and client interviews by using negotiation and facilitation skills. Managing & competing stakeholder expectations, resolve issues across competing segments and channels to arrive at solutions that meets the needs of all stakeholders
• Expertise in writing Business case proposal, Business Requirements Documents (BRD), Non - Functional Specifications Documents, Use Cases, User Stories, mockups, and training manuals, SLAs and test plans. Able to transform the business requirements into System Requirements Specification (SRS) and then create business Process models, diagrams and Data models from the requirement specifications.
• Proven documentation skills plus impact assessments, risk analysis, process mapping, user testing, training and support.
• Coordination with vendors, development teams for Technology Solutions, and Onsite/Offshore.
• Strong skills in ETL testing using advance SQL queries for data analysis, data mapping and to ensure data integrity & validation of business rules in Data Warehouse.
• Excellent knowledge of SDLC and experience in reading programming languages, designing Test Framework, Methodology and Processes, Executing Test Cases and Defect Handling.
• Experience in Regulatory projects of IFRS9, BASEL III, and FATCA.
• Managed complex data and information to provide complete and accurate Business Requirements and then created Use Cases, Use Case Diagrams, Activity diagrams, Entity Relationship Diagram, and Data model diagram using UML methodology.
• Professional experience on working different environments from end to end like SIT, IAT, UAT.
• Depth knowledge of Client On boarding, Trade mapping and execution, regulatory and reporting.
• Extensive experience with Waterfall, Agile and RAD methodology for medium to large projects.
• Build strong relationships, lead discussions, listen and ask the right questions to ensure requirements are documented and obtain stakeholders approvals.

TECHNICAL SKILLS

Operating Systems: Windows, MS DOS, Red Hat Linux, UNIX, Mainframe (AS400)

Databases: Oracle, Sybase, MS-SQL, MS Access.

Programming Languages: C, C++, VBA, .Net, Core Java, PL / SQL, HTML, XML, Java Script, Python.

PC Applications: MS Office (Advance Excel with VBA, Word, PowerPoint, MS Project, Outlook, Visio)

Tools: HP ALM 10 & 11.2, JIRA, Share Point, Confluence

Reporting Tools: IBM Cognos 7, 8.2, 11, Business Objects, SAP BI, IBM Netezza, Tableau 7.0

PROFESSIONAL EXPERIENCE

Senior Business Analyst

Confidential

Responsibilities:

• Drafted detailed designs and prototypes requirements of business workflows, project roadmap, JAD sessions, GUI screens for business domain application features by utilizing MS-Visio, Paint and developed Business Process Workflow/Activity Diagrams, Epics and User stories.
• Performed analysis to identify technical and business barriers on business user requirements, worked with various stakeholders to elicit requirements, facilitated/participated in different session to finalize the solution.
• Extensively performed Gap Analysis to compare all elements of existing "As is" with desired "To be" processes to validate data quality, data profiling and data mapping by using complex SQL query. Understand and negotiate needs and expectations of multiple stakeholders by resolving business conflicts and build strong relationship.
• Provided technical recommendations and constraints associated with eligibility and develop comprehensive and accurate functional specifications; data mapping, data sourcing using SQL and reading codes to identify data manipulations, process flows and identified optimum solution to business and technology through group elicitation.

Business Analysis Advisory

Confidential

Responsibilities:

• Provided full support LOAN IQ to migrate data sources, additions of new business rules, new lending initiatives of business process including various fees, invoices, introducing new transits and ensured it flows to all required down streams.
• Managed multi-disciplinary project Lending Hub replacement to implement solutions to business problems and Loan life cycles for planning, defining business requirements and process, lead design and development of data extraction and transformation, financial reviews, and securing consensus and co-operation from users and senior management.
• Worked with vendor to provide requirements specifications and was responsible for the assigned business analysis work packages end to end including responsibility for monitoring and scheduling control throughout the project lifecycle and guided user for UAT testing.
• Extensively used SQL in Data sourcing, data mapping and mining and data analytics for ETL testing in SIT and UAT as well as used knowledge of programming languages to analyze existing code / logic.
• Implemented Rapid prototyping and Agile methodology thorough out the project cycles using JIRA. Participated in daily scrum, sprint planning, review and retrospective.

Business Analyst

Confidential

Responsibilities:

• Conducted data analysis, data mining to identify risk, solutions to guide the recommendation of innovative business and reporting solutions for Trading life cycle.
• Documented business requirements, functional and non-functional requirements and used various requirement elicitation techniques like JAD, interview, brainstorming to identify optimum solution to business and technology.
• Created User interfaces, GUI screen to provide maximum functionality to users.
• Participated in requirements gathering of daily transactions reporting and trade settlement cycle of each trader and other MIS reporting.
• Performed the Gap analysis of the earlier systems and analysis with excel, generated a detailed System Requirements document describing new system architecture through Use Cases and Activity diagrams
• Extensively worked on Data warehouse Upstream and downstream systems to extract and provide relative data.
• Prepared test plans, test cases and test data and performed stress, regression and back-end testing for multiple capital markets projects deployments. Provided training to the team on how to use HPQC.
• Extensively wrote PL/SQL Queries to extract data from database tables for data analysis, data mapping and validation purpose of incoming data as well as for ETL Testing on Data warehouse projects in SIT and UAT.
• Extensively used programming knowledge to read stored procedure and codes to find out logic.
• Liaised with developers (onshore/offshore) to walkthrough/review and verify Technical documentation and application workflow.
• Used Service now application for change management tickets and promotions for different environments

Business System Analyst

Confidential

Responsibilities:

• Created GUI screens using iRise to review the requirements and provide feedback on the screen design. Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
• Used Visio to carry out the business modeling and object modeling effort to develop the information business architecture and workflow diagrams for the application for rapid and controlled Web Application development.
• Developed test strategies, plans, scripts, defect and closer report which adhere to business requirements, and participate in the testing of developed systems/solutions.
• Coordinated with stakeholders to ensure documented requirements and design goals have been met.
• Managed software validation and verification processes on .Net platform to ensure that the application meets requirements and functions properly.
• Identified root causes for software defects by debugging and reviewing source code.
• Coordinated in various technical and managerial teams to develop process and verifying adherence using the Requirements Traceability Matrix (RTM).
• Coordinated in creating multiple reports using IBM Netezza reporting tool.
• Worked with Oracle database and created and executed SQL statements for ETL and for Data mapping in a specific manner to determine efficient record transaction management in Data Warehouse.
• Involved in organizing and executing all stages of project leading up to a successful release the product.

Business System Analyst

Confidential

Responsibilities:

• Written Business requirements, functional requirements, supplementary GUI requirements, reporting requirements and non-functional requirements to capture all the business requirements.
• Prepared Use Cases, Process model diagram, activity diagrams in UML rational rose.
• Managed all the system requirements and traceability between requirements. Played a pivotal role in conducting Functional testing, Regression testing, and User Acceptance Testing.
• Worked on setting up new downstream feeds as well as enhancement to existing feed.
• Documented UAT test plan and conducted a walkthrough session to make sure all other teams (Development, SIT, Deployment, SME and Baseline) understood their roles and effort.
• Participated in end to end project life cycle with waterfall methodology.
• Coordinated and prioritized outstanding defects and enhancement identified during SIT and escalated the same if necessary, to achieve the deadline.
• Done data mapping, data sourcing & database analysis using complex SQL Queries in Data Warehouse (My SQL and Oracle server)

Business System Analyst

Confidential

Responsibilities:

• Assisted project manager with the creation of project plan covering Project Schedule, Assignment of tasks, Risk management Plan and Test Strategy with waterfall, interactive methodology.
• Conducted multiple one on one and brainstorming sessions with the SME’s to understand the as-is process and gather business requirements.
• Translated business requirements into system requirements document. Documented as-is data flow diagrams and to-be data flow diagrams when process is moving from manual to automation.
• Drafted use case model, business use case specification, GUI requirements, reporting requirements and non-functional requirements to capture all the business needs.
• Managed all the system requirements and traceability between requirements, design, SIT test cases and UAT test cases using HPQC.
• Extensively used Advance SQL on Data Warehouse for Data Mapping, Data Sourcing, Data Profiling, Functional testing, Regression testing, and User Acceptance Testing (UAT).