Data Analyst
Current● Conducted sessions with the Business Analysts to gather the requirements.● Analyze and build proof of concepts to convert SAS reports into tableau or use SAS dataset in Tableau.● Worked as a team to conduct Gap Analysis and identify data anomalies and determined the scope for ● these anomalies and suggested options for conversion and cleanup of data.● Created and executed SQL scripts to validate, verify and compare the source data to target table data.● Created and loaded temporary staging tables for Data validation and to enhance performance.● Performed data analysis and data profiling using complex SQL on various source systems including Oracle.● Involved in identifying the Data requirements and creating Data Dictionary for the functionalities.● Created Stored Procedures, Triggers, view, Tables and other SQL Joins and Statements for Applications using T-SQL.● Created stored procedures using PL/SQL and tuned the databases and backend process.● ● Performed Data mining and hardcopy or electronic document study to improve and expand the databases in the application.● Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.● Performed detailed requirement analysis and created data mapping documents.● Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers.● Acted as liaison between Business Intelligence and Business User groups to relay change requests.● Used predictive analytics such as machine learning and data mining techniques to predict patients,● Working on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.● Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.● Implemented python scripts to parse XML documents and load the data in the databases.
