SUMMARY

• 8+ years of experience as a Business Systems/ Data Analyst.
• Knowledge of Project management skills such as time estimation, task identification, risk analysis and scope management and resource management.
• Ability to act as a liaison with different stakeholders of the project as well as business analysts, quality assurance team, Developers, Management, technical writing team.
• Class diagrams development and UML modelling using modelling tools like MS Visio.
• Conducted Joint Application Development (JAD) sessions with relevant Subject Matter Experts to assess and document current configuration, coordinating extensive communication networks - interviews, written correspondence, Reports, Implementation requirements, project status reports, oral presentations, e-mails, etc.
• Experience working in CRM systems.
• Expertise in understanding the business process from taking a requirement from a systems record to a centralized warehouse.
• Outstanding communication skills and the ability to work effectively with technical teammates in order to translate business requirements into an effective technical solution and serve as an effective communication channels between the key IT and business contacts.
• Strong Knowledge and hands on experience of SDLC methodologies and Business Process Models (BPM) like Agile Modelling, Agile Unified Process (AUP), Waterfall, Rational Unified Process (RUP), Scrum and XP software development.
• Skilled in preparing business requirements document (BRD), functional and technical specifications, systems design and requirements specifications, Requirements traceability matrix.
• Authored business and system requirements analyses and functional specifications with supporting business process flows (data modeling), Traceability matrices, Risk Analysis.
• Expert in Use Cases, Sequence diagrams, Activity diagrams, Collaboration diagrams.
• Charted business requirements for mid-size to large organizations. Adept in gathering business requirements pertaining to functional, non-functional and data aspects of the business. Held meeting with stakeholders and end-users to determine needs and necessities.
• Good experience in documenting existing process, analyzing business requirements, working with requirements traceability matrix and re-engineering business processes.
• Proficient in creating Use Case diagrams, Class diagrams, State Transition Diagrams and Activity Diagrams using UML methodology in MS Visio.
• Facilitated weekly and monthly business review meetings to keep SME's, Stakeholders, executive staff and team members apprised of goals, project status with timely identification, tracking, resolving issues and conflicts and preparing product demonstrations.
• Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, My SQL, MS Access and Excel
• Extensive experience in creating and maintaining source to target data mapping documents
• Experience in Project tracking, management, and reporting using MS Project and in doing presentations and recommendations to plant heads and corporate management.
• Strong documentation and analytical skills, strong problem-solving skills.
• Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision.
• Extensive work experience in ReservePro for Analyzing data loss, Premium/Claims processing, data workflow & Analysis process.
• Vast experience conducting and documenting the "AS-IS" and "TO-BE" processes and Business Process Re-engineering (BPR) exercises according to the Rational Unified Process (RUP) and UML development methodology and Continuous Improvement techniques.
• Experience in the documentation of system and business requirements and specifications, design and development of use and test-case scenarios and root-cause analysis, GAP analysis, developing test plans, conducting user acceptance testing, training, and implementing new processes and technology.

TECHNICAL SKILLS

Business Analysis Tools: MS Office Suite (Word, Excel, PowerPoint, Visio)

SDLC Methodologies: Agile/SCRUM, Waterfall, Spiral, RUP Process and Prototyping

Databases and Tools: SQL Server 2005/2008, My SQL, Teradata, Oracle 9i/10/11g, MS Access, PL/SQL

Project Management: Microsoft Project Professional

Operating Systems: Windows XP/7/8, Windows Server 2003/2008/2012 , Unix, Linux (Ubuntu)

Change Management: Rational Clear Quest 7.1, Rational Clear Case, Team Foundation Services

Languages: C/C++, Java, Shell Scripting, Python, VB.NET, JavaScript, JSON, CSS, VB6, PHP, Perl, ASP.NET, C#.NET

Business Intelligence / Reporting: SQL Server Reporting Services (SSRS), Performance Point Services, SOAP

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, Iowa

Sr. Business Analyst

Responsibilities:

• Participated in the research and development of business opportunities and ideas within the scope of the project.
• Conducted interviews with key business users to collect requirements and business process information.
• Prepared project reports for management, assisted project managers in the development of weekly and monthly status reports, documented process flows, policies and procedures.
• Created Traceability Matrix to reflect how the Business Requirements, at a high level, will be satisfied throughout the lifecycles (Requirements, Design, Build and Testing) of the project.
• Understood core processes of the department to provide input on reverse-engineering and to develop new blueprints for the process flow
• Closely worked with development team to make sure whether the software application fits within the architecture and has the required behavior
• Overseen change control to ensure that all system revisions, upgrades, and enhancements are thoroughly tested and documented to ensure business as usual.
• Translated requirements into functional specifications for the development of online system & managed changes to those specifications.
• Performed extensive requirement analysis including data analysis and GAP analysis.
• Developed business requirement specification documents as well as high level project plan.
• Designed and developed project document templates based on Agile methodology.
• Created Use Case Models using Rational Rose to indicate Actors and Use cases in various Business Processes.
• Set up definitions and process for test phases including product test, integration test, system test and User Acceptance Test (UAT).
• Worked on the impact of changing requirements on the mainframe application during change management procedure.
• Regularly interacted with onshore and offshore teams to communicate requirements and review test cases and test plans.
• Analyzed operational procedures and methods to recommend changes for improvement, with an emphasis on automation and efficiency.

Environment: Windows XP, MS Office, MS Project, MS Visio, UML, Requisite Pro, Teradata, Data Warehouse, Informatica Power center for ETL, Business Objects XI 3.1 for reporting, OLAP/OLTP, Erwin, Power Designer.

Confidential, Houston, Texas

Sr. Business Analyst

Responsibilities:

• Gathered requirements through a series of interview sessions and group meetings with the identified users and developers to design, build and release the Public Facing Website.
• Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Worked closely with the architects and Content Engineers for Design and Development of associated Content in Alfresco CMS.
• Created Use Cases, State diagrams, Sequence Diagrams and Activity Diagrams.
• Developed FRD, Detail Design Document and UI document for the Website.
• Created UI mock ups and PoC’s for the Public facing user interface and the adverse event Reporting form.
• Extensively analyzed XML’s and documented business rules and Validations for XML documents.
• Developed design for Retrieve form for Data Capture via XML, XForm and XHTML.
• Extensively performed XML Data validation and tested the validation Business Rules.
• Worked with QA team to go over the various test scenarios for different types Data Elements and Fields in the Adverse Event Reporting Form.
• Created the UAT document and conducted the UAT testing and Smoke Testing for the Release.

Environment: Windows XP, MS Office, MS Project, MS Visio, UML, Requisite Pro, DB2, Data Warehouse, XML, HTML, Business Objects XI 3.1 for reporting, OLAP/OLTP

Confidential, Chicago, Illinois

Business Analyst

Responsibilities:

• Gathered and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• As part of the project team interacted closely with business community to define and analyze the technical requirements.
• Interacted extensively with Subject Matter Experts (SMEs) for requirement elicitation and documentation for development.
• Conducted one-on-one interview and Joint Application Design (JAD) session with Clients to review MultipleSystem Operator (MSOs) environment.
• Created use case and activity diagram on adoption process for development team.
• Documented all the Detailed Design and Business Rules in Detailed Design Document.
• Conducted user interviews and documented business and functional requirements.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification(URS)
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, ActivityDiagrams using MS Visio according to UML methodology thus defining the Data Process Models
• Used Mercury Quality Center to look up defects and issues raised by testing activities.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and providedfeedback to nail down the bugs.
• Produced and managed documentation on release activities to support problem resolution.
• Responsible for Knowledge Transfer (KT) sessions of the project to the Production Support Team.
• Performed Data mapping, logical data modeling, created class diagrams, Activity diagrams, and ER diagrams and used SQL queries to filter data.
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Created use case scenarios and documented work flow and business process using MS Visio.
• Documented requirements associated change requests with connected requirements and Use cases.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using VisibleAnalyst.

Environment: MS Visio, UML, SQL, MS Project, MS Office, Quality Center, SQL Server, SharePoint, ASP.Net,C#, Visual Studio, HTML

Confidential, Libertyville, Illinois

Business Analyst

Responsibilities:

• Worked on day-to-day claim processing and wrote the change summary for claim processing errors.
• Gathered requirements for HIPAA conversion.
• Performed analysis, mapping, implementation, and testing for HIPAA conversion.
• Identified policies and procedures impacted by the ICD-10 implementation.
• Conducted Joint Requirement Gathering Session to capture ICD-9 to ICD-10 Code conversion rules.
• Created project requirement document and change summary document to replace ICD-9 with ICD-10 code sets.
• Conducted GAP Analysis of AS IS and TO BE business processes.
• Developed Data Flow, Work Flow and Process Flow in MS Visio.
• Assisted with data analysis by generating reports in MS Access.
• Conducted validation sessions / walkthroughs with technical and business SME to identify and resolve open issues in the existing design document for technical logic additions / changes based on the dynamics of desired business flow.
• Worked closely with senior management, business and technical SME to facilitate impact analysis, business process and technical design decisions and created baseline documentation on the same.
• Created test cases for components and identified the test data needed to execute the test cases

Environment: Windows 7, HP Quality Center, MS Office / Visio / Access / SharePoint, XML, Mainframe

Confidential, Cincinnati, Ohio

Business Analyst

Responsibilities:

• Proactively collaborated with stakeholders to analyze business needs and develop system requirements.
• Defined project and solution scope and have written functional specifications, use cases, uses stories and have developed the requirements traceability matrix.
• Communicated systems requirements to the developers, supported and clarified requirements during the development cycle.
• Defined test criteria, supported the test team and performed hot-fix testing.
• Have supported end-users, troubles hooted issues, provided knowledge transfer training to the stakeholders.
• Developed business needs and have written functional specifications based on the requirements.
• Have performed database analysis, gap analysis and have created reports based on reporting requirements.
• Written SQL queries for reports and research.
• Knowledge and understanding of usability and web standards, including accessibility, mobile and responsive design.
• Worked within an iterative or agile development cycle
• Demonstrated capability to work effectively in a cross-functional team

Environment: Windows 7, HP Quality Center, MS Office / Visio / Access / SharePoint, XML, Mainframe

Confidential, Fairfax, Virginia

Sr. Business Analyst

Responsibilities:

• Participated in the research and development of business opportunities and ideas within the scope of the project.
• Conducted interviews with key business users to collect requirements and business process information.
• Interacted with business users to understand the requirements.
• Came up with best practices documentation.
• Designed and documented test plan, test strategies, test cases in Test Manager by evaluating the requirement document in RequisitePro and performed hands-on testing for complex test conditions.
• Validated and analyzed EDI outbound and inbound Transactions.
• Executed test cases for the existing market’s various lines of business.
• Prepared project reports for management, assisted project managers in the development of weekly and monthly status reports, documented process flows, policies and procedures.
• Created Traceability Matrix to reflect how the Business Requirements, at a high level, will be satisfied throughout the lifecycles (Requirements, Design, Build and Testing) of the project.
• Understood core processes of the department to provide input on reverse-engineering and to develop new blueprints for the process flow
• Closely worked with development team to make sure whether the software application fits within the architecture and has the required behavior
• Overseen change control to ensure that all system revisions, upgrades, and enhancements are thoroughly tested and documented to ensure business as usual.
• Performed extensive requirement analysis including data analysis and GAP analysis.
• Developed business requirement specification documents as well as high level project plan.
• Designed and developed project document templates based on Agile methodology.
• Created Use Case Models using Rational Rose to indicate Actors and Use cases in various Business Processes.
• Set up definitions and process for test phases including product test, integration test, system test and User Acceptance Test (UAT).
• Worked on the impact of changing requirements on the mainframe application during change management procedure.
• Analyzed operational procedures and methods to recommend changes for improvement, with an emphasis on automation and efficiency.

Environment: Windows XP, MS Office, MS Project, MS Visio, UML, Requisite Pro, DB2, Data Warehouse, Informatica Power center for ETL, QTP, Business Objects XI 3.1 for reporting, OLAP/OLTP

Confidential

Business Systems Analyst

Responsibilities:

• Actively participated in review meeting including Functional Spec, Test Plan and Test Case.
• Created and published Test cases based on available requirements and functional spec.
• Wrote test cases using Microsoft Excel and performed extensive manual testing.
• Worked with business users to get sign off in the requirements.
• Created Business and process documents.
• Created the Use Cases on the requirements and came up with different diagrams for technical team.
• Reviewed vendor solution designs and assists in coordinating testing between vendor and client for product enhancements.
• Reproduced and researched problems for their consistency
• Performed Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database
• Involved in Functional (positive, negative, null value, boundary value), Integration and Regression Testing.
• Used Quality Center to log defects and monitored the defects for successful resolution.
• Prepared and Documented the test scripts for functional and regression testing
• Wrote SQL statements and SQL queries to check the contents of the application tables
• Participated in weekly meetings to discuss the progress and bugs identified the testing.

Environment: Quality Center, QTP, SOA, Web Services, PHP, Web Sphere, DB2, Oracle, Actuate Reports, SQL, XML, HTML, DHTML, JavaScript, MS Office, UML, RUP and MS Visio, CSS, Excel.