Data Project
Resume:
SANDEEP KETHAMREDDY
****************@*****.***
Summary:
Over 7 years of experience in IT industry as a Designer, Developer and as an Analyst in
the development of data warehousing solutions.
Strong expertise with SQL Assistant and Teradata utilities including BTEQ, MLOAD,
FASTEXPORT, FASTLOAD and TPUMP.
Solid Experience in developing strategies for Extraction, Transformation and Loading
(ETL) mechanism using Ab Initio and Informatica.
Expertise in data modeling techniques (Creation of Dimensions, Cubes and Fact tables).
Solid Experience in UNIX Shell Scripting, Perl Scripting and PL/SQL Programming
(Stored Procedures, Functions and Triggers).
Extensive experience in Software Analysis, Testing, Design, Development and
production Support in Data Warehousing using Oracle 8i/9i, MS SQL Server and DB2.
Possesses experience in development of Client/Server applications using VC++, Oracle,
SQL Server, and MS Access.
Experience in designing ER diagrams using ERWIN tool.
Experience in generating various complex reports using Cognos Impromptu and Cognos
PowerPlay.
Working knowledge of change control procedures, and demonstrated ability to build
and execute test plans.
Possesses strong analytical and excellent communication skills.
Has the ability to work well independently, as well as in a team environment.
Education:
Master of Science in Computer Science, Texas A&M University, Commerce, Texas
CERTIFICATIONS:
.Teradata certified master V2R5
Data warehousing Skills:
ETL Tools : Ab Initio, Informatica
Data Modeling : ERWin Platinum 4.0/3.5.2.
Databases : Teradata V2R4/V2R5/V2R6, Oracle 9i/8.X/7.X, SQL Server6.5/7.0/2000,
DB2 and MS Access 2.0/7.0/2000
Technical Skills:
O/S : Windows XP/2000/NT/98/95, Sun Solaris7.0/8.0, UNIX and MS DOS.
Languages : SAS, C, C++, XML, Assembly (MASM, TASM), UNIX Shell Scripting, Perl
Scripting, SQL, PL/SQL.
Web Tools : Front Page, Dream Weaver and HTML.
Database Tools : MySQL, Erwin, SQL Navigator and SQL*Loader and Toad.
Hardware : IBM, Macintosh, Sun Workstations (SunOS, Solaris).
Version Tracker : PVCS, Harvest, CVS
Professional Experience:
Client: Capital One, Richmond, VA Nov07- Present
Role: ETL Teradata developer/DA analysis
Environment: UNIX, TeradataV2R6.1, SAS, Teradata SQL assistant 7.1, Brio, IFM Campaign tool,
Control_M, ab initio1.14
Project Summary: Working on a data warehouse project to build customer-level data marts for
analytical purposes for Capital One in small business team. SB team launched three new
products- Back to Business Payroll, No Hassle Card Processing and Business Money Market
targeting Small Business Owners. Data analyst solutions were developed for carrying out
solicitations using Small Business Prospect Pool and responses were attributed to different
channels for analysis. I am currently partnering with the IT team for productionizing the DA
solution.
Responsibilities:-
Developed data requirements working with the business and the external vendors
Data loading solutions were developed in UNIX using Teradata utilities like fast load
and TPump for loading vendor files from Epsilon, COMS, Paycycle, Sales force and
Capital One Bank
Data and File validations using PERL script and carried out automation of loads using
CtrlM scheduler jobs
Developed source-target mappings and design documents.
Performed performance tuning of the existing SQL
Export Import scripts for flat file manipulation in UNIX
Developed Teradata scripts for data analysis, reporting, table compressions, container
space management
Worked with the Compliance team to developed CIP reports for Payroll product
Worked on a monthly basis with CFA IFM to carry out multi product multi channel
campaign segmentation through Statement, Email and DM channel
Create and Maintain Teradata Databases, Users, Tables, Views, Macros and Stored
Procedures using Teradata SQL Assistant (Queryman), SQL DDL, SQL DML, SQL DCL,
BTEQ, MLoad, Fastload, FastExport, TPUMP, Statistics Index and Visual Explain
Completed Teradata Masters certification.
Client: Walgreens, Chicago, IL Apr07- Nov07
Role: ETL Teradata developer
Environment: Ab Initio (1.14),EME Co-operating System (2.14), UNIX, TeradataV2R5.1,Teradata
SQL assistant 7.1, CVS, ESP
Project Summary: Gross Profit Modeling (GPM) is a client-based application which assists
Walgreens in analyzing Gross Profit of Brand and Generic drugs, by changing multiple pricing
and/or utilization factors. It also aid in presenting potential client savings during contract
negotiations.
Responsibilities:-
Worked with clients and process owners to translate business requirements into
technical specifications
Established and defined details, definitions, and requirements of applications and
components
Generated design, development and test plans, detailed functional and technical
specification documents, and process flow charts for execution of programming
Followed the established SDLC methodologies for the application development
Developed mappings to format and move the data from Teradata staging area to
intermediate tables using Teradata loader utility MLOAD
Developed UNIX Shell and BTEQ scripts to implement transformations and load the data
from intermediate Teradata tables to Teradata target tables
Performed performance tuning of the existing graphs.
Developed new complex graphs for GPM 1.2 release.
Identified and Resolved existing production issues.
Helped SA's and DB admins to set up UAT environment.
Implemented Teradata fastpath techniques in loading, updating and deleting.
Performed GPM Real Time Response Analysis by developing and Testing adhoc scripts
and adhoc sql.
CVS is used for version controlling
ESP is used for job scheduling mechanism.
Utilized several teradata utilities such as Multiload, FastExport, Fastload, Tpump and
BTEQ.
Involved in the migration to new ab initio batch server.
Client: Capital One, Richmond, VA Jan06 – Apr07
Role: ETL Application Designer/Developer
Environment: Ab Initio (1.13.27),EME, Co-operating System (2.13.1), TeradataV2R4,V2R5.1, UNIX,
Control-M, Clear quest and Windows XP.
Project Summary: The purpose of this effort is to implement the project, collectively known as
Capital One Joint Interface Development Factory (JIDF) for the cardholder system replacement
program (“Helix”).
The primary goal is to develop batch interfaces associated with the movement of data files
between existing systems, external vendor Total Systems Inc (TSYS) and the Data Distribution
Environment (DDE). The scope of Data Distribution Environment is limited to the movement of
data from source systems to target systems. Helix will move data through the DDE to/from
Total Systems Inc., (TSYS) using the DDE for a landing zone to place and retrieve data files. The
wrapper scripts for execution of these graphs were developed using korn shell.
Responsibilities:
Designed no. of Technical Design Document for the Terada BTEQ scripts Which populates
data from BI Staging to BI Base Tables.
Played a major role in setting up different regions - Testing, Integration, Performance,
Break fix and Production environment with the Wrapper scripts
Setup and folder structure for Teradata scripts to run in UNIX environment.
Designed more than 150 BTEQ Scripts from Scratch which populates the Teradata Fact,
dimension and lookup Tables.
Organised a team of Developers to Develop, Unit Test, Test cases and Result
Preparation Related with Loading Scripts and other deliveries related with Teradata
scripts.
Interacted with System Test, Integration Test, Performance Test, User Acceptance
test, Production dry run teams to solve the various stages of Defects and provided
solutions to their Road blocks.
Designed and Developed the Common Audit and Error Routines for BTEQ
Scripts, which is implemented to all Teradata related interfaces.
Involved in finding the root cause of the Defect in Testing,Integration, Performance
,Break fix and Production and Report related issues and provided appropriate solutions
with quick turn around time.
Solved Various Defects in Set of Wrapper Scripts which execute the Teradata
BTEQ,MLOAD,FLOAD utilities and Unix Shell scripts.
Developed various graphs involving multiple sources and targets with complex data
transformation logic.
Used various generic graphs to perform file validation, field validation and ftp of input and
output files.
Followed DDE Standards like naming standards for dmls, wrapper scripts and xfrs.
Created various production support documents for L3.
Insuring reliability and recovery capabilities for the complex multi-graph systems
developed.
Supported Helix events 24 x 7, by monitoring the jobs and by providing support to recover
failed applications.
Control-M is used for job scheduling mechanism.
Clear Quest is used for defect management.
Client: Texas A & M University, TX Aug03- Jul05
Role: Web developer/Graduate Assistant
Environment: Front Page, Dream Weaver, Flash, Firework, XML, SQL Server6.5/7.0, Oracle8.x, and
WindowNT.
Project Summary: Responsibilities include designing new web pages and modifying existing
pages for university purposes. HTML and JSP pages are designed depending on the requirement
given.
Announcements
This Application is done to help the University and all the Departments to keep up with the
Daily announcements. The students can view the announcements posted by the Department.
Administrator can post, update and delete announcements.
Office for Advancement
Designed and developed Office for Advancement WebPages for Texas A&M University-
Commerce.
Schedule of Classes
Designed and developed Schedule of Classes WebPages for Texas A&M University-
Commerce. These pages help students of the University to check for class schedule for
each semester.
Department of Residence life
Designed and developed Department of Residence life WebPages for Texas A&M
University-Commerce. Fireworks, Photoshop are used to edit images.
VPAA
Designed and developed VPAA WebPages for Texas A&M University-Commerce. Dream
Weaver is used as a tool for web designing. Fireworks, Photoshop are used to edit
images.
Pride Online
Designed and developed Pride Online WebPages for Texas A&M University-Commerce.
The web pages are developed in HTML. Dream Weaver is used as a tool for web
designing. Fireworks, Photoshop and Adobe Illustrator are used to edit images.
Undergraduate Catalog
Designed and developed Undergraduate Catalog for Texas A&M University-Commerce.
Dream Weaver is used as a tool for web designing. Fireworks, Photoshop are used to
edit images.
Client: Satyam, INDIA June01-Jul03
Role: Data Warehousing Analyst
Environment: Ab Initio, Business Objects, BO Designer, ERWin, XML, DB2, SQL Server2000,
Oracle8.x, UNIX and Windows2000.
Project Summary: Involved in design, development and maintenance of Data Marts. We have
extracted data from different data sources using Ab Initio. We have also created different Data
Marts to answer different query reports using Business Objects.
Responsibilities:
Created various Complex Graphs between Source and Target using GDE.
Developed Unix Shell scripts to create customized components.
Worked with multi-file data to achieve parallel processing.
Modified Ab Initio components to achieve data parallelism for the enhancement of
overall performance.
Queries are optimized to improve the performance.
Wrote Specs to populate repository.
Imported an XML file, used in the mappings and exported into an XML file.
Used Web browser to see the output of the XML files.
Participated in data design efforts and communicated with data analyst and DBAs.
Testing all stages of warehouse development and deployment life cycle.
Contact this candidate