SUMMARY

• Around 8 years of IT experience, specifically in Data Warehousing and Application Development.
• Excellent SQL skills - experience in working with complex ELT and data modeling.
• Experience in various phases in Data warehouse projects - Requirement gathering, Design/Analysis, Development, Testing coordination, Implementation coordination.
• Worked in both Waterfall type and Agile type project methodologies.
• Good knowledge of Dimensional data modeling, Star Schema and Snowflake schema.
• Around 7 years of experience in Teradata with extensive hands-on knowledge in utilities like BTEQ, FastExport, MultiLoad, FastLoad, TPump etc.
• Extensive working experience in performance tuning of SQLs/loads for optimization of batch process.
• Involved in huge data migration projects, and worked in data migration between Teradata and Netezza.
• Worked in database design as part of reengineering projects, and took part in designing normalized data structure for better loading, and transforming into de-normalized data for better reporting.
• Strong Analytical & Technical skills - ability to quickly analyze and provide optimal solutions.
• Good understanding of banking domain, specifically Wholesale Credit Risk space.
• Working experience with Scheduling Tools like Autosys and Maestro.
• Good communication skills, self-motivated, quick learner and a good team player.

TECHNICAL SKILLS

Database: Teradata, Netezza

Scripting Languages: Unix Shell script.

ETL Tools: Informatica.

Project Methodologies: Waterfall, Agile.

Scheduling Tools: Autosys, Maestro.

Versioning Tools: Perforce, SVN.

Project Tracking Tools: Quality Center, JIRA.

Others: Minor working experience in Hadoop, Java, C

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr.Teradata Developer

Responsibilities:

• Coordinating with Business Partners for gathering business requirements, and working on detailed design / documentation and translating into technical requirements.
• Onshore-Offshore coordination
• Working in highly challenging environment having dynamic requirement changes, and ability to deliver defect free implementation.
• Developing / reviewing the code changes per the business/technical requirements.
• Coordinating with CIT and UAT teams for testing the changes.
• Coordinating with implementation teams for the production deployment using RFC process.
• Providing SME support for legacy processes.
• Working in hybrid environment, which has both normalized data and transforming into de-normalized data.

Environment: Netezza, Teradata, Hadoop/HDFS, Linux/UNIX script servers, Talend, SQL Server, Autosys

Confidential, Charlotte, NC

Sr.Teradata Developer

Responsibilities:

• Setting-up new databases in production and lower environment for production parallel testing.
• Coordinating with Business Analysts for the known differences that generated as part of re-engineering effort and thus analyzing and communicating the impact to downstream systems.
• Involved in designing the new data model in Netezza, and worked in data copy between Netezza and Teradata (both ways).
• Coordinating with business partners for the new business changes and implementing in both legacy and production parallel environments after translating into technical requirements.
• Coordinating with offshore team for the development/redesign activities, and lower environment executions.
• Develop the code and review the code changes.
• Coordinate with QA team and provide data in lower lane for testing.
• Coordinated with different downstream systems and users - since the module is a reporting layer, resulted in exposure to user community.
• Worked in re-engineering of legacy WECRIS from Teradata platform to Netezza, including one time history copy using FEXP/NZLOAD utilities.
• Coordinated with DBAs for creating new databases, new / modifying access categories for user access in Teradata.
• Building data marts for provisioning data for Default Validation and Risk Rating Scorecard Group, involving complex BTEQ scripts for aggregations/preponderance logic.

Environment: Teradata, Informatica, UNIX script servers, Autosys

Confidential

Sr.Teradata Developer

Responsibilities:

• Coordinate with onshore in designing new approach/module to load required target tables for users using BTEQ (Sourcing files using Mload/Fastload).
• Worked as team lead with a team of freshers, and provided required knowledge transfer and support.
• Worked in automation of Port Metrics load - using BTEQ scripts for transformation logic (flat file source loaded through MLOAD).
• Led the team of freshers, gathered requirements and built logic for optimal performance.

Environment: Teradata, UNIX, Crontab

Confidential

Responsibilities:

• Coordinate with onshore for the technical requirements and provide detailed change details.
• Develop/unit test the code changes per the requirements.
• Coordinate with QA team and provide test data by executing batch process in lower environments.
• Coordinate with implementation teams for the production deployment, by using bank-specific CAB (Change Advisory Board) processes. Worked with multiple teams (to get architect sign-off for the change, approvals for SLA impacts etc).
• Generate downstream extracts using Informatica (using FastExport utility).
• Worked in redesign of data model layer from Surrogate key Model to Natural key Model, and rewriting downstream data marts for new Model.
• Worked in optimizing generation of downstream extracts by converting the existing Informatica code to generic reusable code with Automatic FEXP / BTEQ Export control file generation based on the data size.
• Worked in building re-usable logic to copy data from one Teradata server to another Teradata server, which dynamically generates FEXP/MLOAD or BTEQ Export/Import control files based on size.

Environment: Teradata, Informatica, UNIX