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.• Experienced on both Agile and SDLC methodologies based on the requirements.• Strong knowledge in microservice design best-practices, hands-on experience with container managed services in Azure and AWS clouds.

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. • Managed security for applications and administered DB/DW dataflow on cloud. • Designed applications using Python and REST API for applications using multi cloud strategy.

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.• Created data models on Snowflake DB to improve the efficiency of the automated data pipeline by 600% through parsing and cleansing data during transformation and multi-threading with Python.• Snowflake experience on Warehouses, Stages, Schemas, Functions and Account/User management.• Designed and deployed Data Science machine learning algorithms (XgBoost) by generating modeled features for calculating fraud scores which generated revenue more than $2.5M.• Worked on migrating on-prem Data processing from SQL Server to Cloud using S3, EKS, Glue with Spark which reduced load time by 400% for batch processes.• Proficient with container systems like Docker and container orchestration like ECS Fargate, Kubernetes, also developed Terraform scripts to manage IAAS.• Wrote CI/CD scripts using Gitlab, CFT, ECR and ECS for automating deployments.• Developed Model development and deployment (MDAD) application using real-time data from PostgresDB using Kafka queues and AWS Glue/EMR clusters for running Pyspark jobs.• Built and deployed scalable solutions for Enterprise products using AWS serverless application.• Managed end-to-end encryption of PII/PHI/PRI sensitive datasets.

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 the probability of a fraudulent claims.• 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• Created both matching and non-matching features for resolving entities between claims for multiple customers.• Developed high-performance computing and scalable financial applications such as modeling quantitative risk models, financial econometrics, computational statistics, network and expertise with Python programming for statistical analyses and managed, analyzed and visualized data.

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