Dynamic Data Analyst with a proven track record at Finthrive India Pvt Ltd, adept in leveraging Azure Synapse Analytics and SQL to enhance business decision-making. Excelled in collaborative projects, improving data visualization and integrity. Skilled in both technical analysis and cross-functional team leadership, significantly boosting analytical capabilities.
· Schedule data loads from SQL tables to Azure SQL/SQL tables by using Azure Data factory.
· Extensively working in data Extraction, Transformation and Loading from source to target system using SQL Server Integration Services (SSIS).
· Scheduled the ETL Package (Daily-Job) Using SQL Server Management Studio.
Building MQ connectivity on all the Test, QA and Live environment. Updating the end to
end MQ connectivity documentations.
· Creating MQ objects and Queue manager setup.
· MQ migration & Upgradtion - Installation & Decommissioning of MQ Series in different
platforms and also level up on MQ versions.
· SSL configuration & installation - Configuring SSL by installing the Certificates in the MQ
keystore Repository and troubleshooting all SSL related MQ errors.
MQ Cluster setup and troubleshooting of production cluster issues.
· Configured Queues in the cluster for Workload Balancing.
· MQ Channel level and application level trigger setup and Troubleshooting issue on trigger
environment.
· Multi-instance setup and troubleshooting issue.
Creating Message Brokers & Execution Groups.
· Creating Integration Node & Integration servers. Deploying Archive files in applications.
· Configurations of broker objects and properties at Broker and EG level.
· Start and stopping Broker, EG & Flows as part of maintenance activity.
· Deploying the bar files and decommissions of flows and EG.
· Increasing the JVM heap size Memory, Debug port and HTTP port setup, ODBC driver
setup.
· Good Knowledge on Keystore/trust store setup and certificate installation.
· Ability to understand flow and debugging skills from error logs.
Having good experience in Installing & configuring IBM WebSphere MQ Series on various environments like Windows & Linux.
Configured MQ queue managers, queue manager objects like queues, channels and listeners,process, Trigger Monitors.
Created MQ series objects on local and remote MQ servers.
SSL configuration & installation - Configuring SSL by installing the Certificates in the MQ keystore Repository and troubleshooting all SSL related MQ errors.
MQ Cluster setup and troubleshooting of production cluster issues.
Configured Queues in the cluster for Workload Balancing.
MQ Channel level and application level trigger setup and Troubleshooting issue on trigger
environment.
Azure Synapse Analytics