SUMMARY

• 9+ years of IT experience in implementing Data Warehouse projects using Teradata and UNIX shell scripting.
• 9+ years of experience in banking domain.
• 2 years of working experience with Informatica, Netezza and SQL server.
• Good experience in Project Planning, Effort estimation, Business analysis to meet needs of Clients and developing efficient solutions.
• Project experience in both Waterfall and Agile methodologies.
• Expertise in Teradata utilities - TPT, BTEQ, Fast load, MLOAD, TPUMP scripts.
• Excellent knowledge on Teradata SQL Performance tuning for optimal performance and good knowledge on Collect statistics, Derived tables, Volatile/Global Temporary tables, join strategies, join types and Explain/Optimizer plans.
• Excellent knowledge on Teradata Standards, best Practices and ANSI SQL.
• Expertise in creating complex Adhoc SQL queries to support user help requests within a short time frame using OLAP functions, derived tables and complex joins.
• Good Data Warehousing ETL experience using Informatica Power Center Client tools - Power Center Designer - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplets, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience working with business Analyst and Subject Matter Experts (SME's) to identify, prioritize, and implement solutions to improve efficiency, reduce risk, and support new business
• Excellent analytical skills.
• Good Experience in implementing Data Quality (DQ) checks and Recon checks.
• Good Experience working in a Global Delivery Model

TECHNICAL SKILLS

DATABASES: Teradata v12;v13;v14, MS-SQL Server, Netezza, Oracle

Teradata Utilities: TPT(LOAD, UPDATE, STREAM, SQL Selector, ODBC, Fast Export, Data Connector Operators), BTEQ, FASTLOAD, MLOAD, TPUMP,FASTEXPORT

ETL Tools: Informatica Power Center v9.5.1 and v9.6.1 -Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager, SSIS

DB Tools: Teradata SQL Assistant, Toad

Languages: Unix/Linux Shell Scripting, ANSI SQL

Scheduling Tool: Autosys

Other Tools: JIRA, SVN Versioning Tool, Visio, Putty, WINSCP, Quality Center

PROFESSIONAL EXPERIENCE

Confidential | Charlotte, NC

Technology Analyst

Environment: MS SQL Server, SSIS, Oracle, Teradata

Responsibilities:

• Gathering business requirements across different Line of Business
• Attending business sessions and preparing the High and low level design
• Used Teradata for sourcing the data
• Prepare Business requirement document(BRD), Data request memory and other documentation for each testing
• Develop SSIS packages and SQL scripts to load, analyze and generate reports
• Automate the process of data reception, data load, data analysis and report generation from different systems

Confidential | Charlotte, NC

Technology Analyst

Environment: Informatica, Netezza, UNIX, Oracle

Responsibilities:

• Develop Informatica workflows to load data from different sources, combine, transform, analyze the data as per the Data model
• Create views on top of final tables to generate the reports
• Create jobs for the workflows and schedule them using Autosys
• Develop UNIX shell scripts for passing certain parameters
• Designing the Conceptual, Logical, Physical Schema of tables needed as per the requirements
• Preparation of Metadata document for all the tables used in the project.
• Interacting directly with client (over phone or in person) and explaining business to the offshore teammates.
• Taking the project through the Change advisory board (CAB) through SIT, UAT and PROD
• Coordinating with other applications/ systems involved in this project through Quality Centre (QC) for end to end testing
• Provide support during PROD/ UAT release

Confidential | Charlotte, NC

Technology Analyst

Environment: Teradata, UNIX

Responsibilities:

• Interacting directly with client (over phone or in person) and explaining business to the offshore teammates.
• Attending business sessions and preparing the High and low level design.
• Develop BTEQ/ shell scripts to load the data and process
• Used Teradata utilities (MLOAD, FLOAD, TPT etc) to load/ export the data
• Performed tuning and optimization of complex SQL queries
• Preparing the estimates for the requirements in terms of number of resources needed, amount of money and probable number of months needed to execute the project.
• Preparation of Metadata document for all the tables used in the project
• Presenting the design to internal Architectural review board (which reviews the design, codes and schemas of the various projects and give feedbacks) for approval
• Taking the project through the Change advisory board (CAB) through SIT, UAT and PROD
• Performing Code reviews and developing the optimized SQLs.
• Allocating tasks to the offshore team and tracking daily level task status
• Reviewing the code and re-writing SQLs (if needed) as per the design

Confidential

Software Developer

Environment: Teradata, Unix

Responsibilities:

• Developed the business calculation core engine for a brand new REWARDS program for a well-known bank
• Preparation of Low Level Design of project
• Writing new BTEQ, Mloads etc. and shell scripts as per client requirements
• Performance tuning of the SQL queries in the BTEQ scripts
• Schedule the jobs using Autosys
• Planning and managing day to day activities
• Ensuring the timely deliverables
• Interaction with onsite lead to facilitate smooth implementation
• Unit testing, Integration testing
• Support during UAT migration, PROD migration
• Provide support consistently for a month after PROD release to ensure smooth transition to support team
• Worked extensively with bank’s Deposits, Investments, Cards (both credit and small business) products
• Responsible for developing the test scripts SQLs for SIT as per the test objectives/plan given by Data Analyst