Ankur Tiwari

Led end-to-end data migration efforts for financial institutions transitioning to Q2’s online banking platform. Directed migration of financial data from competitor platforms using flat files (CSV, TXT, Excel) and transformed data into XML for SQL Server integration. Optimized data migration processes to minimize downtime during go-live, ensuring seamless transitions for end users. Developed and customized base scripts for vendor-specific projects, ensuring compliance with Q2 standards. Conducted comprehensive migration testing, including mock imports and production deployments, ensuring data accuracy and functionality. Improved process efficiency by standardizing reusable components, reducing project timelines by 20%.

Worked on the Content Data Lake project, a metadata production platform for collection automation. Developed modules to pre-process data from DAM and upload it to Data Lake using Python, AWS ECS, and Lambda. Configured deployment pipelines using Terraform and resolved customer-reported issues.

Developed Python scripts for BI reporting for WebMD and its subsidiary Medscape. Implemented job scheduling and SQL table mapping for data processing. Utilized Databricks Spark, Vertica, and Azure Data Factory for data transformation and reporting.

Designed and implemented ETL pipelines using Databricks Spark and AWS S3 for data replication. Developed Tableau workbooks for reporting using data populated in Snowflake. Created a custom logging solution to track Spark application jobs and ETL orchestration. Migrated data from Oracle/SQL Server to AWS S3 and Snowflake, including security roles and privileges.

Worked on Ericsson Cloud project, automating service migration from physical servers to cloud using YAML. Implemented ANF test cases for cloud migration.

Developed a self-healing tool (SEAL) integrated with Nagios for server health monitoring and issue resolution. Created APIs for cloud resource monitoring and cost optimization using AWS and OpenStack. Worked on Eureka, a data migration project for Citrix, involving HDFS, MapReduce, Pig, and Redshift.