CAREER SUMMARY:

• 9 years 5 month of experience in the IT Industry
• Key Skills in Teradata SQL (Teradata Version 12, 13, 14, 15), Unix Shell Scripting. Doing development, maintenance, enhancement and migration projects on the same platform.
• Worked extensively on Teradata Utilities (BTEQ, FLOAD, FEXPORT, MLOAD, TPT)
• Worked on ETL Tool DataStage and Reporting tool Hyerion. Also working on Teradata Customer Relationship Management Tool which is a reporting tool used by marketing & business analysts.
• Worked on Coldfusion 8, Websphere
• Worked on establishing SSH & Connect Direct Connections. Exposure to Windows Batch Scripting.
• Service Management experience

SOFT SKILLS:

• Excellent communication skills.
• Strong Analytical and Logical skills.
• Ability to work with a team and facilitate the spirit of teamwork.
• Ability to impart knowledge to the team members, as and when required.
• Quick learner and can easily adaptable to any environment.

TECHNICA

Key Skills: Unix Shell scripting and Teradata SQL

Languages Known: Unix Shell Scripting

Technologies: Teradata (v2R5,12,13,14,15), Teradata Utilities BTEQ, MLOAD, Fast Load, Fast Export, Teradata View Point, Teradata Administrator, SQL Assistant, Teradata Customer Relationship Manager, Aprimo Customer Relationship Manager, IBM Websphere Application Server Network Deployment 7.0, Connect Direct, SSH

Exposure to: Hyperion Brio, IBM Infosphere, Colfusion 8, Windows Batch Scripting, C

Operating Systems: GNU/Linux, Windows 7, Windows Server 2008, Unix/AIX

WORK EXPERIENCE:

Teradata Principal Consultant

Confidential

Responsibilities:

• Create code, forms and scripts (Unix shell scripts and Teradata scripts)based on user requirements and needs, that allow computer applications to run.
• Develops software solutions by studying user information needs.
• Modify and test the solutions (code and scripts) to ensure quality and user requirements. Test and document all the code changes which includes Unit Testing, System Testing and Integration Testing. Document all test results and quality peer reviews.
• Gather and analyse business requirements and ensure that underlying application technology meets both short - term and long-term business needs and that system designs can adapt to emerging business and technology demands.
• Communicate with project managers as to the progress of open items and work with software developers and other infrastructure resources as needed using knowledge of information systems infrastructure, systems development stages, systems development life cycle, rapid application development, systems analysis, systems design, data modelling. Preliminary investigation, project analysis, design tips, etc.
• Develop or modify existing codes/scripts to create computer programs that help in storing, locating and retrieving specific documents, data and information. Create effective solutions which are efficient and require optimal resource usage to store information. Provide least cost path solutions to the user which leverages the existing Teradata versions.
• Documents and demonstrates solutions by developing documentation, code comments and clear code.
• Prepares and installs solutions by determining and designing system specifications, standards, and programming.
• Create scripts to conduct performance testing and enhancement on existing as well as new codes/scripts/SQLs. Eg: Queries/SQL scripts in Teradata
• Involve in logical and physical Database design & Relational model; Multiple table queries; functional dependencies and Data warehousing and data mining.
• Create new programming or work on existing programming from specifications drawn by software developers or other individuals. This includes gathering Requirement analysis of existing solutions as well as new requirements from the user. This also includes developing new solutions or modifying existing solutions.
• Assist software developers in understanding and analysing user requirements and needs and help them in designing software solutions. This also includes assisting software developers to enhance existing solutions to provide more efficient and better customer experience.
• Extensively involved in performance tuning
• Developed packages for refreshing data from one Teradata box to the other - Data Transfer Utility

Teradata Technical Lead

Confidential

Responsibilities:

• Working with a team of 10
• Involved in Coding, Performance Tuning, Enhancements, Compression, CDC, SPL, etc

Application Developer

Confidential

Responsibilities:

• Actively involved and participating in High Level Design reviews for projects by giving valuable suggestions and inputs for better performance
• Have been involved actively in Design and review of Application Design for projects.
• This also involves discussions with the Business Analysts on the impact of the project and analysis of the code design.
• Working closely with customer and involving actively in the weekly Maintenance RTB calls with client.
• This involves attending the MRB (Maintenance Review Board) calls representing the DW team, weekly and providing updates on tickets.
• This also involves scheduling and prioritizing the tickets, as per customer requirements and urgency, for installation and monitoring the progress till post installation.
• The spoc for Maintenance Ticket Management. Maintenance Review Board Coordinator for the team. Involved in Maintenance Tickets triage, prioritizing and assigning resources in the team to work on the tickets. Organizing MRB meetings within the team for better ticket resolution aiming at better customer satisfaction.
• This involves active participation in all the pre and post installation activities which includes the organizing of calls with the Production Support team, Teradata DBA team and other stake holders who are involved in the installation. This also involves documenting pre and post installation activities and monitoring the progress of the installation until the Go-No Go call.
• Involved in Unit Testing, System Testing, and User Acceptance testing for my modules of the respective projects that I am working on.
• Actively involved in Production support and is one of the main spocs for the production support for the team.
• Have been involved in providing knowledge transfer to new joiners in the team esp. in production related issues and in the Data Warehouse flow
• Have been involved in creating production support documents for easy reference and understanding.
• Actively involved in team building activities.
• Working closely with customer on maintenance, enhancement and migration projects on Teradata Customer Relationship Manager (TCRM) and Aprimo Relationship Manager (ARM)