EXECUTIVE SUMMARY

• Over seventeen years of professional and consulting experience in Information Technology utilizing all phases of Software Development Life Cycle and multiple methodologies.
• Expertise in Mainframe legacy and Data warehousing applications. Delivered feasible solutions to the business using the technical and project management skills.
• Excellent verbal and written communications, analytical, and problem solving skills. Very quickly assimilate new technologies and methodologies.
• Self-starter and highly motivated personnel.

TECHNICAL EXPERIENCE

Business Area: Automotive, Finance and Health Care

Project Management Skills: Agile Methodologies, PMBOK Initiating, planning, executing, controlling and closing the projects

Mainframe Technologies: z/OS, MVS, TSO/ISPF, COBOL II, DB2, IMS DB/DC, MFS, CICS, JCL, VSAM, CA-7, Easytrieve, MQ Series, File-Aid, Abend-Aid, Xpediter, SPUFI, QMF, FTP, NDM, SAS, IBM Utilities, Endevor, Control-M

Data Warehouse: ETL, Informatica, PowerCenter, Business Objects XI, Cognos

Web Technologies: Knowledge of J2EEcc

Databases / Tools: DB2, IMS, Oracle 11g, Toad

PROFESSIONAL EXPERIENCE

Confidential

BI Technical Delivery Lead

• Delivered multiple BI projects with adequate planning, execution and tracking strategies. Responsibility includes development of prime BI projects, including mainframe legacy projects for various subject areas.
• Responsible for creating the technical deliverables such as High level Functional Design, Technical design documents from the Business Requirement Document BRD
• Responsible for managing resources from multiples platforms such as mainframe, ETL.
• Provided technical solutions to the team to accomplish project milestones.
• Responsible for validating the RTM, UAT with the business..
• Act as a liaison between the business and vendors to resolve the data feed issues.

Confidential

Mainframe Tech Lead

Project : Mainframe Rationalization

• This project is a phase 1 effort of legacy system conversion from mainframe to open system. In this phase, all the mainframe Service Quality and Sales Marketing applications such as Warranty Claims, Warranty Finance, VDF, Recall/Campaign, Dealer information system are analyzed and rationalized. Significant amount of mainframe data and programs are cleansed and changed the data transfer processes like FTP, RVS to open system process utilizing ETL. Finally, the technical system documents are created for all the applications which will be used for phase II, mainframe conversion.
• Created, modified and deleted JCLs, COBOL, IMS DB/DC programs, ETL workflows and mappings to rationalize the mainframe legacy applications.
• Created AS-IS and TO-BE model documents presented to the process integration managers PIMs
• Interacted with other team members, unix middle ware, data warehouse, web application team to co-ordinate the impact on open system side.
• Created technical design document and Operational Support manual for the mainframe legacy applications from the business process.
• Responsible for getting approval from the business for changing the technological process without impacting the business process.
• Responsibilities include reviewing the mainframe, ETL changes and presenting the change tickets to the Change Advisory Board CAB .
• Provided technical solutions to the project team and also expounded the business processes to other teams as a SM

Confidential

• VCAS Vehicle Certification Administration System is a new web-based application with mainframe and ETL interface to handle Certified Pre-owned CPO claims for Volkswagen Audi dealers. This project is a migration of claim CPO processing from mainframe to web based system but still keeping the data in mainframe for downstream financial processing for the claims.
• Responsibilities include gathering the business requirements and performing impact analysis.
• Responsible for creation of High level technical specification, Detail Technical Design documents
• Responsible for assigning tasks to the mainframe developers and providing technical directions.
• Created and modified IMS-DB2-CICS programs do the real-time update in IMS DB2 databases through MQ series for the certification claims entered through web services.
• Involved in UAT, SIT and release management meetings for deployment.
• Created Deployment Backout plans for the impacted mainframe legacy systems.

Environment: COBOL, DB2, IMS DB, FTP, ETL, Informatica, Oracle, MS Visio

Confidential

• Project M is collaboration between Volkswagen of America VWoA and Chrysler to leverage the Chrysler Town and Country minivan to create a variant that will be sold to VWoA customers in the United States, Canada and Mexico.
• Responsibilities are same as the above project with additional front end changes in legacy system.
• Responsible for changes in Vehicle, Dealer Information System, Claims legacy systems including screen changes in IMS DC MFS
• Responsible for assigning tasks to the offshore mainframe team.

Environment: COBOL II, DB2, CICS, IMS DB/DC, JCL, VSAM, FTP, CA7, File-Aid, Xpediter, SPUFI, MS Visio

Confidential

• STAR-DMS/MQ system is developed to send the Repair Order Acknowledgements ROA and Warranty Credit Notes WCN to the DMS Dealer Management Systems providers. DMS is an external vendor who submits the claims on behalf of VW/Audi dealers. The ROA and WCN will be sent in the XML format to the DMS providers.
• Created detailed technical design, Unit test plans.
• Designed Queues and coded new DB2 CICS programs using MQ series
• Created XML file from the message received from the mainframe which will be sent to DMS providers.

Environment: COBOL II, DB2, CICS, VSAM, MQ Series, Xpediter, SPUFI, WMQTool, Cyclone, WebSphere Message Broker, XMLSpy, XML, MS Visio

Confidential

• This project is designed to enhance the vehicle claim history edits in the Warranty Information Network WIN system. The main objective of this project is to perform the vehicle repair in detail level so that the WIN system will have the detailed history of claims of each repair performed.
• Gathering business requirements and converting them into technical requirements.
• Developed technical design for off-shore team for phase-1 which includes CICS program changes.
• Developed 2nd 3rd phases with extensive IMS including new IMS screens MFS , IMS batch online COBOL programs and triggering JCL from IMS MPP program

Environment: COBOL II, DB2, CICS, IMS DB, IMS DC, VSAM, JCL, CA7, File-Aid, Xpediter, SPUFI

Confidential

Sr. Mainframe Developer Infomatics, Inc. MI

Project: Warranty Claims Processing System

• Maintained a system which comprises the process and maintenance of claims submitted by the dealers for the repair done on the vehicles. This system is a global system and has many subsystems such as OTE One Time Edit , GCS Global Claim System . Enhanced downstream reporting in financial systems and transmitting the payment cycle statements to the international dealers via FTP and NDM.
• Responsible for providing technical guidelines for the team members.
• Developed Technical Architecture Specification, Detail Technical Design, test plans.
• Involved in UAT with the customers and end users.

Environment: Enterprise COBOL , DB2, CICS, IMS DB/DC, DCCS, VSAM, JCL, EASYTRIEVE, FTP, WSF2,NDM, QMF, SPUFI, File-Aid, Xpediter

Project: Mass Chargeback Claims System

• Developed and maintained an automated system to process the chargeback claims in mass. Using this system the warranty department recovered a significant amount of money.
• Installed the FTP/upload scripts in the user's PC.
• Converted requirements into technical specs.
• Responsible for coding, testing and implementing.

Environment: Enterprise COBOL , DB2, IMS DB, VSAM, JCL, FTP, CA7, NDM, QMF, SPUFI, File-Aid, Xpediter

Confidential

Sr. Systems Analyst /Oracle DBA

Title: DBA

• Responsible for fulfilling the developer's database requests.
• Database maintenance, SQL tuning, backup and recovery.
• Creating SQL files for build and deployment

Environment: Oracle 8i, SQL Plus, PL/SQL, Unix, Win NT, Toad, Java, JDBC

Confidential

Programmer Analyst

• Enhanced and maintained the brokerage system which includes securities, bonds and trading information. Monitoring and scheduling jobs in Control-M
• Worked on system enhancement such as recalculation in Treasury Cash Management TCM , Government bonds files, trade history files and extraction of data for Institutional sales credit
• Responsible for program changes, testing debugging including verification of data integrity.

Environment: MVS, TSO ISPF, COBOL II, JCL, VSAM, IMS DB/DC, DB2, CICS, Control-M, File-Aid, Xpediter, QMF, SPUFI

Confidential

Project: Treasury Direct Access Book Entry System TDAB

• The Treasury Direct System is operated by the Federal Reserve System and maintained by the Federal Reserve Bank of Philadelphia on behalf of the Treasury Department. Enhanced the TDAB system which maintains securities data for individual investors in Treasury securities including Treasury Bills, notes and Bonds. The system automatically generates interest and redemption payments, including debit ACH to accounts at financial institutions and re-investments into new securities as required.
• Responsible for coding new and modifying existing programs and creating UTP
• Created and modified MFS screens

Environment : MVS, TSO ISPF, COBOL II, JCL, VSM, IMS DB/DC, CICS, DB2, Endevor, SAS, File-Aid, Xpediter, QMF, SPUFI

Confidential

Project: Healthcare A/R A/P System

• This system maintains the account receivables and account payables of J J's external health care customers and suppliers. The information about the sales/order and vendor details are maintained in the mainframe IMS database. General ledger report generated using COBOL. This system also provides the account management services to the supply chain vendors of medical devices and diagnostics sector.
• Created technical specification, test plans by following the SDLC methodologies.
• Modified many sales/order modules and MFS screens and extensive data extraction of many files on a daily basis for reporting purpose.

Environment: MVS, TSO ISPF, COBOL II, JCL, VSM, IMS DB/DC, CICS, DB2, Endevor, File-Aid, Xpediter