Sreerekha Surapaneni

Contact: +1-602-***-****

Email: ac1b87@r.postjobfree.com

SUMMARY

•8+ Years of IT experience in Data Warehouse Architecture, design, software development, maintenance, implementation of Teradata data warehouses using Mainframes, ETL tool Informatica,SSIS And Microstrategy Reporting Tool.

•Worked for clients Wells Fargo, American Express and Qantas Airways.

•Extensively worked in Teradata, DB2, SQL Server Coding, Query tuning. Well versed with Teradata SQL tools like Teradata SQL Assistant.

•Extensively worked in various Teradata Client Utilities like Multiload, Fast load, Fast Export, Tpump and TERADATA administrator activities.

•Familiar with Team Foundation Server.

•Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

•Facilitated at requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.

•Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

•Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

•Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation

•Familiar in Creating Secondary indexes, join indexes, SQL Tuning, Optimizer, Indexes and Table partitions in Teradata.

•Database backup and recovery strategy, database performance and tuning and SQL Code Optimization.

•Familiar with Teradata Tools and Utilities including DBA Tools like Teradata administrator/Teradata Manager/ARCMAIN/SQL Assistant/Teradata performances monitor (PMON) and DBQL for performance tuning and Autosys for scheduling the jobs in sql server environment.

•Familiar with User Management Activities such as creating users, granting permissions, creating pool space, moving space from one DB to other.

•Worked on Performance Monitoring to Fine tune Teradata database for optimum performance.

•Familiar Query Tuning and Optimization to remediate slow running queries by using various query optimization techniques (primary indexes/stats/joins/skew elimination…, etc) and tools (PMON).

•Familiar with Capacity Planning in determining database Perm, Spool and Temp Space. Allocating and moving space between Teradata databases/users using Teradata administrator. Creating roles, granting/revoking permissions using Teradata administrator/Teradata SQL Assistant.

•Familiar with Teradata database set-up/back-up and day-to-day maintenance for table implementations, maintenance and back-up (using ARCMAIN). Creating or Replacing Teradata databases, users, tables, rights, views, stored procedures, joins, indexes and macros.

•Worked on onshore-offshore model for 7 years.

•Extensively worked on PMON, Teradata viewpoint and TASM tools for monitoring the sessions and workload management

•Extensively worked on DBC tables.

•Have strong experience in Data warehouse Development phases and processes like Transformation Views creation, Macros creation

•Very Good knowledge of full life cycle design (SDLC) and development for building Data Warehouse.

•Developed Mappings using various transformations like connected/unconnected Lookups, Filters, Aggregators, Update strategy, Routers, Joiners depending upon requirement to implement business logic to load the data from staging table to the target database.

•Knowledge in DataModelling and creation of Star Schema and Snowflake Schemas.

•Proficient in understanding business processes / requirements and translating them into technical requirements.

•Extensive experience in performing complex analysis and resolving complex issues.

•Technology forte is TeradataV2R6.2/V2R12.

•Advanced expertise in Teradata Application Utilities and Database Administration Utilities viz., BTEQ, Teradata SQL Assistant, and Teradata PMON.

•Experienced in trouble-shooting techniques, tuning SQL statements, Query Optimization, Dynamic SQL and Materialized Views.

•Technical expert in the areas of relational database logical design, physical design, and performance tuning of the RDBMS Excellent in performance tuning in Teradata.

•Sound Knowledge about Indexes (JOIN Indexes, Primary Indexes and Secondary Indexes) and other features of Teradata.

•Sound Knowledge of Data Warehousing concepts, E-R model & Dimensional modeling (3NF), like Star Schema, Snowflake Schema and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.

•Strong Technical Writing and user documentation Skills.

•Experience in creating and handing PPI, UPI, NUPI, NUSI and USI.

•Worked extensively in Mainframe Technologies JCL and PL/1.

•Having working knowledge in Database DB2.

•Technical knowledge on Bigdata Technologies.

•Highly motivated team player with excellent communication, presentation and inter personal skills.

CERTIFICATIONS

•IBM Certified Database Associate for DB2 UDB v8.1 Family.

•IBM Certified Application Programmer for DB2 UDB v8.1 Family.

EDUCATION

Bachelors of Technology from JNTU, in Computer Science and Engineering

TECHNICAL SKILLS

Operating System: WINDOWS 7/ XP, WINDOWS 2000, MVS, Z/OS, UNIX

Concepts: Data Warehousing

ETL Tool : Microsoft Visual Studio 2008,MS Sql Server 2008,Datastage 7.1.5 A,toad for oracle and Informatica Power Centre 9

Applications: TPT Engine, Teradata Manager, PMON, Teradata viewpoint, TASM, Teradata Utilities, SQL,TOAD

Assistant

Development: SSIS,Mainframes,SAS

Databases: Teradata 14,13.10,12 Teradata V2r6, DB2,Sql server,Oracle

Languages: JCL, PL1

Packages: Ms Office (2000 / XP)

Vertical: Banking,EIM, Airlines

PROFESSIONAL EXPERIENCE

Client: Wells Fargo, Phoenix,USA Jun ’13 –Dec '14

Project: Home Lending Business Intelligence

Role: Database Analyst

The Project READR DATAMART handles data from different Integrated database environments and acts as an intermediatary database for Microstrategy Reporing for the end business users . It includes all the usable/re-usable components, component design, data migration strategy, external interfaces and program level specifications for this project. Currently, data is stored in multiple Teradata and Sql Server database systems

Responsibilities:

•Converted Consent for Credit project from SAS to SSIS and Teradata.

•Had experience working with Teradata, including experience creating tables, views, indexes.

•SQL Server Integration Services experience

•Relational database development experience (e.g., normalization, referential integrity, modeling).

•Demonstrated mid-level development of databases, need to have an ETL background and worked with ETL tools

•Experienced in Performance Tuning

•Demonstrated ability to quickly learn, retain, and apply good interpersonal skills, and perform effectively under time pressure.

•Proven ability to identify problems, analyze possible solutions, and determine best course of action to resolve.

•Proven ability to troubleshoot and trace data related issues throughout the architecture.

•Ability to multi-task working on requests, supporting UAT database environment and working on projects.

•Strong inter-personal, consulting, and business partner management skills.

•Technical production support experience and performs all the DBA operations.

Environment: Teradata 13.10 (SQL Assistant, FastLoad, MultiLoad), SQL Server 2008, Unix, WINDOWS 7/XP,SQL SERVER INTEGRATION SERTVICES.VIEW POINT,SAS

Client: AMERICAN EXPRESS, Phoenix, USA Jan ’13 –May’13

Project: IDN DBO Warranty

Role: Technical Lead

The Project Amex IDN DWX data migration/Datapush support is about Sybase to Teradata Transformation of the existing Sybase Databases (IQP0; IQA0; IQC0) to Teradata (6650 and 1650) databases. It includes all the usable/re-usable components, component design, data migration strategy, external interfaces and program level specifications for this project. Currently, data is stored in multiple Sybase ASE and Sybase IQ database systems. Data stored in Sybase IQ is planned to be migrated to Teradata systems in multiple waves and will be divided into three key groups: Hot, Warm and Cold. The Hot data, warm data and cold data may reside in the same Teradata system. The Teradata Disaster Recovery tool ‘Datamover’ is automation and tools for data recovery and archiving.

Responsibilities:

•Data migration from existing IQC0/ColdQ environments (required for full width rows)

•Inventory and categorization of all tables into patterns like Append,Double delete,Backward Dedupe,Forward Dedupe,Onetime Load,Custom etc.,

•Design, development and testing of processes to extract, move and load data into Teradata environment

•Converting Stored procedures from SYBASE to Teradata.

•Coordination of synch between data migration and ELT turn-on in production

•Validation/testing of migrated data

•Data gap analysis between the difference instances of the same data in IQA0 and IQP0. The same source file could be loaded and transformed by difference processes into the production environment and warehouse resulting in different data. The current assumption is that the only difference is the depth of the data but this need to be confirmed. Analysis will validate this assumption or identify additional discrepancies and resolutions.

•Data migration from existing IQP0 database - DBO schema

•B2B Stored Procedures in IQP0 DBO schema

•Custom Load Stored Procedures in IQP0 DBO schema

•Join map analysis of application to determine need for indexes

•Fixing the tech excel tickets,QC tickets and moving the table changes to Production

•Load unit test results to quality center

Environment: Teradata V2R14 (TPT Engine,BTEQ, SQL Assistant, FastLoad, MultiLoad), Unix, WINDOWS XP/2000, PMON

CLIENT :QANTAS AIRLINES LTD, Australia (www.qantas.com.au) Sep ‘10 – Apr‘12

Project : Renumbering

ROLE: Teradata & Mainframe Technical Lead

This project was to change the system in order to accommodate the increased size of the existing customers’ Frequent Flyer ID’s. This was undertaken keeping in mind that the existing FF ID’s could become exhaustive. Completely coordinated offshore efforts in the project and provided expert advice wherever CMI Application specific knowledge was demanded.

Responsibilities:

• Involved in working out the cost and effort of the project and designing work orders.

• Developed and modified the SQL queries based on the client requirements.

• Involved in design, development, testing, documentation, client sign-off, and implementation of the Project.

• Defining and setup of what test data is required to meet the business user needs.

• Designed and developed scripts to load data into staging area mostly using FASTLOAD/BTEQ loads.

• Designed and Developed transformation scripts to load data into core area using BTEQ/MLOAD.

• Worked on loading of data from several flat files sources using Teradata Fast Load and MultiLoad.

• Writing Teradata SQL Queries to join or any modifications in the table.

• Transfer of large volumes of data using Teradata Fast Load, MultiLoad and T-Pump.

• Fined tuned the existing mappings and achieved increased performance and reduced load times for faster user query performance.

• Sorted data files using UNIX Shell scripting.

• Involved in design, development, testing, documentation, client sign-off, and implementation of the Project.

• Written Teradata BTEQ scripts to implement the business logic.

• Hands on with Teradata Queryman to interface with the Teradata.

• Built Test cases and Templates to do this process on a repeated basis.

• Multiple templates are designed and built for various table data updates.

• Developed BTEQ scripts to extract data from the detail tables for reporting requirements.

Environment: Teradata V2R12 (BTEQ, SQL Assistant, FastLoad, MultiLoad), WINDOWS XP/2000, Z/OS, JCL, PL/1 and DB2, PMON

CLIENT : QANTAS AIRLINES LTD, India (www.qantas.com.au) Oct ‘09 – Jul ‘10

Project: Woolworths

ROLE : Teradata Developer / Performed DBA Activities

• The project involved Qantas-Woolworths partnership to enable Woolworth’s customers gain Qantas Frequent Flyer points on transaction with Woolworths. The project was also to address the extra volume of transactions resulting out of this deal. Besides being involved in the design phase, led a team of 3 successfully in the volume aspect of the project.

Responsibilities:

• Involved in working out the cost and effort of the project and designing work orders.

• Involved in creation of new Woolworths databases from scratch and created the new users and objects.

• Involved in performance tuning of queries to improve the query running time.

• Involved in team study of various source system data models and coming up with probable database objects in Teradata.

• Designed and developed scripts to load data into staging area mostly using FASTLOAD/BTEQ loads.

• Designed and Developed transformation scripts to load data into core area using BTEQ/MLOAD.

• Developed and modified the SQL queries based on the client requirements.

• Involved in design, development, testing, documentation, client sign-off, and implementation of the Project.

• Resolved multiple data issues coming from the various source systems. These data cleansing issues helped in accurate final reports.

• Developed various Mappings and Transformations using Informatica Designer

• Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center and Power Mart.

• Responsible for requirement gathering, dimensional modeling of several subject areas

• Creating Database Objects (Databases, Users, Tables, Views and Macros) in TEST and DEV.

• Assigning Database Space and Spool spaces to Databases and Users in TEST and DEV.

Environment: Teradata V2R6 (BTEQ, SQL Assistant, FastLoad, MultiLoad), WINDOWS XP/2000, Z/OS, JCL, PL/1 and DB2, Teradata Viewpoint and TASM

CLIENT : QANTAS AIRLINES LTD, India (www.qantas.com.au) Sep ‘08 – Apr ‘09

Project : Divides

ROLE : Teradata & Mainframe developer & Technical Lead

The project objective was to merge different travel plans into one BASE travel plan to facilitate accurate summaries of Passenger travels. Was the only member chosen in CMI in a team of 3 and achieved the target in record time of 1 month only.

Responsibilities:

• Involved in working out the cost and effort of the project and designing work orders.

• Developed and modified the SQL queries based on the client requirements.

• Involved in design, development, testing, documentation, client sign-off, and implementation of the Project.

• Design and Development of load programs to load Data into Teradata using MLOAD, FLOAD, BTEQ, Fast Export and TPUMP.

• Resolving Data and Process issues on an ongoing basis while loading data from various sources.

• Creating Databases, Users, Tables, Views and Macros on Test and QA Teradata Systems.

• Meeting with source owners to understand the nature and volumes of data.

• Developed Backup/Archive and Restore strategy and creating the jobs using ARCMAIN.

Environment: Teradata V2R6 (BTEQ, SQL Assistant, FastLoad, MultiLoad), WINDOWS XP/2000, Z/OS, JCL, PL/1 and DB2, PMON

CLIENT :QANTAS AIRLINES LTD, India (www.qantas.com.au) Mar ‘08 – Oct ‘08

Project : Triton

ROLE : Teradata & Mainframe Developer cum lead

Worked for reconciliation of check-in information in CMI from various reservation systems.

I was the lone representative from CMI perspective.

Responsibilities:

• Involved in working out the cost and effort of the project and designing work orders.

• Developed and modified the SQL queries based on the client requirements.

• Involved in design, development, testing, documentation, client sign-off, and implementation of the Project.

• Involved in team study of various source system data models and coming up with probable database objects in Teradata.

• Designed and developed scripts to load data into staging area mostly using FASTLOAD/BTEQ loads.

• Designed and Developed transformation scripts to load data into core area using BTEQ/MLOAD.

• Resolved multiple data issues coming from the various source systems. These data cleansing issues helped in accurate final reports.

• On a weekly basis created a set of Sandbox databases, UserIDs with Spool space to be used by the analysis reporting users.

Environment: Teradata V2R6 (BTEQ, SQL Assistant, FastLoad, MultiLoad), WINDOWS XP/2000, Z/OS, JCL, PL/1 and DB2.

CLIENT : QANTAS AIRLINES LTD, India (www.qantas.com.au) Jul ‘07 – Jan ‘08

Project : Golf

ROLE : Teradata & Mainframe developer

Worked in the path-breaking concept of introducing Premium Economy cabin class in Qantas other than the existing First class, Business and Economy class. Managed SIT from the Service Provider side and coordinated with Client for successful implementation.

Responsibilities:

• Involved in working out the cost and effort of the project and designing work orders.

• Developed and modified the SQL queries based on the client requirements.

• Involved in design, development, testing, documentation, client sign-off, and implementation of the Project.

• Design and Development of load programs to load Data into Teradata using MLOAD, FLOAD, BTEQ, Fast Export and TPUMP.

• Resolving Data and Process issues on an ongoing basis while loading data from various sources.

• Creating Databases, Users, Tables, Views and Macros on Test and QA Teradata Systems.

• Meeting with source owners to understand the nature and volumes of data.

• Developed Backup/Archive and Restore strategy and creating the jobs using ARCMAIN.

• Interacted with technical and business analyst, operation analyst to resolve data issues

• Analyze the current data movement process and procedures.

• Used Data profiler to allow the analysis of data directly in the database, which improves performance, while eliminating the time and costs of moving data among databases.

• Identify and assess external data sources as well as internal and external data interfaces

• Created and updated MS Excel mapping document by doing field level analysis and field mapping.

Environment: Teradata V2R6 (BTEQ, SQL Assistant, FastLoad, MultiLoad), WINDOWS XP/2000, Z/OS, JCL, PL/1 and DB2.

CLIENT : QANTAS AIRLINES LTD, India (www.qantas.com.au) Mar ‘06 – Mar ‘12

Applications : Qantas Application support on GDP Frequent Flyer, Customer Management information, Corporate Data Warehouse and Group Schedule Inventory

ROLE : Teradata & Mainframe lead cum developer

Application GDPFF (GDP Frequent Flyer)

GDPFF deals with Frequent Flyer Information and generating accrual, accrual hand back, retro, retro hand back, top tier and billings files with the traveled information and exchanges those files to/from profile and partner airlines via GDPFF. And is a pivot in the Loyalty Business. Profile also stores data at the Passenger, Bookings, Revenue and Flight level from the corresponding source systems and its acts a administrative system for awarding frequent flyer points to Frequent Flyers.

Application CMI (Customer Management Information)

CMI deals in earn and burn points of Frequent Flyer Information and generating campaigns for business. And is a pivot in the Loyalty Business. CMI also stores data at the Passenger, Bookings, Revenue and Flight level from the corresponding source systems. Was involved in 24/7 support. Besides, my work in CMI involved, solving problem tickets and severity issues working on service requests, communicating with interface systems to solve mutual problems, delivering Work Orders as part of Enhancements. Coordinating with Onsite/Off-shore for transferring the knowledge on Application and process.

Adhered to the process and contractual obligations by attaining proficiency in managing tool ESM.

Application CDW (Corporate Data Warehouse)

It’s the Bookings and Traveled Warehouse of Passengers. Worked in solving one highest level of severity issue and supported application for a brief period. And even while in CMI, coordinated with CDW.

Application GSI (Group Schedules Inventory)

GSI, a central corporate database of all flight Schedules (Operated, Allocated or scheduled). Worked with team here in resolving highest severity production issue. Worked as application SPOC for a brief period, managed major Outage, coordinated System Integration testing with client for project GOLF from GSI perspective (GSI was most prominently impacted). Transitioned applications knowledge before moving out to CMI.

Responsibilities:

• Involved heavily in writing complex SQL queries based on the given requirements.

• Created a generic email notification program in UNIX that sends the emails to the production support team if there are any duplicate records or error in load process.

• Created a BTEQ script for pre population of the work tables prior to the main load process.

• Performance tuning of complex queries and deriving Archival and purging strategies.

• Involved in creation of Database, DDL, DML, VIEWS and MACROS for loyalty environment

• Used FastLoad for loading into the empty tables.

• Used volatile table and derived queries for breaking up complex queries into simpler queries

• Conducted daily meetings with team and Business users to know their issues and provided resolutions.

• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc.

• Created Users, Databases, and Profiles and Assigning the Roles.

• Issues resolution and presented many issue resolutions with Business users

• Gathered Requirements and the reporting issues from the End user

• Developed data mappings between source systems and warehouse components

• Analyzed Business requirements from the clients.

• Extensively involved in Data Extraction, Transformation and Loading from Source to target systems.

• Loading of Teradata Tables through batch jobs (using utilities like Bteq, MLoad and fast export).

• Preparation of Technical Specifications as per client’s business standards.

• Participating in client meeting & calls, gathering requirements and analyzing specifications.

• Working out the cost and effort of the project and designing work orders.

• Involved in design, development, testing, documentation, client sign-off, and implementation of the Project. Coordinating onsite and offshore effort for the same.

• Review of work orders and deliverables.

• Manage, coordinate business-as-usual activities.

• Suggest, coordinate and work on various Service Improvements and Proactive initiatives.

• Preparing progress reports and Forum slides for Client presentations.

• Attending periodical Status Meetings with the client and third parties to resolve outstanding issues and discuss future assignments and endeavors. Giving presentations.

• Working on multiple medium and high severity tickets arising out of technical and functional bugs.

Environment: Teradata V2R6 (BTEQ, SQL Assistant, FastLoad, MultiLoad), WINDOWS XP/2000, Z/OS, and Erwin 4.0, JCL, PL/1, DB2.

Contact this candidate