Sr. Business/systems Analyst Resume
Cypress, CA
SUMMARY:
- Qualified professional with over seven years of extensive experience in the field of Business Systems Analysis, working with the technical staff to implement management and staff's business requirements into the software application in Healthcare Industry.
- Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross - platform environment.
- Experience in B2B, B2C and Ecommerce portals web application developments.
- Experienced as a Business Analyst in using the iterative software development life cycle principles of Rational Unified Process to manage, develop and test distributed client/server, Internet and intranet applications on heterogeneous environments.
- Highly proficient in working with users to gather requirements, analyze them and subsequently use the Rational project and design tools to model the requirements.
- In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
- Used Query Analyzer, Execution Plan to optimize SQL Queries.
- Experience with SOX, Regulatory Compliance and Controls.
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
- Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
- Gathered and documented Non-functional requirements.
- Knowledge of healthcare standard Health Level Seven (HL7).
- Experienced in preparing Business Process Re-engineering Models
- Familiar with HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278 etc
- Expertise in the EPIC Medical software application (EMR, HER) as it relates to hospital workflows and setting up the infrastructure for a software implementation in a clinic environment.
- In depth knowledge of SDLC and implementation of the Rational Unified Process (RUP) in all four phases of a project: Inception, Elaboration, Construction and Transition.
- Utilized a fusion of industry knowledge and technical programming to provide executive management the development and implementation of interactive business tools, and strategic analysis, vital for use in mission-critical decision-making
- Conducting requirement gathering sessions, feasibility studies and Impact Analysis and organizing the software requirements in a structured way using Rational RequisitePro to track development.
- Interacting regularly with the development team, creative services, database designer, system administrator and the higher management to meet the deadlines of Project milestones.
- Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
- Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
- Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
- Used Rational ClearQuest for tracking and prioritizing defects and for enhancements after base lining the requirements.
- Used Rational ClearCase for Version Control of requirement documents.
- Well versed in writing queries/Scripts for Data Analysis and QA reporting and testing.
- Good knowledge of Workflows and Content Management Tools.
- Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
- Expertise in Procurement and Management Services
- Excellent skills in Project and Performance Management to support Strategic Planning, Goal Setting, Strengthen Accountability, Enhance Decision Making, and Improve Customer Service.
- Experience in implementing Microsoft Office SharePoint 2007.
TECHNICAL SKILLS:
Programming Languages: C, C++, HTML, XML, SQL.
Data Base: MS Access, Oracle (SQL Series), DB2
Reporting Tools: Crystal Reports 8.0
Operating Systems: MS-DOS, Windows95/98/NT/2000/XP, Apple McIntosh, Linux
Software: MS Office Suite(Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes
Performance Testing Tools: Virtual User Generator, Load Runner
Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint 2007
Automation Tools: Requisite Pro, Win runner, QTP, Test Director, Quality Center
PROFESSIONAL EXPERIENCE:
Confidential, Cypress CA
Sr. Business/Systems Analyst
Responsibilities:
- Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
- Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
- Was responsible for data mapping of HL7 messages into relational database.
- Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Built business requirements into the Medicare Advantage (MA) requirements database and created the Project Requirements Document for the three functional areas
- Responsible for Prior Authorization and dealing with Managed Care and monitored customer flow data.
- Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
- Performed Analysis on Next Gens EPM/EMR application.
- Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
- Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
- Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture)
- Used Query Analyzer, Execution Plan to optimize SQL Queries.
- Meticulously assessed data from various sources and generated conceptual and logical database designs using ER win data modeling tool.
- Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
- Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
- Planned and documented procedures for data processing and prepared data flow diagrams for the application.
- Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
- Expertise with supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
- Interacted with line of business managers and coordinated the transition into the security database to assure business compliance with SOX.
- Analyzed trading partner specifications and created EDI mapping guidelines
- Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
- Developed Data Conversion Strategy for converting data from the existing site to the new site.
- Designed and developed project document templates based on SDLC methodology
- Prepared Demo on SharePoint for various Businesses to get new approvals like the Therapist and Nursing divisions.
- Designed workflows and allocated permissions within SharePoint.
- Performed Unit Testing and User Acceptance testing and documented detailed results.
- Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.
Environment: Windows 2000/XP, Microsoft Office SharePoint 2007, Rational Requisite Pro, MS Office, SQL Server, Agile, MS Project, MS FrontPage 2003, MS Access, EDI, Documentum 2.0. UML.
Confidential, Austin, TX
Business Analyst
Responsibilities:
- Involved in development phase meetings for Business Analysis and Requirements Gathering.
- Worked on U.S. Census Bureau data, including demographic, economic, and geographic data
- Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
- Involved in creating sample mappings for the conversion of EDI X12 transactions code sets version 4010 to 5010 and translation of ICD 9 codes into ICD 10 codes.
- Highly involved in understanding of department workflows and process flows with respect to applications. Developed business process models in RUP to document existing and future business processes. Improved process for payment of Medicare Secondary Payer claims through revised workflows.
- Performed testing for Medicare, Medicaid and X-Over claims for Medicaid Management Information System (MMIS)
- Took lead role in migrating pages and data from old intranet to new SharePoint platform
- Upgrading and Patching of SharePoint and its' related systems
- Worked on System Integration (X12 EDI-HIPAA-835) with Health plans eligibility and claim (CPT, ICD 9 codes).
- Used XML, XSL and XSLT for developing a dynamic and flexible system for handling data.
- Provided support to the completion of the MMIS Data Dictionary. Evaluated and identified all system problems
- Trouble-shooted jobs using Data Stage Debugger.
- Used Soft Test software with pseudo code to ensure test cases covered all branches of project's code impacting the system. (The system is an IBM mainframe based system that contains the master set of customer information used to bill customers).
- Built business requirements into the Medicare Advantage (MA) requirements database and created the Project Requirements Document for the three functional areas.
- Worked on performance tuning and enhancement of Data Stage job transformations.
- Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL* Loader, SQL* Plus and PL/SQL.
- Performed testing for Medicare, Medicaid and X-Over claims for Medicaid Management Information System (MMIS)
- Was Involved in meeting with Clinical Users and Clearing Houses to determine the format of the ICD-10CPT codes
- Was responsible for the hardware, software, upgrades, and patching of SharePoint equipment.
- Experienced working with x12 version 5010 transactions and ICD 10-CM and ICD 10-PCS Code set changes analysis, design and migration strategy.
Environment: Ascential Data Stage 6.0(Manager, Director), JavaScript, IBM DB2/UDB Universal Database Oracle 8/9i,, Teradata, MS SQL Server 7.0, Ms Word, Cobol, MS Excel, IBM WebSphere,MS PowerPoint, MS Project, MS Visio, HTML, XML, UNIX, DB2, GIS Tools, Windows NT, Sybase.
Confidential, Milwaukee, WI
Business Analyst
Responsibilities:
- Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
- Extensively involved in data modeling, Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Gathered requirements and modeled the data warehouse and the underlying transactional database
- Perform Gap Analysis of the processes to identify and validate requirements.
- Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
- Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into Activity and Sequence Diagrams using Rational Rose.
- Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
- Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
- Coordinate and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
- Worked with Rational Clear Quest for defect management
- Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
- Review the Test Plan developed by the testing team for testing the application.
- Assist the QA personnel in the creation of Test Cases using Rational Test Manager.
- Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.
Environment: PL/SQL, SQL Server, XML, Windows 95/98/2000, ODBC, Internet Explorer and Netscape, Web Logic, UNIX, Rational Req. pro, clear case, Rational Rose, Clear Quest, UML, Ms Visio, Ms Project
