Ramya Hershina

Data analyst

Alcon•  October 2022 - Present

Developed and Automated Risk Analysis Tools which supports sales data and reports by using Alteryx tool. Automated the CPM calculations to reduce manual steps and turnaround time, dependencies in technical document routing by using Alteryx. Post-Production Risk Reviews: Automated Risk Analysis Tools and supporting data. Data deployment and Extraction from different data sources and perform Data cleaning. Interacted with stakeholders to understand the ongoing business and their objective behind the data. Analyzing the Requirement and building complex SQL queries. Understanding the requirement and created skeleton dashboard , Data mapping using Tableau. Handling the ad-hoc request to help the business get some insights from the data shared techniques. Created the Sales data request for IQVIA reports using Cognos. Developed and designed an insight for SharePoint website for internal teams in AGS. Created Structured Operating Procedure (SOP) for Cognos data Extraction. Experienced In using advance Excel and macros

Data analyst

Infosys Ltd•  February 2020 - October 2022

Creating Reports and analyzing (reports/query studio/analysis studio) which caters to different employees at different levels. We create Work product through ticket resolution, knowledge item creation and updating, pre-analyzing and working on service requested. Reports include all types such as charts(bar,line,lists). Preparing analysis report of database table space/schema size. Queried data from different database tables as per requirement. Analyzing the Requirement and building complex SQL queries. Dashboard and drill-through reports for the compete management hierarchy. Deployed the reports from development environment and test environment using Cognos framework manager. Running, monitoring and scheduling of DataStage jobs through DataStage director. Involved in performance tuning of queries . Scheduled reports through jobs to get the daily, weekly, Monthly outputs of reports. Interacting with business users for requirement for requirement gathering system analysis. Experienced In using advance Excel and macros.