SUMMARY

• 8+ years of professional experience in the Analysis, Design, Development, Implementation, Testing of Client/Server and Web Applications.
• Experienced in writing System test plans, defining test cases, developing and maintaining test scripts.
• Strong knowledge of the Systems Development Life Cycle (SDLC).
• Highly analytical in developing the methods and measures to meet requirements and solve any issues that arise during the project.
• Acute understanding of concepts related to Consumer Lending, Consumer/Business Credit Cards and Consumer loans.
• Thorough understanding of Software Development Life Cycle (SDLC) principles using methodologies such as Waterfall, Agile, Scrum and Rational Unified Process (RUP).
• Gather requirements for Usability testing and UI evaluation for mobile app and done analysis and design of mobile application UI’s based on client requests
• Business Analyst in requirements gathering and development, with experience in Retail Banking, Mortgage, supporting Risk and Compliance, Front office, Middle office and back - office operations
• Excessive use of documentation to avoid any form of miscommunication or misinterpretation during the entire software development process. Prepared Systems Proposal Reports and Business Plans.
• Designed Use Cases, Activity Diagrams, and Sequence Diagrams, Class Diagrams, and Data flow diagrams.
• Analyzed the business requirements and developed use cases for various Scenarios and developed Use Case diagrams using MS Visio
• Extensive experience in creating documents such as Scope documents, Business Requirement Documents, Functional Specification documents, mock-ups of exception reports, and Risk Assessments.
• Thoroughly worked with MS Office, MS Project Professional, and MS Visio on various projects
• Experienced in customer / client interaction, deep understanding of business systems functionality and technicality.
• Involved in maintaining Test Matrix and Traceability Matrix and performing GAP analysis.
• Proficient in Excel Vlookup and MS word.
• Experienced in designing databases tables and normalizing tables.
• Conducted User Acceptance Testing (UAT).
• Used Quality Center and Rational Clear Quest for error reporting
• Experienced in writing SQL queries to generate reports, including using sub-queries, join, and aggregate functions.
• Motivated self-starter with exceptional team building, leadership, and interpersonal skills.
• Good team player with the ability to work in time sensitive environments.
• Possess excellent communication and interpersonal skills with the ability to adapt to a new environment.
• Excellent analytical and problem solving skills with the ability to handle multiple tasks effectively and quickly master new concepts and subjects.

TECHNICAL SKILLS

Project Methodologies: Rational Unified Process (RUP), UML, Agile

Business Modeling Tools: Rational Rose, MS Visio

Requirement Management Tools: DOORS, Rational Requisite Pro

Defect Tracking Tools: Rational ClearQuest, Test Director

Operating Systems: Windows XP/Vista/7, UNIX

Databases: SQL Server, MS Access

Quality Assurance: Software Application Testing Life Cycle

Business Applications: Microsoft Office Suite- MS Word, ExcelOutlook, PowerPointDesign Tools & Languages Microsoft Visio, C, C++, HTML

Mobile Platform: iOS, Android OS, Windows Mobile

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. Business System Analyst

Responsibilities:

• Created scope documents, business process mappings via tools like Balsamiq and MS Visio, ProVision to map the current and projected process of ATM usage.
• Created business documentation to support action plans, which were shared with stakeholder teams.
• Created and updated reporting for SEC and OCC regarding liquidity within retail banking, to show cash reserves maintained and internal controls followed.
• Performed GAP and Risk analysis of existing system and evaluating benefits of new system.
• Conducted functional requirement reviews and walkthrough with the Integration experts and stakeholders.
• Wrote SQL commands and procedures, to check for newly provisioned Mortgage and credit data for consistency and updated invalid fields with proper value.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables.
• Created and Maintained test case and test script documents from user stories in Agile/ Scrum environment
• Designed and implemented SQL queries for QA testing and report / data validation including joins, aggregate functions to bring together data from various tables, for reporting purposes
• Utilized data mining techniques to find meaningful relationships between data, using SQL queries.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Worked with Jira tickets for work-flow and to log the defects.
• Test mobile applications to find and report bugs, check accessibility, legal requirements, and installation.
• Initiated the Agile Scrum methodology for the project execution.
• Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data.
• Extensively worked on MS Access, MS Excel, MS Word, PowerPoint, SQL, MS Project
• Created UML diagrams like Use Case Diagrams, Activity Diagram using MS-Visio for various stakeholders.
• Utilized defect tracking tool JIRA for reporting bugs/defects in functionality. Conducted weekly status meeting with development teams for defect resolution. Utilized SQL for querying database tables during testing.
• Created Intelligence reports and Pivot tables using Excel Macros for management and leadership to facilitate decision making and help allocation of resources.
• Tested the UI of the end product on mobile, PC, tablets, Android and Apple platforms to ensure that language translation and currency conversions were displaying as required
• Managing the project using Agile method and implemented scrum methodology.
• Established a corporate finance data repository assisting in credit score carding.
• Integrated an external credit score carding system into internal risk management system by identifying management requirements and implementing automatic information upload.
• Recommended process or system changes intended to eliminate identified risks or gaps. In risk analysis, looked at the current process, the internal controls, the checks implemented and the process gaps to analyze and suggest updates.
• Assisted the team members to develop Service Oriented Architecture (SOA), and data warehouse system (EDW) to utilize data mining for data analysis
• Used Data warehousing for Data Profiling to examine the data available (Data Analysis) in an existing database
• Worked extensively on Access, such as creating Tables, Validating the Relationship between tables and Executing SQL queries for data validation and Reporting Purpose.
• Analyzed and understood ETL logic and running ETL scripts and then validating the data
• Exported all reports to EXCEL Spreadsheets for the business reporting.
• With each suggested update, took business approval and then assigned the change request to developers, QA teams, to follow the SDLC steps to implement changes.
• Tested the final application for usability testing (UAT) to verify whether all the user requirements were catered to, by the application.
• Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, PowerPoint, Access.
• Analyzed usage rates, locations, transactions processed, Worked on ATM transaction processing/options ranging from personalized Fast Cash withdrawals to deposit automation.

Confidential, Richmond, VA

Business System Analyst

Responsibilities:

• Gathered High Level requirements working directly with department heads.
• Regular interaction with Portfolio Managers and Research Analysts to understand the current spend trend and derive future trends.
• Use current spend pattern and future trend plots to arrive at the decision of which additional features to implement.
• Suggest fine tuning in requirements and as-is system based on Analysis of available data and discussions with support groups.
• To validate Data extensively wrote complex SQL Queries which mainly was hooked up with backend testing.
• Do Risk Assessment studies in conjunction with Senior Project Managers and Departments heads.
• Create Risk Analysis matrix for the view of Senior Management and prune requirements based on decisions made in stakeholder meetings.
• Utilized the Agile Scrum methodology to analyze the requirements to create stories
• Assisted the customer in defining the high-level Functional Requirements and needs.
• Gathered the requirements, developed process models and detailed Business Policies, and modified the business requirement document.
• Checked the data flow from front end to backend and used SQL queries to extract the data from the database.
• Validate transaction records using SQL queries.
• Worked on Pivot tables (for handling dynamic data/tables for averages, Sum and other functions), Used Macros and created custom data validation rules, VLOOKUP, Array formulas in excel.
• Access: Used Access Database with queries to pull data, Created reports, exported data into excel sheet.
• Functional testing of Android Mobile apps.
• Performed extensive testing of the web based application on various browsers and mobile devices.
• Involved in the analysis of the existing credit card processing system and mapping phase according to the functionality and data conversion procedure.
• Involved in testing UAT environment (creating/executing test cases and logging defect in JIRA)
• Conducted daily SCRUM meetings during the Sprint Development as a part of Agile Methodology. Also captured and addressed concerns from IT to Product Management or Business Team as needed
• Worked with the project manager to estimate best/worse case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center managers and stakeholders of the project.
• Maintaining requirements traceability matrix (RTM) to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan using JIRA.
• Involved in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, and Data Warehousing/ETL testing.
• Also developed System Specification Documents, Interface documents to show the process flow.
• Thorough analysis of available data sources to demarcate the reference data and master data. Designed data flow models to project flow of information from applications to both sets of data.
• Using Agile Methodology, the entire project was broken into sub tasks which were performed in parallel.
• Verify the employment and income information valuate the borrower's collateral(s), and review his credit history before deciding.
• Analyzed the data using MS Excel, SQL and Access and generate different reports to gain more knowledge in about the business status.
• Worked collaboratively with Business Intelligence and ETL resources to design and develop effective solution.
• Worked on Business Intelligence reports development by working closely with Microstrategy, Teradata, and ETL teams.
• Prepared the Business Workflow using MS-Visio with input, output, pre/ post conditions.
• Utilized Excel formulae’s; Vlookup, Hlookup, if/then etc. for data analysis. Additionally, using statistical formulae’s for making inferences and Business intelligence.
• Prepare and document business continuity plans.
• Created traceability matrix.
• Coordinate and prepare documentation and training for end users.
• Responsible for writing Business Use Cases, Business Rules, logical analysis and change management of requirements.
• Created daily report for the clients using Excel and Access according to the requirements for data validation.
• Used MS Visio to carry out the business modeling, data modeling, and object modeling efforts to develop the business architecture for rapid and controlled application development.
• Maintained meeting minutes, meeting agenda and communicated them with the SMEs and the stakeholders on timely manner using MS Word, MS PowerPoint and created reports using MS Excel.

Confidential, Charlotte, NC

Business System Analyst

Responsibilities:

• Involved in full software development life cycle (SDLC) starting from initial requirement gathering to design, testing, documentation and implementation.
• Prepared Business Requirement Document (BRD), Functional Spec Document (FSD), Data Flow Diagrams (DFD).
• Performed query reports and database testing using SQL
• Performed GAP Analysis between “AS IS” and “TO BE” workflow models.
• Interviewed SME’s, facilitated JAD sessions and interacted with Business sponsors.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Assisted project managers with the development of project schedules.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data
• Performed backend testing to validate the data using SQL queries
• Participated in testing of mobile (both Android and iOS) and Web based applications
• Worked in Agile environment and carried responsibility throughout the project life cycle.
• Co-authored business requirements document, functional requirement document with project teams.
• Extracted, discussed, and refined business requirements from business users and team members
• Created SQL Queries using Oracle, SQL Server and DB2 in validating data into Data Warehouse/ETL applications.
• Utilized Agile methodology in the implementation of the system analysed and designed business process flow diagrams using Visio.
• Utilized defect tracking tool JIRA for reporting bugs/defects in functionality. Conducted weekly status meeting with development teams for defect resolution. Utilized SQL for querying database tables during testing.
• Designed and developed project document templates based on SDLC methodology.
• Created reports including scheduling and delivery of reporting in multiple formats including MS Excel worksheet versions, email, XML and other formats.
• Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, and Sequence Diagrams.
• Was involved in process flow analysis for content management system.
• Created new, and modify existing SQL queries for use in the data integrity testing of the data warehouse application's ETL process.
• Used Microsoft Office suit to develop the documents such as Visio for creating wireframes, Word, Excel and PowerPoint for creation of Business Requirement documents.
• Performed analysis and design projects using a systems development methodology.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements
• Coordinated with technical lead and project manager to finalize the data model.

Confidential - Naperville, IL

Business System Analyst

Responsibilities:

• Followed agile methodology to develop process and standards.
• Gathered requirements, organized team meetings requirements from business users, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
• Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts.
• Worked on all phases of the System Development Life Cycle (SDLC), necessary procedures for requesting, developing, implementing and supporting the system development process.
• Conducted extensive study on fixed-income security positions (Corp. Bond, Muni Bond, US Treasury, ABS, MBS, CMO/Pass Through/TBA).
• Participated in meetings for GAP Analysis to identify the difference and enhancement between current (As-is) business process and the future (To-be) business flow.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Managed Scope and change throughout the SDLC process of the product.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Performed functional testing of restful web services using both XML and JSON
• Designed, developed and implemented a concurrent processing scheme for check pointing and restart/recovery. This involved the partitioning of certain application dependent Mainframe DB2 tables.
• Analyzed trading partner specifications and created EDI mapping guidelines.
• Job involved extensive spreadsheet modeling using MS Excel, pivot tables, vlookups, etc, financial statement analysis and various ad-hoc sensitivity analyses for the CFO and Chief Accountant to enable them to maintain reliable income statement data.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Collaborated with the QA team to develop test plans, test scenarios and test cases including execution condition, input description and expected result that will be used in system and user acceptance testing based on business requirements, technical specifications and product knowledge.
• Created Process Flow diagrams, Use case diagrams (UML) using MS-Visio.
• Developed use case diagrams, Entity Relationship diagrams, UML diagrams and activity diagrams to reflect use case narratives.
• Business requirements, defining system scope and schedules, managing costs, time and supervising four contractors; project successfully delivered within schedule and cost constraints.
• Reviewed and analyzed business requirements for International Fixed Income, Equities, Equity Derivatives and Prime Brokerage; developed business strategy and test plan
• Executed the test scripts and raised defects as necessary.
• Performed UAT regression testing after the defects were fixed.
• Build up SQL queries to get data from both source and destination and to compare them in the test bed.
• Created Test cases for all the Features going in for that web release
• Updated the test cases based on the recommendations from the development team
• Worked closely with the senior tester and Project Manager and discussed the scope of testing activities.
• Supported PMO by mentoring specific projects in application of the new SDLC based on the Rational Unified Process, especially from the project management, requirements and architecture perspectives.
• Incorporated Agile to create Business Requirement Document Specifications using MS Visio and MSWord.
• Test results are tracked through MS Excel and made available to all QA team members and a full report is documented every day.