SUMMARY

• 8 years of work experience in IT as IBM Mainframe & SQL - SSIS developer with extensive knowledge on COBOL- CICS programming, DB2 database, JCL, VSAM, File Aid, EZtrieve reporting tool, REXX, Changeman & Endevor version control tools, CA7 job scheduler, SQL server - SSIS packages, VB scriptingwith current project involving extensive use of these technologies.
• Well exposed to financial services - Banking domain principles, acquired as a result of working for world’s top banking clients.
• Extensive experience in creating new COBOL-DB2, CICS programs, debugging existing programs, scheduling new production JCLs on CA7 using Endevor/Changeman packages, used File-Aid, File Manager for sequential and VSAM file functions.
• Experience in creating various format reports using Eztrieve programming tool, create customized panels and automation tools using REXX.
• Experience in creating SSIS packages. Migrating DTS packages to SSIS.Experience in creating sql scheduled jobs,SQL Mail Agent, Alerts and schedule SSIS Packages.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experience in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server, Data Migration and Transformation from Excel Sheets using SQL Server SSIS packages.
• Efficiently used SDLC for projectsthat include analysis, design, development, testing, implementation, Production support of Mainframe & SQL Applications.
• Showed versatility by being successful, working in different environments like development, production support at client & offshore location
• Proactively implemented various application improvement tools and projects which brought benefits to the application like cost savings, effort savings
• Always believe in continuous improvement of self, believe that learning never stops in this space, have keen interest and attitude to learn new technologies and domain principles.
• Team player with good written and spoken communication skills and also a self-motivated individual with exemplary analytical and problem solving skills.
• Highly respect and admire clients’ suggestions on different project situations and bring forth innovative ideas in front of them to add value to their ideas.

TECHNICAL SKILLS

Databases: IBM DB2, Microsoft SQL server 2005, 2008

Operating systems: IBM Mainframes MVS, Windows OS - XP, Windows 7

Languages: COBOL, CICS, DB2, EZtrieve, JCL, REXX, SQL-SSIS package, VB scripting, ETL design

Version Control tools: Changeman, Endevor

Scheduling Tools: CA7 scheduler, SQL agent scheduler Change/Incident

Effort logging tools: IPM+

Other tools: DB2 QMF, BMC, SQL Server Management Studio, SQL Server Business Intelligence Development Studio,Data Transformation Services (DTS), XPEDITOR debug tool

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Technology Analyst

Responsibilities:

• As Onsite technical development lead, is responsible for making any technical changes to the system, small or big, involved in all stages from analysis, design, build, testing, implementation and warranty support. Projects involve changes to mainframe components that involve COBOL, CICS, DB2, JCL, VSAM, and SQL server, SSIS packages, VB scripting
• Worked on a project that involved ETL using SSIS package for one of interfacing applications.
• Understand project requirements to the granular level, prepare estimation sheets after proper analysis, and provide feasible effort-cost estimation.
• Create Request for Change (RFCs) using IBM Maximo for all the changes that happen to production environment.
• Interact effectively with business analysts, business/application end-users, external vendors, customers, coordinate with all these parties, suggest better ideas to achieve the requested changes to the system, there-by providing satisfaction to the business users & customers with reduced cost and effort
• Act as a mentor to a team of 7 including offshore team-mates, to delegate modules, review changes & test cases, integrate modules, involve with QA team to perform regression testing and implement the changes.
• Track team members’ performance at various stages in the project, commend them for their good work whenever due, suggest them with ideas for areas of improvement, leverage good work done by the team to client, higher management

Confidential, Charlotte, NC

Technology Analyst

Responsibilities:

• As Onsite technical production support lead, wasresponsible and accountable to address all severity incident tickets, problem tickets, within the stipulated and agreed upon SLAs, certain high severity incidents had SLA of 15 minutes of acknowledgement, and 1 - 2 hours of resolution with help from the team members including offshore when they are available
• Production support involved attending to the incidents and production problems, by contacting the affected business users, vendor or customers, jumping on triage calls whenever necessary, able to properly grasp the background of the issue, provide resolution at the earliest possible
• Implement minor enhancements or bug fixes to the production system, if needed as resolution to the problems or issues, involve offshore team members to make the changes, review and implement Changeman packages for mainframe changes, and sql-ssis package changes on the server side
• Create ProdEx (Production Exceptions), incident tickets, problem tickets using IBM Maximo for any exception production runs, to log the incidents, and for bug fixes respectively.
• Monitor the system after the resolution is implemented for proper execution of production processes
• Promptly track the tickets, document the issue root cause, restoral actions, symptoms, and close them within the deadlines
• Track team members’ performance in handling critical issues, commend them for their good work whenever due, suggest them with ideas for areas of improvement, leverage good work done by the team to client, higher management
• Identify any automation tools or system improvement options and suggest to the technical onsite team, provide estimation of cost & effort savings that would be achieved with these ideas

Confidential

Senior Systems Engineer

Responsibilities:

• Played offshore team member role, later promoted as a lead, to provide production support from offshore global development center for Confidential
• Production support involved addressing to production issues or tickets, any aberrant functioning of the system, identify the root cause, provide restoral action with SLAs for acknowledgement and resolution during offshore timings
• Involve different parties involved in the issue viz, business, operations, other applications’ technical contacts available at the time of issue, and promptly recover the system to its normality
• Implement minor enhancements or bug fixes to the production system, if needed as resolution to the problems or issues, involve offshore team members to make the changes, review and implement Changeman packages for mainframe changes, and sql-ssis package changes on the server side
• Create Production exception, incident tickets, problem tickets using Peregrine Service center for any exception production runs, to log the incidents, and for bug fixes respectively.
• Monitor the system after the resolution is implemented for proper execution of production processes
• Promptly track the tickets, document the issue root cause, restoral actions, symptoms, and close them within the deadlines
• Track the organic growth of the system and logging the key metrics, report them periodically to the clients and higher management
• Identify any automation tools or system improvement options and suggest to the technical onsite team, provide estimation of cost & effort savings that would be achieved with these ideas

Confidential

Systems Engineer

Responsibilities:

• Played offshore team member role as part of a big team which created the batch process from design, build, testing and implementation.
• Performed key role in developing COBOL programs as part of one of the major modules
• Effectively logged the issues faced while reviewing, testing and in-corporated the review comments
• Involved in all team discussions for analysis, design, build stages
• Worked with QA team in effective testing at SIT, UAT stages.