Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ketan Patel

NYC

Summary

Accomplished Data Engineer and Business Intelligence Analyst with a proven track record at Accenture and Paychex. Expert in leveraging Python, SQL, and AWS to automate processes and enhance data analysis, resulting in significant business insights. Skilled in collaborative problem-solving and adept at creating impactful data visualizations with Tableau and Power BI.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Data Engineer

Accenture
Rancho Cordova, USA
02.2018 - Current
  • Company Overview: State of California, Rancho Cordova, CA
  • Conducted Root Cause Analysis and Problem Management for the organizational Identity Management environment
  • Collaborated with the BA group to understand functional requirements, analyzed and designed business requirements, and implemented solutions
  • Created on-demand tables on S3 files using Lambda Functions and AWS Glue with Python and PySpark.
  • Designed and implemented recommender systems utilizing collaborative filtering techniques on AWS EMR cluster.
  • Automated manual processes with big data tools (Spark, Python, AWS)
  • Worked on Repository to create Facts, Dimensions, and different Subject areas for Finance and Revenue reporting
  • Designed and developed reports using SQL, Oracle BI Answers, BI Publisher, and Tableau
  • Extensively worked on complex SQL data models with different window functions.
  • Created High-Level Design Document (HLD) and Technical detailed design document (TDD) for Different System change request
  • Provided recommendations for Business Process Improvements
  • Designed dashboards using reporting tools such as Tableau or Power BI to better visualize data points.
  • Utilized data analysis tools such as Tableau or Power BI to create reports on sales performance.
  • Tracked service requests through a ticketing system such as Remedy or Service Now.
  • Trained new employees on proper use of cash registers, customer service techniques, product knowledge.
  • Identified key insights from the data by analyzing trends and correlations in the datasets using Snowflake
  • Configured and maintained version control systems such as SVN and GIT.

Business Intelligence Analyst

Paychex
Rochester, USA
12.2016 - 01.2018
  • Company Overview: Rochester, NY
  • Collaborated with the BA group to understand functional requirements, analyzing and designing business requirements
  • Contributed to the OBIEE12c upgradation process
  • Developed Physical, Business Model & Mapping, and Presentation Layer using Oracle BI Server Administration Tool
  • Designed Star Schema for different subject areas, built hierarchies, level-based measures, Aggregate levels, and Alias tables
  • Created Interactive Dashboards and Business Intelligence reports using OBIEE Answers
  • Customized reporting with OBIEE Answers and integrated them into Dashboards
  • Worked in collaboration with Project and Delivery managers
  • Created presentations, reference guides, and FAQs for end users
  • Implemented BI Publisher Bursting for scheduling reports
  • Scheduled OBIEE analysis using BI delivers and set up Agents to run reports on schedule
  • Created High-Level Design Document (HLD) and Technical detailed design document (TDD) for Repository and Web Catalog files
  • Rochester, NY
  • Environment: OBIEE 12c, SQL Developer/Toad, Hyperion 11.1.2.2 IR/WA reports, Oracle 11g, Teradata, Windows

Education

M.S. - Computer Information Systems

California State University
Los Angeles, CA
12.2016

B.S. - Information Technology

Charusat University
Changa, Gujarat, India
12.2014

Skills

  • HTML,CSS
  • Java, JavaScript
  • Python
  • SQL,PL/SQL
  • Relational Databases (Oracle), HDFS
  • Amazon Redshift
  • Apache Spark (Databricks)
  • PySpark
  • Microsoft Azure, AWS (S3)
  • OBIEE 11g, 10g, 12c
  • BI Publisher, Power BI, Forms Report Writer 11g
  • Tableau, Qlik
  • Windows Server 2008, 2012, 2016
  • Toad
  • MS Project
  • WordPress, ServiceNow

Certification

  • Udacity Data Product Manager
  • Microsoft Certified in Database and Network
  • Couchbase (Data Science: Data Modeling, NoSQL, and Data Management)

Timeline

Data Engineer

Accenture
02.2018 - Current

Business Intelligence Analyst

Paychex
12.2016 - 01.2018

M.S. - Computer Information Systems

California State University

B.S. - Information Technology

Charusat University

Similar Profiles

CREATE PROFILE
Ketan Patel