Objective:

Position as a Teradata DW/BI application Developer/Lead role.

Professional Summary

• Around 9 years of IT experience - high degree of proficiency dealing with RDBMS- Tearadata, MS SQL Server and DB2 in the areas of development/DBA. Sound knowledge of software development life cycle SDLC with substantial experience with object-oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.
• 1 year experience at Hanu Software Solutions USA as ETL Developer and SQL Server DBA.
• 6 months experience at CTS at Hyderabad, India as Teradata Lead.
• High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents.
• Experience in all aspects of analytics/data warehousing solutions Database issues, Data modelling, Data mapping, Data Analysis, ETL Development and data migration I have been key in delivering innovative database /data warehousing solutions to the Banking and Insurance Industries.
• Proficient in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC change data capture, Error Handling Techniques for ETL process.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load and TPUMP to export and load data to/from different source systems including flat files.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics.
• Excellent Experience with different indexes UPI, NUPI, USI, NUSI, JI and Collect Statistics.
• Proficiency in Data Modelling, Star Schema Modelling, Snow-Flake Modelling, FACT and Dimension Table design and Physical Data modelling implementations.
• Experienced in building Data marts, data structures, data storages, data warehouses, data archives, and data analysis.
• Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.
• Experienced in UNIX shell scripts to write wrapper scripts to call ETL Jobs
• Familiarity on Teradata Parallel Transporter TPT scripts.
• Well versed with Informatica 9.0.1 and DataStage 8.1 ETL Tools.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Experience in installation, Configuration, Maintenance and Administration of SQL server 2005/2008/2012.
• Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives RPO
• Responsible for disaster recovery processes. Well conversant in developing backup and disaster recovery plans for SQL server in Windows Azure Cloud.
• Experience with database availability, clustering, log shipping, and mirroring.
• 24 x 7 Production Database on Call Support.
• Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service SSIS .
• Completed LOMA 280 certification- principals of insurance
• Strong team player with good analytical skills.
• Good Communication skills, with emphasis on strong client relationships.
• Involved in Technical/ process related events. Demonstrated success in coordinating and mentoring development teams.

Technical Expertise

Databases:

Teradata V2R5, Teradata 12, Teradata 13, Teradata 14, MS SQL Server 2012, SQL Server 2005/2008 and DB2

Programming:

Teradata SQL, T-SQL, C, Java, COBOL, PL1

DBA:

database administration of MS SQL Server 2012, 2008, 2005

Operating System:

Windows 2008/2003 Advanced Server, NT Windows 9x, Linux

Other Software:

Windows 2008/2003 Advanced Server, NT Windows 9x, Linux

Tools:

BTEQ, MLOAD, FASTLOAD, FASTEXPORT, TPUMP, Informatica 9.0.1 and SSIS

Professional Experience

Confidential

Role: ETL Developer

Responsibilities

• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Transferring the data ETL to Data ware house by SQL Server 2005 Integration Services.
• Created dynamic and customized packages for ETL from various data sources using SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task and Send Mail task etc.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files.
• Created user databases, tables, indexes, and stored procedures.
• Worked on simple to complex SQL Queries and TSQL statements
• Designed and Implemented comprehensive Backup plans and disaster Recovery strategies.
• Created SQL Server logins and assigning roles and Authentication models as a part of Security.
• Worked on DR strategies and documentation of DR procedures.
• Provided 24x7 on call production support.

Confidential

Role: MS SQL Server Database Administrator

Responsibilities

• Responsible for the day-to-day administration, technical support, troubleshooting, maintenance, performance and overall health of MS SQL Server 2008 within a Microsoft Windows Server environment. Ensure high levels of data availability and reliability of the systems.
• Provided 24x7 on call production support.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Scheduled the backups for Databases and Transaction logs. Performed restoration operations. Suggested backup strategies.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Worked on simple to complex SQL Queries and TSQL statements
• Rebuilding the indexes at regular intervals for better performance.
• Involved in Disaster Recovery planning, testing and execution.
• Implemented log shipping as disaster recovery solution.

Confidential

Role: Teradata Database Lead

Responsibilities

• Lead the execution of the development pipeline and delivery of the code to QA, and ultimately Production
• Ensure that best practices for coding, architecture, and security are employed across the team consistently, and maintain responsibility for the quality development of the applications.
• Provide hands-on development and mentoring as necessary for other members of the development team.
• Designed the order of flow for the execution of the jobs and scheduling the jobs.
• Fine tuning of SQL to optimize the performance, spool space usage and CPU usage.
• Created proper Primary Index PI talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Worked on concepts involving different types of Indexes, Joins, and Spaces etc. for optimum performance of Teradata.
• Done Query optimization explain plans, collect statistics, Primary and Secondary indexes used volatile table and derived queries for breaking up complex queries into simpler queries.
• Streamlined the Teradata stored procedures.
• Build tables, views, UPI, NUPI, USI and NUSI.
• Worked with DBA's for transition from Development to Testing and Testing to Production.
• Responsible for migration and production support.
• Performing Data Validation and Reviewing the code developed
• Status tracking of project activities.
• Onsite - Offshore Co-ordination.

Confidential

Role: Teradata DW/BI Sr. Developer

Responsibilities

• Involved in requirements gathering and data gathering to support developers in handling the design specification.
• Preparing Technical Design Document
• Created, updated and maintained ETL technical documentation.
• Prepared Unit Test Specification Requirements.
• Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements.
• Extensive experience in writing and executing BTEQ scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MLOAD, TPUMP and FASTLOAD scripts.
• Designed/Developed scripts to move data from the staging tables to the target tables.
• Fine tuning of SQL to optimize the performance, spool space usage and CPU usage.
• Created proper Primary Index PI talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Familiar with concepts involving different types of Indexes, Joins, Spaces etc. for optimum performance of Teradata
• Write numerous BTEQ scripts to run complex queries on the teradata database.
• Created Mappings and scheduled Workflows using Informatica.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Reduced Teradata space used by optimizing tables adding compression where appropriate and ensuring optimum column definitions.
• Responsible for migration and production support.
• Wrote hundreds of DDL scripts to create tables, views and indexes in the company Data Warehouse.
• Created Global and volatile temporary tables to load large volumes of data into teradata database.
• Performing Data Validation and Reviewing the code developed
• Status tracking of project activities.
• Onsite - Offshore Co-ordination

Confidential

Role: Mainframe Developer

Responsibilities

• Involved in full project life cycle involving Requirement Analysis, Design, Coding, Testing and Implementation phases
• Involved in preparing the technical design documents and carrying out walkthrough meeting with the IT Business managers.
• Modified and tested COBOL and PL1 programs and JCL codes per the requests of business departments.
• Prepared Unit Test Specification Requirements.
• Analyze, Design, Develop test activities in PL1,CICS,DB2
• JCL job creation and maintenance.
• Performing Data Validation and Reviewing the code developed
• CA-7 job scheduling / ABEND resolution and JCL coding.
• Create JCL 'PROCs' cataloged procedures