We provide IT Staff Augmentation Services!

Business Data Analyst Resume Profile

2.00/5 (Submit Your Rating)

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

We'd love your feedback!