TECHNICAL SKILLS:

ETL Tool: Teradata - BTEQ,MLOAD,FLOAD, FastExport, Informatica Power Center 9.1.0/9.1.5 , Data Stage

Programming: SQL(in depth knowledge), UNIX shell scripting, Oracle, SAS, cassandra

Reporting Tool: SAP - Business Objects(R3), Desktop Intelligence, Web Intelligence

Databases: TERADATA 14.10/13.00

RDBMS Tools: TERADATA

Testing Tools: Quality Center

Scheduling Tool: Control-M, Autosys

Operating Systems: Windows 7/XP/2000/Linux

PROFESSIONAL EXPERIENCE:

­­­­­­­­­

Programmer Analyst

Confidential

Responsibilities:

• Driven a team of highly-trained and motivated BofA associates supporting bank card information production Teradata, Oracle, DB2 system containing multiple batch cycles, acting as Level 1 support.
• Ensured Unix Teradata job flows perform seamlessly and promptly mitigate any offending processes using TERADATA/SHELL.
• Employed Autosys to manage Linux, Datastage, Informatica,SAS,Cassandra and Teradata job processes and perform root-cause analyses for failed jobs and resolve any abnormalities quickly.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Query man).
• Experienced in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

Senior Application Developer

Confidential

Responsibilities:

• Experience in Dataware Housing, worked on different Databases like Teradata and developing Strategies for loading using Teradata utilities such as FASTLOAD,MULTILOAD,FASTEXPORT,BTEQ,TPT etc.
• Proven track record in planning, building, and managing successful large-scale Data Warehouse and decision support systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Vast experience in end to end life cycle Implementation of data warehouse.
• Automated Workflows and BTEQ scripts using scheduling tool.
• Well versed in writing UNIX korn shell scripting scripting.
• Reduced the file processing time from 2.5 hours to 30 minutes by combining all the files received, using AWK (Unix) and then loading it to the warehouse, was awarded with Eminence & Excellence Orion Award.
• Researched Sources and identified necessary Business Components for Analysis.
• Gathered the required information from the users.
• Interacted with different system groups for analysis of systems.
• Created tables, views in Teradata, according to the requirements.
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Analysis of Business and system requirements including impact analysis of existing systems and create detail requirements with the consultation of Business users and technical architects.
• Creation of design documents for the requirements.
• Familiar in Creating Secondary indexes, and join indexes in Teradata. .
• Experience in multiple business domains (Telecom & Financial).
• Provided performance tuning and physical and logical database design support in projects for Teradata systems.
• Implemented slowly changing dimensions methodology to keep track of historical data.
• Successfully implemented projects using TD- Utilities- FLOAD,FASTEXPORT, MLOAD,TPT
• Worked on projects to integrate various data sources Sybase, Teradata, and Flat Files
• Analyzed existing warehouse and made necessary changes / modifications
• Experience in Data modeling in building data model
• Wrote appropriate code in the conversions as per the Business Logic using Bteq scripts.
• Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, MultiLoad, and Tpump).
• Expertise in performance tuning the user queries. execution of frequently used SQL operations and improve the performance.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities and Unix Shell scripts.
• Played a major role in setting up different regions - Testing, Integration, Performance, Break fix and Production environment with the Wrapper scripts and setup and folder structure for Teradata scripts to run in UNIX environment.
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
• Understanding BRD, Data required document and mapping documents.
• Creation of Data bases and users Space and User maintenance on dev machine
• Designing the ETLs and conducting review meets Involvement in implementation of BTEQ and Bulk load jobs.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Worked on Teradata Query man to validate the data in warehouse for sanity check.
• Scheduled jobs for batch processing using Maestro Scheduler.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Developed unit test plans and involved in system testing.
• Worked in one of the biggest Data warehousing projects of Confidential and developed Codes as per the design to load the interface data into the Data warehouse tables
• Prepared CRQ implementation documents to migrate the code from SIT to Confidential .
• Prepared Unit Test Cases and reviewed documents of the project.
• Analyzed the Source and Target databases to understand the business, thereby suggesting new areas of improvement.
• Received an award for suggesting and developing a tool which could check the total failures in production environment at any instance of time, and send notifications to the concerned person, which helped save time during Production deployment.