2005-2009
B.E(ECE)
Anand Institute of Higher Technology
B.E(ECE)
Anand Institute of Higher Technology
WORK EXPERIENCE:
Cognizant Technical Solutions
ROLE : AZURE DATA ENGINEER
CLIENT – Lincoln Financial Group
Chennai, TN
01/2020 - Present
● Design and implement data solutions in Azure cloud by understanding the current state of applications and recommend better solutions for enhancements to the existing business.
● Involved in Data Preprocessing Techniques for making the data useful for creating Data Visualization and Machine Learning models
● Analyze, design and build Modern data solutions using Azure PaaS service support.
● Extract Transform and load data from source systems to Azure Data storage using ADF.
● Create pipelines in ADF using linked services/datasets/pipelines to extract, transform, and load data from different sources
● Developed spark applications using Pyspark and Spark -SQL for extraction , transformation and aggregation of data from various sources.
● Hands on experience on developing SQL scripts for automation.
● Utilized databases like mssql, DB2, data warehousing tools, tableau and other visualization tools for data intelligence and Analysis.
● experienced in monitoring and troubleshooting of spark data bricks clusters.
● Leveraged technology to automate daily operational activities using python scripting.
● Excellent problem solving and analytical skills, ability to research , follow up and resolve complex issues surfaced by the team.
Cognizant Technical Solutions
ROLE : DB2 DBA LUW , MSSQL DBA
CLIENT – Manulife Japan
Chennai, TN
01/2012- 12/2019
Responsibilities:
● Involved in migration and upgrade of mssql, DB2 luw, mysql databases.
● Maintained , monitored and troubleshot RDBMS databases like mssql, DB2 luw, mysql and sybase databases.
● Migrated DB2 9.7 version to 11.1 in cloud environment
● Install and configure DB2 UDB new releases, upgrades, and fixpacks.
● Perform database maintenance activities such as backup, reorg, runstats.
● Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases
● Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
● Proactively monitor performance, diagnose problems and tune queries and database.
● Assisting with the creation and modification of database storage structures (tablespaces) and primary objects (tables, views, indexes)
● Database Backup/Recovery on databases and file system backups. Redirect Restore to move application from Development, Test and Production
● Use tools like db2explain, db2advise, db2look, db2move, db2top and db2pd to monitor, analyze and make changes in the database.
● Development, performance monitoring and tuning for UDB 10.5 , 11.1 versions
● Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing the server.
● Plan and implement disaster recovery and standard recovery testing using established documentation
● Provide 24X7 on-call support to troubleshoot issues with the Production schedule.
● Perform capacity planning and analysis and implement required changes on the database server