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,support In Mainframe Technologies
• Strong hands on experience in Mainframe Technologies DB2, JCL,CICS & COBOL
• Proficient in ENDEVOR, CHANGEMAN, FILE - AID, INSYNC,QMF, SPUFI, EXPEDITOR and MFE tool.
• Over 2 years of experience as BI developer inSQL 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 Structures for 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.

SOFTWARE 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: CICS

Tools: SSIS,SSAS,SSRS,Tableau,ENDEVOR, CHANGEMAN, MFE,QMF, FILE-AID, SPUFI and INSYNC, GDD( Confidential quality process),E-Tracker

PROFESSIONAL EXPERIENCE:

Mainframe Developer

Confidential, New York

Responsibilities:

• Impact Analysisof the entire wirelessengine 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

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 Analysisof 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.

Environment: MVS mainframe operating system, DB2, COBOL,JCL,CICS

Software Engineer

Confidential

Responsibilities:

• 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 Confidential 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.

Programmer Analyst

Confidential

Responsibilities:

• 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.

Confidential

Developer(Cobol,JCL,Db2)

Responsibilities:

• Responsible for solving Batch problems, customize Confidential
• 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 Confidential Quality Process followed by the tool called E-tracker.