Rajani Patel Email and Phone Number

Analyzing and documenting requirements for the movement, integration and reconciliation of customer data files.Interact with various stakeholders include customer implementation teams and technical IT teams to bring on new customers on to Rx Claims system involving the design and activation of data interfaces, and analyzing/uploading large data files to Client's software systems. Importing/exporting large data files using big-data tools FileZilla, WS_FTP and Robot jobs. Documenting data mapping to ensure external data files align with internal file systems. Testing and validating data file loads for accuracy and ready for the customer's to go-live.Working on Prescription Benefit Management systems marketing projects such as Retail to Mail and Hospice diagnostic code related analysis.Resolving installation ftp issues caused by production systems: length change in fixed length standard files or update to record layout not implemented in production.

Gathered requirements, documented requirements in Requirement Trace Matrix format, elicited requirements from business stakeholders, meeting with technical teams along with business stakeholders.Held project proposal walkthrough, reviewed requirements with both business stakeholders and technical teams. Managed projects to enhanced Settlement transactions process to accept Canadian Dollar and Japanese Yen currencies. Prepared and published projects documents for approvals.Managed projects to migrate from WAS6 (Web Sphere Applications) to WAS8 version. Created technology platform to utilize DB2 Stored Procedures instead of creating DAPs (Data Access Programs) using CICS. Managed projects to enhanced Bank Table to maintain Swift Code and BIC (Bank Identifier Code) information of foreign banks. Enhancement enabled the company to board and maintains entity with foreign currenciesManaged project to reduce mainframe cost by fine tuning SQL queries in programs, eliminated batch jobs, deleted unused data sets, and modifying screens to remove rarely used functions. The efforts saved $160,000 in a year.Created Use Cases, High Level Design and Detailed Technical Design documents for new and enhancement to systems. Coding and testing new and enhancement to systems. Created documents to outline Processes, Functions, and technical requirements.Adhered Data Loss Prevention guidelines defined by the company. Guidelines outlined who, how, when, and where certain; new or modified data, can be accessed in at what capacity such as by an individual, in a program, or during batch job execution.Managed projects to retired old applications. Managed entire project of retirement of old application which spread across 5 different technology teams.Worked with On-Shore and Off-Shore resources to complete projects on time within budget.Created and tested test cases in Unit, System, Integration, and UAT test environment.

Enhanced and maintained an application which sent promotion materials to perspective card members to apply for Discover Credit Card.Enhanced and maintained an application which created promotions to Discover Card members to increase Discover Card usage.Enhanced and maintained an application to issue Discover Cards to perspective members who passed all credit related guidelines such as FICO score, income, and work history. Utilized Fiserv rules engine to evaluate credit card applications.Enhanced and maintained an application to board and maintain entities on Discover Card Network.Worked with VSAM, DB2, SPUFI, DB2 Stored Procedures, COBOL II, OS JCL, TSO/ISPF, File Aid for DB2, and FTP in IBM MVS mainframe environment.

Assigned to work on Global Security Lending Project that dealt with securities lending to prospective borrowers and related systems processing from initiation to completion of each transaction.Created new and maintain existing DB2/COBOL II programs and Stored Procedures, JCLs, PROCs, Copybooks, and Controls to add more functionality during different releases within GSL project. Used SPUFI to test imbedded SQL code in batch/online modes.Coordinated walkthrough and regression testing on the GSL project. Refreshed test DB2 tables with production data, ran regression batch cycle overnight, and on call to fix abends during batch run. Worked with VSAM, DB2 Release 7, SPUFI, COBOL II, OS JCL, TSO/ISPF, File Aid for DB2, File Marvel, Platinum DB2 product, Princeton Utilities for DB2, LOTUS Notes, and FTP in IBM MVS mainframe environment.

Unique ID Conversion project for health claim system. This project assigned Unique Id to replace SSN on members benefit ID cards. Monitored UID conversion job and fix abends as they occurred. Loaded Excel worksheet for ID conversion requests.Created new and maintained existing DB2/COBOL II programs to automate SPUFI in batch mode. These SPUFI were run manually in the past. This enhancement eliminated human interventions.Enhanced Unique ID conversion process within health claim system to eliminate job abends on Group/Section process.Worked with COBOL II, VSAM, DB2, Access, SPUFI, COBOL II, OS JCL, TSO/ISPF, LOTUS Notes, and FTP in IBM MVS mainframe.