GAP (12.2018 - 06.2019)
- Report SQL performance tuning, API Automation. Data pipelines development and business alignment for new data initiatives for related customers.
- Provided thought leadership to mentor teams technically and functionally. Developed/Deployed Framework/Scripts/end to end Automation.
- Proto - type Data Science/ETL/ELT/Data Pipeline solutions for Engineering teams.
- Technologies: Linux, Unix, Azure, Rabbit MQ, Teradata Studio, Talend, Data Stage, DBeaver, MySQLWorkbench, DbVisualizer, SQL, Shell Scripting, BigData, Python, Hadoop, HDFS, Hive, Spark, PySpark, CAWA, MS Teams, GITHUB, Jenkins, Sublime text editor, etc.)
Intuit (02.2017 - 11.2018)
- Created Care Data Mart Model in Python as a framework to ingest data from Hive to Vertica seamlessly even if there are upstream changes in Exadata systems; these will reflect in Vertica automatically.
- Created Splunk API automation that ingests data automatically into Hive.
- Provided thought leadership to mentor teams technically and functionally.
- Proto - type ETL/ELT solutions for Analysts/Marketing team.
- Deploy Machine Learning algorithms.
Technologies: Linux, Unix, SQL, Shell Scripting, Python, Splunk, Vertica, Redshift, Hadoop, HDFS, Hive, Alation, Denodo, Exadata, Oracle, Spark, Pyspark, Scala, AWS (S3, Glue, Lambda, EMR, EC2), Tidal, GITHUB, Sublime text editor, etc.)
Paypal (08.2016 - 01.2017)
- Vendor BigData Engineering challenges, Application/Data Base Reporting, Development Analytics, Data Segmentation Analysis, Design, Data Modelling, Reviews, Product Team support, Performance Tuning, Solving Technical Issues, Team co - ordination, Agile stand ups.
- Technologies: Linux, Unix, Teradata V15 (BTEQ, Fastload, FastExport, TPT, SQL), SQL Assistant, Shell Scripting, Python, Hadoop, Hive, Spark, PySpark, Scala, UC4, GITHUB, Sublime text editor, etc.
Wells Fargo (04.2015 - 03.2016)
- Application DBA Activities, Data Base Analysis, Application development, Data Analysis, Design, Data Modelling, reviews, user support to SAS/Teradata developers/users, Teradata query performance tuning, Box monitoring, support ETL AbInitio developers, fix issues.
- Technologies: Linux, Unix, SAS, Teradata V15 (Stored procedure, Query man, BTEQ, Multiload, FastExport, TPT), SQL, Hadoop, Hive, Python, Pyspark, Spark, Scala, Teradata tools, Td view point, Sublime text editor, etc.
BitYota Inc.(12.2014 - 02.2015)
- Provided product support for BitYota's data warehouse-as-a-service platform, including cluster provisioning, user instance creation, and development support.
- Technologies: Linux, Unix, Bit - Yota, Cloud computing, Azure products, Tableau, Pentahou, QlikView, Postgress SQL, Hive, Hadoop, AWS, S3, Python, PySpark, Sublime text.
Amgen Inc. (01.2014 - 10.2014)
- Led Teradata upgrade and performance optimization initiatives, managed incidents and RFCs, collaborated with Teradata GSC/GST teams, and executed system-level tuning and query optimization.
- Technologies: Teradata V14.10, BTEQ, TPT, Fastload, Multiload, TPump, ARCAIM, SQL, Teradata DBA Tools (Administrator, Viewpoint), Linux, Unix.
Apple Inc. (03.2013 - 11.2013)
- Designed and developed metadata-driven solutions for the SPIN project using Oracle, Teradata, and Python frameworks. Led offshore/on-site teams and supported agile delivery.
- Technologies: Linux, Unix, Teradata 13.10 (Stored Procedures, Query man, BTEQ, TPT, SQL), Oracle SQL Developer, SQL Assistant, Python 2.7, Springs frame work, DQM, Metadata framework, Hadoop, HIVE, Spark, Power Designer.
Kaiser Permanente (02.2012 - 02.2013)
- Managed Teradata incidents, SAS-Teradata development, query optimization, and system monitoring. Led performance tuning and data movement activities.
- Technologies: Linux, Unix, SAS, Teradata V13 (Queryman, BTEQ, Multiload, Fastload, TPump, ARCAIM, 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, Viewpoint etc.
Bank of America (05.2011 - 01.2012)
- Focused on performance tuning, spool issue resolution, and SQL optimization for Teradata systems.
- Technologies: Linux, Unix, Teradata, BTEQ, SQL, Java, JIRA.
eBay Inc.(06.2009 - 04.2011)
- Led A/B testing, site analytics, and ETL development using Teradata and Unix. Developed segmentation models and automated data ingestion using R and Splunk.
- Technologies: Unix, SAS, Teradata V12 Queryman, BTEQ, Multiload, Fastload, TPump, SQL, Viewpoint, Crystal Reports, Business Objects, Tableau, etc.