Senior Technical Lead - Coforge Limited - Fortworth, TS
(2026-04)
Client Name: American Airlines. Credit Risk T&S: (Azure Public Cloud, SQL, PySpark, Spark, Azure Databricks, Azure Data factory, EventHub, Teradata)
- Prepared Low level and high-level design documents for the developer to develop the code.
- Querying Snowflake using SQL Syntax.
- Responsible for developing and implementing solutions related to Snowflake and preparing data for Business Intelligence.
- Work with Business Analysts and Business Owners to understand all stakeholder requirements.
- Release planning and deployment activities.
Lead Azure Data Engineer - Technopathz Inc & Infosys Limited - Houston, TX
(2023-09 - 2026-04)
Client Name: British Petroleum. Credit Risk T&S: (Azure Public Cloud, SQL, PySpark, Scala, Spark, Azure Databricks, Azure Data factory, Oracle, Azure Devops, Logic Apps)
- Developed ETL pipelines using Azure Data Factory to move multiple data sources into a Snowflake.
- Develop complex SQL queries in Snowflake to build different metrics.
- Develop scripts (Pyspark) to Extract, Load and Transform data.
- Extract and load the files into DF using Python in Databricks.
- Write Scala scripts to write data into Snowflake tables.
- Extract and load data from different into Snowflake Internal and external stage (Azure Blob Storage) using Databricks.
- Data ingestion techniques like full and incremental loading into Azure Blob storage in in Databricks.
- Experience with cloud-based analytics and big data tools such as Apache Spark, Pyspark.
- Took ownership of leading the team and developing the code to derive the metrics.
- Worked in tight deadline to deliver the project and fixing the issues.
- Work with Business Analysts and Business Owners to understand all stakeholder requirements.
- Release planning and deployment activities.
Lead Azure Data Engineer - Nisum India - SFO, CA
(2021-12 - 2023-08)
Client Name: William Sonoma. WMOS (Warehouse Management System) (Azure Public Cloud,Snowflake SQL, PySpark, Python, Spark, Azure Databricks, Azure Data factory, Oracle, Azure Devops, SQL). WMOS is data migration project from on – premise systems like DB2 and Oracle to Snowflake using ADF.
- Designed and developed the Azure data factory pipeline to load data into External stage i.e., Azure Blob Storage using Databricks.
- Developed and optimized complex SQL queries to extract insights from large datasets. Understand data transformation and translation requirements and which tools to leverage to get the job done.
- Actively test and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
- Created and managed Neo4j graph in Azure databricks and buitl the ETL pipelines to transorm the data.
- Extract and transform the data from the files into DF using Python libraries like Pandas in Databricks.
- Write custom Scala scripts to connect to Snowflake and write data into Snowflake tables.
- Do data profiling and create data mapping documents from source and target.
- Assist with production issues in Data Warehouses like reloading data, transformations, and translations.
- Debug and fix data pipeline related problems, proactively and as issues surface.
Lead Databricks Engineer - VUI Systems - Singapore
(2019-09 - 2021-09)
Client Name: OCBC Bank, Singapore. KYC - Customer Risk (Azure Public Cloud, Hadoop, Bigdata, Azure Databricks, Informatica, PySpark, Python, Spark and Teradata)
- Building the pipelines to copy the data from source to destination in Azure Data Factory (ADF V1) and in Databricks.
- Worked on creating dependencies of activities in Azure Data factory and in Databricks.
- Creating batch SQLs and executing them using Azure pipeline activities.
- Scheduled them in Azure Environment.
- Understand Informatica mapping and convert into Azure data factory pipeline.
- Successfully creating the Linked Services on the source and as well for the destination servers.
- Provide production support for Data Warehouse issues such data load problems, transformation translation problems.
Lead Databricks Engineer - VUI Systems - Singapore
(2019-09 - 2021-09)
Client Name: OCBC Bank, Singapore. EDAP (Azure Public Cloud, Hadoop, Bigdata, Azure Databricks, Teradata)
- Prepared Low level and high-level design documents for the developer to develop the code.
- Querying Snowflake using SQL Syntax.
- Responsible for developing and implementing solutions related to Snowflake and preparing data for Business Intelligence.
- Write custom PySpark scripts to extract, clean and load into snowflake external stage using DataBricks.
- Experience with Snowflake data engineering / data warehousing.
- Experience in the implementation, execution, and maintenance of Data Integration technology solutions.
- Create, maintain, and optimize data pipelines for specific use cases.
- Overall ownership of the "platform" and supporting essential platform capabilities.
Senior Databricks Engineer - Capgemini India
(2018-10 - 2019-09)
Client Name: HSBC Bank, India. ISST (Integrated Sales and Service Technology) (Teradata, Informatica, Bigdata, Hadoop, SQL, Control-M)
- CIM – Customer interaction manager is a Teradata Tool used to send campaigns to customers.
- MAU – Metadata Administration Utility used to configure CIM with database related objects.
- Estimations and Impact analysis on other modules and design solutions and development.
- Developing the code for generating reports for the use of the campaign.
- Migrating the data from Teradata to Cloud to integrate with multiple steams.
- Design and develop CIM objects based on business requirements.
- Responsible for changes to the MAU scripts to configure the CIM.
- Propose Architectural design changes to improve data warehouse performance.
- Fine-tune the existing scripts and processes to achieve increased performance.
BigData Engineer - Wipro Limited - Singapore
(2016-07 - 2018-10)
Client Name: HSBC Bank, Singapore. Insights and Analytics (Teradata, Informatica, Bigdata, Hadoop, SQL, Control-M)
- Interact with Business Analysts and Business users to understand the requirement.
- Do the data profile to understand the data and their respective metadata.
- Create mapping documents and review them with Business Analyst.
- Develop ETL Informatica jobs to transform data from source to target as per mapping document and test them and move it to production.
- Automate tasks to reduce manual processes and improve productivity.
- Collaborate with IT and business staff for analytics integration.
Analyst Apps Prog - Bank of America
(2015-02 - 2016-07)
Credit Risk: (Teradata, Hadoop, Unix and Mainframes). Credit Risk is an application to analyze the risk associated with customer to the bank.
- Understanding the Business requirements by interacting with business users and Business Analyst.
- Develop Hadoop DMX jobs to migrate Teradata Utilities and data quality checks using Sqoop.
- Fine-tune the existing scripts to increase performance and reduce load times for faster user query performance.
- Writing Teradata SQL queries to transform data into table.
Senior Associate - Cognizant Technology Solutions - Pheonix, AZ
(2012-04 - 2015-02)
Client Name: American Express. IDN Basel: (Teradata, SQL Assistant, Event Engine-Automation tool AMEX proprietary). IDN Basel is a migration project from SAS to Teradata equivalent stored procedures and from Sybase database to Teradata.
- The main challenge is to provide real time data to users with quality and accuracy.
- Focused on design improvement, developing tools and database features that facilitate query-plan analysis and performance tuning.
- Implemented Agile software development methodology which helps to develop project plans.
- Converting SAS to Teradata stored procedures. Data Analysis and issue identification.
- Fine-tune scripts to increase performance and reduce load times for faster user query performance.
Senior Associate - Cognizant Technology Solutions - Pheonix, AZ
(2012-04 - 2015-02)
Client Name: American Express. CDM – Customer data mart: (Teradata, SQL Assistant, Event Engine-Automation tool AMEX proprietary). Customer Data mart is a dashboard tool used to analyze the demographics of customers data.
- Build stored procedure to bring data from different tables and create a deformalized data.
- Created multiple and complex stored procedure to invoke batch SQLs which will transform data from source to target as per the attributes and logic defined for dashboard.
- Performance tuning in the SQL and create exception handling in stored procedure to make the debug process faster and easy to fix.
Senior Developer - Infosys Limited - Charlotte, NC
(2008-09 - 2011-09)
Client Name: Bank of America. Customer Risk Solutions – Customer Data Mart: (TQL Assistant, Mainframes, Autosys, Unix Shell Scripting, Informatica 8.x)
- Developing code based on the requirements from the client. Load data using Multiload, Fastload and SQL logic in BREQ scripts.
- Write complex SQL queries to transform the data.
- Responsible delivering it to production.
- Debugging of the Scripts and executing them through Putty.
- Track defects in the code and retest them when fix has been applied and done Performing Unit Testing.
