Expertise in SQL querying, database development and maintenance.
Creating and presenting informational reports for management based on SQL data.
Information retrieval, data analytics and information visualization.
Knowledged in Descriptive, Exploratory, Infrential, Prediction and Causal analysis.
Strong knowledge of Relational Database for data storage.
Experinced in cloud data warehouse like Data Bricks and SnowFlakes.
Expertise in using SQL for data extraction and reporting.
Identifying the data discrepencies and data quality issues, also to ensure the data consistency and integrity.
Extensive knowledge of complex store procedures, views, functions and triggers from scratch to extract the data from multiple source tables.
Quality check of pharma and sales data daily basis.
Databases: MySQL, MSSQL, Oracle, PostgreSQL, Spark, BigData
BI Tools: Power BI, Tableau, QlikView, Tibco Spotfire
Statistical Tools: SAS, R
Use Cases:
Adhoc Sales reporting for Pharma clients.
Claims Reporting, extracting data from cloud warehouse like databricks and snowflake as per requirements.
Comparison reporting YTD, Month to Month, Last 12 months, Quarterly comparison, Year to year.
Sales Analysis for various pharma products.
Financial data Analysis for banking sector.