SUMMARY

• Confidential TEMPhas over 7 years of experience in IT industry. He specializes in Teradata development and Database administration. He is proficient in design and development of Data warehousing ETL and BI applications using Teradata, IBM Data stage and UNIX.
• He is proficient in data warehouse development practices and processes. He is conversant wif Software Development Life cycle and SEI - CMMI level 5 Quality Processes while executing projects.
• He TEMPhas over 6+ years of experience on Teradata database design & development.
• He TEMPhas experience in Teradata DBA into different activities includes performance tuning, Netback up TARA GUI, Net vault, ARC utility for Backups/Restores, Good exposure in using TTU tools and utilities, Viewpoint, PMON, Teradata Manager for system monitoring and have an experience in handling Teradata database .
• He is well versed in dimensional modeling (BI/ Data Warehouse). He TEMPhas knowledge of different Schemas 3NF, (Star and Snow Flake) to fit reporting, query and business analysis requirements. He also TEMPhas a good understanding of Financial Services logical Data Model Teradata (FSLDM).Teradata Development Experience:
• He TEMPhas over 6+ years of experience on Teradata database design & development.
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using dimension modelling wif Teradata.
• Expertise in working wif Teradata systems and used utilities like MultiLoad, FastLoad, Fast Export, BTEQ, TPump, TPT,ARC and Teradata SQL.
• Experienced in building Data marts, data warehouses, data archives and data analysis.
• Advanced SQL skills, including use of derived/Volatile/GTT tables, unions, multi-table inner/outer joins.
• Monitoring bad queries, aborting bad queries using View point Query monitor, looking for blocked sessions and working wif development teams to resolve blocked sessions.
• Analyzing sessions wif for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Tuning bad queries by analyzing explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases.
• Ability to work independently and as a team and able to TEMPeffectively communicate wif customers, peers and management at all levels in and outside teh organization.
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Experienced in UNIX shell scripts/JCL Programs to write wrapper scripts to call ETL/BTEQ Jobs.

TECHNICAL SKILLS:

Teradata tools & Utilities Query facilities: SQL Assistant, Teradata Administaror,BTEQ, PMON, View point, Data mover, Unity & TARA GUI

Database: Teradata 13.0/14.10,Oracle(9i/10g),SQL Server,DB2

ETL / SAS: IBM Datstage8.5, Informatica 9.6, SAS 9.3, Base SAS,SAS/Macros.

Load & Export: FastLoad, MultiLoad, Fast Export, BTEQ, TPump, TPT, ARC

Scheduler: AutoSys

Modeling tool: Erwin, Visio

Operating Systems: Windows XP, 2000,UNIX/Linux, Mainframes (MVS)

Scripting languages: UNIX Shell, JCL

PROFESSIONAL EXPERIENCE:

Confidential

Consultant

Responsibilities:

• Provide technical leadership through Informatica Power Center ETL design & development for ODS and Enterprise Data Warehouse
• Provide recommendations for re-usable design patterns
• Provide input & vision to ETL development standards and guidelines
• Demonstrate a positive attitude and team focus
• Share knowledge and expertise wif team
• Provide senior level consulting and advisory services to clients as subject matter expert for Informatica Power Center ETL and team delivery
• Provide analysis and recommendations for ETL implementation

Confidential

Analyst

Responsibilities:

• Involved in end-to-end software development life cycle ranging from Data Requirement Analysis, Data Modeling, Data Architecture and implementation.
• Initiated and coordinated teh analysis and design requirements for data marts including schema and ETL scripts.
• Prepare teh Detail Design, Implementation plan and other documents viz Test plans, test cases etc
• Coding teh BTEQ IMPORT, Fast load & Multi Load utility scripts in UNIX for data loading.
• Coding Teradata stored procedures and SAS scripts for extracting data
• Monitoring bad queries, aborting bad queries using View point Query monitor, looking for blocked sessions and working wif development teams to resolve blocked sessions.
• Involved in Teradata database administration activities like monitoring, performance tuning, troubleshooting, maintenance, backup, archive and recovery (BAR).
• Analyzing sessions wif for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Tuning bad queries by analyzing explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases
• Extensively worked wif DBQL data to identify high usage tables and columns.
• Monitoring of all systems using Viewpoint and addressing teh issues wif application teams
• Code reviews and implementation.
• Scheduling jobs on Autosys.
• Unit Testing and System Testing
• Adherence to prescribed Quality procedures

Environment: Teradata 14.10, Teradata SQL, Unix, Hadoop, DB2, Oracle, SQL server, BTEQ, Fast load, TPump, Multiload, TPT, View point, Unity, Data mover, Mainframes, Autosys.

Confidential

Technical Lead - Teradata Development

Responsibilities:

• Involved in End-to-End software development life cycle ranging from Requirements verification, preparing Detail Design documents
• Reviewing teh Design and Other documents viz Test plans, test cases etc.,
• Executing teh System/Integration/UAT Testing
• Coding teh BTEQ IMPORT, Fast load & Multi Load utility scripts in Mainframes, UNIX.
• Code reviews and implementation.
• Unit Testing and System Testing
• Scheduling jobs on Autosys.
• Adherence to prescribed Quality procedures.

Environment: Teradata 12.0, JCL, Teradata SQL, UNIX, DB2, BTEQ, Fast load, Tpump, Multiload, ARCMAIN and MVS

Confidential

ETL Developer

Responsibilities:

• Developed various jobs using most of teh stages using in Data Stage for migration of data from DB2 and Flat File sources.
• Experience in data profile analysis and Master data management activities wif IBM MDM,IIS tools.
• Experience in data lineage activities wif IBM IIS tools like quality stage and profile stage.
• Developed wrapper stages in Data stage 8.5
• Developed Sequencers for scheduling data stage jobs.
• Developed Data Stage Jobs using sequential file, Transformer, Dataset, Join and Teradata multi load and Teradata Enterprise stages.
• ETL implementations wif tolls like IBM datastage.
• Developed shared containers and used them in Jobs.
• Developed jobs to extract files from SAP/BW and load into Data Warehouse Environments.
• Developed BTEQ scripts which load teh data from Landing to Stage area.
• Developed UNIX wrapper scripts which call internally BTEQ.
• Developed Technical Specification for new/CR applications.
• Created teh mapping document for new applications and for CR’s (Change Request).
• Updated deployment template/guide for code promotion to QA.
• Jobs are executed from UNIX wrapper scripts which are scheduled in TWS (Tivoli Work Load System) and are managed by IPM (Inter Process Management).
• Developed UNIX shell script for automation of code to version control tool.
• Monitoring autosys to make sure every job meeting SLA.

Environment: Teradata 13.0, JCL, Teradata SQL, Oracle, DB2, BTEQ, Fast load, Tpump, Multiload, ARCMAIN, PMON and MVS