Business Analyst Resume
Waukegan, IL
Business Analyst with seven years experience in Financial Services and Healthcare industries.
Professional Summary:- Seven years experience as a Business Analyst with extensive knowledge and experience across the project life cycle in Software Development Life Cycle (SDLC) in the fields of Health care andMortgage industry plus domain knowledge of Logistics, Finance, Accounting and trading industry.
- Excellent analytical, organizational, communication and documentation skills to gather requirements which brings out quality product
- Excellent understanding of the Business process, functionality and requirements to translate them to system requirement specification.
- Excellent problem solving skills with the ability to handle multiple tasks effectively and quickly master new conceptsandsubjects.
- Documented and managed requirements in Rational Requisite Pro, JIRA and Excel.
- In-depth understanding of business processes such as the AS-IS and TO-BE approaches and experience in converting these requirements into technical specifications for preparing test plans.
- Strong visual modeling and business process modeling skills using Rational Unified Process (RUP) with tools like Rational Rose and MS Visio.
- Experienced in developing Use Case Models, Entity Relationship Diagrams (ERD), Activity Diagrams, State Diagramsand Data Flow Diagrams (DFD).
- Maintained Requirement Traceability Matrix (RTM) throughout the lifecycle of the project to keep the stakeholders informed about the progress of the project.
- Led Joint Application Development (JAD) sessions to expedite and streamline the requirement gathering process.
- Experienced in developing Use cases with complete alternate flows, business rules, exception messages and system rules.
- Expertise in writing and implementing test plans, test scenarios, test cases, traceability matrices for Black Box, System Testing, Integration testing and User Acceptance Testing.
- Experienced in writing SQL queries to manipulate Oracle database and performing manual testing.
- Good Knowledge of Rational Clear Quest, Quality Center and Test Director Tools for defect management & generating required reports.
KEY ROLES
- Business Analyst
- Requirements Analyst
- IT Analyst
DOMAIN EXPERTISE
- Mortgage
- Healthcare
- Finance /Accounting
- Logistics/Warehousing
KEY COMPETENCIES
- Structured Business Analysis
- Adopting Use Case Methodology for Enterprise Systems
EDUCATION
- Masters in Business Administration ( Marketing)
- Bachelors in Science, (Mathematics)
SKILLS
- Business Process Modeling and Technical Writing skills
- Analytical and Problem solving skills
- Negotiation and Decision making skills
- Presentation and Public speaking skills
TECHNICAL SKILLS:
- Business Modeling UML, Rational Modeler, MS Visio
- Documenting Management SharePoint, JIRA, MS Office.
- Requirement Management Rational Requisite Pro, JIRA
- Change/Repository Management Rational Clear Quest, Rational Clear Case,
- Méthodologies RUP, Water fall, Agile, scrum
- Databases SQL Server 2005/2008 R2, Oracle 11g, MS Access,
- Operating Systems MS-DOS,Windows (98, 2000, NT, XP)
- Testing Tools QTP, Load runner, Win runner.
- Defect Tracking Rational Clear Quest, HP Quality Center, JIRA
- Reporting and DB connectivity Crystal Reports, SSMS,TOAD
PROFESSIONAL EXPERIENCE
Client: Confidential, Waukegan, IL April 2012- CurrentProject: Integrated Laboratory Informatics Solution
Position: Business Analyst
Confidential, is a global, broad based health care company devoted to the discovery, development and marketing of pharmaceuticals and medical products, including nutritionals, devices and diagnostics. The company employs approximately 91,000 people and markets its products in more than 130 countries.
Project: The project to develop a Web-based, integrated laboratory informatics solution named One Lab. One Lab is a highly-configurable platform that unites most of a laboratory\'s information and decision tools into one system, allowing labs to manage data with a single user interface. The solution was comprised of three applications: Smart Center, Inventory Manager and Decision Center
Benefits of the system were: Smart Center which is a Web-based laboratory process management and control application that provided robust connectivity to instruments and a single point for consolidated information. The built-in functionality enabled the automation of complex clinical laboratory protocols, leading to improved productivity and standardization of best practices. Inventory Manager which is a inventory tracking and order management system that utilized Radio Frequency Identification (RFID) and provided an automated solution to improve the accuracy of order entry, inventory count and usage, while reducing the labor required to track supplies . Decision Center is a better business performance application which uses advanced database technology to integrate data from multiple sources and quickly structures it into visually accessible formats.
Responsibilities:
- Created targeted questionnaires for SME to gather requirements and understand the business process goal from stakeholders
- Studied and analyzed competitor's applications and brainstormed to gather effective requirements for a better quality in the product.
- Provided primary liaison between Client and development team, providing adequate information to project team for development of application.
- Performed JAD sessions and interacted with stakeholders to discuss problem issues and describing common goal of project.
- Conducted workflow, process diagrams and GAP analysis to derive requirements for existing systems enhancements.
- Used Rational Requisite Pro to document stakeholders' requests, software requirements specifications and traced it to use cases.
- Developed Use case diagrams, Activity diagrams and sequence diagrams to validate different business processes. Used UML to formalize business modeling and data modeling
- Actively participated in Pre-Testing that included review of the requirement documents, studying the use cases for developing test plans and collection of test data.
- Designed and Documented Test Procedures and Test Cases for user acceptance, functional and integration testing.
- Verified business scenarios on new builds to allow extended testing by the QA team and also helped the testing team to expedite User Acceptance and Regression testing to meet the production date.
- Worked with Technical lead and development team to ensure that they understand the specification.
- Managed Traceability Matrix to trace Business Requirements, Functional Requirements, Business rules, Use Cases and Test Cases.
- Assisted in system and user acceptance testing (UAT), perform client presentations, demos and training.
Environment: MS Office Suite, MS Project, MS SharePoint, Rational Requisite Pro, Rational Modeler, Rational Clear Quest, Oracle, Java J2EE.
Client: Confidential, Oklahoma City, OK Feb 2011- March 2012Project: Electronic Medical Record system
Position: Business Analyst
Confidential, including The Children\'s Hospital at OU Medical Center is Oklahoma\'s largest and most comprehensive hospital. It is located in the heart of Oklahoma City
Project: The project was to build a Physician Support System to capture the outpatient clinical data using an Electronic Medical Record and Electronic Health Record Management System. The purpose of this system was to have a Paperless Medical Record and instant retrieval of data and laboratory records by the doctors, especially for Behavioral and Mental Health Record Systems. The patient's medical record contained information such as physical examination and information specific to the medical discipline
O.U. Medical Center contracts with numerous participating third-party payers to create a master database of prescription information (including the drug name, prescriber, dosage, instructions, pharmacy and the fill date). The database is continuously updated with the most current information. By interfacing this database with a healthcare provider's Patient Admission Information Records System (PAIRS), O.U. Medical Center can search for our patients' recent medication information. Within seconds of admission O.U. Medical Center can retrieve 12 months outpatient medication data and distribute it to the physicians and pharmacists within the healthcare provider's facility.
Benefit resulted in improved patient care, increased efficiency, lower costs, and full compliance with the Joint Commission's medication reconciliation requirements.
Responsibilities:
- Collaborated with project stakeholders throughout all SDLC phases to ensure timely delivery of specified business solutions.
- Worked as a liaison between business users, testers and application development team and helped them in understanding and validating the business requirements.
- Identified various business processes and developed process flow diagrams and validated with Subject Matter Experts.
- Conducted JAD sessions to elicit requirements from medical personnel while ensuring feasibility with technical leads.
- Managed Traceability Matrix to trace Business Requirements, Functional Requirements, Business rules,Use Cases and Test Cases.
- Recognize scope limitations and raise potential scope issues while designing the best system approach.
- Defined business scope and assumptions, recommended changes in the existing system to eliminate gap between as-is and to-be capabilities
- Handled and organized deployment activities and performed post- deployment verification of the systems after the cutover.
- Involved in preparing "BRD" Business requirement Documents for EDI 5010.
- Prepared "FSD" functional specification document for EDI 5010 from 4010A.
- Analyzed existing systems and performing feasibility and impact analysis for new projects and enhancements. Responsible for producing High level Design Documents, TRD for ICD 9 to ICD 10
- Performed the detail comparison between 4010A and 5010 to identify differences across loop Structures.
- Performed the detailed business analysis across line of business (LOB), transaction types.
- Worked on Facets for EDI transactions.
- Tested data to check HIPAA implementation with data mapping source to target.
- Knowledge and experience on Claims Billing, Claims ,Payment Processing in relation to HIPAA, EDI 4010 codes 834, 835, 837, 270, 271
- Involved and worked updating the official changes to the tabular list, instruction manual and alphabetical index of ICD- 9 to ICD-10 in regards to data transactions and Data mapping
- Performed data mapping for 5010 and ICD 10 codes.
- Conducted manual functionaltesting and back-end databasetesting using SQL queries
- Identified various business processes and developed process flow diagrams and validated with Subject Matter Experts.
- Documented supplemental specifications and UI specifications for the system.
- Reviewed, coordinated and executed test plans for the project and ensured that the test cases and the results meet the requirement.
- Assisted Business User during deployment in formulating User Acceptance Testing (UAT) for customized application and getting confirmation for product Release
- Reviewed test cases to ensure accurate and complete testing of user requirements.
- Developed more than 20 Ad-hoc reportsusing Crystal Reports and SQL that provided business with access to data
- Trained the end user in the use of new and existing capabilities of the system.
Environment: .Net 2008, SSMS 2008, SharePoint, HP Quality Center 11.0, MS Visio, MS Office, MS Project 2010, SQL, Crystal Reports.
Client: Confidential, Springfield, IL Dec 2008- Jan 2011
Project: Provider Management systems
Position: Business Analyst
Confidential, is one of Illinois\' largest agencies, with more than 13,000 employees and an annual budget of over $5.4 billion. Illinois created DHS in 1997, to provide our state\'s residents with streamlined access to integrated services, especially those who are striving to move from welfare to work and economic independence, and others who face multiple challenges to self-sufficiency.DHS is proud of its diversity, efficiency, and the services that the agency and its community partners provide to Illinois citizens.
The Project was to develop web based applications in the Pre-Admission Screening (PAS), Temporary Assistance for Needy Families (TANF) and Provider Management systems
Benefits of the system were help the Providers of DHS with ensuring compliance with applicable Federal and State laws, arrange for and conduct assessments, making necessary determinations regarding eligibility for services, and providing linkage to appropriate and needed services
Responsibilities:
- Provided key project inputs by working with users in entire phase of SDLC in defining the project and system requirements and Monitored client expectations and conducted user interviews.
- Facilitatedrequirements meeting, group discussions with business users and subject matter experts (SME) to elicit requirements.
- Worked extensively on the documentation of the scope of the Project, Functional RequirementDocument and Data Requirements
- Identified the scope of the projects through one-one meetings, Requirement session and designed the Business Requirements Document.
- Played a key role in the planning, testing, and implementing system enhancements and conversions
- Facilitated JAD sessions for capturing the Project requirements for achieving synchronization with the Client.
- Used RUP with most of its supporting tools - IBM Rational RequisitePro, Clear Quest to implement the Requirement and Change Management respectively
- Researched operational procedures and methods and recommended procedures for improvement - with an emphasis on automation and efficiency.
- Documented Use Cases, their alternate flow, Business Rules, and System Rules for each functionality with users inputs and coordinated user sign off meetings.
- Documented clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to organization guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.
- Reviewed test cases written for unit and system testing and Effective coordination between development team and testing team
- Worked extensively on SharePoint as user and Administrator. Created sites, lists, maintained user profiles and users.
- Conducted manual functionaltesting and back-end databasetesting using SQL queries.
- Conducted UAT on various occasions and supported business users to do the same.
- Assisted Test Lead, Testers understanding business process and help them successful completion of Unit Testing, Integration Testing and Requirements Testing.
Environment: MS Office Suite, MS Project, MS SharePoint, Rational Requisite Pro, Rational Modeler, Rational Clear Quest, Oracle, Java J2EE.
Client:Confidential, Englewood Cliffs NJ Oct 2007- Nov 2008Project: Loan Management
Position: Business Analyst
Confidential, is serving homeowners and prospective homeowners with over 20 years of combined mortgage experience and a wealth of real estate knowledge. The project involved working with several teams to develop an enterprise Web-based interface system supporting primarily the mortgage loan origination and processing. This application facilitates loan officers and underwriters to maintain loan origination, Escrow analysis and Loan processing.
Project: The project was to develop an application that can serve as Stanley capital's front end internet system that would tie-in with "Loan Work" and serve as an end-to-end solution for customers to avail competitive quotes, compare rates, assess qualification criteria, eligibility for home equity products, checking the application status and closing formalities.
The project aimed at facilitating complete mortgage transactions online and to minimize customer service costs. The application also included a mortgage guide, that navigates the online user right from the pre-approval process to the closing interactively, complementing phone and web support at critical junctures.
Benefits of the system were: Increased scalability, shorter time to automate newer loan types, detailed investor reporting
Responsibilities:
- Designed the business requirement collection approach based on the project scope.
- Facilitated JAD sessions with SME's in understanding the requirements pertaining to Loan Origination to Loan Processing.
- Developed business Requirement specification documents as well as high-level project plan
- Performed Requirements Gathering & Analysis and prepared the requirements specification document for the application.
- Conducted workflow, process diagrams and GAP analysis to derive requirements for existing systems enhancements.
- Developed Use case diagrams, Activity diagrams and sequence diagrams to validate different business processes. Used UML to formalize business modeling and data modeling
- Worked with Technical lead and development team to ensure that they understand the specification.
- Managed Traceability Matrix to trace Business Requirements, Functional Requirements, Business rules, Use Cases and Test Cases.
- Designed and developed project document templates based on SDLC methodology.
- Provided day to day project management and analytical leadership and worked collaboratively with the PSI project lead to ensure the project is executed in an efficient and effective manner.
- Provided basic end user support in post deployment phases and supported the assessment and evaluation feedback.
- Obtained Verification sign offs (VSO) for all major milestones.
- Assisted in system and user acceptance testing (UAT), perform client presentations, demos and training.
- Facilitated walkthroughs with business SME's from loan origination, processing,underwriting and closing domains.
- Involved in assisting project manager in planning, scheduling, and controlling projects based on schedules and requirements outlined by the business.
- Worked extensively on SharePoint as user and Administrator. Created sites, lists, maintained user profiles and users.
Environment: MS Visio 2003, SSMS, SQL Server, SharePoint, Windows 2000, MS Office Suite, Mercury Test Director, win runner, JIRA, Crystal reports.
Client: Confidential, Littleton CO. Aug 2006- Sep 2007Project: Loan Management
Position: Business Analyst
Confidential, provides banking, insurance, investments, mortgage, and consumers and commercial financial services across North America and internationally. It is one of the nation\'s leading mortgage lenders offering conforming, government insured or guaranteed mortgage products, Jumbo and Fannie Mae products directly to consumers. Aurora bank has experienced success by providing exceptional customer service and a wide range of competitive mortgage products.
The Project: The loan modification application was to keep track of all delinquent and defaulted mortgages and to notify the home owner about the loan modification program. I was involved in the loan modification of existing lending application of single family loans to help remediate the increased rate of foreclosure to new and existing properties. The purpose of this application was to track all the customers who had trouble making their last payments and calculate revised payment schedule.
The system's key capability was the Amortization Engine to calculate the revised loan payment schedule based on the loan modification for fixed rate mortgage and Adjustable Rate Mortgage products. This allowed service professionals to provide various options to the borrower based on the Fair Market Value and Debt to Income Ratio. The system also processed an electronic deed-in-lieu to allow the borrower to accept loan medication terms and foreclosure.
Benefit: The system was able to notify the Business User / Loan Officer as soon as a customer failed to make a payment past the grace period. Once the loan became delinquent the customer would be flagged and Aurora Bank would then work with them to save their property by revising payment schedules.
Responsibilities:
- Participated in team to elicit, organize, and document required functionality and constraints by engaging in iterative requirements gathering sessions with the various business users in the projects, including company employees, brokers, and analysts.
- Partnered with Business Users and Subject Matter Experts (SMEs) to understand the project scope and business requirements.
- Identified various business processes and developed process flow diagrams for the pre-approval business processes and validated the processes with SMEs.
- Involved in building functional specifications and test plans/efforts for the Customizable Loan Reporting module.
- Performed To-be analysis by Identifying, validating and implementing changes to incrementally improve process efficiencies.
- Identified processes for developing and documenting detailed business requirements.
- Created Business Rules Spread documents for To Be systems.
- Collected data from end-users and analysts to create Use-Cases and Requirements documents to document business needs.
- Gathered requirements through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and other potential users of the application.
- Reviewed use cases and identified gaps leading to improvements and enhancements.
- Played a pivotal role in the evaluation of change requests to ensure they are properly integrated with existing application functionality or recommend modifications that will be consistent with the direction of the application.
- Designed and developed UAT scenarios based on business requirements
Environment: MS Visio 2003, SSMS, SQL Server, Windows 2000, MS Office Suite, Load Runner, JIRA.
Employer: Confidential, Hamilton, NJ March 2003 - May 2006Position: Manager (Accounting & Administration)
Confidential, is a major producer & importer of frozen fruit, vegetable and milk products in to United States, Canada & UK. Global entered into an exclusive arrangement with Himalya International Ltd. to develop a 100% vertically integrated mushroom and vegetable growing operation. There food processing lines are dedicated to creating and producing unique vegetables, dairy products, meals, soups, appetizers and desserts.
Responsibilities:
- Managed financial records, Bookkeeping using QuickBooks ERP & office administration.
- Managed clearance of Imports & Export shipments from Customs, Port Authority, FDA, USDA, and Agriculture Depts.
- Managed activities associated with Invoicing, Inventory control,shipping, receiving, distribution & logistics for Inland, air and Sea.
- Directed & coordinated activities of business concerned with production, pricing, sales and distribution of products
- Managed Coordination between manufacturing plant & Customers. Managed requests, Purchase orders from new & existing customers, contacting them for open invoices & also negotiate collection of overdue invoices.
- Developed new ethnic food business transaction in US, UK & Canada through extensive networking & marketing research.
Position: Marketing Executive
Confidential, are the oldest and largest overnight worldwide Logistics as well as one of the leading international courier. For over 30 Years they have been providing international courier & logistics services to businesses and individuals around the world. They have a solid international network and serve several markets in the USA, Europe, the Far East, Middle East and Asia
Responsibilities:
- Developed marketing and sales strategies designed to promote service awareness about ICC worldwide couriers.
- Coordinated & visited International clients on a regular basis for procurement of logistic business.
- Developed Aggressive new accounts which resulted in 10% increased in business.
- Negotiated large company contracts & corporate field contracts.
- Monitored account performance, maintained and reactivated existing accounts in India & United States.
- As certain client needs and cost parameter, formulated appropriate service package, made effective sales presentation.
- Developed loyal customer's base and increased logistic volume through personalized service.
- Cultivated & maintained profitable relationship with 200 corporate clients.
EDUCATION
Masters in Business AdministrationBachelors of Science (Mathematics)