We provide IT Staff Augmentation Services!

Business Analyst Resume

Tampa, FL

SUMMARY:

  • IT professional with 6 years of diverse experience in Business Analysis, Data Analysis, Project Coordination & Business Development in Banking (ERM), Finance and Insurance Industries.
  • 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).
  • Mainly worked as a Business Analyst / Systems Analyst using the iterative software development lifecycle principles with extensive experience in the field of business analysis, business modeling, document processing, etc to manage, develop and test P&C insurance (Underwriting, Actuarial, Billing and claims) systems.
  • Have in depth understanding of the different commercial lines of P&C insurance with emphasis on Auto and Business Owners Insurance.
  • Expert with industry standard methodologies like Agile, SCRUM, XP, Rational Unified Process (RUP), Waterfall and industry specific Hybrid models.
  • Expert in reconciling Pool and loan parameter changes (like principle and interest, Note rate, Pass through rate, servicing fees, guarantee fees, Unpaid balance, Last Paid Installment) in Investor Reporting System.
  • Experienced with all phases of software development including requirements gathering, work assignment, implementation and user acceptance testing.
  • Proficient in ensuring that business goal are met throughout the product lifecycle.
    Proficient in creating Behavioral and Structural UML diagrams including Activity, Sequence, Data Flow and ER Diagrams.
  • Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications; Development and Testing.
  • Expert in conducting requirement gathering sessions, feasibility studies and Impact Analysis, Cost/Benefit analysis and Risk analysis, baseline acceptance criteria.
  • Experience in working with Actuarial and Marketing analytics for claims and risk assessment by reviewing their data analytics
  • In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
  • Worked in FileNet for storing and updating data and user interface specifications.
  • Complete knowledge about Risk Management Life cycle and Expert in creating process flow diagrams and data flow diagrams to define Business schemes.
  • Experience in working with knowledge management programs to achieve organizational objectives.
  • Experience in Maintaining Reference data Management System and Master data Management system with service oriented architecture (SOA).
  • Experience with OCR/ICR in data entry and data/text mining
  • Well versed in dealing with Structured data and Relational Database Management Services using Oracle, MS SQL Server, DB2 and MS Access.
  • Experience with writing/analyzing SQL scripts for various report validation and data analysis.
  • Experience in Data Architecture and maintaining Relational Databases and Meta data registry.
  • Experience in using SAS for data management, data retrieval, data quality improvement ad statistic analysis
  • Experience in Asset and Liability management of financial institutions
  • Worked with the treasury to determine cash flows and credit assessment
  • Expert in designing and creating functional specifications to enhance credit risk system aiming to satisfy business needs.
  • Experience in implementing the BASAL Regulatory changes
  • Strong team player with excellent interpersonal skills, including the ability to coordinate and motivate and lead team members.

Technical Skills:

Operating System: Windows95/NT/2000/XP/Vista, UNIX

Testing Suite: TRAC, Mercury Quality Center, QTP, Load Runner, Win Runner

Web Tools: MS Visio, Rational Rose, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, CVS

Project Management: MS Project (PERT, Gantt Charts), Team Track, Excel spread sheets, MS office Suite, OECM (Oracle) 10gR3, CMMI, Lotus Notes, HP Service Manager

Programming Languages: HTML, XML, Java, J2EE, J Rules/PMI, SQL, JavaScript , Visual Basic 5.0/6.0, SAS

Business Skills /Process/Case Tools: Business Definition Requirements, Business Process Analysis & Research Use Case Modeling & Analysis, JAD/RAD Sessions, ENCOMPASS, Genesis, eRoom, Documentum, Content Management, Knowledge Management, Requirements Gathering ,Gap Analysis, Traceability and Impact analysis, MS Visio, Rational Unified Process (RUP), Rational Rose, Rational Requisite Pro, Test Manager, UML, Class Diagrams, Sequence Diagrams, Activity Data stage ETL, Micro strategy.

PROJECT EXPERIENCE:

Confidential, Tampa, FL

Business Analyst

Project Scope: This project delivers a two-table solution composed of all the attributes requested by the business for tracking and reporting on Medicare members. The process will leverage the results of several external processes to build and maintain basic source data for Medicare membership.

Responsibilities:

  • Was responsible for project schedules, creating and reviewing business requirements and test plans for margin requirements of the Fund Disbursement System Automation that was developed specifically to support Private Wealth Management
  • Conducted interviews with key business users to understand business processes for fixed income, FOREX, bonds, equities, hedge funds, derivatives (Options, interest rate and Futures), portfolio, collateral and cash management in terms of margin requirements
  • Utilized US GAAP and IFRS accounting rules to incorporate revenue and costs recognition for both US and international statements and applied these for forecasting purposes
  • Interacted with business users to understand and document the fund accounting of the transactions
  • Designed and developed use cases diagrams, activity diagrams, sequence diagrams for various modules using RUP, Agile and SDLC Methodology
  • Performed workflow, process diagram and GAP analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements
  • Developed traceability matrix to schedule deliverables within agreed timeframes and interacted with all departments to monitor the deliverables in the time frame
  • Utilized SAS to gather relevant data, identified trends in investing, evaluated opportunities to acquire new customers, increase volume with existing customers and manage attrition risk
  • Used SWIFT for communication and processing at all levels of the lifecycle of the transaction
  • Worked with SMEs, such as legal/regulatory advisors, tax accountant and disaster recovery team to ensure appropriate technology provision to comply with standards and requirements
  • Gathered data, segmented into smaller modules, identified trends to increase efficiency for campaign operations and lead generation within CRM to acquire new customers, cross sell and reduce attrition
  • The technologies used were MS Word, PowerPoint, Access, Excel, Visio, ReqPro, Agile, Informatica, ClearQuest, SQL, SWIFT, Business Objects, Bloomberg, SAS

Confidential, Herndon, VA

Business Analyst

Project Scope: Fannie Mae is a government sponsored enterprise (GSE) of the United States government. FNMA's primary method for making money is by charging a guarantee fee on loans that they have securitized into mortgage-backed security bonds. Investors, or purchasers of Fannie Mae MBSs, are willing to let Fannie Mae keep this fee in exchange for assuming the credit risk, that is, Fannie Mae's guarantee that the principal and interest on the underlying loan will be paid regardless of whether the borrower actually repays.

The project involved user acceptance testing of the company’s core Servicer/Investor reporting system (SIR) which has accounting system as major component. It is an enhanced version of the legacy system LASER.1.0. The SIR system comprises of 40+ application systems, 1130+ interfaces and the objective of the testing was to provide confidence that the delivered system meets the business requirements of both sponsors and users. In this phase, the quality of the system was ensured by uncovering the defects that were not detected previously.

Responsibilities:

  • Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB
  • Used SQL queries for organizing and abstracting data from MS access databases, created reports, forms on MS Access.
  • Captured requirements for monthly SL to GL postings, calculating GL beginning and ending balances.
  • Captured Data flow diagrams and formatting of the data flowing through interfaces.
  • Performed workflow analysis, developed process diagram, and gathered the requirements for the new system.
  • Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
  • Utilized Popkin System Architect case for business procedures, processes, rqmts, data dictionary and data modeling.
  • Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
  • Installed and configured TIBCO products on both development and production environments.
  • Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
  • Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
  • Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
  • Facilitated user acceptance testing and test strategies with Information Systems Group.
  • Performed manual front-end testing to check all functionalities of different modules.
  • Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests)
  • Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
  • Trained the future users to coordinate their activities vis-à-vis CORD system rather than ARW.
  • Assisted the SA to document all custom and system modification after the SCR’s were satisfactorily solved.
  • Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the parties involved with respect to the evaluation criterion

Environment: JSP, Oracle , HTML, XML,DOORS, Clear Case, Clear Quest, XSL, Rational Rose, Agile, IBM business process modeler, TOAD, MS Visio, RUP, UML, MS Project, SQL, MS Access, MS Excel and MS Word

Confidential, Oklahoma City, OK

Business Analyst/ Data Analyst

Project Scope: MIDFIRST is a financial service company offering a variety of banking products and financial solutions like personal banking, small business, retail banking, home financing and equity loans, asset management, wealth management, corporate and investment banking and credit card services to its customers. Personal Banking involves opening and maintenance of checking, savings, recurring deposit accounts and personal loans. The web-banking project was basically an enhancement to the existing web application.

Responsibilities:

  • Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
  • Wrote Business Requirements, analyzed them and tested them.
  • Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Responsible for developing annual and mid-year operating budgets by underwriting departments and on a consolidated basis for review by reinsurance group senior management.
  • Worked with the Risk management team for the assessment of credit and liquidity risk
  • Gathered requirements from JAD/JAR sections with developers and business clients
  • Met with users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
  • Facilitated JAR sessions in the elaboration phase in order to elicit Functional Requirements
  • Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
  • Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
  • Responsible for writing Test cases to cover overall quality assurance using Test Director
  • Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
  • Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
  • Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
  • Develop and maintain sales reporting using in MS Excel queries, SQL in DB2, and MS Access.
  • Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
  • Experience in Maintaining Reference data Management System and Master data Management system with service oriented architecture (SOA).
  • Experience with OCR/ICR in data entry and data/text mining
  • Worked with the Structured data and Relational Database Management Services using Oracle, MS SQL Server, DB2 and MS Access.
  • Experience with writing/analyzing SQL scripts for various report and test results validation and data analysis.
  • Experience in Data Architecture and maintaining Relational Databases and Meta data registry.
  • Experience in using SAS for data management, data retrieval, data quality improvement ad statistic analysis
  • Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Crystal Reports XI/XI R2, Oracle 10g, SQL Server 2000, Java, OBIEE, Rational Suite, XML, VBA, Crystal Reports, Oracle, FileNet, OCR/ICR, UML, MS Project, MS Office, MS Visio

Confidential, Cleveland, OH

Business Analyst

Project Scope: The client objective was upgrading and maintenance of its Mortgage Application System. The Mortgage product is a fully integrated, Web-centric, real-time mortgage servicing solution that automates all mortgage servicing processes from loan origination, credit appraisal, credit enhancement, Escrow management, Foreclosure and payment processing. Our team worked with all the concerned business areas and was responsible for successfully provisioning the project from inception until transition to the bank.

Responsibilities:

  • Developed a business plan for sales growth in ENCOMPASS (loan origination and analysis software) that effectively measured the accuracy of marketing goal with respect to particular market trend, volume, scope and performance.
  • Prepared and analyzed complex reports from Genesis (Loan Origination System) and integrated data to financial databases.
  • Collaborated with Sales Vice Presidents and Directors when creating strategies to optimize advertising revenue.
  • Designed an effective Lead management system on Ellie Mae software known as Encompass.
  • Developed customized reports and designed automated data accuracy environment in MS excel for full portfolio Loan Modification monthly reporting data.
  • Performed credit analysis and develop reports for management review.
  • Worked closely with Portfolio Managers to gain a deep understanding of credit metrics and established lending procedures.
  • Established and maintained document library of company lending guidelines and implementation testing.
  • Used UML notations for Object Oriented Design and Documentation
  • Developed RUP Analysis Model that included entity classes, use case diagram, sequence diagrams using MS Visio that provided a view of the requirements.
  • 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.
  • Exposure in working with the Micro strategy ETL tool and instrumental in carrying out Data Validation -of various Source to Target Transformations.
  • Experience in Data and text mining for unstructured data and structured data
  • Worked in data retrieval and data quality improvement using SAS
  • 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, Genesis, ENCOMPASS, RUP, UML, Rational Clear Quest, Rational Clear Case, Rational Tools Suite, SQL, S loader, Windows, Unix, Java/J2EE, XML, HTML, Unit testing, GUI testing, system testing, Oracle, SAS, ERP

Hire Now