Data Analyst And Bi Developer
Current• Experience in Data Analysis, Data warehouse and Business Intelligence Technologies with expertise in SQL development, Data Analyst, BI Report Developer and Training.• Gathering functional, system requirements from business and preparing functional specification document and system requirement specification document.• Analyzing the Functional and System requirement feasibility, preparing the feasibility analysis document for the new requirements.• Interact with clients and define the business rules for the data transformation and create source to target data Mapping/BRD document.• Experience in Data Analysis, Root cause analysis and Data Profiling using SQL, MS Access, and MS Excel on the business requirements on various data sets.• Experience in matching, merging, and cleansing the data sets using complex SQL for identifying unique customer details from different source systems in data warehouse using customer demographic, identification, and address details.• Identify, document, track and communicate data issues/analysis the complex data sets to business and all team members.• Establish data quality standards and best practices and work with Design/Development/QA team to ensure the data rules are being supported and properly maintained.• Expert in writing complex SQLs using Oracle , SSIS, SSRS, Analytical functions and complex JOINs.• Experience in creating Test Plans, Test Cases and Test Data based on business requirement for testing• Strong problem solving and analytical skills with ability to work independently as well as in a team (onshore/offshore).• Designing the ETL and the BI Reporting.• Data Analysis, Report Development, Testing and Validation.• Integration Testing and UAT Support.• Good ability to quickly learn and master new concepts and technologies.• Preparing Status Reports and present to the Clients.