SUMMARY

• 8+ years of experience on Mainframe Z/OS, OS/390 as Programmer Analyst, Business System Analyst, Software Engineer and Project Engineer. Worked in full SDLC including analysis, technical design, developing, testing, debugging, implementation, training, research, documentation and production support.
• Extensively worked on projects using COBOL, JCL, CICS, DB2, VSAM, MVS, MQ, SQL, core JAVA, Exstream Dialogue, UNIX, Eztrieve and VSAM.
• Extensive domain knowledge on Banking (Financial and Accounting), Brokerage, Investment, Insurance and Securities.
• Worked with clients like Confidential, UBS, Confidential, Confidential and Confidential .
• Expertise in various MVS/IBM utilities and tools such as TSO/ISPF, XPEDITOR, FTP, ENDEVOR, DFSORT, CHANGEMAN, SPUFI, Crystal, SAR, QMF, ABEND - AID, MS OFFICE, VISIO, TOAD, FILE-AID, Quality Center, PROGRAM INC and BMC.
• Ability to perform complex systems analysis, good knowledge of agile methodology and programming activities. Strong grasp of relational database concepts.
• Experience in Database operations like developing DB2 code, querying databases, Load, Unload data, problem trouble shooting, database testing, performance tuning.
• Business process analysis with use cases and/or process flows and Gap analysis techniques.
• Knowledge of JAVA, SOA, REXX and .NET Technologies.
• Involved in unit testing, system integration, volume testing, functional testing, regression testing and manual testing support UAT to ensure programs works with no defects before moving to QA.
• Prepare documents regarding technical design, high level system flows, project plan, System use cases, requirements & solution, code reviews and issues, unit test plan, test results, modification processes and weekly status reports for project management.
• Strong organization skills with the ability to work on multiple projects/assignment simultaneously.
• Strong interpersonal and communication skills with the ability to express technical and business concepts.

TECHNICAL SKILLS

Databases/Access method: DB2, SQL, VSAM, MS ACCESS, ORACLE 9i.

Programming Language: COBOL II, DB2, JCL, VSAM, JAVA, SAS, VB.NET, SQL, PL/SQL, Eztrieve, CICS. Tools CHANGEMAN, ENDEVOR, FILE-AID, FTP, SPUFI, TSO,TOAD, SAR, NDM, XPEDITOR, Quality Center (Defect Management Tool), MS OFFICE suit, VISIO, Word, MS Access.

Operating Systems: Z/OS, OS/390, Windows NT/XP, MS-DOS, MVS, UNIX (VI EDITOR).

Web Technologies, CRM Package, Middle ware: ASP. NET, VB.NET, VISUAL STUDIO 2005, .NET Framework, Exstream Dialogue, MQ series.

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Programmer Analyst &Technical writer

Responsibilities:

• Development and analysis using COBOL, DB2, CICS, and VSAM.
• Extraction and documentation of Business process logic/rules from legacy programs to understand the actual business logic in production as opposed to the business rules believed to be in place. Gap analysis.
• Create system level, program level and activity level flow charts for batch and online programs using Visio.
• Responsible for mapping and identification of fields in interfacing systems(Mutual fund, Trade, Corporate actions, etc). Expert knowledge about the file layouts and table structures/fields.
• Flow charting the complex sequence of jobs in batch EOD process and timings to tune the batch cycles and job dependencies. Upload high level flows onto Share point to give overview to all users.
• Detailed documentation of Fractional share breaks and events, Currency code logic, existing Posting rules, Reconciliation process and categorization of breaks and break reasons in reconciliation process, etc.
• Update and maintain application and project documentation in Documentation Framework site.
• Worked closely with Business requirements and QA team, and Technical design and Architecture teams.
• Effective analysis of upstream and down system data and transactions like Cash, Securities, Trade and settlements, understand new and existing applications.
• Participate in project planning sessions to gather requirements, analyze business requirements, assist in root cause analysis and resolutions.
• Participate in design, coding, technical writing, testing, implementation, and documentation of solutions.
• Support testing team in data validation and functionality testing providing data from mainframe system.
• Strong SQL query and data analysis skills .

Environment: COBOL, JCL, DB2, CICS, SQL, MQ, TSO, TOAD, Z/OS, SAR, VSAM, MSOffice, FTP, SPUFI, FILE-AID,ENDEVOR, Crystal, Brownstone, and VISIO.

Confidential, Whippany, NJ

Programmer Analyst

Responsibilities:

• Develop and maintain COBOL, DB2 programs.
• Research system functionality and create technical documentation, analyze and code COBOL, Db2 programs, JCLs, PROCs to extract the business logic.
• Capture the source fields of variables used in Cobol, DB2, VSAM programs from sources like copybooks, Stored Procedures, subroutines. Reverse engineering.
• Presentation to clients on assignment logic of Security types and Sub Security types analyzing related programs and sub programs.
• Understand the data needs of the future system while documenting the existing system. analyze, define source and target structure and perform gap analysis for data migration
• Stream specific sources, IO cards, DB2 tables, Input files to the calculators are listed in data dictionary layouts.
• Used EXCEL sheets for documentation which later on uploaded onto SHAREPOINT in order to be viewed by JAVA developers and concerned Mainframe team.
• Wrote JCLs to capture specific data for business logic, stream wise sort cards description.
• Analytical experience researching system functionality and create technical documentation
• Documentation of all stream wise data of existing legacy system, in a way that is useful for JAVA migration.
• Interacted with upstream and downstream system teams to formalize functional and non-functional requirements and to resolve any technical hurdles and issues of complex mainframe system.
• Status report preparation and co-ordination.Attend weekly team meetings and, client meetings.

Confidential, NJ

Programmer

Responsibilities:

• Did system analysis, programming, testing, implementation, maintenance and documentation of COBOL, DB2, SQL programs.
• This system began receiving daily electronic transmissions of professional claims that were analyzed, reported, and formatted for Batch adjudication.
• Validate data records created on Flat files using File-Aid with layout, create Excel spread sheet to be reviewed by QA team.
• Develop COBOL, DB2 programs as per client requirement.
• Analyze and perform impact analysis used SAS procedures for analyzing the data.
• Promote and execute the packages, supporting System integration testing, UAT support and source code maintenance in CHANGEMAN environment.
• Document all expected test results on Excel spread sheet, loading to share drive to be utilized as references by QA team.
• Escalate production and development issues as necessary to Senior level.
• Test case preparation, debugging, execution and preparation of code review documentation, production support.

Confidential, Jersey City, NJ

Programmer Analyst

Responsibilities:

• Responsibilities include technical design, development, testing, debugging, documentation, support using Exstream Dialogue, COBOL, DB2, JCL and CICS applications accessing DB2 tables and VSAM files.
• Analyze GRU legacy System COBOL/JCL/DB2 program codes, DCLGEN layout, CSF, copybooks, File layout and related JCL, PROCs, Control Cards for program changes
• Develop various co-related/nested sub queries for accessing data by joining multiple tables.
• Prepared test data and analyzing test output before incorporating the SQL query into application programs using SQL/SPUFI, BMC tool.
• Promoted and executed the packages, supporting System integration testing, UAT support and source code maintenance in CHANGEMAN environment.
• Debug and test the programs with XPEDITOR after making changes for expected results.
• Good understanding of QA process for logging, tracking and resolving defects raised by Quality Center system and making sure the functionality is developed as per the requirements.
• Prepare detailed design documentation, System test plan and test procedures documents.
• Participated in project planning sessions with project managers, business analyst, client and team members to outline the requirements and design.

Confidential, CA

Software Engineer

Responsibilities:

• Interact with Business analysts to understand functional requirements.
• Develop and modify COBOL batch applications accessing DB2 database and VSAM files.
• Detailed analysis of all the programs, procedures, parms, GDGs, control cards and copybooks.
• Develop Eztrieve programs and report Generation programs for Mortgage, Deposit and Credit card data.
• Enhancements to the existing system as specified by the customer using COBOL, JCL, SQL, VSAM, ORACLE 9i, DB2, JAVA programs maintaining the CMMI quality standards.
• Submit SPRs (Special purpose request) jobs to remove/filter for periodic maintenance data from database and sending the reports in Excel format.
• Performance tuning SQL queries and DB2-Cobol programs.
• Exposure to QMS (Quality Management System) processes and procedures required for planning and execution.
• Attend team and client meetings, preparation of weekly and monthly status Reports.
• Unit testing, System testing preparation of test data, test cases, document the test results and production support.

Confidential, Cincinnati, OH

Software Engineer

Responsibilities:

• Mailing systems module is designing Business letters and reports for all lines of business of Confidential .
• Execute Exstream Dialogue applications on mainframes and view the desired layout in suitable batch use to produce print-ready output (postscript files) in PDF format.
• Upload the Exstream dialogue pub files, data files/driver files onto mainframe
• Build the application in Exstream Dialogue environment using Applications, Data files, Documents, pages, Images, Statements, section data, frames, etc.
• Code and modify Dialogue formulas, message campaigns and rules, reference files, different output queues using CSF.
• Gather requirements, analysis and enhancement of programs using DB2, VSAM, COBOL and SQL.
• Design and develop packages, which involve creating Data files and doing mapping of data variables.
• Uploaded the application into mainframes through FTP in command prompt environment.
• Create output queues with banner and trailer records. Debugging and rectifying error messages in EXMSGS.
• Made necessary changes in JCL like changing the package names, DD names, versions and DCB.
• Transfer the PDF output file generated by JCL to view the postscript file.
• Document all record layouts in Business letters like length, position, character set records per Bank customer and new functionalities.
• Responsible for understanding the functional specifications given by the client.

Confidential

Project Engineer

Responsibilities:

• Analyze existing code to come up with the best design, and to understand the potential impact on systems.
• Source code changes using languages COBOL, DB2, VB and CICS with Copybooks and Procs.
• /Design Maps/screens and developed online programs with pseudo conversational technique using CICS, DB2, MQ Series and COBOL to view the customer details.
• Load and Unload DB2 tables using IBM utilities.
• Ensure that all the work meets the quality requirements according to CMM level 5 standards.
• Involve in unit testing, integration testing and preparation of the unit test cases according to the quality standards. Peer reviews.
• Status reporting on the module to Project Leader.