Mohammad Khasim

Project#1:
Project : NORMATIVE HEALTH INFORMATION (NHI)
Client : UNITED HEALTH GROUP (UHG)
Role : ETL Developer
Tools : IBM DataStage, Oracle SQL, Teradata, CICD, UNIX, WinSCP, TWS.
Duration : July 2024 to till date

Description:

• NHI is a robust, longitudinally linked statistically de-identified database consisting of de-identified individual-level data going back to 1993. It includes subject areas such as administrative claims, membership, provider, clinical data, socio-demographic consumer data, health risk assessments disability information, cancer registry information, inpatient confinements, standardized cost, pharmacy Part D claims and death data.
• NHI Sources: Galaxy, Ovations, PacifiCare, Oxford, IHCIS, PAPI, GOPHER, CDB, FDB, MSA, Social Security Administration (Death Master files), Touchstone, ECODS, UHC Cancer Registry, Humedica (Optum Analytics) and SK&A.
• Migrate applications from AIX to LINUX environment.
• Establish business continuity plan for migration activities and potential actions needed by, and impacts on, end-users.
• Involved in ETL migration from AIX to LINUX.
• Analyze the current ETL workflows running on AIX, Including job designs, dependencies, schedules.
• Updating the DataStage job configurations (Environment variables, job parameters, mountpoint details as per LINUX.
• Enhance the Teradata TPT and Bteq scripts and updating the mountpoint details and system specifications as per the LINUX.
• We will fix the issues we got the approval for my Team lead apart from that we are coordinating with various teams to fix the issues that occurred when jobs/scripts are aborted.
• Involved in user acceptance testing to identifying the roadblocks, which are causing incorrect data in the target system.
• Excellent team player with an ability to perform individually, quick learner, ability to meet deadlines and analytical skills.
• Skilled at learning new technologies can work well under pressure.

Project #2:

Project : Group Client and Third-Party Solutions Outbound Framework (GCTS)
Client : Group Benefit Solutions (GBS)
Role : ETL Developer
Tools : IBM DataStage, Oracle SQL, GitHub, Jenkins, U Deploy
Duration :Apr 2023 to Aug 2023

Description:

• The NYL migration involves the transition of CGI assets under Claims & Leave Management (CALM), Eligibility & Enrollment (ENE) domains from Cigna data centers to New York Life (NYL) hosting (AWS and on-prem). The primary focus of this program is:
• Migrate applications from Cigna to NYL (on-prem or AWS).
• Migrate the business tools form Cigna to NYL.
• Establish business continuity plan for migration activities and potential actions needed by, and impacts on, end-users.
• Rebrand applications, letters, emails, etc. within the 180-day post-close window (externally facing) and within the TSA boundaries (internal-facing).
• We are migrating the DataStage Job and Oracle tables.
• Doing a production support which Our Dev team developed DataStage jobs, we closely monitoring the DataStage jobs and sent reports on daily basis. If the jobs got failed INCIDENT management team raised a ticket via service now.
• We will fix the issues we got the approval for my Team lead apart from that we are coordinating with various teams to fix the issues that occurred when jobs are aborted.
• Involved in user acceptance testing to identifying the roadblocks, which are causing incorrect data in the target system.
• We got the approval and issue got fixed then we moved the code to higher environment by using GitHub, Jenkins and u Deploy CI/CD tools.
• Excellent team player with an ability to perform individually, quick learner, ability to meet deadlines and analytical skills.
• Skilled at learning new technologies can work well under pressure.

Project #3:

Project : Customer Possible Living Abroad (CPLA)
Client : RBL BANK
Role : ETL Developer
Platform : Platform Windows2007
Tools : IBM DataStage, Oracle
Duration : Jul 2019 to Mar 2023

Description:

• CPLA is a project to identify the customer who has living address in INDIA and making some transaction outside of INDIA. We are identifying the customers who are making physical transactions (POS+ATM).
• Analyzed the requirements and framed the business logic and implemented it using DataStage.
• Worked on designing various jobs for extracting data from various sources involving tables and to load the data into target tables.
• Extensively worked in writing the queries into Oracle SQL, which are there in existing legacy system used by the client.
• Worked on improving query performance by keeping the statistics up to date and tuning the converting queries.
• Involved in user acceptance testing to identifying the roadblocks, which are causing incorrect data in the target system.
• Worked on scheduling the jobs in UAC Scheduler.
• Monitored the daily runs of scheduled jobs, which are developed to load the data into target database.
• Coordinating with various teams to fix the issues that have occurred while monitoring the daily runs.

Project #4:
Project : File Inventory Bank
Client : RBL BANK
Role : ETL Developer
Platform : Platform Windows2007
Tools : IBM DataStage, SQL Developer
Duration : Nov 2018 to Jun 2020

Description:

• CyberArk is a Privilege Identify Management Suite that helps to manage all the privileged account within the organization with automatic password Management. The tool prevents data against any kind of CyberArk Attack. It can Secure, Rotate and Control Access to Privileged Account Credential. CyberArk will help fox our issues by managing service accounts and their passwords in the following ways.
• Involved in converting different jobs like DB connectivity and FTP to CyberArk.
• Working with different stages like Dataset, Sequential file, Oracle connector and performed various activities like import and export of DataStage projects.
• By providing an 'in service' and 'out service' service account and rotates them without human intervention.
• By rotating the password of a service account without human intervention.
• By helping to secure the usage of a service account to a specific server/application.
• Worked in secure room (live date access) for to projects.