Vishnu Kamala Email & Phone Number

Valley Forge, Pa, Us

Woonsocket, Ri, Us

• Worked in Enterprise Data Platform with responsibilities like Data Migration from On-prem to Cloud, building ETLs, creating data marts, etc.• Collaborated with multiple teams within my department to facilitate quick data migration.• Majorly worked on Infoworks (Data Migration) and GCS tools like DataProc, BigQuery, Cloud Storage, and Compute Engines.• Successfully learned Infoworks and GCS as they were newly introduced to the team and delivered the tasks on time.• Automated the jobs using Tidal and performed production support as well.• Performed data ingestions from on-prem (Hadoop) to cloud, on-prem to on-prem, and cloud to cloud. • Developed multiple scripts in Pyspark, sqoop and shell to perform different types of ingestions.• Communicate with Business Analysts and convert their requirements into dimensional models.• Worked with different file formats like parquet, CSV, XML, JSON, DAT, etc during Data migration.• Ingested data from Teradata, HDFS, SQL server, and Teradata into BigQuery which simplified Data analysis easier.

Valley Forge, Pa, Us

Worked in Retail Marketing Team with responsibilities like building cloud infrastructure as a Cloud Developer and building ETL pipelines as a Data Engineer.• Successfully managed two roles and delivered the tasks with impeccable outcomes.• Designed, Developed and Managed multiple ETL pipelines to facilitate Data Analysts/Scientists to predict prospect customers.• Responsible for providing optimized design to reduce resource consumption that resulted in 90% cost reduction.• Utilized Dell boomi tool to get data from external vendors into Amazon S3 buckets. • Developed python scripts to build cloud infrastructure using AWS CloudFormation for all the pipelines. • Majorly used AWS tools like Glue, lambda, ECS and EMR to perform ETLs with Pyspark framework.

While over whelming urban population is connected to electricity, the same scenario is not seen in rural population. To eliminate this energy gap, a social enterprise (SunMoksha) decided to decentralize the electricity source through establishing solar grids. A data analyst is required to use data science techniques to analyze the electricity consumption trend to provide optimized services.Responsibilities:• Play an effective role in a team of 10 from UK, India and USA, to help a social enterprise (Startup) in achieving sustainable development in off-grid villages by utilizing qualitative and quantitative data.• Collect electricity consumption data from different grids in different villages in CSV format.• Explore various government websites to collect census data and filter the suitable information for performing data analysis using R and Python language.• Perform data cleansing, feature engineering and descriptive analysis using Pandas, NumPy and Scikit-learn libraries in Python and visualize the results to the team using MS Excel• Create a database for the entire project using MySQL.​• Build predictive models to estimate the budget, impact of the electricity on quality of life using multiple regression in Python.• Use a simulation tool called Vensim to build System Dynamics models to automate the entire process.Environment: MS Excel, VBA, Python, VENSIM, Basic JavaScript, R language

Master'S Degree, Industrial Engineering

Bachelor'S Degree, Mechanical Engineering