SUMMARY

• Over 7+ years of demonstrated experience as a Business Analyst in Information technology area with solid understanding of Business and Functional Requirement gathering, Business Process Flow, Business Process Modeling and Reporting. Highly proficient in working with users and stakeholders to gather requirements analyze them and subsequently use design tools to model the requirements.
• Experience working in complex, cross functional and geographically dispersed team environments in Finance, Banking, Mortgage Industry.
• Experience in Loan and Mortgage Services.
• Experience in system life cycle (SDLC) development, involved in all phases of development from requirements gathering, business case development, maintenance, developing Requirements Traceability Matrix and defining strategic solutions for business needs
• Demonstrated expertise in client/server systems, UML methodologies for business analysis, object oriented design, database analysis and application development
• Experience developing and documentation of Sales force objects
• Experience with Enterprise Asset Management or CMMS
• Experience with Fixed income instruments and Capital Market
• Extensive experience with documenting Business Requirements document (BRD), Use Case Specifications and Functional Specifications, Systems Design Specification (SDS), Systems Requirements Specification (SRS), Workflows and Unified Modeling Language (UML) diagrams (use case, activity, sequence, data flow diagrams, process flow diagrams), testing
• Extensive experience in transforming business requirements into functional specifications; focused on workflow analysis and design, business process reengineering, user interface design and process flow modeling.
• Created Data Mapping Documents and worked with business to write transformation rules.
• Strong knowledge of SQL and extraction/ transformation/ loading (ETL) process using SQL scripts.
• Experience with Data Warehousing, Extraction, Transformation and Loading (ETL)
• Experienced in interfacing and communicating with various Cross Functional Teams through analysis, design, development and testing phases of the project.
• Experience working in iterative and agile project environments.
• Proficient in conducting Joint Requirement Planning (JRP) and Joint Application Development (JAD) sessions with end - users, development and QA team for project meetings, walkthroughs and customer interviews
• Developed test plans, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Strong Analytical and Problem solving skills, excellent planning and multi-tasking abilities, with proven experience in utilizing people and process knowledge to help enterprises make critical decisions.
• Highly motivated and able to set effective priorities to achieve immediate and long term goals to meet project deadlines..

TECHNICAL SKILLS

Tools: Rational Rose, Rational Requisite Pro, Microsoft Visio, and MySQL

Processes/Technologies: Rational Unified Process, Waterfall, Agile, Use Case, UML, Rational Rose, HP Quality Center, Rational Clear care, Requisite Pro

Operating System: Microsoft Windows 98/NT/2000/2003/XP/2007/Vista/2010 and Mac

Microsoft Office Suite: MS Visio, Microsoft Office- Project, Excel, Outlook, PowerPoint, Word, SharePoint.

PROFESSIONAL EXPERIENCE

Confidential, Dallas Texas

Sr. Business Analyst

Responsibilities:

• Interacted with stakeholders, Subject matter experts (SME’s) to product owner to get the requirements.
• Interacted with project managers, tech leads external teams and vendors to set the estimates for all the functional areas getting impacted.
• Conducted JAD sessions to gather business requirements from stakeholders, business and external users.
• Worked with the MSP Subject matter experts to gather the system and ETL mapping requirements.
• Documentation of the requirements using a customized ETL mapping doc template and standard Business requirements template.
• Followed Software Development Life Cycle using Agile Methodology for the project.
• Prepareduser stories for all the impacted functional areas and walkthroughs with the developers and stakeholders.
• Developed Requirement Traceability Matrix.
• Prepared high level scope document including the impact analysis.
• Participated in weekly status meetings with project manager, delivery manager and tech, leads to discuss and review the status of the projects.
• Responsible for preparingsource to target mapping document and reviewing it internally.
• Responsible for preparing metadata for the impacted tables and including any data type change and get the sign off from data stewards.
• Conducted bi-weekly meetings with external teams to discuss impacts, finalize time lines and share dev and test results.
• Worked as a project manager to conduct standup meeting, retrospective meeting and updated that in sprint backlog.
• Participated in daily call off shore team meetings to have transition presentation to explain every functional area.
• Worked closely with QA lead to solve testing issues while conducting system and regression testing.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data
• Analyzing raw data, drawing conclusions & developing recommendations
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services
• Worked according to the software development life cycle.
• Configuring Standby Database, Replication, DB Mirroring, DB backup and Recovery Scripts on SQL.

Confidential, Plano Texas

Sr. Business Analyst

Responsibilities:

• Interacted with stakeholders, Subject matter experts (SME’s) to product owner to get the requirements.
• Interacted with project managers, tech leads external teams and vendors to set the estimates for all the functional areas getting impacted.
• Conducted JAD sessions to gather business requirements from stakeholders, business and external users.
• Followed Software Development Life Cycle using Agile Methodology for the project.
• Prepareduser stories for all the impacted functional areas and walkthroughs with the developers and stakeholders.
• Performed credit and risk analysis on consumer credit loans for auto and recreational vehicles.
• Sourced a wide selection of client documentation from internal and external data sources in order to extract key information and validate client’sidentity and reputation in order that they meet KYC checks.
• Developed Requirement Traceability Matrix.
• Prepared high level scope document including the impact analysis.
• Participated in weekly status meetings with project manager, delivery manager and tech, leads to discuss and review the status of the projects.
• Completed the KYC review for a multimillion-dollar syndicated loan involving multiple entities and a significantly shortened client adoption time frame.
• Responsible for preparingsource to target mapping document and reviewing it internally.
• Responsible for preparing metadata for the impacted tables and including any data type change and get the sign off from data stewards.
• Conducted bi-weekly meetings with external teams to discuss impacts, finalize time lines and share dev and test results.
• Deliver project estimates and track cost using Clarity.
• Worked as a project manager to conduct standup meeting, retrospective meeting and updated that in sprint backlog.
• Ensuring that SharePoint acts as a ‘hub’ for all related business activities
• Worked closely with QA lead to solve testing issues while conducting system and regression testing.
• Prepared UAT test scripts and shared among the stake holders for review.
• Worked closely with QA lead and data stewards to conduct UAT testing.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, and observing from account managers and User Interface (UI) of the existing Broker Portal system.
• Developed Requirement Traceability Matrix
• Understood and articulated business requirements from user interviews and then translate requirements into functional and technical specifications.
• Interacted with fixed income business heads to finalize the Business Requirements for the Risk Management process.
• Develop sound PLM solutions to address customer objectives.
• Product Lifecycle Management (PLM) systems consultant responsible for identifying business solutions and resolving technical issues of internal customers amongst geographically distributed locations.
• Interacted with Subject Matter Experts (SMEs) of different divisions (Information Technology, Risk and Operations) and established a business analysis and design methodology around the RUP (Rational Unified Process).
• Analyzed the existing system and process gaps in context of new business changes (Gap Analysis).
• Prepared High Level Logical Data Models and BRD supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Designed Use Cases, Use Case diagrams, Class diagrams, Activity diagrams, Sequence diagrams in Unified Modeling Language (UML) methodology using Rational Rose.
• Involved in Joint Application Development (JAD) sessions with the IT Group.
• Worked closely with the UI team to model the screens, which met user defined requirements, organizational and regulatory standards.
• Held group meetings, walkthroughs and supervised/trained other analysts.
• Developed and maintained relationships with clients on all on-going projects.
• Responsible for the completion of projects within specified time and budget dealing with financials, project work flow, change management and dealing with vendor relationships.
• Performed System and Integration Testing along with testers. Conducted User Acceptance testing with the business.
• Leverage various available databases (e.g. Thomson Research, Thomson One Banker, Factiva, Bloomberg, D&B Marketplace) to extract specific information required for the project.
• Assisted with Test Cases and developed strategies with Quality Assurance group to implement them. Efficiently responded to client inquiries and resolved discrepancies.
• Identified, prioritized, tested and proved essential business functions to assure compliance with vendor and internal auditing
• Collaborated with Quality Assurance Analyst in Rational Clear Quest to track defects and used Rational Clear Case to maintain consistency in the builds

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Identify the key business Metrics.
• Meet regularly with key business personnel and IS analysts to determine business needs and to document requirements.
• Gathered details on the business process, technical architecture, software systems and servers employed in the client location.
• Understood fixed income, equities & derivatives trading cycles, securities clearance and settlement process.
• Conducted market analysis and feasibility studies, and developed the project plan.
• Organized and scheduled user interviews, user meetings, group meetings, and JAD sessions.
• Performed a detail research on their existing financial transaction processing and reporting methodologies.
• Collected, analyzed and documented user requirements and created business requirements document and functional specification documents.
• Model and review all current operational data structures and recommend optimizations and reconfigurations to Data Architects for implementation.
• Define best practices, policies and procedures regarding Metadata Management, Data Profiling, Data quality, data storage and archiving, disaster recovery, security and data dictionary metadata standards.
• Participate in the development and maintenance of, and adherence to, corporate data architecture, data management standards and conventions, data dictionaries and data element naming standards.
• Provide leadership and guidance for database architecture design and strategy to ensure quality deliverables across the entire IS organization.
• Document detailed functional and technical specifications based on agreed solutions.
• Support development of the business solution as part of the technical team.
• Work with DBA to support migration of applications from Development to Test to Production
• Gather market data and conduct data analysis.
• Recommend and evaluate new tools and methodologies.
• Work with management to identify issues and risks that may have an effect on quality or delivery from a technical, business and end-user perspective.
• Evaluate and estimate the work effort required to meet a desired deliverable.
• Provide status reporting on work assignments and alert IS management to deviations from plan.
• Ensure completed work meets with all IS best practices and policies.
• Perform administration, maintenance and configuration changes to existing applications where appropriate and be willing to support mission critical 24x7 applications.
• Interact with account management, project management, and clients as appropriate both locally and globally.
• Developed database standards for global deployment security and business recovery
• Provided performance guidelines and analyzed database metrics for Web Applications

Confidential

Business Analyst

Responsibilities:

• Analyze business requirements and turned them into high level and low level Use Cases, Created activity and Sequence diagram using Rational Rose following UML methodology.
• Interacted with the SME’s and stakeholders to get a better understanding of client business processes and gather business requirements.
• Worked closely with project manager in handling whole project.
• Designed and developed Quality Assurance standard and processes to all levels of project team.
• Reviewed Test plans, Test cases, Test case execution using specification documents and Rational Test Manager.
• Interacted with the SME’s and stakeholders to get a better understanding of client business processes and gather business requirements.
• Ensure compliance with economic and trade sanctions enforced by OFAC and the US Patriot Act.
• Supported in developing controls and procedures relating to transaction monitoring.
• Conducted monitoring of AML exception reports.
• Reviewed accounts for completeness according to AML/KYC policies
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specification.
• Performed Smoke Testing to ensure that the compiled software components of the Applications follow Project Standards, Performance Criteria and Functional specifications to ensure feasibility of testing effort.
• Conducted highly interactive JAD sessions with project’s stakeholders such as users, QA analysts, and project management team, identifying and resolving issues.
• Examined, analyzed and model Test plan, Use Case Model cases & Test procedures based on RUP methodology.
• Selected to be a part of the Pilot Batch which involved migration of SWIFT processing from Bournemouth UK to India.
• In charge of the Learning and Development Council for Global Cash Core Operation Department in Confidential .
• Trained in processing and verification of Electronic fund transfer involving various Asian Currencies like Japanese Yen through Fed wire, CHIPS, CHAPS etc.
• Appointed as a supervisor for a migration project of new markets: Beijing, Tianjin, Vietnam, Philippines and Thailand.
• Supervised a team of 5 interns in analyzing over 500 client accounts which led to a new process for compliance data documentation and to a 10% improvement in account compliance.