SUMMARY

• Highly seasoned and experienced IT Consultant with 14 years of experience spread across diversified technologies and industries
• Extensive knowledge/experience in Mainframes (COBOL, DB2, JCL, TeraData and CICS) and on other tools like File - Aid, Endevor, Expeditor, Exceed, ESP, MQ.
• Expertise in Data Warehousing, ETL design and development, database querying using SQL, reporting, performance tuning & IT development, maintenance and integration of client server application, IBM Mainframe Technologies
• Experience in Datastage 8.5/8.1/8.0 (Datastage Manager, Datastage Designer, Datastage Administrator and Datastage Director) and developing Datastage Parallel Extender jobs
• Conversant with all phases of project Life Cycle
• Worked in various capacities viz Tech Lead, QA Lead, Implementation Lead, Business analyst, Senior Developer, Developer
• Expertise in UNIX Shell Scripting, SQL.
• Experience in using of MIGRATION strategies and methods.
• Experience in leading/driving re-hosting medium/complex mainframe systems from IBM-Mainframe to Clerity (a legacy modernization product from CA/DELL)
• Have lead ETL - Datastage upgrade projects ( DS 7.1 to DS 8.1)
• Hands-on experience in IT Project management
• High communications skills and the ability to interact directly with business users.
• Worked in fast-paced / high-pressure team environment with focus on quality.
• Very strong in Production Support and issue solving capabilities.
• Profound ability to quickly understand complex systems/architecture
• Sound problem solving and analytical skills
• Trained and skilled in AGILE model of software development
• Proven leadership skill working directly with business teams and onshore/offshore model
• High sense of ownership, commitment, attention to detail
• Can deliver better products with limited information/resources
• Adept at troubleshooting and ensuring quality control at every stage of management process.
• Proven abilities of managing team be part of a team or function independently.

TECHNICAL SKILLS

Programming /scripting: COBOL, JCL, SQL, UNIX Shell Scripting, Pro-cobol,SAS

Scripting: Unix, powershell

ETL/Reporting Tools: Datastage 8.5/8.1/8.0 EE & SE (Administrator, Designer, Director, Manager), Parallel Extender, Server & Parallel JobsPowerExchange/Informatica

Database: Z/OS - DB2, Oracle, DB2-LUW, IMS, TeraData

Job scheduling Tools: CAWA, ESP, OPC, Mquiry/Control-M

Platform/Database: Oracle 8/9i/10G, IBM DB2, MS SQL Server, LUW, IBM 4690 Controllers, LINUX.

Defect Tracking / Service Management Tools: HP Service Manager, Quality Center

Software Configuration Management tools: Open systems - Serena Dimensions, GIT Mainframe - Endevor, Panvalet, RMS

Service Management Tools: HP Service Manager, HP ALM (Quality Center)

Messaging & Middleware: IBM MQ-Series, WebSphere MQ, WBI Message broker

Tools: TOAD,Data studio, EAZYTRIEVE, REXX, VCOBOL, Clerity BPE & TPE, Filezilla, Winscp, Savers, JS Console, IBM Debug, Exceed, SDM, SYNCSORT/DFSSORT, ICETOOL, Xpediter, ISPF, File-Aid

OLTP interfaces: CICS

PROFESSIONAL EXPERIENCE

Confidential

Tech/Project Lead

Responsibilities:

• Primarily responsible for the availability of the General Financial Services application for the end users providing application support 24x7
• Incident resolution/ Route cause Analysis/ SLA deviations/ System Improvements.
• Troubleshooting failures / problems and providing resolution.
• Manage multiple test environments and debugging issues
• Performs code reviews and collaborates with technical leads/SME when necessary.
• Provide technical/architectural guidance
• Participate in security architecture reviews and risk assessments and resolve any issues identified.
• Work with business and business system analysts to understand requirements for enhancements and production problem areas.
• Responsible for leading, coordinating and driving successful delivery of project deliverables
• Develop and maintain project schedule, efforts and coordinate project activities, adhere toproject deadlines.
• Identification, monitoring and controlling project risks. Preparing mitigation and contingencyplan in consultation with project and senior management team at Confidential and State Farm.
• Communication with offshore and client personnel for ensuring timely status informationavailability
• Conduct design walkthru
• Coordinate the creation and maintenance of the overall Implementation activities
• Act as the lead resource and escalation point for dress rehearsal and implementation activities
• Coordinate with program communication team on implementation-related communications
• Create/maintain Dress rehearsal plan (Implementation test plan)
• Create/maintain Application Availability strategy
• Create test summary and capture lessons learned from Dress rehearsal
• Coordinate post-implementation support activities including plans for subsequent drops, defects, and daily defect meetings
• Create and maintenance all of the defects in ALM/QC
• Performed role based testing and single sign on testing of the applications.
• Played a lead role in developing Test Cases in a spreadsheet and uploading them to ALM/Quality Center Test Plan module and executing them in ALM/QC test lab for various source systems.

Confidential

Technical/Functional lead

Responsibilities:

• Lead a team of developers/testers at offshore as part of Datastage 7.5 to 8.5 upgrade
• Involved in the Analysis and Effort estimation for various levels (complexity) of Data Stage jobs.
• Exporting and Importing of the jobs into System Test environment and preparation ofThe Implementation Plan for deployment into various environments.
• Data Stage Administration tasks such as creation of Projects, creating directory structures and allocating roles for the developers for each of the Projects in the Development and System Test Environments.
• Analysis, design and review of the Data Stage Jobs and SQL scripts.
• Creating and executing the jobs through ESP session.
• Created technical design documents based upon the business requirements
• Analyzed and identified cost effective SQL’s in application programs and replace them with DB2 Stored procedures
• Put in the business rules on the COBOL-DB2 stored procedure(s) and made them accessible/available for more applications with common functionalities
• Conduct walkthrough with DBA’s to get their approval on the stored procedures
• Perform load/performance testing on the DB2 stored procedures
• Enhanced the existing CICS screens to accommodate the Mexico Old navy data
• Brought in new CICS screens to facilitate the item downloads, price change/downloads, Markdown downloads to Mexico old navy store
• Ensured the configuration/mapping/throttle of new MQ(s) for ONMX data with ESB
• Enhanced the trickle polling CICS online programs to process the ONMX data in MQ
• Introduced new TSQ (CICS) for ONMX store, item and walkthrough lookup
• Coordinated with business partners located at client location, to get the sign-off on the reports and results
• Provided valuable suggestions to the clients to eliminate the variances that were earlier seen in the reconciliation reports
• Reviewed all deliverables from offshore team to onsite team/client
• Tracking the impediments, and reach out to specific team to get the issues resolved
• Involved on project estimation, Requirement Analysis, Preparing High Level Functional/Technical design/approach docs
• Prepared the re-hosting migration plan by phases, rite from identifying the business application that needs to be migrated in parallel
• Fine-tune the older DB2-Z/OS SQL queries to accommodate the new working behavior of DB2-LUW
• Evaluated the correctness of new Clerity based CICS screen/transaction’s functionality and performance/TSQ/paging logic
• Provided valuable suggestions to the clients to eliminate the variances that were earlier seen in the reconciliation reports
• Coordinated with the offshore and onsite team during all the phases of the project
• Coordinated with business partners located at client location, to get the sign-off on the results
• Involved in internal review of Test Results, and conducting meeting with business partners for sign-off
• Create and maintenance all of the defects in ALM/QC
• Performed role based testing and single sign on testing of the applications.
• Played a lead role in developing Test Cases in a spreadsheet and uploading them to ALM/Quality Center Test Plan module and executing them in ALM/QC test lab for various source systems.
• Involved in Unit/System/Integration Test planning, execution and conducting daily meeting with Client and stake holders and all vendors
• Reviewed all PFI - Inventory Management application deliverables of offshore
• Supported other immediate upstream and downstream application, that has touch base with any of the Core apps / Inventory Management application