We provide IT Staff Augmentation Services!

Sr. Teradata Consultant (elt) Teradata Architect Resume

UsA

Professional Experience Summary:

  • 11+ years IT experience in implementing Enterprise Data Warehousing and ETL methodologies. Experienced in full software development lifecycle which includes project planning, requirement analysis, documenting, design, development, unit and integration testing.
  • Extensive experience translating business requirements into conceptual, logical, physical data models. Used forward and reverse engineering techniques for building physical data model .Well-versed with ER & Dimension modeling.
  • Architect the ETL, ELT process and database standards and created source to target mapping documents for Development team.
  • Extensive Experience on Teradata V2R5 to V14 in using Fast Load, Fast Export, TPT, TPump, Multi Load and BTEQ to load/extract data into Teradata warehouse. Well versed with Teradata Manager Suite & Teradata Analytical Suite, Performance Monitoring (PMON) & View Point, Statistics and Alert management. Worked on Teradata Virtual APP Node servers.
  • Extensive Experience in database design (Teradata, Oracle and SQL Server). Strong understanding of Star and Snowflake schemas. Extensive experience in creating database objects, including Triggers, Cursors, Stored Procedures and Materialized Views etc.
  • Experience in Teradata upgrade planning, analysis and pre and post validation.
  • Extensive experience in writing UNIX Shell Scripts, JCL (Mainframe), Windows batch scripts and Control M for job scheduling.
  • Experience in developing data maps to communicate with third party source systems. Worked in Retail, Insurance, Marketing, Travel, Hospitality, Utility Energy and Government (Judicial).
  • Experience in debugging and performance tuning of targets, sources, mappings and sessions.
  • Excellent interpersonal communication Skills and technical documentation skills.
  • Worked in Onsite-Offshore model, Knowledge transfer, Communicate time lines, progress, delays etc back and forth from the team to the client and vice versa
  • Ability to be an effective team player and work under time constraints.
  • Batch optimization and automation (Unix/Mainframe/Windows batch)
Technical Skills Summary:

Data Bases Teradata V2R5 – V14, Oracle 8i/9i/10G, SQL Server.
Data Warehousing Informatica Power Mart 4.7/5.0, Power Center 5.1/6.2/7.1
Programming SQL, PL/SQL, Teradata SQL
Data modeling Tools Erwin, Visio
Database Utilities SQL Assistant, Teradata Parallel Transporter, TOAD, MLoad, Fast load,
SQL*PLUS, SQL*LOADER, Bteq, TPump, Teradata Manager Suite, Teradata
Analytical Suite, Teradata Warehouse Miner
Environment MS Windows NT 4.0/ 2000/XP/7, UNIX, Linux, Mainframe.
Scripting Unix Shell scripting, JCL, Windows Batch
Scheduling Tool ControlM, MLoad, AutoSys
Version Control PVCS Version Manager, CCF (Mainframe)
Testing Tools Test Director 7.0/8.0,Quality Center

Confidential, USA
Sr. Teradata Consultant (ELT) Teradata Architect
Environment Teradata 14, ANSI/Teradata SQL, UNIX, Linux, Visio, Teradata Tools and Utilities (TPT, MLoad, FLoad, Fexport, and TPump).

Confidential is a central repository for court data, accessible by approved state and local employees. Approved staff can obtain court history for individuals and also access several reports. One reporting module is a result of a joint effort between the Confidential and the Department of Human Services that tracks court performance in abuse and neglect cases. Reporting module provides reports to courts who submit data to the Confidential. These reports assist courts with case and docket management as well as collections and are strongly rooted in the data sharing agreements the Confidential has with the Michigan Department of Corrections and the Michigan Department of Community Health.
Roles & Responsibilities:
  • Design, development and testing of the ELT/ETL Process for loading the Judicial Data warehouse from various source systems using Teradata tools and utilities (TPT, MLoad, FLoad, Fexport, and TPump).
  • The batch execution process was developed & improved to execute UNIX shell scripts using Teradata utilities in an automated fashion, with built-in logging and reporting. This process has been ported to Linux and customized for use with the JDW project. Worked on Teradata virtual APP Node servers.
  • Implemented data in transit data encryption methodologies for ELT process on Unix/Linux/ Windows.
  • Monitor the database activity throughout the day in View point and act accordingly to throttle the load and monitor business users query load.
  • Providing the Solutions for the more critical Teradata performance issues or design issues performing the design reviews in order to ensure that the Platform standards are followed regularly, Come up with best practices and document the process.
  • Implementing security rule’s for accessing data from judicial data warehouse based on their profile and access granted.
  • Documenting the standards for security areas such as best practices role creations for the end users
  • Complex views were created using to join five or more tables implementing various design specifications, complying with the business requirements for auditing purpose.
  • Redesign and modification to existing ELT/ETL Process. Creating process flow diagrams.
  • Creating low level and high level design documentation for the development and business reviews.
  • Creating System maintenance technical documents for data warehouse maintenance. Created Data warehouse audit documents for office of the auditor general office auditing.
  • Perform support/application DBA activities like creating roles & profiles for users. Create, unlock user accounts manage database space.
  • Actively involved in communication with various vendors at courts to get daily, weekly incremental/full refresh files. Facilitate communication upward and across project teams
  • Interact and work directly with customer team members on projects and support issues.
  • Follow change management and problem management processes.
Confidential
Teradata Architect
Environment Teradata 13, ANSI/Teradata SQL, Teradata XML services, PL/SQL, Oracle 9i/10G, UNIX, Windows XP Prof, Mainframe
Confidential is the product of more than a century of providing reliable electric service to central, coastal and southern California. On an average day SCE provides power to nearly 14 million people, 180 cities in 50000 square miles of service area, encompassing 11 counties in central, coastal and Southern California.
Roles & Responsibilities:
  • Involved in analyzing customer’s business requirements (CCBD) and translated to technical requirements and architect the ELT solution by providing logical and Physical data model and had taken the lead in implementing the solution with the development team.
  • Implemented complex logic algorithm using Teradata OLAP function’s to perform online rate change application, proactive analysis for customers. Calculations were based on the customer past one year history, season, weekday, weekend, holidays and taxes will be projected as next year forecast.
  • Design, Development, Implementation ETL process to support CDC- Change Data Capture using Teradata TTU (TPT, MLoad, FLoad, Fexport).
  • Implemented auto balance and data reconciliation measures during data receipt, stage load and production load process.
  • Conducted webinar sessions for offshore/onsite team for Teradata-XML services training. Presented white papers to knowledge portals.
  • Created nested parameterized stored procedures and macros to support online applications and ETL batch process.
  • Extracted data from Teradata in the form of XML by using XML Publishing methodology and Loaded XML files to Teradata using XML Shredding methodology. Assisted DBA panel for Teradata XML Services installation.
  • Implemented change control and version control mythologies for development project.
  • Actively involved in Source system study, Infrastructure recommendation. Involved in estimation, preparation of SOW, Project Plan for the projects. Tracking of project plan dates and working aggressively to meet SLA's.
  • Involved in the active communication and interaction with the off shore support team during the Development, Production implementation phase of the project.
  • Spearheaded the core team development & delivery of projects with track record of on-time, on-budget measures improving capex ROI.
  • Involved in setting up of Development Center of excellence valued $1.5+ Million initiative for the ORCAT Project.
  • Worked in Onsite-Offshore model- Development, Testing , Implementation Knowledge transfer, Communicate time lines, progress, status reports, delays etc back and forth from the team to the client and vice versa
Confidential
Lead ETL/Teradata – (Teradata Architect)
Environment TeradataV2R6/12, ANSI/Teradata SQL, PL/SQL, Oracle 9i/10G, UNIX, Windows XP Prof, Mainframe
Confidential is a leading multi-brand specialty apparel retailer primarily focused on plus-size women's apparel. We are the parent company of four distinct store brands – Lane Bryant, Fashion Bug, Catherine’s Plus Sizes and Petite Sophisticate Outlet.
Development Projects:
  • Allocations Quick wins.
  • Trident Project Phase 1,1A,1B & 2
  • Omniture Data Load – Phase 1 & 2
  • CTS Fry Integration – Phase 1 ,2A & 2B
  • Ecomm D2C Support.
  • Channel Code.
  • Email Hygiene.
  • SWAT Project 1 & 3
  • UNICA Purge Process
Roles & Responsibilities:
  • Architecting & implementing enterprise marketing segment projects for the CRM tool and real time customer data marts
  • Created logical & physical data model to support the Teradata active data warehouse application. Build process to support active data warehouse between brick n motor stores to customer database. Implemented customer coded coupons process in Teradata using .net application. Create Macros, Join Index to support 2000 Transaction per Minute.
  • Created data model, implemented ELT process and reporting views to support day to day web analytics application.
  • Involved in analyzing customer’s business requirements (CCBD) and translated to technical requirements/Detail Design and architect the ELT solution by providing logical and Physical data model and had taken the lead in implementing the solution with the development team.
  • Design & Implementation ETL & ELT process to support JDA Allocation. ETL source data (Teradata) to Target (Oracle) & Vice Versa using Teradata Load Utilities. Fast Load, Fast Export, TPT, TPump, MultiLoad.
  • Submitted a transformation proposal valued $500K involving conversions/migration of data from legacy applications.
  • Created Generic SFTP scripts to transmit the files from Server to Server and load the files to database.
  • Design & Development of Converting Relation Data to XML on Windows, Mainframe, UNIX. Extracted data from Teradata in the form of XML by using XML Publishing methodology and Loaded XML files to Teradata using XML Shredding methodology.
  • Used Teradata PMON/View point to monitor jobs running on the system and the EXPLAIN steps used in the execution of the SQL queries. Also, it is used to find out the CPU resource allocation for various users on the system. Performance tuning for Teradata SQL statements using Teradata EXPLAIN plan.
  • Wrote JCL’s/Shell Scripts/windows batch scripts for Batch Process.
  • Worked in Onsite-Offshore model, Development, Testing , Implementation Knowledge transfer, Communicate time lines, progress, status reports, delays etc back and forth from the team to the client and vice versa.
Confidential
ETL/Teradata – Sr. Consultant
Environment: Teradata V2R5, ANSI/Teradata SQL, PL/SQL, UNIX, Windows XP Prof, Mainframe
Confidential is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments. The Nationwide Insurance Data Warehouse (NIDW) is the source for FIMS and FOCUS Extracts. The NIDW currently provides extracts to FIMS for some of their statutory and management reports.
Development Projects
  • Associate Discount
  • BDE Billing Data Expansion
  • Billing History Updates
  • Billing- Unknown Codes
  • Florida Mitigation Kentucky Municipality Tax
  • PIRL/AOL
  • Unix to Mainframe Migration
  • Pricing Extracts Unix to Mainframe Migration
  • Property FLAT- Florida Agent Transition(Property & AUTO) Billing VAT process production implementation
  • New Interface Integrity Pricing Extracts 2008 year.
CPE Support Projects
  • AUTO FIMS/FOUCS Daily-Monthly Flow Claims FIMS/FOUCS Daily-Monthly Flow Billing Advantage Weekly Flow Property Incremental Daily-Monthly Flow Property
  • FIMS/FOUCS Daily-Monthly Flow Pricing Extracts Property/AUTO STD
Roles & Responsibilities:
  • Design & Developed the ETL Process for Pricing Application. Developed batch process for Teradata ETL and integrated with the Lotus Notes to drive the pricing extracts to the support BI Team. Developed process to handle Kentucky Municipal tax for existing Insurance holders.
  • Involved in the active communication and interaction with the off shore support team during the Production implementation phase of the project.
  • Complex views were created to join five or more tables implementing various design specifications, complying with the business requirements.
  • Performance tuning for Teradata SQL statements using Teradata EXPLAIN plan.
  • Created proper Primary Index (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
  • Used Teradata PMON to monitor jobs running on the system and the EXPLAIN steps used in the execution of the SQL queries, also used to find out the CPU resource allocation for various users on the system.
  • Developed ETL Process using BTEQ/FLOAD/MLOAD/FEXPORT for building the Billing Application, BDE Billing Data Expansion, and Associate Discount.
  • Migrated FIMS/FOCUS ETL Batch process from UNIX to Mainframe.
  • Help DBA’s to compress and do a clean up DW to clean up more space.
  • Wrote Shell scripts to automate processes to perform DML operations on Target tables.
  • Worked in Onsite-Offshore model, Development, Testing , Implementation Knowledge transfer, Communicate time lines, progress, status reports, delays etc back and forth from the team to the client and vice versa
Confidential
ETL/Teradata developer
Environment Informatica Power Center 6.2/7.1.1, TeradataV2R5, ANSI/Teradata SQL, PL/SQL, Oracle 9i/10G, UNIX, Windows XP Prof.
Confidential is a global leader in the Marketing, Travel, and Hospitality industries. The current project Customer Centricity focuses on integrating data from various source systems like Oracle, XML files Flat Files, Teradata etc into one single Enterprise Data warehouse (EDW) to provide a single source of data for various independent operational units with in the company. The data available in the Confidential is used by these various operational units to develop reports and build triggers to generate the needed campaign information.

Roles & Responsibilities:
  • Extracted data from various Source Systems like Oracle, Teradata, XML Files and Flat Files as per the requirements.
  • Involved in the active communication and interaction with the off shore support team during the Production implementation phase of the project.
  • Developed various Mappings and Workflows as required by the Design specifications.
  • Used various transformations like Expression, Lookup, Joiner, Router, Filter, Normalizer etc. to perform the process of Extract, Load and Transform effectively in the Mapping Designer.
  • Created various tables and views used as sources and target tables in the Informatica Mappings.
  • Performance tuning for Teradata SQL statements using Teradata EXPLAIN plan.
  • Created proper Primary Index (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
  • Used Teradata PMON to monitor jobs running on the system and the EXPLAIN steps used in the execution of the SQL queries. Also, it is used to find out the CPU resource allocation for various users on the system.
  • Wrote numerous BTEQ scripts to run complex queries on the Teradata Database directly rather than implementing the same in Informatica, to reduce the time it takes for successful execution.
  • Wrote Shell scripts to automate processes to perform DML operations on Target tables.
Confidential
Sr. Software Engineer
Environment Oracle 8i, SQL Plus, SQL loaded, UNIX, Windows NT
Confidential IT Solutions is an information technology consulting company. Mainly involved in teaching and also service offerings are focused in five core areas of competency: New Technology Development, Software Applications, Database Development, Content Services and IT Consulting.
Roles & Responsibilities:
  • Design, Develop & Implement ELT process Source to Target using SQL Plus and SQL loader.
  • Created logical, physical data model and mapping documents for the application.
  • Wrote Shell scripts to automate processes to perform DML operations on Target tables
  • Atomized FTP process between the client and vendor servers.
  • Developing Oracle PL/SQL stored procedures, Packages, SQL scripts to facilitate the functionality for various modules.
  • Prepared test plans for System and User acceptance test.
Confidential
Environment Lab View 7.0, VBScript, SQL Server 2000, Oracle 8g, Windows 2000,NT,GPIB, Teradata V2R5 , Jandel Four Point Probe,220 Programmable Current Source, Fluke 45.
Confidential are playing important role in the Display field. The purpose of this programming work is to construct an automatic setup of four point probe measurements through Lab VIEW programming and build Enterprise data base (EDD) to allow scientists, research students and master’s students for taking resistance measurements analysis for sheet and glass substrates.
Roles & Responsibilities:
  • Integrated the Setup Using GPIB, Lab View and Database. By creating the Macros to perform DML Operation on Database.
  • Developed Scripts for scheduling Database backups on a daily basis Performed checks to manage the physical storage and resized the Database files for optimization
  • Build Pro Type Teradata database for the maintaining the Substitute and Liquid crystal information. Windows based database as POC.
  • Created Macros and established ODBC connectivity to perform DML operations.
  • Analysis of the specifications provided by the client.
  • Developed reusable and user compatible Virtual Instruments (VI).
  • Coding using Lab View Programming. Designing VI’s using Lab View.
  • Responsible for overseeing the Quality procedures related to the project.
  • Designed and development of database using MS SQL server 2000
Confidential
Project Engineer
Environment : AutoCAD, UNIX, Windows XP, Oracle 8
Confidential is a multinational financial services company headquartered in London, United Kingdom with operations in more than seventy countries. It operates a network of over 1,700 branches and outlets (including subsidiaries, associates and joint ventures).
Roles & Responsibilities:
  • Helped in cost estimating, project technical supervision, quality assurance, materials selection, approval procurement, transition planning, and project close out documentation.
  • Assisted in development and execution of SCGB Data center projects with emphasis on integrated design.
  • Utilized computer-aided design “CAD” programs to design prototype tooling for research and development of new schematic designs.
  • Build batch jobs to perform DML operation on the database for Vendor and product details.
  • Build FTP Process between Vendor and Client Servers.

Hire Now