SUMMARY:

• Having 6+ years of Total IT experience in Mainframe and Data warehouse Applications in the Domains of Banking and Confidential . Has extensive hands - on experience in Mainframe, Ab Initio development and UNIX.
• Involved in various phases of projects like Requirement analysis, Design, Development, Testing, Implement, Enhancements, Maintenance, Production Support and Data Quality Processes
• Have started career with Mainframe technology in Confidential domain for 2 years and then moved to Banking domain where currently working on multiple technologies - Ab Initio, UNIX and Mainframe.
• Good Knowledge on Mainframe, DB2 and Data ware house concepts.
• Have been working with critical Ab Initio components like Transform (Reformat, Filter By Expression, Join, Dedup etc), Partition (Partition By Expression, Partition By Key, Partition By Round-Robin etc), Departition (Concatenate, Gather, Merge, Interleave), Sort (Sort, Sort within Groups) and Multi stage (Rollup, Scan, Normalize) Components, Dataset (Read/Write Multi Files)
• Good Knowledge on Parallelism concepts (Data, Pipeline & Component Parallelism), Lookups and m-commands
• Lead a team in an Onsite - Offshore Model. Co-ordinate with offshore team and get daily work assigned and get completed.
• Provide Daily/weekly status report to Customer.
• Co-ordinate with Customer to solve business and technical issues.
• Analyze and Understand Requirements from customer and create high level documents.
• Create Build test plans and capture test results.
• Debugging and resolving all types of severity issues in job abends on time to meet the SLA’s.
• Handled Project Estimation, Work efforts estimation, Plan deliverables and deliver error-free code on time for various projects.
• Efficient in software engineering skills in generating design and architecture artifacts using SPRINT Process (Envisioning, TimeBoxedDev, Release Testing, Release & Deploy Working Software).
• Have extensive knowledge and working experience on Software Development Life Cycle (SDLC) and AGILE Methodologies.
• Learning Bigdata/Hadoop to upgrade my skill set with present technology trend.
• A hard working and talented professional with excellent communication, analytical and programming skills, ability to work effectively in a team, flexibility to work on different technologies, a self-learner with proven expertise in development activities, including requirement analysis, design, testing and client interaction.

TECHNICAL EXPERTISE:

Technology: Mainframe (COBOL, JCL, VSAM, EASYTRIEVE, DB2,CHANGEMAN, Expediter, Control-M,CICS)

ETL Tool: Ab Initio

Application Ser: Windows XP, UNIX.

Languages: SQL.

Databases: DB2

Domain: Banking & Confidential .

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Environment: Ab Initio, Unix, Mainframe, DB2

Responsibilities:

• Performing requirement analysis and translating Business needs to Functional and Non-Functional requirements.
• Prepared documents like solution architecture, security interaction and test cases documents etc.
• Worked on data mapping between source and target elements.
• Development of Ab Initio graphs that run on a daily basis as per business requirements.
• Designed and Development of ETL using Ab Initio.(Creation of Ab Initio Graphs)
• Creating Sandbox level, Graph level parameters according to the requirements
• Creation of the Control-M Scheduling Scripts and scheduling the jobs.
• Validation of Component/Assembly Testing outcomes with Client
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like Check In and Check Out were used for this purpose.
• Performing Transformations on source data with Transform Components like Reformat, Filter-by-Expression, Rollup etc.
• Created and Performed reviews of all ETL designs, graphs, and test plans.
• Done appropriate unit-level testing, log defects in QC and the management of the review process for the Ab Initio deliverables.
• Providing 90 Days of warranty support to the application

Confidential

Technical Lead

Environment: Ab Initio, Unix, Mainframe, DB2

Responsibilities:

• Developing and modifying the modules as per the Business Need Request initiated by the client.
• Enhancement of the existing system.
• Identification of the Technical and Business implication of the Business Need Request initiated by client.
• Performing Impact Analysis to identify the modules impacted by the Business Need Request initiated by the client.
• Estimation of effort required for completing the activity.
• Coordinating and assisting the team to ensure that the tasks are delivered on schedule.
• Integrate the developed modules and all other sub-modules followed by integration testing to thoroughly test the code conformity to business and non-functional requirements.
• Porting the modules to support compatibility across different systems developed in different architectures.
• System integration test of specific modules using test plans
• Performance tuning to improve application and database performance
• Ensuring adherence to Quality Standards on the deliveries made.
• Warranty Support for delivered project for 90 days

Confidential

Team member

Environment: Mainframe

Responsibilities:

• Involved in Requirement analysis and performing detailed study of the existing programs.
• Involved in estimation, design, coding, testing and documentation.
• Prepared Unit Test Plan and developing test cases.
• Reviewing and delivering projects with highest quality.

Confidential

Team Member

Environment: Mainframe

Responsibilities:

• Analyzing, mapping the business requirements and designing the flow for implementation of Rate Sheet extraction.
• Prioritizing the work, allocating and reviewing.
• Coding of programs, unit testing.
• Guiding or helping team members for the effective quality of deliverables and to meet the time lines.