Senior Mainframe Developer

Mainframe engineer

Prajakti Kulkarni

Phone: 602-***-****

Experienced Mainframe Applications Developer with expertise in Relational databases, Data Analysis, file systems, and Production Support to maximize business results in service operations worldwide.

Over 13+ years of global technology and industry experience working in complex Credit Card Fraud, Payroll and Insurance projects and multi-year client programs leveraging SDLC and Agile Environments including daily stand ups and KANBAN board,.

Thorough knowledge of db2-SQL, db2 stored procedures and SQL queries writing, indexes, tables etc. all SQL related features.

Experience with Data Visualization tools like Tableau with knowledge of Big Data, Hadoop, Pig and Hive.

Worked in complex client engagements for Syntel, TCS and American Express.

My skills include

●Knowledge of AMX data, working standards and work culture.

●Hands on experience in software development life cycle, by generating technical design and specifications determined from business requirement documents

●Ability to manage multiple projects and priorities in a fast paced environment

●Develop and modify applications

●Perform extensive research and analysis for problem resolution

●Perform extensive testing and provide excellent quality work to clients.

●Implement programming changes to the production environments following release strategy procedures

●Provide technical expertise, direction and leadership to other team members

Technical Experience:

Operating Systems: z/Os, IBM 3090, Windows

Data Visualization tool: Tableau

Big Data : Hadoop, Pig, Hive

Database/OLTP: DB2, CICS

Languages: COBOL

Other s/w, Tools: JCL, TSO/ISPF, CHANGEMAN, DB2 utilities like QMF, SPUFI, BMCDB2, File-Aid and all its utilities, Xpeditor, VSAM

-

EXPERIENCE:

Tableau Certification Training/Course 10/2017 – Present

-Completed Tableau Training/Course with online instructor at Edureka and their Certification Project using dataset “Global superstore” to show visuals of “Top refunds compared to sales by Country and predictions of refunds

During training worked on following :

- Developed Tableau visualizations and dashboards using Tableau Desktop

- Created Tableau dashboard for data visualization reports using interactive views, calculations, parameters, LOD expressions, actions, various filters, dates,

- Built dashboards for measures with forecast, trend line and reference lines.

- Created workbooks using sets, drill down feature, marks, quick calculations, maps, geographic features etc.

- Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

- Connected to various types of data sources to build data visuals.

- Working knowledge of creating Tableau workbooks from multiple data sources using Data Blending.

- Attended online training for Big Data, Hadoop, Pig, Hive

- Tableau Certification in progress

American Express (FTE) Phoenix AZ 08/2015 – Till 09/2017

Project – Fraud reporting applications

Role: Engineer II.

Software: COBOL, DB2, JCL, FILEAID, CHANGEMAN, SERVICE-NOW, VSAM, CTLM, BMCUTIL, SSRUTIL etc.

Responsibilities:

Worked on enhancements and maintenance of following fraud related applications

Worldwide Fraud Information System

Captures and maintain prop/GNS CM data globally. Provides Fraud data to interface systems for investigation. And performs fraud reporting.

Security Worldwide database

Maintains Investigation, Security violated

Incidents and Executive protection DATA globally. Reports data to FEDERAL criminal application

Membership rewards fraud

Membership rewards fraud data and reporting

Secondary Customer Authentication

One time password authentication and maintenance

-These applications gather worldwide information of all AMEX frauds via WEB, data power, flat files, MQ and VSAM files and stores in various db2 tables and thereby the fraud is reported to downstream systems like IDN, cornerstone, GFR in required formats.

All applications are in DB2, maintaining over 100 stored procedures and over 200 batch programs/batch jobs including few IMS programs and MQ programs.

-Worked in consistent development/maintenance of these applications using DB2/COBOL/JCL. Used various utilities like CTLM, BMCUTIL, FILEAID, BMCDB2, SPUFI, CTSMENU, Workbench module WBM to refer to common routines.

-Involved in project Kickoff meetings with business and senior engineers. Also worked on Rally, KANBAN, JIRA for tracking project schedule, budget and relevant changes.

-Proficient in Fraud business and various kinds of Fraud reporting. Working knowledge of WEB to mainframe interfaces since these applications interact with each other via online fraud data entry screens and stored procedures in Mainframe.

American Express (contractor) Phoenix AZ 10/2001 – 09/08

Mainframe Programmer/Analyst - Payroll Project

Role: Senior Analyst, Senior Developer

Software: COBOL, JCL, VSAM, CICS, FILEAID, XPEDITOR, PC Applications, INFOMAN, CHANGEMAN, AGILE

Responsibilities:

●From 09/2007 - 09/2008

Project – AMEX - US Payroll production support

-Overall responsibility in the team is support production issues 24 hours and work on preventive actions to stop Payroll system from breaking.

-Support tasks included US Payroll’s breakfix, business and technical analysis, documentation, code fix and implementation of changes.

-Gathering and compilation of business information from client and preparation of related documentation, Use MANAGENOW effectively to fix system issues within service level agreement (SLA).

-Worked on various Severity 2 and severity 3 problem incidents and fixed them within the AMEX approved SLA time. Fixed many major issues of AMEX Payroll

-Maintained very good relationships with team, trained and helped team members when required.

Project – AMEX - US Payroll production support plus development

10/2001 – 06/2004 AND 08/2005 – 04/2007

-Overall responsibility in the team is support production issue as well as working on payroll enhancement projects, discussions with clients, documentation, designing, programmer-analyst, reviewer, tester, implementations, of projects.

-Worked various development projects such as set up Client Payroll interfaces for new vendors (i.e. AFLAC, BOA, ROSENBLUTH), AEFA data conversion for migration to Ameriprise and AEFA data decommission that included extensive analysis of employee data, AXIOM reporting. Maintenance of TIME and Attendance tracking system developed in CICS as needed.

American Insurance group, Cary NC (contractor) 03/1997 - 03/2001

Mainframe Programmer/Analyst – Insurance Package Projects

Role: Senior Analyst, Senior Mainframe Applications Developer, QA, Production

Software: COBOL, JCL, VSAM, CICS-DB2, FILEAID, XPEDITOR, EZTRIVE, PC Applications, INFOMAN, CHANGEMAN

Responsibilities:

Managing General Agents (MGA) - team of 3 people

-Supported and maintained package with Offshore- Mumbai, India.

-This package received Data on mainframe from vendors in different formats and media and converted all data to a common format and sent for regression.

-Set up agents’ data chain through the system.

-Use of DB2, COBOL, JCL, VSAM and related mainframe utilities.

online/batch application conversion from sequential to CICS-DB2 platform on Mainframe.

Premium Regression Batch system

-Rewrote PREMIUM DATA EDITS system Role including hundreds of data edits/integrity checks and Data data error reporting to Users.

-Complex System and Technical Analysis, Design, Specifications, Developer, Tester

-Daily Interaction with off shore team

-Implementation as well as Production Support.

Workers Compensation

-Worked as Application developer, Support and maintenance of proprietary Workers Compensation Insurance package WCPC.

-Provided 24 hours Production support.

EDUCATION:

B.S. - Bachelor's of Engineering (Computer Engineering) from India (Solapur,Maharashtra)

No Work Authorization required to work in US.

Contact this candidate