Project Developer

PADMANABHARAO POKURI

Email: *********@*****.***

Ph: 952-***-****

Professional Summary

** ***** ** ********** ** IBM Mainframe Technologies with all phases of project Life Cycle including Requirement Analysis, Program Design, Development, Unit testing, System Testing, Integration Testing, Maintenance and Documentation.

Extensive knowledge and Good Experience in Mainframes (COBOL, DB2, JCL, and CICS) and on other tools like File-Aid, Endevor, Changeman, Expeditor, and CA7.

Good Experience in the agile and waterfall project methodologies.

Good Experience in the migration projects from Mainframes to Java, Mainframes to .Net.

Good Experience in the database migration projects from IMS to DB2 Tables, DMS-II to DB2 Tables, VSAM files to DB2 Tables.

Good Experience in the Tera data migration projects.

5+ years of hands-on experience in IT Project management

Experience in leading teams. Involving into multiple activities - Production Maintenance, development, support, Teradata Hardware/Software Upgrade, Disaster recovery, System Upgrade.

In-depth expertise in a broad variety of IT skills, such as project planning, systems development, systems design, systems maintenance, helpdesk/user support, documenting system requirements and changes, infrastructure implementation, and network administration.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player. Good communications skills and the ability to interact with business users.

Work in fast-paced team environment with focus on quality.

Work on projects with minimal supervision.

Summary of Skill Set

IBM Mainframe Technologies

VS-COBOL 74/85, MF-COBOL, Micro Focus COBOL, JCL, DB2, Easytrieve, CICS, IMS-DB/DC, SAS, DB2, Natural, VSAM, PL/1,

Unisys Mainframe Technologies

MCP, Clear path Series, WFL, CANDE, BLSOURCE, DARGAL, WORDER, BLSCHED, BLDIST, SOAP, DUMPALL, Evolve IT DMS.

Teradata Technologies

Teradata Macros, BTEQ, MLOAD, FASTLOAD, FAST EXPORT, Teradata SQL Assistant, Teradata Manager, PMON, Putty

Operating Systems

MVS/ESA, OS/390, Z/OS, MCP, SMP/E, Window 95/98/XP/7, Unix, Red Hat Enterprise Linus 5, Clear path Series.

Tools

TSO/ISPF, ENDEVOR, CHANGE CONTROL, CHANGE MAN, JES2, XPEDITER, FILE-AID, FILEAID-DB2, FILEAID-IMS, INSYC, FILE MASTER, MAX/VSAM, BMC Utilities, VIASOFT, INTERTEST, CA7, XGEN, Cande, BLSource, Workbench, FTP, NDM, SYNCSORT, Dump master, TELON, Progeni, PLATINUM, IBM DB2 TOOLS, SPUFI/QMF, Crystal Reports, Cobol-Report Writing, Teradata SQL Assistant, Teradata Manager, PMON, Putty

Version Control

ENDEVOR, PANVALET

Debugging Tools

VIASOFT, INTERTEST, XPEDITER and SMART TEST

Job Schedulers

CA7, and control M

Reporting Tools

Crystal Reports, Cobol-Report Writing, SFUFI/QMF, Power Builder Reporting (Data windows)

RDBMS

Oracle, Sybase, SQL server-2000, DB2, PL/SQL

Monitoring tool

HP open view, Remedy.

Java Technologies

Java, J2EE, Eclipse, Tomcat, Web Sphere, XML, HTML, JavaScript, JDBC, EJB, SOA, CSS, JSP, JQuery

Micro Soft .Net Technologies

VB 4.0/6.0, ASP, Share Point, Microsoft Visual Studio

EDI Tools

Powerbuilder, TOAD, PLSQL Developer, NetBeans.

Presentation Tools

MS Visio, MS Power Point

SDLC

Agile, Waterfall

Education & Certifications

Bachelor’s in Computer Science & Engineering, Andhra Pradesh, India

Certified IBM DB2

Professional Experience

Worked as Team Lead in Keane from Feb’2004 to July’2010

State of California, CA July’2016 to till date

Sr. Mainframe Developer

The CalWIN Consortium (California Work Opportunity and Responsibility to Kids Information Network) was developed as a modern technological solution for efficiently administering public assistance programs and providing quality service to the communities.

CalWIN is a integrated on-line, real-time automated system with 26 subsystems to support eligibility and benefits determination, client correspondence, management reports, interfaces and case management for public assistance programs.

CalWIN supports CalWORKs/TANF, RCA, Food Stamps, Medi-Cal, CMSP, CAPI, IHSS, Foster Care, KinGAP, Cal-Learn and General Assistance/General Relief. CalWIN also supports employment services programs for WTW, Child Care, FSET and County specific employment programs.

Responsibilities:

Responsibility to create Functional Design Documents based on Mainframe COBOL/DB2 programs.

Responsibility to create Data Flow Diagrams based on Mainframe Jobs.

Responsibility to create Front End Designs based on CICS screens.

Responsibilities to support Other Java Teams.

Analysis of the data stored in DB2 tables and the mainframe files required for the Java Team.

Replace number of legacy mainframe batch processes into Java process.

Reduce number of processes accessing mainframe database for accessing information

Reduce cost and redundant data flowing across complex applications.

Prepared/updated project related knowledge documents and Quality documents.

Ability to quickly understand and code Mainframe COBOL /DB2 programs and created business flow documents.

Provide production support maintaining, troubleshooting, and problem solving with existing State CalWORKs Mainframe COBOL/DB2 business programs and systems.

Develop project plans and detailed schedules.

Use industry and/or State CalWORKs mandated standard coding techniques and testing processes

to ensure quality.

Document all programming work per State CalWORKs standards.

Enhance existing State CalWORKs systems to meet new business requirements.

Explain and/or document complex problems and solutions in an understandable manner to both technical and non-technical State CalWORKs personnel.

Present technical solutions and alternatives to management and decision makers at a level of understanding commensurate with the audience.

Configure, build and maintain the production run processes. Mainframe job and processes.

Solve problems that arise with database data, production runs and/or the systems products (on-line screens, reports files or interfaces).

Tuning and optimization of COBOL/DB2 programs and systems.

Maintenance of system documentation.

Troubleshoot, Identify and correct reported or suspected errors with code, logic and/or data.

Apply necessary and discretionary system changes and/or fixes, making system enhancements as required by IT management, business units, statutes, contracts or the system’s underlying architecture and/or technology as authorized by State CalWORKs IT management.

Helpdesk related activities for Policy system related problems and issues.

Create new applications, programs and/or interfaces in order to resolve problems.

Technical Lead or assistant with development teams.

Share knowledge, mentor and train State Fund staff, on a regular and ongoing basis through the State CalWORKs Mentoring and Skills Enhancement program as well as shadowing and consistent transfer of information form Consultants to State CalWORKs project team members

Environment: TSO/ISPF, MF-COBOL-II, JCL, CICS, DB2/IMS, Oracle, VSAM, SPUFI, SVN, INTERTEST, CHANGE MAN, MQ Series, JAVA/J2EE/HTML, JAVASCRIPT, TOAD

State of West Virginia, Charleston, WV Jan’2016 to July’2016

Sr. Mainframe Developer

The West Virginia Department of Health and Human Resources (DHHR) is comprised of five bureaus: Bureau for Behavioral Health and Health Facilities; Bureau for Child Support Enforcement; Bureau for Children and Families; Bureau for Medical Services; and Bureau for Public Health. DHHR has a statewide presence and employs nearly 6,000 individuals.

Responsibilities:

Responsible for production support 24X7.

Responsible to identify the root cause for production abends.

Provided emergency Bug fixes in production environment.

Mainly involved in the Business requirements, Design documents, and reviews. Installation of the project.

Mainly involved in development and maintenance of the project.

Mainly involved in development of the project using COBOL, DB2, JCL and CICS.

Responsible in preparing weekly reports and delivering the reports on time.

Involved in on call support team activities and adherence to SLA.

Worked upon many root cause analysis and gave the best resolutions to customers.

Involved in improving the performance activities of the project.

Preparing the Knowledge documents for future reference in the project.

Tuning the mappings for better performance

Identifying and resolving the Bugs issues in design documents

Performing unit testing, integration testing and UAT

Preparing release note documents for different releases and involving in installation and post installation of the project.

Mentoring fresher's in the team on project related activities.

Communicated with the users and resolved the issues in timely manner.

Environment: TSO/ISPF, MF-COBOL-II, JCL, CICS, DB2/IMS, TELON, SAS, VSAM, SPUFI, PLATINUM, FILE MASTER, INTERTEST, EZYTRIEVE, CHANGE MAN, CNTL-M, MQ Series, JAVA/J2EE/HTML, JAVASCRIPT

Blue Cross and Blue Shield Association (BCBSA), Chicago, IL 2nd Feb’15 – 31st Dec’2015

Project: SF Sub System - Inter-Plan Teleprocessing Services (ITS)

Sr. Mainframe Developer

The Blue Cross Blue Shield Association (BCBSA) is a federation of 36 separate United States health insurance organizations and companies, providing health insurance to more than 106[2] million Americans.[3] Blue Cross was founded in 1929, and became the Blue Cross Association in 1960, while Blue Shield emerged in 1939 and the Blue Shield Association was created in 1948. The two organizations merged in 1982.

Responsibilities:

Responsible to provide production support maintaining, troubleshooting, and problem solving with existing Mainframe COBOL/DB2 business programs and systems.

Responsible to develop project plans and detailed schedules.

Responsible to use BCBS mandated standard coding techniques and testing processes

to ensure quality.

Document all programming work per BCBS standards.

Enhance existing BCBS systems to meet new business requirements.

Explain and/or document complex problems and solutions in an understandable manner to both technical and non-technical.

After analysis, used COBOL/DB2/CICS programs to create data flow ERD diagrams.

Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD.

Worked on exporting data to flat files using Teradata FEXPORT.

Query optimization (explain plans, collect statistics, Primary and Secondary indexes)

Build tables, views, UPI, NUPI, USI and NUSI.

Written several Teradata BTEQ scripts to implement the business logic.

Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.

Worked with Source databases like Oracle, SQL Server

Involved in designing and developing the FDW (Financial Data warehouse) Data load process.

Environment: TSO/ISPF, VS-COBOL-II, MF-COBOL-II, JCL, CICS, DB2/IMS, SAS, VSAM, SPUFI, MKS PLATINUM, FILE MASTER, INTERTEST, EZYTRIEVE, CHANGE MAN, CNTL-M, MQ Series, JAVA/J2EE/HTML, JAVASCRIPT, Terada, BTEQ, MLOAD, FLOAD, FEXPORT

Edward Jones, St. Louis, MO 27th Sep’ 2013 – 30th Jan’15

Lending/Contact Management

Sr. Mainframe Developer

Edward D. Jones & Co., L.P., since 1995 simplified as Edward Jones[1] is a financial services firm headquartered in Des Peres, Missouri in Greater St. Louis which serves investment clients in the United States and Canada, through its branch network of more than 11,000 locations and currently have relationships with nearly 7 million clients worldwide. The firm focuses solely on individual investors and small-business owners. Edward Jones is a subsidiary of The Jones Financial Companies, L.L.L.P., a limited partnership owned only by its employees and retired employees and is not publicly traded.

Responsibilities:

Based on Business Requirement Documents prepared High Level Details Design Documents.

To Prepared Technical Specification Documents for each programs online and batch.

Prepared required documentation, including both program-level and user-level documentation.

Responsible to guide technical direction to other team members to ensure program deadlines are met.

Responsible for gathering business requirements designing, building, and testing Analyst models, and managing the data workflow within the model.

Responsible for the four types of Performance tuning Mapping Level, Session Level, Source Level, and target Level.

Also used Joiner transformation for Heterogeneous Sources

Used parameter files for defining the values and parameters used in sessions and mappings.

Update the Daily status to client.

Maintained the Business Rules Document based on batch/Online programs.

Created JOB flow (Daily, Weekly, Monthly)

Based on requirements to define and update existing Business Processes Documents.

Created Physical Data and Logical Data Diagrams Using Visio.

Performed the Quality standards and work within the specified time frames.

Based on severity, coordinated clients and business users to resolve the issues.

Responsible to create both program-level and user-level documentation.

Responsible to co-ordinate with Business User/Technical Lead as required to ensure program deadlines are met.

Tested, debugged, and refined the system to produce the required result.

Responsible for configuration Management and installed the Migration changes into Production.

Provided permanent fixes for production issues and responsible for performance Tuning.

Responsible for coding and unit testing.

Provided emergency Bug fixes in production environment.

Communicated with the users and resolved the issues in timely manner.

Responsible for code reviews and Unit Test Documents Reviews.

Responsible to update the status to client on daily basis.

Environment: TSO/ISPF, VS-COBOL-II, MF-COBOL-II, JCL, CICS, DB2/IMS, TELON, VSAM, SPUFI, MKS PLATINUM, FILE MASTER, INTERTEST, EZYTRIEVE, CHANGE MAN, CNTL-M, MQ Series, JAVA/J2EE/HTML, JAVASCRIPT, Terada, BTEQ, MLOAD, FLOAD, FEXPORT

Principal Finance Group – Des Moines, IA 30th Oct’ 2012 – 20th Sep’2013

MKS

Sr. Mainframe Developer

The Principal Financial Group® (The Principal®) is a leading global financial company offering businesses, individuals and institutional clients a wide range of financial products and services.

This products and services includes retirement solutions, insurance, wellness programs, and investment and banking products through our diverse family of financial services companies and national network of financial professionals.

Responsibilities:

Worked between onsite and offshore

Responsible to identify the root cause for production abends.

Based on severity, coordinated clients and business users to resolve the issues.

Tested, debugged, and refined the system to produce the required result.

Provided permanent fixes for production issues.

Based on the Production Issue, working on code changes, testing.

Responsible for coding and unit testing for permanent fixes.

Based on severity working on emergency Bug fixes in production environment.

Communicated with the users and resolved the issues in timely manner.

Responsible to update the status to client on daily basis.

Support the offshore team.

Based on severity working with other teams to resolve the production issues.

After analysis, used COBOL/DB2/CICS programs to create data flow ERD diagrams.

.

Technologies: zOS, TSO/ISPF, COBOL, MF-COBOL-II JCL, CICS, DB2, VSAM, IMS,SPUFI XPEDITER, MKS, CHANGE MAN, ABP,QC.

State of Missouri July 2012 – 29th Oct’2012

Sr. Mainframe Developer

FACES MHD Modifications

The system should allow a set of designated users to add new current or insert missing Title XIX period if there is any incorrect gap in coverage. The system should also provide an option to insert a comment, if a new Title XIX period is added.

Responsibilities:

Analyzed functional business applications and creating Details Design.

Prepared required documentation, including both program-level and user-level documentation.

Created data flow by analyzing the existing COBOL/CICS programs.

Generated the reports using EasyTrieve/IBM Utilities.

Extracted and documented Business Rules based on batch/Online programs.

Created a document describing the data transformation for every data element over a specific period of time (daily, weekly, monthly).

Defined and documented existing Business Processes.

Generated visually appealing diagrams using Visio that describe the data flow and transformations at a micro and macro level.

Performed the work within the specified time frames.

Provided technical direction to other programmers as required ensuring program deadlines are met.

Verified the accuracy and completeness of programs and systems by preparing sample representative data and perform testing by means of cycle and system processing.

Tested, debugged, and refined the system to produce the required result.

Responsible for configuration Management and installed the Migration changes into Production.

Gathered requirements and based on requirement to prepare Design Documents, High Level/Low Level Design Documents.

Wrote new programs/change the existing programs.

Wrote/executed complex queries.

Environment: TSO/ISPF, VS-COBOL 74/85, DB2, CICS, VSAM, JCL, IMS, TELON, CNTL-M, EasyTrieve, IBM Tools, IMS, CA7, SPUFI, INSYNC, LIBRARIAN, PLATINUM, WEBAWARE, HTML, JavaScript, Terada, BTEQ, MLOAD, FLOAD, FEXPORT

State of Illinois, Springfield, IL Sep’ 2011 – June’2012

Senior Mainframe Developer

Migration Project: CCMS

Deloitte partnered with State of Illinois to develop Child Care Management System (CCMS) for Department of Human Services. The main objective of CCMS is to provide a children welfare practice throughout the state in an effective and organized manner with optimal utilization of existing systems, programs, and practices.

Responsibilities:

Responsible to convert all TELON programs into Business Documents.

Responsible to create data flow documents from IMS to DB2

Responsible to convert TELON online screens into Java Online Screens.

Responsible to document each fields on CICS screen.

Responsible to replace all IMS calls into DB2 calls

Responsible to change all Jobs IMS calls into DB2 Tables

Replace number of legacy mainframe batch processes into .net process.

Reduce number of processes accessing mainframe database for accessing information

Reduce cost and redundant data flowing across complex applications.

Prepared/updated project related knowledge documents and Quality documents.

Environment: TSO/ISPF, VS-COBOL 74/85, DB2, JCL, CICS, IMS DB/DC, VSAM, SPUFI/QMF, FILE-AID, XPEDITER, EASYTRIEVE, TELON, PANVALET, XGEN, BLSOURCE, CANDE, IBM DB2 TOOLS, JAVA/J2EE/HTML, JAVA SCRIPT.

SUPERVALU Inc. – Minneapolis, MN Aug’ 2007 – Sep’ 2011

Senior Mainframe Developer

Project: Division Accounting/Order well/Logistics Control System/Online Credits

This application manages the receipt of products into the warehouse, the storage of products and delivery of products to the stores. It processes millions of orders coming through Ordewell system, updates inventory, and generates picking tickets and invoices.

Responsibilities:

Worked between onsite and offshore

Responsible for first point of contact for all the issues.

Conducted team meeting with offshore on daily basis and responsible to resolve issue for offshore team.

Responsible to carry the pager to support 24X7.

Responsible to identify the root cause for production abends.

Based on severity, coordinated clients and business users to resolve the issues.

Analyzed functional business applications and created Details Design.

Prepared required documentation, including both program-level and user-level documentation.

Provided technical direction to Other programmers as required to ensure program deadlines are met.

Tested, debugged, and refined the system to produce the required result.

Responsible for configuration Management and installed the Migration changes into Production.

Provided permanent fixes for production issues and responsible for performance Tuning.

Used Opti Dump to see the production abends.

Responsible for coding and unit testing.

Reviewed all the deliverables from offshore.

Provided emergency Bug fixes in production environment.

Communicated with the users and resolved the issues in timely manner.

Responsible for code reviews and Unit Test Documents Reviews.

Responsible to update the team status to client on daily basis.

Environment: TSO/ISPF, VS-COBOL-II, MF-COBOL, PL/1, JCL, CICS, DB2/IMS DB, VSAM, SPUFI, CHANGE CONTROL, PLATINUM, PANVALET, FILE MASTER, INTERTEST, MQ Series, XGEN, BLSOURCE, CANDE, JAVA/J2EE/HTML, JAVASCRIPT and Unisys Mainframes.

Capital One Bank – Richmond, VA Mar’2004 – July 2007

Senior Mainframe Developer

Migration Project: Card Solution Delivery

Worked between onsite and offshore.

Responsible to create data flow documents from IMS to DB2

Responsible to create Business documents based on CICS screens.

Responsible to document each fields on CICS screen.

Responsible to replace all IMS calls into DB2 calls

Responsible to change all Jobs IMS calls into DB2 Tables

Replace number of legacy mainframe batch processes into .net process.

Reduce number of processes accessing mainframe database for accessing information

Reduce cost and redundant data flowing across complex applications.

Prepared/updated project related knowledge documents and Quality documents.

Environment: MVS/ESA, TSO/ISPF, VS-COBOL-II, JCL, DB2, VSAM, QMF, FILE MASTER, VIASOFT, ENDEVOR, UNIX, XML, and Unisys Mainframe, XGEN, BLSOURCE, CANDE, VB, ASP

TATA Consulting Service QWEST, Denver, CO Oct’2002 – Feb’2004

Mainframe Developer

Project: CBTM

Environment: TSO/ISPF, COBOL, EASYTRIEVE, JCL, DB2, VSAM, QMF, FILE MASTER, ENDEVOR, CA7, Abend-AID, PLATINUM, Xpeditor, IDCAMS, DB2 Utilities, PowerBuilder Syncsort, BMC Tools.

Contact this candidate