Resume

Sign in

Teradata Technical Architech

Location:
United States
Posted:
September 09, 2008

Contact this candidate

Resume:

SAURABH AGRAWAL

********@*****.***

334-***-****

Experience Summary

Project Management:

• Involved in estimation, preparation of SOW, Project Plan for the various projects under Finance/Insurance Domain.

• Tracking of project plan dates and working aggressively to meet those dates to meet all the underlying SLAs.

• Communication/Project co-ordination with remote/offshore component of team.

• Sharing project status with higher management and customer

• Capacity planning, Resource planning and management.

Technical:

• Certified Teradata Master Professional.

• Eight years of professional experience in complete Software Development Life Cycle (SDLC) with Analysis, Design, Data Modeling, Development, Integration, Implementation, Maintenance, Testing, Production Support of Software Applications in Data warehousing Environment in conjunction with various other Source systems including Legacy (Mainframe) Environment.

• Expert level skills on MLOAD, FLOAD, BTEQ, JCL, Teradata V2R5/V2R6 SQL, Informatica Power center 7.x/8.x to perform client side operations.

• Extensive work in ETL process consisting of data transformation, data validation, data sourcing, mapping, data conversion and loading.

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

• Proficient in Data Architecture in Teradata Data warehousing environment.

• Extensively worked with large Databases (40TB) in Production environments.

• Data Processing experience in designing and implementing EDW, mainly transformation processes using ETL tool informatica Power Center.

• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of source system.

• Extensive experience in implementation of transformations, Scripts and execution of test plans for loading the data successfully into the targets.

• Well Versed in Informatica Power center 6.x/7.x/8.x, Teradata V2R5, Mainframe Technologies, VBA.

• Worked extensively on Logical/Extended Logical and Physical Data modeling. Good working knowledge of ERwin 7.1.

• Exposure and implementation of Pushdown optimization,UDF and Dynamic partitioning features of Informatica Powercenter 8.x.

• Working extensively on Windows 95/98/2000/2003/XP, Mainframe OS390 and UNIX platforms

• Exposure to Data Mapping/Modelling for datawarehousing and Acquisition/Conversion related tasks.

• Thorough understanding and good practical knowledge of creating, managing and using database object like User, Database, Views, Macros, Index.

• Exposure to Unix Shell scripting.

• Key Skills: Team building, leadership, client communication, requirement analysis, prototypes, data modeling, design, development, build and release.

• Experience in Software Development Life Cycle (SDLC) – including functional specifications, analysis, design, programming, testing, implementation and maintenance.

• Extensive experience in writing Functional specification and technical design documents with excellent written and communication skills

• Excellent troubleshooting skills & good written and verbal communication skills.

• Create standards, guidelines for data modeling and ETL processes.

• Preparation of Requirement Analysis document, Technical design document

Technical Skills:

Programming Languages: COBOL, VBA

Databases: Teradata V2R5/V2R6, IDMS (Mainframe), MS Access, Oracle 9i

Tools: Informatica PowerCenter 6.x/7.x, ERwin 7.1, SQL Assistant, MLOAD, FLOAD, BTEQ, Fast EXPORT, ERwin 7.1, Mainframe Utilities

Operating Systems: MS Windows 2000/NT/XP/2003, UNIX

Education & Certification:

 Bachelor of Engineering in Civil Engineering – Govt Engineering College, Raipur (Now NIT Raipur) – INDIA

 M.Tech in Transportation Systems Engineering – Indian Institute of Technology, Kanpur - India

 Teradata Certified Master V2R5

Business Area: Under Leasing Finance domain I worked in following area:

• Acquisitions & Integrations

• CALC, Collections, Assignment, Letters, Comments, Litigation.

• PMS - Portfolio Management System

• Account Receivables

• Account Payables

• Invoicing

• Usage Based Billing

• Cash Management

• Data Mapping and Business Reporting

• Actuarial Multivariate Analysis for Insurance sector

Experience:

ALFA Insurance (Alabama Farmers Insurance)

Assistant Project Manager/Teradata Technical Architect

ALFA Insurance BI Program(Apr ‘08 – to – Date)

ALFA is in the process of establishing the framework, technology, infrastructure, and business processes required to transform their enterprise data into actionable information which should significantly impact their decision making ability as a company at multiple levels. ALFA BI program’s main initiative is to effectively join the data from disparate systems (insurance, loans, claims, financial, human resource, and others) with external data (demographic, geographic, etc) and enable various areas (underwriting, actuary, marketing, claims, etc) of ALFA Insurance to effectively make decision in support of ALFA’s mission and visions.

Responsibilities:

• Actively involved in Source system study, Infrastructure recommendation

• Requirement study of the business and data architecture including conceptual/Logical data modeling and Physical data modeling

• Involved in finalizing Teradata Database Architecture for BI Program

• Conducted training on Datawarehousing and Teradata for managers.

• ETL design architecture for all the ETL processes

• Involved in estimation, preparation of SOW, Project Plan for the various projects.

• Create standards, guidelines for data modeling and ETL processes.

• Preparation of Requirement Analysis document, Technical design document

• Tracking of project plan dates and working aggressively to meet those dates.

• Communication/Project co-ordination with remote/offshore component.

• Resource management, capacity planning

Release3B EDW Development(Dec ‘07 – to – Mar ‘08)

This project is part of a big initiative by GAP Inc termed as SII (Systematic Inventory Initiative). The idea here was to retire existing legacy system which at present is supporting all the Merchandise planning and related areas to support Gap Inc’s various sub-businesses. Release3B is meant for In-Season planning. The project has been logically grouped into various Interfaces. Each interface consists of various processes which in turn is translated into ETL components. The team is responsible for development and deployment of ETL software for the Teradata Datawarehouse.

Responsibilities:

• High level design and documentation of Teradata ETL architecture.

• Participation in meeting with business to understand the functional/reporting requirement of the BI application and converting the Business needs into the technical documents.

• Performance tuning of the Teradata ETL application.

• Reviews and Signoff activity all the Teradata application deliverables.

• Offshore team co-ordination and client communication.

• System test support.

• Configuration management/Change Management of the ETL components.

• Understanding reporting requirement and setting up environment for same (Creating Views, Join indexes etc)

• Actively involved in Migration/shakeout/Testing/Review/signoff of the deliverables.

• Proposal for best Teradata utility (Among BTEQ, MLOAD, FEXPORT etc) for the load based on the business requirement and turn around time.

• Actively participated in the data modeling meetings and made proposals that may significantly improve the performance of the overall ETL applications.

GE Commercial Finance, Danbury CT

ETL Technical Architect/Analyst/Lead

Teradata EDW Development(Feb ’05 – to – Nov ’07)

This project is an initiative for migrating GE Comfin’s existing EDW from Oracle to Teradata. The team is responsible for Development and Deployment of ETL software for TD EDW. In last 3 years I have been involved in end to end design of ETL application for various sub-businesses within GE Commercial Finance. Few major projects under this are listed below:

a. Release 1: This project got its name from the fact that it was first sub-business within GE Commercial finance to go in Teradata EDW. In this project I started as supporting hand in data modelling activities. Later I got involved in ETL development.

b. Consistency Phase1: This project was initiated to define about 28 business application under single definition. About 65 business parameters were identified to make them consistent across business in phase1. From this project onwards Informatica was chosen as ETL tool.

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica, Teradata.

• Involved in the analysis, design and development of all the interface’s using Informatica Powercenter tools in interface team and interfaced with all the other tracks for business related issues.

• Used Debugger to test the mappings and fix the bugs.

• Created mappings to move from Various Systems (CRM, OLTP) to EDW Stage/Core database.

• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.

• Created, updated and maintained ETL technical documentation.

• Actively involved in Data Modelling/Mapping activities for Portfolio Management System

• Developed MLOAD, FLOAD and Fast EXPORT for loading data from Mainframe to Teradata Staging area.

• Developed Informatica Mappings/Workflows for loading data to Teradata.

• Performance tuning of the mappings/sessions/workflows.

• Implementation of UDF and Pushdown Optimization features of Powercenter 8.x for better performance.

• Handled issues during data reconciliation.

• Developed BTEQ Scripts for batch load.

• Created Database Objects required for ETL needs.

• Involved in UAT, Production move/support activities.

• Prepared Technical Documentation.

• Performance tuning of the ETL application.

• Offshore team co-ordination and client communication.

Environment: Teradata, Informatica Powercenter 7.x/8.x, BTEQ, MLOAD, FLOAD, JCL, COBOL II, SQL ASSISTANT, IDMS, ORACLE, VBA.

Fusion (Aug’04– to – Jan’05)

This project was result of merger of GE HFS’ HPSC (Health care financial Service) into GE Comfin’s PMS (Portfolio Management system). Scope of this project was Business Mapping of HPSC Lease Plus System (GE’s Heath Care Financial Services) and the GE Commercial Finance’s PMS (Leasing and Loaning System) and development of ETL application.

Responsibilities:

• Data Modelling: I was involved in data Mapping between current Leasing System (PMS ) and the HPSC Heath care financials system (Lease Plus).

• Help business users and application users to troubleshoot source system data/Applications issues. •

• Preparation of Implementation Plans after the user acceptance of deliverables. •

• Functional/Technical Specs Coordination and Documentation.

• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.

• Created, updated and maintained ETL technical documentation.

• Development of Informatica Mappings/Workflows.

• Performance Tuning of ETL application.

• Offshore team co-ordination and client communication.

• Created/Tuned views, queries in MS Access during reconciliation of data.

• Implementation and Documentation of the process.

Environment: Informatica Powercenter 6.x, ORACLE, VBA, JCL, COBOL II, IDMS

GECF UBB Conversion Systems (Jan’04– to – Jul’04)

This is a conversion project, which mainly deals with the conversion of UBB (Usage Based Billing) deals. Acquisition of IKON Canada portfolio by GE resulted in immense need of software that could handle conversion of UBB deals. Because of the volume of data and the complexity involved, Informatica was preferred as the data transformation tool. Codes were written in IDMS COBOL to facilitate conversion of the data to mainframe system. Apart from this, ATOREXX (Automatic Transaction Operation -Tool to automate the online screen Operation and Navigation) was used to minimize post conversion efforts put in by the user.

Responsibilities:

• Analysis of the existing UBB Analysis.

• Data modelling based on the analysis.

• Preparation of Mappings/Workflows using Informatica.

• Created Excel Macros for transformation of small volume of data.

• Developed new IDMS/COBOL programs and JCL for loading the data to PMS.

• Involved in Unit testing, SI testing and User acceptance testing.

• Troubleshooting system data/application issues.

Environment: Informatica, JCL, COBOL II, IDMS, VBA.

Acquisition Center of Excellence (Offshore/Onshore) (Mar’02– to – Jan’04)

This is a conversion project, which mainly deals with the Portfolio Management System. It converts the data from the acquired company’s system to the PMS system used by GE. Codes are written in COBOL to facilitate the conversion from one system to the other. For validation, and Upload to mainframe system, Excel macros are written in Visual Basic. Project uses the methodologies and tools of Six Sigma Design to make sure that the processes are 100 % defect less. This project includes Creation of Documentation for the existing JOBS (including Data Flow Diagrams), Developing IDMS and COBOL programs and shell scripts for Database Extracts.

Responsibilities:

• Running conversion processes to the acquired portfolios.

• Troubleshooting Program/JCL errors.

• Coding new programs as per the requirement.

• Working with users towards completion of UAT, Production move of components.

• Involved in Unit testing, SI testing and User acceptance testing.

• Analysis of ADS/O dialogs.

Environment: JCL, COBOL II, IDMS, ADS/O,MS ACCESS, VBA, FILEAID, VSAM, IDCAMS, OLQ

Installed Base – GE Logistics System (Nov’00– to – Feb’02)

GEMS(Europe) has a client base across Europe. To provide instantaneous service to its clients the company maintains a highly sophisticated Information System. One of the components of this system is GE-Logistics System. The GE-Logistics System (from now on referred to as GELS) is as the name suggests a logistics system for the support of the service base of GE Medical System in Europe. This system is implemented across 13 countries in Europe known as affiliates. The system is structured with the Central warehouse located in France.

Responsibilities:

• 24X7 Production Support.

• Troubleshooting Failures and communication with Onshore component/client.

• Impact analysis and code fixing.

• Analysis of change requests. Case resolution, follow up with users.

• Involved in Unit testing, SI testing and User acceptance testing.

• Code Reviews, Debugging and testing.

Environment: JCL, COBOL II, IDMS, ADS/O, FILEAID, VSAM, IDCAMS, OLQ



Contact this candidate