SUMMARY:

• 8+ years of experience in the IT industry, coupled with extensive experience in Database and data warehousing in Teradata, Oracle, UNIX Environment for Decision Support Systems.
• Extensive experience in Administration and maintenance of Dev, Stage, prod and standby databases for DSS and Data Warehousing environments.
• Hands on experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, Teradata Parallel Transporter (TPT), Teradata SQL and BTEQ Teradata utilities.
• Excellent Programming experience in Teradata SQL, Stored Procedures and Macros.
• Experience in modern Hadoop big data technologies and architecture.
• Involved in ETL development activities using Talend, ODI.
• Experience in performance trending and analysis including recommending indexing strategies, partitioning, Join Indexes, compression opportunities and statistic collection planning.
• Experienced with handling DBQL data.
• Expertise in Dynamic Workload and Resource Management using TDQM.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Proficient in complex Data Warehousing concepts including in Data mart and Data Mining using Dimension Modeling (Star Schema, Snow - Flake schema Design and Normalized structures).
• Expertise in Query Analyzing and performance tuning.
• Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager (TASM).
• Well versed with Java Script, HTML, CSS
• Experience in Designing and implementing disaster recovery plans.
• Performed backup and recovery of Teradata databases using Arc utility.
• Proficient in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis.
• Very good understanding of Reporting tools like MicroStrategy and Business Objects.
• Excellent Team player and Quick learner with positive attitude and self-motivation.
• Ability to work as an individual or as a part of a team

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Teradata Developer

• Work extensively on BTEQ, UNIX Shell scripting.
• Resolve issues related to semantic layer or reporting layer.
• Work on different subject areas like Customer, Loyalty, Promotion and Item
• Responsible to extract the sales data and send it to marketing team.
• Write complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Develop the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and then move data from staging into Base tables
• Review 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.
• Responsible for Analyzing the UNIX shell scripts that are existing in BCI to get the business rules and then created the mappings between the source fields and the target table fields
• Use BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Perform high volume maintenance on large Teradata tables using MultiLoad loader utility.
• Create TPT to transfer the data Oracle system to Teradata.
• Use Fast Export utility to extract large volumes of data at high speed from Teradata RDBMS.
• Develop TPump scripts to load low volume data into Teradata RDBMS at near real-time.
• Collect statistics periodically on tables to improve system performance.
• Performance tuning and optimization of application SQL using Query analyzing tools.

Environment: Teradata, TASM, TPT, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, Teradata Analyst Pack, MLOAD,Unix, Shell scripting, Unica, Oracle.

Confidential, Rosemead, CA

Teradata / Talend Developer

Responsibilities:

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Security administration including creating and maintaining user accounts, passwords, profiles, roles and access rights.
• Capacity planning including review and analysis of usage, capacity, and performance data.
• Performed Space Management for Perm & Spool Space.
• Performance trending and analysis including recommending indexing strategies, partitioning, compression opportunities and statistic collection planning.
• Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
• Used various AMP based utilities like VPROC manager, Lockdisp, Showlock, Qrysessn.
• Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
• Performed bulk data load from multiple data source (legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Used FastLoad for loading into the empty tables.
• Analyzed initial workload to understand the impact of various designs prior to having populated tables using TSET.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
• Involved in troubleshooting the production issues and providing production support.
• Collected statistics every week on the tables to improve performance.
• Involve in design sessions to migrate the data from Teradata to Hadoop Big data
• Perform technical analysis, ETL Design, development, testing and deployment of IT solutions as needed by business or IT.
• Participate in designing the overall logical & physical Data warehouse/Data-mart data model and data architectures to support business requirements.
• Explore prebuilt ETL metadata, mappings and DAC metadata and Develop and maintain SQL code as needed for SQL Server database.
• Performed data manipulations using various Talend components like tMap, tJavarow, tjava, tOracleRow, tOracleInput, tOracleOutput, tMSSQLInput and many more.
• Analyzing the source data to know the quality of data by using Talend Data Quality.
• Troubleshoot data integration issues and bugs, analyze reasons for failure, implement optimal solutions, and revise procedures and documentation as needed.

Environment: Teradata, TASM, TPT, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, Teradata Analyst Pack, MLOAD, ARCHMAIN, UNIX Shell scripts, Hadoop, Talend, Hive, Impala, HBase

Confidential, Sunnyvale, CA

Teradata DBA

Responsibilities:

• Created Teradata objects like Databases, Users, Profiles, Roles, Tables, Views and Macros.
• Modified Databases, Users, Roles & Profiles, Views & Macros.
• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Performed Space Management for Perm & Spool Space.
• Reviewed the SQL for missing joins & join constraints, data format issues, mismatched aliases, casting errors.
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles.
• Dealt with Incremental data as well Migration data to load into the Teradata.
• Have experience in tuning some batch BTEQ queries.
• Enhanced some queries in the other application to run faster and more efficiently.
• Data was extracted from Teradata, Processed/Transformed using Ksh programs and loaded into Data Mart.
• Used various Teradata Index techniques to improve the query performance
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created series of Macros for various applications in TERADATA SQL Assistant.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created several custom tables, views and macros to support reporting and analytic requirements.
• Involved in the complete design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Release Utility Locks of Multiload& dropping Multiload related tables for the aborted jobs.
• Monitor and Abort Sessions for blocked, high CPU consuming, highly skewed and long running queries.
• Monitor Teradata Database using Teradata Viewpoint, TASM.
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the ETLscripts. Have done the JI index analysis to improve SQL performance.

Environment: Oracle 8i, MS-Access, TOAD, Teradata Administrator, Teradata V2R5, Teradata SQL Assistant, Teradata Manager, SQL, UNIX and Windows NT.

Confidential

Teradata Developer

Responsibilities:

• Configured Load Utilities like FLOAD, MLOAD
• Granted & Revoked Object Rights, System Rights on Databases / Users / Roles..
• Constant Testing of Source and Target after loading to ensure Consistency in the Data
• Worked on call to ensure system availability
• Implementation of TASM and Analyst Packs to identify the system variations and SQL trends.
• Moved Teradata Databases from UNIX-MP RAS to Linux SUSE 64 bit to increase performance.
• Worked with Logical and physical data models with help of Erwin.
• Wrote scripts for BTEQ, and other tools.
• Used Teradata Tools and Utilities and configured them to understand the System.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Perform ETL activity through ODI (Oracle Data Integrator) and Teradata
• Worked on Teradata Queryman to validate the data in warehouse for sanity check.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Upgraded older versions of Teradata through PUT utility.
• Analyzed performance after upgrade
• Worked on FSLDM to create physical data models.
• Performed Backup and Recovery activities as and when required.
• Monitored user sessions
• Implemented security as per the Norms of the Company.
• Automated recollection of stats by shell scripting as well as STATS Wizard.
• Selection of Indexes when creating a Table.
• Recommendation of SI and JI to influence the Optimizer.

Environment: Teradata, TASM, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, PMON, MLOAD, ARCHMAIN, UNIX, LINUX SUSE, Shell scripts.

Confidential

Oracle Developer

Responsibilities:

• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views & normal views where business requirements needed.
• Created tables with complex constraints applicable to the business rules.
• Created Explicit Cursors, Records, Tables, Objects, Collections (Nested Tables and Varrays) and Error Handling.
• Involved in writing procedures, functions and packages based on requirements.
• Developed BI Reports using OBIEE
• Defined data model in OBIEE Repository
• Published the BI reports to the portal for end user accessibility.
• Creating Apex Forms and Reports based on user requirements.
• Creating Access Controls based on User roles.
• Creating Pre-Computations and item and page level validations.
• Used JavaScript for some specific page validations.
• Trained end users on the functionality and operability of the application.
• Involved in 24/7 Production support rotation.

Environment: Oracle, Toad, SQL/PLSQL, JavaScript, Apex, HTML, OBIEE