SUMMARY

• 20+ years of IT experience in architecture, design, DB admin, software development, maintenance, implementation & management of Teradata data warehouses
• Experienced in Project study, Analysis, Design, Development, Implementation and Testing.
• Involved in project proposal creation, client presentations, data warehouse vision and organization development
• Experience in Data warehousing (ETL), DB Administration using Teradata
• Experience in Banking, Telecom, Utilities, Healthcare and Credit Cards Industry
• Have extensively worked Teradata tools (Queryman, SQL assistant, Multiload, Fastload, fastexport, PMon, TASM,TPT)
• Used SAS as reporting tool and very strong SQL skills
• Lead mentored and managed a team of developers on Teradata data warehousing projects.
• Designed, Extracted and Loaded the Data in the Warehouse using Teradata (ETL) tool.
• 6+ years in Databases (Teradata, DB2), 6+ years in Teradata DB admin
• 8+ years in Mainframes
• Worked for Banking clients like Confidential, CBA, HSBC, Confidential - Telecom ( Confidential ) - Utility NSC, BG Transco, Confidential, eBay, Confidential and Confidential .
• Technology forte is Teradata V2R5, Mainframes and Unix
• Project management experience in Production Support of data warehousing project
• Strong analytical and problem-solving skills
• Excellent verbal and written communication skills
• Self starter with high degree of commitment and integrity
• Team player with effective communication, negotiation and leadership skills

TECHNICAL SKILLS

Databases: DB2, Teradata V2R5/V2R6/V12, Oracle, MySql, IMS DB, MS - Access

Languages/Software: DB2, Teradata V12 (Query man, BTEQ, MultiLoad, FastLoad, TPump, ARCMAIN, Fast Export, SQL, TPT etc.), Erwin 3.5.2 /4.0, Teradata DBA Tools (Teradata Manager, Teradata Administer, Visual Explain, PMON, Teradata Static Wizard, Teradata Index Wizard, etc.)

AbInitio GDE & Co-operating System: Oracle, IMS DB, BRIO 6.0, VSAM, PL/SQL, SQL, Cobol II, Cobol 370, MetaCobol, CICS, JCL, TSO/ISPF, Intertest, Via-Soft, Panvallet, Endevor, CA-7,QA Auditor, QMF, Spufi, SDF, Unix Shell scripts, IMS Expert, SQL Forms 3.0, Report Writer 1.0, C++, C, Java, Oracle 7.0.1, HTML, Java 2, JDBC, JDK 1.2.1, Database Triggers, Stored procedures, Assembler (8085 & 8086), MQ Series, IMSExpert, MS Project 2000, Visio, Xpeditor, TOAD, Clarify, Infoman, PVCS, MS Word, MS Excel, MS Access, Control M, SAS, DB2 Platinum utilities, Trillium, Changeman, Microstrategy and TABLEAU, INFORMATICA, BOBJ

Operating System: Windows XP/2000, UNIX AIX, Linux, HP UNIX, NCR MP-RAS, DOS and MVS/ESA

PROFESSIONAL EXPERIENCE

Confidential

Sr. Teradata DBA

Responsibilities:

• Design and Development activities for SPIN project including Oracle, Teradata, Springs framework, Python framework
• Metadata driven solutions, framework related enhancements, functional involvement for end to end solutions with technical services provision

Environment: Linux, Unix, Teradata V14.10 (Queryman, BTEQ, Multiload, Fastload, TPump, ARCMAIN, FastExport, TPT, SQL, Teradata DBA Tools (Teradata Administrator, Td view point), Teradata DBS utilities, Viewpoint, root level activities etc.

Confidential

Sr. Solutions Architect

Responsibilities:

• Work with Director of Sales for new opportunities (Presales) of BitYota Dataware house product.

Environment: Linux, Unix, BitYota, Cloud computing, Azure products, Redshift, Tableau, Pentahou.

Confidential

Sr. Teradata DBA/Solutions Architect/Lead Teradata Platform

Responsibilities:

• Incidents/RFC for Teradata fixes, Td 14.10 upgrade activities from Td 13.10, check table/scan disk prep activities, SLES 11 move prep activities from the welcome tool kid, DBS control changes, Act on Tech alerts in consultation/contract with GSC/GST teams of Teradata, Raise incidents P1 with Teradata and involve in patch activities
• Performance tuning system level activities, Work load management, VP settings, TASM settings, PDCR activities, Data mover activities, BAR server activities, Password resets, catching bad queries and monitor system using View point, Fix spool issues, performance tuning, data compression, Code conversion challenges to Sql, Optimization efforts, performance monitoring, DBQL Analysis
• CPU reduction efforts, Top 100 query analysis/recommendations, Data movements between servers using Data Mover, Arcmain, maintenance activities

Environment: Linux, Unix, Teradata V14.10 (Queryman, BTEQ, Multiload, Fastload, TPump, ARCMAIN, FastExport, TPT, SQL, Teradata DBA Tools (Teradata Administrator, Td view point), Teradata DBS utilities, Viewpoint, root level activities etc.

Confidential

Sr. Solutions Architect/ETL Consultant

Responsibilities:

• Design and Development activities for SPIN project including Oracle, Teradata, Springs framework, Python framework, Metadata driven solutions, framework related enhancements, functional involvement for end to end solutions with technical services provision
• Support activities in agile environment, business stand up meetings with delivery responsibilities, off-shore/on-site technical team management, Data Quality Management

Environment: Linux, Unix, Teradata 13.10 (Queryman, BTEQ, Multiload, Fastload, FastExport, TPT, SQL), Oracle SQL Developer, SQL Assistant, Python, Springs, frame work, DQM, Metadata framework, Hadoop, HIVE, Power Designer

Confidential

Teradata DBA

Responsibilities:

• Incidents/RFC for Teradata fixes, Password resets, catching bad queries and monitor system using View point, Fix spool issues, performance tuning, data compression, Code conversion challenges to Sql, Optimization efforts, performance monitoring
• DBQL Analysis, CPU reduction efforts, Top 100 query analysis/recommendations, Data movements between servers using Arcmain, Teradata upgrade efforts

Environment: Linux, Unix, Teradata V13 (Queryman, BTEQ, Multiload, Fastload, TPump, ARCMAIN, FastExport, TPT, SQL, Teradata DBA Tools (Teradata Manager, Teradata Administrator, Visual Explain, PMON, Teradata Static Wizard, Teradata Index Wizard), Teradata DBS utilities, Vproc Manager, Priority Scheduler, Query Session, TWM, TSET, ERwin, Viewpoint etc.

Confidential

Teradata Solution Architect/Developer

Responsibilities:

• Fix spool issues, performance tuning, data compression, Code conversion challenges to Sql, Optimization efforts, performance monitoring

Environment: Linux, Unix, Teradata V13 (Queryman, BTEQ, Multiload, Fastload, TPump, ARCMAIN, FastExport, TPT, SQL, Teradata DBA Tools (Teradata Manager, Teradata Administrator, Visual Explain, PMON, Teradata Static Wizard, Teradata Index Wizard), Teradata DBS utilities, Vproc Manager, Priority Scheduler, Query Session, TWM, TSET, Informatica, ERwin, Viewpoint etc.

Confidential

Business Intelligence Consultant

Responsibilities:

• Pel-R script to compare variants Vs Control, Confidence Interval calculation, Live test update, Site analytics activities, Outlier removal logic, Design/Development and ETL processing using Teradata/Unix, Solve Performance issues, Solve SQL issues for analysts
• Cron job scheduling, Segmentation and Data distribution analysis development using Teradata/SAS/Unix, Table Schema design/review end-to-end solution for the models worked on, GMB analysis, Trend analysis (3months data for one year period) - Users churn-in development activities, Spool issues/fix SQL problems/query tunning/performance based code development, Unix scripting/Automation

Environment: Unix, Teradata V12 Queryman, BTEQ, Multiload, Fastload, TPump, SQL, ERwin, Viewpoint, Crystal Reports, Business Objects, Tableau, etc.

Confidential, San Jose, CA

Teradata Lead/Development

Responsibilities:

• Migrating data from source to target using application tools ( Fast load, Multi load Queryman, BTEQ), Teradata PMon to monitor the performance, backend support for DW bug fixing & Troubleshooting, code review and performance tuning of Teradata programs
• Enhancement in case of any requirement changes, Fixing and resolving the issues during the process

Environment: Windows, Unix, Teradata Tools, BTEQ Script, Fast load, Multi load, Queryman, Teradata Administrator, Teradata PMon, Database Teradata

Confidential

Technical Project Manager

Responsibilities:

• Used Teradata PMon to monitor performance, User creation activities and password reset for the business users, backend support for DW bug fixing & Troubleshooting, Involved in code review and performance tuning of Teradata programs
• Enhancement in case of any requirement changes, Fixing and resolving the issues during the process

Environment: Linux, Unix, Teradata V2R5 (Queryman, BTEQ, Multiload, Fastload, TPump, ARCMAIN, FastExport, SQL, Teradata DBA Tools (Teradata Manager, Teradata Administrator, Visual Explain, PMON, Teradata Static Wizard, Teradata Index Wizard), Teradata DBS utilities, Vproc Manager, Priority Scheduler, Query Session, TSET, Informatica, ERwin, Crystal Reports, Business Objects etc

Confidential, San Roman, CA

Teradata Lead

Responsibilities:

• As a technical Consultant for this project, primarily involved with the data model team to create a reporting environment in the Enterprise Datawarehouse on Teradata, Involved in migrating the data warehouse from Oracle to TERADATA
• Review requirements and user interaction to solve requirement issues (system and functional issues), Develop Program Design (High level design) and Write scripts (Low level Design),Develop code, unit test and system test the scripts (BTEQ, MLOAD, Stored Procedures)

Environment: Unix, Teradata V2R5 (Queryman, SQL assistant, Multiload, Fastload, fastexport), Cobol, MVS

Confidential, SantaClara, CA

Sr. Production Support Analyst

Responsibilities:

• Requirement Analysis, Development and ETL processing involved in SQL scripts and stored procedures to implement business rules, Involved in migrating data from source to target using application tools
• Involved in code review and performance tuning of programs, Enhancement in case of any requirement changes, Transition to the Production and delivery team (Offshore) for maintenance, Fixing and resolving the issues during the process, Bug fixing

Environment: COBOL, DB2, IMS DB, JCL, ISPF, FILE-AID, Via Soft, Change Man, REXX, CICS and Lotus notes

Confidential

Team leader

Responsibilities:

• Knowledge Acquisition and System take over with reference to the earlier project involvement (refer to the project from Sep 1998 to April 2000), it is to take over the system from different support group to TCS, Design, Coding, Unit testing and quality assurance at all level
• Train new TCS team members for production support activities, Responsible for flow Management, Prepared test cases for fixing bugs using xpeditor, Enhancement in case of any recruitment changes
• Transition to the Production and delivery team (Offshore) for maintenance, Fixing and resolving the issues for customer support

Environment: COBOL, DB2, JCL, ISPF, FILE-AID, SCLM, XPEDITOR and CSP

Confidential

Design and Development Engineer

Responsibilities:

• Detailed Data Analysis and Requirement Analysis of life’70 system, Designing the Data Source Mapping Matrix of the operational sources to Unisure, Creating Extraction requirements
• Transformation matrix, Data Quality Reports and recommendations documents for the above mentioned operational systems, Involved in migrating data from source to target using application tools

Environment: Mainframes, DB2, Cobol, VSAM files

Confidential, Milwaukee, WI, USA

Production Support Engineer

Responsibilities:

• Requirement Analysis, Code fixing, Data fixing, Testing & Debugging, System Study and Detail Data Analysis, Data Quality Analysis and Data preparedness documentation, Maintenance, Co-ordination and Consultation

Environment: Mainframes, Cobol, DB2, Data Loading.

Confidential

Team Member

Responsibilities:

• Production support and analyzing user's problems, Code fixing, Data fixing, Testing & Debugging, Preparation of Technical Specifications, Preparation of Process Flow Diagram and Testing.

Environment: COBOL, DB2, JCL, SQL, ISPF, FILE-AID, SCLM, XPEDITOR REXX, CLIST and CSP

Confidential

Team Member

Responsibilities:

• Analysis, Build, Unit testing and Debugging,Y2K test plan preparation and system testing, Code Review and quality assurance at all levels

Environment: COBOL, DB2, IMS DB, JCL, ISPF, FILE-AID, Via Soft, Change Man, REXX, CICS and Lotus notes