Profile:

• 8 years of total IT experience
• 6 years as Teradata/ETL Developer

Summary:

• SDLC: 7 years of experience in analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines. Diverse industry experience, including Telecom, Retail, Financial and Manufacturing
• Teradata: 6 years of Teradata V 13/V 12/V2R6/V2R5/V2R4.1/V2R3, Teradata SQL Assistant Queryman . Experience on data load/unload utilities like BTEQ Import/Export , FastLoad, MultiLoad, T-Pump, Fast Export. Worked on Teradata administrative utilities like Teradata Manager, Teradata Administrator, Teradata Visual Explain and Teradata Index wizard. OLAP, OLTP, ETL, BI, Sync Sort for NCR 4300/5200. Proficient in Teradata V2R5 database design Logical and Physical , Query Optimization, SQL Performance Tuning, PLSQL and dynamic SQL.
• Teradata Skills: Teradata SQL, Teradata Basics, Teradata Physical Implementation and Teradata Application development .Knowledge on PMON
• Data Modeling: 4 years of Dimensional Data modeling experience on Data modeling, Erwin 4.5/4.0/3.5.5/3.5.2, Dimensional Modeling, Datamarts, OLAP, FACT Dimensions tables.
• Databases: 7 years of experience using Oracle 11g/10g/9i/8i/8.0/7.0, DB2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3,DB2 for OS/390, 12.x/11.x, MS Access 7.0/2000,SQR 3.0, Erwin 3.5/3.x, SQL, XML, PL/SQL, SQL Plus, SQL Loader and Developer 2000 and SQL Server 12.0/11.x, MS SQL Server 2000/8.0/7.0/6.5, MS Access 97/2000.

Technical Skills

Professional Experience:

Teradata Developer

• Confidntial is built on more than 30 years of customer focus, dedication, and innovation. American Eagle Outfitters, Inc. is now a portfolio of brands, with American Eagle Outfitters for 15 - 25-year-old girls and guys,
• Aerie for the college girl, 77kids for grade-schoolers, and little77 for infants.
• AE.COM , the online home of all the brands, ships to 76 countries worldwide.

Responsibilities

• Understood the business needs and implemented the same into a functional database design.
• Worked closely with Project Managers, Business Analysts, BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and execute the SQL's on UNIX environment.
• Working with vendors to provide required data.
• Create BTEQ scripts to extract data from warehouse for downstream applications.
• Participated in Meetings of Designing Source Matrix Preparation for the System for both Dealers vendors and subsequent strategy changes in those systems.
• Export data using BTEQ and FastExport.
• Used Teradata SQL Assistant extensively to work with Teradata Database.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Develop processes on Teradata using RDBMS utilities such as FastLoad, FastExport and BTEQ Teradata .
• Versed with proactively addressing DBMS performance issues such as partition optimization, indexes, and statistics collection.
• Troubleshoot the failure Jobs.
• Developed SHELL scripts and PERL programs for getting the data from all systems to load into Data Warehousing system. The data was standardized to store various Business Units in tables.
• Performance Tuning of sources, Targets and SQL queries in transformations.
• Used Visual Explain for query optimization.
• Developed unit test plans and involved in system testing.

Environment: Teradata 14, Teradata QueryMan, Utility: Teradata Loading Utilities BTEQ, MultiLoad, FastLoad and Fast Export ,Unix.

Confidential

Teradata Developer

I have been involved in project SHIELD for remediating 300 Data Card Service processes which belongs to different areas like Disputes Dashboards, Disputes Cycle Time, ALR ADDRESS, Credit Limit Change Report etc.The main goal of the project is to increase the customer data security for not to have the access to plastic number.

Responsibilities

• Work on SQLs to get required data.
• Help the reporting team by providing the Teradata SQL queries.
• Involve in implementation of BTEQ and Bulk load jobs.
• Create BTEQ scripts to extract data from warehouse for downstream applications.
• Export data using BTEQ and FastExport.
• Execute the SQLs on Unix environment.
• Develop processes on Teradata using RDBMS utilities such as FastLoad, FastExport and BTEQ Teradata .
• Troubleshoot the failure Jobs.
• Develop MLoad scripts to load data from Load Ready Files to Teradata Warehouse.
• Solved various defects in set of wrapper scripts which executed the Teradata BTEQ, MLoad and FLoad utilities.
• Wrote Teradata SQL queries according to process needs.
• Used Visual Explain for query optimization.

Environment: Teradata V2R13, Teradata QueryMan, Oracle 8i, Utility: Teradata Loading Utilities BTEQ, MultiLoad, FastLoad and Fast Export

Confidential

Teradata/Informatica Developer

WellPoint, Inc. formerly Anthem, Inc. was formed when WellPoint Health Networks Inc. and Anthem, Inc. merged in 2004 to become the nation's leading health benefits company. EDWard Enterprise Data warehouse and Research Depot is the IT Platform.

Responsibilities

• Communication with business users and analysts on business requirements.
• Creating Scope doc's and coming up with Technical design.
• Working on SQL's to get required data.
• Using Informatica to load data from source to staging.
• Helping the Reporting team by providing the Teradata SQL queries.
• Working on Claims and memberships Subject Areas.
• Involvement in implementation of BTEQ and Bulk load jobs.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Exporting Data using BTEQ and Fast Export.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator
• Execute the SQL's on UNIX environment.
• Expertise in working with various operational sources like Oracle and Mainframe.
• Have Knowledge on PMON.
• Performance tuning the long running queries.
• Developed processes on Teradata using RDBMS utilities such as Fast Load, FastExport, BTEQ Teradata .
• Involved in understanding requirements and in modeling activities of the attributes identified from different source systems which are in Oracle, Teradata, CSV FILES and Mainframe.
• Troubleshooting the failure Jobs.
• Checking the table skewing.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Tuning and optimization of Teradata Queries.
• Code review's in production issue's.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities.

Environment: Teradata V2R13, Teradata Queryman, Oracle 8i, Utility: Teradata Loading Utilities Bteq, Multiload, Fastload, Fast Export ,Powercenter9.

Confidential

Teradata Developer.

Confidential is a global leader in delivering innovative communications, information and entertainment. We offer voice, data and video products and services over intelligent wireless, broadband and global IP networks that meet customers' growing demand for speed, mobility, security and control. As a committed corporate citizen, we use our advanced communications services to address important issues confronting our society.

Responsibilities

• Communication with business users and analysts on business requirements.
• Fulfilled ad-hoc requests coming from superiors.
• Working on SQL's to get required data.
• Helping the Reporting team by providing the Teradata SQL queries.
• Working on individual work Requests.
• Involvement in implementation of BTEQ and Bulk load jobs.
• Worked on PMON,Manager.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Exporting Data using BTEQ and Fast Export.
• Execute the SQL's on UNIX environment. Performance tuning the long running queries.
• Developed processes on Teradata using RDBMS utilities such as Fast Load, FastExport, BTEQ Teradata .
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Created SSIS package to load data from Flat File 2GB -- 4GB to Flat File and Flat File to SQL Server 2008
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Tuning and optimization of Teradata Queries.
• Worked on DDF for masking data.
• Created Aggregate Join indexes AJIs for OLAP ROLAP development
• Code review's in production issue's.
• Monitoring load job's and issues.
• Interaction with user's to work on AST's.
• Changing of SQL's as per required, creating reports to users.

Environment: Teradata V2R12, Teradata Queryman, Oracle 8i, Erwin7.2, Utility: Teradata Loading Utilities Bteq, Multiload, Fastload, Fast Export , SQL Server 2008.

Confidential

Teradata/Informatica Developer.

Confidential is the worlds leading Producer of large and small jet engines for commercial and military aircraft. They also Supply Aircraft-derived Engines for Marine Applications and Provide Aviation Services.

Responsibilities

• Understanding BRD, Data required document and mapping documents.
• Experienced in Creating the Data bases and users
• Space estimations and User maintenance on dev machine
• Designing the ETLs and conducting review meets.
• Coded test SQLs and analyzed results.
• Created ad-hoc reports using SQL server 2005 Reporting Services SSRS .
• Involvement in implementation of BTEQ and Bulk load jobs
• Working on different transformations. router,Aggregator,Expression
• Coding using BTEQ SQL of TERADATA.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities.
• Execute the SQL's on UNIX environment. Performance tuning the long running queries.
• Worked with Teradata EXPLAIN facility, which describes to end-users how the database system will perform any requests.
• Migrated all DTS packages to SQL Server Integration Services SSIS and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Populate or refresh Teradata tables using Fast load, Multi load Fast export utilities for User Acceptance testing and loading history data into Teradata.
• Reduced Teradata space used by optimizing tables adding compression where Appropriate and ensuring optimum column definitions.
• Monitoring ETL jobs until production jobs are stabilized.
• Tuning and optimization of Teradata Queries.
• Using the UNIX wrappers to make the workflows.

Environment: Teradata V2R6, Teradata Queryman, Informatica V 7.1.2, SQL server 2005 ,Oracle 8i, Erwin7.2, Utility: Teradata Loading Utilities Bteq, Multiload, Fastload, FastExport, Tpump .Informatica 8.

Confidential

Teradata Developer

Confidential is a wholly owned subsidiary of Sony Computer Entertainment Inc. Its PlayStation brand continues to redefine interactive consumer entertainment with the ground-breaking products that include the PlayStation 3 PS3 computer entertainment system, the PlayStation 2 PS2 , PlayStation Portable PSP and PSP go handheld entertainment systems, and its online and network services, the PlayStation Network and PlayStation Store.

Responsibilities:

• Understanding BRD, Data required document and mapping documents.
• Experienced in Creating the Data bases and users.
• Worked in Data migration using Mainframe files
• Space estimations and User maintenance on dev machine
• Involvement in implementation of BTEQ and Bulk load jobs
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and execute the SQL's on UNIX environment.
• Performance tuning the long running queries.
• Developed processes on both Teradata using shell scripting and RDBMS
• Used utilities such as Multi Load, Fast Load, Fast Export, BTEQ.
• Experienced with mentoring Teradata Development teams, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing
• Designed and developed Informatica mappings for data loads
• Involvement in optimization
• Preparation of Production support document
• Monitoring ETL jobs until production jobs are stabilized
• Experienced in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading ETL mechanism using Informatica
• Creating workflows in Informatica to run the BTEQ scripts and bulk loads.
• Change request management.
• Tuning and optimization of Teradata Queries

Environment: Teradata V2R12, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP Windows XP, Sun Solaris 2.8, SAS, SAS/MACROS Erwin Data Modeler.

Confidential

Teradata Developer

AIG began as a small insurance business grew to become one of the world's largest companies. By the end of 2007 AIG had assets of approximately 1 trillion, 110 billion in annual revenues, 74 million customers and 116,000 employees in 130 countries and jurisdictions. Yet, less than a year later, AIG found itself on the brink of failure and in need of emergency government assistance

Responsibilities

• Designed Technical Design Documents for the Terada BTEQ 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.
• Interacted with System Test, Integration Test, Performance Test, User Acceptance test, Production dry run teams to solve the various stages of Defects and provided solutions to their Road blocks..
• Documented the mappings used in ETL processes.
• Designed and Developed the Common Audit and Error Routines for BTEQ Scripts, which is implemented to all Teradata related interfaces.
• Prepared the Release notes and ESP Schedule Document which was used in creating ESP Schedule.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Developed unit test plans and involved in system testing.
• Co-ordinated with Transformation Team members and Reporting to Integrate the data from Teradata Staging to Teradata Base Table Environments and then to Reports.
• Involved in finding the root cause of the Defect in Testing, Integration, Performance, Break fix and Production and Report related issues and provided appropriate solutions with quick turnaround time.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities and UNIX Shell scripts.
• Provided the Production Support During the Warranty Period.

Environment: Teradata V2R6, BTeq, Mload, Fast Load, Tpump, Teradata SQL Assistant, Informatica power center 7.1, UNIX and Windows XP,

Confidential

Teradata Developer

Merry Lynch Company provides unmatched convenience in the Confidential , serving more than 59 million consumer and small business relationships with more than 6,100 retail banking offices, more than 18,000 ATMs and award-winning online banking with more than 25 million active users. Bank of America offers industry leading support to more than 4 million small business owners through a suite of innovative, easy-to-use online products and services.

Responsibilities

• Worked on the Module Call Detail Record, sustaining its Production support and implemented digits analysis on the called number to identify the called country, within and outside the nation and identified the international long distance calls.
• Worked on different subject areas like Product, Billing, Subscription, and Party.
• Worked on the National Billing Instance NBI - module which involves modifying no. mappings and corresponding Fast Load and BTeq scripts.
• Worked on Home Location Register HLR , consumer save tool modules to enhance the Mappings and Teradata scripts to accommodate the change in Table structure.
• Developed the Maestro Schedules for different Extract, Transform and load jobs and implemented considering other schedule constraints
• Organised a team of Developers to Develop, Unit Test, Test cases and Result Preparation Related with Loading Scripts and other deliveries related with Teradata scripts.
• Involved in gathering functional and technical requirements.
• Created Stored Procedures to transform the data and worked extensively on SQL, PL/SQL for various needs of the transformations.
• Coded complex and highly-optimized SQLs looking up at core EDW in Third Normal Form Financial Services Physical Data Model to output at denormalized data mart requirements
• Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter, Normalizer, Stored Procedure, Union etc.
• Extensively used debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Developed mappings to dynamically generate parameter files used by other mappings.
• 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 Queryman 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.

Environment: Windows XP, Oracle 9i, SQL, PL/SQL, Teradata V2R5, Informatica Power Center 7.1, TOAD 7.0.HP UNIX 5.7.8, Erwin Data Modeler.

Confidential

DW Teradata Developer

Item file is the Item Information system of Confidential Wal-Mart uses this system to maintain the information of the Items in all the stores of Wal-Mart in US and International locations. The project Involves building a data warehouse application to store Item file information for efficient reporting and extracting data from multiple data sources, transformation and loading.

Responsibilities:

• Used Informatica for ETL operations, Created Universes for various functional areas of high level reports group.
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Developed, managed and administered UNIX scripts in a production data warehouse environment including the ability to read/code K-shell scripts.
• Real-time root cause and service impact analysis capabilities to pinpoint the source of a given problem and determine its impact on all the systems.
• Establish Loading process using MLOAD, FLOAD, and BTEQ.
• Exporting Data using BTEQ and Fast Export.
• Writing Teradata SQL queries according to Process needs.
• Used Visual Explain for query Optimization.
• MVS JCL/Unix load scripts to support various data lengths for BTEQ and FAST/MULTILOAD.
• Performed tuning of Informatica Mappings, SQL for optimum performance.
• Customized BO Universes for quicker performance of reports
• Unload / load data into Teradata RDBMS using fastload/fastexport/multiload tools.
• Performance Analysis of all DW databases was done with appropriate recommendations
• Worked with Oracle, Flat File, XML files as Sources in Mapping Designer.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Created the joins strategies while designing the universes.
• Changed the universe parameter settings to optimize the performance of universe.
• Created different universes which contains the information about the customer
• Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Involved in Working with Erwin tool in Data Modeling both Physical and Logical Design .

Environment: Teradata V2R5, Informatica 6.2.1, Business Objects Supervisor, Designer, Reporter 6.1, Crystal Reports, Oracle 9i, PL/SQL, ERWIN.

Confidential

Teradata Developer

Description: It is an integrated technology and operations firm which offers end to end IT services solutions, solutions in data analytics, enterprise systems, BPO/BSP, Contact Center and Infrastructure Management Services.

Responsibilities:

• Involved in complete SDLC System Development Life Cycle .
• Exported the data into from UNIX to Mainframe for backup.
• Developed performance utilization charts, optimized and tuned SQL and designed physical databases. Assisted developers with Teradata load utilities and SQL.
• Converted batch jobs with BULKLOAD utility to TPUMP utility
• 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.
• Implemented slowly changing dimensions methodology to keep track of historical data.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
• Developed and scheduled Workflows using workflow designer, worklet designer in Workflow manager and monitored the results in Workflow monitor. Scheduled batch and sessions within Informatica using Informatica scheduler.
• Involved in unit testing of mappings, Mapplets also involved in integration testing and user acceptance testing.
• Wrote unload wrapper shell .ksh scripts to unload serial/parallel data from a flat file into Teradata database.
• 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.
• Written many of the MACROS in Teradata to generate less channel traffic and easy execution of frequently used SQL operations and improve the performance.
• Automated the routine tasks using Shell Scripts. HP-Unix Shell Scripting, Awk, Sed .

Environment: Teradata V2R5, BTeq, Mload, Fast Load, Tpump, Informatica Power Center 6.2 , DB2, UNIX, Windows NT