Business Data Analyst Resume Profile
Atlanta, GA
PROFILE SUMMARY:
- Business Analyst with over 5 of experience inBusiness Analysis, Quality assurance, Software Validation and Business Process Re-engineering with provenability to articulate business values.
- Experience in system design, implementation and integration strategies within a teamoriented environment.
- Working experiences inHealthcare Insurance, Retail, andPharmaceutical Domain.
- Knowledge Health Insurance Portability and Accountability Act HIPAA standards, Electronic Data Interchange EDI and implementation of HIPAA code sets, ICD-9, ICD-10 and HL7.
- Experienced in financial planning, budgeting, forecasting and reporting using Cognos
- Skillful at eliciting business and functional requirements through 1-1 meeting, team meeting, interviewing, questionnaires, the Joint Application Development JAD sessions.
- Proficient in working with business SMEs and external stakeholders to gather business and technicalrequirements
- Skillfully documented Business Requirements, Use Case Specification, Functional and Non-Functional specification, UML diagrams Use Case diagram, Class diagram and Sequence diagram , Data Flow diagram DFD , Entity-Relationship diagram ERD , Requirement Traceability Matrix RTM , Change-Version Control, Training Manual and User Guide using MS Visio 2013
- Experience in implementing Test scenarios, Test cases, System testing, Regression testing and writing, Defect Report, and Weekly Status Reporting while maintaining Requirement Traceability Matrices for baselinedocuments
- Experience in conducting Gap Analysis and Impact Analysis, and modelingBusiness Process
- Experience working with Agile/Scrum Methodology, and Rational Unified process in SoftwareDevelopment Lifecycle
- Experienced performing quality assurance, user acceptance testing, and change management control
- Strong knowledge and experience in Data Analysis, Data Warehousing writing SQL queries T-SQL PL-SQL especially stored procedures, joins, triggers and views
- BroadMS Excel skills, like pivot tablesand Vlookups
- A team player with experience in handling remote teams esp. managing schedules and meeting agenda
- Worked with project managers throughout project lifecycle to manage scope, schedule, budget, andresources
- Developed training documentation, training modules, training presentations, and facilities workshops forend users
- Excellentplanning, organizational, and communication skills Strong analytical, interpersonal, and problemsolving skills
TECHNICAL SKILLS TOOLS
| Tools | MS Office 2007-2013, MS Project, Rational Requisite Pro, MS Visio 2010-2013, UML, MS SQL Server 2012 Oracle, MS Share Point, JAVA,Clear Case, Report Studio |
| Languages | SQL, JAVA, C |
| Data Tools | DB2, MS SQL Server, Cognos, Oracle, MS-Access. |
| Operating Systems | Windows XP/Vista/7 |
PROFESSIONAL EXPERIENCE:
Confidential
Business Data Analyst
Responsibilities:
- Created and Managed User Stories in Epics, Themes and Sprints also calculated velocity and Story-points in TFS. I was also part of the team that assessed and analyzed TFS, HP Agile Manager and Green Hopper as Agile ALM tool
- Participated in Backlog Grooming sessions, identified obstacles, planned releases and managed sprints, also created a Business Requirement Document for management.
- Conducted interviews with the SME and gathered information about Health care Enrolment, Billing and Claims processing leading to creation of user stories, test cases in epics and themes.
- Analyzed HIPAA 5010 related to 837,835, 834 creating Data warehouse model schemas for faster dataprocessing also performed Normalization-De-Normalization at various occasions.
- Worked with end users to define business design solutions e.g. new workflows, systems, programs, andreports as well as created integration requirements for system coupling.
- Designed reports and data sets for COGNOS reporting
- Created Report Mockups for SSRS based data and Sample Data Mapping documents for ETL process.
- Worked with the DBA to define the dimension modeling requirements.
- Created SharePoint workflow diagrams describing how to use the new system.
- Participated and conducted daily standup meetings and owned daily milestones to gather and create reportingspecifications.
- Created UAT plans and several other types of test cases for each project to ensure that the system runs smoothly after the proposed enhancements.
- Coordinated between business line, operations and the technical team throughout the project.
- Gathered requirements for impacted system and business areas for ICD-10 and their needs to embrace thechanges.
- Created T-SQL statements, stored procedures to query the custom claims OLAP database.
- Proactively identified opportunities and made recommendations to improve the system's effectiveness via data mining and analysis
Environment: Agile, MS Office 2007, MS Project, Rational Requisite Pro, MS Visio 2010, MS SQL Server,
Oracle, MS Share Point, Cognos
Confidential
Business Systems Analyst
Responsibilities:
- Coordinate with Program/ Project Managers and their teams, keeping the business and IT team up-to-date/ informed about scope changes, as and when approved, analyzing the business impact on the initiative
- Coordinate between teams to clarify GAPs, and find resolutions for the Data Model
- Conduct JAD sessions to gather/ review Process Flows, Requirement Timelines, and Component- Delivery Milestones, with emphasis on the ones that impact the Data Model
- Coordinate target-dates for SIT/ UAT, and RT with QA Team during STLC Software Testing Life Cycle , Solutions Architect, and the Developers to prioritize activities revolving around the Data Model
- Worked with the end users to conduct business process modeling, analyzed system requirements andchanged requests to existing software
- Developed design prototype of the color matching software application and wrote feature lists describingfunctions and rules
- Gathered functional and user requirements and documented the same creating use case documents andsystem functional requirements document
- Engaged the team of chemists and technologists and created several color databases in order to makeefficient color formulas using low VOC colorant pigments
- Used SQL tools to access data and interfacing with the project manager and scientist to perform data analysis
- Involved in development, testing and implementation of software functionality
- Worked with users to build and formulate business requirements
- Implemented project plan/timeline and execution and provided technical solution design document
- Provided support to customers of all levels of the organization
- Participated in decision making according to established guidelines, standards and procedures.
Environment: MS Project, Oracle, MS Visio, SQL, MS Office, C Language
Confidential
Business Analyst
Responsibilities:
- Gathered all the required functional requirements
- Prepared Business Requirement Documents BRDs , Technical Requirement Documents TRDs and CaseStudies to evaluate business needs for Pharmacy chain.
- Coordinated and conducted several JAD sessions with SMEs, stakeholders, design/development teams and users.
- Custom solutions were created and tested to resolve operational issues.
- Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using UML in Visio tomap the claims adjudication workflow, and POS integration.
- Created and maintained the Requirement Traceability Matrix RTM between the requirements and design documents and test plans
- Conducted various meetings and interacted with the SMEs, and developers to discuss Enhancement and Modification Request issues.
- Assisted in developing User Interface UI designs and prototypes using Fireworks for web applicationdevelopment.
- Assisted in User Acceptance Test UAT .
Environment: Windows, MS Visio, Requisite Pro, Bugzilla, UML, SQL, MS Office, .Net, HIPPA, EDI.
Confidential
Jr. Business Analyst
Responsibilities:
- Designed and developed Use cases, Activity diagrams, and Sequence diagrams using UML.
- Conducted formal interviews, live meetings with business users and subject matter experts SME's . Documented, organized and tracked the requirements.
- Analyzed current business process flow by understanding preset business rules and conditions
- Developed Business process flow diagrams, Data Flow Diagrams DFD's , Activity Diagram for data modeling
- Created web-page mock-ups on MS - Visio using Data Fields from HCFA 1500 and CMS 1500.
- Defined project milestones, schedules, and monitored progress using MS-Project and updated plans
- Analyzed, organized, and updated database using SQL.
- Involved in back end testing to verify data integrity using SQL.
- Analyzed and tested data interface needs with external systems.
- Developed Test plans, Test conditions, and Test cases to be used in testing based on business requirements and technical specifications.
- Assisted with user testing of systems and maintained quality procedures and ensured appropriatedocumentation in its place.
Environment: UML, MS Word, Rational Requisite Pro, SQL, MS Visio
