SUMMARY

• Highly seasoned and experienced IT Consultant with 13+ of experience spread across diversified technologies and industries
• Extensive knowledge/experience in Mainframes (COBOL, DB2, JCL, 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

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

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, 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/ SLA deviations/ System Improvements.
• Production support /Development/ Incident/Problem/Change Management/BCP/Stakeholders Meeting.
• On call primary - Resolution for any Failures/Batch cycle reporting/Emergency fixes for BPs.
• Responsible to handle all production related issues and scheduling the work items with delivery/targeted dates and monitor progress
• Responsible for monitoring, assisting defect resolution, guiding, mentoring and assisting team in root cause analysis, defect prevention and permanent fixes.
• Responsible for leading, coordinating and driving successful delivery of project deliverables
• Develop and maintain project schedule, efforts and coordinate project activities, adhere to project deadlines.
• Identification, monitoring and controlling project risks. Preparing mitigation and contingency plan in consultation with project and senior management team at DXC and State Farm.
• Communication with offshore and client personnel for ensuring timely status information availability
• Ensure that team follows process/quality guidelines and standard
• Review/approve of high level designs
• 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

Confidential

Technical/Functional lead

Responsibilities:

• Lead a team of 10 (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 of The 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