SUMMARY:

• 14+ years overall IT experience in software development, with excellent skills in Design & development of Data warehousing & OLTP systems, Database designing, Application programming using Cobol+Db2, DB2/UDB, PL/SQL, Oracle 9i, SQL, SQL Server 2000.
• Possesses high level of expertise in business analysis, design, testing, implementation, maintenance, optimization, capacity planning and performance tuning of heterogeneous software environments.
• Experience in building applications and optimizing code to perform analysis on large volumes of data.
• Currently managing high transactional DB2 database dealing with high volume of external data from different external sources including MULTI FONDS, INVEST1, AIGENEIVA, and OXIDE.
• Strong Application development skills on Mainframe platform using Cobol,Db2, CICS, VSAM,JCL
• Worked closely with custody, securities and fund accounting business groups to understand and implement the business logic. Successfully executed complete SDLC for various projects.
• In addition to the system development and support job involves doing all kind of system testing(unit testing, integration testing, user acceptance and Regression testing), system outages, integration etc
• Experience in managing large teams, experienced project Manager who has successfully led large project team’s people from requirements - gathering through to implementation and support for internal and external customers.
• Expertise in Project management in IT Software Department starting from initiation of the project till closure.
• Experience in interaction between cross functional teams to share the common methodologies, Technical designs/discussions and Project dependencies.
• Expertise in COBOL+ Db2 stored Procedures, Db2/Udb Stored Procedure, Triggers, User defined functions, backup and recovery, SQL & PL/SQL performance tuning & UNIX Shell Programming.
• Strong Logical & Physical Data Modeling Skills using AllFusion Erwin tool.
• Expertise in Database design (Logical/Physical), Sizing, Index columns identification and Index type required, Table partitioning, UNLOAD,LOAD,REORG etc.
• Expertise in DB2 DBA skills, Performance tuning using EXPLAIN, VISUAL EXPALIN.
• Worked on domains like Financial ( Investment Bank), Credit Card Processing, Utility Services, etc.
• Strong working knowledge of Back office fund accounting business and Project Management
• Ability to learn very quickly and apply new skills to existing problems.
• Commitment to quality from requirements through design, construction, testing, and installation.
• Flexible and quick to adjust to abrupt changes. Highly motivated and capable of working both independently and as a member of the team.

TECHNICAL SKILLS:

• VSCOBOL-II, CICS TS 1.3, DB2/SQL, QMF
• VSAM, TSO/ISPF, JCL/UTILITIES, INTERTEST, XPEDITER
• VIASOFT, FILE-AID, CHANGEMAN, INFOMAN, DB2 UTILITIES
• DB2/UDB V 8.1, DB2 on Z/OS ver 7.0, 8.0(NFM),V 9.0
• REXX, OARS (Reporting tool), SYNCSORT, PLATINUM
• OMEGAMON DB2 PERFORMANCE MONITOR
• AllFusion ERwin 7.2, Assembler, CA7, OPCT
• OPC, Oracle, Developer 2000, SQL Server 2000
• Abinitio ETL Tool, Visual Source safe, SVN
• ASP 3.0, HTML,DHTML,VB Script
• Java script, Unix Shell script, MS Project, Visio.

PROFESSIONAL EXPERIENCE

Confidential

DB2 DBA/Mainframe Technical Lead

Environment: Cobol,VSAM,CICS,JCL,DB2 on Z/OS V9,DB2 UDB 8.1 Windows, MQ-Series (middleware), Actuate, Business Objects, Abinitio, Java, AUTOSYS, PVCS 7.5, DB2 Connect, SVN.

Responsibilities:

• Working with business team to define business objectives and create overall Statement of Work which delivers solution to meet business objectives.
• Develop project documentation, Estimation, project schedule, risks and issues logs, resource forecasts, communications plans, etc.
• Timely updates to Project plan, manage changes, track milestones.
• Proactively identify and manage Project dependencies, changes in project scope and critical path identify potential crises, and devise contingency plans.
• Identify and resolve issues and conflicts within the project team.
• Coordinated Progressive elaboration of a Projects specifications needs with proper project scope definition to avoid scope creep.
• Communicate regularly with Project teams, appropriate stakeholders to understand constraints and ensure risks are managed.
• Experience in interaction between cross functional teams to share the common methodologies, Technical designs/discussions and Project dependencies.
• Complete post-implementation review both with client and internally, capturing items which should become best practice as well as those requiring improvement.
• Responsible for ensuring successful delivery within agreed time, cost and quality objectives.
• Provided help to PMO team to improve processes through out many other similar projects.
• Manage a Share Point site to maintain status and priorities.
• Installed and configured Db2 UDB database as well as Z/os DB2 database.
• Creation and Administration of Storage Groups, Data Bases and Table Spaces .
• Suggested data compression at the database level and reduced storage requirements for UDB database.
• Designed and implemented a database backup/restore policy for UDB database.
• Controlling access to DB2 Objects, Planning of Backup and Recovery of Table Spaces.
• Modeling and implementing database schema changes in DB2 UDB.
• Created logical model for set of business or functional requirements and after approval converted them to a physical model using CA AllFusion ERwin modeling tool.
• Designing, developing, maintaining and supporting Data Warehouse Extract, Transform and Load (ETL) software using Abinitio, Shell Scripts, Stored Procedures and Autosys.
• Extensively working upon Large Transactional DB2 Database with more than 700 segmented and more than 100 partitioned tables database.
• Designed /Created DDL for DB2 /UDB database.
• Designed and implemented a database codepage conversion (Unicode) project to accommodate international language data with minimal impact to the application team and end users.
• Actively Involved in Design of tables, Partitioned Tables, views, stored procedures, user defined functions(UDF), triggers for our huge application.
• Worked upon preparation of Technical Specification Documents, Review and/or develop SQL queries for the various use cases in the application.
• Used OMEGAMON tool to see Active threads, application traces, exceptions, locking conflicts.
• Generating batch statistics report to gather information such as buffer pool at subsystem level.
• Generating Accounting reports to check application information about specific time periods which is useful for ongoing analysis and trend analysis.
• Determining the usage of Indexes and other parameters with EXPLAIN and Visual EXPLAIN.
• Tuning and Tweaking of embedded SQL’ s to use the current indexes effectively.
• Suggested Performance recommendations like creation of new indexes and alteration of existing indexes to suit the program's needs.
• Developed UNIX Shell scripts for database migration purposes between Db2 subsystems.
• Changing of Table spaces and suggestions to create partitioned table spaces for relevant tables.
• Working with Db2 Catalogs; solving execution plan problems, verified statistics, executed Bind commands, tuned performance of SQL queries, stored procedures and DB2 batch programs.
• Designed/Created Variety of batch processes to create/extract data to be loaded into DB2 databases.
• Created, modified, tested and implemented JCL procedures.
• Developed and maintained static and dynamic DB2 Stored Procedures in COBOL. SQL stored procedures in UDB.
• Developed Programs for migrations of Reporting and Extract metadata and other components from development to testing to Production.
• Developed REXX programs to automate the migration between Db2 sub systems.
• Support for maintenance of Production DB2 sub systems.
• DB2 sub systems testing after upgrades.
• Developed and maintained COBOL + DB2 programs to interface with front-end platform Java/Actuate.
• Created and modified VSAM and GDG files, using File-Aid and IDCAM utilities.
• Responsible for regular restoration, creation and reloading of DB2 tables. For the DDL creation and maintenance of database worked upon LOAD, UNLOAD, REORG, REPAIR and PLATINUM utilities.
• Responsible for Granting and revoking authority on DB2 and UDB objects as per requirements.
• Responsible for creation of JCL’ s to run the batch programs on aged data, archive the same on GDG’s for up to 6 years and Restore the same when required.
• Identified and solved Applications issues, systems related issues, contention issues, table/Table space issues. Database monitoring.
• Identified deadlocks, resource contention issues and monitored excessive locking to ensure high availability for the application team.
• Responsible for regular house keeping activities such as REORG, RUNSTATS etc.
• Removing pending status by running DB2 Utilities.
• Increasing the DB2 tables space and index space size.
• Creating Plan & packages and Granting BIND, EXECUTE PLAN Access.
• Scheduled jobs using OPC in Production and maintaining the same.
• Enhanced DB2 Processing, improved performance of numerous DB2 programs.
• Interfaced with end users to gather, evaluate and implement feedback during entire project life cycle.
• On call 24-hour Production support for DB2 batch jobs and online regions, including real-time troubleshooting and problem solving.
• Providing DB2 support for errors occurred in Java/Actuate Reporting Modules and Abinitio based Extract modules.
• Responsible for Client deliveries and production support rotation basis.

Confidential

DB2 DBA/Data Architect

Environment: COBOL, CICS, DB2, VSAM, UDB, File-Aid and Platinum Utilities.

Responsibilities:

• Created Logical/Physical Database model using ERwin.
• Reviews all data models for technical accuracy. This includes the enforcement of all modeling and naming standards.
• Responsible for Application DBA Activities and tuning of SQL Queries.
• Physical implementation of the database design provided by AMS and loading of data provided by client using DB2 Load utility. A staging and a development database were being maintained.
• Responsible for setting up various environments for Testing and UAT (Customer Acceptance).
• Written Technical Documents as per requirement given by Users.
• Developed and maintained COBOL DB2 programs, using Static SQL to interface with Java.
• Created and modified VSAM and GDG files, using File-Aid and IDCAM utilities.
• Optimized and tested SQL statements, using SPUFI and EXPLAIN.
• Used DB2 utilities and commands for data manipulation.
• Increasing the DB2 tables space and index space size.
• Creating Plan & packages and Granting BIND, EXECUTE PLAN Access.
• Modified various COBOL programs to optimize performance.
• Designed, normalized and implemented Databases, including indexes.
• Enhanced DB2 Processing, improved performance of numerous DB2 programs.
• Optimization related to creation of Secondary Indexes based on access paths indicated by EXPLAIN, SQL modifications in a bid to improve access paths, de-normalizing existing design for better performance and ensuring RUNSTATS and REORG utility run regularly.
• Assisted in developing purge/archive criteria and procedures for historical application data.
• Based on design, creation and maintenance of database and/or tables, relevant indexes, views and triggers if necessary.

Confidential

DB2 DBA

Environment: COBOL, CICS, DB2, UDB,CWS .

Responsibilities:

• Responsibilities included analyzing modules and estimating time frames for the same. Was actively involved in Preparing detailed design documents and program specifications.
• Working on the interface between COBOL and HTML (Web).
• Designed, implemented new CICS on-line programs to query DB2 database.
• Assisted for all development work on DB2. This includes helping with application development, designing and creating database objects, migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities.
• Supported DB2 sub system in production and test environments. These include OMEGAMON Performance monitoring tool, Platinum tools (RC/Query, RC/Migrator, Plan Analyzer and Database Analyzer).
• Created and Administered database objects.
• Enforced/revoked Referential Integrity (RI) on the databases as per the project requirements.
• Did synchronization of all the databases with the physical data model across various environments.
• Maintained database naming standards.
• Moved data across databases using db2move, IMPORT, EXPORT, LOAD utilities.
• Managed/executed database maintenance tasks (REORG, RUNSTATS utilities).
• Granted/Revoked access on database objects to users and groups.
• Responsible for database backups/restores.
• Did performance tuning using db2 explain/Visual Explain utilities.
• Works with Security Administration to ensure that proper security is in place for DB2 data.
• Analyze and correct problems that occur in the DB2 environment. This includes nightly support for the batch environment.

Confidential

Programmer Analyst/Team Leader

Environment: IBM Mainframe, VS-Cool II, DB2, CICS, JCL, PROC, Infoman, Endevor, SPUFI, FileAid, OARS, SAR.

Responsibilities:

• Estimating milestones of Project Requests,
• Map the user requirements with the operational systems.
• Coding and Testing of elements like Proc/JCL/Control Card/Cobol Program.
• During on call resolved Abends time to time and provided support during integration/CAT and Production cycle turnover time.
• Rendering technical help to team members, Quality review of elements.
• Resolving abends and Primary on call person for TM5F/5Z/8L
• Development of Reports using COBOL.
• Involved during teleconference and individual communication to onsite.
• Schedule and monitoring of the jobs using CA7.
• Schedule and maintain the batch processes.

Confidential

Programmer Analyst

Environment: Developer 2000, Oracle 7.0, Forms-4.5, Report writer 2.5.

Responsibilities:

• Analysis and gathering of the user requirement.
• Creation of tables in Oracle, performing DDL and DML activities and unit testing in dev environment.
• Creation of test plans.
• Development of forms and reports as per prototype.