Nithin Aryan Agrishetty

Senior Data Analyst @Amerisure Insurance

MI, US

Creating System Retirement Plan, Data Migration Verification, Data Management Report and Final Retirement Report for pharmaceutical data.Working for extracting, transforming and loading source data into the data warehouse environment from multiple Sources.Working on SQL Queries for the migration and manipulation of the Good Distribution Practice (GDP) from the data base and cleansing it.Moving the profiled data from SQL data bases to the Data Warehouse by mapping the data and using ETL Tools like Tableau and Power BI.Working on Tools like Starflake schema to manage and maintain the rows and columns of the tables in the data warehouse.Reviewing Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).Working on data mapping techniques Erwin, Talend and ODI (Oracle data integrator) to map the data from source to the target which is a data warehouse.Extracting the data of pharmaceutical marketing from data bases using data migration tools and cleansing it from mismatches and errors.Implementing the best practices in Warehousing and Intelligence applications and databases, including the design and creating of objects such as tables, diagnosis and repairing user and performance issues.Extensive use of Informatica development using Lookup, Normalizer, Stored Procedure, Filter, Expression, Aggregator, router, joiner transformation.Coordinated with R&D, Pharmaceutical industry, manufacturing, regulatory affairs and know the process of NDA application.Working with the team validating computerized laboratory equipment like Atomic Emission Spectroscopy (automated in process equipment).