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