Jitendra Singh Rathour

SUMMARY

**+ years’ experience in IT industry

Experience in analysis, design, Development, debugging, testing and maintenance of software applications.

Created industry standard Technical specifications and Business requirement documents.

Experience in Data Analysis/Analytics & Data Migration.

Data preparation and Statistical Analysis using Python & R

Wide spectrum of industry experience spanning Airlines, Insurance and Healthcare Industry

Exposure to Modeling tools (CaGen, ERWin)

Pursuing MS in Analytics from Georgia Institute of Technology.

SKILLS PROFILE

Communication

Skilled communicator, proficient in putting a point forward in efficient manner.

Focused negotiator with an aim to elicit answer in black and white and avoiding greys.

Extensive experience documenting all aspects of software development.

Created industry standard documentation for churning out analysis of the requirements, design documents.

Technical Skills

Operating System: MVS (OS/390), UNIX, Linux, HP NonStop Kernel, Ubuntu LTS 12.

Tools: COOL:Gen/CaGen/AdvantageGen, Canam Report Composer, CE-EDIT, Accessgen, CSE Access, QuikJob, InfoMan, Service Manager, ChangeMan, Endevor, CA-7, Smart Test, Tandem, UltraEdit, GuardIEn, SpecBuilder, VSS, Lotus Notes, DB2 Master logs, GDGs, Abend-Aid, QMF, Rumba, Extra X-treme, QuickStart, MQ-Series, SoapUI, BMC Catalog manager, CaseGen, ERWIN, SQL Navigator/Developer, Maestro

Agile/Defect tracking: Test Director, HP Quality Center 11, JIRA, Version One

Languages: Cobol, JCL, SQL, Focus, Python, R, C, C++, SAS, SAS/AF, HTML, CSS, JavaScript, SVG, D3.js

DBMS: DB2, MS SQL, NonStop SQL, IMS, Oracle, SQLite3.

Visualization Tools: Tableau, D3.js, ggplot2, matplotlib

Performance Monitors: CA Insight, CAMat, APMConnect, DynaTrace

Log Monitors: Splunk, Kibana

Analytics: Predictive/descriptive/prescriptive statistical modeling, Time Series Analysis, A/B Testing, Matlab, R-Studio, Jupyter Notebook, Spyder, excel solver, Open Refine.

Cloud familiarity: AWS S3, EC2, EMR, Azure ADFs, Azure ML

PROFESSIONAL WORK EXPERIENCE

Role: Senior Application Developer

Application maintenance and enhancement by modifying existing programs or writing new ones for backend programs for Web Interfaces (delta.com), Batch Applications, Data Life Cycle (DLC), TUX, Client-Server/CBD and Online CICS Applications.

Data Analysis, data Conversion, data migration and Data Fixing

Requirement Gathering, Analysis, Design, Coding, Testing, peer reviews

Preparing design documents, test plans, test cases, generating reports

Defect logging, tracking & fixing

Production support, production migrations and Offshore Coordination.

Conducting/Attending JAD sessions with Business users and Business system Analysts to gather and understand the requirements

Following Agile Methodologies.

Participated in Being Agile workshops.

BESTBUY, MN MARCH 2020 – TILL DATE

Project: Javelin (Tech Lead)

Javelin application is an analytical tool to forecast promotional pricings to optimize the revenue. ADF pipelines prepare data to be used by the forecasting model to make various promo price predictions.

Built the batch data pipelines for daily and weekly data movement from on-prem Teradata to Azure hive & SQL DB using Azure Data Factory.

Leading a team of 4 to support and enhance the application.

Analyze and resolve the pipeline failures due to upstream delays, data issues or infrastructure related issues.

Data validation in hive & SQL DB post daily and weekly refresh.

Automation - Integrated slack notifications with azure ADF and configured Dynatrace for application monitoring.

Generate Adhoc reports & trend analysis using R, Excel & SQL for business users.

Created What-Ifs and SOP (standard operating procedure) documents for the application using confulence.

Environment: Azure ADFs, HDInsight/Spark clusters, PySpark, Hive, R, SQL, Linux, Maestro, Teradata, Splunk, Kibana, Dynatrace, Excel, R, R-markdown, Python.

Delta Air Lines, Eagan, MN Mar 2009 –Feb 2020

Project: Delta Vacations - Suntrac

Sr Developer

Delta Vacations provides the vacation packages including air and ground services. Suntrac is the core of the system which includes the backend programs to add/manage data, rules and get availabilities, book and manage reservations, handle customer support etc.

Project: SkyMiles Frequent Flyer System

Sr Developer

SkyMiles is the frequent flyer program of Delta Air Lines. Members earn miles for air and non-air activities with Delta and its partners and can use the earned miles to redeem air/non-air awards.

Have developed the backend programs for Login/Account Summary/Activity Tracking/Modify Member Profile / Retrieve Member Info and Delta Sky Club on Delta.com

Major projects –

Loyalty Integration – After the merger of NWA & Delta Air Lines, their Frequent Flyer programs ‘WorldPerks’ & ‘SkyMiles’ were merged to become the largest Frequent Flyer program of the world. Existing WorldPerks system was modified and enhanced to accommodate the new requirements after the merger. Huge amount of data was analysed/filtered/modified and migrated/merged to the new system. New backend programs were written for several channels like Delta.com, CMS/RES, VRU/IVR, Shuttle, EDP, SNAPP etc.

Performed huge scale data migration and conversion using Batch jobs. Coded some of the most frequently used backend programs/services like Member login Activity Tracking/Account History, LoyaltyInfolite, RetrieveMemberInfo etc to be used by multiple channels like DELTA.COM, DeltaVacations.com, CMS/AXIS, SNAPP, DLTERM, IVR/VRU

EOS/RBMA (Revenue Based Mileage Accrual) – milestone project to convert existing distance (flown) based model to revenue based model. Number of new services/programs were added, most of the existing programs were modified.

Cyber Security: Analyse the data for accounts targeted by cyber attackers, identify patterns and generating multiple reports for further analysis by the Business team.

Here are few more projects to name:

CINCO/Modified Availability

Pay With Miles

POLARIS

Upsell as an Ancillary

Comfort+/Premium Cabin

Branded Fares

Choice Benefits

SHUTTLE/Kiosk & EDP

Environment: Cobol, DB2, MVS, CICS, JCL, ChangeMan, CA-Gen, Host/CS Encyclopedia, Accessgen, VSS, MQ-Series, HP ALM (Quality Center) 9.2, soapUI 2.5.1, DB2 Insight, Quikjobs, SQL, Brio, MQ Series, SAS, Infoman, Service Manager, Quikjobs, APMConnect, DynaTrace, CE-Edit, AccessGen.

Kaiser Permanente (KP), Pasadena, CA May 2008 – Feb 2009

Project: KPFS (Kaiser Permanente Foundation System)

Sr. Programmer Analyst

KPFS is Kaiser’s information management system for group and individual health plan administration. It is the main source for maintaining member benefit information. KPFS is used for a variety of reasons, including medical record number look up, membership history, benefit eligibility and purchaser information.

Worked in Foundation System’s Medicare program as a senior Programmer analyst. Was responsible for maintaining and enhancing the existing system. Attended HIPAA training and earned the certificate of recognition.

Environment: MVS, DB2, JCL, COBOL, CaGen, CICS, myEXTRA, CE-Access, GuardIEn, ChangeMan, QuickStart, HP Quality Center 9.2, Lotus Notes, DB2 Masterlog.

Texas Medicaid & Health Partners (TMHP), Austin, TX Nov 2006 – Jan 2008

Project: National Drug Code (NDC)

Sr. Programmer Analyst

Enhancement of the existing Claim processing system to accommodate the new functionality ‘National Drug Code’ (NDC) as a result of new federal legislation.

Project: National Provider Identifier (NPI)

Sr. Programmer Analyst

The Texas Medicaid & Healthcare Partnership (TMHP) carries out the Medicaid claims payment and Primary Care Case management administrator duties for State of Texas.

Currently a Medicaid provider can have multiple provider identifiers (TPIs for Texas Provider identifier for Texas’ providers) based on type, location and specialty. After the NPI implementation, all providers will have a unique id (NPI) irrespective of their type, location and specialty. This process needs all existing TMHP systems which currently use TPI to be enhanced/modified to handle the NPI.

My roles was to identify and request the data model changes to accommodate the NPI rules in the system and modifying existing programs, creating new programs based on the requirements. Attended HIPAA training.

Environment: C, CaGen Proxies/CBD, Tandem, OutsideView32, CSE Access, GuardIEn, Test Director, UltraEdit, Cool:gen CS Encyclopedia, Canam RC, HP Non-Stop kernel, Non-stop SQL, SpecBuilder

Aetna Healthcare, Middletown, CT July 2006 – Nov 2006

Project: HMO Enrollment

Business Analyst

*This was a Business Analyst role involving Preparing Use Cases and requirement documents, co-ordinating with teams in 4 different locations.

Environment: Visio, MS Word, MS Xcel, ClearCase, ClearQuest, DB2, MVS, Windows XP, JCL

St Paul Travelers, Minneapolis, MN Jan 2006 – July 2006

Project: Direct Billing Enhancement

Sr. Programmer Analyst / Onsite Co-ordinator

After the merger of St Paul Companies and Travelers’ insurance company, they were required to merge the existing information systems of both the companies and enhance the system to incorporate new requirements. Direct Billing is one of the Billing systems which includes receiving and processing the Bills from Insured/Agent issued by different issue systems, Creating and sending Notices, Dividend Calculations, Cash handling, ePay-eBill etc.

Played a key role in Knowledge Transfer sessions during the initial stage of the project and in building up the team at offshore.

Environment: Cobol, Db2, IMS, MVS, JCL, Endevor, Coolgen Proxies, Host Encyclopedia, Canam Report Composer, CaseGen, Smart Test, Lotus Notes

Northwest Airlines, Minneapolis, MN Jan 2002 – Jan 2006

Project: Worldperks System

Sr Programmer Analyst / Team Lead/ Onsite Co-ordinator

WorldPerks was NWA’s Frequent Flyer program before merging with Delta. The system involves Enrollment, Promotions, Air and Non-Air accruals and redemption Processing, member information (customer details), Agent Booking System and Interface. CICS screens and Cool:gen/Java GUIs are used as user interfaces wherever required.

Environment: Cobol, DB2, MVS, CICS, JCL, ChangeMan, CA-Gen, Host/CS Encyclopedia, Accessgen, VSS, MQ-Series, HP ALM (Quality Center) 9.2, soapUI 2.5.1, DB2 Insight, Quikjobs, SQL, Brio, MQs, SAS.

Project: Focus Sunset Feb 2004 – Jul 2004

Sr Programmer Analyst

NWA decided to sunset all FOCUS applications; used for reporting, database access, and decision support. All focus programs needed to be converted to other platforms and languages acceptable within the NWA technology architecture to achieve the same functionality as the existing FOCUS programs and reports. The Architecture proposes to use SAS and SAS/AF on Mainframe for all programs. .Net was used for internet based application. .Net shall initiate request for voluminous reports to be generated on mainframe using SAS. The project involves extensive data extraction and loading into DB2 tables.

It involved analysing existing focus programs and preparing program specification and detail design documents to convert the existing Focus programs into SAS.

Environment: FOCUS, SAS 8.2, SAS/AF, DB2, MVS, JCL

EDUCATION & QUALIFICATION

Master of Computer Applications (MCA)

A 3 year post graduate degree course from IPS Academy, Indore, MP India.

Bachelors Degree in Science (BSc with Mathematics Major)

A 3 years degree course from DSB College, Kumaun University, Nanital, India.

Currently pursuing MS in Analytics at Georgia Tech University, Atlanta, GA

adlwfr@r.postjobfree.com

www.linkedin.com/in/jitendrarathour

https://github.com/JSR2000

Ph. 952-***-****

Contact this candidate