SUMMARY:

• About 10 years of experience in IT industry in Business models, Business System Analysis principles and techniques to gather Business requirements and system requirements through SDLC and worked on end to end for PMLC.
• Experience in Capital markets, back office operations, Trader support with Trading life cycle , Derivatives, equities, Forex, Fixed income, Money market, Corporate Lending and Counterparty credit risk, Client on Boarding & AML, Corporate Lending Hub etc.
• Experienced in conducting Joint Application Development (JAD), project meetings / Presentations, 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, Business Requirements Documents (BRD), BPM (Business process mappings/models, NFR, Use Cases, User Stories, mockups, and training manuals, SLAs and test plans.
• Transforms the business requirements into System Requirements Specification ( SRS ) and NFR then create business Process models, diagrams and Data models, Use cases from the requirement specifications.
• Proven documentation skills for risk analysis, process mapping, QA testing, training and support.
• Coordination with vendors, development teams for Technology Solutions, and Onsite/Offshore.
• Strong skills in ETL (Informatica & Data Stage) testing using advance SQL queries for data analysis, data mapping, data integrity, and data quality of business rules for data architectures 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, compliance and audit projects of IFRS9, EMIR, BASEL III, OSFI, and FATCA.
• Managed complex data and information to provide complete and accurate Business Requirements and created Visio Diagrams, Activity diagrams, ER Diagram, and Data model using UML methodology.
• Experience on working environments from end to end like SIT, IAT, UAT with implementation support.
• Extensive experience with Agile - Scrum, Waterfall and RAD methodology for medium to large projects.
• Performed project management activities to define Cost benefit analysis, scoping, estimating, risk mitigation plans and recommendations, status update and escalation of issues.
• Acted as Scrum Master, lead and mentor BA team and collaborated, promoted positive environment and built strong relationships with multiple stakeholders, interacted with executives regarding project proposal.

TECHNICAL SKILLS:

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

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

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

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

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

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

Education: Bachelor of Computer Application, India Jun - 2004

Canadian Software Testing Board: CTFL (ISTQB) Nov - 2011

Professional Scrum Master: PSM I Mar - 2018

Project Management: PMP In Progress

PROFESSIONAL EXPERIENCE:

Business System Analyst

Confidential

Responsibilities:

• Creating Business case, Scope of service, benefits management plans (Cost, Benefits & ROI), business and technical requirements documents.
• Working SAP project which is replacement of legacy system. Analyzing the business needs and identity and provide solutions to meet strategic goals and following agile methodologies.
• Leading multiple initiatives, JAD sessions, drafting business workflows, data models and data analysis, data mapping throughout the project using SQL.
• Constructing documents for Agile methodologies like Epics, theme and User stories using JIRA and managing projects through Confluence.

Senior Business Analyst

Confidential

Responsibilities:

• Worked on CQRS (Credit Quality Risk reporting- Cognos 10) replacement project as a Lead BA for IFRS9 regulatory reporting for expected credit loss and provision credit loss risk engine for end to end credit life cycle.
• Drafted detailed designs and prototypes requirements of business workflows, data architecture and infrastructure through ERDL (Enterprise Risk Data Lake) with Big data, project roadmap, GUI screens for business domain features by utilizing MS-Visio, developed Business Process, Activity Diagrams, Epics and User stories in Agile methodology.
• Acted as Scrum Master as well as created Epics and User stories, Story mapping in Agile/Scrum methodologies.
• 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:

• Worked on corporate Loan products (secured & non- secured) with systems like ACBS (Advance Commercial Banking Systems), CRS (Compliance Reporting System), and LoanTrak, SyndTrak, Regulatory Reporting - (IFRS9, FATCA, VOLCKER), IBM Cognos migration to Tableau, ACBS DataMart, Patriot Act Reporting and data integration and process engineering projects from multiple source systems.
• Provided business supports to new and existing projects including Corporate Lending Replacement (CLR) ACBS migration, Loan-Trak migration, CRS, ACRM (Automated Client Risk Measurement).
• Acted as Scrum Master and followed Scrum methodology thorough out CRS project using JIRA. Participated in daily scrum, sprint planning, review, retrospective and worked closely with Product Owner and business stakeholders.
• Provided full support to loan trading data initiatives, additions of new business rules, new lending initiatives of business process & various fees, invoices, introducing new transits and ensured it flows to all required down streams.
• Led multi-disciplinary Lending Hub replacement project (4-6 teammates) to implement solutions to business problems, created business case, data architecture, recommended feasible cost-effective solutions lead design and development of data architecture, BPM and Visio diagramming with UML methodologies.
• Worked with vendor to provide requirements specifications and was responsible for the assigned business analysis work packages end to end SDLC life cycle for monitoring and scheduling control throughout the PMLC lifecycle including SIT automation and functional testing and guided user for UAT testing.
• Extensively used SQL/ Python for Data sourcing from My-SQL, 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.

Business Analyst

Confidential

Responsibilities:

• Gathered requirements from Business Owners, stakeholders and the subject matter experts through meetings to understand needs of different types of capital markets products and assets classes (Equities, FX, FI, MM, Commodities, Derivatives - Options, Future, Forward, Swaps) with Murex system.
• Worked on multiple Trade life cycles projects with SDLC including derivatives, FX Maintenance reporting, IBM Cognos Impromptu 7 to Cognos 10 Migration, Client Data Repository (MDM), Client Coverage, MIS Reporting, ESG management group, STARS Online (.Net), STARS-OLAP and Spotfire BI and Derivatives reporting Projects.
• Conducted data analysis, data lineage, trade data initiatives and solutions to data architect with recommendation of innovative business and reporting solutions for Trading life cycle and managed and controlled projects through PMLC.
• Documented business requirements, functional and non-functional requirements and understand technical recommendations and constraints associated with eligibility, and develop comprehensive and accurate technical specifications document, process flows and identified optimum solution to business and technology.
• Participated in data analytics with Big data & Hadoop, Created User interfaces, GUI screen with low fidelity wireframes, sketches and POC (Proof of Concept) to provide maximum functionality to users.
• Facilitated meetings, PowerPoint presentations, JAD sessions, Walkthroughs and provided support to business users such as investigations on message flagging, system alerts. Monitoring of status and reporting on trade life cycle.
• 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 with Visio diagramming.
• Extensively worked on Data Warehouse Upstream and downstream systems to extract and data architecture and XML coding. Followed Agile Scrum methodologies throughout the projects and performed scrum rituals.
• Prepared SIT & UAT test plans, test cases and test data and performed automation, regression and back-end testing for multiple capital markets projects deployments. Provided training to the team on how to use HPQC and JIRA.
• Led Off-shore team and followed Agile-Scrum, Prototype and waterfall application development methodologies.
• Extensively wrote PL/SQL Queries to extract data from database tables for data analysis, worked to manipulate (delegate list) data as well as for ETL Testing on Data warehouse projects in SIT and UAT. Extensively used programming knowledge to read stored procedure and update coding for automation testing.

Business System Analyst

Confidential

Responsibilities:

• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a system requirement specification format that can be reviewed and understood by both business people and technical people.
• 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, sketches 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 with advance excel skills (H, V -Lookups, Pivot tables, VBA scripts).
• 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 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:

• Involved in projects of banking and investments, healthcare system, insurance and Accounting systems.
• Created BRD, SRD, NFR and Service level agreement to meet all current business requirements and anticipated future enhancements for .Net application and Java applications. Worked on mainframe (AS400) for financial clients.
• 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, design, SIT test cases and UAT test cases using HPQC.
• Performed automation testing using QTP and extensive used VB scripting to modify coding.
• Extensively used Advance SQL on Data Warehouse (MS SQL server, Oracle) for Data Mapping, Data Sourcing, Data Profiling, Functional testing, Regression testing, and User Acceptance Testing (UAT).