SUMMARY:

• 16+ Years of experience in all aspect of application design, development, legacy migration/modernization, implementation, maintenance and DB2 Administration.
• Strong knowledge on Big Data Hadoop Administration.
• Familiarity with Hadoop Ecosystem and components HDFS, Hive, Pig, HBase, Sqoop, Flume, Oozie, ZooKeeper, Cloussdera CDH4, HiveQL, and PigLatin.
• Strong understanding of various technologies, applications development and migration project life cycle Phases.
• Good in understanding complex interfaces across applications.
• Effectively worked with Operating systems Windows, Linux, Solaris and Unix (HP - UX & AIX).
• Having experience in consulting in medium to large-scale enterprise wide migration projects.
• Good knowledge and hands-on implementation experience with Migration concepts using tool based solutions.
• Skilled in DB2 database administration, data modeling, SQL coding, stored procedure and trigger development.
• Skilled in Sybase, SQL coding, stored procedure development.
• Rich experience in Legacy application migration and Modernization.
• Good understanding and hands-on experience on migration using Micro Focus suite of products.
• Having strong knowledge of scripting languages in UNIX.
• Self-motivated with strong leadership and team player skills, adept at motivating and supporting team members to achieve professional goals.
• IBM certified Database Associate - DB2 9 Fundamentals.
• More than 8 years of proven DB2 DBA experience expertise in leveraging DB2 database platform for enterprise wide solutions and having Work experience includes DB2 Application Programmer/DB2 Database Administrator.
• Experienced as Application & Support DBA.
• Hands on experience in Data Integration, Performance Tuning and troubleshooting problems.
• Certified IBM Informix Mastery Test.
• Extensive experience in Incident Management and Problem Management.
• Good exposures to SW build systems and configuration, change & release management.
• Good People management skills in hiring right talent and team management.
• Strong experience in Requirement Analysis, Impact Analysis, System design and Implementation.
• Experienced in managing projects & handling responsibilities in various phases of SDLC.
• Executed Key projects for major banks like Confidential Confidential, Confidential, Confidential and Confidential .
• Developed the Assessment technique using Analytical Hierarchy Process to derive the Business Value, Risk Exposure and Capability improvement weightage.
• Developed the Legacy migration approach using AHP model. Provided the high level migration solutions to the new platform.

TECHNICAL SKILLS:

Operating System: MPE, MVS/ESA, Z/OS, Microsoft Windows, UNIX (HP & AIX), Solaris & Linux

Languages: Micro Focus Cobol, JCL, CICS andSQL

Database: DB2, Sybase, Oracle, Informix, MySql, Tourboimaze andAllbase

Utilities: sed, awk, perl, TSO/ISPF, VSAM, QUERY, QEDIT, ASKPLUS and SUPRTOOL

Tools: FILE-AID, XPEDITER, INTERFACE TRANSFER MONITOR, ANIMATOR

Others: Bigdata/Hadoop,HDFS, Hive, Pig, HBase, Sqoop, Flume, Oozie, ZooKeeper, Cloudera CDH4, HiveQL, and PigLatin, Micro Focus Enterprise Server (Net & Server Express), UNIX Shell Programming,Clarify, Clear Case,CIRTIX, Connect Directory (NDM), CVS, Subversion, Control-M, Autosys&OpsWise.

WORK EXPERIENCE:

Confidential

Technical Architect

Responsibilities:

• Supervising architectural & design specification, transforming business requirements to architectural Models, designing & developing business solutions as well as for RFPs proposals & estimation.
• Developing high level designs meeting the prescribed functional & non-functional requirements; ensuring the design is as per company standards and best practices.
• Experience in Disaster recovery, Buffer pool maintenance/tuning.
• Extensively worked with DB2 Explain, Runstats, REORG and other ONLINE and Offline utilities.
• Database operations like Tuning, monitoring, backups & recovery, Data loads and other Database operations.
• Working on TSM backup and restore.
• High availability and disaster recovery experience with DB2 HADR.
• DB2 LUW Application and DB2 Admin Support.
• DB2 database administration, data modeling, SQL coding, stored procedure and trigger development.

DB2 SME

Responsibilities:

• End-to-end project management activities inclusive of planning, designing, scope, and estimation, tracking milestones, Resource, task list, resource coordination and delivery as perspecified time frame.
• Served as a key driver of pre-sales activities across technology, handled proposal submission process, quotation gathering, consolidation and solution suggestions; liaised with the sales team by answering queries and managed customersensured proper trainings for fresher’s on overall career development.
• Collaborated with interface teams for on-going enhancements & implementations.
• Supervising architectural & design specification, transforming business requirements to architecturalModels, designing & developing business solutions as well as for RFPs proposals & estimation.
• Defining service standards and guidelines as per global best-practices, governance structures and best practices for software delivery life cycle and documentation that serve as benchmarks for excellent service delivery.
• Developing high level designs meeting the prescribed functional & non-functional requirements; ensuring the design is as per company standards and best practices.
• Leading, mentoring & monitoring the performance of team members to ensure efficiency in process operations. Developing competency among the team members.
• Steered process re-engineering, defect tracking and root cause analysis on production related issues.
• Liaised with interface teams for on-going enhancements & implementations.
• Ensured process change deliver to meet end user’s requirements.
• Propounded inputs for modifying the existing application and carried out implementation for order management, shipping & inventory and invoicing module.
• Rendered effective application support for a supply chain program.
• Handled codes development, modification & bug fixing; involved in extraction, transformation & loading of data to DWH tools.
• Exceptional skills in Tuning and analyzing application code such as SQL, Triggers, Stored Procedures, CPU, I/O, Memory, Setting up Backup and recovery strategies, Scheduling jobs, developing database procedures and functions.
• Experience in Disaster recovery, Buffer pool maintenance/tuning.
• Extensively worked with DB2 Explain, Runstats, REORG and other ONLINE and Offline utilities.
• Has extensive experience in Database operations like Tuning, monitoring, backups & recovery, Data loads and other Database operations.
• Working on TSM backup and restore.
• High availability and disaster recovery experience with DB2 HADR.

Application Specialist

Responsibilities:

• Steered process re-engineering, defect tracking and root cause analysis on production related issues.
• Handled codes development, modification & bug fixing; involved in extraction, transformation & loading of data to DWHTools.
• Development, supporting applications products and client-specific applications software.
• Investigate the options available for migration from the HP3000 to the HP9000 HP-UX Servers.
• Migrating Application from MPE/iX to HP-UX client/server applications.
• DB2 UDB Application and DB2 Admin Support.
• Data Integration, Performance Tuning and troubleshooting problems