PROFESSIONAL SUMMARY:

• 9 years of experience in IT industry and has a good domain expertise in Credit Card Applications and Banking Application.
• Worked extensively in TERADATA, SQL, UNIX, JCL, COBOL and well versed with Teradata ETL
• Utilities, AUTOSYS, VSAM, File - Aid, NDVR and Change Man.
• Very good domain knowledge in Card posting and billing system and experience in both Application development and Production Support in Teradata and mainframes.
• Also good domain knowledge in Data Warehousing.

SKILLS PROFILE:

Technical Operating System: Windows 98/XP, UNIX, OS/390

Environment: IBM Mainframes

Database: TERADATA, DB2, Oracle 10G(Basics), VSAM, VERTICA

Internet Tools: HTML, CICS

Languages: BTEQ, SQL, Cobol, MVS JCL, C, C++, SAS, FOCUS

Other: Teradata Utilities(Mload, Fload, Fast Export) File AID, NDVR, QUICK JOB, CHANGEMAN

FUNCTIONAL:

• Development, Application Support, Project Management and Business Analysis
• Trained and worked on the development projects of cards, insurance and data warehousing. Have conducted many training for team members.

PROFESSIONAL EXPERIENCE:

Technology Analyst

Confidential, Charlotte, NC

Environment: TERADATA, Teradata ETL Utilities(MLOAD,FLOAD,FAST EXPORT,TPUMP), BTEQ, SQL, UNIX, MAINFRAME, Autosys, Remedy, SAS.

Responsibilities:

• Responsible for gathering requirements from Clients and providing Offshore with high level code and Design.
• Accountable for reviewing the Design document and the getting it approved from Clients.
• Accountable for code development in Teradata BTEQ, MLOAD, Fast Export and Unix shell scripts based on the requirements.
• Involved in the migration of code components across various pre-production environments like SIT, UAT and Production migration. Also worked on the post production activities which includes code reviewing, Post production Validation and monitoring the production runs.
• Used to work with other teams like DBAs, migration teams, metadata teams for approval and install activities in the production migration.
• Used Remedy for attending Ticktes and for Production Install activities.
• Used to provide 24/7 production support for my appliction.
• Used Autosys extensively for scheduling Jobs, monitoring and run manually whenever required.
• Accountable to handle my application whenever there is an Outage in the Source side or in case of an Environment Outage.
• Have used Teradata ETL utilities(Mload, Fast Export) to pull data from Mainframe flat files to Teradata table and also have exported data from Teradata to Mainframe files.
• Responsible for implementation of new initiatives from the phase of coding till production install. Used to take care of Coding, Unit Testing, SIT testing, UAT testing and get the required approvals for production implementation.
• Used to work on lot many Analysis for the tickets or concerns raised by Users.
• Also used to work on lot many Adhoc, Analysitcal and POC tasks requested by Clients.

Confidential

Technology Analyst

Environment: UNIX, TERADATA, Teradata Utilities(MLOAD,FLOAD,FAST EXPORT,TPUMP), BTEQ, MAINFRAME, SQL, VERTICA, Autosys.

Responsibilities:

• Responsible for gathering requirements from my Onshore and Client LOBs and allocating tasks for my team members.
• Used Maximo for attending Ticktes and raising tickets.
• Used to provide production support for my appliction whenever there is an issue that is beyond L1/L2 Team's reach.
• Used Autosys extensively for scheduling Jobs, monitoring and run manually whenever required.
• Accountable to handle my application whenever there is an Outage in the Source side or in case of an Environment Outage.
• Accountable for maintaing the list of activities/tickets and prepare weekly Dashboard for the L3 Team's activities.

Confidential

Programmer Analyst

Environment: SAS, FOCUS, File Aid, CHANGEMAN, JCL.

Responsibilities:

• Responsible for gathering requirements from my Onshore.
• Used Changeman for installing Mainframe components.
• Migrated lots of Focus programs to SAS programs.
• Responsible for testing the programs created and move it to the next environment.

Confidential

Programmer Analyst

Environment: COBOL, VSAM, CICS, File Aid, CHANGEMAN

Responsibilities:

• Responsible for gathering requirements from my Onshore.
• Used Changeman for installing Mainframe components.
• Involved in the development of many COBOL programs.
• Responsible for testing the programs created and move it to the next environment.

Confidential

Associate Consultant

Environment: COBOL, DB2, CICS, File Aid, NDVR, Unix, EXCEED

Responsibilities:

• Responsible for gathering requirements from my Onshore and distributing among the team.
• Involved in designing the Creidit cards Payment Hierarchy and Interest hierarchy.
• Used NDVR for installing Mainframe components.
• Involved in the development of many COBOL programs in Mainframe and Unix.
• Responsible for testing the programs created and moving it to the next environment.
• Provided support for L3 Teams analysis whenever required.

Confidential

Associate Consultant

Environment: COBOL, DB2, CICS, File Aid, NDVR, Unix, EXCEED

Responsibilities:

• Responsible for gathering requirements from my Team Lead and completing it before the dead line.
• Used NDVR for installing Mainframe components.
• Involved in the development of many COBOL programs in Mainframe and Unix.
• Involved in coding and enhancements on the Credit cards Monetary module and Account transfer module which made me understand the functionality of the Credit card system.
• Responsible for testing the programs created and moving it to the next environment.