Mohd Atif

As part of this project, I am designing/developing a new ETL process to extract data from multiple sources including Google Ad Manager using APIs and uploading the data into the Vertica database. Database size 100+ TB. DataLake designing with Spark Streaming for ingestion with source as AWS, GCP etc. Designing of Data Warehouse with migration of Hive Tables on HDFS to Apache Iceberg. Use of Spark and Trino SQL engine. Big data streaming and processing using Spark and Hive. Technologies used are Java, Python, Shell Script, SQL. Databases used are Vertica, SQL Server, Oracle.

Worked with client Opel Vauxhall Finance project (OVF) in Europe and Latin America on a highly customized flagship product of Nucleus (Finnone) that provides LMS facilities to clients across the globe. Visited client at Shanghai for Functional UAT Support of China relocation project. Worked at High Wycombe, UK (client location) to gather the requirements for the new projects. Worked as a Project Lead at Cardiff, UK (client location) for implementation of Leasing project & handled end-to-end development right from requirement gathering to deployment & production support. Worked as a Project Lead at Monterrey, Mexico(client location) for 12c migration project. Interact with Business Analysts and End Users to get the requirements & help them with the solutions. Delivered a Performance Tuning project & reduce the batch timings by 30% using Indexes, Hints, Explain Plan, parallel processing, CTAS, With Clause. Involve in direct client handling and mentoring a team of 4 developers to deliver the projects on time. Designing Technical Design documents based on business requirements.

Worked for Nielsen telecom, AMEX & Income tax projects. Successfully completed ETL Optimization Project & reduced cycle time from 35 hours to 12 hours. Designing and developing stored procedures, Tables, Views and other Database objects in MS-SQL (2005 and 2008) using T-SQL. Migrating and optimizing Google Maps API from Version 2 to 3. Creating custom markers and routes on Google Maps.

Design, development and execution of Stress/Performance testing of Oracle 23c projects with strong focus on IoT. End-to-end Installation/setup of Single/Multi node RAC Grid and Database environment. Writing scripts in SQL, PLSQL, SHELL and making use of Python and its libraries such as CX_ORACLE, Pandas etc to simulate IoT application. Using tools such as Hammerdb, SwingBench, TPCH benchmark.