data science analyst
witmer health technologies
Total years of experience :2 years, 9 Months
• Developed ETL Mappings using Postgres SQL to extract the data from unstructured data and transformed it to the Staging area, EDW and then to the Data Marts (OLAP DB) for approximately 10, 000 record.
Designed, implemented, and maintained Power BI dashboards to monitor key institutional metrics, such as enrollment rates, course completion, and faculty performance.
• Designed 167 SQL QA queries from source to target tables based on transformation rules and lookup tables comparing business and production data with efficiency of 99%.
• Analyzed dataset in MS Excel and collaborated with Automation, Finance, Accounting, and IT Operations to gather and prioritize their business requirements for IIT Madras Purchasing and Sales order system.
• Enhanced data visualization capabilities by designing and deploying interactive dashboards using Power BI, providing stakeholders with real-time insights into market trends, operational performance, and customer behaviour analytics.
• Conducted regular data audits to ensure the integrity and accuracy of the institution's student information system, safeguarding the reliability of internal and external reporting.
• Documented success in designing business processes to enhance efficiency.
• Proven track record of formulating business recommendations based on detailed data analysis.
• Executed a data quality initiative that ensured the integrity of student data, driving a 15% improvement in data accuracy for reporting purposes.
• Developed visual data presentations, including charts and graphs, to succinctly communicate key business insights to senior management, contributing to informed decision-making processes.
URL removed due to policy violation. Please contact support for further information.