We provide IT Staff Augmentation Services!

Business Data Analyst Resume

Bridgewater, NJ

PROFESSIONAL SUMMARY:

  • Accomplished as Business Analyst, System Analyst, and Data Analyst with extensive experience in Finance (Compliance, Credit Risk, Operational Risk, ADR, Collaterals and Fixed Income), Pharmaceutical (sampling services, Pharmacy Benefit Management, Manufacture and sell medical devices system), Wealth Management (IRA Rollover), Life Insurance (Term, Annuities and Disability), Health care (Affordable Health Care) and PLM domains
  • Proficient as long - time liaison between business and technology with competence in Full System Development life cycle (SDLC) with Waterfall, Agile and RUP methodology
  • Proficient in Sybase SQL Server, TOAD, Erwin Data Modeling, Data Analysis, Reference Data, Data Mapping, Data Governance, Operational Data Store and Informatica ETL
  • Expertise in documenting requirements using Unified Modeling Language (Use Cases, Work Flow Diagrams, Activity Diagrams), SRS, URS, BRD, FRD, and building business process flow, traceability Matrix
  • Exposure to Oracle Warehouse Builder(OWB), Data Analytics(R-Studio), Business Intelligence (Power BI) and JIRA
  • Collaborate with peers in both business and technical areas to deliver optimal business process solutions, in line with corporate priorities and closely work with Stakeholders, SMEs and PMOs.
  • Facilitated change management across entire process from project conceptualization to testing through project delivery, Software Development & Implementation Management in diverse business & technical environments with demonstrated leadership abilities.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, Unix, Mac OX

Business Process Modelling: Action Workflow, MS Visio, UML, Rational Rose, ReqPro, Share Point, Mapping Documents

Data Reporting/Analysis: Tableau, MS Excel, MySQL

Software Development Tools: Use Case Method, Business Requirement Document (BRD), Data modelling technique, JIRA

Languages: SQL

Databases: MS Access, SQL server, Oracle

Methodologies: SCRUM, RUP, RAD, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater, NJ

Business Data Analyst

  • Build the Approved Supplier List (ASL) application for Global Approved BDX Supplier List (legacy BD (BD1) and legacy care-fusion (BD2))
  • Responsible for preparing SRS, URS, BRD, FRD and Work Flow process diagrams
  • Analyze the source data and document the discrepancies of data type, Data Size and the data duplication.
  • Data mapping of the source data to the destination (ASL application)
  • Work with the development to develop the SQL server DB and transformation of the data
  • Implementing the PLM packaging capability parts and specs origination process in ENOVIA’s Digital Spec Management (DSM) application.
  • Build the data assets (like common performance specifications and material compositions) in libraries and mapped to specifications for maximum reuse.

Business Analyst

Confidential
  • Provide integrated PBM (Pharmacy Benefit Management) services including network-pharmacy claims processing and home delivery pharmacy services
  • Prepare HLR (High Level Requirement) document and DLR (Detail Level Requirement) document
  • Communicated extensively with clients and different levels of management to identify new requirements, use cases and to develop functional and technical specifications.
  • Conducted Gap Analysis and developed data relationships diagrams to define the impact of the new requirements on the existing system.
  • Used MS Visio to model activities and data flow process in the business and make them more understandable to developers and architects.
  • Conducted JAD Sessions to resolve open issues, change requests and most importantly, to facilitate identification and development of an architectural solution.

Business Data Analyst

Confidential, NJ

  • Authored Developed Business Requirements Document (BRD) aka source & post position level rules, defined the vision/scope document and the approach document to implement the requirements in LRM.
  • Investigated, analyzed, defined and documented existing business & technical processes within the data warehouse
  • Documented application enhanced features and functions and assessed scope on a monthly basis
  • Worked with data assurance team to establish the daily support model (dashboard included) of KBE data outliers that will be analyzed by product level SME’s at various level to understand the discrepancies.
  • Acted as a Subject Matter Expert for Regulatory fields in the dashboard enhancements & proposed improvements in the outlier’s dashboard for various product lines that is used LRM.
  • Wrote SQL queries in TOAD to conduct business & data analysis for various product lines

Business Data Analyst

Confidential, NJ

  • Prepared SRS to validate the client source data to Target system.
  • Practitioner Validation to support PDMA compliance.
  • Responsible for data analysis and mapping of external source data to the internal target system.
  • Analyzed the Internal and external source data with the reference data for creating the staging data
  • Used of TOAD to run the SQL queries for data validation
  • Interacted with the systems for testing and report generation

Business Data Analyst

Confidential, PA

  • Prepared the BRD for HIPAA transactions, 834 and 837 for on exchange and off exchange enrollments file from IBC exchange gateway to EDI platform that routed to AEDW.
  • Created the Business System Requirement Document with use cases for Health Care Reform Billing System.
  • Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW) to populate the internal DB tables.
  • Developed the Interface Control Document (ICD) to gather the data elements (Field Types, Field Length etc.) of the existing systems
  • Analyzed the data elements of each source and destination of all the systems, and analyzed the data redundancy to crate the data dictionary.

Business Data Analyst

Confidential, PA

  • Documented Business Requirement Document (BRD) and Functional Requirement Specifications (FRS).
  • Worked on various level of SQL queries (basic to complex) to analyze issues in the QA region.
  • Supported the user acceptance test (UAT) and approval of the application.
  • Conducted MS Project to report project status and planning.
  • Used MS Visio, designed Activity Diagrams, Use Case Diagrams and Sequence Diagrams.
  • Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and claims marts.
  • Provided structured walkthroughs to the developers to understand the Use Cases and worked with quality control teams to develop test Plans, test Cases and test scripts based on usability and functional performance criteria.

Business Data Analyst

Confidential, NY

  • Gathered information to prepare the rollover desk portal, advisor portal and advisor call center application for a new IRA and existing IRA.
  • Collected Functional Requirements from System Users and provided appropriate scope of work for technical team to develop prototype, Use Cases, Flow diagrams for overall system
  • Prepared the Business Requirement Documents (BRD’s), Functional Requirement Specifications (FRS)
  • Created the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge for the User

Business Data Analyst

Confidential, NY

  • Project initiation, documentation of Data Acquisition and Control components of Credit Infrastructure Transformation program initiated by Global Credit Risk Management.
  • Worked on DAC system for Cash Transactions of various LOB
  • Generated the reconciliation reports, financial reports, Basel II reports and regulatory reports
  • Worked with project team representatives to ensure that logical and physical data models developed in line with corporate standards and guidelines.
  • Involved in defining the source to target data mappings, business rules and data definitions.
  • Responsible for defining the functional requirement documents for each source to target interface
  • Documented, clarified, and communicated requests for change requests with the requestor and coordinate with the development and testing team.
  • Extensively used SQL queries to generate the reports.

Hire Now