Summary:
Analytically savvy IT leader, who has more than 20 years of experience, looking for a challenging opportunity in Business Intelligence/Project Management/IT Strategy. His experience comprises in diverse areas such as Problem solving, Project/People Management, Analysis, Design, Development, Implementation, Trouble-shooting and coordinating an offshore development project from on-site. His domain knowledge includes Banking, Retail, Insurance, financial services, retail and Health care.

Managerial Skills:

• Project planning, execution, tracking and delivery.
• Hands-on with PM methodologies.
• Status reporting, Metrics, senior management liaison.
• People management, Performance reviews, talent management.
• Experienced in managing teams with Onsite-Offshore composition.
• Tenacious in problem solving.
• Versatile in strategizing and architecting solutions in-line with the client needs.

Technical Skills:

Hardware

IBM ES-9000, IBM 4341,IBM S/390, HP 9000

Operating Systems

MVS/ESA, MVS/XA, VM/SP, WINDOWS 95, WINDOWS NT, WINDOWS 2000, HP-UX(UNIX), Mandrake Linux

Languages

JCL, COBOL/370,VS COBOL II, MF-COBOL,SQL, REXX, CA-EASYTRIEVE PLUS, NATURAL, WAAPDSUT, VISUALAGE, SMALLTALK, C, C++, UNIX Shell Script, AWK,SAP BW

Access Methods

VSAM,QSAM,BDAM

DBMS

DB2, IMS/DB, ADABAS, MS-ACCESS, Oracle 9i,SQL SERVER, NETEZZA,TERADATA

OLTP

CICS

OLAP

Business Objects, Cognos,SSIS,SSRS

ETL

Informatica 6.2,7.X,8.X , Data Stage

Tools/Utilities

TSO/ISPF, SPUFI, SDFII, ENDEVOR, CHANGEMAN, FILE-AID, TOAD,XPEDITOR/TSO, INTERTEST, SMARTTEST, SAM, CA-7, FTP, QA-HIPERSTATION, VISIO PROFESSIONAL, MS Office, MS Project 2010, SAP Crystal Reports XI, SAP Business Objects XI, Cognos 8, Xcelsius, DYL-280, MQ Series, ERWIN, PLATINUM,STROBE,RSD, CA-VIEW , Princeton Data archive

Professional Experience:

Confidential, May 2011 – Oct 2012
Manager (Consulting)
Project: Managed software Services for Invest One Fund Accounting System for Fidelity Investments, Westlake, TX

• Worked on a major undertaking of converting Fidelity’s retail funds to Sungard’s flagship Investone Platform. Performing leadership role in SDLC Process.
• Responsible for Project Planning, Delivery, Metrics, Status Reporting.
• Developed and maintained Microsoft project plans.
• Carried out PM functions.
• Involved in UAT,QA life cycle, Automated test schedule through Control-M.
• Hands on with various technical and functional aspects of Sungard’s InvestOne system.

Confidential, TX JUN 2010 – APR 2011
Sr.Consultant/Application Architect
Project: Design and development of Direct Sales and Accounting Application for JCPENNEY, Plano, TX

• Intensively developed new Common Table Expressions and advised the client on Stored Procedures, Global Temp Tables and latest features of DB2 9.1
• Created new modules for Direct Sales Returns and process to update into the GL.
• Created new modules for Will Call PBO and process into the GL.
• Developed testing strategy and executed with HP Quality Center.
• Worked with Informatica 8.6 and created mappings for the data exported to EDW.
• Exposed to Power Exchange 8.6, Worked with conversion of COBOL Copybook to Data Map and Imported as source in Power Center.

Confidential,TX JUL 2009 – JAN 2010
Consultant
Project: Design and development of Express Allocations for the Merchandise Planning system for Neiman Marcus, Irving, TX.

• Creating converted feeds for SAP BW from Merchandise Planning System which runs DB2/Z OS
• Creating Reports using Business Objects Crystal XI.
• Creating efficient queries with DB2. Modifying COBOL programs using DB2V9.1 features (Extensively used new features such as CTE, MERGE, Native stored procs, Index on expressions, Pure XML).
• Creating new online CICS, DB2 programs using the new express allocation tables.
• Creating new JCL, PROC and Batch programs for conversion work.
• Modifying IMS, CICS online programs.
• Using ICETOOL for performance enhancements when ever needed.
• Analyze queries using TOAD for DB2.
• Developed programs using Eztrieve for file matching and data massaging.

Confidential,TX FEB 2006 – MAY 2009
Technical officer
Project: Development and support of Custody systems, Pension Benefit Payment system, WINS(aka Invest one),Master Notes Pooled Funds system. Involved in development and support of Income processing area of custody system, Pension benefit payment system also known as Infopay, invest one ( Sunguard products) .

• Mentor junior staff brought out of the box solution to various problems
• Helped the team to organize in Project management approach to the team functions and introduced ITIL methodology.
• Developed Data Conversion strategies from CAPP/AIRS system to Data warehousing, SAP BW systems.
• Developed strategy for Data cleansing, ETL using IBM Datastage.
• Worked with Datastage Designer to create mainframe jobs.
• Worked with Datastage Director,Datastage Manager.
• Exposed to Datastage Administrator.
• Extensively used Eztrieve for synchronized processing, Data massaging and data conversion.
• Developed strategy to Data conversion to Views Portfolio Reporting system a Cognos based Web reporting environment.

BUSINESS DOMAIN EXPERTISE

• Income processing of US custody system servicing Mortgage Backed Securities, Stocks, Bonds and ADR’s
• Infopay and PSA/MNPF systems
• Omnibus and Oasis interface systems
• Motivator, a vendor package for Sales incentive management system
• Activity and Rejects Processing for Motivator incentive management system)
• Auto Insurance policy processing system and billing system
• Health Insurance System (MMIS )
• Erroneous Payment Corrections (Refunds and Recoupments)
• COGEN billing system for Insurance companies
• Claims Processing System
• Materials Management System
• Accounts Receivables System
• Production Control & Management system
• Online Financial Accounting system

Educational Qualification:

Master’s degree in Computer Applications