Over eight years of experience as a business system analyst specializing in gathering functional and non-functional requirements using techniques such as Activity Diagram, Data Flow Diagram, Business Contact Diagram, as well as leading JAD sessions and workshops. With strong knowledge in SDLC methodologies including Waterfall, RUP and Agile Scrum and STLC phases, I've been involved in the design of BRDs, FSDs, UI, and system use cases, Test Strategy, Test Plan, and Test Cases, using tools such as Rational RequisitePro, Quality Center, and SoapUI etc. Besides that, I am also heavily involved in system integration, identifying IEF, or EDI in healthcare domain, designing STM, and perform ETL to achieve database update/migration.

Adept at leading requirement gathering sessions such as JAD Joint Application Design , Process Workshops and one-on-one interviews with Business Users and Stakeholders.

Familiar with Project Management including change and risk management, LOE Level of Effort estimation, budget estimation, control and management.

Proficient at gathering Business and System Requirements, using techniques such as Business Contact Diagram, Activity Diagram, Data Flow Diagram, and Use Cases.

Well versed at composing Feasibility studies, GAP analysis, Impact Analysis and Requirements Traceability Matrix RTM and Data Quality Management.

Deep understanding of Agile SCRUM, RUP and Waterfall SDLC methodologies.

Designed UI User Interface , System Use Case, Data Dictionary etc. based on requirements for system design.

Comprehensive exposure to Data Warehousing, Database Migration and Data Architectures involving ETL Extract Transform Load Operations, Indexing, Data Staging, Data Marts, FACT Tables, DIM Tables, OLAP Online Analytical Processing ..

Experienced in Extract Transform Load ETL mappings, Electronic Data Interchange EDI mappings and system integration.

Data Modeling with experience in creating Star Schemas, Dimensional Tables, and Snow Flaking.

Cross-functional experience in collaborating with developers, QA Testers, System Requirement Analysts, SCRUM Masters, Product Owners and Executive Management Team.

Exceptional in creating Source to Target Mapping Document STM and integrating the data inputs/outputs from the legacy to a new system.

Experienced with SQL queries to extract data, design target tables, and test data validation.

Involved with design of Test Strategy, Test Plan, Test Scenarios and Test Cases.

Familiar with Unit Testing, Integration Testing, Functional Testing, System Testing, and UAT.

Adroit in IT Finance in large cross-functional teams and well versed in IT finance system processes.

TECHNICAL EXPERTISE

Operation System

Windows 7/XP/Vista/Mac

Software Tools

MS Project / Visio, MS Office Suite, Rational RequisitePro

Methodologies

RUP, Agile SCRUM and Waterfall

Testing Tools

Mercury Quality Center 10.0, ALM 11 version, SoapUI

Database Tools

MS SQL Server

Confidential

Business Data Analyst/Financial Consultant

Responsibilities:

Conducted GAP and process analysis to identify the potential improvements or potential issues and suggested a roadmap for solution.

Performed Feasibility and Requirement analysis.

Designed UML modeling including Activity Diagram, Data Flow Diagram to define the process and dig deep into gaps and risks.

Involved with day-to-day trading and conduct training when necessary.

Captured Business Requirements BRD and Functional Requirements FS working with Subject Matter Experts SMEs , Business Users and Stakeholders

Recognize trades and execute trade reconciliation for products such as OTC Derivatives, FX Options, Exchange traded derivatives, secured financing, commercial lending, money markets etc.

Worked with project managers to monitor and supervise the entire lifecycle of portfolio management, from pre-trade, execution to post trade and operations.

Involved in decision-making process with relevance to Swaps, Options, Futures, and Forwards and closely followed the Foreign Exchange market.

Monitored financial instruments operations including equity and derivatives to reduce risks and inefficiencies.

Advanced at using Excel to create complex spreadsheets and tables.

Wrote SQL queries utilizing Aggregate Functions, Joins, and other advanced techniques to perform a variety of CRUD functions extracting and formulating data.

Involved Unit Testing, Integration Testing, Regression, Smoke Testing, and User Acceptance UAT .

Managed Business Requirement Traceability by utilizing tools such as Traceability Trees and Traceability Matrixes with Req. Pro a Rational Suites Tool

Assisted in UAT testing training end users, preparing test cases and test data, setting up the testing environment, and logging in defects.

Experienced in Star Schema data organization dealing with Dimensions, high grain Fact Tables, Aggregate Tables, Surrogate Keys, Measures, and Slowly Changing Dimensions SCDs .

Collaborated with team members from cross-functional departments to mitigate risks.

Confidential

Business Analyst/Financial Consultant

Responsibilities:

Conducted JAD Joint Application Design/Development sessions with stakeholders to narrow down the scope and agree on system boundaries.

Adopted cost-benefit analysis to conduct feasibility study.

Held interviews and workshops to understand the integration process and gather requirements.

Designed UML modeling including Activity Diagram, Data Flow Diagram to define the integration process and gather deep requirements.

Created BRDs Business Requirement Documents and FSDs Functional Specific Documents based on business modeling.

Designed wireframe and system use cases to define interaction between actors and systems.

Documented rules for field validation and system behavior.

Helped smooth the conversion process from IFRS International Financial Reporting Standards to US GAAP Generally Accepted Accounting Principles .

Involved in Balance Sheet and Income Statements consolidation among different countries, regions, and branches.

Created Test Strategy, Test Plan, and Test Cases based on requirements and system design documents.

Created the traceability from technical specifications and requirements to test scenarios and test steps using Requisite Pro and Quality Center QC .

Identify financial KPIs Key Performance Indicators needed in dashboards.

Designed IEF and STM document in data integration ETL Extract, Transform, Load process.

Assisted in Functional Testing, Integration Testing, System Testing and UAT.

Constantly involved in review meetings and made sure the project was on the go and on the right track to meet the deadlines.

Used SQL to extract data from transactional database, and perform data integrity test, validated stored procedures and functions.

Involved in Defect review meetings with team members and developers to analyze defect and fixed the issues.

Confidential

Business System Analyst

Responsibilities:

Led JAD sessions to identify problems or desired improved areas to narrow down project scope and suggested recommended solutions.

Created vision and scope document supplemented by Feasibility Studies and Impact Analysis.

Conducted inter-departmental Requirement gathering sessions with Loan Officers, Underwriters, Business Users and external/internal clients to identify vital business process and synchronize project expectations.

Detailed UML Diagrams to document Mortgage Loan Origination process from initial contact, to appraisal, evaluation until funding with Activity diagrams, Use Case Diagrams, Data Flow Diagrams, and ER Diagrams.

Created diverse BRDs and FSDs with Functional and Non-Functional Requirement Specifications.

Translated business and technical requirements among the Loss Mitigation, Foreclosure and Loan Origination teams as well as the IT Ops team and developers.

Simplified Mortgage Loan Application UI, designed Data Dictionary and defined System Use Cases as per business rules between Origination, Credit Reporting, PMIs Private Mortgage Insurers and Real Estate Appraisals.

Created and updated IEF Information Exchange Format , STMs Source to Target Mappings , and documented key ETL mappings within the Data Source, Data Warehouse and Data Marts for seamless exchange of sensitive financial data.

Created Data Prototypes for Migration and Integration of XML Data shared by clients and partners.

Collaborated with the product owner to prioritize user stories to define Product Backlogs and manage Sprint Backlogs.

Involved in Backlog Define Meetings, Sprint Planning, Daily, End-of-Sprint-Review and Retrospective meetings to guide and monitor the project along with its development process.

Liaised with executive management to evaluate project progress Burn-down charts and harmonized timelines to manage release cycles.

Documented Test Cases derived from Functional Requirement Document FRD and Software Design Document.

Created Requirement Traceability Matrix RTM across the project by linking business requirements, functional specifications and corresponding test cases.

Confidential

Sr. Business System Analyst

Responsibilities:

Performed GAP analysis of 4010 and 5010 EDI transactions using implementation guides to identify the changes in loops, segment and data elements.

Designed UML modeling including Activity Diagram, Data Flow Diagram to define the integration process and gather deep requirements.

Addressed the issues and challenges according to GAP analysis.

Conducted Bi-directional mappings forward and backward mapping and GEMs General Equivalence Mappings

Gathered requirements regarding claim validation rules for 837.

Designed a template schedule for conversion process.

Conducted training sessions when necessary.

Created BRDs Business Requirement Documents and FSDs Functional Specific Documents based on business modeling.

Designed wireframe and system use cases to define interaction between actors and systems.

Documented rules for field validation and system behavior.

Used and verified the EDI messages 837. Healthcare encounter claim and coordination of benefits COB -Claim payment and remittance advice 835 - Healthcare claim status 276/277, Eligibility for a health plan 270/271.

Facilitated User Acceptance Testing UAT with the stakeholders and the business users, and the errors discovered were fixed and then verified via regression testing

Exposure in testing the conversion of disease codes from ICD-9 to ICD-10 format.

Elicited information to determine how the ICD -9 to ICD-10 conversion will need to be performed for written documentation process and IT systems.

Performed the impact analysis by identifying the functional business areas and supporting information technology that will be impacted by the conversion from ICD 9 to ICD 10

Conducted detailed mapping between ICD 9 to ICD 10, regarding one-to-one exact, one-to-one approximate and one-to-many approximate mappings.

Involved in design of Test Strategy, Test Plan, and Test Cases with respect to requirement documents and high level design.

Involved in functional testing, system testing, and regression testing to ensure the rules are accurately implemented.

Confidential

Business Analyst

Responsibilities:

Led JAD sessions with IT Risk, Compliance and Business Users to identify vital business process and align projects.

Conducted Cost Benefit Analysis to test feasibility.

Created Impact Analysis Documents to capture expected changes.

Detailed UML Diagrams to document Loss Mitigation workflow process from identifying high risk accounts, notifications, Loan Modifications to Short-sales with Activity diagrams, Use Case Diagrams, Data Flow Diagrams.

Drafted diverse BRDs and FSDs with cross-functional processes within the Lending domain.

Translated business and technical requirements among the Servicing, Collections and Loss Mitigation teams as well as the IT Ops team and developers.

Drafted Analytic Functions, Dimensional hierarchy, Data Relations within Data Warehouse to translate business rules into transformation logic.

Defined Document Type Definition DTD for data extraction from database using XML for transmitting financial and transactional information between banks.

Wrote and analyzed complex SQL queries to obtain KPIs used in periodic and management reporting.

Collaborated with development team to ensure all modules are prioritized, APIs and code defects are tracked and fixed.

Coordinated Loss Mitigation workflow mapping workshops to simplify User Stories into clearly defined tasks and measurable functional points and prioritized items.

Conducted Time Studies to identify bottlenecks within Loss Mitigation workflows.

Enhanced Mortgage Loss Mitigation identification feature for improved Data Sharing allowing for better coordination and quicker responsiveness.

Conducted weekly milestone meetings with business owners and developers to assess progress and direction of project.