Sundeep Thotpalli

Email:adc8or@r.postjobfree.com

Mobile: 856-***-****

PROFESSIONAL SNAPSHOT:

● Solutions-driven professional with 12+ years of experience in designing/ Coding/ implementing technical solutions and support for top clients like EdwardJones, Cox Automotive, Royal Ahold, Commonwealth Bank of Australia, OMI (Oregon Mutual Insurance), General Motors, UnitedHealth Group(UHG).

● Extensive Knowledge in requirement gathering, analysis, design, development, implementation, testing, deployment, documentation and maintenance of IBM Mainframe applications

● Excellent working knowledge in core application design, development, Testing and production support

● Ability to multi-task work across different applications, diverse work experience with different functionalities of applications with development and production support projects

● Experience in handling projects in various roles as Team member, Team Lead, Technical specialist, Programmer and Software consultant

● Excellent at troubleshooting issues and problem solving and experience in MIPS reduction activities. Provided solution for repetitive job abends and reduced ticket count.

● Hands on experience with OS/390, Z/OS, COBOL, PL/1, CICS, DB2, IDMS, JCL, VSAM SORT Utilities, Easytrieve, SAS, File-Id, File Manager, DB2I, SPUFI, Endeavor, CA-7, IBM Utilities, FTP, HTML, Changeman, Panvalet, WIN-RUNNER, Teamtrack tools, TT4ZMF, MS Office (MS-word, Excel, Power Point).

● Hands on experience with Python and SPARK.

● Experienced in working with various Python Integrated Development Environments like IDLE, PyCharm

● Experience with Requests, Numpy, Matplotlib, and Pandas python libraries during development lifecycle.

● Self-motivated, highly committed to responsibilities, ability to work independently and ability to perform well within cross-functional teams

● Quick learner and good team player, ability to meet tight deadlines and work under pressure.

● Proven ability in working individually or as a part of team, Problem solving, Process improvement activities, Analytical skills, reporting and Assisting to Manager.

● Test-to-break attitude with Quality Oriented mind setup. ACHIEVEMENT HIGHLIGHTS:

● Received Outstanding Performance award in 2010 for AHOLD project.

● Always rated high in yearly performance appraisals in spite of strict organization bell curve adherence in performance evaluation.

● Received Outstanding Performer certification from OMI.

● Received Spot Spark award in (UnitedHealth Group) UHG Employment Summary:

Client : Edward Jones

Designation : Sr. Software Engineer

Duration : July 2019 – April 2020

Client : Cox Automotive

Designation :Software Engineer

Duration : Mar 2016 – June 2019

Organization : Mphasis, HP Company

(Royal Ahold,GM,OMI, Commonwealth Bank of Australia) Designation : Module Lead

Duration : May 2010 – Jan 2016

Organization : UnitedHealth Group (UHG)

Designation : Sr. Software Engineer

Duration : Jul 2007 – April 2010

PROFESSIONAL EXPERTISE:

Edward Jones (Domain - Financial)July 2019 to April 2020 Environment/Software : Z/OS, TSO/ISPF, COBOL II, JCL, CICS, VSAM, CTG, DB2, CA-7, XPEDITOR,, File-Aid, CoreFTP,SPUFI

Responsibilities:

● Work with initiative leads, product teams, technical leads, architects, subject matter experts, developers, technical support groups and test teams to deliver value to the business

● Discuss with initiative leads and product owners to come up with business requirements which will be documented as user stories in HP Quality Center tool for technical and non-technical teams to enhance and scale up the existing and new products.

● Work with technical leads, architects, subject matter experts and Support groups to analyze existing metrics and brainstorm ideas to come up with new metrics that will add value to the business.

● Gather and review software and interface design and requirements – Consolidated Audit Trail & Fractional share project .

● Discuss with technical architects to review data models that are created and make sure data models are in line with business requirements.

● Work with architects to review high level interface designs and after approval, work on creating low level design.

● Refine and decompose requirements to the level of detail required to initiate development – Consolidated Audit Trail & Fractional share project

● Analyze, refine and decompose the requirements into fragments to derive modules required to initiate development.

● Develop new / modify existing mainframe programs for Consolidated Audit Trail & Fractional share projects.

● Develop new or modify the existing COBOL+CICS+DB2 programs.

● Develop COBOL CICS Interface Gateway Modules that interact with Java Web applications.

● Develop JCLs, PROCs and SYSIN Control Cards for DB2 Data Unload/ Load Utility.

● Create File-controls to validate the files before processing through the mainframe programs.

● Create Job document and Schedule document, information containing the scheduling of mainframe batch jobs.

● Perform unit testing of mainframe programs and document results – Consolidated Audit Trail & Fractional share project

● Analyze the requirements and decide on possible test cases for all mainframe programs using testing tools.

● Document the test cases for efficient testing and made sure code passes all the quality gates standards.

● Perform unit testing, system testing, and integration testing and user acceptance testing for all ALP efforts. Observe, infer and document the test results.

● Complete code reviews for mainframe program changes and related components, and complete documentation of issues identified and action items.

● Work with project architects and subject matter experts to review the developed mainframe programs. Code reviews are done, and issues were logged into the workbook and later fixed in the next build.

● Log and document issues using HP Quality Center (QC) so that they can be tracked in the next release.

● Correct testing defects and support all testing, including but not limited to: Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing – Consolidated Audit Trail & Fractional share project

● Log all identified defects at every stage of testing in HP Quality Center.

● Support and work towards identifying fixes for the identified defects and log them.

● Work towards fixing all identified issues to deliver a defect free product.

● Perform troubleshooting on all mainframe based applications – Consolidated Audit Trail & Fractional share project

● Used XPEDITOR to debug mainframe programs.

● Review application bottlenecks and possible opportunities wherever possible to bring-in an enhanced performance and an optimized process. Worked with IS performance team to perform a performance test by load testing the system and coming up with solutions to improve the system performance.

● Proactively come-up with cost-effective, optimized and enhanced solutions to come across the inferred extensive range of complications.

● Perform code version control activities – Consolidated Audit Trail & Fractional share project

● Used CA Workbench tools to version control the mainframe programs and other related elements.

● Document all the new elements and modified elements and their versions in the project directory. COX Automotive (Domain - Automotive) March 2016 to June 2019 Cox Automotive is an automobile auction company and the world's largest wholesale auto auction based on trade volume with 145 auctions located in North America, Europe, Asia and Australia. As a subsidiary of privately owned Cox Enterprises, Inc. Cox Automotive’s primary business is wholesaling vehicles via a bidding process using traditional and online formats. Cox also provides other vital dealership and wholesale services, such as financing, title work, transportation (auto hauling), recovery, auto body repair, dealership management systems, dent repair and automotive reconditioning, and automotive remarketing at each location. Role : Software Engineer

Environment/Software : Salesforce.com, SOA, Java, Oracle Apps, IDE, Mainframes(COBOL, JCL, DB2), API, XML, and Python

Responsibilities:

● Analysis, maintenance and support of Oracle, SOA, BEE, Mainframes systems

● Working on client requirements in Java, Mainframes and Salesforce applications.

● Conduct and/or facilitate the discovery and definition of business process, data and system requirements in cooperation with business and IT partners.

● Business requirements and technology assessments

● Gap analysis and General advisory services and Triaging data issues between Mainframes, BEE (Informatica, Tibco), Oracle APPS (OM, AR) modules and ODS (Oracle warehouse system)

● Interact with integration infrastructure and varied systems

● Develop apt standards and controls to ensure every system’s projects function effectively perform all varied applications as well as operating systems.

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

● Evaluate, design, code and test improvement as required to complex modules.

● Develop system parameters and interact for complicated components

● Design and develop code applications to technical and functional programming standards. Creating defects for different teams

● Involved in Code construction in Mainframes systems

● Eliminate constant computations by performing them when the program is compiled.

● Query Optimization and fine tuning the queries to reduce the elapsed time up to 15% to 20%.

● Delete from the program, and identify with a warning message, code that can never be executed (unreachable code elimination). To see how the optimizer works on your program, compile it with and without the OPTIMIZE option and then compare the generated code. (You can request the assembler language listing of the generated code by specifying the LIST compiler option.)

● Coordinate and involve in structured peer reviews and walkthroughs.

● Participate in releases, Smoke tests and production roll-outs

● Created Data tables utilizing PyQt to display customer and policy information and add, delete, update customer records.

● Involve in building database Model, APIs and Views utilizing Python, in order to build an interactive

● Monitor and organize all client invoices and perform all timely assessment for all payment issues.

● Perform data analysis and facilitate in delivery to all end users. RCU, Commonwealth Bank of Australia (Domain - Payments)April 2014 to Jan 2016 The Commonwealth Bank is Australia’s leading provider of integrated financial services including retail banking, premium banking, business banking, institutional banking, funds management, superannuation, insurance, investment and share broking products and services. RCU is one of the CARDS package team part of CBA.RCU supports all the major cards operations. RCU having various application like GCPS, GCMS, ACB, ACF etc. Role : Module Lead

Environment/Software : Z/OS, TSO/ISPF, COBOL II, JCL, CICS, VSAM, DB2, CA-7, Informatica, Endeavour, File-Aid, CoreFTP,SPUFI Responsibilities:

● Work with IT and Business users to evaluate complex user requests, projects, and clarify objectives and functional requirements for new or modified computer programs

● Independently formulate detailed program specifications using structured analysis and design methodology. Prepare project documentation when needed.

● Independently code new or modified computer programs into existing systems and test program effectiveness. Perform analysis of complex systems issues or changes.

● Develop detailed application designs and specifications for Payment applications. Served as technical lead capacity during project development phase.

● Worked on the standards team to modify system JCL, PROCS, and other system resources to conform to information system standards in support of online and batch processing.

● Delete from the program, and identify with a warning message, code that can never be executed (unreachable code elimination). To see how the optimizer works on your program, compile it with and without the OPTIMIZE option and then compare the generated code. (You can request the assembler language listing of the generated code by specifying the LIST compiler option.)

● Provide technical assistance to resolve operating issues. Provide on-the-job training for new or less experienced programmers who join the team.

● Mentor team to improve their understanding and skill and ensure they are familiar with resource materials including manuals and systems documentation.

● Modify existing software to correct errors, to adapt it to new hardware and to upgrade user interfaces to improve performances.

● Technical support to technical teams to resolve complex issues by providing appropriate solutions as needed and involve other teams if the issues develop due to interfacing applications. Analyze and propose alternative methods if the criticality is high.

● Performed Root cause analysis to identify the cause of issues in the Test/Production environment by the team during SIT, UAT & implementation.

● As a Tech lead, to provide an estimate of the project tasks and assigns the tasks to team members based on the priority. Provide technical guidance to team on technical issues

● Prepare the tech designs, test plans and test cases documents. Load them in QC.

● Developed multiple batch and online programs in Mainframe technologies OMI- Oregon Mutual Insurance (Domain - Insurance)Dec 2013 to April 2014 Deals with P & C (Property and Casualty). Commercial/Personnel Lines Database is a relational database that is updated weekly representing a full book of in-force Commercial Lines policies for each line of business. From there they can individually query and build reports as needed CLDB Solution is designed using ETL processing. This is a Claim creation application for the vehicle related policies. This application has three parts, Client Application (which is used by Agents), Web Service & Batch Programs. Client application will provide facilities to Agents to create new claim which includes loss notice, details of the claim. Web Service part of the application is having the business logic to calculate the eligibility, premium calculation logic, policy benefits add remove options etc. Also this part will communicate with both client application, Policy Issuing systems & database. Batch part will take care of synchronization of data like claim details / active policy details etc with Policy Issuing systems (Mainframe & DB2). Role : Module Lead

Environment/Software : Z/OS, TSO/ISPF, COBOL II, JCL, CICS, VSAM, MQ, DB2, VM, VSC, REXX.

Responsibilities:

● Problem Analysis / Problem Reporting (analysis of programs / bugs)

● PROD Support activities for existing/new applications

● Customer Interaction

● Technical support to technical teams to resolve complex issues by providing appropriate solutions as needed and involve other teams if the issues develop due to interfacing applications. Analyze and propose alternative methods if the criticality is high.

● Primarily responsible for preparing/reviewing Design, Test and Develop components.

● Report project status on a daily / weekly or need basis.

● Ensures code quality is maintained by participating in the coding guideline preparation, review checklist preparation and code reviews

● Wrote Technical Specification Documents (TSDs) for each assignment including a description of proposed changes, expected effects, and sample code to upload to the project SharePoint site

● Installed over 50+ new modules for a major client product release upgrade on COBOL Exceed Billing Application comprising COBOL programs and CICS GUI interface screen programs.

● Provided DB2 tables analysis, worked with DBA on application performance improvement.

● Ensures the project is compliant with the MphasiS process.

● Ensures Configuration Management of all documents and source codes are created/ maintained as per the CM plan.

● Ensures Change requests are handled as per the Change Management process.

● Performs detailed Impact Analysis

● Document the bug fixes made and codes written

● Coded mainframe development assignments in COBOL, modified tables in DB2, created job cards in JCL to run batch jobs, and modified online screens using CICS.

● Prepare and performing Unit Test Plan / Design.

● Review another team member's work and implement review suggestions GMNA, General Motors (Domain - Manufacturer)Feb 2013 to Dec 2013 Project Description: GM-GBS is General Motors Global business services operations. General Motors Corporation (GM) is the world’s largest auto company by annual production volume and by sales volume. GM with global headquarters at Detroit, USA, manufactures its cars and trucks in 33 countries. GBS has two horizontal business divisions, HR and Financial services. Role : Module Lead

Environment/Software : Z/OS, TSO/ISPF, COBOL II, JCL, CICS, VSAM, DB2, IMS/DB, CA-7, Xpediter, File-Aid, File-Manager, Abend-aid, SDSF, SPUFI, FTP Responsibilities:

● The GMNA-GM GBS project is focused on providing the Customer Services Request

(CSR) and Production Support services to GMNA GBS for their various applications in areas of Finance and Human Resources.

● Involved in Preparation of Detail Technical Design, Coding, Test Case Preparation, Execute Regression Test suites (SIT, UAT).

● Modified, recompiled and tested many COBOL programs to bring them up to standards and COBOL 5.2.

● Worked with the Data Management Team and QA during the different testing/QA phases

● Provided reverse engineering - analyzed existing COBOL programs of the Program billing Accounting System and created detailed specification,documents that are used to produce business and functional requirements for the new Direct Billing System

● Works with the development team to develop and define application scope and objectives and prepare functional and/or technical specifications.

● Responsible for Providing Detailed Estimate and Milestone Dates.

● Review of all Artifacts before Delivery to Client.

● Prepare Implementation Checklist and Ensuring Error free delivery of code.

● Prepare all Project and delivery Related Documents.

● Production cycle monitoring (24 * 7 * 365) job flow for all GMNA GBS batch jobs.

● Acting as Back-up for the Team lead .Participate and Host the weekly status meetings

● Post Implementation Support

ROYAL AHOLD (Domain - Retail)May 2010 to Feb 2013

Ahold USA is the world's third largest grocery retailer. Ahold USA has presence in the eastern part of United States with about 1000 super markets. Ahold operates three retail companies i.e. Stop & Shop, Giant Landover and Giant Carlisle. Role : Module Lead

Environment/Software : Z/OS, TSO/ISPF, COBOL II, JCL, CICS, PL/1, VSAM, DB2, MQ-Series, Assembler, CA-7, Auto-sys, Xpediter, File-Aid, File-Manager, Abend-aid, SDSF, SPUFI, QMF, Informatica, Mercury Quality Center(QC), NDM, Connect Direct

,FTP, HTML, Java Script, XML, MS Office (MS-word, Excel, Power Point). Responsibilities:

● Ensures quality of deliverables is made during every phase of the project and it is in accordance to the agreed commitments with the Customer.

● Provided Technical help to the team as a Senior Developer.

● Investigation of Customer queries on potential system problems

● Developed programs using COBOL, JCLs, PROCs, DB2, and CICS. Developed CICS BMS Maps using SDF II tool.

● Experience in using NDM / Connect Direct tools to transfer data.

● Developed programs using MQ Series in Online and Batch environment.

● Responsible for Test Execution (Unit, System, Integration and User Acceptance Testing) in mainframe applications as well as in Web applications.

● Participated in peer reviews of Designs, Code, test results.

● Developed Front end web applications using HTML, Java Script and used XML for transferring data from Mainframe to Web applications.

● Experience in using STROBE tool for DB2 performance tuning.

● Work with front-end (Java/J2EE) development team to resolve issues in development and integration testing.

● Use Xpediter and Interest tools to debug CTG programs.

● Involvement in Production support activities during and after the implementation of jobs. Used CA-7 for job monitoring and scheduling.

● Code SQL SPUFIs to generate ad-hoc reports for business user’s verification and matrix purpose.

● Performed Incidents Analysis

● Performed production cycle monitoring

● Resolve all types of ABENDs and update the resolution in Ticket tracker

● Perform Cause Analysis Report to identify the root cause and fix the issue permanently if possible.

CDD, United Health Group (Domain – Health care)July 2007 – April 2010 The Customer data delivery (CDD) is an Application to deliver the data extracts and claim reports to internal and external vendors. Taking data from different sources and process that data to deliver the different types of reports or feeds. CDD make links with in internal applications by providing the reports.

Role : Sr. software Engineer

Environment/Software : Z/OS, TSO/ISPF, COBOL II, JCL, VSAM, DB2, SAS, PL/1, File-Aid, Endeavour.

Responsibilities:

● Handling the SPRFs, WOs & ad-hoc works Analyzes and evaluates detailed business and technical requirements. Codes and maintains complex components of information systems.

● Mentors others on coding standards and performs code reviews.

● Develops and performs system testing and fixes defects identified during testing and re-executes unit tests to validate results.

● Aids in integrating activities with other IT departments for successful implementation and support of project efforts.

● Provides on call support and monitors the system and identifies system deficiencies.

● provide and implement technical solutions to a wide range of difficult problems.

● Works independently on most aspects of work

● Provide prime assistance toward application releases installation into production under given direction.

● Understanding the requirements and assigned them to team members

● Assist team members to understand the requirements and provide solutions 10

● Review the tasks done by the team members and suggest the changes if any

● Document unit test plans and prepare all release documents related to WOs and SPRFs.

● Make sure that all tasks have been delivered as specified in the requested schedule

● Handling the tracking and status sheets shared same with Project manager

● Reporting the status to customers

Contact this candidate