SUMMARY

• 8+ years of experience in business process analysis, business requirements modeling and development of Web Based, and Client/Server applications in diverse business domains of Banking and Financial Sectors
• Proficient in gathering and converting User Requirements into Business Requirements and Functional Requirement Specifications (FRS) and use Modeling tools like Rational Rose and Microsoft Visio for requirements modeling.
• Excellent analytical and problem solving skills in designing, developing and implementing innovative business processes using new approaches and technology
• Commanding knowledge of various Software Development methodologies like Waterfall, Rational Unified Process, JAD, RAD, Agile and Scrum.
• Experience in the Fund Transfer Operations and Technology field. Accomplished in providing excellent customer support in a real time environment requiring immediate resolution for money movement and critical reporting.
• Combined views and reports into interactive dashboards in Tableau Desktop and presented to senior management.
• Experience in creating visualizations and reports using Tableau 9.1
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Implemented an AGILE solution for Brokerage applications which resulted in enhanced trading efficiency and reduced IT support time by 30%.
• Created different Data visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOAD).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience with SQL queries and database objects.
• Strong Experience with data migration (ETL development), document data manipulation processes and scripts
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Experience in conducting JAD sessions / Facilitated sessions for project definition involving analyzing requirements, creating prototypes, and user interface documents.
• Solid understanding of Business Requirement gathering, Requirement Analysis, Business Process flow, Business Process Modeling, Data Analysis and Data Mapping.
• Experience in preparing various documentations like Business Requirement Document (BRD), Functional Requirement Document (FRD), Data Mapping Document (DMD), Requirement Traceability Matrix (RTM), designing User Interfaces (GUI) and wireframes and other client specific documents.

PROFESSIONAL EXPERIENCE

Confidential - NYC, NY

Project Manager/Business Analyst

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Coordinate with the business Users to gather requirements for the issues raised by them on the applications.
• Coordinate with the offshore development team to explain the requirement and assign them the tasks which needs to be worked on for the issues raised by the business users
• Coordinate with the offshore to get updates on the tasks which were assigned to them.
• Performed unit testing for the tasks completed by the offshore and update the business on the same.
• Performed Data analysis and Data validation by writing SQL queries.
• Worked closely with the Enterprise Data Warehouse team to understand repository objects that support the business requirement and process.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Led the testing team and assisted the finance team with the customization and implementation of Dy- namics AX, an enterprise resource planning (ERP) solution for Confidential .
• Manages Issue Tracker for Preprocessor Enterprise Data Warehouse team, to resolve the issues proposing to correct team.
• Involved in designing and developing Data Models that support the Business Intelligence Data Warehouse for Enrolment and Eligibility.
• Assisted with project team in the whole project lifecycle phases including scope analyzing, requirements gatherings, developments and quality assurance.
• Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications.
• Performed analysis and design projects using a systems development methodology. Worked with all levels of client staff in solution definition
• Extensively involved in business process modeling
• Conducted interviews with various business users to collect requirement and business process information using MS Visio, Requisite pro.
• Coordinated with various vendors who were supporting different applications for the client to get a status updates and timelines and updated the client on the same.
• Coordinated with the accounting team in various regions such as China, India, Europe, Brazil & U.S. to get their requirements.
• Involved understanding the current business process, defining scope of the project along with position statement.
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Created business use case, functional (FRS) and technical specifications for trading system.
• Helped document the rational and requirements behind the XML architecture that encompasses data origination, secondary market and servicing data for implementing MISMO standards
• Assisted in preparing a data dictionary to provide business definitions and corresponding architecture data element tag names for MISMO
• Applied Unified Modeling Language (UML) methodology to create use case diagrams and sequence diagrams in Rational Rose.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application.
• Resolved issues and improvised the process to ensure a stable and accurate solution.
• Performed cost-benefit analysis, generated reports for analyzing various investments and their profitability and also for analyzing various lost opportunities due to time delay in investing.

Environment: MS Office Suite, MS Visio, Tableau, MS Dynamics AX,Use cases, Windows, JSON, XML, UML, Oracle 10g, PL/SQL, SharePoint, PowerDesigner

Confidential - NYC, NY

Sr. Business Systems Analyst

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Part of team as Senior business analyst involved in the design, analysis, testing and support of an asset management billing, trading account maintenance and a wealth planning tool
• Provide user support and assistance to the bank on all aspects of the bank's core banking system and its integrated systems, including testing/implementations, resolving systems issues, and supporting routine.
• Perform extensive requirement analysis including data analysis and gap analysis to create and develop new functionality to meet business needs..
• Responsible for validating the work of the KYC Analyst as well as ensuring that all pertinent information and AML risk has been addressed.
• Involved in Preparation and present dashboards to managers highlighting key findings and takeaways.
• Create advanced reporting and analysis by mining company data using SQL, Excel and Power BI. Occasionally use Tableau to analyse and visualize data.
• Performed Quantitative and qualitative document review retail Portfolios and risk models to deem fit for monthly usage in order to calculate risk-weighted assets and minimum capital requirements for Broker-dealer functions.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories and Created teas cases in ALM for test execution, defect tracking & reporting.
• Created business process descriptions, use cases, scenarios, source to target mappings, and workflow analysis.
• Managers, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
• Liaised with Clients, Front Office, Credit, Legal and Client On-Boarding as necessary as part of the KYC process.
• Expertise in creating UI Mockups, wireframes, ER diagrams, Use Case Models and creating coherent user interfaces to realize business requirements.
• Reviewed counterparty credit risk & assigned credit risk ratings for transactions for credit limit applications.
• Conducted business and data analysis and developed the activity diagrams, sequence diagrams, and created use cases using UML and AGILE methodology.
• Conducted Joint Application Development (JAD) sessions to allow different stakeholders to communicate with each other, resolve problems at an early stage.
• Conducted interviews with key business users to collect requirement and business process information for the loan process including set-up Account Information, New Loan set-up, the Appraisal, Credit, income and Title functionalities
• Designed, developed, implemented and executed test plans, test cases and test processes manually and also with XML messages and UI Web Services.

Environment: MS Office Suite, MS Visio, Tableau, Use cases, Windows, JSON, XML, UML, Oracle 10g, PL/SQL, SharePoint, PowerDesigner

Confidential, NYC, NY

Business Systems Analyst

Responsibilities:

• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Extensively involved in every phase of the RUP process starting from Inception to Transition.
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Excellent understanding of EFT system (such as ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage).Knowledge of Online Banking and the whole Fund Transfer process
• This involves Analysis & testing the actual structure of SWIFT message to ensure that it complies with SWIFT standards.
• Message Routing, validation ON both message transmission and response to the SWIFT message.
• Design, build and support usage of Tableau dashboards & workbooks to convey performance to business partners
• Message Format, Validation of field formats and field content within SWIFT messages to ensure compliance with SWIFT standards.
• Application was developed for Online Banking accessing personal accounts, checking balances, payment of recurring bills, such as mortgages and loan payments, transfer of funds between accounts of its customers.
• Perform the operation deposit, withdrawal, fund transfer, FD or RD creation or apply for Loan, along with text to speech facility.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Developed & executed several Optimized queries in SQL on this data.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Analysed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

Environment: MS Visio, Rational Requisite Pro, Rational Rose, SQL, UML, Rational Unified Process,FIX, Test Director, Crystal Reports, MS Office

Confidential - Murrysville, PA

Business Systems Analyst

Responsibilities:

• Conducted interviews with business users to gather requirements and documenting those requirements for technical and non-technical audience.
• Collaborated in building a business analysis process model using Rational Rose, Requisite Pro, and Visio and provided key initiatives in working with users in defining project and system requirements.
• Worked on various Online Banking projects like set up Check Payment, Browser variations, Keep the Change, Online Banking mail communication with live customers, Authentication flow, Alert mails to Customers etc.
• Worked with Siebel users and co-ordinate with the teams involved in testing the user interface and backend testing.
• Worked with the ETL,QA and the BI team to help them understand the data model and helped them in preparation of Data Element Mapping (Source to Target Mapping)
• Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface) and extensively used HP ALM/Quality Centre for Test Planning, Bug tracking and reporting the defects.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Identified, researched, investigated, analysed, defined and documented business processes and Use Case Scenarios.
• Analysed business requirements and developed Use Cases, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, site map and wire frames.
• Successfully used Agile/Scrum Method for gathering requirements. Documented User Stories and facilitated Story Point discussions to analyse the level of effort on project specifications.
• Documented and supported the requirements to develop the platform which enables the user to monitor his/her accounts, provides at-a-glance balances and positions, order status, account reporting, grouping accounts, real-time margin balances and real-time profit & loss.
• Captured and managed change requests throughout the lifecycle - as well as provided effort estimations to internal and external development teams.
• Documented business workflow textually as well as in UML diagrams according to agile for the stakeholder review.
• Worked extensively with SME's including heads in areas of derivatives, swaps and futures in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRDs.
• Involved in defining the source to target data analysis, data mappings, and business rules and data definitions.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Developed Test Plans and Test Cases according to Business Requirements and Followed agile methodology and maintained user stories.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.

Environment: MS Visio, MS-Project, MS-PowerPoint, MS-Word, MS-Excel, SharePoint, Rally, HP Quality Center, Agile.

Confidential, Newark, NJ

Business Systems Analyst

Responsibilities:

• Conducted interviews with business users to gather requirements and documenting those requirements for technical and non-technical audience.
• Collaborated in building a business analysis process model using Rational Rose, Requisite Pro, and Visio and provided key initiatives in working with users in defining project and system requirements.
• Documented current-'as-is' and future-'to-be' business process flows
• Gathered and documented customer requirements, detailed functional design specifications and system documentation;
• Created and maintained all related procedural documentation.
• Created UML diagrams using Visio and Rose to represent the business process visually for the relations and actions between the users and system.
• Involved in conducting JAD sessions with Business and Developer units.
• Documented Business processes in terms of customer service and feedback.
• Documented the Glossary terms
• Recorded Data Elements and Business Rules
• Identified and documented issues, risk and gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements
• Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
• Wrote SQL statements to extract data from the Tables.
• Documented functional, non-functional requirements and Use Cases
• Assisted project management with technical and support process development.
• Maintained track of timelines and project progress, using Project and Visio.
• Oversaw two complete project development life cycles.
• Created and Managed the Requirements traceability Matrix
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.
• Identified problems and presented solutions associated with Business data models, Inconsistencies in Data reporting and Business Data Exchange
• Implemented a structured system development methodology with emphasis on Rational Unified Process that dramatically improved productivity, reduced errors, and increased morale.

Environment: MS Project, MS Visio, MS Office, MySQL, Rational ClearQuest