SUMMARY:

• 6+ years of IT Experience and Technical proficiency in the field of Data Warehousing paired with Data Analysis, Data Mining, Business Requirements Analysis, Application Design, Development & testing, Database Support and Administration.
• Extensive Experience as a Teradata ETL Developer, Teradata ETL Production Support and Teradata ETL Migration Specialist, Teradata Dataware house Analyst, Performance Tuning Expert.
• Have extensively worked on Data Warehousing projects in the Banking and Financial services.
• Also, having good work experience in Data Management Project in Health Insurance domain.
• Have a Proven Track record in Execution and Coordination of recovery for Enterprise Applications during Teradata Upgrades (Hardware and Software), Technology Refresh Upgrades, Disaster Recovery Exercises and ETL Migration Projects.
• Worked as Senior Application support, platform support for Mainframes & Teradata Warehouse team(s) for 5+ Years in a Multi - Platform Data Warehouse management Project(s) having several hundreds of ETL Applications and thousands of users on 7 different Teradata Platforms housing more than 2 PB of data.
• Worked extensively on Teradata Utilities like MLOAD, FASTLOAD, TPUMP, FASTEXPORT, BTEQ, TPT and ARCMAIN.
• Strong knowledge in designing and developing Stored Packages, Procedures, Functions with Oracle, DB2, PL/SQL using tools TOAD and PL/SQL Developer
• Having good knowledge of all phases of Water Fall and Agile Software Development Life Cycle in large scale projects.
• Requirements analyst and Onshore Team Lead Developer, Offshore lead developer, Production support lead

TECHNICAL SKILLS:

Domain and Technology: Banking & Financial Services, Health Insurance, Data Warehousing, Database Administration, Data Mining, Data Analysis, SQL, Performance Tuning and Capacity Management.

Operation System: Windows, Mainframes ZOS, UNIX

RDBMS: Teradata 12, 13.0, 14.10 and 15; and SQL Server 2008/12

Languages: COBOL, JCL, SQL, PL/SQL, Easytrieve, REXX, HTML, XML, VB, C++

Tools and Software: Share Point, Microsoft Technologies, Autosys, IXP, CA7, Putty, EZTRIVE, Endeavor, JCL, COBOL, File Manager, SAR, Remedy, Maximo, Teradata SQL Assistant, TOAD, SQL Developer, Putty, FM, NDM, CA7, Endevor, PostMan

DB Utilities: Teradata SQL, FASTLOAD, MLOAD, BTEQ, XPORT, TPUMP, ARCMAIN, TPT, Teradata Unity Data Mover, Teradata Administrator, Teradata SQL Assistant, Viewpoint.

ORGANIZATIONAL EXPERIENCE:

Data Warehouse Analyst

Confidential, Bloomfield, CT

Responsibilities:

• Participate in business requirements review session as required
• Provide Analysis and estimations
• Analyze and understand the flow of the application including Source systems and Landing zones
• Define the database and application enforced relationships for entire application
• Analyze the data in the application and define the Reference tables, look up tables, History tables and back up tables present in the relationships etc.,
• Work with the application team to validate the tables and relationships, as per the business requirement.
• Load the data into RDR sub-setting engine and set up the environment .
• Perform the extract and Load from Sub-setting Portal into the appropriate environment.

Senior Teradata Analyst & Support

Confidential

Responsibilities:

• System Performance Review, ETL Code Review, Coding Standards, Guidelines, Enterprise policies and procedures, Data Archival & Restoral, Data Mover Cross Platform Consulting, Performance Tuning and Performance Reporting & Metrics.
• Nature of work involves Code Review, Enhancements, Performance Tuning, Capacity management and performance review and support of the existing and new Teradata ETL processes running on the Enterprise Data Warehouse.
• Design and implement the archival strategy for the new Applications.
• Perform Data movement across different Teradata systems to support the User needs, recovery solution, application development and testing needs.
• Monitor the Systems using Teradata View point, setup Viewpoint alerts and implemented TASM and to generate various performance and system related reports.
• Performance Monitoring & Performance tuning recommendations and Load Process Remediation and System Monitoring, Remediating Poorly Performing Queries.
• Provide query optimization and tuning support to End Users.
• Experience in generating reports using PDCR, DBQL and DBC tables for senior management at the bank. These reports are for various requirements like assessing CPU/IO/space usage for different applications, IDs, load processes;
• Successfully lead the offshore team for two domains in planning, execution and coordination of the Hardware Upgrade Load recovery activities for a 60 million Technology Refresh Upgrade in 2014.
• Flawless coordination and execution of 2015 RDBMS upgrade 14.10 on Teradata ODP platform, to keep it current with supported software, mitigate risk, and continue with the Optimization Roadmap.
• Tuning and reviewing the performance metrics of the Production and User queries.
• Responsible for space management and forecast, back-up, monitoring, and maintaining Production Teradata databases.
• Database security and access management for the development databases and Unity Data Mover Servers. worked in Data Mover team that handles numerous activities like monitoring Teradata platform using Viewpoint, remediating excessive statistics, tuning production ETL queries, resolving spool space issues, tuning high impact analytical queries, applying compression for space reclamation, Capacity management, Data Mover Development and Support etc.
• Oncall support (24X7) as part of a scheduled rotation with other team members.
• Extract, transform data from various sources and transfer data to the Teradata data warehouse tables/Views.
• Resolved hundreds of Incident tickets(Level 3) raised on 450+ across multiple domains(Cards, Loans, OLB, E-commerce, Deposits, GCIB, CIM - Customer Interaction Management etc.. on multiple platforms.
• Resolved thousands of abends from 450+ applications belong to multiple domains and platforms.
• SME in many business critical applications like Deposit data mining, EPAOM - Enterprise Pre-Approval Offers Management, Interaction management etc..
• Tuning and reviewing the performance metrics of the Production and User queries.
• Decommissioning of Redundant ecommerce ETL process, Unused Databases and Tables and dropping unnecessary production-work scratch tables had saved 23.72 TB space on Operation data Platform and analytical data platform.
• Worked in the project to analyze 25K datasets across 450+ applications for DASD space reclamation on production LPARs resulting in 216 TB of space savings amounting 1.4 Million USD/year.

Environment: Teradata RDBMS 12.0/13.10/14.10, BTEQ, FASTLOAD, MLOAD, XPORT, Teradata SQL Assistant, Teradata Administrator, Teradata Viewpoint, Mainframe, JCL and Autosys.

ETL /Teradata Developer

Confidential

Responsibilities:

• Perform analysis of existing code in mainframes to understand the mapping logics.
• Provide analysis with expertise in different technologies, business areas, application wide analysis and proposal of solutions.
• Coding using Teradata Analytical functions, BTEQ SQL of Teradata, format and execute the SQLs on Mainframe environment.
• Developed views based on user and/or reporting requirements.
• Performance tuned and optimized various complex SQL queries.
• Query and Index optimization and fine-tuning.
• Propose, and negotiate performance enhancement changes into data models, ETL workflows and BI reporting, by working with Data, ETL & BI architects.
• Application development that enables data moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Multiload, Fastload, Fast export, and BTEQ.
• Set up Automatic Email generation process after the stream completes.
• Coordinating with testing team for fixing QA and UAT Defects.
• Scheduling the jobs in CA-7/Autosys and monitoring its daily run in Production.
• Support the Applications and users until completion of warranty.

Environment: Teradata V2R6/12, Teradata SQL Assistant, SQL, Outlook, MLOAD, TPUMP, TPT, FAST LOAD, FAST EXPORT, Raw Data Loading (RDL) Tool ( Project Specific).