SUMMARY

• Around 9 years of IT experience in Programming, design, and development of Data Warehousing using Teradata, Informatica and UNIX environments for medium to large enterprise data warehouses.
• 3 years of experience on various projets in Oracle Database Adminstrator.
• Worked on different AWS Services EC2,S3, IAM, Glacir and RDS .
• Experience using Version control and Source code Management tools like GIT, Subversion (SVN) and Bit bucket on UNIX/LINUX and Windows environments.
• Around 5 years of experience on various projets in Teradata.
• Good understanding of various phases of project life cycle.
• Good knowledge on Data Warehousing concepts.
• Extracting the Data from Oracle source system and loading in to the Teradata using Informatica
• Creating the Informatica work flow for the History and Delta Loads
• Experience and conceptual knowledge in using load Teradata utilities BTEQ, FASTLOAD, MULTILOAD and TPT.
• Good knowledge on Teradata Architecture.
• Good understanding on Teradata Performance tuning measures including collecting Stats, Primary Index, Primary Partitioned Index, Join Indexes, Secondary Indexes, analyzing explain plans.
• Worked on reading COBOL files using Teradata FLOAD or MLOAD.
• Worked on reading EBCIDIC files from Mainframe.
• Strong DDL and DML writing skills as well as capable to write complex SQLs for data analysis.
• Have good experience in optimization, performance enhancement of queries and techniques for enhancing the load performance in various schemas across databases.
• Has been instrumental in analysis of long running queries and identifying root cause and saving system resources effectively.
• With the in - depth expertise in the Teradata cost-based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc.) etc.
• Through knowledge of working with DBQL tables and suggesting solutions with better optimized queries
• Experience in Teradata viewpoint to monitor the sessions and identify the high CPU utilization and skewed queries and spool usage sessions.
• Have good Experience in ETL Tool Informatica and Unix Scripting.
• Have good Experience in Autosys scheduler tool.
• Excellent problem-solving skills with strong technical background and good interpersonal skills.

TECHNICAL SKILLS

Programming Language: Java basics

Operating System: Linux 9/10, Windows XP, Unix

Version Control Tools: SVN,GIT,Bit Bucket.

Linux Tools: Shell Scripting, Vi Editor.

ETL tool: Informatica, Teradata load Utilities

Database version: 13.10, 13.0 & Oracle

Load/Unload Utilities: Bteq, Fast Load, Multiload, TPump, Fast Export, TPT

System Monitoring/Analysis: Teradata Viewpoint

PROFESSIONAL EXPERIENCE

Confidential, Wisconsin

ETL Teradata Developer

RESPONSIBILITIES:

• Worked extensively on BTEQ, UNIX Shell scripting.
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Developed the Teradata Views, Stored Procedures to load data into Worktables and then move data from worktable into Base tables.
• Reviewed the SQL for missing joins & join constraints, data format issues, miss-matched aliases, casting errors.
• Responsible for Design, Data Mapping Analysis, Mapping rules.
• Responsible for Development, Coding & testing.
• Responsible for Implementation & Post Implementation support.
• Extensively used loader utilities to load flat files into Teradata RDBMS.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created FASTLOAD to transfer the data SQL Server to Teradata.
• Collected statistics periodically on tables to improve system performance.
• Performed tuning and optimization of application SQL using Query analyzing tools.

Environment: Teradata, Unix, Oracle, SQL Server.

Confidential

ETL Developer

Responsibilities:

• Has involved in stored procedure conversion, history data migration of tables & stored procedure testing
• Job scheduling of the nodes associated to the stored procedures in the Event engine
• Resolved complex stored procedure issues like Spool space issue, Target row updated by multiple source rows error etc. and also guided the team for debugging errors so that stored procedures can be deployed on time
• Gained thorough exposure to MDF (file load) framework which was suggested as a replacement in Teradata for all the direct file load Sybase stored procedures by the client.
• Worked extensively on BTEQ, UNIX Shell scripting.
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Developed the Teradata Views, Stored Procedures to load data into Worktables and then move data from worktable into Base tables.
• Reviewed the SQL for missing joins & join constraints, data format issues, miss-matched aliases, casting errors.
• Responsible for Design, Data Mapping Analysis, Mapping rules.
• Responsible for Development, Coding & testing.
• Responsible for Implementation & Post Implementation support.
• Extensively used loader utilities to load flat files into Teradata RDBMS.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created FASTLOAD to transfer the data SQL Server to Teradata.
• Collected statistics periodically on tables to improve system performance.
• Performed tuning and optimization of application SQL using Query analyzing tools.

Environment: Teradata, Unix, Sybase

Confidential

Database Administrator

Responsibilities:

• Daily Monitoring of all servers and generating weekly/monthly reports accordingly
• Applied Patching Oracle 12c (12.1.0.1.0 ) database to 12.1.0.1.5 on standalone Server
• Active participation in DB reboot activities which are part of monthly schedule or for patching of Windows Servers
• Handling user management and Security Management requests which include creating, dropping, changing passwords and assigning a user with different roles, privileges and profiles.
• Working with traditional and data pump utility for the selective data export and import on production/test/dev on client/online team request basis. Creating directories, granting permissions and performing imp/exp accordingly
• Generating performance reports like STATSPACK/AWR
• Database troubleshooting for general issues (DB Connectivity, Disk Spaces, Alert log & trace file management, DB locks, cursor issues, undo tablespace issues and temporary tablespace issues)
• Cloning the Oracle Databases from Production to Development servers.
• Performing Logical backups using Export and Expdp Utilities.
• Performing daily incremental backups, weekly backups using RMAN.
• Schema, Table, Database refreshes on demand for dev teams
• Cloning the databases from Production to Test environment using Hot/cold/export/RMAN backups.
• User creation and providing necessary Roles, Privileges and quota as per the requirement.
• Monitoring the Table spaces and adding/resizing datafiles.
• Generating AWR reports to monitor database health.