sr business analyst resume example with 12+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • H: (555) 432-1000
  • C:
  • Date of Birth:
  • India:
  • :
  • single:
  • :
  • Over 7+ years of IT experience working as a Business Analyst and Oracle Database Administrator in various industries such as Insurance, Financial, Technology and Healthcare.
  • Experience working as a Business Analyst with knowledge of SDLC, requirement documentation, requirement elicitation, Quality Assurance and Project Coordination.
  • Experience working with the Quality Assurance team in area of preparing test cases, defect tracking, User Acceptance Testing (UAT) and documentation of test cases.
  • Experience in preparing Business & Functional requirement documents.
  • Experience in managing Product Backlog and Sprint Backlog.
  • Experience in conducting Joint Application Development (JAD) sessions with Project sponsors and Development team.
  • Interacted and coordinated between end-users, expert team, UX team, development and QA team and suggested key enhancements and changes to the business flows.
  • Experienced in full system development life cycle, from requirements gathering and business case development to maintenance and project management using Agile and Waterfall Methodologies.
  • Experience in using business modeling tools such as MS Visio to generate data flow diagrams, process maps, flowcharts and UML diagrams.
  • Experience working with UI/UX designing and development team and knowledge of UI/UX design methodologies such as wire framing, prototyping, Use Cases, Work Flow Diagrams, and Activity diagrams.
  • Experience in coordinating project schedules, resources and information.
  • Attended client meetings and assisted with determination of project requirements.
  • Strong expertise in Client Relationship Management, worked as a liaison between businesses, technical and non-technical departments within organizations.
  • Created and maintained comprehensive project documentation, plans and reports.
  • Excellent multitasking skills and effective time management skills.
  • Have good analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and can work as a part of a team as well as independently.
  • Strong communication skills in engaging business stakeholders, subject matter experts and end users in gathering the intricate working of business process through different Requirement Elicitation Techniques.
  • Effective hands-on business professional with solid business understanding, strong technical skills, outstanding communication and interpersonal skills as well as effective organizational and team building qualities.
  • Microsoft Office: Excel, MS Word, PowerPoint, MS
  • Visio, MS Project
  • SDLC Methodologies: Waterfall, Agile, SDLC
  • Databases: MS SQL Server, Oracle, Excel, Access
  • Quality Assurance/Defect Tracking Tools: JIRA, Rally, Quality Center, Clarity
  • Languages: Sql, PL/SQL, Unix Sehll Scripting, T-SQL
  • Tuning Tools: TKPROF, EXPLAIN PLAN, STASPACK, SQL ADVISOR, performance analyzer

  • UX and Web Development Tools: Axure RP Pro, Balsamiq, Microsoft Visio, Lucid Charts
  • Content Management Tools: WordPress, SharePoint, Open Text, Wix
  • Operating Systems: RHEL, HPUX, AIX, Sun and Windows
  • RDBMS: Oracle 12c, 11/10g, 9i, Sql Server 2005/ 2008
  • Tools: SQL Performance Dashboard, RMAN, OEM, sqlldr, exp, imp, expdp, impdp, dbconsole, asmcmd, confio, query Analyzer
Sr. Business Analyst, 08/2014 - Current
Burlington Coat Factory Corporation Warren, MI,

New York Life Insurance Company is the largest mutual life-insurance company in the United States and one of the largest life insurers in the world. The Project was to develop eAnnuity application which gives agent correct form generation, a simplistic eSignature solution, and a user friendly interface that allows them to collect only the information necessary for the cases. This application was available to 200+ agents for variable annuities, fixed and income annuities.

  • Collaborated with business partners from multiple disciplines to elicit, document, prepare and manage business requirements package for stakeholder sign-off and delivery to technical teams.
  • Established meaningful traceability between related requirements.
  • Acted as a liaison between the business and IT design and delivery teams.
  • Documented requirement artifacts utilizing industry standard diagram techniques to enhance the clarity of definition, including: process flows, context diagrams, use cases, wireframes, etc.
  • Interfaced with Business Partners, Technical resources (i.e.
  • Solution Engineers, Systems Analysts, Developers, Architecture, and Quality Assurance) to translate and simplify requirements, ensure requirements are met throughout entire SDLC framework, and verify that the implemented solution meets the requirements.
  • Partnered with QA team and SMEs to ensure adequate test coverage.
  • Interacted with various end user teams during beta testing to gather feedback on application usability.
  • Involved in creating Test Strategy for User Acceptance Testing (UAT).
  • Worked on Jira to help the Quality Assurance team in defect tracking.
  • Assisted the Project Manager & Senior Business Analyst in communicating to project stakeholders on project progress and risks and collected feedback.
  • Provided project support to the Project Manager & reviewed the efficiency and effectiveness of service delivery.
  • Worked with stakeholders to conduct training sessions/demos, and to develop manuals /user guides.
  • Identified and articulated the need for requirements change and assessing the impact of the change.
  • Followed the Agile methodology.
Business Analyst, 09/2012 - 08/2014
Associated Bank Burnsville, MN,

Western Union is an American financial services and communications company. It has several divisions, with products such as online money transfer, money orders, business payments and commercial services. The project consisted of developing a comprehensive online money transfer system, mobile application to allow the customers to effectively manage their accounts. The application allowed the users to transfer funds between accounts, view statements and utilize check free electronic billing services. The redesigned system made self-service activities more user-friendly and provided simpler and swifter navigation and seamless integration of various money management functions.

  • Participated in using the Agile Methodologies on projects utilizing full Systems Development Life Cycle (SDLC), while using MS SharePoint for storing project documents.
  • Conducted workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements about the online money transfer experience.
  • Conducted requirement gathering sessions with the purpose of creating User Stories, Epics, and Features created for the various releases through-out the year.
  • Quick ability to identify, research, investigates, analyze, define and document business processes.
  • Responsible for identifying and documenting business rules and creating detailed Use Stories.
  • Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
  • Act as a resource in understanding how IT systems carry out business functions and assist in ensuring the timely and effective implementation of projects.
  • Designed and developed Use Stories, Activity Diagrams, Sequence Diagrams using UML and MS Visio.
  • Assisted with user testing of systems to validate configuration processes for HR, payroll, and benefits transactions, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
  • Assisted in development of training materials for new technology and process improvements.
  • Interacted with team to review and develop XML data standards as well as develop and review data exchange or data sharing models.
  • Experience creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
Oracle DBA, 06/2010 - 07/2012
Computer Aid Charleston, WV,
  • Planning, implementing various versions of Oracle Databases to 9i, 11G R2, 12c, installation and upgrade.
  • Served in an administrative role regarding database privileges, security,.
  • Implementing High Availability Oracle Golden Gate from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11Grr2 RAC Environments.
  • Performed Database Migration from Oracle 10g to Oracle using Golden Gate.
  • Worked on Rman duplication, cross-platform transportable tablespaces.
  • Performed Oracle software installations, creation of new standalone and clustered databases.
  • Administering and setting up of 11g RAC and 12c RAC cluster ware and instances.
  • Resolved RAC issues.
  • OCR related issues, rebooting of faulty nodes, relocating and switched over services.
  • Established database backup/recovery strategy for different databases.
  • Utilized RMAN for backup and recovery strategy.
  • Completed export and import of different database using datapump and SQL.
  • Loader.
  • Setup and trouble-shoot the Oracle physical Data Guard for disaster recovery purposes.
  • Identify the database performance issue, analyze AWR reports, check and explain plans of SQL queries and provide solution for performance issues.
  • Maintain the stats of large partitioned tables in Data Warehouse databases to help fix the long-running SQL query performance by gathering/locking/export/import table statistics.
  • Upgrade databases and applied patched.
  • Experienced with ASM, adding, deleting disks to diskgroup.
  • Scheduled RMAN backups, purge jobs, Maintenance jobs, using DBMS_JOBS, DBMS_SCHEDULER and Crontab.
  • Supported development teams for all database related issues and handled critical issues like network failures, and ASM DISK group errors, node failures in RAC clusters.
  • Used explain plan, oracle hints and creation of new indexed to improve the performance of SQL statements.
  • Supported development teams for moving changes to different dev, test, and prod environments.
  • 24/7 on-call support for production environment.
  • Set up 11G Grid Control and 12c.
  • Monitored databases using OEM, re-organization of database tables and indexes.
  • Creating new user accounts, assigning roles and responsibilities.
  • Hot and cold backup cloning of instances.
  • Performed migration of database from 9i and 11g on linux.
  • Upgraded the databases from 9i and 10g to 11g and resolving the issues during upgrade.
  • Worked on RMAN backup and recovery.
  • Recovered the databases (full recovery) during database upgrade and point in time recovery as per the user request using RMAN.
  • Created DB links (private and public), synonyms and views.
  • Validated the views and compiled the views which are invalid.
  • Responsible for monitoring the daily jobs and resolving and finding reasons for failed jobs.
  • Used Toad.
  • Provided 24/7 support.
Business Analyst, 05/2010 - 06/2012
Associated Bank Columbus, WI, The Guardian Life Insurance Company of America is a Fortune 300 company in New York. It is one of the largest mutual life insurance companies in the United States. Guardian sells a variety of products including Life insurance, Disability insurance, Dental insurance, 401(k), and annuities. The project was to enhance the Individual Markets Portal by initiating redesign of portal for better experience and promote customer service excellence by enhancing the website's usability.  
  • Reviewing & gathering of business requirements with the business and creating business analysis process.  
  • Analyzing and identifying gaps in existing system comparing and contrasting with documented business requirements, As-is system and the To-be system.
  • Created detailed Functional Requirement Specification (FRS) and Non-Functional Requirements for Individual Market Portal Project based on the approved scope document.
  • Facilitated JAD sessions and workshops required to understand workflows, business needs and storyboards.  
  • Conducted Scrum meetings on regular basis.  
  • Kept the Product Owner & Project Manager informed about project status and issues that may impact client relations.
  • Attended client meetings and assist with determination of project requirements.  
  • Organized meetings, team celebrations, between team members and clients.  
  • Recorded minutes at meetings & kept detailed project notes and records.  
  • Worked with cross functional team like UX, design, development, QA, marketing and different Line of Businesses.
  • Generated Use Case diagrams, Activity diagrams, Business Object to depict process flows and PowerPoint presentations.
  • Performed User Acceptance Testing (UAT) for various web based and database related applications.  
  • Worked on defining the sprint scope and oversee the BA schedule and deliverables.  
  • Worked with IT to design and develop data collection and management tools to manage the information.  
  • Created a roadmap for the Internal Communications department to enhance the overall employee engagement and increase productivity.
Education and Training
Bachelor of Science: Computer Science, Expected in
University of Karachi - ,
Status -
: MISM, Expected in
DeVry University - ,
Status -

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • University of Karachi
  • DeVry University

Job Titles Held:

  • Sr. Business Analyst
  • Business Analyst
  • Oracle DBA
  • Business Analyst


  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: