data business systems analyst ii resume example with 10+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:

Business/Data Systems Analyst with 8 years of IT and Management experience in diversified industry sectors like Finance, healthcare, logistics, CRM, and manufacturing with exposure to emerging technologies and data analytics tools.

  • Hadoop
  • Informatica 10.0
  • DB2
  • Data Lake
  • AWS
  • Python
  • Service Now
  • Specification formulation
  • Enhancement support
  • Business rule consolidation
  • Data consolidation
Data/Business Systems Analyst II, 07/2015 to Current
National Bank Of ArizonaCalifornia, MD,

HMS provides the broadest range of healthcare cost containment solutions for healthcare payers in America. HMS uses innovative technology as well as powerful data services and analytics tools to increase system efficiency to implement cost containment strategies.

  • · Interact with client to understand their data and communicate HMS requirements
  • · Carried out Gap Analysis between client layouts and HMS requirement document
  • · Good understanding of eligibility, claims and provider data
  • · Worked in analyzing data layout and data elements for claims, eligibility and provider files
  • · Worked on Gap analysis, data analysis and data mapping for all claim types (Rx, Institutional, Professional and Dental)
  • · Worked on Hadoop Hive and DB2 tables to identify data discrepancies and missing required fields by running distribution queries
  • · Worked on Informatica v10 for data profiling
  • · Identifying data issues by using SQL queries in DB2 Toad and preparing data issues document
  • · Interacted with client and Project Manager on weekly basis to communicate data issues. Acted as a liaison between the development and Business team.
  • · Developing source to target data mapping document for ETL developers for coding
  • · Carried out claims netting to identify the claims that are adjusted, paid, reversed or voided to assign error codes
  • · Leading efforts to convert source data from the legacy system to Data Lake
  • · Coordinated with Informatica developers to understand data onboarding issues and prepared Data Issues document for the client
  • · Provide inputs to Quality Business Optimization team with process enhancements and changes
  • Participated in Hadoop implementation
Business Systems Analyst, 09/2014 to 07/2015
AvanadeNew Haven, CT,
  • Gathered, outlined and reviewed business requirements
  • Worked on MS Dynamics CRM 2011 tool
  • Carried out Requirement Analysis for each sprint and releases
  • Managed user administration in MS CRM 2011
  • Created user stories and use-cases for testing and development teams
  • Created users for testing in QA and UAT environments based on requirements
  • Developed and maintained MS CRM 2011 product specification document (Solution Document) in SharePoint
  • Assisted BI Analyst in data mining (Data source and Data mining model) by providing functional inputs and Business Objectives
  • Creating Manual test cases for UAT testing and SQL for querying and analysis purposes on various source tables and conditions applied.
  • Carried out analysis to streamline and consolidate user security roles in MSCRM 2011
  • Defect tracking and defect management in JIRA
Business Analyst Consultant, 06/2013 to 09/2014
Foot Locker Inc.Pinole, CA,
  • Manipulated data using pivot tables, pivot charts and macros in Excel
  • · Visited customer (Pharmacy) sites to understand issues and defects onsite
  • · Coordinated with marketing department for resolving issues and writing requirements for new products and existing product enhancements
  • · Used DQL (Data Query Language) to query SQL server 2012 DB to understand the data and provide inputs to testing team
  • · Prepared testable use cases and assisted the QA with writing of test cases
  • · Conducted JAD sessions with cross functional teams
  • · Worked on multiple product lines to gather requirements, managing change request and change control
  • · Coordinated with sales force team to resolve customer issues
  • · Analyzed test cases in TFS (Team Foundation Server)
Business Analyst, 05/2011 to 06/2013
Aorta TechnologiesCity, STATE,
  • Worked with cross-functional resources to implement direct marketing programs to increase customer base
  • Identified bottlenecks in processes and implemented new and improved procedures and policies to ease friction and improve productivity
  • · Gap Analysis between the AS-IS and T0-BE systems
  • · Mobile application development and online banking system up gradation
  • · Assisted developers in developing web services in online banking application
  • · Moderate understanding of XML schema
  • · Defect tracking and defect management on JIRA
  • · Followed agile scrum methodology
  • · Helped identifying relationships between entities to establish hierarchies in data model.

Tennessee State Project :

  • · Conducted JAD sessions and called out meetings for gathering system requirements
  • · Developed Use Cases and Use Case Diagrams
  • · Good understanding of Informatica 9.1
  • · Followed agilemethodology.
  • · Reading Informatica (9.1) maps and preparing Standard Operating Procedure’s (SOP’s) for the end users.
  • · Understanding the functionality of As-Is process and doing GAP Analysis
  • · Documented the As-Is processes and developed Flow Diagrams in Visio
  • · Participated regularly in Walkthrough and review meetings with Project Manager, QA Engineers and development team
  • · Content Management and Data Mapping to facilitate GAP Analysis
Education and Training
Master of Science: Industrial Engineering, Expected in 05/2010
The University of Texas At Arlington - Arlington, TX
  • Completed projects :

Global Supply Chain Management (ALCON):

· Studied and analyzed large data bases that had redressed and packaging activity information

· Applied 80-20 rule to identify 20% of the products and locations that would cause 80% of changes in the overall redressed activity

· Recommended changes and analyzed cost

Time Studies, Work sampling and Productivity Improvement (UTA):

· Project on time study, which was performed to measure the performance/rating/allowance of the operator using time study measurement techniques

Performed project on Work Sampling and Line balancing to improve overall performance and productivity

Bachelor of Science: Industrial Engineering, Expected in 08/2006
Mumbai University - Mumbai,

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • The University of Texas At Arlington
  • Mumbai University

Job Titles Held:

  • Data/Business Systems Analyst II
  • Business Systems Analyst
  • Business Analyst Consultant
  • Business Analyst


  • Master of Science
  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: