PUJA BISWAS

*** ********* **, **********, ** ****0 740-***-**** ac0oap@r.postjobfree.com www.linkedin.com/in/pujabiswas17 EXPERIENCE SUMMARY (DOMAIN – Manufacturing And Supply Chain Management) I have an extensive knowledge of working as a Mainframe Developer with close to 5 years of experience in end-to-end implementation and transformation projects. Used skill sets like COBOL, JCL, ENDEVOR (for change management), JOBTRAC (for scheduling), DB2-SQL (for data processing) in my capacity as a Senior Developer for application support and enhancements of a legacy system. I have gained vast experience in working with stakeholders from diverse geographies across the globe and was involved in project planning, project delivery, and customer management. CERTIFICATIONS & SKILLS

Certification: .NET L3 (Wipro Internal need based training for Microsoft) Skills:

Operating System – z/OS, TSO, MVS, ISPF

Data Management System – DB2 (SQL), VSAM

Programming language – COBOL, JCL, C, JAVA (basic) Scripting language – PERL Programming; UNIX Shell Scripting Mainframe Tools – JOBTRAC, ENDEVOR, ISPF, QMF, SAR, SDSF, Spool, Lotus Domino, have worked on IBM MQ series

WORK EXPERIENCE

Sr. Software Engineer Jan ’16 - Present

Wipro Technologies (Client - Honda North America, Inc.), Ohio, USA

Worked as a senior developer to manage inventory and production control across 18 plants in North America

Conducted physical inventory for two plants from onsite location (Alabama and South Carolina), provided offsite support for Canada and Marysville plants, which involved the following activities - o Comprehensive data analysis, data verification, modification from plant using Microsoft Excel, SQL and JCL

o Process the data through several batches (which included COBOL program changes and JCL changes) o Direct interaction with end users and business team for final verification and reviews

Analyzed COBOL programs, the database and core functionalities of the application, modified the programs and subprograms for optimization to save mainframe CPU utilization up to 15%

Analyzed user requirements and designed unique solutions for performance tuning / enhancement of the system as per customer requirement, which involved the following activities - o Requirement gathering from end users and business team o Creation of design documents based on the BRD received from user o Design & development of test cases & test scenarios o Development of the code using COBOL program, JCL to execute the program in Endevor o Prepare the test data either from user or simulate test data in PS flat file or modify the data in test database o Execute and drive the unit testing and see the result in SAR or SPOOL based on the o/p type selected o Prepare the test results for user validation and conduct final UAT with end users o Promote the changes in JCL or COBOL through System modification request & packages (in Endevor)

Automated application functionalities to stabilize the system and increase efficiency by 65% and cost saving up to

$10k/month

Debugged COBOL program & JCL changes and suggested immediate fixes to address production critical issues Software Engineer Aug ’13 - Dec ’15

Wipro Technologies, (Client - Honda North America, Inc.) Hyderabad, India

Worked as an individual contributor, for the project, my responsibilities included understanding Design documents, CUT and UAT support of the system application

Designed & developed different interfaces using IBM MQ, COBOL and JCL which automated data transmission between different location saving 100% data reliability and minimal manual intervention

Created the test environment/test data (Developer / Dev environment) using the following - o ENDEVOR to create test JCLs

o Create appropriate test files (PS / VSAM for GDG creation) o Compile the programs/sub programs to match the version o Verify the MQ setup (channel, file name, file length etc) between sender and receiver o Identifying valid values, exception values and creating gold list of values o Verify the email confirmation, Print confirmation (o/p going to printer)

Developed auto-generating reports using COBOL program, JCL and SQL to notify end users about system performance/delays

Perform 24/7 production support and address any JOB failure due to Space (SB37, SE37), Lockout (-911), Resource unavailable (-904), data not found (100) etc.

Develop and deploy small to medium sized enhancements using, COBOL, JCL

Incident closure on time via HEAT followed by ITSM (ServiceNow) with proper recovery of the issue and resolution provided

Analyze the incident trend and differentiate the repetitive failures and deploy permanent resolution for the same

Regular interaction with user/client to address any issues reported by them within SLA time

Analyzed and fine-tuned SQL queries for code optimization and better performance Software Engineer Dec ’12 - Jul ’13

Wipro Technologies, Hyderabad, India (Induction Training & Internal Project)

Prepared test cases for the different applications like Nagios, Asterisk, Windows 7, Bugzilla and Ubuntu as per requirement specification provided to verify their expected behavior using Perl scripting

Developed a menu driven application (ATM application) using Perl scripting language

Developed knowledge in Unix Shell Scripting, COBOL programming, JCL LEADERSHIP ACTIVITIES

Project Lead, Wipro Ltd. Mar ’15 - Dec ’16

Introduced NextGen initiative, huddle meeting, time management sheet, DILO etc to the project to ensure transparency of deliverables by the team, reduce bottlenecks, sharing of new ideas by individual and well co- ordination in team.

Created a staffing model to reduce the overall late deliveries

Drove a project with a team of 9 to archive old data from database to improve performance by - o First analyzing the data in Database (using SQL) and communicate to business team about the old data in database.

o Understand the business logic for data retention o Design programs & JCLs to move the data from database to TAPE and then removing them from the database EDUCATION

B.Tech in Information Technology 07/2008 – 08/2012 West Bengal University of Technology, India GPA: 7.58/10 Higher Secondary 05/2006 – 05/2008

Bidya Bharati Girls’ High School, India PC: 77%

Major – Science