SUMMARY

• More than 7 years of experience as a Business Data Analyst with strong understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Business Analysis and Business Analyst/Tester in business data modeling, software requirement analysis, process modeling, process flow and quality assurance skills using different methodologies, mainly UML.
• Experience in the Finance Industry, Banking Industry, Mortgage, Asset Management, etc.
• Experience in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions to converge early towards a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
• Worked on Data Quality measures by analyzing, profiling, cleansing and standardizing data across the Platform.
• Extensive experience withBusiness Process Management (BPM).
• Expertise in Software Development Life Cycle (SDLC), Use Cases, Business Process Modeling Notation (BPMN), Object - oriented Analysis and Design, Rational Unified Process (RUP) and Rational tools used during all four phases of RUP: Inception, Elaboration, Construction, and Transition.
• Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardizations.
• Experience in test execution - Integration, Functional, System, Regression, Compatible testing and Database Testing using SQL and User Acceptance Testing (UAT)
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Extensive experience working in back-end tester by writing SQL Queries.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Diverse experience in Banking and Financial Services. Solid experience in Mobile Banking implementations
• Expertise in Performance Management, Asset Management, Cash Management, Portfolio Management, Credit Management, Client Reporting and implementing its benefits.
• Experience in Object Oriented Analysis of business requirements, Program Management Office PMO, application system design and Business Process management BPM
• Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000.
• Have good understanding with entire phases of Software Development Life Cycle SDLC .
• Full understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT).
• Experience in Scrum Process and thorough understanding of Extreme Programming (XP), Agile Software Development Methodology and Object-Oriented Analysis (OOA).
• Experience in managing and approving requirement in Enterprise Portfolio Management tools (EPM)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Business Technical Analyst

Responsibilities:

• Maintains the Detailed Specifications defining the scope of the functions to be implemented by the middle-tier applications owned by APS
• These specifications serve multiple audiences: developers for coding direction; testing teams to build test cases; and Client-application developers for understanding the behavior and interface of the middle-tier functions.
• Conducts document review meetings with each audience to ensure that the service specifications are accurate and clear.
• Develops knowledge of the functions supported by the middle-tier by becoming familiar with the groups published service specifications.
• Walks through the specifications with new Client applications intending to reuse functions already implemented in the middle-tier.
• Attends meetings with other technical analysts and business sponsors to help gather and refine Business Requirements for new projects.
• With the help of other senior analysts evaluates and recommends solutions based on their cost effectiveness, maintainability, and future opportunities for reuse.
• Creates Functional System Design documents (FSD) identifying the impact to the components of the middle-tier application for each project.
• Conducts document review meetings with business sponsor and other affected applications to ensure common understanding of the scope of changes to the middle-tier required for the project.
• Works on multiple concurrent projects in various stages of the development lifecycle and across different business processes.
• In Agile projects, participates in User-Story grooming and sprints to frame the changes in the business-service application, and creates/updates the technical specs for them. strong understanding of the tool architecture and data
• Experience with reusable business services (WSDL and XML schemas, or JSON/RESTful services) -Analyzing financial industry business processes.
• Performed Data mapping, logical data modeling, created class diagrams and Entity Relationship (ER) diagrams and used SQL queries to filter data
• Writing complex technical specifications detailing data transformations, business rules and flow of control
• Design distributed systems including defining interfaces between applications
• Experience with both Waterfall SDLC and Agile/Scrum practices
• Experience with production Matric report to analysis production data

Confidential, Monterey Park, CA

Business Data Analyst

Responsibilities:

• Brain storming with client on the Business Requirement Document (BRD), and convert BRDs into FRDs
• Followed Agile methodology.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both businesspeople and technical people.
• Researched on Best Industry Practices and explained the Business Users of the benefits and costs associated in implementing the same.
• Extensive experience with Data Warehouse/ETL testing by using SQL scripts. Areas of testing included cardinality (number of rows) and data Transformation (Business rules) testing.
• Involved in Production Support and troubleshooting data quality and integrity issues.
• Experience in using, collecting, modifying, and maintaining report on a SharePoint.
• Studiedcarefully all of the organization's policies and procedures relating to loans.
• Performed Data mapping, logical data modeling, created class diagrams and Entity Relationship (ER) diagrams and used SQL queries to filter data.
• Performed End-to-End account validation using Excel Matrices and generating an output to validate with the data warehouse provided result.
• Responsible for working on Front end and Landing Data Control measures.
• Experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts.
• Ensuring the Data Quality Dashboard performs reporting on the status of the Data Quality Process across the platform.
• Participated in design walk-through with Subject Matter Experts (SME’s) to baseline the business architecture.
• Assisted the team members to develop Service Oriented Architecture (SOA), and data warehouse system (EDW) to utilize data mining for data analysis.
• Used MS Visio/Enterprise Architect to carry out business modeling and created use cases, use case diagrams, and activity diagrams.
• Providing review to Test Cases and Test Files generated by QA team.
• Interacted constantly with the Business Users and Project Manager to keep them current with the latest updates.
• Converted business requirements into System Requirement Specifications.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds using Informatica PowerMart, PL/SQL.
• Responsible for creating user stories and use cases and upload them to Quality Center (QC).
• Involved in requirement scoping and analyzing high priority requirements for implementation.
• Supported the QA manager in creating various testing scenarios for integration and system testing.
• Managed the Metadata associated with ETL processes used to populate the data warehouse.
• Involved in Production Support and troubleshooting data quality and integrity issues.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams.
• Supported the QA team while conducting Unit and Functional Testing.
• Assisted the Business Users at the time of Application testing and User Acceptance Testing.

Confidential, Richardson, TX

Business Analyst

Responsibilities:

• Interactedwithloan officers to finalize theBusinessRequirements for the application.
• Researched and analyzed IT best practices and strategies (CMM, ISO, IEEE, and FDA Regulations) and established and managed a common SDLC process for all regulated systems development/procurement.
• Created functional & technical specifications for an in-house front office trading application whose main products were related to ABS (Asset Backed Securities), CDO (Collateralized debt obligations) and Whole Loan Mortgages.
• Conducted JAD sessions with the stakeholders, end users and SME, to determine the critical business processes and identify key functional requirements for Loan Serv system adhering to the Mortgage Servicing Industry practices and FDIC guidelines.
• Designed and implemented SQL queries for QA testing and report / data validation.
• Tested the final application for usability testing (UAT) to verify whether all the user requirements were catered to, by the application.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Designed Use-Case Models after understanding scope of the project and thebusinessmodel.
• Worked with the Mortgage Business Applications including Loan Origination System, Loan Processing System.
• Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data.
• Used the BPMN to GAP Analysis to bridge the gap between business processes.
• Conducted both need and GAP analysis and resource allocation studies to determine most effective use of design, architecture and review.
• Used SAS as an ETL tool to load data from flat files and databases into SQL Server and Teradata environments.
• Creation of reports and dashboard objects for presentation at executive levels
• Involved in setting up dimensions based on business rules for maintaining the data quality based on various measures like Accuracy, Uniqueness, Completeness and Consistency.
• Conducted Agile refinement sessions for requirements and stories with the business and change management teams.
• Developing strategic partnershipswiththebusinessunit to develop a solid knowledge base of thebusinessline, including thebusinessplan, products,and process and revenue streams.
• Responsible for creating a business process and workflow documentation using BPMN standards.
• Designed and developed Use Cases and UML models using Microsoft Visio/Enterprise Architect.
• Defined requirements for all workflow activities including analysis, design, testing, and implementation formortgage lendingandloan origination systems.
• Followed Business Process Modeling Notation (BPMN) specifications to ensure that businesses will understand themselves and participants in their business and also to help enable organizations to adjust to new internal and B2B business circumstances.
• Extensively worked on MS Access, MS Excel, MS Word, PowerPoint, SQL, MS Project.
• Analyze business requirements,businessprocess and system architecture/design.
• Translatedbusinessrequirements into Design Document for functional coding.
• Responsible for defining, documenting and publishing Functional Specifications and BRD-Business Requirements Documents.
• Validated the various business processes with a committee of Subject Matter Experts (SME's) like Mortgage Servicers, Underwriters, Credit Analyst etc, to ensure the rules and guidelines have been met.
• Performed Business process modeling Notation BPMN to improve process efficiency and quality.
• Assisting QA manger with Release notes, status reports, Prioritizing test coverage on daily basis of multiple Appian applications through re-engineered projects and defect tracking.
• Experience in creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
• Monitored client expectations through client involvement and communicationthroughout the lifecycle of the project, educate clients, stakeholders and end users on the benefits and risks associatedwiththe project.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Assisted in development of training materials for new technology and process improvements.

Confidential, Fort Worth, TX

Business Analyst

Responsibilities:

• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Facilitated JAD sessions with the clients and assessed the facts of the discussion to not only gain an understanding of the issues but drive to a solution.
• Make sure that ETL application appropriately rejects, replaces with default values and reports invalid data.
• Involved in setting up data quality and control strategies to prevent errors from entering a dataset and identifying those errors if they are present in the data
• Assessed risks in trading application and worked with teams to reduce risk implications.
• Acted as liaison between business and technical staff at all levels.
• Involved in writing complex SQL queries to extract the data from Oracle database
• Conduct JAD (Joint application development) sessions on Business Requirement Document and Functional Specification Documents with IT Directors, Project Managers, Business Analysts, and Development Team.
• Made sure the business requirements are met in cost effective manner. Regarding the same performed budgeting and valuation analysis to gauge the project efficiency.
• Coordinate demo workshops to Business Managers, Business Users and demonstrated the entire functionality of the product.
• Conduct requirement analysis and gap analysis.
• Responsible for validating the financial effectiveness of the whole project team. For the same performed budgeting and expense and cost analysis. Also, laid down the forecasted benchmarks to gauge the project effectiveness.
• Assisted in SOX compliance testing. For the same analyze the requirements and gather evidence.
• Involved in Data Analysis, Data Modeling and Logical Data Specification.
• Perform Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and conducted document analysis.
• Responsible for creating Business Requirement Document (BRD), Functional Specifications Document (FRD) and involved extensively in use case analysis using the UML tool MS-Visio/Enterprise Architect.
• Involved in creating and running UAT test cases and test scripts. Also, generated reports for UAT test cases.
• Job responsibilities include but not limited to Client interaction, managing artifacts, problem resolution, escalating issues, manage testing, prioritize projects, gather estimates for time and cost, deal with ongoing challenges etc.
• Involved in identifying the existing business processes by interacting with subject matter experts. The SME's involved are complex processors, financial processors and non-financial processors.
• Define project scope, business requirements, use-cases, and functional specifications.
• Identifying, researching and analyzing problems and developing alternative solutions to resolve underlying operational issues.