SUMMARY:

• 8+ years of experience working as a Business Analyst, within the Financial/Banking Industry.
• Worked on projects impacting investment clients and card holders in Accounts, Fraud, Claims, Collections, and Mutual funds including Account Master and Processing flows.
• Knowledge of regulatory compliance - AML/BSA, Dodd Frank, PCI-DSS and CFR.
• Expertise in assessing the business need and processes, performing Requirements Gathering, modeling, analyzing and documenting Business Requirements (BRD), Functional Specifications (FRS), Mockups, Object Oriented Modeling (OOM), Reverse and Re-Engineering, Change Management, Impact analysis, Gap analysis and Release Management.
• Used RUP, Waterfall and Agile methodologies. Developed User Stories (and Epics) for each Sprint.
• Coordinated development of Project Plan, scope document, Work Break down structure and documentation of SLAs, DTS’s, technical design and test specifications for Release Management.
• Strong in Modeling (UML, MS-Visio, Sybase - Power Designer, IBM- BPM), Data Analysis, SQL, MS-Office, MS-SharePoint, MS-Project, Jira, and QC/ALM.
• Worked with users, architecture, technical (application development, production support, infrastructure and networking) teams for design, data, and timelines. Worked with QA team for creation and implementation of test plans, test strategy, test scenarios, test cases for system and user acceptance testing (UAT). Experience working with offshore teams.
• Experienced in Object Oriented Analysis and Design (OOAD), Data Analysis, Relational Database, Data Warehousing, Hadoop, SQL, ETL, Integration, SOA, shared services, Graphical User Interface (GUI) and user experience.
• Proficient in developing User Stories, Use Cases, wireframes and creating Use case diagrams, Activity Diagrams, Swim Lane diagrams, Component, Sequence Diagrams and Class Diagrams.
• Experience working with Project Management, multiple Lines of Business, vendor teams (including COTS providers), clients, Stakeholders, Subject Matter experts, end users and Technical teams to achieve project objectives.

TECHNICAL SKILLS:

Operating System: Windows 7, 8.1, 2000, XP, NT, UNIX.

Tools: MS-Word, Excel, PowerPoint, Visio, BPM, SharePoint, MS - Project; Edraw.

Business Analysis: UML, RUP, PowerDesigner, Visio, BPMN.

Database: SQL Server2000, Sybase, MS Access, Oracle.

Testing Tools: Manual testing, Silk, Quality Center 8.2, ALM, JIRA, SQL, Mobile Testing.

EXPERIENCE:

Confidential, NY

Business Analyst/Technical Project Manager

Responsibilities:

• Performed business analysis by liaising with executive teams (Center of Excellence -card, payment), business users, vendor, technical teams and other stakeholders for a multi- phased project.
• Leveraged industry and enterprise knowledge to design and implement as per the defined approach.
• Created process flows to depict the design using MS- Visio and worked on the timelines for tollgates.
• Captured business requirements, assumptions, exception scenarios and non-functional requirements. Gathered business requirements using various techniques including JAD.
• Captured and tracked product backlog, user stories in Jira and Rally following agile methodology.
• Performed impact analysis and analyzed data flows and metadata. Captured new fact model, updated data models and data specifications for each phase.
• Worked with enterprise information security (GIS, Payment Card Industry Data Security Standards - PCI DSS), model governance and risk assessment teams to validate compliance with policies and standards and gain approvals. Worked with business team to capture the KPI’s for risk assessment.
• Created mockups for short message service (SMS), email messages and customized UI screens. Worked with User Experience, people process and legal teams for design and wording for the screens.
• Used SQL to track and transaction data, identify volume impacts. Performed data analysis and provided weekly charts to show trend.
• Created and dispatched project and reviewed estimates of impacted teams. Coordinated with project manager, technical teams and release management (RM) to meet milestones.
• Reviewed internal and external vendor and client guides to meet compliance and partner implementation per timelines. Coordinated with Visa, MasterCard and American Express.
• Captured and maintained the Work Breakdown Structure (WBS) and deployment schedules (Gantt chart) in MS-Project. Provided weekly project updates to all stakeholders.
• Captured the RASCI matrix and maintained through new and updated tasks.
• Facilitated document reviews (SPD, HLD/LLD, Technical specifications, data specifications).
• Provided coordination for scheduling new batches via payment network and processor (TSYS).
• Facilitated and lead technical meetings for analyzing data flows through impacted applications.
• Completed DTSs, SLAs through meetings and follow ups with development teams to meet Data management standards (EDM). Ensured design incorporates all business rules.
• Coordinated effort for addition of new functionalities in data orchestration layer.
• Analyzed data from multiple sources using SQL queries. Evaluated technical specifications, internal Data Lineage, performed Data Mapping (internal and external) and captured new data flow diagrams.
• Prepared documentation and slides, facilitated meetings for design decisions and approvals.
• Maintained documentation on SharePoint and tracked test scripts and defects in QC/ALM.
• Supported User Acceptance testing and coordinated Component Integration (CIT), System Integration (SIT) and performance testing. Mentored junior Business Analysts.

Environment: Windows 9, Hadoop(Impala, HBase), SAS, Java 1.6, Unix, Mainframe, Informatica, XML, HP-ALM, JIRA, Rally, MS- Visio, UML, MS-Project, MS-Office, Nexus, PPRT, SharePoint, and NoSQL.

Confidential, DE

Business Systems Analyst

Responsibilities:

• Performed analysis and designed multiple projects in Card Services, including a new solution.
• Lead Business Systems Analyst for Dormant Vendor R. Data Management (DVRDM) and Anti Money Laundering (AML/KYC) - Capture & Screening projects, worked on Risk, Legal and compliance impacts.
• Used SQL extensively to query database for data analysis. Performed data mapping for migration.
• Captured the Business requirements, functional requirements and data specifications (vendor and client data). Tracked adherence to the project plan and business case.
• Participated in concept meetings. Analyzed and modeled the business process flows for various Lines of Business (LOB) through the impacted applications.
• Captured RACI matrix, Scope document and Impact Matrix. Interacted with stakeholders and business users, reviewed operational flows to capture Business Processed and business logic, and proposed solution design to meet business strategy.
• Captured requirements during JAD sessions, created Process flow Diagrams, mock up screens.
• Documented Business Requirements, Used Cases, Business Rules and Functional Specifications; captured swim lane diagrams, activities and tasks in IBM - BPM tool.
• Used Blueprint for capturing and managing requirements and MS-Visio for wireframes, use case diagrams and activity diagrams. Ran SQL queries to analyze and verify data.
• Gathered requirements for customization of screens of vendor product - Computer Assisted Collection System (CACS), to optimize it for the impacted lines of Business.
• Facilitated and led cross team coordination for Integration with Origination and Payment systems.
• Developed Product Backlog, User stories, provided details to help weight story points during grooming session. Managed Sprints and daily stand-ups as per Agile/Scrum Methodology.
• Delegated and followed up with offshore Business Analysts, coordinating for milestones.
• Provided walk through to development and testing teams (IS and UAT).
• Supported during build and test phases. Used JIRA for different projects to capture and track backlogs, epics, user stories, burndown charts for sprints.
• Conducted joint sessions with development and infrastructure teams. Facilitated working sessions (technical) to resolve issues. Co-ordinated with offshore team and technical team of vendor.
• Coordinated change control. Mitigated scope creep and contributed to adherence to timelines.
• Maintained issue log and various project deliverables in MS-SharePoint
• Created Functional specifications capturing ETL process and Error Reporting.
• Updated the enhancements in documents with impacts to web services.
• Participated in metadata review meetings for integration of new source in the data warehouse.
• Assessed the future state and performed Impact Analysis for the components.
• Analyzed requirements and provided project estimates, work break down structure.
• Supported testing efforts - test plan documentation, review test cases and defect tracking.
• Supported data assessment for Logical and physical data models. Participated during data review.
• Supported System and regression testing efforts and User Acceptance testing (UAT) efforts.
• Assigned, tracked defects to resolution in AML, and attended daily defect call status meetings.

Environment: Windows 9, SQL developer, Java 1.6, Unix, Informatica, XML, HP-ALM, JIRA, MS- Visio, UML, IBM - BPM 8.5, MS-Office, SharePoint, Blueprint, Erwin and SQL.

Confidential, NJ

Business Systems Analyst

Responsibilities:

• Re-engineered five legacy applications. Reverse Engineered and created the Object Oriented Models (OOM) from Source Code, defining the parameters in Power Designer.
• Analyzed the PowerBuilder applications and provided estimates for the Re-platform effort.
• Identified and analyzed problematic SQL queries for remediation by assessment, verification and followed through resolution.
• Mapped usage of stored procedures for Impact Analysis in all components and wrote remediation SQL statements for multiple applications.
• Captured Application and Object level details to quantify the effort.
• Gathered and analyzed requirements. Prepared presentations for the stakeholders.
• Performed data analysis to verify compliance to standardization.
• Created the Business Requirement Document, Functional Use Cases, Functional Requirements, and GUI mockups; incorporated the business rules. Captured the Standard Operating Procedure (SOP).
• Analyzed Business processes, created the Process Flow Diagrams, Data flow diagram of the upstream and downstream data feeds for all scoring programs.
• Gathered the data for programs based on the compliance for required level.
• Developed Use Case diagrams, Activity Diagrams, Collaboration diagram and Sequence Diagram using Power Designer. Utilized the Data models for the Oracle remediation.
• Created the Entity Relationship diagram. Developed the wireframes for SKM - CSM.
• Documented Software Component Specification and User Interface Specifications for SKM CSM.
• Identified and documented the steps for the remediation process (Oracle 9i to 11g upgrade).
• Performed Change Control management and Gap analysis.
• Created the Traceability matrix for all components and maintained through completion.
• Followed the Agile methodology, captured the User Stories, prioritized for each sprint and followed up during development and testing.
• Contributed to assessment and adherence of scope and timelines, provided updates for Operational readiness reviews (ORR) by reviewing relevant artifacts.
• Used Borland SilkCentral - Test Manager and Issue Manager to log and track the issues (PNs).
• Used Javadoc and generated documentation for the remediated Java components to maintain updated versions. Used MS-SharePoint for all document management.

Environment: Windows 9, Oracle 9i, 11g, Java 1.6, Sybase PowerDesigner 16.1, Sybase PowerBuilder 12, C, PowerBuilder Libraries Viewer 1.0, UML, MS-Office(Word, Excel, Powerpoint), Sharepoint, Borland SilkCentral 8.9, MS-Outlook and SQL.

Confidential, NJ

Lead Business Analyst

Responsibilities:

• Analyzed the components of the different existing SaaS solutions and Supply chain for designing new solutions. Assessed process and data flow for the modules.
• Liaised between management, clients (current and prospects), business users, technical staff and interacted with sponsors, business partners (including Merck, Novartis) and vendors.
• Worked with internal and external stakeholders to identify product functionality and business rules, ensured conformity to business and market intelligence.
• Provided details and charts for use in marketing material. Designed solutions to meet strategic goals and revenue expectations for projects implemented as Software as a Service (SAAS)..
• Created Prototype using Oracle Apex as per the RFP for gaining sponsor approval.
• Captured Mind Map, Brainstorming diagram, SWOT analysis, Business Case, Project Plan and contributed to the Project Charter for various projects.
• Facilitated JAD sessions, led meetings. Created wireframes to gain consensus and recommended improvements. Used UML for Analysis & Design.
• Developed Use Case diagrams, Sequence, Activity diagrams and data flow diagrams.
• Documented business Process Flow, Scope document, Business Requirement Document (BRD), Functional Specifications (FSD), project schedules, project scope and test plans.
• Collected Data and verified its in corporation by extensively using SQL.
• Analyzed the coordinate systems and verified the maps developed as per GIS. Mapped the functional flows from Inventory Management module to the Accounting module.
• Worked on CFR Title 7 Part 810 (Grades), 800 (collateral) and Southwest scale for integration in the calculations and capturing of Forward Contracts.
• Designed Reports and Dashboards that support operational goals through the identified KPIs.
• Performed Data Analysis to check the conformance of features for internationalization.
• Provided status during weekly and monthly calls to evaluate progress and adherence to development and scope. Worked closely with all stakeholders to manage timelines.
• Performed feasibility analysis, recommended project strategy and prioritization.
• Assessed and captured the functionalities for mobile version and worked with the development team for the User Interface (UI).
• Provided walkthrough of the functional requirements and to the development and testing teams.
• Built the logical data model. Performed data mapping using SQL.
• Created and maintained the Traceability Matrix, performed Change Management and addressed scope creep. Managed all open issues.
• Organized meetings to monitor progress and recorded and reviewed the minutes.
• Facilitated brainstorming and SWOT analysis sessions.
• Captured the information using Edraw. Developed presentations and reports for business groups.
• Involved in developing the test strategy and assisted in developing test plans, test case objectives and test data. Created SQL statements to validate the data.
• Performed GUI testing and user acceptance testing (UAT) for the web and mobile applications.

Environment: Windows XP, Oracle Application Express 4.0, Oracle, Java Script, JQuery, Oracle ADF, JDeveloper, HTML, UML, MS-Office, MS- Visio, Edraw, Quality Center, and SQL.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Gathered requirements from business users, analyzed and documented them.
• Documented functional specifications for the development of the Accounts module.
• Organized and led meetings, JAD sessions, and presented story boards to ensure accurate comprehension of the existing situation with regards to mismatched scenarios.
• Followed and applied SDLC Methodology in planning, defining the solution, requirements - analysis and management, design, development, integration, testing as well as implementation and .
• Obtained signoff for the UAT process before rolling out to production. Performed GUI and navigation testing.
• Used SQL to query the database, used joins to query data from multiple tables.
• Prepared and analyzed AS IS and TO BE features of the application and performed Gap Analysis.
• Developed wireframes using MS-Visio for the depiction of changed GUI screens.
• Designed and developed Use Cases, use case diagrams, UML diagrams, using MS Visio.
• Acted as a liaison between business users and technical team during development process.
• Conducted interviews with clients for the purpose of gathering product requirements and understanding the client workflow. Created reports for the stakeholders.
• Created all deliverables - Scope document, Business Requirement Document, Functional Requirement Document, Requirements Traceability Matrix, Test Approach Document and uploaded artifacts to the repository.
• Worked with the Quality Assurance team to create Test Plan, Test Data, and Test Cases. Supported system testing using Quality Center. Conducted User Acceptance Testing (UAT).
• Tracked defects using JIRA and mapped test cases to requirements using requirements traceability matrix and created defects report for open defects.
• Participated in developing of Materials and provided User .

Environment: SDLC, Windows, J2EE, Oracle, TOAD, UML, SQL, Quality Center, JIRA, Oracle, MS Project, MS Office.

Confidential, New York

Business Analyst

Responsibilities:

• Gathered business requirements and documented along with business rules for the solution to be developed. Captured the flows for data feeds from Account Master.
• Documented Business Requirements (BRD), Functional specifications (FRS) and use cases. Created Reports for monthly and daily status based on live data.
• Used UML and MS-Visio for business modeling, and creating use case diagrams, activity diagrams, and sequence diagrams and created mockups.
• Performed analysis and assessment across the various functional business units to support re-engineering efforts and check adherence to scope.
• Assessed Quality Management strategies with various internal teams and implemented enhancements to augment Data accessibility and to identify data quality related issues.
• Interacted with the US (NY and LA), London and Canada users to assess business needs, obtain consensus and approval for change requests and reach consensus for project scope and timelines.
• Designed and maintained the Requirements Traceability Matrix and associated change requests with requirements. Developed Use cases for functional requirements.
• Conducted Impact Analysis and Gap Analysis to assess disruption due to new requirements and resolve them.
• Worked with developers and data analysts for Data Quality management and Control (DQMC).
• Coordinated Test Planning and Test Case, integration, system and regression testing. Conducted User Acceptance Testing (UAT).
• Implemented RUP Methodology of application development with its various workflows, artifacts, and activities.
• Wrote SQL queries using TOAD for verifying certified data updates in Data warehouse.
• Reported weekly on status, milestones and project tracking to project management and stakeholders.

Environment: .NET, RUP, UML, SQL, TOAD, MS Visio, MS Project, MS Office (Word, Excel, PowerPoint), SharePoint, SQL Server.