SUMMARY:

• Confidential is, Teradata Certified Masters V2R5, an experienced IT professional with 14+ years of experience in Information Technologies includes Hadoop, Teradata, Oracle, SQL Server, Unix/Linux Shell Scripting, Informatica, Ab Initio, Qlik Sense & Tableau.
• Teradata database V2R5/V2R6/V2R12/V2R13.10/V2R14/V2R14.10, Teradata Utilities such as BTEQ, SQL Assistant, Fast load, Multiload, TPT, Fast export, TPUMP, Administrator, Viewpoint, DBQL, Teradata SQL, Stored Procedures, Macros & Views. Oracle / Sybase to Teradata migration processes.
• Hadoop, Hadoop Distributed File System (HDFS), Sqoop, Hive, Impala, HBase, Flume, Oozie, Spark & Scala.
• Informatica 8.5.1 & 8.6.1 & Ab Initio.
• Microsoft SQL server (11.0.7), SSIS (SQL Server Integration Services), SQL Server Reporting Services SSRS and SQL Server Analysis Services SSAS, Confidential - SQL experience, stored procedures & functions.
• Oracle databases 8i, 9i, 10g, 11g, Oracle SQL, PL/SQL, Sqlldr, Packages, Stored Procedures, Triggers, Functions & Views.
• Toad / SQL developer / Teradata SQL Assistant / Advance Query Tool
• Issue logging / project tracking tools such as ALM and JIRA
• Agile methodology, Scrum.
• UNIX shell scripting.
• 12+ years of experience in Extract, Transform and Load (ETL), semantic, analytics and data warehousing.
• Tableau, Qlik Sense & Oracle Reports (6i & 2K)
• Erwin and data modeling.
• 12+ years of working experience as an onsite resource in Healthcare, Financial and Retail industries.
• Excellent communication skills.
• Good leadership skills performed project management tasks.
• 7+ years of experience as Technical Lead.
• Working closely with Business Associates, Business Partners and end users.
• 7+ years of experience in data analytics.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix, & Linux

Database Systems: Teradata (V2R5/V2R6/V2R12/V2R13.10/V2R14/V2R14.10), Oracle Database 8i/9i/10g, SQL server (11.0.7), Hadoop

Tools: and Utilities TPT, Teradata SQL Assistant, BTEQ, Multiload, Fast load, Tpump, Fast export, Teradata Visual Explain, Teradata viewpoint, Teradata Administrator & Teradata DBQL HDFS, Sqoop, Hive, Impala, Flume, HBase, Oozie, Spark & Scala SQL Server Integration Services (SSIS), SQL Server Reporting Services SSRS and SQL Server Analysis Services SSAS Informatica 8.5.1/8.6.1 & Ab-Initio, Toad / SQL developer, Tableau, Qlik Sense, Oracle Reports (6i & 2k)

Programming Languages: Teradata SQL, Stored Procedural Language, Macros, Views Oracle SQL, PLSQL, Unix Shell Scripting, Confidential -Sql, Functions, Triggers, Constraints, Python & Scala.

PROFESSIONAL EXPERIENCE:

Confidential

ETL/ Teradata Senior Developer / Technical Lead, Raleigh, NC

Responsibilities:

• Understanding business requirements provided by client for designing, developing and implementing workable database and data warehousing solutions.
• Perform database architectural decisions by preparing high level data flow diagrams, functional specifications & data analysis.
• Modeling - Create physical data models in Teradata / Oracle / SQL server to meet the business requirements.
• Develop lower level data model design for ETL and Semantic.
• Build Design spec / Unit Spec / Unit Test Plan / Traceability matrix / Development check list / Source code review documents.
• Develop process using stored procedures, functions, packages, triggers, views, macros, user defined functions, complex SQLs, PL/SQL and all other database objects in SQL Server / Oracle / Teradata databases.
• Development of ETL and semantic jobs using SQL server, Oracle Database, Teradata Database, Informatica, Ab Initio, SSIS, Confidential -SQL, Sqlldr, PL/SQL, Fast load, Multiload, TPT, SQL Assistant, BTEQ & TPUMP.
• Development of medium to complex UNIX shell scripting (ksh, bash) for file handling and data manipulation.
• Provide technical leadership to offshore & onshore team.
• Review / co-ordination with offshore team on development progress.
• Ensure the smooth ongoing execution of the development engagement phase through the maintenance of regular status meetings and reports, and by soliciting the continuous feedback from the customer.
• Performance tuning of long running queries in Teradata / Oracle / SQL Server.
• Conversion of cursor-based logic into batch processing SQLs by writing complex queries appropriately.
• Development of ad-hoc queries for end users.
• Integration of complex source systems into data warehouse system.
• Working on Water Fall, Scrum and Agile methodologies.
• Project management experience using JIRA tool. Issue logging in ALM (formerly HP QC)
• Working with quality assurance (QA) team for addressing process issues if any.
• Working with business users for product approval by supporting User Acceptance Test (UAT)
• Continuous reporting to client on the development progress by having face to face meetings and or web meetings.
• Working with production operation team on code deployment / production release processes.
• Provide production support for the recently deployed processes.
• Maintain source code for database and ETL projects.
• Ensure that projects build successfully in a continuous integration environment using version controlling tool CVS, TFS, VSS & Star Team.
• Import of data into and from HDFS and Hive using Sqoop.
• Creation of HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
• Development of flume scripts for Collecting, Aggregating and moving large amount of streaming data into the HDFS.
• Development of load / analytic scripts in Spark Scala.
• Creation of relational data models in Impala & Hive.
• Created Hive queries that helped client analytics by comparing fresh data with EDW tables and historical metrics.
• Manage and review Hadoop log files.
• Automation of data loading into HDFS using Oozie. Job automation using IPM (In-Process Manager)
• Creation of reports for the BI team using Qlik Sense and Tableau using data from Hive.
• Design, plan, and develop programs to perform automated extract, transform and load data between data sources when working with large data sets (TBs+ range)
• Perform complex data analysis or predictive analysis using data in Hadoop.

Confidential

ETL/Teradata Senior Developer, Raleigh, NC

Responsibilities:

• Understand business requirements provided by client and/or onsite Teradata personnel for designing, developing and implementing workable database and data warehousing solutions.
• Perform high/detail level database designs by preparing high/detail level data flow diagrams, functional specifications, detail technical specifications & data Analysis.
• Modeling - Creating logical/physical data models in Teradata / Oracle to meet the business requirements.
• Preparation of lower level data model design for ETL and Semantic.
• Development of Extract Transform and Load (ETL) and semantic jobs using Informatica, Ab Initio, Oracle Database, Teradata Database, Teradata / Oracle utilities such as Sqlldr, PL/SQL, Fast load, Multiload, TPT, BTEQ, Stored Procedures, Viewpoint, Fast export, TPUMP, Static wizard, SQL Assistant, Administrator, DBQL, SQL and UNIX shell scripting.
• Managing team of up to 10 members and performed lead role in developing many applications.
• Development of UNIX shell scripting for file handling and data manipulation.
• Provide technical leadership to offshore & onshore team.
• Review / co-ordination with offshore team on development progress.
• Ensure the smooth ongoing execution of the development engagement phase through the maintenance of regular status meetings and reports, and by soliciting the continuous feedback from the customer.
• Performance tuning of long running processes in Teradata / Oracle.
• Working with quality assurance (QA) team for addressing process issues if any.
• Working with business users for end product approval by supporting user acceptance test (UAT)
• Continuous reporting to client on the development progress by having face to face meetings and or web meetings.
• Working with production operation team on code deployment / production release processes.
• Provide production support for the recently deployed processes.

Confidential

Onshore Senior Developer / Technical Lead, Raleigh, NC

Responsibilities:

• Understanding business requirements provided by client for designing, developing and implementing workable database and data warehousing solutions.
• Perform database architectural decisions by preparing high level data flow diagrams, functional specifications & data analysis.
• Modeling - Create physical data models in Teradata Oracle / SQL server to meet the business requirements.
• Develop lower level data model design for ETL and Semantic.
• Build Design spec / Unit Spec / Unit Test Plan / Traceability matrix / Development check list / Source code review documents.
• Develop process using stored procedures, functions, packages, triggers, views, macros, user defined functions, complex SQLs, PL/SQL and all other database objects in SQL Server / Oracle / Teradata databases.
• Development of ETL and semantic jobs using SQL server, Oracle Database, Teradata Database, Informatica, Ab Initio, SSIS, Confidential -SQL, Sqlldr, PL/SQL, Fast load, Multiload, TPT, SQL Assistant, BTEQ & TPUMP.
• Development of medium to complex UNIX shell scripting (ksh, bash) for file handling and data manipulation.
• Provide technical leadership to offshore team.
• Review / co-ordination with offshore team on development progress.
• Ensure the smooth ongoing execution of the development engagement phase through the maintenance of regular status meetings and reports, and by soliciting the continuous feedback from the customer.
• Performance tuning of long running queries in Teradata / Oracle / SQL Server.
• Conversion of cursor-based logic into batch processing SQLs by writing complex queries appropriately.
• Development of ad-hoc queries for end users.
• Integration of complex source systems into data warehouse system.
• Working on Water Fall, Scrum and Agile methodologies.
• Issue logging in ALM (formerly HP QC)
• Working with quality assurance (QA) team for addressing process issues if any.
• Working with business users for product approval by supporting User Acceptance Test (UAT)
• Continuous reporting to client on the development progress by having face to face meetings and or web meetings.
• Working with production operation team on code deployment / production release processes.
• Provide production support for the recently deployed processes.
• Maintain source code for database and ETL projects.
• Ensure that projects build successfully in a continuous integration environment using version controlling tool CVS, TFS, VSS & Star Team.

Confidential

ETL Module lead/developer

Responsibilities:

• Understanding of the business requirements provided by client and/or onsite Teradata personnel for designing, developing and implementing workable database and data warehousing solutions.
• Perform high/detail level database designs by preparing high/detail level data flow diagrams, functional specifications, detail technical specifications & data Analysis.
• Modeling - Creating logical/physical data models in Teradata / Oracle to meet the business requirements.
• Preparation of lower level data model design for ETL and Semantic.
• Development of Extract Transform and Load (ETL) and semantic jobs using Informatica, Ab Initio, Teradata Database, Teradata / Oracle utilities such as Sqlldr, PL/SQL, Fast load, Multiload, TPT, BTEQ, Stored Procedures, Viewpoint, Fast export, TPUMP, Static wizard, SQL Assistant, Administrator, DBQL, SQL and UNIX shell scripting.
• Managing small teams and performed lead role in developing many applications.

Confidential

Developer / Technical Associate

Responsibilities:

• Analyzing the issues reported by the customer/support team and interacting with customer/support team for resolution approach.
• Analyze the effect of the new code on the production system before development.
• Development of new code.
• Testing of a new code in Test Environment.
• Release of the patch to customer/support team for production deployment.

Environment: Oracle 8i/9i, D2K and Pro* C

Confidential

Developer / Programmer Analyst

Responsibilities:

• Analyzing the issues reported by the customer and interacting with customer for resolution approach.
• Development of new processes or updates to existing database processes.
• Perform impact analysis of new code on the production system before development.
• Testing of the database code in Test Environment.
• Interacting with customers on patch implementation.
• Applying the patches in Production Environment.
• Providing support to production systems.

Environment: Oracle 8i/9i and D2K

Confidential

Trainee Programmer

Responsibilities:

• Development of Oracle D2K forms and reports required for various modules.
• Unit testing of newly developed forms and reports.