Naveena Kallam

• Innovative software developer with several years of hands-on experience designing and testing applications. Well-versed in agile methodologies and coding languages. Dedicated to developing creative solutions to meet business goals and requirements.
• Skilled Production Support Analyst with broad background in managing and resolving complex production issues. Strong ability to maintain system reliability, improve service level agreement compliance, and drive process improvements. Demonstrate high levels of technical troubleshooting acumen, system administration knowledge, and strong project management skills. Previous roles have resulted in improved operational efficiency and reduced downtime.
• Skilled in analyzing and improving computer systems to enhance business operations. Experience includes identifying system requirements, designing solutions, and integrating software applications to optimize workflow and increase efficiency. Strengths encompass strong analytical skills, adept problem-solving abilities, and proficiency in developing user-friendly solutions. Contributed to significant improvements in system functionality and user satisfaction in previous roles.

• Awarded with Excellency certificate from CIGNA client for effective support during September Release in 2014 at CGI.
• Received ‘Pat on the back’ award twice for completing more than 150 hpsm tickets on a single day in CGI.
• Received ‘Corona’ award for excellence efforts in Settlement Tracking Application in CGI.
• Received High Five award for continuous support and providing permanent fixes for recurring abends in Bank of America.
• Received Bronze award twice in Bank of America for automation of CRH application and supporting the application/deployments without any delay in Covid situation.

• Certified in Healthcare domain (PAHM Certified).
• Certfied in IBM Info Sphere Data Stage v9.1.

Bank of America, Plano, TX: from 12/5/22 to till date

Project Name: Mortgage System

Environment: DevOps, XLR, Ansible, Autosys, Toad for Oracle, SQL Server, IBM Info Sphere Data Stage, Linux, Hive, Hue, Jira

• Preparing plans: Preparing build/environment plans for projects
• Configuring applications: Configuring applications that integrate with existing applications.
• Supporting new releases: Playing a key role in implementing new releases, and providing post-production support.
• Using the build tools to have latest chnages across all LLE environmnets and test the application end to end to have smooth Production installation.
• Capturing all the issues in each release and create defects through JIRA/Defect mgmt to avioid further issues in production.

State Street, Tx: from Nov 2021 to 12/2/22.

Project Name: GMT Risk management System

Environment  : Autosys, Toad for Oracle, PL SQL, IBM Info Sphere Data Stage, Linux, Hive, Hue, Service now, Python.

Roles and Responsibilities:

• Production support for all Risk applications.
• Identifying and fixing issues with ETL jobs and following escalation procedures.
• Tracking incidents and changes, and planning production changes using change management tools.
• Collaborating with other people, such as network engineers, developers, and production engineers, to provide solutions to end users.
• Identifying problem areas and providing actionable insights. Identifying opportunities to improve the efficiency of ETL scripts.
• Resolving high-impact production issues by working on development tickets.
• Analyzing new system enhancement requirements from users, designing, coding, and testing new changes.
• Attending status meetings with clients. Preparing the SOP for the issues we faced in prod environment with root cause and resolution.

Bank of America, Plano, Tx: from Nov’2016 to April’2021

Project Name: Batch Support Services

Environment  : ISPF/TSO, Cobol, JCL, DB2, File – Aid, Endeavour, Spufi, QMF, File manager, VSAM, IMS DB, CICS, CA7, ABEND AID, and CA-7 scheduler, Autosys, Toad for Oracle, PL SQL, IBM Info Sphere Data Stage, Linux.   Domain :Banking

Roles and Responsibilities:

• Design, develop and maintain Mainframe COBOL, JCL, DB2 to meet support and/or project requirements.
• Interface with business and IT teams to understand business requirements and translate business requirements into formal technical requirements and application code.
• Responsible to evaluate/create packages for production deployment activities using Endeavor TSO/ISPF Mainframe.
• Automated the jobs to avoid manual interventions in batch executions.
• Worked on SR requests for production scheduling/changes for both Mainframe and Midrange applications.
• Experience in Regression testing for end-to-end application.
• Schedule the jobs through Auto sys and CA7 in Production and Test regions.

 HSBC (Global Repository), Hyderabad, India from Aug’15 to Apr’16

Environment: IBM InfoSphere Data Stage 9.1, Oracle, Mainframe

Roles and Responsibilities:

· Scheduling a job in CA ESP Scheduler, Modify the jobs, running days, Dependencies, Running Ad hoc requests, Moving Programs to Productions, Promoting the JCLs to production after checking the JCL, creating new calendars, modifications to existing Calendars, Setting/Removal of Job dependencies/File dependencies/Time dependencies for Jobs.

· Fixing the job abends based on the severity of the job.

· Monitoring Remedy, Resolving the remedy tickets within SLA.

· Used the DataStage Designer to debug processes for extracting, cleansing, transforming, integrating, and loading data into the data warehouse database and also the process of loading data into Data-mart.

· Used the IBM DataStage designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

· Worked with different source systems like sequential files, Oracle data base and DB2.

· Implemented Shared container for multiple jobs and Local containers for same job as per requirements.

· Adept knowledge and experience in mapping source to target data using IBM Data Stage 8.x

· Extracted data from flat files and then transformed according to the requirement and loaded into target tables using various stages like sequential file, look up, Aggregator, Transformer, Join, Remove Duplicates, Change capture data, Filter and Oracle Enterprise.

Client Name: CIGNA (Billing and Banking), Hyderabad, India from Mar’15 to July’15

Environment  : COBOL, DB2, JCL, xpeditor, Endeavor, File aid, CA ESP, Data stage

Roles and Responsibilities:

· Scheduled jobs, prepared batch flows, System and Integration test plans. Involved in Coding, Unit testing and Co-ordination with team and Review of deliverables.

· Design, code, test, debug, and record those programs proficient to work at top technical level of every level of applications programming activities.

· Identify and prepare test data needs for the requirements

· Developing and modifying the programs based on the requirement.

· Involved as ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Info Sphere software (Data Stage v8.1)

#Project Name: Sales and Underwriting (STARS) , Hyderabad, India

Client    : Connecticut General Life Insurance Company (CIGNA)

Project Duration : Aug-2011 to Mar’2015

Environment  : S/390, COBOL, DB2, JCL xpeditor, Endeavor, File aid, CA7, ESP, IMS DB

Roles and Responsibilities:

· Scheduled jobs, prepared batch flows, System and Integration test plans. Involved in Coding, Unit testing and Co-ordination with team and Review of deliverables.

· Monitoring the production batch job flow through CA-7 and CA ESP Scheduler to insure successful job completion.

· Following escalation procedures for job failures to perform job restarts.

· Monitoring batch cycles for daily, weekly, monthly, quarterly, yearly jobs and report statistics to client and to provide immediate fixes to the production abends.

· Ensuring timely completion of batch cycles and all the transaction processing regions are up on time.

· Design, code, test, debug, and record those programs proficient to work at top technical level of every level of applications programming activities.

· Identify and prepare test data needs for the requirements

· Developing and modifying the programs based on the requirement.Unloading and Loading data from production to different test regions

· Identify and prepare test data needs for the requirements.

Project Name: Sales and Underwriting (Stop Loss) , Hyderabad, India

Client    : Connecticut General Life Insurance Company (CIGNA)

Project Duration : Oct-2010 to Aug-2011

Environment  : S/390, COBOL, DB2, JCL xpeditor, Endeavor, File aid, CA7, ESP

Project Application Description:

STOP LOSS was developed to process Individual and Aggregate pooling/reimbursement, new products/contract flexibility and the clarification of contract terms.