SUMMARY:

• 20+ years of IT Experience in Architecture/Design, Data Modeling, DB Admin, Software Development, Maintenance, Implementation & Management of Data Warehouses.
• Experienced in Project Study, Analysis, Design, Development, Implementation and Testing/Quality Assurance.
• Experienced in ETL, Big Data, Data Analysis, Data Migration, Data In - sight Reporting and Business Intelligence.
• Experienced in Data Warehousing ETL/ELT, Business Analysis, DB Administration.
• Experienced in Banking, Telecom, Utilities, Healthcare, Pharma and Credit Cards Industries.
• Experienced in BI Reporting tools and very strong SQL skills.
• 8+ years Business Analysis, 10+ years in Databases, 10+ years in Design/Development and 8+ years in DB Admin, 6+ years in Application/Production Support, 8+ years in Mainframes.
• Project management experience in Production Support/Data warehousing projects/Lead mentored and managed the team of developers on Teradata data warehousing projects.
• 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: Teradata V15, Postgres, Oracle, MongoDB, Bit-Yota DW as a service

Languages/Software/Tools: Teradata V15 (SQL Assistant, BTEQ, Multi Load, Fast Load, T-Pump, ARCMAIN, Fast Export, SQL, TPT, Stored procedures, Macros, etc.), Teradata DBA Tools (TD Admin), Erwin, Ab Initio, Informatica, Talend, Postgres SQL, Oracle, SAS and TABLEAU, Pentahou, Shell scripting, Python scripting, AWS/Azure products

Operating System: Windows, Unix, Linux, NCR MP-RAS, DOS and MVS

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Teradata Consultant (DBA/Development/Performance tuning)

Responsibilities:

• Application DBA Admin activities, Application development, Design, Data Modelling, review activities, user support activities to SAS/Teradata developers/users, performance tuning, support ETL Ab Initio developers, fix issues, Box monitoring

Environment: Sun Solaris, Unix, SAS, Teradata V15 (Stored procedures, Macros, BTEQ, Multi load, Fast load, Fast Export, TPT, SQL, Teradata DBA Tools (Teradata Administrator, Td view point), SQL Assistant, Ab Initio graph etc.

Confidential

Sr. Solutions Architect/Consultant/Pre-Sales

Responsibilities:

• Product support on Bit-Yota data warehouse product, spinning up the clusters, create user instances in Bit-Yota clusters, data warehouse development activities and support

Environment: Linux, Windows, Bit-Yota, Cloud computing, Azure products, Redshift, Tableau, Pentahou, Posgress SQL, MongoDB, AWS, Python.

Confidential

Sr. Teradata Business Solutions Consultant/Platform DBA/System owner

Responsibilities:

• DBA activities, System owner responsibilities, provide solutions, dealing with TD vendor to take care of customer environment, process adherence and assurance

Environment: Linux, Unix, Teradata V14.10 (BTEQ, Multi load, Fast load, T-Pump, ARCMAIN, Fast Export, TPT, SQL, SQL Assistant, Teradata DBA Tools (Teradata Administrator, Td view point), Teradata DBS utilities, Viewpoint, root level activities, Informatica etc.

Apple

Techno-Functional Consultant

Responsibilities:

• Design/Development/Architecture/Metadata driven solutions/Data quality management

Environment: Linux, Unix, Teradata 13.10 (Stored Procedures, BTEQ, TPT, SQL), Oracle SQL Developer, TD SQL Assistant, Python, Springs frame work, DQM, Metadata framework, Power Designer

Confidential

Sr. Teradata Solutions Consultant/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, SAS, Teradata V13 (Query man, BTEQ, Multi load, Fast load, T-Pump, ARCMAIN, Fast Export, TPT, SQL, Teradata DBA Tools (SQL Assistant,Teradata Administrator, PMON), ERwin, Viewpoint, Informatica etc.

Confidential

Sr. Teradata Consultant (Development/Analyst)

Responsibilities:

• Fix spool issues, performance tuning, data compression, Code conversion challenges to Sql, Optimization efforts for SQL from JAVA code, reverse engineering, Development efforts

Environment: Linux, Unix, JAVA, Teradata V13 (Query man, BTEQ, Multi load, Fast load, Fast Export, TPT, Informatica, SQL etc.

Confidential

Business Intelligence Consultant

Responsibilities:

• AB testing, Statistical analysis, Perl-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, 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 tuning/performance based code development, Unix scripting/Automation

Environment: Unix, SAS, Teradata V12, SQL Assistant, BTEQ, Multi load, Fast load, SQL, Excel custom built reporting tools, Tableau, etc.

Confidential, San Jose, CA

Teradata Lead/Development

Responsibilities:

• Migrating data from source to target using Teradata tools, Teradata PMon to monitor the performance, backend support for DW bug fixing & Troubleshooting, code review and performance tuning of Teradata Code, 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, SQL Assistant, Teradata Administrator, Teradata PMon, Database Teradata