SUMMARY

• Business System Analyst with 8 plus years of experience with domain expertise in Financial and Banking Industries.
• My Special expertise includes in Mortgage and loan from opening to closing.
• Expertise in gathering requirements from the stakeholders, conducting user interviews, analysing business requirements and documentation
• Proven communication, analytical, and problem - solving skills to help manage the project development process, and to ensure that project deliverables are met according to specifications.
• Experience overseeing the design, development, and implementation of software and hardware solutions, systems, or products.
• In-depth knowledge and hands on experience working with CCAR
• Analysis, Design, Implementation, Testing and Deployment as well as exposure to software engineering methods like Agile Methodology and Rational Unified Process (RUP)
• Formally trained and on-going experience in Agile methodology as Business Analyst on Scrum team
• Expertise in business process mapping & re-engineering, proposal development, project management organization, requirements analysis, data analysis, change management, use-case design, software implementation with strong business acumen, positive attitude, creative thinking & effective analytical power.
• Excellent Analytical, Presentation, Communication and Interpersonal skills with proficiency in demonstration and highly adaptable to new technologies & business environment.
• Strong leadership, facilitation, organizational and multi-tasking skills. Good Team player with excellent trouble shooting and problem solving skills.
• Expertise in using Databases like SQL, Oracle, MS Excel and MS Access for querying purpose
• Experience in creating reports using MS Access and Excel
• Ability to take initiative and drive Agile Best Practices to improve time-to-market, quality and predictability.
• Ability to thrive in a highly ambiguous, fast paced environment where priorities shift rapidly. Experience in Rally’s Agile Portfolio Management Solution.
• Passionate for Scrum, Agile and Lean methodologies. Self-motivated and capable of managing multiple priorities and tasks as delegated
• Team-player with the ability to work within a collaborative environment. Creative and efficient in proposing solutions to complex, time-critical problems. Collaborative in driving decisions. Strong analytical and problem solving skills with a high attention to detail
• Strong organizational and cross-team communication skills. Ability to adapt to a rapidly changing environment. Ability to understand and communicate customer needs
• Ability to utilize the Microsoft Suite (includes MS Visio, Outlook, Excel, PowerPoint, Project, and Project Server)
• Experience in generating reports and resolving issues with Tableau Server and Reports
• Experience managing conflicts, facilitating negotiation, and maintaining a degree of adaptability
• Proven expertise in preparing and presenting communications to all levels of management and staff.
• Facilitated and conducted SCRUMS, Joint Application Design (JAD) and Joint Requirement Planning (JRP) sessions, interviews, workshops and requirement elicitation sessions with end-users, clients, stakeholders and development team.
• Skilled in translating business objectives into prioritized functional requirements and recommending feasible solutions to business problems using tools like Rational Requisite Pro and Quality Center.
• Extensive knowledge of Design using Unified Modeling Language (UML) and skilled in creation of Use Case, Activity, and Class Diagrams using various tools.
• Designed and reviewed test strategies, test cases, test scripts with QA/Dev teams and facilitated User Acceptance Testing (UAT).
• Expert in working with Commercial off the Shelf (COTS) Packages.
• Experience with OLTP, Data warehouse and Data Mart projects
• Experience with GAP, Data Mapping documentation and data analysis during the conversion process (In DWH, Data Mart and Reporting environments).
• Experience writing analytical SQL queries to perform data analysis and data validation and quality check.
• Experience with Oracle Enterprise Manager (OEM), Oracle Recovery Manager (RMAN), and have UNIX shell scripting, SQL scripting and PL/SQL experience.
• Experience in developing and maintaining Oracle 11g application using Oracle 11g Forms and Reports

TECHNICAL SKILLS

Languages: C/C++, SQL, PL/SQL and Basic

Databases: MS Access, Oracle, MS SQL Server

Browsers: Netscape Navigator, Internet Explorer, Firefox and Google Chrome

Operating systems: Windows NT, Windows 95/98/00, Windows XP

Requirement Tools: Rational Requisite Pro, DOORS, Quality Centre

Bug tracking and reporting: HP Quality Centre, Rational Clear Quest, Bugzilla, Hyperion

Other Tools: MS SharePoint, MS Excel, MS Visio, TOAD, SQL Navigator, BMC Remedy, Rally (APMS), Test Manager, MS Project, Tableau

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SR. BUSINESS SYSTEMS ANALYST

Responsibilities:

• Created User Stories with accurate Acceptance Criteria and Plans of Intent, lead Agile ceremonies
• Coordinated process improvements and automation of manual processes and focused on creating tangible visible value to benefit stakeholders quickly
• Worked daily with business stakeholders on transforming legacy processes into distributed model
• Created Agile program to manage process improvement efforts, including Sprint structure and ceremonies, Program and Team level backlogs and manage all inspect and adapt sessions
• Acted as liaison between stakeholders, system users, external partners, and managers to gather requirements
• Documented data sources and transformation rules required populating and maintaining data warehouse content.
• Worked in agile development environment in a scrum fashion. Worked with the scrum manager to develop stories, sprint and conduct daily scrum
• Worked with Tableau BI Dashboard reporting solution for different groups in the organization
• Documented use cases based on discussions with users and subject matter experts
• Performed in depth analysis of data & prepared weekly, biweekly, monthly reports by using MS Excel, MS Access, SQL
• Worked with Access Management Group and end users to validate the actual right assigned by performing User Acceptance Testing (UAT).
• Worked with different stakeholders to create End Users access provisioning matrix for different access level rights of internal and external applications for different teams and submitted to Access Management Group.
• Prepared use case diagrams and activity diagrams using Rational Rose
• Developed project schedules, timelines, status, system schematics and process work flows.
• Created V/H Lookup using Excel Spreadsheet to find the information for different type of loan documents
• Use Excel Spreadsheet to make the comparison between two methods of gathering and retrieval of document (automation and manual).
• Created graphs and charts using Excel Spreadsheet to analyze the data.
• Used Excel Spreadsheet extensively to validate the format of the available data
• Created Pivot table using Excel Spreadsheet to summarize the collected data
• Interacted with the business to verify the mappings and prepared the Functional Specification Document
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server - Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensure that critical requirements are not missed.
• Wrote SQL queries in MS Access and SQL Server for data analysis.
• Worked with business users, programmers, testing staff, and database administrators to develop database requirements, test plans and database schemas to transition MS ACCESS databases to SQL Server
• Created workbooks and reports for analyzing statistical data using Tableau
• Did GAP analysis and documented actual performance Vs. potential performance

Environment: Scrum, MS-SQL Server, MS Access, Erwin, Tableau, MS-Office, Teradata, RDBMS-Oracle, DOORS

Confidential, OH

SR. BUSINESS SYSTEMS ANALYST

Responsibilities:

• Conducted daily stand up meetings to get live updates from the team, helping Project Manager actively update the project status, detect risks at early stage and take corrective / preventive actions.
• Actively participated in program level and team level backlog grooming to ensure work aligned with organization’s needs
• Facilitated requirements validation working sessions to make sure team’s work delivered continuous value
• Performed several iterations of Data Profiling to discover Semi Structured Data, Textual Data, Audio/Video Data, Cold Data and Obsolete data. Conducted numerous JAD data mining sessions to explore data lineage from the Data Ware house and Data Marts to the source systems.
• Managed and coordinated the efforts of the Business analyst team as well User Interface team to ensure efficient and timely delivery of the documentation.
• Worked directly with the Project Manager to manage project scope, managing deliverables, updating BA Dashboard.
• Worked directly with Portfolio managers with application lifecycle management for all the mobile app development projects (different platforms and devices) though Rally’s software solutions.
• Collaborate with stakeholders to refine ideas that drive innovation, prioritize work, improve efficiency and improve response time for BOA’s Core channel portfolio by using Rally‘s Agile Portfolio Management solution.
• Conducted JAD sessions, user interviews, and detailed research and requirement meetings to capture the requirements and prepare BRD.
• Worked directly with IA (Information Architect) and other representatives from the UX (User Experience) to design wireframes and flows.
• Created High Level Use Case to detailed UC documents to be used throughout the project from estimation to final design and delivery.
• Used expert knowledge of MS Excel, MS Access, MS Query, and SQL, to import and correlate data from multiple sources in multiple formats
• Managed change control log and version control documents to avoid confusion and avoid documentation gaps.
• Prepared As-is To-be business models (Gap Analysis) to highlight the Gap and outline the future
• Assisted IA for the design of wireframes based on interface design knowledge and expertise.
• Managed and efficiently completed the one of the highly desired project (due its revenue
• Generating properties) on the BOA Bank roadmap
• Worked directly with the offshore development team. Conducting and coordinating numerous product design sessions - On site and Virtual
• Assured timely delivery of various documents (BRD, Wireframes, Visio Source files, Style Guide, Content etc.)
• Managed A-Z workflows for the sign off on all required documentation throughout the release
• Managed SharePoint repository to ensure availability and proper access to the up to date documentation related to the project / release.
• Provided regular status reports for project dashboard using predefined reports in BMC Remedy
• Conducted cross channel meetings to ensure all internal groups like Security, Fraud, Compliance, Risk and Reporting etc. understood the requirements and the impact.
• Provided testing support to the testing team. Actively participated in overnight app releases, running test cases, revivifying defects and bugs and properly communicating to the required.
• Hands on experience of testing, troubleshooting and configuring various types of handsets and different OS such as BB, Android, iOS, Windows.

Environment: MS SharePoint, Lotus Notes, MS Project, Rational Rose, MS Visio, MS Access, Android, iOS, Blackberry, Generic Handsets, Android tablets, iPad, Windows Phone and Tablet, DDTS (Distributed Defect Tracking System), TSYS, RWD (Responsive Web Design), Omniture, SharePoint, Adobe Test and Target, WebEx

Confidential, Charlotte, NC

BUSINESS SYSTEMS ANALYST

Responsibilities:

• Responsible for the Design, Analysis & implementation of the Interface Gateway for a global gateway process to handle multiple feeds from several different regions of BOA Europe, Asia-Pac rim, Australia & North America.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, and maintenance review.
• Teamed together with client resources to design the to-be processes, applying standards and facilitating the industry best practices.
• Analyzed and designed data mart requirements.
• Worked-on several JAD sessions to solve the different issues occurred during the project development.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using MS Excel, MS Access, SQL
• Created MS Access databases to track and provide automated reporting capabilities for user and technology-related issues
• Created and enhanced logical view of dimensional data model for data marts.
• Performed Data analysis and created Data mapping documents for ETL design that feeds to physical data models
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro
• Audited historical data to ensure data integrity and developed procedures and maintained instruction manuals and document library
• Created and maintained data dictionary to describe data flow, process and structures and other attributed of database.
• Used Rational Clear Quest as a change management tool to maintain and track stakeholders requested enhancements and changes
• Reviewed test plans and test cases and ensuring test cases reflect user needs; responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting

Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS-Project, MS Access, Windows XP/7, Rational requisite Pro, SQL, SharePoint 2010, Clear quest and Clear case.

Confidential, NY

BUSINESS SYSTEM ANALYST

Responsibilities:

• Participated in requirements gathering and design sessions based on business processes, requirements and system designs. Prepared requirement specifications (SRS), functionality trace matrix and design test cases.
• Analyzed and collected business requirements, generated business models, identified system interface and created the requirements specification document.
• Developed Requirement specifications and process diagrams including context, dataflow diagrams.
• Analysed requirement document by identifying ambiguous, incomplete and incorrect requirements. Developed test cases to ensure that the application is delivered according to requirement
• Performed Sarbanes-Oxley analysis of information technology processes comparing company policy to current practices.
• Performed detailed Gap analysis of technical requirements reviewed under to Sarbanes-Oxley process. Used DOORS to understand the impact of changing a requirement and decide whether to include it in the current project and to define the traceability across the entire project lifecycle.
• Worked on DOORS, to submit, review and approve changes within the document.
• Managed change of the requirements and associated requirements to other requirements for traceability using DOORS.
• Created and executed queries using SQL and MS Access to validate data movement and generate expected results for UAT.
• Developed the Project using the Iterative RUP model. The Project was streamlined through all phases of the RUP model starting from Inception through Transition.
• Used a Functional Decomposition strategy to divide system into sub-systems.
• Used questionnaire, surveys, JAD sessions and Brainstorming sessions as requirement elicitation techniques
• Developed Use case diagrams by analyzing the business process followed by Class diagrams,
• Activity diagrams and Collaboration diagrams in UML using Rational Rose.
• Used MS-Visio to draw data flow diagrams, process flow diagrams, and network diagrams. Used
• MS-Project for developing schedules using Gantt charts and PERT charts.
• Eyed a pivotal role in conducting Functional testing, Regression testing, and User Acceptance Testing (UAT).
• Created UAT test plan and conducted a walkthrough session to make sure all other teams (Development, SIT, Deployment, SME and Baseline) understood their roles and effort.
• Created test cases and test scripts for user acceptance testing and maintained them in Test Manager and created traceability to Doors.
• Conducted UAT and made sure all identified defects and enhancements were logged into in-house Access tool (Defect Enhancement Tracking System-DETS).
• Coordinated and prioritized outstanding defects and enhancement identified during UAT, and escalated the same if necessary to achieve the deadline.
• Overlooked the project binder and approvals log and ensured that all approvals and signoffs were attained as per schedule and met with the guidelines laid down by SOX.
• Ensured that changes in business process have strong controls and meet the reporting requirements of Aegis’s internal audit, and SOX.
• Created the Service level agreement to meet all current business requirements and anticipated future enhancements.
• Represented the team in Change Control Board (CCB) meetings to ensure that the board approved the changes proposed and migration of impacted codes to production occurred at scheduled time

Environment: Oracle 8i/9i, MS Suite, SQL, Win Runner, DOORS, MS Access (DETS).