Business And Database Analyst Resume
Tampa, FL
SUMMARY
- Business Analyst with over 7 years of information technology experience in business and system analysis, technical, analytical, enthusiastic and innovative, developing business processes and system solutions for Banking, Health care, Retail and Telecomm. Working in multi - functional teams with business, technical and consultancy staff, locally and internationally.
- Experienced with BPR, Process and data modeling and migration, design and documentation, Feasibility studies and cost benefit analysis.
- Proficient in designing Use Case, Data Flow, Activity, Sequence, and ER Diagrams using UML, Manual testing and User acceptance testing using Quality Center
- Experienced in conducting and facilitating workshops or Joint Application Development (JAD) sessions and one on one interviews to elicit information, presentations and training.
- Performed Cost & Benefit analysis, SWOT analysis and Risk analysis of the application and also helped in developing detailed test plan and test cases.
- Working knowledge of healthcare Technology standards such as HL7, ANSI ASC X12, IHE XDS/XDM, HITSP, CCR(continuity of Care Record), CCD(Continuity of Care Document), NCPDP Script 8.1, ELINCS, CDA and Electronic Remittance Advice.
- Experienced in directing, developing and mentoring junior analyst and also developing staff from the business into BA roles during projects.
- Experienced with end to end project lifecycle; Iterative Rational Unified Process (RUP), Agile/SCRUM development and Prototyping Model, Waterfall Model and Spiral Model
- Excellent practice in gathering and documenting business and functional requirements
- Lead and coordinate teams in the analysis, design and management of source data transformed from multiple source systems for the data warehouse.
- Excel at interfacing with the business at all levels from senior management to junior clerical and with outside consultants to gather, transfer, disseminate and present information.
- Experienced with Dreamweaver, Balsamiq and Smart draw for developing Mock-ups /wireframes
TECHNICAL SKILLS
Business Modeling Tools: Enterprise Architecture, ClearQuest, Clearcase
Computer Skills: Minitab, Excel, PowerPoint
Project Management Tools: MS Project, OpenProject Serena
Methodologies: Rational Unified Process (RUP), Waterfall, Agile/Scrum
Industry Standards: HIPAA, SOX, ISO, GRC
Management Skills: Six Sigma Resources, Green fields
Testing Tools: Quality Center, Quick Test Pro
Wire frames tools: Snagit, Balsamiq, Rational rose, Smartdraw
Web authoring: Dreamweaver 8.0/ 9.0/ 10.0
Database: SQL Server, MS Access, Oracle
Microsoft Tools: MS Suite, MS Access, MSProject, MS Outlook, MS Visio
Other: SAP, SAS, SWIFT, Teamsite, HL7, Epic, Cognos, Crystal Reports
PROFESSIONAL EXPERIENCE
Confidential, Tampa, FL
Business and DataBase Analyst
Responsibilities:
- Performed Feasibility, Adaptability and Risk Analysis and Data Analysis to identify the business critical and high-risk areas of the migration
- Identified, assessed, and documented business requirements and functional specifications, recommending business priorities, and advising business on options, risks, and costs versus benefits of various solutions.
- Created detailed product requirements documents by conducting user interviews, interacting with SMEs (Medicare business partners), claims processing team and other technical and admin staff.
- Managed and maintained the change control process for requirements during the project's cycle.
- Interacted with SME's in the process of Project implementation. Working with the business to analyze business requirements, providing technical expertise, and producing specifications for any new change in applications.
- Prepared Status reports and modify schedules, as required keeping management, clients and others informed of project status
- Used and administered Share Point for sharing team's work spaces and documents.
- Documented test strategies ensuring that requirements documentation can be easily translated into test scripts, and ensured that the proper testing plans have been completed.
- Conducted JAD sessions and peer review meetings to keep track of projects milestones.
- Developed and executedsystemintegration test scripts and ensured the testing results correspond to the business expectations.
- Performed bug tracking, configuration management, and UAT.
- Performed GAP analysis and highlighted related issues and analyzed impacts of proposed solutions on technology platforms.
- Defined data quality plans to address data quality issues; worked withSMEsto build business understanding of data issues.
- Worked on various phases of SDLC throughout the project life cycle in Rational Unified Process (RUP) environment and the creation of artifacts and management of various roles specified by RUP
- Updated and modified progress and resources allocation in MS project for the team.
- Worked on the process flow model for ICD 10 codes using Rational Rose and Visio
- Mentored junior BAs
Environment: J2EE, Java Web logic Server, UNIX, Web Services Clear Quest, DB2, Oracle 8i, XML, HTML, DHTML, PL SQL, Windows NT, Mainframes
Confidential, Plano TX
Business and DataBase Analyst
Responsibilities:
- Performed Feasibility, Adaptability and Risk Analysis and Data Analysis to identify the business critical and high-risk areas of the migration
- Gathered Business Requirements, interacted with the Users, Developers, Designers, Project manager and SMEs to get a better understanding of the business process, and analyzed and optimized the project.
- Addressed all the aspect of the Claim Processing Life Cycle starting from identifying a claim right up to the closure under HIPAA compliance and the Revenue Cycle Management.
- Conduct in-depth analysis on business requirements and gather information from multiple sources toeffectively design plans and activities that will enhance and simplify the functionality of current EDIprograms (especially payments).
- Successfully strategized project scope, specification documents, deliverables, timelines and project roadmap by usingGantt Charts
- CreatedEntity Relationship Diagrams(ERD) to describe the new system.
- Conducted Gap analysis to compare As Is with To Be business processes, Cost Benefit analysis and SWOT analysis, and offered solutions.
- Created Use Case Diagramsand Activity Diagrams with the use of MS Visio.
- Validate EDI Claim process according to HIPAA compliance under standard format.
- Enhanced the billing cycle to automate end of month billing relative to all the points of integration and the different web services.
- Facilitated demonstration of a major ACH software system and performed evaluations with a group of experts to select a package that best suits the need of the business.
- Developed ETL process to import the data from existing manual MS Access database into the Oracle database for use by the new system.
- Executed various SQL Queries to perform the backend testing.
- Developed Traceability Matrix (RTM) for maintaining/updating current and new system requirements using MS Excel.
- Researched/Analyzed the various steps involved in claim processing life cycle and then wrote the Business Requirement Document and Functional Requirement Document.
- Created the users requirements specifications and help concert them to Functional Requirements, and assisted the developers with system requirement specifications.
- Responsible for the development and executions of the test plans.
- Conducted UAT (User Accepted Testing) sessions with business users and prepared documents for enhancements and bug fixes.
Environment: RUP SDLC, MS Project, MS, Access, Oracle, MS Visio, MS Office, Quality Center
Confidential, New Castle DE
Business Analyst
Responsibilities:
- Conducted interviews with key business users to collect requirement and business process information. Then created Process flows based on the requirements to define the user interface and written activity steps.
- Conducted several meetings between members of different IT groups and representatives of the higher management to make the“Build or Buy”decision
- Documented the Business requirements into the Functional specification document.
- Have participated in Requirements Walkthroughs, Defect Review Meetings, and Status Meetings.
- Supervised and developed documentation effort from an analysis standpoint.
- Utilized Use Cases, Stated requirements documents, feature specifications, workflow diagrams throughout the analysis phase of the project.
- Organized requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
- Performed Gap analysis to determine the as is system, documented the Gaps and consulted the development team and project manager to fix the issues.
- Re-engineered the system to document the User interface based on the current functionality of the application.
- Made Screen Mockups/Definitions using MS Visio.
- Experienced setting up test scenarios and executing on these scenarios and worked closely with testing team to make sure all the changes made to requirements documents are implemented in their Test Cases.
- Maintained the Requirements Traceability Matrix (RTM) across the deliverables
- Worked closely with lead to create the Impact matrix to document the impacts on other blocks.
- Worked with application development team to identify bottlenecks that could hinder progress of development.
- Collaborated with developers as needed to determine the root cause of defects
- Checked validation of the application against the requirements
Environment: Windows Server 2003, UML, MS Project, MS Visio, MS Office 2007, Scrum SDLC, Quality Center, Ms Office, Ms Project, Ms visio, ASP .Net, VB .Net, Ms SQL Server 2005, SQL Client.
Confidential, Oakland CA
Business Analyst
Responsibilities:
- Successfully involved the end users and clients from the initial requirements analysis, feasibility analysis is and risk analysis for the software development.
- Performed GAPanalysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
- Created Business Overview and User Reference documents for all the projects.
- Conducted Joint Requirements planning sessions (JRP) as a facilitator to gather requirements from the Business User and Technical Teams.
- Collected and documented business process as well as business rules and provided key input in working with users in defining project and system requirements.
- Organized and Documented Business Requirement Document (BRD) and Functional Requirement Document (FRD) and coordinated with testing team to help them write test cases based on business requirements.
- Lead the meetings with Technical Managers, Program managers, Product managers and developers for defining business requirements and user requirements.
- Helped the customers to define business processes and researched new solutions or software in project estimation and planning stages
- Analyzed and reported metrics by running SQL based reports weekly/monthly
- Created Data Mapping and Data Modeling for data transformation.
- Implemented Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagram and ER using CASE tools like Erwin.
- Coordinated the Change Control process for the project.
- Monitored and tracked projects, ensuring optimal project utilization of project resources.
Environment: SQL Server 2003, T-SQL, UML, RUP, MS Project, Visio, EXCEL, HTML
Confidential, Denver CO
Business Analyst
Responsibilities:
- Established the business analysis methodology using Scrum SDLC.
- Facilitated and Participated in Sprint Planning, Daily Scrum, Scrum of Scrums, Sprint Review, and Sprint Retrospective meetings.
- Developed use cases, activity diagrams, and assisted Scrum Master to set up project plans in order to manage project scope.
- Performed GAP analysis of business process flows.
- Developed strategic partnerships with business units to develop a solid knowledge base of the business line, including the business plan, products and processes.
- Researched operational procedures and methods and recommended procedures for improvement with an emphasis on automation and efficiency.
- Provided key project inputs by working with users in defining the project and system requirements.
Environment: Windows Server 2003, UML, MS Project, MS Visio, MS Office 2007 (MS Word, MS Excel, MS PowerPoint, and MS Outlook), Oracle 9i, Java, Scrum SDLC, Quality Center.