Data Analyst
Current Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality. Worked on Business Intelligence side of analysis and reporting. Performed Business Process mapping for new requirements and for the purpose of business process re-engineering. Performed Data Validation with Data profiling and data handling. Documentation work on BRD, User guides. Conducted Grooming session with the business team to provide the requirements also did an in-depth analysis of the requirements. Experienced in creating Tableau Dashboards. Worked on Master data management. Applied forecasting methods to see the trend and analyses based on them. Checked for Outliers and done forecasting in Tableau by using RScripts. Involved in Data Extraction from Toad using SQL assistant. Used SAS technologies for business intelligence and reporting purposes. Designed reports in word, Access, Excel using advanced functions not limited to VLOOKUP, pivot tables, formulas. Used SQL to validate the Data going into the Data Warehouse. Worked on SAS coding to extract data by using macro language. Tested the ETL Data Stage staging and other ETL Processes (Data Warehouse Testing) Conducted Scrum meeting and made sure the scope of the Sprint is set to the right level. Experienced in creating SSIS packages, DTS packages. Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.