Mainframe Developer Resume
4.00/5 (Submit Your Rating)
New, YorK
SUMMARY
- Overall 11 years of professional experience in IT industry in Telecom, Insurance, Automotive and health care domains
- Over 8 years of experience in Development,maintainance,enhancement,migration,supportIn Mainframe Technologies
- Strong hands on experience in Mainframe Technologies DB2, JCL,CICS, COBOL and MQ series
- Proficient in ENDEVOR, CHANGEMAN, FILE - AID, INSYNC,QMF, SPUFI, EXPEDITOR and MFE tool.
- Over 2 years of experience as BI developer in SQL server MSBI suite of tools SSIS,SSAS,SSRS .
- 2 years of Experience in data extraction, transformation and loading (ETL) between systems NBBE-OLTP to NBBE-OLAP using SQL tools such as SSIS, different server locations and heterogeneous locations like flat files, excel etc
- Experience in involvement for creating Fact Tables and Dimension Tables, Star Schema and Snowflake Schema for implementing Data Warehouse Structuresfor the NBBE tables that were involved in rating,usage processes.
- Over 2 years of Experince in creating,deploying and managing reports in SSRS as per the client requirement for paper and vz450 for each bill cycle.
- Involved in cube designing using SSAS tool, working MDX queries.
- Developed Tableau visualizations and dashboards using Tableau Desktop.
- Extensive experience of communicating and coordinating with both business and technical teams at all levels in the organization.
- Project coordination activities using organization provided tools such as HPQC, GDD,E-Tracker,CMIS.
- Quick learner of new tools/technologies as per the organizational requirements.
- Extensive experience in coaching and training my junior members of projects as needed.
- Experience in handling off-shore teams and on-site client co-ordination for application development, product development and maintenance activities.
TECHNICAL SKILLS
Operating Systems: SQL server 2012,MVS, Windows 2000,UNIX
Languages: VS Cobol II, JCL,REXX,SAS, C and C#.
Databases: SQL,DB2, IMS DB, VSAM, VSP,SQL Server 7.0, Oracle 8i and MS access
OLTP: CICSTools SSIS,SSAS,SSRS,Tableau,ENDEVOR, CHANGEMAN, MFE,QMF, FILE-AID, SPUFI and INSYNC, GDD(Accenture quality process),E-Tracker(Cognizant project management tool)
PROFESSIONAL EXPERIENCE
Mainframe Developer
Confidential, New York
Responsibilities:
- Impact Analysis of the entire wireless engine for any changes to any wireless customers across all states for both business and residential customers in all segments and communicate the same with upstream and downstream applications
- Documentation of technical and functional specs, get the approvals from the client.
- Coding,testing,reviewing the code and move the code to the next level in ACC to be picked by production teams in ENDEAVOR version control tool.
- Deliver one time code for the next release if there are any one time charges to be paid for customers by updating NRC tables
- Create ad-hoc reports in DCA application for business users to review
- Taking care of historical data at all levels of aggregation in DB2 tables and import them text files to be further processed by data analysis teams.
- Maintain Functional/Technical specs,UTPs,UTRs in project share drives .
- Taking care of tickets raised by testing team and delivering back to ENDEAVOR until successful release.
- Estimation of project timelines by considering the number of resources, tables involved, files involved, lines of code involed
Environment: MVS mainframe operating system, DB2, COBOL,JCL,CICS.
Confidential, New York, USA
Mainframe Project Lead
Responsibilities:
- Checking the trigger file each bill cycle date to pick the right accounts
- Requirement gathering for each project for the changes to implement for any new packages,bundles,contracts or determinants in the cobol code or sometimes DB2 tables.
- Impact Analysis of the entire Pricing system for any changes to Business, Consumer, LD and Residential segments and communicate the same with upstream and downstream applications
- Documentation of technical and functional specs, get the approvals from the client.
- Coding,testing,reviewing the code and move the code to the next level in ACC to be picked by production teams in ENDEAVOR version control tool.
- Implementation of new Pricing plans,contracts,bundles without breaking any existing code for all MRCs
- Maintain Functional/Technical specs,UTPs,UTRs in project share drives and also CMIS tools
- Taking care of tickets raised by testing team and delivering back to ENDEAVOR until successful release.
- Production support after each release first time run bill cycle and fix any problem that arises with Verison Emergency process in 24 hours for last minute deliverables.
- Deliver one time code for the next release if there are any one time charges to be paid for customers by updating NRC tables
- Create ad-hoc reports in DCA application for business users to review
- Estimation of project timelines by considering the number of resources, tables involved, files involved, lines of code involed
- Training and mentoring new team members
- Timesheet management/Leave management of the team members.
- Analyze the Conceptual software design provided by the client.
- Responsible for delivering quality Technical design documents.
- Build code using MFE tool.
- Mentoring the new team-members.
- Taking care of onsite deliverables.
- Taking care of Accenture Quality Process followed by the tool called GDD.
- Timesheet management/Leave management of the team members.
Confidential
Developer(Cobol,JCL,Db2)
Responsibilities:
- Analyze the Technical analysis documents provided by the client.
- Creation of Technical analysis documents basing upon functional analysis documents provided by the client.
- Build code using ULTRA editor, compile and execute the code in UNIX AIX environment
- Preparation of UTP and UTR
- Involve in Peer reviews.
- Mentoring new team members.
- Responsible for solving Batch problems and production support.
- Analyze the specifications provided by the client to design, code and test any change
- Mentoring the new team-members.
- Responsible for solving Batch problems, customize JCLs
- Analyze the specifications provided by the client to design, code and test any change requests
- Mentoring the new team-members.
- Taking care of onsite deliverables.
- Production Support of weekly-cycles and monthly-cycles.
- Taking care of Cognizant Quality Process followed by the tool called E-tracker.