OBJECTIVE

• To attain a responsible and challenging position in the field of Information Technology which will enable me to put my ability, analytical and problem solving skills for the development of the organization and the self.

SUMMARY

• 7+ Years of Extensive experience in the Analysis, Development and Implementation and Testing of Data warehouse Projects.
• Extensive work in ETL processes consisting of Data Analysis, Data Sourcing, Data transformations, Mapping, Conversion, Reporting solutions with standout Performance tuning skills.
• Expertise in SQL and Performance tuning on large scale Teradata Database.
• Establishing the needs of users and monitoring user access and security.
• Enhancements and Maintenance for DWH applications.
• Expertise in creating users tables and joins in Teradata database.
• Good experience Teradata utilities like BTEQ, Fast Load, MLoad/Multiload to Load and Fast Export extract data to/from different source systems including flat files.
• Hands on experience using query tools like Teradata SQL Assistant.
• Worked on various tools like VSAM, File - Aid, Change man, ISPF TSO, TELON, File manager and Endevor.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics.
• Good hands of experience with parallel processing database technology.
• Having domain and development Life Cycle knowledge of Data Warehousing & Client Server Concepts and knowledge of basic data modeling.
• Actively involved in Quality Processes and release management activities - To establish, monitor and streamline quality processes in the project.
• Very good in Analytical thinking, decision making and problem solving skills.
• Involved in review meetings with Project Managers, Developers and Business Customer for Project.
• Ambitious, self-motivated, ability to work independently as well as in teams, possess multi-tasking skills, results oriented engineering professional.

TECHNICAL SKILLS

Languages: SQL, COBOL - II, JCL

RDBMS: Teradata V13, DB2, VSAM

Utilities: MLOAD, FLOAD, BTEQ, FEXPORT,VSAM, File-Aid, Changeman, ISPF, TSO, TELON, Filemanager, Endevor

Tools: Teradata SQL Assistant

Scheduler: CA7

Packages: MS Office (Technical Documentation)-MS Visio.

Operating Systems: MVS, OS 390

PROFESSIONAL EXPERIENCE

Confidential

Onsite Co-ordinator

Responsibilities:

• Coordination with offshore team and handling the development changes according to the business requirements
• Looking migration from Development to QAT, QAT to UAT and finally UAT to production environment from code level to functional level.
• Involving in integration of ETL process.
• Created BTEQ scripts to load data in target from stage
• Involved in requirement gathering for the new enhancements from business users and generate LOE for ETL Life cycle.
• Handling Dev meetings, Go-Live meeting and coordinating the offshore requirements in development for Monthly releases.
• Make sure of QAT covered with smoke test before go-ahead for UAT / Performance release.
• Resolving Incidents, solving customer queries.
• Analyzing the impact on the application due the changes made in upstream system and notifying the downstream system about the changes required to their application.
• Monitoring the production job scheduling and impact on the application due to schedule changes by the upstream. Notify the downstream system about the changes.
• Teradata Space forecast as an Annual activity so that jobs should not fail due to space issue.

Environment: COBOL, JCL,DB2, Teradata R13, SQL Assistant, MLOAD, FLOAD, BTEQ, FEXPORT, Fileaid, Changeman, Endevor, CA7, Filemanager

Confidential

Onsite Co-ordinator

Responsibilities:

• Coordination with offshore team and handling the development changes according to the business requirements
• Looking migration from Development to QAT, QAT to UAT and finally UAT to production environment from code level to functional level.
• Involving in integration of ETL process.
• Created BTEQ scripts to load data in target from stage
• Involved in requirement gathering for the new enhancements from business users and generate LOE for ETL Life cycle.
• Handling Dev meetings, Go-Live meeting and coordinating the offshore requirements in development for Monthly releases.
• Make sure of QAT covered with smoke test before gohead for UAT / Performance release.
• Resolving Incidents, solving customer queries.
• Analyzing the impact on the application due the changes made in upstream system and notifying the downstream system about the changes required to their application.
• Monitoring the production job scheduling and impact on the application due to schedule changes by the upstream. Notify the downstream system about the changes.
• Teradata Space forecast as an Annual activity to avoid job failure due to space issue.

Environment: COBOL, JCL, DB2, Teradata R13, SQL Assistant, MLOAD, FLOAD, BTEQ, FEXPORT, Fileaid, Changeman, Endevor, CA7, Filemanager

Confidential

Onsite Co-ordinator

Responsibilities:

• Coordination with offshore team and handling the development changes according to the business requirements
• Looking migration from development to QAT, QAT to UAT and finally UAT to production environment from code level to functional level.
• Involving in integration of ETL process.
• Created BTEQ scripts to load data in target from stage
• Involved in requirement gathering for the new enhancements from business users and generate LOE for ETL Life cycle.
• Handling Dev meetings, Go-Live meeting and coordinating the offshore requirements in development for Monthly releases.
• Make sure of QAT covered with smoke test before gohead for UAT / Performance release.
• Resolving Incidents, solving customer queries.
• Analyzing the impact on the application due the changes made in upstream system and notifying the downstream system about the changes required to their application.
• Monitoring the production job scheduling and impact on the application due to schedule changes by the upstream. Notify the downstream system about the changes.
• Teradata Space forecast as an Annual activity to avoid job failure due to space issue.
• Work with the business customer in finding the root cause on BO report issues.

Environment: COBOL, JCL, DB2, Teradata R13, SQL Assistant, MLOAD, FLOAD, BTEQ, FEXPORT, Fileaid, Changeman, Endevor, CA7, Filemanager, Business Object.

Confidential

Team Member

Responsibilities:

• Looking migration from Development to QAT, QAT to UAT and finally UAT to production environment from code level to functional level.
• Involving in integration of ETL process.
• Created BTEQ scripts to load data in target from stage.
• Involved in exporting data using FASTEXPORT as per user requirement.
• Involved in requirement gathering for the new enhancements from business users and generate LOE for ETL Life cycle.
• Handling Dev meetings, Go-Live meeting and coordinating the offshore requirements in development for Monthly releases.
• Make sure of QAT covered with smoke test before gohead for UAT / Performance release.
• Resolving Incidents, solving customer queries.
• Analyzing the impact on the application due the changes made in upstream system and notifying the downstream system about the changes required to their application.
• Monitoring the production job scheduling and impact on the application due to schedule changes by the upstream. Notify the downstream system about the changes.
• Teradata Space forecast as an Annual activity to avoid job failure due to space issue.
• Involved in Disaster recovery testing when there is a switchover to ensure that the application is working as expected.

Environment: COBOL, JCL, DB2, Teradata R13, SQL Assistant, MLOAD, FLOAD, BTEQ, FEXPORT, IMS, VSAM, Fileaid, Changeman, Endevor

Confidential

Team Member

Responsibilities:

• Looking migration from Development to QAT, QAT to UAT and finally UAT to production environment from code level to functional level.
• Involving in integration of ETL process.
• Created BTEQ scripts to load data in target from stage
• Involved in requirement gathering from business users and generate LOE for ETL Life cycle.
• Handling Dev meetings, Go-Live meeting and coordinating the offshore requirements in development for Monthly releases.
• Actively involved during the new enhancements to know more about the Business.
• Make sure of QAT covered with smoke test before gohead for UAT / Performance release.
• Resolving Incidents, solving customer queries.
• Impact analysis and monitoring the production job scheduling.
• Involved in Disaster recovery testing when there is a switchover to ensure that the application is working as expected.

Environment: COBOL, JCL, DB2, Teradata R13, SQL Assistant, MLOAD, FLOAD, BTEQ, FEXPORT, VSAM, Changeman, Fileaid

Confidential

Team Member

Responsibilities:

• After receiving an issue used to analyze the root cause for the issue and notify the users about the cause.
• Need to fix the code / Data as required to resolve the issue.
• Use to schedule the new jobs and modify the schedule of existing jobs in production as per the requirement.
• Analyze the impact on application when DB2 version changes.
• Monitor the impact on the application when there is any changes happened to the upstream system.

Environment: COBOL, JCL, DB2, VSAM, File aid, Change man