Professional Summary

• Over 6.5 years of work experience in Requirements Gathering, Analysis, Design, Development, Testing, Implementation and Maintenance.
• Comprehensive experience using Structured Methodology covering entire life cycle of the system in Mainframe applications of Retail Industry and Telecom Industry billing systems.
• Confidential
• Proficient in DB2 SQL, PL/SQL, Embedded Programming, Utilities, Stored Procedures and other supporting tools like SPUFI, INSYNC, EXPLAIN and DBVisualizer.
• Experience in Web Applications using Java, JavaScript, Spring, Swing, Struts, AJAX, HTML, MySQL, PHP, SOAP, JQuery.
• IBM Certified - Database Associate DB2 9 Fundamentals , Solution Developer DB2 9.5 SQL Procedure Developer and Application Developer Programming with Enterprise PL/I .
• Infosys Certified in Retail Domain Retailing Level 1 , Consumer Product Goods Level 1 , and Merchandise Management Level 2 .
• Infosys Certified in Mainframe Technology Level 1 and Level 2.
• Actively looked for scope of Automation in various time consuming tasks and developed tools using REXX and VBA.
• Experience on traditional Waterfall model as well as the emerging Agile Methodology.

Designed and developed complex reports for the business purpose.

• Responsible for maintaining and support production systems at different clients by 24X7.
• Proficient in QA Testing, Test Plans, Test Scenarios / Test Cases and documentation.
• Worked as Programmer, Analyst and played a Team Leader.
• Highly motivated team player with immense ability to grasp new concepts and apply.
• Excellent interpersonal skills, strong communication and presentation skills.

Technical Skills:

• Programming Languages : COBOL, JCL, PL/1, REXX, CICS, EZtrieve, VB Script
• Web Technologies : Java, HTML, JavaScript, PHP, AJAX, Spring, Swing, Struts, JQuery
• Database : DB2, VSAM, MS Access, MySQL, Teradata, IMS DB, XML, JSON
• Other Tools : DB2 Utilities, SORT Utilities, ENDEVOR, CRISS, TSO/ISPF, MQ Series, IBM SPUFI, QMF, INSYNC, FTP, NDM, Lotus Notes, MS Excel with VBA, MS Word with VBA, MS Outlook with VBA, MS Visio, MS PowerPoint, SAR, DB Visualizer, HP Quality Centre, Eclipse, Adobe PhotoShop, Adobe Java Scripting, XAMPP
• Professional Experience: Verizon, Boston, MA
• Verizon Communications, branded as Verizon, is an American broadband and Telecommunications Company and a corporate component of the Dow Jones Industrial Average. Verizon has more than 180,000 employees and has global operations, with more than 200 data centers in 24 countries. Verizon's global network includes over 800,000 route miles, including terrestrial and undersea cable, spanning six continents.

Confidential

Specialist System Development

Objective

To migrate several legacy billing systems into the Next Generation system model provided by the Business and consolidate billing programs into a generalized way easier for scaling up and maintaining. Improve the ways of interaction and streamline communication with other applications like ordering and provisioning systems.

Roles, Responsibilities and Accomplishments

• Coded complex SQLs above 1000 LOC to display bills in the desired format viewable through the v2 framework v2 framework is a customized content management system developed.
• Developed COBOL-DB2 programs to display reports pulled from huge tables. Used staging concepts to create efficient programs that don't compromise performance.
• Worked on DB2 stored procedures, XML, LOB data structures.
• Worked on SQL performance tuning, MQT tables, IBM DB2 Analytics Accelerator.
• Developed efficient PL/1-DB2 programs for several web services and used SOAP utility for testing and debugging. Also designed and coded PL/1-DB2 programs for MQ interfaces to communicate in real time with other applications.
• Modified Java modules in the v2 framework to accommodate the various currency formats, language translations and bill customizations.
• Mentored the new team members and made them productive in a short span of time.

Environment

COBOL, JCL, DB2, PL/1, MQ, REXX, Java, J2EE, JSP, JavaScript, Struts, Spring, AJAX, HTML, XML, Web services, SOAP

Confidential

Specialist System Development

Objective

To migrate all Invoice display programs and billing reports of Millennium Customers from Legacy system into the Next Gen format and v2 framework. Provide all necessary custom functionality available in the legacy applications in the new platform as well.

Roles, Responsibilities and Accomplishments

• A major project developed in Java, J2EE, JSP, JS, AJAX and Struts to present various complex reports to the users with advanced filtering/sorting and grouping functionality. They serve as a good value addition especially to the big customers who want to analyze their bills. This tool also has visual representation of some high level reports which are developed in Adobe Flex.
• These reports are at different levels user id, summary account, billed account, single invoice date and range of invoice date. Though they look up several billion records in the table and bring more than 6000 records in the frontend, we managed to display them in less than 30 seconds.
• Provided download and schedule functionality for reports with huge data.
• Implemented staging concepts for pagination, filtering and sorting. This helps to reduce the processing time for these actions.
• Enforced Agile Methodology in few tasks and successfully accomplished the goal.
• Represented the team and presented the team accomplishments in various skip level meetings.

Environment

COBOL, JCL, DB2, PL/1, MQ, REXX, Java, J2EE, JSP, JavaScript, Struts, Spring, AJAX, HTML

Confidential

Analyst System Development

Objective

This is a web based tool developed accessible by Customers and Customer Care Executives to create inquiries. It provides seamless experience to the Customers by allowing to create inquires easily and add details references to the ticket. This tool helps reps in the Verizon call center to handle customer inquiries at ease, by providing all necessary information handy.

Roles, Responsibilities and Accomplishments

• Involved in early stages of the project by interacting with call centers representatives, analyzing their existing tools, business operations and framing requirements from the gathered information.
• Designed an easy to use dashboard to get a glance of the tickets under a rep and manager.
• Recognized from higher level managers for implementing this new functionality and bringing huge savings to the money spent in call centers and reducing the manual work done by the reps.
• ICI also enabled the customers to create inquires themselves with easy steps which has proved a potential savings of 40 in the operating cost of the call centers.
• Interacted with RADs to keep the designs meet the customer's satisfactory level.
• Suggested ideas in several implementations done by the onshore and offshore team.

Environment

COBOL, JCL, DB2, PL/1, Java, J2EE, JSP, JavaScript, Struts, Spring, Swing AJAX, HTML

Confidential

Analyst System Development

Objective

Confidential is the portal for Enterprise Customers showing billing statements, detailed reports and access the other online services offered. Verizon Business Center VBC is a replica of the VEC with lot more additional functionalities that assist Customer Care Executives. This project focused on the custom bill presentation for each Enterprise Customer based on their location, currency, language and other parameters. The online service offered for each customer also differed based on various factors. We also provided access to Customer Care Executives to view the customer's invoices in VBC.

Roles, Responsibilities and Accomplishments

• Worked on both frontend and backend systems.
• Understood the system in a short span of time worked on different change requests and production tickets.
• Played a vital role in designing and developing a customized Content Management System CMS framework for displaying invoices of the enterprise customers with which the backend programs plug-in to provide various summary and detail level invoices. It is highly efficient as the online bill display is targeted to have a very less response time for the users. This frontend of the v2 framework was developed in Java and the backend is driven from Mainframe DB2 Embedded programming and Stored Procedures.
• Provided ability to pull customized bill formats and render them in less than 10 seconds, which gives a good user experience.
• Billing systems always have a high importance as they directly impact the revenue, hence did extensive testing, ensured defect free delivery and met timelines always.
• Developed several complex reports using SQL of 1000 lines which processed data from huge tables as high as 4 Billion records, complex JOINs and numerous DB2 functions were used.

Environment

COBOL, JCL, DB2, PL/1, REXX, Java, J2EE, JSP, JavaScript, Struts, Spring, AJAX, HTML, XML, Web services, SOAP

Confidential

Senior Software Engineer

Objective

Confidential has different channel of sales like stores, catalog and e-commerce. There were different ordering systems and inventory control systems doing similar functions. This project was to consolidate various job streams in Direct Inventory Management Systems that perform similar activities and to streamline the system.

Roles, Responsibilities and Accomplishments

• Played a vital role in design stage of ECOS project. This involved the study of various job streams in the existing system.
• Analyzed huge COBOL-DB2-IMS programs in the job streams for system consolidation and documented them concisely.
• Implemented complex SORT jobs useful for certain analysis tasks and saved manual effort.
• Got appreciation from client for quick and accurate documentation.

Environment

COBOL, JCL, DB2, REXX, CICS, IMS DB, ENDEVOR, INSYNC, SORT

Confidential

Senior Software Engineer

Objective

To offer support to various Financial General Accounting system jobs that were interacting with PeopleSoft applications for files and information.

Roles, Responsibilities and Accomplishments

• Supported 26 PeopleSoft applications that had dependency on mainframe batch jobs.
• Performed analysis research tasks in April Catalog Desk Inventory Process.
• Studied the process of Puerto Rico Excise Tax calculation in legacy job stream and explained client it's working.

Environment

COBOL, JCL, DB2, REXX, ENDEVOR, CRISS, INSYNC, DUMP MASTER

Financial Systems

Software Engineer

Objective

To modify the programs in Financial Systems to be CARB compliant and also upgrade the General Ledger code to newer version with enhanced capabilities.

Roles, Responsibilities and Accomplishments

• Contributed towards minor database requests in AIX Unix and UDB.
• Handled CARB compliance implementation independently and got client appreciation for a zero defect, hassle free and smooth install.
• GL 8.9 Upgrade, a minor enhancement where I contributed towards Impact Analysis, Coding, Unit Testing, Deployment and Documentation.
• Implemented all COBOL DB2 program changes and Database changes for the upgrade.
• Got appreciation from clients for meeting deadlines for all phases of the project.

Environment

COBOL, JCL, DB2, REXX, ENDEVOR, CRISS, INSYNC, UNIX UDB, SORT, SPUFI, QMF, DB2 Utilities

Software Engineer

Confidential

Objective

The main objective of this project was to mask any account information such as credit card numbers wherever physically stored and to only lookup the real numbers when programmatically manipulating information.

Roles, Responsibilities and Accomplishments

• The project was to implement PCI Compliance Standards in the JCPenney Credit Systems.
• This was my first project in my career and I got exposure to various stages of the Software Development Lifecycle such as - Analysis, Coding, Testing and deployment.
• Analyzed the stream of jobs in Credit Systems and came up with impacted elements.
• Identified lot of potential issues at earlier stage of the project that saved a lot of rework cost.
• Implemented all database and program changes on time, tested them thoroughly and deployed the code with perfection.
• Got appreciation from client for giving them great support during the installation.
• Boosted Client's yearly feedback from 4/7 to 7/7 during the project.

Environment

COBOL, JCL, DB2, REXX, ENDEVOR, CRISS, INSYNC, EZTREIVE, SPUFI, QMF, DB2 Utilities