Mainframe Consultant Resume
Vancouver, CanadA
Summary:
- Over 13 years of Senior Systems Analyst / Team Lead / BA / Technical Development expertise, in the IT field
- Experience with Project Management, Functional BA Role and leadership skills on achieving results
- Excellent interpersonal, analytical and communication skills
- Experience in conversion projects, system enhancements project, trouble shooting skills on applications
- Intensive exposure to the entire SDLC in feasibility study, requirements study, analysis, design, development, implementation, maintenance and production support
- Very proficient in analysis, development and implementation of business applications
- Extensive experience with VS COBOL II, JCL, DB2, CICS, VSAM, VB Script
- Wide scale experience on working with Production (24x7) and Development environment
- Knowledge in performance tuning the application, updating applications documentation etc
Education:
Masters in Computers Applications
Bachelor of Computer Science
Technical Skills:
Operating Systems : MVS/ESA, MS-DOS, Windows NT/95/98/2000, TSO/ISPF, UNIX
Languages : VS COBOL II, Easytrieve, MS VISIO (flow-chart), Java
Databases : DB2, VSAM, IMS DB/DC, SQL, DB2 Platinum, SQL Server 2005
Hardware : Z/OS, IBM 3090, ES/9000, IBM COMPATIBLES
Case Tools : ADW, COOLGEN (CA)
Tools : CICS (OLTP), MF REVOLVE, JCL, SuperC, XPEDITER, File Aid, Endevor, SYNCSORT, SCLM
Application : Inventory, USA Child Welfare support, Mutual Funds, Tele Communications, Conversion
Training Course : MS Share point MOSS 2007, Informatica [Power Center ETL Tool), .Net 3.5, C#, Ajax
Professional Experience:
Confidential,Vancouver, CANADA,Mar '07 - Nov '09
Mainframe Consultant Client: Confidential, Vancouver, BC, Canada
- Projects IMAGINE, the data conversion process formed to accommodate the customer transition from old billing legacy environment to new billing AMDOCS environment. An estimated of 6 million AB & BC residential customers were targeted for the new stack billing migration (Pilot, Phase 1 & 2). Converting more customers in a limited amount of time requires significant improvements to the coding architecture for data conversion process. The internal run of conversion process executed frequently and efficiently to apply the business rules on converting customers. All TELUS 11 BP customers are subject to convert during production cutover date.
- Creates and executes project work plans and revises as appropriate to meet changing needs and requirements
- Manages day-to-day operational aspects of a project and scope
- Meetings conducted to discuss the conversion process, issues, status and share the success results
- Technical and functional assistance to whole conversion, and test environment. DB2 activities done for 21-test region
- Lead the QA team to provide direction for execution and created automation plan with framework based QTP scripts and created an End-to-End testing process flow diagram for testing of a data warehouse and sample business reports
- Assisted Business users with system testing and requirements validation and helped in planning and estimation of iterations as this project was in orange and agile mode
- Drove performance testing and software monitoring efforts by providing critical inputs.
- Engineered and created a batch test harness to generate transaction load for data warehouse (informatica) using COBOL and JCL.
- Provided analysis skills on customer data and maintaining the run efficiency level statistics to improve the efficiency
- Maintain contacts with senior BSA and their artifacts on customer issues to fix the defects for fallout customer from conversion
- Documentation created for process improvement and defects worked upon receiving email from quality center
- Provided 24x7 on call support for live data conversion of TELUS customers
Environment: IBM Z/OS, COBOLII, JCL, VSAM, SAS, DB2, FILEAID, ORACLE DB, AMDOCS (Telecomm Billing), SPUFI, IMS/DB, UNIX, DB2 PLATINUM, MERCURY QC/TD,
Confidential, Toronto, CANADA, Jun '02 - Feb '07
Sr. Programmer Analyst / Team Lead Client: Confidential, Piscataway, NJ, USA
- Performed Project Management responsibilities for the Billing Systems. Took TELCO training from AT & T
- Led a group of 4 subordinates, mentor and trained Junior programmers in the various Applications
- Prepare, Plan, Setup, and executed whole new Disaster Recovery for billing application as per AT & T higher management proposal
- Provided excellent first level client interaction with the AT & T for solving any outstanding work issues
- Tracks and reports team hours and expenses on a weekly basis
- Ensures project documents are complete, current, and stored appropriately
- Creation of whole test environment and DB2 DBA activities done for the project in testing region
- Maintained contacts with AT & T Business team for any business growth enhancement or improvements projects
- Innovated and automated various billing cycle stream to make the processing time faster and saved much storage space
- Designed, coded, and integration tested the online billing reports and batch processing on CICS, Cobol II, VSAM, DB2, BMS screens
- Fixed and provided solutions for Maintenance Request tickets of severity (1, 2) and for Enhancement Requests
- Responsible for coordinating the analysis/coding/testing activities with offshore team to ensure the traceability to requirements is maintained
- Provided 24x7 on call support for the AT & T billing cycle and In the deployment of enhancements and patches
- Documentation of work activities in compliance with CMM level 3 formalities
- Performed as mainframe integrated system tester for one of the biggest AT & T Billing System
- Actively involved in design/coding of the billing module in the mainframe platform and Involved in the cycles of the Billing
Environment: IBM Z/OS, SCLM, COBOLII, JCL, VSAM, MF-REVOLVE, EXSTREAM DIALOGUE 3.0, DB2, FILEAID, XPEDITER, SPUFI, DB2 PLATINUM, CTRL-M, UNIX
Confidential, Kansas City, USA Oct '99 - Mar' 02
Systems Specialist / SME Client: Confidential, Kansas City
- Analyzed, designed and created new application codes for the healthcare group member plan management system
- Involved in status meeting to solve any outstanding issues pertinent to release and maintenance request
- CICS was used along with DB2 & COBOL II to create online programs for online customer data to produce reports
- To eliminate human error, automated the process by bringing changes to CA-7 schedule and created new COBOL, VSAM programs
- Acted as a senior analyst, given technical solutions to the new-comers on the project expectation and deliverables
- Analyzed the various CICS, COBOL, IMS modules that needed enhancements. Involved in ER (entity-relation) diagram for project
- Prepared test data, tested and debugged system as well as performed System/Integrated Test activities
- Created of new JCL, PROC, Parameters and scheduling changes on dependencies and trigger process jobs
- Analyze/Code the programs according to the specifications provided by the client. Provided 24x7 on call support on rotation basis
Environment: IBM 3090, COOLGEN 4.1a, FILEAID, CICS, HL Protocol, DB2, COBOL II, TSO/ISPF, CA7, XPEDITOR, IMS DB/DC, MQ, VSAM, JCL, and FILEAID
Confidential, Kansas City, USA, Apr '97 - Sep '99
Systems Consultant Client: Confidential, Kansas City
- Participated in meetings to study the new requirements of Mutual Funds Accounts for various stock companies
- Developed online and batch programs which performs 41.6 million shareholders to enable them to do online accounting activity
- Generated weekly, monthly and yearly management reports on customer complaints
- Identified all CICS & COBOL programs for Y2K problem, coded, tested, installed the changes.
- Derived solutions to existing production JCL, PROC, COBOL & DB2 modules for feasible performance and production ready
- Protected existing database file structures and ensured accuracy of modification
- Coding and unit testing the CICS online programs and batch programs to meet user requirements
- Used DFSORT utility to extract accounting data for testing and debugging of the online/batch programs
Environment: IBM 3090, CICS, MVS/XA, TSO/ISPF, JCL, VSAM, DB2, SQL, VS COBOL II, FILEAID, QMF, and SPUFI
Confidential, Mar '96 - Mar '97
Software Programmer Client: Confidential, Merrillville, IN
- Involved in the development and trouble fixing of Steel inventory application systems
- Validated user inputs using the CICS online programs and created flat files to load into DB2
- Certified programs for the next stage of testing or implementation
- Coding, unit testing and system testing of the programs
- COBOL II was used to create and modify the various batch programs to meet the system requirements
- Enhancement of existing modules to expedite the shipment of steel coils to the customer location.
- Development of screens, data structures and created report modules using COBOL, IMS, and DB2
Environment: IBM 3090, WIN NT, IDMS, TSO/ISPF, JCL, VSAM, DB2, VS COBOL II, CICS, XPEDITER, IMS, FILEAID, QMF, SPUFI
Confidential, Pvt Ltd, India, Jul '93 - Feb '96
Programmer Client: Confidential, Oregon
- Participated in the development of the Child welfare enforcement system for the state of Oregon
- Provided solutions for Ad hoc requests on on-line inquiry CICS screen
- Involved in the development of the online/batch master module and unit tested and system tested on online screens
- Inspected, reviewed, proposed changes to the functional specifications according to the user requirements
- Created many batch programs and sub-routines to identify, locate, paternity issue and missing parents for the paternity issue child
- Performed impact analysis of the date fields on the product
- Prepared batch programs to produce various reports for the child welfare system
Environment: IBM ES/9000 WIN NT, TSO/ISPF, JCL, VSAM, DB2, SQL, VS COBOL II, CICS, XPEDITER, FILEAID, QMF, SPUFI, VAX / RDB, VAX COBOL, SQL, DECFORMS, JOB