Aswini P Email & Phone Number

Enterprising junior data analyst highly skilled in gathering and processing data for developing client-centric solutions. Computer science graduate with strong technical skills and a passion for data analysis. Excellent written and verbal communication skills. Expertise knowledge in Data modeling – both normalized for OLTP and de-normalized for OLAP. T-SQL development skills in Objects creation such as Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, and Triggers using SQL Server 2019/2017. Expertise in writing T-SQL Stored procedures, Triggers, Constraints, Temp tables, Temp Variables, Views (Schema Binding) and Indexes using various DDL and DML commands. Expertise in developing SSIS packages including Data flow component, control flow component. Proven proficiency in Data Transformations like Derived Column, Conditional Split, Aggregate, Union all, Merge join, Lookup, Sort & Execute SQL Task to load data into Data Warehouse. Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS. Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into data warehouse. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server. Expertise in generating on-demand and scheduled Workbooks/Dashboards/Vizs/reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Power BI. Periodic reporting is done on a daily, weekly, monthly, and quarterly basis which helps the client. Created various types of charts like Pie Charts, Bar Charts, Line Charts, Area Charts, Scatter Plots in Power BI, and Excel to provide better data visualization. Developed and involved in creating facts, dimensions, and Star Schema representation for the data mart. Extensive use of DAX functions for various fact calculations for efficient data visualization in Power BI. Experience in project management methodologies such as Agile – Scrum. Involved in tracking project progress, prioritizing workstreams and supporting strategic workstreams related to strategy, business development, and/or corporate initiatives. Excellent communication, presentation, interpersonal skills, strong troubleshooting, and organizational skills.