We provide IT Staff Augmentation Services!

Business Analyst Resume

Chicago, IL


  • Over 8 years of Business Analyst/Quality Analyst experience in all phases of SDLC life cycle, including requirements gathering, testing, defect tracking, management, and reporting.
  • 4 years of Onsite Coordinator experience in managing offshore team, giving training, online meetings, manage project status report, resource budgeting.
  • Comprehensive knowledge in Finance, Insurance (P&C, Reinsurance, Compliance, Audits) and Claims.
  • Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
  • Experienced in developing Data Mapping and Identifying Bottlenecks of sources, mappings, targets and sessions.
  • Strong understanding of Data Modeling in data warehouse environment such as star schema and Snow Flake schema.
  • Hands on experience in PL/SQL and UNIX Scripting.
  • Expertise on System support via Testing, Data Verification and Validation, production support, UAT and setting Business Processes.
  • Strong Knowledge and hands on experience of SDLC methodologies and Business Process Models (BPM) like Agile Modelling, Waterfall and Rational Unified Process (RUP) software development.
  • Skilled in preparing business requirements document (BRD), functional and technical specifications, systems design and requirements specifications.
  • Strong analytical and problem solving skills, capable of addressing relevant facts and recommending solutions and analyzed reports.
  • Experience in Data Transformation from various sources.
  • Experience in conducting Joint Application Development (JAD) sessions to converge early toward a design acceptable to the customer.
  • Facilitated User Acceptance Testing (UAT) and other requirements with the stakeholders and the business users.
  • Knowledge of testing and implementation of ISO statistical plans and rule changes, experience with P&C (Commercial lines of business)
  • Extensive work experience for Data Analysis like Day - to Day transactions of Policies - Premium/Claims processing, Expenses, Coverages, First Day Notice of Loss) and data workflow from source to reporting target.
  • Vast experience conducting and documenting the “AS-IS” and “TO-BE” processes and Business Process Re-engineering (BPR)
  • Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix RTM
  • Assisted QA team in Test Planning, Test data Preparation, Testing Execution and Defect Issue Resolution.
  • Experience in Project tracking, management, and reporting using MS Project and in doing presentations and recommendations to plant heads and corporate management.
  • Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision.


Methodologies: Waterfall, Agile, RUP, SDLC

Functional Areas: Requirement Gathering, Risk Analysis, Data Mining and Mapping, Data Trend Analysis, Quality Assurance, User Training, JAD sessions, Data Reporting, Data Warehousing, DataBase, Data Mart

Documentation Tools: Visio, MS Excel, MS Word & MS Power point, SharePoint

Project Management: Microsoft Project, Microsoft Office Suite

Defect Tracking & Logging: HP Quality Center a.k.a Mercury Quality Center, SNOW

Environment: MS Windows 98/2000/XP/7, SQL Server, z/os, UNIX

Other Software Knowledge: SAS, SQL, Tableau - 9, ETL processes


Confidential, Chicago, IL

Business Analyst


  • Monitoring regulatory changes promulgated by insurance offices and regulatory bureaus and create Requirement documents.
  • Making sure that regulatory update content, rates and forms releases are available immediately, implemented into our base system, and made ready and available to customers based on their schedule and choice
  • Managed Adhoc requests like data and requirement analysis in case of non-compliance issues.
  • Experience in analyzing, implementation and testing of ISO statistical plans and circulars changes/updates.
  • Created Requirement documents and technical design documents for Statistical plan changes.
  • Maintained different versions of the project documents using Project Artifacts and Documented the ‘AS-IS’ and ‘TO-BE’ process.
  • Analysis of the queries requested by Regulatory Agencies and provided solutions and make sure to implement the same in the system.
  • Mapping of the new fields/attributes introduced in the Statistical Plan and report the same in filings.
  • Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).

Environment: Insurity, ServiceNow, ISO compliance tool, MS Project, MS Office, SAS, SQL, Mainframe, SharePoint

Confidential, Northbrook, IL

Business Analyst


  • Business requirements gathering: Gathering requirements and analyzed the requirements. Understand and translate Business Requirements from business uses into Business Requirement Specifications (BRS)
  • Conducted JAD sessions with management, SME and other stakeholders for open, pending and critical issues along with Requirement gathering.
  • Conducting Web demonstration of application to business stakeholders, QAs, Developers and Users.
  • Assisted QA Team in writing test cases, Data mapping and conversion, test plans and tested the final application to verify whether all the User Requirements were catered to by the application.
  • Proactively worked with developers and business analysts to assure critical and severe defects reduction before integration and system test.
  • Conducted User Acceptance Testing (UAT) and Coordinated with third party vendors: Liaison with third party vendors to identify data elements for product mapping requirement such as ISO reporting.
  • Maintained different versions of the project documents using Project Artifacts and Documented the ‘AS-IS’ and ‘TO-BE’ process.
  • Mapped source to target: Developed data maps to track transformation of data elements from source to target
  • Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
  • Co-ordinated pre-release and release processes including change control, production migration and performed SOX approvals.

Environment: Insurity, SNOW, MS Project, MS Office, SAS, SQL, Mainframe, SharePoint, Informatica

Confidential, Northbrook, IL

Business Analyst


  • Conduct comprehensive financial audits, federal and state compliance audits, and agreed-upon procedures.
  • Perform analytical procedures/analyses to detect unusual financial statement relationships.
  • Perform internal control and substantive testings.
  • Identify and communicate accounting and auditing matters to seniors and managers.
  • Gathered requirements from the business users, Compliance and Operations teams.
  • Communicated with business users to identify required data to be extracted from the back end systems.
  • Managed and worked on all Compliance Audits and Market Conduct Exam.
  • Managed all Post-Audit deliverables that includes Data Transfer, Data Upload, and coordination with vendors and provided support to other teams for file transfer process.
  • Managed adhoc requests like Data analysis in case of out of compliance.
  • Documented project processes and procedures, and version controlled in SharePoint.
  • Performed manual Back-End testing by writing SQL queries for validating user information available in the tables.
  • Monitored and tracked projects, ensuring project utilization of project resources.

Environment: MS-EXCEL, Visual Basic, SAS, SAP, SQL, SharePoint, Data Warehouse, Database, Data Mart

Confidential, Northbrook, IL

Business Analyst


  • Led implementation, testing, training and support for back-end reporting tools.
  • Prepared Business Requirement Document (BRD), Functional Specification and Use cases.
  • Developed Process flow diagrams and Sequence diagrams to enable developers and other stakeholders understand the business process better.
  • Created a process document to depict the flow of critical information.
  • Compiled data analysis, sampling, frequencies and stats using SAS on mainframe
  • Managed documentation and process flows for internal teams and client project teams.
  • Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
  • Created system specification/technical documents.
  • Developed training material and trained staff; performed knowledge transfer and ongoing client support
  • Evaluated process flows and procedures and user application interfaces
  • Developed project plans, managed project resources, managed project status, managed time lines, deliverables and documentation, and met client expectations
  • Supported users in developing reports for data analysis and trend analysis using SAS Report (Mainframe tool)
  • Analysed the Existing System and created the As-is Systems
  • Created Business process model To-Be Systems for various Applications using MS Visio.
  • Assisted in the User Acceptance Testing by writing test cases and checking the same.

Environment: EAZYTRIEVE, XCOMS, TSO/ISPF, SCLM, MS Office (MS Word, MS Excel, MS PowerPoint), ServiceNow


Programmer Analyst


  • Use of SPEC tool, assembler complex coding to translate the financial and statistical data into required State regulatory agencies format.
  • Testing of production data and fixed the errors before submitting it to State Regulatory Agencies.
  • Involved in creating filling for agencies monthly, quarterly, semi-annually and annually.
  • Analyzing the errors and correct it by using SPECS and build intermediate files.
  • Involve in writing SPEC tool which is Company developed translation tool.
  • Refilling the data quarterly, monthly if any issues reported by State regulatory agencies.
  • Provide production support to personal and commercial jobs which runs monthly and quarterly, ensure that financial and statistical data is as per State regulatory agencies format.
  • Responsible for defect fixing in Assembler and Spec programs.
  • Execute the test plan, regression testing, complete verification and validation.
  • Created SAS programs for providing the data in requested format.
  • Responsible for reconciliation of data with Financial Data Warehouse.

Environment: SPEC, JCL, Assembler, SAS, EAZYTRIEVE, COBOL

Hire Now