SUMMARY

• 9+ years of experience as a Business Analyst/Business System Analyst in industry domains including Mortgage, Financial, Brokerage Accounts, Healthcare, Insurance, Retail Banking, e - Commerce, and Supply Chain.
• Strong understanding of Online Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations.
• Knowledge of Anti Money Laundering (AML), Bank Secrecy Act (BSA), Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act. Working noledge and understanding of Suspicious Activity Reporting (SAR),and OFAC reports.
• Experienced in ServiceNow ITSM, Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications. Experienced in creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.
• Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using ER/Studio.
• Strong Data Quality Management background performing analysis, monitoring and tuning to maintain data integrity.
• Experience in creating database tables, writing stored triggers, select statements, joins, views.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge of Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income, and Title functionalities
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Extensive experience in project management best practices, processes, & methodologies including Waterfall, Agile, SCRUM, and Rational Unified Process (RUP).
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per teh Software Development Life Cycle.
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gatheird Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Analysis and review of Software and Business Requirement Documents (BRD).
• Conducting requirement gathering sessions, feasibility studies and organizing teh software requirements in a structured way.
• Gathering business and Technical requirements dat would best suit teh needs of teh technical architectural development process.
• Team lead skills encompassing user interviews, coordination with Tech Lead, DBA's, Developers, QA/QC Analysts during teh design phase.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording teh requirements in a format dat can be reviewed and understood by both business and technical people.
• Having application testing experience with working noledge of automatic testing tools like Mercury Quick test Professional and Load Runner.
• Experience with re-engineering, implementation and Data Governance projects.
• Worked in various technologies such as XSLT, XPATH, CSS, XML, and HTML.
• Well versed in Process Narratives, Flow charting Techniques using UML, and Good Documentation Practices. Prepared documents to conduct user acceptance testing. Good working experience in all teh sprints of teh project in SCRUM.
• Strong SQL noledge for querying teh database and proficient in developing External Tables, Joins, Indexes, Data Modeling, Analysis, Verification, Cleansing, Transformation, Integration, Mapping, Extraction, Load Process from multiple Data Sources.
• Proficient in executing Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, Positive-Negative, and Regression testing.
• Experience in writing User manual, conducting functional walkthroughs, and in performing extensive User Acceptance Testing (UAT).

TECHNICAL SKILLSET

Web Technologies: HTML, DHTML, XML, CSS, XSLT, JavaScript

Software Applications: MS Office, MS Project, MS Visio, MS FrontPage, Dreamweaver, Adobe PhotoShop

SDLC Methodologies: Waterfall, RUP (Rational Unified Process), AGILE (Scrum)

Requirements Management: Rational ClearCase, Requisite Pro, Use Cases, User Stories

QA/Testing: Rational Clear Quest, Team Foundation Server, HP Quality Center 11, QTP, LoadRunner

Project Management: MS Project (PERT, Gantt charts), Excel spread sheets

Operating System: Windows 95 & 2007, NT/2000/XP, LINUX, UNIX, DOS

Design Tools: Rational Rose, MS Visio (UML)

Database/Tools: Microsoft SQL Server, Oracle 10g & 11g, PeopleSoft, TOAD, Lotus Notes, MS Access, NORKOM

BI/ETL Tools Informatica: PowerCenter 9.1, IBM Cognos 10.2, IBM SPSS

Change Management: Stakeholder Analysis, Change Classification, Prioritization, & Implementation IT Service Management ServiceNow ITSM Suite

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Business System Analyst

Responsibilities:

• Gatheird high-level requirement for all teh external projects in a release.
• Conducted Gap Analysis by creating Swim lane diagrams and highlighted teh differences between teh Current (AS IS) environments versus teh Target (TO BE) environment.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML..
• Extensively involved in teh modelling and development of Reporting Data Warehousing System.
• 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.
• Created functional requirement documents for teh impacting projects dat were agreed upon to be implemented in teh current release
• Responsible for teh requirements / ETL Analysis, ETL Testing and designing of teh flow and teh logic for teh Data warehouse project.
• Reviewed teh data model and reporting requirements for Cognos Reports with teh Data warehouse/ETL and Reporting team.
• Involved in designing and developing Data Models and Data Marts dat support teh Business Intelligence Data Warehouse.
• Participated in establishing a Data Governance structure, creating documentation templates, business process diagrams, RACI matrix and other job aids.
• Refined and introduced a Data Governance Maturity Model and scorecards for an enterprise data governance initiative.
• Managed teh development of change management process for enterprise data, working with system owners and data stewards to document existing change control processes and define new processes as needed.
• Created and implemented documentation templates to captured data related issues, change control processes, and business process improvements.
• Managed teh implementation and oversee teh maintenance of an enterprise data dictionary and provided education for management and usage to internal teams.
• Conducted needs analysis sessions using proven elicitation techniques, such as requirements workshops, brainstorming, reverse engineering, and cross system workflow discovery sessions.
• Mentored and educated teh data governance initiative participants including data stewards and data governance working groups.
• Analyzed, researched and wrote 100+ Business Requirement Documents for web and proprietary system.
• Evaluated data integrity and oversaw data migration.
• Established monthly, quarterly, and annual metrics for teh data governance initiative tracking issues, change control processes, and data governance activities.
• Extensively worked in designing teh Testing approach for teh ETL process in teh Credit Data Provisioning Enterprise Data Warehouse (CDP).
• Creation of teh data mart from existing Operational data Store and other sources.
• Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos.
• Implemented business modeling, data modeling, and object modeling using MS Visio to develop teh business architecture for teh application. Created reports using formulas such as Vlookup, goal seek and pivot tables.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all teh impacting projects and updated teh documents based on recommendations (if any).
• Created UAT plans with several test cases for each project to ensure dat teh system runs smoothly after teh proposed enhancements or changes have been made.
• Reviewed test results and coordinated with testing and development team to correct teh issues.
• Developed timelines for project delivery, and managed projects/resources

Environment: Microsoft Office Suite, Microsoft Visio, Unix, IBM Cognos 10.2, IBM SPSS, TestDirector, LoadRunner

Confidential, San Francisco, CA

Business System Analyst

Responsibilities:

• Gatheird requirements from teh business and technical end to develop teh mainframe and teh web portal backend.
• Participated in Sprint Planning sessions to transition user stories over to developers.
• Used user stories approach for describing teh requirements using teh user story template.
• Create, review and detail User stories for enhancements on various ITIL process areas.
• Worked closely with business users to prioritize and scope out teh Product Backlog Items (PBI) based on priority and bandwidth.
• Actively participated during teh Production releases of teh web portal and provided go-live support during Production deployments.
• Lead and participated in multiple ongoing project meetings using iterative and Agile project methodologies.
• Conducted JAD sessions with management, SME, vendors and other stakeholders for open, pending and critical issues. Sessionsfocusing on IT strategies.
• Problem solving skills and building a liaison between business and technical ends of teh project.
• Researched in determining teh reporting tool, and teh allocation of direct access to backend tables for real-time Ad hoc Reporting and analysis.
• Managed procedures for teh submission, review and authorization of Change Requests.
• Developed teh KPIs design and run global “ITSM monthly Performance metrics report” with scheduled reports in ServiceNow and compare with IT Services Scorecard to meet strategic goals.
• Played a major role in documenting functional and technical specifications.
• Performed meetings and discussions to implement technology concepts.
• Created and managed project templates, use case project templates, requirement types and traceability relationships.
• Performed document management using Microsoft Sharepoint.
• Developing Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Designed SQL queries for Backend Testing based on teh specifications.
• Prepared Test Reports and submitted teh Bug Findings to teh Bug Tracking system using Quality Center and its modules (Requirements, Test Plan, Test lab and Defects).
• Performed Functionality, Integration, GUI, Regression, Usability and System testing.
• Performed testing and developed usage manual for Quick Test Professional (QTP).
• Tested teh Applications compatibility on different browser versions of IE, Firefox and Safari.
• Involved in creating a detailed SystemTest Plans, Test Cases and Test Scripts for different modules in teh Application according to teh Business Requirement Documentation.

Environment: MS Office Professional, Agile Methodology, ServiceNow, Sharepoint, MS Project, MS Visio, ASP.Net MVC 4, IIS7, SQL Server 2012, Rational Requisite Pro, Rational Rose, Rational Robot, Quick Test Pro, Test Director.

Confidential, Dallas, TX

Business System Analyst

Responsibilities:

• Participated in Daily Standups with teh Project Manager, Development Team, QA Team and other Business Analysts.
• Accurately and efficiently translated business requirements to high level and atomic level specifications.
• Developed and presented conceptual and functional models along with cross-functional process and system dependencies.
• Participated and conducted iteration kick-off meetings to develop a backlog to adequately meet teh team's bandwidth.
• Wrote User Stories to identify business requirements and capture user experience.
• Created Product Backlog Items and prioritized them to halp define teh scope for each iteration.
• Demonstrated teh configurability and functionality of new Item Types to cross functional teams and product owners.
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure with teh new business requirements.
• Created schema objects like Indexes, Views and Sequences.
• Involved in dimensional modeling of teh data warehouse to design teh business process.
• Designed Logical data model and Physical Conceptual data model using ER/studio Data Architect.
• Created teh ETL data mapping documents between source systems and teh target data warehouse.
• Worked with teh OLTP database to generate teh DDL.
• Performed 1st, 2nd, 3rd Normal form.
• Data mapping using Business Rules and data transformation logic for ETL purposes.
• Designed star schemas and bridge tables to control slowly changing dimensions (SCD).
• Developed ER and Dimensional Models using ER/studio Data Architect advanced features.
• Involved in teh process design documentation of teh Data Warehouse Dimensional Upgrades.Worked with Claims data, member's data and provider's data.
• Worked with PPOs and HMO care Plans.
• Extensive use of SQL for accessing and manipulating database systems and Profiling.
• Maintained a close and strong working relationship with team mates and management staff to achieve expected results for teh project team.
• Worked Closely with Developers and Testers.
• Assisted in teh design of report layouts to maximize usability and business relevance.

Environment: ER/Studio, Informatica 9.1, Oracle 9i/ 10g, PL/SQL, Toad, IBM Rational clear quest, Clear case, Cute PDF.

Confidential, Fort Washington, PA

Business System Analyst

Responsibilities

• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
• Conducted interviews with key business users to collect requirement and business process information for teh loan process including set-up Account Information, New Loan set-up, Escrow Analysis, teh Appraisal, Credit, income and Title functionalities.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured dat critical requirements are not missed.
• Conducted Functional requirement specification and User requirement specification reviews and walkthroughs with teh designers, developers and stakeholders.
• Worked and discussed teh changes with change management to get approvals for teh scheduled release.
• Served as a technical point-of-contact and assists subject matter experts in developing Loan Originations System.
• Triage requests and troubleshoot issues; report defects/bugs for development teams.
• Wrote Technical/Functional specifications documenting all LOS configurations and modifications.
• Uploaded Technical and Functional requirements and tan traced them with their Business requirements provided by teh Business.
• Workeded closely with Business, QA, and Developers to design LOS functionality dat meets teh needs of teh Business.
• Followed up with queries and questions regarding defects dat had been logged to ensure their respective solution is in place moving forward in teh project.
• Developed strong working relationships with risk and technology stakeholders to deliver new LOS functionality.
• Involved in performing User acceptance testing (UAT).
• Worked with Quality Assurance team to review teh test scripts against teh functional specification and halped them create scenarios which would test teh system end to end.
• Worked closely with teh data model team to review teh data model and validate them.

Environment: Rational Requisite Pro, Rational Rose, Clear Quest, Clear-Case, Java, MS-Project, MS-Visio, MS-Office, UML

Confidential, Detroit, MI

Business Analyst (AML/KYC)

Responsibilities:

• Gatheird, analyzed, refined, and interpreted business requirements Business and converted them into functional requirement specifications.
• Documented business rules, understood teh business need, added new Customer experience features (Update Content for Enrollment, Add Payees) and provided Screen Layout Specifications for teh SRS document.
• Selected teh appropriate elicitation technique to efficiently identify critical requirements and prioritized requirements by conducting brainstorming sessions with teh back office portfolio management and sign offs on requirement artifacts from project managers.
• Determined teh level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks.
• Coordinated and conducted meeting sessions with teh business users, captured teh equity derivatives requirements and gained an understanding of teh business rules & constraints.
• Analyzed trading/sales and Credit risk requirements according to FDIC and FSA standards and identified functional and non-functional requirements.
• Worked extensively on NORKOM, teh enhanced Anti - Money Laundering (AML) analysis and risk detection/management system, which enables to fight crime and create reports on teh flagged transactions.
• Successfully conducted (JAD) Joint Application Development sessions with cross-functional team members for discussing various shared issues to ensure dat teh business objectives are met with and requirements are understood clearly at all levels.
• Investigated breaks in teh reconciliation reports concerning trade population, MTM, and Counterparty data.
• Prepared requirement traceability matrices and managed all components of teh business requirements & UAT testing phase of teh development lifecycle.
• Maintained current, detailed noledge of anti-money laundering and anti-terrorist financing matters.
• Utilized in-depth understanding of BSA/AML and OFAC regulatory requirements and best practices to guide decision making in execution of enterprise-wide AML objectives.
• Developed and maintained a high level of expertise in BSA, OFAC, USA PATRIOT Act and related regulations, directives and guidance.
• Identified possible enhancements to AML monitoring tools and processes and communicate them to teh Financial Intelligence Manager.
• Properly reviewed teh file from teh AML/Compliance folder ensuring all documents are available and meet teh Financial Institutions standards.
• Developed SQL Scripts for teh Online Editing Application for teh Client interface.
• Retrieved and analyzed data using T-SQL, Excel, SSRS.
• Facilitated group meetings, one-on-one interviews, and correspondence through emails to manage change control process and to discuss teh impact of change request on teh project.
• Initiated and exercised various strategies involved in website Usability, Functionality, and Compatibility testing.
• Closely interacted with developers and System Architect to understand customer site navigational flow, to identify bottlenecks, enhance site navigation, and increase customer satisfaction.
• Created Test Plan document, test cases, test scripts and expected results for UAT.

Environment: RUPSDLC, Risk Management, Enterprise System, Core Banking, NORKOM, MS Project, MS Access, Dreamweaver, Mobile Application, MySQL database, IBM Requisite Pro.

Confidential - Bloomington IL

Business System Analyst

Responsibilities:

• Worked on multiple releases for State Farm mobile app across multiple platforms (iOS, Android).
• Strong noledge of design standards for Responsive web and native applications.
• Primary Liaison between Business, Systems and other LOBs (Auto, Fire, Claims & Bank).
• Responsible for interacting with vendors for getting latest SDK's and internal co-ordination between front end, back ends and native mobile team.
• Responsible for Mobile Device Management (MDM) for teh team, regularly updating mobile devices for security patches and worked closely with teh mobility hardware team to ensure secured devices are available for app testing.
• Worked with teh User Interface (UI) Project Team, and coordinated with enterprise architects to ensure project deliverables
• meet teh requirements and are delivered in a timely manner and adhere to Mobile/Digital Standards and project
• schedules.
• Provided desired mobile experience and insights to influence teh overall customer experience. Serves as first point of contact to User Interface Team and Direct UI project-level decision making.
• Worked closely with teh User Experience Designer to ensure accuracy of usability test plan content and execution.

Environment: MS Project, MS Visio, SharePoint, MS Excel, Rational Rose, RUP, UML, iOS, Android, Rational Requisite Pro

Confidential

Jr. Business System Analyst

Responsibilities:

• Involved in interviewing business area experts, asking detailed questions and carefully recording teh requirements in teh format so dat it can be reviewed and understood by both business and technical people.
• Gatheird user and business requirements through interviews, surveys, prototyping and observing from account managers and User Interface of teh existing system.
• Worked as a liaison between technology and teh business clients to improve business processes and support critical business strategies.
• Determined user/business/functional requirements. Created UML diagrams including Use Case diagrams, Activity Diagrams using MS Visio and Rational Rose.
• Used brainstorming and ideation techniques to derive ideas from teh stakeholders.
• Gatheird requirements by using interviews, observation, JAD, brainstorming sessions, and documents analysis.
• Collected Business Requirements and converted them into Systems Requirement specifications.
• Developed non-functional requirements and documented them as Business Rules, Quality attributes, constraints documents.
• Produced Mockups and Wireframes after interacting with SME's using Axure.
• Utilized RUP to configure and develop process, standards, and procedures.
• Validated technical designs created by IT developers against functional specifications.

Environments: Rational Unified Process (RUP), HTML, Java Script, Java, Axure, UML, Rational Rose, Mercury Test Director and MS Office Tools.