We provide IT Staff Augmentation Services!

Business/data Analyst Resume

4.00/5 (Submit Your Rating)

Atlanta, GA

EXPERIENCE SUMMARY:

  • About 4+ years of Professional experience in IT field involved in Development of Project SDLC Life cycle and Maintenance of different applications in Data warehousing Environment.
  • Strong analytical and problem solving skills with knowledge in programming, application enhancement and maintenance where the turnaround time counts.
  • Strong knowledge in Health Insurance Domain.
  • Expertise in Provider and Membership, claims data.
  • Working as SME for provider subject area.
  • Good experience of interacting with users and resolving the data issues.
  • Working with multiple development teams on providing the business and technical solutions.
  • Good knowledge on Agile Methodolofy.
  • Working in KanBan board using JIIRA tool.
  • Participate and demonstrate the business requirement in SPRINT review call with Stake holders.
  • Participate in stand up calls and discuss on the status of the tasks.
  • Significant Technical expertise in Teradata and Oracle SQL.
  • Strong Knowledge in Informatica 9.1 version.
  • Expertise in fixing the data issues and expertise in data analysis.
  • Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and vice versa.
  • Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards.
  • Experience in writing SQL’s using Teradata and Oracle.
  • Strong skills in resolving SQL issues, providing workaround for the problems.
  • Experience in JIIRA tool to track the tickets.
  • Ability and interest to handle and execute projects independently by assuming ownership and responsibility.
  • Working knowledge in the deployment, compliance and adherence to quality assurance procedures.
  • Team player with ability to adapt to various environments.
  • Excellent communication, interpersonal skills and a strong commitment towards Customer Satisfaction.

TECHNOLOGICAL EXPERTISE:

ETL Tools: Informatica PowerCenter 9.x

Databases: Teradata

Agile tools: JIIRA, KanBan Board

DB Tools: SQL Assistance, SQL* Plus, TOAD

Programming: UNIX SHELL SCRIPTING

ETL Tools: Teradata SQL Assistant, Informatica

EXPERIENCE:

Confidential, Atlanta, GA

Business/Data Analyst

Responsibilities:

  • Handling Data Questions and Data Integrity issues through DIM System (Data Issue Management System). We get tickets through this DIM tool.
  • Gathering information from users for in depth analysis and finding the root cause.
  • Once the root cause was found, will tag the DIM number to the JIIRA board and assign story points.
  • Based on priority we consider the DIMS and work to close out the tickets.
  • Helping users for debugging the query issues and help them understand the relationship between the tables..
  • Interact with Development teams and explain them the business needs and clarity them if any questions raises.
  • Work with Scrum master on status updates and project progress.
  • Used teradata SQL Assistance to write the queries.
  • Prepared the Business system documents.
  • Write SQL queries the data in tables to verify the data.
  • Involved in Tokenization and de tokenization (Protegrity) Testing.

Environment: Teradata SQL assistance, JIIRA, Service Now, DIMS, UNIX.

Confidential

Software Engineer

Responsibilities:

  • Involved in designing, developing and maintaining the mappings using Informatica tool.
  • Prepared the documents like impact analysis document, approach document, design document and test result document.
  • Designed the mappings using various transformations.
  • Written shell scripts to validate the source data and target data and send notification.
  • Designed the workflows and sessions.
  • Communicated to the onsite with daily tasks.
  • Monitor the jobs in Control M scheduling tool and fix the production issues.
  • Load the missing files from source to production on adhoc basis. run the catch up loads in production. work on performance issues in Informatica and Oracle.

Environment: Informatica 9.1, Teradata, Oracle and UNIX Shell Scripting, Control M

We'd love your feedback!