Technical Lead/Architect Resume

SUMMARY:

I am a Teradata professional and have 11 years’ experience in Software Development and 8 years in DW - BI implementation on Teradata.
I have worked extensively on analysis, architecture, design and implementation of Data Warehouse solution on Teradata platform and experience on designing ETL and Reporting framework.
I have worked on DW performance improvement projects, enabling the clients to maximize returns on their investment in Teradata appliance.
Well versed with the complete software development life cycle.
Excellent technical abilities having defined Architecture for multiple projects. Excellent oral and written communication skills.
Experience in designed scalable, flexible, ETL data integration and Reporting frameworks.
Lead critical projects including production support. Experienced in client facing roles like Architecture Definition, Requirements Gathering and Analysis, Project Tracking, Go-live activities and Production Support. Experience in working in multivendor and offshore models.
Experience in Teradata Warehouse systems having worked in Architecture Design, Data Modeling, Physical Database Design and Tuning, Worked at various levels in Teradata implementations. Indepth understanding of Teradata Architecture, TTU (BTEQ, FastLoad, MLoad, Tpump, TPT etc). Strong RDBMS & SQL skills with hands on experience in developing batch jobs in PL/SQL. Hands-on experience in Teradata Administration.
Conducted several internal as well as external Teradata trainings.
In addition to Data Warehousing experience, I have worked with various technologies and languages like Teradata MDM, Java, VB.NET. The hands - on experience of his involves databases like Oracle and SQL Server 2000 over Windows Server Family, UNIX.

SKILLS:

Operating Systems: Windows, UNIX

Data Modeling Tools: ER-WIN,ER Studio, IBM Infosphere Data Architect

RDBMS: Teradata V2R5/12/13/14, Oracle 8i/11g MS SQL Server 2000

ETL: Informatica 9, BODI

Reporting: Business Objects XI, Cognos

Other Tools and Utilities: Eclipse 3.0, TOAD, MS Visual Studio 2003

Other Languages/ Technologies / Platforms: Teradata, Teradata MDM, Java, VB.NET, C/C++

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Teradata 14, Informatica 9.1, ERWIN, ESP for scheduling

Technical Lead/Architect

Responsibilities:

Defined the Architecture for the new EDW application.
Analyzed the source systems and defined a roadmap to bring the data in EDW.
Defined and documented the data load strategy, best practices document through POC ensuring audit, traceability, fault tolerance, automatic restart capability and performance monitoring reporting.
Coordinated with systems partners to finalize designs and confirm requirements.
Spearheaded the data modeling activities in the initial phase.
Lead the design and development for data loads and coordinated the work effort between offshore and onshore teams.
Provided production support for the live data loads and resolved technical and functional issues.
Performed performance tuning for the by defining PI, Statistics and load strategies.

Confidential

Environment: Teradata 12, Informatica 9.1, BO XIR3

Teradata Architect/ Onshore Lead

Responsibilities:

Analyzed the As-Is system & recommended Architecture changes for To-Be system.
Redesigned & optimized the Batch process to reduce the time taken for Batch processing from 14-24 hrs to 1 - 1.5 hrs
Redesigned Audit process & scaled to handle more that 100 requests per night from the limit of 7 requests per night.
As an Offshore Lead provided technical resolutions to UI (Java), ETL (Informatica) & BO reporting teams.
Responsible for Project Management including Estimating, Status Tracking, Risk Management, Reporting, generating Project Metrics, Client Communications, Issue Resolution and SOW adherence.

Confidential

Environment: Teradata 12/ 13, Data Stage, BO XIR3

Teradata SME

Responsibilities:

Responsible for Teradata Architecture, Design & implementation for this project.
Data Modeling: designed Normalized Model for core schema and STAR schema to comply with the reporting architecture.
STAR data load: Designed and implemented the Star data model. Was responsible for the creation, scheduling of BTEQ jobs to load/refresh the star schema from the normalized schema. Implemented complex computations reqquired to calculate measures at the BTEQ layer itself.
Teradata Administration: Was involved in designing the Backup & Archiving strategy using NetVault system.
Implemented the User, role creation and maintenance of the production system.
Responsible for performance tuning of the application from ETL, Star and BO perspective.
Teradata Utilities: Used Fastload, BTEQ, FastExport extensively in project. Used TPT, MLOAD for certain parts of project.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship