Software Developer

MASTAN

91-924*******

**********.*******@*****.*** Teradata 13

Synopsis:

•Having 2+ years of experience in the IT industry in the Analysis, Design, Development and Implementation of business application systems in Data warehousing for business system like Banking Industries.

•Extensively worked on Database utilities like SQL, ORACLE, Informatica 8.6 and TERADATA Utilities (Fast Load, Multi Load, Fast Export, TPUMP, and BTEQ).

•Experienced with Logical and Physical Data Model design process in Star and Snowflake Schema.

•Developed ETL scripts to extract data from Oracle tables to Teradata tables using Teradata FASTLOAD utility.

•Developed Teradata FASTEXPORT scripts to export data from single and multiple Teradata tables.

•Doing Error Handling by using ET/UV/WT tables, creating various types of tables. Worked with Collect Statistics commands. Identifying & creating indexes of different types (PI, SI, JI, HI etc

•Writing various Queries by using Functions, Joins, Set operations and OLAP functions extensively.

•Strong Communication, Presentation and Interpersonal skills with excellent problem solving capabilities.

•Created & Worked with Derived, Volatile and Global Temporary tables.

•Having Knowledge on UNIX Commands.

•Having knowledge on Data warehousing Concepts.

Educational Qualifications

•Master of Computer Application (MCA) from JNT University, India.

•Certification in Diploma in Computer Application (DCA), India.

Employment Profile

•

IBM Pvt Ltd., Hyderabad – Jan’11 to till date.

Designation: Software Engineer

•

IBM Pvt L., Bangalore – Feb’10 to Dec’10.

Designation: Software Engineer

TECHNICAL SKILLS

Operating Systems : Windows 2000 / XP /, UNIX

Languages : Java

Databases : Teradata V2R7, Oracle

Data Modeling Tools : Star Schema, Snowflake Schema

ETL Tool : Informatica 8.6

Snapshots of the Projects

IBM., Hyderabad

Software Engineer Jan’11 to till date

Project Title: Loan System

Client: South Trust Bank

Teradata Developer

South Trust Bank is a leading global bank with a strong and profitable private client's franchise. Its businesses are mutually reinforcing leasing and asset finance transactions involve complex, long-term structures that are tailor-made to serve the specific legal and accounting requirements of the parties involved as well as to provide for the general framework of the respective regions.

This project meant to hold the raw data getting from the fields and keeping historical transactions and satisfying the reporting needs of the high level management. This project delivered a most trusted data warehouse to satisfy the reporting needs and single fact store

Responsibilities:

.

•Interacted with business analysts & end users to identify and develop business requirements and transform it into technical requirements

•Having experience in relational database theory and design including logical and physical structures & data normalization techniques.

•Involved in Designing and Development of logical and physical data models of systems that hold Terabytes of data.

•Worked on loading of data from several flat files sources to staging area using teradata utilities like MLOAD, FLOAD, TPUMP and Fast Export.

•Worked on Performance Tuning.

•Gathering of Requirements from the various systems business users.

•Created Global and volatile temporary tables to load large volumes of data into teradata database.

•Created, updated and maintained ETL technical documentation.

•Build tables, views, UPI, NUPI, USI and NUSI.

•Written several Teradata BTEQ scripts to implement the business logic.

•Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.

•Done Query optimization explain plans, collect statistics, Primary and Secondary indexes

•Excellent in Teradata Data warehousing environment.

Environment: Teradata (Fast Load, Fast Export, TPump, Multi Load, BTEQ), Informatica 8.6, Oracle, Sql server, UNIX.

IBM., Bangalore.

Software Engineer Feb’10 to Dec’10

Client: South Trust Bank

Teradata Developer

South Trust Bank is a World’s largest Bank.South Trust Bank offering provides day-to-day management, financial operations and operation of IT assets and processes. It has a suite of products catering to various customer segments such as home loan, vehicle loan and personnel loan etc. This project helps the top level management to analyze the customer data so that they can come up with customer segment-specific products.

Responsibilities:

•Understanding business requirements.

•Worked on loading of data from several flat files sources to staging area using teradata utilities like MLOAD, FLOAD, TPUMP and Fastexport.

•Fine tuning of Teradata/Oracle SQL to optimize the performance, spool space usage.

•Analyzed query functioning using collect statistics feature in teradata for various columns in tables.

•Loading data into Teradata database using Multiload and TPUMP scripts.

•Creating Teradata scripts using Fastexport, Fastload, Multiload, BTEQ, and TPUMP. .

•Created Global and volatile temporary tables to load large volumes of data into teradata database.

•Optimizing performance by using indexes (AJI, join indexes), joins and efficiently utilized perm and spool space areas to reduce running costs.

•Generate reports for analyzing the various customer patterns

•Write hundreds of DDL scripts to create tables, views and indexes in the company Data Warehouse.

•Providing on-call trouble-shooting support for all applications run in the data center with responsibility for all applications involved in Data Warehouse Services.

Environment: Informatica, Oracle 8i/9i, Flat files, PL/SQL, XML,Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP, SQL, UNIX.

Contact this candidate