Facilbusiness Systems Analyst Resume
Richmond, VA
SUMMARY:
IT professional with 6+ years of diverse experience in Business Analysis, System Analysis, Data Analysis & Business Development. In depth knowledge of the Software Development Life Cycle with complete understanding of business process, defining vision documents, interacting with stakeholders, understanding user requirements to articulate into User Requirement Specifications (Use Cases).Strong analytical communication, decision making and organizational skills.
- Six years of experience as a Business Analyst/System Analyst in Banking (ERM), Insurance (claims processing), and Automobile Industry.
- Extensive experience in Business Performance Management, Process Management, Business Process Reengineering and Gap Analysis (as is-to be) and Design Review.
- Adept with industry standard methodologies like Rational Unified Process (RUP), Agile Methodology, Waterfall Model and industry specific Hybrid models.
- Complete knowledge about Risk Management Life cycle. Actively involved in designing Risk Matrix models and Risk Log sheets
- Prepared the Request for Proposal Document (RFP) along with the PM team for the allocation of funds and resources
- Worked on different Project SDLC methodologies – RUP, Waterfall and Agile.
- Worked in complete project life cycle of Analysis, Design, Implementation, Integration Testing, Functional and Regression testing
- Created process flow diagrams and data flow diagrams to define Business schemes.
- Well versed in dealing with RDBMS’ such as Oracle, MS SQL Server and MS Access.
- Worked with Basic Teradata query language BTEQ
- Experience in Rational Rose, Clear Case, Requisite Pro, Clear Quest.
- Strong knowledge of Data Warehousing concepts and Dimensional Modeling.
- Worked with Core Banking Systems (CBS) to treat them as Commercial Customers
- Experience with GAP analysis, Data Mapping, JAD sessions and documented system/process inconsistencies. .
- Experience with writing/analyzing SQL scripts for various report validation and data analysis
- Worked as an Java Business Analyst collaborating and influences leadership across the IT organization.
- Worked with ACBS loan systems in order to design the companies commercial lending and trading system.
- Worked as a Java Business Analyst and consistently reviewed product strategy and maintained roadmap.
- Worked as a Java Business Analyst closely with technical team to ensure business objectives are met in an efficient/economical manner.
- Design and create functional specifications to enhance bank’s credit risk system aiming to satisfy business needs.
- Reviewed Legacy claims processing systems and gathered new requirements for developing applications that enable statistical analysis, reporting and Executive Information systems (EIS)
- Worked on the modeling of centralized Reference Data Hub database structure.
- Managed documentation of projects, Requirement Traceability Matrices, Risk Management plans, updated the requirement repository and provided status of documents to PMO team and release team
- Involved in discussions and meetings with all the levels of people in the software hierarchy ranging from Project managers to Architects, system administrators to Database Developers and end users
- Worked with EMC tools such as Documentum, eRoom and Webtop. Worked with Business Intelligence tools for reporting
- Involved in extensive requirements gathering for building the Data mart, Data warehouse and information delivery.
- Assisted the Data Modeler in creating Logical and Physical Data Models using ERWIN.
- Strong Background in working with Star Schema, Snow Flake Schema, & knowledge of Dimensional Modeling.
- Built teams and created an atmosphere that energizes others and the ability to consistently execute.
- Excellent interpersonal skills, problem solving and analytical abilities.
- Used MS Office extensively (Word, Excel, Visio, Power Point, Outlook, Project) for calculations, graphs, analysis, presentation and documentation throughout the projects.
- Experience in Firm wide Disaster Recovery planning, Risk Management plan, RTM
- Effortlessly managed clients, guaranteed the link between successful business strategies, financials and complex technology solutions.
SKILLS:
Operating System
Windows95/NT/2000/XP, UNIX
RDBMS
MS SQL Server 2000, Oracle 8i/9i/10g, MS-Access, TOAD,
Testing Suite
Win Runner
Web Tools
MS Viso, Rational Rows, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, Quality Center, CVS
Project Management
MS Project (PERT, Gantt charts), Excel spread sheets, MS office Suite
Programming Languages
HTML, XML, Java, MS SQL, Oracle 9i, JavaScript, J2EE, eRoom, Documentum, Visual Basic 5.0/6.0, Teradata
Business Skills /Process/Case Tools
Business Definition Requirements, Business Process Analysis & Research Use Case Modeling & Analysis, JAD/RAD Sessions, Requirements Gathering ,Gap Analysis and Impact analysis, MS Visio, Rational Unified Process (RUP), Rational Rose, Rational Requisite Pro, Test Manager, UML, Class Diagrams, Sequence Diagrams, Activity
EXPERIENCE:
Confidential,Richmond-VA August 2009—Current
Business Systems Analyst
Project Scope: Capital One Financial Corp. is a Mclean, Virginia-based U.S bank holding company spspecializing in credit cards, home loans, auto loans, banking, and savings products. A member of the Fortune 500, the company helped pioneer the mass marketing of credit cards in the early 1990s, and it is now the fourth largest customer of the United States Postal Service and has the 8th largest deposit portfolio in the United States. This project primarily deals with the making CapOne systems compatible after the integration of CCB (Chevy Chase Bank) and COB (Capital One Bank). CCB maintains a very high standard of Customer Experience and COB needs to alter their systems to achieve similar standards. This includes the payments made on US Card, Auto Loans , Inquires on Loans and Lines, Card Payments through Call Center (Bank and Card) and ATM.
Roles and Achievements:
- Analyzed, Gathered and Documented Back end system Business requirements for the CCB-COB integration.
- Performed a Vital Role in defining and eliciting Front end Business Requirements for the CCB-COB integration.
- Worked closely with the Compliance, Legal and Customer Advocacy department of Capital One for gathering, documenting and sign off of the Business Requirements.
- Prepared RFP documents for automation of the commercial banking process of tracking and risk mitigation including request discretionary approvals by the Stake holder team
- Worked closely with the Process, CID and the Fidelity Department of Capital One for gathering, documenting and sign off of the Business Requirements.
- Created Use Cases clearly eliciting the various scenario’s a CCB customer’s experience with various modes of payment in various channels of COB.
- Created number of UML diagrams for the testing team to have a clear flow of the processes and help them in system and regression testing.
- Worked with the PM to elicit Timelines and clearly define scope
- Framed and documented the requirements in a loadable format for Requisite Pro
- Created high level design documents for the PM to clearly defining the current and future states of the functionality.
Confidential,Richmond-VA Sept 2008-March 2009
Business Systems Analyst
Project Scope: Capital One Financial Corp. is a McLean, Virginia-based U.S. bank holding company specializing in credit cards, home loans, auto loans, banking, and savings products. A member of the Fortune 500, the company helped pioneer the mass marketing of credit cards in the early 1990s, and it is now the fourth largest customer of the United States Postal Service and has the 8th largest deposit portfolio in the United States. The CLIR (Closed Loop Issue Resolution) project is defined as the process to successfully handle customer contacts that require follow up, future customer communications and/or where fulfillment of the customer’s request is not certain. At present there is a manual process in place for Customers to submit affidavits related to fraud transactions to Capital One. The CLIR initiative involves the automation of the manual process. In an effort to streamline the business process the EOS will be leveraged as it is one of the primary interfaces between Capital One and the customer. It will allow the customer to submit the affidavit this expediting the case resolution process.
Roles and Achievements:
- Analyzed, gathered and Documented system requirements for 2 capabilities of CLIR: 1) Outbound Secure Message and E-affidavit.
- Gathered Design specifications for both the capabilities clearly specifying the Meta Data from Backend systems and key elements for Design
- Documented requirements surrounding Interaction of EOS with Middleware systems and nature of Middleware codes and Return Codes
- Involved in various design sessions and submitted CR’s as and when the design decisions impacted requirements gathering.
- Worked in an Agile environment where piecewise enhancements were made to the Current state of requirements with minimum budgetary impact.
- Conducted impact analysis meetings before every release determining stakeholder impact, developer impact, testing impact and Business impact on a scale of 1 to 4.
- Worked with external Capone Vendors to make sure the ongoing enhancements did not impact the capabilities leveraged by their channels
- Extensively worked with Use Case Diagrams in determining the Case model for the CLIR project.
- Worked with the Fulfillment Management System ensuring correct file transfer between the Case Management system and EOS.
- Conducted various JAD requirements walkthrough sessions at the program level of the CLIR project
- Helped in documenting the RFP documents to request new timeline schedules for the CLIR project at the program level.
- Actively involved in helping the testing team understand the scope and requirements of the CLIR project and also the facilitated the subsequent test case creation.
- Conducted various “Requirements Hand-off” sessions with the Developers and made sure they got what they wanted as far as Requirements were concerned.
- Wrote Specific Requirements for developers to write Dynamic Content on the web server using Java Servlets
- Wrote Key Requirements for the passage of static data across teams using Java Server Pages instead of XML
- Participated in Unit, system and Integration testing by ensuring that their did not breach the Business Intent
- Documented and Drafted Business Requirements from the all business stakeholders across the organization for the CLIR project
- Performed a Key role with the Intent Delivery Team in defining well defined Business Intent across all the teams.
- Actively teamed up with the Tech Lead in documenting comprehensive system requirements for the CLIR program.
- Actively participated in planning sessions with the Project Manager in defining scope and timelines of the CLIR project.
- Successfully conducted requirements review sessions in the presence stakeholders, Legal and compliance and Business Intent
- Actively participated in creating design documents for both high level and detailed design.
- Successfully conducted Design review sessions (high level design) in the presence of stakeholders and Business Intent.
- Provided Extensive Testing support with all issues governing requirements clean up and requirements elicitation.
- Extensive use of Quality Center as a system of record of all the requirements.
- Worked with the UI team and developed UI screens to facilitate the visual look of both the capabilities for the development team.
- Worked with the Business Intent team and the Solutions Architect in creating high-level architecture documents for the CLIR program
- Worked with the Content Management group of Capital One in ensuring the correct publishing and deployment of the secure message templates for the CLIR program.
- Involved in Designing and identifying key elements of dynamic data via a web service operation through the middle ware system
- Played a pivotal role in identifying various error scenario’s with the backend systems and designing subsequent error handling scenario’s for error mitigation.
Environment: Rational Rose, Rational Requisite Pro, Windows 2000, JAVA SERVLETS, J2EE, MS Office, Rational Clear Case, Rational Clear Quest, Dream Waver, Quality Center.
Confidential, Florida Jan 07 – Aug 08
Sr. Business Analyst/ Systems Analyst
Commercial banking
Riverside bank initiated a project to automate its Commercial banking process within the bank using LSAMS. As part of this initiative a ruled based workflow application was introduced with tracking and process costing facilities. Exposure Analysis, Risk Mitigation and discretionary approvals were the key features of the system. A workflow solution incorporated with rules to analyze, review and manage the approval process for Commercial loans. The “Approval” decision task is directed to the position in accordance with the discretionary Limits chart of the organization.
Roles and Achievements:
- Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Portfolio Risk Management System.
- Understood and articulated business requirements from user interviews and then translated those requirements into functional and technical specifications.
- Understood the Risk Management Life cycle and related it with the application
- Interacted with financial analysts to finalize the Business Requirements for the Risk Management process.
- Interacted with SME’s of different divisions (Information Technology, Risk and Operations) and established a business analysis and design methodology around the RUP (Rational Unified Process).
- Prepared High Level Logical Data Models and BRD supporting documents like the use case, sequential diagrams containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements using MS Visio
- Worked with Documentum and eRoom for storing documents like RTM, RMP and keep track of the projects.
- Conducted Joint Requirements Planning (JRP) sessions with management, SME’s (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications.
- Designed Use Cases, Use Case diagrams, Class diagrams, Activity diagrams, Sequence diagrams in 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.
- Involved in writing Test Cases and developing 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.
- Participated in System Testing along with testers. Conducted UAT with the business.
- Involved in Data validation in both front end and back end risk management reference center
- Collaborated with Quality Assurance Analyst in Rational Clear Quest to track defects and used Rational Clear Case to maintain consistency in the builds.
- Involved in maintaining the risk management plan
- Responsible for the completion of projects within specified time and budget dealing with financials, project work flow, change management and dealing with vendor relationships.
Environment: Rational Rose, Rational Requisite Pro, Windows 2000, MS Office, Informatica, Erwin, Rational Clear Case, Rational Clear Quest, Oracle 10g, XML, HTML, Microsoft SQL Server, Win Runner,
Confidential,Boston, MA June2005-July2006
Sr. Business Analyst/System Analyst
Project Scope: Plymouth Rock Assurance is a leading provider of Auto, Property and Casualty Insurances solutions in Boston, MA. Its flagship product is a comprehensive and easily customizable Insurance coverage. Project involved the development of their claim processing system which was designed to adapt diverse customer environments. Your clients and underwriters can view whatever data you dictate is relevant to them from anywhere in the world, and powerful reports can be generated on the fly. Plymouth Rock runs on both Windows based online system and supports multiple database systems. The software suite can be run by a single user, or with thousands of users, offering a highly scalable architecture that can be tailored to each client\'s specific business rules.
Roles and Achievements:
- Involved in business meetings along with Architects and Data Modelers to help gather both the business requirements and the Data Mart requirements for the portal
- Prioritized project efforts, developed project plans, process flows, Use Cases and software requirements specifications (SRS) using RUP.
- Analyzed the Business requirements and the site specifications.
- Analyzed System and Functional Specification documents for the Web Portal System
- Worked with application development team to identify bottlenecks that could hinder progress of development
- RUP process model was used for the different phases of the application development of the Software Development Life Cycle
- Played a key role in helping the company adopt Rational Unified Process
- Used UML notations for Object Oriented Design and Documentation
- RUP process model was used for the different phases of the application development of the Software Development Life Cycle
- Worked on writing functional specification for reporting module that handled credit and consumer risk management services.
- Developed RUP Analysis Model that included entity classes, use case diagram, sequence diagrams using MS Viso that provided a view of the requirements
- Monitored the FTP process of importing raw data from third party FTP servers to the Plymouth’s local server called Plymouth Netcom
- Assisted the programmers in loading the Data from the Server to the Plymouths staging Database using SQL loader.
- Provided Data Mapping Documents to the ETL developers to define source and target tables to load structured data into Plymouth’s ODS which was called Common Underwriting exchange ODS..
- Instrumental in carrying out Data Validation -of various Source to Target Transformations
- Assisted in performing functional and GUI testing by preparing automated scripts using Win Runner
- Carried out Defect Tracking in Rational clear Quest and interacted with CCB with respect to enhancements/changes made.
- Tested security privileges of the application for individual users as well as group access
- Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing efforts on their applications
Environment: Rational rose Rational Requisite Pro, MS Visio , RUP, UML, Rational Clear Quest, Rational Clear Case, Rational Tools Suite, SQL, SLQ loader, Windows, Unix, Java/J2EE, XML, HTML, Unit testing, GUI testing, system testing
Confidential, Jan 2004-June2005
Sr. Business Analyst/System Analyst
Project scope: Chevy Chase Bank is designing new software architecture for single-family legacy .The system automates the entire Servicing system from establishing the loan into servicing system to managing the loan by automating the most complex applications. I was involved working as a Business and Data Analyst gathering requirements and framing complex mapping documents and assisting the Data Modelers and ETL developers.
Roles and Achievements:
- Involved in gathering control reports and assisted in verifying data from one database to another
- Involved in the ETL process of Data Integration
- Wrote requirements for the designing data marts that were used as the source for the various reporting systems in the company
- Analyzed the loan processing engine and drew UML diagrams for the ETL developers using MS Visio
- Participated in developing ETL’s for Data extraction, Data transformation and loading
- Performed Analysis and design of implementing a Star Schema Data Mart with Facts and Dimensions.
- Assisted developers in using ERWIN for logical and physical database modeling
- Performed Data Analysis and Data validation by writing complex sql queries against the DB2 database.
- Created Data Flow Diagrams and Process flow diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation
- Worked on gathering requirements for the Internal FTP server.
- User Requirements gathering by interacting with the stakeholders and other management personnel to get a better understanding of the business process
- Gathered requirements for the Loan processing Engine
- Participated in JAD session with team of developers, stakeholders, SME’s, analysts to decide the resources and deadlines associated with this Loan processing Engine.
- Aided the developing team in developing the loan processing engine by providing the functional requirement document
- Prepared the Business and Functional Requirements documents in Rational Requisite pro.
- Performed tests with the QA teams.
- Performed UAT to test validity of the engine
- Involved in Defect Tracking-tracking defects in rational clear quest and dealing with the CCB.
- Coordinated and prioritized outstanding defects and enhancement requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
- Gathered requirements for the resulting Data Mart to generate reports
- Actively Involved in General Ledger Reconciliation
- Wrote SQL queries to do report validation of the Accounts Recievable and Accounts Payable tables
Environment: Oracle 8i/9i, MS Suite, SQL Toad, Informatica, ERWIN, VISIO, Win Runner, DOORS, CVS.
Confidential,NY July 2002-Dec 03
Business Analyst/QA Analyst
The project involved creation of a Commercial banking application that allows customers to access information like Checking /Saving Account balances and make payments online. Users are able to view Loan history, Tax/interest details and update personal information. The Application responds within 60 seconds and gives details of credit card approval or non-approval.
Role & Achievements:
- Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
- Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
- Identified internal and external system Requirements, design and configuration set-up.
- Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
- Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
- 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
- Designed and developed Project document templates based on AGILE methodology.
- Developed Business Requirement Document as well as High-Level Project Plan.
- Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
- Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
- Participated in the Logical and Physical Design sessions and developed Design Documents.
- Worked with developers to make sure that they understood the Use Cases.
- Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
- Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
- Worked with Quality Control Teams to develop Test Plan and Test Cases.
- Develop User Manuals, and Training Manuals as per Project Specifications and timelines.
Environment: Microsoft Office Suite, MS Visio, Windows XP, SQL, PLSQL, XML, VB, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner
EDUCATION:
Master of Science in Computer Science
