Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Akshay Rajan

NY

Summary

Responsive expert with 3+ years of experience in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

Kroger
07.2023 - Current
  • Created Process flow chart, presentations and defects mgmt. using JIRA, Visio, PowerPoint and MS Excel
  • Prepared reports by using and utilizing MS Excel (VLOOKUP, HLOOKUPS, pivot tables, Macros, data points)
  • Managed spreadsheets and maintain data integrity to ensure accurate data availability for higher management
  • Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of business.
  • Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
  • Experienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and expert in Creating, Configuring and Fine-tuning ETL workflows in SSIS.
  • Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, drill through filters also created custom visualizations using “R-Programming Language”.
  • Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace

Data Analyst

Subex
01.2019 - 06.2021
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Upheld security and confidentiality of documents and data within area of responsibility.
  • Works with key stakeholders to understand the data requirements and translates strategic requirements into usable enterprise information architecture.
  • Perform data modeling, design, mapping and analysis - using both ERD and dimensional data models.
  • Experienced in Vertabelo and SQL Workbench for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
  • Handled performance requirements for databases in OLTP and OLAP models.
  • Written shell scripts to export/import database backups from RDS & keep the same in S3 (AWS Storage)
  • Worked on AWS redshift datawarehouse for columnar data storage
  • Strategized and wrote scripts in Python and SQL for reporting, visualization, data extraction. Redesigned and optimized process of the Merger Task' using Python, SQL, Oracle therefore bringing the execution time down from 11 to 4 hours

Education

Master of Science - Computer Science

Syracuse University
NY, USA
05.2023

Bachelor of Science - Computer Science

Reva University
India
06.2019

Skills

Technologies: Python, R, SQL, C, Shell Scripting, TensorFlow, Keras, PyTorch, AWS, Jupyter, Airflow, GCP, NumPy, Pandas, Java, DBT, Alteryx, MLFlow

Databases and Cloud: Microsoft SQL Server, Oracle, MySQL, NoSQL, AWS, Azure, GCP

Data Visualization, Productivity and Design: Tableau, MS Excel, Matplotlib, Google Sheets, PowerBI, MS Office (Word, Excel, PowerPoint, Outlook, OneNote, Publisher)

Data Techniques: Data Profiling, Data Ingestion, Data Integration, Data Analysis, Data Modeling, Data Mining , Data Migration, ETL, NLP, Database Design & Management, Data Quality Assessment, Data Analysis, Pattern & Trend Identification, Big Data

Tools: AWS, Power BI, Tableau, MS Excel, Plotly, Statistics, Spacy, Flask, Git, Docker, Jira, BigQuery, PySpark, Vertabelo

Soft Skills: Cross-Functional Collaboration, Problem Solving, Strong Communication Skills

Certification

  • Google Advanced Data Analytics Professional Certificate - Oct 2023

Timeline

Data Analyst

Kroger
07.2023 - Current

Data Analyst

Subex
01.2019 - 06.2021

Master of Science - Computer Science

Syracuse University

Bachelor of Science - Computer Science

Reva University

Similar Profiles

CREATE PROFILE
Akshay Rajan