SUMMARY:

• 14 years of IT experience and 9 years working on Teradata, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines. Led and participated in various projects covering all phases of SDLC. Involved all phases of SDLC like system analysis, application design, development, testing and implementation of data warehouse and non - data warehouse projects
• Skilled in large-scale multi-terabyte initial database load and ongoing update techniques, backup and recovery requirements, SQL, etc.
• Consult with database ETL developers providing guidance on Teradata DDL & DML best practices, Teradata Database administration including database-design, tuning, backup, software maintenance, hardware upgrades, and application support of databases.
• Expertise in Migration of Environments from Development, System Integration Testing, UAT, Production. Expertise in Data Warehousing, Data Mart, Data Analysis, Query Optimization, Performance Tuning.
• Experienced in load and unload tools like FastLoad, BTEQ, MultiLoad, TPump, TPT and FastExport.
• Hands-on experience in query and database management tools like TDQM, Teradata Manager, Queryman, Visual Explain, Stored procedures and Performance Monitor.
• Thorough grasp of Teradata RDBMS Architecture and data warehouse concepts.
• Experience working with Agile and scrum Methodologies.
• Experienced on logical - Physical data models conversions, Fine tuning (Performance tuning) the complex queries and views. Extensive experience in data modeling, data warehousing, ETL, and data administration as IT consultant, excellent skills in SQL coding and UNIX shell scripting.
• Involved in creating adhoc reports for the business using Tableau, Excel reporting and have good experience working with VBA programming and MS Access database.
• Extensive experience working with Data Analytics related to Campaigns, promotions, issuances, Loyalty programs, customers email and Sales data.
• Experience working with Teradata Temporal features.
• Ability to work individually as well as in a team with excellent problem solving and trouble-shooting capabilities.
• Experience working in Hadoop environment and involved in creating sqoop scripts to extract the data from the source tables.
• Experience working with scheduler tools like Control M, Event Coordinator, Autosys and UC4.
• Self-motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts and environments

TECHNICAL SKILLS:

Software: Teradata, SQL,SAP-ABAP, Java, VB6

Scheduling Tools: Control-M, Event Coordinator, auto sys

Operating Systems: Unix, Hadoop, Windows

Databases: TERADATA V14, V13, Oracle 8i, MS-ACCESS

Teradata Tools & Utilities: Fast Load, Multi Load, Fast Export, BTEQ, TPump, SQL Assistant, Teradata Manager, Statistics Wizard, Teradata Administrator, Teradata Index Wizard, Erwin, SQL Assistant

CAD: Unigraphics, CATIA, Solid Works, Solid Edge

Languages: C, C++, Java, SAP-ABAP, SAP-BI, SAP-BW, Unix shell scripting

ERP and Markup Languages: SAP-ABAP, BDC, LSMW, ALE/IDOC, ALV, HTML, DHTML,CSS

Others: MS Office, Microsoft Visio, PL/SQL, Shell scripting, Tableau, Power Designer, Erwin, Hadoop

PROFESSIONAL SUMMARY:

Confidential, Chicago, IL

Sr. Teradata Developer and Data Architect

Responsibilities:

• Provide code tuning guidelines to development & project teams and coordinate the resolution of performance issues as needed
• Creation & Analysis of Functional/Technical Specification Documents
• Worked on scheduling daily, weekly, monthly jobs and setting up the sequence using Control M scheduling tool.
• Design & Implementation of Data Extraction, Transformation & Loading
• Developed SQL, Ad Hoc queries to fulfill business analyst requirements.
• Involved in creating adhoc reports to the business using Excel and Tableau.
• Created Fast Load, Fast Export, Multi Load, Tpump, BTEQ scripts.
• Involved in migrating TI Mart to new Offer performance data mart with revised design for better performance and to meet the new business needs
• Involved usage analysis of tables and deleted unwanted tables as a part of migration and cleanup activities.
• Created daily Database space usage report for all Enterprise applications.
• Involved in creating the DataMart’s and loaded the Campaign, Promotion and Loyalty member related data into DataMart’s for the business use.
• Developed FastLoad and BTEQ scripts to load the coupon/promotion related Issuances, Redemption and POS data into Teradata Database and helped in creating Microstrategy and Tableau reports to see how the each offer is performing.
• Created UNIX shell script to automate the Full refresh data load process.

Environment: Teradata 13.10, Tools & Utilities(BTEQ, Fast Export, Multi Load, Fast load, Teradata SQL Assistant, Teradata Manager and Teradata Performance Monitor), Control-M, VBA, Hadoop, Windows and Unix.

Sr Teradata / Semantic Developer

Responsibilities:

• Worked extensively on the Temporal feature of Teradata 14
• Worked on Retail Party data model environment.
• Involved in performance tuning of existing semantic views and CDW ETL processing.
• Resolved issues related to semantic layer or reporting layer.
• Worked on different subject areas like Sales, Customer, Loyalty, Promotion and Item
• Responsible to extract the CDW sales data and send it to third party vendors for Loyalty Point Calculation
• Worked with loyalty vendors like Comarch and AIMIA for rewards calculations and maintenance.
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Expertise in writing scripts to extract data through IBM sterling Integrator into Data Warehouse using BTEQ, FastLoad
• Developed and modified UNIX shell scripts as part of the ETL process.

Environment: Teradata 14, Teradata SQL, Tools & Utilities (BTEQ, Fast Export, Multi Load, Fast load, TPT, UNIX, UC4/Appworx.

Sr. Teradata Developer and Data Analyst.

Responsibilities:

• Involved in meetings to gather requirements from the Business Analyst
• Following the AGILE methodology for SDLC. Involved in Sprint Planning, Scrums and Retrospective meetings
• Understand the specification and analyzed data according to business requirements.
• Unix Scripts were written for file manipulations, archival and FTP process.
• Involved in data migration of online data from SQL server to Hadoop environment using Sqoop statements
• Scheduled the jobs in control M for daily, weekly and semiannual jobs.
• Involved in design development of demographics buyer and non buyer data into CDI data base
• Created the bteq scripts for processing the Acxiom InfoBase data into CDI data ware house tables.
• Involved in anlysing the old 2007 system and redesign according to the new business requirement.
• Involved in mapping the old view with the new CDI tables,so that business can use the same views.
• Data conversion was done using Teradata Utilities, SQL and UNIX shell script and load them into Teradata tables.
• Involve in the co-ordination with different groups to fulfill dependencies
• Created datastage jobs to move the data from Teradata 12 to Teradata 14.

Environment: Teradata 13.10, Teradata SQL, Tools & Utilities(BTEQ, Fast Export, Multi Load, Fast load, Teradata SQL Assistant, Teradata Manager and Teradata Performance Monitor), Control-M, Hadoop, Windows and Unix.

Campaign Management Support

Responsibilities:

• Involved in creating bteq scripts to load the online browse data into CDW database and created export script to send the data to third party vendors,
• Provide 24 7 production database troubleshooting support for Omniture Load and Campaign management process.
• Responsible in scheduling the jobs in Control-M for all campaign management project activities.
• Worked closely with the third party vendor epsilon and SPC for campaign management support
• Created daily, weekly and monthly feed to Epsilon for sears and Kmart campaigns
• Created export scripts to send the Sales transaction details, POS (Point of sales data) to epsilon on daily basis.
• Responsible to develop weekly audit comparison report to track the counts on epsilon side and Sears’s holdings database.
• Involved in developing many fast export scripts to send the Email triggered data to epsilon.
• Developed a shell script to automate the process from downloading the file from FTP to loading the data into Teradata using scripts.
• Created Unix Shell script to process the Member balance data to from Epsilon Unix and sent to Epsilon Loyalty team.
• Created the Load scripts to load the Omni order data into CDW.

Environment: Teradata 13.10, Teradata SQL, Tools & Utilities(BTEQ, Fast Export, Multi Load, Fast load, Teradata SQL Assistant, Teradata Manager and Teradata Performance Monitor), Control-M, Hadoop, Windows and Unix.

Triggered Email processing and Omniture

Responsibilities:

• Developed a shell script to automate the process from downloading file from FTP to loading the data into Teradata using scripts.
• Involved in architecting the data flow and development of scripts
• Developed scripts to load high volume of Omniture data into empty tables using FastLoad utility.
• Developed a BTEQ to calculate the online purchase orders for Sears, Kmart, Kenmore, craftsman online data by applying the transformation rules.
• Own the responsibility to transform historical CRM database data into LCI CDW tables.
• Applied the sound performance techniques to increase the efficiency of the Teradata scripts.
• Created a stored procedure to capture the online purchase orders using Omniture page url data.
• Involved in developing the Product hierarchy Xref data into Teradata database.
• Involved in tuning up the performance of existing scripts.

Environment: Teradata 13.10, Teradata SQL, Tools & Utilities(BTEQ, Fast Export, Multi Load, Fast load, Teradata SQL Assistant, Teradata Manager and Teradata Performance Monitor), Control-M, Hadoop, Windows and Unix.

CampaignMart Support

Responsibilities:

• Design & Implementation of Data Extraction, Transformation & Loading
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Used FastExport utility to extract large volumes of data at high speed from Teradata RDBMS.
• Created stored procedures, macros, triggers, views, tables and other database objects.
• Modified MVS JCL load scripts to support various data lengths for BTEQ and FASTLOAD.
• Shell scripts that invoke BTEQ scripts that load the Fact tables and the dimension tables.
• We use soft referential integrity, which is done by BTEQ scripts.
• Work with the Cognos team for any changes to the reporting layer.
• The data from the 3NF is loaded to the Fact tables on a daily basis. Views are created on fact and dimension tables to be used in reporting, which is done by COGNOS.
• Provide 24x7 on call production support on a rotation basis
• Developed SQL, Ad Hoc queries to fulfill business analyst requirements.

Programmer Analyst

Responsibilities:

• Involved in meetings to gather information and requirements from the clients.
• Developed DSIDS (Delphi Supplier Identification System) interface for Vendor creation and Vendor maintenance using ALE and IDOC
• Developed a Module pool interface for matching the vendors for divestiture business.
• Developed a Function module for populating the custom fields of vendor master data and also for inserting these segment data in receiver side.
• Developed a reusable custom includes for the steering project with common functionality for all extraction and BDC upload programs.
• Analyzing the Functional Inputs and estimating the time required to complete that specification.
• Worked extensively on the modules SD, MM, and FI/CO.
• Developed custom report for sending the work orders through custom IDOC.
• Developed a program to download the divestiture vendors search item for matching vendors to the specified business.

Environment: SAP-ABAP, SAP-MM, SAP-SD, SAP-BW,IDOC, FI/CO, ECC 4.7, ECC 6

Sr. Teradata developer

Responsibilities:

• Responsible for Analysis and mappings between the SOR fields and the target table fields.
• Responsible for Design, creating design documents, Data Mapping Analysis, Mapping rules
• Responsible for Development, Coding & testing
• Responsible for Implementation & Post Implementation support
• Establish Loading process using MLOAD, FLOAD, BTEQ
• Exporting Data using BTEQ and Fast Export.
• Writing BTEQ Scripts for uploading data.
• Writing UNIX shell scripts for automating Data Load process files.
• Writing Teradata SQL queries according to Process needs.
• Establish backup jobs, review procedures for backing up and review frequencies for backing up DBC using NetVault.
• Design and Document monitoring processes of production databases.
• Provide 24 7 production database troubleshooting support.
• Implementing adhoc techniques to achieve business needs.
• Assisted another Teradata DBA to bring the system in production.

Confidential, GE

Responsibilities:

• Interact with business users and create a design concept for various automotive parts for transportation.
• Automation of Feed Water Heater Design Using KBE, UG Nx3, HTML and JSP.
• Automation of Rotor Coil Design using KBE and UG for Toshiba Japan.
• Online Examination for QuEST HR Recruitment cell using VB and MS Access.
• Modeling and detailing of Turbine rotor, blade using Unigraphics for GE

Environment: VB6, JAVA, JSP, Unigraphics (CAD), KBE and HTML.