PROFESSIONAL SUMMARY:

• 11+ years of overallIT experience with a strong background in software development and 6 Years of experience in Core Mainframe applications and 5+ Years of Experience in DataStage & Teradata along with Mainframes and Business Intelligence solutions in Data Warehousing and decision support systems using the ETL tool DataStage.
• Over 5+ years of experience with Enterprise Data Warehousing (EDW) projects and Proficient in Extract Transform and Load (ETL) processes involving Teradata, DataStage, Mainframe and UNIX shell script.
• Strong Knowledge in Data Warehousing methodologies of Star/Snow flake Schemas.
• Worked with different DataStage stages like ODBC Connector, Teradata Connector, Transformer, Copy, Merge, Join, Filter, Look - up, and Aggregator stages in ETL.
• Thorough understanding of using AXSMOD in DataStage to handle untranslatable characters
• Extensive working knowledge in Teradata utilities (TDLOAD, BTEQ, Fast Load, Fast Export, Multiload, TPT and Tpump) and various mainframe tools like ENDEVOR, Panvalet, FILE-AID, FILE-MASTER, OPC, CA-7, SAR, SAVRS, JMR, SPUFI & QMF.
• Excellent team player with experience in working large size project team
• Experience in integration of various data sources like Oracle, SQL Server and Sybase in to Teradata Enterprise Data warehouse using Mainframe Batch processes.
• Strong understanding and experience in software development methodologies/concepts like SDLC, AGILE and CMMI process improvement.
• Completed s in property and casualty line of insurance, publications, Airlines and Hospitality domains.

TECHNICAL SKILLS:

Operating Systems: MVS, DOS, Windows 95- 7

Languages: COBOL, JCL, CICS, Adders, Easytrive, APS

Tools: DataStage, Endeavor, File-Aid, File-Master, File Manager, SPUFI, QMF, Platinum, CA7, SAR, JMR, BMC, SAVRS, OPC, Panvalet, FTP Pro, Teradata Viewpoint, TSO

Database: VSAM, DB2, M204, Teradata

Vendor Packages: ENTRI, QAS, VALITY, Trillium

IT Service Management tools: Remedy, Peregrine, Assyst, WMS, Webstar

Methodologies: Agile, SDLC Waterfall

Document Management: VSS, SharePoint

Business modeling: Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential

Technology Lead

Environment: Teradata, Data Stage, UNIX, and JCL

Responsibilities:

• Participating in user meetings, gathering Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Involved in designing & developing DataStage Mappings and workflows for extraction of data from various source DB into staging Area
• Performing Data ModelingusingER diagram, Dimensional data modeling, Star Schema modeling and Snow-flake modeling.
• Creating Mapping Documents and ETL design documents. Followed Enterprise Level Metadata while creating design and source-to-target mapping documents.
• Designing of data loads into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Involve in designing and coding Teradata Macros from staging to Target Tables.
• Working in loading data into Data Warehouse/Data Marts using DataStage, Teradata Utilities such as Multiload, Fast load and BTEQ utilities
• Working on indexes in Teradata and Creation of proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Performance tuning for Teradata SQL statements using Teradata Explain command and Run stats
• Preparing release plan considering the System down time, Blue note communication for Users, back out plan and change release window.

Confidential

Senior Developer

Environment: COBOL, JCL, VSAM,DB2, BMC, File-Aid and SPUFI

Responsibilities:

• Performing end to end analysis of existing systems.·Preparing Technical Spec and estimations for the new programs.
• Preparing artifacts related to SDLC.
• Performing Coding, unit testing and creating Test pack for the same.
• Code changes for defects raised in Quality center and updating the same.
• Allocating tasks, reviewing and responsible for deliveries.

Confidential

Production Support Analyst

Environment: COBOL, JCL, VSAM, M204, JMR, CA7 and File-Master.

Responsibilities:

• On call for ICSS batch cycle as primary support.·Responding to the logs/tickets (24X7) based on the severity .
• Generating adhoc reports based on Business users requirement.
• Also automated some of the adhoc requests.
• Supported other applications namely International data for stores, Core Customer Database and Customer information System

Confidential

Developer

Environment: COBOL, JCL, VSAM, DB2, Endeavor, SAR and File-AID.

Responsibilities:

• Preparing program specification for new code. Unit testing, preparation of copybooks, JCL S, Procs etc.
• Preparation of unit test data, document the newly constructed programs and the changed programs.

Confidential, Charlotte

Developer

Environment: COBOL, JCL, VSAM, Easytrive, APS, Endeavor, SAR, CA7 and File-AID.

Responsibilities:

• Monitoring the job with macro running for all the applications and fixing job abends.. Analysis, Coding and testing for Enhancements.
• Preparing the SDLC documents for the work items.
• Responsible for other small applications and performing Adhoc requests.