Vivek Pandiyan Email & Phone Number

New Jersey, United States

• Collaborated with clients and executives to plan and design data and network architecture and presented to the upper management with compliance standards.
• Developed dbt scripts for data ingestion into Snowflake DB leveraging data pipelines.
• Designed and implemented cloud architecture for data pipelines using Python and SQL.
• Automated data flow models from file repositories to various databases.
• Worked with data lake and Lakehouse methodologies for big datasets on Medical insurance.
• Designed Erwin data models for healthcare datasets and developed STTM on Erwin BI portal.

New Jersey, United States

• Worked on automated history file migration from DB2 to Cloud.
• Created and replicated Blue-Green Deployments for serverless and microservice applications.
• Worked with other architects on design patterns for cloud migration.
• Automated data pipelines with Azure Data Factory and Azure Synapse for end-to-end dataflow.
• Developed automation scripts in Python and Bash to streamline operational tasks.
• Developed high-performance computing and scalable applications using modern data warehouses such as Snowflake/Redshift/BigQuery/Azure Synapse.

New Jersey, United States

• Proficient with container systems like Docker and container orchestration like ECS Fargate.
• Managed AWS architecture and automated data pipelines using Terraform and CloudFormation.
• Developed automated ETL pipelines using AWS serverless technologies like Lambda, S3, DynamoDB, and SQS.
• Monitored system performance and availability using AWS CloudWatch and custom Python scripts.
• Worked on Snowpipes to auto ingest hourly files and Snowflake DataSharing to distribute data points for data analytics and BI products to produce critical business insights.
• Experienced in Data mining with both structured and unstructured datasets, data acquisition, data validation, predictive modeling, and data visualization.

New Jersey, United States

• Created BI dashboards for smart features to support business products for fraud analytics and create dashboards for smart features using Gradient Boosting algorithm to assist business with fraud analytics and estimate.
• Implemented KPIs for enhanced alert mechanism.
• Designed new products for seamless data transformation between client infrastructure to on-premises data warehouses.
• Automated regression testing from source to target
• Developed internal and external web services for web API interface on AWS cloud.
• Designed APIs to interact with third party applications using functions and sample the response on semi-structured JSON data format

Chennai Area, India

• Used Python scripts to automate job scheduler tracker and improved the performance by almost 200% over the conventional tracking method through excel macros.
• Upgraded Tools release on Oracle JDE to 8.98.4.14 in Production.
• Configured the database parameters, user security, created the user id, granted/revoked roles, extended database storage capacity and managed data file.
• Maintained 3 different servers (RFsmart, Vertex, and As400) and its administrative activities.

Chennai Area, India

• Managed database design, administration and security for the clients.
• Developed a module for validating zip codes on all the insurance policies and claims for more than 20 million records.
• Awarded "Employee of the Month" for updating the sales tax to the server and automated the process to generate the reports periodically.
• Analyzed the business requirement documents and prepared the technical design.
• Created SDR (Service Delivery Report) graphs to indicate the workload and resource utilization on a weekly basis.

Master’S Degree, Data Science With A Concentration In Business Analytics, 3.725

1st Semester (Fall 2015) - Introduction to Data Science Statistical Programming Data Analysis and Decision Modeling Database & Data.

Bachelor’S Degree, Mechanical Engineering, 3.5

Activities and Societies: Basketball Team

Education record