SUMMARY

• 8+ Years of total IT experience and Technical proficiency in Data Warehousing that involves Business Requirements Analysis, Application Design, Data Modelling, Development, testing and documentation.
• Experience in Teradata Database design, implementation and maintenance mainly in large scale Data Warehouse environments.
• Hands on experience in Teradata RDBMS using FastLoad, MultiLoad, FastExport, Teradata SQL Assistant, BTEQ Teradata utilities.
• Around 4+ years of strong data warehousing experience using Informatica Power Mart 6.1/5.1/4.7, Power Center 9.5.0/9.1.0/8.6.1/8.1/7.1.3/7.0/6.2/5.1 , Power Exchange, Power Connect as ETL tool.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Expertise in Query Analyzing, performance tuning and testing.
• Experience in writing UNIX korn shell scripts to support and automate the ETL process.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Extensive database experience and highly skilled in SQL in Oracle, MS SQL Server, DB2, Teradata, Sybase, Flat Files, MS Access.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling.
• Experience in importing and exporting data from different RDBMS Servers like MySQL, Oracle and Teradata into HDFS and Hive using Sqoop.
• Proficient in analysis of user requirements and functional specifications.
• Strong Emphasis in reviewing End-to-End test requirements, assigning appropriate resources, and initiate the End-to-End planning process.
• CreatedDatastagejobs (ETL Process) for populating thedatainto theDataWarehouse constantly
• Good understanding of the Software Development Life Cycle (SDLC).
• Excellent in interacting withdevelopersat various levels and understanding technical specifications, documentation of the application to be tested.
• ETL Data warehousing using Informatica Power Center 7.x/8.x/9.6 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Involved in development ofInformaticamappings with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy etc.
• Strong Knowledge on Power Center Designer, Workflow Manager, Workflow Monitor.
• Creating sessions and Workflows usingInformaticaWorkflow Manager.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings usingInformaticaDesigner Tool.
• Involved in Performance Tuning at mapping level and session level.
• Expert on various UNIX (AIX, SUN, HP - UX and SVR) systems and Scheduling tools like AUTOSYS, Tivoli & CONTROL-M.
• Experience in resolving on-going maintenance issues and bug fixes; monitoringInformaticasessions as well as performance tuning of mappings and sessions.
• Exclusive knowledge in Identification of User requirements, System Design, writing Program specifications, Coding and implementation of the Systems.
• Excellent communication and inter personnel skills, Proactive, Dedicated and Enjoy learning new Technologies and Tools.
• Strong commitment towards quality, experience in ensuring experience in ensuring compliance to coding standards and review process.
• Good experience in writing Shell Scripts in UNIX and Batch files in Windows environment.
• Experienced in writing stored procedures, Functions, Packages and Triggers using PL/SQL.

TECHNICAL SKILLS

Primary Tools: Teradata SQL Assistant, BTEQ, Fast Load, Multiload, Fast Export, Tpump, Informatica 10.2.0/9.6.1/ 9.5.0/9.1.0/8.6.1/8.1/7.1.3/7.0/6.2/5.1 Power Center 6.x/7.x/8.x, Power Exchange 5.x

Languages: C, C++, SQL, PL/SQL, HTML, DHTML, Visual Basic, UNIX Shell Scripting

Teradata Utilities: BTEQ, Fast Load, Multiload, Tpump, TPT, SQL Assistant, Teradata Manager

Databases: Teradata 13/14/15, Oracle 10g/11g, MS SQL Server, SQL Server 2000/2005/2008/2012/2014/2016 , DB2, Flat Files

Operating Systems: Windows, UNIX, Linux

Reporting tools: Business Objects Web-Intelligence, Crystal Reports

SQL Tools: SQL Assistant, TOAD 7.x

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

Sr. Teradata Developer

Responsibilities:

• Worked in all the stages of the SDLC like Business, Functional, Technical Requirements Gathering, Designing, Documenting, Developing and Testing.
• Involved heavily in writing complex SQL queries based on the given requirements such as complex Teradata Joins, Stored Procedures, Macros, etc.
• Worked onTeradataStore procedures and functions to confirm the data and load it on the table.
• Worked in the conversion of SQL server functions into theTeradataStore procedure for confirming the data.
• The financial data mainly included Accounts Payables, Account Receivables, Budget, Fixed Assets, General Accounting, Procurement, Treasury Accounting, Performance Budgeting etc.
• Created, optimized, reviewed, and executedTeradataSQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Wrote numerous BTEQ scripts to run complex queries on theTeradatadatabase.
• Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
• Manage and support production/development/test servers, databases, Data Warehouses on standalone, clustered, (AWS,Azure) cloud environments
• Designed and used shell scripts that automate thedatastagejobs and validate files.
• Extensively usedInformaticaClient tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer,InformaticaRepository Manager andInformaticaWorkflow Manager.
• Developed various complex mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Optimized and Tuned SQL queries used in the source qualifier of certain mappings to eliminate Full Table scan.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables usingInformaticaWorkflow Manager.
• Created various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Involved in the administration of theInformaticaRepository and in the design and architecture of multiple repositories to support multiple application development areas.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQLdeveloper.
• Developed UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Created scripts for Batch test and set the required options for overnight, automated execution of test scripts.
• Created Shell Script to send the data to downstream systems using FTP / SFTP.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Expertise in writing scripts for Data Extraction, Transformation and Loading of data from legacy systems to target data warehouse using BTEQ, Fast Load, Multiload, Tpump.
• Wrote complex SQL’s and used volatile tables for code modularity and to improve performance of the query.
• Created Data Mapping Documents as part of the Data migration projects.
• Worked closely with the Business to understand their needs and provided my inputs to address their needs and requirements.

Environment: Teradata 15/14, Microsoft SQL Server, UNIX, Informatica, Tpump, Fast load, BTEQ, Power center, MLoad, MS Office Tools, Erwin, Jira, Tableau.

Confidential, Minneapolis, MN

ETL/Teradata Developer

Responsibilities:

• Exclusively worked on creating Technical Design documents by gathering business Requirements from Business Users and developed source to target design documents for development of workflows.
• Worked in Teradata team in loading the data using relational connections and using different utilities to load the data like BTEQ, Fast Load, Multi Load, Fast Export, TPUMP, TPT scripts.
• Create/modify Teradata Tables, Views and Stored Procedures. Create Semantic layer views for business users.
• Data ingestion from Teradata to hadoop (sqoop/ibis imports). Perform validation; create hive tables for reporting layer.
• Scheduling Teradata / Hive scripts through CA ESP work station.
• Performance Tuning of Teradata SQL through Explain, PPI, AJI, Indices, Collect stats and query tuning and performance tuning of Hive/Impala queries in Hadoop.
• Code Optimization. Parameterizing scripts reducing the number of scripts.
• Testing/Validating data between cross environments by using Fitnesse.
• Migrated data from Teradata to Hadoop Using Squoop/IBIS/Udeploy.
• Create BI/Multi-dimensional cubes using AtScale meeting SLA improving report generation time in Tableau.
• Support and coach peers and juniors as and when required on specific technical competencies
• Production/Release Support - escalation point for production issues.
• Handled Production issues fixing data issues.
• DeployedDataStagejobs to different environments; development environment to test environment and from test environment to production environment.
• Experience in developing Hive UDF's and running hive scripts using different execution engines like Tez and Spark (Hive on Spark).
• Worked with Volatile tables and used secondary Indexes in joining two tables for fast retrieval of data, to improve performance and there by efficiency.
• Involved in different phases of Data Warehouse life cycle ranging from project planning, requirements gathering and analysis, offshore coordination, ETL design, ETL development and testing, Reporting, integration, regression and user acceptance testing, implementation, system documentation and support.
• Performed extraction, transformation and loading of data from RDBMS tables, Flat Files, SQL into Teradata in accordance with requirements and specifications.
• Extensively worked on the Root Cause Analysis for high severity issues and resolve them within the given SLA.
• Prepare test cases & perform Unit / Integration / System / Regression Testing. Assist Business during UAT.
• Worked in Agile Development model using Jira, participated in daily standups providing everyday updates in project movement.

Environment: Teradata 14, Fast Load, Multiload, TPump, TPT Scripts, Erwin, Jira.

Confidential, Portland OR

ETL/Teradata Developer

Responsibilities:

• Gatheredbusiness requirements through meeting the customers who have requested the reports.
• Created mockup reports and prototypes to get a sign off from the customer.
• Extensively usedInformaticaClient tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer,InformaticaRepository Manager andInformaticaWorkflow Manager.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Teradata is the backend database for this reporting project taking the future enhancement into consideration.
• Gather information from different data warehouse systems and loaded into warehouse using BTEQ.
• Noticeable Contribution for burndown of burndown chart
• Execution of SQL queries to extract data from DB2 tables for running test scripts.
• Designed various Mappings for extracting data from various sources involving Flat files, Oracle and SQL Server usingTeradatautilities BTEQ, MLOAD, FLOAD and PUMP to load staging area
• Developed Test plans to verify the logic of every phase. The test plans included counts verification, look up hits, the business logic of each element of data attributes and target counts.
• Assisted in designing and development of DB2, Oracle and database objects
• Extensively used SCD's (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Working on POC using Java, Hadoop, Hive and NO-SQL databases like Cassandra for the data analysis. This is the initial implementation of the Hadoop related project where LM want to see the claims loss transactions on Hadoop.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, push down optimization, pre, and post stored procedures to drop and build constraints.
• Created UNIX Script for ETL jobs, logs session cleanup and dynamic parameter.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor and Scheduler alert editor.
• Involved in creating Metadata data for BASEL and BETA Solutions.
• Data profiling to make sure the source that have been identified are appropriate.
• Involved in enhancing the SAS scripts for the CCM and Rose Tracker.
• Developed Tableau data visualization using Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Worked on the Daily Dialer reports, Call Center Management (CCM) Reports and Abandon Rate Report.
• Involved in loading the REO tables and provided underlying SQL Scripts for the critical REO Dashboards and Scorecards built in Business Objects Environment.
• Provided production support to the Default &Servicing and Originations Reports in the BO Environment.
• Involved in tuning the SQL’s in order to improve the SQL execution performance.
• Maintained the Teradata UD tables used for Rose-Tracker, Debt Protection, CCM and FNMA reports.
• Worked on the Risk Weight Assessment project.
• Have gained the more knowledge on different types of Databases (MDW, BDE, BDW, EDW, LDW) available in the Home Loans department.

Environment: Teradata 12.x/13.x, Teradata SQL Assistant, MLOAD, FLOAD, Hive, Business Objects 3.1/4.0, Crystal Reports 2008, PC-SAS, MS-Excel, MS-Word.

Confidential, NY

Teradata Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design, Development, testing and implementation of business rules.
• Implemented logical and physical data modeling with Star and SnowFlakes techniques using Erwin.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Responsible for Collect Statistics on FACT tables.
• Created proper Primary Index taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Wrote numerous BTEQ scripts to run complex queries on the Teradata database.
• Created tables, views in Teradata, according to the requirements.
• Performed bulk data load from multiple data source to Teradata using BTEQ, Multiload and FastLoad.
• Designing, creating and tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to support normalized and dimensional models. Maintain the referential integrity of the database.
• Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
• Developed UNIX scripts to automate different tasks involved as part of loading process.

Environment: Teradata 13, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, TPT, TPump, Erwin Designer, UNIX, Korn Shell scripts.

Confidential

Software Engineer

Responsibilities:

• Created Star Schema model with required facts and dimensions.
• Defined various facts and Dimensions in the data mart including Aggregate and Summary facts.
• Converted DataMart from Logical to Physical design, defined data types, Constraints, Indexes, generated Schema in Database, created automated scripts, defined storage parameters for objects in the Database.
• Created and Maintained Teradata Tables, Views, Macros, Triggers and Stored Procedures
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
• Worked on complex queries to map the data as per the requirements.
• Populate or refresh Teradata tables using Fast load, Multi load & TPump utilities for user acceptance testing and loading history data into Teradata.
• Created UNIX Scripts for triggering the Stored Procedures and Macro.
• Involved in Performance tuning for the long running queries.

Environment: Teradata 12, Teradata SQL Assistant, BTEQ, FLoad, FExport, MLoad, TPT, TPump Erwin4.1.4, Quest Toad 9.3, UNIX Shell Scripting, SQL*Loader, Smart Putty, SQL Server, Windows XP, UNIX.