SUMMARY

• Over 11+ years of IT experience as Teradata developer and Data warehousing
• Experience in cloud warehouse Snowflake, AWS S3, AWS EC2, AWS EMR
• Experience in various database DB2, Oracle, Sybase and Teradata
• Certified Scrum Master, experience in Agile methodology
• Active involvement in different phases of Software development life cycle (SDLC) such as gathering Business Requirement, System Analysis, Design & profiling, Proof of Concept, Development, Unit Testing, UAT, Deployment, User Training & Support.
• Expert Developer skills in Teradata RDBMS, initial environment setup and development.
• Good knowledge in Teradata Architecture
• Hands on experience in Teradata SQL, Tools & Utilities (FastExport, MultiLoad, FastLoad, Tpump, BTEQ, SQL Assistant and Teradata viewpoint).
• Experience in writing Teradata/DB2 stored procedures
• Expertise in Query Analyzing, performance tuning and testing.
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Experience in Mainframes JCL to support Teradata SQL process
• Good knowledge in Informatica
• Exceptional skills in writing complex SQL and PL involving multiple tables, constraints and relationships for efficient data retrieval
• Expertise in ETL migration projects
• Highly motivated with the ability to work effectively in teams as well as independently
• Experience in scheduling the project, risk analysis and overall project plan.

TECHNICAL SKILLS

Database: Teradata V15.0, SYBASE, IBM DB2, Oracle, Snowflake, Postgres

Utilities: Teradata utilities BTEQ, FastLoad, MultiLoad, T - pump, FastExport/Import utilities and stored procedures, Python Spark

Platforms: Mainframes MVS, UNIX, Windows

Tools: SQL Assistant (Queryman) 14.0, Airflow, Jira, GIT, SVN, File Aid, Putty, FileZilla, Microsoft Office products.

Languages: PL/SQLs, JCL, COBOL

PROFESSIONAL EXPERIENCE

Confidential, Beaverton, OR

Developer

Responsibilities:

• Developing Teradata BTEQ scripts and stored procedures
• Migrating code from Teradata to Cloud Snowflake
• Migrated 200+ Teradata objects (Tables, Views and Stored procedures)
• Migrating data using Spark in AWS EMR
• Creating and maintaining AWS S3 buckets
• Long running Teradata procedures are performance tuned to acceptable standard in Snowflake
• Scheduling jobs in Airflow from AWS EC2 instance
• Educating the team about the new cloud database Snowflake - difference between Teradata and Snowflake
• Involved in all the project cycles (Design, Development, UT, SIT, deployment and PROD support)

Confidential, Phoenix, AZ

Developer

Responsibilities:

• Development in Teradata SQL and stored procedure
• Coding in Teradata tools and utilities(Mload, BTEQ, Fastload) in Unix shell script
• Long running Teradata procedures are performance tuned to acceptable standard
• Development in Apache Spark
• Involved in all the project cycles (Design, Development, UT, SIT, deployment and PROD support)
• Review Development and Unit testing results
• Production implementation and post production support
• Co-ordination with teams across locations

Confidential, Phoenix, AZ

Developer

Responsibilities:

• Provide support for GCP applications in Teradata
• Long running Teradata procedures are tuned to acceptable standard
• Alerting users if any failure in the process
• Daily Health status check of critical applications
• Initiating impact analysis due to maintenance activities in database or code changes in upstream
• Co-ordination with teams across locations

Confidential, Phoenix, AZ

Developer

Responsibilities:

• Analyzing the existing code in Ab Initio and Sybase and prepare As-Is (ETL Tool Ab Initio graph) process flow
• Design approach to be compatible with Teradata
• Development in Teradata PL/SQL
• Coding in Teradata tools and utilities(Mload, BTEQ, Fastload, Tpump) in Unix shell script
• Guiding the team in all the project cycles (Design, Development, UT, SIT, deployment and PROD support)
• Review Development and Unit testing results
• Production implementation and post production support
• Co-ordination with teams across locations

Confidential, Phoenix, AZ

Developer

Responsibilities:

• Analyzing the existing code in Ab Initio and Sybase and prepare As-Is (ETL Tool Ab Initio graph) process flow
• Design approach to be compatible with Teradata
• Development in Teradata SQL
• Coding in Teradata tools and utilities(Mload, BTEQ, Fastload, Tpump)
• Guiding team in all the project cycles (Design, Development, UT, SIT, deployment and PROD support)
• Performance tuning of Teradata procedures
• Review Development and Unit testing results
• Production implementation and post production support
• Co-ordination with teams across locations

Confidential, Phoenix, AZ

Developer

Responsibilities:

• Analyzing the existing code in Ab Initio and Sybase and prepare As-Is (ETL Tool Ab Initio graph) process flow
• Design approach to be compatible with Teradata
• Development in Teradata SQL
• Guiding team in all the project cycles (Design, Development, UT, SIT, deployment and PROD support)
• Review Development and Unit testing results
• Production implementation and post production support
• Co-ordination with teams across locations

Confidential, Dallas, TX

Developer

Responsibilities:

• Development in Teradata utilities (Mload, Fastload, BTEQ) in UNIX scripts.
• Development in Teradata SQL
• Create legends, formats and templates in TCRM
• Create campaign and communication to test the legends, formats and template.
• Analyzing business requirements
• Prepare design documents
• Involved in all the project life cycle - Design, Code, Testing, Deployment and PROD support

Confidential, Charlotte, NC

Developer

Responsibilities:

• The behaviors of existing and new jobs are captured and suggestions are given for proper SLA adherence and Coordinate with onshore
• Involved in performance tuning to improve efficiency
• Development in Teradata SQL
• Development in Teradata utilities (Mload,Fastload,BTEQ) in UNIX scripts
• Informatica development and testing activity
• Guiding team in all the project cycles (coding, UT, SIT, deployment and PROD support)

Confidential, Charlotte, NC

Developer

Responsibilities:

• Development in Teradata SQL
• Development in Teradata utilities (Mload,Fastload,BTEQ) in Unix shell script
• Writing UNIX shell scripts
• Coding in COBOL, JCL
• To train the newly joined about the project processes and company process
• Conducted Academic Sessions on Teradata
• Travelled to Mexico to conduct training and knowledge sharing sessions
• Involved in requirement gathering
• Worked in all project cycles (coding, UT, SIT, deployment and PROD support)