Pramod Venkataraman
Hoboken,NJ
Summary
Experienced and result oriented professional with 9+ years of industry experience in big data analytics, leading multiple projects in Walmart Healthcare and Walmart Canada Pharmacy, working closely with multiple team members in SDLC lifecycle and managing IT processes for over 9 years. Strong ability to understand business requirements, keen in incorporating new technologies, and prudent in implementing best methodologies and solutions. Excellent communication, interpersonal and cross functional skills.
Overview
13
13
years of professional experience
Work History
Senior Data Engineer
Walmart Inc.
Hoboken, NJ
05.2020 - Current
- Providing healthcare insights for WMT US using GCP dataproc and Big Query to process billions of data for Walmart pharmacy, Walmart Vision Ecomm Vision, Walmart Identity Verification for Optics & Patient portal
- Experienced working in spark context, Spark SQL, Data frames, Datasets and Spark YARN for implementing data transformations
- Worked extensively on PySpark libraries such as pandas, numpy and scipy to run data models to help the internal data science team
- Worked in Google Cloud Platform related components such as DataProc, Pub/Sub, Google Cloud Storage (GCS), Big Query (BQ)
- Experienced in Linear Regression model forecasting for understanding routine item cost changes with respect to demand using metrics like Days-on-Hand and OTIF (supply chain demand forecast)
- Analyzed customer churn rate for department, categories and sub-categories using ML recommendation systems
- Led migration projects for migrating ETL process from on-prem Hadoop systems to Google Cloud Platform using GCP Dataproc, Airflow as a Service and Big Query
Data Engineer
Mu Sigma Business Solutions LLC.
Bentonville, AR
08.2017 - 05.2020
- Successfully implemented DIDC (Data Integration/Data Control) project for Walmart and Mckesson (pharmacy supply chain)
- Worked as consultant for Walmart in implementing data engineering tools using Hadoop (On-prem) and IBM infosphere
- Specifically got HIPAA certified to work on this project along with offshore team members
- Led an engineering team in offshore through Mu Sigma and helped the client to build a business dashboard to calculate net sales, total products sold and units (masked due to HIPAA regulation for specific users) using tableau
- Maintained an ETL team to refresh the data Biweekly to help keep the dashboard with the current data
- Worked with clients on Data Science project related to Household analysis and Customer churn rate in Walmart
- Got multiple small projects in data analytics and insights through data science for making key decisions such as Apparel analysis, super-bowl item analysis per household, and Back-to-school and Back-to-college analysis
- Holiday shopping analysis during November and December by preparing the necessary platform to turn in the data to clients with 24 hours of Black Friday shopping
- Extensively spent time in analyzing key KPIs for ethnicity, store, and region level for finding new avenues to increase the churn rate of customers
Data Analyst (Interned from Feb 2016 – May 2016)
ALK Technologies LLC. (Alias Trimble Navigation Inc.)
Princeton, NJ
08.2016 - 07.2017
- Started in ALK as an intern to make route optimization for Truck Drivers using an app(Android/iOS) developed for various navigation vehicles and trucks called Co-Pilot
- Implemented route optimization APIs through integration with 3rd party application from INRIX (real time traffic and weather updates)
- Used python flask to connect to web APIs and postgresql to update the current route in the database and perform data analysis to find new optimized routes
- Perform API calls to rule engines that sets the Federal rules and regulations while optimizing the route plans for Truck Drivers
- Updating driver’s route with respect to detours, accidents and weather calamities using INRIX API call to fleet management tool
Senior Systems Executive
Cognizant Technology Solutions
Chennai, India
10.2012 - 12.2014
- Worked for Hartford Insurance Group (HIG) as vendor to speed up the processing of claims through easy-to-use questionnaires via web and phone app
- Using schedulers like Autosys to schedule ETL jobs to provide the claim forms to the claims manager with 1 hour of claims update process
- Populating user related information from the login page to reduce user interaction in updating the user related information
- Updating expired insurance policies and making the renewal of insurance application seamless for the underwriters and establishing ETL logics to load and process the same to load to data warehouse
- Generate report to business users using SSIS logic and provide the reports through SSRS
Systems Analyst Associate Intern
KPMG Global Services Pvt Limited
Bangalore, India
05.2012 - 09.2012
- Worked with stakeholders on WRFs to create IT audit documents and perform quality analysis on the documents
- Understanding the foundations of Governance Risk and Compliance (GRC) in IT audits
Education
Master of Science - Management Information Sciences (MIS)
New Jersey Institute of Technology
06.2016
Bachelor of Engineering - Electronics and Communication (ECE)
SCSVMV University
05.2012
Skills
Big Data Systems
- Hadoop
- PySpark
- Kafka
- Hive Query Language (HQL)
- SQL
- Unix shell scripting
Google Cloud Platform (GCP)
- DataProc
- Apache Airflow ( For scheduling DE jobs)
- Big Query
- GCP Looker
Microsoft SQL server
- SSIS
- SSRS
- Parallel Data Warehousing (PDW)
Azure Cloud
- Azure Data Factory
- Azure Blob Storage
- Azure Cosmos DB
Other Databases
- No SQL databases like – CassandraDB and MongoDB
- Postgresql
- Snowflake
Visualization Tools
- Tableau
- Power BI
CI/CD Tools
- Jenkins
- Looper
Retail environment
- Health and Wellness
- Consumer Insights
- Analytics
Timeline
Senior Data Engineer
Walmart Inc.
05.2020 - Current
Data Engineer
Mu Sigma Business Solutions LLC.
08.2017 - 05.2020
Data Analyst (Interned from Feb 2016 – May 2016)
ALK Technologies LLC. (Alias Trimble Navigation Inc.)
08.2016 - 07.2017
Senior Systems Executive
Cognizant Technology Solutions
10.2012 - 12.2014
Systems Analyst Associate Intern
KPMG Global Services Pvt Limited
05.2012 - 09.2012
Master of Science - Management Information Sciences (MIS)
New Jersey Institute of Technology
Bachelor of Engineering - Electronics and Communication (ECE)
SCSVMV University
Similar Profiles
Jared SikesJared Sikes
Associate at Walmart Inc.Associate at Walmart Inc.
Cruz MatosCruz Matos
Maintenance Manager at Walmart Inc.Maintenance Manager at Walmart Inc.
Robert FultonRobert Fulton
Coach at Walmart Inc.Coach at Walmart Inc.