Vikash Kumar Email & Phone Number

West Des Moines, IA, US

Moline, IL, US

• Designed and maintained ETL pipelines within Databricks, efficiently managing large datasets from diverse sources such as AWS S3, relational databases, and batch services.
• Implemented Databricks Medallion Architecture to organize data processing layers, moving data from Raw (Bronze) to Silver and finally to the gold layer, enabling advanced analytics and business intelligence.
• Worked with different file system e.g.: Avro, Parquet, JSON and flat files.
• Built Product for John Deere Risk Analysis team for Retail and Wholesale customers using different programming languages e.g., Python, PySpark and SQL.
• Worked with different stakeholders to gather the requirements and implement the logic.
• Developed data orchestration using AWS Apache Airflow and other AWS services e.g., SQS, SNS, CloudWatch, DynamoDB, lambda and DMS.

• Performed data wrangling/analysis using SQL and PySpark to identify fraudulent applicants for Medicaid eligibility using employment status and household income data.
• Built a series of data visualizations (histograms, scatter plots, joint plots, etc.) using Pandas, Matplotlib & Seaborn, enabling key internal stakeholders to gain a richer understanding of what consumer attributes are.
• Performed data modelling and data analysis on Medicaid Claim data hosted on Teradata database.

Dublin 2, IE

• Led an team, managing the lifecycle of internal projects and bringing them to completion.
• Collaborated internally with senior leadership and externally with client stakeholders to identify inconsistencies across different data sources, successfully streamlining data processes and maintaining strong customer.
• Developed interactive data visualizations in customized dashboards with in-house tool, empowering non-technical business partners to tell their own data stories, improving the overall customer experience and.

Dublin 2, IE

• Performed and delivered end-to-end data analyses (from pre-processing to missing value imputation to insights derivation) for AT&T, one of Accenture’s core telecommunications clients
• Worked extensively on SQL to collect and transform the data.
• Worked across all phases of the data extraction, performed database testing across multiple environments such as dev, QA and prod.
• Implemented Agile-based practices and tools in conjunction with the Software Development Life Cycle (SDLC), translating business requirements into detailed functional and non-functional specifications

Bangalore, Karnataka, IN

• Performed data-type mapping, data migration, and ETL on both staging and production systems.
• Utilized Apache Tomcat and IIS servers to configure SSL certificates on A10 and F5 BIG-IP.
• Performed database testing on all different testbed, eg: Testing, Staging and production system.
• Conducted team meetings and ensured project documentation is completed in accordance with Agile best practice.

Shenzhen, Guangdong, CN

• Spearheaded the overall redesign of data schemas and technical specifications for a key telecommunications client based in Mexico.
• Developed stored procedures and user defined functions using PL/SQL
• Trained a team of 25 engineers on best practices for internal technology products including NGIN Platform, Call Flow Design, VPN Services.
• Designed and automated weekly reports and project updates to senior leadership, performing root cause analysis (RCA) to diagnose any issues that arise, and outlining specific plans to tackle those issues.
• Performed User Acceptance Testing (UAT) with multiple clients, achieving 100% success rate prior to deploying production systems.
• Worked on complete GSM Architecture and different Network Entities data.

Master Of Science - Ms, Data Analytics

Postgraduate Degree, Artificial Intelligence And Machine Learning

B.Tech, Comuter Science