Business Analyst Resume
Chicago, IL
SUMMARY
- Business Analyst with over 6 years of experience and strong understanding of Business Requirement Gathering, Business Process Flows, Business Process Modeling and Case Tools.
- Result - oriented professional with proven ability to drive revenue growth in highly competitive markets. Demonstrated broad strengths in: Project Management, Business Analysis, New Business Development and Negotiations.
- Excellent Business writing skills in writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications, Systems Requirements Specification (SRS), Data Dictionary, Workflows.
- Extensive experience in conducting Gap Analysis and Impact Analysis, SWOT analysis, Risk analysis, modeling Business Process, and preparing Training manuals and Knowledge Transfer manuals.
- Authored business and system requirements analyses and functional specifications with supporting business process flows (data modeling), Traceability matrices, risk analyses and Software Development Life Cycle (SDLC) processes, Object Oriented Analysis (OOA/D).
- Worked with project teams and information architects to develop business process models to generate models to depict business processes and information flows.
- Expertise in Rational tools including Rational Rose, Rational Requisite Pro, Rational Clear Case and Rational Clear Quest
- Extensive hands on experience in developing Data Warehousing/BI applications using Cognos BI with strong business understanding of Banking and Health Care domain.
- Data Modeling experience using Dimensional Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using Erwin
- Experienced with implementation of Agile and all phases of Rational Unified Process (RUP): Inception, Elaboration, Construction and Transition,
- Expertise in Creating Unified Modeling Language (UML) diagrams such as Use Case diagrams, Activity diagrams, Sequence diagrams, Context diagrams, Component diagrams, State diagrams using Enterprise Architect using Erwin and Microsoft Visio.
- Strong experience in conducting User Acceptance Testing (UAT) and documentation of test case.
- Experience with HP Quality Center for test management and functional testing.
- Experienced with Relational Database Management Systems (RDBMS), Data Warehousing.
- Conducted successful projects with the help of development and testing teams to achieve deadlines timely and proficiently.
- Expertise in designing and developing test plans, test scripts, mockup screens and mentored QA teams.
- Sincere, well-organized, quick learner, self-motivated, team player and achiever with strong relationship building and excellent individual and group presentation skills
- Proactive problem solver, implementing solutions with careful consideration to the bottom line, long-range goals, quality, feasibility and ease of use.
- Outstanding ability to gather and translate complex technical requirements into practical, reliable, cost-effective projects and designs with excellent verbal & written skills.
TECHNICAL SKILLS
Operating Systems: Microsoft Windows 8/7/Vista/XP/NT/2000, MS DOS, Macintosh, UNIX and Linux
Modeling/Documenting Tools: MS Visio, Enterprise Architect (SPARK/TOGAF ADM), Visual Paradigm(modeler edition), Crystal Reports
Reporting Tools: Informatica Crystal Reports, TIBCO, Google Analytics, Hyperion Essbase
Design / Wireframes: MS Visio, Snagit, Balsamic
Database Management: MS SQL Server 2005/2008, MySQL, Oracle 9i/10g/11g, MS Access
Quality Assurance: HP Quality Center 8.0/9.0/10.0/11.0 , ALM, IBM Clear Quest, JIRA, Bugzilla, Sales Logix
Change Management Tools: Service NOW, IBM ClearCase
Programming Languages: C, C++, VB Script, JAVA Script, MATLAB
Scripting Languages: SQL, HTML, HTML5, XML
MS-Suite: MS Project, MS Visio, MS-Word, MS Excel, MS-Power point, MS Visio, MS OneNote, MS Outlook, MS Share Point 2007/2010/2013
Other tools: Azure Technologies, QTP 9.2/11,QC 9.2/11, SOAP UI Pro, XML, HTML,IBM Clear Case, MS Share Point 2007/2010/2012
PROFESSIONAL EXPERIENCE
Confidential, Chicago, IL
Business Analyst
Responsibilities:
- Business Requirement Documentation (BRD). Facilitated business/technical sessions (JAD) and documented business requirement. Developed business/IT current and future state.
- Created Version One User Stories for business requirements and conducted UAT.
- Processing Payor files and Load to Capella.
- Conducted IT Impact Assessment. Worked with DEV, QA team for effective Service Development.
- Conducted Conceptual Design Sessions and worked with IT team for systems current and future state.
- Maintained a traceability matrix for all requirements and mapping to various Data Reporting Manuals, User Guides
- Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various upstream, downstream projects on STG Billing.
- Assisted client in understanding the business impact of potential rule changes on STG Billing Suite
- Developed guidelines and upgraded techniques of new operational procedures for the
- Support systems
- Analyzed clients systems and business processes.
- Wrote Business cases for the Stakeholders to understand the functioning of the new Billing System.
- Involved in all stages of testing STG Suite of application.
- Worked with the development team during the Design, Build and Test phase of system projects to clarify business requirements as required.
- Coordinating and Reviewing QA activities including test matrix to ensure Good Quality of Deliverables.
- Conducted presentations of the QA test results with Involved stakeholders and users
- Worked extensively with MS Excel and MS Visio to manage schedules, deadlines and resources and collaborate on the project.
- Assisted in building a Business Analysis Process Model
- BA Scrum and BA/Data Warehouse Brainstorming Sessions.
- Created Database of Capella Premium -18 roles including every screen for re-write and enhancements.
- Analysis of pending enhancements/request for UI updates.
- Forecasting/Budgeting, EIP Report (Project Variance)
- Business Status Meeting & Report.
Environment: .Net, UML, SQL, Windows Server 2003, Excel, Visio, MS Project, Power Point, Mercury Quality Center, Test Director, SQL Server 2008
Confidential, New York, NY
Business Analyst
Responsibilities:
- Worked on codes conversion for ICD9 CM - ICD10 CM by conducting data mapping from CDW naming data to EHW data warehouse based on location migration of scheme of conversion.
- Experience in EDI transaction X12 HIPPA P, 837I, 837D outbound, 834, 835, 270/271, 276/277 transactions for claim processing on Gentran 5.0
- Written normal SQL queries to validate the data.
- Developed functional specifications for clients business requirements and CMS regulation.
- Performed liaison to client health plans, the internal development and compliance teams.
- Conducted user interviews, gathered requirements and analyzed the requirements in RUP framework.
- Extensively used Erwin and MS Visio for data modeling and Dimensional Data Modeling.
- Used Rational tools such as Rational Rose to model requirements and Rational Requisite Pro to manage the requirements.
- Conducted JAD sessions with Stakeholders, users, vendor and SME’s, Project Directors for open and pending issues to develop specifications.
- Experience with MDM Hub configurations - Data modeling & Data Mappings, Data validation, cleansing, Match and Merge rules.
- Performed Impact analysis for the readiness of ICD-10 conversion.
- Documented High Level Logical Data Models and BRD supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
- Created and supported the development of Complex Reports in Cognos while working with features including Conditional Formatting, Drill Through, Cascading Prompts, Query Calculation, Layout Calculation, Conditional Blocks, Master-Detail Relationship, Page Breaks, and Render Variable.
- Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed the Risk Mitigation Plan.
- Created Use-Case diagrams, Sequence Diagrams and Activity Diagrams after accessing the scope of the Project and understanding the business processes.
- Modeled the AS-IS system and performed GAP Analysis for the existing system in order to map it to the To-Be system.
- Involved in the installation and configuration of Cognos 10, Cognos tools, web server, and directory server and assisted in migrating reports from Cognos 8.4 to Cognos 10.
- Involved in providing Logic and mapping for ICD10 fields.
- Involved in redefining the business rules for claims processing.
- Provided mapping and transformation rules for Professional, Facility and Denied Claims processes, including the conversion of ICD10 fields.
- Worked closely with the UI team to model the screens, which met user defined requirements, organizational and regulatory standards.
- Created and updated tasks in the MS Project and Project Management Directory for senior management reviews.
- Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
- Reviewed test cases written by QA team and made changes for better execution of test cases.
- Documented Requirement Traceability Matrix in Requisite Pro for traceability of requirements through test cases.
- Used Erwin7.2 data modeling tool to do conceptual/logical/physical data models
- Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processesusingInformatica power center.
- Prepared Technical specification documents for Informatica.
- Created ETL process to extract the data from SAP sources and load into the Oracle database that spans multiple projects.
- Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
- Coordinated with the PMO group in defining timelines & schedules for the project and maintained/monitored project progress status using MS Project.
- Communicated project status to management and business partners on a regular basis to ensure that all stakeholders have accurate and current information throughout the process.
- Conducted User Acceptance Testing (UAT) with the stakeholders and business users, fixed the discovered errors and verified it through regression testing
- Assisted end users and IT staff in the use of data to satisfy informational and reporting requirements
- Clearly translated the customer’s business needs into application and operational requirements.
- Analyzed data, documents, user input surveys and workflow to determine the appropriate course of action to correct business problems.
- Served as the primary point of contact between business and technical staff at all levels
Environment: .Net, UML, SQL, Windows Server 2003, Excel, Visio, MS Project, Power Point, Mercury Quality Center, Test Director, SQL Server 2008
Confidential, Richmond, VA
Business Systems Analyst
Responsibilities:
- Studied existing business application and processes, current source system, collected end user requirements and suggested the improvised business process model
- Analyzed the “As is” and “To be” system documents to show the current and proposed functionalities of the system using MS VISIO.
- Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This includes HIPAA 4010; 837, 835, 270/271, and others. Provided healthcare provider problem resolution.
- Completed several HIPAA 4010 and 5010 Projects, included Medicaid and Commercial entities. Projects include claims and enrollment testing as well as NPI and medical coding and ICD-9 EDI testing.
- Determined eligibility benefits for customers with EDI Health Care Eligibility/Benefit Inquiry (270)
- Authored Data flow diagram, sequence diagrams and business process models that describe how the EDI Health Care Claim Transaction set (837) is used to submit health care billing information and encounter.
- Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts
- Involved in defining and documenting the vision and scope of the warehousing project
- Utilized the knowledge of Facets system to perform the data warehousing of facets system data into Teradata
- Worked with ACES claims data for claims subject area, Enrollment and billing data for membership subject area
- Conducting business validations covering the following deliverables: Facets Providers, Facets Claims and Facets Membership areas
- Involved in the development of Business and Technical Requirements Document (BTRD) and Business System Design (BSD) document for the project.
- Involved in identifying and studying the ACES and Facets system data and field by field analysis of Facets system for the attribute mapping purpose
- Analyzed the data in the Facets source system to map into the correct field and attribute in the target storage
- Conducted interviews with management team and other stakeholders
- Conducted and participated in the JAD session with the SMEs and project team members
- Worked as a liaison between the business and technical side to convey the business needs to the system architects
- Participated in weekly status meetings to present status and in corporate any digressions from the original scope
- Designed Use Cases using UML and managed the entire functional requirements life cycle using SDLC
- Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro
- Carried out a thorough target data model assessment and risk analysis
- Involved in cross-functional teams, developing new ways to boost efficiency and delivering results in a fast changing environment to achieve company goals
- Participated in the walkthroughs and meetings specifically for Claims and Membership modules
- Coordinate with Development and Business team to develop high level Business and Technical documents
- Worked with the clients on the verification process for the requirement phase documents
- Implemented Standardized process throughout the software Development Life Cycle (SDLC)
Environment: Windows XP, Unix, ACES, Facets, Rational Requisite Pro, MS Office, MS Visio, UML, COBOL, Informatica, IBM classic event publisher, Teradata, DB2, IMS, SDLC
Confidential
Business Analyst
Responsibilities:
- Acted as liaison between the SME's and the technical teams, handled all scheduling, resource planning and allocation matters, ran all status meetings and compiled reports.
- Interacted with Subject Matter Experts such as Investment Managers and Process Analysts to gather requirements and goals through interviews, surveys to understand the business process. Conducted controlled brainstorming sessions with project focus groups.
- Involved in gathering and synthesizing business requirements and translated into functional and non-functional requirements to be used as input to the functional design specifications.
- Conducted Joint Application Development (JAD) sessions for communicating and managing expectations with SME's, understand the business process and the interface requirements.
- Extensively worked on creating User Requirement Specifications (URS), Functional Requirement Specifications (FRS), Business Process Documents and developed System Requirements.
- Prepared Use Cases, Use Case Scenarios and elaborated those using UML diagrams like Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Business Process and Data Process Model using MS Visio.
- Ensured project deliverables meet business requirements and industry best practices and standards.
Environment: Test Director, MS Office, Project 98, Windows NT, Rational Requisite Pro, Rational Clear Case, UML
Confidential
Business Analyst
Responsibilities:
- Interacted with SME’s, asking detailed questions and carefully recording the requirements 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 convert requirements into technical specifications.
- Analyzed software requirement specification documents. Created processing model diagrams in UML using the business process information captured in the business context analysis documents. Present high-level requirements using use cases, and interaction diagrams to user groups, as well as documenting requirements and getting them reviewed and base lining the same.
- Elicit requirements by employing information-gathering techniques (e.g., Interviews, surveys, business process analysis, competitive product analysis, reverse engineering of existing systems, etc.). Interacted with the user community to enhance understanding of the solutions project timelines and impact
- Utilized Rational Unified Process (RUP) to configure and develop processes, standards, and procedures
- Used the UML for structuring / modeling the whole project. Identify Use Cases and developed Use Case Diagram using UML
- Created Use Cases and maintained traceability relationships using Requisite Pro.
- Reviewing and writing URS and Functional Requirements.
- Interviewed business area experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business people and technical people.
- Worked as a User\Customer Advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to BRIDGE the gaps between IT and Business Client.
- Used MS Office extensively (Word, Excel, Power Point, Outlook,) for analysis, presentation and documentation throughout the project.
Environment: Windows, MS Visio, RUP, Rational Suite (Requisite Pro, Rose, Clear Case), UML, Oracle 9i