Mainframe Software Development/Database Administration Professional 
Targeting the technology-oriented, Top Organizations in the IT sector with challenging assignments at Senior Managerial position, utilizing skills in the software industry.

EXECUTIVE SUMMARY

• Competent and dynamic professional, offering a distinguished and insightful exposure of nearly 7 years across high-growth Information Technology environments, experience includes software development usingMainframe technologies for banking domain and database administration. Last worked as Team Lead with TCS Eserve.
• Possessing valuable insights, keen analysis and team approach to implement best practices & processes used, adept at working in high pressure environments with strict deadlines and multiple deliverables.
• Excellent experience in the analysis, design, development, unit testing, and regression tests on mainframe technological platform.
• Comprehensive understanding & knowledge of database programming and sound background in database tuning and optimization
• Possesses sound knowledge of DB2, COBOL, Jcl & Vsam, CICS etc
• Demonstrated expertise in handling a diverse range of operations entailing Project Management, development and training. Hands on experience in designing, developing, testing & implementing legacy system projects. Exposure in co-ordination of training programs to team members.
• Perfect team manager having ability to lead cross-functional project teams and integrate their efforts to maximize operational efficiency. Superior communication and interpersonal skills with a high degree of flexibility, resourcefulness and commitment.
• Also, had a business trip to US once, from April 5th to 31st and have 10 years Valid B1/B2 Visa.

Core Competencies:

• Database Management
• Project Planning/Execution/Management
• Coding & Bug Fixing
• Software Testing
• Quality Adherence/Control
• Operations Management
• Client Servicing
• Problem-solving
• Multi-tasking
• Team Management

Technical Skills:
Operating Systems: MVS, Windows NT/95/2000, MS-DOS
Languages: VS COBOL II, JCL, C, C++ 
Databases: DB2, SQL Server 7.0, Oracle 8 and MS Access
OLTP: CICS
Tools: SPUFI, QMF, FILE-AID, CHGMAN, SCLM, Infoman, Dbadmin, OPC 
Internet Technologies: HTML, ASP, VBSCRIPT
Packages: MS-Office 2000
Hardware: IBM Compatible PC.AT

KEY ACCOLADES ACROSS CAREER PATH

• Received IBM Bravo Award
• Was awarded twice for excellent work done in TCS ESERVE

CAREER GLIMPSE

Confidential, SEPT’05-DEC’10
Team Lead

Confidential FEB’04-JUNE’05
Software Engineer

Snap Shot of Profile:

• Developing application by mapping client requirement, providing customized software solutions, finalization of product specifications and selection of appropriate techniques.
• Analyzing document reports & complaint reports for reducing the overall rate of complaints in the long term. Daily reporting for completely solved negative profile cases & present report.
• Introducing measures, leading to reduction, elimination & reoccurrence of some type of complaints. Managing customer service operations for rendering and achieving quality services.
• A facilitative manager adept in handling the array of tasks as:
• Data Analysed document reports & complaint reports for reducing the overall rate of complaints in the long term.
• Solving and issuing Digital certificate as per client request on the client side.
• Providing technical leadership while estimating and evaluating the effort/ schedules and managed the team and its grievances while training them and the fresher on the project architectures
• Successfully solving the Client queries and encouraged the employees to work in a team and share their feelings and experience.

KEY PROJECTS HANDLED

Project:Apollo for Risk System Client:ConfidentialDuration:Sep 2005 to Dec 2010Environment:COBOL, VSAM, and JCLTools:File-aid, SpufiRole:Team LeadDescription:Apollo is a main acquisition system for Citi card. Citi card has various products in market. First of all modelling team comes up with new product or they do model validation for existing product. Then the policy team defines that product to fit into the business goal. The newly launch product application are processed through Apollo system. Then several validations are performed on that application as data comes from various channels. The ECM database is on IBS mainframe system. Apollo GUI has interface with the IBS system as well as the credit bureau replica Experion or Magnum system. All the application is referred by the credit bureau a disaster criterion is checked for that application. As credit bureau don’t understand Apollo format so a reference number is generated to the individual application and matched with credit bureau format. When CEDI system performs all the validation CMF file is updated and an account is openedResponsibilities

• Prepare Test bed for Citi Card Major Release.
• Support UAT.
• Monitor BATCH job for ECM maintenance.
• Make DB2 database in sync with production data.

Project:FIW (Financial Information Warehouse)Client:ConfidentialDuration:October 2004 to June 2005Environment:COBOL, DB2, VSAM, JCLTools:DBADMIN, Spufi, QMF, OPCRole:Team MemberDescription:Financial Information Warehouse a co-production of Financial Information Warehouse-Corporate or FIW-C, Financial Information Warehouse- Mega Centre/Ledger Reporting or FIW-MC/LR and Financial Information User Interface or FI-UI will strategically contain a consistent base of ledger accurate details with world wide scope, together with enriched data at country and regional level and consolidated information from corporate level. The objectives for Centralizing the finance information needs into a logical warehouse are Improved information consistency and quality to support IBM’s position as a world-wide, customer focused company. This requires consistency across countries and divisions in processing and data. · Timely availability of the accounting results. · Enhancing the depth and breadth of information that is available worldwide to Support Measurements, Business Decision Making, Market Analysis and Financial Reporting. · Alignment with the ledger consolidation project to assist in driving reduced processing and data center cost. · Reduction of development cost associated with each country and division maintaining local measurement and reporting solutions.FIW provides a common and consistent database for measuring IBM's business Performance, sourcing financial data from the upstream Financial Data Warehouse System .The common base enables consistent reporting across reporting dimension- ions like Customer or Geography. Reports can be created at either worldwide level or at the Regional level using the same definitions. The common base also enables worldwide measurement changes/re-engineering to be implemented quickly and cost effectively. The system provides the business with information needed as part of the decision making process. The challenge is to keep the warehouse up and running 24/7 with high performance and in-sync with the Job-streams which runs on the assigned work-days.Responsibilities

• Analysis and Design.
• Coding and Testing.
• Running DB2 utilities like LOAD, UNLOAD REORG, RUNSTAT, COPY, REPAIR etc.
• Quality Related Process.

Project:ING ISV Product Migration Client:ConfidentialDuration:February 2004 to September 2004Environment:COBOL, DB2, VSAM, JCLTools:Xpeditor, FILE-AID, DFsort, SYNCsort, Migration Utility, EazytrieveRole:Team MemberDescription:This project is basically a Product migration project; in this project IGSI will convert all the ISV tools like Syncsort, CA-7, Easytrieve, Top Secret etc to compatible IBM tools DFsort, Tivoli, and RACF etc. The major work involves in this product migration is identifying impacted members in the different libraries and doing the necessary code changes and testing the modified member functionality with earlier results.Responsibilities

• Enhancement of the Existing programs according to the client’s new requirements.
• Preparation of Unit test plans.
• Testing of enhanced programs in development region with the prepared unit test plans and compares the test results with the expected results.

ACADEMIA

MCA,  Confidential 
BSc (Maths Hons),  Confidential 
12th,  Confidential

Certification:

• IBM certified DB2 User
• IBM certified on QMS (Internal)
• IBM certified on HIPPA (Internal)
• Citigroup certified on Risk Management

Trainings Attended:

• Risk Management