SUMMARY

• Well - rounded 7+ years of diverse industrial experience as Business Analyst / Systems Analyst in Wealth Management Solutions, Finance Merger, Retail Banking, Mortgage Loan, Accounts Payable and Cash Management Services.
• Solid understanding of Business Requirement gathering, Business Process Flow, Business Process Modeling, Business Analysis and Data Analysis, Mapping, Clean-up and Conversion
• Strong knowledge of SDLC, RUP methodology, Agile methodology and Project Life Cycles.
• Expertise in identifying, developing and documenting business and Functional Requirements Specifications (FRS), Software Requirement Specifications (SRS), organizing discussions and requirement elicitation sessions.
• Strong knowledge of constructing UML Diagrams, using IBM Rational Rose and MS Visio.
• Experience in writing Test Cases, Test Scenarios, developing Test Plans and conducting User Acceptance Testing, SWOT analysis, GAP analysis.
• Experience in Business Intelligence, Data Warehousing and Business Architecture.
• Significant exposure to Cross Cultural Diversity.
• Robust leadership skills that facilitate mediators and conflict resolution at levels of project management group.
• Excellent interpersonal skills with proven ability to develop strong relationships within the organization in order to coordinate project operations.
• Strong time management skills in handling multiple projects and deadlines under minimal supervision.

TECHNICAL SKILLS

Operating Systems: Win 98 / 2000 / XP

Languages: C++, Java, J2ee, Visual Basic, RPG, Html

Modeling Tools: MS Visio, IBM Rational Rose, Smart Draw, Erwin Data Modeler

Documenting Tools: MS Office (Word, Access, Excel, PowerPoint), MS Project, Requisite Pro

Screen Capture and Image Editing: SnagIt

Database: MS Access, SQL, PeopleSoft, BizTalk

Financial Systems: GLAS, STARS (Ledgers / Subledgers), CFRS, Hyperion (Corporate Reporting Systems), SEM-PA (Reporting Systems), Accelerator, Axys, STP (Straight Through Process), FiServ, eBBS, SAM, Fifth Third, MMARS (Baseline Advantage), CMS

Testing Tool: Mercury Quality Center, Rational ClearQuest

PROFESSIONAL EXPERIENCES

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Extensive walk-through on Massachusetts Management Accounting and Reporting System (MMARS) and Cash Management System (CMS)
• Primarily work on the Project Areas that directly or indirectly impact Accounts Payable Bureau (APB), which include Statewide Vendor Payment (Regular Check and/or Electronic Funds Transfer (EFT) Disbursement and Cancellation Process, Float Fund and Investment (Portfolio Accounting), and Accounts Reconciliation.
• Analyze ‘Current Business Processes’ and ‘Proposed Future Business Processes’ (Solution Approaches) suggested by the Application Vendor CGI.
• Coordinate the Project initiatives with TRE and CGI by representing APB (CTR)
• Perform extensive Data Analysis, Mapping, Clean-up and Conversion from CMS (Source) to MMARS (Target)
• Raise Issues and identify GAPS and Differences.
• Lead on all the Action Items related to APB to resolve to fit into Solution Approaches.
• Suggest to streamline and/or automate (where feasible) the existing manual processes performed by the State Treasury.
• Prepare Use-Cases for various business processes that are suggested to be automated.
• Gather the requirements / specifications for Procurement Card (similar to Credit Card), analyze and document the Business process, set-up the criteria based on the eligibility, and delegate to the personnel requested by the departments across the State, and initiate and disburse the monthly payments to the banking partner on behalf of the departments.
• Notify business architects of modified or new fields, tables, documents and reports to be added to the Data Warehouse detailed in the envisioned state requirements.
• Develop existing and future Business Process Diagrams using MS Visio
• Redesign Screen Mock-ups for cosmetic change using SnagIt.
• Create Incidents in Rational ClearQuest for custom change and follow up on bug tracking and process automation.
• Work closely with QA engineers to prepare Test Scripts and Test Cases, and also facilitate various Testing initiatives (Shakedown Testing, System Testing, Regression Testing, UAT).

Confidential, Dorchester, MA

Business Systems Analyst

Responsibilities:

• Performed extensive walk-through on SAM (Sovereign Account Maintenance) and FiServ (Third Party application for Personal and Business Account Opening and Maintenance)
• Reviewed the present Use-Cases for the Account Maintenance Functionalities that already existed for SAM.
• Gathered Business Requirements from Line of Business for Target SovSelling Application.
• Identified GAPs between existing SAM and Proposed SovSelling Application.
• Originated and Substantiated Business Rules for sub-functions within the Account Maintenance Functionalities.
• Prepared the Use-Cases for proposed ported and standalone Account Maintenance Functionalities in light of the Target SovSelling application.
• Developed Use Case Diagrams and Activity Diagrams using MS Visio and Rational Rose.
• Performed extensive Data Mapping, Clean-up and Conversion between SAM and Fiserv Host Applications in light of SovSelling perspective.
• Redesigned Screen Mock-ups using SnagIt.
• Followed-up with Business Group, SME, Operations and also, facilitate project manager to conduct daily / weekly meetings with UI Designers, Developers and QA for updates and project status.

Confidential, Boston, MA

Business Systems Analyst

Responsibilities:

• Performed the data mapping and reengineered the downloading process for Pershing (an affiliate of the Bank of New York), Schwab Institutional, TD Ameritrade Institutional and Fidelity Brokerage Services.
• Worked extensively with Investment Professionals, Financial Analysts, Operations as well as Business Architect and Development leads on requirement gathering and process evaluation
• Performed system analysis on the architecture of source as well as target application Custodian Download Process
• Designed new data process flows (Custodian Download) for the existing systems as well as for the enhanced systems
• Run and modified basic SQL queries to populate desired outputs; distinct Transaction & Security Types, etc as per business requirements for data integrity and data cleansing
• Translated requirements into business rules using the BizTalk server Tool
• Prepared Business Specification for Schwab Institutional and TD Ameritrade Institutional
• Articulated business requirements to create Use Cases, Activity Diagrams and Sequence Diagrams using MS Visio for different custodial files (Name & Address, Transaction, Security, Pricing, Trade and Fee Files) downloading process.
• Created Project Plan using MS Project
• Performed extensive GAP analysis for facts and dimension and followed up with business and individual expertise with Action Items to resolve the issues
• Responsible for addressing, diagnosing and resolving issues that arise on a day to day basis and also documenting the causes and final resolution
• Responsible for facilitating QA engineers to carry out Manual and Automated testing during various phases of testing; Functional Testing, Performance testing and Regression testing, etc
• Conducted and lead status report meetings with the business sponsors, operations and the IT (development and Product Configuration) team on a weekly basis.

Confidential, Newport, NJ

Business Analyst

Responsibilities:

• Coordinated the development and integration of Finance requirements for the project across all workstreams (Reference Data, General Ledger (GL), Data Capture, Reconciliation, Clearance and Settlement, MIS, Corporate / Regulatory Reporting, Testing and Infrastructure).
• Identified Line of Business (LOB) data requirements and Finance business processes in order to support those needs.
• Gathered detailed information / requirements from LOB for in-scope and out-scope of the project.
• Prepared Finance Project Charter, which illustrated In-Scope and Out-Scope of the project in terms of finance impact, Current & Future State of Data Flow and also analyzed workstreams impact, etc.
• Validated detailed designs for solutions (Business Flow and Functional Specifications) for projects across all workstreams.
• Documented business constraints and assumptions.
• Assisted Project Manager in balancing project goals and business needs and preparing project plan using MS Project.
• Identified and mitigated project Issues / Risks, follow-up with Action Items and prepared Status Reports.
• Assisted Project Manager in development of project milestones and project deliverables.
• Collaborated with the QA team to facilitate and track test tasks, activities and milestones during Day 1 & Day 2 Conversion Event.

Confidential, Manhattan, NY

Business Analyst

Responsibilities:

• Interacted with the executives and software development team to liaison the business requirements to ensure that the proposed upgraded application complies with the business requirements.
• Performed SWOT and GAP analysis for new functionality requirements as well as prioritized them based on actual business needs.
• Developed and facilitated implementation processes for requirements gathering, analysis, planning, tracking and delivery using Rational Rose, Requisite Pro - RUP.
• Facilitated JAD sessions and conducted peer review meetings periodically to keep track of projects milestones.
• Identified opportunities to use customer data to develop customer strategies and improve business performance.
• Assisted the project manager in preparing the project schedules, milestone tracking, and resource allocation using MS Project.
• Developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams using MS Visio and Smart Draw.
• Managed project risk management and business process analysis reviews over the implementation of different stages of the applications.
• Assisted to develop training materials and process guide of the enhanced module.
• Collaborated with the QA team to ensure adequate testing on software, maintained quality procedures, and ensured that appropriate documentation is in place.

Confidential, Manhattan, NY

Business Analyst

Responsibilities:

• Studied and assessed the Business Processes.
• Collaborated with product and technology sponsors and LOB to evolve business requirements.
• Analyzed user problems, including automated and manual business operations.
• Performed requirement analysis and designed USE Cases and Workflows.
• Assisted in building a business analysis process model using Rational Rose and Visio.
• Designed and developed project document templates based on SDLC methodology.
• Complied system glossary commonly used terms to aid developers and users in understanding the common vocabulary.

Confidential, Edina, MN

Marketing Database (System) Analyst

Responsibilities:

• Solely responsible for planning, designing, developing, maintaining and updating Atrium Relational Databases using MS Access to meet the needs of Sales and Marketing Communication groups.
• Provided recommendations for database improvements based on an understanding of Building Information Services Marketing needs and the system’s capabilities.
• Performed research on referred companies’ strategies, opportunities and future expansions in light of internal marketing perspectives.
• Wrote various marketing campaigns, newsletter, brochures to promote and disseminate to the target client / company.
• Accurately and efficiently incorporated telemarketing campaigns.
• Received and fulfilled all direct mail potential client replies as well as keyed into the database and ensured data integrity and full accomplishment with twice as much as success rates in terms of projected client response.
• Work closely with the chain unit of market aptitude to ensure the latest trends and enhancement.
• Provided marketing administration support as assigned.