Preet Kamal

This project aimed at implementation and maintenance of Medicare/Medicaid plan benefits for Federal Healthcare clients as per CMS guidelines. It involved evaluating client intent pertinent to different lines of business and effectively cascading functional requirements across respective downstream teams. The client benefit grids were processed through Salesforce portal to create and maintain health plans in RxClaim platform.

• Collaborated closely with stakeholders to identify opportunities for process improvements and drive continuous innovation in the organization.
• Interacted with internal customers to understand business needs and translate into requirements and project scope.
• Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
• Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
• Implemented best-practice methodologies that improved overall project delivery timelines while maintaining quality standards.
• Enhanced company-wide decision-making by developing comprehensive reports on key performance indicators.
• Strengthened regulatory compliance by updating internal processes in line with new industry standards and legislation.
• Collaborated with IT to develop business intelligence tools, enhancing quality of data-driven decision-making.
• Designed process-oriented Visio flowcharts to enhance clarity on Formulary Management, Copays, Drug Utilization Review (DUR), Refill Management.
• Utilized Salesforce Lightning cloud for case management, resolution, defect/issue tracking.
• Created & Maintained Requirements Traceability Matrix (RTM) to effectively document/manage Test results pertaining to project requirements.
• Created detailed Project Charters for leadership review & sign off.

Environment: Salesforce Lightning, Microsoft PowerBI, Tableau, JIRA, AS400, EZ Query & EZ Test Web Portal

This project migrated data from QL to Rx-claim Platform. The data was divided into two categories- Group and Member. Group data dealt with client information while member data dealt with participant’s information. The data was migrated in two forms -DELTA: data was sent on daily basis, SLAM: history data up to 2 years of migration date was sent to Rx-claim platform.

• Created High Level and Low-level Designs as per functional requirements.
• Performed Coding, Unit Testing, and Code Reviews.
• Created Requirement Traceability Matrix to map all requirements to test case execution.
• Redesigned Batch/Online modules to streamline and improve throughput times.
• Automated backend data verification by writing DB2 queries.
• Involved in troubleshooting and debugging programs.
• Responsible for providing Design and Results walkthrough to the client.

Environment: Quality Center, GUI Interface, Stored Procedure, SFTP, COBOL, JCL, DB2 Editor, ISPF, VSAM, CHANGEMAN, XPEDITOR, SPUFI, FILE MARVEL, MS Word, MS Excel, MS Visio 2007, OS/390 (QL Platform)

Data Warehouse Acceleration project was a multi release project intended to expedite loading data on EDW2 in ELDM format. This project focused on loading Member/Member Eligibility data from each of the source systems.

The EDW2 is used to support reporting for the PBM business by Enterprise Analytics (Analytics and Outcomes or A&O). The EDW2 is a self-service warehouse where all data consumers write their own processes/queries to extract the data.

• Analysis of business requirements.
• Designed high level design approach.
• Developed various components including COBOL codes, JCLs, Procedures, Stored procedures, Multi-fetch DB2 Queries, Copybooks, Control Cards and GDG Creation tools.
• Prepared Unit/System Test Plans, Test Cases and Test Results documents.
• Performed Unit and System testing.
• Created Regression Test Plan and executed Regression Testing on the system.
• Prepared detailed integration plans and executed integration testing.
• Implemented defect prevention techniques.
• Deployed the modules to production environment in adherence to the deployment protocols.
• Tracked post deployment results and periodically examined behavior of the new/modified components in the production environment.
• Attended weekly status meetings and provided detailed status report to the client.
• Provided support during deployment of components to production environment.
• Received client recognition for introducing high level Multi-fetch DB2 Select queries to enhance system performance.

Environment: COBOL, JCL, DB2, MQ, ISPF, VSAM, Xpeditor, SPUFI, Quality Center, File Aid, SAR, MS Office.

This project’s objective was to enhance Member Master Record update process in LINKS application to ensure data consistency between LINKS and SAP, thus providing accurate reported information to account teams and clients. The goal was achieved by creating additional triggers on certain DB2 tables so that any update made on the fields in these tables alone would trigger a Member Master Record feed to be sent to SAP.

• Analyzed high level design and suggested design approach for the new and impacted components.
• Created detailed Unit Test Plan.
• Coded programs and performed unit testing.
• Provided support during System Integration Testing and User Acceptance Testing.
• Fixed defects (if any) reported during System Integration Testing and User Acceptance Testing.
• Performed post deployment analysis and reporting.
• Attended weekly status meetings.
• Created project documents for internal audit.

Environment: COBOL, JCL, DB2, MQ, ISPF, VSAM, Xpeditor, SPUFI, Quality Center, File Aid, SAR, MS Office, Mainframe OS/390 (QL Platform)

Northern Trust is a leading provider of specialized financing and asset management services. The work for the project was received in the form of new application development, enhancements in the existing application, End to End testing, preventive maintenance and FIRECALL support. Legacy Trust System maintains the back office financial accounting and supports their critical path applications. The project involved synchronizing the CV/CASH between Security database (comprising of the securities traded) and the Holding-database (comprising of the various holders participating in trading) on daily basis. The purpose of the project was to automate the process of settling the out of balances thus reducing the manual efforts and time spent on the same. The successful implementation of the venture resulted in a substantial dollar saving for the client and was highly appreciated.

• Analyzed the functional requirement documents.
• Prepared high level design documents.
• Coded highly complex programs to identify and rectify the out of balance amounts between two core banking backend applications.
• Removed manual intervention to correct the frequent out of balance scenarios.
• Built an automated stream of programs to fetch and correct out of balance records.
• Attended weekly status meetings and provided detailed status report to the client.
• Production support (24*7) for critical Legacy trust banking stream. Consistently fixed production issues within strict SLA timelines.

Environment: COBOL, TSO/ISPF, JCL, IMS DB, DB2, Remedy, SCLM scheduler.