CONTACT

•Briarwood, New York

•718-***-****

•ad2a0r@r.postjobfree.com

SKILLS

Hard Skills:

•Data Warehousing

•Data Modeling

•Data Mining and Scraping

•ETL

•Reporting Services

•Agile Methodology

•Waterfall Methodology Tools and Software:

•Python

•AWS Quicksight

•AWS Lambda

•AWS Athena

•AWS Redshift

•AWS Glue

•Microsoft Excel

•Microsoft PowerQuery

•Microsoft PowerBI

•Microsoft Power Automate

•Microsoft PowerApps

•Microsoft Office Suite

•Tableau Cloud

•Tableau Prep

•JIRA Administration

•JIRA Service Desk Administration

Languages:

•English (Native)

•Punjabi (Native)

•Hindi (Conversational)

OTHER

Certifications:

•In Progress: Microsoft Power BI Data Analyst certification

•In Progress: AWS Certified Data Analytics – Specialty certification

Rajan Kumar

Business & Data Analyst

EDUCATION

State University of New York

General Educational Development Diploma, Nov 2023

WORK EXPERIENCE

IRIS TransTech, Long Island City, NY

Transportation industry focused Technology Company

Role: Data Analyst 02/2020 – 07/2023

●Collected, cleaned, and warehoused data from in-house and external services for the purposes of reporting, dashboarding, archiving and regulatory auditing.

●Engaged with executive team on effective data strategies for new ventures including retail vehicle maintenance facility with over $6M in revenue, inventory warehousing and distribution, and soon to launch franchise retail.

café and express service center chain.

●Developed dashboards and distributed reports based on KPI, OKR, forecasting and statistical requirements by operational, financial, and executive teams using various tools and services such as AWS QuickSight, Microsoft PowerBI, and Microsoft Excel.

●Built violations and toll monitoring dashboard on AWS Lambda with python, AWS Athena and AWS QuickSight that helped cut $2M+ in DOF fines and expenses over the course of 2 years.

●Provided technical and training support for business intelligence platforms such as Microsoft Excel, Microsoft PowerBI, and AWS QuickSight.

IRIS TransTech, Long Island City, NY

Transportation industry focused Technology company

Role: Business Analyst 07/2015 – 02/2020

●Collaborated on creating functional and product lifecycle documentation on projects with $3M+ budgets centered around the For-hire-vehicle and nonemergency medical transportation industries using Agile Development Methodology.

●SME for NYC transportation industry regulatory ordinances.

●Performed scheduled NYC TLC compliance reporting based on operational data within dispatching platforms.

●Researched and vetted software services to be implemented for operational, financial, IT support, and executive teams on ventures in vehicle repair industry and warehouse distribution industry.

●Created and documented business practice SOPs and workflows based on interviews with SMEs withing their respective industries using Business Process Modeling.

●Launched and implemented repair facility management and POS system.

●Administrated JIRA & JIRA service desk environments that provided task management for operations and IT support teams alongside SLAs.

Contact this candidate