Lead Business Analyst Resume Profile
Windsor, CT
Summary
- Over 8 years' experience as Business Analyst and extensive experience in gathering business and application functional and non-functional requirements, reporting, business processes, business rules, identifying risks, impact analysis, UML modeling, Sequence and Activity Diagrams using Rational Rose and Microsoft Visio. Extensive use of rational tools including Requisite Pro, Software Modeler, Application Developer, Clear Case, Clear Quest.
- Comprehensive knowledge of Software Development Life Cycle SDLC , waterfall, agile methodology, having through understanding of various phases like Requirements, Analysis/Design, Development and Testing.
- Reporting, worked on COGNOS, Enterprise series, Report net, Worked on SAS, report mock-ups
- Lead the teams of developers, Programmers and QA's for proper project compliance, implementation and validation of the projects
- Through knowledge of EDI, HIPAA standards, ANSI X12, HIPAA 4010 and 5010 compliance, ICD-9, ICD-10, EDI transactions 834, 835, 837 I, 837 P, 837 D, 278, 277, 276, 271, 270.
- Expertise in Rational Unified Process RUP methodology, Use Cases and Object Oriented Analysis and Design OOA/D , experience in using Trizetto's Facets 3.x/4.x
- Adept in reducing development cost and providing traceability of project, RTM, GAP Analysis, Cost Benefit Analysis, SWOT, ROI, Risk analysis.
- Experience in writing DRD, BRD, FRD, Use Case documents and Software Requirements Specifications.
- Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and JAD, RAD and JRP sessions.
- Familiarity with current industry standards such as SOX, ISO, Six Sigma Methodology and Capability Maturity Model CMM , CMMI.
- Working knowledge of Data warehouse RDBMS concepts with OLAP, Dimensional modeling using Star Schema Design and Snow Flake Schema design.
- Active role in eliciting requirements from users by utilizing methods like Interviews, Requirement workshops, Joint Application Design and Participatory Design.
- Modeled User Interface for creating user-friendly interfaces and creation of prototypes to review the proposed usability of the system.
- Ability to work in a team and coordinate/resolve issues with team of developers and other stakeholders.
- Proven skill set in Business Process Enhancement.
- Experience in testing dynamic, database-driven applications with web interfaces.
- Strong Experience in Developing Test Plans, build Test Conditions and Test Cases, creating test data, analyzing bugs, interacting with development team members to fix errors.
- Strong experience in conducting UAT, PVT scripts and documentation of test cases. Familiar in designing and developing manual and automation test cases and test scripts using Test Director 7.6 and Win runner 7.5, Quick Test Professional QTP .
- Have exposure in educating internal customers on business systems and procedures and working with other analyst and QA team to set priorities and schedules.
- Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions, confident, decision making coupled with excellent communication and interpersonal skills. Excellent track record for meeting deadlines and submitting deliverables on time.
- Served as liaison between business units, technology teams and support teams. Also liaison with clients and PM to solicit detailed business requirement and create business/functional requirements documentation.
SKILLS
Software Tools: Microsoft Office Suite Word, Excel, Access, PowerPoint, SharePoint, Project, Visio , Rational Suite Requisite Pro, Clear Case, Clear Quest , SAS, SQL Navigator, Power Designer, Quality Center, Facets 3.x/4.x, SQL Management Studio, Toad, DB Artisan 8.1, Mega Modeling suite, Java, XML, VB, .Net
Databases: MS Access, Oracle 9i, 10g, SQL, SSIS, SQL script
Standards: HIPAA 4010/5010, ICD-9/10 compliance coding, ANSI X12, EDI transactions 834, 835, 837 I, 837 P, 837 D, 278, 277, 276, 271, 270, SOX, ISO, Six Sigma, CMM, CMMI
Reporting Tools: Crystal Reports, COGNOS 8.x Cognos Report Net 1.1, Cognos Enterprise 7.1 Series
Operating Systems: Win 7, NT, Linux, UNIX
Apps Web servers: Apache web server, Jakarta Tomcat, Web logic 8.1, IIS.
Processes/Methodologies: Software Development Methodology SDM , Rational Unified Process RUP , Agile Scrum, Extreme Programming XP .
Testing Tools: Rational Clear Quest, Win Runner, Load Runner, Quick Test Professional QTP , Test Director, Gentran Basic
WORK EXPERIENCE
Confidential
Lead Business Analyst
Responsibilities:
- Associated with full HIPAA Compliance life-cycle from gap analysis, mapping, implementation and testing for claims.
- Analyzed, coordinated, documented and managed project requirements, project processes and procedures and its changes throughout the software development lifecycle.
- Worked on dashboard architecture and structure to make it more efficient for non-technical resources, Designed it to make it efficient for query and reporting
- Worked with BPM team to coordinate and refine the process for claim submission and tracking with the applicability of business rules.
- Gathered AS-IS and TO-BE information about Cigna's Health Plans work processes and information flows Claims process, Membership, Enrollment , and conceptualized using process flow diagrams
- Created EDI documents for EDI maps to generate requirement documents and Project Charter, and logical design documents for EDI transactions 834, 837, 835, 270, 271.
- Worked on XML and XML based claim and its processing on Oracle platform for testing purposes in Dev, System and System Integration.
- Used UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to help them understand the workflow of the system associated with the requirements.
- Performed Requirements Analysis and traceability using Caliber RM.
- Involved in writing test plans, defining test cases, test scenarios and data sets developed and maintained test scripts, analyzed bugs and interacted with development team in fixing the errors using HP Quality Center
- Worked with Subject Matter Experts SME , project team members business and technical , to define technology application for the business and system requirements. Also worked with the QA Team Lead to develop QA standards and ensured compliance with all regulatory requirements.
- Created and segregated SQL views and stored procedures for obtaining meaningful set of data.
Environment: Caliber RM, HP quality Center, XML, Oracle 11g, Microsoft Office suit, Windows 7, Microsoft project, MS Visio
Confidential
Sr. Business System Analyst
Responsibilities:
- Facilitated interview sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
- Understood and articulated business requirements from user interviews and then converted requirements into functional specifications. Created targeted Questionnaires to gather requirements.
- Used COGNOS and applications to automate manual calculations and optimize reporting structure.
- Worked on Agile Methodology Scrum for creating and developing Business Requirement, Functional Requirement, design, implementation and validation.
- Lead the team of 30 team members including developers, programmers and testers for project compliance and validation
- Worked in Business Rules team to document various requirements, functional, non-functional, business rules.
- Provider, AS-IS and TO-BE business process, interpreting business process and data model
- Conducted JAD sessions with the system owners and different team leads to analyze requirements.
- Worked on SAS for data analysis, data linkage, quality measures, system integration.
- Conducted analysis of HIPAA compliance and took part in discussions for designing the healthcare transactions to be HIPAA 5010 compliant, ICD-9 to ICD-10 and worked with developer on ICD 9-10 coding.
- Used detailed knowledge of the application features and functionality to assess the scope and impact of business needs throughout the analysis and completion of the enhancement specifications.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure, features and functionality with the new business design using the As Is and To Be methodology.
- Conducted business-impact assessment and the results were compared with the new HIPAA 5010 standards to determine the current level of compliance and developed an action plan for approval by the project steering committee.
- Developed business case which included results of the business-impact assessment, gaps identified, alternative solutions, risk assessment, preliminary work plans, resource requirements, and a budget for completing the initiative.
- Analyzed the impact of new HIPAA standards on targeted systems, processes, and business-associate relationships.
- Identified solutions to close gaps in HIPAA compliance.
- Analyzed the changes made to different EDI ANSI X12 transactions 837 I and P, 278, 270 and 271 under HIPAA 5010.
Environment: SAS, COGNOS, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Project, Rational Rose, Rational Requisite Pro, Adobe Captivate 3.0 and Windows XP.
Confidential
Business Systems Analyst
Responsibilities:
- Conducted User interviews and documented their queries, business analysis reporting needs.
- Involved in functional requirement gathering from Business Users Teams and translated the Functional requirements into Technical requirements specifications.
- Performed six sigma compliance with implementation of MVP corporate standards
- Performed under Agile Methodology XP for prototyping, designing, integration, refactoring, development and testing to come through the required goals.
- Worked with team of 12 members and lead developers for the proper requirement implementation of the project, lead the testing team and QA's in various phases of project
- Designed Dashboard to make it more interactive, populating various fields and to make it efficient for querying for non-technical users
- Worked on SAS to perform Data Quality Analysis to determine cleansing requirements. Also used for data modeling, and linkages
- Worked on COGNOS for various reporting, prepared report mock-ups for clients, users, participated in discussions with the management and end users to understand the reporting needs.
- Prepared Functional and Business Rules document, which meets requirements and application behavior describing the detail design of the application.
- Worked on a daily basis with Sr. Architects/Lead Developers to evaluate impact to the current implementation, design of all ETL logic, design of date capping logic in order to preserve Point-In-Time reporting, design of Referential Integrity as well as evaluated impact of DW logic that is currently shared by multiple source systems.
- Wrote PL/SQL procedures and functions.
- Provided Security to reports by creating Users and User groups and giving appropriate privileges.
- Charged with the development of test plan, test cases and test procedures.
- Coordinated WebEx conferences.
- Developed eLearning Training simulation video using Adobe Captivate.
Environment: SAS, COGNOS, Microsoft Word, Microsoft Visio, Microsoft Excel, Rational Rose, Microsoft Project, Rational Requisite Pro, Rational Clear Case, HP Quality Center, Adobe Captivate 3, WebEx, Oracle, SQL, Windows 2003 Server.
Confidential
Business System Analyst
Responsibilities:
- Conducted requirement gathering sessions with the Information Technology team, Risk and Change control
- Followed a structured approach to organize requirements into logical groupings of business processes and information needs, ICD 9, HIPAA 4010
- Worked with various stakeholders and lead the team of QA's and system analysts for compliance, implementation and validation in Agile Methodology.
- Developed Use Cases, Activity diagrams and Sequence diagrams from the requirements based on the UML methodologies using MS-Visio
- .Participated in Facets Table data modeling planning, designing, implementation of the data warehouse and conducted testing by developing complex SQL queries.
- Involved in the design and development of User Interfaces UI using HTML, JavaScript and JSP
- Designed and developed a Search Engine to enable users to search information on the tables and fields and tables in the database
- Designed and developed Reports suitable for print using HTML, Java script and JSP, Object modeling and data warehouse modeling using Power Designer 12.X
- Evaluate the requirements for testing products and documentation, developing test strategies
- Helped the testing team in carrying out manual testing and also assisted in writing test cases and a Test Plan.
- Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
- Bugs that would enhance the usability of the application were logged using Rational Clear Quest.
- Interacting with the developers on resolving the reported bugs and various technical issues.
- Involved in preparing a simple and detailed User manual for the application, for an intended novice user.
Environment: Rational Requisite Pro, Rational Rose, Facets, UML, Load Runner, MS-Project, MS Visio, Java, MS Office, Windows XP
Confidential
Business Analyst
Responsibilities:
- Gathered requirements for necessary modifications to Pfizer in-house systems, monitored completion of requirements
- Interacted with Business Unit members for gathering data, information and requirements related to business analysis in the clinical and regulatory area of pharmaceuticals.
- Gained intermediate and advanced knowledge of the industry best practices, document management systems, regulatory submissions creation, review approval, and publishing.
- Participated in the entire life cycle of projects related with initial situational analysis gap analysis, change management, operation design procedures, overall project scoping and QA testing procedures
- Utilized RUP and UML methodologies and Requisite Pro tool to design, document, and manage requirements and Visio to model use cases
- Document and established traceability between the Business requirements, Use Cases, Business Rules, Activity diagrams and Test Scenarios
- Document and defined the functionalities of the new system based on business needs to integrate with Employer and Member data from the Mainframe system, imaging and workflow components.
- Documented Business Rules surrounding the complex calculations for the service credit eligibility
Environment: Requisite Pro, RUP, UML, MS project, MS Visio, Win runner, Load runner, Test director, Crystal report
Confidential
Business Systems Analyst
Responsibilities:
- Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager to get a better understanding of the Business Processes.
- Responsible for creating UML modeling plans, Use cases, process flows, screen flows and business requirements documentation using Visio, Requisite Pro and Clear Case tools.
- Brought valuable knowledge and solutions to business groups to enhance competitive edge with Facets Extended Enterprise TM administrative system implementation.
- Performed Quality Insurance, testing, electronic health record, underwriting tasks and analyze and optimize the online application for the insurance agents.
- Created AS-IS and TO-BE business process flow diagrams, Integrate process flow diagrams to show one end-to-end business model and process mapping including swim lanes.
- Worked with business owners, content staff, IT and other stakeholders in creating a content management solution for managing the information in the supplier portal using Web Sphere Application Server.
- Built and customized SoDA for Word templates and extract information from information sources such as Requisite Pro and Rose, and created a highly automated system for handling approvals, exceptions and priorities.
- Created Project management plans for managing on time delivery using MS Project along with writing test cases, unit and systems integration test plans in Load Runner and Win Runner.
Environment: OO Modeling, Rational Requisite Pro, Facets, Rational Rose, Rational SoDA, RUP, UML, Load Runner, MS-Project, MS Visio, Java, MS Office, Windows XP
