Avinash Reddy Email & Phone Number

Remote

As a Data engineer I was involved in building the data modelling and ETL frame works to analyze the customer care call center data using the reporting dashboard in Power BIModelling Reporting Framework in Azure Data Bricks/SQLModeling Azure Zen 2 data lake for storage of the dataWritten python scripts to automate the process of pulling the source data using API and salesforcesystems.Extensively worked on SQL tables design, loading data into SQL tables and data bricks tablesImplemented Spark SQL to transform the raw data into refined data layer.Setting up the Azure Data bricks Unity Catalog for data governance.Created the Reporting layer in Azure Data Bricks for the Power BI reporting needs.Scheduling the Jupiter notebooks using the Azure data factory (ADF) for daily runsDeploying the code using Git hub Actions

Remote

AB Testing is used to determine what is the best experience based on the real time data from the customers by comparing the results, as a data engineer I was involved in building the AB Testing Reporting Framework for analyzing the AB Testing Results using Power BI and other reporting dashboards.Modelling Reporting Framework in Hive/SQL across different customer life cyclesDeploying and Scheduling use case scripts in Airflow for Automated runsExtensively worked on hive tables design, loading data into hive tablesImplemented Py Spark to read / write / Execute hive codes for running rules.Written python scripts to automate the process of scheduling jobs in airflow.Created dashboards in Power BI to display the results of the AB testing for experiments.Extensively used statistics to measure AB testing resulting using confidence and p values tocompare the Key performance indicators like Conversion rate (CVR), Average order value (AOV),Revenue per visit (RPV) and clickthrough rate

Phoenix, Arizona, United States

Global Alert Repository (GAR) is built on HBASE to store data for exception monitoring, case management and Key Risk Indicator (KRI) metadata, GAR provides real time updates to case creation management where exceptions are handled , GAR also provides the data to Dashboards for reporting purposes • Involved in complete life cycle of software development from requirement gathering to launching the project • Building API’s to process data from different source systems using Java• Created Hive External tables on top of GAR Hbase data base • Written Hive Scripts to support different business logic for Reporting purpose• Building Java API’s to feed the data to case management in Archer to create cases • Building API’s to sync taxonomy data from Archer management systems for market, businessunits, legal entity • Writing Python/ hql scripts to load the data to Jethro data base to provide data for tableau • Reporting• Built Java APIS to connect to HBASE for CRUD operations • Extensively worked on Building HBASE Tables and Architecture • Built Data Migration Scripts to Load data from SQL to HBASE

New York, United States

Building Key Risk Indicators for American Express across processes, products, business units, and risk types leveraging recent advances in data science and technology, the automated framework will be executed in real time basis and will provide unprecedented transparency into functioning of key processes• modeling different key risk indicators in Hive/SQL/Splunk across different customer life cycles• Extensively worked in Hive tables Design, loading the data into Hive tables • Implemented Py spark to read / write/execute hive codes for running rules • Written Shell scripts to automate the process of scheduling jobs • Created reports, Alerts and dashboards in Splunk which demonstrate various risk levels • Created and managed Splunk DB connect identities, Database Connections, Database inputs, lookups, access controls.• Worked on Encryption and Decryption on Sensitive data Like PI, SSN, PCN using Voltage Encryption and Java API • Extensively used Various risk reporting tools such as tableau and jasper soft to understand risk types and levels at American express

New York, United States

Documenting the business processes by identifying data required for analysis from multiple sources and method of obtaining , storing data.• Built highly available, distributed systems of data extraction, ingestion, and processing of large data sets• Ingesting data from relational databases like Tera data/SQL to HDFS for using Sqoop• Data warehousing with Hive • Writing Hive Scripts to process large sets of data as per business logic• Involved in creating and designing tables to store the data set generated from Hive scripts• Created SSIS packages to integrate data coming from text files and excel files • Data is loaded to SQL tables using SSIS packages created• Involved in creating and designing tables to store the data set generated from Hive scripts• Created Views, stored procedures for MIS reporting tool • Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.

Postgraduate Degree, Computer Science

Master Of Science - Ms, Electrical And Electronics Engineering, 3.4 Gpa

Bachelor'S Degree, Electrical, Electronics And Communications Engineering, 80 %