Data Analyst Editor

Sasi Maruthanayagam

Jacksonville Florida ***** Ph: +1-984-***-**** *****************@*****.*** linkedin.com/in/Sasi Maruthanayagam EDUCATION

Campbellsville University, Louisville, Kentucky Till August 2022 Master of Science in Information Technology Management GPA 3.72 Coursework: Data Visualization, Database Management, Math Methods for Data Analysis St. Xavier’s College Autonomous, Chennai India June 2016 - April 2018 Master of Commerce in Computer Application GPA 3.7 PROFESSIONAL EXPERIENCE

Data Analyst, Reliance Jio Infocomm Ltd., Bangalore India June 2018 – Nov 2019 Technologies: Excel, Tableau, Power BI, Python, MySQL, GitHub, JIRA

• Involving in business requirements gathering and analysing data sources for report development identified the data models and created the data dictionaries

• Experience with Level of Detail (LOD) expressions for analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data

• Working Extensively with Advanced analysis Actions, Calculations, Dynamic Parameters, Background Images, and Maps. Trend Lines, Statistics, and table calculations

• Working on data blending, cross-database joins, unions extracting data/connecting live to data source prepared technical specifications for the business owners to record business logics

• Developing wireframes to display the proposed Tableau views to the business understand the legacy / existing reports and advise solutions to implement in Tableau

• Building reports in Tableau using advance functions like LOD Expressions, Parameters, Sets, Groups, and Quick table calculations

• Strong understanding in advanced Tableau features like table calculations, aggregates, calculated fields, Dynamic parameters, quick filters, action filters, context filters, cascading filters, drill downs, hierarchies

• With Denodo, has successfully combined data sources such as Oracle, MS-SQL, Amazon Redshift, Web services and Box.com, securely serving information to consuming applications such as Tableau and Excel.

• Worked in Agile Environment and responsible for designing analytic frameworks for Data mining, ETL, Analysis, and reporting under the supervision of the Manager.

• Implemented advanced analytical functions Lead/Lag, Over, Partition By, Dense Rank, N-Tile, Row Number, Windowing Aggregate Function, Inverse Percentile, First/Last Functions. SKILLS

• Data Query language: SQL Server, DAX Functions

• Cloud Technologies: Amazon Web Services, Power BI services

• Databases: SQL Server Management Studio 2008

• Tools: Tableau Desktop, Power BI desktop, MS Excel, JIRA, GitHub

• Math & Stats: Logistic Regression, Linear Regression, Time Series Analysis, Hypothesis Testing, ANOVA, Chi-Square Test, Z-Test and T-Test, Predictive Modelling, Numerical Analysis

• ETL/Data warehousing: Talend, Informatica, Data Modelling, Star schema, Snowflake schema, Power Query editor PROJECTS

Students connect Analysis Mar 2022- Aug 2022

• We devised a system and elaborate infrastructure layout for resolving most of the problems which will group students based on various interests which would help university students to communicate.

• Coordinated with ETL team and QA team to improve the quality of the model and reports(analytics) Wtaild fire Data Analysis & Visualization (AWS S3, Redshift, Glue, Quick Sight) Sep 2020 – Nov 2020

• Loaded the preprocessed multiple datasets to S3, Glue was used to perform ETL jobs then the data was loaded to Redshift.

• Visualized the combined the wildfire and air pollution datasets on AWS Quick Sight by accessing the RedShift database.

• Analyzed the cause and effect of climate change, the correlation between different factors MEDLINE Analysis July 2021 – Dec 2021

• Create a Clustered search on PubMed corpus of medical/bio-medical journals using HPC at IU

• Effectively integrated Text clustering, Text summarization, and Text ranking and organized MEDLINE retrieval results into different topical groups.

Contact this candidate