SUMMARY

• 8+ years of IT experience with expertise in analysis, design, development and implementation of Data Warehousing applications using Teradata utilities, UNIX, Teradata SQL Assistant 13.0, COBOL, JCL,CICS, DB2, VSAM, SQL, TSO/ISPF, and mainframe tools like ENDEVOR, File - AID, Xpeditor, Platinum, Easytrieve, SPUFI, QMF, NDM, SDSF, CA7, Control M.
• Extensive experience in Business Analysis, Application Design, Development, Implementation for Banking and Financial Services.
• Worked inmigration ofTeradata12 toTeradata13.
• Worked inmigration ofTeradata13.10toTeradata14.
• Strong hands on experience using Teradata utilities (BTEQ, Fast Load, MultiLoad, Fast Export, Tpump)
• Conducting code walk-through and reviewing internal and external quality assurance in the applications, debugging the defects identified and fixing them, comparing the test results with production results to make sure the changes are effective.
• Proficient in developing strategies for extracting, transforming and loading using Informatica Power Center 9.1
• Experience in designing and developing stored procedures, functions, constructing tables, views, indexes, triggers and user defined data types
• Implemented data strategies, build data flows and developed conceptual, logical and physical data models to support new and existing projects.
• Extensive experience on End-to-End implementation of Data warehouse and Strong understanding of Data warehouse concepts and methodologies.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Proven track record in delivering effective design documents, code deliverables, test strategies and business value to the customer.
• Good knowledge on version control tool- Change man
• Worked for Onsite / Offshore Model and expert at handling multiple projects simultaneously
• Expertise in debugging tool Xpeditor.
• Good knowledge on File-AID and CA7 scheduler
• Experience in Autosys for creating JIL files and Monitoring jobs
• Having Expertise knowledge in Teradata and has good exposure on other databases like Mainframe DB2.
• Has exposure to UNIX shell scripting.
• Possess excellent analytical and problem solving skills.
• Committed to continuous improvement, excellent communications, and project management skills. Self-disciplined, focused, solid teamwork and a team player.
• Good experience in technical documentation.
• Expertise in setting up testing environments, defining, creating, documenting, verifying and executing test cases, test scenarios and Test plans.
• Quick learner and keen observer, determining external & internal customer needs and well versed in internal & external relationship building. Good team worker and like to be part of a team, which always tries to explore out of box.

TECHNICAL SKILLS

Programming Languages: SQL, UNIX Shell Scripting, COBOL, JCL, REXXDatabases Teradata, DB2, SQL Server 2008

Operating Systems: Mainframes OS/390, WINDOWS, UNIX, Linux

ETL Tools: Informatica Power Center 9.1

Tools: /Applications: Teradata SQL Assistant, File-Aid, Xpeditor, DB2I, SSH Tectia Client QMF, CA7, CHANGEMAN, SPUFI, FILD, Autosys, Control M

Domain Experience: Banking & Financial services

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY

Teradata Lead Developer

Responsibilities:

• Interacted with the users, Business Analysts for collecting, understanding the business requirements.
• Prepared business requirement documents and reviewed with Clients, downstream application teams and users
• Create standard abbreviation documents for conceptual, logical, physical and dimensional data models.
• Created/EnhancedTeradataStored Procedures to generate automated testing SQLs.
• Create conceptual, logical, physical and dimensional data models.
• Document conceptual, logical, physical and dimensional data models.
• Extensively worked on the Performance Tuning of mappings, ETL Procedures and process
• Designed and developed various components usingstored procedures
• Create procedures inTeradataSQL.
• Prepared combine High level and Low level design document for all the applications
• Involved in creating scripts and JILs as per the design documents.
• Involved creating the tables in Teradata and setting up the various environments like DEV, SIT, UAT and PROD.
• Prepare Unit test case document and perform Unit testing and Integration testing
• Coordinate with up-stream and downstream application owner to process and make available the required source data for testing.
• Unit testing of the changed/new code
• SIT and UAT testing of the changed/new code
• Involved joint working session with LOBs and reviewed the results after each level of testing
• Involved in CAB activities and release planning to move the components.
• Deployed the components into production using support teams.
• Pre-Production execution and compared the results with existing production results.
• Joint working session with LOBs and reviewed and validated the pre-production execution results.

Environment: UNIX, Teradata, SQL and JCL

Confidential, Manhattan, NY

Sr. Teradata Developer

Responsibilities:

• Monitoring the Production system using the View Point tool.
• Keeping watch on the Heavy Hitter queries in production and work on performance tuning of them and thereby reducing the overheard on the Teradata Production Box.
• Space reclamation of the space more than over allocated and occupied due to skewness.
• Working on the Help Desk Spool Space Tickets and the Tickets related to the tuning of the User Queries.
• Responsible foroptimizing mappings, ETL procedures and Star schemasfor improving performance in querying and loading.
• Created UNIX Scripts for triggering the Stored Procedures
• Designed andimplemented stored procedures and triggers for automating tasks in SQL.
• Query Tuning: Tuning the high CPU consumed Queries to decrease the SUM CPU and IMPACT CPU.
• Archive Jobs Remediation.
• Collect Stats Remediation: Analyzing the Collect Stats in the Production jobs and remediation.
• Analyzing the long running, highly Skewed and non-complaint Queries and tuning on the same.
• DDL Conversions: Changing SET-MSET and vice versa for effective distribution of the data.
• Utility Conversion: MLOAD-TPUMP and MLOAD-BTEQ Conversion which saves the SUM CPU.
• Working on the migration of tables from one region to the other region. Fast exporting the table’s data to files and then loading the Files data into the tables of other region.
• Deploy changed components into production using change man tool
• Involved in CAB activities and release planning to move the components

Environment: Teradata, SQL, COBOL and JCL

Confidential, Manhattan, NY

Sr. Teradata Developer

Responsibilities:

• Interacted with the users, Business Analysts for collecting, understating the business requirements.
• Prepared High level and Low level design document as per the requirement design document.
• Involved in creating Jobs and scripts as per the design documents.
• Coordinate with downstream and up-stream application owner to process and make available require data for users reporting.
• Development of Informatica Mappings and History load scripts
• Involved in unit testing of the changed/new code.
• Involved SIT and UAT testing of the changed/new code.
• Reviewed the test results with LOBs and the defects are logged into QC.
• Logged the defects in QC and assigned to respective team and also involved in defect fixes raised by business users and Quality team.
• Involved in CAB activities and release planning to move the components.
• Deployed the components into production using support teams.
• Provided one month warrant support and completed the production handover

Environment: Teradata, SQL, COBOL and JCL

Confidential, Omaha, NE

Sr. Developer

Responsibilities:

• Interacted with the Technical leads, Business Analysts for collecting, understating the business requirements
• Design, Development, and Enhancement of new functionalities
• Developed COBOL programs and JCLs as per the design documents
• Testing, Reviewing with Check List and Code Walk through
• Writing the Stored Procedures, checking the code for efficiency.
• Used Changeman to compile COBOL and DB2 programs and maintained the different versions
• Ensuring that the deliverables meet the Quality standards
• Ensure defect free implementations
• Responsibility for overall quality and timeliness of the deliverables
• Data validation after each level of testing
• Coordination with offshore team
• Reviewing the work done by team members
• Support for System testing/Implementation

Environment: Mainframes (JCL & COBOL), EASYTRIEVE, DB2

Confidential

Team Lead

Responsibilities:

• Interacted with the Technical leads, Business Analysts for collecting, understating the business requirements
• Design, Development, and Enhancement of new functionalities
• Developed COBOL programs and JCLs as per the design documents
• Used Changeman to compile COBOL and DB2 programs and maintained the different versions
• Testing, Reviewing with Check List and Code Walk through
• Ensuring that the deliverables meet the Quality standards
• Responsibility for overall quality and timeliness of the deliverables
• Data validation after each level of testing
• Coordination with onsite team
• Support for System testing/Implementation

Environment: Mainframes (JCL & COBOL), EASYTRIEVE, DB2

Confidential

Developer

Responsibilities:

• Interacted with the Technical leads, Business Analysts for collecting, understating the business requirements
• Involved in analyzing, design, coding and testing the modules
• Prepared High Level and Low-level design documents
• Responsible for unit testing,SystemIntegration Testing (SIT) and User Acceptance Testing (UAT) support
• Extensively worked on COBOL, JCL, and DB2 for development of programs
• Used Changeman to compile COBOL and DB2 programs and maintained the different versions
• Used FILEAID, Platinum, QMF, Xpeditor tools
• Reviewing the work done by team members

Environment: Mainframes (JCL & COBOL), EASYTRIEVE, DB2

Confidential

Responsibilities:

• Working on the tickets raised by the development team
• Allocating the space for DEV tables
• Deallocating the space from the DEV tables
• Sending email notification to the teams for reminding the table deletions or extensions
• Providing the different levels of access to DEV tables based on the requests
• Attending meetings with clients
• Loading the development environment space details into the database

Environment: Teradata