9 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 system 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,Oracle, Eztrieve and VSAM.
• Extensive domain knowledge on Banking (Financial and Accounting), Trading/Brokerage, Investment, Insurance and Securities.
• Worked with clients like Charles Schwab, UBS, Bank of America/Merrill Lynch, Fifth Third Bank and JP Morgan Chase.
• 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 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.

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.

CERTIFICATIONS

• Insurance 1-0-1 (Internal to Wipro)
• SDLC and Project Management (Internal to Wipro)
• Post graduation in Industrial Relations and Personnel Management

Confidential(Pennington, NJ Nov, 2010 - till date)

Business system Analyst/Technical writer

Global Bookkeeping Repository is data repository , will house client financial data globally. GBR will be the one shopping source of client financial data within Global Utilities for both Banking and Trading/Brokerage. This repository will consolidate all client financial data (activity, holdings, tax lots and balances) into one source regardless of entity, region, product, currency, time zone, language, etc.

Responsibilities:

• Requirements gathering for application design.
• 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 and interact with SMEs.
• 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, 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, MS Office, FTP, SPUFI, FILE-AID,ENDEVOR, Crystal, Brownstone, and VISIO.

Confidential

Business Analyst/Programmer Analyst

The goal of MARGINS project was to wean out the information required to re-implement the ancient legacy programs in a new client/server environment. The programs were re- structured, secondly the programs were sliced into business logic module, thirdly the business modules were subjected to a multi new analysis, and finally the views are integrated into a unified documentation describing the data decision and procedural flow of each program slice.

Responsibilities:

• Research system functionality and create technical documentation, analyze COBOL, Db2 programs, JCLs, PROCs, Copybooks 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 like trades. 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 (Apr, 08 – July, 09)

Business System Analyst

Claims process project is an effort to address the business need to support physicians and providers with patient liability information in real-time, Health Vision set out to build a robust claims processing application that would allow physician offices to submit claim information and immediately get processing results. The new Web-based application would allow patients to know, at the point of service, the total amount owed for the medical procedure.

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 (Aug, 07– Jan, 08)

Business Analyst/Programmer Analyst

Implementer: Wipro Technologies, India

Global Reconciliation Utility has been set up to initially replace the Bank's Stock reconciliation system, STORM, with the existing Cash reconciliation system into TLM (Transaction life cycle management), for UBS business in London, Stanford and Asia Pacific, with associated applications Lotus Notes and Business Objects providing additional reporting and manual matching functions.

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 of Cash and Stock reconciliation, 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 (Mar, 07 – Jul, 07)

Software Engineer

Implementer: Wipro Technologies, India

Complex Client Relationship (CCR) groups (Household) customer based on the common assets which will be shared by one or more than one customer. House holding is a sale, service, advice, and marketing tool used to group together the accounts that belong to the same 'households’.

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 (Sept. 05 – Feb. 07),

Software Engineer

Implementer: Wipro Technologies, India

Responsibilities:

Fifth Third Bank provides its customers with all services like Savings, Deposits, Consumer lease, Credit, Debit and Gift cards, Mortgage loan etc. The Universal Deposit System (UDS) statement uses Dialogue software for formatting the raw input data and customer information that produces statistical information for reporting to senior management or error report for analysis. Enhancement project from an existing process using Custom Statement Formatter (CSF) to a new letter format and design using Exstream Dialogue.

• Mailing systems module is designing Business letters and reports for all lines of business of Fifth Third Bank.
• 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 Dialogue application into mainframes through FTP in command prompt environment to produce PST files.
• 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 (JUNE, 03- AUG, 2005)

Project Engineer

Implementer: Innova Solutions, India

Customer History project is fully designed for Ring wan Insurance Corporation, Singapore that provides various Life Security schemes for Insurance holders. This product provides provision to take-in various related information such as Life Partner Insurance, Dependent Insurance and having attractive options for the holders and checks the conditions captured in case of claims.

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.