Summary
Overview
Work History
Education
Skills
Timeline
Generic

Bharath Kumar

Irving,USA

Summary

Dynamic IT professional with over 9 years of experience bridging complex data architecture with impactful marketing execution. Proven expertise in orchestrating end-to-end sales campaigns through the integration of third-party data and advanced analytics tools, including SQL, Python, and Tableau, to drive substantial ROI. Extensive background in business analysis, design, implementation, and testing of applications across diverse industries such as finance and aviation, along with a strong track record in developing large-scale data warehouses and decision support systems. Recognized for collaborating closely with cross-functional teams to deliver high-quality solutions while leveraging a comprehensive skill set in ETL development, database management, and data visualization.

Overview

9
9
years of professional experience

Work History

Teradata/SAS Developer

Verizon
Irving, TX
08.2021 - Current
  • Designed and maintained marketing data pipelines and database structures to support scalable campaign execution and reporting.
  • Streamlined DBM execution by integrating new technologies and automating repetitive data extraction processes and increasing speed to market.
  • Led end to end marketing campaign execution by extracting and transforming customer data to support targeted marketing and sales initiatives.
  • Utilized Python to set up an API connection between Marketo and Teradata. This connection allows us to extract key suppression files like unsubscribed, suspended and invalid email records to create a comprehensive dataset with Teradata.
  • Developed and optimized customer targeting datasets, strategies using data insights to drive engagement, conversion and revenue growth.
  • Partnered with marketing operation to deliver data driven campaigns lists supporting the full lifecycle of marketing programs.
  • Applied best practices in data analytics and customer segmentation to improve targeting accuracy and campaign effectiveness.
  • Managed multi party stakeholder engagements, coordinating between marketing, analytics and external vendors.
  • Reduced campaign data preparation time by 70% through SQL automation.
  • Provided data insights to strategy and sales teams by analyzing the percentage of addressable vs non-addressable accounts, and identifying the proportion of data customer data delivered vs not delivered in marketing campaigns each quarter to support future campaign planning.
  • Investigated and resolved complex technical discrepancies within large datasets, maintaining the reliability of business intelligence tools for executive decision making.
  • Performed full spectrum quality analysis on campaign output, ensuring 100% accuracy in data delivery to sales operations and marketing managers.
  • Continuous fine tuning of the well-oiled outbound campaign automation and the No leads uncalled initiative.
  • Provided leadership and strategic support for multiple CRM campaigns, ensuring effective execution and improved customer retention, supported key initiatives including Iconic launch, Strategi Upgrade, Device Protection open enrollment, BYOD, BIC and LAC offers.

Teradata/SAS Developer

Verge Information Tech Inc
Irving, TX
01.2020 - 08.2021
  • Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Teradata DB.
  • Documentation, presentation, data reports and model results to the Marketing lists managers.
  • Initially created tables and views in Teradata and used a BI/Query model for local users to access the data tables and reports.
  • Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.
  • Develop and maintain UNIX scripts, SAS and SQL for internal, external data sources including Teradata databases.
  • Multiple Interactions with business users on a daily basis to understand business requirements, perform preliminary round of demo to agree upon the final requirements, demo utilizing data display in multiple forms like SAS reports, Matrices, Dynamic Grids , Email, Door to Door, Telemarketing, Bill media etc.
  • Developing SAS ship file for various marketing programs like Email, Door to Door, Telemarketing, Bill media etc.
  • Implemented business logic and requirements in SQL scripts, SAS reporting tool depending on various conditions and limitations of the tools.
  • Experienced in handling Terabytes of records and manipulating them through SAS.
  • Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets and converted them into useful SAS Datasets for marketing lists.
  • Effectively managed business marketing database and closely analyzed product universe record counts on weekly basis.
  • Migrated BAU marketing list codes to The Fiber store Marketing Universe for campaigns.
  • Performed address standardization for external file data with TFS Data and utilized it for marketing campaigns.
  • Assisted in creation of New TFS Marketing universe for VZ Business Marketing.
  • Worked towards delivering Business Wireless marketing list for Add a Line and Total Mobile Protection campaigns.
  • Effectively developed, and collaborated with others developers in developing BAU marketing list and deliver the data to marketing science team for camping in Marketo tool.
  • Worked closely with marketing list owners, Marketo team and helped them to understand data overlapping difficulties found in Marketo with different marketing campaigns.
  • Efficiently worked on multiple projects simultaneously.
  • Maintained well balanced work delivery with prioritization and due dates.
  • Well versed with BAU scheduler jobs handling and maintained in Cron shell.

Teradata/SAS Developer

Diversant LLC
05.2019 - 12.2019
  • Develop Teradata CIM/ARM Custom SQL to create marketing data sources.
  • Work with business team for requirements gathering and assist them in building targeting matrices, dynamic grids, and providing them with estimated lead quantities, and conduct data possibility checks.
  • Develop Custom BTEQ scripts to process warehouse data and update the tables.
  • Created tables, views, macros, functions in Teradata SQL Assistant.
  • Utilized pre and post session command tasks to invoke BTEQ scripts to insert/update Audit tables.
  • Research internal and external marketing data sources, resolve data inconsistencies, and document anomalies.
  • Provide support to groups by reacting to ad-hoc data requests, addressing questions, and providing analysis.
  • Create a new Shell scripts and change existing Shell scripts to pull and load data from and into Teradata databases.
  • Created several different Segments, Offers, also Creating and Personalizing E-Mail layouts, DM layouts, OTM layouts for running the Email Campaigns, DM Campaigns and OTM Campaigns.
  • Demonstrated data analysis, data presentation, and data development skills.
  • Created Teradata objects like Views and Macros for marketing lists suppression.
  • Analyzed Interactive Marketing / eCRM System data and produced ad-hoc report details.
  • Analysis included Behavioral model, Customer Profiling, Segmentation, Trend Analysis, Predictive Modeling and Lift modeling etc.

Teradata/SAS Developer

Bank of America
Richardson, TX
11.2017 - 04.2019
  • Worked closely with the Data Analysts, Teradata DBAs and BI Developers to ensure accurate and timely delivery of solutions.
  • Prepared the detailed design or technical design of the project phase by phase.
  • Interacted with the client to discuss day-to-day matters, issues, design walkthroughs, change request implementations and its effects and coordinating on a daily basis for status update.
  • Created tables, views, macros, functions and Procedures in Teradata SQL Assistant.
  • Used TPT (Teradata Parallel Transporter) configured for Fast load and Mload to load data.
  • Utilized pre and post session command tasks to invoke BTEQ scripts to insert/update Audit tables.
  • Extensively worked on indexes in Teradata and Creation of proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
  • Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, table spaces, triggers, dB links and privileges.
  • Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
  • Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
  • Created Run Books and Turnover documents for the scheduling team to schedule jobs on Appworx.
  • Created Business Requirement Documents, Technical Design documents and Implementation Plans for migration of code to various environments.
  • Analyzed various database containing sales, titles, account, region etc data of the releases of various titles.
  • Experienced in handling Terabytes of records and manipulating them through SAS.
  • Analyzed Interactive Marketing / eCRM System data and produced ad-hoc report details.
  • Analysis included Behavioral model, Customer Profiling, Segmentation, Trend Analysis, Predictive Modeling, Lift modeling and Validation, Optimizing open-ended offers, etc.
  • Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets.
  • Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
  • Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Teradata DB.
  • Documentation, presentation, data reports and model results to the team/manager.
  • Used various Statistical Procedures like PROC FREQ, PROC REG, PROC ANOVA and PROC GLM to analyze data and generate reports.
  • Initially created tables and views in Teradata and used a BI/Query model for local users to access the data tables and reports.
  • Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.
  • Created various dashboards using Actions, Quick filters, Parameters, Sets, Groups, Hierarchies calculated fields, table calculations and Worked on creation of Pareto chart.
  • Built dashboard with pareto analysis in tableau for headcount analysis based on different KPI's and data source from Google Big Query.
  • Worked on Python Libraries and fallowed the best practices using PEP-8.
  • Used Python scripts to update content in the database and manipulate tables view that are being used for Tableau Dashboard.
  • Wrote and executed various SQL database queries from Python using Python-SQL connector.
  • Used Python to extract Data from External files.
  • Wrote and executed various SQL queries from python using SQLAlchemy module.

Teradata Developer

Us Soft LLC
Irving, TX
12.2016 - 11.2017
  • Involved in complete SDLC (System Development Life Cycle).
  • Developed performance utilization charts, optimized and tuned SQL and designed physical databases. Assisted developers with Teradata load utilities and SQL.
  • Converted batch jobs with BULKLOAD utility to TPUMP utility.
  • Researched Sources and identified necessary Business Components for Analysis.
  • Gathered the required information from the users.
  • Interacted with different system groups for analysis of systems.
  • Created tables, views in Teradata, according to the requirements.
  • Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
  • Implemented slowly changing dimensions methodology to keep track of historical data.
  • Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from DB2 databases.
  • Wrote appropriate code in the conversions as per the Business Logic using BTEQ scripts.
  • Loaded the data into the Teradata database using Load utilities like (Fast Export, Fast Load, MultiLoad, and Tpump).
  • Expertise in performance tuning the user queries. Executions of frequently used SQL operations and improve the performance.
  • Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities and Unix Shell scripts.
  • Automation of Data Extraction, Transformation and Loading the results to final datasets using SAS and SQL.
  • Played a major role in setting up different regions - Testing, Integration, Performance, Break fix and Production environment with the Wrapper scripts and setup and folder structure for Teradata scripts to run in UNIX environment.
  • Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
  • Understanding BRD, Data required document and mapping documents.
  • Creation of Data bases and users Space and User maintenance on dev machine.
  • Designing the ETLs and conducting review meets Involvement in implementation of BTEQ and Bulk load jobs.
  • Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
  • Created BTEQ scripts to extract data from warehouse for downstream applications.
  • Worked on Teradata Query man to validate the data in warehouse for sanity check.
  • Scheduled jobs for batch processing using Maestro Scheduler.
  • Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
  • Developed unit test plans and involved in system testing.

Education

Bachelors of Electronics and Communications Engineering -

JNTU
Hyderabad

Master of Science - Computer and Information Science

Southern Arkansas University
Arkansas

Skills

  • Languages: SQL, PL/SQL, Oracle, C, C, Visual Basic 60, UNIX Shell, PYTHON
  • Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro
  • Databases: Teradata V2R41, V2R5, V2R6, V2R61, SQL Server and Sybase, MS Access, MS Excel, MySQL, SQL, MS SQL Server, FoxPro, SAS, SAS Proc
  • GUIS/Front-end: Visual Basic, Developer 2000, IBM Visual Age, NetBeans 36, Developer 2000(Forms45/50/60,Reports25/30/60), Excel ,SAS 90, Sql
  • Net, Informatica, Tableau, Alteryx
  • Operating Systems: Windows 9x/NT/2000/XP, UNIX, Solaris, MVS & MS-DOS

Timeline

Teradata/SAS Developer

Verizon
08.2021 - Current

Teradata/SAS Developer

Verge Information Tech Inc
01.2020 - 08.2021

Teradata/SAS Developer

Diversant LLC
05.2019 - 12.2019

Teradata/SAS Developer

Bank of America
11.2017 - 04.2019

Teradata Developer

Us Soft LLC
12.2016 - 11.2017

Master of Science - Computer and Information Science

Southern Arkansas University

Bachelors of Electronics and Communications Engineering -

JNTU